messageApplet/serviceApi/applet.sql

/*
Navicat MySQL Data Transfer

Source Server         : applet
Source Server Version : 50727
Source Host           : 122.51.231.221:3306
Source Database       : applet

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

Date: 2019-12-25 11:09:14
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for article
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
  `no` int(11) NOT NULL AUTO_INCREMENT COMMENT '文章编号',
  `title` varchar(255) DEFAULT NULL COMMENT '文章标题',
  `describ` varchar(300) DEFAULT NULL COMMENT '文章描述',
  `imageTitle` varchar(100) DEFAULT NULL COMMENT '文章配图',
  `date` datetime DEFAULT NULL COMMENT '文章日期',
  `g_id` int(11) DEFAULT NULL COMMENT '公众号id',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of article
-- ----------------------------
INSERT INTO `article` VALUES ('1', '悲喜自渡', '生活中并没有哪一个是无忧无虑的。你只看到自己悲伤却未曾看到他人笑容背后的泪水。', 'https://applet.yull.top/static/wechat/upload/1577241131404.jpg', '2019-12-25 00:00:00', '4');
INSERT INTO `article` VALUES ('2', '生活小技巧', '夏天如何去除卫生间异味', 'https://applet.yull.top/static/wechat/upload/157724293888.png', '2019-12-25 00:00:00', '1');

-- ----------------------------
-- Table structure for gonginfo
-- ----------------------------
DROP TABLE IF EXISTS `gonginfo`;
CREATE TABLE `gonginfo` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT '公众号ID',
  `headpath` varchar(255) DEFAULT NULL COMMENT '公众号头像地址',
  `describes` varchar(255) DEFAULT NULL COMMENT '公众号描述',
  `password` varchar(255) DEFAULT NULL COMMENT '后台密码',
  `openid` varchar(255) DEFAULT NULL COMMENT '公众号主的openID唯一标识',
  `fromid` varchar(255) DEFAULT NULL COMMENT '模版ID',
  `token` varchar(255) DEFAULT NULL COMMENT 'token验证字段',
  `countinform` int(11) DEFAULT '0' COMMENT '留言通知计数',
  `check` enum('1','0') DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gonginfo
-- ----------------------------
INSERT INTO `gonginfo` VALUES ('1', '鱼啰啰', 'https://applet.yull.top/static/wechat/upload/1577237925544.png', '分享生活', '123456', 'oC_OQ4sg9oRNHQpTNdkMiSCWemOQ', null, null, '-1', '1');
INSERT INTO `gonginfo` VALUES ('4', '安东南吖', 'https://applet.yull.top/static/wechat/upload/1577240160497.jpg', '故人河畔，借花荀柳', 'hyh13179ing', 'oC_OQ4sKpXkpQJDhkPEcyMfLYNHg', null, null, '5', '1');

-- ----------------------------
-- Table structure for messages
-- ----------------------------
DROP TABLE IF EXISTS `messages`;
CREATE TABLE `messages` (
  `p_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 留言id',
  `title` varchar(200) DEFAULT NULL COMMENT '文章标题',
  `username` varchar(255) DEFAULT NULL COMMENT '用户名',
  `headimage` varchar(255) DEFAULT NULL COMMENT '用户头像',
  `userMesContent` varchar(255) DEFAULT NULL COMMENT '用户留言',
  `authorMesContent` varchar(255) DEFAULT '' COMMENT '作者回复',
  `no` int(11) DEFAULT NULL COMMENT '文章编号',
  `isCheck` enum('1','0') DEFAULT '0' COMMENT '是否精选',
  `isTop` enum('1','0') DEFAULT '0' COMMENT '是否置顶',
  `g_id` int(11) DEFAULT NULL COMMENT '公众号ID',
  `zanCounts` int(11) DEFAULT '0' COMMENT '点赞数量',
  `fromid` varchar(255) DEFAULT NULL COMMENT '模版ID',
  `token` varchar(255) DEFAULT NULL COMMENT 'token验证值',
  `openid` varchar(255) DEFAULT NULL,
  `create_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`p_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of messages
-- ----------------------------
INSERT INTO `messages` VALUES ('1', '悲喜自渡', '东祭、', 'https://wx.qlogo.cn/mmopen/vi_32/pVxaShmrVyollibL6qUZmEmuUuatMbeldmYmLUPGNALx8m8ef1ibIuavdbpqd58oAX9BCTDXyM1DEibszFJfK49jQ/132', '孤独', '', '1', '0', '0', '4', '0', null, null, 'oC_OQ4sKpXkpQJDhkPEcyMfLYNHg', null);
INSERT INTO `messages` VALUES ('2', '悲喜自渡', '鱼啰啰', 'https://wx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLI7ItkHYYp8bP4IZyKlibmMA8EajoCib0USAmLF7IBQYHKP70ZC8bA0oXH1xWjwZImjMVelMnnh8uQ/132', '顺其自然更好', '生活对我们已经够仁慈了', '1', '1', '0', '4', '0', null, null, 'oC_OQ4sg9oRNHQpTNdkMiSCWemOQ', null);
INSERT INTO `messages` VALUES ('3', '生活小技巧', '鱼啰啰', 'https://wx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLI7ItkHYYp8bP4IZyKlibmMA8EajoCib0USAmLF7IBQYHKP70ZC8bA0oXH1xWjwZImjMVelMnnh8uQ/132', '试了一下，这个技巧真的可以用', '能给你提供帮助很开心', '2', '1', '0', '1', '0', null, null, 'oC_OQ4sg9oRNHQpTNdkMiSCWemOQ', null);

-- ----------------------------
-- Table structure for zan
-- ----------------------------
DROP TABLE IF EXISTS `zan`;
CREATE TABLE `zan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `g_id` int(11) DEFAULT NULL COMMENT '公众号ID',
  `no` int(11) DEFAULT NULL COMMENT '文章编号',
  `p_id` int(11) DEFAULT NULL COMMENT '留言ID',
  `openid` varchar(200) DEFAULT NULL COMMENT '用户openid',
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pid-openid` (`p_id`,`openid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zan
-- ----------------------------