update20210906.sql 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302
  1. ALTER TABLE `zh_ledger_0`
  2. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `check_calc`,
  3. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  4. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  5. ALTER TABLE `zh_ledger_1`
  6. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `check_calc`,
  7. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  8. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  9. ALTER TABLE `zh_ledger_2`
  10. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `check_calc`,
  11. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  12. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  13. ALTER TABLE `zh_ledger_3`
  14. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `check_calc`,
  15. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  16. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  17. ALTER TABLE `zh_ledger_4`
  18. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `check_calc`,
  19. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  20. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  21. ALTER TABLE `zh_ledger_5`
  22. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `check_calc`,
  23. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  24. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  25. ALTER TABLE `zh_ledger_6`
  26. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `check_calc`,
  27. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  28. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  29. ALTER TABLE `zh_ledger_7`
  30. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `check_calc`,
  31. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  32. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  33. ALTER TABLE `zh_ledger_8`
  34. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `check_calc`,
  35. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  36. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  37. ALTER TABLE `zh_ledger_9`
  38. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `check_calc`,
  39. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  40. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  41. ALTER TABLE `zh_revise_bills_0`
  42. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `check_calc`,
  43. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  44. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  45. ALTER TABLE `zh_revise_bills_1`
  46. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `check_calc`,
  47. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  48. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  49. ALTER TABLE `zh_revise_bills_2`
  50. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `check_calc`,
  51. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  52. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  53. ALTER TABLE `zh_revise_bills_3`
  54. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `check_calc`,
  55. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  56. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  57. ALTER TABLE `zh_revise_bills_4`
  58. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `check_calc`,
  59. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  60. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  61. ALTER TABLE `zh_revise_bills_5`
  62. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `check_calc`,
  63. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  64. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  65. ALTER TABLE `zh_revise_bills_6`
  66. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `check_calc`,
  67. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  68. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  69. ALTER TABLE `zh_revise_bills_7`
  70. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `check_calc`,
  71. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  72. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  73. ALTER TABLE `zh_revise_bills_8`
  74. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `check_calc`,
  75. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  76. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  77. ALTER TABLE `zh_revise_bills_9`
  78. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `check_calc`,
  79. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  80. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  81. ALTER TABLE `zh_pos_0`
  82. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  83. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  84. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  85. ALTER TABLE `zh_pos_1`
  86. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  87. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  88. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  89. ALTER TABLE `zh_pos_2`
  90. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  91. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  92. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  93. ALTER TABLE `zh_pos_3`
  94. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  95. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  96. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  97. ALTER TABLE `zh_pos_4`
  98. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  99. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  100. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  101. ALTER TABLE `zh_pos_5`
  102. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  103. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  104. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  105. ALTER TABLE `zh_pos_6`
  106. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  107. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  108. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  109. ALTER TABLE `zh_pos_7`
  110. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  111. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  112. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  113. ALTER TABLE `zh_pos_8`
  114. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  115. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  116. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  117. ALTER TABLE `zh_pos_9`
  118. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  119. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  120. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  121. ALTER TABLE `zh_pos_10`
  122. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  123. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  124. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  125. ALTER TABLE `zh_pos_11`
  126. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  127. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  128. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  129. ALTER TABLE `zh_pos_12`
  130. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  131. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  132. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  133. ALTER TABLE `zh_pos_13`
  134. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  135. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  136. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  137. ALTER TABLE `zh_pos_14`
  138. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  139. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  140. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  141. ALTER TABLE `zh_pos_15`
  142. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  143. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  144. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  145. ALTER TABLE `zh_pos_16`
  146. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  147. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  148. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  149. ALTER TABLE `zh_pos_17`
  150. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  151. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  152. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  153. ALTER TABLE `zh_pos_18`
  154. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  155. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  156. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  157. ALTER TABLE `zh_pos_19`
  158. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  159. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  160. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  161. ALTER TABLE `zh_revise_pos_0`
  162. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  163. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  164. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  165. ALTER TABLE `zh_revise_pos_1`
  166. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  167. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  168. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  169. ALTER TABLE `zh_revise_pos_2`
  170. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  171. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  172. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  173. ALTER TABLE `zh_revise_pos_3`
  174. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  175. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  176. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  177. ALTER TABLE `zh_revise_pos_4`
  178. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  179. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  180. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  181. ALTER TABLE `zh_revise_pos_5`
  182. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  183. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  184. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  185. ALTER TABLE `zh_revise_pos_6`
  186. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  187. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  188. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  189. ALTER TABLE `zh_revise_pos_7`
  190. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  191. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  192. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  193. ALTER TABLE `zh_revise_pos_8`
  194. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  195. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  196. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  197. ALTER TABLE `zh_revise_pos_9`
  198. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  199. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  200. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  201. ALTER TABLE `zh_revise_pos_10`
  202. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  203. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  204. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  205. ALTER TABLE `zh_revise_pos_11`
  206. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  207. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  208. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  209. ALTER TABLE `zh_revise_pos_12`
  210. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  211. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  212. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  213. ALTER TABLE `zh_revise_pos_13`
  214. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  215. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  216. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  217. ALTER TABLE `zh_revise_pos_14`
  218. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  219. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  220. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  221. ALTER TABLE `zh_revise_pos_15`
  222. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  223. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  224. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  225. ALTER TABLE `zh_revise_pos_16`
  226. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  227. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  228. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  229. ALTER TABLE `zh_revise_pos_17`
  230. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  231. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  232. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  233. ALTER TABLE `zh_revise_pos_18`
  234. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  235. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  236. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  237. ALTER TABLE `zh_revise_pos_19`
  238. ADD COLUMN `ex_memo1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注1' AFTER `dagl_url`,
  239. ADD COLUMN `ex_memo2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注2' AFTER `ex_memo1`,
  240. ADD COLUMN `ex_memo3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注3' AFTER `ex_memo2`;
  241. ALTER TABLE `zh_project`
  242. ADD COLUMN `sjs_rela` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'sjs相关配置' AFTER `fun_rela`;