/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50624
Source Host           : localhost:3306
Source Database       : chongwushequ

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

Date: 2020-11-12 15:10:55
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `caccumulate`
-- ----------------------------
DROP TABLE IF EXISTS `caccumulate`;
CREATE TABLE `caccumulate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `csum` int(11) DEFAULT NULL,
  `cuse` int(11) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of caccumulate
-- ----------------------------
INSERT INTO `caccumulate` VALUES ('3', '100100', '96800', '18152183560');

-- ----------------------------
-- Table structure for `caccumulateitem`
-- ----------------------------
DROP TABLE IF EXISTS `caccumulateitem`;
CREATE TABLE `caccumulateitem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) DEFAULT NULL,
  `eid` int(11) DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of caccumulateitem
-- ----------------------------
INSERT INTO `caccumulateitem` VALUES ('20', '1', '125', '10000', '2020年08月04 13:17:35', '18152183560');
INSERT INTO `caccumulateitem` VALUES ('21', '1', '126', '5900', '2020年08月04 13:18:49', '18152183560');
INSERT INTO `caccumulateitem` VALUES ('22', '2', '1', '100', '2020年08月04 13:26:10', '18152183560');
INSERT INTO `caccumulateitem` VALUES ('23', '2', '1', '100', '2020年08月04 13:34:35', '18152183560');
INSERT INTO `caccumulateitem` VALUES ('24', '1', '127', '5900', '2020年10月06 08:22:40', '18152183560');
INSERT INTO `caccumulateitem` VALUES ('25', '1', '128', '5900', '2020年10月09 10:08:21', '18152183560');
INSERT INTO `caccumulateitem` VALUES ('26', '1', '129', '17700', '2020年10月09 10:25:19', '18152183560');
INSERT INTO `caccumulateitem` VALUES ('27', '1', '130', '5900', '2020年10月17 15:46:41', '18152183560');
INSERT INTO `caccumulateitem` VALUES ('28', '1', '131', '5900', '2020年10月19 15:34:52', '18152183560');
INSERT INTO `caccumulateitem` VALUES ('29', '1', '132', '13200', '2020年10月22 15:28:46', '18152183560');
INSERT INTO `caccumulateitem` VALUES ('30', '1', '133', '13200', '2020年10月22 15:29:19', '18152183560');
INSERT INTO `caccumulateitem` VALUES ('31', '1', '134', '13200', '2020年11月06 14:58:49', '18152183560');

-- ----------------------------
-- Table structure for `caddress`
-- ----------------------------
DROP TABLE IF EXISTS `caddress`;
CREATE TABLE `caddress` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `addis` int(11) DEFAULT NULL,
  `addphone` varchar(255) DEFAULT NULL,
  `addname` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of caddress
-- ----------------------------
INSERT INTO `caddress` VALUES ('1', '18152183560', '上海市 上海市 普陀区 t', '0', '181521835460', '王明3');
INSERT INTO `caddress` VALUES ('2', '18152183560', '甘肃省 白银市 会宁县 会宁一中', '0', '15193093423', '王明2');
INSERT INTO `caddress` VALUES ('3', '18152183560', '上海市 上海市 嘉定区 2828', '0', '8228', '2282');
INSERT INTO `caddress` VALUES ('7', '18152183560', '上海市 上海市 浦东新区 5', '0', '5', '5');
INSERT INTO `caddress` VALUES ('8', '18152183560', '上海市 上海市 静安区 522', '1', '22', '2');

-- ----------------------------
-- Table structure for `cadmin`
-- ----------------------------
DROP TABLE IF EXISTS `cadmin`;
CREATE TABLE `cadmin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(255) DEFAULT NULL,
  `pwd` varchar(255) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cadmin
-- ----------------------------
INSERT INTO `cadmin` VALUES ('1', '18152183560', 'e2b079378271e5a6dd033f64954c13af', '1');
INSERT INTO `cadmin` VALUES ('2', '18796959415', '7468be5b26caf6073220471f12b0d2c0', '2');

-- ----------------------------
-- Table structure for `cattention`
-- ----------------------------
DROP TABLE IF EXISTS `cattention`;
CREATE TABLE `cattention` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `t` varchar(255) DEFAULT NULL,
  `f` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of cattention
-- ----------------------------
INSERT INTO `cattention` VALUES ('7', '13884286359', '18152183560');
INSERT INTO `cattention` VALUES ('19', '15193093423', '18152183560');
INSERT INTO `cattention` VALUES ('21', '18152183560', '15193093423');
INSERT INTO `cattention` VALUES ('22', '18152183560', '17368150311');
INSERT INTO `cattention` VALUES ('23', '18152183560', '18152183560');

-- ----------------------------
-- Table structure for `cbarrage`
-- ----------------------------
DROP TABLE IF EXISTS `cbarrage`;
CREATE TABLE `cbarrage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eid` int(11) DEFAULT NULL,
  `text` varchar(255) DEFAULT NULL,
  `shijian` int(11) DEFAULT NULL,
  `size` varchar(11) DEFAULT NULL,
  `color` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cbarrage
-- ----------------------------
INSERT INTO `cbarrage` VALUES ('2', '1', '你好', '47', '15px', '#B60266');
INSERT INTO `cbarrage` VALUES ('3', '1', '你好世界', '18', '15px', '#B60266');
INSERT INTO `cbarrage` VALUES ('4', '1', '年后', '10', '15px', '#B60266');
INSERT INTO `cbarrage` VALUES ('5', '1', '发个弹幕1', '7', '15px', '#cb7d93');
INSERT INTO `cbarrage` VALUES ('6', '1', '发个弹幕2', '7', '15px', '#007A34');
INSERT INTO `cbarrage` VALUES ('7', '1', '发个弹幕3', '7', '15px', '#007A34');
INSERT INTO `cbarrage` VALUES ('8', '1', '发个弹幕4', '7', '20px', '#007A34');
INSERT INTO `cbarrage` VALUES ('9', '1', '发个弹幕5', '7', '15px', '#CECECE');
INSERT INTO `cbarrage` VALUES ('10', '1', '发个弹幕6', '7', '15px', '#CECECE');
INSERT INTO `cbarrage` VALUES ('11', '1', '发个弹幕7', '7', '15px', '#CECECE');
INSERT INTO `cbarrage` VALUES ('12', '1', '发个弹幕7', '47', '15px', '#CCC201');
INSERT INTO `cbarrage` VALUES ('13', '1', '发个弹幕7', '47', '15px', '#CCC201');
INSERT INTO `cbarrage` VALUES ('14', '1', '发个弹幕8', '47', '20px', '#CCC201');
INSERT INTO `cbarrage` VALUES ('15', '1', '发个弹幕1', '32', '20px', '#BB000E');
INSERT INTO `cbarrage` VALUES ('16', '1', '发个弹幕1', '32', '20px', '#BB000E');
INSERT INTO `cbarrage` VALUES ('17', '1', '发个弹幕1', '32', '20px', '#BB000E');
INSERT INTO `cbarrage` VALUES ('18', '1', '发个弹幕1', '32', '20px', '#BB000E');
INSERT INTO `cbarrage` VALUES ('19', '1', '发个弹幕1', '32', '20px', '#BB000E');
INSERT INTO `cbarrage` VALUES ('20', '1', '发个弹幕1', '32', '20px', '#BB000E');
INSERT INTO `cbarrage` VALUES ('21', '1', '发个弹幕1', '32', '20px', '#BB000E');
INSERT INTO `cbarrage` VALUES ('22', '1', '发个弹幕1', '32', '20px', '#BB000E');
INSERT INTO `cbarrage` VALUES ('23', '1', '发个弹幕2', '32', '20px', '#B60266');
INSERT INTO `cbarrage` VALUES ('24', '1', '发个弹幕2', '32', '20px', '#B60266');
INSERT INTO `cbarrage` VALUES ('25', '1', '发个弹幕2', '32', '20px', '#B60266');
INSERT INTO `cbarrage` VALUES ('26', '1', '发个弹幕2', '32', '20px', '#B60266');
INSERT INTO `cbarrage` VALUES ('27', '1', '发个弹幕2', '32', '20px', '#B60266');
INSERT INTO `cbarrage` VALUES ('28', '1', '发个弹幕2', '32', '15px', '#007A34');
INSERT INTO `cbarrage` VALUES ('29', '1', '发个弹幕2', '32', '15px', '#007A34');
INSERT INTO `cbarrage` VALUES ('30', '1', '发个弹幕2', '32', '15px', '#007A34');
INSERT INTO `cbarrage` VALUES ('31', '1', '发个弹幕2', '32', '15px', '#007A34');
INSERT INTO `cbarrage` VALUES ('32', '1', '发个弹幕2', '32', '15px', '#007A34');
INSERT INTO `cbarrage` VALUES ('33', '1', '发个弹幕2', '32', '15px', '#007A34');
INSERT INTO `cbarrage` VALUES ('34', '1', '发个弹幕2', '32', '15px', '#007A34');
INSERT INTO `cbarrage` VALUES ('35', '1', '发个弹幕3', '32', '20px', '#CECECE');
INSERT INTO `cbarrage` VALUES ('36', '1', '发个弹幕3', '32', '20px', '#CECECE');
INSERT INTO `cbarrage` VALUES ('37', '1', '发个弹幕3', '32', '20px', '#CECECE');
INSERT INTO `cbarrage` VALUES ('38', '1', '发个弹幕3', '32', '20px', '#CECECE');
INSERT INTO `cbarrage` VALUES ('39', '1', '25822', '6', '15px', '#CCC201');
INSERT INTO `cbarrage` VALUES ('40', '1', '25822', '6', '15px', '#CCC201');
INSERT INTO `cbarrage` VALUES ('41', '1', '25822', '6', '15px', '#CCC201');
INSERT INTO `cbarrage` VALUES ('42', '1', '25822', '6', '15px', '#CCC201');
INSERT INTO `cbarrage` VALUES ('43', '1', '25822', '6', '15px', '#CCC201');
INSERT INTO `cbarrage` VALUES ('44', '1', '25822', '6', '15px', '#CCC201');
INSERT INTO `cbarrage` VALUES ('45', '1', '25822', '6', '15px', '#CCC201');
INSERT INTO `cbarrage` VALUES ('46', '1', '25822', '6', '15px', '#CCC201');
INSERT INTO `cbarrage` VALUES ('47', '1', '25822', '6', '15px', '#CCC201');
INSERT INTO `cbarrage` VALUES ('48', '1', '下次一定', '9', '20px', '#CCC201');
INSERT INTO `cbarrage` VALUES ('49', '1', 'vgnn', '2', '15px', '#cb7d93');
INSERT INTO `cbarrage` VALUES ('50', '1', 'vgnn', '2', '15px', '#cb7d93');
INSERT INTO `cbarrage` VALUES ('51', '1', 'vgnn', '2', '20px', '#CECECE');
INSERT INTO `cbarrage` VALUES ('52', '1', 'vgnn', '2', '20px', '#CECECE');
INSERT INTO `cbarrage` VALUES ('53', '1', 'vgnn', '2', '20px', '#CECECE');
INSERT INTO `cbarrage` VALUES ('54', '1', 'vgnn', '2', '20px', '#CECECE');
INSERT INTO `cbarrage` VALUES ('55', '2', '呕呕', '2', '20px', '#BB000E');
INSERT INTO `cbarrage` VALUES ('56', '2', '呕呕', '9', '15px', '#007A34');
INSERT INTO `cbarrage` VALUES ('57', '1', '1', '2', '15px', '#cb7d93');
INSERT INTO `cbarrage` VALUES ('58', '1', '1', '2', '15px', '#CCC201');
INSERT INTO `cbarrage` VALUES ('59', '1', '跟人沟通吧', '5', '15px', '#CCC201');

-- ----------------------------
-- Table structure for `cclass`
-- ----------------------------
DROP TABLE IF EXISTS `cclass`;
CREATE TABLE `cclass` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `classname` varchar(255) DEFAULT NULL,
  `lecturer` varchar(255) DEFAULT NULL,
  `introduce` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cclass
-- ----------------------------
INSERT INTO `cclass` VALUES ('1', '犬类技能培训', '小明2', '本课程是犬类的培训课程，有上厕所、接飞盘、握手等教学内容。本课程由著名训犬师小明进行授课。', '狗');
INSERT INTO `cclass` VALUES ('2', '犬类技能培训2', '小明', '本课程是犬类的培训课程，有上厕所、接飞盘、握手等教学内容。本课程由著名训犬师小明进行授课。2', '狗');
INSERT INTO `cclass` VALUES ('3', '犬类技能培训3', '小明3', '本课程是犬类的培训课程，有上厕所、接飞盘、握手等教学内容。本课程由著名训犬师小明进行授课。3', '狗');
INSERT INTO `cclass` VALUES ('4', '犬类技能培训4', '小明4', '本课程是犬类的培训课程，有上厕所、接飞盘、握手等教学内容。本课程由著名训犬师小明进行授课。4', '狗');

-- ----------------------------
-- Table structure for `cclassitem`
-- ----------------------------
DROP TABLE IF EXISTS `cclassitem`;
CREATE TABLE `cclassitem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eid` int(11) DEFAULT NULL,
  `classname` varchar(255) DEFAULT NULL,
  `unit` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cclassitem
-- ----------------------------
INSERT INTO `cclassitem` VALUES ('1', '1', '上厕所', '第一单元');
INSERT INTO `cclassitem` VALUES ('2', '1', '接飞盘', '第一单元');
INSERT INTO `cclassitem` VALUES ('3', '1', '握手', '第二单元');
INSERT INTO `cclassitem` VALUES ('4', '1', '坐下', '第二单元');
INSERT INTO `cclassitem` VALUES ('5', '1', '卧下', '第二单元');
INSERT INTO `cclassitem` VALUES ('6', '1', 's步', '第二单元');
INSERT INTO `cclassitem` VALUES ('7', '1', '随行', '第三单元');
INSERT INTO `cclassitem` VALUES ('9', '2', '接飞盘2', '第一单元');
INSERT INTO `cclassitem` VALUES ('10', '2', '上厕所2', '第二单元');
INSERT INTO `cclassitem` VALUES ('11', '2', '握手', '第二单元');

-- ----------------------------
-- Table structure for `ccollection`
-- ----------------------------
DROP TABLE IF EXISTS `ccollection`;
CREATE TABLE `ccollection` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) DEFAULT NULL,
  `eid` int(11) DEFAULT NULL,
  `user` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of ccollection
-- ----------------------------
INSERT INTO `ccollection` VALUES ('5', '1', '9', '18152183560');
INSERT INTO `ccollection` VALUES ('7', '1', '10', '18152183560');
INSERT INTO `ccollection` VALUES ('8', '1', '8', '18152183560');
INSERT INTO `ccollection` VALUES ('9', '1', '7', '18152183560');
INSERT INTO `ccollection` VALUES ('10', '1', '6', '18152183560');
INSERT INTO `ccollection` VALUES ('11', '1', '5', '18152183560');
INSERT INTO `ccollection` VALUES ('12', '1', '4', '18152183560');
INSERT INTO `ccollection` VALUES ('17', '1', '46', '18152183560');
INSERT INTO `ccollection` VALUES ('32', '1', '44', '18152183560');
INSERT INTO `ccollection` VALUES ('34', '2', '4', '18152183560');
INSERT INTO `ccollection` VALUES ('38', '3', '1', '18152183560');
INSERT INTO `ccollection` VALUES ('40', '3', '2', '18152183560');
INSERT INTO `ccollection` VALUES ('42', '1', '48', '18152183560');

-- ----------------------------
-- Table structure for `ccomment`
-- ----------------------------
DROP TABLE IF EXISTS `ccomment`;
CREATE TABLE `ccomment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` varchar(255) DEFAULT NULL,
  `dynamicid` int(11) DEFAULT NULL,
  `userphone` varchar(11) DEFAULT NULL,
  `releasetime` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of ccomment
-- ----------------------------
INSERT INTO `ccomment` VALUES ('1', '说点啥不管不顾1', '9', '18152183560', '2020/07/02');
INSERT INTO `ccomment` VALUES ('2', '说点啥不管不顾2', '9', '13884286359', '2020/07/02');
INSERT INTO `ccomment` VALUES ('10', '说点啥11', '9', '18152183560', '2020/07/02');
INSERT INTO `ccomment` VALUES ('14', '说点啥彻底的', '9', '18152183560', '2020/07/02');
INSERT INTO `ccomment` VALUES ('16', '说点啥v而法律和风格个人给给官方v发发', '9', '18152183560', '2020/07/02');
INSERT INTO `ccomment` VALUES ('20', '说点啥v而法律和风格个人给给官方v发发', '9', '18152183560', '2020/07/02');
INSERT INTO `ccomment` VALUES ('22', '说点啥v而法律和风格个人给给官方v发发', '9', '18152183560', '2020/07/02');
INSERT INTO `ccomment` VALUES ('24', '说点啥', '9', '18152183560', '2020/07/03');
INSERT INTO `ccomment` VALUES ('25', '说点啥', '9', '18152183560', '2020/07/03');
INSERT INTO `ccomment` VALUES ('26', '说点啥vff ', '10', '18152183560', '2020/07/04');
INSERT INTO `ccomment` VALUES ('27', '说点啥 vf d ', '1', '18152183560', '2020/07/06');
INSERT INTO `ccomment` VALUES ('28', '说点啥', '46', '18152183560', '2020/07/07');
INSERT INTO `ccomment` VALUES ('29', '说点啥11', '9', '18152183560', '2020/07/10');
INSERT INTO `ccomment` VALUES ('30', '说点啥', '44', '18152183560', '2020/07/10');
INSERT INTO `ccomment` VALUES ('31', '说点啥', '46', '18152183560', '2020/08/26');
INSERT INTO `ccomment` VALUES ('32', '说点啥bbgbgt', '47', '18152183560', '2020/10/09');
INSERT INTO `ccomment` VALUES ('33', '说点啥hmjym', '48', '18152183560', '2020/10/10');
INSERT INTO `ccomment` VALUES ('34', '说点啥', '48', '18152183560', '2020/10/11');
INSERT INTO `ccomment` VALUES ('35', '说点啥trgt', '48', '18152183560', '2020/10/17');
INSERT INTO `ccomment` VALUES ('36', '说点啥关闭关闭', '48', '18152183560', '2020/10/19');
INSERT INTO `ccomment` VALUES ('37', '说点啥', '46', '18152183560', '2020/10/22');
INSERT INTO `ccomment` VALUES ('38', '说点啥   跟他沟通', '49', '18152183560', '2020/10/22');
INSERT INTO `ccomment` VALUES ('39', '说点啥vfr', '52', '18152183560', '2020/11/06');

-- ----------------------------
-- Table structure for `ccommentitem`
-- ----------------------------
DROP TABLE IF EXISTS `ccommentitem`;
CREATE TABLE `ccommentitem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `commentid` int(11) DEFAULT NULL,
  `userphone` varchar(11) DEFAULT NULL,
  `text` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of ccommentitem
