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;