

UPDATE
    site_global
SET
    data = '{
  "template": {
    "name": "dark",
    "whatson": true
  },
  "evergreenPages": [
    {
      "heading": "Popular Events",
      "items": [
        {
          "title": "Christmas Parties",
          "slug": "/your-venue/christmas-parties/"
        },
        {
          "title": "Ladies Day",
          "slug": "/popular-events/ladies-day/"
        }
      ]
    }
  ],
  "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 & Hummingbird Bar",
              "slug": "/restaurants-and-hospitality/grandstand-and-hummingbird-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": "Christmas Parties",
              "slug": "/your-venue/christmas-parties/"
            },
            {
              "type": "parent",
              "title": "Business Meetings",
              "slug": "/your-venue/business-meetings/"
            },
            {
              "type": "parent",
              "title": "Conferences & Events",
              "slug": "/your-venue/conferences-and-events/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Funerals & Wakes",
              "slug": "/your-venue/funerals-and-wakes/"
            },
            {
              "type": "parent",
              "title": "Weddings",
              "slug": "/your-venue/weddings/"
            },
            {
              "type": "parent",
              "title": "Parties & Celebrations",
              "slug": "/your-venue/parties-and-celebrations/"
            }
          ]
        },
        {
          "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';


UPDATE
    page
SET
    title = 'Grandstand & Hummingbird Bar | Hereford Racecourse',
    name = '/restaurants-and-hospitality/grandstand-and-hummingbird-bar/',
    description = 'Grandstand & Hummingbird Bar'
WHERE
    id = 22;


UPDATE
    page
SET
    title = 'Hummingbird Bar | Venue Hire Herefordshire | Hereford Racecourse',
    name = '/your-venue/hummingbird-bar/',
    description = 'Hummingbird Bar'
WHERE
        id = 41;


INSERT INTO `slug_history`
    (`id`, `slug`, `update_date`, `slug_type`)
VALUES
    (14, '/restaurants-and-hospitality/grandstand-and-paddock-bar/', NOW(), 2);


INSERT INTO `slug_history`
(`id`, `slug`, `update_date`, `slug_type`)
VALUES
(15, '/your-venue/paddock-bar/', NOW(), 2);


INSERT INTO `page_slug_history`
    (`slug_history_id`, `page_id`)
VALUES
   (14, 22);


INSERT INTO `page_slug_history`
(`slug_history_id`, `page_id`)
VALUES
(15, 41);


