update20230627.sql 8.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103
  1. --临时更新
  2. --task 4529 使用ex_memo字段做市政-项目特征,三个扩展备注放宽至1000
  3. --广东-谢金鑫
  4. ALTER TABLE `zh_ledger_0`
  5. MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`,
  6. MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`,
  7. MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;
  8. ALTER TABLE `zh_ledger_1`
  9. MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`,
  10. MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`,
  11. MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;
  12. ALTER TABLE `zh_ledger_2`
  13. MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`,
  14. MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`,
  15. MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;
  16. ALTER TABLE `zh_ledger_3`
  17. MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`,
  18. MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`,
  19. MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;
  20. ALTER TABLE `zh_ledger_4`
  21. MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`,
  22. MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`,
  23. MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;
  24. ALTER TABLE `zh_ledger_5`
  25. MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`,
  26. MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`,
  27. MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;
  28. ALTER TABLE `zh_ledger_6`
  29. MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`,
  30. MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`,
  31. MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;
  32. ALTER TABLE `zh_ledger_7`
  33. MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`,
  34. MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`,
  35. MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;
  36. ALTER TABLE `zh_ledger_8`
  37. MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`,
  38. MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`,
  39. MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;
  40. ALTER TABLE `zh_ledger_9`
  41. MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`,
  42. MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`,
  43. MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;
  44. ALTER TABLE `zh_revise_bills_0`
  45. MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`,
  46. MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`,
  47. MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;
  48. ALTER TABLE `zh_revise_bills_1`
  49. MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`,
  50. MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`,
  51. MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;
  52. ALTER TABLE `zh_revise_bills_2`
  53. MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`,
  54. MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`,
  55. MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;
  56. ALTER TABLE `zh_revise_bills_3`
  57. MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`,
  58. MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`,
  59. MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;
  60. ALTER TABLE `zh_revise_bills_4`
  61. MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`,
  62. MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`,
  63. MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;
  64. ALTER TABLE `zh_revise_bills_5`
  65. MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`,
  66. MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`,
  67. MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;
  68. ALTER TABLE `zh_revise_bills_6`
  69. MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`,
  70. MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`,
  71. MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;
  72. ALTER TABLE `zh_revise_bills_7`
  73. MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`,
  74. MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`,
  75. MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;
  76. ALTER TABLE `zh_revise_bills_8`
  77. MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`,
  78. MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`,
  79. MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;
  80. ALTER TABLE `zh_revise_bills_9`
  81. MODIFY COLUMN `ex_memo1` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' AFTER `check_calc`,
  82. MODIFY COLUMN `ex_memo2` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' AFTER `ex_memo1`,
  83. MODIFY COLUMN `ex_memo3` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' AFTER `ex_memo2`;