# Version 0.1

INSTALLATION INSTRUCTIONS

Read README first, plaese ...

1. Create your MP3-DB on your mysql server.
   A table has to be created, the default name is have:

 mysql> describe have;
+-----------+----------------------+------+-----+------------+----------------+
| Field     | Type                 | Null | Key | Default    | Extra          |
+-----------+----------------------+------+-----+------------+----------------+
| filename  | varchar(100)         |      | PRI |            |                |
| directory | varchar(100)         |      | PRI |            |                |
| rate      | smallint(5) unsigned | YES  |     | NULL       |                |
| length    | time                 | YES  |     | NULL       |                |
| title     | varchar(255)         | YES  |     | NULL       |                |
| artist    | varchar(255)         | YES  |     | NULL       |                |
| album     | varchar(255)         | YES  |     | NULL       |                |
| year      | smallint(5) unsigned | YES  |     | NULL       |                |
| comment   | varchar(255)         | YES  |     | NULL       |                |
| cd        | varchar(20)          |      | PRI |            |                |
| gotdate   | date                 |      |     | 0000-00-00 |                |
| genre     | varchar(20)          | YES  |     | NULL       |                |
| tracknum  | smallint(3) unsigned | YES  |     | NULL       |                |
| copyright | int(1) unsigned      | YES  |     | NULL       |                |
| version   | int(1) unsigned      | YES  |     | NULL       |                |
| frequency | float(3,1)           | YES  |     | NULL       |                |
| mode      | smallint(1) unsigned | YES  |     | NULL       |                |
| layer     | smallint(1) unsigned | YES  |     | NULL       |                |
| id        | int(11)              |      | MUL | 0          | auto_increment |
+-----------+----------------------+------+-----+------------+----------------+

   You can create such a table by doing just the following:

  First, create a database (usually you have to be root or the database
  manager) if you don't already have one. Please Replace "<MP3DB>" by the
  name of the database.

	  mysqladmin create <MP3DB>


  Thereafter you have to create the table. You can use the template
  "storemp3.sql" that consists of the table description.

	  mysql  <MP3DB>  < storemp3.sql

  Note #1: If you choose another name than "have", please remember to change
  the table name in storemp3.sql as well

  Note #2: If you just created the database with "mysqladmin create ..." you
  probably have to grant access to that database. For a clean approach on
  that problem, please refer to the mysql documentation (see section "How
  the privilege system works")
  And don't forget to call "mysqladmin reload" after you changed the
  access permissions.
  

  The width of the columns can be changed by your own will,
  filename, directory and cd are PRIMARY KEYs in order to
  avoid duplicates!


2. Hostname, Username, Password and the name of the DB should be known !

Two more steps have to be done ...

Before you start with the install process, please make sure you have
replaced the hostname, the user name, the password of the user, as well
as the name of the database in the file storemp3.conf.

Here's the relevant section:

$mp3db = "<MP3DB>";
$host = "<MYSQLSERVER>";
$user = "<DBUSER>";
$passwd = "<DBPASSWD>";
$table = "have";



The INSTALLATION is quite easy. First make sure the Perl module
MPEG-MP3Info-0.71 (see README for the URL to get it) is installed. 
Edit the install file to fit your environment. Then run 

./install

to copy the necessary files into the specified directories.
Probably you can do all the changes on your own, the install file is
self-explanatory :-)


That's it.

At that point you can move the folder web/ whereever you want, perhaps
into your webserver directory? Remember zu change the permissions, so that
the webserver can access the files !  :-)



That's all
enjoy it!


joe@mcknight.de
seb@gunis.de
