| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057 |
- /*
- Navicat MySQL Data Transfer
- Source Server : localhost_3306
- Source Server Version : 50635
- Source Host : localhost:3306
- Source Database : conference_room
- Target Server Type : MYSQL
- Target Server Version : 50635
- File Encoding : 65001
- Date: 2019-02-12 22:28:13
- */
- SET FOREIGN_KEY_CHECKS=0;
- -- ----------------------------
- -- Table structure for reservation
- -- ----------------------------
- DROP TABLE IF EXISTS `reservation`;
- CREATE TABLE `reservation` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `room_id` int(11) DEFAULT NULL,
- `user` varchar(32) DEFAULT NULL,
- `mobile` varchar(20) DEFAULT NULL,
- `date` date DEFAULT NULL,
- `begintime` time DEFAULT NULL,
- `endtime` time DEFAULT NULL,
- `mark` varchar(10) DEFAULT NULL,
- -- 主题
- `subject` varchar(60) DEFAULT NULL,
- -- 部门
- `department` varchar(60) DEFAULT NULL,
- -- 会议纪要
- `summary` varchar(5000) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_reservation_room` (`room_id`),
- CONSTRAINT `fk_reservation_room` FOREIGN KEY (`room_id`) REFERENCES `room` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Records of reservation
- -- ----------------------------
- -- ---------------------------------------------------
- -- Table structure for reservation_users--参会人员
- -- ---------------------------------------------------
- Drop TABLE IF EXISTS `reservation_users`;
- CREATE Table `reservation_users`(
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `reservation_id` int(11) NOT NULL,
- `user_id` varchar(32) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_reservation_users_reservation` (reservation_id),
- CONSTRAINT `fk_reservation_users_reservation` FOREIGN KEY (`reservation_id`) REFERENCES `reservation` (`id`),
- KEY `fk_reservation_users_user` (user_id),
- CONSTRAINT `fk_reservation_users_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
- )ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Records of reservation_users
- -- ----------------------------
- -- ---------------------------------------------------
- -- Table structure for reservation_resource--会议资料
- -- ---------------------------------------------------
- Drop TABLE IF EXISTS `reservation_resource`;
- CREATE TABLE `reservation_resource` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `reservation_id` int(11) NOT NULL,
- -- 资料名称
- `name` varchar(60) NOT NULL,
- -- 资料路径
- `path` varchar(100) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_reservation_users_room` (reservation_id),
- CONSTRAINT `fk_reservation_users_room` FOREIGN KEY (`reservation_id`) REFERENCES `reservation` (`id`)
- )ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Records of reservation_resource
- -- ----------------------------
- -- ----------------------------
- -- Table structure for role
- -- ----------------------------
- DROP TABLE IF EXISTS `role`;
- CREATE TABLE `role` (
- `role_id` int(11) NOT NULL,
- `role_name` varchar(50) DEFAULT NULL,
- PRIMARY KEY (`role_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Records of role
- -- ----------------------------
- INSERT INTO `role` VALUES ('1', 'admin');
- INSERT INTO `role` VALUES ('2', 'ordinary');
- -- ----------------------------
- -- Table structure for room
- -- ----------------------------
- DROP TABLE IF EXISTS `room`;
- CREATE TABLE `room` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(60) NOT NULL,
- `message` varchar(200) DEFAULT NULL,
- -- 物理位置
- `position` varchar(200) DEFAULT NULL,
- -- 会议室图片
- `image` varchar(200) DEFAULT NULL,
- -- 容量
- `capacity` int(11) DEFAULT NULL,
- -- 会议室区域
- `region` varchar(60) DEFAULT NULL,
- -- 会议室二维码
- `code` varchar(60) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Records of room
- -- ----------------------------
- INSERT INTO `room`(id,name,message) VALUES ('1', 'Cpeco会议室', '小会议室,适合十人小型会议,含多媒体');
- INSERT INTO `room`(id,name,message) VALUES ('2', 'Meos会议室', '大型会议室,可使用多媒体,适合开会、讲座');
- INSERT INTO `room`(id,name,message) VALUES ('3', 'Wellzoom会议室', '小会议室,适合十人小型会议,含多媒体');
- INSERT INTO `room`(id,name,message) VALUES ('4', '上格云大会议室', '大型会议室,可使用多媒体,适合开会、讲座');
- INSERT INTO `room`(id,name,message) VALUES ('5', '尚格云小会议室', '小会议室,适合十人小型会议,含多媒体');
- INSERT INTO `room`(id,name,message) VALUES ('6', 'Beecom会议室', '小会议室,适合十人小型会议,含多媒体');
- -- ----------------------------------------
- -- Table structure for Facility--会议室设备
- -- ----------------------------------------
- Drop TABLE IF EXISTS `facility`;
- CREATE Table `facility`(
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `room_id` int(11) NOT NULL,
- `facility_name` varchar(60) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_facility_room` (`room_id`),
- CONSTRAINT `fk_facility_room` FOREIGN KEY (`room_id`) REFERENCES `room` (`id`)
- )ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Records of Facility
- -- ----------------------------
- -- ----------------------------
- -- Table structure for user
- -- ----------------------------
- DROP TABLE IF EXISTS `user`;
- CREATE TABLE `user` (
- `id` varchar(32) NOT NULL,
- `password` varchar(32) NOT NULL,
- `role` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_user_role` (`role`),
- CONSTRAINT `fk_user_role` FOREIGN KEY (`role`) REFERENCES `role` (`role_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Records of user
- -- ----------------------------
- INSERT INTO `user` VALUES ('201801', '123', '2');
- INSERT INTO `user` VALUES ('admin', 'emadmin', '1');
- INSERT INTO `user` VALUES ('ordinary', '123456', '2');
- INSERT INTO `user` VALUES ('李京鄂', '123456', '2');
- INSERT INTO `user` VALUES ('木小龙', '123456', '2');
- INSERT INTO `user` VALUES ('范丽颖', '123456', '2');
- INSERT INTO `user` VALUES ('王珊1', '123456', '2');
- INSERT INTO `user` VALUES ('张晶晶', '123456', '2');
- INSERT INTO `user` VALUES ('李俊威', '123456', '2');
- INSERT INTO `user` VALUES ('陈涛1', '123456', '2');
- INSERT INTO `user` VALUES ('刘西良', '123456', '2');
- INSERT INTO `user` VALUES ('蔡文琪', '123456', '2');
- INSERT INTO `user` VALUES ('王俊', '123456', '2');
- INSERT INTO `user` VALUES ('陈荟任', '123456', '2');
- INSERT INTO `user` VALUES ('薛敬雷', '123456', '2');
- INSERT INTO `user` VALUES ('王勤泽', '123456', '2');
- INSERT INTO `user` VALUES ('李旭', '123456', '2');
- INSERT INTO `user` VALUES ('张雨晴', '123456', '2');
- INSERT INTO `user` VALUES ('苏建飞', '123456', '2');
- INSERT INTO `user` VALUES ('王龙', '123456', '2');
- INSERT INTO `user` VALUES ('侯爽', '123456', '2');
- INSERT INTO `user` VALUES ('陈俊宏', '123456', '2');
- INSERT INTO `user` VALUES ('王熙婷', '123456', '2');
- INSERT INTO `user` VALUES ('李浩3', '123456', '2');
- INSERT INTO `user` VALUES ('袁锦旺', '123456', '2');
- INSERT INTO `user` VALUES ('李坤', '123456', '2');
- INSERT INTO `user` VALUES ('段超', '123456', '2');
- INSERT INTO `user` VALUES ('李浩2', '123456', '2');
- INSERT INTO `user` VALUES ('邹业强', '123456', '2');
- INSERT INTO `user` VALUES ('马圆', '123456', '2');
- INSERT INTO `user` VALUES ('王贺平', '123456', '2');
- INSERT INTO `user` VALUES ('杨勇', '123456', '2');
- INSERT INTO `user` VALUES ('杨琳', '123456', '2');
- INSERT INTO `user` VALUES ('刘世彪', '123456', '2');
- INSERT INTO `user` VALUES ('段瑞超', '123456', '2');
- INSERT INTO `user` VALUES ('赵宏昌', '123456', '2');
- INSERT INTO `user` VALUES ('郑成茂', '123456', '2');
- INSERT INTO `user` VALUES ('邓浩', '123456', '2');
- INSERT INTO `user` VALUES ('李晨禹', '123456', '2');
- INSERT INTO `user` VALUES ('孙锦阳', '123456', '2');
- INSERT INTO `user` VALUES ('石立强', '123456', '2');
- INSERT INTO `user` VALUES ('时欣意', '123456', '2');
- INSERT INTO `user` VALUES ('廖仁强', '123456', '2');
- INSERT INTO `user` VALUES ('王建何', '123456', '2');
- INSERT INTO `user` VALUES ('杨伟欢', '123456', '2');
- INSERT INTO `user` VALUES ('陈彦超', '123456', '2');
- INSERT INTO `user` VALUES ('刘建超', '123456', '2');
- INSERT INTO `user` VALUES ('丁言', '123456', '2');
- INSERT INTO `user` VALUES ('白轲', '123456', '2');
- INSERT INTO `user` VALUES ('闫鸿飞', '123456', '2');
- INSERT INTO `user` VALUES ('袁秋磊', '123456', '2');
- INSERT INTO `user` VALUES ('钟曼玉', '123456', '2');
- INSERT INTO `user` VALUES ('王礼军', '123456', '2');
- INSERT INTO `user` VALUES ('何一凡', '123456', '2');
- INSERT INTO `user` VALUES ('甘德维', '123456', '2');
- INSERT INTO `user` VALUES ('黄文亮', '123456', '2');
- INSERT INTO `user` VALUES ('柏林', '123456', '2');
- INSERT INTO `user` VALUES ('杜佳峰', '123456', '2');
- INSERT INTO `user` VALUES ('饶华', '123456', '2');
- INSERT INTO `user` VALUES ('杜迪', '123456', '2');
- INSERT INTO `user` VALUES ('杜宣言', '123456', '2');
- INSERT INTO `user` VALUES ('刘晗', '123456', '2');
- INSERT INTO `user` VALUES ('黄国旺', '123456', '2');
- INSERT INTO `user` VALUES ('王子恒', '123456', '2');
- INSERT INTO `user` VALUES ('李鹏麒', '123456', '2');
- INSERT INTO `user` VALUES ('杨新宇', '123456', '2');
- INSERT INTO `user` VALUES ('魏运华', '123456', '2');
- INSERT INTO `user` VALUES ('魏国仕', '123456', '2');
- INSERT INTO `user` VALUES ('韩龙', '123456', '2');
- INSERT INTO `user` VALUES ('李涛', '123456', '2');
- INSERT INTO `user` VALUES ('隋佳峻', '123456', '2');
- INSERT INTO `user` VALUES ('魏永东', '123456', '2');
- INSERT INTO `user` VALUES ('范志豪', '123456', '2');
- INSERT INTO `user` VALUES ('于明伟', '123456', '2');
- INSERT INTO `user` VALUES ('郑亚飞', '123456', '2');
- INSERT INTO `user` VALUES ('白俊杰', '123456', '2');
- INSERT INTO `user` VALUES ('葛薇', '123456', '2');
- INSERT INTO `user` VALUES ('池利娟', '123456', '2');
- INSERT INTO `user` VALUES ('赵腾飞', '123456', '2');
- INSERT INTO `user` VALUES ('向莉', '123456', '2');
- INSERT INTO `user` VALUES ('王文延', '123456', '2');
- INSERT INTO `user` VALUES ('李玲玲', '123456', '2');
- INSERT INTO `user` VALUES ('刘雨东', '123456', '2');
- INSERT INTO `user` VALUES ('张雅萍', '123456', '2');
- INSERT INTO `user` VALUES ('周学宇', '123456', '2');
- INSERT INTO `user` VALUES ('栾金颖', '123456', '2');
- INSERT INTO `user` VALUES ('李智婕', '123456', '2');
- INSERT INTO `user` VALUES ('陈中山', '123456', '2');
- INSERT INTO `user` VALUES ('吴若飒', '123456', '2');
- INSERT INTO `user` VALUES ('张振宇', '123456', '2');
- INSERT INTO `user` VALUES ('狄雨佳', '123456', '2');
- INSERT INTO `user` VALUES ('杨东升', '123456', '2');
- INSERT INTO `user` VALUES ('赵争艳', '123456', '2');
- INSERT INTO `user` VALUES ('庞欢', '123456', '2');
- INSERT INTO `user` VALUES ('肖丽', '123456', '2');
- INSERT INTO `user` VALUES ('郭姝璇', '123456', '2');
- INSERT INTO `user` VALUES ('陆千富', '123456', '2');
- INSERT INTO `user` VALUES ('吕娇莉', '123456', '2');
- INSERT INTO `user` VALUES ('陈伟军', '123456', '2');
- INSERT INTO `user` VALUES ('李松', '123456', '2');
- INSERT INTO `user` VALUES ('赖星其', '123456', '2');
- INSERT INTO `user` VALUES ('陈媖', '123456', '2');
- INSERT INTO `user` VALUES ('贾笑丽', '123456', '2');
- INSERT INTO `user` VALUES ('孙月', '123456', '2');
- INSERT INTO `user` VALUES ('谭庆威', '123456', '2');
- INSERT INTO `user` VALUES ('邵泓博', '123456', '2');
- INSERT INTO `user` VALUES ('李林善', '123456', '2');
- INSERT INTO `user` VALUES ('胡立松', '123456', '2');
- INSERT INTO `user` VALUES ('杜军明', '123456', '2');
- INSERT INTO `user` VALUES ('郭杰夫', '123456', '2');
- INSERT INTO `user` VALUES ('刘杰', '123456', '2');
- INSERT INTO `user` VALUES ('陈娴', '123456', '2');
- INSERT INTO `user` VALUES ('边琼阳', '123456', '2');
- INSERT INTO `user` VALUES ('候晓波', '123456', '2');
- INSERT INTO `user` VALUES ('桂璇', '123456', '2');
- INSERT INTO `user` VALUES ('陶俊羽', '123456', '2');
- INSERT INTO `user` VALUES ('李磊', '123456', '2');
- INSERT INTO `user` VALUES ('王清慧', '123456', '2');
- INSERT INTO `user` VALUES ('朱嘉君', '123456', '2');
- INSERT INTO `user` VALUES ('杨伯禹', '123456', '2');
- INSERT INTO `user` VALUES ('刘慧莹', '123456', '2');
- INSERT INTO `user` VALUES ('肖曼', '123456', '2');
- INSERT INTO `user` VALUES ('段悦', '123456', '2');
- INSERT INTO `user` VALUES ('黄向静', '123456', '2');
- INSERT INTO `user` VALUES ('李婧雯', '123456', '2');
- INSERT INTO `user` VALUES ('朱杰', '123456', '2');
- INSERT INTO `user` VALUES ('王凯军', '123456', '2');
- INSERT INTO `user` VALUES ('李鹏飞', '123456', '2');
- INSERT INTO `user` VALUES ('秦炜炜', '123456', '2');
- INSERT INTO `user` VALUES ('李海碧', '123456', '2');
- INSERT INTO `user` VALUES ('林萌', '123456', '2');
- INSERT INTO `user` VALUES ('高杨', '123456', '2');
- INSERT INTO `user` VALUES ('黄浩然', '123456', '2');
- INSERT INTO `user` VALUES ('冯忠学', '123456', '2');
- INSERT INTO `user` VALUES ('马丽雪', '123456', '2');
- INSERT INTO `user` VALUES ('吴明星', '123456', '2');
- INSERT INTO `user` VALUES ('温浩', '123456', '2');
- INSERT INTO `user` VALUES ('冯长浩', '123456', '2');
- INSERT INTO `user` VALUES ('刘洪磊', '123456', '2');
- INSERT INTO `user` VALUES ('秦智勇', '123456', '2');
- INSERT INTO `user` VALUES ('陈成', '123456', '2');
- INSERT INTO `user` VALUES ('张超', '123456', '2');
- INSERT INTO `user` VALUES ('侯悦', '123456', '2');
- INSERT INTO `user` VALUES ('刘松', '123456', '2');
- INSERT INTO `user` VALUES ('王鹏', '123456', '2');
- INSERT INTO `user` VALUES ('赵闯', '123456', '2');
- INSERT INTO `user` VALUES ('司蔚蔚', '123456', '2');
- INSERT INTO `user` VALUES ('席东霞', '123456', '2');
- INSERT INTO `user` VALUES ('付慧', '123456', '2');
- INSERT INTO `user` VALUES ('胡家政', '123456', '2');
- INSERT INTO `user` VALUES ('周晓强', '123456', '2');
- INSERT INTO `user` VALUES ('惠彦斌', '123456', '2');
- INSERT INTO `user` VALUES ('赵博', '123456', '2');
- INSERT INTO `user` VALUES ('柳佳伟', '123456', '2');
- INSERT INTO `user` VALUES ('王兰旭', '123456', '2');
- INSERT INTO `user` VALUES ('张鹏飞', '123456', '2');
- INSERT INTO `user` VALUES ('杨静婷', '123456', '2');
- INSERT INTO `user` VALUES ('赵旭', '123456', '2');
- INSERT INTO `user` VALUES ('罗铃松', '123456', '2');
- INSERT INTO `user` VALUES ('蒋克文', '123456', '2');
- INSERT INTO `user` VALUES ('王东军', '123456', '2');
- INSERT INTO `user` VALUES ('周玉涛', '123456', '2');
- INSERT INTO `user` VALUES ('高明', '123456', '2');
- INSERT INTO `user` VALUES ('王丹丹', '123456', '2');
- INSERT INTO `user` VALUES ('范铄', '123456', '2');
- INSERT INTO `user` VALUES ('连玉洁', '123456', '2');
- INSERT INTO `user` VALUES ('武濛濛', '123456', '2');
- INSERT INTO `user` VALUES ('张暄', '123456', '2');
- INSERT INTO `user` VALUES ('党伟康', '123456', '2');
- INSERT INTO `user` VALUES ('王雪', '123456', '2');
- INSERT INTO `user` VALUES ('化笑炎', '123456', '2');
- INSERT INTO `user` VALUES ('张媛媛', '123456', '2');
- INSERT INTO `user` VALUES ('王磊1', '123456', '2');
- INSERT INTO `user` VALUES ('张骋', '123456', '2');
- INSERT INTO `user` VALUES ('何德志', '123456', '2');
- INSERT INTO `user` VALUES ('扶鑫', '123456', '2');
- INSERT INTO `user` VALUES ('马帅', '123456', '2');
- INSERT INTO `user` VALUES ('杨忠红', '123456', '2');
- INSERT INTO `user` VALUES ('肖征', '123456', '2');
- INSERT INTO `user` VALUES ('田野', '123456', '2');
- INSERT INTO `user` VALUES ('洪克军', '123456', '2');
- INSERT INTO `user` VALUES ('张磊', '123456', '2');
- INSERT INTO `user` VALUES ('王海龙', '123456', '2');
- INSERT INTO `user` VALUES ('常海', '123456', '2');
- INSERT INTO `user` VALUES ('张慧君', '123456', '2');
- INSERT INTO `user` VALUES ('高帅', '123456', '2');
- INSERT INTO `user` VALUES ('王明明', '123456', '2');
- INSERT INTO `user` VALUES ('徐瑜', '123456', '2');
- INSERT INTO `user` VALUES ('邹敏华', '123456', '2');
- INSERT INTO `user` VALUES ('李云飞', '123456', '2');
- INSERT INTO `user` VALUES ('范南雁', '123456', '2');
- INSERT INTO `user` VALUES ('陈德海', '123456', '2');
- INSERT INTO `user` VALUES ('邓晓鹏', '123456', '2');
- INSERT INTO `user` VALUES ('彭晶晶', '123456', '2');
- INSERT INTO `user` VALUES ('刘世祥', '123456', '2');
- INSERT INTO `user` VALUES ('王智鹏', '123456', '2');
- INSERT INTO `user` VALUES ('江江', '123456', '2');
- INSERT INTO `user` VALUES ('金大钧', '123456', '2');
- INSERT INTO `user` VALUES ('任立山', '123456', '2');
- INSERT INTO `user` VALUES ('王雅惠', '123456', '2');
- INSERT INTO `user` VALUES ('许金丽', '123456', '2');
- INSERT INTO `user` VALUES ('何建强', '123456', '2');
- INSERT INTO `user` VALUES ('李冬梅', '123456', '2');
- INSERT INTO `user` VALUES ('康军红', '123456', '2');
- INSERT INTO `user` VALUES ('田雨森', '123456', '2');
- INSERT INTO `user` VALUES ('范晓宇', '123456', '2');
- INSERT INTO `user` VALUES ('洪迎迎', '123456', '2');
- INSERT INTO `user` VALUES ('张丹丹', '123456', '2');
- INSERT INTO `user` VALUES ('徐彬', '123456', '2');
- INSERT INTO `user` VALUES ('李爽菲', '123456', '2');
- INSERT INTO `user` VALUES ('杨末', '123456', '2');
- INSERT INTO `user` VALUES ('林玉涵', '123456', '2');
- INSERT INTO `user` VALUES ('陈聪', '123456', '2');
- INSERT INTO `user` VALUES ('高凤', '123456', '2');
- INSERT INTO `user` VALUES ('刘红洋', '123456', '2');
- INSERT INTO `user` VALUES ('杨思佳', '123456', '2');
- INSERT INTO `user` VALUES ('周雨娇', '123456', '2');
- INSERT INTO `user` VALUES ('陶溯', '123456', '2');
- INSERT INTO `user` VALUES ('杨志刚', '123456', '2');
- INSERT INTO `user` VALUES ('付勇琪', '123456', '2');
- INSERT INTO `user` VALUES ('安少辉', '123456', '2');
- INSERT INTO `user` VALUES ('张梦媛', '123456', '2');
- INSERT INTO `user` VALUES ('闫嘉玮', '123456', '2');
- INSERT INTO `user` VALUES ('祝瑞', '123456', '2');
- INSERT INTO `user` VALUES ('崔文波', '123456', '2');
- INSERT INTO `user` VALUES ('丁惊涛', '123456', '2');
- INSERT INTO `user` VALUES ('宁云飞', '123456', '2');
- INSERT INTO `user` VALUES ('耿占民', '123456', '2');
- INSERT INTO `user` VALUES ('周保永', '123456', '2');
- INSERT INTO `user` VALUES ('陈涛', '123456', '2');
- INSERT INTO `user` VALUES ('王钰博', '123456', '2');
- INSERT INTO `user` VALUES ('王凯山', '123456', '2');
- INSERT INTO `user` VALUES ('刘梦楠', '123456', '2');
- INSERT INTO `user` VALUES ('万里涛', '123456', '2');
- INSERT INTO `user` VALUES ('安晨曦', '123456', '2');
- INSERT INTO `user` VALUES ('孔胜祥', '123456', '2');
- INSERT INTO `user` VALUES ('张晓林', '123456', '2');
- INSERT INTO `user` VALUES ('姜永涛', '123456', '2');
- INSERT INTO `user` VALUES ('郭江波', '123456', '2');
- INSERT INTO `user` VALUES ('张志尧', '123456', '2');
- INSERT INTO `user` VALUES ('赵彦涛', '123456', '2');
- INSERT INTO `user` VALUES ('刘佟', '123456', '2');
- INSERT INTO `user` VALUES ('刘学志', '123456', '2');
- INSERT INTO `user` VALUES ('于柏松', '123456', '2');
- INSERT INTO `user` VALUES ('王超', '123456', '2');
- INSERT INTO `user` VALUES ('段瑞香', '123456', '2');
- INSERT INTO `user` VALUES ('王凡', '123456', '2');
- INSERT INTO `user` VALUES ('唐蕾', '123456', '2');
- INSERT INTO `user` VALUES ('覃漳', '123456', '2');
- INSERT INTO `user` VALUES ('樊玉松', '123456', '2');
- INSERT INTO `user` VALUES ('严小远', '123456', '2');
- INSERT INTO `user` VALUES ('邬倩倩', '123456', '2');
- INSERT INTO `user` VALUES ('张德虎', '123456', '2');
- INSERT INTO `user` VALUES ('翟宇杰', '123456', '2');
- INSERT INTO `user` VALUES ('孙金宝', '123456', '2');
- INSERT INTO `user` VALUES ('岳彩普', '123456', '2');
- INSERT INTO `user` VALUES ('杨杰锋', '123456', '2');
- INSERT INTO `user` VALUES ('杨乐', '123456', '2');
- INSERT INTO `user` VALUES ('魏接晖', '123456', '2');
- INSERT INTO `user` VALUES ('朱永磊', '123456', '2');
- INSERT INTO `user` VALUES ('龙建超', '123456', '2');
- INSERT INTO `user` VALUES ('郝书彰', '123456', '2');
- INSERT INTO `user` VALUES ('汪存文', '123456', '2');
- INSERT INTO `user` VALUES ('周广龙', '123456', '2');
- INSERT INTO `user` VALUES ('张武', '123456', '2');
- INSERT INTO `user` VALUES ('宋好义', '123456', '2');
- INSERT INTO `user` VALUES ('丁亮', '123456', '2');
- INSERT INTO `user` VALUES ('王磊', '123456', '2');
- INSERT INTO `user` VALUES ('李杰', '123456', '2');
- INSERT INTO `user` VALUES ('李浩', '123456', '2');
- INSERT INTO `user` VALUES ('左丞', '123456', '2');
- INSERT INTO `user` VALUES ('王茂波', '123456', '2');
- INSERT INTO `user` VALUES ('张圣仓', '123456', '2');
- INSERT INTO `user` VALUES ('车成浩', '123456', '2');
- INSERT INTO `user` VALUES ('纪永强', '123456', '2');
- INSERT INTO `user` VALUES ('马娟', '123456', '2');
- INSERT INTO `user` VALUES ('葛小松-', '123456', '2');
- INSERT INTO `user` VALUES ('钱亮', '123456', '2');
- INSERT INTO `user` VALUES ('黄得恩', '123456', '2');
- INSERT INTO `user` VALUES ('史超', '123456', '2');
- INSERT INTO `user` VALUES ('汪文博', '123456', '2');
- INSERT INTO `user` VALUES ('史辉', '123456', '2');
- INSERT INTO `user` VALUES ('戈弋', '123456', '2');
- INSERT INTO `user` VALUES ('刘博玮', '123456', '2');
- INSERT INTO `user` VALUES ('于小威', '123456', '2');
- INSERT INTO `user` VALUES ('丁宝柱', '123456', '2');
- INSERT INTO `user` VALUES ('王晓宇', '123456', '2');
- INSERT INTO `user` VALUES ('李保成', '123456', '2');
- INSERT INTO `user` VALUES ('李万新', '123456', '2');
- INSERT INTO `user` VALUES ('解枫', '123456', '2');
- INSERT INTO `user` VALUES ('李若冲', '123456', '2');
- INSERT INTO `user` VALUES ('王伟', '123456', '2');
- INSERT INTO `user` VALUES ('高乐', '123456', '2');
- INSERT INTO `user` VALUES ('时启相', '123456', '2');
- INSERT INTO `user` VALUES ('吴丽琼', '123456', '2');
- INSERT INTO `user` VALUES ('苏月', '123456', '2');
- INSERT INTO `user` VALUES ('张颖佳', '123456', '2');
- INSERT INTO `user` VALUES ('刘永', '123456', '2');
- INSERT INTO `user` VALUES ('王弘韬', '123456', '2');
- INSERT INTO `user` VALUES ('杜博', '123456', '2');
- INSERT INTO `user` VALUES ('李东鹏', '123456', '2');
- INSERT INTO `user` VALUES ('龚正', '123456', '2');
- INSERT INTO `user` VALUES ('祝园园', '123456', '2');
- INSERT INTO `user` VALUES ('李航', '123456', '2');
- INSERT INTO `user` VALUES ('曹征', '123456', '2');
- INSERT INTO `user` VALUES ('张云云', '123456', '2');
- INSERT INTO `user` VALUES ('胡剑辉', '123456', '2');
- INSERT INTO `user` VALUES ('曹康应', '123456', '2');
- INSERT INTO `user` VALUES ('李佩佳', '123456', '2');
- INSERT INTO `user` VALUES ('宋天瑶', '123456', '2');
- INSERT INTO `user` VALUES ('韩伟', '123456', '2');
- INSERT INTO `user` VALUES ('李强', '123456', '2');
- INSERT INTO `user` VALUES ('张晨曦', '123456', '2');
- INSERT INTO `user` VALUES ('李洪吉', '123456', '2');
- INSERT INTO `user` VALUES ('宗源', '123456', '2');
- INSERT INTO `user` VALUES ('高创库', '123456', '2');
- INSERT INTO `user` VALUES ('刘贵轩', '123456', '2');
- INSERT INTO `user` VALUES ('周德斐', '123456', '2');
- INSERT INTO `user` VALUES ('周演', '123456', '2');
- INSERT INTO `user` VALUES ('江崇邦', '123456', '2');
- INSERT INTO `user` VALUES ('沈启', '123456', '2');
- INSERT INTO `user` VALUES ('刘楠', '123456', '2');
- INSERT INTO `user` VALUES ('周洋帆', '123456', '2');
- INSERT INTO `user` VALUES ('李超', '123456', '2');
- INSERT INTO `user` VALUES ('刘伟鑫', '123456', '2');
- INSERT INTO `user` VALUES ('吕华杰', '123456', '2');
- INSERT INTO `user` VALUES ('杨启凡', '123456', '2');
- INSERT INTO `user` VALUES ('耿锁锋', '123456', '2');
- INSERT INTO `user` VALUES ('吕学广', '123456', '2');
- INSERT INTO `user` VALUES ('程丽娇', '123456', '2');
- INSERT INTO `user` VALUES ('赵昕', '123456', '2');
- INSERT INTO `user` VALUES ('王欢欢', '123456', '2');
- INSERT INTO `user` VALUES ('张善国', '123456', '2');
- INSERT INTO `user` VALUES ('张志双', '123456', '2');
- INSERT INTO `user` VALUES ('赵锴', '123456', '2');
- INSERT INTO `user` VALUES ('卫盼', '123456', '2');
- INSERT INTO `user` VALUES ('芦海锋', '123456', '2');
- INSERT INTO `user` VALUES ('李文婕', '123456', '2');
- INSERT INTO `user` VALUES ('荣宇红', '123456', '2');
- INSERT INTO `user` VALUES ('孙晓鹏', '123456', '2');
- INSERT INTO `user` VALUES ('楚雅迪', '123456', '2');
- INSERT INTO `user` VALUES ('张勇嘉', '123456', '2');
- INSERT INTO `user` VALUES ('王洋洋', '123456', '2');
- INSERT INTO `user` VALUES ('掌梦阳', '123456', '2');
- INSERT INTO `user` VALUES ('冯复汉', '123456', '2');
- INSERT INTO `user` VALUES ('周爱娟', '123456', '2');
- INSERT INTO `user` VALUES ('赵纯', '123456', '2');
- INSERT INTO `user` VALUES ('段潘英', '123456', '2');
- INSERT INTO `user` VALUES ('高子旭', '123456', '2');
- INSERT INTO `user` VALUES ('李士勇', '123456', '2');
- INSERT INTO `user` VALUES ('张子恒', '123456', '2');
- INSERT INTO `user` VALUES ('秦晓强', '123456', '2');
- INSERT INTO `user` VALUES ('李蓉', '123456', '2');
- INSERT INTO `user` VALUES ('王华平', '123456', '2');
- INSERT INTO `user` VALUES ('胡礼霞', '123456', '2');
- INSERT INTO `user` VALUES ('1', '123456', '2');
- INSERT INTO `user` VALUES ('龚世超', '123456', '2');
- INSERT INTO `user` VALUES ('张凌霄', '123456', '2');
- INSERT INTO `user` VALUES ('孙楷', '123456', '2');
- INSERT INTO `user` VALUES ('史佳成', '123456', '2');
- INSERT INTO `user` VALUES ('123213', '123456', '2');
- INSERT INTO `user` VALUES ('李佳帅', '123456', '2');
- INSERT INTO `user` VALUES ('刘林安', '123456', '2');
- INSERT INTO `user` VALUES ('毛锟', '123456', '2');
- INSERT INTO `user` VALUES ('魏志雄', '123456', '2');
- INSERT INTO `user` VALUES ('郭志骞', '123456', '2');
- INSERT INTO `user` VALUES ('李珊', '123456', '2');
- INSERT INTO `user` VALUES ('王雪1', '123456', '2');
- INSERT INTO `user` VALUES ('刘仕琦', '123456', '2');
- INSERT INTO `user` VALUES ('张合松', '123456', '2');
- INSERT INTO `user` VALUES ('刘凌鹏', '123456', '2');
- INSERT INTO `user` VALUES ('黎港', '123456', '2');
- INSERT INTO `user` VALUES ('韩硕', '123456', '2');
- INSERT INTO `user` VALUES ('季雯雯', '123456', '2');
- INSERT INTO `user` VALUES ('王育硕', '123456', '2');
- INSERT INTO `user` VALUES ('杨鹏', '123456', '2');
- INSERT INTO `user` VALUES ('李聚鑫', '123456', '2');
- INSERT INTO `user` VALUES ('王松庆', '123456', '2');
- INSERT INTO `user` VALUES ('陈鹏', '123456', '2');
- INSERT INTO `user` VALUES ('陈玉柱', '123456', '2');
- INSERT INTO `user` VALUES ('吴东金', '123456', '2');
- INSERT INTO `user` VALUES ('崔莹', '123456', '2');
- INSERT INTO `user` VALUES ('叶小思', '123456', '2');
- INSERT INTO `user` VALUES ('范仔骏', '123456', '2');
- INSERT INTO `user` VALUES ('胡苏婉', '123456', '2');
- INSERT INTO `user` VALUES ('姚林林', '123456', '2');
- INSERT INTO `user` VALUES ('王家宁', '123456', '2');
- INSERT INTO `user` VALUES ('刘建尚', '123456', '2');
- INSERT INTO `user` VALUES ('杨佩佩', '123456', '2');
- INSERT INTO `user` VALUES ('周振华', '123456', '2');
- INSERT INTO `user` VALUES ('师浩洋', '123456', '2');
- INSERT INTO `user` VALUES ('何玲', '123456', '2');
- INSERT INTO `user` VALUES ('叶小东', '123456', '2');
- INSERT INTO `user` VALUES ('纪元', '123456', '2');
- INSERT INTO `user` VALUES ('吴国仪', '123456', '2');
- INSERT INTO `user` VALUES ('次仁顿珠', '123456', '2');
- INSERT INTO `user` VALUES ('赵婷', '123456', '2');
- INSERT INTO `user` VALUES ('韩洋', '123456', '2');
- INSERT INTO `user` VALUES ('王艺璇', '123456', '2');
- INSERT INTO `user` VALUES ('魏玉峤', '123456', '2');
- INSERT INTO `user` VALUES ('池硕', '123456', '2');
- INSERT INTO `user` VALUES ('周忠文', '123456', '2');
- INSERT INTO `user` VALUES ('罗成', '123456', '2');
- INSERT INTO `user` VALUES ('赵恒昕', '123456', '2');
- INSERT INTO `user` VALUES ('刘旻龙', '123456', '2');
- INSERT INTO `user` VALUES ('余惕恒', '123456', '2');
- INSERT INTO `user` VALUES ('代明洋', '123456', '2');
- INSERT INTO `user` VALUES ('王驰', '123456', '2');
- INSERT INTO `user` VALUES ('雪慧敏', '123456', '2');
- INSERT INTO `user` VALUES ('王诗予', '123456', '2');
- INSERT INTO `user` VALUES ('卢华飞', '123456', '2');
- INSERT INTO `user` VALUES ('张明明', '123456', '2');
- INSERT INTO `user` VALUES ('索桂红', '123456', '2');
- INSERT INTO `user` VALUES ('戴伟', '123456', '2');
- INSERT INTO `user` VALUES ('徐永平', '123456', '2');
- INSERT INTO `user` VALUES ('纪少杰', '123456', '2');
- INSERT INTO `user` VALUES ('卯龙', '123456', '2');
- INSERT INTO `user` VALUES ('李潇康', '123456', '2');
- INSERT INTO `user` VALUES ('马昕宇', '123456', '2');
- INSERT INTO `user` VALUES ('余钱', '123456', '2');
- INSERT INTO `user` VALUES ('王田雨', '123456', '2');
- INSERT INTO `user` VALUES ('宗浩', '123456', '2');
- INSERT INTO `user` VALUES ('鲁永川', '123456', '2');
- INSERT INTO `user` VALUES ('牟俊', '123456', '2');
- INSERT INTO `user` VALUES ('温华贵', '123456', '2');
- INSERT INTO `user` VALUES ('何彪', '123456', '2');
- INSERT INTO `user` VALUES ('黄向森', '123456', '2');
- INSERT INTO `user` VALUES ('李昕', '123456', '2');
- INSERT INTO `user` VALUES ('张文丽', '123456', '2');
- INSERT INTO `user` VALUES ('陈申有', '123456', '2');
- INSERT INTO `user` VALUES ('齐心1', '123456', '2');
- INSERT INTO `user` VALUES ('孙霞霞', '123456', '2');
- INSERT INTO `user` VALUES ('姜亚奇', '123456', '2');
- INSERT INTO `user` VALUES ('张会娟', '123456', '2');
- INSERT INTO `user` VALUES ('宋冰玉', '123456', '2');
- INSERT INTO `user` VALUES ('马洪彦', '123456', '2');
- INSERT INTO `user` VALUES ('王启', '123456', '2');
- INSERT INTO `user` VALUES ('闫方方', '123456', '2');
- INSERT INTO `user` VALUES ('刘春涛', '123456', '2');
- INSERT INTO `user` VALUES ('乞欣', '123456', '2');
- INSERT INTO `user` VALUES ('姜燕', '123456', '2');
- INSERT INTO `user` VALUES ('何祖银', '123456', '2');
- INSERT INTO `user` VALUES ('覃万科', '123456', '2');
- INSERT INTO `user` VALUES ('冯燕杰', '123456', '2');
- INSERT INTO `user` VALUES ('杨学亭', '123456', '2');
- INSERT INTO `user` VALUES ('阳帆', '123456', '2');
- INSERT INTO `user` VALUES ('贾乾然', '123456', '2');
- INSERT INTO `user` VALUES ('尹志华', '123456', '2');
- INSERT INTO `user` VALUES ('雷虎', '123456', '2');
- INSERT INTO `user` VALUES ('陈传玮', '123456', '2');
- INSERT INTO `user` VALUES ('贠星', '123456', '2');
- INSERT INTO `user` VALUES ('马若怀', '123456', '2');
- INSERT INTO `user` VALUES ('陈权威', '123456', '2');
- INSERT INTO `user` VALUES ('张振', '123456', '2');
- INSERT INTO `user` VALUES ('李兴', '123456', '2');
- INSERT INTO `user` VALUES ('赵晶晶', '123456', '2');
- INSERT INTO `user` VALUES ('开佰达', '123456', '2');
- INSERT INTO `user` VALUES ('任震', '123456', '2');
- INSERT INTO `user` VALUES ('马业明', '123456', '2');
- INSERT INTO `user` VALUES ('张佳奇', '123456', '2');
- INSERT INTO `user` VALUES ('杜晓倩', '123456', '2');
- INSERT INTO `user` VALUES ('任晓欣', '123456', '2');
- INSERT INTO `user` VALUES ('温喆强', '123456', '2');
- INSERT INTO `user` VALUES ('刘颂', '123456', '2');
- INSERT INTO `user` VALUES ('谢郑凯', '123456', '2');
- INSERT INTO `user` VALUES ('范韬博文', '123456', '2');
- INSERT INTO `user` VALUES ('田继超', '123456', '2');
- INSERT INTO `user` VALUES ('杨志伟', '123456', '2');
- INSERT INTO `user` VALUES ('贾晓宁', '123456', '2');
- INSERT INTO `user` VALUES ('未艺超', '123456', '2');
- INSERT INTO `user` VALUES ('刘畅', '123456', '2');
- INSERT INTO `user` VALUES ('刘晓雨', '123456', '2');
- INSERT INTO `user` VALUES ('李俊杰', '123456', '2');
- INSERT INTO `user` VALUES ('陈晨', '123456', '2');
- INSERT INTO `user` VALUES ('王永梅', '123456', '2');
- INSERT INTO `user` VALUES ('张鑫', '123456', '2');
- INSERT INTO `user` VALUES ('吴权隆', '123456', '2');
- INSERT INTO `user` VALUES ('金操', '123456', '2');
- INSERT INTO `user` VALUES ('刘璐', '123456', '2');
- INSERT INTO `user` VALUES ('许月', '123456', '2');
- INSERT INTO `user` VALUES ('刘晓倩', '123456', '2');
- INSERT INTO `user` VALUES ('符御峰', '123456', '2');
- INSERT INTO `user` VALUES ('赵慧敏', '123456', '2');
- INSERT INTO `user` VALUES ('罗广毅', '123456', '2');
- INSERT INTO `user` VALUES ('冀少军', '123456', '2');
- INSERT INTO `user` VALUES ('庄起峰', '123456', '2');
- INSERT INTO `user` VALUES ('邢景灏', '123456', '2');
- INSERT INTO `user` VALUES ('顾佳', '123456', '2');
- INSERT INTO `user` VALUES ('崔东升', '123456', '2');
- INSERT INTO `user` VALUES ('曹帅', '123456', '2');
- INSERT INTO `user` VALUES ('刘达', '123456', '2');
- INSERT INTO `user` VALUES ('杜洋', '123456', '2');
- INSERT INTO `user` VALUES ('吴新纪', '123456', '2');
- INSERT INTO `user` VALUES ('高扬', '123456', '2');
- INSERT INTO `user` VALUES ('杨洁', '123456', '2');
- INSERT INTO `user` VALUES ('冯金钻', '123456', '2');
- INSERT INTO `user` VALUES ('王鹏皓', '123456', '2');
- INSERT INTO `user` VALUES ('罗丹', '123456', '2');
- INSERT INTO `user` VALUES ('韩昭阳', '123456', '2');
- INSERT INTO `user` VALUES ('刘亚萍', '123456', '2');
- INSERT INTO `user` VALUES ('郑权', '123456', '2');
- INSERT INTO `user` VALUES ('崔旭彬', '123456', '2');
- INSERT INTO `user` VALUES ('崔龙效', '123456', '2');
- INSERT INTO `user` VALUES ('杨清昆', '123456', '2');
- INSERT INTO `user` VALUES ('黄剑', '123456', '2');
- INSERT INTO `user` VALUES ('胡秋林', '123456', '2');
- INSERT INTO `user` VALUES ('刘莹莹', '123456', '2');
- INSERT INTO `user` VALUES ('王喜', '123456', '2');
- INSERT INTO `user` VALUES ('杨缙', '123456', '2');
- INSERT INTO `user` VALUES ('张现伟', '123456', '2');
- INSERT INTO `user` VALUES ('鲁舜', '123456', '2');
- INSERT INTO `user` VALUES ('胡楚梅', '123456', '2');
- INSERT INTO `user` VALUES ('韩耀龙', '123456', '2');
- INSERT INTO `user` VALUES ('邹业龙', '123456', '2');
- INSERT INTO `user` VALUES ('郝固烜', '123456', '2');
- INSERT INTO `user` VALUES ('吴艳东', '123456', '2');
- INSERT INTO `user` VALUES ('邢茂军', '123456', '2');
- INSERT INTO `user` VALUES ('丁志鹏', '123456', '2');
- INSERT INTO `user` VALUES ('齐超锋', '123456', '2');
- INSERT INTO `user` VALUES ('党洋', '123456', '2');
- INSERT INTO `user` VALUES ('李文鹏', '123456', '2');
- INSERT INTO `user` VALUES ('薛晨笑', '123456', '2');
- INSERT INTO `user` VALUES ('王永昌', '123456', '2');
- INSERT INTO `user` VALUES ('李秋瑾', '123456', '2');
- INSERT INTO `user` VALUES ('谢伟', '123456', '2');
- INSERT INTO `user` VALUES ('王蕊', '123456', '2');
- INSERT INTO `user` VALUES ('刘超杰', '123456', '2');
- INSERT INTO `user` VALUES ('万超朋', '123456', '2');
- INSERT INTO `user` VALUES ('测试', '123456', '2');
- INSERT INTO `user` VALUES ('崔恩浩', '123456', '2');
- INSERT INTO `user` VALUES ('张丽', '123456', '2');
- INSERT INTO `user` VALUES ('许路晗', '123456', '2');
- INSERT INTO `user` VALUES ('刘宸', '123456', '2');
- INSERT INTO `user` VALUES ('丁凡', '123456', '2');
- INSERT INTO `user` VALUES ('王淑钰', '123456', '2');
- INSERT INTO `user` VALUES ('张博禹', '123456', '2');
- INSERT INTO `user` VALUES ('孙慧慧', '123456', '2');
- INSERT INTO `user` VALUES ('赵浩翔', '123456', '2');
- INSERT INTO `user` VALUES ('李豪', '123456', '2');
- INSERT INTO `user` VALUES ('芮鹏飞', '123456', '2');
- INSERT INTO `user` VALUES ('郑新鹏', '123456', '2');
- INSERT INTO `user` VALUES ('邬贝辉', '123456', '2');
- INSERT INTO `user` VALUES ('黄晓杰', '123456', '2');
- INSERT INTO `user` VALUES ('李晓健', '123456', '2');
- INSERT INTO `user` VALUES ('鲍东旭', '123456', '2');
- INSERT INTO `user` VALUES ('杨康', '123456', '2');
- INSERT INTO `user` VALUES ('彭琛', '123456', '2');
- INSERT INTO `user` VALUES ('易鹏', '123456', '2');
- INSERT INTO `user` VALUES ('杨红颖', '123456', '2');
- INSERT INTO `user` VALUES ('姬强强', '123456', '2');
- INSERT INTO `user` VALUES ('王建勋', '123456', '2');
- INSERT INTO `user` VALUES ('袁楚坤', '123456', '2');
- INSERT INTO `user` VALUES ('李泓名', '123456', '2');
- INSERT INTO `user` VALUES ('贾晓平', '123456', '2');
- INSERT INTO `user` VALUES ('任俊健', '123456', '2');
- INSERT INTO `user` VALUES ('何承阳', '123456', '2');
- INSERT INTO `user` VALUES ('兰帅歌', '123456', '2');
- INSERT INTO `user` VALUES ('王志君', '123456', '2');
- INSERT INTO `user` VALUES ('李润明', '123456', '2');
- INSERT INTO `user` VALUES ('苟海', '123456', '2');
- INSERT INTO `user` VALUES ('刘紫薇', '123456', '2');
- INSERT INTO `user` VALUES ('李静原', '123456', '2');
- INSERT INTO `user` VALUES ('王红丽', '123456', '2');
- INSERT INTO `user` VALUES ('童景波', '123456', '2');
- INSERT INTO `user` VALUES ('徐欢', '123456', '2');
- INSERT INTO `user` VALUES ('战昱翔', '123456', '2');
- INSERT INTO `user` VALUES ('侯建东', '123456', '2');
- INSERT INTO `user` VALUES ('蒋一言', '123456', '2');
- INSERT INTO `user` VALUES ('周雪岭', '123456', '2');
- INSERT INTO `user` VALUES ('王国虎', '123456', '2');
- INSERT INTO `user` VALUES ('陆佳伟', '123456', '2');
- INSERT INTO `user` VALUES ('王玉顺', '123456', '2');
- INSERT INTO `user` VALUES ('杨顺朋', '123456', '2');
- INSERT INTO `user` VALUES ('方兴', '123456', '2');
- INSERT INTO `user` VALUES ('奥云', '123456', '2');
- INSERT INTO `user` VALUES ('刘炳骥', '123456', '2');
- INSERT INTO `user` VALUES ('杨柳', '123456', '2');
- INSERT INTO `user` VALUES ('赵惠晤', '123456', '2');
- INSERT INTO `user` VALUES ('史文俊', '123456', '2');
- INSERT INTO `user` VALUES ('熊双', '123456', '2');
- INSERT INTO `user` VALUES ('侯阳', '123456', '2');
- INSERT INTO `user` VALUES ('常贺', '123456', '2');
- INSERT INTO `user` VALUES ('白日磊', '123456', '2');
- INSERT INTO `user` VALUES ('郭丽苹', '123456', '2');
- INSERT INTO `user` VALUES ('范秀颂', '123456', '2');
- INSERT INTO `user` VALUES ('王世龙', '123456', '2');
- INSERT INTO `user` VALUES ('解靠锋', '123456', '2');
- INSERT INTO `user` VALUES ('刘伟', '123456', '2');
- INSERT INTO `user` VALUES ('肖贺', '123456', '2');
- INSERT INTO `user` VALUES ('王鑫', '123456', '2');
- INSERT INTO `user` VALUES ('高见', '123456', '2');
- INSERT INTO `user` VALUES ('刘新新', '123456', '2');
- INSERT INTO `user` VALUES ('熊俊嗣', '123456', '2');
- INSERT INTO `user` VALUES ('梁学清', '123456', '2');
- INSERT INTO `user` VALUES ('刘均超', '123456', '2');
- INSERT INTO `user` VALUES ('马复达', '123456', '2');
- INSERT INTO `user` VALUES ('周强', '123456', '2');
- INSERT INTO `user` VALUES ('张增太', '123456', '2');
- INSERT INTO `user` VALUES ('邓永良', '123456', '2');
- INSERT INTO `user` VALUES ('马微', '123456', '2');
- INSERT INTO `user` VALUES ('尹献雨', '123456', '2');
- INSERT INTO `user` VALUES ('景肖', '123456', '2');
- INSERT INTO `user` VALUES ('李巧玲', '123456', '2');
- INSERT INTO `user` VALUES ('吴媛媛', '123456', '2');
- INSERT INTO `user` VALUES ('华皖玉', '123456', '2');
- INSERT INTO `user` VALUES ('叶超', '123456', '2');
- INSERT INTO `user` VALUES ('阿达的', '123456', '2');
- INSERT INTO `user` VALUES ('黄东辉', '123456', '2');
- INSERT INTO `user` VALUES ('许帅', '123456', '2');
- INSERT INTO `user` VALUES ('葛鹏', '123456', '2');
- INSERT INTO `user` VALUES ('田冰冰', '123456', '2');
- INSERT INTO `user` VALUES ('贾皓璋', '123456', '2');
- INSERT INTO `user` VALUES ('步皓', '123456', '2');
- INSERT INTO `user` VALUES ('谢清', '123456', '2');
- INSERT INTO `user` VALUES ('史建博', '123456', '2');
- INSERT INTO `user` VALUES ('李鹏翔', '123456', '2');
- INSERT INTO `user` VALUES ('李阳', '123456', '2');
- INSERT INTO `user` VALUES ('王程宏', '123456', '2');
- INSERT INTO `user` VALUES ('王鑫磊', '123456', '2');
- INSERT INTO `user` VALUES ('曾志雄', '123456', '2');
- INSERT INTO `user` VALUES ('李永刚', '123456', '2');
- INSERT INTO `user` VALUES ('周晓飞', '123456', '2');
- INSERT INTO `user` VALUES ('孙日阳2', '123456', '2');
- INSERT INTO `user` VALUES ('邹文华', '123456', '2');
- INSERT INTO `user` VALUES ('熊伟', '123456', '2');
- INSERT INTO `user` VALUES ('岳东旭', '123456', '2');
- INSERT INTO `user` VALUES ('温锦汶', '123456', '2');
- INSERT INTO `user` VALUES ('刘颖琪', '123456', '2');
- INSERT INTO `user` VALUES ('郜梦雪', '123456', '2');
- INSERT INTO `user` VALUES ('赵泽', '123456', '2');
- INSERT INTO `user` VALUES ('罗建成', '123456', '2');
- INSERT INTO `user` VALUES ('姚舜超', '123456', '2');
- INSERT INTO `user` VALUES ('史可鉴', '123456', '2');
- INSERT INTO `user` VALUES ('金晓群', '123456', '2');
- INSERT INTO `user` VALUES ('刘开拓', '123456', '2');
- INSERT INTO `user` VALUES ('王浩明', '123456', '2');
- INSERT INTO `user` VALUES ('周振郭', '123456', '2');
- INSERT INTO `user` VALUES ('赵艳敏', '123456', '2');
- INSERT INTO `user` VALUES ('张建兵', '123456', '2');
- INSERT INTO `user` VALUES ('杨亚帅', '123456', '2');
- INSERT INTO `user` VALUES ('高燕敏', '123456', '2');
- INSERT INTO `user` VALUES ('叶发成', '123456', '2');
- INSERT INTO `user` VALUES ('王珊', '123456', '2');
- INSERT INTO `user` VALUES ('朱学林', '123456', '2');
- INSERT INTO `user` VALUES ('谢浪', '123456', '2');
- INSERT INTO `user` VALUES ('钟文智', '123456', '2');
- INSERT INTO `user` VALUES ('王莹', '123456', '2');
- INSERT INTO `user` VALUES ('牛涛', '123456', '2');
- INSERT INTO `user` VALUES ('母冰冰', '123456', '2');
- INSERT INTO `user` VALUES ('赵麟', '123456', '2');
- INSERT INTO `user` VALUES ('李玮斌', '123456', '2');
- INSERT INTO `user` VALUES ('曾臻', '123456', '2');
- INSERT INTO `user` VALUES ('万涛', '123456', '2');
- INSERT INTO `user` VALUES ('刘娟娟', '123456', '2');
- INSERT INTO `user` VALUES ('许金刚', '123456', '2');
- INSERT INTO `user` VALUES ('顾曦', '123456', '2');
- INSERT INTO `user` VALUES ('刘金双', '123456', '2');
- INSERT INTO `user` VALUES ('黄高坚', '123456', '2');
- INSERT INTO `user` VALUES ('宋悦', '123456', '2');
- INSERT INTO `user` VALUES ('杨宁', '123456', '2');
- INSERT INTO `user` VALUES ('蔡乐', '123456', '2');
- INSERT INTO `user` VALUES ('郑志凯', '123456', '2');
- INSERT INTO `user` VALUES ('宋利冰', '123456', '2');
- INSERT INTO `user` VALUES ('仇伟阳', '123456', '2');
- INSERT INTO `user` VALUES ('李书光', '123456', '2');
- INSERT INTO `user` VALUES ('申秋辉', '123456', '2');
- INSERT INTO `user` VALUES ('杨洋', '123456', '2');
- INSERT INTO `user` VALUES ('靳义磊', '123456', '2');
- INSERT INTO `user` VALUES ('郭巧巧', '123456', '2');
- INSERT INTO `user` VALUES ('孙圣杰', '123456', '2');
- INSERT INTO `user` VALUES ('赵济群', '123456', '2');
- INSERT INTO `user` VALUES ('齐明空', '123456', '2');
- INSERT INTO `user` VALUES ('王杰', '123456', '2');
- INSERT INTO `user` VALUES ('严伟', '123456', '2');
- INSERT INTO `user` VALUES ('窦强', '123456', '2');
- INSERT INTO `user` VALUES ('殷显慧', '123456', '2');
- INSERT INTO `user` VALUES ('贺灿文', '123456', '2');
- INSERT INTO `user` VALUES ('赵静', '123456', '2');
- INSERT INTO `user` VALUES ('涂文超', '123456', '2');
- INSERT INTO `user` VALUES ('周硕', '123456', '2');
- INSERT INTO `user` VALUES ('史晶晶', '123456', '2');
- INSERT INTO `user` VALUES ('王京津', '123456', '2');
- INSERT INTO `user` VALUES ('杨涛', '123456', '2');
- INSERT INTO `user` VALUES ('王鸯鸯', '123456', '2');
- INSERT INTO `user` VALUES ('冯汉超', '123456', '2');
- INSERT INTO `user` VALUES ('吴云飞', '123456', '2');
- INSERT INTO `user` VALUES ('贾振博', '123456', '2');
- INSERT INTO `user` VALUES ('苗莉景', '123456', '2');
- INSERT INTO `user` VALUES ('李东东', '123456', '2');
- INSERT INTO `user` VALUES ('乔晓峰', '123456', '2');
- INSERT INTO `user` VALUES ('杨元皓', '123456', '2');
- INSERT INTO `user` VALUES ('方源', '123456', '2');
- INSERT INTO `user` VALUES ('金继辉', '123456', '2');
- INSERT INTO `user` VALUES ('王超1', '123456', '2');
- INSERT INTO `user` VALUES ('廖龙', '123456', '2');
- INSERT INTO `user` VALUES ('翟文涛', '123456', '2');
- INSERT INTO `user` VALUES ('王一君', '123456', '2');
- INSERT INTO `user` VALUES ('张维青', '123456', '2');
- INSERT INTO `user` VALUES ('师瑞林', '123456', '2');
- INSERT INTO `user` VALUES ('张远', '123456', '2');
- INSERT INTO `user` VALUES ('王巍', '123456', '2');
- INSERT INTO `user` VALUES ('葛小松', '123456', '2');
- INSERT INTO `user` VALUES ('张亚男', '123456', '2');
- INSERT INTO `user` VALUES ('王飞', '123456', '2');
- INSERT INTO `user` VALUES ('罗紫晋', '123456', '2');
- INSERT INTO `user` VALUES ('孟芦', '123456', '2');
- INSERT INTO `user` VALUES ('马春义', '123456', '2');
- INSERT INTO `user` VALUES ('许枭鹏', '123456', '2');
- INSERT INTO `user` VALUES ('曹瑞', '123456', '2');
- INSERT INTO `user` VALUES ('王宗祥', '123456', '2');
- INSERT INTO `user` VALUES ('黄燕良', '123456', '2');
- INSERT INTO `user` VALUES ('张豪', '123456', '2');
- INSERT INTO `user` VALUES ('季雨薇', '123456', '2');
- INSERT INTO `user` VALUES ('陈元', '123456', '2');
- INSERT INTO `user` VALUES ('李剑', '123456', '2');
- INSERT INTO `user` VALUES ('李天宇', '123456', '2');
- INSERT INTO `user` VALUES ('符怡攀', '123456', '2');
- INSERT INTO `user` VALUES ('乔杨', '123456', '2');
- INSERT INTO `user` VALUES ('张童', '123456', '2');
- INSERT INTO `user` VALUES ('王艳军', '123456', '2');
- INSERT INTO `user` VALUES ('史亚鹏', '123456', '2');
- INSERT INTO `user` VALUES ('张静', '123456', '2');
- INSERT INTO `user` VALUES ('毛德峥', '123456', '2');
- INSERT INTO `user` VALUES ('鲁欣', '123456', '2');
- INSERT INTO `user` VALUES ('范中源', '123456', '2');
- INSERT INTO `user` VALUES ('郭昌魁', '123456', '2');
- INSERT INTO `user` VALUES ('郭娜', '123456', '2');
- INSERT INTO `user` VALUES ('冉晶晶', '123456', '2');
- INSERT INTO `user` VALUES ('伏香钗', '123456', '2');
- INSERT INTO `user` VALUES ('李晨阳', '123456', '2');
- INSERT INTO `user` VALUES ('曹金宇', '123456', '2');
- INSERT INTO `user` VALUES ('王娇', '123456', '2');
- INSERT INTO `user` VALUES ('牛恒', '123456', '2');
- INSERT INTO `user` VALUES ('马小波', '123456', '2');
- INSERT INTO `user` VALUES ('葛占彬', '123456', '2');
- INSERT INTO `user` VALUES ('闫存海', '123456', '2');
- INSERT INTO `user` VALUES ('孙兴禄', '123456', '2');
- INSERT INTO `user` VALUES ('包路奇', '123456', '2');
- INSERT INTO `user` VALUES ('韩文', '123456', '2');
- INSERT INTO `user` VALUES ('张明浩', '123456', '2');
- INSERT INTO `user` VALUES ('林超', '123456', '2');
- INSERT INTO `user` VALUES ('范金鼎', '123456', '2');
- INSERT INTO `user` VALUES ('汤明', '123456', '2');
- INSERT INTO `user` VALUES ('康俊', '123456', '2');
- INSERT INTO `user` VALUES ('王恒', '123456', '2');
- INSERT INTO `user` VALUES ('刘文琪', '123456', '2');
- INSERT INTO `user` VALUES ('彭存', '123456', '2');
- INSERT INTO `user` VALUES ('许斌', '123456', '2');
- INSERT INTO `user` VALUES ('李霞', '123456', '2');
- INSERT INTO `user` VALUES ('马海涛', '123456', '2');
- INSERT INTO `user` VALUES ('刘娜', '123456', '2');
- INSERT INTO `user` VALUES ('戴霄玥', '123456', '2');
- INSERT INTO `user` VALUES ('杨烁', '123456', '2');
- INSERT INTO `user` VALUES ('张帅', '123456', '2');
- INSERT INTO `user` VALUES ('徐瑶', '123456', '2');
- INSERT INTO `user` VALUES ('邓岚', '123456', '2');
- INSERT INTO `user` VALUES ('张超群', '123456', '2');
- INSERT INTO `user` VALUES ('李艳', '123456', '2');
- INSERT INTO `user` VALUES ('马力', '123456', '2');
- INSERT INTO `user` VALUES ('阎思远', '123456', '2');
- INSERT INTO `user` VALUES ('华正平', '123456', '2');
- INSERT INTO `user` VALUES ('邓慧', '123456', '2');
- INSERT INTO `user` VALUES ('倪星煜', '123456', '2');
- INSERT INTO `user` VALUES ('胡冰瑶', '123456', '2');
- INSERT INTO `user` VALUES ('袁丹妮', '123456', '2');
- INSERT INTO `user` VALUES ('肖萌', '123456', '2');
- INSERT INTO `user` VALUES ('石娱赫', '123456', '2');
- INSERT INTO `user` VALUES ('王宇', '123456', '2');
- INSERT INTO `user` VALUES ('许南江', '123456', '2');
- INSERT INTO `user` VALUES ('张立崇', '123456', '2');
- INSERT INTO `user` VALUES ('王公越', '123456', '2');
- INSERT INTO `user` VALUES ('安然', '123456', '2');
- INSERT INTO `user` VALUES ('陈国强', '123456', '2');
- INSERT INTO `user` VALUES ('李雪峰', '123456', '2');
- INSERT INTO `user` VALUES ('包政', '123456', '2');
- INSERT INTO `user` VALUES ('李莎', '123456', '2');
- INSERT INTO `user` VALUES ('沈志强', '123456', '2');
- INSERT INTO `user` VALUES ('刘爽', '123456', '2');
- INSERT INTO `user` VALUES ('肖国', '123456', '2');
- INSERT INTO `user` VALUES ('刘英帅', '123456', '2');
- INSERT INTO `user` VALUES ('曹琴娜', '123456', '2');
- INSERT INTO `user` VALUES ('苏鸿飞', '123456', '2');
- INSERT INTO `user` VALUES ('李井强', '123456', '2');
- INSERT INTO `user` VALUES ('吴文军', '123456', '2');
- INSERT INTO `user` VALUES ('魏来来', '123456', '2');
- INSERT INTO `user` VALUES ('张彬', '123456', '2');
- INSERT INTO `user` VALUES ('王腾', '123456', '2');
- INSERT INTO `user` VALUES ('马慧娟', '123456', '2');
- INSERT INTO `user` VALUES ('陈东浩', '123456', '2');
- INSERT INTO `user` VALUES ('张凯', '123456', '2');
- INSERT INTO `user` VALUES ('王洪昌', '123456', '2');
- INSERT INTO `user` VALUES ('晏永康', '123456', '2');
- INSERT INTO `user` VALUES ('王雪松', '123456', '2');
- INSERT INTO `user` VALUES ('邵秉森', '123456', '2');
- INSERT INTO `user` VALUES ('焦文亮', '123456', '2');
- INSERT INTO `user` VALUES ('李骁', '123456', '2');
- INSERT INTO `user` VALUES ('蒋星星', '123456', '2');
- INSERT INTO `user` VALUES ('陈晓亮', '123456', '2');
- INSERT INTO `user` VALUES ('王洪强', '123456', '2');
- INSERT INTO `user` VALUES ('王亚东', '123456', '2');
- INSERT INTO `user` VALUES ('韩帅', '123456', '2');
- INSERT INTO `user` VALUES ('胡沅伶', '123456', '2');
- INSERT INTO `user` VALUES ('母莉娜', '123456', '2');
- INSERT INTO `user` VALUES ('詹雨田', '123456', '2');
- INSERT INTO `user` VALUES ('赵宝峰', '123456', '2');
- INSERT INTO `user` VALUES ('张莉娟', '123456', '2');
- INSERT INTO `user` VALUES ('韩赟', '123456', '2');
- INSERT INTO `user` VALUES ('李润民', '123456', '2');
- INSERT INTO `user` VALUES ('耿晓明', '123456', '2');
- INSERT INTO `user` VALUES ('马学武', '123456', '2');
- INSERT INTO `user` VALUES ('雷嘉兴', '123456', '2');
- INSERT INTO `user` VALUES ('文小苏', '123456', '2');
- INSERT INTO `user` VALUES ('金瑞丽', '123456', '2');
- INSERT INTO `user` VALUES ('郭天亮', '123456', '2');
- INSERT INTO `user` VALUES ('李帆', '123456', '2');
- INSERT INTO `user` VALUES ('韩永鑫', '123456', '2');
- INSERT INTO `user` VALUES ('张亚杰', '123456', '2');
- INSERT INTO `user` VALUES ('李梦', '123456', '2');
- INSERT INTO `user` VALUES ('李桐', '123456', '2');
- INSERT INTO `user` VALUES ('韩瑞', '123456', '2');
- INSERT INTO `user` VALUES ('樊琦', '123456', '2');
- INSERT INTO `user` VALUES ('宋路遥', '123456', '2');
- INSERT INTO `user` VALUES ('刘延召', '123456', '2');
- INSERT INTO `user` VALUES ('姜鹏', '123456', '2');
- INSERT INTO `user` VALUES ('江鹏', '123456', '2');
- INSERT INTO `user` VALUES ('王嵩', '123456', '2');
- INSERT INTO `user` VALUES ('孙日阳', '123456', '2');
- INSERT INTO `user` VALUES ('刘静坤', '123456', '2');
- INSERT INTO `user` VALUES ('李东', '123456', '2');
- INSERT INTO `user` VALUES ('王昕', '123456', '2');
- INSERT INTO `user` VALUES ('郭松超', '123456', '2');
- INSERT INTO `user` VALUES ('齐星全', '123456', '2');
- INSERT INTO `user` VALUES ('申昌昊', '123456', '2');
- INSERT INTO `user` VALUES ('王延乐', '123456', '2');
- INSERT INTO `user` VALUES ('许二冬', '123456', '2');
- INSERT INTO `user` VALUES ('李玲艳', '123456', '2');
- INSERT INTO `user` VALUES ('闫永凯', '123456', '2');
- INSERT INTO `user` VALUES ('刘玉', '123456', '2');
- INSERT INTO `user` VALUES ('甘佩华', '123456', '2');
- INSERT INTO `user` VALUES ('柴难让', '123456', '2');
- INSERT INTO `user` VALUES ('周利娟', '123456', '2');
- INSERT INTO `user` VALUES ('锁志平', '123456', '2');
- INSERT INTO `user` VALUES ('梁峰彰', '123456', '2');
- INSERT INTO `user` VALUES ('王永存', '123456', '2');
- INSERT INTO `user` VALUES ('谭振东', '123456', '2');
- INSERT INTO `user` VALUES ('吴胜宗', '123456', '2');
- INSERT INTO `user` VALUES ('text', '123456', '2');
- INSERT INTO `user` VALUES ('郝星', '123456', '2');
- INSERT INTO `user` VALUES ('聂祥周', '123456', '2');
- INSERT INTO `user` VALUES ('张忠林', '123456', '2');
- INSERT INTO `user` VALUES ('鲁锐', '123456', '2');
- INSERT INTO `user` VALUES ('李凯乐', '123456', '2');
- INSERT INTO `user` VALUES ('王洋洋1', '123456', '2');
- INSERT INTO `user` VALUES ('王宁', '123456', '2');
- INSERT INTO `user` VALUES ('刘福省', '123456', '2');
- INSERT INTO `user` VALUES ('高浩轩', '123456', '2');
- -- ----------------------------------------
- -- Table structure for roomauthority--会议室权限
- -- ----------------------------------------
- Drop TABLE IF EXISTS `room_authority`;
- CREATE Table `room_authority`(
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `room_id` int(11) NOT NULL,
- `user_id` varchar(32) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_authority_room` (`room_id`),
- CONSTRAINT `fk_authority_room` FOREIGN KEY (`room_id`) REFERENCES `room` (`id`),
- KEY `fk_authority_user` (user_id),
- CONSTRAINT `fk_authority_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
- )ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Records of roomauthority
- -- ----------------------------
|