LOCK TABLES site WRITE, notification WRITE;

SELECT id INTO @siteId FROM site limit 1;

INSERT INTO `notification` (`site_id`, `user_id`, `message_added`, `message`, `expiry_date`, `active`)
VALUES
(@siteId, 1, '2021-07-29', '{\n      \"notification_type\": \"notice\",\n	\"notification_heading\": \"Advance Notice of Maintenance – Sunday 1st August 2021\",\n      \"notification_content\": \"Our online ticketing service will be unavailable for six hours from midnight to 6:00am Sunday 1st August. <br/>We apologise for any inconvenience this may cause.\"\n    }', '2021-08-02', 1);

UNLOCK TABLES