Files
gochat/backend/migrations/000081_enforce_captain_skill_tenant_consistency.down.sql
Rogeeandrogee be53f30394 H-290: enforce Captain Skill tenant bindings (#51)
* H-290: enforce Captain Skill tenant consistency

* H-290: fix SQLite tenant migration coverage

* H-290: leave tenant constraints to migrations

---------

Co-authored-by: Rogee <rogee@ipao.vip>
2026-08-19 17:54:45 +08:00

7 lines
296 B
SQL

ALTER TABLE captain_assistant_skills
DROP CONSTRAINT IF EXISTS fk_captain_assistant_skills_assistant_tenant,
DROP CONSTRAINT IF EXISTS fk_captain_assistant_skills_skill_tenant;
DROP INDEX IF EXISTS idx_captain_assistants_account_id_id;
DROP INDEX IF EXISTS idx_captain_skills_account_id_id;