You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
10 lines
584 B
10 lines
584 B
|
|
ALTER TABLE `itax_base`.`sys_manager_dept` ADD COLUMN `permission_flag` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限标识 0 本部门 1本部门以及下级' AFTER `dept_id`;
|
|
|
|
|
|
update `itax_base`.`sys_manager_dept` set permission_flag ='0';
|
|
|
|
ALTER TABLE `itax_base`.`sys_manager_info` ADD COLUMN `cascade_flag` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据权限是否级联选择 0 不级联 1 级联选择' AFTER `update_user_id`;
|
|
|
|
|
|
update `itax_base`.`sys_manager_info` set cascade_flag ='1'; |