· 8 years ago · Feb 18, 2018, 04:44 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Versione server: 10.2.13-MariaDB - mariadb.org binary distribution
4-- S.O. server: Win64
5-- HeidiSQL Versione: 9.4.0.5125
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dump della struttura del database radiomestre
16CREATE DATABASE IF NOT EXISTS `radiomestre` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `radiomestre`;
18
19-- Dump della struttura di tabella radiomestre.carts
20CREATE TABLE IF NOT EXISTS `carts` (
21 `ID` int(11) NOT NULL AUTO_INCREMENT,
22 `name` varchar(255) NOT NULL,
23 PRIMARY KEY (`ID`),
24 UNIQUE KEY `ID` (`ID`)
25) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
26
27-- Dump dei dati della tabella radiomestre.carts: 1 rows
28/*!40000 ALTER TABLE `carts` DISABLE KEYS */;
29INSERT INTO `carts` (`ID`, `name`) VALUES
30 (1, 'Default');
31/*!40000 ALTER TABLE `carts` ENABLE KEYS */;
32
33-- Dump della struttura di tabella radiomestre.carts_list
34CREATE TABLE IF NOT EXISTS `carts_list` (
35 `ID` int(11) NOT NULL AUTO_INCREMENT,
36 `pID` int(11) NOT NULL,
37 `swID` int(11) NOT NULL,
38 `swButton` int(11) NOT NULL,
39 `color` varchar(100) NOT NULL,
40 PRIMARY KEY (`ID`),
41 UNIQUE KEY `ID` (`ID`)
42) ENGINE=MyISAM DEFAULT CHARSET=utf8;
43
44-- Dump dei dati della tabella radiomestre.carts_list: 0 rows
45/*!40000 ALTER TABLE `carts_list` DISABLE KEYS */;
46/*!40000 ALTER TABLE `carts_list` ENABLE KEYS */;
47
48-- Dump della struttura di tabella radiomestre.category
49CREATE TABLE IF NOT EXISTS `category` (
50 `ID` int(11) NOT NULL AUTO_INCREMENT,
51 `name` varchar(100) NOT NULL,
52 PRIMARY KEY (`ID`),
53 UNIQUE KEY `name` (`name`)
54) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
55
56-- Dump dei dati della tabella radiomestre.category: 11 rows
57/*!40000 ALTER TABLE `category` DISABLE KEYS */;
58INSERT INTO `category` (`ID`, `name`) VALUES
59 (1, 'Music'),
60 (2, 'Sound Effects'),
61 (3, 'Sweepers'),
62 (4, 'Station IDs'),
63 (5, 'Jingles'),
64 (6, 'Promos'),
65 (7, 'Commercials'),
66 (8, 'News'),
67 (9, 'Interviews'),
68 (10, 'Radio Shows'),
69 (11, 'Radio Streams');
70/*!40000 ALTER TABLE `category` ENABLE KEYS */;
71
72-- Dump della struttura di tabella radiomestre.events
73CREATE TABLE IF NOT EXISTS `events` (
74 `ID` int(11) NOT NULL AUTO_INCREMENT,
75 `type` tinyint(2) NOT NULL,
76 `time` varchar(20) NOT NULL,
77 `name` varchar(200) NOT NULL,
78 `date` date DEFAULT '2002-01-01',
79 `day` varchar(30) DEFAULT '&',
80 `hours` varchar(100) DEFAULT '&',
81 `data` text DEFAULT NULL,
82 `enabled` enum('True','False') DEFAULT 'True',
83 `catID` int(11) NOT NULL DEFAULT 0,
84 `smart` tinyint(1) NOT NULL DEFAULT 0,
85 PRIMARY KEY (`ID`)
86) ENGINE=MyISAM DEFAULT CHARSET=utf8;
87
88-- Dump dei dati della tabella radiomestre.events: 0 rows
89/*!40000 ALTER TABLE `events` DISABLE KEYS */;
90/*!40000 ALTER TABLE `events` ENABLE KEYS */;
91
92-- Dump della struttura di tabella radiomestre.events_categories
93CREATE TABLE IF NOT EXISTS `events_categories` (
94 `ID` int(11) NOT NULL AUTO_INCREMENT,
95 `name` varchar(255) CHARACTER SET latin1 NOT NULL,
96 PRIMARY KEY (`ID`)
97) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
98
99-- Dump dei dati della tabella radiomestre.events_categories: 1 rows
100/*!40000 ALTER TABLE `events_categories` DISABLE KEYS */;
101INSERT INTO `events_categories` (`ID`, `name`) VALUES
102 (1, 'Default');
103/*!40000 ALTER TABLE `events_categories` ENABLE KEYS */;
104
105-- Dump della struttura di tabella radiomestre.genre
106CREATE TABLE IF NOT EXISTS `genre` (
107 `id` int(11) NOT NULL AUTO_INCREMENT,
108 `name` varchar(50) NOT NULL,
109 KEY `id` (`id`)
110) ENGINE=MyISAM AUTO_INCREMENT=149 DEFAULT CHARSET=utf8;
111
112-- Dump dei dati della tabella radiomestre.genre: 148 rows
113/*!40000 ALTER TABLE `genre` DISABLE KEYS */;
114INSERT INTO `genre` (`id`, `name`) VALUES
115 (1, 'Acapella'),
116 (2, 'Acid'),
117 (3, 'Acid Jazz'),
118 (4, 'Acid Punk'),
119 (5, 'Acoustic'),
120 (6, 'Alternative'),
121 (7, 'Alternative Rock'),
122 (8, 'Ambient'),
123 (9, 'Anime'),
124 (10, 'Avantgarde'),
125 (11, 'Ballad'),
126 (12, 'Bass'),
127 (13, 'Beat'),
128 (14, 'Bebob'),
129 (15, 'Big Band'),
130 (16, 'Black Metal'),
131 (17, 'Bluegrass'),
132 (18, 'Blues'),
133 (19, 'Booty Bass'),
134 (20, 'BritPop'),
135 (21, 'Cabaret'),
136 (22, 'Celtic'),
137 (23, 'Chamber Music'),
138 (24, 'Chanson'),
139 (25, 'Chorus'),
140 (26, 'Christian Gangsta Rap'),
141 (27, 'Christian Rap'),
142 (28, 'Christian Rock'),
143 (29, 'Classic Rock'),
144 (30, 'Classical'),
145 (31, 'Club'),
146 (32, 'Club - House'),
147 (33, 'Comedy'),
148 (34, 'Contemporary Christian'),
149 (35, 'Country'),
150 (36, 'Crossover'),
151 (37, 'Cult'),
152 (38, 'Dance'),
153 (39, 'Dance Hall'),
154 (40, 'Darkwave'),
155 (41, 'Death Metal'),
156 (42, 'Disco'),
157 (43, 'Dream'),
158 (44, 'Drum & Bass'),
159 (45, 'Drum Solo'),
160 (46, 'Duet'),
161 (47, 'Easy Listening'),
162 (48, 'Electronic'),
163 (49, 'Ethnic'),
164 (50, 'Euro-House'),
165 (51, 'Euro-Techno'),
166 (52, 'Eurodance'),
167 (53, 'Fast Fusion'),
168 (54, 'Folk'),
169 (55, 'Folk-Rock'),
170 (56, 'Folklore'),
171 (57, 'Freestyle'),
172 (58, 'Funk'),
173 (59, 'Fusion'),
174 (60, 'Game'),
175 (61, 'Gangsta'),
176 (62, 'Goa'),
177 (63, 'Gospel'),
178 (64, 'Gothic'),
179 (65, 'Gothic Rock'),
180 (66, 'Grunge'),
181 (67, 'Hard Rock'),
182 (68, 'Hardcore'),
183 (69, 'Heavy Metal'),
184 (70, 'Hip-Hop'),
185 (71, 'House'),
186 (72, 'Humour'),
187 (73, 'Indie'),
188 (74, 'Industrial'),
189 (75, 'Instrumental'),
190 (76, 'Instrumental Pop'),
191 (77, 'Instrumental Rock'),
192 (78, 'JPop'),
193 (79, 'Jazz'),
194 (80, 'Jazz+Funk'),
195 (81, 'Jungle'),
196 (82, 'Latin'),
197 (83, 'Lo-Fi'),
198 (84, 'Meditative'),
199 (85, 'Merengue'),
200 (86, 'Metal'),
201 (87, 'Musical'),
202 (88, 'National Folk'),
203 (89, 'Native US'),
204 (90, 'Negerpunk'),
205 (91, 'New Age'),
206 (92, 'New Wave'),
207 (93, 'Noise'),
208 (94, 'Oldies'),
209 (95, 'Opera'),
210 (96, 'Other'),
211 (97, 'Polka'),
212 (98, 'Polsk Punk'),
213 (99, 'Pop'),
214 (100, 'Pop-Folk'),
215 (101, 'Pop/Funk'),
216 (102, 'Porn Groove'),
217 (103, 'Power Ballad'),
218 (104, 'Pranks'),
219 (105, 'Primus'),
220 (106, 'Progressive Rock'),
221 (107, 'Psychadelic'),
222 (108, 'Psychedelic Rock'),
223 (109, 'Punk'),
224 (110, 'Punk Rock'),
225 (111, 'R&B'),
226 (112, 'Rap'),
227 (113, 'Rave'),
228 (114, 'Reggae'),
229 (115, 'Retro'),
230 (116, 'Revival'),
231 (117, 'Rhythmic Soul'),
232 (118, 'Rock'),
233 (119, 'Rock & Roll'),
234 (120, 'Salsa'),
235 (121, 'Samba'),
236 (122, 'Satire'),
237 (123, 'Showtunes'),
238 (124, 'Ska'),
239 (125, 'Slow Jam'),
240 (126, 'Slow Rock'),
241 (127, 'Sonata'),
242 (128, 'Soul'),
243 (129, 'Sound Clip'),
244 (130, 'Soundtrack'),
245 (131, 'Southern Rock'),
246 (132, 'Space'),
247 (133, 'Speech'),
248 (134, 'Swing'),
249 (135, 'Symphonic Rock'),
250 (136, 'Symphony'),
251 (137, 'Synthpop'),
252 (138, 'Tango'),
253 (139, 'Techno'),
254 (140, 'Techno-Industrial'),
255 (141, 'Terror'),
256 (142, 'Thrash Metal'),
257 (143, 'Top 40'),
258 (144, 'Trailer'),
259 (145, 'Trance'),
260 (146, 'Tribal'),
261 (147, 'Trip-Hop'),
262 (148, 'Vocal');
263/*!40000 ALTER TABLE `genre` ENABLE KEYS */;
264
265-- Dump della struttura di tabella radiomestre.history
266CREATE TABLE IF NOT EXISTS `history` (
267 `ID` int(11) NOT NULL AUTO_INCREMENT,
268 `trackID` int(11) NOT NULL,
269 `date_played` datetime DEFAULT '2002-01-01 00:00:01',
270 `song_type` tinyint(2) NOT NULL,
271 `id_subcat` int(11) NOT NULL,
272 `id_genre` int(11) NOT NULL,
273 `duration` double(11,5) NOT NULL,
274 `artist` varchar(255) NOT NULL,
275 `original_artist` varchar(255) NOT NULL,
276 `title` varchar(255) NOT NULL,
277 `album` varchar(255) NOT NULL,
278 `composer` varchar(255) NOT NULL,
279 `label` varchar(255) NOT NULL,
280 `year` varchar(4) NOT NULL DEFAULT '1900',
281 `track_no` smallint(6) NOT NULL DEFAULT 0,
282 `disc_no` smallint(6) NOT NULL DEFAULT 0,
283 `publisher` varchar(255) NOT NULL,
284 `copyright` varchar(255) NOT NULL,
285 `isrc` varchar(255) NOT NULL,
286 `listeners` mediumint(9) DEFAULT NULL,
287 PRIMARY KEY (`ID`),
288 KEY `artist` (`artist`),
289 KEY `title` (`title`),
290 KEY `date_played` (`date_played`)
291) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
292
293-- Dump dei dati della tabella radiomestre.history: 3 rows
294/*!40000 ALTER TABLE `history` DISABLE KEYS */;
295INSERT INTO `history` (`ID`, `trackID`, `date_played`, `song_type`, `id_subcat`, `id_genre`, `duration`, `artist`, `original_artist`, `title`, `album`, `composer`, `label`, `year`, `track_no`, `disc_no`, `publisher`, `copyright`, `isrc`, `listeners`) VALUES
296 (1, 1, '2018-02-16 15:40:30', 0, 4, 1, 182.80952, 'Michael Bublé', '', 'Santa Baby', '', '', '', '', 0, 0, '', '', '', 0),
297 (2, 4, '2018-02-16 16:59:14', 0, 4, 1, 4520.06864, '4E', '', 'Blue Note', '', '', '', '', 0, 0, '', '', '', 0),
298 (3, 2, '2018-02-16 18:35:04', 0, 4, 1, 5019.67494, '80 s Soul & Funk Mix', '', 'Dj XS 100% Old School Funk & Soul Grooves', '', '', '', '', 0, 0, '', '', '', 0);
299/*!40000 ALTER TABLE `history` ENABLE KEYS */;
300
301-- Dump della struttura di tabella radiomestre.playlists
302CREATE TABLE IF NOT EXISTS `playlists` (
303 `ID` int(11) NOT NULL AUTO_INCREMENT,
304 `name` varchar(255) NOT NULL,
305 PRIMARY KEY (`ID`),
306 UNIQUE KEY `ID` (`ID`),
307 UNIQUE KEY `name` (`name`)
308) ENGINE=MyISAM DEFAULT CHARSET=utf8;
309
310-- Dump dei dati della tabella radiomestre.playlists: 1 rows
311/*!40000 ALTER TABLE `playlists` DISABLE KEYS */;
312INSERT INTO `playlists` (`ID`, `name`) VALUES
313 (-1, 'Active Playlist');
314/*!40000 ALTER TABLE `playlists` ENABLE KEYS */;
315
316-- Dump della struttura di tabella radiomestre.playlists_list
317CREATE TABLE IF NOT EXISTS `playlists_list` (
318 `ID` int(11) NOT NULL AUTO_INCREMENT,
319 `pID` int(11) NOT NULL,
320 `sID` int(11) NOT NULL,
321 `cstart` double(11,5) NOT NULL,
322 `cnext` double(11,5) NOT NULL,
323 `cend` double(11,5) NOT NULL,
324 `fin` double(11,5) NOT NULL,
325 `fout` double(11,5) NOT NULL,
326 `swID` int(11) NOT NULL,
327 `swplay` double(11,5) NOT NULL,
328 `vtID` int(11) NOT NULL,
329 `vtplay` double(11,5) NOT NULL,
330 `swfirst` enum('True','False') NOT NULL,
331 `ord` int(11) NOT NULL,
332 PRIMARY KEY (`ID`),
333 KEY `ID` (`ID`)
334) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
335
336-- Dump dei dati della tabella radiomestre.playlists_list: 1 rows
337/*!40000 ALTER TABLE `playlists_list` DISABLE KEYS */;
338INSERT INTO `playlists_list` (`ID`, `pID`, `sID`, `cstart`, `cnext`, `cend`, `fin`, `fout`, `swID`, `swplay`, `vtID`, `vtplay`, `swfirst`, `ord`) VALUES
339 (1, -1, 3, 0.27551, 9122.02583, 9122.22583, 0.00000, 0.20000, 0, -100.00000, 0, -100.00000, 'False', 0);
340/*!40000 ALTER TABLE `playlists_list` ENABLE KEYS */;
341
342-- Dump della struttura di tabella radiomestre.queuelist
343CREATE TABLE IF NOT EXISTS `queuelist` (
344 `ID` int(11) NOT NULL AUTO_INCREMENT,
345 `songID` int(11) NOT NULL DEFAULT 0,
346 `artist` varchar(250) NOT NULL,
347 `swID` int(11) NOT NULL DEFAULT -1,
348 `swPlay` double(11,5) NOT NULL DEFAULT 0.00000,
349 `vtID` int(11) NOT NULL DEFAULT -1,
350 `vtPlay` double(11,5) NOT NULL DEFAULT 0.00000,
351 PRIMARY KEY (`ID`)
352) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='12';
353
354-- Dump dei dati della tabella radiomestre.queuelist: 1 rows
355/*!40000 ALTER TABLE `queuelist` DISABLE KEYS */;
356INSERT INTO `queuelist` (`ID`, `songID`, `artist`, `swID`, `swPlay`, `vtID`, `vtPlay`) VALUES
357 (1, 3, 'Acid Jazz Classics', -1, 0.00000, -1, 0.00000);
358/*!40000 ALTER TABLE `queuelist` ENABLE KEYS */;
359
360-- Dump della struttura di tabella radiomestre.requests
361CREATE TABLE IF NOT EXISTS `requests` (
362 `ID` int(11) NOT NULL AUTO_INCREMENT,
363 `songID` int(11) NOT NULL,
364 `username` varchar(255) NOT NULL DEFAULT 'Anomymous',
365 `userIP` varchar(50) NOT NULL,
366 `message` text DEFAULT NULL,
367 `requested` datetime NOT NULL,
368 `played` int(1) NOT NULL DEFAULT 0,
369 PRIMARY KEY (`ID`)
370) ENGINE=MyISAM DEFAULT CHARSET=utf8;
371
372-- Dump dei dati della tabella radiomestre.requests: 0 rows
373/*!40000 ALTER TABLE `requests` DISABLE KEYS */;
374/*!40000 ALTER TABLE `requests` ENABLE KEYS */;
375
376-- Dump della struttura di tabella radiomestre.rotations
377CREATE TABLE IF NOT EXISTS `rotations` (
378 `ID` int(11) NOT NULL AUTO_INCREMENT,
379 `name` varchar(255) NOT NULL,
380 PRIMARY KEY (`ID`),
381 UNIQUE KEY `name` (`name`)
382) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
383
384-- Dump dei dati della tabella radiomestre.rotations: 1 rows
385/*!40000 ALTER TABLE `rotations` DISABLE KEYS */;
386INSERT INTO `rotations` (`ID`, `name`) VALUES
387 (1, 'Default');
388/*!40000 ALTER TABLE `rotations` ENABLE KEYS */;
389
390-- Dump della struttura di tabella radiomestre.rotations_list
391CREATE TABLE IF NOT EXISTS `rotations_list` (
392 `ID` int(11) NOT NULL AUTO_INCREMENT,
393 `pID` int(11) NOT NULL,
394 `catID` int(11) NOT NULL,
395 `subID` int(11) NOT NULL,
396 `genID` int(11) NOT NULL,
397 `mood` varchar(250) DEFAULT NULL,
398 `gender` varchar(250) DEFAULT NULL,
399 `language` varchar(250) DEFAULT NULL,
400 `start_type` int(11) NOT NULL DEFAULT 0,
401 `end_type` int(11) NOT NULL DEFAULT 0,
402 `selType` int(1) NOT NULL,
403 `sweeper` int(1) NOT NULL,
404 `repeatRule` set('True','False') NOT NULL,
405 `ord` int(2) NOT NULL,
406 `data` text NOT NULL,
407 `track_separation` int(11) NOT NULL DEFAULT 0,
408 `artist_separation` int(11) NOT NULL DEFAULT 0,
409 `title_separation` int(11) NOT NULL DEFAULT 0,
410 `album_separation` int(11) NOT NULL DEFAULT 0,
411 `advanced` text DEFAULT NULL,
412 PRIMARY KEY (`ID`)
413) ENGINE=MyISAM DEFAULT CHARSET=utf8;
414
415-- Dump dei dati della tabella radiomestre.rotations_list: 0 rows
416/*!40000 ALTER TABLE `rotations_list` DISABLE KEYS */;
417/*!40000 ALTER TABLE `rotations_list` ENABLE KEYS */;
418
419-- Dump della struttura di tabella radiomestre.settings
420CREATE TABLE IF NOT EXISTS `settings` (
421 `source` varchar(150) NOT NULL,
422 `setting` varchar(150) NOT NULL,
423 `value` varchar(250) NOT NULL
424) ENGINE=MyISAM DEFAULT CHARSET=utf8;
425
426-- Dump dei dati della tabella radiomestre.settings: 0 rows
427/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
428/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
429
430-- Dump della struttura di tabella radiomestre.songs
431CREATE TABLE IF NOT EXISTS `songs` (
432 `ID` int(11) NOT NULL AUTO_INCREMENT,
433 `path` varchar(255) NOT NULL,
434 `enabled` int(1) NOT NULL DEFAULT 0,
435 `date_added` datetime DEFAULT '2002-01-01 00:00:01',
436 `date_modified` datetime DEFAULT '2002-01-01 00:00:01',
437 `date_played` datetime DEFAULT '2002-01-01 00:00:01',
438 `artist_played` datetime DEFAULT '2002-01-01 00:00:01',
439 `album_played` datetime DEFAULT '2002-01-01 00:00:01',
440 `title_played` datetime DEFAULT '2002-01-01 00:00:01',
441 `count_played` mediumint(9) NOT NULL DEFAULT 0,
442 `play_limit` int(11) NOT NULL DEFAULT 0,
443 `limit_action` int(1) NOT NULL DEFAULT 0,
444 `start_date` datetime DEFAULT '2002-01-01 00:00:01',
445 `end_date` datetime DEFAULT '2002-01-01 00:00:01',
446 `startEvent` int(11) NOT NULL DEFAULT -1,
447 `endEvent` int(11) NOT NULL DEFAULT -1,
448 `song_type` tinyint(2) NOT NULL,
449 `id_subcat` int(11) NOT NULL,
450 `id_genre` int(11) NOT NULL,
451 `weight` double(5,1) NOT NULL DEFAULT 50.0,
452 `duration` double(11,5) NOT NULL,
453 `original_duration` double(11,5) NOT NULL,
454 `cue_times` varchar(255) NOT NULL DEFAULT '&',
455 `precise_cue` tinyint(1) NOT NULL DEFAULT 0,
456 `fade_type` tinyint(1) NOT NULL DEFAULT 0,
457 `start_type` tinyint(1) NOT NULL DEFAULT 0,
458 `end_type` tinyint(1) NOT NULL DEFAULT 0,
459 `mix_type` tinyint(1) NOT NULL DEFAULT 0,
460 `mood` varchar(150) NOT NULL DEFAULT 'Not Set',
461 `gender` varchar(150) NOT NULL DEFAULT 'Not Set',
462 `lang` varchar(150) NOT NULL DEFAULT 'Not Set',
463 `rating` tinyint(1) NOT NULL DEFAULT 0,
464 `loudness` double(11,2) NOT NULL DEFAULT 1.00,
465 `overlay` tinyint(1) NOT NULL DEFAULT 0,
466 `artist` varchar(255) NOT NULL,
467 `original_artist` varchar(255) NOT NULL,
468 `title` varchar(255) NOT NULL,
469 `album` varchar(255) NOT NULL,
470 `composer` varchar(255) NOT NULL,
471 `label` varchar(255) NOT NULL,
472 `year` varchar(4) NOT NULL DEFAULT '1900',
473 `track_no` smallint(6) NOT NULL DEFAULT 0,
474 `disc_no` smallint(6) NOT NULL DEFAULT 0,
475 `publisher` varchar(255) NOT NULL,
476 `copyright` varchar(255) NOT NULL,
477 `isrc` varchar(255) NOT NULL,
478 `bpm` double(11,1) NOT NULL,
479 `comments` text DEFAULT NULL,
480 `sweepers` varchar(250) DEFAULT NULL,
481 `image` varchar(255) NOT NULL DEFAULT 'no_image.jpg',
482 `buy_link` varchar(255) NOT NULL DEFAULT 'http://',
483 `url1` varchar(255) NOT NULL DEFAULT 'http://',
484 `url2` varchar(255) NOT NULL DEFAULT 'http://',
485 `tdate_played` datetime DEFAULT '2002-01-01 00:00:01',
486 `tartist_played` datetime DEFAULT '2002-01-01 00:00:01',
487 `originalmetadata` tinyint(1) NOT NULL DEFAULT 0,
488 PRIMARY KEY (`ID`),
489 UNIQUE KEY `path` (`path`),
490 KEY `title` (`title`),
491 KEY `artist` (`artist`),
492 KEY `date_played` (`date_played`),
493 KEY `artist_played` (`artist_played`),
494 KEY `album_played` (`album_played`),
495 KEY `count_played` (`count_played`),
496 KEY `id_subcat` (`id_subcat`)
497) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
498
499-- Dump dei dati della tabella radiomestre.songs: 4 rows
500/*!40000 ALTER TABLE `songs` DISABLE KEYS */;
501INSERT INTO `songs` (`ID`, `path`, `enabled`, `date_added`, `date_modified`, `date_played`, `artist_played`, `album_played`, `title_played`, `count_played`, `play_limit`, `limit_action`, `start_date`, `end_date`, `startEvent`, `endEvent`, `song_type`, `id_subcat`, `id_genre`, `weight`, `duration`, `original_duration`, `cue_times`, `precise_cue`, `fade_type`, `start_type`, `end_type`, `mix_type`, `mood`, `gender`, `lang`, `rating`, `loudness`, `overlay`, `artist`, `original_artist`, `title`, `album`, `composer`, `label`, `year`, `track_no`, `disc_no`, `publisher`, `copyright`, `isrc`, `bpm`, `comments`, `sweepers`, `image`, `buy_link`, `url1`, `url2`, `tdate_played`, `tartist_played`, `originalmetadata`) VALUES
502 (1, 'C:\\Users\\Marco\\Music\\♥ Michael Buble - Santa Baby.mp3', 1, '2018-02-16 15:32:17', '2002-01-01 00:00:01', '2018-02-16 15:40:30', '2018-02-16 15:40:30', '2002-01-01 00:00:01', '2018-02-16 15:40:30', 1, 0, 0, '2002-01-01 00:00:01', '2002-01-01 00:00:01', 0, 0, 0, 4, 1, 50.0, 182.80952, 185.53576, '&sta=0.196371882086168&xta=182.650272108844&end=183.00589569161&fin=0&fou=0.355623582766441', 0, 0, 0, 0, 0, '', '', '', 0, 1.00, 0, 'Michael Bublé', '', 'Santa Baby', '', '', '', '', 0, 0, '', '', '', 0.0, '', '', 'no_cover_image.jpg', '', '', '', '2002-01-01 00:00:01', '2002-01-01 00:00:01', 0),
503 (2, 'C:\\Users\\Marco\\Music\\4K YouTube to MP3\\80 s Soul & Funk Mix - Dj XS 100% Old School Funk & Soul Grooves.mp3', 1, '2018-02-16 15:32:19', '2002-01-01 00:00:01', '2018-02-16 18:35:04', '2018-02-16 18:35:05', '2002-01-01 00:00:01', '2018-02-16 18:35:04', 1, 0, 0, '2002-01-01 00:00:01', '2002-01-01 00:00:01', 0, 0, 0, 4, 1, 50.0, 5019.67494, 5020.74882, '&sta=1.07290249433107&xta=5020.54784580499&end=5020.74784580499&fin=0&fou=0.199999999999818', 0, 0, 0, 0, 0, '', '', '', 0, 1.00, 0, '80 s Soul & Funk Mix', '', 'Dj XS 100% Old School Funk & Soul Grooves', '', '', '', '', 0, 0, '', '', '', 0.0, '', '', 'no_cover_image.jpg', '', '', '', '2002-01-01 00:00:01', '2002-01-01 00:00:01', 0),
504 (3, 'C:\\Users\\Marco\\Music\\4K YouTube to MP3\\Acid Jazz Classics - 2 Hours Funk Jazz Soul Breaks Bossa Beats - HQ Non Stop.mp3', 1, '2018-02-16 15:32:23', '2002-01-01 00:00:01', '2002-01-01 00:00:01', '2002-01-01 00:00:01', '2002-01-01 00:00:01', '2002-01-01 00:00:01', 0, 0, 0, '2002-01-01 00:00:01', '2002-01-01 00:00:01', 0, 0, 0, 4, 1, 50.0, 9121.95032, 9124.66392, '&sta=0.275510204081633&xta=9122.0258276644&end=9122.2258276644&fin=0&fou=0.200000000000728', 0, 0, 0, 0, 0, '', '', '', 0, 1.00, 0, 'Acid Jazz Classics', '', '2 Hours Funk Jazz Soul Breaks Bossa Beats', '', '', '', '', 0, 0, '', '', '', 0.0, '', '', 'no_cover_image.jpg', '', '', '', '2002-01-01 00:00:01', '2002-01-01 00:00:01', 0),
505 (4, 'C:\\Users\\Marco\\Music\\4K YouTube to MP3\\Blue Note - Blue Funk [Various Artists].mp3', 1, '2018-02-16 15:32:26', '2002-01-01 00:00:01', '2018-02-16 16:59:14', '2018-02-16 16:59:14', '2002-01-01 00:00:01', '2018-02-16 16:59:14', 1, 0, 0, '2002-01-01 00:00:01', '2002-01-01 00:00:01', 0, 0, 0, 4, 1, 50.0, 4520.06864, 4532.20678, '&sta=1.13133786848073&xta=4520.99997732426&end=4521.19997732426&fin=0&fou=0.199999999999818', 0, 0, 0, 0, 0, '', '', '', 0, 1.00, 0, '4E', '', 'Blue Note', '', '', '', '', 0, 0, '', '', '', 0.0, '', '', 'no_cover_image.jpg', '', '', '', '2002-01-01 00:00:01', '2002-01-01 00:00:01', 0);
506/*!40000 ALTER TABLE `songs` ENABLE KEYS */;
507
508-- Dump della struttura di tabella radiomestre.subcategory
509CREATE TABLE IF NOT EXISTS `subcategory` (
510 `ID` int(11) NOT NULL AUTO_INCREMENT,
511 `parentid` int(11) NOT NULL,
512 `name` varchar(100) NOT NULL,
513 PRIMARY KEY (`ID`)
514) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
515
516-- Dump dei dati della tabella radiomestre.subcategory: 22 rows
517/*!40000 ALTER TABLE `subcategory` DISABLE KEYS */;
518INSERT INTO `subcategory` (`ID`, `parentid`, `name`) VALUES
519 (1, 1, '90s'),
520 (2, 1, '80s'),
521 (3, 1, 'Oldies'),
522 (4, 1, '2000s'),
523 (5, 1, 'Heavy Rotation'),
524 (6, 1, 'Top 40'),
525 (7, 2, 'Contest Effects'),
526 (8, 3, 'Daily Sweepers'),
527 (9, 3, 'Nightly Sweepers'),
528 (10, 4, 'Artist IDs'),
529 (11, 5, 'Station Jingles'),
530 (12, 6, 'Radio Show Promos'),
531 (13, 7, 'Sponsor Commercials'),
532 (14, 7, 'Paid Commercials'),
533 (15, 8, 'Daily News'),
534 (16, 9, 'Music Interviews'),
535 (17, 9, 'Political Interviews'),
536 (18, 10, 'My First Show'),
537 (19, 10, 'My Second Show'),
538 (20, 11, 'Other'),
539 (21, 11, 'Syndicated Shows'),
540 (22, 11, 'Syndicated News');
541/*!40000 ALTER TABLE `subcategory` ENABLE KEYS */;
542
543-- Dump della struttura di procedura radiomestre.UpdateTracks
544DELIMITER //
545CREATE DEFINER=`root`@`localhost` PROCEDURE `UpdateTracks`(IN trackID INT, IN tType INT, IN curListeners INT, IN historyDays INT, IN pWeight DOUBLE)
546BEGIN
547SET @tArtist = (SELECT artist FROM songs WHERE ID=trackID);
548SET @tAlbum = (SELECT album FROM songs WHERE ID=trackID);
549SET @tTitle = (SELECT title FROM songs WHERE ID=trackID);
550UPDATE `songs` SET `count_played`=`count_played`+1, `date_played`=NOW() WHERE `ID`=trackID;
551IF tType = 0 OR tType = 9 THEN
552 UPDATE `songs` SET `artist_played`=NOW() WHERE `artist`=@tArtist;
553 UPDATE `songs` SET `title_played`=NOW() WHERE `title`=@tTitle;
554 IF @tAlbum <> '' THEN
555 UPDATE `songs` SET `album_played`=NOW() WHERE `album`=@tAlbum;
556 END IF;
557END IF;
558IF tType = 9 THEN
559 UPDATE `requests` SET `played`=1 WHERE `songID`=trackID;
560END IF;
561UPDATE `songs` SET `enabled`=0, `play_limit`=0 WHERE `enabled`=1 AND `play_limit`>0 AND `count_played`>=`play_limit` AND `limit_action`=1;
562DELETE FROM `songs` WHERE `play_limit`>0 AND `count_played`>=`play_limit` AND `limit_action`=2;
563UPDATE `songs` SET `id_subcat`=ABS(limit_action), `play_limit`=0, limit_action=0 WHERE `enabled`=1 AND `limit_action`<0 AND `count_played`>=`play_limit`;
564IF pWeight>0 THEN
565 UPDATE `songs` SET `weight`=`weight`-pWeight WHERE `ID`=trackID AND (`weight`-pWeight)>=0;
566END IF;
567IF historyDays > 0 THEN
568 INSERT INTO `history`(trackID, date_played, song_type, id_subcat, id_genre, duration, artist, original_artist, title, album, composer, label, `year`, track_no, disc_no, publisher, copyright, isrc, listeners)
569 SELECT ID, NOW(), song_type, id_subcat, id_genre, duration, artist, original_artist, title, album, composer, label, `year`, track_no, disc_no, publisher, copyright, isrc, curListeners FROM `songs` WHERE ID=trackID;
570END IF;
571DELETE FROM `history` WHERE TIMESTAMPDIFF(DAY, `date_played`, NOW()) >= historyDays;
572END//
573DELIMITER ;
574
575-- Dump della struttura di tabella radiomestre.users
576CREATE TABLE IF NOT EXISTS `users` (
577 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
578 `user` varchar(100) NOT NULL,
579 `auth` varchar(250) DEFAULT NULL,
580 `data` text NOT NULL,
581 KEY `ID` (`ID`)
582) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
583
584-- Dump dei dati della tabella radiomestre.users: 1 rows
585/*!40000 ALTER TABLE `users` DISABLE KEYS */;
586INSERT INTO `users` (`ID`, `user`, `auth`, `data`) VALUES
587 (1, 'admin', '8ZCC4bp0CQxRB0NN5pzdOJG0m6L4b71/TEJ+IJG10u93m0Du94Pl15sCgkViAMv9fY150iwQQREU5TuGqa7pmw==', '');
588/*!40000 ALTER TABLE `users` ENABLE KEYS */;
589
590/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
591/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
592/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;