de36bb0724
Some checks failed
CI / Lint & TypeCheck (push) Has been cancelled
CI / Unit Tests (push) Has been cancelled
CI / Build Frontend (push) Has been cancelled
CI / Rust Check (push) Has been cancelled
CI / Security Scan (push) Has been cancelled
CI / E2E Tests (push) Has been cancelled
- Add IF NOT EXISTS to accounts_template_assignment ALTER COLUMN - Add IF NOT EXISTS to webhooks CREATE INDEX statements - Add created_at/updated_at columns + ON CONFLICT DO NOTHING to industry templates - Bump SCHEMA_VERSION 13→14 to force migration re-run on existing DB
10 lines
440 B
SQL
10 lines
440 B
SQL
-- Phase 1: accounts 表增加 assigned_template_id
|
||
-- 用户选择行业模板后记录分配关系，用于跟踪和跳过 onboarding
|
||
-- ON DELETE SET NULL: 模板被删除时不影响账户
|
||
|
||
ALTER TABLE accounts ADD COLUMN IF NOT EXISTS assigned_template_id TEXT
|
||
REFERENCES agent_templates(id) ON DELETE SET NULL;
|
||
|
||
COMMENT ON COLUMN accounts.assigned_template_id IS
|
||
'用户选择的行业模板 ID，用于跟踪模板分配状态';
|