/*
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
-- ----------------------------



