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