text: -- phpMyAdmin SQL Dump
  -- version 4.8.1
  -- https://www.phpmyadmin.net/
  --
  -- Host: localhost
  -- Generation Time: 2019-07-09 11:19:06
  -- 服务器版本： 5.5.60
  -- PHP Version: 5.6.36
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  START TRANSACTION;
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Database: `jlp_tplay`
  --
  
  -- --------------------------------------------------------
  
  --
  -- 表的结构 `tplay_admin`
  --
  
  CREATE TABLE `tplay_admin` (
    `id` int(11) NOT NULL,
    `nickname` varchar(20) DEFAULT NULL COMMENT '昵称',
    `name` varchar(100) NOT NULL,
    `password` varchar(255) NOT NULL,
    `thumb` int(11) NOT NULL DEFAULT '1' COMMENT '管理员头像',
    `create_time` int(11) NOT NULL COMMENT '创建时间',
    `update_time` int(11) NOT NULL COMMENT '修改时间',
    `login_time` int(11) DEFAULT NULL COMMENT '最后登录时间',
    `login_ip` varchar(100) DEFAULT NULL COMMENT '最后登录ip',
    `admin_cate_id` int(2) NOT NULL DEFAULT '1' COMMENT '管理员分组'
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- 转存表中的数据 `tplay_admin`
  --
  
  INSERT INTO `tplay_admin` (`id`, `nickname`, `name`, `password`, `thumb`, `create_time`, `update_time`, `login_time`, `login_ip`, `admin_cate_id`) VALUES
  (1, 'admin', 'admin', '153441086ce450f9b62643cf4830698e', 2, 1510885948, 1560492763, 1562564446, '124.126.0.243', 1),
  (16, 'JLP', 'JLP_admin', 'a12e8c72ed4dff67d8bb21956fd51440', 5, 1560493985, 1561032008, 1562307647, '124.126.3.188', 20),
  (17, '金立品学服', 'jlp_xf_admin', 'a12e8c72ed4dff67d8bb21956fd51440', 10, 1562298601, 1562298601, 1562298636, '124.126.3.188', 21);
  
  -- --------------------------------------------------------
  
  --
  -- 表的结构 `tplay_admin_cate`
  --
  
  CREATE TABLE `tplay_admin_cate` (
    `id` int(11) NOT NULL,
    `name` varchar(100) NOT NULL,
    `permissions` text COMMENT '权限菜单',
    `create_time` int(11) NOT NULL,
    `update_time` int(11) NOT NULL,
    `desc` text COMMENT '备注'
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- 转存表中的数据 `tplay_admin_cate`
  --
  
  INSERT INTO `tplay_admin_cate` (`id`, `name`, `permissions`, `create_time`, `update_time`, `desc`) VALUES
  (1, '超级管理员', '51,4,5,6,7,8,9,11,13,14,16,17,19,20,21,25,26,28,29,34,35,37,38,39,40,41,42,43,44,45,47,48,52,55,56,58', 0, 1562303617, '超级管理员，拥有最高权限！'),
  (20, '销售系统管理员', '6,7,8,34,35,37,38,39,40,42,43,44,45,47,48,55,56,58', 1560493824, 1562307368, '销售系统管理员'),
  (21, '学服系统管理员', '6,7,8,56,58', 1562298323, 1562303541, '学服系统管理员');
  
  -- --------------------------------------------------------
  
  --
  -- 表的结构 `tplay_admin_log`
  --
  
  CREATE TABLE `tplay_admin_log` (
    `id` int(11) NOT NULL,
    `admin_menu_id` int(11) NOT NULL COMMENT '操作菜单id',
    `admin_id` int(11) NOT NULL COMMENT '操作者id',
    `ip` varchar(100) DEFAULT NULL COMMENT '操作ip',
    `operation_id` varchar(200) DEFAULT NULL COMMENT '操作关联id',
    `create_time` int(11) NOT NULL COMMENT '操作时间'
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- 转存表中的数据 `tplay_admin_log`
  --
  
  INSERT INTO `tplay_admin_log` (`id`, `admin_menu_id`, `admin_id`, `ip`, `operation_id`, `create_time`) VALUES
  (1, 50, 1, '127.0.0.1', '', 1560492491),
  (2, 49, 1, '127.0.0.1', '2', 1560492578),
  (3, 7, 1, '127.0.0.1', '1', 1560492580),
  (4, 8, 1, '127.0.0.1', '', 1560492616),
  (5, 50, 1, '127.0.0.1', '', 1560492639),
  (6, 11, 1, '127.0.0.1', '', 1560492690),
  (7, 11, 1, '127.0.0.1', '', 1560492711),
  (8, 25, 1, '127.0.0.1', '1', 1560492751),
  (9, 7, 1, '127.0.0.1', '1', 1560492763),
  (10, 49, 1, '127.0.0.1', '3', 1560492809),
  (11, 4, 1, '127.0.0.1', '52', 1560493222),
  (12, 4, 1, '127.0.0.1', '52', 1560493284),
  (13, 28, 1, '127.0.0.1', '20', 1560493824),
  (14, 49, 1, '127.0.0.1', '4', 1560493926),
  (15, 49, 1, '127.0.0.1', '5', 1560493938),
  (16, 25, 1, '127.0.0.1', '16', 1560493985),
  (17, 50, 16, '127.0.0.1', '', 1560494012),
  (18, 50, 1, '127.0.0.1', '', 1560494058),
  (19, 28, 1, '127.0.0.1', '20', 1560494143),
  (20, 49, 16, '127.0.0.1', '6', 1560494207),
  (21, 49, 16, '127.0.0.1', '7', 1560494213),
  (22, 50, 16, '127.0.0.1', '', 1560494361),
  (23, 50, 1, '127.0.0.1', '', 1560494573),
  (24, 4, 1, '127.0.0.1', '53', 1560494809),
  (25, 4, 1, '127.0.0.1', '54', 1560494901),
  (26, 4, 1, '127.0.0.1', '54', 1560494921),
  (27, 4, 1, '127.0.0.1', '54', 1560494970),
  (28, 4, 1, '127.0.0.1', '54', 1560495065),
  (29, 4, 1, '127.0.0.1', '55', 1560495379),
  (30, 50, 1, '127.0.0.1', '', 1560739256),
  (31, 50, 1, '127.0.0.1', '', 1560748907),
  (32, 50, 1, '127.0.0.1', '', 1560749012),
  (33, 4, 1, '127.0.0.1', '55', 1560761869),
  (34, 4, 1, '127.0.0.1', '55', 1560761901),
  (35, 42, 1, '127.0.0.1', '7', 1560767939),
  (36, 50, 1, '127.0.0.1', '', 1560822311),
  (37, 49, 1, '127.0.0.1', '8', 1560827102),
  (38, 49, 1, '127.0.0.1', '9', 1560827120),
  (39, 50, 16, '127.0.0.1', '', 1560828860),
  (40, 50, 1, '127.0.0.1', '', 1560829097),
  (41, 50, 1, '124.126.1.197', '', 1560910625),
  (42, 25, 1, '124.126.1.197', '16', 1561032008),
  (43, 28, 1, '124.126.1.197', '20', 1561034146),
  (44, 50, 16, '124.126.1.197', '', 1561034172),
  (45, 8, 16, '124.126.1.197', '', 1561034211),
  (46, 50, 16, '124.126.1.197', '', 1561034245),
  (47, 50, 16, '124.126.1.197', '', 1561081131),
  (48, 50, 16, '124.126.1.197', '', 1561082640),
  (49, 50, 1, '124.126.1.197', '', 1561110404),
  (50, 50, 16, '124.126.3.188', '', 1562225417),
  (51, 50, 1, '124.126.3.188', '', 1562297272),
  (52, 4, 1, '124.126.3.188', '56', 1562298107),
  (53, 4, 1, '124.126.3.188', '56', 1562298148),
  (54, 4, 1, '124.126.3.188', '57', 1562298199),
  (55, 4, 1, '124.126.3.188', '58', 1562298234),
  (56, 28, 1, '124.126.3.188', '20', 1562298289),
  (57, 28, 1, '124.126.3.188', '21', 1562298323),
  (58, 49, 1, '124.126.3.188', '10', 1562298552),
  (59, 25, 1, '124.126.3.188', '17', 1562298601),
  (60, 50, 17, '124.126.3.188', '', 1562298636),
  (61, 50, 1, '124.126.3.188', '', 1562299358),
  (62, 4, 1, '124.126.3.188', '3', 1562299423),
  (63, 4, 1, '124.126.3.188', '3', 1562299429),
  (64, 4, 1, '124.126.3.188', '3', 1562299441),
  (65, 4, 1, '124.126.3.188', '9', 1562299505),
  (66, 28, 1, '124.126.3.188', '1', 1562299533),
  (67, 11, 1, '124.126.3.188', '', 1562299549),
  (68, 4, 1, '124.126.3.188', '23', 1562299591),
  (69, 4, 1, '124.126.3.188', '22', 1562299616),
  (70, 4, 1, '124.126.3.188', '24', 1562299632),
  (71, 4, 1, '124.126.3.188', '27', 1562299644),
  (72, 4, 1, '124.126.3.188', '41', 1562299655),
  (73, 4, 1, '124.126.3.188', '27', 1562299688),
  (74, 4, 1, '124.126.3.188', '22', 1562303261),
  (75, 4, 1, '124.126.3.188', '23', 1562303285),
  (76, 4, 1, '124.126.3.188', '24', 1562303350),
  (77, 28, 1, '124.126.3.188', '1', 1562303450),
  (78, 28, 1, '124.126.3.188', '1', 1562303461),
  (79, 28, 1, '124.126.3.188', '1', 1562303478),
  (80, 28, 1, '124.126.3.188', '20', 1562303499),
  (81, 4, 1, '124.126.3.188', '55', 1562303513),
  (82, 28, 1, '124.126.3.188', '1', 1562303521),
  (83, 28, 1, '124.126.3.188', '20', 1562303531),
  (84, 28, 1, '124.126.3.188', '21', 1562303541),
  (85, 4, 1, '124.126.3.188', '52', 1562303606),
  (86, 28, 1, '124.126.3.188', '1', 1562303617),
  (87, 4, 1, '124.126.3.188', '46', 1562303653),
  (88, 4, 1, '124.126.3.188', '36', 1562303674),
  (89, 4, 1, '124.126.3.188', '32', 1562303692),
  (90, 28, 1, '124.126.3.188', '20', 1562307301),
  (91, 50, 16, '124.126.3.188', '', 1562307333),
  (92, 28, 1, '124.126.3.188', '20', 1562307368),
  (93, 50, 16, '124.126.3.188', '', 1562307647),
  (94, 50, 1, '124.126.0.243', '', 1562564446);
  
  -- --------------------------------------------------------
  
  --
  -- 表的结构 `tplay_admin_menu`
  --
  
  CREATE TABLE `tplay_admin_menu` (
    `id` int(11) NOT NULL,
    `name` varchar(50) NOT NULL,
    `module` varchar(50) NOT NULL COMMENT '模块',
    `controller` varchar(100) NOT NULL COMMENT '控制器',
    `function` varchar(100) NOT NULL COMMENT '方法',
    `parameter` varchar(50) DEFAULT NULL COMMENT '参数',
    `description` varchar(250) DEFAULT NULL COMMENT '描述',
    `is_display` int(1) NOT NULL DEFAULT '1' COMMENT '1显示在左侧菜单2只作为节点',
    `type` int(1) NOT NULL DEFAULT '1' COMMENT '1权限节点2普通节点',
    `pid` int(11) NOT NULL DEFAULT '0' COMMENT '上级菜单0为顶级菜单',
    `create_time` int(11) NOT NULL,
    `update_time` int(11) NOT NULL,
    `icon` varchar(100) DEFAULT NULL COMMENT '图标',
    `is_open` int(1) NOT NULL DEFAULT '0' COMMENT '0默认闭合1默认展开',
    `orders` int(11) NOT NULL DEFAULT '0' COMMENT '排序值，越小越靠前'
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='系统菜单表';
  
  --
  -- 转存表中的数据 `tplay_admin_menu`
  --
  
  INSERT INTO `tplay_admin_menu` (`id`, `name`, `module`, `controller`, `function`, `parameter`, `description`, `is_display`, `type`, `pid`, `create_time`, `update_time`, `icon`, `is_open`, `orders`) VALUES
  (1, '系统', '', '', '', '', '系统设置。', 1, 2, 0, 0, 1517015748, 'fa-cog', 1, 0),
  (2, '菜单', '', '', '', '', '菜单管理。', 1, 2, 1, 0, 1517015764, 'fa-paw', 0, 0),
  (51, '系统菜单排序', 'admin', 'menu', 'orders', '', '系统菜单排序。', 2, 1, 3, 1517562047, 1517562047, '', 0, 0),
  (3, '系统菜单', 'admin', 'menu', 'index', '', '系统菜单管理', 1, 2, 2, 0, 1562299441, 'fa-share-alt', 0, 0),
  (4, '新增/修改系统菜单', 'admin', 'menu', 'publish', '', '新增/修改系统菜单.', 2, 1, 3, 1516948769, 1516948769, '', 0, 0),
  (5, '删除系统菜单', 'admin', 'menu', 'delete', '', '删除系统菜单。', 2, 1, 3, 1516948857, 1516948857, '', 0, 0),
  (6, '个人', '', '', '', '', '个人信息管理。', 1, 1, 1, 1516949308, 1517021986, 'fa-user', 0, 0),
  (7, '个人信息', 'admin', 'admin', 'personal', '', '个人信息修改。', 1, 1, 6, 1516949435, 1516949435, 'fa-user', 0, 0),
  (8, '修改密码', 'admin', 'admin', 'editpassword', '', '管理员修改个人密码。', 1, 1, 6, 1516949702, 1517619887, 'fa-unlock-alt', 0, 0),
  (9, '设置', '', '', '', '', '系统相关设置。', 1, 1, 1, 1516949853, 1562299505, 'fa-cog', 0, 0),
  (10, '网站设置', 'admin', 'webconfig', 'index', '', '网站相关设置首页。', 1, 2, 9, 1516949994, 1516949994, 'fa-bullseye', 0, 0),
  (11, '修改网站设置', 'admin', 'webconfig', 'publish', '', '修改网站设置。', 2, 1, 10, 1516950047, 1516950047, '', 0, 0),
  (12, '邮件设置', 'admin', 'emailconfig', 'index', '', '邮件配置首页。', 1, 2, 9, 1516950129, 1516950129, 'fa-envelope', 0, 0),
  (13, '修改邮件设置', 'admin', 'emailconfig', 'publish', '', '修改邮件设置。', 2, 1, 12, 1516950215, 1516950215, '', 0, 0),
  (14, '发送测试邮件', 'admin', 'emailconfig', 'mailto', '', '发送测试邮件。', 2, 1, 12, 1516950295, 1516950295, '', 0, 0),
  (15, '短信设置', 'admin', 'smsconfig', 'index', '', '短信设置首页。', 1, 2, 9, 1516950394, 1516950394, 'fa-comments', 0, 0),
  (16, '修改短信设置', 'admin', 'smsconfig', 'publish', '', '修改短信设置。', 2, 1, 15, 1516950447, 1516950447, '', 0, 0),
  (17, '发送测试短信', 'admin', 'smsconfig', 'smsto', '', '发送测试短信。', 2, 1, 15, 1516950483, 1516950483, '', 0, 0),
  (18, 'URL 设置', 'admin', 'urlsconfig', 'index', '', 'url 设置。', 1, 2, 9, 1516950738, 1516950804, 'fa-code-fork', 0, 0),
  (19, '新增/修改url设置', 'admin', 'urlsconfig', 'publish', '', '新增/修改url设置。', 2, 1, 18, 1516950850, 1516950850, '', 0, 0),
  (20, '启用/禁用url美化', 'admin', 'urlsconfig', 'status', '', '启用/禁用url美化。', 2, 1, 18, 1516950909, 1516950909, '', 0, 0),
  (21, ' 删除url美化规则', 'admin', 'urlsconfig', 'delete', '', ' 删除url美化规则。', 2, 1, 18, 1516950941, 1516950941, '', 0, 0),
  (22, '会员', '', '', '', '', '会员管理。', 1, 2, 0, 1516950991, 1562303261, 'fa-users', 0, 0),
  (23, '管理员', '', '', '', '', '系统管理员管理。', 1, 2, 22, 1516951071, 1562303285, 'fa-user', 0, 0),
  (24, '管理员', 'admin', 'admin', 'index', '', '系统管理员列表。', 1, 2, 23, 1516951163, 1562303350, 'fa-user', 0, 0),
  (25, '新增/修改管理员', 'admin', 'admin', 'publish', '', '新增/修改系统管理员。', 2, 1, 24, 1516951224, 1516951224, '', 0, 0),
  (26, '删除管理员', 'admin', 'admin', 'delete', '', '删除管理员。', 2, 1, 24, 1516951253, 1516951253, '', 0, 0),
  (27, '权限组', 'admin', 'admin', 'admincate', '', '权限分组。', 1, 2, 23, 1516951353, 1562299688, 'fa-dot-circle-o', 0, 0),
  (28, '新增/修改权限组', 'admin', 'admin', 'admincatepublish', '', '新增/修改权限组。', 2, 1, 27, 1516951483, 1516951483, '', 0, 0),
  (29, '删除权限组', 'admin', 'admin', 'admincatedelete', '', '删除权限组。', 2, 1, 27, 1516951515, 1516951515, '', 0, 0),
  (30, '操作日志', 'admin', 'admin', 'log', '', '系统管理员操作日志。', 1, 2, 23, 1516951754, 1517018196, 'fa-pencil', 0, 0),
  (31, '内容', '', '', '', '', '内容管理。', 1, 2, 0, 1516952262, 1517015835, 'fa-th-large', 0, 0),
  (32, '文章', '', '', '', '', '文章相关管理。', 1, 1, 31, 1516952698, 1562303692, 'fa-bookmark', 0, 0),
  (33, '分类', 'admin', 'articlecate', 'index', '', '文章分类管理。', 1, 2, 32, 1516952856, 1516952856, 'fa-tag', 0, 0),
  (34, '新增/修改文章分类', 'admin', 'articlecate', 'publish', '', '新增/修改文章分类。', 2, 1, 33, 1516952896, 1516952896, '', 0, 0),
  (35, '删除文章分类', 'admin', 'articlecate', 'delete', '', '删除文章分类。', 2, 1, 33, 1516952942, 1516952942, '', 0, 0),
  (36, '文章', 'admin', 'article', 'index', '', '文章管理。', 1, 1, 32, 1516953011, 1562303674, 'fa-bookmark', 0, 0),
  (37, '新增/修改文章', 'admin', 'article', 'publish', '', '新增/修改文章。', 2, 1, 36, 1516953056, 1516953056, '', 0, 0),
  (38, '审核/拒绝文章', 'admin', 'article', 'status', '', '审核/拒绝文章。', 2, 1, 36, 1516953113, 1516953113, '', 0, 0),
  (39, '置顶/取消置顶文章', 'admin', 'article', 'is_top', '', '置顶/取消置顶文章。', 2, 1, 36, 1516953162, 1516953162, '', 0, 0),
  (40, '删除文章', 'admin', 'article', 'delete', '', '删除文章。', 2, 1, 36, 1516953183, 1516953183, '', 0, 0),
  (41, '附件', 'admin', 'attachment', 'index', '', '附件管理。', 1, 1, 31, 1516953306, 1562299655, 'fa-cube', 0, 0),
  (42, '附件审核', 'admin', 'attachment', 'audit', '', '附件审核。', 2, 1, 41, 1516953359, 1516953440, '', 0, 0),
  (43, '附件上传', 'admin', 'attachment', 'upload', '', '附件上传。', 2, 1, 41, 1516953392, 1516953392, '', 0, 0),
  (44, '附件下载', 'admin', 'attachment', 'download', '', '附件下载。', 2, 1, 41, 1516953430, 1516953430, '', 0, 0),
  (45, '附件删除', 'admin', 'attachment', 'delete', '', '附件删除。', 2, 1, 41, 1516953477, 1516953477, '', 0, 0),
  (46, '留言', 'admin', 'tomessages', 'index', '', '留言管理。', 1, 1, 31, 1516953526, 1562303653, 'fa-comments', 0, 0),
  (47, '留言处理', 'admin', 'tomessages', 'mark', '', '留言处理。', 2, 1, 46, 1516953605, 1516953605, '', 0, 0),
  (48, '留言删除', 'admin', 'tomessages', 'delete', '', '留言删除。', 2, 1, 46, 1516953648, 1516953648, '', 0, 0),
  (49, '图片上传', 'admin', 'common', 'upload', '', '图片上传。', 2, 2, 0, 1516954491, 1516954491, '', 0, 0),
  (50, '管理员登录', 'admin', 'common', 'login', '', '管理员登录。', 2, 2, 0, 1516954517, 1516954517, '', 0, 0),
  (52, '数据分析', '', '', '', '', '数据分析管理。', 1, 1, 31, 1560493222, 1562303606, 'fa-area-chart ', 0, 0),
  (53, '文章数据', '', '', '', '', '文章数据分析', 1, 2, 52, 1560494809, 1560494809, 'fa-file-text', 0, 0),
  (54, '报名数据', '', '', '', '', '报名数据分析', 1, 2, 52, 1560494901, 1560495065, 'fa-address-book ', 0, 0),
  (55, '报名列表', 'admin', 'register', 'index', '', '报名列表', 1, 1, 31, 1560495379, 1562303513, 'fa-cubes ', 0, 0),
  (56, '生日贺卡', '', '', '', '', '生日贺卡模块', 1, 1, 31, 1562298107, 1562298148, 'fa fa-credit-card', 0, 0),
  (57, '贺卡配置', 'admin', 'birthday', 'card_config', '', '生日贺卡配置信息', 1, 1, 56, 1562298199, 1562298199, 'fa fa-cog fa-fw', 0, 0),
  (58, '贺卡列表', 'admin', 'birthday', 'card_list', '', '贺卡列表', 1, 1, 56, 1562298234, 1562298234, 'fa fa-list-alt ', 0, 0);
  
  -- --------------------------------------------------------
  
  --
  -- 表的结构 `tplay_article`
  --
  
  CREATE TABLE `tplay_article` (
    `id` int(11) NOT NULL,
    `title` varchar(255) NOT NULL,
    `tag` varchar(255) DEFAULT NULL,
    `description` varchar(255) DEFAULT NULL,
    `article_cate_id` int(11) NOT NULL,
    `thumb` int(11) DEFAULT NULL,
    `content` text,
    `admin_id` int(11) NOT NULL,
    `create_time` int(11) NOT NULL,
    `update_time` int(11) NOT NULL,
    `edit_admin_id` int(11) NOT NULL COMMENT '最后修改人',
    `status` int(1) NOT NULL DEFAULT '0' COMMENT '0待审核1已审核',
    `is_top` int(1) NOT NULL DEFAULT '0' COMMENT '1置顶0普通'
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- 表的结构 `tplay_article_cate`
  --
  
  CREATE TABLE `tplay_article_cate` (
    `id` int(11) NOT NULL,
    `name` varchar(100) NOT NULL,
    `tag` varchar(250) DEFAULT NULL COMMENT '关键词',
    `description` varchar(250) DEFAULT NULL,
    `create_time` int(11) NOT NULL,
    `update_time` int(11) NOT NULL,
    `pid` int(11) NOT NULL DEFAULT '0'
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- 表的结构 `tplay_attachment`
  --
  
  CREATE TABLE `tplay_attachment` (
    `id` int(10) UNSIGNED NOT NULL,
    `module` char(15) NOT NULL DEFAULT '' COMMENT '所属模块',
    `filename` char(50) NOT NULL DEFAULT '' COMMENT '文件名',
    `filepath` char(200) NOT NULL DEFAULT '' COMMENT '文件路径+文件名',
    `filesize` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '文件大小',
    `fileext` char(10) NOT NULL DEFAULT '' COMMENT '文件后缀',
    `user_id` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '会员ID',
    `uploadip` char(15) NOT NULL DEFAULT '' COMMENT '上传IP',
    `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0未审核1已审核-1不通过',
    `create_time` int(11) UNSIGNED NOT NULL DEFAULT '0',
    `admin_id` int(11) NOT NULL COMMENT '审核者id',
    `audit_time` int(11) NOT NULL COMMENT '审核时间',
    `use` varchar(200) DEFAULT NULL COMMENT '用处',
    `download` int(11) NOT NULL DEFAULT '0' COMMENT '下载量'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='附件表' ROW_FORMAT=DYNAMIC;
  
  --
  -- 转存表中的数据 `tplay_attachment`
  --
  
  INSERT INTO `tplay_attachment` (`id`, `module`, `filename`, `filepath`, `filesize`, `fileext`, `user_id`, `uploadip`, `status`, `create_time`, `admin_id`, `audit_time`, `use`, `download`) VALUES
  (1, 'admin', '79811855a6c06de53047471c4ff82a36.jpg', '\\uploads\\admin\\admin_thumb\\20180104\\79811855a6c06de53047471c4ff82a36.jpg', 13781, 'jpg', 1, '127.0.0.1', 1, 1515046060, 1, 1515046060, 'admin_thumb', 0),
  (2, 'admin', 'c1313819fd18690f364394b26d0c35e2.png', '\\uploads\\admin\\admin_thumb\\20190614\\c1313819fd18690f364394b26d0c35e2.png', 9704, 'png', 1, '127.0.0.1', 1, 1560492578, 1, 1560492578, 'admin_thumb', 0),
  (3, 'admin', '97b9af50166460d110fb7faa2eec0513.png', '\\uploads\\admin\\article_thumb\\20190614\\97b9af50166460d110fb7faa2eec0513.png', 9704, 'png', 1, '127.0.0.1', 1, 1560492809, 1, 1560492809, 'article_thumb', 0),
  (4, 'admin', 'b241afc39addb75261efcba1a0d971ae.jpg', '\\uploads\\admin\\admin_thumb\\20190614\\b241afc39addb75261efcba1a0d971ae.jpg', 43008, 'jpg', 1, '127.0.0.1', 1, 1560493926, 1, 1560493926, 'admin_thumb', 0),
  (5, 'admin', '29363d0894f7f5b10b1fb45acef19ee6.jpg', '\\uploads\\admin\\admin_thumb\\20190614\\29363d0894f7f5b10b1fb45acef19ee6.jpg', 13280, 'jpg', 1, '127.0.0.1', 1, 1560493938, 1, 1560493938, 'admin_thumb', 0),
  (6, 'admin', 'b6fa434c649fc18975547dc2db5a25f4.jpg', '\\uploads\\admin\\article_thumb\\20190614\\b6fa434c649fc18975547dc2db5a25f4.jpg', 349100, 'jpg', 16, '127.0.0.1', 1, 1560494207, 16, 1560494207, 'article_thumb', 0),
  (7, 'admin', 'db42e32a847da7db13065231d88665b5.gif', '\\uploads\\admin\\article_thumb\\20190614\\db42e32a847da7db13065231d88665b5.gif', 22182, 'gif', 16, '127.0.0.1', 1, 1560494213, 0, 1560767939, 'article_thumb', 0),
  (8, 'admin', '287208de4388609d34b448490d07c0f6.jpg', '\\uploads\\admin\\admin_thumb\\20190618\\287208de4388609d34b448490d07c0f6.jpg', 213341, 'jpg', 1, '127.0.0.1', 1, 1560827102, 1, 1560827102, 'admin_thumb', 0),
  (9, 'admin', 'f4bf1d56a2b122137029b5712dd4d209.jpg', '\\uploads\\admin\\admin_thumb\\20190618\\f4bf1d56a2b122137029b5712dd4d209.jpg', 299148, 'jpg', 1, '127.0.0.1', 1, 1560827120, 1, 1560827120, 'admin_thumb', 0),
  (10, 'admin', 'b3f6363f1dafd0ca044f87705b088c3d.jpg', '/uploads/admin/admin_thumb/20190705/b3f6363f1dafd0ca044f87705b088c3d.jpg', 25879, 'jpg', 1, '124.126.3.188', 1, 1562298552, 1, 1562298552, 'admin_thumb', 0);
  
  -- --------------------------------------------------------
  
  --
  -- 表的结构 `tplay_birthday_list`
  --
  
  CREATE TABLE `tplay_birthday_list` (
    `id` int(11) NOT NULL COMMENT '流水ID',
    `username` varchar(100) NOT NULL COMMENT '会员昵称',
    `birthday_time` varchar(100) NOT NULL COMMENT '生日时间',
    `content` varchar(255) NOT NULL COMMENT '文案内容',
    `producers` varchar(100) NOT NULL COMMENT '出品方',
    `composite` varchar(255) NOT NULL COMMENT '合成链接',
    `visit_ip` text NOT NULL COMMENT 'ip访问记录',
    `visit_num` int(11) NOT NULL COMMENT '浏览次数',
    `create_time` datetime NOT NULL COMMENT '创建时间',
    `update_time` datetime NOT NULL COMMENT '更新时间'
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- 转存表中的数据 `tplay_birthday_list`
  --
  
  INSERT INTO `tplay_birthday_list` (`id`, `username`, `birthday_time`, `content`, `producers`, `composite`, `visit_ip`, `visit_num`, `create_time`, `update_time`) VALUES
  (1, '测试数据', '2019年12月03日', '', '金立品教育', '/birthday/card/cardview.html?user_id=1&keyword=JLP', '[{\"ip\":\"124.126.3.188\",\"create_time\":\"2019-07-05 11:55:01\",\"update_time\":\"2019-07-05 19:24:21\"},{\"ip\":\"122.7.199.254\",\"create_time\":\"2019-07-05 15:29:37\",\"update_time\":\"2019-07-05 15:29:37\"},{\"ip\":\"61.151.178.175\",\"create_time\":\"2019-07-05 19:13:47\",\"update_time\":\"2019-07-08 16:43:22\"},{\"ip\":\"101.89.29.94\",\"create_time\":\"2019-07-05 19:25:16\",\"update_time\":\"2019-07-05 19:25:16\"},{\"ip\":\"139.208.194.65\",\"create_time\":\"2019-07-06 08:30:26\",\"update_time\":\"2019-07-06 08:30:26\"},{\"ip\":\"61.148.245.244\",\"create_time\":\"2019-07-08 09:28:58\",\"update_time\":\"2019-07-08 09:29:07\"},{\"ip\":\"124.126.0.243\",\"create_time\":\"2019-07-08 09:29:24\",\"update_time\":\"2019-07-08 16:56:07\"},{\"ip\":\"61.129.6.151\",\"create_time\":\"2019-07-08 13:47:58\",\"update_time\":\"2019-07-08 13:47:58\"},{\"ip\":\"61.129.7.235\",\"create_time\":\"2019-07-08 13:48:51\",\"update_time\":\"2019-07-08 13:48:51\"},{\"ip\":\"183.61.51.64\",\"create_time\":\"2019-07-08 13:54:01\",\"update_time\":\"2019-07-08 13:54:01\"},{\"ip\":\"117.136.38.35\",\"create_time\":\"2019-07-08 13:55:11\",\"update_time\":\"2019-07-08 16:29:08\"},{\"ip\":\"180.97.118.223\",\"create_time\":\"2019-07-08 13:57:58\",\"update_time\":\"2019-07-08 13:57:58\"},{\"ip\":\"61.151.207.205\",\"create_time\":\"2019-07-08 14:00:11\",\"update_time\":\"2019-07-08 14:00:11\"},{\"ip\":\"117.136.38.162\",\"create_time\":\"2019-07-08 14:07:44\",\"update_time\":\"2019-07-08 14:14:21\"},{\"ip\":\"101.91.60.109\",\"create_time\":\"2019-07-08 14:16:06\",\"update_time\":\"2019-07-08 14:16:06\"},{\"ip\":\"101.91.62.99\",\"create_time\":\"2019-07-08 14:19:31\",\"update_time\":\"2019-07-08 14:19:31\"},{\"ip\":\"223.104.3.163\",\"create_time\":\"2019-07-08 15:39:29\",\"update_time\":\"2019-07-08 16:27:06\"},{\"ip\":\"183.61.51.55\",\"create_time\":\"2019-07-08 16:11:17\",\"update_time\":\"2019-07-08 16:11:17\"}]', 296, '2019-07-05 11:54:54', '2019-07-05 11:54:54'),
  (3, 'lisa', '2019年07月05日', '', '金品君', '/birthday/card/cardview.html?user_id=3&keyword=JLP', '', 0, '2019-07-05 14:21:48', '2019-07-05 14:21:48');
  
  -- --------------------------------------------------------
  
  --
  -- 表的结构 `tplay_emailconfig`
  --
  
  CREATE TABLE `tplay_emailconfig` (
    `email` varchar(5) NOT NULL COMMENT '邮箱配置标识',
    `from_email` varchar(50) NOT NULL COMMENT '邮件来源也就是邮件地址',
    `from_name` varchar(50) NOT NULL,
    `smtp` varchar(50) NOT NULL COMMENT '邮箱smtp服务器',
    `username` varchar(100) NOT NULL COMMENT '邮箱账号',
    `password` varchar(100) NOT NULL COMMENT '邮箱密码',
    `title` varchar(200) NOT NULL COMMENT '邮件标题',
    `content` text NOT NULL COMMENT '邮件模板'
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- 转存表中的数据 `tplay_emailconfig`
  --
  
  INSERT INTO `tplay_emailconfig` (`email`, `from_email`, `from_name`, `smtp`, `username`, `password`, `title`, `content`) VALUES
  ('email', '', '', '', '', '', '', '');
  
  -- --------------------------------------------------------
  
  --
  -- 表的结构 `tplay_messages`
  --
  
  CREATE TABLE `tplay_messages` (
    `id` int(11) NOT NULL,
    `create_time` int(11) NOT NULL,
    `ip` varchar(50) NOT NULL,
    `is_look` int(1) NOT NULL DEFAULT '0' COMMENT '0未读1已读',
    `message` text NOT NULL,
    `update_time` int(11) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- 表的结构 `tplay_question`
  --
  
  CREATE TABLE `tplay_question` (
    `id` int(11) NOT NULL COMMENT '流水id',
    `question_title` varchar(100) NOT NULL COMMENT '问卷调查title',
    `question_desc` varchar(255) DEFAULT NULL COMMENT '问卷调查描述',
    `question_config` text NOT NULL COMMENT '问卷调查配置信息',
    `question_lastdesc` varchar(200) NOT NULL COMMENT '表单末尾插入文本内容',
    `create_time` datetime NOT NULL COMMENT '创建时间',
    `update_time` datetime NOT NULL COMMENT '更新时间',
    `user_id` int(11) DEFAULT NULL COMMENT '编辑信息用户id',
    `ip` varchar(50) NOT NULL COMMENT '操作ip',
    `jump_type` int(11) NOT NULL COMMENT '提交后跳转方式（1：显示文字内容；2：跳转链接）',
    `jump_text` varchar(200) DEFAULT NULL COMMENT '提交跳转显示文字',
    `jump_href` varchar(200) DEFAULT NULL COMMENT '提交跳转链接'
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- 转存表中的数据 `tplay_question`
  --
  
  INSERT INTO `tplay_question` (`id`, `question_title`, `question_desc`, `question_config`, `question_lastdesc`, `create_time`, `update_time`, `user_id`, `ip`, `jump_type`, `jump_text`, `jump_href`) VALUES
  (1, 'ACCA学前评估', 'ACCA学前评估顾问通过你的问卷选择进行评估，评估内容包括：英语水平是否适合学习ACCA、未来ACCA学习进度情况、ACCA给你带来的影响，并提供适当建议。', '[{\"title\":\"\\u4f60\\u76ee\\u524d\\u804c\\u4e1a\\u662f\\u5b66\\u751f\\u3001\\u4e0a\\u73ed\\u65cf\\uff1f\",\"type\":\"radio\",\"not_null\":\"true\",\"value\":{\"1\":\"\\u5b66\\u751f\",\"2\":\"\\u4e0a\\u73ed\\u65cf\",\"3\":\"\\u5176\\u4ed6\"}},{\"title\":\"\\u4f60\\u7684\\u82f1\\u8bed\\u6c34\\u5e73\",\"type\":\"radio\",\"not_null\":\"true\",\"value\":{\"1\":\"\\u6ca1\\u8fc7\\u56db\\u7ea7\",\"2\":\"\\u56db\\u7ea7\",\"3\":\"\\u516d\\u7ea7\"}},{\"title\":\"\\u59d3\\u540d\",\"type\":\"input\",\"not_null\":\"true\",\"value\":[]},{\"title\":\"\\u624b\\u673a\\u53f7\\u7801\",\"type\":\"input\",\"not_null\":\"true\",\"value\":[]},{\"title\":\"\\u5e38\\u7528\\u90ae\\u7bb1\",\"type\":\"input\",\"not_null\":\"true\",\"value\":[]}]', '', '2019-06-18 11:00:18', '2019-06-18 16:59:06', 16, '127.0.0.1', 1, '您的答卷已经提交，感谢您的参与！', ''),
  (2, ' ACCA学习资料领取', '温馨提示：您提交信息之后，将自动跳转页面获取百度云盘链接，自行下载即可。\r\n\r\n*隐私申明：个人信息仅用于本测试，我们在未征得您事先同意的情况下，不会向第三方提供或泄露您的任何个人信息。', '[{\"title\":\"\\u59d3\\u540d\",\"type\":\"input\",\"not_null\":\"true\",\"value\":[]},{\"title\":\"\\u624b\\u673a\\u53f7\\u7801\",\"type\":\"input\",\"not_null\":\"true\",\"value\":[]},{\"title\":\"\\u5e38\\u7528\\u90ae\\u7bb1\",\"type\":\"input\",\"not_null\":\"true\",\"value\":[]},{\"title\":\"\\u5fae\\u4fe1\\u53f7\",\"type\":\"input\",\"not_null\":\"false\",\"value\":[]}]', '', '2019-06-18 11:10:33', '2019-06-18 11:10:33', 1, '127.0.0.1', 0, '您的答卷已经提交，感谢您的参与！\r\n链接: https://pan.baidu.com/s/1z1kuXta5cts7ZmC51UrxnA    提取码: m3af', ''),
  (3, '管理会计师CMA报考条件快速测试通道', '美国注册管理会计师简称\"CMA\"，它是目前全球管理会计及财务管理领域最权威的资格认证。在全球120个国家、200家地方分会中拥有超过68,000名会员，在中国的会员数超过10000名。拥有CMA，不仅代表其具备完整会计及财务相关领域知识，也表明了具备高度专业能力来分析企业内部经营状况、协助管理当局、参与集团财务管理、拟定未来策略、执行流程优化工作等。', '[{\"title\":\"\\u59d3\\u540d\",\"type\":\"input\",\"not_null\":\"true\",\"value\":[]},{\"title\":\"\\u6700\\u9ad8\\u5b66\\u5386\",\"type\":\"radio\",\"not_null\":\"true\",\"value\":{\"1\":\"\\u4e2d\\u4e13\",\"2\":\"\\u5927\\u4e13\",\"3\":\"\\u672c\\u79d1\",\"4\":\"\\u7814\\u7a76\\u751f\"}},{\"title\":\"\\u5de5\\u4f5c\\u5e74\\u9650\",\"type\":\"radio\",\"not_null\":\"true\",\"value\":{\"1\":\"\\u5927\\u5b66\\u5728\\u8bfb\",\"2\":\"1-3\\u5e74\",\"3\":\"3-5\\u5e74\",\"4\":\"5-10\\u5e74\",\"5\":\"10\\u5e74\\u4ee5\\u4e0a\"}},{\"title\":\"\\u6240\\u83b7\\u804c\\u79f0\",\"type\":\"input\",\"not_null\":\"false\",\"value\":[]},{\"title\":\"\\u624b\\u673a\\u53f7\\u7801\",\"type\":\"input\",\"not_null\":\"true\",\"value\":[]},{\"title\":\"\\u5e38\\u7528\\u90ae\\u7bb1\",\"type\":\"input\",\"not_null\":\"true\",\"value\":[]}]', '温馨提示：您提交信息之后，认证部老师将会在1个工作日内将结果发送给您，为确保结果准确，请如实填写。\r\n\r\n*隐私申明：个人信息仅用于本测试，我们在未征得您事先同意的情况下，不会向第三方提供或泄露您的任何个人信息。', '2019-06-18 11:25:56', '2019-06-18 11:25:56', 1, '127.0.0.1', 0, '您的答卷已经提交，感谢您的参与！', '');
  
  -- --------------------------------------------------------
  
  --
  -- 表的结构 `tplay_question_answer`
  --
  
  CREATE TABLE `tplay_question_answer` (
    `id` int(11) NOT NULL COMMENT '流水id',
    `question_id` varchar(255) NOT NULL COMMENT '问卷配置id',
    `answer_datas` text NOT NULL COMMENT '问卷回答内容 json 字串',
    `source` varchar(30) NOT NULL COMMENT '信息收集来源',
    `create_time` datetime NOT NULL COMMENT '提交时间',
    `update_time` datetime NOT NULL COMMENT '修改时间',
    `total_time` int(11) NOT NULL COMMENT '消耗时长',
    `ip` varchar(50) NOT NULL COMMENT '报名ip',
    `equipment` varchar(50) NOT NULL COMMENT '设备来源'
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- 转存表中的数据 `tplay_question_answer`
  --
  
  INSERT INTO `tplay_question_answer` (`id`, `question_id`, `answer_datas`, `source`, `create_time`, `update_time`, `total_time`, `ip`, `equipment`) VALUES
  (24, 'question_02', '[{\"title\":\"\\u59d3\\u540d\",\"value\":\"\\u772d\"},{\"title\":\"\\u624b\\u673a\\u53f7\\u7801\",\"value\":\"18248865772\"},{\"title\":\"\\u5e38\\u7528\\u90ae\\u7bb1\",\"value\":\"1652141917@qq.com\"},{\"title\":\"\\u5fae\\u4fe1\\u53f7\",\"value\":\"18248865772\"}]', ' ACCA学习资料领取', '2019-06-27 16:54:35', '0000-00-00 00:00:00', 84, '112.2.255.165', '微信浏览器'),
  (23, 'question_01', '[{\"title\":\"\\u4f60\\u76ee\\u524d\\u804c\\u4e1a\\u662f\\u5b66\\u751f\\u3001\\u4e0a\\u73ed\\u65cf\\uff1f\",\"value\":\"\\u4e0a\\u73ed\\u65cf\"},{\"title\":\"\\u4f60\\u7684\\u82f1\\u8bed\\u6c34\\u5e73\",\"value\":\"\\u6ca1\\u8fc7\\u56db\\u7ea7\"},{\"title\":\"\\u59d3\\u540d\",\"value\":\"\\u59dc\\u667a\\u9e4f\"},{\"title\":\"\\u624b\\u673a\\u53f7\\u7801\",\"value\":\"13579877853\"},{\"title\":\"\\u5e38\\u7528\\u90ae\\u7bb1\",\"value\":\"61754020@qq.com\"}]', 'ACCA学前评估', '2019-06-26 18:26:01', '0000-00-00 00:00:00', 24, '110.152.220.46', '微信浏览器'),
  (22, 'question_01', '[{\"title\":\"\\u4f60\\u76ee\\u524d\\u804c\\u4e1a\\u662f\\u5b66\\u751f\\u3001\\u4e0a\\u73ed\\u65cf\\uff1f\",\"value\":\"\\u4e0a\\u73ed\\u65cf\"},{\"title\":\"\\u4f60\\u7684\\u82f1\\u8bed\\u6c34\\u5e73\",\"value\":\"\\u6ca1\\u8fc7\\u56db\\u7ea7\"},{\"title\":\"\\u59d3\\u540d\",\"value\":\"\\u59dc\\u667a\\u9e4f\"},{\"title\":\"\\u624b\\u673a\\u53f7\\u7801\",\"value\":\"13579877853\"},{\"title\":\"\\u5e38\\u7528\\u90ae\\u7bb1\",\"value\":\"61754020@qq.com\"}]', 'ACCA学前评估', '2019-06-26 18:26:00', '0000-00-00 00:00:00', 23, '110.152.220.46', '微信浏览器'),
  (15, 'question_02', '[{\"title\":\"\\u59d3\\u540d\",\"value\":\"\\u80e1\\u7ade\\u4e88\"},{\"title\":\"\\u624b\\u673a\\u53f7\\u7801\",\"value\":\"15172249209\"},{\"title\":\"\\u5e38\\u7528\\u90ae\\u7bb1\",\"value\":\"1106483203@qq.com\"},{\"title\":\"\\u5fae\\u4fe1\\u53f7\",\"value\":\"hjy112189\"}]', ' ACCA学习资料领取', '2019-06-22 15:50:08', '0000-00-00 00:00:00', 63, '117.136.23.99', '微信浏览器');
  
  -- --------------------------------------------------------
  
  --
  -- 表的结构 `tplay_smsconfig`
  --
  
  CREATE TABLE `tplay_smsconfig` (
    `sms` varchar(10) NOT NULL DEFAULT 'sms' COMMENT '标识',
    `appkey` varchar(200) NOT NULL,
    `secretkey` varchar(200) NOT NULL,
    `type` varchar(100) DEFAULT 'normal' COMMENT '短信类型',
    `name` varchar(100) NOT NULL COMMENT '短信签名',
    `code` varchar(100) NOT NULL COMMENT '短信模板ID',
    `content` text NOT NULL COMMENT '短信默认模板'
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- 转存表中的数据 `tplay_smsconfig`
  --
  
  INSERT INTO `tplay_smsconfig` (`sms`, `appkey`, `secretkey`, `type`, `name`, `code`, `content`) VALUES
  ('sms', '', '', '', '', '', '');
  
  -- --------------------------------------------------------
  
  --
  -- 表的结构 `tplay_urlconfig`
  --
  
  CREATE TABLE `tplay_urlconfig` (
    `id` int(11) NOT NULL,
    `aliases` varchar(200) NOT NULL COMMENT '想要设置的别名',
    `url` varchar(200) NOT NULL COMMENT '原url结构',
    `desc` text COMMENT '备注',
    `status` int(1) NOT NULL DEFAULT '1' COMMENT '0禁用1使用',
    `create_time` int(11) NOT NULL,
    `update_time` int(11) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- 转存表中的数据 `tplay_urlconfig`
  --
  
  INSERT INTO `tplay_urlconfig` (`id`, `aliases`, `url`, `desc`, `status`, `create_time`, `update_time`) VALUES
  (1, 'admin_login', 'admin/common/login', '后台登录地址。', 0, 1517621629, 1517621629);
  
  -- --------------------------------------------------------
  
  --
  -- 表的结构 `tplay_webconfig`
  --
  
  CREATE TABLE `tplay_webconfig` (
    `web` varchar(20) NOT NULL COMMENT '网站配置标识',
    `name` varchar(200) NOT NULL COMMENT '网站名称',
    `keywords` text COMMENT '关键词',
    `desc` text COMMENT '描述',
    `is_log` int(1) NOT NULL DEFAULT '1' COMMENT '1开启日志0关闭',
    `file_type` varchar(200) DEFAULT NULL COMMENT '允许上传的类型',
    `file_size` bigint(20) DEFAULT NULL COMMENT '允许上传的最大值',
    `statistics` text COMMENT '统计代码',
    `black_ip` text COMMENT 'ip黑名单',
    `url_suffix` varchar(20) DEFAULT NULL COMMENT 'url伪静态后缀'
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- 转存表中的数据 `tplay_webconfig`
  --
  
  INSERT INTO `tplay_webconfig` (`web`, `name`, `keywords`, `desc`, `is_log`, `file_type`, `file_size`, `statistics`, `black_ip`, `url_suffix`) VALUES
  ('web', 'Tplay后台管理框架', 'Tplay,后台管理,thinkphp5,layui', 'Tplay是一款基于ThinkPHP5.0.12 + layui2.2.45 + ECharts + Mysql开发的后台管理框架，集成了一般应用所必须的基础性功能，为开发者节省大量的时间。', 1, 'jpg,png,gif,mp4,zip,jpeg,aac', 500, '', '', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- 表的结构 `tplay_wx_access_token`
  --
  
  CREATE TABLE `tplay_wx_access_token` (
    `id` int(11) NOT NULL,
    `access_token` varchar(255) NOT NULL COMMENT 'access_token',
    `refresh_token` varchar(255) NOT NULL COMMENT '刷新获取access_token',
    `ticket` varchar(255) NOT NULL COMMENT 'jssdk_ticket',
    `create_time` datetime NOT NULL COMMENT '创建时间',
    `cut_time` datetime NOT NULL COMMENT '到期时间',
    `status` int(11) NOT NULL COMMENT 'access_token 状态（1：普通token；2：授权token；3：js_token）',
    `openid` varchar(100) NOT NULL COMMENT '用户openid'
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- 转存表中的数据 `tplay_wx_access_token`
  --
  
  INSERT INTO `tplay_wx_access_token` (`id`, `access_token`, `refresh_token`, `ticket`, `create_time`, `cut_time`, `status`, `openid`) VALUES
  (154, '22_dNdvzayOS2czsAhswYi26JYFOIEXqRzRLiICFThRUEIKIYs8SZSzgPR2bzk_2YwIeSKXfcJeSnVA8f0zUGSLnF4PD7w63mIETnwYfckhTi7VaIXv-CdchlGc_wMBQWeABATIO', '', '', '2019-06-14 17:07:03', '2019-06-14 19:07:03', 4, ''),
  (155, '22_9wh-V64gFNNEEiCr_HAo1MgbQ5kpouWo-WWiMUqDYOkOHpbq_CY3E8oQSwD3nGkQmxeAG8EcrKuBQNvvut18P4ZoFHbxAt8F53on5Jp_I1VU9vQjzLgU6JSKgHQBNUfAIAIUB', '', '', '2019-06-20 19:31:09', '2019-06-20 21:31:09', 4, ''),
  (156, '22_YySxb_nicrFtSOQW3R2MkLdQZb-VFwKQlOVIKwPF3qjwff2BcGzRwd0B_LT3RaQ1kqHdzZw1qfvYCghiokZXVEWN44vuJUCBjhX25qlsW4581t52eNOFcIPd4FcP-K_VhvTMTz2x5PsxtFnNOHTeACAATF', '', '', '2019-06-21 09:46:57', '2019-06-21 11:46:57', 4, ''),
  (157, '22_xvRAe5dhzWUSP3XGIOWLasknUgc-fFH0fQpO5uqyctJ8Pf15lipbhsxghfVp1KyBsKYAks1JVdw2vULR1NVG5zesq63fw08VIC3_BTzYhWw5Dt3u-uZx7-56mRKmM4LqQ_tCBeZ18qjdiwKPGAQcABAWQG', '', '', '2019-06-21 14:10:47', '2019-06-21 14:10:47', 4, ''),
  (158, '22_bh6_-dbCAGCmuQN_HnKZ79TXiNyJafZ4-zQIMNjfnRhKU4k8aV2Np-0J-VTIJhNtkc08nrNAZEf95cf_A8sSXm7ivOVfCN5Tas2vlEVj4NKv8JeKnFbTOyPRcY9T5xFGMM-ZCfjNhQAwlcMlFDOhAEAIGR', '', '', '2019-06-21 14:42:05', '2019-06-21 16:42:05', 4, ''),
  (159, '22_VDt3zx3RAbjMl6lc3hA_jQ5j3eCv7BSBTChSudKUF6g1-LdXaX6xRf1OGWXsT66dXmiLeB1ePnPT52sWFSjTSW_-fKOhPypDYkOkX5YKzE2_NaZixAzisZjX-L7P9_VeF88cSuxVwwZzf2oRYUZdADAMIN', '', '', '2019-06-22 15:50:08', '2019-06-22 17:50:08', 4, ''),
  (160, '22_eYDvCLDP6zC2TNNHJ4w4Q1bOaaTTEjrOF3g2AuFZCMnZTYHTmf1bV3yrpqJgS2qM4fAgBqX1sweTw47yav5hLE4CI2dLI4LP2qv37nrcjP6GspZwwjuAXO4NriC_iyEME94hj_jhuXyuFrItDYShABATOI', '', '', '2019-06-25 19:13:39', '2019-06-25 21:13:39', 4, ''),
  (161, '22_MAN1pE5dUsnBMmyrJIAV2iIMdGQCUfVlcYwzJefV9zbkZ2PZDtGBoJB69ucszLtnIFnSAneXhUnpbq6UWmtGm7nATmAmDvUymtrzG5htO5-GeRb7G18HlHb3qOUCFEQ5l1U_ktMzIhZ-nBX9BNLcAGANZX', '', '', '2019-06-26 18:26:01', '2019-06-26 20:26:01', 4, ''),
  (162, '22_v5bE_ZA2y3O16EKvXWKKV4xvSGSngUbKh0dzHTy4NtEjo8lH_9jmaVunr12dZcvs1-sw0fz7Hobm-SR3sInQWUk42KELiz4P2rNS_XxScyPF1YzShe4TPMrUoeBrdbZD4TUxyPwG22WDYrZgVRLdAIAFBV', '', '', '2019-06-27 16:54:35', '2019-06-27 18:54:35', 4, '');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `tplay_admin`
  --
  ALTER TABLE `tplay_admin`
    ADD PRIMARY KEY (`id`),
    ADD KEY `id` (`id`) USING BTREE,
    ADD KEY `admin_cate_id` (`admin_cate_id`) USING BTREE,
    ADD KEY `nickname` (`nickname`) USING BTREE,
    ADD KEY `create_time` (`create_time`) USING BTREE;
  
  --
  -- Indexes for table `tplay_admin_cate`
  --
  ALTER TABLE `tplay_admin_cate`
    ADD PRIMARY KEY (`id`),
    ADD KEY `id` (`id`) USING BTREE,
    ADD KEY `name` (`name`) USING BTREE,
    ADD KEY `create_time` (`create_time`) USING BTREE;
  
  --
  -- Indexes for table `tplay_admin_log`
  --
  ALTER TABLE `tplay_admin_log`
    ADD PRIMARY KEY (`id`),
    ADD KEY `id` (`id`) USING BTREE,
    ADD KEY `admin_id` (`admin_id`) USING BTREE,
    ADD KEY `create_time` (`create_time`) USING BTREE;
  
  --
  -- Indexes for table `tplay_admin_menu`
  --
  ALTER TABLE `tplay_admin_menu`
    ADD PRIMARY KEY (`id`),
    ADD KEY `id` (`id`) USING BTREE,
    ADD KEY `module` (`module`) USING BTREE,
    ADD KEY `controller` (`controller`) USING BTREE,
    ADD KEY `function` (`function`) USING BTREE,
    ADD KEY `is_display` (`is_display`) USING BTREE,
    ADD KEY `type` (`type`) USING BTREE;
  
  --
  -- Indexes for table `tplay_article`
  --
  ALTER TABLE `tplay_article`
    ADD PRIMARY KEY (`id`),
    ADD KEY `id` (`id`) USING BTREE,
    ADD KEY `status` (`status`) USING BTREE,
    ADD KEY `is_top` (`is_top`) USING BTREE,
    ADD KEY `article_cate_id` (`article_cate_id`) USING BTREE,
    ADD KEY `admin_id` (`admin_id`) USING BTREE,
    ADD KEY `create_time` (`create_time`) USING BTREE;
  
  --
  -- Indexes for table `tplay_article_cate`
  --
  ALTER TABLE `tplay_article_cate`
    ADD PRIMARY KEY (`id`),
    ADD KEY `id` (`id`) USING BTREE;
  
  --
  -- Indexes for table `tplay_attachment`
  --
  ALTER TABLE `tplay_attachment`
    ADD PRIMARY KEY (`id`),
    ADD KEY `id` (`id`) USING BTREE,
    ADD KEY `status` (`status`) USING BTREE,
    ADD KEY `filename` (`filename`) USING BTREE,
    ADD KEY `create_time` (`create_time`) USING BTREE;
  
  --
  -- Indexes for table `tplay_birthday_list`
  --
  ALTER TABLE `tplay_birthday_list`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `tplay_emailconfig`
  --
  ALTER TABLE `tplay_emailconfig`
    ADD KEY `email` (`email`) USING BTREE;
  
  --
  -- Indexes for table `tplay_messages`
  --
  ALTER TABLE `tplay_messages`
    ADD PRIMARY KEY (`id`),
    ADD KEY `id` (`id`) USING BTREE,
    ADD KEY `is_look` (`is_look`) USING BTREE,
    ADD KEY `create_time` (`create_time`) USING BTREE;
  
  --
  -- Indexes for table `tplay_question`
  --
  ALTER TABLE `tplay_question`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `tplay_question_answer`
  --
  ALTER TABLE `tplay_question_answer`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `tplay_smsconfig`
  --
  ALTER TABLE `tplay_smsconfig`
    ADD KEY `sms` (`sms`) USING BTREE;
  
  --
  -- Indexes for table `tplay_urlconfig`
  --
  ALTER TABLE `tplay_urlconfig`
    ADD PRIMARY KEY (`id`),
    ADD KEY `id` (`id`) USING BTREE,
    ADD KEY `status` (`status`) USING BTREE;
  
  --
  -- Indexes for table `tplay_webconfig`
  --
  ALTER TABLE `tplay_webconfig`
    ADD KEY `web` (`web`) USING BTREE;
  
  --
  -- Indexes for table `tplay_wx_access_token`
  --
  ALTER TABLE `tplay_wx_access_token`
    ADD PRIMARY KEY (`id`);
  
  --
  -- 在导出的表使用AUTO_INCREMENT
  --
  
  --
  -- 使用表AUTO_INCREMENT `tplay_admin`
  --
  ALTER TABLE `tplay_admin`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
  
  --
  -- 使用表AUTO_INCREMENT `tplay_admin_cate`
  --
  ALTER TABLE `tplay_admin_cate`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
  
  --
  -- 使用表AUTO_INCREMENT `tplay_admin_log`
  --
  ALTER TABLE `tplay_admin_log`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=95;
  
  --
  -- 使用表AUTO_INCREMENT `tplay_admin_menu`
  --
  ALTER TABLE `tplay_admin_menu`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59;
  
  --
  -- 使用表AUTO_INCREMENT `tplay_article`
  --
  ALTER TABLE `tplay_article`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- 使用表AUTO_INCREMENT `tplay_article_cate`
  --
  ALTER TABLE `tplay_article_cate`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- 使用表AUTO_INCREMENT `tplay_attachment`
  --
  ALTER TABLE `tplay_attachment`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
  
  --
  -- 使用表AUTO_INCREMENT `tplay_birthday_list`
  --
  ALTER TABLE `tplay_birthday_list`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '流水ID', AUTO_INCREMENT=5;
  
  --
  -- 使用表AUTO_INCREMENT `tplay_messages`
  --
  ALTER TABLE `tplay_messages`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- 使用表AUTO_INCREMENT `tplay_question`
  --
  ALTER TABLE `tplay_question`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '流水id', AUTO_INCREMENT=6;
  
  --
  -- 使用表AUTO_INCREMENT `tplay_question_answer`
  --
  ALTER TABLE `tplay_question_answer`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '流水id', AUTO_INCREMENT=25;
  
  --
  -- 使用表AUTO_INCREMENT `tplay_urlconfig`
  --
  ALTER TABLE `tplay_urlconfig`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- 使用表AUTO_INCREMENT `tplay_wx_access_token`
  --
  ALTER TABLE `tplay_wx_access_token`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=163;
  COMMIT;
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  