fixup! chore: update v1 schema

coadler · coadler · commit 0f51d90e2e64 · 2022-03-30T17:30:42.000-05:00
diff --git a/coderd/database/migrations/000001_base.down.sql b/coderd/database/migrations/000001_base.down.sql
@@ -5,6 +5,7 @@ DROP TRIGGER trig_uuid_to_longid_users ON users;
 DROP TRIGGER trig_uuid_to_longid_organizations ON organizations;
 DROP TRIGGER trig_uuid_to_longid_organization_members_user_id ON organization_members;
 DROP TRIGGER trig_uuid_to_longid_organization_members_org_id ON organization_members;
+DROP TRIGGER trig_uuid_to_longid_api_keys_user_id ON api_keys;
 
 DROP FUNCTION org_uuid_to_longid_trigger;
 DROP FUNCTION user_uuid_to_longid_trigger;
diff --git a/coderd/database/migrations/000001_base.up.sql b/coderd/database/migrations/000001_base.up.sql
@@ -229,6 +229,13 @@ EXCEPTION
     WHEN duplicate_object THEN null;
 END $$;
 
+CREATE TRIGGER
+    trig_uuid_to_longid_api_keys_user_id
+BEFORE INSERT ON
+    api_keys
+FOR EACH ROW EXECUTE PROCEDURE
+    user_uuid_to_longid_trigger();
+
 CREATE TABLE IF NOT EXISTS licenses (
 	id serial,
 	license jsonb NOT NULL,
