foreign key

aslilac · aslilac · commit 1c6f7fee3fc8 · 2025-02-14T19:05:53.000Z
diff --git a/coderd/database/migrations/000293_user_configs.up.sql b/coderd/database/migrations/000293_user_configs.up.sql
@@ -1,7 +1,10 @@
 CREATE TABLE IF NOT EXISTS user_configs (
-		user_id uuid NOT NULL,
-		key varchar(256) NOT NULL,
-		value text NOT NULL
+	user_id uuid NOT NULL,
+	key varchar(256) NOT NULL,
+	value text NOT NULL,
+
+	PRIMARY KEY (user_id, key),
+	FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE
 );
 
 ALTER TABLE ONLY user_configs
