ente/server/migrations/73_remove_kex_user_id_fk.down.sql
2024-03-01 13:37:01 +05:30

5 lines
187 B
SQL

ALTER TABLE kex_store ADD COLUMN user_id BIGINT NOT NULL;
ALTER TABLE kex_store
ADD
CONSTRAINT fk_kex_store_user_id FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE;