---
--- Create Table Platten
---
drop database if exists platten;
create database platten;
use platten;
--
-- Table structure for table 'interpreten'
--
DROP TABLE IF EXISTS interpreten;
CREATE TABLE interpreten (
InterpretID int(11) NOT NULL auto_increment,
Interpret varchar(60) NOT NULL default '',
Interpret_Lang varchar(60) NOT NULL default '',
Guid varchar(36) NOT NULL default '',
Timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (InterpretID),
FULLTEXT KEY iInterpret (Interpret)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Table structure for table 'titel'
--
DROP TABLE IF EXISTS titel;
CREATE TABLE titel (
TitelID int(11) NOT NULL auto_increment,
InterpretID int(11) NOT NULL default '0',
Titel varchar(60) NOT NULL default '',
ErschDatum int(11) default NULL,
MediumID int(11) default NULL,
mp3tag int(1) default '0',
Guid varchar(36) NOT NULL default '',
PictureFormat varchar(5) default NULL,
Cover longblob,
thumbnail mediumblob,
ErstellDatum datetime default NULL,
ErstellerNm varchar(50) default '',
MutationDatum datetime default NULL,
MutationNm varchar(50) default '',
Timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
genreId int(11) default NULL,
PRIMARY KEY (TitelID),
UNIQUE KEY iGuid (Guid),
FULLTEXT KEY iTitel (Titel)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Table structure for table 'lieder'
--
DROP TABLE IF EXISTS lieder;
CREATE TABLE lieder (
LiedID int(11) NOT NULL auto_increment,
TitelID int(11) NOT NULL default '0',
Track int(11) default NULL,
Lied varchar(100) default NULL,
Dauer datetime default NULL,
Liedpfad varchar(255) default NULL,
guid varchar(36) NOT NULL default '',
Timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (LiedID),
FULLTEXT KEY iLied (Lied)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Table structure for table 'medium'
--
DROP TABLE IF EXISTS medium;
CREATE TABLE medium (
MediumID int(3) NOT NULL auto_increment,
Medium varchar(5) NOT NULL default '',
Beschreibung varchar(50) default NULL,
Guid varchar(36) NOT NULL default '',
Timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (MediumID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table 'medium'
--
/*!40000 ALTER TABLE medium DISABLE KEYS */;
LOCK TABLES medium WRITE;
INSERT INTO medium VALUES (1,'CD','Compact Disc','cd9aed6d-150d-4b3b-b629-ffbea9913632',20030205211910),(2,'LP','Langspielplatte','4bbf333a-bfb1-47d6-a8f4-83593e9724e0',20030203223235),(3,'MICD','Mini Compact Disc','91fb9986-0338-405a-8085-b416f21f0c4d',20030204201434),(4,'2LP','DoppelLP','673c0130-ac6e-4fcf-bbec-b8d827f8306c',20030208211504),(5,'2CD','Doppel Compact Disc','f4620fbc-50ec-48f1-bc73-6f851eb1f209',20030208211538),(6,'3CD','3er Compact Disc','52e71a04-b3e9-4741-9cce-a048abb06544',20030208211629),(7,'3LP','3er Langspielplatte','192c8a84-9c79-433c-93af-f5bb3337256a',20030208211701),(8,'MILP','Mini Langspielplatte','854f7187-2f48-4330-b400-4babdf663b32',20030208211754);
UNLOCK TABLES;
/*!40000 ALTER TABLE medium ENABLE KEYS */;
--
-- Table structure for table 'playlist'
--
DROP TABLE IF EXISTS playlist;
CREATE TABLE playlist (
ListId int(11) NOT NULL auto_increment,
ListName varchar(100) NOT NULL default '',
User varchar(50) NOT NULL default '',
guid varchar(36) NOT NULL default '',
Timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (ListId),
UNIQUE KEY iListNameUser (ListName,User),
UNIQUE KEY iGuid (guid)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Table structure for table 'playlistentries'
--
DROP TABLE IF EXISTS playlistentries;
CREATE TABLE playlistentries (
EntryId int(11) NOT NULL auto_increment,
PlaylistId int(11) NOT NULL default '0',
LiedId int(11) NOT NULL default '0',
Guid char(36) NOT NULL default '',
Timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (EntryId)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Table structure for table 'history'
--
DROP TABLE IF EXISTS history;
CREATE TABLE history (
PlayID int(11) NOT NULL auto_increment,
AppID int(11) NOT NULL default '0',
TitelID int(11) NOT NULL default '0',
LiedID int(11) NOT NULL default '0',
Zeit datetime NOT NULL default '0000-00-00 00:00:00',
Interpret varchar(50) NOT NULL default '',
Titel varchar(60) NOT NULL default '',
Lied varchar(60) NOT NULL default '',
Benutzer varchar(50) NOT NULL default '',
PRIMARY KEY (PlayID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Table structure for table 'genre'
--
DROP TABLE IF EXISTS genre;
CREATE TABLE genre (
genreid int(11) NOT NULL auto_increment,
genre varchar(100) NOT NULL default '',
guid varchar(36) NOT NULL default '',
timestamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (genreid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Table structure for table 'filtersettings'
--
DROP TABLE IF EXISTS filtersettings;
CREATE TABLE filtersettings (
filterid int(11) NOT NULL auto_increment,
mode int(11) NOT NULL default '0',
value varchar(255) default NULL,
isused bit(1) NOT NULL default '\0',
benutzer varchar(50) NOT NULL default '',
PRIMARY KEY (filterid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;