· 8 years ago · Feb 13, 2018, 11:08 PM
1-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)
2--
3-- Host: localhost Database: samdb
4-- ------------------------------------------------------
5-- Server version 5.0.45-community-nt
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Not dumping tablespaces as no INFORMATION_SCHEMA.FILES table on this server
20--
21
22--
23-- Table structure for table `adz`
24--
25
26DROP TABLE IF EXISTS `adz`;
27/*!40101 SET @saved_cs_client = @@character_set_client */;
28/*!40101 SET character_set_client = utf8 */;
29CREATE TABLE `adz` (
30 `ID` int(11) NOT NULL auto_increment,
31 `PROVIDERID` int(11) NOT NULL default '0',
32 `ADZID` int(11) NOT NULL default '0',
33 `CAMPAIGNID` int(11) NOT NULL default '0',
34 `CATEGORYID` int(11) NOT NULL default '0',
35 `DATE_START` date default NULL,
36 `DATE_END` date default NULL,
37 `SONGTYPE` char(1) collate latin1_general_ci NOT NULL default 'A',
38 `LOCALFILENAME` varchar(200) collate latin1_general_ci NOT NULL default '',
39 `LOCALSTATUS` varchar(10) collate latin1_general_ci NOT NULL default 'download',
40 `DOWNLOAD_URL` varchar(200) collate latin1_general_ci NOT NULL default '',
41 `LASTUPDATE` datetime NOT NULL default '0000-00-00 00:00:00',
42 `DESCRIPTION` varchar(100) collate latin1_general_ci NOT NULL default '',
43 `CAMPAIGNACTIVE` char(3) collate latin1_general_ci NOT NULL default 'yes',
44 `STATUS` varchar(10) collate latin1_general_ci NOT NULL default 'active',
45 `WEIGHT` float NOT NULL default '1',
46 `GLOBALWEIGHT` float NOT NULL default '1',
47 `DURATION` int(11) NOT NULL default '0',
48 `FILESIZE` int(11) NOT NULL default '0',
49 `DATE_PLAYED` datetime NOT NULL default '0000-00-00 00:00:00',
50 `DATE_CATEGORY_PLAYED` datetime NOT NULL default '0000-00-00 00:00:00',
51 `DATE_CAMPAIGN_PLAYED` datetime NOT NULL default '0000-00-00 00:00:00',
52 `SPINS` int(11) NOT NULL default '0',
53 `PERFORMANCES` int(11) NOT NULL default '0',
54 `SPINS_MAX` int(11) NOT NULL default '0',
55 `PERFORMANCES_MAX` int(11) NOT NULL default '0',
56 `cap_day` int(11) NOT NULL default '0',
57 `cap_day_cnt` int(11) NOT NULL default '0',
58 `DAYS` varchar(100) collate latin1_general_ci NOT NULL default '',
59 `HOURS` varchar(200) collate latin1_general_ci NOT NULL default '',
60 `BLOCKED` char(3) collate latin1_general_ci NOT NULL default 'no',
61 `LOCALWEIGHT` float NOT NULL default '1',
62 `LOCALBALANCE` float NOT NULL default '0',
63 `SORTID` float NOT NULL default '0',
64 `EXTERNALID` int(11) NOT NULL default '0',
65 `SYNCINFO` varchar(200) collate latin1_general_ci NOT NULL default '',
66 `PROGRESS` double NOT NULL default '100',
67 PRIMARY KEY (`ID`)
68) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
69/*!40101 SET character_set_client = @saved_cs_client */;
70
71--
72-- Dumping data for table `adz`
73--
74
75LOCK TABLES `adz` WRITE;
76/*!40000 ALTER TABLE `adz` DISABLE KEYS */;
77/*!40000 ALTER TABLE `adz` ENABLE KEYS */;
78UNLOCK TABLES;
79
80--
81-- Table structure for table `category`
82--
83
84DROP TABLE IF EXISTS `category`;
85/*!40101 SET @saved_cs_client = @@character_set_client */;
86/*!40101 SET character_set_client = utf8 */;
87CREATE TABLE `category` (
88 `ID` int(11) NOT NULL auto_increment,
89 `name` varchar(100) collate latin1_general_ci NOT NULL default '',
90 `parentID` int(11) NOT NULL default '0',
91 `levelindex` tinyint(4) NOT NULL default '0',
92 `itemindex` int(11) NOT NULL default '0',
93 PRIMARY KEY (`ID`),
94 UNIQUE KEY `name` (`name`)
95) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
96/*!40101 SET character_set_client = @saved_cs_client */;
97
98--
99-- Dumping data for table `category`
100--
101
102LOCK TABLES `category` WRITE;
103/*!40000 ALTER TABLE `category` DISABLE KEYS */;
104/*!40000 ALTER TABLE `category` ENABLE KEYS */;
105UNLOCK TABLES;
106
107--
108-- Table structure for table `categorylist`
109--
110
111DROP TABLE IF EXISTS `categorylist`;
112/*!40101 SET @saved_cs_client = @@character_set_client */;
113/*!40101 SET character_set_client = utf8 */;
114CREATE TABLE `categorylist` (
115 `ID` int(11) NOT NULL auto_increment,
116 `songID` int(11) NOT NULL default '0',
117 `categoryID` int(11) NOT NULL default '0',
118 `sortID` float NOT NULL default '0',
119 PRIMARY KEY (`ID`),
120 KEY `categoryID` (`categoryID`)
121) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
122/*!40101 SET character_set_client = @saved_cs_client */;
123
124--
125-- Dumping data for table `categorylist`
126--
127
128LOCK TABLES `categorylist` WRITE;
129/*!40000 ALTER TABLE `categorylist` DISABLE KEYS */;
130/*!40000 ALTER TABLE `categorylist` ENABLE KEYS */;
131UNLOCK TABLES;
132
133--
134-- Table structure for table `disk`
135--
136
137DROP TABLE IF EXISTS `disk`;
138/*!40101 SET @saved_cs_client = @@character_set_client */;
139/*!40101 SET character_set_client = utf8 */;
140CREATE TABLE `disk` (
141 `ID` int(11) NOT NULL default '0',
142 `serial` varchar(100) collate latin1_general_ci NOT NULL default '',
143 `name` varchar(100) collate latin1_general_ci NOT NULL default '',
144 `status` tinyint(4) NOT NULL default '0',
145 `t_stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
146) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
147/*!40101 SET character_set_client = @saved_cs_client */;
148
149--
150-- Dumping data for table `disk`
151--
152
153LOCK TABLES `disk` WRITE;
154/*!40000 ALTER TABLE `disk` DISABLE KEYS */;
155/*!40000 ALTER TABLE `disk` ENABLE KEYS */;
156UNLOCK TABLES;
157
158--
159-- Table structure for table `event`
160--
161
162DROP TABLE IF EXISTS `event`;
163/*!40101 SET @saved_cs_client = @@character_set_client */;
164/*!40101 SET character_set_client = utf8 */;
165CREATE TABLE `event` (
166 `ID` int(11) NOT NULL auto_increment,
167 `name` varchar(200) collate latin1_general_ci NOT NULL default '',
168 `eventaction` varchar(50) collate latin1_general_ci NOT NULL default '',
169 `data` text collate latin1_general_ci,
170 `extra` text collate latin1_general_ci,
171 PRIMARY KEY (`ID`)
172) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
173/*!40101 SET character_set_client = @saved_cs_client */;
174
175--
176-- Dumping data for table `event`
177--
178
179LOCK TABLES `event` WRITE;
180/*!40000 ALTER TABLE `event` DISABLE KEYS */;
181/*!40000 ALTER TABLE `event` ENABLE KEYS */;
182UNLOCK TABLES;
183
184--
185-- Table structure for table `eventtime`
186--
187
188DROP TABLE IF EXISTS `eventtime`;
189/*!40101 SET @saved_cs_client = @@character_set_client */;
190/*!40101 SET character_set_client = utf8 */;
191CREATE TABLE `eventtime` (
192 `ID` int(11) NOT NULL auto_increment,
193 `eventID` int(11) NOT NULL default '0',
194 `eventtime` time NOT NULL default '00:00:00',
195 `eventdate` date NOT NULL default '0000-00-00',
196 `eventday` varchar(20) collate latin1_general_ci NOT NULL default 'day',
197 `recurring` enum('No','Yes') collate latin1_general_ci NOT NULL default 'Yes',
198 PRIMARY KEY (`ID`)
199) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
200/*!40101 SET character_set_client = @saved_cs_client */;
201
202--
203-- Dumping data for table `eventtime`
204--
205
206LOCK TABLES `eventtime` WRITE;
207/*!40000 ALTER TABLE `eventtime` DISABLE KEYS */;
208/*!40000 ALTER TABLE `eventtime` ENABLE KEYS */;
209UNLOCK TABLES;
210
211--
212-- Table structure for table `fixedlist`
213--
214
215DROP TABLE IF EXISTS `fixedlist`;
216/*!40101 SET @saved_cs_client = @@character_set_client */;
217/*!40101 SET character_set_client = utf8 */;
218CREATE TABLE `fixedlist` (
219 `ID` int(11) NOT NULL auto_increment,
220 `PROVIDERID` int(11) NOT NULL default '0',
221 `FIXEDLISTID` int(11) NOT NULL default '0',
222 `SORTMODE` varchar(5) collate latin1_general_ci NOT NULL default 'auto',
223 `DATE_MODIFIED` datetime NOT NULL default '0000-00-00 00:00:00',
224 `DATE_START` date NOT NULL default '0000-00-00',
225 `DATE_END` date NOT NULL default '0000-00-00',
226 `TIME_START` time NOT NULL default '00:00:00',
227 `TIME_END` time NOT NULL default '00:00:00',
228 `LOOP_MAX` smallint(6) NOT NULL default '0',
229 PRIMARY KEY (`ID`)
230) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
231/*!40101 SET character_set_client = @saved_cs_client */;
232
233--
234-- Dumping data for table `fixedlist`
235--
236
237LOCK TABLES `fixedlist` WRITE;
238/*!40000 ALTER TABLE `fixedlist` DISABLE KEYS */;
239/*!40000 ALTER TABLE `fixedlist` ENABLE KEYS */;
240UNLOCK TABLES;
241
242--
243-- Table structure for table `fixedlist_item`
244--
245
246DROP TABLE IF EXISTS `fixedlist_item`;
247/*!40101 SET @saved_cs_client = @@character_set_client */;
248/*!40101 SET character_set_client = utf8 */;
249CREATE TABLE `fixedlist_item` (
250 `ID` int(11) NOT NULL auto_increment,
251 `PROVIDERID` int(11) NOT NULL default '0',
252 `FIXEDLISTID` int(11) NOT NULL default '0',
253 `FIXEDLIST_ITEMID` int(11) NOT NULL default '0',
254 `ADZID` int(11) NOT NULL default '0',
255 `SORTID` float NOT NULL default '0',
256 `PLAYCOUNT` int(11) NOT NULL default '0',
257 PRIMARY KEY (`ID`)
258) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
259/*!40101 SET character_set_client = @saved_cs_client */;
260
261--
262-- Dumping data for table `fixedlist_item`
263--
264
265LOCK TABLES `fixedlist_item` WRITE;
266/*!40000 ALTER TABLE `fixedlist_item` DISABLE KEYS */;
267/*!40000 ALTER TABLE `fixedlist_item` ENABLE KEYS */;
268UNLOCK TABLES;
269
270--
271-- Table structure for table `historylist`
272--
273
274DROP TABLE IF EXISTS `historylist`;
275/*!40101 SET @saved_cs_client = @@character_set_client */;
276/*!40101 SET character_set_client = utf8 */;
277CREATE TABLE `historylist` (
278 `ID` int(11) NOT NULL auto_increment,
279 `songID` int(11) NOT NULL default '0',
280 `filename` varchar(255) collate latin1_general_ci NOT NULL default '',
281 `date_played` datetime NOT NULL default '0000-00-00 00:00:00',
282 `duration` mediumint(9) NOT NULL default '0',
283 `artist` varchar(255) collate latin1_general_ci NOT NULL default '',
284 `title` varchar(255) collate latin1_general_ci NOT NULL default '',
285 `album` varchar(255) collate latin1_general_ci NOT NULL default '',
286 `albumyear` varchar(4) collate latin1_general_ci NOT NULL default '',
287 `website` varchar(255) collate latin1_general_ci NOT NULL default '',
288 `buycd` varchar(255) collate latin1_general_ci NOT NULL default '',
289 `picture` varchar(255) collate latin1_general_ci NOT NULL default '',
290 `listeners` mediumint(9) NOT NULL default '0',
291 `label` varchar(100) collate latin1_general_ci NOT NULL default '',
292 `pline` varchar(50) collate latin1_general_ci NOT NULL default '',
293 `trackno` smallint(6) NOT NULL default '0',
294 `composer` varchar(100) collate latin1_general_ci NOT NULL default '',
295 `ISRC` varchar(50) collate latin1_general_ci NOT NULL default '',
296 `catalog` varchar(50) collate latin1_general_ci NOT NULL default '',
297 `UPC` varchar(50) collate latin1_general_ci NOT NULL default '',
298 `feeagency` varchar(20) collate latin1_general_ci NOT NULL default '',
299 `songtype` char(1) collate latin1_general_ci NOT NULL default '',
300 `requestID` int(11) NOT NULL default '0',
301 `overlay` enum('yes','no') collate latin1_general_ci NOT NULL default 'no',
302 `songrights` set('broadcast','download','on-demand','royaltyfree') collate latin1_general_ci NOT NULL default 'broadcast',
303 PRIMARY KEY (`ID`),
304 KEY `date_played` (`date_played`)
305) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
306/*!40101 SET character_set_client = @saved_cs_client */;
307
308--
309-- Dumping data for table `historylist`
310--
311
312LOCK TABLES `historylist` WRITE;
313/*!40000 ALTER TABLE `historylist` DISABLE KEYS */;
314/*!40000 ALTER TABLE `historylist` ENABLE KEYS */;
315UNLOCK TABLES;
316
317--
318-- Table structure for table `queuelist`
319--
320
321DROP TABLE IF EXISTS `queuelist`;
322/*!40101 SET @saved_cs_client = @@character_set_client */;
323/*!40101 SET character_set_client = utf8 */;
324CREATE TABLE `queuelist` (
325 `ID` int(11) NOT NULL auto_increment,
326 `songID` int(11) NOT NULL default '0',
327 `sortID` float NOT NULL default '0',
328 `requests` int(11) NOT NULL default '0',
329 `requestID` int(11) NOT NULL default '0',
330 `auxdata` varchar(200) collate latin1_general_ci NOT NULL,
331 PRIMARY KEY (`ID`)
332) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='12';
333/*!40101 SET character_set_client = @saved_cs_client */;
334
335--
336-- Dumping data for table `queuelist`
337--
338
339LOCK TABLES `queuelist` WRITE;
340/*!40000 ALTER TABLE `queuelist` DISABLE KEYS */;
341/*!40000 ALTER TABLE `queuelist` ENABLE KEYS */;
342UNLOCK TABLES;
343
344--
345-- Table structure for table `requestlist`
346--
347
348DROP TABLE IF EXISTS `requestlist`;
349/*!40101 SET @saved_cs_client = @@character_set_client */;
350/*!40101 SET character_set_client = utf8 */;
351CREATE TABLE `requestlist` (
352 `ID` int(11) NOT NULL auto_increment,
353 `songID` int(11) NOT NULL default '0',
354 `t_stamp` datetime NOT NULL default '0000-00-00 00:00:00',
355 `host` varchar(255) collate latin1_general_ci NOT NULL default '',
356 `msg` text collate latin1_general_ci,
357 `name` varchar(255) collate latin1_general_ci NOT NULL default '',
358 `code` mediumint(9) NOT NULL default '0',
359 `ETA` datetime NOT NULL default '0000-00-00 00:00:00',
360 `status` enum('played','ignored','pending','new') collate latin1_general_ci NOT NULL default 'new',
361 PRIMARY KEY (`ID`),
362 KEY `t_stamp` (`t_stamp`)
363) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
364/*!40101 SET character_set_client = @saved_cs_client */;
365
366--
367-- Dumping data for table `requestlist`
368--
369
370LOCK TABLES `requestlist` WRITE;
371/*!40000 ALTER TABLE `requestlist` DISABLE KEYS */;
372/*!40000 ALTER TABLE `requestlist` ENABLE KEYS */;
373UNLOCK TABLES;
374
375--
376-- Table structure for table `songlist`
377--
378
379DROP TABLE IF EXISTS `songlist`;
380/*!40101 SET @saved_cs_client = @@character_set_client */;
381/*!40101 SET character_set_client = utf8 */;
382CREATE TABLE `songlist` (
383 `ID` int(11) NOT NULL auto_increment,
384 `filename` varchar(255) collate latin1_general_ci NOT NULL default '',
385 `diskID` int(11) NOT NULL default '0',
386 `flags` varchar(10) collate latin1_general_ci NOT NULL default 'NNNNNNNNNN',
387 `songtype` char(1) collate latin1_general_ci NOT NULL default 'S',
388 `status` tinyint(4) NOT NULL default '0',
389 `weight` float NOT NULL default '50',
390 `balance` float NOT NULL default '0',
391 `date_added` datetime default NULL,
392 `date_played` datetime default NULL,
393 `date_artist_played` datetime default '2002-01-01 00:00:01',
394 `date_album_played` datetime default '2002-01-01 00:00:01',
395 `date_title_played` datetime default '2002-01-01 00:00:01',
396 `duration` mediumint(9) NOT NULL default '0',
397 `artist` varchar(255) collate latin1_general_ci NOT NULL default '',
398 `title` varchar(255) collate latin1_general_ci NOT NULL default '',
399 `album` varchar(255) collate latin1_general_ci NOT NULL default '',
400 `label` varchar(255) collate latin1_general_ci NOT NULL default '',
401 `pline` varchar(50) collate latin1_general_ci NOT NULL default '',
402 `trackno` smallint(6) NOT NULL default '0',
403 `composer` varchar(100) collate latin1_general_ci NOT NULL default '',
404 `ISRC` varchar(50) collate latin1_general_ci NOT NULL default '',
405 `catalog` varchar(50) collate latin1_general_ci NOT NULL default '',
406 `UPC` varchar(50) collate latin1_general_ci NOT NULL default '',
407 `feeagency` varchar(20) collate latin1_general_ci NOT NULL default '',
408 `albumyear` varchar(4) collate latin1_general_ci NOT NULL default '0',
409 `genre` varchar(20) collate latin1_general_ci NOT NULL default '',
410 `website` varchar(255) collate latin1_general_ci NOT NULL default '',
411 `buycd` varchar(255) collate latin1_general_ci NOT NULL default '',
412 `info` text collate latin1_general_ci,
413 `lyrics` text collate latin1_general_ci,
414 `picture` varchar(255) collate latin1_general_ci NOT NULL default '',
415 `count_played` mediumint(9) NOT NULL default '0',
416 `count_requested` mediumint(9) NOT NULL default '0',
417 `last_requested` datetime NOT NULL default '2002-01-01 00:00:01',
418 `count_performances` int(11) NOT NULL default '0',
419 `xfade` varchar(50) collate latin1_general_ci NOT NULL default '',
420 `bpm` mediumint(9) NOT NULL default '0',
421 `mood` varchar(50) collate latin1_general_ci NOT NULL default '',
422 `rating` mediumint(9) NOT NULL default '0',
423 `overlay` enum('yes','no') collate latin1_general_ci NOT NULL default 'no',
424 `playlimit_count` int(11) NOT NULL default '0',
425 `playlimit_action` enum('none','remove','erase') collate latin1_general_ci NOT NULL default 'none',
426 `songrights` set('broadcast','download','on-demand','royaltyfree') collate latin1_general_ci NOT NULL default 'broadcast',
427 `adz_listID` int(11) NOT NULL default '0',
428 PRIMARY KEY (`ID`),
429 UNIQUE KEY `filename` (`filename`),
430 KEY `date_played` (`date_played`),
431 KEY `date_artist_played` (`date_artist_played`),
432 KEY `date_album_played` (`date_album_played`)
433) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
434/*!40101 SET character_set_client = @saved_cs_client */;
435
436--
437-- Dumping data for table `songlist`
438--
439
440LOCK TABLES `songlist` WRITE;
441/*!40000 ALTER TABLE `songlist` DISABLE KEYS */;
442/*!40000 ALTER TABLE `songlist` ENABLE KEYS */;
443UNLOCK TABLES;
444/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
445
446/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
447/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
448/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
449/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
450/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
451/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
452/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
453
454-- Dump completed on 2018-01-31 2:15:22