Allow null on prefix after downgrade

code-asher · code-asher · commit da447c2aeeda · 2024-02-20T14:21:40.000-09:00
Without this I think the tests would fail since they are not adding a
prefix and there is no default.
diff --git a/coderd/database/migrations/000195_oauth2_provider_codes.down.sql b/coderd/database/migrations/000195_oauth2_provider_codes.down.sql
@@ -14,4 +14,5 @@ DROP TABLE oauth2_provider_app_codes;
 -- so users will not be able to create broken secrets.  This is really just to
 -- make sure tests keep working (say for a bisect).
 ALTER TABLE ONLY oauth2_provider_app_secrets
-    DROP CONSTRAINT oauth2_provider_app_secrets_secret_prefix_key;
+    DROP CONSTRAINT oauth2_provider_app_secrets_secret_prefix_key,
+    ALTER COLUMN secret_prefix SET NULL;
