
SELECT id INTO @siteId FROM site limit 1;


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, 'Hereford Racing Club | Hereford Racecourse', '/hereford-racecourse/hereford-racing-club/', 'Hereford Racing Club', '<?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>\n<module key=\"254ce364-22fb-46b3-89db-8e1829cf3ccb\" type=\"page-hero\">{\"template_name\":\"page-hero\",\"data\":{\"items\":[{\"image\":{\"id\":0,\"filename\":\"\",\"show_placeholder\":true,\"alt\":\"\",\"tablet_land\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":\"\",\"filename\":\"\",\"alt\":\"\"}},\"title\":{\"text\":\"This is a slide title\",\"visible\":\"true\"},\"subtitle\":{\"text\":\"This is slide subtitle\",\"visible\":\"true\"},\"cta\":{\"label\":\"CTA Button\",\"url\":\"\\/\",\"target\":\"_self\",\"visible\":\"true\"}}]}}</module>\n\n<module key=\"04c2cf28-4782-4d66-8e9c-8df89f195c2c\" type=\"standard-content\">{\"template_name\":\"hlg-txt50-img50_1sqr\",\"template_inverse\":false,\"data\":{\"title\":{\"text\":\"Promo Block Header\",\"visible\":\"true\"},\"content\":{\"text\":\"Content text.\",\"visible\":\"true\"},\"paragraph\":{\"text\":\"This is paragraph text.\",\"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\":\"\"}}}}</module>\n\n<module key=\"4a2b6a98-cb27-4776-9ffd-1dbc80c072f0\" type=\"standard-content\">{\"template_name\":\"hlg-txt100\",\"template_inverse\":false,\"data\":{\"title\":{\"text\":\"Promo Block Header\",\"visible\":\"true\"},\"content\":{\"text\":\"Content text.\",\"visible\":\"true\"},\"paragraph\":{\"text\":\"This is paragraph text.\",\"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\":\"\"}}}}</module>\n\n<module key=\"98562661-0582-425b-9330-c1dcf6e683a0\" type=\"key-facts\">{\"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\":true},\"title\":{\"text\":\"title\",\"visible\":true},\"content\":{\"text\":\"Content\",\"visible\":true},\"cta\":{\"label\":\"CTA\",\"url\":\"\\/\",\"target\":\"_self\",\"visible\":true}}]}}</module>\n\n<module key=\"564d20b0-fc1e-4f81-bf23-e0ca3e42e76f\" type=\"salesforce-form\">{\"template_name\":\"salesforce-form-pre-newsletter\",\"template_inverse\":true}</module>\n</content>\n', 0, 0, 0, 0.9, 'monthly', NULL, 0, 1);


UPDATE
    site_global
