forked from mtusi2026/mtusi2026lab4
7 lines
247 B
SQL
7 lines
247 B
SQL
DROP TABLE IF EXISTS message_attachments;
|
|
DROP TABLE IF EXISTS attachments;
|
|
|
|
ALTER TABLE messages DROP CONSTRAINT IF EXISTS messages_text_len;
|
|
ALTER TABLE messages
|
|
ADD CONSTRAINT messages_text_len CHECK (char_length(text) BETWEEN 1 AND 4000);
|