
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": "New Racegoers Guide",
              "slug": "/plan-your-visit/new-racegoers-guide/"
            },
            {
              "type": "parent",
              "title": "Get Here",
              "slug": "/plan-your-visit/get-here/"
            },
            {
              "type": "parent",
              "title": "Tickets & Packages",
              "slug": "/plan-your-visit/tickets-and-packages/"
            },
            {
              "type": "parent",
              "title": "Rewards4Racing",
              "slug": "/plan-your-visit/rewards4racing/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Food & Drink",
              "slug": "/plan-your-visit/food-and-drink/"
            },
            {
              "type": "parent",
              "title": "Venue Etiquette",
              "slug": "/plan-your-visit/venue-etiquette/"
            },
            {
              "type": "parent",
              "title": "Venue Accessibility ",
              "slug": "/plan-your-visit/venue-accessibility/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Racecourse Map",
              "slug": "/plan-your-visit/racecourse-map/"
            },
            {
              "type": "parent",
              "title": "Where To Stay",
              "slug": "/plan-your-visit/where-to-stay/"
            },
     	    {
              "type": "parent",
              "title": "Around Bath",
              "slug": "/plan-your-visit/around-bath/"
            }
          ]
        }
      ]
    },
    {
      "title": "Restaurants </br>& Hospitality",
      "menu": "hospitality",
      "slug": "/restaurants-and-hospitality/",
      "columns": [
        {
          "items": [
            {
              "type": "parent",
              "title": "Restaurants & Hospitality",
              "slug": "/restaurants-and-hospitality/"
            }

          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Raceday Hospitality",
              "slug": "/restaurants-and-hospitality/raceday-hospitality/"
            }

          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Executive Suites",
              "slug": "/restaurants-and-hospitality/executive-suites/"
            }

          ]
        }
      ]
    },
    {
      "title": "Hire Our Venue",
      "menu": "hire-our-venue",
      "slug": "/hire-our-venue/",
      "columns": [
        {
          "items": [
            {
              "type": "parent",
              "title": "Hire Our Venue",
              "slug": "/hire-our-venue/"
            },
            {
              "type": "parent",
              "title": "Hire For Business",
              "slug": "/hire-our-venue/hire-for-business/"
            },
            {
              "type": "child",
              "title": "Conferences & Meetings",
              "slug": "/hire-our-venue/hire-for-business/conferences-and-meetings/"
            },
            {
              "type": "child",
              "title": "Exhibitions & Fairs",
              "slug": "/hire-our-venue/hire-for-business/exhibitions-and-fairs/"
            },
            {
              "type": "child",
              "title": "Seminars & Training Sessions",
              "slug": "/hire-our-venue/hire-for-business/seminars-and-training-sessions/"
            },
            {
              "type": "child",
              "title": "Banquets & Awards",
              "slug": "/hire-our-venue/hire-for-business/banquets-and-awards/"
            }

          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Hire For Celebration",
              "slug": "/hire-our-venue/hire-for-celebration/"
            },
            {
              "type": "child",
              "title": "Weddings",
              "slug": "/hire-our-venue/hire-for-celebration/weddings/"
            },
            {
              "type": "child",
              "title": "Wedding Packages & Prices",
              "slug": "/hire-our-venue/hire-for-celebration/wedding-packages-and-prices/"
            },
            {
              "type": "child",
              "title": "Christmas Parties",
              "slug": "/hire-our-venue/hire-for-celebration/christmas-parties/"
            },
            {
              "type": "child",
              "title": "Parties & Dinners",
              "slug": "/hire-our-venue/hire-for-celebration/parties-and-dinners/"
            },
            {
              "type": "child",
              "title": "Celebration of Life",
              "slug": "/hire-our-venue/hire-for-celebration/celebration-of-life/"
            }

          ]
        },
        {
          "items": [
        {
              "type": "parent",
              "title": "Outdoor Events",
              "slug": "/hire-our-venue/outdoor-events/"
            }

          ]
        }

      ]
    },
    {
      "title": "Our Racecourse",
      "menu": "our-racecourse",
      "slug": "/our-racecourse/",
      "columns": [
        {
          "items": [
            {
              "type": "parent",
              "title": "Our Racecourse",
              "slug": "/our-racecourse/"
            },
            {
              "type": "parent",
              "title": "About Us",
              "slug": "/our-racecourse/about-us/"
            },
             {
              "type": "parent",
              "title": "Annual Membership",
              "slug": "/our-racecourse/annual-membership/"
            },
             {
              "type": "parent",
              "title": "Lansdown Live",
              "slug": "/our-racecourse/lansdown-live/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Competitions",
              "slug": "/our-racecourse/competitions/"
            },
	   {
              "type": "parent",
              "title": "Sponsorship & Advertising",
              "slug": "/our-racecourse/sponsorship-and-advertising/"
            },
            {
              "type": "parent",
              "title": "Official Partners",
              "slug": "/our-racecourse/official-partners/"
            },
            {
              "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": "The Roof Garden",
              "slug": "/our-racecourse/the-roof-garden/"
            }
          ]
        }
      ]
    },
    {
      "title": "News",
      "menu": "news",
      "url": "/news/"
    },
    {
      "title": "Contact Us",
      "menu": "contact-us",
      "url": "/contact-us/"
    }
  ]
}'
WHERE
  label = 'main_menu';



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
	(13, NULL, 'The Roof Garden | Bath Racecourse', '/our-racecourse/the-roof-garden/', 'The Roof Garden', '<?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=\"ad73cb5d-81ed-444f-99cb-bf60b93ce4b0\" 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=\"0c4c75c6-323c-4fd5-a065-b5da3e23475f\" type=\"hero\">\n        {\n        \"template_name\": \"template-main\",\n        \"data\": {\n        \"hero\": {\n        \"id\": \"\",\n        \"filename\": \"\"\n        }\n        }\n        }\n    </module>\n    <module key=\"b10da166-06eb-4bcc-abfc-691aa3671b7d\" type=\"paragraph\">\n        {\n        \"template_name\": \"paragraph-img-50-left\",\n        \"data\": {\n        \"paragraph\": {\n        \"text\": \"The Roof Garden is the perfect al fresco experience, located on the top floor of the Langridge Stand with spectacular views overlooking the racecourse and surrounding Bath countryside.\"\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=\"9171f300-777b-4ddc-8b92-da8eebfd3ce8\" type=\"paragraph\">\n        {\n        \"template_name\": \"paragraph-img-50-right\",\n        \"data\": {\n        \"paragraph\": {\n        \"text\": \"The Roof Garden has its own fully serviced bar and betting facilities. Freshly prepared food is served up by the house chef from an open grill, offering a range of hot sandwiches and gourmet burgers.\"\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=\"a71597d1-1c6a-4cb8-8704-cc3511674d59\" type=\"paragraph\">\n        {\n        \"template_name\": \"paragraph-img-50-left\",\n        \"data\": {\n        \"paragraph\": {\n        \"text\": \"The Roof Garden has its own fully serviced bar and betting facilities. Freshly prepared food is served up by the house chef from an open grill, offering a range of hot sandwiches and gourmet burgers.\"\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=\"e3febff1-8aa8-4bce-a3b1-bc458e810bc7\" type=\"call-to-action\">\n        {\n        \"template_name\": \"call-to-action\",\n        \"data\": {\n        \"items\": [\n        {\n        \"desc\": {\n        \"text\": \"See our fill list of live events, and their available tickets and packages here.\"\n        },\n        \"cta\": {\n        \"label\": \"What\'s On\",\n        \"url\": \"/\",\n        \"target\": \"_self\"\n        }\n        }\n        ]\n        }\n        }\n    </module>\n    <module key=\"37cf313d-76b5-4f8e-9b50-c7d48fcb602b\" type=\"form\">\n        {\n        \"template_name\":\"newsletter\"\n        }\n    </module>\n</content>', 13, 45, 46, 0, '', NULL, 0, 1);



UPDATE
  page
SET
  next_page_id = 51
WHERE
  name = '/our-racecourse/equine-welfare/';


UPDATE
  page
SET
  previous_page_id = 51
WHERE
  name = '/news/';



