api.spaceplanner.app

Spaceplanner API
git clone git://jacobedwards.org/api.spaceplanner.app
Log | Files | Refs

2024-09-26T01:29:10.sql (239B)

      1 BEGIN;
      2 
      3 DELETE FROM spaceplanner.user_settings WHERE username NOT IN (SELECT name from spaceplanner.users);
      4 ALTER TABLE spaceplanner.user_settings ADD FOREIGN KEY (username) REFERENCES spaceplanner.users(name)
      5 	ON DELETE CASCADE;
      6 
      7 COMMIT;