/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50505
Source Host           : localhost:3306
Source Database       : interest

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

Date: 2019-06-21 10:37:00
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for interest_activity
-- ----------------------------
DROP TABLE IF EXISTS `interest_activity`;
CREATE TABLE `interest_activity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `activityname` varchar(50) NOT NULL COMMENT '活动名',
  `type` tinyint(4) DEFAULT NULL COMMENT '活动类型（）',
  `content` text COMMENT '活动介绍',
  `img` text COMMENT '活动图片',
  `num` int(11) DEFAULT NULL COMMENT '活动人数',
  `total` varchar(50) DEFAULT NULL COMMENT '价钱',
  `start_time` varchar(50) DEFAULT NULL COMMENT '活动开始时间',
  `end_time` varchar(50) DEFAULT NULL COMMENT '活动结束时间',
  `add_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `ip` varchar(11) DEFAULT NULL COMMENT 'IP地址',
  `remark` text COMMENT '备注',
  `status` tinyint(1) DEFAULT NULL COMMENT '活動狀態 1活動 0禁用',
  `activity_time` varchar(50) DEFAULT NULL COMMENT '活动时间段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='管理活动内容信息';

-- ----------------------------
-- Records of interest_activity
-- ----------------------------
INSERT INTO `interest_activity` VALUES ('1', '興趣班', '1', '薩拉姆第三大街灑到拉薩交流電機撒羅尼', null, '12', '50', '1559702996', null, '1559702996', '127.0.0.1', null, '1', null);
INSERT INTO `interest_activity` VALUES ('6', '兴趣班的讲解', null, '讲述兴趣班培训内容，环境，地点，以及人员安排方面的筛选。', '/uploads/20190613/83cf8914261d9beef04fcc2da9482a42.png', null, '3800', null, null, '1560409468', '127.0.0.1', null, '1', '2019/06/05 - 2019/06/27');

