diff options
Diffstat (limited to 'scripts')
| -rwxr-xr-x | scripts/createdb.mysql | 16 | ||||
| -rwxr-xr-x | scripts/createtables.mysql | 246 | ||||
| -rwxr-xr-x | scripts/make-empty-db | 19 |
3 files changed, 6 insertions, 275 deletions
diff --git a/scripts/createdb.mysql b/scripts/createdb.mysql index 7ccdc89..da1234a 100755 --- a/scripts/createdb.mysql +++ b/scripts/createdb.mysql @@ -1,14 +1,2 @@ -/* Creates DB and opens it to any user */ -/* Run this mysql macro as root! */ - -DROP DATABASE IF EXISTS GiantDisc; -CREATE DATABASE GiantDisc; - -use GiantDisc; - -/* The first line is useful for granting access to user vdr on all computers in a network. */ -/* grant all privileges on GiantDisc.* to vdr@'%'; */ - -/* Grant access to user vdr on the local machine */ -grant all privileges on GiantDisc.* to vdr@localhost; - +-- NO LONGER NEEDED. +-- SEE README
\ No newline at end of file diff --git a/scripts/createtables.mysql b/scripts/createtables.mysql index 708bdd2..da1234a 100755 --- a/scripts/createtables.mysql +++ b/scripts/createtables.mysql @@ -1,244 +1,2 @@ --- 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, - - samplerate int(7) unsigned default NULL, - channels tinyint(3) unsigned default NULL, - - id int(11) NOT NULL auto_increment, - folder1 varchar(255), - folder2 varchar(255), - folder3 varchar(255), - folder4 varchar(255), - - 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; - +-- NO LONGER NEEDED. +-- SEE README
\ No newline at end of file diff --git a/scripts/make-empty-db b/scripts/make-empty-db index 92ccf75..16c14c5 100755 --- a/scripts/make-empty-db +++ b/scripts/make-empty-db @@ -1,19 +1,4 @@ #!/bin/sh -echo "creating db" -mysql -u root < createdb.mysql - -echo "creating tables" -mysql -u root < createtables.mysql - -echo "reading genres" -echo " use GiantDisc; load data local infile 'genres.txt' into table genre;"| mysql -u root --local-infile=1 - -echo "reading languages" -echo "use GiantDisc; load data local infile 'languages.txt' into table language;" | mysql -u root --local-infile=1 - -echo "reading musictypes" -echo "use GiantDisc; load data local infile 'musictypes.txt' into table musictype;" | mysql -u root --local-infile=1 - -echo "reading sources" -echo "use GiantDisc; load data local infile 'sources.txt' into table source;" | mysql -u root --local-infile=1 +echo "THIS SCRIPT IS NO LONGER NEEDED." +echo "SEE THE README" |