updatepro1.0.sql 3.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128
  1. REPLACE INTO `zt_grouppriv` (`group`, `module`, `method`) VALUES
  2. (1,'pivot','bugAssignSummary'),
  3. (1,'pivot','bugSummary'),
  4. (1,'pivot','build'),
  5. (1,'pivot','casesrun'),
  6. (1,'pivot','projectSummary'),
  7. (1,'pivot','projectWorkload'),
  8. (1,'pivot','reportExport'),
  9. (1,'pivot','roadmap'),
  10. (1,'pivot','storyLinkedBug'),
  11. (1,'pivot','testcase'),
  12. (1,'pivot','workAssignSummary'),
  13. (1,'pivot','workSummary'),
  14. (2,'pivot','bugAssignSummary'),
  15. (2,'pivot','bugSummary'),
  16. (2,'pivot','build'),
  17. (2,'pivot','casesrun'),
  18. (2,'pivot','projectSummary'),
  19. (2,'pivot','projectWorkload'),
  20. (2,'pivot','roadmap'),
  21. (2,'pivot','storyLinkedBug'),
  22. (2,'pivot','testcase'),
  23. (2,'pivot','workAssignSummary'),
  24. (2,'pivot','workSummary'),
  25. (3,'pivot','bugAssignSummary'),
  26. (3,'pivot','bugSummary'),
  27. (3,'pivot','build'),
  28. (3,'pivot','casesrun'),
  29. (3,'pivot','projectSummary'),
  30. (3,'pivot','projectWorkload'),
  31. (3,'pivot','roadmap'),
  32. (3,'pivot','storyLinkedBug'),
  33. (3,'pivot','testcase'),
  34. (3,'pivot','workAssignSummary'),
  35. (3,'pivot','workSummary'),
  36. (4,'pivot','bugAssignSummary'),
  37. (4,'pivot','bugSummary'),
  38. (4,'pivot','build'),
  39. (4,'pivot','casesrun'),
  40. (4,'pivot','projectSummary'),
  41. (4,'pivot','projectWorkload'),
  42. (4,'pivot','reportExport'),
  43. (4,'pivot','roadmap'),
  44. (4,'pivot','storyLinkedBug'),
  45. (4,'pivot','testcase'),
  46. (4,'pivot','workAssignSummary'),
  47. (4,'pivot','workSummary'),
  48. (5,'pivot','bugAssignSummary'),
  49. (5,'pivot','bugSummary'),
  50. (5,'pivot','build'),
  51. (5,'pivot','casesrun'),
  52. (5,'pivot','projectSummary'),
  53. (5,'pivot','projectWorkload'),
  54. (5,'pivot','reportExport'),
  55. (5,'pivot','roadmap'),
  56. (5,'pivot','storyLinkedBug'),
  57. (5,'pivot','testcase'),
  58. (5,'pivot','workAssignSummary'),
  59. (5,'pivot','workSummary'),
  60. (6,'pivot','bugAssignSummary'),
  61. (6,'pivot','bugSummary'),
  62. (6,'pivot','build'),
  63. (6,'pivot','casesrun'),
  64. (6,'pivot','projectSummary'),
  65. (6,'pivot','projectWorkload'),
  66. (6,'pivot','roadmap'),
  67. (6,'pivot','storyLinkedBug'),
  68. (6,'pivot','testcase'),
  69. (6,'pivot','workAssignSummary'),
  70. (6,'pivot','workSummary'),
  71. (7,'pivot','bugAssignSummary'),
  72. (7,'pivot','bugSummary'),
  73. (7,'pivot','build'),
  74. (7,'pivot','casesrun'),
  75. (7,'pivot','projectSummary'),
  76. (7,'pivot','projectWorkload'),
  77. (7,'pivot','reportExport'),
  78. (7,'pivot','roadmap'),
  79. (7,'pivot','storyLinkedBug'),
  80. (7,'pivot','testcase'),
  81. (7,'pivot','workAssignSummary'),
  82. (7,'pivot','workSummary'),
  83. (8,'pivot','bugAssignSummary'),
  84. (8,'pivot','bugSummary'),
  85. (8,'pivot','build'),
  86. (8,'pivot','casesrun'),
  87. (8,'pivot','projectSummary'),
  88. (8,'pivot','projectWorkload'),
  89. (8,'pivot','roadmap'),
  90. (8,'pivot','storyLinkedBug'),
  91. (8,'pivot','testcase'),
  92. (8,'pivot','workAssignSummary'),
  93. (8,'pivot','workSummary'),
  94. (9,'pivot','bugAssignSummary'),
  95. (9,'pivot','bugSummary'),
  96. (9,'pivot','build'),
  97. (9,'pivot','casesrun'),
  98. (9,'pivot','projectSummary'),
  99. (9,'pivot','projectWorkload'),
  100. (9,'pivot','reportExport'),
  101. (9,'pivot','roadmap'),
  102. (9,'pivot','storyLinkedBug'),
  103. (9,'pivot','testcase'),
  104. (9,'pivot','workAssignSummary'),
  105. (9,'pivot','workSummary'),
  106. (10,'pivot','bugAssignSummary'),
  107. (10,'pivot','bugSummary'),
  108. (10,'pivot','build'),
  109. (10,'pivot','casesrun'),
  110. (10,'pivot','projectSummary'),
  111. (10,'pivot','projectWorkload'),
  112. (10,'pivot','reportExport'),
  113. (10,'pivot','roadmap'),
  114. (10,'pivot','storyLinkedBug'),
  115. (10,'pivot','testcase'),
  116. (10,'pivot','workAssignSummary'),
  117. (10,'pivot','workSummary'),
  118. (11,'pivot','bugAssignSummary'),
  119. (11,'pivot','bugSummary'),
  120. (11,'pivot','build'),
  121. (11,'pivot','casesrun'),
  122. (11,'pivot','projectSummary'),
  123. (11,'pivot','projectWorkload'),
  124. (11,'pivot','roadmap'),
  125. (11,'pivot','storyLinkedBug'),
  126. (11,'pivot','testcase'),
  127. (11,'pivot','workAssignSummary'),
  128. (11,'pivot','workSummary');