← Back to branch summary

~xibo-maintainers/xibo/tempel

« back to all changes in this revision

Viewing changes to install/database/46.sql

  • Committer: Dan Garner
  • Date: 2015-11-20 14:18:04 UTC
  • mfrom: (454.3.22)
  • Revision ID: git-v1:140e411ecd1777e5e9a27bf4326db2d8f947d534
Merge pull request #125 from dasgarner/upgrader

Upgrader

Show diffs side-by-side

added added

removed removed

Lines of Context:
install/database/46.sql
1
 
ALTER TABLE  `schedule_detail` DROP FOREIGN KEY  `schedule_detail_ibfk_6` ;
2
 
ALTER TABLE  `schedule` DROP FOREIGN KEY  `schedule_ibfk_1` ;
3
 
 
4
 
INSERT INTO `campaign` (Campaign, IsLayoutSpecific, UserId)
5
 
SELECT Layout, 1, UserId
6
 
  FROM `layout`
7
 
 WHERE layout = 'Default Layout';
8
 
 
9
 
INSERT INTO `lkcampaignlayout` (CampaignID, LayoutID, DisplayOrder)
10
 
SELECT 1, LayoutID, 1
11
 
  FROM `layout`
12
 
 WHERE layout = 'Default Layout';
13
 
 
14
 
UPDATE `version` SET `app_ver` = '1.3.3', `XmdsVersion` = 3;
15
 
UPDATE `setting` SET `value` = 0 WHERE `setting` = 'PHONE_HOME_DATE';
16
 
UPDATE `version` SET `DBVersion` = '46';
 
 
b'\\ No newline at end of file'