Click here to Skip to main content
15,860,861 members
Articles / Desktop Programming / Windows Forms

BSEtunes

Rate me:
Please Sign up or sign in to vote.
4.67/5 (11 votes)
24 Apr 2010CPOL4 min read 64.2K   4.3K   58  
BSEtunes is a MySQL based, full manageable, networkable single or multiuser jukebox application
---
--- 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;

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Switzerland Switzerland
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions