SAM Broadcaster 4.2.2 tables.sql for MariaDB

# Database : `SAMDB`
# --------------------------------------------------------

#
# Table structure for table `category`
#

CREATE TABLE category (
  ID int(11) NOT NULL auto_increment,
  name varchar(100) NOT NULL default '',
  parentID int(11) NOT NULL default '0',
  levelindex tinyint(4) NOT NULL default '0',
  itemindex int(11) NOT NULL default '0',
  PRIMARY KEY  (ID),
  UNIQUE KEY name (name)
) ENGINE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `categorylist`
#

CREATE TABLE categorylist (
  ID int(11) NOT NULL auto_increment,
  songID int(11) NOT NULL default '0',
  categoryID int(11) NOT NULL default '0',
  sortID float NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY categoryID (categoryID)
) ENGINE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `disk`
#

CREATE TABLE disk (
  ID int(11) NOT NULL default '0',
  serial varchar(100) NOT NULL default '',
  name varchar(100) NOT NULL default '',
  status tinyint(4) NOT NULL default '0',
  t_stamp timestamp NOT NULL
) ENGINE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `historylist`
#


CREATE TABLE historylist (
  ID int(11) NOT NULL auto_increment,
  songID int(11) NOT NULL default '0',
  filename varchar(255) NOT NULL default '',
  date_played datetime NOT NULL default '0000-00-00 00:00:00',
  duration mediumint(9) NOT NULL default '0',
  artist varchar(255) NOT NULL default '',
  title varchar(255) NOT NULL default '',
  album varchar(255) NOT NULL default '',
  albumyear varchar(4) NOT NULL default '',
  website varchar(255) NOT NULL default '',
  buycd varchar(255) NOT NULL default '',
  picture varchar(255) NOT NULL default '',
  listeners mediumint(9) NOT NULL default '0',
  label varchar(100) NOT NULL default '',
  pline varchar(50) NOT NULL default '',
  trackno smallint(6) NOT NULL default '0',
  composer varchar(100) NOT NULL default '',
  ISRC varchar(50) NOT NULL default '',
  catalog varchar(50) NOT NULL default '',
  UPC varchar(50) NOT NULL default '',
  feeagency varchar(20) NOT NULL default '',
  songtype char(1) NOT NULL default '',
  requestID int(11) NOT NULL default '0',
  overlay ENUM( 'yes', 'no' ) DEFAULT 'no' NOT NULL ,
  songrights SET( 'broadcast', 'download', 'on-demand', 'royaltyfree' ) DEFAULT 'broadcast' NOT NULL,
  PRIMARY KEY  (ID),
  KEY `date_played` (`date_played`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `requestlist`
#

CREATE TABLE requestlist (
  ID int(11) NOT NULL auto_increment,
  songID int(11) NOT NULL default '0',
  t_stamp datetime NOT NULL default '0000-00-00 00:00:00',
  host varchar(255) NOT NULL default '',
  msg text NULL,
  name varchar(255) NOT NULL default '',
  code mediumint(9) NOT NULL default '0',
  ETA datetime NOT NULL default '0000-00-00 00:00:00',
  status enum('played','ignored','pending','new') NOT NULL default 'new',
  PRIMARY KEY  (ID),
  KEY t_stamp (t_stamp)
) ENGINE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `songlist`
#

CREATE TABLE `songlist` (
  `ID` int(11) NOT NULL auto_increment,
  `filename` varchar(255) NOT NULL default '',
  `diskID` int(11) NOT NULL default '0',
  `flags` varchar(10) NOT NULL default 'NNNNNNNNNN',
  `songtype` char(1) NOT NULL default 'S',
  `status` tinyint(4) NOT NULL default '0',
  `weight` float NOT NULL default '50',
  `balance` float NOT NULL default '0',
  `date_added` datetime default NULL,
  `date_played` datetime default NULL,
  `date_artist_played` datetime default '2002-01-01 00:00:01',
  `date_album_played` datetime default '2002-01-01 00:00:01',
  `date_title_played` datetime default '2002-01-01 00:00:01',
  `duration` mediumint(9) NOT NULL default '0',
  `artist` varchar(255) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `album` varchar(255) NOT NULL default '',
  `label` varchar(255) NOT NULL default '',
  `pline` varchar(50) NOT NULL default '',
  `trackno` smallint(6) NOT NULL default '0',
  `composer` varchar(100) NOT NULL default '',
  `ISRC` varchar(50) NOT NULL default '',
  `catalog` varchar(50) NOT NULL default '',
  `UPC` varchar(50) NOT NULL default '',
  `feeagency` varchar(20) NOT NULL default '',
  `albumyear` varchar(4) NOT NULL default '0',
  `genre` varchar(20) NOT NULL default '',
  `website` varchar(255) NOT NULL default '',
  `buycd` varchar(255) NOT NULL default '',
  `info` text,
  `lyrics` text,
  `picture` varchar(255) NOT NULL default '',
  `count_played` mediumint(9) NOT NULL default '0',
  `count_requested` mediumint(9) NOT NULL default '0',
  `last_requested` datetime NOT NULL default '2002-01-01 00:00:01',
  `count_performances` int(11) NOT NULL default '0',
  `xfade` varchar(50) NOT NULL default '',
  `bpm` mediumint(9) NOT NULL default '0',
  `mood` varchar(50) NOT NULL default '',
  `rating` mediumint(9) NOT NULL default '0',
  `overlay` enum('yes','no') NOT NULL default 'no',
  `playlimit_count` int(11) NOT NULL default '0',
  `playlimit_action` enum('none','remove','erase') NOT NULL default 'none',
  `songrights` set('broadcast','download','on-demand','royaltyfree') NOT NULL default 'broadcast',
  `adz_listID` INT NOT NULL DEFAULT '0',

  PRIMARY KEY  (`ID`),
  UNIQUE KEY `filename` (`filename`),
  KEY `date_played` (`date_played`),
  KEY `date_artist_played` (`date_artist_played`),
  KEY `date_album_played` (`date_album_played`)
) ENGINE=MyISAM;


# --------------------------------------------------------

#
# Table structure for table `event`
#


CREATE TABLE `event` (
  `ID` int(11) NOT NULL auto_increment,
  `name` varchar(200) NOT NULL default '',
  `eventaction` varchar(50) NOT NULL default '',
  `data` text,
  `extra` text,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `eventtime`
#

CREATE TABLE `eventtime` (
  `ID` int(11) NOT NULL auto_increment,
  `eventID` int(11) NOT NULL default '0',
  `eventtime` time NOT NULL default '00:00:00',
  `eventdate` date NOT NULL default '0000-00-00',
  `eventday` varchar(20) NOT NULL default 'day',
  `recurring` enum('No','Yes') NOT NULL default 'Yes',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM;



# --------------------------------------------------------

#
# Table structure for table `queuelist`
#

CREATE TABLE queuelist (
  ID int(11) NOT NULL auto_increment,
  songID int(11) NOT NULL default '0',
  sortID float NOT NULL default '0',
  requests int(11) NOT NULL default '0',
  requestID int(11) NOT NULL default '0',
  auxdata VARCHAR( 200 ) NOT NULL,
  PRIMARY KEY  (ID)
) ENGINE=MyISAM COMMENT='12';



# -----------------------------------------------------------
CREATE TABLE `adz` (
  `ID` int(11) NOT NULL auto_increment,
  `PROVIDERID` int(11) NOT NULL default '0',
  `ADZID` int(11) NOT NULL default '0',
  `CAMPAIGNID` int(11) NOT NULL default '0',
  `CATEGORYID` int(11) NOT NULL default '0',
  `DATE_START` date default NULL,
  `DATE_END` date default NULL,
  `SONGTYPE` char(1) NOT NULL default 'A',
  `LOCALFILENAME` varchar(200) NOT NULL default '',
  `LOCALSTATUS` varchar(10) NOT NULL default 'download',
  `DOWNLOAD_URL` varchar(200) NOT NULL default '',
  `LASTUPDATE` datetime NOT NULL default '0000-00-00 00:00:00',
  `DESCRIPTION` varchar(100) NOT NULL default '',
  `CAMPAIGNACTIVE` char(3) NOT NULL default 'yes',
  `STATUS` varchar(10) NOT NULL default 'active',
  `WEIGHT` float NOT NULL default '1',
  `GLOBALWEIGHT` float NOT NULL default '1',
  `DURATION` int(11) NOT NULL default '0',
  `FILESIZE` int(11) NOT NULL default '0',
  `DATE_PLAYED` datetime NOT NULL default '0000-00-00 00:00:00',
  `DATE_CATEGORY_PLAYED` datetime NOT NULL default '0000-00-00 00:00:00',
  `DATE_CAMPAIGN_PLAYED` datetime NOT NULL default '0000-00-00 00:00:00',
  `SPINS` int(11) NOT NULL default '0',
  `PERFORMANCES` int(11) NOT NULL default '0',
  `SPINS_MAX` int(11) NOT NULL default '0',
  `PERFORMANCES_MAX` int(11) NOT NULL default '0',
  `cap_day` int(11) NOT NULL default '0',
  `cap_day_cnt` int(11) NOT NULL default '0',
  `DAYS` varchar(100) NOT NULL default '',
  `HOURS` varchar(200) NOT NULL default '',
  `BLOCKED` char(3) NOT NULL default 'no',
  `LOCALWEIGHT` float NOT NULL default '1',
  `LOCALBALANCE` float NOT NULL default '0',
  `SORTID` float NOT NULL default '0',
  `EXTERNALID` int(11) NOT NULL default '0',
  `SYNCINFO` varchar(200) NOT NULL default '',
  `PROGRESS` DOUBLE NOT NULL default 100,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM;

CREATE TABLE `fixedlist` (
  `ID` int(11) NOT NULL auto_increment,
  `PROVIDERID` int(11) NOT NULL default '0',
  `FIXEDLISTID` int(11) NOT NULL default '0',
  `SORTMODE` varchar(5) NOT NULL default 'auto',
  `DATE_MODIFIED` datetime NOT NULL default '0000-00-00 00:00:00',
  `DATE_START` date NOT NULL default '0000-00-00',
  `DATE_END` date NOT NULL default '0000-00-00',
  `TIME_START` time NOT NULL default '00:00:00',
  `TIME_END` time NOT NULL default '00:00:00',
  `LOOP_MAX` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM;


CREATE TABLE `fixedlist_item` (
  `ID` int(11) NOT NULL auto_increment,
  `PROVIDERID` int(11) NOT NULL default '0',
  `FIXEDLISTID` int(11) NOT NULL default '0',
  `FIXEDLIST_ITEMID` int(11) NOT NULL default '0',
  `ADZID` int(11) NOT NULL default '0',
  `SORTID` float NOT NULL default '0',
  `PLAYCOUNT` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM;
# ------------------------------------------------------------------