Files
mtusi2026lab4/migrations/005_attachment_owner.sql

3 lines
174 B
SQL

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