
-- Add page navigation in main menu.

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/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Betting at Hereford",
              "slug": "/raceday-experience/betting-at-hereford/"
            },
            {
              "type": "parent",
              "title": "Venue Accessibility",
              "slug": "/raceday-experience/venue-accessibility/"
            }
          ]
        }
      ]
    },
    {
      "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 & Paddock Bar",
              "slug": "/restaurants-and-hospitality/grandstand-and-paddock-bar/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Private Boxes",
              "slug": "/restaurants-and-hospitality/private-boxes/"
            }
          ]
        }
      ]
    },
    {
      "title": "YourVENUE",
      "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": "Funerals & Wakes",
              "slug": "/your-venue/funerals-and-wakes/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Weddings",
              "slug": "/your-venue/weddings/"
            },
            {
              "type": "parent",
              "title": "Parties & Celebrations",
              "slug": "/your-venue/parties-and-celebrations/"
            },
            {
              "type": "parent",
              "title": "Christmas Parties",
              "slug": "/your-venue/christmas-parties/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "YourVENUE+",
              "slug": "/your-venue/your-venue-plus/"
            }
          ]
        }
      ]
    },
    {
      "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/"
            }
          ]
        },
        {
          "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/"
            }
          ]
        }
      ]
    },
    {
      "title": "News",
      "menu": "news",
      "url": "/news/"
    },
    {
      "title": "Contact Us",
      "menu": "contact-us",
      "url": "/contact-us/"
    }
  ]
}'
WHERE
  label = 'main_menu';



-- Add page data to page table.

INSERT INTO `page` (`id`, `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
	('', 7, NULL, 'Funerals & Wakes | Hereford Racecourse', '/your-venue/funerals-and-wakes/', 'Funerals & Wakes', '<?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=\"5bd5b0cd-dbb0-4c13-b5f3-ea51ece66ff9\" type=\"page-hero\"><![CDATA[{\"template_name\":\"page-hero\",\"data\":{\"items\":[{\"image\":{\"id\":0,\"filename\":\"\",\"show_placeholder\":true,\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}},\"title\":{\"text\":\"Funeral Receptions\",\"visible\":\"true\"},\"subtitle\":{\"text\":\"In a beautiful and tranquil environment.\",\"visible\":\"true\"},\"cta\":{\"label\":\"CTA Button\",\"url\":\"\\/\",\"target\":\"_self\",\"visible\":false}}]},\"block_type\":\"page-hero\"}]]></module><module key=\"9fdbb1e7-9757-45f9-a03b-13fe66604776\" type=\"standard-content\"><![CDATA[{\"template_name\":\"hlg-intro-txt100\",\"template_inverse\":false,\"data\":{\"title\":{\"text\":\"Funeral Receptions at Hereford Racecourse\",\"visible\":true},\"content\":{\"text\":\"At Hereford Racecourse, our dedicated team know what a difficult and emotional time arranging a funeral can be and we do all we can to ensure a peaceful and appropriate occasion which reflects your wishes. Our venue offers breathtaking views, wonderful scenery and superb facilities enabling you to gather together and reflect in a sympathetic environment.\",\"visible\":\"true\"},\"paragraph\":{\"text\":\"Paragraph\",\"visible\":\"true\"},\"cta\":{\"label\":\"CTA\",\"target\":\"_self\",\"url\":\"\\/\",\"visible\":false},\"image50sqr\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}},\"image50land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}},\"image100\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}},\"image100thn\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}},\"image25a\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}},\"image25b\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}},\"image25port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}}},\"block_type\":\"standard-content\"}]]></module><module key=\"cb64a951-09be-4a2c-8677-326807f616d8\" type=\"standard-content\"><![CDATA[{\"template_name\":\"hlg-txt50-img50_1sqr\",\"template_inverse\":false,\"data\":{\"title\":{\"text\":\"Title\",\"visible\":false},\"content\":{\"text\":\"Content\",\"visible\":\"true\"},\"paragraph\":{\"text\":\"<p>Funeral Receptions at Hereford Racecourse can be for any size from 10 \\u2013 100+ guests with catering requirements to suit your budget and style. Whether tea, coffee and cake to a light finger buffet at \\u00a320.99 or hot buffet at \\u00a330.99pp you can be assured of delicious food served by caring and compassionate staff. Our venue offers unlimited free parking, taking that hassle away altogether.<\\/p>\",\"visible\":\"true\"},\"cta\":{\"label\":\"CTA\",\"target\":\"_self\",\"url\":\"\\/\",\"visible\":false},\"image50sqr\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}},\"image50land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}},\"image100\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}},\"image100thn\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}},\"image25a\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}},\"image25b\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}},\"image25port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}}},\"block_type\":\"standard-content\"}]]></module><module key=\"fcccc523-6666-40f5-8a46-fe48ea92b718\" type=\"standard-content\"><![CDATA[{\"template_name\":\"hlg-img50_1sqr-txt50\",\"template_inverse\":false,\"data\":{\"title\":{\"text\":\"Title\",\"visible\":false},\"content\":{\"text\":\"Content\",\"visible\":\"true\"},\"paragraph\":{\"text\":\"<p>Please contact us for further information and let us take the stress away from organising a Funeral Reception.<\\/p><p>Email: <a href=\\\"mailto:info@hereford-racecourse.co.uk\\\"><strong><u>info@hereford-racecourse.co.uk<\\/u><\\/strong><\\/a><br>Phone: <a href=\\\"tel:441432 273560\\\"><strong><u>01432 273560<\\/u><\\/strong><\\/a><\\/p>\",\"visible\":\"true\"},\"cta\":{\"label\":\"CTA\",\"target\":\"_self\",\"url\":\"\\/\",\"visible\":false},\"image50sqr\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}},\"image50land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}},\"image100\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}},\"image100thn\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}},\"image25a\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}},\"image25b\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}},\"image25port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\",\"tablet_land\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"tablet_port\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"},\"mobile\":{\"id\":0,\"filename\":\"\",\"alt\":\"\"}}},\"block_type\":\"standard-content\"}]]></module><module key=\"3027fad1-5962-44bc-8d71-dc63243abae1\" type=\"key-facts\"><![CDATA[\n{\n  \"template_name\": \"key-facts-center\",\n  \"template_inverse\": false,\n  \"data\": {\n    \"title\": {\n      \"text\": \"Title\",\n      \"visible\": false\n    },\n    \"content\": {\n      \"text\": \"Content\",\n      \"visible\": false\n    },\n    \"items\": [\n      {\n        \"icon\": {\n          \"name\": \"icon-15-racecourses\",\n          \"visible\": false\n        },\n        \"title\": {\n          \"text\": \"title\",\n          \"visible\": false\n        },\n        \"content\": {\n          \"text\": \"Make an Enquiry\",\n          \"visible\": true\n        },\n        \"cta\": {\n          \"label\": \"Contact Us\",\n          \"url\": \"\\/contact-us\\/\",\n          \"target\": \"_self\",\n          \"visible\": true\n        }\n      }\n    ]\n  },\n  \"block_type\": \"key-facts\"\n}]]></module><module key=\"fe4b3467-60c3-48fe-8469-22d6e2b4c9e0\" type=\"form\">\n        {\n        \"template_name\": \"eventmaster-form-pre-newsletter\"\n        }\n    </module></content>\n', 0, 0, 0, 0.9, 'yearly', NULL, 0, 1);


