Removed database creation stuff which is now done by mugglei

git-svn-id: https://vdr-muggle.svn.sourceforge.net/svnroot/vdr-muggle/trunk/muggle-plugin@545 e10066b5-e1e2-0310-b819-94efdf66514b

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"