ホーム エクスプローラ ヘルプ
登録 サインイン
WAREWMS
/
WAREAMS
2
0
フォーク 0
ファイル 課題 0 プルリクエスト 0 Wiki
ツリー: 90c3454e8a
ブランチ タグ
WAREAMS
/
sql
/
xuankuang_ddl_20230904.sql

xuankuang_ddl_20230904.sql 24 KB
履歴 Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233 
  1. -- ----------------------------
    2. 

  2. -- 增加库位对应wcs库位信息
    3. 

  3. -- ----------------------------
    4. 

  4. update base_location_info set userdefine4 = '0110S' where row_index = 1 and row_no = 10 and shift_no = 1;
    5. 

  5. update base_location_info set userdefine4 = '0205S' where row_index = 2 and row_no = 5 and shift_no = 1;
    6. 

  6. update base_location_info set userdefine4 = '0206S' where row_index = 2 and row_no = 6 and shift_no = 1;
    7. 

  7. update base_location_info set userdefine4 = '0207S' where row_index = 2 and row_no = 7 and shift_no = 1;
    8. 

  8. update base_location_info set userdefine4 = '0208S' where row_index = 2 and row_no = 8 and shift_no = 1;
    9. 

  9. update base_location_info set userdefine4 = '0210S' where row_index = 2 and row_no = 10 and shift_no = 1;
    10. 

  10. update base_location_info set userdefine4 = '0301S' where row_index = 3 and row_no = 1 and shift_no = 1;
    11. 

  11. update base_location_info set userdefine4 = '0302S' where row_index = 3 and row_no = 2 and shift_no = 1;
    12. 

  12. update base_location_info set userdefine4 = '0303S' where row_index = 3 and row_no = 3 and shift_no = 1;
    13. 

  13. update base_location_info set userdefine4 = '0305S' where row_index = 3 and row_no = 5 and shift_no = 1;
    14. 

  14. update base_location_info set userdefine4 = '0306S' where row_index = 3 and row_no = 6 and shift_no = 1;
    15. 

  15. update base_location_info set userdefine4 = '0307S' where row_index = 3 and row_no = 7 and shift_no = 1;
    16. 

  16. update base_location_info set userdefine4 = '0308S' where row_index = 3 and row_no = 8 and shift_no = 1;
    17. 

  17. update base_location_info set userdefine4 = '0310S' where row_index = 3 and row_no = 10 and shift_no = 1;
    18. 

  18. update base_location_info set userdefine4 = '0401S' where row_index = 4 and row_no = 1 and shift_no = 1;
    19. 

  19. update base_location_info set userdefine4 = '0402S' where row_index = 4 and row_no = 2 and shift_no = 1;
    20. 

  20. update base_location_info set userdefine4 = '0403S' where row_index = 4 and row_no = 3 and shift_no = 1;
    21. 

  21. update base_location_info set userdefine4 = '0405S' where row_index = 4 and row_no = 5 and shift_no = 1;
    22. 

  22. update base_location_info set userdefine4 = '0406S' where row_index = 4 and row_no = 6 and shift_no = 1;
    23. 

  23. update base_location_info set userdefine4 = '0407S' where row_index = 4 and row_no = 7 and shift_no = 1;
    24. 

  24. update base_location_info set userdefine4 = '0408S' where row_index = 4 and row_no = 8 and shift_no = 1;
    25. 

  25. update base_location_info set userdefine4 = '0410S' where row_index = 4 and row_no = 10 and shift_no = 1;
    26. 

  26. update base_location_info set userdefine4 = '0503S' where row_index = 5 and row_no = 3 and shift_no = 1;
    27. 

  27. update base_location_info set userdefine4 = '0505S' where row_index = 5 and row_no = 5 and shift_no = 1;
    28. 

  28. update base_location_info set userdefine4 = '0506S' where row_index = 5 and row_no = 6 and shift_no = 1;
    29. 

  29. update base_location_info set userdefine4 = '0507S' where row_index = 5 and row_no = 7 and shift_no = 1;
    30. 

  30. update base_location_info set userdefine4 = '0508S' where row_index = 5 and row_no = 8 and shift_no = 1;
    31. 

  31. update base_location_info set userdefine4 = '0510S' where row_index = 5 and row_no = 10 and shift_no = 1;
    32. 

  32. update base_location_info set userdefine4 = '0603S' where row_index = 6 and row_no = 3 and shift_no = 1;
    33. 

  33. update base_location_info set userdefine4 = '0605S' where row_index = 6 and row_no = 5 and shift_no = 1;
    34. 

  34. update base_location_info set userdefine4 = '0606S' where row_index = 6 and row_no = 6 and shift_no = 1;
    35. 

  35. update base_location_info set userdefine4 = '0607S' where row_index = 6 and row_no = 7 and shift_no = 1;
    36. 

  36. update base_location_info set userdefine4 = '0608S' where row_index = 6 and row_no = 8 and shift_no = 1;
    37. 

  37. update base_location_info set userdefine4 = '0610S' where row_index = 6 and row_no = 10 and shift_no = 1;
    38. 

  38. update base_location_info set userdefine4 = '0703S' where row_index = 7 and row_no = 3 and shift_no = 1;
    39. 

  39. update base_location_info set userdefine4 = '0705S' where row_index = 7 and row_no = 5 and shift_no = 1;
    40. 

  40. update base_location_info set userdefine4 = '0706S' where row_index = 7 and row_no = 6 and shift_no = 1;
    41. 

  41. update base_location_info set userdefine4 = '0707S' where row_index = 7 and row_no = 7 and shift_no = 1;
    42. 

  42. update base_location_info set userdefine4 = '0708S' where row_index = 7 and row_no = 8 and shift_no = 1;
    43. 

  43. update base_location_info set userdefine4 = '0710S' where row_index = 7 and row_no = 10 and shift_no = 1;
    44. 

  44. update base_location_info set userdefine4 = '0801S' where row_index = 8 and row_no = 1 and shift_no = 1;
    45. 

  45. update base_location_info set userdefine4 = '0802S' where row_index = 8 and row_no = 2 and shift_no = 1;
    46. 

  46. update base_location_info set userdefine4 = '0803S' where row_index = 8 and row_no = 3 and shift_no = 1;
    47. 

  47. update base_location_info set userdefine4 = '0805S' where row_index = 8 and row_no = 5 and shift_no = 1;
    48. 

  48. update base_location_info set userdefine4 = '0806S' where row_index = 8 and row_no = 6 and shift_no = 1;
    49. 

  49. update base_location_info set userdefine4 = '0807S' where row_index = 8 and row_no = 7 and shift_no = 1;
    50. 

  50. update base_location_info set userdefine4 = '0808S' where row_index = 8 and row_no = 8 and shift_no = 1;
    51. 

  51. update base_location_info set userdefine4 = '0810S' where row_index = 8 and row_no = 10 and shift_no = 1;
    52. 

  52. update base_location_info set userdefine4 = '0901S' where row_index = 9 and row_no = 1 and shift_no = 1;
    53. 

  53. update base_location_info set userdefine4 = '0902S' where row_index = 9 and row_no = 2 and shift_no = 1;
    54. 

  54. update base_location_info set userdefine4 = '0903S' where row_index = 9 and row_no = 3 and shift_no = 1;
    55. 

  55. update base_location_info set userdefine4 = '0905S' where row_index = 9 and row_no = 5 and shift_no = 1;
    56. 

  56. update base_location_info set userdefine4 = '0906S' where row_index = 9 and row_no = 6 and shift_no = 1;
    57. 

  57. update base_location_info set userdefine4 = '0907S' where row_index = 9 and row_no = 7 and shift_no = 1;
    58. 

  58. update base_location_info set userdefine4 = '0908S' where row_index = 9 and row_no = 8 and shift_no = 1;
    59. 

  59. update base_location_info set userdefine4 = '0910S' where row_index = 9 and row_no = 10 and shift_no = 1;
    60. 

  60. update base_location_info set userdefine4 = '1005S' where row_index = 10 and row_no = 5 and shift_no = 1;
    61. 

  61. update base_location_info set userdefine4 = '1006S' where row_index = 10 and row_no = 6 and shift_no = 1;
    62. 

  62. update base_location_info set userdefine4 = '1007S' where row_index = 10 and row_no = 7 and shift_no = 1;
    63. 

  63. update base_location_info set userdefine4 = '1008S' where row_index = 10 and row_no = 8 and shift_no = 1;
    64. 

  64. update base_location_info set userdefine4 = '1010S' where row_index = 10 and row_no = 10 and shift_no = 1;
    65. 

  65. update base_location_info set userdefine4 = '1110S' where row_index = 11 and row_no = 10 and shift_no = 1;
    66. 

  66. update base_location_info set userdefine4 = '1205S' where row_index = 12 and row_no = 5 and shift_no = 1;
    67. 

  67. update base_location_info set userdefine4 = '1206S' where row_index = 12 and row_no = 6 and shift_no = 1;
    68. 

  68. update base_location_info set userdefine4 = '1207S' where row_index = 12 and row_no = 7 and shift_no = 1;
    69. 

  69. update base_location_info set userdefine4 = '1208S' where row_index = 12 and row_no = 8 and shift_no = 1;
    70. 

  70. update base_location_info set userdefine4 = '1210S' where row_index = 12 and row_no = 10 and shift_no = 1;
    71. 

  71. update base_location_info set userdefine4 = '1303S' where row_index = 13 and row_no = 3 and shift_no = 1;
    72. 

  72. update base_location_info set userdefine4 = '1305S' where row_index = 13 and row_no = 5 and shift_no = 1;
    73. 

  73. update base_location_info set userdefine4 = '1306S' where row_index = 13 and row_no = 6 and shift_no = 1;
    74. 

  74. update base_location_info set userdefine4 = '1307S' where row_index = 13 and row_no = 7 and shift_no = 1;
    75. 

  75. update base_location_info set userdefine4 = '1308S' where row_index = 13 and row_no = 8 and shift_no = 1;
    76. 

  76. update base_location_info set userdefine4 = '1310S' where row_index = 13 and row_no = 10 and shift_no = 1;
    77. 

  77. update base_location_info set userdefine4 = '1405S' where row_index = 14 and row_no = 5 and shift_no = 1;
    78. 

  78. update base_location_info set userdefine4 = '1406S' where row_index = 14 and row_no = 6 and shift_no = 1;
    79. 

  79. update base_location_info set userdefine4 = '1407S' where row_index = 14 and row_no = 7 and shift_no = 1;
    80. 

  80. update base_location_info set userdefine4 = '1408S' where row_index = 14 and row_no = 8 and shift_no = 1;
    81. 

  81. update base_location_info set userdefine4 = '1410S' where row_index = 14 and row_no = 10 and shift_no = 1;
    82. 

  82. update base_location_info set userdefine4 = '0110S' where row_index = 1 and row_no = 10 and shift_no = 2;
    83. 

  83. update base_location_info set userdefine4 = '0205S' where row_index = 2 and row_no = 5 and shift_no = 2;
    84. 

  84. update base_location_info set userdefine4 = '0206S' where row_index = 2 and row_no = 6 and shift_no = 2;
    85. 

  85. update base_location_info set userdefine4 = '0207S' where row_index = 2 and row_no = 7 and shift_no = 2;
    86. 

  86. update base_location_info set userdefine4 = '0208S' where row_index = 2 and row_no = 8 and shift_no = 2;
    87. 

  87. update base_location_info set userdefine4 = '0210S' where row_index = 2 and row_no = 10 and shift_no = 2;
    88. 

  88. update base_location_info set userdefine4 = '0301S' where row_index = 3 and row_no = 1 and shift_no = 2;
    89. 

  89. update base_location_info set userdefine4 = '0302S' where row_index = 3 and row_no = 2 and shift_no = 2;
    90. 

  90. update base_location_info set userdefine4 = '0303S' where row_index = 3 and row_no = 3 and shift_no = 2;
    91. 

  91. update base_location_info set userdefine4 = '0305S' where row_index = 3 and row_no = 5 and shift_no = 2;
    92. 

  92. update base_location_info set userdefine4 = '0306S' where row_index = 3 and row_no = 6 and shift_no = 2;
    93. 

  93. update base_location_info set userdefine4 = '0307S' where row_index = 3 and row_no = 7 and shift_no = 2;
    94. 

  94. update base_location_info set userdefine4 = '0308S' where row_index = 3 and row_no = 8 and shift_no = 2;
    95. 

  95. update base_location_info set userdefine4 = '0310S' where row_index = 3 and row_no = 10 and shift_no = 2;
    96. 

  96. update base_location_info set userdefine4 = '0401S' where row_index = 4 and row_no = 1 and shift_no = 2;
    97. 

  97. update base_location_info set userdefine4 = '0402S' where row_index = 4 and row_no = 2 and shift_no = 2;
    98. 

  98. update base_location_info set userdefine4 = '0403S' where row_index = 4 and row_no = 3 and shift_no = 2;
    99. 

  99. update base_location_info set userdefine4 = '0405S' where row_index = 4 and row_no = 5 and shift_no = 2;
    100. 

  100. update base_location_info set userdefine4 = '0406S' where row_index = 4 and row_no = 6 and shift_no = 2;
    101. 

  101. update base_location_info set userdefine4 = '0407S' where row_index = 4 and row_no = 7 and shift_no = 2;
    102. 

  102. update base_location_info set userdefine4 = '0408S' where row_index = 4 and row_no = 8 and shift_no = 2;
    103. 

  103. update base_location_info set userdefine4 = '0410S' where row_index = 4 and row_no = 10 and shift_no = 2;
    104. 

  104. update base_location_info set userdefine4 = '0503S' where row_index = 5 and row_no = 3 and shift_no = 2;
    105. 

  105. update base_location_info set userdefine4 = '0505S' where row_index = 5 and row_no = 5 and shift_no = 2;
    106. 

  106. update base_location_info set userdefine4 = '0506S' where row_index = 5 and row_no = 6 and shift_no = 2;
    107. 

  107. update base_location_info set userdefine4 = '0507S' where row_index = 5 and row_no = 7 and shift_no = 2;
    108. 

  108. update base_location_info set userdefine4 = '0508S' where row_index = 5 and row_no = 8 and shift_no = 2;
    109. 

  109. update base_location_info set userdefine4 = '0510S' where row_index = 5 and row_no = 10 and shift_no = 2;
    110. 

  110. update base_location_info set userdefine4 = '0605S' where row_index = 6 and row_no = 5 and shift_no = 2;
    111. 

  111. update base_location_info set userdefine4 = '0606S' where row_index = 6 and row_no = 6 and shift_no = 2;
    112. 

  112. update base_location_info set userdefine4 = '0607S' where row_index = 6 and row_no = 7 and shift_no = 2;
    113. 

  113. update base_location_info set userdefine4 = '0608S' where row_index = 6 and row_no = 8 and shift_no = 2;
    114. 

  114. update base_location_info set userdefine4 = '0610S' where row_index = 6 and row_no = 10 and shift_no = 2;
    115. 

  115. update base_location_info set userdefine4 = '0703S' where row_index = 7 and row_no = 3 and shift_no = 2;
    116. 

  116. update base_location_info set userdefine4 = '0705S' where row_index = 7 and row_no = 5 and shift_no = 2;
    117. 

  117. update base_location_info set userdefine4 = '0706S' where row_index = 7 and row_no = 6 and shift_no = 2;
    118. 

  118. update base_location_info set userdefine4 = '0707S' where row_index = 7 and row_no = 7 and shift_no = 2;
    119. 

  119. update base_location_info set userdefine4 = '0708S' where row_index = 7 and row_no = 8 and shift_no = 2;
    120. 

  120. update base_location_info set userdefine4 = '0710S' where row_index = 7 and row_no = 10 and shift_no = 2;
    121. 

  121. update base_location_info set userdefine4 = '0801S' where row_index = 8 and row_no = 1 and shift_no = 2;
    122. 

  122. update base_location_info set userdefine4 = '0802S' where row_index = 8 and row_no = 2 and shift_no = 2;
    123. 

  123. update base_location_info set userdefine4 = '0803S' where row_index = 8 and row_no = 3 and shift_no = 2;
    124. 

  124. update base_location_info set userdefine4 = '0805S' where row_index = 8 and row_no = 5 and shift_no = 2;
    125. 

  125. update base_location_info set userdefine4 = '0806S' where row_index = 8 and row_no = 6 and shift_no = 2;
    126. 

  126. update base_location_info set userdefine4 = '0807S' where row_index = 8 and row_no = 7 and shift_no = 2;
    127. 

  127. update base_location_info set userdefine4 = '0808S' where row_index = 8 and row_no = 8 and shift_no = 2;
    128. 

  128. update base_location_info set userdefine4 = '0810S' where row_index = 8 and row_no = 10 and shift_no = 2;
    129. 

  129. update base_location_info set userdefine4 = '0901S' where row_index = 9 and row_no = 1 and shift_no = 2;
    130. 

  130. update base_location_info set userdefine4 = '0902S' where row_index = 9 and row_no = 2 and shift_no = 2;
    131. 

  131. update base_location_info set userdefine4 = '0903S' where row_index = 9 and row_no = 3 and shift_no = 2;
    132. 

  132. update base_location_info set userdefine4 = '0905S' where row_index = 9 and row_no = 5 and shift_no = 2;
    133. 

  133. update base_location_info set userdefine4 = '0906S' where row_index = 9 and row_no = 6 and shift_no = 2;
    134. 

  134. update base_location_info set userdefine4 = '0907S' where row_index = 9 and row_no = 7 and shift_no = 2;
    135. 

  135. update base_location_info set userdefine4 = '0908S' where row_index = 9 and row_no = 8 and shift_no = 2;
    136. 

  136. update base_location_info set userdefine4 = '0910S' where row_index = 9 and row_no = 10 and shift_no = 2;
    137. 

  137. update base_location_info set userdefine4 = '1005S' where row_index = 10 and row_no = 5 and shift_no = 2;
    138. 

  138. update base_location_info set userdefine4 = '1006S' where row_index = 10 and row_no = 6 and shift_no = 2;
    139. 

  139. update base_location_info set userdefine4 = '1007S' where row_index = 10 and row_no = 7 and shift_no = 2;
    140. 

  140. update base_location_info set userdefine4 = '1008S' where row_index = 10 and row_no = 8 and shift_no = 2;
    141. 

  141. update base_location_info set userdefine4 = '1010S' where row_index = 10 and row_no = 10 and shift_no = 2;
    142. 

  142. update base_location_info set userdefine4 = '1110S' where row_index = 11 and row_no = 10 and shift_no = 2;
    143. 

  143. update base_location_info set userdefine4 = '1205S' where row_index = 12 and row_no = 5 and shift_no = 2;
    144. 

  144. update base_location_info set userdefine4 = '1206S' where row_index = 12 and row_no = 6 and shift_no = 2;
    145. 

  145. update base_location_info set userdefine4 = '1207S' where row_index = 12 and row_no = 7 and shift_no = 2;
    146. 

  146. update base_location_info set userdefine4 = '1208S' where row_index = 12 and row_no = 8 and shift_no = 2;
    147. 

  147. update base_location_info set userdefine4 = '1210S' where row_index = 12 and row_no = 10 and shift_no = 2;
    148. 

  148. update base_location_info set userdefine4 = '1305S' where row_index = 13 and row_no = 5 and shift_no = 2;
    149. 

  149. update base_location_info set userdefine4 = '1306S' where row_index = 13 and row_no = 6 and shift_no = 2;
    150. 

  150. update base_location_info set userdefine4 = '1307S' where row_index = 13 and row_no = 7 and shift_no = 2;
    151. 

  151. update base_location_info set userdefine4 = '1308S' where row_index = 13 and row_no = 8 and shift_no = 2;
    152. 

  152. update base_location_info set userdefine4 = '1310S' where row_index = 13 and row_no = 10 and shift_no = 2;
    153. 

  153. update base_location_info set userdefine4 = '1405S' where row_index = 14 and row_no = 5 and shift_no = 2;
    154. 

  154. update base_location_info set userdefine4 = '1406S' where row_index = 14 and row_no = 6 and shift_no = 2;
    155. 

  155. update base_location_info set userdefine4 = '1407S' where row_index = 14 and row_no = 7 and shift_no = 2;
    156. 

  156. update base_location_info set userdefine4 = '1408S' where row_index = 14 and row_no = 8 and shift_no = 2;
    157. 

  157. update base_location_info set userdefine4 = '1410S' where row_index = 14 and row_no = 10 and shift_no = 2;
    158. 

  158. update base_location_info set userdefine4 = '0110S' where row_index = 1 and row_no = 10 and shift_no = 3;
    159. 

  159. update base_location_info set userdefine4 = '0205S' where row_index = 2 and row_no = 5 and shift_no = 3;
    160. 

  160. update base_location_info set userdefine4 = '0206S' where row_index = 2 and row_no = 6 and shift_no = 3;
    161. 

  161. update base_location_info set userdefine4 = '0207S' where row_index = 2 and row_no = 7 and shift_no = 3;
    162. 

  162. update base_location_info set userdefine4 = '0208S' where row_index = 2 and row_no = 8 and shift_no = 3;
    163. 

  163. update base_location_info set userdefine4 = '0210S' where row_index = 2 and row_no = 10 and shift_no = 3;
    164. 

  164. update base_location_info set userdefine4 = '0301S' where row_index = 3 and row_no = 1 and shift_no = 3;
    165. 

  165. update base_location_info set userdefine4 = '0302S' where row_index = 3 and row_no = 2 and shift_no = 3;
    166. 

  166. update base_location_info set userdefine4 = '0303S' where row_index = 3 and row_no = 3 and shift_no = 3;
    167. 

  167. update base_location_info set userdefine4 = '0305S' where row_index = 3 and row_no = 5 and shift_no = 3;
    168. 

  168. update base_location_info set userdefine4 = '0306S' where row_index = 3 and row_no = 6 and shift_no = 3;
    169. 

  169. update base_location_info set userdefine4 = '0307S' where row_index = 3 and row_no = 7 and shift_no = 3;
    170. 

  170. update base_location_info set userdefine4 = '0308S' where row_index = 3 and row_no = 8 and shift_no = 3;
    171. 

  171. update base_location_info set userdefine4 = '0310S' where row_index = 3 and row_no = 10 and shift_no = 3;
    172. 

  172. update base_location_info set userdefine4 = '0401S' where row_index = 4 and row_no = 1 and shift_no = 3;
    173. 

  173. update base_location_info set userdefine4 = '0402S' where row_index = 4 and row_no = 2 and shift_no = 3;
    174. 

  174. update base_location_info set userdefine4 = '0403S' where row_index = 4 and row_no = 3 and shift_no = 3;
    175. 

  175. update base_location_info set userdefine4 = '0405S' where row_index = 4 and row_no = 5 and shift_no = 3;
    176. 

  176. update base_location_info set userdefine4 = '0406S' where row_index = 4 and row_no = 6 and shift_no = 3;
    177. 

  177. update base_location_info set userdefine4 = '0407S' where row_index = 4 and row_no = 7 and shift_no = 3;
    178. 

  178. update base_location_info set userdefine4 = '0408S' where row_index = 4 and row_no = 8 and shift_no = 3;
    179. 

  179. update base_location_info set userdefine4 = '0410S' where row_index = 4 and row_no = 10 and shift_no = 3;
    180. 

  180. update base_location_info set userdefine4 = '0503S' where row_index = 5 and row_no = 3 and shift_no = 3;
    181. 

  181. update base_location_info set userdefine4 = '0505S' where row_index = 5 and row_no = 5 and shift_no = 3;
    182. 

  182. update base_location_info set userdefine4 = '0506S' where row_index = 5 and row_no = 6 and shift_no = 3;
    183. 

  183. update base_location_info set userdefine4 = '0507S' where row_index = 5 and row_no = 7 and shift_no = 3;
    184. 

  184. update base_location_info set userdefine4 = '0508S' where row_index = 5 and row_no = 8 and shift_no = 3;
    185. 

  185. update base_location_info set userdefine4 = '0510S' where row_index = 5 and row_no = 10 and shift_no = 3;
    186. 

  186. update base_location_info set userdefine4 = '0605S' where row_index = 6 and row_no = 5 and shift_no = 3;
    187. 

  187. update base_location_info set userdefine4 = '0606S' where row_index = 6 and row_no = 6 and shift_no = 3;
    188. 

  188. update base_location_info set userdefine4 = '0607S' where row_index = 6 and row_no = 7 and shift_no = 3;
    189. 

  189. update base_location_info set userdefine4 = '0608S' where row_index = 6 and row_no = 8 and shift_no = 3;
    190. 

  190. update base_location_info set userdefine4 = '0610S' where row_index = 6 and row_no = 10 and shift_no = 3;
    191. 

  191. update base_location_info set userdefine4 = '0703S' where row_index = 7 and row_no = 3 and shift_no = 3;
    192. 

  192. update base_location_info set userdefine4 = '0705S' where row_index = 7 and row_no = 5 and shift_no = 3;
    193. 

  193. update base_location_info set userdefine4 = '0706S' where row_index = 7 and row_no = 6 and shift_no = 3;
    194. 

  194. update base_location_info set userdefine4 = '0707S' where row_index = 7 and row_no = 7 and shift_no = 3;
    195. 

  195. update base_location_info set userdefine4 = '0708S' where row_index = 7 and row_no = 8 and shift_no = 3;
    196. 

  196. update base_location_info set userdefine4 = '0710S' where row_index = 7 and row_no = 10 and shift_no = 3;
    197. 

  197. update base_location_info set userdefine4 = '0801S' where row_index = 8 and row_no = 1 and shift_no = 3;
    198. 

  198. update base_location_info set userdefine4 = '0802S' where row_index = 8 and row_no = 2 and shift_no = 3;
    199. 

  199. update base_location_info set userdefine4 = '0803S' where row_index = 8 and row_no = 3 and shift_no = 3;
    200. 

  200. update base_location_info set userdefine4 = '0805S' where row_index = 8 and row_no = 5 and shift_no = 3;
    201. 

  201. update base_location_info set userdefine4 = '0806S' where row_index = 8 and row_no = 6 and shift_no = 3;
    202. 

  202. update base_location_info set userdefine4 = '0807S' where row_index = 8 and row_no = 7 and shift_no = 3;
    203. 

  203. update base_location_info set userdefine4 = '0808S' where row_index = 8 and row_no = 8 and shift_no = 3;
    204. 

  204. update base_location_info set userdefine4 = '0810S' where row_index = 8 and row_no = 10 and shift_no = 3;
    205. 

  205. update base_location_info set userdefine4 = '0901S' where row_index = 9 and row_no = 1 and shift_no = 3;
    206. 

  206. update base_location_info set userdefine4 = '0902S' where row_index = 9 and row_no = 2 and shift_no = 3;
    207. 

  207. update base_location_info set userdefine4 = '0903S' where row_index = 9 and row_no = 3 and shift_no = 3;
    208. 

  208. update base_location_info set userdefine4 = '0905S' where row_index = 9 and row_no = 5 and shift_no = 3;
    209. 

  209. update base_location_info set userdefine4 = '0906S' where row_index = 9 and row_no = 6 and shift_no = 3;
    210. 

  210. update base_location_info set userdefine4 = '0907S' where row_index = 9 and row_no = 7 and shift_no = 3;
    211. 

  211. update base_location_info set userdefine4 = '0908S' where row_index = 9 and row_no = 8 and shift_no = 3;
    212. 

  212. update base_location_info set userdefine4 = '0910S' where row_index = 9 and row_no = 10 and shift_no = 3;
    213. 

  213. update base_location_info set userdefine4 = '1005S' where row_index = 10 and row_no = 5 and shift_no = 3;
    214. 

  214. update base_location_info set userdefine4 = '1006S' where row_index = 10 and row_no = 6 and shift_no = 3;
    215. 

  215. update base_location_info set userdefine4 = '1007S' where row_index = 10 and row_no = 7 and shift_no = 3;
    216. 

  216. update base_location_info set userdefine4 = '1008S' where row_index = 10 and row_no = 8 and shift_no = 3;
    217. 

  217. update base_location_info set userdefine4 = '1010S' where row_index = 10 and row_no = 10 and shift_no = 3;
    218. 

  218. update base_location_info set userdefine4 = '1110S' where row_index = 11 and row_no = 10 and shift_no = 3;
    219. 

  219. update base_location_info set userdefine4 = '1205S' where row_index = 12 and row_no = 5 and shift_no = 3;
    220. 

  220. update base_location_info set userdefine4 = '1206S' where row_index = 12 and row_no = 6 and shift_no = 3;
    221. 

  221. update base_location_info set userdefine4 = '1207S' where row_index = 12 and row_no = 7 and shift_no = 3;
    222. 

  222. update base_location_info set userdefine4 = '1208S' where row_index = 12 and row_no = 8 and shift_no = 3;
    223. 

  223. update base_location_info set userdefine4 = '1210S' where row_index = 12 and row_no = 10 and shift_no = 3;
    224. 

  224. update base_location_info set userdefine4 = '1305S' where row_index = 13 and row_no = 5 and shift_no = 3;
    225. 

  225. update base_location_info set userdefine4 = '1306S' where row_index = 13 and row_no = 6 and shift_no = 3;
    226. 

  226. update base_location_info set userdefine4 = '1307S' where row_index = 13 and row_no = 7 and shift_no = 3;
    227. 

  227. update base_location_info set userdefine4 = '1308S' where row_index = 13 and row_no = 8 and shift_no = 3;
    228. 

  228. update base_location_info set userdefine4 = '1310S' where row_index = 13 and row_no = 10 and shift_no = 3;
    229. 

  229. update base_location_info set userdefine4 = '1405S' where row_index = 14 and row_no = 5 and shift_no = 3;
    230. 

  230. update base_location_info set userdefine4 = '1406S' where row_index = 14 and row_no = 6 and shift_no = 3;
    231. 

  231. update base_location_info set userdefine4 = '1407S' where row_index = 14 and row_no = 7 and shift_no = 3;
    232. 

  232. update base_location_info set userdefine4 = '1408S' where row_index = 14 and row_no = 8 and shift_no = 3;
    233. 

  233. update base_location_info set userdefine4 = '1410S' where row_index = 14 and row_no = 10 and shift_no = 3;
    234.