/*
Navicat MySQL Data Transfer

Source Server         : 本地Mysql
Source Server Version : 80018
Source Host           : localhost:3306
Source Database       : restfuldemo

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

Date: 2019-11-26 16:45:31
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for data
-- ----------------------------
DROP TABLE IF EXISTS `data`;
CREATE TABLE `data` (
  `name` varchar(16) COLLATE utf8_bin NOT NULL,
  `price` varchar(10) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of data
-- ----------------------------
INSERT INTO `data` VALUES ('CCTV13', '83288.4');
INSERT INTO `data` VALUES ('CCTV14', '76163.88');
INSERT INTO `data` VALUES ('CCTV2', '85743.84');
INSERT INTO `data` VALUES ('CCTV3', '75405.72');
INSERT INTO `data` VALUES ('CCTV4', '74418.24');
INSERT INTO `data` VALUES ('CCTV5', '71246.76');
INSERT INTO `data` VALUES ('CCTV6', '62693.28');
INSERT INTO `data` VALUES ('CCTV7', '77918.88');
INSERT INTO `data` VALUES ('CCTV8', '79063.92');
INSERT INTO `data` VALUES ('东方卫视', '81882.84');
INSERT INTO `data` VALUES ('北京卫视', '73295.04');
INSERT INTO `data` VALUES ('四川卫视', '78294.84');
INSERT INTO `data` VALUES ('宁夏卫视', '81456.96');
INSERT INTO `data` VALUES ('安徽卫视', '76831.56');
INSERT INTO `data` VALUES ('江苏卫视', '81870.36');
INSERT INTO `data` VALUES ('浙江卫视', '64711.92');
INSERT INTO `data` VALUES ('深圳卫视', '70011.24');
INSERT INTO `data` VALUES ('湖南卫视', '82190.16');
INSERT INTO `data` VALUES ('湖南金鹰卡通', '80057.64');

-- ----------------------------
-- Table structure for demo_user
-- ----------------------------
DROP TABLE IF EXISTS `demo_user`;
CREATE TABLE `demo_user` (
  `id` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `name` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `age` tinyint(4) NOT NULL,
  `qq` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `address` varchar(72) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `email` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of demo_user
-- ----------------------------
INSERT INTO `demo_user` VALUES ('798825602', '陈英', '18', '32146863068', '北京市朝阳区世纪东方城125栋5单元3005室', '2310561307@qq.com');
INSERT INTO `demo_user` VALUES ('798825603', '赵兵', '20', '90847506198', '北京市朝阳区世纪东方城125栋5单元3006室', '1881435326@qq.com');
INSERT INTO `demo_user` VALUES ('798825604', '王麒民', '22', '95431441180', '北京市朝阳区世纪东方城125栋5单元3007室', '1734846536@qq.com');
INSERT INTO `demo_user` VALUES ('798825605', '戴国强', '22', '28442485045', '北京市朝阳区世纪东方城125栋5单元3008室', '1781511213@qq.com');
INSERT INTO `demo_user` VALUES ('798825606', '陶洪万', '19', '79825546119', '北京市朝阳区世纪东方城125栋5单元3009室', '2283974687@qq.com');
INSERT INTO `demo_user` VALUES ('798825607', '朱洪纯', '23', '76909349730', '北京市朝阳区世纪东方城125栋5单元3010室', '1425002097@qq.com');
INSERT INTO `demo_user` VALUES ('798825608', '徐亚玲', '19', '63372466569', '北京市朝阳区世纪东方城125栋5单元3011室', '1534262585@qq.com');
INSERT INTO `demo_user` VALUES ('798825609', '徐宗玲', '18', '28994320130', '北京市朝阳区世纪东方城125栋5单元3012室', '1956770773@qq.com');
INSERT INTO `demo_user` VALUES ('798825610', '刘海琪', '19', '95201224119', '北京市朝阳区世纪东方城125栋5单元3013室', '2255764786@qq.com');
INSERT INTO `demo_user` VALUES ('7988256100', '张五娘', '18', '8008208820', '北京市朝阳区世纪东方城125栋5单元3103室', '8008208820@qq.com');
INSERT INTO `demo_user` VALUES ('798825611', '曾辉', '22', '74714726666', '北京市朝阳区世纪东方城125栋5单元3014室', '1620869775@qq.com');
INSERT INTO `demo_user` VALUES ('798825612', '唐转兵', '19', '43136718018', '北京市朝阳区世纪东方城125栋5单元3015室', '1565299971@qq.com');
INSERT INTO `demo_user` VALUES ('798825613', '张其', '24', '59313839605', '北京市朝阳区世纪东方城125栋5单元3016室', '1669557028@qq.com');
INSERT INTO `demo_user` VALUES ('798825614', '光光', '23', '32134211694', '北京市朝阳区世纪东方城125栋5单元3017室', '1931567065@qq.com');
INSERT INTO `demo_user` VALUES ('798825615', '谢林华', '22', '89797287269', '北京市朝阳区世纪东方城125栋5单元3018室', '1474064163@qq.com');
INSERT INTO `demo_user` VALUES ('798825616', '梁远述', '22', '64957886336', '北京市朝阳区世纪东方城125栋5单元3019室', '2349619856@qq.com');
INSERT INTO `demo_user` VALUES ('798825617', '王波香', '21', '81753956572', '北京市朝阳区世纪东方城125栋5单元3020室', '2160025703@qq.com');
INSERT INTO `demo_user` VALUES ('798825618', '王洪超', '21', '84330276621', '北京市朝阳区世纪东方城125栋5单元3021室', '1682397751@qq.com');
INSERT INTO `demo_user` VALUES ('798825619', '刘江', '22', '75649166242', '北京市朝阳区世纪东方城125栋5单元3022室', '1879996012@qq.com');
INSERT INTO `demo_user` VALUES ('798825620', '黄光平', '18', '72326323268', '北京市朝阳区世纪东方城125栋5单元3023室', '1977905655@qq.com');
INSERT INTO `demo_user` VALUES ('798825621', '赵磊', '18', '15918903619', '北京市朝阳区世纪东方城125栋5单元3024室', '1962710661@qq.com');
INSERT INTO `demo_user` VALUES ('798825622', '杨春香', '23', '32501444125', '北京市朝阳区世纪东方城125栋5单元3025室', '2403481265@qq.com');
INSERT INTO `demo_user` VALUES ('798825623', '卢军', '20', '61835250019', '北京市朝阳区世纪东方城125栋5单元3026室', '1716994550@qq.com');
INSERT INTO `demo_user` VALUES ('798825624', '谭恢来', '19', '72608007051', '北京市朝阳区世纪东方城125栋5单元3027室', '1659073176@qq.com');
INSERT INTO `demo_user` VALUES ('798825625', '徐福海', '22', '74006227541', '北京市朝阳区世纪东方城125栋5单元3028室', '2046793987@qq.com');
INSERT INTO `demo_user` VALUES ('798825626', '陈群华', '20', '98789512983', '北京市朝阳区世纪东方城125栋5单元3029室', '1496966764@qq.com');
INSERT INTO `demo_user` VALUES ('798825627', '敬小玲', '24', '87072934784', '北京市朝阳区世纪东方城125栋5单元3030室', '1749653530@qq.com');
INSERT INTO `demo_user` VALUES ('798825628', '王柏杨', '18', '75683934406', '北京市朝阳区世纪东方城125栋5单元3031室', '2023698559@qq.com');
INSERT INTO `demo_user` VALUES ('798825629', '刘崇溶', '20', '66753286646', '北京市朝阳区世纪东方城125栋5单元3032室', '1814255203@qq.com');
INSERT INTO `demo_user` VALUES ('798825630', '袁微', '18', '44106800574', '北京市朝阳区世纪东方城125栋5单元3033室', '1769383427@qq.com');
INSERT INTO `demo_user` VALUES ('798825631', '冯世军', '18', '97971918455', '北京市朝阳区世纪东方城125栋5单元3034室', '1962584892@qq.com');
INSERT INTO `demo_user` VALUES ('798825632', '袁舒含', '22', '32995158704', '北京市朝阳区世纪东方城125栋5单元3035室', '2226761278@qq.com');
INSERT INTO `demo_user` VALUES ('798825633', '李贵君', '19', '89183380167', '北京市朝阳区世纪东方城125栋5单元3036室', '2370870978@qq.com');
INSERT INTO `demo_user` VALUES ('798825634', '袁绍斌', '18', '55353484065', '北京市朝阳区世纪东方城125栋5单元3037室', '2003581914@qq.com');
INSERT INTO `demo_user` VALUES ('798825635', '李定其', '21', '51209484399', '北京市朝阳区世纪东方城125栋5单元3038室', '2020461792@qq.com');
INSERT INTO `demo_user` VALUES ('798825636', '罗江山', '23', '73444446492', '北京市朝阳区世纪东方城125栋5单元3039室', '1969138899@qq.com');
INSERT INTO `demo_user` VALUES ('798825637', '王广芳', '24', '16167264113', '北京市朝阳区世纪东方城125栋5单元3040室', '2153641941@qq.com');
INSERT INTO `demo_user` VALUES ('798825638', '孔宪全', '23', '63273494704', '北京市朝阳区世纪东方城125栋5单元3041室', '2177606696@qq.com');
INSERT INTO `demo_user` VALUES ('798825639', '曹兴富', '24', '89200040313', '北京市朝阳区世纪东方城125栋5单元3042室', '2067604410@qq.com');
INSERT INTO `demo_user` VALUES ('798825640', '游伟', '24', '87873751636', '北京市朝阳区世纪东方城125栋5单元3043室', '1625582453@qq.com');
INSERT INTO `demo_user` VALUES ('798825641', '宁有洁', '24', '40865305353', '北京市朝阳区世纪东方城125栋5单元3044室', '2381951506@qq.com');
INSERT INTO `demo_user` VALUES ('798825642', '陈桂香', '21', '73262222355', '北京市朝阳区世纪东方城125栋5单元3045室', '2210039922@qq.com');
INSERT INTO `demo_user` VALUES ('798825643', '王恒英', '19', '93446525828', '北京市朝阳区世纪东方城125栋5单元3046室', '1506484206@qq.com');
INSERT INTO `demo_user` VALUES ('798825644', '吴文模', '20', '92433539568', '北京市朝阳区世纪东方城125栋5单元3047室', '1699468196@qq.com');
INSERT INTO `demo_user` VALUES ('798825645', '叶元凤', '22', '80037324255', '北京市朝阳区世纪东方城125栋5单元3048室', '1545066638@qq.com');
INSERT INTO `demo_user` VALUES ('798825646', '陈德民', '24', '69621914743', '北京市朝阳区世纪东方城125栋5单元3049室', '1528789097@qq.com');
INSERT INTO `demo_user` VALUES ('798825647', '谭定珍', '21', '25337687377', '北京市朝阳区世纪东方城125栋5单元3050室', '1993485093@qq.com');
INSERT INTO `demo_user` VALUES ('798825648', '罗元森', '23', '93993765495', '北京市朝阳区世纪东方城125栋5单元3051室', '1467691374@qq.com');
INSERT INTO `demo_user` VALUES ('798825649', '夏永权', '22', '70172907870', '北京市朝阳区世纪东方城125栋5单元3052室', '1875138888@qq.com');
INSERT INTO `demo_user` VALUES ('798825650', '张馨予', '22', '50690860500', '北京市朝阳区世纪东方城125栋5单元3053室', '1615946291@qq.com');
INSERT INTO `demo_user` VALUES ('798825651', '孙晓梅', '23', '68437887914', '北京市朝阳区世纪东方城125栋5单元3054室', '1429359268@qq.com');
INSERT INTO `demo_user` VALUES ('798825652', '武英瑛', '19', '27704523359', '北京市朝阳区世纪东方城125栋5单元3055室', '1856739959@qq.com');
INSERT INTO `demo_user` VALUES ('798825653', '付晓晨', '19', '72052073090', '北京市朝阳区世纪东方城125栋5单元3056室', '2023193569@qq.com');
INSERT INTO `demo_user` VALUES ('798825654', '彭华', '19', '28439207517', '北京市朝阳区世纪东方城125栋5单元3057室', '1632275399@qq.com');
INSERT INTO `demo_user` VALUES ('798825655', '罗成', '21', '70763738950', '北京市朝阳区世纪东方城125栋5单元3058室', '2105934707@qq.com');
INSERT INTO `demo_user` VALUES ('798825656', '宋凤英', '21', '26199624548', '北京市朝阳区世纪东方城125栋5单元3059室', '1497061957@qq.com');
INSERT INTO `demo_user` VALUES ('798825657', '张斌', '19', '45660933019', '北京市朝阳区世纪东方城125栋5单元3060室', '2378747623@qq.com');
INSERT INTO `demo_user` VALUES ('798825658', '董太林', '20', '31910675642', '北京市朝阳区世纪东方城125栋5单元3061室', '2097730982@qq.com');
INSERT INTO `demo_user` VALUES ('798825659', '丁雪', '19', '20035926386', '北京市朝阳区世纪东方城125栋5单元3062室', '2130674225@qq.com');
INSERT INTO `demo_user` VALUES ('798825660', '释亲海', '20', '55810863548', '北京市朝阳区世纪东方城125栋5单元3063室', '1697205856@qq.com');
INSERT INTO `demo_user` VALUES ('798825661', '张乐', '23', '18003457093', '北京市朝阳区世纪东方城125栋5单元3064室', '2251536353@qq.com');
INSERT INTO `demo_user` VALUES ('798825662', '王洪斌', '22', '71619480207', '北京市朝阳区世纪东方城125栋5单元3065室', '1801458268@qq.com');
INSERT INTO `demo_user` VALUES ('798825663', '施继海', '20', '52255041669', '北京市朝阳区世纪东方城125栋5单元3066室', '1982670804@qq.com');
INSERT INTO `demo_user` VALUES ('798825664', '方世爱', '20', '76733401334', '北京市朝阳区世纪东方城125栋5单元3067室', '2224966661@qq.com');
INSERT INTO `demo_user` VALUES ('798825665', '张灵', '23', '34714815078', '北京市朝阳区世纪东方城125栋5单元3068室', '1959613087@qq.com');
INSERT INTO `demo_user` VALUES ('798825666', '刘莹莹', '18', '51613476657', '北京市朝阳区世纪东方城125栋5单元3069室', '1508464759@qq.com');
INSERT INTO `demo_user` VALUES ('798825667', '李林', '22', '65456972726', '北京市朝阳区世纪东方城125栋5单元3070室', '1899046808@qq.com');
INSERT INTO `demo_user` VALUES ('798825668', '张淑瑛', '23', '55362060215', '北京市朝阳区世纪东方城125栋5单元3071室', '1863044131@qq.com');
INSERT INTO `demo_user` VALUES ('798825669', '付淑霞', '24', '65821367717', '北京市朝阳区世纪东方城125栋5单元3072室', '2286200676@qq.com');
INSERT INTO `demo_user` VALUES ('798825670', '李洪文', '22', '74668433955', '北京市朝阳区世纪东方城125栋5单元3073室', '1685304228@qq.com');
INSERT INTO `demo_user` VALUES ('798825671', '张金玲', '18', '39175659561', '北京市朝阳区世纪东方城125栋5单元3074室', '2090467234@qq.com');
INSERT INTO `demo_user` VALUES ('798825672', '李宁', '24', '92929331778', '北京市朝阳区世纪东方城125栋5单元3075室', '2196412623@qq.com');
INSERT INTO `demo_user` VALUES ('798825673', '樊景国', '19', '92257566176', '北京市朝阳区世纪东方城125栋5单元3076室', '1854642822@qq.com');
INSERT INTO `demo_user` VALUES ('798825674', '金香淑', '19', '53724875224', '北京市朝阳区世纪东方城125栋5单元3077室', '1692956435@qq.com');
INSERT INTO `demo_user` VALUES ('798825675', '李辰烽', '23', '59885061368', '北京市朝阳区世纪东方城125栋5单元3078室', '1765793342@qq.com');
INSERT INTO `demo_user` VALUES ('798825676', '吕春敏', '20', '82275732999', '北京市朝阳区世纪东方城125栋5单元3079室', '2402123293@qq.com');
INSERT INTO `demo_user` VALUES ('798825677', '李文全', '22', '34163775045', '北京市朝阳区世纪东方城125栋5单元3080室', '1435360894@qq.com');
INSERT INTO `demo_user` VALUES ('798825678', '于源水', '19', '80010561379', '北京市朝阳区世纪东方城125栋5单元3081室', '2292438722@qq.com');
INSERT INTO `demo_user` VALUES ('798825679', '元涛', '23', '98079597524', '北京市朝阳区世纪东方城125栋5单元3082室', '2278871233@qq.com');
INSERT INTO `demo_user` VALUES ('798825680', '白玉', '22', '15960845816', '北京市朝阳区世纪东方城125栋5单元3083室', '1826252497@qq.com');
INSERT INTO `demo_user` VALUES ('798825681', '孙福艳', '19', '91400449249', '北京市朝阳区世纪东方城125栋5单元3084室', '2106063082@qq.com');
INSERT INTO `demo_user` VALUES ('798825682', '张明美', '18', '64018743400', '北京市朝阳区世纪东方城125栋5单元3085室', '1760583224@qq.com');
INSERT INTO `demo_user` VALUES ('798825683', '傅江桐', '18', '80814923899', '北京市朝阳区世纪东方城125栋5单元3086室', '2341718848@qq.com');
INSERT INTO `demo_user` VALUES ('798825684', '张志军', '20', '56801454154', '北京市朝阳区世纪东方城125栋5单元3087室', '2091780476@qq.com');
INSERT INTO `demo_user` VALUES ('798825685', '采有明', '22', '72144694885', '北京市朝阳区世纪东方城125栋5单元3088室', '2042652485@qq.com');
INSERT INTO `demo_user` VALUES ('798825686', '刘祺龙', '19', '85611894296', '北京市朝阳区世纪东方城125栋5单元3089室', '2336801966@qq.com');
INSERT INTO `demo_user` VALUES ('798825687', '王程', '18', '93295811973', '北京市朝阳区世纪东方城125栋5单元3090室', '2270583111@qq.com');
INSERT INTO `demo_user` VALUES ('798825688', '赵海勇', '23', '50614412340', '北京市朝阳区世纪东方城125栋5单元3091室', '1873832817@qq.com');
INSERT INTO `demo_user` VALUES ('798825689', '王绍然', '22', '95399407299', '北京市朝阳区世纪东方城125栋5单元3092室', '1844796221@qq.com');
INSERT INTO `demo_user` VALUES ('798825690', '刘洁芳', '22', '89499585286', '北京市朝阳区世纪东方城125栋5单元3093室', '2130058529@qq.com');
INSERT INTO `demo_user` VALUES ('798825691', '张贵文', '19', '47141761113', '北京市朝阳区世纪东方城125栋5单元3094室', '1493835773@qq.com');
INSERT INTO `demo_user` VALUES ('798825692', '朱海媛', '18', '54234254212', '北京市朝阳区世纪东方城125栋5单元3095室', '2022766387@qq.com');
INSERT INTO `demo_user` VALUES ('798825693', '李龙生', '22', '84204313237', '北京市朝阳区世纪东方城125栋5单元3096室', '1549086803@qq.com');
INSERT INTO `demo_user` VALUES ('798825694', '刘昊天', '18', '95106986829', '北京市朝阳区世纪东方城125栋5单元3097室', '1728609417@qq.com');
INSERT INTO `demo_user` VALUES ('798825695', '张杰', '18', '48359005614', '北京市朝阳区世纪东方城125栋5单元3098室', '1861525829@qq.com');
INSERT INTO `demo_user` VALUES ('798825696', '蔺昱睿', '18', '79297453899', '北京市朝阳区世纪东方城125栋5单元3099室', '2108858405@qq.com');
INSERT INTO `demo_user` VALUES ('798825697', '翁金卉', '22', '48135424733', '北京市朝阳区世纪东方城125栋5单元3100室', '1900044159@qq.com');
INSERT INTO `demo_user` VALUES ('798825698', '陈彪', '21', '15359701221', '北京市朝阳区世纪东方城125栋5单元3101室', '2185183990@qq.com');
INSERT INTO `demo_user` VALUES ('798825699', '蔡小雨', '22', '78821640487', '北京市朝阳区世纪东方城125栋5单元3102室', '1423505545@qq.com');