15
15
KEY `fk_production_automedia_media` (`mediaID`)
18
CREATE TABLE IF NOT EXISTS `rm_production_category` (
19
`categoryID` int(11) NOT NULL AUTO_INCREMENT,
20
`name` varchar(255) NOT NULL,
21
`start` date DEFAULT NULL,
22
`end` date DEFAULT NULL,
23
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
24
PRIMARY KEY (`categoryID`)
27
CREATE TABLE IF NOT EXISTS `rm_production_media` (
28
`productionID` int(11) NOT NULL AUTO_INCREMENT,
29
`mediaID` int(11) NOT NULL,
30
`name` varchar(255) NOT NULL,
31
`description` varchar(255) NULL,
32
`filename` varchar(255) NOT NULL,
33
`mimetype` varchar(255) NOT NULL,
34
`duration` varchar(255) NOT NULL,
35
`start` date DEFAULT NULL,
36
`end` date DEFAULT NULL,
37
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
38
PRIMARY KEY (`productionID`),
39
UNIQUE KEY `mediaID` (`mediaID`),
40
KEY `fk_production_media_media` (`mediaID`)
43
CREATE TABLE IF NOT EXISTS `rm_production_mediacategory` (
44
`productionID` int(11) NOT NULL,
45
`categoryID` int(11) NOT NULL
18
48
CREATE TABLE IF NOT EXISTS `rm_production_programmedia` (
19
49
`productionID` int(11) NOT NULL,
20
50
`programID` int(11) NOT NULL
25
55
`programID` int(11) NOT NULL
58
CREATE TABLE IF NOT EXISTS `rm_production_promo` (
59
`promoID` int(11) NOT NULL AUTO_INCREMENT,
60
`productionID` int(11) NOT NULL,
61
`authorised` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
62
`authorisedActorID` int(11) DEFAULT NULL,
63
PRIMARY KEY (`promoID`)
28
66
CREATE TABLE IF NOT EXISTS `rm_production_spot` (
29
67
`spotID` int(11) NOT NULL AUTO_INCREMENT,
30
68
`mediaID` int(11) NOT NULL,
31
`dateTime` datetime NOT NULL,
32
`playedDateTime` datetime DEFAULT NULL,
69
`scheduled` datetime NOT NULL,
70
`played` datetime DEFAULT NULL,
33
71
`priority` int(11) DEFAULT NULL,
34
72
`inactive` enum('false','true') DEFAULT 'false',
35
73
PRIMARY KEY (`spotID`),
36
74
KEY `fk_production_spot_media` (`mediaID`)
39
CREATE TABLE IF NOT EXISTS `rm_production_media` (
40
`productionID` int(11) NOT NULL AUTO_INCREMENT,
41
`mediaID` int(11) NOT NULL,
42
`name` varchar(255) NOT NULL,
43
`description` varchar(255) NULL,
44
`filename` varchar(255) NOT NULL,
45
`mimetype` varchar(255) NOT NULL,
46
`duration` varchar(255) NOT NULL,
47
`start` date DEFAULT NULL,
48
`end` date DEFAULT NULL,
49
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
50
PRIMARY KEY (`productionID`),
51
UNIQUE KEY `mediaID` (`mediaID`),
52
KEY `fk_production_media_media` (`mediaID`)
55
CREATE TABLE IF NOT EXISTS `rm_production_promo` (
56
`promoID` int(11) NOT NULL AUTO_INCREMENT,
57
`mediaID` int(11) NOT NULL,
58
`name` varchar(255) NOT NULL,
59
`description` varchar(255) NOT NULL,
60
`filename` varchar(255) NOT NULL,
61
`mimetype` varchar(255) NOT NULL,
62
`duration` varchar(255) NOT NULL,
63
`start` date DEFAULT NULL,
64
`end` date DEFAULT NULL,
65
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
66
`authorisedActorID` int(11) DEFAULT NULL,
67
PRIMARY KEY (`promoID`),
68
UNIQUE KEY `mediaID` (`mediaID`),
69
KEY `fk_production_promo_media` (`mediaID`)
72
CREATE TABLE IF NOT EXISTS `rm_production_category` (
73
`categoryID` int(11) NOT NULL AUTO_INCREMENT,
74
`name` varchar(255) NOT NULL,
75
`start` date DEFAULT NULL,
76
`end` date DEFAULT NULL,
77
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
78
PRIMARY KEY (`categoryID`)
81
CREATE TABLE IF NOT EXISTS `rm_production_mediacategory` (
82
`productionID` int(11) NOT NULL,
83
`categoryID` int(11) NOT NULL