superidou
5759c1862e
M0-M7 已完成:核心网关(身份/RBAC/TOTP/OIDC/SAML/Provider/配额/路由/内容策略/审计/定价)+ 资源市场(MCP/Skills/数字员工)。 含 22 个 PostgreSQL 迁移、管理端/门户端前端源码、OpenAPI 契约、部署 compose。 Co-Authored-By: Claude <noreply@anthropic.com>
14 lines
553 B
SQL
14 lines
553 B
SQL
ALTER TABLE gateway.departments
|
|
ADD COLUMN IF NOT EXISTS parent_id uuid REFERENCES gateway.departments(id),
|
|
ADD COLUMN IF NOT EXISTS description text NOT NULL DEFAULT '';
|
|
|
|
CREATE INDEX IF NOT EXISTS departments_parent_active_idx
|
|
ON gateway.departments (parent_id, active, code);
|
|
|
|
ALTER TABLE gateway.departments
|
|
ADD CONSTRAINT departments_not_self_parent
|
|
CHECK (parent_id IS NULL OR parent_id <> id);
|
|
|
|
COMMENT ON COLUMN gateway.departments.parent_id IS
|
|
'Adjacency-list parent. Application writes reject cycles transactionally.';
|