14 lines
762 B
SQL
14 lines
762 B
SQL
-- Replace Docker image terminology with the pre-installed native browser contract.
|
|
ALTER TABLE browser_image RENAME TO browser_version;
|
|
ALTER TABLE browser_version RENAME COLUMN image_ref TO browser_path;
|
|
ALTER TABLE browser_env RENAME COLUMN image_version TO browser_version;
|
|
ALTER TABLE audit_event RENAME COLUMN old_image_version TO old_browser_version;
|
|
ALTER TABLE audit_event RENAME COLUMN new_image_version TO new_browser_version;
|
|
|
|
ALTER TABLE browser_version DROP CONSTRAINT browser_image_image_ref_check;
|
|
ALTER TABLE browser_version
|
|
ADD CONSTRAINT browser_version_browser_path_check
|
|
CHECK (browser_path ~ '^/[A-Za-z0-9._+~/-]+$');
|
|
ALTER TABLE browser_env
|
|
RENAME CONSTRAINT browser_env_image_version_fkey TO browser_env_browser_version_fkey;
|