SAM Broadcaster 4.2.2 Upgraded SQL

-- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
--
-- Host: localhost    Database: samdb
-- ------------------------------------------------------
-- Server version	5.0.45-community-nt

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Not dumping tablespaces as no INFORMATION_SCHEMA.FILES table on this server
--

--
-- Table structure for table `adz`
--

DROP TABLE IF EXISTS `adz`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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) collate latin1_general_ci NOT NULL default 'A',
  `LOCALFILENAME` varchar(200) collate latin1_general_ci NOT NULL default '',
  `LOCALSTATUS` varchar(10) collate latin1_general_ci NOT NULL default 'download',
  `DOWNLOAD_URL` varchar(200) collate latin1_general_ci NOT NULL default '',
  `LASTUPDATE` datetime NOT NULL default '0000-00-00 00:00:00',
  `DESCRIPTION` varchar(100) collate latin1_general_ci NOT NULL default '',
  `CAMPAIGNACTIVE` char(3) collate latin1_general_ci NOT NULL default 'yes',
  `STATUS` varchar(10) collate latin1_general_ci 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) collate latin1_general_ci NOT NULL default '',
  `HOURS` varchar(200) collate latin1_general_ci NOT NULL default '',
  `BLOCKED` char(3) collate latin1_general_ci 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) collate latin1_general_ci NOT NULL default '',
  `PROGRESS` double NOT NULL default '100',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `adz`
--

