mirror of
https://github.com/coder/coder.git
synced 2025-07-03 16:13:58 +00:00
19 lines
488 B
SQL
19 lines
488 B
SQL
-- Step 1: Remove the new entries from crypto_keys table
|
|
DELETE FROM crypto_keys
|
|
WHERE feature IN ('workspace_apps_token', 'workspace_apps_api_key');
|
|
|
|
CREATE TYPE old_crypto_key_feature AS ENUM (
|
|
'workspace_apps',
|
|
'oidc_convert',
|
|
'tailnet_resume'
|
|
);
|
|
|
|
ALTER TABLE crypto_keys
|
|
ALTER COLUMN feature TYPE old_crypto_key_feature
|
|
USING (feature::text::old_crypto_key_feature);
|
|
|
|
DROP TYPE crypto_key_feature;
|
|
|
|
ALTER TYPE old_crypto_key_feature RENAME TO crypto_key_feature;
|
|
|