@@ -146,20 +146,18 @@ ALTER TYPE api_key_scope ADD VALUE IF NOT EXISTS 'workspace_proxy:update';
146146-- https://github.com/coder/coder/blob/main/coderd/database/dbpurge/dbpurge.go#L85
147147DELETE FROM api_keysWHERE expires_at< NOW()- INTERVAL' 7 days'
148148
149- --
150149-- Add new columns without defaults; backfill; then enforce NOT NULL
151- --
152- ALTER TABLE api_keys
153- ADD COLUMN scopes api_key_scope[],
154- ADD COLUMN allow_listtext [];
150+ ALTER TABLE api_keys ADD COLUMN scopes api_key_scope[];
151+ ALTER TABLE api_keys ADD COLUMN allow_listtext [];
155152
156153-- Backfill existing rows for compatibility
157154UPDATE api_keysSET
158155 scopes= ARRAY[scope::api_key_scope],
159156 allow_list= ARRAY[' *:*'
160157
161- -- Enforce NOT NULL and drop legacy single-scope column
162- ALTER TABLE api_keys
163- ALTER COLUMN scopesSET NOT NULL ,
164- ALTER COLUMN allow_listSET NOT NULL ,
165- DROP COLUMN scope;
158+ -- Enforce NOT NULL
159+ ALTER TABLE api_keys ALTER COLUMN scopesSET NOT NULL ;
160+ ALTER TABLE api_keys ALTER COLUMN allow_listSET NOT NULL ;
161+
162+ -- Drop legacy single-scope column
163+ ALTER TABLE api_keys DROP COLUMN scope;