LOCK TABLES `page` WRITE, `site` WRITE;

# Get the site id
select id into @siteId from site limit 1;

# Delete the old competition
DELETE FROM `page` WHERE `name` = '/competitions/gigantic-january-giveaway';

# New competition
INSERT INTO `page` (`site_id`, `image_id`, `title`, `name`, `description`, `cache`, `parent_page_id`, `previous_page_id`, `next_page_id`, `sitemap_priority`, `sitemap_frequency`, `sitemap_lastmod`, `menu_order`, `include_on_menu`)
VALUES
(@siteId, NULL, 'Gigantic January Giveaway | Competitions | Bath Racecourse', '/competitions/gigantic-january-giveaway', 'Gigantic January Giveaway', '<?xml version=\"1.0\" encoding=\"utf8\"?>\n<!DOCTYPE content [\n<!ELEMENT content (module | modal)*>\n<!ELEMENT module (#PCDATA)>\n<!ELEMENT modal (#PCDATA)>\n<!ATTLIST module key CDATA #REQUIRED>\n<!ATTLIST module type CDATA #REQUIRED>\n<!ATTLIST modal key CDATA #REQUIRED>\n]>\n<content><module key=\"fc5e60a2-9aaf-4403-acb2-e09df01d99f0\" type=\"page-hero\"><![CDATA[{\"template_name\":\"page-hero\",\"data\":{\"items\":[{\"image\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"show_placeholder\":true,\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}},\"title\":{\"text\":\"This is a slide title\",\"visible\":false},\"subtitle\":{\"text\":\"This is slide subtitle\",\"visible\":false},\"cta\":{\"label\":\"CTA Button\",\"url\":\"\\/\",\"target\":\"_self\",\"visible\":false}}]},\"block_type\":\"page-hero\"}]]></module><module key=\"67ce3f23-c63e-4911-a31b-6d2af80e25d9\" type=\"standard-content\"><![CDATA[{\"template_name\":\"hlg-intro-txt100\",\"template_inverse\":false,\"data\":{\"title\":{\"text\":\"ENTER FOR A CHANCE TO WIN 1 OF 2,021 PRIZES!\",\"visible\":\"true\"},\"content\":{\"text\":\"<p>AND they\'re off! Want something to look forward to in 2021? Enter our <strong>Gigantic January Giveaway<\\/strong> to be in with a chance to win one of our incredible prizes worth <strong>more than \\u00a325,000!!<\\/strong><\\/p><p><strong>Prizes on offer:<\\/strong><\\/p><ul><li>Money-Can\\u2019t-Buy Racing Experience<\\/li><li>10 x VIP Hospitality Packages<\\/li><li>A Luxury Overnight Stay &amp; Music Live Concert<\\/li><li>9 x Pairs of Music Live Tickets<\\/li><li>2,000 Vouchers Worth \\u00a310 each<\\/li><\\/ul><p>With over 570 race days from you to choose from if you are one of our lucky winners you really don\\u2019t want to miss out!<\\/p><p>All you\'ve got to do is enter your details below and will do the rest!<\\/p>\",\"visible\":\"true\"},\"paragraph\":{\"text\":\"This is paragraph text.\",\"visible\":true},\"cta\":{\"label\":\"Promo Block CTA\",\"target\":\"_self\",\"url\":\"\\/\",\"visible\":false},\"image50sqr\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image50land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image25a\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image25b\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image75\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image25port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image100\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image100thn\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}}},\"block_type\":\"standard-content\"}]]></module><module key=\"4f830f6f-127f-4129-8bd0-7f4e0be80079\" type=\"standard-content\"><![CDATA[{\"template_name\":\"hlg-txt100\",\"template_inverse\":false,\"data\":{\"title\":{\"text\":\"Promo Block Header\",\"visible\":\"true\"},\"content\":{\"text\":\"Content text.\",\"visible\":\"true\"},\"paragraph\":{\"text\":\"<p>Competition closes 23:59 on 7th February 2021. Winners will be notified within 10 working days of the competition closing date.<\\/p>\",\"visible\":true},\"cta\":{\"label\":\"Promo Block CTA\",\"target\":\"_self\",\"url\":\"\\/\",\"visible\":\"true\"},\"image50sqr\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image50land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image25a\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image25b\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image75\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image25port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image100\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"image100thn\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}}},\"block_type\":\"standard-content\"}]]></module><module key=\"dbfc9101-dec1-45ef-82b9-4951edc1e5f5\" type=\"key-facts\"><![CDATA[{\"template_name\":\"key-facts-center\",\"template_inverse\":false,\"data\":{\"title\":{\"text\":\"Title\",\"visible\":false},\"content\":{\"text\":\"Content\",\"visible\":false},\"items\":[{\"icon\":{\"name\":\"icon-15-racecourses\",\"visible\":false},\"title\":{\"text\":\"Terms & Conditions\",\"visible\":true},\"content\":{\"text\":\"Click below to download a copy of the full terms and conditions.\",\"visible\":true},\"cta\":{\"label\":\"Download\",\"url\":\"\\/downloads\\/Gigantic-Giveway-Terms-Conditions-bth.pdf\",\"target\":\"_self\",\"visible\":true}}]},\"block_type\":\"key-facts\"}]]></module></content>\n', 0, 0, 0, 0.9, 'monthly', NULL, 0, 1);

UNLOCK TABLES;