8 lines
501 B
SQL
8 lines
501 B
SQL
|
CREATE UNIQUE INDEX uq_tenant_skill_catalog_legacy_check ON tenant_skill_catalog(tenant_id, name) WHERE deleted_at IS NULL;
|
||
|
|
DROP INDEX uq_tenant_instruction_skill_owner_name;
|
||
|
|
DROP INDEX uq_tenant_skill_catalog_name;
|
||
|
|
CREATE UNIQUE INDEX uq_tenant_skill_catalog_name ON tenant_skill_catalog(tenant_id, name) WHERE deleted_at IS NULL;
|
||
|
|
DROP INDEX uq_tenant_skill_catalog_legacy_check;
|
||
|
|
ALTER TABLE tenant_skill_catalog DROP COLUMN instruction_only;
|
||
|
|
ALTER TABLE tenant_skill_catalog DROP COLUMN created_by;
|