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