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

1 files changed, 235 insertions, 0 deletions

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;
+