wechat/mysql.sql

/*
Navicat MySQL Data Transfer

Source Server         : maria
Source Server Version : 100312
Source Host           : localhost:3306
Source Database       : wechat

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

Date: 2019-01-27 16:57:32
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for customer
-- ----------------------------
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
  `csr_id` varchar(20) NOT NULL COMMENT '用户id',
  `csr_name` varchar(255) NOT NULL DEFAULT '' COMMENT '用户姓名或昵称',
  `csr_phone` varchar(16) NOT NULL COMMENT '用户电话',
  `csr_gender` bit(1) NOT NULL COMMENT '用户性别',
  `csr_password` varchar(32) NOT NULL COMMENT '用户密码',
  `csr_old_phone` varchar(16) DEFAULT '' COMMENT '用户旧手机（换手机）',
  `csr_vcode` varchar(32) DEFAULT '' COMMENT '用户验证码（用于忘记密码）',
  `vcode_expiry_time` datetime DEFAULT NULL ON UPDATE current_timestamp() COMMENT '验证码有效时间',
  `enable` bit(1) DEFAULT b'0' COMMENT '启用禁用',
  `csr_gen_time` datetime DEFAULT NULL ON UPDATE current_timestamp(),
  PRIMARY KEY (`csr_id`),
  UNIQUE KEY `phone` (`csr_phone`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for reply
-- ----------------------------
DROP TABLE IF EXISTS `reply`;
CREATE TABLE `reply` (
  `type_id` varchar(20) NOT NULL COMMENT '分类id',
  `reply_name` varchar(255) NOT NULL COMMENT '回复名称',
  `reply_content` varchar(16) NOT NULL COMMENT '回复内容',
  `reply_gen_time` datetime DEFAULT NULL COMMENT '生成时间',
  PRIMARY KEY (`reply_name`,`type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for reply_type
-- ----------------------------
DROP TABLE IF EXISTS `reply_type`;
CREATE TABLE `reply_type` (
  `csr_id` varchar(20) NOT NULL COMMENT '用户id',
  `type_id` varchar(20) NOT NULL COMMENT '分类id',
  `type_name` varchar(255) NOT NULL COMMENT '分类名称',
  `type_gen_time` datetime DEFAULT NULL COMMENT '分类生成时间',
  PRIMARY KEY (`type_id`),
  UNIQUE KEY `cus_type` (`csr_id`,`type_name`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;