7 lines
367 B
SQL
7 lines
367 B
SQL
-- Drop any platform-generated rows before re-tightening the CHECK so the
|
|
-- ADD CONSTRAINT does not fail on existing system comments.
|
|
DELETE FROM comment WHERE author_type = 'system';
|
|
ALTER TABLE comment DROP CONSTRAINT IF EXISTS comment_author_type_check;
|
|
ALTER TABLE comment ADD CONSTRAINT comment_author_type_check
|
|
CHECK (author_type IN ('member', 'agent'));
|