-- ----------------------------
INSERT INTO `ccommentitem` VALUES ('1', '2', '13884286359', '说点啥淡出');
INSERT INTO `ccommentitem` VALUES ('9', '1', '18152183560', '说点啥????‍♂️?????✌?');
INSERT INTO `ccommentitem` VALUES ('10', '1', '18152183560', '说点啥????‍♂️?????✌?');
INSERT INTO `ccommentitem` VALUES ('11', '1', '18152183560', '说点啥????‍♂️?????✌?');
INSERT INTO `ccommentitem` VALUES ('12', '1', '18152183560', '说点啥????‍♂️?????✌?');
INSERT INTO `ccommentitem` VALUES ('13', '1', '18152183560', '说点啥????‍♂️?????✌?');
INSERT INTO `ccommentitem` VALUES ('15', '1', '18152183560', '说点啥????‍♂️?????✌?');
INSERT INTO `ccommentitem` VALUES ('18', '1', '18152183560', '说点啥????‍♂️?????✌?');
INSERT INTO `ccommentitem` VALUES ('29', '26', '18152183560', '说点啥frgrvv ');
INSERT INTO `ccommentitem` VALUES ('42', '28', '18152183560', '说点啥');
INSERT INTO `ccommentitem` VALUES ('47', '28', '18152183560', '说点啥');
INSERT INTO `ccommentitem` VALUES ('48', '28', '18152183560', '说点啥');
INSERT INTO `ccommentitem` VALUES ('49', '28', '18152183560', '说点啥');
INSERT INTO `ccommentitem` VALUES ('50', '28', '18152183560', '说点啥');
INSERT INTO `ccommentitem` VALUES ('58', '24', '18152183560', '说点啥4');
INSERT INTO `ccommentitem` VALUES ('60', '25', '18152183560', '说点啥3');
INSERT INTO `ccommentitem` VALUES ('67', '24', '18152183560', '说点啥2');
INSERT INTO `ccommentitem` VALUES ('68', '24', '18152183560', '说点啥3');
INSERT INTO `ccommentitem` VALUES ('70', '29', '18152183560', '说点啥2');
INSERT INTO `ccommentitem` VALUES ('72', '29', '18152183560', '说点啥4');
INSERT INTO `ccommentitem` VALUES ('75', '24', '18152183560', '说点啥6');
INSERT INTO `ccommentitem` VALUES ('77', '29', '18152183560', '说点啥6');
INSERT INTO `ccommentitem` VALUES ('78', '29', '18152183560', '说点啥7');
INSERT INTO `ccommentitem` VALUES ('79', '31', '18152183560', '说点啥');
INSERT INTO `ccommentitem` VALUES ('80', '28', '18152183560', '说点啥v但是VS是');
INSERT INTO `ccommentitem` VALUES ('81', '32', '18152183560', '说点啥gbr');
INSERT INTO `ccommentitem` VALUES ('82', '33', '18152183560', '说点啥h yh y');
INSERT INTO `ccommentitem` VALUES ('83', '39', '18152183560', '说点啥 vfv');

-- ----------------------------
-- Table structure for `cdynamic`
-- ----------------------------
DROP TABLE IF EXISTS `cdynamic`;
CREATE TABLE `cdynamic` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone` varchar(255) DEFAULT NULL,
  `text` text,
  `type` int(11) DEFAULT NULL,
  `browse` int(11) DEFAULT NULL,
  `pettypeid` int(11) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `releasetime` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of cdynamic
-- ----------------------------
INSERT INTO `cdynamic` VALUES ('3', '18152183560', '111', '1', '0', '3', '', '2020/7/3');
INSERT INTO `cdynamic` VALUES ('4', '18152183560', '2', '0', '5', '3', '', '2020/7/4');
INSERT INTO `cdynamic` VALUES ('5', '18152183560', '22', '0', '1', '3', '', '2020/7/5');
INSERT INTO `cdynamic` VALUES ('6', '18152183560', '222', '0', '1', '3', '', '2020/7/6');
INSERT INTO `cdynamic` VALUES ('7', '18152183560', '3', '0', '2', '7', '', '2020/7/7');
INSERT INTO `cdynamic` VALUES ('8', '18152183560', '呱呱呱呱呱呱', '0', '4', '5', '', '2020/7/8');
INSERT INTO `cdynamic` VALUES ('9', '18152183560', '呱呱呱呱呱呱', '1', '20', '5', '北京市', '2020/7/9');
INSERT INTO `cdynamic` VALUES ('10', '18152183560', '[\'', '0', '15', '3', '', '2020/7/10');
INSERT INTO `cdynamic` VALUES ('11', '15193093423', '11', '1', '0', '2', '北京市', null);
INSERT INTO `cdynamic` VALUES ('12', '15193093423', '收藏', '1', '0', '1', '天津市', null);
INSERT INTO `cdynamic` VALUES ('13', '15193093423', '222', '1', '0', '2', '', null);
INSERT INTO `cdynamic` VALUES ('14', '15193093423', '222', '1', '0', '2', '', null);
INSERT INTO `cdynamic` VALUES ('15', '15193093423', '222', '1', '0', '2', '', null);
INSERT INTO `cdynamic` VALUES ('16', '15193093423', '222', '1', '0', '2', '', null);
INSERT INTO `cdynamic` VALUES ('17', '15193093423', '222', '1', '1', '2', '', null);
INSERT INTO `cdynamic` VALUES ('18', '15193093423', '222', '1', '0', '2', '', null);
INSERT INTO `cdynamic` VALUES ('19', '15193093423', '222', '1', '0', '2', '', null);
INSERT INTO `cdynamic` VALUES ('20', '15193093423', '222', '1', '0', '2', '', null);
INSERT INTO `cdynamic` VALUES ('21', '15193093423', '222', '1', '0', '2', '', null);
INSERT INTO `cdynamic` VALUES ('22', '15193093423', '222', '1', '0', '2', '', null);
INSERT INTO `cdynamic` VALUES ('23', '15193093423', '222', '1', '0', '2', '', null);
INSERT INTO `cdynamic` VALUES ('24', '15193093423', '猫1', '0', '0', '1', '', null);
INSERT INTO `cdynamic` VALUES ('25', '15193093423', '猫1', '0', '0', '1', '北京市', null);
INSERT INTO `cdynamic` VALUES ('26', '15193093423', '\n】=】】', '1', '1', '1', '', null);
INSERT INTO `cdynamic` VALUES ('27', '15193093423', '\n】=】】', '1', '0', '1', '', null);
INSERT INTO `cdynamic` VALUES ('28', '15193093423', '\n】=】】', '1', '0', '1', '', null);
INSERT INTO `cdynamic` VALUES ('29', '15193093423', '\n】=】】', '1', '0', '1', '', null);
INSERT INTO `cdynamic` VALUES ('30', '15193093423', '\n】=】】', '1', '0', '1', '', null);
INSERT INTO `cdynamic` VALUES ('31', '15193093423', '\n】=】】', '1', '0', '1', '', null);
INSERT INTO `cdynamic` VALUES ('32', '15193093423', '\n】=】】', '1', '0', '1', '', null);
INSERT INTO `cdynamic` VALUES ('33', '15193093423', '\n】=】】', '1', '0', '1', '', null);
INSERT INTO `cdynamic` VALUES ('34', '15193093423', '\n】=】】', '1', '0', '1', '', null);
INSERT INTO `cdynamic` VALUES ('35', '15193093423', '\n】=】】', '1', '1', '1', '', null);
INSERT INTO `cdynamic` VALUES ('36', '15193093423', '\n】=】】', '1', '1', '1', '', null);
INSERT INTO `cdynamic` VALUES ('37', '15193093423', '\n】=】】', '1', '0', '1', '', null);
INSERT INTO `cdynamic` VALUES ('38', '15193093423', '1111', '1', '18', '2', '', null);
INSERT INTO `cdynamic` VALUES ('39', '18152183560', '777252', '0', '3', '3', '秦皇岛市', null);
INSERT INTO `cdynamic` VALUES ('40', '18152183560', '视频', '1', '0', '2', '天津市', null);
INSERT INTO `cdynamic` VALUES ('41', '18152183560', 'test视频', '1', '7', '1', '', null);
INSERT INTO `cdynamic` VALUES ('42', '18152183560', '1222时间', '1', '11', '2', '', '2020/07/07');
INSERT INTO `cdynamic` VALUES ('44', '18152183560', '常州1', '1', '30', '1', '常州市', '2020/07/07');
INSERT INTO `cdynamic` VALUES ('46', '18152183560', '6', '0', '60', '6', '', '2020/07/07');
INSERT INTO `cdynamic` VALUES ('48', '18152183560', 'rrg:joy::joy::joy::rolling_on_the_floor_laughing::rolling_on_the_floor_laughing::grin::grin::heart::heart:', '1', '16', '1', '天津市', '2020/10/09');
INSERT INTO `cdynamic` VALUES ('49', '18152183560', 'swxx:rolling_on_the_floor_laughing::joy::joy::joy:', '1', '2', '3', '北京市', '2020/10/22');
INSERT INTO `cdynamic` VALUES ('50', '18152183560', '吧v会不会', '0', '0', '3', '北京市', '2020/10/22');
INSERT INTO `cdynamic` VALUES ('51', '18152183560', '、\n525252572', '1', '0', '3', '天津市', '2020/10/31');
INSERT INTO `cdynamic` VALUES ('52', '18152183560', '多次出入', '1', '1', '2', '天津市', '2020/10/31');
INSERT INTO `cdynamic` VALUES ('53', '18152183560', '1', '1', '0', '3', '北京市', '2020/10/31');
INSERT INTO `cdynamic` VALUES ('54', '18152183560', '丰富', '0', '1', '6', '北京市', '2020/11/06');

-- ----------------------------
-- Table structure for `cequipment`
-- ----------------------------
DROP TABLE IF EXISTS `cequipment`;
CREATE TABLE `cequipment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cequipment
-- ----------------------------
INSERT INTO `cequipment` VALUES ('1', ' 小尚', '18152183560', '1');
INSERT INTO `cequipment` VALUES ('2', '小胡', '18152183560', '1');
INSERT INTO `cequipment` VALUES ('3', '小朱', '18152183560', '2');
INSERT INTO `cequipment` VALUES ('4', '小汤', '18152183560', '2');
INSERT INTO `cequipment` VALUES ('5', '小张', '18152183560', '1');
INSERT INTO `cequipment` VALUES ('6', '小王', '18152183560', '1');

