1
0

j_wms_operate_u_user_role_resource_relation.sql 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161
  1. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('1', '1', 'admin');
  2. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('11', '11', 'admin');
  3. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('1101', '1101', 'admin');
  4. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('1102', '1102', 'admin');
  5. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('12', '12', 'admin');
  6. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('1201', '1201', 'admin');
  7. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('1202', '1202', 'admin');
  8. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('1203', '1203', 'admin');
  9. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2', '2', 'admin');
  10. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('21', '21', 'admin');
  11. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2101', '2101', 'admin');
  12. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2102', '2102', 'admin');
  13. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2103', '2103', 'admin');
  14. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2104', '2104', 'admin');
  15. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2105', '2105', 'admin');
  16. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2106', '2106', 'admin');
  17. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2107', '2107', 'admin');
  18. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2108', '2108', 'admin');
  19. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2109', '2109', 'admin');
  20. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2110', '2110', 'admin');
  21. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2111', '2111', 'admin');
  22. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('22', '22', 'admin');
  23. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2201', '2201', 'admin');
  24. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2202', '2202', 'admin');
  25. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2203', '2203', 'admin');
  26. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2204', '2204', 'admin');
  27. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2205', '2205', 'admin');
  28. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('23', '23', 'admin');
  29. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2301', '2301', 'admin');
  30. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2302', '2302', 'admin');
  31. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2303', '2303', 'admin');
  32. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('24', '24', 'admin');
  33. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2401', '2401', 'admin');
  34. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2402', '2402', 'admin');
  35. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2403', '2403', 'admin');
  36. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2404', '2404', 'admin');
  37. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2405', '2405', 'admin');
  38. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2406', '2406', 'admin');
  39. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('25', '25', 'admin');
  40. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2501', '2501', 'admin');
  41. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('2502', '2502', 'admin');
  42. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('3', '3', 'admin');
  43. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('31', '31', 'admin');
  44. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('3101', '3101', 'admin');
  45. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('3102', '3102', 'admin');
  46. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('3103', '3103', 'admin');
  47. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('3104', '3104', 'admin');
  48. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('3105', '3105', 'admin');
  49. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('3106', '3106', 'admin');
  50. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('3107', '3107', 'admin');
  51. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('32', '32', 'admin');
  52. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('3201', '3201', 'admin');
  53. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('3202', '3202', 'admin');
  54. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('3203', '3203', 'admin');
  55. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('3204', '3204', 'admin');
  56. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('3205', '3205', 'admin');
  57. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('3206', '3206', 'admin');
  58. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('4', '4', 'admin');
  59. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('41', '41', 'admin');
  60. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('4101', '4101', 'admin');
  61. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('4102', '4102', 'admin');
  62. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('4103', '4103', 'admin');
  63. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('4104', '4104', 'admin');
  64. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('4105', '4105', 'admin');
  65. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('4107', '4107', 'admin');
  66. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('42', '42', 'admin');
  67. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('4201', '4201', 'admin');
  68. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('4202', '4202', 'admin');
  69. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('43', '43', 'admin');
  70. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('4301', '4301', 'admin');
  71. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('4302', '4302', 'admin');
  72. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('4303', '4303', 'admin');
  73. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('4304', '4304', 'admin');
  74. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('44', '44', 'admin');
  75. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('4401', '4401', 'admin');
  76. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('4402', '4402', 'admin');
  77. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5', '5', 'admin');
  78. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('51', '51', 'admin');
  79. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5101', '5101', 'admin');
  80. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510101', '510101', 'admin');
  81. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510102', '510102', 'admin');
  82. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510103', '510103', 'admin');
  83. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510104', '510104', 'admin');
  84. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510105', '510105', 'admin');
  85. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510106', '510106', 'admin');
  86. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510107', '510107', 'admin');
  87. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510108', '510108', 'admin');
  88. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510109', '510109', 'admin');
  89. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510110', '510110', 'admin');
  90. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510111', '510111', 'admin');
  91. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510112', '510112', 'admin');
  92. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510113', '510113', 'admin');
  93. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510114', '510114', 'admin');
  94. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510115', '510115', 'admin');
  95. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510116', '510116', 'admin');
  96. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510117', '510117', 'admin');
  97. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510118', '510118', 'admin');
  98. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510119', '510119', 'admin');
  99. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510120', '510120', 'admin');
  100. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('510121', '510121', 'admin');
  101. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5102', '5102', 'admin');
  102. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5103', '5103', 'admin');
  103. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5104', '5104', 'admin');
  104. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5105', '5105', 'admin');
  105. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5106', '5106', 'admin');
  106. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5107', '5107', 'admin');
  107. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5108', '5108', 'admin');
  108. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5109', '5109', 'admin');
  109. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5110', '5110', 'admin');
  110. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5111', '5111', 'admin');
  111. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5112', '5112', 'admin');
  112. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5113', '5113', 'admin');
  113. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5114', '5114', 'admin');
  114. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5115', '5115', 'admin');
  115. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5116', '5116', 'admin');
  116. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('52', '52', 'admin');
  117. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5201', '5201', 'admin');
  118. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5202', '5202', 'admin');
  119. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5203', '5203', 'admin');
  120. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5204', '5204', 'admin');
  121. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5205', '5205', 'admin');
  122. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5206', '5206', 'admin');
  123. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5207', '5207', 'admin');
  124. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('53', '53', 'admin');
  125. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5301', '5301', 'admin');
  126. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5302', '5302', 'admin');
  127. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5303', '5303', 'admin');
  128. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5304', '5304', 'admin');
  129. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5305', '5305', 'admin');
  130. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('54', '54', 'admin');
  131. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5401', '5401', 'admin');
  132. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5402', '5402', 'admin');
  133. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5403', '5403', 'admin');
  134. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('55', '55', 'admin');
  135. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5501', '5501', 'admin');
  136. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5502', '5502', 'admin');
  137. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5503', '5503', 'admin');
  138. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5504', '5504', 'admin');
  139. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5505', '5505', 'admin');
  140. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5506', '5506', 'admin');
  141. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5507', '5507', 'admin');
  142. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5508', '5508', 'admin');
  143. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('56', '56', 'admin');
  144. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5601', '5601', 'admin');
  145. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5602', '5602', 'admin');
  146. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5603', '5603', 'admin');
  147. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('5604', '5604', 'admin');
  148. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('6', '6', 'admin');
  149. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('61', '61', 'admin');
  150. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('6101', '6101', 'admin');
  151. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('6102', '6102', 'admin');
  152. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('6103', '6103', 'admin');
  153. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('6104', '6104', 'admin');
  154. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('6106', '6106', 'admin');
  155. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('62', '62', 'admin');
  156. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('6201', '6201', 'admin');
  157. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('9', '9', 'admin');
  158. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('91', '91', 'admin');
  159. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('911', '911', 'admin');
  160. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('912', '912', 'admin');
  161. INSERT INTO `j-wms-operate`.u_user_role_resource_relation (id, resource_code, role_code) VALUES ('92', '92', 'admin');