
DB=speicher

mysqladmin --user=root create $DB

mysql --user=root --database=$DB <<EOT
  CREATE TABLE cds (
    id       INT AUTO_INCREMENT,
    cddbid   VARCHAR(10),
    title    VARCHAR(40),
    artist   VARCHAR(40),
    category VARCHAR(40),
    PRIMARY KEY (id)
  )
EOT

mysql --user=root --database=$DB <<EOT
  CREATE TABLE tracks (
    id    INT AUTO_INCREMENT,
    cd    INT,
    track INT,
    song  VARCHAR(40),
    PRIMARY KEY (id)
  )
EOT
