conference_room.sql 53 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057
  1. /*
  2. Navicat MySQL Data Transfer
  3. Source Server : localhost_3306
  4. Source Server Version : 50635
  5. Source Host : localhost:3306
  6. Source Database : conference_room
  7. Target Server Type : MYSQL
  8. Target Server Version : 50635
  9. File Encoding : 65001
  10. Date: 2019-02-12 22:28:13
  11. */
  12. SET FOREIGN_KEY_CHECKS=0;
  13. -- ----------------------------
  14. -- Table structure for reservation
  15. -- ----------------------------
  16. DROP TABLE IF EXISTS `reservation`;
  17. CREATE TABLE `reservation` (
  18. `id` int(11) NOT NULL AUTO_INCREMENT,
  19. `room_id` int(11) DEFAULT NULL,
  20. `user` varchar(32) DEFAULT NULL,
  21. `mobile` varchar(20) DEFAULT NULL,
  22. `date` date DEFAULT NULL,
  23. `begintime` time DEFAULT NULL,
  24. `endtime` time DEFAULT NULL,
  25. `mark` varchar(10) DEFAULT NULL,
  26. -- 主题
  27. `subject` varchar(60) DEFAULT NULL,
  28. -- 部门
  29. `department` varchar(60) DEFAULT NULL,
  30. -- 会议纪要
  31. `summary` varchar(5000) DEFAULT NULL,
  32. PRIMARY KEY (`id`),
  33. KEY `fk_reservation_room` (`room_id`),
  34. CONSTRAINT `fk_reservation_room` FOREIGN KEY (`room_id`) REFERENCES `room` (`id`)
  35. ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
  36. -- ----------------------------
  37. -- Records of reservation
  38. -- ----------------------------
  39. -- ---------------------------------------------------
  40. -- Table structure for reservation_users--参会人员
  41. -- ---------------------------------------------------
  42. Drop TABLE IF EXISTS `reservation_users`;
  43. CREATE Table `reservation_users`(
  44. `id` int(11) NOT NULL AUTO_INCREMENT,
  45. `reservation_id` int(11) NOT NULL,
  46. `user_id` varchar(32) NOT NULL,
  47. PRIMARY KEY (`id`),
  48. KEY `fk_reservation_users_reservation` (reservation_id),
  49. CONSTRAINT `fk_reservation_users_reservation` FOREIGN KEY (`reservation_id`) REFERENCES `reservation` (`id`),
  50. KEY `fk_reservation_users_user` (user_id),
  51. CONSTRAINT `fk_reservation_users_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
  52. )ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
  53. -- ----------------------------
  54. -- Records of reservation_users
  55. -- ----------------------------
  56. -- ---------------------------------------------------
  57. -- Table structure for reservation_resource--会议资料
  58. -- ---------------------------------------------------
  59. Drop TABLE IF EXISTS `reservation_resource`;
  60. CREATE TABLE `reservation_resource` (
  61. `id` int(11) NOT NULL AUTO_INCREMENT,
  62. `reservation_id` int(11) NOT NULL,
  63. -- 资料名称
  64. `name` varchar(60) NOT NULL,
  65. -- 资料路径
  66. `path` varchar(100) NOT NULL,
  67. PRIMARY KEY (`id`),
  68. KEY `fk_reservation_users_room` (reservation_id),
  69. CONSTRAINT `fk_reservation_users_room` FOREIGN KEY (`reservation_id`) REFERENCES `reservation` (`id`)
  70. )ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
  71. -- ----------------------------
  72. -- Records of reservation_resource
  73. -- ----------------------------
  74. -- ----------------------------
  75. -- Table structure for role
  76. -- ----------------------------
  77. DROP TABLE IF EXISTS `role`;
  78. CREATE TABLE `role` (
  79. `role_id` int(11) NOT NULL,
  80. `role_name` varchar(50) DEFAULT NULL,
  81. PRIMARY KEY (`role_id`)
  82. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  83. -- ----------------------------
  84. -- Records of role
  85. -- ----------------------------
  86. INSERT INTO `role` VALUES ('1', 'admin');
  87. INSERT INTO `role` VALUES ('2', 'ordinary');
  88. -- ----------------------------
  89. -- Table structure for room
  90. -- ----------------------------
  91. DROP TABLE IF EXISTS `room`;
  92. CREATE TABLE `room` (
  93. `id` int(11) NOT NULL AUTO_INCREMENT,
  94. `name` varchar(60) NOT NULL,
  95. `message` varchar(200) DEFAULT NULL,
  96. -- 物理位置
  97. `position` varchar(200) DEFAULT NULL,
  98. -- 会议室图片
  99. `image` varchar(200) DEFAULT NULL,
  100. -- 容量
  101. `capacity` int(11) DEFAULT NULL,
  102. -- 会议室区域
  103. `region` varchar(60) DEFAULT NULL,
  104. -- 会议室二维码
  105. `code` varchar(60) DEFAULT NULL,
  106. PRIMARY KEY (`id`)
  107. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
  108. -- ----------------------------
  109. -- Records of room
  110. -- ----------------------------
  111. INSERT INTO `room`(id,name,message) VALUES ('1', 'Cpeco会议室', '小会议室,适合十人小型会议,含多媒体');
  112. INSERT INTO `room`(id,name,message) VALUES ('2', 'Meos会议室', '大型会议室,可使用多媒体,适合开会、讲座');
  113. INSERT INTO `room`(id,name,message) VALUES ('3', 'Wellzoom会议室', '小会议室,适合十人小型会议,含多媒体');
  114. INSERT INTO `room`(id,name,message) VALUES ('4', '上格云大会议室', '大型会议室,可使用多媒体,适合开会、讲座');
  115. INSERT INTO `room`(id,name,message) VALUES ('5', '尚格云小会议室', '小会议室,适合十人小型会议,含多媒体');
  116. INSERT INTO `room`(id,name,message) VALUES ('6', 'Beecom会议室', '小会议室,适合十人小型会议,含多媒体');
  117. -- ----------------------------------------
  118. -- Table structure for Facility--会议室设备
  119. -- ----------------------------------------
  120. Drop TABLE IF EXISTS `facility`;
  121. CREATE Table `facility`(
  122. `id` int(11) NOT NULL AUTO_INCREMENT,
  123. `room_id` int(11) NOT NULL,
  124. `facility_name` varchar(60) NOT NULL,
  125. PRIMARY KEY (`id`),
  126. KEY `fk_facility_room` (`room_id`),
  127. CONSTRAINT `fk_facility_room` FOREIGN KEY (`room_id`) REFERENCES `room` (`id`)
  128. )ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
  129. -- ----------------------------
  130. -- Records of Facility
  131. -- ----------------------------
  132. -- ----------------------------
  133. -- Table structure for user
  134. -- ----------------------------
  135. DROP TABLE IF EXISTS `user`;
  136. CREATE TABLE `user` (
  137. `id` varchar(32) NOT NULL,
  138. `password` varchar(32) NOT NULL,
  139. `role` int(11) DEFAULT NULL,
  140. PRIMARY KEY (`id`),
  141. KEY `fk_user_role` (`role`),
  142. CONSTRAINT `fk_user_role` FOREIGN KEY (`role`) REFERENCES `role` (`role_id`)
  143. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  144. -- ----------------------------
  145. -- Records of user
  146. -- ----------------------------
  147. INSERT INTO `user` VALUES ('201801', '123', '2');
  148. INSERT INTO `user` VALUES ('admin', 'emadmin', '1');
  149. INSERT INTO `user` VALUES ('ordinary', '123456', '2');
  150. INSERT INTO `user` VALUES ('李京鄂', '123456', '2');
  151. INSERT INTO `user` VALUES ('木小龙', '123456', '2');
  152. INSERT INTO `user` VALUES ('范丽颖', '123456', '2');
  153. INSERT INTO `user` VALUES ('王珊1', '123456', '2');
  154. INSERT INTO `user` VALUES ('张晶晶', '123456', '2');
  155. INSERT INTO `user` VALUES ('李俊威', '123456', '2');
  156. INSERT INTO `user` VALUES ('陈涛1', '123456', '2');
  157. INSERT INTO `user` VALUES ('刘西良', '123456', '2');
  158. INSERT INTO `user` VALUES ('蔡文琪', '123456', '2');
  159. INSERT INTO `user` VALUES ('王俊', '123456', '2');
  160. INSERT INTO `user` VALUES ('陈荟任', '123456', '2');
  161. INSERT INTO `user` VALUES ('薛敬雷', '123456', '2');
  162. INSERT INTO `user` VALUES ('王勤泽', '123456', '2');
  163. INSERT INTO `user` VALUES ('李旭', '123456', '2');
  164. INSERT INTO `user` VALUES ('张雨晴', '123456', '2');
  165. INSERT INTO `user` VALUES ('苏建飞', '123456', '2');
  166. INSERT INTO `user` VALUES ('王龙', '123456', '2');
  167. INSERT INTO `user` VALUES ('侯爽', '123456', '2');
  168. INSERT INTO `user` VALUES ('陈俊宏', '123456', '2');
  169. INSERT INTO `user` VALUES ('王熙婷', '123456', '2');
  170. INSERT INTO `user` VALUES ('李浩3', '123456', '2');
  171. INSERT INTO `user` VALUES ('袁锦旺', '123456', '2');
  172. INSERT INTO `user` VALUES ('李坤', '123456', '2');
  173. INSERT INTO `user` VALUES ('段超', '123456', '2');
  174. INSERT INTO `user` VALUES ('李浩2', '123456', '2');
  175. INSERT INTO `user` VALUES ('邹业强', '123456', '2');
  176. INSERT INTO `user` VALUES ('马圆', '123456', '2');
  177. INSERT INTO `user` VALUES ('王贺平', '123456', '2');
  178. INSERT INTO `user` VALUES ('杨勇', '123456', '2');
  179. INSERT INTO `user` VALUES ('杨琳', '123456', '2');
  180. INSERT INTO `user` VALUES ('刘世彪', '123456', '2');
  181. INSERT INTO `user` VALUES ('段瑞超', '123456', '2');
  182. INSERT INTO `user` VALUES ('赵宏昌', '123456', '2');
  183. INSERT INTO `user` VALUES ('郑成茂', '123456', '2');
  184. INSERT INTO `user` VALUES ('邓浩', '123456', '2');
  185. INSERT INTO `user` VALUES ('李晨禹', '123456', '2');
  186. INSERT INTO `user` VALUES ('孙锦阳', '123456', '2');
  187. INSERT INTO `user` VALUES ('石立强', '123456', '2');
  188. INSERT INTO `user` VALUES ('时欣意', '123456', '2');
  189. INSERT INTO `user` VALUES ('廖仁强', '123456', '2');
  190. INSERT INTO `user` VALUES ('王建何', '123456', '2');
  191. INSERT INTO `user` VALUES ('杨伟欢', '123456', '2');
  192. INSERT INTO `user` VALUES ('陈彦超', '123456', '2');
  193. INSERT INTO `user` VALUES ('刘建超', '123456', '2');
  194. INSERT INTO `user` VALUES ('丁言', '123456', '2');
  195. INSERT INTO `user` VALUES ('白轲', '123456', '2');
  196. INSERT INTO `user` VALUES ('闫鸿飞', '123456', '2');
  197. INSERT INTO `user` VALUES ('袁秋磊', '123456', '2');
  198. INSERT INTO `user` VALUES ('钟曼玉', '123456', '2');
  199. INSERT INTO `user` VALUES ('王礼军', '123456', '2');
  200. INSERT INTO `user` VALUES ('何一凡', '123456', '2');
  201. INSERT INTO `user` VALUES ('甘德维', '123456', '2');
  202. INSERT INTO `user` VALUES ('黄文亮', '123456', '2');
  203. INSERT INTO `user` VALUES ('柏林', '123456', '2');
  204. INSERT INTO `user` VALUES ('杜佳峰', '123456', '2');
  205. INSERT INTO `user` VALUES ('饶华', '123456', '2');
  206. INSERT INTO `user` VALUES ('杜迪', '123456', '2');
  207. INSERT INTO `user` VALUES ('杜宣言', '123456', '2');
  208. INSERT INTO `user` VALUES ('刘晗', '123456', '2');
  209. INSERT INTO `user` VALUES ('黄国旺', '123456', '2');
  210. INSERT INTO `user` VALUES ('王子恒', '123456', '2');
  211. INSERT INTO `user` VALUES ('李鹏麒', '123456', '2');
  212. INSERT INTO `user` VALUES ('杨新宇', '123456', '2');
  213. INSERT INTO `user` VALUES ('魏运华', '123456', '2');
  214. INSERT INTO `user` VALUES ('魏国仕', '123456', '2');
  215. INSERT INTO `user` VALUES ('韩龙', '123456', '2');
  216. INSERT INTO `user` VALUES ('李涛', '123456', '2');
  217. INSERT INTO `user` VALUES ('隋佳峻', '123456', '2');
  218. INSERT INTO `user` VALUES ('魏永东', '123456', '2');
  219. INSERT INTO `user` VALUES ('范志豪', '123456', '2');
  220. INSERT INTO `user` VALUES ('于明伟', '123456', '2');
  221. INSERT INTO `user` VALUES ('郑亚飞', '123456', '2');
  222. INSERT INTO `user` VALUES ('白俊杰', '123456', '2');
  223. INSERT INTO `user` VALUES ('葛薇', '123456', '2');
  224. INSERT INTO `user` VALUES ('池利娟', '123456', '2');
  225. INSERT INTO `user` VALUES ('赵腾飞', '123456', '2');
  226. INSERT INTO `user` VALUES ('向莉', '123456', '2');
  227. INSERT INTO `user` VALUES ('王文延', '123456', '2');
  228. INSERT INTO `user` VALUES ('李玲玲', '123456', '2');
  229. INSERT INTO `user` VALUES ('刘雨东', '123456', '2');
  230. INSERT INTO `user` VALUES ('张雅萍', '123456', '2');
  231. INSERT INTO `user` VALUES ('周学宇', '123456', '2');
  232. INSERT INTO `user` VALUES ('栾金颖', '123456', '2');
  233. INSERT INTO `user` VALUES ('李智婕', '123456', '2');
  234. INSERT INTO `user` VALUES ('陈中山', '123456', '2');
  235. INSERT INTO `user` VALUES ('吴若飒', '123456', '2');
  236. INSERT INTO `user` VALUES ('张振宇', '123456', '2');
  237. INSERT INTO `user` VALUES ('狄雨佳', '123456', '2');
  238. INSERT INTO `user` VALUES ('杨东升', '123456', '2');
  239. INSERT INTO `user` VALUES ('赵争艳', '123456', '2');
  240. INSERT INTO `user` VALUES ('庞欢', '123456', '2');
  241. INSERT INTO `user` VALUES ('肖丽', '123456', '2');
  242. INSERT INTO `user` VALUES ('郭姝璇', '123456', '2');
  243. INSERT INTO `user` VALUES ('陆千富', '123456', '2');
  244. INSERT INTO `user` VALUES ('吕娇莉', '123456', '2');
  245. INSERT INTO `user` VALUES ('陈伟军', '123456', '2');
  246. INSERT INTO `user` VALUES ('李松', '123456', '2');
  247. INSERT INTO `user` VALUES ('赖星其', '123456', '2');
  248. INSERT INTO `user` VALUES ('陈媖', '123456', '2');
  249. INSERT INTO `user` VALUES ('贾笑丽', '123456', '2');
  250. INSERT INTO `user` VALUES ('孙月', '123456', '2');
  251. INSERT INTO `user` VALUES ('谭庆威', '123456', '2');
  252. INSERT INTO `user` VALUES ('邵泓博', '123456', '2');
  253. INSERT INTO `user` VALUES ('李林善', '123456', '2');
  254. INSERT INTO `user` VALUES ('胡立松', '123456', '2');
  255. INSERT INTO `user` VALUES ('杜军明', '123456', '2');
  256. INSERT INTO `user` VALUES ('郭杰夫', '123456', '2');
  257. INSERT INTO `user` VALUES ('刘杰', '123456', '2');
  258. INSERT INTO `user` VALUES ('陈娴', '123456', '2');
  259. INSERT INTO `user` VALUES ('边琼阳', '123456', '2');
  260. INSERT INTO `user` VALUES ('候晓波', '123456', '2');
  261. INSERT INTO `user` VALUES ('桂璇', '123456', '2');
  262. INSERT INTO `user` VALUES ('陶俊羽', '123456', '2');
  263. INSERT INTO `user` VALUES ('李磊', '123456', '2');
  264. INSERT INTO `user` VALUES ('王清慧', '123456', '2');
  265. INSERT INTO `user` VALUES ('朱嘉君', '123456', '2');
  266. INSERT INTO `user` VALUES ('杨伯禹', '123456', '2');
  267. INSERT INTO `user` VALUES ('刘慧莹', '123456', '2');
  268. INSERT INTO `user` VALUES ('肖曼', '123456', '2');
  269. INSERT INTO `user` VALUES ('段悦', '123456', '2');
  270. INSERT INTO `user` VALUES ('黄向静', '123456', '2');
  271. INSERT INTO `user` VALUES ('李婧雯', '123456', '2');
  272. INSERT INTO `user` VALUES ('朱杰', '123456', '2');
  273. INSERT INTO `user` VALUES ('王凯军', '123456', '2');
  274. INSERT INTO `user` VALUES ('李鹏飞', '123456', '2');
  275. INSERT INTO `user` VALUES ('秦炜炜', '123456', '2');
  276. INSERT INTO `user` VALUES ('李海碧', '123456', '2');
  277. INSERT INTO `user` VALUES ('林萌', '123456', '2');
  278. INSERT INTO `user` VALUES ('高杨', '123456', '2');
  279. INSERT INTO `user` VALUES ('黄浩然', '123456', '2');
  280. INSERT INTO `user` VALUES ('冯忠学', '123456', '2');
  281. INSERT INTO `user` VALUES ('马丽雪', '123456', '2');
  282. INSERT INTO `user` VALUES ('吴明星', '123456', '2');
  283. INSERT INTO `user` VALUES ('温浩', '123456', '2');
  284. INSERT INTO `user` VALUES ('冯长浩', '123456', '2');
  285. INSERT INTO `user` VALUES ('刘洪磊', '123456', '2');
  286. INSERT INTO `user` VALUES ('秦智勇', '123456', '2');
  287. INSERT INTO `user` VALUES ('陈成', '123456', '2');
  288. INSERT INTO `user` VALUES ('张超', '123456', '2');
  289. INSERT INTO `user` VALUES ('侯悦', '123456', '2');
  290. INSERT INTO `user` VALUES ('刘松', '123456', '2');
  291. INSERT INTO `user` VALUES ('王鹏', '123456', '2');
  292. INSERT INTO `user` VALUES ('赵闯', '123456', '2');
  293. INSERT INTO `user` VALUES ('司蔚蔚', '123456', '2');
  294. INSERT INTO `user` VALUES ('席东霞', '123456', '2');
  295. INSERT INTO `user` VALUES ('付慧', '123456', '2');
  296. INSERT INTO `user` VALUES ('胡家政', '123456', '2');
  297. INSERT INTO `user` VALUES ('周晓强', '123456', '2');
  298. INSERT INTO `user` VALUES ('惠彦斌', '123456', '2');
  299. INSERT INTO `user` VALUES ('赵博', '123456', '2');
  300. INSERT INTO `user` VALUES ('柳佳伟', '123456', '2');
  301. INSERT INTO `user` VALUES ('王兰旭', '123456', '2');
  302. INSERT INTO `user` VALUES ('张鹏飞', '123456', '2');
  303. INSERT INTO `user` VALUES ('杨静婷', '123456', '2');
  304. INSERT INTO `user` VALUES ('赵旭', '123456', '2');
  305. INSERT INTO `user` VALUES ('罗铃松', '123456', '2');
  306. INSERT INTO `user` VALUES ('蒋克文', '123456', '2');
  307. INSERT INTO `user` VALUES ('王东军', '123456', '2');
  308. INSERT INTO `user` VALUES ('周玉涛', '123456', '2');
  309. INSERT INTO `user` VALUES ('高明', '123456', '2');
  310. INSERT INTO `user` VALUES ('王丹丹', '123456', '2');
  311. INSERT INTO `user` VALUES ('范铄', '123456', '2');
  312. INSERT INTO `user` VALUES ('连玉洁', '123456', '2');
  313. INSERT INTO `user` VALUES ('武濛濛', '123456', '2');
  314. INSERT INTO `user` VALUES ('张暄', '123456', '2');
  315. INSERT INTO `user` VALUES ('党伟康', '123456', '2');
  316. INSERT INTO `user` VALUES ('王雪', '123456', '2');
  317. INSERT INTO `user` VALUES ('化笑炎', '123456', '2');
  318. INSERT INTO `user` VALUES ('张媛媛', '123456', '2');
  319. INSERT INTO `user` VALUES ('王磊1', '123456', '2');
  320. INSERT INTO `user` VALUES ('张骋', '123456', '2');
  321. INSERT INTO `user` VALUES ('何德志', '123456', '2');
  322. INSERT INTO `user` VALUES ('扶鑫', '123456', '2');
  323. INSERT INTO `user` VALUES ('马帅', '123456', '2');
  324. INSERT INTO `user` VALUES ('杨忠红', '123456', '2');
  325. INSERT INTO `user` VALUES ('肖征', '123456', '2');
  326. INSERT INTO `user` VALUES ('田野', '123456', '2');
  327. INSERT INTO `user` VALUES ('洪克军', '123456', '2');
  328. INSERT INTO `user` VALUES ('张磊', '123456', '2');
  329. INSERT INTO `user` VALUES ('王海龙', '123456', '2');
  330. INSERT INTO `user` VALUES ('常海', '123456', '2');
  331. INSERT INTO `user` VALUES ('张慧君', '123456', '2');
  332. INSERT INTO `user` VALUES ('高帅', '123456', '2');
  333. INSERT INTO `user` VALUES ('王明明', '123456', '2');
  334. INSERT INTO `user` VALUES ('徐瑜', '123456', '2');
  335. INSERT INTO `user` VALUES ('邹敏华', '123456', '2');
  336. INSERT INTO `user` VALUES ('李云飞', '123456', '2');
  337. INSERT INTO `user` VALUES ('范南雁', '123456', '2');
  338. INSERT INTO `user` VALUES ('陈德海', '123456', '2');
  339. INSERT INTO `user` VALUES ('邓晓鹏', '123456', '2');
  340. INSERT INTO `user` VALUES ('彭晶晶', '123456', '2');
  341. INSERT INTO `user` VALUES ('刘世祥', '123456', '2');
  342. INSERT INTO `user` VALUES ('王智鹏', '123456', '2');
  343. INSERT INTO `user` VALUES ('江江', '123456', '2');
  344. INSERT INTO `user` VALUES ('金大钧', '123456', '2');
  345. INSERT INTO `user` VALUES ('任立山', '123456', '2');
  346. INSERT INTO `user` VALUES ('王雅惠', '123456', '2');
  347. INSERT INTO `user` VALUES ('许金丽', '123456', '2');
  348. INSERT INTO `user` VALUES ('何建强', '123456', '2');
  349. INSERT INTO `user` VALUES ('李冬梅', '123456', '2');
  350. INSERT INTO `user` VALUES ('康军红', '123456', '2');
  351. INSERT INTO `user` VALUES ('田雨森', '123456', '2');
  352. INSERT INTO `user` VALUES ('范晓宇', '123456', '2');
  353. INSERT INTO `user` VALUES ('洪迎迎', '123456', '2');
  354. INSERT INTO `user` VALUES ('张丹丹', '123456', '2');
  355. INSERT INTO `user` VALUES ('徐彬', '123456', '2');
  356. INSERT INTO `user` VALUES ('李爽菲', '123456', '2');
  357. INSERT INTO `user` VALUES ('杨末', '123456', '2');
  358. INSERT INTO `user` VALUES ('林玉涵', '123456', '2');
  359. INSERT INTO `user` VALUES ('陈聪', '123456', '2');
  360. INSERT INTO `user` VALUES ('高凤', '123456', '2');
  361. INSERT INTO `user` VALUES ('刘红洋', '123456', '2');
  362. INSERT INTO `user` VALUES ('杨思佳', '123456', '2');
  363. INSERT INTO `user` VALUES ('周雨娇', '123456', '2');
  364. INSERT INTO `user` VALUES ('陶溯', '123456', '2');
  365. INSERT INTO `user` VALUES ('杨志刚', '123456', '2');
  366. INSERT INTO `user` VALUES ('付勇琪', '123456', '2');
  367. INSERT INTO `user` VALUES ('安少辉', '123456', '2');
  368. INSERT INTO `user` VALUES ('张梦媛', '123456', '2');
  369. INSERT INTO `user` VALUES ('闫嘉玮', '123456', '2');
  370. INSERT INTO `user` VALUES ('祝瑞', '123456', '2');
  371. INSERT INTO `user` VALUES ('崔文波', '123456', '2');
  372. INSERT INTO `user` VALUES ('丁惊涛', '123456', '2');
  373. INSERT INTO `user` VALUES ('宁云飞', '123456', '2');
  374. INSERT INTO `user` VALUES ('耿占民', '123456', '2');
  375. INSERT INTO `user` VALUES ('周保永', '123456', '2');
  376. INSERT INTO `user` VALUES ('陈涛', '123456', '2');
  377. INSERT INTO `user` VALUES ('王钰博', '123456', '2');
  378. INSERT INTO `user` VALUES ('王凯山', '123456', '2');
  379. INSERT INTO `user` VALUES ('刘梦楠', '123456', '2');
  380. INSERT INTO `user` VALUES ('万里涛', '123456', '2');
  381. INSERT INTO `user` VALUES ('安晨曦', '123456', '2');
  382. INSERT INTO `user` VALUES ('孔胜祥', '123456', '2');
  383. INSERT INTO `user` VALUES ('张晓林', '123456', '2');
  384. INSERT INTO `user` VALUES ('姜永涛', '123456', '2');
  385. INSERT INTO `user` VALUES ('郭江波', '123456', '2');
  386. INSERT INTO `user` VALUES ('张志尧', '123456', '2');
  387. INSERT INTO `user` VALUES ('赵彦涛', '123456', '2');
  388. INSERT INTO `user` VALUES ('刘佟', '123456', '2');
  389. INSERT INTO `user` VALUES ('刘学志', '123456', '2');
  390. INSERT INTO `user` VALUES ('于柏松', '123456', '2');
  391. INSERT INTO `user` VALUES ('王超', '123456', '2');
  392. INSERT INTO `user` VALUES ('段瑞香', '123456', '2');
  393. INSERT INTO `user` VALUES ('王凡', '123456', '2');
  394. INSERT INTO `user` VALUES ('唐蕾', '123456', '2');
  395. INSERT INTO `user` VALUES ('覃漳', '123456', '2');
  396. INSERT INTO `user` VALUES ('樊玉松', '123456', '2');
  397. INSERT INTO `user` VALUES ('严小远', '123456', '2');
  398. INSERT INTO `user` VALUES ('邬倩倩', '123456', '2');
  399. INSERT INTO `user` VALUES ('张德虎', '123456', '2');
  400. INSERT INTO `user` VALUES ('翟宇杰', '123456', '2');
  401. INSERT INTO `user` VALUES ('孙金宝', '123456', '2');
  402. INSERT INTO `user` VALUES ('岳彩普', '123456', '2');
  403. INSERT INTO `user` VALUES ('杨杰锋', '123456', '2');
  404. INSERT INTO `user` VALUES ('杨乐', '123456', '2');
  405. INSERT INTO `user` VALUES ('魏接晖', '123456', '2');
  406. INSERT INTO `user` VALUES ('朱永磊', '123456', '2');
  407. INSERT INTO `user` VALUES ('龙建超', '123456', '2');
  408. INSERT INTO `user` VALUES ('郝书彰', '123456', '2');
  409. INSERT INTO `user` VALUES ('汪存文', '123456', '2');
  410. INSERT INTO `user` VALUES ('周广龙', '123456', '2');
  411. INSERT INTO `user` VALUES ('张武', '123456', '2');
  412. INSERT INTO `user` VALUES ('宋好义', '123456', '2');
  413. INSERT INTO `user` VALUES ('丁亮', '123456', '2');
  414. INSERT INTO `user` VALUES ('王磊', '123456', '2');
  415. INSERT INTO `user` VALUES ('李杰', '123456', '2');
  416. INSERT INTO `user` VALUES ('李浩', '123456', '2');
  417. INSERT INTO `user` VALUES ('左丞', '123456', '2');
  418. INSERT INTO `user` VALUES ('王茂波', '123456', '2');
  419. INSERT INTO `user` VALUES ('张圣仓', '123456', '2');
  420. INSERT INTO `user` VALUES ('车成浩', '123456', '2');
  421. INSERT INTO `user` VALUES ('纪永强', '123456', '2');
  422. INSERT INTO `user` VALUES ('马娟', '123456', '2');
  423. INSERT INTO `user` VALUES ('葛小松-', '123456', '2');
  424. INSERT INTO `user` VALUES ('钱亮', '123456', '2');
  425. INSERT INTO `user` VALUES ('黄得恩', '123456', '2');
  426. INSERT INTO `user` VALUES ('史超', '123456', '2');
  427. INSERT INTO `user` VALUES ('汪文博', '123456', '2');
  428. INSERT INTO `user` VALUES ('史辉', '123456', '2');
  429. INSERT INTO `user` VALUES ('戈弋', '123456', '2');
  430. INSERT INTO `user` VALUES ('刘博玮', '123456', '2');
  431. INSERT INTO `user` VALUES ('于小威', '123456', '2');
  432. INSERT INTO `user` VALUES ('丁宝柱', '123456', '2');
  433. INSERT INTO `user` VALUES ('王晓宇', '123456', '2');
  434. INSERT INTO `user` VALUES ('李保成', '123456', '2');
  435. INSERT INTO `user` VALUES ('李万新', '123456', '2');
  436. INSERT INTO `user` VALUES ('解枫', '123456', '2');
  437. INSERT INTO `user` VALUES ('李若冲', '123456', '2');
  438. INSERT INTO `user` VALUES ('王伟', '123456', '2');
  439. INSERT INTO `user` VALUES ('高乐', '123456', '2');
  440. INSERT INTO `user` VALUES ('时启相', '123456', '2');
  441. INSERT INTO `user` VALUES ('吴丽琼', '123456', '2');
  442. INSERT INTO `user` VALUES ('苏月', '123456', '2');
  443. INSERT INTO `user` VALUES ('张颖佳', '123456', '2');
  444. INSERT INTO `user` VALUES ('刘永', '123456', '2');
  445. INSERT INTO `user` VALUES ('王弘韬', '123456', '2');
  446. INSERT INTO `user` VALUES ('杜博', '123456', '2');
  447. INSERT INTO `user` VALUES ('李东鹏', '123456', '2');
  448. INSERT INTO `user` VALUES ('龚正', '123456', '2');
  449. INSERT INTO `user` VALUES ('祝园园', '123456', '2');
  450. INSERT INTO `user` VALUES ('李航', '123456', '2');
  451. INSERT INTO `user` VALUES ('曹征', '123456', '2');
  452. INSERT INTO `user` VALUES ('张云云', '123456', '2');
  453. INSERT INTO `user` VALUES ('胡剑辉', '123456', '2');
  454. INSERT INTO `user` VALUES ('曹康应', '123456', '2');
  455. INSERT INTO `user` VALUES ('李佩佳', '123456', '2');
  456. INSERT INTO `user` VALUES ('宋天瑶', '123456', '2');
  457. INSERT INTO `user` VALUES ('韩伟', '123456', '2');
  458. INSERT INTO `user` VALUES ('李强', '123456', '2');
  459. INSERT INTO `user` VALUES ('张晨曦', '123456', '2');
  460. INSERT INTO `user` VALUES ('李洪吉', '123456', '2');
  461. INSERT INTO `user` VALUES ('宗源', '123456', '2');
  462. INSERT INTO `user` VALUES ('高创库', '123456', '2');
  463. INSERT INTO `user` VALUES ('刘贵轩', '123456', '2');
  464. INSERT INTO `user` VALUES ('周德斐', '123456', '2');
  465. INSERT INTO `user` VALUES ('周演', '123456', '2');
  466. INSERT INTO `user` VALUES ('江崇邦', '123456', '2');
  467. INSERT INTO `user` VALUES ('沈启', '123456', '2');
  468. INSERT INTO `user` VALUES ('刘楠', '123456', '2');
  469. INSERT INTO `user` VALUES ('周洋帆', '123456', '2');
  470. INSERT INTO `user` VALUES ('李超', '123456', '2');
  471. INSERT INTO `user` VALUES ('刘伟鑫', '123456', '2');
  472. INSERT INTO `user` VALUES ('吕华杰', '123456', '2');
  473. INSERT INTO `user` VALUES ('杨启凡', '123456', '2');
  474. INSERT INTO `user` VALUES ('耿锁锋', '123456', '2');
  475. INSERT INTO `user` VALUES ('吕学广', '123456', '2');
  476. INSERT INTO `user` VALUES ('程丽娇', '123456', '2');
  477. INSERT INTO `user` VALUES ('赵昕', '123456', '2');
  478. INSERT INTO `user` VALUES ('王欢欢', '123456', '2');
  479. INSERT INTO `user` VALUES ('张善国', '123456', '2');
  480. INSERT INTO `user` VALUES ('张志双', '123456', '2');
  481. INSERT INTO `user` VALUES ('赵锴', '123456', '2');
  482. INSERT INTO `user` VALUES ('卫盼', '123456', '2');
  483. INSERT INTO `user` VALUES ('芦海锋', '123456', '2');
  484. INSERT INTO `user` VALUES ('李文婕', '123456', '2');
  485. INSERT INTO `user` VALUES ('荣宇红', '123456', '2');
  486. INSERT INTO `user` VALUES ('孙晓鹏', '123456', '2');
  487. INSERT INTO `user` VALUES ('楚雅迪', '123456', '2');
  488. INSERT INTO `user` VALUES ('张勇嘉', '123456', '2');
  489. INSERT INTO `user` VALUES ('王洋洋', '123456', '2');
  490. INSERT INTO `user` VALUES ('掌梦阳', '123456', '2');
  491. INSERT INTO `user` VALUES ('冯复汉', '123456', '2');
  492. INSERT INTO `user` VALUES ('周爱娟', '123456', '2');
  493. INSERT INTO `user` VALUES ('赵纯', '123456', '2');
  494. INSERT INTO `user` VALUES ('段潘英', '123456', '2');
  495. INSERT INTO `user` VALUES ('高子旭', '123456', '2');
  496. INSERT INTO `user` VALUES ('李士勇', '123456', '2');
  497. INSERT INTO `user` VALUES ('张子恒', '123456', '2');
  498. INSERT INTO `user` VALUES ('秦晓强', '123456', '2');
  499. INSERT INTO `user` VALUES ('李蓉', '123456', '2');
  500. INSERT INTO `user` VALUES ('王华平', '123456', '2');
  501. INSERT INTO `user` VALUES ('胡礼霞', '123456', '2');
  502. INSERT INTO `user` VALUES ('1', '123456', '2');
  503. INSERT INTO `user` VALUES ('龚世超', '123456', '2');
  504. INSERT INTO `user` VALUES ('张凌霄', '123456', '2');
  505. INSERT INTO `user` VALUES ('孙楷', '123456', '2');
  506. INSERT INTO `user` VALUES ('史佳成', '123456', '2');
  507. INSERT INTO `user` VALUES ('123213', '123456', '2');
  508. INSERT INTO `user` VALUES ('李佳帅', '123456', '2');
  509. INSERT INTO `user` VALUES ('刘林安', '123456', '2');
  510. INSERT INTO `user` VALUES ('毛锟', '123456', '2');
  511. INSERT INTO `user` VALUES ('魏志雄', '123456', '2');
  512. INSERT INTO `user` VALUES ('郭志骞', '123456', '2');
  513. INSERT INTO `user` VALUES ('李珊', '123456', '2');
  514. INSERT INTO `user` VALUES ('王雪1', '123456', '2');
  515. INSERT INTO `user` VALUES ('刘仕琦', '123456', '2');
  516. INSERT INTO `user` VALUES ('张合松', '123456', '2');
  517. INSERT INTO `user` VALUES ('刘凌鹏', '123456', '2');
  518. INSERT INTO `user` VALUES ('黎港', '123456', '2');
  519. INSERT INTO `user` VALUES ('韩硕', '123456', '2');
  520. INSERT INTO `user` VALUES ('季雯雯', '123456', '2');
  521. INSERT INTO `user` VALUES ('王育硕', '123456', '2');
  522. INSERT INTO `user` VALUES ('杨鹏', '123456', '2');
  523. INSERT INTO `user` VALUES ('李聚鑫', '123456', '2');
  524. INSERT INTO `user` VALUES ('王松庆', '123456', '2');
  525. INSERT INTO `user` VALUES ('陈鹏', '123456', '2');
  526. INSERT INTO `user` VALUES ('陈玉柱', '123456', '2');
  527. INSERT INTO `user` VALUES ('吴东金', '123456', '2');
  528. INSERT INTO `user` VALUES ('崔莹', '123456', '2');
  529. INSERT INTO `user` VALUES ('叶小思', '123456', '2');
  530. INSERT INTO `user` VALUES ('范仔骏', '123456', '2');
  531. INSERT INTO `user` VALUES ('胡苏婉', '123456', '2');
  532. INSERT INTO `user` VALUES ('姚林林', '123456', '2');
  533. INSERT INTO `user` VALUES ('王家宁', '123456', '2');
  534. INSERT INTO `user` VALUES ('刘建尚', '123456', '2');
  535. INSERT INTO `user` VALUES ('杨佩佩', '123456', '2');
  536. INSERT INTO `user` VALUES ('周振华', '123456', '2');
  537. INSERT INTO `user` VALUES ('师浩洋', '123456', '2');
  538. INSERT INTO `user` VALUES ('何玲', '123456', '2');
  539. INSERT INTO `user` VALUES ('叶小东', '123456', '2');
  540. INSERT INTO `user` VALUES ('纪元', '123456', '2');
  541. INSERT INTO `user` VALUES ('吴国仪', '123456', '2');
  542. INSERT INTO `user` VALUES ('次仁顿珠', '123456', '2');
  543. INSERT INTO `user` VALUES ('赵婷', '123456', '2');
  544. INSERT INTO `user` VALUES ('韩洋', '123456', '2');
  545. INSERT INTO `user` VALUES ('王艺璇', '123456', '2');
  546. INSERT INTO `user` VALUES ('魏玉峤', '123456', '2');
  547. INSERT INTO `user` VALUES ('池硕', '123456', '2');
  548. INSERT INTO `user` VALUES ('周忠文', '123456', '2');
  549. INSERT INTO `user` VALUES ('罗成', '123456', '2');
  550. INSERT INTO `user` VALUES ('赵恒昕', '123456', '2');
  551. INSERT INTO `user` VALUES ('刘旻龙', '123456', '2');
  552. INSERT INTO `user` VALUES ('余惕恒', '123456', '2');
  553. INSERT INTO `user` VALUES ('代明洋', '123456', '2');
  554. INSERT INTO `user` VALUES ('王驰', '123456', '2');
  555. INSERT INTO `user` VALUES ('雪慧敏', '123456', '2');
  556. INSERT INTO `user` VALUES ('王诗予', '123456', '2');
  557. INSERT INTO `user` VALUES ('卢华飞', '123456', '2');
  558. INSERT INTO `user` VALUES ('张明明', '123456', '2');
  559. INSERT INTO `user` VALUES ('索桂红', '123456', '2');
  560. INSERT INTO `user` VALUES ('戴伟', '123456', '2');
  561. INSERT INTO `user` VALUES ('徐永平', '123456', '2');
  562. INSERT INTO `user` VALUES ('纪少杰', '123456', '2');
  563. INSERT INTO `user` VALUES ('卯龙', '123456', '2');
  564. INSERT INTO `user` VALUES ('李潇康', '123456', '2');
  565. INSERT INTO `user` VALUES ('马昕宇', '123456', '2');
  566. INSERT INTO `user` VALUES ('余钱', '123456', '2');
  567. INSERT INTO `user` VALUES ('王田雨', '123456', '2');
  568. INSERT INTO `user` VALUES ('宗浩', '123456', '2');
  569. INSERT INTO `user` VALUES ('鲁永川', '123456', '2');
  570. INSERT INTO `user` VALUES ('牟俊', '123456', '2');
  571. INSERT INTO `user` VALUES ('温华贵', '123456', '2');
  572. INSERT INTO `user` VALUES ('何彪', '123456', '2');
  573. INSERT INTO `user` VALUES ('黄向森', '123456', '2');
  574. INSERT INTO `user` VALUES ('李昕', '123456', '2');
  575. INSERT INTO `user` VALUES ('张文丽', '123456', '2');
  576. INSERT INTO `user` VALUES ('陈申有', '123456', '2');
  577. INSERT INTO `user` VALUES ('齐心1', '123456', '2');
  578. INSERT INTO `user` VALUES ('孙霞霞', '123456', '2');
  579. INSERT INTO `user` VALUES ('姜亚奇', '123456', '2');
  580. INSERT INTO `user` VALUES ('张会娟', '123456', '2');
  581. INSERT INTO `user` VALUES ('宋冰玉', '123456', '2');
  582. INSERT INTO `user` VALUES ('马洪彦', '123456', '2');
  583. INSERT INTO `user` VALUES ('王启', '123456', '2');
  584. INSERT INTO `user` VALUES ('闫方方', '123456', '2');
  585. INSERT INTO `user` VALUES ('刘春涛', '123456', '2');
  586. INSERT INTO `user` VALUES ('乞欣', '123456', '2');
  587. INSERT INTO `user` VALUES ('姜燕', '123456', '2');
  588. INSERT INTO `user` VALUES ('何祖银', '123456', '2');
  589. INSERT INTO `user` VALUES ('覃万科', '123456', '2');
  590. INSERT INTO `user` VALUES ('冯燕杰', '123456', '2');
  591. INSERT INTO `user` VALUES ('杨学亭', '123456', '2');
  592. INSERT INTO `user` VALUES ('阳帆', '123456', '2');
  593. INSERT INTO `user` VALUES ('贾乾然', '123456', '2');
  594. INSERT INTO `user` VALUES ('尹志华', '123456', '2');
  595. INSERT INTO `user` VALUES ('雷虎', '123456', '2');
  596. INSERT INTO `user` VALUES ('陈传玮', '123456', '2');
  597. INSERT INTO `user` VALUES ('贠星', '123456', '2');
  598. INSERT INTO `user` VALUES ('马若怀', '123456', '2');
  599. INSERT INTO `user` VALUES ('陈权威', '123456', '2');
  600. INSERT INTO `user` VALUES ('张振', '123456', '2');
  601. INSERT INTO `user` VALUES ('李兴', '123456', '2');
  602. INSERT INTO `user` VALUES ('赵晶晶', '123456', '2');
  603. INSERT INTO `user` VALUES ('开佰达', '123456', '2');
  604. INSERT INTO `user` VALUES ('任震', '123456', '2');
  605. INSERT INTO `user` VALUES ('马业明', '123456', '2');
  606. INSERT INTO `user` VALUES ('张佳奇', '123456', '2');
  607. INSERT INTO `user` VALUES ('杜晓倩', '123456', '2');
  608. INSERT INTO `user` VALUES ('任晓欣', '123456', '2');
  609. INSERT INTO `user` VALUES ('温喆强', '123456', '2');
  610. INSERT INTO `user` VALUES ('刘颂', '123456', '2');
  611. INSERT INTO `user` VALUES ('谢郑凯', '123456', '2');
  612. INSERT INTO `user` VALUES ('范韬博文', '123456', '2');
  613. INSERT INTO `user` VALUES ('田继超', '123456', '2');
  614. INSERT INTO `user` VALUES ('杨志伟', '123456', '2');
  615. INSERT INTO `user` VALUES ('贾晓宁', '123456', '2');
  616. INSERT INTO `user` VALUES ('未艺超', '123456', '2');
  617. INSERT INTO `user` VALUES ('刘畅', '123456', '2');
  618. INSERT INTO `user` VALUES ('刘晓雨', '123456', '2');
  619. INSERT INTO `user` VALUES ('李俊杰', '123456', '2');
  620. INSERT INTO `user` VALUES ('陈晨', '123456', '2');
  621. INSERT INTO `user` VALUES ('王永梅', '123456', '2');
  622. INSERT INTO `user` VALUES ('张鑫', '123456', '2');
  623. INSERT INTO `user` VALUES ('吴权隆', '123456', '2');
  624. INSERT INTO `user` VALUES ('金操', '123456', '2');
  625. INSERT INTO `user` VALUES ('刘璐', '123456', '2');
  626. INSERT INTO `user` VALUES ('许月', '123456', '2');
  627. INSERT INTO `user` VALUES ('刘晓倩', '123456', '2');
  628. INSERT INTO `user` VALUES ('符御峰', '123456', '2');
  629. INSERT INTO `user` VALUES ('赵慧敏', '123456', '2');
  630. INSERT INTO `user` VALUES ('罗广毅', '123456', '2');
  631. INSERT INTO `user` VALUES ('冀少军', '123456', '2');
  632. INSERT INTO `user` VALUES ('庄起峰', '123456', '2');
  633. INSERT INTO `user` VALUES ('邢景灏', '123456', '2');
  634. INSERT INTO `user` VALUES ('顾佳', '123456', '2');
  635. INSERT INTO `user` VALUES ('崔东升', '123456', '2');
  636. INSERT INTO `user` VALUES ('曹帅', '123456', '2');
  637. INSERT INTO `user` VALUES ('刘达', '123456', '2');
  638. INSERT INTO `user` VALUES ('杜洋', '123456', '2');
  639. INSERT INTO `user` VALUES ('吴新纪', '123456', '2');
  640. INSERT INTO `user` VALUES ('高扬', '123456', '2');
  641. INSERT INTO `user` VALUES ('杨洁', '123456', '2');
  642. INSERT INTO `user` VALUES ('冯金钻', '123456', '2');
  643. INSERT INTO `user` VALUES ('王鹏皓', '123456', '2');
  644. INSERT INTO `user` VALUES ('罗丹', '123456', '2');
  645. INSERT INTO `user` VALUES ('韩昭阳', '123456', '2');
  646. INSERT INTO `user` VALUES ('刘亚萍', '123456', '2');
  647. INSERT INTO `user` VALUES ('郑权', '123456', '2');
  648. INSERT INTO `user` VALUES ('崔旭彬', '123456', '2');
  649. INSERT INTO `user` VALUES ('崔龙效', '123456', '2');
  650. INSERT INTO `user` VALUES ('杨清昆', '123456', '2');
  651. INSERT INTO `user` VALUES ('黄剑', '123456', '2');
  652. INSERT INTO `user` VALUES ('胡秋林', '123456', '2');
  653. INSERT INTO `user` VALUES ('刘莹莹', '123456', '2');
  654. INSERT INTO `user` VALUES ('王喜', '123456', '2');
  655. INSERT INTO `user` VALUES ('杨缙', '123456', '2');
  656. INSERT INTO `user` VALUES ('张现伟', '123456', '2');
  657. INSERT INTO `user` VALUES ('鲁舜', '123456', '2');
  658. INSERT INTO `user` VALUES ('胡楚梅', '123456', '2');
  659. INSERT INTO `user` VALUES ('韩耀龙', '123456', '2');
  660. INSERT INTO `user` VALUES ('邹业龙', '123456', '2');
  661. INSERT INTO `user` VALUES ('郝固烜', '123456', '2');
  662. INSERT INTO `user` VALUES ('吴艳东', '123456', '2');
  663. INSERT INTO `user` VALUES ('邢茂军', '123456', '2');
  664. INSERT INTO `user` VALUES ('丁志鹏', '123456', '2');
  665. INSERT INTO `user` VALUES ('齐超锋', '123456', '2');
  666. INSERT INTO `user` VALUES ('党洋', '123456', '2');
  667. INSERT INTO `user` VALUES ('李文鹏', '123456', '2');
  668. INSERT INTO `user` VALUES ('薛晨笑', '123456', '2');
  669. INSERT INTO `user` VALUES ('王永昌', '123456', '2');
  670. INSERT INTO `user` VALUES ('李秋瑾', '123456', '2');
  671. INSERT INTO `user` VALUES ('谢伟', '123456', '2');
  672. INSERT INTO `user` VALUES ('王蕊', '123456', '2');
  673. INSERT INTO `user` VALUES ('刘超杰', '123456', '2');
  674. INSERT INTO `user` VALUES ('万超朋', '123456', '2');
  675. INSERT INTO `user` VALUES ('测试', '123456', '2');
  676. INSERT INTO `user` VALUES ('崔恩浩', '123456', '2');
  677. INSERT INTO `user` VALUES ('张丽', '123456', '2');
  678. INSERT INTO `user` VALUES ('许路晗', '123456', '2');
  679. INSERT INTO `user` VALUES ('刘宸', '123456', '2');
  680. INSERT INTO `user` VALUES ('丁凡', '123456', '2');
  681. INSERT INTO `user` VALUES ('王淑钰', '123456', '2');
  682. INSERT INTO `user` VALUES ('张博禹', '123456', '2');
  683. INSERT INTO `user` VALUES ('孙慧慧', '123456', '2');
  684. INSERT INTO `user` VALUES ('赵浩翔', '123456', '2');
  685. INSERT INTO `user` VALUES ('李豪', '123456', '2');
  686. INSERT INTO `user` VALUES ('芮鹏飞', '123456', '2');
  687. INSERT INTO `user` VALUES ('郑新鹏', '123456', '2');
  688. INSERT INTO `user` VALUES ('邬贝辉', '123456', '2');
  689. INSERT INTO `user` VALUES ('黄晓杰', '123456', '2');
  690. INSERT INTO `user` VALUES ('李晓健', '123456', '2');
  691. INSERT INTO `user` VALUES ('鲍东旭', '123456', '2');
  692. INSERT INTO `user` VALUES ('杨康', '123456', '2');
  693. INSERT INTO `user` VALUES ('彭琛', '123456', '2');
  694. INSERT INTO `user` VALUES ('易鹏', '123456', '2');
  695. INSERT INTO `user` VALUES ('杨红颖', '123456', '2');
  696. INSERT INTO `user` VALUES ('姬强强', '123456', '2');
  697. INSERT INTO `user` VALUES ('王建勋', '123456', '2');
  698. INSERT INTO `user` VALUES ('袁楚坤', '123456', '2');
  699. INSERT INTO `user` VALUES ('李泓名', '123456', '2');
  700. INSERT INTO `user` VALUES ('贾晓平', '123456', '2');
  701. INSERT INTO `user` VALUES ('任俊健', '123456', '2');
  702. INSERT INTO `user` VALUES ('何承阳', '123456', '2');
  703. INSERT INTO `user` VALUES ('兰帅歌', '123456', '2');
  704. INSERT INTO `user` VALUES ('王志君', '123456', '2');
  705. INSERT INTO `user` VALUES ('李润明', '123456', '2');
  706. INSERT INTO `user` VALUES ('苟海', '123456', '2');
  707. INSERT INTO `user` VALUES ('刘紫薇', '123456', '2');
  708. INSERT INTO `user` VALUES ('李静原', '123456', '2');
  709. INSERT INTO `user` VALUES ('王红丽', '123456', '2');
  710. INSERT INTO `user` VALUES ('童景波', '123456', '2');
  711. INSERT INTO `user` VALUES ('徐欢', '123456', '2');
  712. INSERT INTO `user` VALUES ('战昱翔', '123456', '2');
  713. INSERT INTO `user` VALUES ('侯建东', '123456', '2');
  714. INSERT INTO `user` VALUES ('蒋一言', '123456', '2');
  715. INSERT INTO `user` VALUES ('周雪岭', '123456', '2');
  716. INSERT INTO `user` VALUES ('王国虎', '123456', '2');
  717. INSERT INTO `user` VALUES ('陆佳伟', '123456', '2');
  718. INSERT INTO `user` VALUES ('王玉顺', '123456', '2');
  719. INSERT INTO `user` VALUES ('杨顺朋', '123456', '2');
  720. INSERT INTO `user` VALUES ('方兴', '123456', '2');
  721. INSERT INTO `user` VALUES ('奥云', '123456', '2');
  722. INSERT INTO `user` VALUES ('刘炳骥', '123456', '2');
  723. INSERT INTO `user` VALUES ('杨柳', '123456', '2');
  724. INSERT INTO `user` VALUES ('赵惠晤', '123456', '2');
  725. INSERT INTO `user` VALUES ('史文俊', '123456', '2');
  726. INSERT INTO `user` VALUES ('熊双', '123456', '2');
  727. INSERT INTO `user` VALUES ('侯阳', '123456', '2');
  728. INSERT INTO `user` VALUES ('常贺', '123456', '2');
  729. INSERT INTO `user` VALUES ('白日磊', '123456', '2');
  730. INSERT INTO `user` VALUES ('郭丽苹', '123456', '2');
  731. INSERT INTO `user` VALUES ('范秀颂', '123456', '2');
  732. INSERT INTO `user` VALUES ('王世龙', '123456', '2');
  733. INSERT INTO `user` VALUES ('解靠锋', '123456', '2');
  734. INSERT INTO `user` VALUES ('刘伟', '123456', '2');
  735. INSERT INTO `user` VALUES ('肖贺', '123456', '2');
  736. INSERT INTO `user` VALUES ('王鑫', '123456', '2');
  737. INSERT INTO `user` VALUES ('高见', '123456', '2');
  738. INSERT INTO `user` VALUES ('刘新新', '123456', '2');
  739. INSERT INTO `user` VALUES ('熊俊嗣', '123456', '2');
  740. INSERT INTO `user` VALUES ('梁学清', '123456', '2');
  741. INSERT INTO `user` VALUES ('刘均超', '123456', '2');
  742. INSERT INTO `user` VALUES ('马复达', '123456', '2');
  743. INSERT INTO `user` VALUES ('周强', '123456', '2');
  744. INSERT INTO `user` VALUES ('张增太', '123456', '2');
  745. INSERT INTO `user` VALUES ('邓永良', '123456', '2');
  746. INSERT INTO `user` VALUES ('马微', '123456', '2');
  747. INSERT INTO `user` VALUES ('尹献雨', '123456', '2');
  748. INSERT INTO `user` VALUES ('景肖', '123456', '2');
  749. INSERT INTO `user` VALUES ('李巧玲', '123456', '2');
  750. INSERT INTO `user` VALUES ('吴媛媛', '123456', '2');
  751. INSERT INTO `user` VALUES ('华皖玉', '123456', '2');
  752. INSERT INTO `user` VALUES ('叶超', '123456', '2');
  753. INSERT INTO `user` VALUES ('阿达的', '123456', '2');
  754. INSERT INTO `user` VALUES ('黄东辉', '123456', '2');
  755. INSERT INTO `user` VALUES ('许帅', '123456', '2');
  756. INSERT INTO `user` VALUES ('葛鹏', '123456', '2');
  757. INSERT INTO `user` VALUES ('田冰冰', '123456', '2');
  758. INSERT INTO `user` VALUES ('贾皓璋', '123456', '2');
  759. INSERT INTO `user` VALUES ('步皓', '123456', '2');
  760. INSERT INTO `user` VALUES ('谢清', '123456', '2');
  761. INSERT INTO `user` VALUES ('史建博', '123456', '2');
  762. INSERT INTO `user` VALUES ('李鹏翔', '123456', '2');
  763. INSERT INTO `user` VALUES ('李阳', '123456', '2');
  764. INSERT INTO `user` VALUES ('王程宏', '123456', '2');
  765. INSERT INTO `user` VALUES ('王鑫磊', '123456', '2');
  766. INSERT INTO `user` VALUES ('曾志雄', '123456', '2');
  767. INSERT INTO `user` VALUES ('李永刚', '123456', '2');
  768. INSERT INTO `user` VALUES ('周晓飞', '123456', '2');
  769. INSERT INTO `user` VALUES ('孙日阳2', '123456', '2');
  770. INSERT INTO `user` VALUES ('邹文华', '123456', '2');
  771. INSERT INTO `user` VALUES ('熊伟', '123456', '2');
  772. INSERT INTO `user` VALUES ('岳东旭', '123456', '2');
  773. INSERT INTO `user` VALUES ('温锦汶', '123456', '2');
  774. INSERT INTO `user` VALUES ('刘颖琪', '123456', '2');
  775. INSERT INTO `user` VALUES ('郜梦雪', '123456', '2');
  776. INSERT INTO `user` VALUES ('赵泽', '123456', '2');
  777. INSERT INTO `user` VALUES ('罗建成', '123456', '2');
  778. INSERT INTO `user` VALUES ('姚舜超', '123456', '2');
  779. INSERT INTO `user` VALUES ('史可鉴', '123456', '2');
  780. INSERT INTO `user` VALUES ('金晓群', '123456', '2');
  781. INSERT INTO `user` VALUES ('刘开拓', '123456', '2');
  782. INSERT INTO `user` VALUES ('王浩明', '123456', '2');
  783. INSERT INTO `user` VALUES ('周振郭', '123456', '2');
  784. INSERT INTO `user` VALUES ('赵艳敏', '123456', '2');
  785. INSERT INTO `user` VALUES ('张建兵', '123456', '2');
  786. INSERT INTO `user` VALUES ('杨亚帅', '123456', '2');
  787. INSERT INTO `user` VALUES ('高燕敏', '123456', '2');
  788. INSERT INTO `user` VALUES ('叶发成', '123456', '2');
  789. INSERT INTO `user` VALUES ('王珊', '123456', '2');
  790. INSERT INTO `user` VALUES ('朱学林', '123456', '2');
  791. INSERT INTO `user` VALUES ('谢浪', '123456', '2');
  792. INSERT INTO `user` VALUES ('钟文智', '123456', '2');
  793. INSERT INTO `user` VALUES ('王莹', '123456', '2');
  794. INSERT INTO `user` VALUES ('牛涛', '123456', '2');
  795. INSERT INTO `user` VALUES ('母冰冰', '123456', '2');
  796. INSERT INTO `user` VALUES ('赵麟', '123456', '2');
  797. INSERT INTO `user` VALUES ('李玮斌', '123456', '2');
  798. INSERT INTO `user` VALUES ('曾臻', '123456', '2');
  799. INSERT INTO `user` VALUES ('万涛', '123456', '2');
  800. INSERT INTO `user` VALUES ('刘娟娟', '123456', '2');
  801. INSERT INTO `user` VALUES ('许金刚', '123456', '2');
  802. INSERT INTO `user` VALUES ('顾曦', '123456', '2');
  803. INSERT INTO `user` VALUES ('刘金双', '123456', '2');
  804. INSERT INTO `user` VALUES ('黄高坚', '123456', '2');
  805. INSERT INTO `user` VALUES ('宋悦', '123456', '2');
  806. INSERT INTO `user` VALUES ('杨宁', '123456', '2');
  807. INSERT INTO `user` VALUES ('蔡乐', '123456', '2');
  808. INSERT INTO `user` VALUES ('郑志凯', '123456', '2');
  809. INSERT INTO `user` VALUES ('宋利冰', '123456', '2');
  810. INSERT INTO `user` VALUES ('仇伟阳', '123456', '2');
  811. INSERT INTO `user` VALUES ('李书光', '123456', '2');
  812. INSERT INTO `user` VALUES ('申秋辉', '123456', '2');
  813. INSERT INTO `user` VALUES ('杨洋', '123456', '2');
  814. INSERT INTO `user` VALUES ('靳义磊', '123456', '2');
  815. INSERT INTO `user` VALUES ('郭巧巧', '123456', '2');
  816. INSERT INTO `user` VALUES ('孙圣杰', '123456', '2');
  817. INSERT INTO `user` VALUES ('赵济群', '123456', '2');
  818. INSERT INTO `user` VALUES ('齐明空', '123456', '2');
  819. INSERT INTO `user` VALUES ('王杰', '123456', '2');
  820. INSERT INTO `user` VALUES ('严伟', '123456', '2');
  821. INSERT INTO `user` VALUES ('窦强', '123456', '2');
  822. INSERT INTO `user` VALUES ('殷显慧', '123456', '2');
  823. INSERT INTO `user` VALUES ('贺灿文', '123456', '2');
  824. INSERT INTO `user` VALUES ('赵静', '123456', '2');
  825. INSERT INTO `user` VALUES ('涂文超', '123456', '2');
  826. INSERT INTO `user` VALUES ('周硕', '123456', '2');
  827. INSERT INTO `user` VALUES ('史晶晶', '123456', '2');
  828. INSERT INTO `user` VALUES ('王京津', '123456', '2');
  829. INSERT INTO `user` VALUES ('杨涛', '123456', '2');
  830. INSERT INTO `user` VALUES ('王鸯鸯', '123456', '2');
  831. INSERT INTO `user` VALUES ('冯汉超', '123456', '2');
  832. INSERT INTO `user` VALUES ('吴云飞', '123456', '2');
  833. INSERT INTO `user` VALUES ('贾振博', '123456', '2');
  834. INSERT INTO `user` VALUES ('苗莉景', '123456', '2');
  835. INSERT INTO `user` VALUES ('李东东', '123456', '2');
  836. INSERT INTO `user` VALUES ('乔晓峰', '123456', '2');
  837. INSERT INTO `user` VALUES ('杨元皓', '123456', '2');
  838. INSERT INTO `user` VALUES ('方源', '123456', '2');
  839. INSERT INTO `user` VALUES ('金继辉', '123456', '2');
  840. INSERT INTO `user` VALUES ('王超1', '123456', '2');
  841. INSERT INTO `user` VALUES ('廖龙', '123456', '2');
  842. INSERT INTO `user` VALUES ('翟文涛', '123456', '2');
  843. INSERT INTO `user` VALUES ('王一君', '123456', '2');
  844. INSERT INTO `user` VALUES ('张维青', '123456', '2');
  845. INSERT INTO `user` VALUES ('师瑞林', '123456', '2');
  846. INSERT INTO `user` VALUES ('张远', '123456', '2');
  847. INSERT INTO `user` VALUES ('王巍', '123456', '2');
  848. INSERT INTO `user` VALUES ('葛小松', '123456', '2');
  849. INSERT INTO `user` VALUES ('张亚男', '123456', '2');
  850. INSERT INTO `user` VALUES ('王飞', '123456', '2');
  851. INSERT INTO `user` VALUES ('罗紫晋', '123456', '2');
  852. INSERT INTO `user` VALUES ('孟芦', '123456', '2');
  853. INSERT INTO `user` VALUES ('马春义', '123456', '2');
  854. INSERT INTO `user` VALUES ('许枭鹏', '123456', '2');
  855. INSERT INTO `user` VALUES ('曹瑞', '123456', '2');
  856. INSERT INTO `user` VALUES ('王宗祥', '123456', '2');
  857. INSERT INTO `user` VALUES ('黄燕良', '123456', '2');
  858. INSERT INTO `user` VALUES ('张豪', '123456', '2');
  859. INSERT INTO `user` VALUES ('季雨薇', '123456', '2');
  860. INSERT INTO `user` VALUES ('陈元', '123456', '2');
  861. INSERT INTO `user` VALUES ('李剑', '123456', '2');
  862. INSERT INTO `user` VALUES ('李天宇', '123456', '2');
  863. INSERT INTO `user` VALUES ('符怡攀', '123456', '2');
  864. INSERT INTO `user` VALUES ('乔杨', '123456', '2');
  865. INSERT INTO `user` VALUES ('张童', '123456', '2');
  866. INSERT INTO `user` VALUES ('王艳军', '123456', '2');
  867. INSERT INTO `user` VALUES ('史亚鹏', '123456', '2');
  868. INSERT INTO `user` VALUES ('张静', '123456', '2');
  869. INSERT INTO `user` VALUES ('毛德峥', '123456', '2');
  870. INSERT INTO `user` VALUES ('鲁欣', '123456', '2');
  871. INSERT INTO `user` VALUES ('范中源', '123456', '2');
  872. INSERT INTO `user` VALUES ('郭昌魁', '123456', '2');
  873. INSERT INTO `user` VALUES ('郭娜', '123456', '2');
  874. INSERT INTO `user` VALUES ('冉晶晶', '123456', '2');
  875. INSERT INTO `user` VALUES ('伏香钗', '123456', '2');
  876. INSERT INTO `user` VALUES ('李晨阳', '123456', '2');
  877. INSERT INTO `user` VALUES ('曹金宇', '123456', '2');
  878. INSERT INTO `user` VALUES ('王娇', '123456', '2');
  879. INSERT INTO `user` VALUES ('牛恒', '123456', '2');
  880. INSERT INTO `user` VALUES ('马小波', '123456', '2');
  881. INSERT INTO `user` VALUES ('葛占彬', '123456', '2');
  882. INSERT INTO `user` VALUES ('闫存海', '123456', '2');
  883. INSERT INTO `user` VALUES ('孙兴禄', '123456', '2');
  884. INSERT INTO `user` VALUES ('包路奇', '123456', '2');
  885. INSERT INTO `user` VALUES ('韩文', '123456', '2');
  886. INSERT INTO `user` VALUES ('张明浩', '123456', '2');
  887. INSERT INTO `user` VALUES ('林超', '123456', '2');
  888. INSERT INTO `user` VALUES ('范金鼎', '123456', '2');
  889. INSERT INTO `user` VALUES ('汤明', '123456', '2');
  890. INSERT INTO `user` VALUES ('康俊', '123456', '2');
  891. INSERT INTO `user` VALUES ('王恒', '123456', '2');
  892. INSERT INTO `user` VALUES ('刘文琪', '123456', '2');
  893. INSERT INTO `user` VALUES ('彭存', '123456', '2');
  894. INSERT INTO `user` VALUES ('许斌', '123456', '2');
  895. INSERT INTO `user` VALUES ('李霞', '123456', '2');
  896. INSERT INTO `user` VALUES ('马海涛', '123456', '2');
  897. INSERT INTO `user` VALUES ('刘娜', '123456', '2');
  898. INSERT INTO `user` VALUES ('戴霄玥', '123456', '2');
  899. INSERT INTO `user` VALUES ('杨烁', '123456', '2');
  900. INSERT INTO `user` VALUES ('张帅', '123456', '2');
  901. INSERT INTO `user` VALUES ('徐瑶', '123456', '2');
  902. INSERT INTO `user` VALUES ('邓岚', '123456', '2');
  903. INSERT INTO `user` VALUES ('张超群', '123456', '2');
  904. INSERT INTO `user` VALUES ('李艳', '123456', '2');
  905. INSERT INTO `user` VALUES ('马力', '123456', '2');
  906. INSERT INTO `user` VALUES ('阎思远', '123456', '2');
  907. INSERT INTO `user` VALUES ('华正平', '123456', '2');
  908. INSERT INTO `user` VALUES ('邓慧', '123456', '2');
  909. INSERT INTO `user` VALUES ('倪星煜', '123456', '2');
  910. INSERT INTO `user` VALUES ('胡冰瑶', '123456', '2');
  911. INSERT INTO `user` VALUES ('袁丹妮', '123456', '2');
  912. INSERT INTO `user` VALUES ('肖萌', '123456', '2');
  913. INSERT INTO `user` VALUES ('石娱赫', '123456', '2');
  914. INSERT INTO `user` VALUES ('王宇', '123456', '2');
  915. INSERT INTO `user` VALUES ('许南江', '123456', '2');
  916. INSERT INTO `user` VALUES ('张立崇', '123456', '2');
  917. INSERT INTO `user` VALUES ('王公越', '123456', '2');
  918. INSERT INTO `user` VALUES ('安然', '123456', '2');
  919. INSERT INTO `user` VALUES ('陈国强', '123456', '2');
  920. INSERT INTO `user` VALUES ('李雪峰', '123456', '2');
  921. INSERT INTO `user` VALUES ('包政', '123456', '2');
  922. INSERT INTO `user` VALUES ('李莎', '123456', '2');
  923. INSERT INTO `user` VALUES ('沈志强', '123456', '2');
  924. INSERT INTO `user` VALUES ('刘爽', '123456', '2');
  925. INSERT INTO `user` VALUES ('肖国', '123456', '2');
  926. INSERT INTO `user` VALUES ('刘英帅', '123456', '2');
  927. INSERT INTO `user` VALUES ('曹琴娜', '123456', '2');
  928. INSERT INTO `user` VALUES ('苏鸿飞', '123456', '2');
  929. INSERT INTO `user` VALUES ('李井强', '123456', '2');
  930. INSERT INTO `user` VALUES ('吴文军', '123456', '2');
  931. INSERT INTO `user` VALUES ('魏来来', '123456', '2');
  932. INSERT INTO `user` VALUES ('张彬', '123456', '2');
  933. INSERT INTO `user` VALUES ('王腾', '123456', '2');
  934. INSERT INTO `user` VALUES ('马慧娟', '123456', '2');
  935. INSERT INTO `user` VALUES ('陈东浩', '123456', '2');
  936. INSERT INTO `user` VALUES ('张凯', '123456', '2');
  937. INSERT INTO `user` VALUES ('王洪昌', '123456', '2');
  938. INSERT INTO `user` VALUES ('晏永康', '123456', '2');
  939. INSERT INTO `user` VALUES ('王雪松', '123456', '2');
  940. INSERT INTO `user` VALUES ('邵秉森', '123456', '2');
  941. INSERT INTO `user` VALUES ('焦文亮', '123456', '2');
  942. INSERT INTO `user` VALUES ('李骁', '123456', '2');
  943. INSERT INTO `user` VALUES ('蒋星星', '123456', '2');
  944. INSERT INTO `user` VALUES ('陈晓亮', '123456', '2');
  945. INSERT INTO `user` VALUES ('王洪强', '123456', '2');
  946. INSERT INTO `user` VALUES ('王亚东', '123456', '2');
  947. INSERT INTO `user` VALUES ('韩帅', '123456', '2');
  948. INSERT INTO `user` VALUES ('胡沅伶', '123456', '2');
  949. INSERT INTO `user` VALUES ('母莉娜', '123456', '2');
  950. INSERT INTO `user` VALUES ('詹雨田', '123456', '2');
  951. INSERT INTO `user` VALUES ('赵宝峰', '123456', '2');
  952. INSERT INTO `user` VALUES ('张莉娟', '123456', '2');
  953. INSERT INTO `user` VALUES ('韩赟', '123456', '2');
  954. INSERT INTO `user` VALUES ('李润民', '123456', '2');
  955. INSERT INTO `user` VALUES ('耿晓明', '123456', '2');
  956. INSERT INTO `user` VALUES ('马学武', '123456', '2');
  957. INSERT INTO `user` VALUES ('雷嘉兴', '123456', '2');
  958. INSERT INTO `user` VALUES ('文小苏', '123456', '2');
  959. INSERT INTO `user` VALUES ('金瑞丽', '123456', '2');
  960. INSERT INTO `user` VALUES ('郭天亮', '123456', '2');
  961. INSERT INTO `user` VALUES ('李帆', '123456', '2');
  962. INSERT INTO `user` VALUES ('韩永鑫', '123456', '2');
  963. INSERT INTO `user` VALUES ('张亚杰', '123456', '2');
  964. INSERT INTO `user` VALUES ('李梦', '123456', '2');
  965. INSERT INTO `user` VALUES ('李桐', '123456', '2');
  966. INSERT INTO `user` VALUES ('韩瑞', '123456', '2');
  967. INSERT INTO `user` VALUES ('樊琦', '123456', '2');
  968. INSERT INTO `user` VALUES ('宋路遥', '123456', '2');
  969. INSERT INTO `user` VALUES ('刘延召', '123456', '2');
  970. INSERT INTO `user` VALUES ('姜鹏', '123456', '2');
  971. INSERT INTO `user` VALUES ('江鹏', '123456', '2');
  972. INSERT INTO `user` VALUES ('王嵩', '123456', '2');
  973. INSERT INTO `user` VALUES ('孙日阳', '123456', '2');
  974. INSERT INTO `user` VALUES ('刘静坤', '123456', '2');
  975. INSERT INTO `user` VALUES ('李东', '123456', '2');
  976. INSERT INTO `user` VALUES ('王昕', '123456', '2');
  977. INSERT INTO `user` VALUES ('郭松超', '123456', '2');
  978. INSERT INTO `user` VALUES ('齐星全', '123456', '2');
  979. INSERT INTO `user` VALUES ('申昌昊', '123456', '2');
  980. INSERT INTO `user` VALUES ('王延乐', '123456', '2');
  981. INSERT INTO `user` VALUES ('许二冬', '123456', '2');
  982. INSERT INTO `user` VALUES ('李玲艳', '123456', '2');
  983. INSERT INTO `user` VALUES ('闫永凯', '123456', '2');
  984. INSERT INTO `user` VALUES ('刘玉', '123456', '2');
  985. INSERT INTO `user` VALUES ('甘佩华', '123456', '2');
  986. INSERT INTO `user` VALUES ('柴难让', '123456', '2');
  987. INSERT INTO `user` VALUES ('周利娟', '123456', '2');
  988. INSERT INTO `user` VALUES ('锁志平', '123456', '2');
  989. INSERT INTO `user` VALUES ('梁峰彰', '123456', '2');
  990. INSERT INTO `user` VALUES ('王永存', '123456', '2');
  991. INSERT INTO `user` VALUES ('谭振东', '123456', '2');
  992. INSERT INTO `user` VALUES ('吴胜宗', '123456', '2');
  993. INSERT INTO `user` VALUES ('text', '123456', '2');
  994. INSERT INTO `user` VALUES ('郝星', '123456', '2');
  995. INSERT INTO `user` VALUES ('聂祥周', '123456', '2');
  996. INSERT INTO `user` VALUES ('张忠林', '123456', '2');
  997. INSERT INTO `user` VALUES ('鲁锐', '123456', '2');
  998. INSERT INTO `user` VALUES ('李凯乐', '123456', '2');
  999. INSERT INTO `user` VALUES ('王洋洋1', '123456', '2');
  1000. INSERT INTO `user` VALUES ('王宁', '123456', '2');
  1001. INSERT INTO `user` VALUES ('刘福省', '123456', '2');
  1002. INSERT INTO `user` VALUES ('高浩轩', '123456', '2');
  1003. -- ----------------------------------------
  1004. -- Table structure for roomauthority--会议室权限
  1005. -- ----------------------------------------
  1006. Drop TABLE IF EXISTS `room_authority`;
  1007. CREATE Table `room_authority`(
  1008. `id` int(11) NOT NULL AUTO_INCREMENT,
  1009. `room_id` int(11) NOT NULL,
  1010. `user_id` varchar(32) NOT NULL,
  1011. PRIMARY KEY (`id`),
  1012. KEY `fk_authority_room` (`room_id`),
  1013. CONSTRAINT `fk_authority_room` FOREIGN KEY (`room_id`) REFERENCES `room` (`id`),
  1014. KEY `fk_authority_user` (user_id),
  1015. CONSTRAINT `fk_authority_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
  1016. )ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
  1017. -- ----------------------------
  1018. -- Records of roomauthority
  1019. -- ----------------------------