LOCK TABLES `adz` WRITE;
/*!40000 ALTER TABLE `adz` DISABLE KEYS */;
/*!40000 ALTER TABLE `adz` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `category`
--

DROP TABLE IF EXISTS `category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `category` (
  `ID` int(11) NOT NULL auto_increment,
  `name` varchar(100) collate latin1_general_ci 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 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `category`
--

LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `categorylist`
--

DROP TABLE IF EXISTS `categorylist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `categorylist`
--

LOCK TABLES `categorylist` WRITE;
/*!40000 ALTER TABLE `categorylist` DISABLE KEYS */;
/*!40000 ALTER TABLE `categorylist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `disk`
--

DROP TABLE IF EXISTS `disk`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `disk` (
  `ID` int(11) NOT NULL default '0',
  `serial` varchar(100) collate latin1_general_ci NOT NULL default '',
  `name` varchar(100) collate latin1_general_ci NOT NULL default '',
  `status` tinyint(4) NOT NULL default '0',
  `t_stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `disk`
--

LOCK TABLES `disk` WRITE;
/*!40000 ALTER TABLE `disk` DISABLE KEYS */;
/*!40000 ALTER TABLE `disk` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `event`
--

DROP TABLE IF EXISTS `event`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `event` (
  `ID` int(11) NOT NULL auto_increment,
  `name` varchar(200) collate latin1_general_ci NOT NULL default '',
  `eventaction` varchar(50) collate latin1_general_ci NOT NULL default '',
  `data` text collate latin1_general_ci,
  `extra` text collate latin1_general_ci,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `event`
--

LOCK TABLES `event` WRITE;
/*!40000 ALTER TABLE `event` DISABLE KEYS */;
/*!40000 ALTER TABLE `event` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `eventtime`
--

DROP TABLE IF EXISTS `eventtime`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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) collate latin1_general_ci NOT NULL default 'day',
  `recurring` enum('No','Yes') collate latin1_general_ci NOT NULL default 'Yes',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `eventtime`
--

LOCK TABLES `eventtime` WRITE;
/*!40000 ALTER TABLE `eventtime` DISABLE KEYS */;
/*!40000 ALTER TABLE `eventtime` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fixedlist`
--

DROP TABLE IF EXISTS `fixedlist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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) collate latin1_general_ci 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 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fixedlist`
--

LOCK TABLES `fixedlist` WRITE;
/*!40000 ALTER TABLE `fixedlist` DISABLE KEYS */;
/*!40000 ALTER TABLE `fixedlist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fixedlist_item`
--

DROP TABLE IF EXISTS `fixedlist_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fixedlist_item`
--

LOCK TABLES `fixedlist_item` WRITE;
/*!40000 ALTER TABLE `fixedlist_item` DISABLE KEYS */;
/*!40000 ALTER TABLE `fixedlist_item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `historylist`
--

DROP TABLE IF EXISTS `historylist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `historylist` (
  `ID` int(11) NOT NULL auto_increment,
  `songID` int(11) NOT NULL default '0',
  `filename` varchar(255) collate latin1_general_ci 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) collate latin1_general_ci NOT NULL default '',
  `title` varchar(255) collate latin1_general_ci NOT NULL default '',
  `album` varchar(255) collate latin1_general_ci NOT NULL default '',
  `albumyear` varchar(4) collate latin1_general_ci NOT NULL default '',
  `website` varchar(255) collate latin1_general_ci NOT NULL default '',
  `buycd` varchar(255) collate latin1_general_ci NOT NULL default '',
  `picture` varchar(255) collate latin1_general_ci NOT NULL default '',
  `listeners` mediumint(9) NOT NULL default '0',
  `label` varchar(100) collate latin1_general_ci NOT NULL default '',
  `pline` varchar(50) collate latin1_general_ci NOT NULL default '',
  `trackno` smallint(6) NOT NULL default '0',
  `composer` varchar(100) collate latin1_general_ci NOT NULL default '',
  `ISRC` varchar(50) collate latin1_general_ci NOT NULL default '',
  `catalog` varchar(50) collate latin1_general_ci NOT NULL default '',
  `UPC` varchar(50) collate latin1_general_ci NOT NULL default '',
  `feeagency` varchar(20) collate latin1_general_ci NOT NULL default '',
  `songtype` char(1) collate latin1_general_ci NOT NULL default '',
  `requestID` int(11) NOT NULL default '0',
  `overlay` enum('yes','no') collate latin1_general_ci NOT NULL default 'no',
  `songrights` set('broadcast','download','on-demand','royaltyfree') collate latin1_general_ci NOT NULL default 'broadcast',
  PRIMARY KEY  (`ID`),
  KEY `date_played` (`date_played`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `historylist`
--

LOCK TABLES `historylist` WRITE;
/*!40000 ALTER TABLE `historylist` DISABLE KEYS */;
/*!40000 ALTER TABLE `historylist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `queuelist`
--

DROP TABLE IF EXISTS `queuelist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='12';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `queuelist`
--

LOCK TABLES `queuelist` WRITE;
/*!40000 ALTER TABLE `queuelist` DISABLE KEYS */;
/*!40000 ALTER TABLE `queuelist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `requestlist`
--

DROP TABLE IF EXISTS `requestlist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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) collate latin1_general_ci NOT NULL default '',
  `msg` text collate latin1_general_ci,
  `name` varchar(255) collate latin1_general_ci 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') collate latin1_general_ci NOT NULL default 'new',
  PRIMARY KEY  (`ID`),
  KEY `t_stamp` (`t_stamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `requestlist`
--

LOCK TABLES `requestlist` WRITE;
/*!40000 ALTER TABLE `requestlist` DISABLE KEYS */;
/*!40000 ALTER TABLE `requestlist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `songlist`
--

DROP TABLE IF EXISTS `songlist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `songlist` (
  `ID` int(11) NOT NULL auto_increment,
  `filename` varchar(255) collate latin1_general_ci NOT NULL default '',
  `diskID` int(11) NOT NULL default '0',
  `flags` varchar(10) collate latin1_general_ci NOT NULL default 'NNNNNNNNNN',
  `songtype` char(1) collate latin1_general_ci 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) collate latin1_general_ci NOT NULL default '',
  `title` varchar(255) collate latin1_general_ci NOT NULL default '',
  `album` varchar(255) collate latin1_general_ci NOT NULL default '',
  `label` varchar(255) collate latin1_general_ci NOT NULL default '',
  `pline` varchar(50) collate latin1_general_ci NOT NULL default '',
  `trackno` smallint(6) NOT NULL default '0',
  `composer` varchar(100) collate latin1_general_ci NOT NULL default '',
  `ISRC` varchar(50) collate latin1_general_ci NOT NULL default '',
  `catalog` varchar(50) collate latin1_general_ci NOT NULL default '',
  `UPC` varchar(50) collate latin1_general_ci NOT NULL default '',
  `feeagency` varchar(20) collate latin1_general_ci NOT NULL default '',
  `albumyear` varchar(4) collate latin1_general_ci NOT NULL default '0',
  `genre` varchar(20) collate latin1_general_ci NOT NULL default '',
  `website` varchar(255) collate latin1_general_ci NOT NULL default '',
  `buycd` varchar(255) collate latin1_general_ci NOT NULL default '',
  `info` text collate latin1_general_ci,
  `lyrics` text collate latin1_general_ci,
  `picture` varchar(255) collate latin1_general_ci 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) collate latin1_general_ci NOT NULL default '',
  `bpm` mediumint(9) NOT NULL default '0',
  `mood` varchar(50) collate latin1_general_ci NOT NULL default '',
  `rating` mediumint(9) NOT NULL default '0',
  `overlay` enum('yes','no') collate latin1_general_ci NOT NULL default 'no',
  `playlimit_count` int(11) NOT NULL default '0',
  `playlimit_action` enum('none','remove','erase') collate latin1_general_ci NOT NULL default 'none',
  `songrights` set('broadcast','download','on-demand','royaltyfree') collate latin1_general_ci NOT NULL default 'broadcast',
  `adz_listID` int(11) 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 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `songlist`
--

LOCK TABLES `songlist` WRITE;
/*!40000 ALTER TABLE `songlist` DISABLE KEYS */;
/*!40000 ALTER TABLE `songlist` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2018-01-31  2:15:22