Files
codit/backend/migrations/002_ssh_principal_grant_principals.sql

6 lines
191 B
SQL

ALTER TABLE ssh_principal_grants ADD COLUMN principals_json TEXT NOT NULL DEFAULT '[]';
UPDATE ssh_principal_grants
SET principals_json = json_array(principal)
WHERE principals_json = '[]';