Spaces:
Running
Running
File size: 308 Bytes
27127dd |
1 2 3 4 5 6 7 8 9 10 11 |
-- Add user_id column to conversations table
ALTER TABLE "conversations"
ADD COLUMN "user_id" integer;
-- Add foreign key constraint
ALTER TABLE "conversations"
ADD CONSTRAINT "conversations_user_id_users_id_fk"
FOREIGN KEY ("user_id")
REFERENCES "users"("id")
ON DELETE no action
ON UPDATE no action; |