From 2370a13b7f6512147550e5eec8a773e69d49119b Mon Sep 17 00:00:00 2001 From: lvw Date: Fri, 28 May 2004 15:30:48 +0000 Subject: Merged and added import scripts git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk/muggle-plugin@99 e10066b5-e1e2-0310-b819-94efdf66514b --- scripts/createtables.mysql | 235 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 235 insertions(+) create mode 100755 scripts/createtables.mysql (limited to 'scripts/createtables.mysql') diff --git a/scripts/createtables.mysql b/scripts/createtables.mysql new file mode 100755 index 0000000..5969ce2 --- /dev/null +++ b/scripts/createtables.mysql @@ -0,0 +1,235 @@ +-- MySQL dump 8.21 +-- +-- Host: localhost Database: GiantDisc +--------------------------------------------------------- +-- Server version 3.23.49 + +-- +-- Current Database: GiantDisc +-- + +--CREATE DATABASE /*!32312 IF NOT EXISTS*/ GiantDisc; + +USE GiantDisc; + +-- +-- Table structure for table 'album' +-- + +drop table if exists album; +CREATE TABLE album ( + artist varchar(255) default NULL, + title varchar(255) default NULL, + cddbid varchar(20) NOT NULL default '', + coverimg varchar(255) default NULL, + covertxt mediumtext, + modified date default NULL, + genre varchar(10) default NULL, + PRIMARY KEY (cddbid), + KEY artist (artist(10)), + KEY title (title(10)), + KEY genre (genre), + KEY modified (modified) +) TYPE=MyISAM; + +-- +-- Table structure for table 'genre' +-- + +drop table if exists genre; +CREATE TABLE genre ( + id varchar(10) NOT NULL default '', + id3genre smallint(6) default NULL, + genre varchar(255) default NULL, + freq int(11) default NULL, + PRIMARY KEY (id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'language' +-- + +drop table if exists language; +CREATE TABLE language ( + id varchar(4) NOT NULL default '', + language varchar(40) default NULL, + freq int(11) default NULL, + PRIMARY KEY (id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'musictype' +-- + +drop table if exists musictype; +CREATE TABLE musictype ( + musictype varchar(40) default NULL, + id tinyint(3) unsigned NOT NULL auto_increment, + PRIMARY KEY (id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'player' +-- + +drop table if exists player; +CREATE TABLE player ( + ipaddr varchar(255) NOT NULL default '', + uichannel varchar(255) NOT NULL default '', + logtarget int(11) default NULL, + cdripper varchar(255) default NULL, + mp3encoder varchar(255) default NULL, + cdromdev varchar(255) default NULL, + cdrwdev varchar(255) default NULL, + id int(11) NOT NULL default '0', + PRIMARY KEY (id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'playerstate' +-- + +drop table if exists playerstate; +CREATE TABLE playerstate ( + playerid int(11) NOT NULL default '0', + playertype int(11) NOT NULL default '0', + snddevice varchar(255) default NULL, + playerapp varchar(255) default NULL, + playerparams varchar(255) default NULL, + ptlogger varchar(255) default NULL, + currtracknb int(11) default NULL, + state varchar(4) default NULL, + shufflepar varchar(255) default NULL, + shufflestat varchar(255) default NULL, + pauseframe int(11) default NULL, + framesplayed int(11) default NULL, + framestotal int(11) default NULL, + anchortime bigint(20) default NULL, + PRIMARY KEY (playerid,playertype) +) TYPE=HEAP; + +-- +-- Table structure for table 'playlist' +-- + +drop table if exists playlist; +CREATE TABLE playlist ( + title varchar(255) default NULL, + author varchar(255) default NULL, + note varchar(255) default NULL, + created timestamp(8) NOT NULL, + id int(10) unsigned NOT NULL auto_increment, + PRIMARY KEY (id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'playlistitem' +-- + +drop table if exists playlistitem; +CREATE TABLE playlistitem ( + playlist int(11) NOT NULL default '0', + tracknumber mediumint(9) NOT NULL default '0', + trackid int(11) default NULL, + PRIMARY KEY (playlist,tracknumber) +) TYPE=MyISAM; + +-- +-- Table structure for table 'playlog' +-- + +drop table if exists playlog; +CREATE TABLE playlog ( + trackid int(11) default NULL, + played date default NULL, + id tinyint(3) unsigned NOT NULL auto_increment, + PRIMARY KEY (id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'recordingitem' +-- + +drop table if exists recordingitem; +CREATE TABLE recordingitem ( + trackid int(11) default NULL, + recdate date default NULL, + rectime time default NULL, + reclength int(11) default NULL, + enddate date default NULL, + endtime time default NULL, + repeat varchar(10) default NULL, + initcmd varchar(255) default NULL, + parameters varchar(255) default NULL, + atqjob int(11) default NULL, + id int(11) NOT NULL default '0', + PRIMARY KEY (id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'source' +-- + +drop table if exists source; +CREATE TABLE source ( + source varchar(40) default NULL, + id tinyint(3) unsigned NOT NULL auto_increment, + PRIMARY KEY (id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'tracklistitem' +-- + +drop table if exists tracklistitem; +CREATE TABLE tracklistitem ( + playerid int(11) NOT NULL default '0', + listtype smallint(6) NOT NULL default '0', + tracknb int(11) NOT NULL default '0', + trackid int(11) NOT NULL default '0', + PRIMARY KEY (playerid,listtype,tracknb) +) TYPE=MyISAM; + +-- +-- Table structure for table 'tracks' +-- + +drop table if exists tracks; +CREATE TABLE tracks ( + artist varchar(255) default NULL, + title varchar(255) default NULL, + genre1 varchar(10) default NULL, + genre2 varchar(10) default NULL, + year smallint(5) unsigned default NULL, + lang varchar(4) default NULL, + type tinyint(3) unsigned default NULL, + rating tinyint(3) unsigned default NULL, + length smallint(5) unsigned default NULL, + source tinyint(3) unsigned default NULL, + sourceid varchar(20) default NULL, + tracknb tinyint(3) unsigned default NULL, + mp3file varchar(255) default NULL, + condition tinyint(3) unsigned default NULL, + voladjust smallint(6) default '0', + lengthfrm mediumint(9) default '0', + startfrm mediumint(9) default '0', + bpm smallint(6) default '0', + lyrics mediumtext, + bitrate varchar(10) default NULL, + created date default NULL, + modified date default NULL, + backup tinyint(3) unsigned default NULL, + id int(11) NOT NULL auto_increment, + PRIMARY KEY (id), + KEY title (title(10)), + KEY mp3file (mp3file(10)), + KEY genre1 (genre1), + KEY genre2 (genre2), + KEY year (year), + KEY lang (lang), + KEY type (type), + KEY rating (rating), + KEY sourceid (sourceid), + KEY artist (artist(10)) +) TYPE=MyISAM; + -- cgit v1.2.3 From 653ca204d10b3481670a80769baa3d768bb5f64a Mon Sep 17 00:00:00 2001 From: lvw Date: Tue, 7 Sep 2004 17:40:47 +0000 Subject: Merged ogg vorbis player to trunk git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk/muggle-plugin@148 e10066b5-e1e2-0310-b819-94efdf66514b --- scripts/createtables.mysql | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'scripts/createtables.mysql') diff --git a/scripts/createtables.mysql b/scripts/createtables.mysql index 5969ce2..079b3bd 100755 --- a/scripts/createtables.mysql +++ b/scripts/createtables.mysql @@ -219,6 +219,10 @@ CREATE TABLE tracks ( created date default NULL, modified date default NULL, backup tinyint(3) unsigned default NULL, + + samplerate int(7) unsigned default NULL, + channels tinyint(3) unsigned default NULL, + id int(11) NOT NULL auto_increment, PRIMARY KEY (id), KEY title (title(10)), -- cgit v1.2.3 From 0fe155eaff5361997c03243e263131da203f691c Mon Sep 17 00:00:00 2001 From: lvw Date: Thu, 28 Oct 2004 09:57:42 +0000 Subject: Avoid multiline comments as they seem to cause trouble git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk/muggle-plugin@259 e10066b5-e1e2-0310-b819-94efdf66514b --- scripts/createtables.mysql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'scripts/createtables.mysql') diff --git a/scripts/createtables.mysql b/scripts/createtables.mysql index 079b3bd..402f66b 100755 --- a/scripts/createtables.mysql +++ b/scripts/createtables.mysql @@ -8,7 +8,7 @@ -- Current Database: GiantDisc -- ---CREATE DATABASE /*!32312 IF NOT EXISTS*/ GiantDisc; +-- CREATE DATABASE /*!32312 IF NOT EXISTS*/ GiantDisc; USE GiantDisc; -- cgit v1.2.3 From 0756ae40d68d403082c86adef042a4c0daba219f Mon Sep 17 00:00:00 2001 From: LarsAC Date: Fri, 7 Jan 2005 18:43:03 +0000 Subject: Merged branch osd_extensions back to main trunk git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk/muggle-plugin@324 e10066b5-e1e2-0310-b819-94efdf66514b --- scripts/createtables.mysql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'scripts/createtables.mysql') diff --git a/scripts/createtables.mysql b/scripts/createtables.mysql index 402f66b..079b3bd 100755 --- a/scripts/createtables.mysql +++ b/scripts/createtables.mysql @@ -8,7 +8,7 @@ -- Current Database: GiantDisc -- --- CREATE DATABASE /*!32312 IF NOT EXISTS*/ GiantDisc; +--CREATE DATABASE /*!32312 IF NOT EXISTS*/ GiantDisc; USE GiantDisc; -- cgit v1.2.3