CREATE TABLE IF NOT EXISTS tenant_skill_catalog (
 id TEXT PRIMARY KEY, tenant_id INTEGER NOT NULL, name TEXT NOT NULL,
 version TEXT, description TEXT, instructions TEXT, bundle_ref TEXT, bundle_sha256 TEXT,
 created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
 updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, deleted_at DATETIME
);
ALTER TABLE tenant_skill_catalog ADD COLUMN instruction_only INTEGER NOT NULL DEFAULT 0;
ALTER TABLE tenant_skill_catalog ADD COLUMN created_by TEXT NOT NULL DEFAULT '';
DROP INDEX IF EXISTS 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 AND instruction_only = 0;
CREATE UNIQUE INDEX uq_tenant_instruction_skill_owner_name ON tenant_skill_catalog(tenant_id, created_by, name) WHERE deleted_at IS NULL AND instruction_only = 1;