-- ----------------------------
-- Table structure for `cfabulous`
-- ----------------------------
DROP TABLE IF EXISTS `cfabulous`;
CREATE TABLE `cfabulous` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) DEFAULT NULL,
  `user` varchar(255) DEFAULT NULL,
  `eid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of cfabulous
-- ----------------------------
INSERT INTO `cfabulous` VALUES ('79', '1', '18152183560', '10');
INSERT INTO `cfabulous` VALUES ('81', '2', '18152183560', '25');
INSERT INTO `cfabulous` VALUES ('82', '1', '18152183560', '7');
INSERT INTO `cfabulous` VALUES ('83', '1', '18152183560', '41');
INSERT INTO `cfabulous` VALUES ('84', '1', '18152183560', '42');
INSERT INTO `cfabulous` VALUES ('85', '1', '18152183560', '46');
INSERT INTO `cfabulous` VALUES ('86', '1', '18152183560', '44');
INSERT INTO `cfabulous` VALUES ('87', '2', '18152183560', '28');
INSERT INTO `cfabulous` VALUES ('88', '2', '18152183560', '29');
INSERT INTO `cfabulous` VALUES ('89', '2', '18152183560', '30');
INSERT INTO `cfabulous` VALUES ('102', '3', '18152183560', '1');
INSERT INTO `cfabulous` VALUES ('103', '3', '18152183560', '2');
INSERT INTO `cfabulous` VALUES ('104', '2', '18152183560', '32');
INSERT INTO `cfabulous` VALUES ('106', '2', '18152183560', '34');
INSERT INTO `cfabulous` VALUES ('107', '1', '18152183560', '48');
INSERT INTO `cfabulous` VALUES ('108', '2', '18152183560', '36');

-- ----------------------------
-- Table structure for `cmsg`
-- ----------------------------
DROP TABLE IF EXISTS `cmsg`;
CREATE TABLE `cmsg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fromUserId` varchar(255) DEFAULT NULL,
  `toUserId` varchar(255) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `contentText` text,
  `time` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cmsg
-- ----------------------------
INSERT INTO `cmsg` VALUES ('44', '18152183560', '20', '2', '', '2020-07-25 15:51:35');
INSERT INTO `cmsg` VALUES ('45', '18152183560', '20', '1', '', '2020-07-25 15:51:41');
INSERT INTO `cmsg` VALUES ('46', '18152183560', '20', '0', '你好', '2020-07-25 15:51:47');
INSERT INTO `cmsg` VALUES ('47', '18152183560', '20', '1', '', '2020-07-25 15:52:44');
INSERT INTO `cmsg` VALUES ('48', '18152183560', '20', '0', '你好世界', '2020-07-25 15:57:01');
INSERT INTO `cmsg` VALUES ('49', '18152183560', '20', '0', '你好世界', '2020-07-25 15:57:04');
INSERT INTO `cmsg` VALUES ('50', '18152183560', '20', '0', '你好世界', '2020-07-25 15:57:04');
INSERT INTO `cmsg` VALUES ('51', '18152183560', '20', '0', '2', '2020-07-25 15:57:52');
INSERT INTO `cmsg` VALUES ('52', '20', '18152183560', '0', '1', '2020-07-25 15:59:48');
INSERT INTO `cmsg` VALUES ('53', '20', '18152183560', '0', '12', '2020-07-25 15:59:50');
INSERT INTO `cmsg` VALUES ('54', '20', '18152183560', '0', '123', '2020-07-25 15:59:51');
INSERT INTO `cmsg` VALUES ('55', '20', '18152183560', '0', '1234', '2020-07-25 15:59:54');
INSERT INTO `cmsg` VALUES ('56', '20', '18152183560', '2', '', '2020-07-25 16:01:28');
INSERT INTO `cmsg` VALUES ('57', '20', '18152183560', '1', '', '2020-07-25 16:01:35');
INSERT INTO `cmsg` VALUES ('58', '20', '18152183560', '0', '12345', '2020-07-25 16:07:13');
INSERT INTO `cmsg` VALUES ('59', '18152183560', '20', '0', '哈哈哈', '2020-07-25 16:10:17');
INSERT INTO `cmsg` VALUES ('60', '18152183560', '20', '0', '哈哈哈', '2020-07-25 16:10:28');
INSERT INTO `cmsg` VALUES ('61', '18152183560', '20', '0', '哈哈哈', '2020-07-25 16:15:53');
INSERT INTO `cmsg` VALUES ('62', '18152183560', '20', '0', '1', '2020-07-25 16:19:34');
INSERT INTO `cmsg` VALUES ('63', '20', '20', '0', '111', '2020-07-25 16:44:24');
INSERT INTO `cmsg` VALUES ('64', '20', '20', '0', '1111', '2020-07-25 16:44:35');
INSERT INTO `cmsg` VALUES ('65', '20', '20', '0', '12', '2020-07-25 16:44:57');
INSERT INTO `cmsg` VALUES ('66', '20', '20', '0', '22', '2020-07-25 16:45:42');
INSERT INTO `cmsg` VALUES ('67', '18152183560', '20', '0', '222', '2020-07-25 16:46:01');
INSERT INTO `cmsg` VALUES ('68', '18152183560', '20', '0', '', '2020-07-25 16:47:35');
INSERT INTO `cmsg` VALUES ('69', '18152183560', '20', '0', '525', '2020-07-25 16:47:38');
INSERT INTO `cmsg` VALUES ('70', '18152183560', '20', '0', '141', '2020-07-25 16:49:27');
INSERT INTO `cmsg` VALUES ('71', '20', '20', '0', '7471', '2020-07-25 16:49:34');
INSERT INTO `cmsg` VALUES ('72', '20', '20', '0', '7471', '2020-07-25 16:50:45');
INSERT INTO `cmsg` VALUES ('73', '20', '18152183560', '0', '2152', '2020-07-25 16:52:59');
INSERT INTO `cmsg` VALUES ('74', '20', '18152183560', '0', '5', '2020-07-25 16:54:18');
INSERT INTO `cmsg` VALUES ('75', '20', '18152183560', '0', '6', '2020-07-25 16:54:35');
INSERT INTO `cmsg` VALUES ('76', '20', '18152183560', '0', '6', '2020-07-25 16:55:59');
INSERT INTO `cmsg` VALUES ('77', '20', '18152183560', '0', '7', '2020-07-25 16:56:07');
INSERT INTO `cmsg` VALUES ('78', '20', '18152183560', '2', '', '2020-07-25 16:56:31');
INSERT INTO `cmsg` VALUES ('79', '20', '18152183560', '1', '', '2020-07-25 16:57:18');
INSERT INTO `cmsg` VALUES ('80', '20', '18152183560', '0', '7', '2020-07-25 16:59:31');
INSERT INTO `cmsg` VALUES ('81', '20', '18152183560', '0', '828', '2020-07-25 17:02:15');
INSERT INTO `cmsg` VALUES ('82', '20', '18152183560', '2', '', '2020-07-25 17:02:39');
INSERT INTO `cmsg` VALUES ('83', '18152183560', '20', '0', '7417', '2020-07-25 17:03:06');
INSERT INTO `cmsg` VALUES ('84', '18152183560', '20', '2', '', '2020-07-25 17:05:25');
INSERT INTO `cmsg` VALUES ('85', '18152183560', '20', '2', '', '2020-07-25 17:08:57');
INSERT INTO `cmsg` VALUES ('86', '18152183560', '20', '2', '', '2020-07-25 17:11:18');
INSERT INTO `cmsg` VALUES ('87', '20', '18152183560', '0', '55', '2020-07-25 17:12:07');
INSERT INTO `cmsg` VALUES ('88', '20', '18152183560', '0', '55', '2020-07-25 17:12:56');
INSERT INTO `cmsg` VALUES ('89', '20', '18152183560', '0', '55', '2020-07-25 17:13:10');
INSERT INTO `cmsg` VALUES ('90', '18152183560', '20', '0', '222', '2020-07-25 17:13:38');
INSERT INTO `cmsg` VALUES ('91', '20', '18152183560', '2', '', '2020-07-25 17:13:50');
INSERT INTO `cmsg` VALUES ('92', '18152183560', '20', '0', '', '2020-10-06 08:23:00');
INSERT INTO `cmsg` VALUES ('93', '18152183560', '20', '0', '', '2020-10-06 08:23:02');
INSERT INTO `cmsg` VALUES ('94', '20', '18152183560', '0', 'vf ', '2020-10-16 16:20:11');
INSERT INTO `cmsg` VALUES ('95', '20', '18152183560', '0', 'vf ', '2020-10-16 16:20:18');
INSERT INTO `cmsg` VALUES ('96', '18152183560', '20', '0', '你好，请问商品有打折优惠活动吗', '2020-10-21 09:45:21');
INSERT INTO `cmsg` VALUES ('97', '18152183560', '20', '0', '你好，请问商品有打折优惠活动吗', '2020-10-21 09:45:24');
INSERT INTO `cmsg` VALUES ('98', '18152183560', '20', '0', '你好，请问商品有打折优惠活动吗', '2020-10-21 09:45:24');
INSERT INTO `cmsg` VALUES ('99', '18152183560', '20', '0', '你好，请问商品有打折优惠活动吗', '2020-10-21 09:45:24');
INSERT INTO `cmsg` VALUES ('100', '18152183560', '20', '0', '你好，请问商品有打折优惠活动吗', '2020-10-21 09:45:26');
INSERT INTO `cmsg` VALUES ('101', '18152183560', '20', '2', '', '2020-10-21 09:45:34');
INSERT INTO `cmsg` VALUES ('102', '18152183560', '20', '0', '我家的宝宝这个体型应该选择什么尺寸的衣服', '2020-10-21 09:46:29');
INSERT INTO `cmsg` VALUES ('103', '18152183560', '20', '1', '', '2020-10-21 09:46:38');
INSERT INTO `cmsg` VALUES ('104', '20', '18152183560', '0', '你好，XXXXXXXXXXXXXXXXXXXXXXXXXL的就可以的哦', '2020-10-21 09:54:20');
INSERT INTO `cmsg` VALUES ('105', '18152183560', '20', '0', 'fgre ', '2020-11-06 15:03:11');

-- ----------------------------
-- Table structure for `corder`
-- ----------------------------
DROP TABLE IF EXISTS `corder`;
CREATE TABLE `corder` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `address` int(11) DEFAULT NULL,
  `state` int(11) DEFAULT NULL,
  `user` varchar(255) DEFAULT NULL,
  `pay` varchar(255) DEFAULT NULL,
  `paynum` double(11,0) DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of corder
-- ----------------------------
INSERT INTO `corder` VALUES ('38', '0', '1', '18152183560', '微信', '157', '2020-07-22 10:40:42');
INSERT INTO `corder` VALUES ('39', '0', '1', '18152183560', '微信', '39', '2020-07-22 11:04:51');
INSERT INTO `corder` VALUES ('40', '0', '3', '18152183560', '微信', '39', '2020-07-22 11:05:03');
INSERT INTO `corder` VALUES ('41', '0', '3', '18152183560', '支付宝', '216', '2020-07-22 11:06:41');
INSERT INTO `corder` VALUES ('42', '2', '3', '18152183560', '银行卡', '92', '2020-07-22 11:07:13');
INSERT INTO `corder` VALUES ('44', '0', '3', '18152183560', '支付宝', '229', '2020-07-26 10:16:33');
INSERT INTO `corder` VALUES ('45', '0', '3', '18152183560', '支付宝', '148', '2020-07-26 10:17:06');
INSERT INTO `corder` VALUES ('46', '0', '2', '18152183560', '微信', '229', '2020-07-26 10:22:20');
INSERT INTO `corder` VALUES ('47', '0', '1', '18152183560', '微信', '39', '2020-08-03 16:55:57');
INSERT INTO `corder` VALUES ('48', '0', '1', '18152183560', '微信', '38', '2020-08-03 17:01:00');
INSERT INTO `corder` VALUES ('49', '0', '1', '18152183560', '银行卡', '0', '2020-08-03 17:05:15');
INSERT INTO `corder` VALUES ('50', '0', '1', '18152183560', '银行卡', '0', '2020-08-03 17:06:15');
INSERT INTO `corder` VALUES ('51', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:13:08');
INSERT INTO `corder` VALUES ('52', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:16:22');
INSERT INTO `corder` VALUES ('53', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:20:52');
INSERT INTO `corder` VALUES ('54', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:21:19');
INSERT INTO `corder` VALUES ('55', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:23:36');
INSERT INTO `corder` VALUES ('56', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:24:14');
INSERT INTO `corder` VALUES ('57', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:30:22');
INSERT INTO `corder` VALUES ('58', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:30:27');
INSERT INTO `corder` VALUES ('59', '0', '1', '18152183560', '银行卡', '0', '2020-08-03 17:30:58');
INSERT INTO `corder` VALUES ('60', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:31:01');
INSERT INTO `corder` VALUES ('61', '0', '1', '18152183560', '支付宝', '0', '2020-08-03 17:31:41');
INSERT INTO `corder` VALUES ('62', '0', '1', '18152183560', '支付宝', '0', '2020-08-03 17:31:42');
INSERT INTO `corder` VALUES ('63', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:32:02');
INSERT INTO `corder` VALUES ('64', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:32:12');
INSERT INTO `corder` VALUES ('65', '0', '1', '18152183560', '支付宝', '0', '2020-08-03 17:32:35');
INSERT INTO `corder` VALUES ('66', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:32:46');
INSERT INTO `corder` VALUES ('67', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:32:52');
INSERT INTO `corder` VALUES ('68', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:33:30');
INSERT INTO `corder` VALUES ('69', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:33:44');
INSERT INTO `corder` VALUES ('70', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:34:57');
INSERT INTO `corder` VALUES ('71', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:35:12');
INSERT INTO `corder` VALUES ('72', '0', '1', '18152183560', '支付宝', '0', '2020-08-03 17:39:28');
INSERT INTO `corder` VALUES ('73', '0', '1', '18152183560', '支付宝', '0', '2020-08-03 17:40:37');
INSERT INTO `corder` VALUES ('74', '0', '1', '18152183560', '支付宝', '0', '2020-08-03 17:41:20');
INSERT INTO `corder` VALUES ('75', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:41:45');
INSERT INTO `corder` VALUES ('76', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:42:54');
INSERT INTO `corder` VALUES ('77', '0', '1', '18152183560', '银行卡', '0', '2020-08-03 17:43:32');
INSERT INTO `corder` VALUES ('78', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:43:42');
INSERT INTO `corder` VALUES ('79', '0', '1', '18152183560', '银行卡', '0', '2020-08-03 17:45:51');
INSERT INTO `corder` VALUES ('80', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:46:21');
INSERT INTO `corder` VALUES ('81', '0', '1', '18152183560', '微信', '0', '2020-08-03 17:47:14');
INSERT INTO `corder` VALUES ('82', '0', '1', '18152183560', '微信', '58', '2020-08-03 17:49:56');
INSERT INTO `corder` VALUES ('83', '0', '1', '18152183560', '微信', '58', '2020-08-03 17:51:22');
INSERT INTO `corder` VALUES ('84', '0', '1', '18152183560', '微信', '58', '2020-08-03 17:51:52');
INSERT INTO `corder` VALUES ('85', '0', '1', '18152183560', '微信', '59', '2020-08-03 17:53:58');
INSERT INTO `corder` VALUES ('86', '0', '1', '18152183560', '微信', '58', '2020-08-03 17:54:35');
INSERT INTO `corder` VALUES ('87', '0', '1', '18152183560', '微信', '58', '2020-08-03 17:54:51');
INSERT INTO `corder` VALUES ('88', '0', '1', '18152183560', '微信', '58', '2020-08-03 17:56:13');
INSERT INTO `corder` VALUES ('89', '0', '1', '18152183560', '支付宝', '58', '2020-08-03 17:56:21');
INSERT INTO `corder` VALUES ('90', '0', '1', '18152183560', '微信', '59', '2020-08-03 17:57:17');
INSERT INTO `corder` VALUES ('91', '0', '1', '18152183560', '微信', '59', '2020-08-03 17:57:19');
INSERT INTO `corder` VALUES ('92', '0', '1', '18152183560', '微信', '59', '2020-08-03 17:57:24');
INSERT INTO `corder` VALUES ('93', '0', '1', '18152183560', '微信', '58', '2020-08-03 17:57:30');
INSERT INTO `corder` VALUES ('94', '0', '1', '18152183560', '微信', '58', '2020-08-03 17:58:01');
INSERT INTO `corder` VALUES ('95', '0', '1', '18152183560', '微信', '58', '2020-08-03 17:58:07');
INSERT INTO `corder` VALUES ('96', '0', '1', '18152183560', '微信', '58', '2020-08-03 17:58:30');
INSERT INTO `corder` VALUES ('97', '0', '1', '18152183560', '支付宝', '59', '2020-08-03 17:58:37');
INSERT INTO `corder` VALUES ('98', '0', '1', '18152183560', '微信', '59', '2020-08-03 17:58:44');
INSERT INTO `corder` VALUES ('99', '0', '1', '18152183560', '微信', '59', '2020-08-03 18:01:05');
INSERT INTO `corder` VALUES ('100', '0', '1', '18152183560', '微信', '59', '2020-08-03 18:05:12');
INSERT INTO `corder` VALUES ('101', '0', '1', '18152183560', '支付宝', '176', '2020-08-03 18:10:43');
INSERT INTO `corder` VALUES ('102', '0', '1', '18152183560', '微信', '117', '2020-08-03 18:13:44');
INSERT INTO `corder` VALUES ('103', '0', '1', '18152183560', '支付宝', '176', '2020-08-03 18:16:14');
INSERT INTO `corder` VALUES ('104', '0', '1', '18152183560', '微信', '176', '2020-08-03 18:17:16');
INSERT INTO `corder` VALUES ('105', '0', '1', '18152183560', '微信', '59', '2020-08-03 18:17:54');
INSERT INTO `corder` VALUES ('106', '0', '1', '18152183560', '微信', '59', '2020-08-03 18:19:37');
INSERT INTO `corder` VALUES ('107', '0', '1', '18152183560', '微信', '58', '2020-08-03 18:20:32');
INSERT INTO `corder` VALUES ('108', '2', '1', '18152183560', '微信', '58', '2020-08-03 18:23:47');
INSERT INTO `corder` VALUES ('109', '2', '1', '18152183560', '微信', '58', '2020-08-03 18:23:59');
INSERT INTO `corder` VALUES ('110', '0', '1', '18152183560', '微信', '59', '2020-08-03 18:24:08');
INSERT INTO `corder` VALUES ('111', '0', '1', '18152183560', '微信', '226', '2020-08-04 10:55:19');
INSERT INTO `corder` VALUES ('112', '0', '1', '18152183560', '微信', '476', '2020-08-04 11:49:53');
INSERT INTO `corder` VALUES ('113', '0', '1', '18152183560', '微信', '0', '2020-08-04 11:50:22');
INSERT INTO `corder` VALUES ('114', '0', '1', '18152183560', '微信', '0', '2020-08-04 12:06:20');
INSERT INTO `corder` VALUES ('115', '0', '1', '18152183560', '银行卡', '267', '2020-08-04 12:07:22');
INSERT INTO `corder` VALUES ('116', '0', '1', '18152183560', '微信', '18', '2020-08-04 12:08:36');
INSERT INTO `corder` VALUES ('117', '0', '1', '18152183560', '支付宝', '0', '2020-08-04 12:10:34');
INSERT INTO `corder` VALUES ('118', '0', '1', '18152183560', '支付宝', '77', '2020-08-04 12:12:20');
INSERT INTO `corder` VALUES ('119', '0', '1', '18152183560', '微信', '136', '2020-08-04 12:16:02');
INSERT INTO `corder` VALUES ('120', '0', '1', '18152183560', '微信', '77', '2020-08-04 12:30:11');
INSERT INTO `corder` VALUES ('121', '0', '1', '18152183560', '微信', '116', '2020-08-04 12:30:33');
INSERT INTO `corder` VALUES ('122', '0', '1', '18152183560', '微信', '58', '2020-08-04 12:31:09');
INSERT INTO `corder` VALUES ('123', '0', '1', '18152183560', '微信', '195', '2020-08-04 12:32:08');
INSERT INTO `corder` VALUES ('124', '0', '1', '18152183560', '微信', '18', '2020-08-04 13:14:40');
INSERT INTO `corder` VALUES ('125', '0', '1', '18152183560', '支付宝', '77', '2020-08-04 13:17:35');
INSERT INTO `corder` VALUES ('126', '0', '1', '18152183560', '微信', '59', '2020-08-04 13:18:49');
INSERT INTO `corder` VALUES ('127', '2', '1', '18152183560', '支付宝', '0', '2020-10-06 08:22:40');
INSERT INTO `corder` VALUES ('128', '0', '1', '18152183560', '支付宝', '0', '2020-10-09 10:08:21');
INSERT INTO `corder` VALUES ('129', '0', '1', '18152183560', '支付宝', '177', '2020-10-09 10:25:18');
INSERT INTO `corder` VALUES ('130', '0', '1', '18152183560', '微信', '0', '2020-10-17 15:46:41');
INSERT INTO `corder` VALUES ('132', '3', '1', '18152183560', '微信', '0', '2020-10-22 15:28:46');
INSERT INTO `corder` VALUES ('133', '0', '1', '18152183560', '微信', '132', '2020-10-22 15:29:19');
INSERT INTO `corder` VALUES ('134', '0', '1', '18152183560', '支付宝', '132', '2020-11-06 14:58:49');

-- ----------------------------
-- Table structure for `corderitem`
-- ----------------------------
DROP TABLE IF EXISTS `corderitem`;
CREATE TABLE `corderitem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shopid` int(11) DEFAULT NULL,
  `choicesid` int(11) DEFAULT NULL,
  `orderid` int(11) DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=248 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of corderitem
-- ----------------------------
INSERT INTO `corderitem` VALUES ('113', '1', '1', '38', '1');
INSERT INTO `corderitem` VALUES ('114', '1', '1', '38', '1');
INSERT INTO `corderitem` VALUES ('115', '1', '1', '38', '1');
INSERT INTO `corderitem` VALUES ('116', '1', '1', '39', '1');
INSERT INTO `corderitem` VALUES ('117', '1', '1', '40', '1');
INSERT INTO `corderitem` VALUES ('118', '1', '1', '41', '1');
INSERT INTO `corderitem` VALUES ('119', '1', '1', '41', '1');
INSERT INTO `corderitem` VALUES ('120', '1', '1', '41', '1');
INSERT INTO `corderitem` VALUES ('121', '1', '1', '41', '1');
INSERT INTO `corderitem` VALUES ('122', '1', '2', '42', '2');
INSERT INTO `corderitem` VALUES ('123', '1', '1', '43', '4');
INSERT INTO `corderitem` VALUES ('124', '1', '1', '43', '3');
INSERT INTO `corderitem` VALUES ('125', '1', '1', '43', '2');
INSERT INTO `corderitem` VALUES ('126', '1', '1', '43', '4');
INSERT INTO `corderitem` VALUES ('127', '2', '4', '44', '1');
INSERT INTO `corderitem` VALUES ('128', '3', '5', '45', '1');
INSERT INTO `corderitem` VALUES ('129', '2', '4', '46', '1');
INSERT INTO `corderitem` VALUES ('130', '1', '1', '47', '1');
INSERT INTO `corderitem` VALUES ('131', '1', '1', '48', '1');
INSERT INTO `corderitem` VALUES ('132', '1', '1', '49', '1');
INSERT INTO `corderitem` VALUES ('133', '1', '1', '50', '1');
INSERT INTO `corderitem` VALUES ('134', '1', '1', '51', '1');
INSERT INTO `corderitem` VALUES ('135', '1', '1', '52', '1');
INSERT INTO `corderitem` VALUES ('136', '1', '1', '53', '1');
INSERT INTO `corderitem` VALUES ('137', '1', '1', '54', '1');
INSERT INTO `corderitem` VALUES ('138', '1', '1', '55', '1');
INSERT INTO `corderitem` VALUES ('139', '1', '1', '56', '1');
INSERT INTO `corderitem` VALUES ('140', '1', '1', '57', '1');
INSERT INTO `corderitem` VALUES ('141', '1', '1', '58', '1');
INSERT INTO `corderitem` VALUES ('142', '1', '1', '59', '1');
INSERT INTO `corderitem` VALUES ('143', '1', '1', '60', '1');
INSERT INTO `corderitem` VALUES ('144', '1', '1', '61', '1');
INSERT INTO `corderitem` VALUES ('145', '1', '1', '62', '1');
INSERT INTO `corderitem` VALUES ('146', '1', '1', '63', '1');
INSERT INTO `corderitem` VALUES ('147', '1', '1', '64', '1');
INSERT INTO `corderitem` VALUES ('148', '1', '1', '65', '1');
INSERT INTO `corderitem` VALUES ('149', '1', '1', '66', '1');
INSERT INTO `corderitem` VALUES ('150', '1', '1', '67', '1');
INSERT INTO `corderitem` VALUES ('151', '1', '1', '68', '1');
INSERT INTO `corderitem` VALUES ('152', '1', '1', '69', '1');
INSERT INTO `corderitem` VALUES ('153', '1', '1', '70', '1');
INSERT INTO `corderitem` VALUES ('154', '1', '1', '71', '1');
INSERT INTO `corderitem` VALUES ('155', '1', '1', '72', '1');
INSERT INTO `corderitem` VALUES ('156', '1', '1', '73', '1');
INSERT INTO `corderitem` VALUES ('157', '1', '1', '74', '1');
INSERT INTO `corderitem` VALUES ('158', '1', '1', '75', '1');
INSERT INTO `corderitem` VALUES ('159', '1', '1', '76', '1');
INSERT INTO `corderitem` VALUES ('160', '1', '1', '77', '1');
INSERT INTO `corderitem` VALUES ('161', '1', '1', '78', '1');
INSERT INTO `corderitem` VALUES ('162', '1', '1', '79', '1');
INSERT INTO `corderitem` VALUES ('163', '1', '1', '80', '1');
INSERT INTO `corderitem` VALUES ('164', '1', '1', '81', '1');
INSERT INTO `corderitem` VALUES ('165', '1', '1', '82', '1');
INSERT INTO `corderitem` VALUES ('166', '1', '1', '83', '1');
INSERT INTO `corderitem` VALUES ('167', '1', '1', '84', '1');
INSERT INTO `corderitem` VALUES ('168', '1', '1', '85', '1');
INSERT INTO `corderitem` VALUES ('169', '1', '1', '86', '1');
INSERT INTO `corderitem` VALUES ('170', '1', '1', '87', '1');
INSERT INTO `corderitem` VALUES ('171', '1', '1', '88', '1');
INSERT INTO `corderitem` VALUES ('172', '1', '1', '89', '1');
INSERT INTO `corderitem` VALUES ('173', '1', '1', '90', '1');
INSERT INTO `corderitem` VALUES ('174', '1', '1', '91', '1');
INSERT INTO `corderitem` VALUES ('175', '1', '1', '92', '1');
INSERT INTO `corderitem` VALUES ('176', '1', '1', '93', '1');
INSERT INTO `corderitem` VALUES ('177', '1', '1', '94', '1');
INSERT INTO `corderitem` VALUES ('178', '1', '1', '95', '1');
INSERT INTO `corderitem` VALUES ('179', '1', '1', '96', '1');
INSERT INTO `corderitem` VALUES ('180', '1', '1', '97', '1');
INSERT INTO `corderitem` VALUES ('181', '1', '1', '98', '1');
INSERT INTO `corderitem` VALUES ('182', '1', '1', '99', '1');
INSERT INTO `corderitem` VALUES ('183', '1', '1', '100', '1');
INSERT INTO `corderitem` VALUES ('184', '1', '1', '101', '1');
INSERT INTO `corderitem` VALUES ('185', '1', '1', '101', '1');
INSERT INTO `corderitem` VALUES ('186', '1', '1', '101', '1');
INSERT INTO `corderitem` VALUES ('187', '1', '1', '102', '1');
INSERT INTO `corderitem` VALUES ('188', '1', '1', '102', '1');
INSERT INTO `corderitem` VALUES ('189', '1', '1', '103', '1');
INSERT INTO `corderitem` VALUES ('190', '1', '1', '103', '1');
INSERT INTO `corderitem` VALUES ('191', '1', '1', '103', '1');
INSERT INTO `corderitem` VALUES ('192', '1', '1', '104', '1');
INSERT INTO `corderitem` VALUES ('193', '1', '1', '104', '1');
INSERT INTO `corderitem` VALUES ('194', '1', '1', '104', '1');
INSERT INTO `corderitem` VALUES ('195', '1', '1', '105', '1');
INSERT INTO `corderitem` VALUES ('196', '1', '1', '106', '1');
INSERT INTO `corderitem` VALUES ('197', '1', '1', '107', '1');
INSERT INTO `corderitem` VALUES ('198', '1', '1', '108', '1');
INSERT INTO `corderitem` VALUES ('199', '1', '1', '109', '1');
INSERT INTO `corderitem` VALUES ('200', '1', '1', '110', '1');
INSERT INTO `corderitem` VALUES ('201', '1', '1', '111', '1');
INSERT INTO `corderitem` VALUES ('202', '1', '1', '111', '1');
INSERT INTO `corderitem` VALUES ('203', '1', '1', '111', '1');
INSERT INTO `corderitem` VALUES ('204', '1', '1', '111', '1');
INSERT INTO `corderitem` VALUES ('205', '1', '1', '112', '1');
INSERT INTO `corderitem` VALUES ('206', '3', '5', '112', '1');
INSERT INTO `corderitem` VALUES ('207', '2', '4', '112', '1');
INSERT INTO `corderitem` VALUES ('208', '3', '5', '113', '1');
INSERT INTO `corderitem` VALUES ('209', '1', '1', '114', '1');
INSERT INTO `corderitem` VALUES ('210', '2', '4', '115', '1');
INSERT INTO `corderitem` VALUES ('211', '1', '1', '115', '1');
INSERT INTO `corderitem` VALUES ('212', '1', '1', '116', '1');
INSERT INTO `corderitem` VALUES ('213', '1', '1', '116', '1');
INSERT INTO `corderitem` VALUES ('214', '1', '1', '117', '1');
INSERT INTO `corderitem` VALUES ('215', '1', '1', '118', '1');
INSERT INTO `corderitem` VALUES ('216', '1', '1', '118', '1');
INSERT INTO `corderitem` VALUES ('217', '1', '1', '119', '1');
INSERT INTO `corderitem` VALUES ('218', '1', '1', '119', '1');
INSERT INTO `corderitem` VALUES ('219', '1', '1', '119', '1');
INSERT INTO `corderitem` VALUES ('220', '1', '1', '119', '1');
INSERT INTO `corderitem` VALUES ('221', '1', '1', '120', '1');
INSERT INTO `corderitem` VALUES ('222', '1', '1', '120', '1');
INSERT INTO `corderitem` VALUES ('223', '1', '1', '120', '1');
INSERT INTO `corderitem` VALUES ('224', '1', '1', '121', '1');
INSERT INTO `corderitem` VALUES ('225', '1', '1', '121', '1');
INSERT INTO `corderitem` VALUES ('226', '1', '1', '122', '1');
INSERT INTO `corderitem` VALUES ('227', '1', '1', '123', '1');
INSERT INTO `corderitem` VALUES ('228', '1', '1', '123', '1');
INSERT INTO `corderitem` VALUES ('229', '1', '1', '123', '1');
INSERT INTO `corderitem` VALUES ('230', '1', '1', '123', '1');
INSERT INTO `corderitem` VALUES ('231', '1', '1', '123', '1');
INSERT INTO `corderitem` VALUES ('232', '1', '1', '124', '1');
INSERT INTO `corderitem` VALUES ('233', '1', '1', '124', '1');
INSERT INTO `corderitem` VALUES ('234', '1', '1', '125', '1');
INSERT INTO `corderitem` VALUES ('235', '1', '1', '125', '1');
INSERT INTO `corderitem` VALUES ('236', '1', '1', '125', '1');
INSERT INTO `corderitem` VALUES ('237', '1', '1', '126', '1');
INSERT INTO `corderitem` VALUES ('238', '1', '1', '127', '1');
INSERT INTO `corderitem` VALUES ('239', '1', '1', '128', '1');
INSERT INTO `corderitem` VALUES ('240', '1', '1', '129', '1');
INSERT INTO `corderitem` VALUES ('241', '1', '1', '129', '1');
INSERT INTO `corderitem` VALUES ('242', '1', '1', '129', '1');
INSERT INTO `corderitem` VALUES ('243', '1', '1', '130', '1');
INSERT INTO `corderitem` VALUES ('244', '1', '1', '131', '1');
INSERT INTO `corderitem` VALUES ('245', '1', '3', '132', '2');
INSERT INTO `corderitem` VALUES ('246', '1', '3', '133', '2');
INSERT INTO `corderitem` VALUES ('247', '1', '2', '134', '2');

-- ----------------------------
-- Table structure for `cpettype`
-- ----------------------------
DROP TABLE IF EXISTS `cpettype`;
CREATE TABLE `cpettype` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of cpettype
-- ----------------------------
INSERT INTO `cpettype` VALUES ('1', '猫类');
INSERT INTO `cpettype` VALUES ('2', '犬类');
INSERT INTO `cpettype` VALUES ('3', '鱼类');
INSERT INTO `cpettype` VALUES ('4', '鸟类');
INSERT INTO `cpettype` VALUES ('5', '昆虫类');
INSERT INTO `cpettype` VALUES ('6', '鼠类');
INSERT INTO `cpettype` VALUES ('7', '兔类');
INSERT INTO `cpettype` VALUES ('8', '其他');

-- ----------------------------
-- Table structure for `crecord`
-- ----------------------------
DROP TABLE IF EXISTS `crecord`;
CREATE TABLE `crecord` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timestamp` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `text` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of crecord
-- ----------------------------
INSERT INTO `crecord` VALUES ('2', '2020-8-29 17:47', '2', '18152183560', '2');
INSERT INTO `crecord` VALUES ('3', '2020-8-29 17:47', '3', '18152183560', '2');
INSERT INTO `crecord` VALUES ('4', '2020-8-29 17:47', '3', '18152183560', '3');
INSERT INTO `crecord` VALUES ('5', '2020-8-29 17:52', '标题', '18152183560', '在代码阅读过程中人们说脏话的频率是衡量代码质量的唯一标准。');
INSERT INTO `crecord` VALUES ('7', '2020-8-30 9:59', '你好', '18152183560', '今天是个好日子');
INSERT INTO `crecord` VALUES ('8', '2020-8-31 10:17', '时间测试', '18152183560', '时间测试3');
INSERT INTO `crecord` VALUES ('9', '2020-8-31 10:17', '时间测试', '8', '时间测试2');
INSERT INTO `crecord` VALUES ('10', '2020-8-31 10:17', '时间测试2', '8', '时间测试');
INSERT INTO `crecord` VALUES ('11', '2020-8-31 10:17', '时间测试2', '8', '时间测试');
INSERT INTO `crecord` VALUES ('12', '2020-8-31 10:17', '时间测试', '8', '时间测试');
INSERT INTO `crecord` VALUES ('13', '2020-8-31 10:17', '时间测试', '8', '时间测试');
INSERT INTO `crecord` VALUES ('14', '2020-8-31 10:17', '时间测试2', '8', '时间测试');
INSERT INTO `crecord` VALUES ('15', '2020-8-31 10:17', '时间测试', '8', '时间测试');
INSERT INTO `crecord` VALUES ('17', '2020-1-30 11:10', '1', '18152183560', '1');
INSERT INTO `crecord` VALUES ('18', '2021-1-30 11:10', '222', '18152183560', '1');
INSERT INTO `crecord` VALUES ('19', '2020-10-23 10:12', '555', '18152183560', '5555555555');

