Domů Procházet Nápověda
Registrovat se Přihlásit se
LYFZ
/
lyfz_repos
2
0
Rozštěpit 0
Soubory Úkoly 0 Pull Requesty 0 Wiki
Větev: master
Větve Značky
lyfz_repos
/
经典版源码
/
document
/
数据库维护脚本
/
修改version表字段属性.sql

修改version表字段属性.sql 11 KB
Trvalý odkaz Historie Surový

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174 
  1. --version±í;
    2. 

  2. use db
    3. 

  3. if not exists(select name from syscolumns where id=object_id('version') and name='curdate')
    4. 

  4. 	alter table [version] add [curdate] [nvarchar](50) NULL
    5. 

  5. else
    6. 

  6. 	alter table	[version] alter column [curdate] [nvarchar](50) NULL
    7. 

  7. 

  8. if not exists(select name from syscolumns where id=object_id('version') and name='cardlength')
    9. 

  9. 	alter table [version] add [cardlength] [nvarchar](50) NULL
    10. 

  10. else
    11. 

  11. 	alter table	[version] alter column [cardlength] [nvarchar](50) NULL
    12. 

  12. 

  13. ------------------------------------------------------------
    14. 

  14. alter table	[version] alter column [version] [nvarchar](50) NULL
    15. 

  15. alter table	[version] alter column [check1] [nvarchar](50) NULL
    16. 

  16. alter table	[version] alter column [check2] [nvarchar](50) NULL
    17. 

  17. alter table	[version] alter column [check3] [nvarchar](50) NULL
    18. 

  18. alter table	[version] alter column [check4] [nvarchar](50) NULL
    19. 

  19. 

  20. alter table	[version] alter column [edit1] [nvarchar](50) NULL
    21. 

  21. alter table	[version] alter column [edit2] [nvarchar](50) NULL
    22. 

  22. alter table	[version] alter column [edit3] [nvarchar](50) NULL
    23. 

  23. alter table	[version]  alter column [edit4] [nvarchar](50) NULL
    24. 

  24. alter table	[version]  alter column [info1] [nvarchar](50) NULL
    25. 

  25. alter table	[version]  alter column [info2] [nvarchar](50) NULL
    26. 

  26. alter table	[version]  alter column [info3] [nvarchar](50) NULL
    27. 

  27. alter table	[version]  alter column [info4] [nvarchar](50) NULL
    28. 

  28. alter table	[version]  alter column [info5] [nvarchar](50) NULL
    29. 

  29. alter table	[version]  alter column [bak1] [nvarchar](50) NULL
    30. 

  30. alter table	[version]  alter column [bak2] [nvarchar](50) NULL
    31. 

  31. alter table	[version]  alter column [bak3] [nvarchar](50) NULL
    32. 

  32. alter table	[version]  alter column [bak4] [nvarchar](50) NULL
    33. 

  33. alter table	[version]  alter column [bak5] [nvarchar](50) NULL
    34. 

  34. alter table	[version]  alter column [bak6] [nvarchar](50) NULL
    35. 

  35. alter table	[version]  alter column [baktime] [nvarchar](50) NULL
    36. 

  36. alter table	[version]  alter column [bakserver1] [nvarchar](50) NULL
    37. 

  37. alter table	[version]  alter column [bakserver2] [nvarchar](50) NULL
    38. 

  38. alter table	[version]  alter column [bakserver3] [nvarchar](50) NULL
    39. 

  39. alter table	[version]  alter column [bakserver4] [nvarchar](50) NULL
    40. 

  40. alter table	[version]  alter column [bakserver5] [nvarchar](50) NULL
    41. 

  41. alter table	[version]  alter column [msgaccount] [nvarchar](50) NULL
    42. 

  42. 

  43. alter table	[version]  alter column [msgpsw] [nvarchar](50) NULL
    44. 

  44. alter table	[version]  alter column [msgused] [nvarchar](50) NULL
    45. 

  45. alter table	[version]  alter column [msgbalance] [nvarchar](50) NULL
    46. 

  46. alter table	[version]  alter column [msgcheck1] [nvarchar](50) NULL
    47. 

  47. alter table	[version]  alter column [msgcheck2] [nvarchar](50) NULL
    48. 

  48. alter table	[version]  alter column [msgdays1] [nvarchar](50) NULL
    49. 

  49. alter table	[version]  alter column [msgdays2] [nvarchar](50) NULL
    50. 

  50. alter table	[version]  alter column [msgcontent1] [nvarchar](max) NULL
    51. 

  51. alter table	[version]  alter column [msgcontent2] [nvarchar](max) NULL
    52. 

  52. alter table	[version]  alter column [remarks] [nvarchar](max) NULL
    53. 

  53. alter table	[version]  alter column [rate] [nvarchar](50) NULL
    54. 

  54. alter table	[version]  alter column [msgcheck3] [nvarchar](50) NULL
    55. 

  55. alter table	[version]  alter column [msgcontent3] [nvarchar](max) NULL
    56. 

  56. alter table	[version]  alter column [salarycheck1] [nvarchar](50) NULL
    57. 

  57. alter table	[version]  alter column [salarycheck2] [nvarchar](50) NULL
    58. 

  58. alter table	[version]  alter column [msgcheck4] [nvarchar](50) NULL
    59. 

  59. alter table	[version]  alter column [msgtime] [nvarchar](50) NULL
    60. 

  60. alter table	[version]  alter column [msgphones] [nvarchar](max) NULL
    61. 

  61. alter table	[version]  alter column [info6] [nvarchar](50) NULL
    62. 

  62. alter table	[version]  alter column [msgcompanyname] [nvarchar](50) NULL
    63. 

  63. alter table	[version]  alter column [msgphones2] [nvarchar](max) NULL
    64. 

  64. alter table	[version] alter column [msgsendtype] [nvarchar](50) NULL
    65. 

  65. alter table	[version] alter column [msgcontent5] [nvarchar](max) NULL
    66. 

  66. alter table	[version] alter column [msgcontent6] [nvarchar](max) NULL
    67. 

  67. 

  68. alter table	[version] alter column [rate2] [nvarchar](50) NULL--
    69. 

  69. 

  70. alter table	[version] alter column [salarycheck3] [nvarchar](50) NULL
    71. 

  71. alter table	[version] alter column [salarycheck4] [nvarchar](50) NULL
    72. 

  72. alter table	[version] alter column [msgcheck5] [nvarchar](50) NULL
    73. 

  73. alter table	[version] alter column [msgcheck6] [nvarchar](50) NULL
    74. 

  74. alter table	[version] alter column [setcheck1] [nvarchar](50) NULL
    75. 

  75. alter table	[version] alter column [setcheck2] [nvarchar](50) NULL
    76. 

  76. alter table	[version] alter column [setcheck3] [nvarchar](50) NULL
    77. 

  77. alter table	[version] alter column [setcheck4] [nvarchar](50) NULL
    78. 

  78. alter table	[version] alter column [setcheck5] [nvarchar](50) NULL
    79. 

  79. alter table	[version] alter column [setcheck10] [nvarchar](50) NULL
    80. 

  80. alter table	[version] alter column [printer1] [nvarchar](50) NULL
    81. 

  81. alter table	[version] alter column [printer2] [nvarchar](50) NULL
    82. 

  82. alter table	[version] alter column [printer3] [nvarchar](50) NULL
    83. 

  83. alter table	[version] alter column [setprintstyle] [nvarchar](50) NULL
    84. 

  84. alter table	[version] alter column [setprintstyle2] [nvarchar](50) NULL
    85. 

  85. alter table	[version] alter column [uploadcheck1] [nvarchar](50) NULL
    86. 

  86. alter table	[version] alter column [uploadcheck2] [nvarchar](50) NULL
    87. 

  87. alter table	[version] alter column [uploadcheck3] [nvarchar](50) NULL
    88. 

  88. alter table	[version] alter column [uploadcheck4] [nvarchar](50) NULL
    89. 

  89. alter table	[version] alter column [bak11] [nvarchar](50) NULL
    90. 

  90. alter table	[version] alter column [bak22] [nvarchar](50) NULL
    91. 

  91. alter table	[version] alter column [bak33] [nvarchar](50) NULL
    92. 

  92. alter table	[version] alter column [bak44] [nvarchar](50) NULL
    93. 

  93. 

  94. alter table	[version] alter column [ziptype1] [nvarchar](50) NULL
    95. 

  95. alter table	[version] alter column [ziptype2] [nvarchar](50) NULL
    96. 

  96. alter table	[version] alter column [ziptype3] [nvarchar](50) NULL
    97. 

  97. alter table	[version] alter column [ziptype4] [nvarchar](50) NULL
    98. 

  98. alter table	[version] alter column [limitcount1] [nvarchar](50) NULL
    99. 

  99. alter table	[version] alter column [limitcount2] [nvarchar](50) NULL
    100. 

  100. alter table	[version] alter column [limitcount3] [nvarchar](50) NULL
    101. 

  101. alter table	[version] alter column [salaryset] [nvarchar](max) NULL
    102. 

  102. alter table	[version] alter column [setcheck11] [nvarchar](50) NULL
    103. 

  103. alter table	[version] alter column [setcheck12] [nvarchar](50) NULL
    104. 

  104. alter table	[version] alter column [setprintstyle3] [nvarchar](50) NULL
    105. 

  105. alter table	[version] alter column [msgcheck7] [nvarchar](50) NULL
    106. 

  106. alter table	[version] alter column [msgcheck8] [nvarchar](50) NULL
    107. 

  107. alter table	[version] alter column [msgcheck9] [nvarchar](50) NULL
    108. 

  108. alter table	[version] alter column [msgcheck10] [nvarchar](50) NULL
    109. 

  109. alter table	[version] alter column [msgcontent8] [nvarchar](max) NULL
    110. 

  110. alter table	[version] alter column [msgcontent9] [nvarchar](max) NULL
    111. 

  111. alter table	[version] alter column [msgcontent10] [nvarchar](max) NULL
    112. 

  112. alter table	[version] alter column [setcheck13] [nvarchar](50) NULL
    113. 

  113. alter table	[version] alter column [time1] [nvarchar](50) NULL
    114. 

  114. alter table	[version] alter column [time2] [nvarchar](50) NULL
    115. 

  115. alter table	[version] alter column [time3] [nvarchar](50) NULL
    116. 

  116. alter table	[version] alter column [setcheck14] [nvarchar](50) NULL
    117. 

  117. alter table	[version] alter column [setcheck15] [nvarchar](50) NULL
    118. 

  118. alter table	[version] alter column [msgcheck11] [nvarchar](50) NULL
    119. 

  119. alter table	[version] alter column [msgcheck12] [nvarchar](50) NULL
    120. 

  120. alter table	[version] alter column [msgcheck13] [nvarchar](50) NULL
    121. 

  121. alter table	[version] alter column [msgcheck14] [nvarchar](50) NULL
    122. 

  122. alter table	[version] alter column [msgcontent11] [nvarchar](max) NULL
    123. 

  123. alter table	[version] alter column [msgcontent12] [nvarchar](max) NULL
    124. 

  124. alter table	[version] alter column [msgcontent13] [nvarchar](max) NULL
    125. 

  125. alter table	[version] alter column [msgcontent14] [nvarchar](max) NULL
    126. 

  126. alter table	[version] alter column [setcheck6] [nvarchar](50) NULL
    127. 

  127. alter table	[version] alter column [msgcheck15] [nvarchar](50) NULL
    128. 

  128. alter table	[version] alter column [msgcontent15] [nvarchar](max) NULL
    129. 

  129. alter table	[version] alter column [logdays] [nvarchar](50) NULL
    130. 

  130. alter table	[version] alter column [setcheck17] [nvarchar](50) NULL
    131. 

  131. alter table	[version] alter column [setcheck18] [nvarchar](50) NULL
    132. 

  132. alter table	[version] alter column [setcheck19] [nvarchar](50) NULL
    133. 

  133. alter table	[version] alter column [uploadrule] [nvarchar](max) NULL
    134. 

  134. alter table	[version] alter column [setcheck20] [nvarchar](50) NULL
    135. 

  135. 

  136. alter table	[version] alter column [cardnum] [nvarchar](50) NULL
    137. 

  137. alter table	[version] alter column [cardscale] [nvarchar](500) NULL
    138. 

  138. alter table	[version] alter column [info7] [nvarchar](120) NULL
    139. 

  139. alter table	[version] alter column [setcheck21] [nvarchar](50) NULL
    140. 

  140. alter table	[version] alter column [msgcheck16] [nvarchar](50) NULL
    141. 

  141. alter table	[version] alter column [hospitalmsgcheck1] [nvarchar](50) NULL
    142. 

  142. alter table	[version] alter column [hospitalmsgcheck2] [nvarchar](50) NULL
    143. 

  143. alter table	[version] alter column [serialno] [nvarchar](50) NULL
    144. 

  144. alter table	[version] alter column [serialno2] [nvarchar](50) NULL
    145. 

  145. alter table	[version] alter column [msgcheck17] [nvarchar](50) NULL
    146. 

  146. alter table	[version] alter column [msgcontent17] [nvarchar](max) NULL
    147. 

  147. 

  148. alter table	[version] alter column [setcheck22] [nvarchar](50) NULL
    149. 

  149. alter table	[version] alter column [setcheck23] [nvarchar](50) NULL
    150. 

  150. alter table	[version] alter column [info8] [nvarchar](120) NULL
    151. 

  151. alter table	[version] alter column [setcheck24] [nvarchar](120) NULL
    152. 

  152. alter table	[version] alter column [outtime] [nvarchar](120) NULL
    153. 

  153. alter table	[version] alter column [info9] [nvarchar](120) NULL
    154. 

  154. alter table	[version] alter column [reverse1] [nvarchar](50) NULL
    155. 

  155. alter table	[version] alter column [reverse2] [nvarchar](50) NULL
    156. 

  156. alter table	[version] alter column [reverse3] [nvarchar](50) NULL
    157. 

  157. alter table	[version] alter column [reverse4] [nvarchar](50) NULL
    158. 

  158. alter table	[version] alter column [reverse5] [nvarchar](50) NULL
    159. 

  159. alter table	[version] alter column [photo] [image] NULL
    160. 

  160. 

  161. alter table	[version] alter column [delcheck1] [nvarchar](50) NULL
    162. 

  162. alter table	[version] alter column [delcheck2] [nvarchar](50) NULL
    163. 

  163. alter table	[version] alter column [delcheck3] [nvarchar](50) NULL
    164. 

  164. alter table	[version] alter column [delcheck4] [nvarchar](50) NULL
    165. 

  165. alter table	[version] alter column [deledit1] [nvarchar](50) NULL
    166. 

  166. alter table	[version] alter column [deledit2] [nvarchar](50) NULL
    167. 

  167. alter table	[version] alter column [deledit3] [nvarchar](50) NULL
    168. 

  168. alter table	[version] alter column [deledit4] [nvarchar](50) NULL
    169. 

  169. alter table	[version] alter column [alarmdays1] [nvarchar](50) NULL
    170. 

  170. alter table	[version] alter column [alarmdays2] [nvarchar](50) NULL
    171. 

  171. alter table	[version] alter column [alarmdays3] [nvarchar](50) NULL
    172. 

  172. alter table	[version] alter column [alarmdays4] [nvarchar](50) NULL
    173. 

  173. alter table	[version] alter column [alarmdays5] [nvarchar](50) NULL
    174. 

  174. alter table	[version] alter column [alarmdays6] [nvarchar](50) NULL
    175.