
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
	(32, 7, NULL, 'Where to Stay', '/plan-your-visit/where-to-stay/', 'Where to Stay', '<?xml version=\"1.0\" encoding=\"utf8\"?>\n<!DOCTYPE content [\n        <!ELEMENT content (module)*>\n        <!ELEMENT module (#PCDATA)>\n        <!ATTLIST module key CDATA #REQUIRED>\n        <!ATTLIST module type CDATA #REQUIRED>\n        ]>\n<content>\n    <module key=\"eae2d225-4517-433a-9603-085b6c3ccd88\" type=\"hero\">\n        {\n        \"template_name\": \"template-main\",\n        \"data\": {\n        \"hero\": {\n        \"id\": \"\",\n        \"filename\": \"\"\n        }\n        }\n        }\n    </module>\n    <module key=\"cf7974b0-c2cb-4f9f-8dfc-da357475428f\" type=\"meta-data\">\n        {\n        \"template_name\":\"meta-data\",\n        \"data\":{\n        \"meta_data\":{\n        \"description\":\"Description text.\",\n        \"keywords\":\"keywords, separated, with, commas\"\n        }\n        }\n        }\n    </module>\n    <module key=\"b2e92f7b-19f1-4fa3-b342-f42b70511d37\" type=\"paragraph\">\n        {\n        \"template_name\": \"paragraph-img-50-left\",\n        \"data\": {\n        \"paragraph\": {\n        \"text\": \"Paragraph Text\"\n        },\n        \"image50\": {\n        \"id\": \"\",\n        \"filename\": \"\"\n        },\n        \"cta\": {\n        \"label\": \"CTA Button\",\n        \"target\": \"_self\",\n        \"url\": \"/\"\n        }\n        }\n        }\n    </module>\n    <module key=\"03a64a7f-20d2-42db-bbbb-463f22a337b2\" type=\"paragraph\">\n        {\n        \"template_name\": \"paragraph-img-50-right\",\n        \"data\": {\n        \"paragraph\": {\n        \"text\": \"Paragraph Text\"\n        },\n        \"image50\": {\n        \"id\": \"\",\n        \"filename\": \"\"\n        },\n        \"cta\": {\n        \"label\": \"CTA Button\",\n        \"target\": \"_self\",\n        \"url\": \"/\"\n        }\n        }\n        }\n    </module>\n    <module key=\"38d830ac-9f2d-4184-8081-ac5af12ccf92\" type=\"form\">\n        {\n        \"template_name\":\"newsletter\"\n        }\n    </module>\n</content>\n', 6, 12, 13, 0.9, 'yearly', NULL, 0, 1);

UPDATE
  site_global
SET
  data = '
{
  "template": {
    "name": "light"
  },
  "menus": [
    {
      "title": "Plan Your Visit",
      "menu": "plan-your-visit",
      "slug": "/plan-your-visit/",
      "columns": [
        {
          "items": [
            {
              "type": "parent",
              "title": "Plan Your Visit",
              "slug": "/plan-your-visit/"
            },
            {
              "type": "parent",
              "title": "Get Here",
              "slug": "/plan-your-visit/get-here/"
            },
            {
              "type": "parent",
              "title": "Tickets & Admission",
              "slug": "/plan-your-visit/tickets-and-admission/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Venue Etiquette",
              "slug": "/plan-your-visit/venue-etiquette/"
            },
            {
              "type": "parent",
              "title": "Racecourse Facilities",
              "slug": "/plan-your-visit/racecourse-facilities/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Beginners Guide",
              "slug": "/plan-your-visit/beginners-guide/"
            },
            {
              "type": "parent",
              "title": "Rewards4Racing",
              "slug": "/plan-your-visit/rewards4racing/"
            },
            {
              "type": "parent",
              "title": "Where to Stay",
              "slug": "/plan-your-visit/where-to-stay/"
            }
          ]
        }
      ]
    },
    {
      "title": "Restaurants & Hospitality",
      "menu": "hospitality",
      "slug": "/restaurants-and-hospitality/",
      "columns": [
        {
          "items": [
            {
              "type": "parent",
              "title": "Restaurants & Hospitality",
              "slug": "/restaurants-and-hospitality/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Private Boxes",
              "slug": "/restaurants-and-hospitality/private-boxes/"
            }
          ]
        }
      ]
    },
    {
      "title": "Hire Our Venue",
      "menu": "hire-our-venue",
      "slug": "/hire-our-venue/",
      "columns": [
        {
          "items": [
            {
              "type": "parent",
              "title": "Hire Our Venue",
              "slug": "/hire-our-venue/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Meetings & Events",
              "slug": "/hire-our-venue/meetings-and-events/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Weddings",
              "slug": "/hire-our-venue/weddings/"
            }
          ]
        }
      ]
    },
    {
      "title": "Our Racecourse",
      "menu": "our-racecourse",
      "slug": "/our-racecourse/",
      "columns": [
        {
          "items": [
            {
              "type": "parent",
              "title": "Our Racecourse",
              "slug": "/our-racecourse/"
            },
            {
              "type": "parent",
              "title": "Annual Membership",
              "slug": "/our-racecourse/annual-membership/"
            },
            {
              "type": "parent",
              "title": "Join Our Team",
              "slug": "/our-racecourse/join-our-team/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Owners & Trainers",
              "slug": "/our-racecourse/owners-and-trainers/"
            },
            {
              "type": "parent",
              "title": "Equine Welfare",
              "slug": "/our-racecourse/equine-welfare/"
            },
            {
              "type": "parent",
              "title": "Commercial Opportunities",
              "slug": "/our-racecourse/commercial-opportunities/"
            }
          ]
        },
        {
          "items": []
        }
      ]
    },
    {
      "title": "News",
      "menu": "news",
      "url": "/news/"
    },
    {
      "title": "Contact Us",
      "menu": "contact-us",
      "url": "/contact-us/"
    }
  ]
}'
WHERE
  label = 'main_menu';

