
# Update menu item in mega menu
UPDATE
    site_global
SET
    data = '{
  "template": {
    "name": "dark",
    "whatson": true
  },
  "evergreenPages": [
    {
      "heading": "Racing Highlights",
      "items": [
        {
          "title": "Good Friday Raceday",
          "slug": "/racing-highlights/good-friday-raceday/"
        }
      ]
    },
    {
      "heading": "Popular Events",
      "items": [
        {
          "title": "Live Music",
          "slug": "/popular-events/live-music/"
        },
        {
          "title": "Ladies Day",
          "slug": "/popular-events/ladies-day/"
        },
        {
          "title": "Fireworks",
          "slug": "/popular-events/fireworks/"
        },
        {
          "title": "Family Fun Days",
          "slug": "/popular-events/family-fun-days/"
        },
        {
          "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 & Packages",
              "slug": "/raceday-experience/tickets-and-packages/"
            },
            {
              "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": "Racecourse Map",
              "slug": "/raceday-experience/racecourse-map/"
            },
            {
              "type": "parent",
              "title": "Where To Stay",
              "slug": "/raceday-experience/where-to-stay/"
            }

          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Around Bath",
              "slug": "/raceday-experience/around-bath/"
            },
            {
              "type": "parent",
              "title": "Betting at Bath",
              "slug": "/raceday-experience/betting-at-bath/"
            },
            {
              "type": "parent",
              "title": "Venue Accessibility",
              "slug": "/raceday-experience/venue-accessibility/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "FAQ''s",
              "slug": "/faqs/"
            }
          ]
        }
      ]
    },
    {
      "title": "Restaurants & <br/>Hospitality",
      "menu": "restaurants-and-hospitality",
      "columns": [
        {
          "title":{
            "text": "Restaurants & Hospitality",
            "slug": "/restaurants-and-hospitality/"
          },
          "items": [
            {
              "type": "parent",
              "title": "Corporate Hospitality",
              "slug": "/restaurants-and-hospitality/corporate-hospitality/"
            },
            {
              "type": "parent",
              "title": "Groups and Private Parties",
              "slug": "/restaurants-and-hospitality/groups-and-private-parties/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Staff Events",
              "slug": "/restaurants-and-hospitality/staff-events/"
            },
            {
              "type": "parent",
              "title": "Fine Dining",
              "slug": "/restaurants-and-hospitality/royal-crescent-restaurant/"
            }
          ]
        }
      ]
    },
    {
      "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 Parties",
              "slug": "/your-venue/christmas-parties/"
            }
          ]
        }
      ]
    },
    {
      "title": "Bath <br/>Racecourse",
      "menu": "bath-racecourse",
      "columns": [
        {
          "title":{
            "text": "Bath Racecourse",
            "slug": "/bath-racecourse/"
          },
          "items": [
            {
              "type": "parent",
              "title": "About Us",
              "slug": "/bath-racecourse/about-us/"
            },
            {
              "type": "parent",
              "title": "Meet The Team",
              "slug": "/bath-racecourse/meet-the-team/"
            },
            {
              "type": "parent",
              "title": "Careers",
              "slug": "/bath-racecourse/careers/"
            },
            {
              "type": "parent",
              "title": "Special Offers",
              "slug": "/bath-racecourse/special-offers/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Sponsorship and Partnerships",
              "slug": "/bath-racecourse/sponsorship-and-partnership-opportunities/"
            },
            {
              "type": "parent",
              "title": "Owners & Trainers",
              "slug": "/bath-racecourse/owners-and-trainers/"
            },
            {
              "type": "parent",
              "title": "Annual Membership",
              "slug": "/bath-racecourse/annual-membership/"
            }
          ]
        },
        {
          "items": [
            {
              "type": "parent",
              "title": "Hub XV Coworking Space",
              "slug": "/bath-racecourse/hub-xv-coworking-space/"
            },
            {
              "type": "parent",
              "title": "Competitions",
              "slug": "/bath-racecourse/competitions/"
            },
            {
              "type": "parent",
              "title": "Gift Vouchers",
              "slug": "/bath-racecourse/gift-vouchers/"
            }

          ]
        }
      ]
    },
    {
      "title": "News",
      "menu": "news",
      "url": "/news/"
    },
    {
      "title": "Contact Us",
      "menu": "contact-us",
      "url": "/contact-us/"
    }
  ]
}'
WHERE
    label = 'main_menu';

# Update the route in the page table
UPDATE page
SET name = '/bath-racecourse/special-offers/'
WHERE name = '/restaurants-and-hospitality/special-offers/';

# Update Paddock Pavilion page name
UPDATE page
SET title = 'Paddock Pavilion'
WHERE name = '/restaurants-and-hospitality/paddock-pavilion/';

