水利项目
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.

21 lines
1.5 KiB

1 year ago
ALTER TABLE `sgc_yg`.`sys_role` ADD COLUMN `area` VARCHAR ( 255 ) NULL AFTER `md5`;
ALTER TABLE `sgc_yg`.`sys_role` ADD COLUMN `data_config` VARCHAR ( 255 ) NULL AFTER `md5`;
ALTER TABLE `sgc_yg`.`sys_role` ADD COLUMN `type` VARCHAR ( 255 ) NULL AFTER `md5`;
ALTER TABLE `sgc_yg`.`sys_role` ADD COLUMN `category` VARCHAR ( 50 ) NULL AFTER `md5`;
ALTER TABLE `sgc_yg`.`sys_role` ADD COLUMN `md5` VARCHAR ( 50 ) NULL AFTER `md5`;
ALTER TABLE `sgc_yg`.`sys_dept` ADD COLUMN `single_type` VARCHAR ( 255 ) NULL;
ALTER TABLE `sgc_yg`.`sys_dept` ADD COLUMN `single_code` VARCHAR ( 255 ) NULL;
ALTER TABLE `sgc_yg`.`sys_dept` ADD COLUMN `single_seq` VARCHAR ( 255 ) NULL;
ALTER TABLE `sgc_yg`.`sys_dept` ADD COLUMN `category` VARCHAR ( 255 ) NULL;
ALTER TABLE `sgc_yg`.`sys_dept` ADD COLUMN `md5` VARCHAR ( 255 ) NULL;
ALTER TABLE `sgc_yg`.`sys_dept` ADD COLUMN `level_text` VARCHAR ( 255 ) NULL;
ALTER TABLE `sgc_yg`.`sys_dept` ADD COLUMN `level` VARCHAR ( 255 ) NULL;
ALTER TABLE `sgc_yg`.`sys_user` ADD COLUMN `single_user_id` VARCHAR ( 255 ) NULL;
ALTER TABLE `sgc_yg`.`sys_user` ADD COLUMN `single_user_source` VARCHAR ( 255 ) NULL;
ALTER TABLE `sgc_yg`.`sys_user` ADD COLUMN `single_user_type` VARCHAR ( 255 ) NULL;
ALTER TABLE `sgc_yg`.`sys_user` ADD COLUMN `md5` VARCHAR ( 255 ) NULL;
ALTER TABLE `sgc_yg`.`sys_user` ADD COLUMN `user_type` VARCHAR ( 255 ) NULL;
1 year ago
ALTER TABLE `sgc_yg`.`att_dike_base`
CHANGE COLUMN `ENG_GRAD` `dike_GRAD` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '堤防级别' AFTER `dike_USE`;
1 month ago