LOCK TABLES `notification` WRITE, `site` 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, '2022-07-12', 'Due to essential maintenance work, online bookings will be not be available between 09.00 – 10.00. Apologies for any inconvenience.', '2022-07-13', 1);

UNLOCK TABLES;