/*
Navicat MySQL Data Transfer

Source Server         : courseConn
Source Server Version : 50527
Source Host           : localhost:3306
Source Database       : text3

Target Server Type    : MYSQL
Target Server Version : 50527
File Encoding         : 65001

Date: 2020-04-24 16:28:19
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for city
-- ----------------------------
DROP TABLE IF EXISTS `city`;
CREATE TABLE `city` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `provincename` varchar(255) DEFAULT NULL,
  `cityname` varchar(255) DEFAULT NULL,
  `usernumber` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of city
-- ----------------------------
INSERT INTO `city` VALUES ('1', 'wang@163.com', 'oop', '123456');
INSERT INTO `city` VALUES ('2', 'wang@178.com', 'iij', '123456');
INSERT INTO `city` VALUES ('3', 'wang@136.com', 'jkk', '123456');
INSERT INTO `city` VALUES ('4', 'wang@149.com', 'gbb', '123456');
INSERT INTO `city` VALUES ('5', '广东', '梅州', '500');
INSERT INTO `city` VALUES ('6', 'cew', 'yuu', '857');
INSERT INTO `city` VALUES ('7', '台湾', '台北', '500');

-- ----------------------------
-- Table structure for ck
-- ----------------------------
DROP TABLE IF EXISTS `ck`;
CREATE TABLE `ck` (
  `ckbh` varchar(255) NOT NULL,
  `ckdz` varchar(255) DEFAULT NULL,
  `ck_phone` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ckbh`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ck
-- ----------------------------
INSERT INTO `ck` VALUES ('1', '北京市丰台区六里桥南里甲九号首发大厦C座13层', '2727228272');
INSERT INTO `ck` VALUES ('2', '浙江省杭州市江干区富春路188号市民中心D座14楼', '5275275272');
INSERT INTO `ck` VALUES ('3', '湖北省武汉市汉江区万松街道', '7857575757');

-- ----------------------------
-- Table structure for ckcc
-- ----------------------------
DROP TABLE IF EXISTS `ckcc`;
CREATE TABLE `ckcc` (
  `ckid` varchar(255) NOT NULL DEFAULT '',
  `spname` varchar(255) NOT NULL DEFAULT '',
  `synum` int(8) DEFAULT NULL,
  PRIMARY KEY (`ckid`,`spname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ckcc
-- ----------------------------
INSERT INTO `ckcc` VALUES ('1', '小厨宝', '62');
INSERT INTO `ckcc` VALUES ('1', '柴油', '10000');
INSERT INTO `ckcc` VALUES ('1', '电热水器', '419');
INSERT INTO `ckcc` VALUES ('1', '精密空调加湿器', '4');
INSERT INTO `ckcc` VALUES ('1', '越南一次性口罩', '800');
INSERT INTO `ckcc` VALUES ('1', '防火涂层板\r\n', '60');
INSERT INTO `ckcc` VALUES ('2', '公牛墙壁开关插座', '7570');
INSERT INTO `ckcc` VALUES ('2', '干粉灭火器', '200');
INSERT INTO `ckcc` VALUES ('2', '开关插座、照明灯具（佛山照明、飞雕电器）', '1');
INSERT INTO `ckcc` VALUES ('2', '智慧消防云服务平台', '1');
INSERT INTO `ckcc` VALUES ('2', '格力净化器\r\n格力净化器', '400');
INSERT INTO `ckcc` VALUES ('2', '洗手盆、感应龙头、马桶、淋浴器、拖把池', '5840');
INSERT INTO `ckcc` VALUES ('2', '液体灭火器', '200');
INSERT INTO `ckcc` VALUES ('2', '火灾报警云服务费', '1500');
INSERT INTO `ckcc` VALUES ('2', '照明灯具设备产品', '4255');
INSERT INTO `ckcc` VALUES ('2', '独立式光电感烟探测报警器', '1500');
INSERT INTO `ckcc` VALUES ('2', '防护服', '800');
INSERT INTO `ckcc` VALUES ('2', '飞利浦紫外杀毒灯', '62');
INSERT INTO `ckcc` VALUES ('3', '口罩', '2000');
INSERT INTO `ckcc` VALUES ('3', '恒洁座便器、淋浴花洒', '1983');
INSERT INTO `ckcc` VALUES ('3', '无线对讲设备', '53');
INSERT INTO `ckcc` VALUES ('3', '格兰斯柯新风设备', '113');
INSERT INTO `ckcc` VALUES ('3', '热成像式红外人体测温仪', '2');
INSERT INTO `ckcc` VALUES ('3', '越南一次性口罩\r\n', '1600');
INSERT INTO `ckcc` VALUES ('3', '防护服\r\n', '500');
INSERT INTO `ckcc` VALUES ('3', '防火涂层板', '60');
INSERT INTO `ckcc` VALUES ('4', '饼干', '5000');

-- ----------------------------
-- Table structure for jzjl
-- ----------------------------
DROP TABLE IF EXISTS `jzjl`;
CREATE TABLE `jzjl` (
  `hdbh` varchar(255) NOT NULL,
  `user_id` int(255) DEFAULT NULL,
  `spname` varchar(255) DEFAULT NULL,
  `num` int(8) DEFAULT NULL,
  PRIMARY KEY (`hdbh`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of jzjl
-- ----------------------------
INSERT INTO `jzjl` VALUES ('202004150', '1', '口罩', '1000');
INSERT INTO `jzjl` VALUES ('202004151', '2', '防护服', '50');
INSERT INTO `jzjl` VALUES ('202004152', '3', '飞利浦紫外杀毒灯', '1230');
INSERT INTO `jzjl` VALUES ('202004153', '4', '配电箱箱体及元器件', '168');
INSERT INTO `jzjl` VALUES ('202004154', '5', '照明灯具设备产品', '4255');
INSERT INTO `jzjl` VALUES ('202004155', '6', '开关插座、照明灯具', '1');
INSERT INTO `jzjl` VALUES ('202004156', '7', '公牛墙壁开关插座', '7570');
INSERT INTO `jzjl` VALUES ('202004157', '8', '干粉灭火器', '200');
INSERT INTO `jzjl` VALUES ('202004158', '9', '液体灭火器', '200');
INSERT INTO `jzjl` VALUES ('202004159', '10', '独立式光电感烟探测报警器', '1500');
INSERT INTO `jzjl` VALUES ('202004160', '11', '火灾报警云服务费', '1500');
INSERT INTO `jzjl` VALUES ('202004161', '12', '智慧消防云服务平台', '1');
INSERT INTO `jzjl` VALUES ('202004162', '13', '洗手盆、感应龙头、马桶', '5840');
INSERT INTO `jzjl` VALUES ('202004163', '14', '精密空调风冷机房室外机组', '4');
INSERT INTO `jzjl` VALUES ('202004164', '15', '精密空调加湿器', '4');
INSERT INTO `jzjl` VALUES ('202004165', '16', '精密空调延长管', '4');
INSERT INTO `jzjl` VALUES ('202004166', '17', '新风设备新风机', '42');
INSERT INTO `jzjl` VALUES ('202004167', '18', '格力空调', '277');
INSERT INTO `jzjl` VALUES ('202004168', '19', '格力净饮机', '100');

-- ----------------------------
-- Table structure for jzw
-- ----------------------------
DROP TABLE IF EXISTS `jzw`;
CREATE TABLE `jzw` (
  `hdbh` varchar(255) NOT NULL,
  `ckbh` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of jzw
-- ----------------------------
INSERT INTO `jzw` VALUES ('202004150', 'Ck000003');
INSERT INTO `jzw` VALUES ('202004151', 'Ck000003');
INSERT INTO `jzw` VALUES ('202004152', 'Ck000002');
INSERT INTO `jzw` VALUES ('202004153', 'Ck000002');
INSERT INTO `jzw` VALUES ('202004154', 'Ck000002');
INSERT INTO `jzw` VALUES ('202004155', 'Ck000002');
INSERT INTO `jzw` VALUES ('202004156', 'Ck000002');
INSERT INTO `jzw` VALUES ('202004157', 'Ck000002');
INSERT INTO `jzw` VALUES ('202004158', 'Ck000002');
INSERT INTO `jzw` VALUES ('202004159', 'Ck000002');
INSERT INTO `jzw` VALUES ('202004160', 'Ck000002');
INSERT INTO `jzw` VALUES ('202004161', 'Ck000002');
INSERT INTO `jzw` VALUES ('202004162', 'Ck000002');
INSERT INTO `jzw` VALUES ('202004163', 'Ck000001');
INSERT INTO `jzw` VALUES ('202004164', 'Ck000001');
INSERT INTO `jzw` VALUES ('202004165', 'Ck000001');
INSERT INTO `jzw` VALUES ('202004166', 'Ck000001');
INSERT INTO `jzw` VALUES ('202004167', 'Ck000001');
INSERT INTO `jzw` VALUES ('202004168', 'Ck000001');

-- ----------------------------
-- Table structure for jzz
-- ----------------------------
DROP TABLE IF EXISTS `jzz`;
CREATE TABLE `jzz` (
  `user_id` varchar(255) NOT NULL,
  `user_sex` varchar(255) DEFAULT NULL,
  `province` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `town` varchar(255) DEFAULT NULL,
  `village` varchar(255) DEFAULT NULL,
  `adress` varchar(255) DEFAULT NULL,
  `user_phone` varchar(255) DEFAULT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of jzz
-- ----------------------------
INSERT INTO `jzz` VALUES ('yh000001', '男', '湖南', '长沙', '开福区', '福元路一号', '体育馆', '13446564516', '张三');
INSERT INTO `jzz` VALUES ('yh000002', '男', '湖南', '长沙', '开福区', '福元路一号', '先富', '13808481687', '张四');
INSERT INTO `jzz` VALUES ('yh000003', '男', '湖南', '长沙', '开福区', '福元路一号', '荷花池', '15173115588', '吴　磊');
INSERT INTO `jzz` VALUES ('yh000004', '女', '湖南', '长沙', '雨花区', '东塘街道', '七里庙', '17775748481', '刘志明');
INSERT INTO `jzz` VALUES ('yh000005', '男', '湖南', '长沙', '芙蓉区', '解放路', '化龙池', '15173115588', '张东裔');
INSERT INTO `jzz` VALUES ('yh000006', '女', '湖南', '长沙', '芙蓉区', '解放路', '化龙池', '15367994537', '王  干');
INSERT INTO `jzz` VALUES ('yh000007', '男', '湖南', '长沙', '雨花区', '八一路', '体育馆', '13874885585', '王晓燕');
INSERT INTO `jzz` VALUES ('yh000008', '男', '湖北', '武汉', '汉江区', '万松街道', '裕民小区', '17352545520', '孟  尔');
INSERT INTO `jzz` VALUES ('yh000009', '男', '湖北', '武汉', '汉江区', '万松街道', '利民苑', '13017587539', '李文颖');
INSERT INTO `jzz` VALUES ('yh000010', '男', '湖北', '武汉', '汉江区', '万松街道', '车站', '13618495817', '谢斯思');
INSERT INTO `jzz` VALUES ('yh000011', '男', '湖北', '武汉', '汉江区', '万松街道', '惠民小区', '17670751339', '闵  璐');
INSERT INTO `jzz` VALUES ('yh000012', '女', '湖北', '武汉', '汉江区', '万松街道', '财经大厦', '18008452603', '吴小敏');
INSERT INTO `jzz` VALUES ('yh000013', '女', '山西', '太原', '小店区', '小店街道', '通达', '18570685689', '朱律韵');
INSERT INTO `jzz` VALUES ('yh000014', '男', '山西', '太原', '小店区', '小店街道', '康宁', '18611783537', '吴文健');
INSERT INTO `jzz` VALUES ('yh000015', '女', '山西', '太原', '小店区', '小店街道', '通达', '15173550100', '胡碧茹');
INSERT INTO `jzz` VALUES ('yh000016', '男', '山西', '太原', '小店区', '小店街道', '汾东', '18552520557', '叶宗煌');
INSERT INTO `jzz` VALUES ('yh000017', '男', '山西', '太原', '小店区', '小店街道', '康宁', '13955148761', '吴  玢');
INSERT INTO `jzz` VALUES ('yh000018', '男', '山西', '太原', '小店区', '小店街道', '通达', '17807377790', '匡静宇');
INSERT INTO `jzz` VALUES ('yh000019', '男', '内蒙古', '呼和浩特', '新城区', '东风路街道', '宝铁', '13308551152', '陈  璇');

-- ----------------------------
-- Table structure for kdd
-- ----------------------------
DROP TABLE IF EXISTS `kdd`;
CREATE TABLE `kdd` (
  `kdbh` varchar(255) NOT NULL,
  `ckbh` varchar(255) DEFAULT NULL,
  `yymc` varchar(255) DEFAULT NULL,
  `kd_id` varchar(255) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  `arrive_time` time DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of kdd
-- ----------------------------
INSERT INTO `kdd` VALUES ('Sf202004130001', '1', '火神山医院', 'Sf000001', '武汉市', '16:30:00');
INSERT INTO `kdd` VALUES ('Sf202004130021', '2', '火神山医院', 'Sf000001', '武汉市', '16:30:00');
INSERT INTO `kdd` VALUES ('Sf202004130031', '3', '火神山医院', 'Sf000001', '武汉市', '16:30:00');
INSERT INTO `kdd` VALUES ('Sf202004130041', '1', '火神山医院', 'Sf000002', '武汉市', '17:30:00');
INSERT INTO `kdd` VALUES ('Sf202004130051', '2', '火神山医院', 'Sf000002', '武汉市', '17:30:00');
INSERT INTO `kdd` VALUES ('Sf202004130061', '3', '火神山医院', 'Sf000003', '武汉市', '19:30:00');
INSERT INTO `kdd` VALUES ('Yt202004130541', '2', '雷神山医院', 'Yt000001', '武汉市', '13:00:00');
INSERT INTO `kdd` VALUES ('Yt202004130551', '1', '雷神山医院', 'Yt000002', '武汉市', '13:00:00');
INSERT INTO `kdd` VALUES ('Yt202004130561', '2', '雷神山医院', 'Yt000002', '武汉市', '13:00:00');

-- ----------------------------
-- Table structure for kdy
-- ----------------------------
DROP TABLE IF EXISTS `kdy`;
CREATE TABLE `kdy` (
  `kd_id` varchar(255) NOT NULL,
  `kd_name` varchar(255) DEFAULT NULL,
  `kd_company` varchar(255) DEFAULT NULL,
  `kd_phone` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kd_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of kdy
-- ----------------------------
INSERT INTO `kdy` VALUES ('Sf000001', '张三', '顺丰速运', '13967931038');
INSERT INTO `kdy` VALUES ('Sf000002', '王五', '顺丰速运', '13565654879');
INSERT INTO `kdy` VALUES ('Sf000003', '李四', '顺丰速运', '14562587896');
INSERT INTO `kdy` VALUES ('Yt000001', '张四', '圆通快递', '13568978988');
INSERT INTO `kdy` VALUES ('Yt000002', '李二', '圆通快递', '15655888558');

-- ----------------------------
-- Table structure for wlgs
-- ----------------------------
DROP TABLE IF EXISTS `wlgs`;
CREATE TABLE `wlgs` (
  `wlgs_name` varchar(255) DEFAULT NULL,
  `wlgs_phone` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wlgs
-- ----------------------------
INSERT INTO `wlgs` VALUES ('顺丰', '45635');
INSERT INTO `wlgs` VALUES ('圆通', '53483');
INSERT INTO `wlgs` VALUES ('韵达', '95546');
INSERT INTO `wlgs` VALUES ('百世', '95320');
INSERT INTO `wlgs` VALUES ('EMS', '11183');

-- ----------------------------
-- Table structure for wzxx
-- ----------------------------
DROP TABLE IF EXISTS `wzxx`;
CREATE TABLE `wzxx` (
  `spname` varchar(255) DEFAULT NULL,
  `sptype` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wzxx
-- ----------------------------
INSERT INTO `wzxx` VALUES ('口罩', '医用');
INSERT INTO `wzxx` VALUES ('防护服', '医用');
INSERT INTO `wzxx` VALUES ('飞利浦紫外杀毒灯', '医用');
INSERT INTO `wzxx` VALUES ('配电箱箱体及元器件', '日用百货');
INSERT INTO `wzxx` VALUES ('照明灯具设备产品', '日用百货');
INSERT INTO `wzxx` VALUES ('开关插座、照明灯具', '日用百货');
INSERT INTO `wzxx` VALUES ('公牛墙壁开关插座', '日用百货');
INSERT INTO `wzxx` VALUES ('干粉灭火器', '消防');
INSERT INTO `wzxx` VALUES ('液体灭火器', '消防');
INSERT INTO `wzxx` VALUES ('独立式光电感烟探测报警器', '消防');
INSERT INTO `wzxx` VALUES ('火灾报警云服务费', '消防');
INSERT INTO `wzxx` VALUES ('智慧消防云服务平台', '消防');
INSERT INTO `wzxx` VALUES ('洗手盆、感应龙头、马桶', '日用百货');
INSERT INTO `wzxx` VALUES ('精密空调风冷机房室外机组', '日用百货');
INSERT INTO `wzxx` VALUES ('精密空调加湿器', '日用百货');
INSERT INTO `wzxx` VALUES ('精密空调延长管', '日用百货');
INSERT INTO `wzxx` VALUES ('新风设备新风机', '日用百货');
INSERT INTO `wzxx` VALUES ('格力空调', '日用百货');
INSERT INTO `wzxx` VALUES ('格力净饮机', '日用百货');

-- ----------------------------
-- Table structure for yy
-- ----------------------------
DROP TABLE IF EXISTS `yy`;
CREATE TABLE `yy` (
  `yymc` varchar(255) DEFAULT NULL,
  `yy_need` varchar(255) DEFAULT NULL,
  `yy_phone` varchar(255) DEFAULT NULL,
  `yy_dz` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yy
-- ----------------------------
INSERT INTO `yy` VALUES ('火神山医院', '口罩、防护服，消防用具，食品', '123456', '湖北省武汉市蔡甸区知音湖大道');
INSERT INTO `yy` VALUES ('雷神山医院', '口罩、防护服，消防用具，食品', '456123', '湖北省武汉市江夏区强军路');
INSERT INTO `yy` VALUES ('汉口医院', '口罩、防护服', '0278287616', '湖北省武汉市江岸区二七侧路7号');