-- ----------------------------
-- Table structure for `cshop`
-- ----------------------------
DROP TABLE IF EXISTS `cshop`;
CREATE TABLE `cshop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `cold` double DEFAULT NULL,
  `cnew` double DEFAULT NULL,
  `text` varchar(255) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `highlights` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cshop
-- ----------------------------
INSERT INTO `cshop` VALUES ('1', '狗粮', '69', '59', '买1送1 好主人狗粮通用型泰迪比熊博美柯基大小型犬幼犬成犬共8斤', '2', '【买一送一】全犬种通用型 全营养配方');
INSERT INTO `cshop` VALUES ('2', '狗粮', '260', '290', '麦富迪狗粮中大型成犬通用20斤装金毛拉布拉多阿拉斯加鱼萃粮10kg', '2', null);
INSERT INTO `cshop` VALUES ('3', '狗粮', '268', '298', '力狼狗粮20kg公斤通用型金毛阿拉斯加拉布拉多边牧大型成犬40斤装', '2', '11年品质保障 累计热卖1500万袋');
INSERT INTO `cshop` VALUES ('4', '猫粮', '65', '59', '【10万好评】好主人猫粮成猫专用增肥发腮英短蓝猫10成年2.5kg5斤', '1', null);
INSERT INTO `cshop` VALUES ('5', '猫粮', '598', '509', '麦富迪弗列加特成猫粮增肥发腮英短蓝猫美短鸡肉鲜肉猫粮8kg^@^', '1', null);

-- ----------------------------
-- Table structure for `cshopcart`
-- ----------------------------
DROP TABLE IF EXISTS `cshopcart`;
CREATE TABLE `cshopcart` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eid` int(11) DEFAULT NULL,
  `user` varchar(255) DEFAULT NULL,
  `choice` int(11) DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cshopcart