-- ----------------------------
-- Table structure for interest_admin
-- ----------------------------
DROP TABLE IF EXISTS `interest_admin`;
CREATE TABLE `interest_admin` (
  `admin_id` tinyint(4) NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
  `group_id` mediumint(8) DEFAULT NULL COMMENT '分组ID',
  `nickname` varchar(10) CHARACTER SET utf8 DEFAULT NULL COMMENT '真实姓名',
  `username` varchar(20) CHARACTER SET utf8 NOT NULL COMMENT '管理员用户名',
  `pwd` varchar(70) CHARACTER SET utf8 NOT NULL COMMENT '管理员密码',
  `email` varchar(30) CHARACTER SET utf8 DEFAULT NULL COMMENT '邮箱',
  `tel` varchar(30) CHARACTER SET utf8 DEFAULT NULL COMMENT '电话号码',
  `ip` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT 'IP地址',
  `add_time` int(11) DEFAULT NULL COMMENT '添加时间',
  `is_open` tinyint(2) DEFAULT '0' COMMENT '审核状态',
  `mchToken` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '商户Token',
  `is_sys` int(1) DEFAULT '0' COMMENT '1为系统号，0普通号',
  `is_mch` int(1) DEFAULT '0' COMMENT '1为商户账号',
  PRIMARY KEY (`admin_id`) USING BTREE,
  KEY `admin_username` (`username`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='后台用户';

-- ----------------------------
-- Records of interest_admin
-- ----------------------------
INSERT INTO `interest_admin` VALUES ('1', '1', 'admin', 'admin', 'e10adc3949ba59abbe56e057f20f883e', '654589023@qq.com', '18792402229', '127.0.0.1', '1559702996', '1', '', '1', '0');
INSERT INTO `interest_admin` VALUES ('8', '2', 'admin2', 'admin2', 'e10adc3949ba59abbe56e057f20f883e', '8234738438@qq.com', '18767654897', '127.0.0.1', '1559702996', '1', '6DC36E92-BA1BF1D6', '0', '1');
INSERT INTO `interest_admin` VALUES ('10', '3', 'admin3', 'admin3', 'e10adc3949ba59abbe56e057f20f883e', '512837965@qq.com', '15820597993', null, '1559702996', '0', '8F58930D-5034DDD9', '0', '1');
INSERT INTO `interest_admin` VALUES ('11', '4', 'admin4', 'admin4', 'e10adc3949ba59abbe56e057f20f883e', '512837965@qq.com', '187924022295', '127.0.0.1', '1559702996', '0', null, '0', '0');

-- ----------------------------
-- Table structure for interest_advertise
-- ----------------------------
DROP TABLE IF EXISTS `interest_advertise`;
CREATE TABLE `interest_advertise` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` tinyint(4) NOT NULL COMMENT '类型（1www，2app）',
  `admin_id` int(11) DEFAULT NULL COMMENT '发文者ID',
  `title` varchar(50) DEFAULT NULL COMMENT '主题',
  `content` text COMMENT '内容',
  `img` text COMMENT '图片',
  `add_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `ip` int(11) DEFAULT NULL COMMENT 'IP地址',
  `remark` text COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='管理 网站Banner，APP Banner。';

-- ----------------------------
-- Records of interest_advertise
-- ----------------------------

-- ----------------------------
-- Table structure for interest_articles
-- ----------------------------
DROP TABLE IF EXISTS `interest_articles`;
CREATE TABLE `interest_articles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` tinyint(4) NOT NULL COMMENT '文章类型（）',
  `admin_id` int(11) DEFAULT NULL COMMENT '发文者ID',
  `title` varchar(50) DEFAULT NULL COMMENT '主题',
  `content` text COMMENT '内容',
  `address` varchar(50) DEFAULT NULL COMMENT '地址',
  `tel` varchar(30) DEFAULT NULL COMMENT '电话',
  `add_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `ip` int(11) DEFAULT NULL COMMENT 'IP地址',
  `remark` text COMMENT '备注',
  `praise` int(11) DEFAULT NULL COMMENT '点赞数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='管理文章';

-- ----------------------------
-- Records of interest_articles
-- ----------------------------

-- ----------------------------
-- Table structure for interest_attendance
-- ----------------------------
DROP TABLE IF EXISTS `interest_attendance`;
CREATE TABLE `interest_attendance` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `admin_id` mediumint(9) DEFAULT NULL COMMENT '组ID',
  `start_time` varchar(20) NOT NULL COMMENT '签到时间（上班）',
  `end_time` varchar(20) DEFAULT NULL COMMENT '签到时间（下班）',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态',
  `ip` varchar(20) DEFAULT NULL COMMENT 'IP地址',
  `add_time` int(11) DEFAULT NULL COMMENT '添加时间',
  `remark` text COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='员工考勤表';

-- ----------------------------
-- Records of interest_attendance
-- ----------------------------

-- ----------------------------
-- Table structure for interest_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `interest_auth_group`;
CREATE TABLE `interest_auth_group` (
  `group_id` mediumint(9) NOT NULL AUTO_INCREMENT COMMENT '组ID',
  `title` char(20) DEFAULT NULL COMMENT '组名',
  `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态:0禁用,1启用',
  `rules` longtext NOT NULL COMMENT '规则',
  `add_time` int(11) DEFAULT NULL COMMENT '添加时间',
  `remark` text COMMENT '备注',
  PRIMARY KEY (`group_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户组表';

-- ----------------------------
-- Records of interest_auth_group
-- ----------------------------
INSERT INTO `interest_auth_group` VALUES ('1', '超级管理员', '1', '[0,1,277,15,17,149,116,117,118,151,18,108,114,112,109,110,111,3,5,126,127,128,4,230,232,129,295,296,300,294,297,298,299,301,302,303,313,316,314,315,304,306,310,311,305,307,308,309]', '1465114224', null);
INSERT INTO `interest_auth_group` VALUES ('2', '員工', '1', '[0,1,277,15,17,149,116,117,118,151,3,5,126,127,128,4,230,232,129,295,296,300,294,297,298,299,301,302,303,304,306,310,311,305,307,308,309]', '1465114224', null);
INSERT INTO `interest_auth_group` VALUES ('3', '導師', '1', '[0,1,277,295,296,300,294,297,298]', '1465114224', '');
INSERT INTO `interest_auth_group` VALUES ('4', '點名員工', '1', '[0,1,277,15,16,119,120,121,145,17,149,116,117,118,151,18,108,114,112,109,110,111]', '1557980540', null);
INSERT INTO `interest_auth_group` VALUES ('5', '123', '1', '[0]', null, null);

-- ----------------------------
-- Table structure for interest_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `interest_auth_rule`;
CREATE TABLE `interest_auth_rule` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `href` char(80) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `title` char(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `type` tinyint(1) NOT NULL DEFAULT '1',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `authopen` tinyint(2) NOT NULL DEFAULT '1',
  `icon` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '样式',
  `condition` char(100) CHARACTER SET utf8 DEFAULT '',
  `pid` int(5) NOT NULL DEFAULT '0' COMMENT '父栏目ID',
  `sort` int(11) DEFAULT '0' COMMENT '排序',
  `addtime` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  `zt` int(1) DEFAULT NULL,
  `menu_status` tinyint(1) DEFAULT NULL,
  `module` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT 'admin' COMMENT '模块',
  `onclick` int(1) DEFAULT '0',
  `is_mch` int(1) DEFAULT '1' COMMENT '是否为商户权限',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=317 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='后台权限';

-- ----------------------------
-- Records of interest_auth_rule
-- ----------------------------
INSERT INTO `interest_auth_rule` VALUES ('1', 'Index/index', '系统管理', '1', '1', '1', 'icon-cogs', '', '0', '103', '1446535750', '1', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('3', 'Database/database', '数据库管理', '1', '1', '1', 'icon-database', '', '1', '4', '1446535805', '1', '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('4', 'Database/restore', '还原数据库', '1', '1', '1', '', '', '3', '22', '1446535750', '1', '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('5', 'Database/database', '数据库备份', '1', '1', '1', '', '', '3', '21', '1446535834', '1', '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('15', 'Auth/adminList', '权限管理', '1', '1', '1', 'icon-lifebuoy', '', '1', '3', '1446535750', '1', '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('17', 'Auth/adminGroup', '用户组列表', '1', '1', '1', '', '', '15', '11', '1446535750', '1', '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('18', 'Auth/adminRule', '路由管理', '1', '1', '1', '', '', '15', '12', '1446535750', '1', '1', 'admin', '0', '0');
INSERT INTO `interest_auth_rule` VALUES ('108', 'Auth/ruleAdd', '操作-添加', '1', '1', '1', '', '', '18', '1', '1461550835', '1', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('109', 'Auth/ruleState', '操作-状态', '1', '1', '1', '', '', '18', '4', '1461550949', '1', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('110', 'Auth/ruleTz', '操作-验证', '1', '1', '1', '', '', '18', '5', '1461551129', '1', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('111', 'Auth/ruleorder', '操作-排序', '1', '1', '1', '', '', '18', '6', '1461551263', '1', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('112', 'Auth/ruleDel', '操作-删除', '1', '1', '1', '', '', '18', '3', '1461551536', '1', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('114', 'Auth/ruleEdit', '操作-修改', '1', '1', '1', '', '', '18', '2', '1461551913', '1', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('116', 'Auth/groupEdit', '操作-修改', '1', '1', '1', '', '', '17', '2', '1461552326', '1', '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('117', 'Auth/groupDel', '操作-删除', '1', '1', '1', '', '', '17', '3', '1461552349', '1', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('118', 'Auth/groupAccess', '操作-权限', '1', '1', '1', '', '', '17', '4', '1461552404', '1', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('119', 'Auth/adminAdd', '操作-添加', '1', '1', '1', '', '', '16', '1', '1461553162', '1', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('120', 'Auth/adminEdit', '操作-修改', '1', '1', '1', '', '', '16', '2', '1461554130', '1', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('121', 'Auth/adminDel', '操作-删除', '1', '1', '1', '', '', '16', '3', '1461554152', '1', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('126', 'Database/export', '操作-备份', '1', '1', '1', '', '', '5', '1', '1461550835', '1', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('127', 'Database/optimize', '操作-优化', '1', '1', '1', '', '', '5', '2', '1461550835', '1', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('128', 'Database/repair', '操作-修复', '1', '1', '1', '', '', '5', '3', '1461550835', '1', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('129', 'Database/delSqlFiles', '操作-删除', '1', '1', '1', '', '', '4', '3', '1461550835', '1', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('230', 'Database/restoreData', '操作-还原', '1', '1', '1', '', '', '4', '1', '1497423595', '0', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('145', 'Auth/adminState', '操作-状态', '1', '1', '1', '', '', '16', '4', '1461550835', '1', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('149', 'Auth/groupAdd', '操作-添加', '1', '1', '1', '', '', '17', '1', '1461550835', '1', '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('151', 'Auth/groupRunaccess', '操作-权存', '1', '1', '1', '', '', '17', '5', '1461550835', '1', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('232', 'Database/downFile', '操作-下载', '1', '1', '1', '', '', '4', '2', '1497423744', '0', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('277', 'Index/index', '控制面板', '1', '1', '0', '', '', '1', '2', '1446535789', '1', '0', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('294', 'Staff/index', '员工管理', '1', '1', '1', null, '', '295', '3', '1559725888', '1', '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('295', 'Staff/index', '应用管理', '1', '1', '1', null, '', '0', '102', '1559727067', '1', '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('297', 'Staff/staffList', '员工列表', '1', '1', '1', null, '', '294', '0', '1559801684', null, '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('296', 'User/index', '用户管理', '1', '1', '1', null, '', '295', '2', '1559789931', null, '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('298', 'Staff/staffAdd', '操作-添加', '1', '1', '1', null, '', '297', '1', '1559804449', null, '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('302', 'Course/index', '课程管理', '1', '1', '1', null, '', '295', '5', '1560159014', null, '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('299', 'Order/index', '订单管理', '1', '1', '1', null, '', '295', '4', '1559805270', null, '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('300', 'User/userList', '用户列表', '1', '1', '1', null, '', '296', '1', '1559805351', null, '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('301', 'Order/orderList', '订单列表', '1', '1', '1', null, '', '299', '1', '1560132158', null, '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('303', 'Content/index', '内容管理', '1', '1', '1', null, '', '295', '6', '1560159071', null, '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('304', 'Store/index', '积分商店管理', '1', '1', '1', null, '', '295', '7', '1560159201', null, '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('305', 'System/index', '系统应用', '1', '1', '1', null, '', '295', '9', '1560159279', null, '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('306', 'Discuss/index', '讨论区', '1', '1', '1', null, '', '295', '8', '1560159388', null, '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('307', 'System/activityList', '活動管理', '1', '1', '1', null, '', '305', '1', '1560215385', null, '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('308', 'System/noticeList', '公告推送通知', '1', '1', '1', null, '', '305', '2', '1560215950', null, '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('309', 'System/emailList', '郵箱配置', '1', '1', '1', null, '', '305', '3', '1560216205', null, '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('310', 'Discuss/topicList', '主题管理', '1', '1', '1', null, '', '306', '1', '1560217199', null, '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('311', 'Discuss/replyList', '回復管理', '1', '1', '1', null, '', '306', '2', '1560217265', null, '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('313', 'Single/singleList', '单页管理', '1', '1', '1', null, '', '303', '1', '1560410202', null, '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('314', 'Article/articleList', '文章管理', '1', '1', '1', null, '', '303', '2', '1560410294', null, '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('315', 'Advertise/advertiseList', '广告管理', '1', '1', '1', null, '', '303', '3', '1560410397', null, '1', 'admin', '0', '1');
INSERT INTO `interest_auth_rule` VALUES ('316', 'Single/singleAdd', '操作-添加', '1', '1', '1', null, '', '313', '1', '1560417685', null, '1', 'admin', '0', '1');

-- ----------------------------
-- Table structure for interest_comments
-- ----------------------------
DROP TABLE IF EXISTS `interest_comments`;
CREATE TABLE `interest_comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL COMMENT '用户名',
  `type` tinyint(4) NOT NULL COMMENT '用户类型（家长、学生）',
  `sex` bit(1) DEFAULT NULL COMMENT '性别',
  `age` int(11) DEFAULT NULL COMMENT '年龄',
  `remark` text COMMENT '备注',
  `add_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `ip` int(11) DEFAULT NULL COMMENT 'IP地址',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='管理评论内容';

-- ----------------------------
-- Records of interest_comments
-- ----------------------------

-- ----------------------------
-- Table structure for interest_coupon
-- ----------------------------
DROP TABLE IF EXISTS `interest_coupon`;
CREATE TABLE `interest_coupon` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL COMMENT '优惠卷名',
  `total` text COMMENT '优惠价格',
  `add_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `remark` text COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='优惠卷表';

-- ----------------------------
-- Records of interest_coupon
-- ----------------------------

-- ----------------------------
-- Table structure for interest_courses
-- ----------------------------
DROP TABLE IF EXISTS `interest_courses`;
CREATE TABLE `interest_courses` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `type` tinyint(4) NOT NULL COMMENT '课程种类（補習班課程,興趣班課程）',
  `code` varchar(30) DEFAULT NULL COMMENT '课程编号',
  `name` varchar(50) NOT NULL COMMENT '课程名',
  `introduction` text COMMENT '课程介绍',
  `img` text COMMENT '课程图片',
  `course_num` int(11) DEFAULT NULL COMMENT '课程数目（次，节）',
  `course_time` varchar(20) DEFAULT NULL COMMENT '课程时长',
  `stu_num` int(11) DEFAULT NULL COMMENT '学生人数',
  `total` varchar(50) DEFAULT NULL COMMENT '总价钱',
  `start_time` varchar(50) DEFAULT NULL COMMENT '课程开始时间',
  `end_time` varchar(50) DEFAULT NULL COMMENT '课程结束时间',
  `add_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `remark` text COMMENT '备注',
  `lower_num` int(11) DEFAULT NULL COMMENT '课堂人数下限 （数字）',
  `upper_num` int(11) DEFAULT NULL COMMENT '课堂人数上限 （数字）',
  `join_end_time` int(11) DEFAULT NULL COMMENT '课程报名截止时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='管理课程内容信息';

-- ----------------------------
-- Records of interest_courses
-- ----------------------------

-- ----------------------------
-- Table structure for interest_delivery_address
-- ----------------------------
DROP TABLE IF EXISTS `interest_delivery_address`;
CREATE TABLE `interest_delivery_address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL COMMENT '店名',
  `address` varchar(50) DEFAULT NULL COMMENT '送货地址',
  `renewal` text COMMENT '换领物品地址（可以多个，json）',
  `tel` varchar(30) DEFAULT NULL COMMENT '联系电话',
  `add_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `ip` varchar(20) DEFAULT NULL COMMENT 'IP地址',
  `remark` text COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='送货地址';

-- ----------------------------
-- Records of interest_delivery_address
-- ----------------------------

-- ----------------------------
-- Table structure for interest_goods
-- ----------------------------
DROP TABLE IF EXISTS `interest_goods`;
CREATE TABLE `interest_goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` tinyint(4) DEFAULT NULL COMMENT '商品分類(普通分類/優惠卷)',
  `code` varchar(50) DEFAULT NULL COMMENT '優惠代碼(一次性優惠卷,用作購買課程作現金折扣)',
  `name` varchar(50) NOT NULL COMMENT '商品名称',
  `content` text COMMENT '商品介绍',
  `price` varchar(20) DEFAULT NULL COMMENT '价钱',
  `add_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `ip` varchar(20) DEFAULT NULL COMMENT 'IP地址',
  `remark` text COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='积分商品表';

-- ----------------------------
-- Records of interest_goods
-- ----------------------------

-- ----------------------------
-- Table structure for interest_notices
-- ----------------------------
DROP TABLE IF EXISTS `interest_notices`;
CREATE TABLE `interest_notices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` tinyint(4) NOT NULL COMMENT '公告类型（通知，提醒）',
  `title` varchar(50) NOT NULL COMMENT '公告标题',
  `content` text COMMENT '内容',
  `add_time` int(11) DEFAULT NULL COMMENT '添加时间',
  `ip` int(11) DEFAULT NULL COMMENT 'IP地址',
  `remark` text COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='公告';

-- ----------------------------
-- Records of interest_notices
-- ----------------------------

-- ----------------------------
-- Table structure for interest_notices_record
-- ----------------------------
DROP TABLE IF EXISTS `interest_notices_record`;
CREATE TABLE `interest_notices_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` tinyint(4) NOT NULL COMMENT '公告类型（通知，提醒）',
  `status` char(10) DEFAULT NULL COMMENT '状态（1发送成功，发送失败）',
  `add_time` int(11) DEFAULT NULL COMMENT '添加时间',
  `ip` int(11) DEFAULT NULL COMMENT 'IP地址',
  `remark` text COMMENT '备注',
  `Column_7` char(10) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='公告推送通知记录';

-- ----------------------------
-- Records of interest_notices_record
-- ----------------------------

-- ----------------------------
-- Table structure for interest_orders
-- ----------------------------
DROP TABLE IF EXISTS `interest_orders`;
CREATE TABLE `interest_orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ordersn` varchar(50) NOT NULL COMMENT '订单号',
  `outside_ordersn` varchar(50) DEFAULT NULL COMMENT '外部订单号',
  `content` text COMMENT '记录课程介绍或者内容信息',
  `user_id` int(11) DEFAULT NULL COMMENT '下单者ID（家长ID）',
  `course_id` int(11) DEFAULT NULL COMMENT '课程ID',
  `course_name` varchar(30) DEFAULT NULL COMMENT '课程名字',
  `status` int(11) DEFAULT NULL COMMENT '订单状态（0新订单，1缴费成功，2取消订单，3退款中，4退款成功）',
  `total` varchar(50) DEFAULT NULL COMMENT '价钱',
  `ip` int(11) DEFAULT NULL COMMENT 'IP地址',
  `add_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `pay_time` int(11) DEFAULT NULL COMMENT '下单时间',
  `remark` text COMMENT '备注',
  `pay_type` int(11) DEFAULT NULL COMMENT '支付方式（1微信，2支付宝，3银联）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='管理订单信息';

-- ----------------------------
-- Records of interest_orders
-- ----------------------------

-- ----------------------------
-- Table structure for interest_orders_status
-- ----------------------------
DROP TABLE IF EXISTS `interest_orders_status`;
CREATE TABLE `interest_orders_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL COMMENT '更改者ID（家长ID）',
  `course_id` int(11) DEFAULT NULL COMMENT '课程ID',
  `content` text COMMENT '更改课程状态的描述',
  `status` int(11) DEFAULT NULL COMMENT '订单状态（0新订单，1缴费成功，2取消订单，3退款中，4退款成功）',
  `add_time` int(11) DEFAULT NULL COMMENT '添加时间',
  `ip` int(11) DEFAULT NULL COMMENT 'IP地址',
  `remark` text COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='管理订单状态记录表';

-- ----------------------------
-- Records of interest_orders_status
-- ----------------------------

-- ----------------------------
-- Table structure for interest_pages
-- ----------------------------
DROP TABLE IF EXISTS `interest_pages`;
CREATE TABLE `interest_pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT NULL COMMENT '标题',
  `content` text COMMENT '内容',
  `thumb` text COMMENT '缩略图',
  `status` tinyint(1) DEFAULT NULL COMMENT '状态',
  `sort` varchar(10) DEFAULT NULL COMMENT '排序',
  `isuser` tinyint(1) DEFAULT NULL COMMENT '是否在用户中心显示',
  `add_time` int(11) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='管理【中心介绍,联系我们，首页】内容';

-- ----------------------------
-- Records of interest_pages
-- ----------------------------
INSERT INTO `interest_pages` VALUES ('1', '中心介绍', '安师大', '1', '1', '1', '1', '1147483647');
INSERT INTO `interest_pages` VALUES ('2', '联系我', '--------------坚持--------------------', null, '1', '2', '1', '1560475026');

-- ----------------------------
-- Table structure for interest_posts
-- ----------------------------
DROP TABLE IF EXISTS `interest_posts`;
CREATE TABLE `interest_posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` tinyint(4) NOT NULL COMMENT '帖子类型（自由讨论、助人为乐、功课讨论、家事百科）',
  `title` varchar(50) NOT NULL COMMENT '标题',
  `content` text COMMENT '帖子内容',
  `user_id` int(11) DEFAULT NULL COMMENT '发帖者ID',
  `praise` int(11) DEFAULT NULL COMMENT '点赞数',
  `add_time` int(11) DEFAULT NULL COMMENT '添加时间',
  `ip` int(11) DEFAULT NULL COMMENT 'IP地址',
  `remark` text COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='管理帖子内容';

-- ----------------------------
-- Records of interest_posts
-- ----------------------------

-- ----------------------------
-- Table structure for interest_scale
-- ----------------------------
DROP TABLE IF EXISTS `interest_scale`;
CREATE TABLE `interest_scale` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL COMMENT '积分比例',
  `point` text COMMENT '比例',
  `add_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `remark` text COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='积分比例';

-- ----------------------------
-- Records of interest_scale
-- ----------------------------

-- ----------------------------
-- Table structure for interest_stu_attend
-- ----------------------------
DROP TABLE IF EXISTS `interest_stu_attend`;
CREATE TABLE `interest_stu_attend` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(9) DEFAULT NULL COMMENT '用户ID',
  `sign_time` varchar(20) NOT NULL COMMENT '签到时间',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态',
  `ip` varchar(20) DEFAULT NULL COMMENT 'IP地址',
  `add_time` int(11) DEFAULT NULL COMMENT '添加时间',
  `remark` text COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='学生考勤表';

-- ----------------------------
-- Records of interest_stu_attend
-- ----------------------------

-- ----------------------------
-- Table structure for interest_timeline
-- ----------------------------
DROP TABLE IF EXISTS `interest_timeline`;
CREATE TABLE `interest_timeline` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) NOT NULL COMMENT '課程ID',
  `coach_id` int(11) DEFAULT NULL COMMENT '教練ID',
  `week` int(11) DEFAULT NULL COMMENT '周一到周五（如1，周一）',
  `timeline` varchar(50) DEFAULT NULL COMMENT '时间安排（如9：00-11：00）',
  `add_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `start_time` int(11) DEFAULT NULL COMMENT '每节课的上课时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='安排课程时间段';

-- ----------------------------
-- Records of interest_timeline
-- ----------------------------

-- ----------------------------
-- Table structure for interest_user
-- ----------------------------
DROP TABLE IF EXISTS `interest_user`;
CREATE TABLE `interest_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` tinyint(4) NOT NULL COMMENT '用户类型（家长1、学生2）',
  `nickname` varchar(20) NOT NULL COMMENT '姓名',
  `username` varchar(20) DEFAULT NULL COMMENT '用户账号',
  `pwd` varchar(20) DEFAULT NULL COMMENT '用户密码',
  `sex` bit(1) DEFAULT NULL COMMENT '性别',
  `age` int(11) DEFAULT NULL COMMENT '年龄',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `tel` varchar(50) DEFAULT NULL COMMENT '电话',
  `user_qrcode` text COMMENT '学生二维码',
  `add_time` int(11) DEFAULT NULL COMMENT '添加时间',
  `ip` varchar(20) DEFAULT NULL COMMENT 'IP地址',
  `remark` text COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户表';

-- ----------------------------
-- Records of interest_user
-- ----------------------------
INSERT INTO `interest_user` VALUES ('1', '1', '潘大臣', 'pdc', 'e10adc3949ba59abbe56', '
', '33', '512837965@qq.com', '13750088640', 'qrcode\\1559814532.jpg', '1559702996', '127.0.0.1', null);
INSERT INTO `interest_user` VALUES ('2', '2', '潘小福', 'pxf', 'e10adc3949ba59abbe56', '
', '7', '', '', 'qrcode\\1559815332.jpg', '1559703500', '127.0.0.1', null);