SET
    data = '{\"template\":{\"name\":\"dark\",\"whatson\":true},\"evergreenPages\":[{\"heading\":\"Popular Events\",\"items\":[{\"title\":\"Ladies Day\",\"slug\":\"/popular-events/ladies-day/\"},{\"title\":\"Christmas Parties\",\"slug\":\"/your-venue/christmas-parties/\"}]}],\"menus\":[{\"title\":\"Raceday <br/>Experience\",\"menu\":\"raceday-experience\",\"columns\":[{\"title\":{\"text\":\"Raceday Experience\",\"slug\":\"/raceday-experience/\"},\"items\":[{\"type\":\"parent\",\"title\":\"Tickets & Admission\",\"slug\":\"/raceday-experience/tickets-and-admission/\"},{\"type\":\"parent\",\"title\":\"Dress Code\",\"slug\":\"/raceday-experience/dress-code/\"},{\"type\":\"parent\",\"title\":\"Food & Drink\",\"slug\":\"/raceday-experience/food-and-drink/\"}]},{\"items\":[{\"type\":\"parent\",\"title\":\"Get Here\",\"slug\":\"/raceday-experience/get-here/\"},{\"type\":\"parent\",\"title\":\"Where To Stay\",\"slug\":\"/raceday-experience/where-to-stay/\"},{\"type\":\"parent\",\"title\":\"Betting at Hereford\",\"slug\":\"/raceday-experience/betting-at-hereford/\"}]},{\"items\":[{\"type\":\"parent\",\"title\":\"Racecard\",\"slug\":\"/raceday-experience/racecard/\"},{\"type\":\"parent\",\"title\":\"Venue Accessibility\",\"slug\":\"/raceday-experience/venue-accessibility/\"},{\"type\":\"parent\",\"title\":\"Visiting Safely\",\"slug\":\"https://www.arenaracingcompany.co.uk/racing/visiting-safely/?site={site}&slug={slug}\"}]},{\"items\":[{\"type\":\"parent\",\"title\":\"FAQs\",\"slug\":\"/raceday-experience/faqs/\"}]}]},{\"title\":\"Restaurants & <br/>Hospitality\",\"menu\":\"restaurants-and-hospitality\",\"columns\":[{\"title\":{\"text\":\"Restaurants & Hospitality\",\"slug\":\"/restaurants-and-hospitality/\"},\"items\":[{\"type\":\"parent\",\"title\":\"Rusty Bridge Restaurant\",\"slug\":\"/restaurants-and-hospitality/rusty-bridge-restaurant/\"},{\"type\":\"parent\",\"title\":\"Grandstand & Hummingbird Bar\",\"slug\":\"/restaurants-and-hospitality/grandstand-and-hummingbird-bar/\"}]},{\"items\":[{\"type\":\"parent\",\"title\":\"Private Boxes\",\"slug\":\"/restaurants-and-hospitality/private-boxes/\"}]}]},{\"title\":\"Venue Hire\",\"menu\":\"your-venue\",\"columns\":[{\"title\":{\"text\":\"YourVENUE\",\"slug\":\"/your-venue/\"},\"items\":[{\"type\":\"parent\",\"title\":\"Business Meetings\",\"slug\":\"/your-venue/business-meetings/\"},{\"type\":\"parent\",\"title\":\"Conferences & Events\",\"slug\":\"/your-venue/conferences-and-events/\"},{\"type\":\"parent\",\"title\":\"YourVENUE+\",\"slug\":\"/your-venue/your-venue-plus/\"}]},{\"items\":[{\"type\":\"parent\",\"title\":\"Weddings\",\"slug\":\"/your-venue/weddings/\"},{\"type\":\"parent\",\"title\":\"Funerals & Wakes\",\"slug\":\"/your-venue/funerals-and-wakes/\"},{\"type\":\"parent\",\"title\":\"Parties & Celebrations\",\"slug\":\"/your-venue/parties-and-celebrations/\"}]},{\"items\":[{\"type\":\"parent\",\"title\":\"Christmas Parties\",\"slug\":\"/your-venue/christmas-parties/\"}]}]},{\"title\":\"Hereford <br/>Racecourse\",\"menu\":\"hereford-racecourse\",\"columns\":[{\"title\":{\"text\":\"Hereford Racecourse\",\"slug\":\"/hereford-racecourse/\"},\"items\":[{\"type\":\"parent\",\"title\":\"History\",\"slug\":\"/hereford-racecourse/history/\"},{\"type\":\"parent\",\"title\":\"Meet The Team\",\"slug\":\"/hereford-racecourse/meet-the-team/\"},{\"type\":\"parent\",\"title\":\"Careers\",\"slug\":\"/hereford-racecourse/careers/\"},{\"type\":\"parent\",\"title\":\"Hereford Racing Club\",\"slug\":\"/hereford-racecourse/hereford-racing-club/\"}]},{\"items\":[{\"type\":\"parent\",\"title\":\"Owners & Trainers\",\"slug\":\"/hereford-racecourse/owners-and-trainers/\"},{\"type\":\"parent\",\"title\":\"Annual Membership\",\"slug\":\"/hereford-racecourse/annual-membership/\"}]},{\"items\":[{\"type\":\"parent\",\"title\":\"Sponsorship\",\"slug\":\"/hereford-racecourse/sponsorship/\"},{\"type\":\"parent\",\"title\":\"Gift Vouchers\",\"slug\":\"/hereford-racecourse/gift-vouchers/\"}]}]},{\"title\":\"News\",\"menu\":\"news\",\"url\":\"/news/\"},{\"title\":\"Contact Us\",\"menu\":\"contact-us\",\"url\":\"/contact-us/\"}]}'
WHERE
        label = 'main_menu';