-- ----------------------------

-- ----------------------------
-- Table structure for `cshopchoice`
-- ----------------------------
DROP TABLE IF EXISTS `cshopchoice`;
CREATE TABLE `cshopchoice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eid` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `price` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cshopchoice
-- ----------------------------
INSERT INTO `cshopchoice` VALUES ('1', '1', '【买一送一 共8斤】', '59');
INSERT INTO `cshopchoice` VALUES ('2', '1', '【买一送一 共6斤】泰迪专用', '66');
INSERT INTO `cshopchoice` VALUES ('3', '1', '【买一送一 共6斤】比熊专用', '66');
INSERT INTO `cshopchoice` VALUES ('4', '2', '中大型犬10kg', '249');
INSERT INTO `cshopchoice` VALUES ('5', '3', '成犬专用20斤', '168');
INSERT INTO `cshopchoice` VALUES ('6', '3', '成犬专用5kg', '68');
INSERT INTO `cshopchoice` VALUES ('7', '4', '幼猫粮5kg', '69');
INSERT INTO `cshopchoice` VALUES ('8', '4', '成猫粮5kg五斤', '69.9');
INSERT INTO `cshopchoice` VALUES ('9', '4', '【王炸】幼猫套餐', '258');
INSERT INTO `cshopchoice` VALUES ('10', '5', '鸡肉味', '509');

