11 lines
541 B
PL/PgSQL
11 lines
541 B
PL/PgSQL
|
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;
|