xinmi/migrations/versioned/000210_instruction_skill_version_names.up.sql

BEGIN;
ALTER TABLE tenant_skill_catalog ADD COLUMN IF NOT EXISTS version_source_id VARCHAR(36) NOT NULL DEFAULT '';
UPDATE tenant_skill_catalog s SET version_source_id = f.source_id
FROM workbench_resource_forks f
WHERE f.kind = 'skills' AND f.tenant_id = s.tenant_id AND f.personal_id = s.id;
DROP INDEX IF EXISTS uq_tenant_instruction_skill_owner_name;
CREATE UNIQUE INDEX uq_tenant_instruction_skill_owner_name
ON tenant_skill_catalog(tenant_id, created_by, name, version_source_id)
WHERE deleted_at IS NULL AND instruction_only;
COMMIT;