-- ----------------------------
-- Table structure for `cshopevaluate`
-- ----------------------------
DROP TABLE IF EXISTS `cshopevaluate`;
CREATE TABLE `cshopevaluate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(255) DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  `fraction` int(11) DEFAULT NULL,
  `text` varchar(255) DEFAULT NULL,
  `eid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cshopevaluate
-- ----------------------------
INSERT INTO `cshopevaluate` VALUES ('21', '18152183560', '2020-07-23 10:49:58', '3', '，李12388', '1');
INSERT INTO `cshopevaluate` VALUES ('22', '18152183560', '2020-07-23 10:50:10', '3', '，李12388', '1');
INSERT INTO `cshopevaluate` VALUES ('23', '18152183560', '2020-07-23 15:43:14', '3', '=', '42');
INSERT INTO `cshopevaluate` VALUES ('24', '18152183560', '2020-07-23 15:48:46', '3', '\n585', '41');
INSERT INTO `cshopevaluate` VALUES ('25', '18152183560', '2020-07-26 09:39:44', '3', '', '40');
INSERT INTO `cshopevaluate` VALUES ('26', '18152183560', '2020-07-26 10:16:44', '3', '222', '44');
INSERT INTO `cshopevaluate` VALUES ('27', '18152183560', '2020-07-26 10:17:23', '3', '5', '45');
INSERT INTO `cshopevaluate` VALUES ('28', '18152183560', '2020-07-26 10:24:59', '3', '141252', '2');

