/*
Navicat MySQL Data Transfer

Source Server         : www.mcniu.xyz_3306
Source Server Version : 50560
Source Host           : www.mcniu.xyz:3306
Source Database       : rrx

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

Date: 2018-08-30 16:17:31
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `address`
-- ----------------------------
DROP TABLE IF EXISTS `address`;
CREATE TABLE `address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `province` varchar(255) CHARACTER SET utf8 NOT NULL,
  `city` varchar(255) CHARACTER SET utf8 NOT NULL,
  `area` varchar(255) CHARACTER SET utf8 NOT NULL,
  `location` varchar(255) CHARACTER SET utf8 NOT NULL,
  `time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `address_and_user` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of address
-- ----------------------------
INSERT INTO `address` VALUES ('1', '2', '四川省', '成都市', '成华区', '东风路北二巷', '0000-00-00 00:00:00');
INSERT INTO `address` VALUES ('2', '2', '四川省', '绵阳市', '高新区', '万达公司', '0000-00-00 00:00:00');

-- ----------------------------
-- Table structure for `admin`
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8 NOT NULL,
  `password` varchar(255) CHARACTER SET latin1 NOT NULL,
  `imageurl` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT 'default.jpg',
  `admintime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `state` int(11) NOT NULL DEFAULT '0',
  `email` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `admin_username_unique` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=sjis;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'adminadmin', '123123', 'Mei.jpg', '2018-08-21 13:43:21', '0', '1005528419@qq.com');
INSERT INTO `admin` VALUES ('2', 'admin2', '123', 'default.jpg', '2018-08-21 13:48:00', '0', '10086@qq.com');
INSERT INTO `admin` VALUES ('3', 'admin3', '123', 'default.jpg', '2018-08-21 13:54:25', '0', '123');
INSERT INTO `admin` VALUES ('4', 'admin4', '123', 'default.jpg', '2018-08-21 14:04:29', '0', '123');
INSERT INTO `admin` VALUES ('5', 'admin5', '123', 'default.jpg', '2018-08-21 14:04:57', '0', '123');
INSERT INTO `admin` VALUES ('6', 'MaChengLong', '123', 'default.jpg', '2018-08-23 09:49:04', '0', '123456789@qq.com');
INSERT INTO `admin` VALUES ('7', 'PengChunXin', '123', 'default.jpg', '2018-08-23 09:49:17', '0', '123456789@qq.com');
INSERT INTO `admin` VALUES ('8', 'HeYouXu', '123', 'default.jpg', '2018-08-23 09:49:37', '0', '123456789@qq.com');
INSERT INTO `admin` VALUES ('9', 'FengYuan', '123', 'default.jpg', '2018-08-23 09:49:50', '0', '123456789@qq.com');
INSERT INTO `admin` VALUES ('10', 'ZengZeHao', '123', 'default.jpg', '2018-08-23 09:51:16', '0', '123456789@qq.com');
INSERT INTO `admin` VALUES ('11', 'admin6', '123', 'default.jpg', '2018-08-23 09:56:09', '0', '123456789@qq.com');
INSERT INTO `admin` VALUES ('12', 'admin7', '123', 'default.jpg', '2018-08-23 09:57:18', '0', '123456789@qq.com');
INSERT INTO `admin` VALUES ('13', 'admin11', '123', 'default.jpg', '2018-08-23 14:24:40', '0', '123@qq.com');
INSERT INTO `admin` VALUES ('14', 'admin12', '123', 'default.jpg', '2018-08-23 14:25:59', '0', '123@qq.com');
INSERT INTO `admin` VALUES ('23', 'admin20', '123123123', 'default.jpg', '2018-08-24 16:27:26', '0', '123456789@qq.com');

-- ----------------------------
-- Table structure for `admin_and_role`
-- ----------------------------
DROP TABLE IF EXISTS `admin_and_role`;
CREATE TABLE `admin_and_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adminid` int(11) NOT NULL,
  `roleid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_and_role
-- ----------------------------
INSERT INTO `admin_and_role` VALUES ('7', '23', '2');
INSERT INTO `admin_and_role` VALUES ('15', '1', '1');
INSERT INTO `admin_and_role` VALUES ('16', '1', '2');

-- ----------------------------
-- Table structure for `board`
-- ----------------------------
DROP TABLE IF EXISTS `board`;
CREATE TABLE `board` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `boardtime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `showtime` datetime NOT NULL,
  `finishtime` datetime NOT NULL,
  `adminid` int(11) NOT NULL,
  `addtime` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `board_and_admin` (`adminid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of board
-- ----------------------------

-- ----------------------------
-- Table structure for `coupons`
-- ----------------------------
DROP TABLE IF EXISTS `coupons`;
CREATE TABLE `coupons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) NOT NULL DEFAULT '0',
  `userid` int(11) NOT NULL,
  `usertype` int(11) NOT NULL DEFAULT '0',
  `time` datetime NOT NULL,
  `deadline` datetime NOT NULL,
  `coupongstime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `usetime` datetime NOT NULL,
  `state` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of coupons
-- ----------------------------

-- ----------------------------
-- Table structure for `fault`
-- ----------------------------
DROP TABLE IF EXISTS `fault`;
CREATE TABLE `fault` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `faultinfo` varchar(255) DEFAULT NULL,
  `deletedfailt` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `sadasd` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of fault
-- ----------------------------
INSERT INTO `fault` VALUES ('1', '电视', '花了', '0');
INSERT INTO `fault` VALUES ('2', '空调', '漏水', '0');
INSERT INTO `fault` VALUES ('3', '电脑', '蓝屏', '1');
INSERT INTO `fault` VALUES ('4', '冰箱', '结冰', '0');
INSERT INTO `fault` VALUES ('5', '微波炉', '温度太高', '1');
INSERT INTO `fault` VALUES ('6', '油烟机', '漏油', '0');
INSERT INTO `fault` VALUES ('7', '热水器', '太热了', '0');
INSERT INTO `fault` VALUES ('8', '洗碗机', '洗碗太慢了', '0');
INSERT INTO `fault` VALUES ('9', '电视', '坏了', '0');
INSERT INTO `fault` VALUES ('37', '冰箱', '不制冷', '0');
INSERT INTO `fault` VALUES ('38', '电脑', '有毒', '0');
INSERT INTO `fault` VALUES ('39', '电脑', '有毒啊', '0');
INSERT INTO `fault` VALUES ('40', '电脑', '真的有毒啊', '0');
INSERT INTO `fault` VALUES ('41', '电脑', '毒的不轻', '0');
INSERT INTO `fault` VALUES ('42', '电视', '再次坏了', '1');

-- ----------------------------
-- Table structure for `fettler`
-- ----------------------------
DROP TABLE IF EXISTS `fettler`;
CREATE TABLE `fettler` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 NOT NULL,
  `idcard` varchar(18) NOT NULL,
  `imageurl` varchar(255) NOT NULL,
  `authtime` datetime DEFAULT NULL,
  `authstate` int(11) DEFAULT '0',
  `adminid` int(11) DEFAULT NULL,
  `userid` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `fettle_and_user` (`userid`) USING BTREE,
  KEY `idcard` (`idcard`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of fettler
-- ----------------------------
INSERT INTO `fettler` VALUES ('1', 'Tom', '511524199502156456', 'D:\\rrx\\target\\RRX\\/RRXwx1482a5aea3785f9a.o6zAJsyMwD9rJwh7Xa5cSNxhogs0.ad250ac9080b298a321e3b0f4ed09921.jpg', null, '1', null, '1');
INSERT INTO `fettler` VALUES ('2', '呵呵呵', '51070419940202211x', 'C:\\Users\\Administrator\\IdeaProjects\\rrx\\target\\RRX\\/RRXwx1482a5aea3785f9a.o6zAJs-dRsQaQqqirfTxAjm7ShmE.i0BYBoWYJZCN2b04df3ecc1d94afddff082d139c6f15.jpg', null, '1', null, '2');
INSERT INTO `fettler` VALUES ('3', '张三', '510107199609163418', 'C:\\Users\\Administrator.CDEDUASK_PC\\IdeaProjects\\rrx\\target\\RRX\\/RRXwx1482a5aea3785f9a.o6zAJs_gq67u6aXFgbP0ZqrYqD0o.QasAzWcQdBxc076e3caed758a1c18c91a0e9cae3368f.jpg', null, '1', null, '5');

-- ----------------------------
-- Table structure for `index_img`
-- ----------------------------
DROP TABLE IF EXISTS `index_img`;
CREATE TABLE `index_img` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `imageurl` varchar(255) NOT NULL,
  `request` varchar(255) NOT NULL,
  `ident` int(11) NOT NULL,
  `adminid` int(11) NOT NULL,
  `remark` varchar(255) NOT NULL,
  `order` int(11) NOT NULL,
  `createtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `admin_and_indeximg` (`adminid`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of index_img
-- ----------------------------
INSERT INTO `index_img` VALUES ('1', 'http://localhost:8090/RRX/images/wxhome/banner1.jpg', '', '0', '0', '', '0', '0000-00-00 00:00:00');
INSERT INTO `index_img` VALUES ('2', 'http://localhost:8090/RRX/images/wxhome/banner2.jpg', '', '0', '0', '', '0', '0000-00-00 00:00:00');
INSERT INTO `index_img` VALUES ('3', 'http://localhost:8090/RRX/images/wxhome/banner3.jpg', '', '0', '0', '', '0', '0000-00-00 00:00:00');

-- ----------------------------
-- Table structure for `log`
-- ----------------------------
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adminid` int(11) NOT NULL,
  `logtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `logcontent` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `log_and_admin` (`adminid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of log
-- ----------------------------

-- ----------------------------
-- Table structure for `menu`
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `menu_name` varchar(255) NOT NULL,
  `iconurl` varchar(255) NOT NULL DEFAULT 'default.jpg',
  `menu_permission` varchar(255) NOT NULL,
  `menu_order` int(2) NOT NULL DEFAULT '0',
  `parent` int(11) DEFAULT NULL,
  `request` varchar(255) NOT NULL,
  `state` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `menu_parentmenu` (`parent`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of menu
-- ----------------------------
INSERT INTO `menu` VALUES ('1', '管理员管理', 'default.jpg', '', '1', null, '', '0');
INSERT INTO `menu` VALUES ('2', '添加管理员', 'default.jpg', 'html.admin.add', '0', '1', 'toAddAdmin', '0');
INSERT INTO `menu` VALUES ('3', '添加角色', 'default.jpg', 'html.role.add', '1', '4', 'toAddRole', '0');
INSERT INTO `menu` VALUES ('4', '角色管理', 'default.jpg', '', '0', null, '', '0');
INSERT INTO `menu` VALUES ('5', '菜单管理', 'default.jpg', '', '2', null, '', '0');
INSERT INTO `menu` VALUES ('6', '添加菜单', 'default.jpg', 'html.menu.add', '0', '5', 'toAddMenu', '0');
INSERT INTO `menu` VALUES ('7', '删除菜单', 'default.jpg', 'html.menu.delete', '1', '5', 'toDeleteMenu', '0');
INSERT INTO `menu` VALUES ('8', '后台管理', 'default.jpg', '', '5', null, 'ww', '0');
INSERT INTO `menu` VALUES ('9', '师傅管理', 'default.jpg', '', '10', null, 'www', '0');
INSERT INTO `menu` VALUES ('10', '添加师傅', 'default.jpg', 'html.fettler.add', '0', '9', 'toFettlerAdd', '0');
INSERT INTO `menu` VALUES ('23', '修改角色', 'default.jpg', 'html.role.update', '0', '4', 'toUpdateRole', '0');
INSERT INTO `menu` VALUES ('24', '修改管理员', 'default.jpg', 'html.admin.update', '0', '1', 'toUpdateAdmin', '0');
INSERT INTO `menu` VALUES ('25', '首页管理', 'default.jpg', '', '0', null, 'aaa', '0');
INSERT INTO `menu` VALUES ('26', '修改首页图片', 'default.jpg', 'html.index.update', '0', '25', 'toUpdateIndex', '0');
INSERT INTO `menu` VALUES ('27', '师傅认证', 'default.jpg', 'html.fettler.auth', '0', '9', 'toAuthFettler', '0');
INSERT INTO `menu` VALUES ('28', '故障管理', 'default.jpg', '', '0', null, '', '0');
INSERT INTO `menu` VALUES ('29', '添加故障', 'default.jpg', 'html.fault.add', '1', '28', 'toAddFault', '0');
INSERT INTO `menu` VALUES ('30', '修改故障', 'default.jpg', 'html.fault.update', '0', '28', 'toUpdateFault', '0');
INSERT INTO `menu` VALUES ('31', '订单管理', 'default.jpg', '', '0', null, '', '0');
INSERT INTO `menu` VALUES ('32', '订单查询', 'default.jpg', 'html.order.select', '0', '31', 'toSelectOrders', '0');

-- ----------------------------
-- Table structure for `orders`
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `id` int(11) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `number` varchar(50) CHARACTER SET latin1 NOT NULL,
  `userid` int(11) NOT NULL,
  `name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fettlerid` int(11) NOT NULL DEFAULT '-1',
  `addressname` varchar(255) CHARACTER SET utf8 NOT NULL,
  `type` varchar(20) CHARACTER SET utf8 NOT NULL,
  `content` varchar(255) CHARACTER SET utf8 NOT NULL,
  `taketime` datetime DEFAULT NULL,
  `time` datetime NOT NULL,
  `completedtime` datetime DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `usermoney` int(11) DEFAULT '0',
  `usertime` datetime DEFAULT NULL,
  `fettlermoney` int(11) DEFAULT NULL,
  `fettletime` datetime DEFAULT NULL,
  `timestamp` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `noncestr` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `package` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `signtype` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `paysign` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `appid` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `phone` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES ('00000000001', '1535449268837', '2', '张三', '-1', '广东省广州市海珠区新港中路397号', '油烟机', '漏油', null, '2018-08-28 17:41:08', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000002', '1535449279336', '2', '李四', '-1', '广东省广州市海珠区新港中路397号', '洗碗机', '洗碗太慢了', null, '2018-08-28 17:41:19', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000003', '1535449389566', '2', '王五', '-1', '广东省广州市海珠区新港中路397号', '热水器', '太热了', null, '2018-08-28 17:43:09', null, '1', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000004', '1535451493252', '2', '张三', '-1', '广东省广州市海珠区新港中路397号', '油烟机', '漏油', null, '2018-08-28 18:18:13', null, '2', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000005', '1535451581907', '2', '张三', '-1', '广东省广州市海珠区新港中路397号', '油烟机', '漏油', null, '2018-08-28 18:19:41', null, '3', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000008', '1535462617423', '2', '张三', '-1', '广东省广州市海珠区新港中路397号', '冰箱', '结冰', null, '2018-08-28 21:23:36', null, '2', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000009', '1535509874140', '3', '张三', '-1', '广东省广州市海珠区新港中路397号', '冰箱', '结冰', null, '2018-08-29 10:31:15', null, '2', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000010', '1535509905458', '3', '张三', '-1', '广东省广州市海珠区新港中路397号', '其他', '电脑搓了', null, '2018-08-29 10:31:46', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000011', '1535510169081', '3', '张三', '-1', '广东省广州市海珠区新港中路397号', '冰箱', '结冰', null, '2018-08-29 10:36:10', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000012', '1535510256368', '3', '张三', '-1', '广东省广州市海珠区新港中路397号', '冰箱', '结冰', null, '2018-08-29 10:37:37', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000015', '1535522838344', '3', '张三', '-1', '广东省广州市海珠区新港中路397号', '冰箱', '结冰', null, '2018-08-29 14:07:19', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000016', '1535522871566', '3', '张三', '-1', '广东省广州市海珠区新港中路397号', '冰箱', '结冰', null, '2018-08-29 14:07:52', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000017', '1535524828674', '3', '张三', '-1', '广东省广州市海珠区新港中路397号', '冰箱', '结冰', null, '2018-08-29 14:40:29', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000018', '1535525203425', '3', '张三', '-1', '广东省广州市海珠区新港中路397号', '冰箱', '结冰', null, '2018-08-29 14:46:44', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000019', '1535525529384', '3', '张三', '-1', '广东省广州市海珠区新港中路397号', '冰箱', '结冰', null, '2018-08-29 14:52:10', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000020', '1535525526404', '3', '张三', '-1', '广东省广州市海珠区新港中路397号', '冰箱', '结冰', null, '2018-08-29 14:52:10', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000021', '1535526906392', '3', '张三', '-1', '广东省广州市海珠区新港中路397号', '冰箱', '结冰', null, '2018-08-29 15:15:07', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000022', '1535526930573', '3', '张三', '-1', '广东省广州市海珠区新港中路397号', '冰箱', '结冰', null, '2018-08-29 15:15:31', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000023', '1535530405189', '2', '张三', '-1', '广东省广州市海珠区新港中路397号', '冰箱', '结冰', null, '2018-08-29 16:13:27', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000024', '1535539661933', '1', null, '-1', '广东省广州市海珠区新港中路397号', '电视', '花了', null, '2018-08-29 18:47:44', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000025', '1535596031193', '3', '张三', '-1', '广东省广州市海珠区新港中路397号', '冰箱', '结冰', null, '2018-08-30 10:27:13', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000026', '1535607453776', '3', '张三', '-1', '广东省广州市海珠区新港中路397号', '热水器', '太热了', null, '2018-08-30 13:37:35', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000027', '1535609159291', '3', null, '-1', '广东省广州市海珠区新港中路397号', '空调', '漏水', null, '2018-08-30 14:06:01', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000028', '1535609987960', '5', '张三', '-1', '广东省广州市海珠区新港中路397号', '冰箱', '结冰', null, '2018-08-30 14:20:01', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000029', '1535609997122', '5', '张三', '-1', '广东省广州市海珠区新港中路397号', '冰箱', '结冰', null, '2018-08-30 14:20:10', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000030', '1535610369077', '5', '张三', '-1', '广东省广州市海珠区新港中路397号', '冰箱', '结冰', null, '2018-08-30 14:26:22', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000031', '1535614009427', '5', null, '-1', '广东省广州市海珠区新港中路397号', '油烟机', '漏油', null, '2018-08-30 15:26:49', null, '1', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000032', '1535614019689', '5', null, '-1', '广东省广州市海珠区新港中路397号', '油烟机', '漏油', null, '2018-08-30 15:26:59', null, '1', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000033', '1535614631434', '5', null, '-1', '四川省成都市武侯区2333', '电视', '花了', null, '2018-08-30 15:37:11', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000034', '1535614772025', '5', null, '-1', '广东省广州市海珠区新港中路397号', 'undefined', 'undefined', null, '2018-08-30 15:39:32', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000035', '1535614793289', '5', null, '-1', '广东省广州市海珠区新港中路397号', '电脑', '有毒', null, '2018-08-30 15:39:53', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000036', '1535614817536', '5', null, '-1', '广东省广州市海珠区新港中路397号', '电视', '花了', null, '2018-08-30 15:40:17', null, '0', '0', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `orders` VALUES ('00000000037', '1535616185630', '5', null, '-1', '四川省成都市武侯区2333', '其他', '一点都不好用', null, '2018-08-30 16:03:05', null, '0', '0', null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `order_and_coupons`
-- ----------------------------
DROP TABLE IF EXISTS `order_and_coupons`;
CREATE TABLE `order_and_coupons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `orederid` int(11) NOT NULL,
  `couponsid` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `order_and_coupons` (`orederid`),
  KEY `coupons_and_order` (`couponsid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of order_and_coupons
-- ----------------------------

-- ----------------------------
-- Table structure for `role`
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `remark` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `role_name_unique` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('1', '超级管理员', '所有权限');
INSERT INTO `role` VALUES ('2', '师傅认证员', '可以认证师傅通过');

-- ----------------------------
-- Table structure for `role_and_permission`
-- ----------------------------
DROP TABLE IF EXISTS `role_and_permission`;
CREATE TABLE `role_and_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `roleid` int(11) NOT NULL,
  `permission` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `menu_and_role` (`roleid`),
  KEY `role_and_menu` (`permission`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of role_and_permission
-- ----------------------------
INSERT INTO `role_and_permission` VALUES ('23', '19', 'html.fettler.add');
INSERT INTO `role_and_permission` VALUES ('30', '2', 'html.fettler.auth');
INSERT INTO `role_and_permission` VALUES ('41', '1', 'html.fettler.add');
INSERT INTO `role_and_permission` VALUES ('42', '1', 'html.fettler.auth');
INSERT INTO `role_and_permission` VALUES ('43', '1', 'html.menu.delete');
INSERT INTO `role_and_permission` VALUES ('44', '1', 'html.menu.add');
INSERT INTO `role_and_permission` VALUES ('45', '1', 'html.admin.add');
INSERT INTO `role_and_permission` VALUES ('46', '1', 'html.admin.update');
INSERT INTO `role_and_permission` VALUES ('47', '1', 'html.role.add');
INSERT INTO `role_and_permission` VALUES ('48', '1', 'html.role.update');
INSERT INTO `role_and_permission` VALUES ('49', '1', 'html.index.update');
INSERT INTO `role_and_permission` VALUES ('50', '1', 'html.fault.add');
INSERT INTO `role_and_permission` VALUES ('51', '1', 'html.fault.update');
INSERT INTO `role_and_permission` VALUES ('52', '1', 'html.order.select');
INSERT INTO `role_and_permission` VALUES ('53', '1', '');

-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `openid` varchar(255) NOT NULL,
  `phone` varchar(11) DEFAULT NULL,
  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `state` int(11) NOT NULL DEFAULT '0',
  `address` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `users_and_address` (`address`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('1', 'ongyA4srdgaVVgHxCyAmRz9SQvs0', '454644545', '2018-08-27 09:13:13', '0', '1');
INSERT INTO `users` VALUES ('2', 'ongyA4mIHf3czcLvy5DWJiEsqFAs', '17601427407', '2018-08-27 09:13:58', '0', '1');
INSERT INTO `users` VALUES ('3', 'ongyA4rn-37Hyy7Fw-Qkt48VVOKw', '89465413154', '2018-08-27 09:15:18', '0', '1');
INSERT INTO `users` VALUES ('5', 'ongyA4hw5S9f5_rHO_GFGvZF8pGc', '15002819221', '2018-08-29 15:50:49', '0', null);