data.sql 6.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182
  1. delete
  2. from `it_user`;
  3. insert into `it_user` (`user`, `display_name`, `password`, `phone_number`, `role_id`)
  4. values ('user01', '用户01', '123456', '13000000000', 1);
  5. insert into `it_user` (`user`, `display_name`, `password`, `phone_number`, `role_id`)
  6. values ('user02', '用户02', '123456', '13000000001', 1);
  7. insert into `it_user` (`user`, `display_name`, `password`, `phone_number`, `role_id`)
  8. values ('user03', '用户03', '123456', '13000000002', 1);
  9. insert into `it_user` (`user`, `display_name`, `password`, `phone_number`, `role_id`)
  10. values ('yw01', '运维01', '789456', '13000000003', 2);
  11. insert into `it_user` (`user`, `display_name`, `password`, `phone_number`, `role_id`)
  12. values ('yw02', '运维02', '789456', '13000000004', 2);
  13. insert into `it_user` (`user`, `display_name`, `password`, `phone_number`, `role_id`)
  14. values ('yw03', '运维03', '789456', '13000000005', 2);
  15. insert into `it_user` (`user`, `display_name`, `password`, `phone_number`, `role_id`)
  16. values ('yw04', '运维04', '789456', '13000000006', 2);
  17. insert into `it_user` (`user`, `display_name`, `password`, `phone_number`, `role_id`)
  18. values ('admin01', '管理员01', '456123', '13000000007', 3);
  19. insert into `it_user` (`user`, `display_name`, `password`, `phone_number`, `role_id`)
  20. values ('admin02', '管理员02', '456123', '13000000007', 3);
  21. delete
  22. from `it_role`;
  23. insert into `it_role` (`role_id`, `name`)
  24. values (1, '普通用户'),
  25. (2, 'IT运维人员'),
  26. (3, '系统管理员')
  27. ;
  28. delete
  29. from `it_sys`;
  30. insert into `it_sys` (`sys_id`, `name`)
  31. values (1, '工单'),
  32. (2, '监控'),
  33. (3, '资产'),
  34. (4, '管理')
  35. ;
  36. delete
  37. from `it_role_permission`;
  38. insert into `it_role_permission` (`role_id`, `sys_id`)
  39. values (1, 1),
  40. (2, 1),
  41. (2, 2),
  42. (2, 3),
  43. (3, 1),
  44. (3, 2),
  45. (3, 3),
  46. (3, 4)
  47. ;
  48. delete
  49. from `it_resource_group`;
  50. insert into `it_resource_group` (group_id, group_name)
  51. values (1, '服务器'),
  52. (2, '交换机'),
  53. (3, '存储')
  54. ;
  55. delete
  56. from `it_resource_attribute`;
  57. insert into `it_resource_attribute`
  58. (attribute_id, group_id, attribute_name, display_name, attribute_type, value_type, default_value, options)
  59. values (1, 1, 'name', '服务器名称', 0, 0, '', ''),
  60. (2, 1, 'model', '型号', 0, 0, '', ''),
  61. (3, 1, 'location', '服务器位置', 0, 0, '', ''),
  62. (4, 1, 'hostname', '主机名', 0, 0, '', ''),
  63. (5, 1, 'cpu', 'CPU型号', 1, 0, '', ''),
  64. (6, 1, 'cpu_cores', 'CPU核心数量', 0, 1, '', ''),
  65. (9, 2, 'name', '交换机名称', 0, 0, '', ''),
  66. (10, 2, 'model', '交换机型号', 0, 0, '', ''),
  67. (11, 2, 'port', '端口', 1, 0, '', ''),
  68. (12, 3, 'name', '存储名称', 0, 0, '', ''),
  69. (13, 3, 'company', '厂商', 2, 0, '', 'DELL,HP,HUAWEI'),
  70. (14, 3, 'expire', '是否过保', 2, 0, '否', '是,否'),
  71. (15, 3, 'disk', '磁盘', 1, 0, '', ''),
  72. (16, 1, 'company', '厂商', 2, 0, '', '戴尔,惠普,华为,浪潮'),
  73. (17, 1, 'memory', '内存', 1, 0, '', ''),
  74. (18, 1, 'room_location', '机房位置', 2, 0, '', '深圳,广州,北京,宁夏,香港')
  75. ;
  76. delete
  77. from `it_resource_type`;
  78. insert into `it_resource_type` (type_id, type_name, parent_type_id)
  79. values (1, '基础设备', -1),
  80. (2, '服务器', 1),
  81. (3, '交换机', 1),
  82. (4, '存储设备', -1),
  83. (5, '分布式存储', 4)
  84. ;
  85. delete
  86. from `it_resource`;
  87. insert into `it_resource` (resource_id, resource_name, type_id, group_id, remark)
  88. values (1, '服务器001', 2, 1, ''),
  89. (2, '服务器002', 2, 1, ''),
  90. (3, '服务器003', 2, 1, ''),
  91. (4, '交换机001', 3, 2, '全万兆交换机'),
  92. (5, '存储001', 5, 3, '1P'),
  93. (6, '存储002', 5, 3, '18T')
  94. ;
  95. delete
  96. from `it_resource_value`;
  97. insert into `it_resource_value` (resource_id, attribute_id, attribute_value)
  98. values (1, 1, '服务器111'),
  99. (1, 2, 'HP'),
  100. (1, 3, '北京'),
  101. (1, 4, 'server-001'),
  102. (2, 1, '服务器222'),
  103. (2, 2, 'DELL'),
  104. (2, 3, '北京'),
  105. (2, 4, 'server-002'),
  106. (2, 5, 'Intel'),
  107. (3, 9, '交换机111'),
  108. (3, 10, 'HUAWEI'),
  109. (3, 11, '{"column":["端口","可用"],"data":[["COM1","是"],["COM2","否"]]}'),
  110. (3, 12, '存储111'),
  111. (3, 13, 'H3C'),
  112. (1, 18, '北京'),
  113. (1, 17,
  114. '{"column":["插槽","品牌","规格","大小"],"data":[["1","三星","DDR4","128G"],["2","三星","DDR4","128G"],["3","三星","DDR4","128G"],["4","三星","DDR4","128G"],["5","三星","DDR4","128G"],["6","三星","DDR4","128G"],["7","三星","DDR4","128G"],["8","三星","DDR4","128G"]]}')
  115. ;
  116. delete
  117. from `it_monitor_template`;
  118. INSERT INTO `it_monitor_template` (`template_id`, `template_name`)
  119. VALUES (1, '模板1');
  120. INSERT INTO `it_monitor_template` (`template_id`, `template_name`)
  121. VALUES (2, '模板2');
  122. INSERT INTO `it_monitor_template` (`template_id`, `template_name`)
  123. VALUES (3, '模板3');
  124. INSERT INTO `it_monitor_template` (`template_id`, `template_name`)
  125. VALUES (4, '模板4');
  126. delete
  127. from `it_monitor_resource_group`;
  128. INSERT INTO `it_monitor_resource_group` (`group_id`, `group_name`)
  129. VALUES (1, '资源组1');
  130. INSERT INTO `it_monitor_resource_group` (`group_id`, `group_name`)
  131. VALUES (2, '资源组2');
  132. INSERT INTO `it_monitor_resource_group` (`group_id`, `group_name`)
  133. VALUES (3, '资源组3');
  134. delete
  135. from `it_monitor_resource`;
  136. INSERT INTO `it_monitor_resource` (`resource_id`, `template_id`, `agent_id`, `resource_group_id`, `resource_name`)
  137. VALUES (1, 1, 1, 1, '资源1');
  138. INSERT INTO `it_monitor_resource` (`resource_id`, `template_id`, `agent_id`, `resource_group_id`, `resource_name`)
  139. VALUES (2, 1, 2, 2, '资源2');
  140. delete
  141. from `it_monitor_agent_key`;
  142. INSERT INTO `it_monitor_agent_key` (`agent_key_id`, `key`, `remark`)
  143. VALUES (1, '123456', '备注1');
  144. INSERT INTO `it_monitor_agent_key` (`agent_key_id`, `key`, `remark`)
  145. VALUES (2, '654321', '');
  146. delete
  147. from `it_monitor_agent`;
  148. INSERT INTO `it_monitor_agent` (`agent_id`, `agent_name`, `agent_ip`, `agent_key_id`)
  149. VALUES (1, 'agent1_local', '127.0.0.1', 1);
  150. delete
  151. from `it_monitor_item_group`;
  152. INSERT INTO `it_monitor_item_group` (`group_id`, `group_name`, `template_id`, `interval`, `top_item_id`)
  153. VALUES (1, '指标组1', 1, 5, -1);
  154. delete
  155. from `it_monitor_item`;
  156. INSERT INTO `it_monitor_item` (`item_id`, `item_name`, `item_key_name`, `item_group_id`, `item_type`)
  157. VALUES (1, 'item1', 'group1.item1', 1, 1);
  158. INSERT INTO `it_monitor_item` (`item_id`, `item_name`, `item_key_name`, `item_group_id`, `item_type`)
  159. VALUES (2, 'item2', 'group1.item2', 1, 2);
  160. delete
  161. from `it_monitor_threshold`;
  162. INSERT INTO `it_monitor_threshold` (`item_id`, `resource_id`, `alarm_type`, `threshold_type`, `threshold`, `times`)
  163. VALUES (1, 1, 0, 2, '50', 5);