/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50528
Source Host           : localhost:3306
Source Database       : tea

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

Date: 2019-04-20 19:37:39
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `comment`
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `zuopin` varchar(255) DEFAULT NULL,
  `c_comment` varchar(255) DEFAULT NULL,
  `commenter` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of comment
-- ----------------------------
INSERT INTO `comment` VALUES ('3', '20190418171657.json', '456', '456');
INSERT INTO `comment` VALUES ('4', '20190418171657.json', '哈哈哈', '456');

-- ----------------------------
-- Table structure for `qianbao`
-- ----------------------------
DROP TABLE IF EXISTS `qianbao`;
CREATE TABLE `qianbao` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `money` int(255) DEFAULT NULL,
  `dashangzhe` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qianbao
-- ----------------------------
INSERT INTO `qianbao` VALUES ('1', '123', '5', '1');
INSERT INTO `qianbao` VALUES ('2', '1', '5', '123');
INSERT INTO `qianbao` VALUES ('3', '1', '1', '456');
INSERT INTO `qianbao` VALUES ('4', '456', '1', '1');
INSERT INTO `qianbao` VALUES ('5', '123', '2', '456');
INSERT INTO `qianbao` VALUES ('6', '456', '2', '123');
INSERT INTO `qianbao` VALUES ('7', '1', '1', '456');
INSERT INTO `qianbao` VALUES ('8', '456', '1', '1');
INSERT INTO `qianbao` VALUES ('9', '1', '1', '456');
INSERT INTO `qianbao` VALUES ('10', '456', '1', '1');
INSERT INTO `qianbao` VALUES ('11', '1', '10', '456');
INSERT INTO `qianbao` VALUES ('12', '456', '10', '1');

-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `identity` varchar(255) DEFAULT NULL COMMENT '1读者 2作者 3管理员',
  `qiandao` date DEFAULT NULL,
  `money` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('2', 'admin', 'admin', null, '3', '2019-02-11', '147');
INSERT INTO `user` VALUES ('3', '1', '1', null, '2', '2019-04-20', '58');
INSERT INTO `user` VALUES ('9', '456', '456', null, '1', '2019-04-20', '99');
INSERT INTO `user` VALUES ('11', '789', '789', null, '2', '2019-03-14', '5');

-- ----------------------------
-- Table structure for `zuopin`
-- ----------------------------
DROP TABLE IF EXISTS `zuopin`;
CREATE TABLE `zuopin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(225) DEFAULT NULL,
  `zuopingming` varchar(225) DEFAULT NULL,
  `zuopin` varchar(225) DEFAULT NULL,
  `entity` varchar(255) DEFAULT NULL COMMENT '1通过 2申请中 3驳回',
  `views` int(11) DEFAULT '0',
  `shangjia` varchar(255) DEFAULT '1' COMMENT '1为上架 2为下架',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zuopin
-- ----------------------------
INSERT INTO `zuopin` VALUES ('1', '1', '我的第2部小说', '20190418171657.json', '2', '0', '1');
INSERT INTO `zuopin` VALUES ('2', '1', '测试1', '20190417092114.json', '1', '0', '1');