-- 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;