-- MySQL dump 8.23 -- -- Host: localhost Database: otto --------------------------------------------------------- -- Server version 3.23.58 -- -- Table structure for table `albums` -- CREATE TABLE albums ( albumid int(11) NOT NULL auto_increment, dir varchar(255) NOT NULL default '', album varchar(255) NOT NULL default '', artist varchar(255) NOT NULL default '', fileunderid int(11) NOT NULL default '0', owner varchar(30) default NULL, parsesongs varchar(30) default NULL, notes text, PRIMARY KEY (albumid), KEY dirindex (dir), KEY albumindex (album), KEY artistindex (artist), KEY fileunderidindex (fileunderid) ) TYPE=MyISAM; -- -- Table structure for table `channels` -- CREATE TABLE channels ( channel char(1) default NULL, channelname varchar(20) default NULL, user varchar(30) default NULL, active int(11) NOT NULL default '0', manual int(11) default NULL, notes text, KEY channelindex (channel), KEY activeindex (active) ) TYPE=MyISAM; -- -- Table structure for table `fileunder` -- CREATE TABLE fileunder ( fileunderid int(11) NOT NULL auto_increment, fileunder varchar(255) NOT NULL default '', albumcount int(11) NOT NULL default '0', songcount int(11) NOT NULL default '0', variouscount int(11) NOT NULL default '0', notes text, PRIMARY KEY (fileunderid), KEY fileunderindex (fileunder), KEY albumcountindex (albumcount) ) TYPE=MyISAM; -- -- Table structure for table `fileundermap` -- CREATE TABLE fileundermap ( artist varchar(255) NOT NULL default '', album varchar(255) NOT NULL default '', song varchar(255) NOT NULL default '', fileunder varchar(255) default NULL, KEY artistindex (artist), KEY albumindex (album), KEY songindex (song) ) TYPE=MyISAM; -- -- Table structure for table `listelements` -- CREATE TABLE listelements ( listid int(11) NOT NULL default '0', songid int(11) NOT NULL default '0', albumid int(11) NOT NULL default '0', fileunderid int(11) NOT NULL default '0', xwhen timestamp(14) NOT NULL, owner varchar(30) NOT NULL default '', notes text, KEY listidindex (listid), KEY songidindex (songid), KEY albumidindex (albumid), KEY fileunderidindex (fileunderid), KEY ownerindex (owner) ) TYPE=MyISAM; -- -- Table structure for table `listenerlog` -- CREATE TABLE listenerlog ( xwhen timestamp(14) NOT NULL, action varchar(10) default NULL, seconds int(11) default NULL, ipaddress varchar(15) default NULL, ipname varchar(50) default NULL, user varchar(30) default NULL, listeners int(11) default NULL, KEY xwhenindex (xwhen) ) TYPE=MyISAM; -- -- Table structure for table `listenermap` -- CREATE TABLE listenermap ( host varchar(200) NOT NULL default '', user varchar(30) NOT NULL default '', channel char(1) default NULL, firstlogin timestamp(14) NOT NULL, lastlogin timestamp(14) NOT NULL, PRIMARY KEY (host), KEY hostindex (host) ) TYPE=MyISAM; -- -- Table structure for table `lists` -- CREATE TABLE lists ( listid int(11) NOT NULL auto_increment, list varchar(100) NOT NULL default '', exclude int(11) default NULL, notes text, xwhen timestamp(14) NOT NULL, owner varchar(30) NOT NULL default '', listsize int(11) NOT NULL default '0', albumcount int(11) default NULL, fileundercount int(11) default NULL, PRIMARY KEY (listid), KEY listidindex (listid), KEY listindex (list), KEY ownerindex (owner) ) TYPE=MyISAM; -- -- Table structure for table `propernamemap` -- CREATE TABLE propernamemap ( propername varchar(255) NOT NULL default '', fileunder varchar(255) default NULL, PRIMARY KEY (propername) ) TYPE=MyISAM; -- -- Table structure for table `queue` -- CREATE TABLE queue ( queueid int(11) NOT NULL auto_increment, channel char(1) default NULL, playorder int(11) NOT NULL default '0', priority int(11) NOT NULL default '0', user varchar(30) default NULL, songid int(11) NOT NULL default '0', PRIMARY KEY (queueid), KEY queueidindex (queueid), KEY channelindex (channel), KEY playorderindex (playorder) ) TYPE=MyISAM; -- -- Table structure for table `seealso` -- CREATE TABLE seealso ( seealsoid int(11) NOT NULL auto_increment, fileunderid int(11) NOT NULL default '0', albumid int(11) NOT NULL default '0', songid int(11) NOT NULL default '0', tracknum int(11) default NULL, notes text, PRIMARY KEY (seealsoid), KEY fileunderidindex (fileunderid), KEY albumidindex (albumid), KEY songidindex (songid) ) TYPE=MyISAM; -- -- Table structure for table `songs` -- CREATE TABLE songs ( songid int(11) NOT NULL auto_increment, file varchar(255) NOT NULL default '', song varchar(255) NOT NULL default '', tracknum int(11) default NULL, albumid int(11) NOT NULL default '0', fileunderid int(11) NOT NULL default '0', xwhen timestamp(14) NOT NULL, notes text, PRIMARY KEY (songid), KEY songindex (song), KEY fileindex (file), KEY albumidindex (albumid), KEY fileunderidindex (fileunderid) ) TYPE=MyISAM; -- -- Table structure for table `stats` -- CREATE TABLE stats ( xwhen timestamp(14) NOT NULL, newest timestamp(14) NOT NULL, songcount int(11) default NULL, albumcount int(11) default NULL, artistcount int(11) default NULL, kbytes int(11) default NULL ) TYPE=MyISAM; -- -- Table structure for table `users` -- CREATE TABLE users ( user varchar(30) NOT NULL default '', priority int(11) NOT NULL default '0', PRIMARY KEY (user) ) TYPE=MyISAM;