1--
2-- This adds Manufacturers and Models
3--
4
5SET @s = (SELECT IF(
6    (SELECT COUNT(*)
7      FROM INFORMATION_SCHEMA.TABLES
8      WHERE table_name = 'MontageLayouts'
9      AND table_schema = DATABASE()
10    ) > 0,
11    "SELECT 'MontageLayouts table exists'",
12    "
13 CREATE TABLE MontageLayouts (
14  `Id` int(10) unsigned NOT NULL auto_increment,
15  `Name`    TEXT  NOT NULL,
16  `Positions` LONGTEXT,
17  PRIMARY KEY (`Id`)
18);
19"
20  ));
21
22PREPARE stmt FROM @s;
23EXECUTE stmt;
24
25DELETE FROM MontageLayouts WHERE Name IN ('Freeform','2 Wide','3 Wide','4 Wide','5 Wide');
26
27SET @s = ( SELECT IF(
28    (SELECT COUNT(*) FROM MontageLayouts WHERE Name='Freeform') > 0,
29      "SELECT 'Freeform already in layouts'",
30'INSERT INTO MontageLayouts (`Name`,`Positions`) VALUES (\'Freeform\', \'{"default":{"float":"left","position":"relative","left":"0px","right":"0px","top":"0px","bottom":"0px"}}\');'
31) );
32PREPARE stmt FROM @s;
33EXECUTE stmt;
34
35SET @s = ( SELECT IF(
36    (SELECT COUNT(*) FROM MontageLayouts WHERE Name='2 Wide') > 0,
37"SELECT '2 Wide already in layouts'",
38'INSERT INTO MontageLayouts (`Name`,`Positions`) VALUES (\'2 Wide\', \'{"default":{"float":"left","position":"relative","width":"49%","left":"0px","right":"0px","top":"0px","bottom":"0px"}}\');'
39) );
40PREPARE stmt FROM @s;
41EXECUTE stmt;
42
43SET @s = ( SELECT IF(
44    (SELECT COUNT(*) FROM MontageLayouts WHERE Name='3 Wide') > 0,
45      "SELECT '3 Wide already in layouts'",
46'INSERT INTO MontageLayouts (`Name`,`Positions`) VALUES (\'3 Wide\', \'{"default":{"float":"left","position":"relative","width":"33%","left":"0px","right":"0px","top":"0px","bottom":"0px"}}\');'
47) );
48PREPARE stmt FROM @s;
49EXECUTE stmt;
50
51SET @s = ( SELECT IF(
52    (SELECT COUNT(*) FROM MontageLayouts WHERE Name='4 Wide') > 0,
53      "SELECT '4 Wide already in layouts'",
54'INSERT INTO MontageLayouts (`Name`,`Positions`) VALUES (\'4 Wide\', \'{"default":{"float":"left","position":"relative","width":"24.5%","left":"0px","right":"0px","top":"0px","bottom":"0px"}}\');'
55) );
56
57PREPARE stmt FROM @s;
58EXECUTE stmt;
59
60SET @s = ( SELECT IF(
61    (SELECT COUNT(*) FROM MontageLayouts WHERE Name='5 Wide') > 0,
62      "SELECT '5 Wide already in layouts'",
63      'INSERT INTO MontageLayouts (`Name`,`Positions`) VALUES (\'5 Wide\', \'{"default":{"float":"left","position":"relative","width":"19%"}}\' );'
64) );
65
66PREPARE stmt FROM @s;
67EXECUTE stmt;
68