1
ALTER TABLE `schedule_detail` CHANGE `layoutID` `CampaignID` INT( 11 ) NOT NULL;
3
ALTER TABLE `schedule_detail` ADD FOREIGN KEY ( `CampaignID` ) REFERENCES `campaign` (
5
) ON DELETE RESTRICT ON UPDATE RESTRICT ;
7
ALTER TABLE `schedule` CHANGE `layoutID` `CampaignID` INT( 11 ) NOT NULL;
9
ALTER TABLE `schedule` ADD FOREIGN KEY ( `CampaignID` ) REFERENCES `campaign` (
11
) ON DELETE RESTRICT ON UPDATE RESTRICT ;
13
DROP TABLE lklayoutgroup;
15
INSERT INTO `module` (`ModuleID`, `Module`, `Name`, `Enabled`, `RegionSpecific`, `Description`, `ImageUri`, `SchemaVersion`, `ValidExtensions`) VALUES (NULL, 'shellcommand', 'Shell Command', '1', '1', 'Execute a shell command on the client', 'img/forms/shellcommand.gif', '1', NULL);
17
INSERT INTO `setting` (`settingid`, `setting`, `value`, `type`, `helptext`, `options`, `cat`, `userChange`) VALUES (NULL, 'LIBRARY_SIZE_LIMIT_KB', '0', 'text', 'The Limit for the Library Size in KB', NULL, 'content', '0'), (NULL, 'MONTHLY_XMDS_TRANSFER_LIMIT_KB', '0', 'text', 'XMDS Transfer Limit in KB/month', NULL, 'general', '0');
19
CREATE TABLE IF NOT EXISTS `bandwidth` (
20
`BandwidthID` int(11) NOT NULL AUTO_INCREMENT,
21
`DateTime` int(11) NOT NULL,
22
`Type` tinyint(4) NOT NULL,
23
`DisplayID` int(11) NOT NULL,
24
`Size` int(11) NOT NULL,
25
PRIMARY KEY (`BandwidthID`)
26
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
28
ALTER TABLE `user` ADD `Retired` TINYINT NOT NULL DEFAULT '0';
30
INSERT INTO `setting` (`settingid`, `setting`, `value`, `type`, `helptext`, `options`, `cat`, `userChange`) VALUES (NULL, 'DEFAULT_LANGUAGE', 'en_GB', 'text', 'The default language to use', NULL, 'general', '1');
32
UPDATE `version` SET `app_ver` = '1.3.3', `XmdsVersion` = 3;
33
UPDATE `setting` SET `value` = 0 WHERE `setting` = 'PHONE_HOME_DATE';
34
UPDATE `version` SET `DBVersion` = '47';
b'\\ No newline at end of file'