2024-06-10 10:24:23 +00:00
|
|
|
-- Place your SQL code here
|
|
|
|
|
ALTER TABLE vn.mrwConfig ADD IF NOT EXISTS notified TIMESTAMP NULL
|
|
|
|
|
COMMENT 'Date when it was notified that the web service deadline was exceeded';
|
2024-06-14 15:40:08 +00:00
|
|
|
|
|
|
|
|
INSERT IGNORE INTO util.notification
|
|
|
|
|
SET name = 'mrw-deadline',
|
|
|
|
|
description = 'The MRW deadline has passed';
|
|
|
|
|
|
|
|
|
|
INSERT IGNORE INTO util.notificationAcl (notificationFk, roleFK)
|
|
|
|
|
SELECT LAST_INSERT_ID(), r.id
|
|
|
|
|
FROM account.role r
|
|
|
|
|
WHERE r.name = 'delivery'
|