-- ----------------------------
-- Table structure for `csports`
-- ----------------------------
DROP TABLE IF EXISTS `csports`;
CREATE TABLE `csports` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eid` int(11) DEFAULT NULL,
  `y` int(11) DEFAULT NULL,
  `m` int(11) DEFAULT NULL,
  `d` int(11) DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=373 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of csports
-- ----------------------------
INSERT INTO `csports` VALUES ('1', '1', '2020', '8', '1', '4587');
INSERT INTO `csports` VALUES ('2', '1', '2020', '8', '2', '4679');
INSERT INTO `csports` VALUES ('3', '1', '2020', '8', '3', '2544');
INSERT INTO `csports` VALUES ('4', '1', '2020', '8', '4', '1475');
INSERT INTO `csports` VALUES ('5', '1', '2020', '8', '5', '3925');
INSERT INTO `csports` VALUES ('6', '1', '2020', '8', '6', '4506');
INSERT INTO `csports` VALUES ('7', '1', '2020', '8', '7', '4418');
INSERT INTO `csports` VALUES ('8', '1', '2020', '8', '8', '3850');
INSERT INTO `csports` VALUES ('9', '1', '2020', '8', '9', '3001');
INSERT INTO `csports` VALUES ('11', '1', '2020', '8', '11', '1441');
INSERT INTO `csports` VALUES ('12', '1', '2020', '8', '12', '4667');
INSERT INTO `csports` VALUES ('13', '1', '2020', '8', '13', '4261');
INSERT INTO `csports` VALUES ('14', '1', '2020', '8', '14', '3391');
INSERT INTO `csports` VALUES ('15', '1', '2020', '8', '15', '2826');
INSERT INTO `csports` VALUES ('16', '1', '2020', '8', '16', '4827');
INSERT INTO `csports` VALUES ('17', '1', '2020', '8', '17', '3157');
INSERT INTO `csports` VALUES ('18', '1', '2020', '8', '18', '3300');
INSERT INTO `csports` VALUES ('19', '1', '2020', '8', '19', '1681');
INSERT INTO `csports` VALUES ('20', '1', '2020', '8', '20', '1237');
INSERT INTO `csports` VALUES ('21', '1', '2020', '8', '21', '2255');
INSERT INTO `csports` VALUES ('22', '1', '2020', '8', '22', '2897');
INSERT INTO `csports` VALUES ('23', '1', '2020', '8', '23', '3526');
INSERT INTO `csports` VALUES ('24', '1', '2020', '8', '24', '1550');
INSERT INTO `csports` VALUES ('25', '1', '2020', '8', '25', '1058');
INSERT INTO `csports` VALUES ('26', '1', '2020', '8', '26', '2716');
INSERT INTO `csports` VALUES ('27', '1', '2020', '8', '27', '4762');
INSERT INTO `csports` VALUES ('28', '1', '2020', '8', '28', '4680');
INSERT INTO `csports` VALUES ('29', '1', '2020', '8', '29', '3263');
INSERT INTO `csports` VALUES ('30', '1', '2020', '8', '30', '1346');
INSERT INTO `csports` VALUES ('31', '1', '2020', '8', '31', '1107');
INSERT INTO `csports` VALUES ('32', '1', '2020', '7', '1', '2020');
INSERT INTO `csports` VALUES ('33', '1', '2020', '7', '2', '3367');
INSERT INTO `csports` VALUES ('34', '1', '2020', '7', '3', '3058');
INSERT INTO `csports` VALUES ('35', '1', '2020', '7', '4', '3415');
INSERT INTO `csports` VALUES ('36', '1', '2020', '7', '5', '4870');
INSERT INTO `csports` VALUES ('37', '1', '2020', '7', '6', '2556');
INSERT INTO `csports` VALUES ('38', '1', '2020', '7', '7', '4134');
INSERT INTO `csports` VALUES ('39', '1', '2020', '7', '8', '4318');
INSERT INTO `csports` VALUES ('40', '1', '2020', '7', '9', '4152');
INSERT INTO `csports` VALUES ('41', '1', '2020', '7', '10', '4479');
INSERT INTO `csports` VALUES ('42', '1', '2020', '7', '11', '2299');
INSERT INTO `csports` VALUES ('43', '1', '2020', '7', '12', '2924');
INSERT INTO `csports` VALUES ('44', '1', '2020', '7', '13', '3392');
INSERT INTO `csports` VALUES ('45', '1', '2020', '7', '14', '1543');
INSERT INTO `csports` VALUES ('46', '1', '2020', '7', '15', '3214');
INSERT INTO `csports` VALUES ('47', '1', '2020', '7', '16', '4192');
INSERT INTO `csports` VALUES ('48', '1', '2020', '7', '17', '1171');
INSERT INTO `csports` VALUES ('49', '1', '2020', '7', '18', '3680');
INSERT INTO `csports` VALUES ('50', '1', '2020', '7', '19', '4409');
INSERT INTO `csports` VALUES ('51', '1', '2020', '7', '20', '4605');
INSERT INTO `csports` VALUES ('52', '1', '2020', '7', '21', '2351');
INSERT INTO `csports` VALUES ('53', '1', '2020', '7', '22', '1339');
INSERT INTO `csports` VALUES ('54', '1', '2020', '7', '23', '1598');
INSERT INTO `csports` VALUES ('55', '1', '2020', '7', '24', '1810');
INSERT INTO `csports` VALUES ('56', '1', '2020', '7', '25', '2225');
INSERT INTO `csports` VALUES ('57', '1', '2020', '7', '26', '1870');
INSERT INTO `csports` VALUES ('58', '1', '2020', '7', '27', '3854');
INSERT INTO `csports` VALUES ('59', '1', '2020', '7', '28', '2295');
INSERT INTO `csports` VALUES ('60', '1', '2020', '7', '29', '4443');
INSERT INTO `csports` VALUES ('61', '1', '2020', '7', '30', '4886');
INSERT INTO `csports` VALUES ('62', '1', '2020', '7', '31', '3728');
INSERT INTO `csports` VALUES ('63', '2', '2020', '7', '1', '2956');
INSERT INTO `csports` VALUES ('64', '2', '2020', '7', '2', '2482');
INSERT INTO `csports` VALUES ('65', '2', '2020', '7', '3', '2939');
INSERT INTO `csports` VALUES ('66', '2', '2020', '7', '4', '4332');
INSERT INTO `csports` VALUES ('67', '2', '2020', '7', '5', '4925');
INSERT INTO `csports` VALUES ('68', '2', '2020', '7', '6', '2801');
INSERT INTO `csports` VALUES ('69', '2', '2020', '7', '7', '4280');
INSERT INTO `csports` VALUES ('70', '2', '2020', '7', '8', '3201');
INSERT INTO `csports` VALUES ('71', '2', '2020', '7', '9', '2891');
INSERT INTO `csports` VALUES ('72', '2', '2020', '7', '10', '3873');
INSERT INTO `csports` VALUES ('73', '2', '2020', '7', '11', '4060');
INSERT INTO `csports` VALUES ('74', '2', '2020', '7', '12', '2700');
INSERT INTO `csports` VALUES ('75', '2', '2020', '7', '13', '4926');
INSERT INTO `csports` VALUES ('76', '2', '2020', '7', '14', '2909');
INSERT INTO `csports` VALUES ('77', '2', '2020', '7', '15', '3984');
INSERT INTO `csports` VALUES ('78', '2', '2020', '7', '16', '1337');
INSERT INTO `csports` VALUES ('79', '2', '2020', '7', '17', '2655');
INSERT INTO `csports` VALUES ('80', '2', '2020', '7', '18', '3236');
INSERT INTO `csports` VALUES ('81', '2', '2020', '7', '19', '3703');
INSERT INTO `csports` VALUES ('82', '2', '2020', '7', '20', '3502');
INSERT INTO `csports` VALUES ('83', '2', '2020', '7', '21', '4865');
INSERT INTO `csports` VALUES ('84', '2', '2020', '7', '22', '3685');
INSERT INTO `csports` VALUES ('85', '2', '2020', '7', '23', '3876');
INSERT INTO `csports` VALUES ('86', '2', '2020', '7', '24', '3652');
INSERT INTO `csports` VALUES ('87', '2', '2020', '7', '25', '3638');
INSERT INTO `csports` VALUES ('88', '2', '2020', '7', '26', '3212');
INSERT INTO `csports` VALUES ('89', '2', '2020', '7', '27', '1066');
INSERT INTO `csports` VALUES ('90', '2', '2020', '7', '28', '4898');
INSERT INTO `csports` VALUES ('91', '2', '2020', '7', '29', '3975');
INSERT INTO `csports` VALUES ('92', '2', '2020', '7', '30', '3391');
INSERT INTO `csports` VALUES ('93', '2', '2020', '7', '31', '3662');
INSERT INTO `csports` VALUES ('94', '3', '2020', '7', '1', '2426');
INSERT INTO `csports` VALUES ('95', '3', '2020', '7', '2', '3638');
INSERT INTO `csports` VALUES ('96', '3', '2020', '7', '3', '3597');
INSERT INTO `csports` VALUES ('97', '3', '2020', '7', '4', '4861');
INSERT INTO `csports` VALUES ('98', '3', '2020', '7', '5', '3951');
INSERT INTO `csports` VALUES ('99', '3', '2020', '7', '6', '4800');
INSERT INTO `csports` VALUES ('100', '3', '2020', '7', '7', '3957');
INSERT INTO `csports` VALUES ('101', '3', '2020', '7', '8', '4669');
INSERT INTO `csports` VALUES ('102', '3', '2020', '7', '9', '3233');
INSERT INTO `csports` VALUES ('103', '3', '2020', '7', '10', '1139');
INSERT INTO `csports` VALUES ('104', '3', '2020', '7', '11', '3583');
INSERT INTO `csports` VALUES ('105', '3', '2020', '7', '12', '1951');
INSERT INTO `csports` VALUES ('106', '3', '2020', '7', '13', '4658');
INSERT INTO `csports` VALUES ('107', '3', '2020', '7', '14', '1071');
INSERT INTO `csports` VALUES ('108', '3', '2020', '7', '15', '2118');
INSERT INTO `csports` VALUES ('109', '3', '2020', '7', '16', '3752');
INSERT INTO `csports` VALUES ('110', '3', '2020', '7', '17', '4985');
INSERT INTO `csports` VALUES ('111', '3', '2020', '7', '18', '4148');
INSERT INTO `csports` VALUES ('112', '3', '2020', '7', '19', '1293');
INSERT INTO `csports` VALUES ('113', '3', '2020', '7', '20', '2429');
INSERT INTO `csports` VALUES ('114', '3', '2020', '7', '21', '4583');
INSERT INTO `csports` VALUES ('115', '3', '2020', '7', '22', '2968');
INSERT INTO `csports` VALUES ('116', '3', '2020', '7', '23', '3982');
INSERT INTO `csports` VALUES ('117', '3', '2020', '7', '24', '3575');
INSERT INTO `csports` VALUES ('118', '3', '2020', '7', '25', '4832');
INSERT INTO `csports` VALUES ('119', '3', '2020', '7', '26', '1476');
INSERT INTO `csports` VALUES ('120', '3', '2020', '7', '27', '1140');
INSERT INTO `csports` VALUES ('121', '3', '2020', '7', '28', '1271');
INSERT INTO `csports` VALUES ('122', '3', '2020', '7', '29', '2832');
INSERT INTO `csports` VALUES ('123', '3', '2020', '7', '30', '2155');
INSERT INTO `csports` VALUES ('124', '3', '2020', '7', '31', '2058');
INSERT INTO `csports` VALUES ('125', '4', '2020', '7', '1', '3920');
INSERT INTO `csports` VALUES ('126', '4', '2020', '7', '2', '3161');
INSERT INTO `csports` VALUES ('127', '4', '2020', '7', '3', '3368');
INSERT INTO `csports` VALUES ('128', '4', '2020', '7', '4', '4522');
INSERT INTO `csports` VALUES ('129', '4', '2020', '7', '5', '1705');
INSERT INTO `csports` VALUES ('130', '4', '2020', '7', '6', '1151');
INSERT INTO `csports` VALUES ('131', '4', '2020', '7', '7', '3971');
INSERT INTO `csports` VALUES ('132', '4', '2020', '7', '8', '2746');
INSERT INTO `csports` VALUES ('133', '4', '2020', '7', '9', '3662');
INSERT INTO `csports` VALUES ('134', '4', '2020', '7', '10', '4985');
INSERT INTO `csports` VALUES ('135', '4', '2020', '7', '11', '3357');
INSERT INTO `csports` VALUES ('136', '4', '2020', '7', '12', '4363');
INSERT INTO `csports` VALUES ('137', '4', '2020', '7', '13', '2450');
INSERT INTO `csports` VALUES ('138', '4', '2020', '7', '14', '2915');
INSERT INTO `csports` VALUES ('139', '4', '2020', '7', '15', '3170');
INSERT INTO `csports` VALUES ('140', '4', '2020', '7', '16', '1304');
INSERT INTO `csports` VALUES ('141', '4', '2020', '7', '17', '4044');
INSERT INTO `csports` VALUES ('142', '4', '2020', '7', '18', '2966');
INSERT INTO `csports` VALUES ('143', '4', '2020', '7', '19', '2240');
INSERT INTO `csports` VALUES ('144', '4', '2020', '7', '20', '1020');
INSERT INTO `csports` VALUES ('145', '4', '2020', '7', '21', '3945');
INSERT INTO `csports` VALUES ('146', '4', '2020', '7', '22', '3755');
INSERT INTO `csports` VALUES ('147', '4', '2020', '7', '23', '4609');
INSERT INTO `csports` VALUES ('148', '4', '2020', '7', '24', '2330');
INSERT INTO `csports` VALUES ('149', '4', '2020', '7', '25', '4900');
INSERT INTO `csports` VALUES ('150', '4', '2020', '7', '26', '4349');
INSERT INTO `csports` VALUES ('151', '4', '2020', '7', '27', '4072');
INSERT INTO `csports` VALUES ('152', '4', '2020', '7', '28', '2070');
INSERT INTO `csports` VALUES ('153', '4', '2020', '7', '29', '1722');
INSERT INTO `csports` VALUES ('154', '4', '2020', '7', '30', '4616');
INSERT INTO `csports` VALUES ('155', '4', '2020', '7', '31', '3262');
INSERT INTO `csports` VALUES ('156', '5', '2020', '7', '1', '4736');
INSERT INTO `csports` VALUES ('157', '5', '2020', '7', '2', '2468');
INSERT INTO `csports` VALUES ('158', '5', '2020', '7', '3', '1071');
INSERT INTO `csports` VALUES ('159', '5', '2020', '7', '4', '3053');
INSERT INTO `csports` VALUES ('160', '5', '2020', '7', '5', '1503');
INSERT INTO `csports` VALUES ('161', '5', '2020', '7', '6', '4065');
INSERT INTO `csports` VALUES ('162', '5', '2020', '7', '7', '2983');
INSERT INTO `csports` VALUES ('163', '5', '2020', '7', '8', '2963');
INSERT INTO `csports` VALUES ('164', '5', '2020', '7', '9', '3272');
INSERT INTO `csports` VALUES ('165', '5', '2020', '7', '10', '2421');
INSERT INTO `csports` VALUES ('166', '5', '2020', '7', '11', '3312');
INSERT INTO `csports` VALUES ('167', '5', '2020', '7', '12', '1216');
INSERT INTO `csports` VALUES ('168', '5', '2020', '7', '13', '2811');
INSERT INTO `csports` VALUES ('169', '5', '2020', '7', '14', '4084');
INSERT INTO `csports` VALUES ('170', '5', '2020', '7', '15', '3068');
INSERT INTO `csports` VALUES ('171', '5', '2020', '7', '16', '2258');
INSERT INTO `csports` VALUES ('172', '5', '2020', '7', '17', '3581');
INSERT INTO `csports` VALUES ('173', '5', '2020', '7', '18', '2776');
INSERT INTO `csports` VALUES ('174', '5', '2020', '7', '19', '1742');
INSERT INTO `csports` VALUES ('175', '5', '2020', '7', '20', '1795');
INSERT INTO `csports` VALUES ('176', '5', '2020', '7', '21', '3519');
INSERT INTO `csports` VALUES ('177', '5', '2020', '7', '22', '1357');
INSERT INTO `csports` VALUES ('178', '5', '2020', '7', '23', '2696');
INSERT INTO `csports` VALUES ('179', '5', '2020', '7', '24', '4760');
INSERT INTO `csports` VALUES ('180', '5', '2020', '7', '25', '4819');
INSERT INTO `csports` VALUES ('181', '5', '2020', '7', '26', '2302');
INSERT INTO `csports` VALUES ('182', '5', '2020', '7', '27', '4752');
INSERT INTO `csports` VALUES ('183', '5', '2020', '7', '28', '4169');
INSERT INTO `csports` VALUES ('184', '5', '2020', '7', '29', '3655');
INSERT INTO `csports` VALUES ('185', '5', '2020', '7', '30', '1271');
INSERT INTO `csports` VALUES ('186', '5', '2020', '7', '31', '3682');
INSERT INTO `csports` VALUES ('187', '6', '2020', '7', '1', '4405');
INSERT INTO `csports` VALUES ('188', '6', '2020', '7', '2', '4857');
INSERT INTO `csports` VALUES ('189', '6', '2020', '7', '3', '3082');
INSERT INTO `csports` VALUES ('190', '6', '2020', '7', '4', '1910');
INSERT INTO `csports` VALUES ('191', '6', '2020', '7', '5', '3271');
INSERT INTO `csports` VALUES ('192', '6', '2020', '7', '6', '1674');
INSERT INTO `csports` VALUES ('193', '6', '2020', '7', '7', '1212');
INSERT INTO `csports` VALUES ('194', '6', '2020', '7', '8', '1446');
INSERT INTO `csports` VALUES ('195', '6', '2020', '7', '9', '4988');
INSERT INTO `csports` VALUES ('196', '6', '2020', '7', '10', '4065');
INSERT INTO `csports` VALUES ('197', '6', '2020', '7', '11', '4863');
INSERT INTO `csports` VALUES ('198', '6', '2020', '7', '12', '1929');
INSERT INTO `csports` VALUES ('199', '6', '2020', '7', '13', '1352');
INSERT INTO `csports` VALUES ('200', '6', '2020', '7', '14', '2368');
INSERT INTO `csports` VALUES ('201', '6', '2020', '7', '15', '1738');
INSERT INTO `csports` VALUES ('202', '6', '2020', '7', '16', '2637');
INSERT INTO `csports` VALUES ('203', '6', '2020', '7', '17', '2375');
INSERT INTO `csports` VALUES ('204', '6', '2020', '7', '18', '4715');
INSERT INTO `csports` VALUES ('205', '6', '2020', '7', '19', '1833');
INSERT INTO `csports` VALUES ('206', '6', '2020', '7', '20', '2391');
INSERT INTO `csports` VALUES ('207', '6', '2020', '7', '21', '4990');
INSERT INTO `csports` VALUES ('208', '6', '2020', '7', '22', '2255');
INSERT INTO `csports` VALUES ('209', '6', '2020', '7', '23', '1873');
INSERT INTO `csports` VALUES ('210', '6', '2020', '7', '24', '4539');
INSERT INTO `csports` VALUES ('211', '6', '2020', '7', '25', '2786');
INSERT INTO `csports` VALUES ('212', '6', '2020', '7', '26', '3993');
INSERT INTO `csports` VALUES ('213', '6', '2020', '7', '27', '1475');
INSERT INTO `csports` VALUES ('214', '6', '2020', '7', '28', '1519');
INSERT INTO `csports` VALUES ('215', '6', '2020', '7', '29', '1240');
INSERT INTO `csports` VALUES ('216', '6', '2020', '7', '30', '2983');
INSERT INTO `csports` VALUES ('217', '6', '2020', '7', '31', '2671');
INSERT INTO `csports` VALUES ('218', '6', '2020', '8', '1', '1357');
INSERT INTO `csports` VALUES ('219', '6', '2020', '8', '2', '3746');
INSERT INTO `csports` VALUES ('220', '6', '2020', '8', '3', '1986');
INSERT INTO `csports` VALUES ('221', '6', '2020', '8', '4', '1588');
INSERT INTO `csports` VALUES ('222', '6', '2020', '8', '5', '4544');
INSERT INTO `csports` VALUES ('223', '6', '2020', '8', '6', '3573');
INSERT INTO `csports` VALUES ('224', '6', '2020', '8', '7', '3921');
INSERT INTO `csports` VALUES ('225', '6', '2020', '8', '8', '4072');
INSERT INTO `csports` VALUES ('226', '6', '2020', '8', '9', '1621');
INSERT INTO `csports` VALUES ('227', '6', '2020', '8', '10', '3843');
INSERT INTO `csports` VALUES ('228', '6', '2020', '8', '11', '1374');
INSERT INTO `csports` VALUES ('229', '6', '2020', '8', '12', '2791');
INSERT INTO `csports` VALUES ('230', '6', '2020', '8', '13', '1386');
INSERT INTO `csports` VALUES ('231', '6', '2020', '8', '14', '1803');
INSERT INTO `csports` VALUES ('232', '6', '2020', '8', '15', '2101');
INSERT INTO `csports` VALUES ('233', '6', '2020', '8', '16', '1104');
INSERT INTO `csports` VALUES ('234', '6', '2020', '8', '17', '1795');
INSERT INTO `csports` VALUES ('235', '6', '2020', '8', '18', '1372');
INSERT INTO `csports` VALUES ('236', '6', '2020', '8', '19', '3944');
INSERT INTO `csports` VALUES ('237', '6', '2020', '8', '20', '2812');
INSERT INTO `csports` VALUES ('238', '6', '2020', '8', '21', '4340');
INSERT INTO `csports` VALUES ('239', '6', '2020', '8', '22', '1873');
INSERT INTO `csports` VALUES ('240', '6', '2020', '8', '23', '4870');
INSERT INTO `csports` VALUES ('241', '6', '2020', '8', '24', '4994');
INSERT INTO `csports` VALUES ('242', '6', '2020', '8', '25', '2040');
INSERT INTO `csports` VALUES ('243', '6', '2020', '8', '26', '1050');
INSERT INTO `csports` VALUES ('244', '6', '2020', '8', '27', '3338');
INSERT INTO `csports` VALUES ('245', '6', '2020', '8', '28', '2974');
INSERT INTO `csports` VALUES ('246', '6', '2020', '8', '29', '1831');
INSERT INTO `csports` VALUES ('247', '6', '2020', '8', '30', '1793');
INSERT INTO `csports` VALUES ('248', '6', '2020', '8', '31', '1760');
INSERT INTO `csports` VALUES ('249', '5', '2020', '8', '1', '1123');
INSERT INTO `csports` VALUES ('250', '5', '2020', '8', '2', '4855');
INSERT INTO `csports` VALUES ('251', '5', '2020', '8', '3', '4525');
INSERT INTO `csports` VALUES ('252', '5', '2020', '8', '4', '2551');
INSERT INTO `csports` VALUES ('253', '5', '2020', '8', '5', '4310');
INSERT INTO `csports` VALUES ('254', '5', '2020', '8', '6', '3946');
INSERT INTO `csports` VALUES ('255', '5', '2020', '8', '7', '2005');
INSERT INTO `csports` VALUES ('256', '5', '2020', '8', '8', '2153');
INSERT INTO `csports` VALUES ('257', '5', '2020', '8', '9', '2147');
INSERT INTO `csports` VALUES ('258', '5', '2020', '8', '10', '2555');
INSERT INTO `csports` VALUES ('259', '5', '2020', '8', '11', '2080');
INSERT INTO `csports` VALUES ('260', '5', '2020', '8', '12', '3425');
INSERT INTO `csports` VALUES ('261', '5', '2020', '8', '13', '3548');
INSERT INTO `csports` VALUES ('262', '5', '2020', '8', '14', '1431');
INSERT INTO `csports` VALUES ('263', '5', '2020', '8', '15', '2937');
INSERT INTO `csports` VALUES ('264', '5', '2020', '8', '16', '4908');
INSERT INTO `csports` VALUES ('265', '5', '2020', '8', '17', '4667');
INSERT INTO `csports` VALUES ('266', '5', '2020', '8', '18', '2558');
INSERT INTO `csports` VALUES ('267', '5', '2020', '8', '19', '2481');
INSERT INTO `csports` VALUES ('268', '5', '2020', '8', '20', '2753');
INSERT INTO `csports` VALUES ('269', '5', '2020', '8', '21', '2965');
INSERT INTO `csports` VALUES ('270', '5', '2020', '8', '22', '4173');
INSERT INTO `csports` VALUES ('271', '5', '2020', '8', '23', '2703');
INSERT INTO `csports` VALUES ('272', '5', '2020', '8', '24', '1429');
INSERT INTO `csports` VALUES ('273', '5', '2020', '8', '25', '3890');
INSERT INTO `csports` VALUES ('274', '5', '2020', '8', '26', '2115');
INSERT INTO `csports` VALUES ('275', '5', '2020', '8', '27', '3229');
INSERT INTO `csports` VALUES ('276', '5', '2020', '8', '28', '4907');
INSERT INTO `csports` VALUES ('277', '5', '2020', '8', '29', '4621');
INSERT INTO `csports` VALUES ('278', '5', '2020', '8', '30', '3341');
INSERT INTO `csports` VALUES ('279', '5', '2020', '8', '31', '1733');
INSERT INTO `csports` VALUES ('280', '4', '2020', '8', '1', '2562');
INSERT INTO `csports` VALUES ('281', '4', '2020', '8', '2', '1315');
INSERT INTO `csports` VALUES ('282', '4', '2020', '8', '3', '1128');
INSERT INTO `csports` VALUES ('283', '4', '2020', '8', '4', '4491');
INSERT INTO `csports` VALUES ('284', '4', '2020', '8', '5', '1859');
INSERT INTO `csports` VALUES ('285', '4', '2020', '8', '6', '4490');
INSERT INTO `csports` VALUES ('286', '4', '2020', '8', '7', '2291');
INSERT INTO `csports` VALUES ('287', '4', '2020', '8', '8', '2065');
INSERT INTO `csports` VALUES ('288', '4', '2020', '8', '9', '4720');
INSERT INTO `csports` VALUES ('289', '4', '2020', '8', '10', '1441');
INSERT INTO `csports` VALUES ('290', '4', '2020', '8', '11', '2695');
INSERT INTO `csports` VALUES ('291', '4', '2020', '8', '12', '2966');
INSERT INTO `csports` VALUES ('292', '4', '2020', '8', '13', '4501');
INSERT INTO `csports` VALUES ('293', '4', '2020', '8', '14', '3005');
INSERT INTO `csports` VALUES ('294', '4', '2020', '8', '15', '2406');
INSERT INTO `csports` VALUES ('295', '4', '2020', '8', '16', '2106');
INSERT INTO `csports` VALUES ('296', '4', '2020', '8', '17', '3620');
INSERT INTO `csports` VALUES ('297', '4', '2020', '8', '18', '2524');
INSERT INTO `csports` VALUES ('298', '4', '2020', '8', '19', '4018');
INSERT INTO `csports` VALUES ('299', '4', '2020', '8', '20', '2962');
INSERT INTO `csports` VALUES ('300', '4', '2020', '8', '21', '2146');
INSERT INTO `csports` VALUES ('301', '4', '2020', '8', '22', '1524');
INSERT INTO `csports` VALUES ('302', '4', '2020', '8', '23', '2992');
INSERT INTO `csports` VALUES ('303', '4', '2020', '8', '24', '4586');
INSERT INTO `csports` VALUES ('304', '4', '2020', '8', '25', '1020');
INSERT INTO `csports` VALUES ('305', '4', '2020', '8', '26', '3389');
INSERT INTO `csports` VALUES ('306', '4', '2020', '8', '27', '1326');
INSERT INTO `csports` VALUES ('307', '4', '2020', '8', '28', '2938');
INSERT INTO `csports` VALUES ('308', '4', '2020', '8', '29', '4104');
INSERT INTO `csports` VALUES ('309', '4', '2020', '8', '30', '3251');
INSERT INTO `csports` VALUES ('310', '4', '2020', '8', '31', '3380');
INSERT INTO `csports` VALUES ('311', '3', '2020', '8', '1', '4509');
INSERT INTO `csports` VALUES ('312', '3', '2020', '8', '2', '2858');
INSERT INTO `csports` VALUES ('313', '3', '2020', '8', '3', '1328');
INSERT INTO `csports` VALUES ('314', '3', '2020', '8', '4', '1442');
INSERT INTO `csports` VALUES ('315', '3', '2020', '8', '5', '4786');
INSERT INTO `csports` VALUES ('316', '3', '2020', '8', '6', '2226');
INSERT INTO `csports` VALUES ('317', '3', '2020', '8', '7', '2108');
INSERT INTO `csports` VALUES ('318', '3', '2020', '8', '8', '4371');
INSERT INTO `csports` VALUES ('319', '3', '2020', '8', '9', '4832');
INSERT INTO `csports` VALUES ('320', '3', '2020', '8', '10', '4168');
INSERT INTO `csports` VALUES ('321', '3', '2020', '8', '11', '1079');
INSERT INTO `csports` VALUES ('322', '3', '2020', '8', '12', '1642');
INSERT INTO `csports` VALUES ('323', '3', '2020', '8', '13', '2114');
INSERT INTO `csports` VALUES ('324', '3', '2020', '8', '14', '2296');
INSERT INTO `csports` VALUES ('325', '3', '2020', '8', '15', '4081');
INSERT INTO `csports` VALUES ('326', '3', '2020', '8', '16', '3164');
INSERT INTO `csports` VALUES ('327', '3', '2020', '8', '17', '4667');
INSERT INTO `csports` VALUES ('328', '3', '2020', '8', '18', '1181');
INSERT INTO `csports` VALUES ('329', '3', '2020', '8', '19', '3924');
INSERT INTO `csports` VALUES ('330', '3', '2020', '8', '20', '4437');
INSERT INTO `csports` VALUES ('331', '3', '2020', '8', '21', '4799');
INSERT INTO `csports` VALUES ('332', '3', '2020', '8', '22', '1180');
INSERT INTO `csports` VALUES ('333', '3', '2020', '8', '23', '2564');
INSERT INTO `csports` VALUES ('334', '3', '2020', '8', '24', '4917');
INSERT INTO `csports` VALUES ('335', '3', '2020', '8', '25', '1749');
INSERT INTO `csports` VALUES ('336', '3', '2020', '8', '26', '3984');
INSERT INTO `csports` VALUES ('337', '3', '2020', '8', '27', '2900');
INSERT INTO `csports` VALUES ('338', '3', '2020', '8', '28', '2939');
INSERT INTO `csports` VALUES ('339', '3', '2020', '8', '29', '2069');
INSERT INTO `csports` VALUES ('340', '3', '2020', '8', '30', '3603');
INSERT INTO `csports` VALUES ('341', '3', '2020', '8', '31', '2200');
INSERT INTO `csports` VALUES ('342', '2', '2020', '8', '1', '3061');
INSERT INTO `csports` VALUES ('343', '2', '2020', '8', '2', '3956');
INSERT INTO `csports` VALUES ('344', '2', '2020', '8', '3', '4143');
INSERT INTO `csports` VALUES ('345', '2', '2020', '8', '4', '3155');
INSERT INTO `csports` VALUES ('346', '2', '2020', '8', '5', '1425');
INSERT INTO `csports` VALUES ('347', '2', '2020', '8', '6', '3390');
INSERT INTO `csports` VALUES ('348', '2', '2020', '8', '7', '1459');
INSERT INTO `csports` VALUES ('349', '2', '2020', '8', '8', '2754');
INSERT INTO `csports` VALUES ('350', '2', '2020', '8', '9', '1532');
INSERT INTO `csports` VALUES ('351', '2', '2020', '8', '10', '1621');
INSERT INTO `csports` VALUES ('352', '2', '2020', '8', '11', '4672');
INSERT INTO `csports` VALUES ('353', '2', '2020', '8', '12', '3456');
INSERT INTO `csports` VALUES ('354', '2', '2020', '8', '13', '4759');
INSERT INTO `csports` VALUES ('355', '2', '2020', '8', '14', '1412');
INSERT INTO `csports` VALUES ('356', '2', '2020', '8', '15', '3534');
INSERT INTO `csports` VALUES ('357', '2', '2020', '8', '16', '3511');
INSERT INTO `csports` VALUES ('358', '2', '2020', '8', '17', '1042');
INSERT INTO `csports` VALUES ('359', '2', '2020', '8', '18', '1431');
INSERT INTO `csports` VALUES ('360', '2', '2020', '8', '19', '4736');
INSERT INTO `csports` VALUES ('361', '2', '2020', '8', '20', '3871');
INSERT INTO `csports` VALUES ('362', '2', '2020', '8', '21', '3304');
INSERT INTO `csports` VALUES ('363', '2', '2020', '8', '22', '2249');
INSERT INTO `csports` VALUES ('364', '2', '2020', '8', '23', '4545');
INSERT INTO `csports` VALUES ('365', '2', '2020', '8', '24', '1739');
INSERT INTO `csports` VALUES ('366', '2', '2020', '8', '25', '4547');
INSERT INTO `csports` VALUES ('367', '2', '2020', '8', '26', '3658');
INSERT INTO `csports` VALUES ('368', '2', '2020', '8', '27', '4491');
INSERT INTO `csports` VALUES ('369', '2', '2020', '8', '28', '1632');
INSERT INTO `csports` VALUES ('370', '2', '2020', '8', '29', '4972');
INSERT INTO `csports` VALUES ('371', '2', '2020', '8', '30', '1352');
INSERT INTO `csports` VALUES ('372', '2', '2020', '8', '31', '3373');

-- ----------------------------
-- Table structure for `cuserpettype`
-- ----------------------------
DROP TABLE IF EXISTS `cuserpettype`;
CREATE TABLE `cuserpettype` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(255) DEFAULT NULL,
  `pettype` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of cuserpettype
-- ----------------------------
INSERT INTO `cuserpettype` VALUES ('1', '18152183560', '1');

-- ----------------------------
-- Table structure for `cusers`
-- ----------------------------
DROP TABLE IF EXISTS `cusers`;
CREATE TABLE `cusers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone` varchar(255) DEFAULT NULL,
  `pwd` varchar(255) DEFAULT NULL,
  `nickname` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `sex` int(255) DEFAULT NULL,
  `birthday` varchar(255) DEFAULT NULL,
  `introduce` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of cusers
-- ----------------------------
INSERT INTO `cusers` VALUES ('1', '18152183560', '123', '喵子1', '天津市', '1', '2000-11-03', '本平台作者。是一个品学兼优的好学生，擅长java，vue开发。');
INSERT INTO `cusers` VALUES ('2', '18796959415', '111', '喵子2', '常州市', '1', '1999-01-23', '平台测试号1');
INSERT INTO `cusers` VALUES ('3', '15193093423', '111', '喵子3', '白银市', '2', '1978-1-2', '平台测试号2');
INSERT INTO `cusers` VALUES ('4', '13884286359', '111', '喵子4', '白银市', '2', '1980-3-3', '平台测试号3');
INSERT INTO `cusers` VALUES ('10', '17368150311', '111', '1111', '丹东市', '1', '12-1-3', '1111');

-- ----------------------------
-- Table structure for `cyzm`
-- ----------------------------
DROP TABLE IF EXISTS `cyzm`;
CREATE TABLE `cyzm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) DEFAULT NULL,
  `yzm` int(11) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cyzm
-- ----------------------------
INSERT INTO `cyzm` VALUES ('1', '1', '5206', '18152183560', '2020-10-06 10:27:18');
INSERT INTO `cyzm` VALUES ('2', '1', '6200', '18152183560', '2020-10-06 11:06:56');
INSERT INTO `cyzm` VALUES ('3', '2', '2321', 'undefined', '2020-10-06 13:24:51');
INSERT INTO `cyzm` VALUES ('4', '2', '5932', '18152183560', '2020-10-06 13:30:38');
INSERT INTO `cyzm` VALUES ('5', '2', '4252', '17368150311', '2020-10-07 08:53:35');
INSERT INTO `cyzm` VALUES ('6', '1', '5514', '18152183560', '2020-10-07 10:59:28');
INSERT INTO `cyzm` VALUES ('7', '1', '3950', '18152183560', '2020-10-11 12:30:50');