Files
mtusi2026lab4/migrations/003_attachment_fields.sql

4 lines
253 B
SQL

ALTER TABLE attachments ADD COLUMN IF NOT EXISTS owner_id uuid REFERENCES users(id);
ALTER TABLE attachments ADD COLUMN IF NOT EXISTS updated_at timestamptz NOT NULL DEFAULT clock_timestamp();
ALTER TABLE attachments ALTER COLUMN owner_id SET NOT NULL;