api.spaceplanner.app

commit af0d10c7f25199b95807f7f12cc4c2b48a1b552f
parent 6964d963332ee36036db3844329008ab2b6ca94f
Author: Jacob R. Edwards <jacob@jacobedwards.org>
Date:   Wed, 25 Sep 2024 18:34:05 -0700

Add foreign key constraint to user_settings username

Diffstat:
A
cmd/api/migration/2024-09-26T01:29:10.sql
 | 
7
+++++++

1 file changed, 7 insertions(+), 0 deletions(-)
diff --git a/cmd/api/migration/2024-09-26T01:29:10.sql b/cmd/api/migration/2024-09-26T01:29:10.sql
@@ -0,0 +1,7 @@
+BEGIN;
+
+DELETE FROM spaceplanner.user_settings WHERE username NOT IN (SELECT name from spaceplanner.users);
+ALTER TABLE spaceplanner.user_settings ADD FOREIGN KEY (username) REFERENCES spaceplanner.users(name)
+	ON DELETE CASCADE;
+
+COMMIT;