--临时更新 --task 4529 使用ex_memo字段做市政-项目特征,三个扩展备注放宽至1000 --广东-谢金鑫 ALTER TABLE `zh_ledger_0` MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`, MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`, MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`; ALTER TABLE `zh_ledger_1` MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`, MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`, MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`; ALTER TABLE `zh_ledger_2` MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`, MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`, MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`; ALTER TABLE `zh_ledger_3` MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`, MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`, MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`; ALTER TABLE `zh_ledger_4` MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`, MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`, MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`; ALTER TABLE `zh_ledger_5` MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`, MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`, MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`; ALTER TABLE `zh_ledger_6` MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`, MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`, MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`; ALTER TABLE `zh_ledger_7` MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`, MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`, MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`; ALTER TABLE `zh_ledger_8` MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`, MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`, MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`; ALTER TABLE `zh_ledger_9` MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`, MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`, MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`; ALTER TABLE `zh_revise_bills_0` MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`, MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`, MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`; ALTER TABLE `zh_revise_bills_1` MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`, MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`, MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`; ALTER TABLE `zh_revise_bills_2` MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`, MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`, MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`; ALTER TABLE `zh_revise_bills_3` MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`, MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`, MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`; ALTER TABLE `zh_revise_bills_4` MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`, MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`, MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`; ALTER TABLE `zh_revise_bills_5` MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`, MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`, MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`; ALTER TABLE `zh_revise_bills_6` MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`, MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`, MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`; ALTER TABLE `zh_revise_bills_7` MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`, MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`, MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`; ALTER TABLE `zh_revise_bills_8` MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`, MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`, MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`; ALTER TABLE `zh_revise_bills_9` MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`, MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`, MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;