← Back to branch summary

~alexharrington/xibo/pyclient-1.1.0a22

« back to all changes in this revision

Viewing changes to server/install/database/3.sql

  • Committer: Alex Harrington
  • Date: 2009-12-31 11:38:50 UTC
  • Revision ID: alex@longhill.org.uk-20091231113850-bz5flhqq2gsw0qxf
Converted to 2.0 repo format and fixed lineendings

Show diffs side-by-side

added added

removed removed

Lines of Context:
server/install/database/3.sql
1
 
UPDATE `setting` SET `type` = 'timezone' WHERE `setting`.`settingid` =11 LIMIT 1 ;
2
 
 
3
 
INSERT INTO `layout` (`layoutID`, `layout`, `permissionID`, `xml`, `userID`, `createdDT`, `modifiedDT`, `description`, `tags`, `templateID`, `retired`, `duration`, `background`) VALUES (NULL, 'Default Layout', '3', '<?xml version="1.0"?>
4
 
<layout width="800" height="500" bgcolor="#000000"><region id="47ff29524ce1b" width="800" height="500" top="0" left="0"><media id="ba2b90ee2e21f9aaffbc45f253068c60" type="text" duration="20" lkid="" schemaVersion="1">
5
 
                                        <options><direction>none</direction></options>
6
 
                                        <raw><text><![CDATA[<h1 style="text-align: center;"><span style="font-size: 2em;"><span style="font-family: Verdana;"><span style="color: rgb(255, 255, 255);">Welcome to </span></span></span></h1><h1 style="text-align: center;"><span style="font-size: 2em;"><span style="font-family: Verdana;"><span style="color: rgb(255, 255, 255);">Xibo! </span></span></span></h1><h1 style="text-align: center;"><span style="font-size: 2em;"><span style="font-family: Verdana;"><span style="color: rgb(255, 255, 255);">Open Source Digital Signage</span></span></span></h1><p style="text-align: center;"><span style="font-family: Verdana;"><span style="color: rgb(255, 255, 255);"><span style="font-size: 1.6em;">This is the default layout - please feel free to change it whenever you like!</span></span></span></p>]]></text></raw>
7
 
                                </media><media id="7695b17df85b666d420c232ee768ef68" type="ticker" duration="100" lkid="" schemaVersion="1">
8
 
                                        <options><direction>up</direction><uri>http://xibo.org.uk/feed/</uri></options>
9
 
                                        <raw><template><![CDATA[<h2 style="text-align: center;"><span style="color: rgb(255, 255, 255);"><span style="font-size: 1.6em;"><u><span style="font-size: 1.8em;">[Title]</span></u></span></span></h2><p><span style="color: rgb(255, 255, 255);"><span style="font-size: 1.6em;">[Description]</span></span></p><p>&nbsp;</p><p>&nbsp;</p>]]></template></raw>
10
 
                                </media></region></layout>
11
 
', '1', NOW(), NOW(), NULL, NULL, NULL, '0', '0', NULL);
12
 
 
13
 
ALTER TABLE `log` CHANGE `page` `page` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL  ;
14
 
 
15
 
UPDATE `version` SET `DBVersion` = '3';
 
1
UPDATE `setting` SET `type` = 'timezone' WHERE `setting`.`settingid` =11 LIMIT 1 ;
 
2
 
 
3
-- Default Layout
 
4
INSERT INTO `layout` (`layoutID`, `layout`, `permissionID`, `xml`, `userID`, `createdDT`, `modifiedDT`, `description`, `tags`, `templateID`, `retired`, `duration`, `background`) VALUES (NULL, 'Default Layout', '3', '<?xml version="1.0"?>
 
5
<layout width="800" height="500" bgcolor="#000000"><region id="47ff29524ce1b" width="800" height="500" top="0" left="0"><media id="ba2b90ee2e21f9aaffbc45f253068c60" type="text" duration="20" lkid="" schemaVersion="1">
 
6
                                        <options><direction>none</direction></options>
 
7
                                        <raw><text><![CDATA[<h1 style="text-align: center;"><span style="font-size: 2em;"><span style="font-family: Verdana;"><span style="color: rgb(255, 255, 255);">Welcome to </span></span></span></h1><h1 style="text-align: center;"><span style="font-size: 2em;"><span style="font-family: Verdana;"><span style="color: rgb(255, 255, 255);">Xibo! </span></span></span></h1><h1 style="text-align: center;"><span style="font-size: 2em;"><span style="font-family: Verdana;"><span style="color: rgb(255, 255, 255);">Open Source Digital Signage</span></span></span></h1><p style="text-align: center;"><span style="font-family: Verdana;"><span style="color: rgb(255, 255, 255);"><span style="font-size: 1.6em;">This is the default layout - please feel free to change it whenever you like!</span></span></span></p>]]></text></raw>
 
8
                                </media><media id="7695b17df85b666d420c232ee768ef68" type="ticker" duration="100" lkid="" schemaVersion="1">
 
9
                                        <options><direction>up</direction><uri>http://xibo.org.uk/feed/</uri></options>
 
10
                                        <raw><template><![CDATA[<h2 style="text-align: center;"><span style="color: rgb(255, 255, 255);"><span style="font-size: 1.6em;"><u><span style="font-size: 1.8em;">[Title]</span></u></span></span></h2><p><span style="color: rgb(255, 255, 255);"><span style="font-size: 1.6em;">[Description]</span></span></p><p>&nbsp;</p><p>&nbsp;</p>]]></template></raw>
 
11
                                </media></region></layout>
 
12
', '1', NOW(), NOW(), NULL, NULL, NULL, '0', '0', NULL);
 
13
 
 
14
ALTER TABLE `log` CHANGE `page` `page` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL  ;
 
15
 
 
16
UPDATE `version` SET `DBVersion` = '3';