taskcafe/migrations/0072_remove-not-null-from-notification-caused_by.up.sql
2021-11-17 17:11:28 -06:00

3 lines
164 B
SQL

ALTER TABLE notification ALTER COLUMN caused_by DROP NOT NULL;
UPDATE notification SET caused_by = null WHERE caused_by = '00000000-0000-0000-0000-000000000000';