Calculation/sql/update20230627.sql

--临时更新
--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`;