1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| -- ===========================
| -- 部门表添加服务单和调度单编码字段
| -- ===========================
|
| -- 添加服务单编码字段
| ALTER TABLE sys_dept
| ADD COLUMN service_order_class VARCHAR(20) NULL COMMENT '服务单编码(对应旧系统OrderClass vType=1)' AFTER department_id;
|
| -- 添加调度单编码字段
| ALTER TABLE sys_dept
| ADD COLUMN dispatch_order_class VARCHAR(20) NULL COMMENT '调度单编码(对应旧系统OrderClass vType=2)' AFTER service_order_class;
|
| -- 添加索引
| ALTER TABLE sys_dept ADD INDEX idx_service_order_class (service_order_class);
| ALTER TABLE sys_dept ADD INDEX idx_dispatch_order_class (dispatch_order_class);
|
| -- 查看表结构
| DESC sys_dept;
|
|
