Files

7 lines
639 B
SQL
Raw Permalink Normal View History

ALTER TABLE custom_agents ADD COLUMN IF NOT EXISTS visibility varchar(16) NOT NULL DEFAULT 'global';
ALTER TABLE custom_agents ADD COLUMN IF NOT EXISTS enabled boolean NOT NULL DEFAULT true;
ALTER TABLE custom_agents ADD CONSTRAINT ck_custom_agents_visibility CHECK (visibility IN ('private', 'global'));
ALTER TABLE tenant_skill_catalog ADD COLUMN IF NOT EXISTS visibility varchar(16) NOT NULL DEFAULT 'private';
ALTER TABLE tenant_skill_catalog ADD COLUMN IF NOT EXISTS enabled boolean NOT NULL DEFAULT true;
ALTER TABLE tenant_skill_catalog ADD CONSTRAINT ck_tenant_skill_catalog_visibility CHECK (visibility IN ('private', 'global'));