

UPDATE
    site_global
SET
    data = '{
  "template": {
    "name": "dark",
    "whatson": true
  },
  "evergreenPages": [
    {
      "heading": "Racing Highlights",
      "items": [
        {
          "title": "St Leger Festival",
          "slug": "/racing-highlights/st-leger-festival/"
        },
        {
          "title": "November Handicap",
          "slug": "/racing-highlights/november-handicap/"
        },
        {
          "title": "Sky Bet Chase",
          "slug": "/racing-highlights/sky-bet-chase/"
        },
        {
          "title": "Grimthorpe Chase",
          "slug": "/racing-highlights/grimthorpe-chase/"
        },
        {
          "title": "UNIBET Lincoln",
          "slug": "/racing-highlights/unibet-lincoln/"
        },
        {
          "title": "Vertem Futurity Trophy",
          "slug": "/racing-highlights/vertem-futurity-trophy/"
        }
      ]
    },
    {
      "heading": "Popular Events",
      "items": [
        {
          "title": "Live Music",
          "slug": "/popular-events/live-music/"
        },
        {
          "title": "Family Fun Days",
          "slug": "/popular-events/family-fun-days/"
        },
        {
          "title": "Ladies Day",
          "slug": "/popular-events/ladies-day/"
        },
        {
          "title": "Gentlemens Day",
          "slug": "/popular-events/gentlemens-day/"
        },
        {
          "title": "Fireworks",
          "slug": "/popular-events/fireworks/"
        },
        {
          "title": "Christmas Live",
          "slug": "/your-venue/christmas-live/"
        },
        {
          "title": "New Years Eve",
          "slug": "/popular-events/new-years-eve/"
        }
      ]
    }
  ],
  "menus" : [
    {
      "title": "Visitor <br/>Experience",
      "menu": "visitor-experience",
      "columns": [
        {
          "title":{
            "text": "Visitor Experience",
            "slug": "/visitor-experience/"
          },
          "items": [
            {
              "type": "parent",
              "title": "Get Here",
              "slug": "/visitor-experience/get-here/"
            },
            {
              "type": "parent",
              "title": "Dress Code",
              "slug": "/visitor-experience/dress-code/"
            },
            {
              "type": "parent",
              "title": "Venue Accessibility",
              "slug": "/visitor-experience/venue-accessibility/"
            }

          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Racecourse Map",
              "slug": "/visitor-experience/racecourse-map/"
            },
            {
              "type": "parent",
              "title": "Betting at Doncaster",
              "slug": "/visitor-experience/betting-at-doncaster/"
            },
            {
              "type": "parent",
              "title": "Where To Stay",
              "slug": "/visitor-experience/where-to-stay/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Destination Doncaster",
              "slug": "/visitor-experience/destination-doncaster/"
            },
            {
              "type": "parent",
              "title": "Virtual Tours",
              "slug": "/visitor-experience/virtual-tours/"
            },
            {
              "type": "parent",
              "title": "Food & Drink",
              "slug": "/visitor-experience/food-and-drink/"
            }
          ]
        },
        {
          "items": [

          ]
        }

      ]
    },
    {
      "title": "Restaurants & <br/>Hospitality",
      "menu": "restaurants-and-hospitality",
      "columns": [
        {
          "title":{
            "text": "Restaurants & Hospitality",
            "slug": "/restaurants-and-hospitality/"
          },
          "items": [
            {
              "type": "parent",
              "title": "The Home Straight Restaurant",
              "slug": "/restaurants-and-hospitality/the-home-straight-restaurant/"
            },
            {
              "type": "parent",
              "title": "The Conduit Restaurant",
              "slug": "/restaurants-and-hospitality/the-conduit-restaurant/"
            },
            {
              "type": "parent",
              "title": "The Garden Grille",
              "slug": "/restaurants-and-hospitality/the-garden-grille/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Private Boxes",
              "slug": "/restaurants-and-hospitality/private-boxes/"
            },
            {
              "type": "parent",
              "title": "The Old Weighing Room Restaurant",
              "slug": "/restaurants-and-hospitality/the-old-weighing-room-restaurant/"
            },
            {
              "type": "parent",
              "title": "St Leger Hospitality",
              "slug": "/restaurants-and-hospitality/st-leger-hospitality/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Food Court",
              "slug": "/restaurants-and-hospitality/food-court/"
            }
          ]
        }
      ]
    },
    {
      "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": "YourVENUE+",
              "slug": "/your-venue/your-venue-plus/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Weddings",
              "slug": "/your-venue/weddings/"
            },
            {
              "type": "parent",
              "title": "Parties & Celebrations",
              "slug": "/your-venue/parties-and-celebrations/"
            },
            {
              "type": "parent",
              "title": "Christmas Live",
              "slug": "/your-venue/christmas-live/"
            }
          ]
        }
      ]
    },
    {
      "title": "Doncaster <br/>Racecourse",
      "menu": "doncaster-racecourse",
      "columns": [
        {
          "title":{
            "text": "Doncaster Racecourse",
            "slug": "/doncaster-racecourse/"
          },
          "items": [
            {
              "type": "parent",
              "title": "About Us",
              "slug": "/doncaster-racecourse/about-us/"
            },
            {
              "type": "parent",
              "title": "St Leger History",
              "slug": "/doncaster-racecourse/st-leger-history/"
            },
            {
              "type": "parent",
              "title": "Annual Membership",
              "slug": "/doncaster-racecourse/annual-membership/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Meet The Team",
              "slug": "/doncaster-racecourse/meet-the-team/"
            },
            {
              "type": "parent",
              "title": "Gift Vouchers",
              "slug": "/doncaster-racecourse/gift-vouchers/"
            },
            {
              "type": "parent",
              "title": "Careers",
              "slug": "/doncaster-racecourse/careers/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Sponsorship & Advertising",
              "slug": "/doncaster-racecourse/sponsorship-and-advertising/"
            },
            {
              "type": "parent",
              "title": "Owners & Trainers",
              "slug": "/doncaster-racecourse/owners-and-trainers/"
            },
            {
              "type": "parent",
              "title": "FAQs",
              "slug": "/doncaster-racecourse/faqs/"
            }
          ]
        }
      ]
    },
    {
      "title": "Hilton Garden <br/>Inn",
      "menu": "hilton-garden-inn",
      "columns": [
        {
          "title":{
            "text": "Hilton Garden Inn",
            "slug": "/hilton-garden-inn/"
          },
          "items": [
            {
              "type": "parent",
              "title": "The Old Weighing Room",
              "slug": "/restaurants-and-hospitality/the-old-weighing-room-restaurant/"
            },
            {
              "type": "parent",
              "title": "The Garden Grille",
              "slug": "/restaurants-and-hospitality/the-garden-grille/"
            }

          ]
        },
        {
          "items": [

          ]
        },
        {
          "items": [

          ]
        }
      ]
    },
    {
      "title": "News",
      "menu": "news",
      "url": "/news/"
    }
  ]
}'
WHERE
    label = 'main_menu';



UPDATE
    page
SET
    name = '/restaurants-and-hospitality/the-home-straight-restaurant/',
    description = 'The Home Straight Restaurant'
WHERE
    id = 20;



INSERT INTO `slug_history` (`id`, `slug`, `update_date`, `slug_type`)
VALUES
(56, '/restaurants-and-hospitality/the-mallard-restaurant/', '2020-01-06 09:17:00', 2);



INSERT INTO `page_slug_history` (`slug_history_id`, `page_id`)
VALUES
(56, 20);




