Files
mtusi2026lab4/migrations/004_message_attachments.sql
2026-10-28 22:41:10 +03:00

14 lines
613 B
SQL

-- +goose Up
ALTER TABLE messages
DROP CONSTRAINT IF EXISTS messages_text_check,
ADD CONSTRAINT messages_text_check CHECK (char_length(text) BETWEEN 0 AND 4000),
ADD COLUMN IF NOT EXISTS attachment_ids uuid[] NOT NULL DEFAULT '{}';
-- +goose Down
-- Attachment-only messages cannot exist in lab3; retain an explicit placeholder when downgrading.
UPDATE messages SET text='[attachment]' WHERE text='';
ALTER TABLE messages
DROP COLUMN IF EXISTS attachment_ids,
DROP CONSTRAINT IF EXISTS messages_text_check,
ADD CONSTRAINT messages_text_check CHECK (char_length(text) BETWEEN 1 AND 4000);