weixin_repair/wxkf.sql

/*
Navicat MySQL Data Transfer

Source Server         : 自己的阿里云
Source Server Version : 50557
Source Host           : 47.104.71.253:3306
Source Database       : wxkf

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

Date: 2019-04-23 10:44:44
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `username` varchar(50) NOT NULL DEFAULT '' COMMENT '用户名',
  `password` varchar(50) NOT NULL DEFAULT '' COMMENT '密码',
  `user_nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '昵称',
  `status` int(2) NOT NULL DEFAULT '0' COMMENT '当前账号的状态',
  `user_type` varchar(2) DEFAULT NULL,
  `create_time` varchar(30) DEFAULT NULL COMMENT '创建时间',
  `update_time` varchar(30) DEFAULT NULL COMMENT '更新时间',
  `code_time` varchar(40) DEFAULT '0' COMMENT '分享吗时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'admin', 'e10adc3949ba59abbe56e057f20f883e', '管理员', '0', '0', '1550738794', null, '12');

-- ----------------------------
-- Table structure for group
-- ----------------------------
DROP TABLE IF EXISTS `group`;
CREATE TABLE `group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `name` varchar(50) DEFAULT NULL COMMENT '分组的名称',
  `addtime` varchar(30) DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of group
-- ----------------------------
INSERT INTO `group` VALUES ('1', '第一小区', '1551149469');
INSERT INTO `group` VALUES ('2', '第二小区', '1551149469');
INSERT INTO `group` VALUES ('3', '第三小区', '1551149469');
INSERT INTO `group` VALUES ('4', '第四小区', '1551149469');
INSERT INTO `group` VALUES ('5', '第五小区', '1551149469');
INSERT INTO `group` VALUES ('6', '第六小区', '1551149469');
INSERT INTO `group` VALUES ('7', '第七小区', '1551149469');
INSERT INTO `group` VALUES ('8', '第八小区', '1551236529');

-- ----------------------------
-- Table structure for repair_order
-- ----------------------------
DROP TABLE IF EXISTS `repair_order`;
CREATE TABLE `repair_order` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `order_id` varchar(30) NOT NULL DEFAULT '' COMMENT '订单id',
  `type` varchar(100) DEFAULT NULL COMMENT '订单类别',
  `linkman` varchar(100) DEFAULT NULL COMMENT '联系人',
  `linktel` varchar(100) DEFAULT NULL COMMENT '联系电话',
  `repuser` varchar(100) DEFAULT NULL COMMENT '维修人',
  `status` int(2) NOT NULL DEFAULT '0' COMMENT '订单的状态(0接单中,1处理中，2完成)',
  `group` varchar(25) DEFAULT NULL COMMENT '小区信息',
  `address` varchar(100) DEFAULT NULL COMMENT '地址信息',
  `title` varchar(255) DEFAULT NULL COMMENT '问题的简单描述',
  `content` varchar(255) DEFAULT NULL COMMENT '问题的详细描述',
  `message` varchar(255) DEFAULT NULL COMMENT '备注',
  `grade` varchar(5) DEFAULT NULL COMMENT '订单的等级',
  `create_time` varchar(25) DEFAULT NULL COMMENT '订单创建时间',
  `update_time` varchar(25) DEFAULT NULL COMMENT '订单更新时间',
  `openid` varchar(100) NOT NULL DEFAULT '' COMMENT '提交订单的用户微信标识符',
  `repuser_message` varchar(255) DEFAULT NULL COMMENT '管理者对订单的评论',
  `linkman_message` varchar(255) DEFAULT NULL COMMENT '报修者对订单的评论',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of repair_order
-- ----------------------------
INSERT INTO `repair_order` VALUES ('1', '2019022252505556', '', '张惠奇', '15176628061', 'oOnXGwpc7_8My4YLpDkTnbSFdrak', '0', '第九小区', '512', '水龙头问题', '水龙头一直流水，管不住', '周六日来维修', '0', '1550807988', '1550807988', 'oOnXGwpc7_8My4YLpDkTnbSFdrak', null, null);
INSERT INTO `repair_order` VALUES ('2', '2019022210299509', '', '张惠奇', '15176628062', '', '1', '第七小区', '512', '路由器问题', '一直连接不上网络', '周六日来维修', '1', '1550808111', '1551149469', 'oOnXGwpc7_8My4YLpDkTnbSFdrak', '', null);
INSERT INTO `repair_order` VALUES ('3', '2019022210299510', '', '张惠奇', '15176628062', null, '2', '第八小区', '512', '路由器问题', '一直连接不上网络', '周六日来维修', '1', '1550808111', '1550808111', 'oOnXGwpc7_8My4YLpDkTnbSFdrak', null, 'nihao');

-- ----------------------------
-- Table structure for share
-- ----------------------------
DROP TABLE IF EXISTS `share`;
CREATE TABLE `share` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `author` varchar(40) DEFAULT NULL COMMENT '分享者',
  `url` varchar(100) DEFAULT NULL COMMENT '分享地址',
  `code` varchar(10) DEFAULT NULL COMMENT '邀请码',
  `addtime` varchar(20) DEFAULT NULL COMMENT '生成时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of share
-- ----------------------------
INSERT INTO `share` VALUES ('1', 'oOnXGwpc7_8My4YLpDkTnbSFdrak', 'http://www.repair.com/home/index/register?num=346789', '346789', '1553220022');
INSERT INTO `share` VALUES ('2', 'oOnXGwpc7_8My4YLpDkTnbSFdrak', 'http://www.repair.com/home/index/register?num=125678', '125678', '1553221169');
INSERT INTO `share` VALUES ('3', 'oOnXGwpc7_8My4YLpDkTnbSFdrak', 'http://www.repair.com/home/index/register?num=234569', '234569', '1553221337');
INSERT INTO `share` VALUES ('4', 'oOnXGwpc7_8My4YLpDkTnbSFdrak', 'http://www.repair.com/home/index/register?num=123489', '123489', '1553221339');
INSERT INTO `share` VALUES ('5', 'oOnXGwpc7_8My4YLpDkTnbSFdrak', 'http://www.repair.com/home/index/register?num=124578', '124578', '1553223121');
INSERT INTO `share` VALUES ('6', 'oOnXGwpc7_8My4YLpDkTnbSFdrak', 'http://ceshi.kamihu.com/home/index/register?num=456789', '456789', '1554261755');
INSERT INTO `share` VALUES ('7', 'oOnXGwpc7_8My4YLpDkTnbSFdrak', 'http://ceshi.kamihu.com/home/index/register?num=234689', '234689', '1554261809');
INSERT INTO `share` VALUES ('8', 'oOnXGwpc7_8My4YLpDkTnbSFdrak', 'http://ceshi.kamihu.com/home/index/register?num=346789', '346789', '1554261882');
INSERT INTO `share` VALUES ('9', 'oOnXGwpc7_8My4YLpDkTnbSFdrak', 'http://ceshi.kamihu.com/home/index/register?num=134689', '134689', '1554261882');
INSERT INTO `share` VALUES ('10', 'oOnXGwpc7_8My4YLpDkTnbSFdrak', 'http://ceshi.kamihu.com/home/index/register?num=135789', '135789', '1554261903');
INSERT INTO `share` VALUES ('11', 'oOnXGwpc7_8My4YLpDkTnbSFdrak', 'http://ceshi.kamihu.com/home/index/register?num=123567', '123567', '1554262033');
INSERT INTO `share` VALUES ('12', 'oOnXGwpc7_8My4YLpDkTnbSFdrak', 'http://ceshi.kamihu.com/home/index/register?num=345678', '345678', '1554262067');
INSERT INTO `share` VALUES ('13', 'oOnXGwpc7_8My4YLpDkTnbSFdrak', 'http://ceshi.kamihu.com/home/index/register?num=124579', '124579', '1554262351');
INSERT INTO `share` VALUES ('14', 'oOnXGwpc7_8My4YLpDkTnbSFdrak', 'http://ceshi.kamihu.com/index/index/register?num=124689', '124689', '1554262473');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `nickname` varchar(255) DEFAULT NULL COMMENT '昵称',
  `openid` varchar(255) DEFAULT NULL COMMENT '微信中唯一的标识符',
  `headimgurl` varchar(255) DEFAULT NULL COMMENT '头像',
  `telephone` varchar(30) DEFAULT '' COMMENT '注册的手机号码',
  `username` varchar(255) DEFAULT '' COMMENT '注册的姓名',
  `group` varchar(30) DEFAULT '' COMMENT '分组信息(所属的片区)',
  `area` varchar(50) DEFAULT NULL COMMENT '所属的小区',
  `address` varchar(255) DEFAULT '' COMMENT '地址信息',
  `addtime` varchar(255) DEFAULT '' COMMENT '添加时间',
  `identity` varchar(255) DEFAULT '0' COMMENT '身份选择（0报修 1维修 2协管者）',
  `is_register` int(10) NOT NULL DEFAULT '0' COMMENT '是否注册过(0未注册 1注册)',
  `is_check` int(10) NOT NULL DEFAULT '0' COMMENT '是否审核(0 未审核  1 审核)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('4', 'Kyermë', 'oOnXGwvmG0kPcrQO7CjkzMGqHN_M', 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83ervmh8icaUd9yOxVugIO3ZtXer0icJNXZ7xPiaW9FhscYkgSqDqa8ialiaoHTAZqeLtjg8jCictVQPBfNDQ/132', '', '', '1', null, '', '1550738794', '99', '1', '0');
INSERT INTO `user` VALUES ('6', 'Sam', 'oOnXGwrfWmHuLnED77BTFCIWn3Os', 'http://thirdwx.qlogo.cn/mmopen/vi_32/0iaGqqJtNGrq6oia5KOdZVOcrWRXqFIbx2GfMTS9jIqgXpWfIFM3ne4Dq3pDJfCpwZI9laxRFtKKveBdOsiaIo8vA/132', '', '', '', null, '', '1550738794', '', '0', '0');
INSERT INTO `user` VALUES ('7', '风清扬', 'oOnXGwpc7_8My4YLpDkTnbSFdrak', 'http://thirdwx.qlogo.cn/mmopen/vi_32/5Jwdq5hdxaQGMC3horzmbBia32VialnqBmr50zd0HKAyKfGRzpwdzUw9kd7WcG7UxfwuFeE3Y7MCIu5lN7g8K2mw/132', '15176628061', '张惠奇哈', '1', '天水小区', '512', '1554262552', '2', '1', '1');
INSERT INTO `user` VALUES ('8', '惶恐不安的我', null, null, '15176628063', '张天师', '6', null, '天水小城', '1551166024', '0', '0', '0');
INSERT INTO `user` VALUES ('9', '天下之大', null, null, '15176628000', '独孤九剑', '1', null, '第三小区的张雅丹', '1551238860', '0', '1', '0');
INSERT INTO `user` VALUES ('10', 'yy', 'oOnXGwrxYZ7iZZxo1tEYci9Kjlnk', 'http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJLSfHuP26MM5y0C0tCia1icJOz2aib31jwAlicJu1TSTQ3MptkD7CEF9fIDP84FHIfxCcTRgY7ShNnJQ/132', '13890276475', 'lqj', '1', '恒升', '什邡', '1555061360', '0', '1', '0');