2022-07-19 12:03:05 +08:00
|
|
|
ALTER TABLE t_camera_channel ADD COLUMN region_code VARCHAR(255) COMMENT '市区编码';
|
|
|
|
|
ALTER TABLE t_camera_channel ADD COLUMN region_name VARCHAR(255) COMMENT '市区名称';
|
|
|
|
|
|
2022-08-05 17:34:53 +08:00
|
|
|
ALTER TABLE t_camera_organization ADD COLUMN count INT DEFAULT(0);
|
2022-07-19 12:03:05 +08:00
|
|
|
ALTER TABLE t_camera_organization ADD COLUMN is_parent INT COMMENT '是否父节点';
|
|
|
|
|
ALTER TABLE t_camera_organization ADD COLUMN path VARCHAR(500) COMMENT '从属关系';
|
