You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
322 lines
16 KiB
322 lines
16 KiB
/*
|
|
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号');
|