reservation_admin/app/install/data/db.sql

-- --------------------------------------------------------
-- 主机:                           127.0.0.1
-- 服务器版本:                        5.5.62-log - MySQL Community Server (GPL)
-- 服务器操作系统:                      Win64
-- HeidiSQL 版本:                  11.3.0.6295
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

-- 导出  表 appointment.tplay_address 结构
DROP TABLE IF EXISTS `tplay_address`;
CREATE TABLE IF NOT EXISTS `tplay_address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '地名',
  `address` varchar(500) NOT NULL DEFAULT '' COMMENT '详细地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='地址';

-- 正在导出表  appointment.tplay_address 的数据：~2 rows (大约)
/*!40000 ALTER TABLE `tplay_address` DISABLE KEYS */;
INSERT INTO `tplay_address` (`id`, `title`, `address`) VALUES
	(1, '厦门曙光医院', '福建省厦门市湖里区金尚路127号'),
	(2, '厦门前埔医院', '地址 : 福建省厦门市湖里区仙岳路3777号\r\n电话 : 0592-5262666');
/*!40000 ALTER TABLE `tplay_address` ENABLE KEYS */;

-- 导出  表 appointment.tplay_admin 结构
DROP TABLE IF EXISTS `tplay_admin`;
CREATE TABLE IF NOT EXISTS `tplay_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '昵称',
  `name` varchar(50) NOT NULL COMMENT '账号',
  `password` varchar(255) NOT NULL COMMENT '密码',
  `thumb` int(11) NOT NULL DEFAULT '0' COMMENT '头像',
  `login_time` int(11) NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `login_ip` char(15) NOT NULL DEFAULT '' COMMENT '最后登录ip',
  `admin_cate_id` int(2) NOT NULL DEFAULT '1' COMMENT '管理员分组',
  `create_time` int(11) NOT NULL,
  `update_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='管理员';

-- 正在导出表  appointment.tplay_admin 的数据：~2 rows (大约)
/*!40000 ALTER TABLE `tplay_admin` DISABLE KEYS */;
INSERT INTO `tplay_admin` (`id`, `nickname`, `name`, `password`, `thumb`, `login_time`, `login_ip`, `admin_cate_id`, `create_time`, `update_time`) VALUES
	(1, 'Tplay', 'admin', '535ddb89a52491f46128048e648bd418', 0, 1682139145, '127.0.0.1', 1, 1649328230, 1651808242),
	(2, 'test', 'test', '582833c7a791bae18e77c4151efafc57', 6, 0, '', 2, 1682075579, 1682075579);
/*!40000 ALTER TABLE `tplay_admin` ENABLE KEYS */;

-- 导出  表 appointment.tplay_admin_cate 结构
DROP TABLE IF EXISTS `tplay_admin_cate`;
CREATE TABLE IF NOT EXISTS `tplay_admin_cate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '角色名称',
  `permissions` varchar(1000) NOT NULL DEFAULT '' COMMENT '权限',
  `desc` varchar(50) NOT NULL DEFAULT '' COMMENT '备注',
  `create_time` int(11) NOT NULL,
  `update_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='角色';

-- 正在导出表  appointment.tplay_admin_cate 的数据：~2 rows (大约)
/*!40000 ALTER TABLE `tplay_admin_cate` DISABLE KEYS */;
INSERT INTO `tplay_admin_cate` (`id`, `name`, `permissions`, `desc`, `create_time`, `update_time`) VALUES
	(1, '超级管理员', '52,87,88,120,121,132,139,141,152,157,158,159,153,180,181,154,160,161,162,155,167,168,169,156,163,164,165,166,184,185,186,111,112,113,114,115,116,142,182,22,7,8,24,25,26,91,27,28,29,96,30,97,1,10,12,13,14,15,16,17,148,170,179,187,11,41,42,44,45,106,145,43,105,108,2,3,4,5,51,117,18,19,20,21,57,58,59,130,131,129,133,134,135,136,53,54,55,56,61,122,140,92,94,137,149,150,151,77,78,79,80,81,82,83,110', '', 1649328138, 1682147816),
	(2, '测试', '52,87,88,120,121,132,139,141,152,153,154,155,156,111,112,113,114,115,116,142', '', 1682075047, 1682075310);
/*!40000 ALTER TABLE `tplay_admin_cate` ENABLE KEYS */;

-- 导出  表 appointment.tplay_admin_log 结构
DROP TABLE IF EXISTS `tplay_admin_log`;
CREATE TABLE IF NOT EXISTS `tplay_admin_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_menu_id` int(11) NOT NULL COMMENT '操作菜单id',
  `admin_id` int(11) NOT NULL COMMENT '操作者id',
  `ip` char(15) NOT NULL DEFAULT '' COMMENT '操作ip',
  `url` varchar(255) NOT NULL DEFAULT '',
  `params` varchar(2000) NOT NULL DEFAULT '',
  `create_time` int(11) NOT NULL COMMENT '操作时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=203 DEFAULT CHARSET=utf8 COMMENT='后台日志';

-- 正在导出表  appointment.tplay_admin_log 的数据：~283 rows (大约)
/*!40000 ALTER TABLE `tplay_admin_log` DISABLE KEYS */;
INSERT INTO `tplay_admin_log` (`id`, `admin_menu_id`, `admin_id`, `ip`, `url`, `params`, `create_time`) VALUES
	(1, 77, 1, '127.0.0.1', '/admin/databackup/index.html', '', 1682040980),
	(2, 81, 1, '127.0.0.1', '/admin/databackup/export.html', 'tables=["tplay_address","tplay_admin","tplay_admin_cate","tplay_admin_log","tplay_admin_menu","tplay_announcement","tplay_appointment","tplay_appointment_application","tplay_article","tplay_article_cate","tplay_attachment","tplay_catalog","tplay_cate_catalog","tplay_config","tplay_config_option","tplay_config_tab","tplay_emailconfig","tplay_feedback","tplay_messages","tplay_point_log","tplay_service_provider","tplay_smsconfig","tplay_specialist","tplay_urlconfig","tplay_user","tplay_webconfig"]', 1682040985),
	(3, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=0&start=0&tablename=tplay_address', 'id=0&start=0&tablename=tplay_address', 1682040986),
	(4, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=1&start=0&tablename=tplay_admin', 'id=1&start=0&tablename=tplay_admin', 1682040986),
	(5, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=2&start=0&tablename=tplay_admin_cate', 'id=2&start=0&tablename=tplay_admin_cate', 1682040987),
	(6, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=3&start=0&tablename=tplay_admin_log', 'id=3&start=0&tablename=tplay_admin_log', 1682040987),
	(7, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=4&start=0&tablename=tplay_admin_menu', 'id=4&start=0&tablename=tplay_admin_menu', 1682040988),
	(8, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=5&start=0&tablename=tplay_announcement', 'id=5&start=0&tablename=tplay_announcement', 1682040989),
	(9, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=6&start=0&tablename=tplay_appointment', 'id=6&start=0&tablename=tplay_appointment', 1682040989),
	(10, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=7&start=0&tablename=tplay_appointment_application', 'id=7&start=0&tablename=tplay_appointment_application', 1682040990),
	(11, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=8&start=0&tablename=tplay_article', 'id=8&start=0&tablename=tplay_article', 1682040990),
	(12, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=9&start=0&tablename=tplay_article_cate', 'id=9&start=0&tablename=tplay_article_cate', 1682040991),
	(13, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=10&start=0&tablename=tplay_attachment', 'id=10&start=0&tablename=tplay_attachment', 1682040991),
	(14, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=11&start=0&tablename=tplay_catalog', 'id=11&start=0&tablename=tplay_catalog', 1682040992),
	(15, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=12&start=0&tablename=tplay_cate_catalog', 'id=12&start=0&tablename=tplay_cate_catalog', 1682040993),
	(16, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=13&start=0&tablename=tplay_config', 'id=13&start=0&tablename=tplay_config', 1682040993),
	(17, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=14&start=0&tablename=tplay_config_option', 'id=14&start=0&tablename=tplay_config_option', 1682040994),
	(18, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=15&start=0&tablename=tplay_config_tab', 'id=15&start=0&tablename=tplay_config_tab', 1682040994),
	(19, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=16&start=0&tablename=tplay_emailconfig', 'id=16&start=0&tablename=tplay_emailconfig', 1682040995),
	(20, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=17&start=0&tablename=tplay_feedback', 'id=17&start=0&tablename=tplay_feedback', 1682040996),
	(21, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=18&start=0&tablename=tplay_messages', 'id=18&start=0&tablename=tplay_messages', 1682040996),
	(22, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=19&start=0&tablename=tplay_point_log', 'id=19&start=0&tablename=tplay_point_log', 1682040997),
	(23, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=20&start=0&tablename=tplay_service_provider', 'id=20&start=0&tablename=tplay_service_provider', 1682040997),
	(24, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=21&start=0&tablename=tplay_smsconfig', 'id=21&start=0&tablename=tplay_smsconfig', 1682040998),
	(25, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=22&start=0&tablename=tplay_specialist', 'id=22&start=0&tablename=tplay_specialist', 1682040998),
	(26, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=23&start=0&tablename=tplay_urlconfig', 'id=23&start=0&tablename=tplay_urlconfig', 1682040999),
	(27, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=24&start=0&tablename=tplay_user', 'id=24&start=0&tablename=tplay_user', 1682041000),
	(28, 81, 1, '127.0.0.1', '/admin/databackup/export.html?id=25&start=0&tablename=tplay_webconfig', 'id=25&start=0&tablename=tplay_webconfig', 1682041000),
	(29, 78, 1, '127.0.0.1', '/admin/databackup/importlist.html', '', 1682041003),
	(30, 92, 1, '127.0.0.1', '/admin/code_generation/index.html', '', 1682044634),
	(31, 10, 1, '127.0.0.1', '/admin/webconfig/index.html', '', 1682044643),
	(32, 10, 0, '127.0.0.1', '/admin/webconfig/index.html', '', 1682058081),
	(33, 50, 0, '127.0.0.1', '/admin_login/6xy8h3PBxycrCsBj4pI8.html', '', 1682058082),
	(34, 50, 0, '127.0.0.1', '/admin_login/6xy8h3PBxycrCsBj4pI8.html', 'name=admin&password=123456&captcha=viue 登录成功', 1682058086),
	(35, 126, 1, '127.0.0.1', '/admin/index/index.html', '', 1682058089),
	(36, 123, 1, '127.0.0.1', '/admin/main/index', '', 1682058089),
	(37, 10, 1, '127.0.0.1', '/admin/webconfig/index.html', '', 1682058612),
	(38, 41, 1, '127.0.0.1', '/admin/attachment/index.html', '', 1682058613),
	(39, 41, 1, '127.0.0.1', '/admin/attachment/index.html?page=1&limit=15', 'page=1&limit=15', 1682058614),
	(40, 10, 1, '127.0.0.1', '/admin/webconfig/index.html', '', 1682058615),
	(41, 77, 1, '127.0.0.1', '/admin/databackup/index.html', '', 1682058617),
	(42, 57, 1, '127.0.0.1', '/admin/config/index.html', '', 1682058618),
	(43, 57, 1, '127.0.0.1', '/admin/config/index.html?tab_id=&page=1&limit=15', 'tab_id=&page=1&limit=15', 1682058618),
	(44, 58, 1, '127.0.0.1', '/admin/config/publish.html?id=1', 'id=1', 1682058622),
	(45, 58, 1, '127.0.0.1', '/admin/config/publish.html', 'name=首页轮播图&type=1&value=&tab_id=1&remark=&image_open=1&image_label=轮播图&name_label=图片标题&value_label=跳转链接&desc_label=&id=1', 1682058652),
	(46, 57, 1, '127.0.0.1', '/admin/config/index.html?tab_id=', 'tab_id=', 1682058653),
	(47, 57, 1, '127.0.0.1', '/admin/config/index.html?tab_id=&page=1&limit=15', 'tab_id=&page=1&limit=15', 1682058654),
	(48, 58, 1, '127.0.0.1', '/admin/config/publish.html?id=2', 'id=2', 1682058657),
	(49, 58, 1, '127.0.0.1', '/admin/config/publish.html', 'name=模块配置&type=1&value=&tab_id=1&remark=网站首页模块配置&image_open=1&image_label=&name_label=模块名称&value_label=跳转链接&desc_label=&id=2', 1682058684),
	(50, 57, 1, '127.0.0.1', '/admin/config/index.html?tab_id=', 'tab_id=', 1682058686),
	(51, 57, 1, '127.0.0.1', '/admin/config/index.html?tab_id=&page=1&limit=15', 'tab_id=&page=1&limit=15', 1682058687),
	(52, 15, 1, '127.0.0.1', '/admin/smsconfig/index.html?check_permission=true', 'check_permission=true', 1682058689),
	(53, 15, 1, '127.0.0.1', '/admin/smsconfig/index.html', '', 1682058689),
	(54, 10, 1, '127.0.0.1', '/admin/webconfig/index.html', '', 1682058690),
	(55, 129, 1, '127.0.0.1', '/admin/config_tab/index.html', '', 1682058692),
	(56, 129, 1, '127.0.0.1', '/admin/config_tab/index.html?page=1&limit=15', 'page=1&limit=15', 1682058693),
	(57, 136, 1, '127.0.0.1', '/admin/config_tab/status.html', 'status=1&id=1', 1682058695),
	(58, 133, 1, '127.0.0.1', '/admin/config_tab/publish.html?id=1', 'id=1', 1682058700),
	(59, 133, 1, '127.0.0.1', '/admin/config_tab/publish.html', 'name=网站配置&remark=网站相关配置项&id=1', 1682058707),
	(60, 129, 1, '127.0.0.1', '/admin/config_tab/index.html', '', 1682058709),
	(61, 129, 1, '127.0.0.1', '/admin/config_tab/index.html?page=1&limit=15', 'page=1&limit=15', 1682058709),
	(62, 57, 1, '127.0.0.1', '/admin/config/index.html', '', 1682058710),
	(63, 57, 1, '127.0.0.1', '/admin/config/index.html?tab_id=&page=1&limit=15', 'tab_id=&page=1&limit=15', 1682058711),
	(64, 10, 1, '127.0.0.1', '/admin/webconfig/index.html', '', 1682058712),
	(65, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&check_permission=true', 'tab_id=1&check_permission=true', 1682058713),
	(66, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1', 'tab_id=1', 1682058714),
	(67, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&page=1&limit=15', 'tab_id=1&page=1&limit=15', 1682058715),
	(68, 53, 1, '127.0.0.1', '/admin/config_option/index.html?pid=1', 'pid=1', 1682058719),
	(69, 53, 1, '127.0.0.1', '/admin/config_option/index/pid/1.html?page=1&limit=15', 'page=1&limit=15&pid=1', 1682058719),
	(70, 54, 1, '127.0.0.1', '/admin/config_option/publish/pid/1.html?id=1', 'id=1&pid=1', 1682058722),
	(71, 105, 1, '127.0.0.1', '/admin/attachment/selectimage.html', '', 1682058724),
	(72, 54, 1, '127.0.0.1', '/admin/config_option/publish.html', 'name=图片1&value=http://local.appointment.com/admin/index/index.html&description=&image=0&pid=1&id=1', 1682058747),
	(73, 53, 1, '127.0.0.1', '/admin/config_option/index.html?pid=1', 'pid=1', 1682058748),
	(74, 53, 1, '127.0.0.1', '/admin/config_option/index/pid/1.html?page=1&limit=15', 'page=1&limit=15&pid=1', 1682058749),
	(75, 54, 1, '127.0.0.1', '/admin/config_option/publish/pid/1.html?id=2', 'id=2&pid=1', 1682058751),
	(76, 54, 1, '127.0.0.1', '/admin/config_option/publish.html', 'name=图片2&value=http://local.appointment.com/admin/index/index.html&description=&image=&pid=1&id=2', 1682058754),
	(77, 53, 1, '127.0.0.1', '/admin/config_option/index.html?pid=1', 'pid=1', 1682058755),
	(78, 53, 1, '127.0.0.1', '/admin/config_option/index/pid/1.html?page=1&limit=15', 'page=1&limit=15&pid=1', 1682058756),
	(79, 54, 1, '127.0.0.1', '/admin/config_option/publish/pid/1.html?id=1', 'id=1&pid=1', 1682058759),
	(80, 105, 1, '127.0.0.1', '/admin/attachment/selectimage.html', '', 1682058765),
	(81, 105, 1, '127.0.0.1', '/admin/attachment/selectimage.html', '', 1682058774),
	(82, 108, 1, '127.0.0.1', '/admin/attachment/create.html', 'filepath=http://local.appointment.com/static/public/images/tx.jpg&use=/admin/config_option/publish/pid/1.html', 1682058779),
	(83, 54, 1, '127.0.0.1', '/admin/config_option/publish.html', 'name=图片1&value=http://local.appointment.com/admin/index/index.html&description=&image=3&pid=1&id=1', 1682058782),
	(84, 53, 1, '127.0.0.1', '/admin/config_option/index.html?pid=1', 'pid=1', 1682058784),
	(85, 53, 1, '127.0.0.1', '/admin/config_option/index/pid/1.html?page=1&limit=15', 'page=1&limit=15&pid=1', 1682058785),
	(86, 54, 1, '127.0.0.1', '/admin/config_option/publish/pid/1.html?id=2', 'id=2&pid=1', 1682058838),
	(87, 105, 1, '127.0.0.1', '/admin/attachment/selectimage.html', '', 1682058840),
	(88, 108, 1, '127.0.0.1', '/admin/attachment/create.html', 'filepath=http://iph.href.lu/879x200?fg=666666&bg=cccccc&use=/admin/config_option/publish/pid/1.html', 1682058974),
	(89, 105, 1, '127.0.0.1', '/admin/attachment/selectimage.html', '', 1682058977),
	(90, 54, 1, '127.0.0.1', '/admin/config_option/publish.html', 'name=图片2&value=http://local.appointment.com/admin/index/index.html&description=&image=4&pid=1&id=2', 1682058980),
	(91, 53, 1, '127.0.0.1', '/admin/config_option/index.html?pid=1', 'pid=1', 1682058982),
	(92, 53, 1, '127.0.0.1', '/admin/config_option/index/pid/1.html?page=1&limit=15', 'page=1&limit=15&pid=1', 1682058982),
	(93, 54, 1, '127.0.0.1', '/admin/config_option/publish/pid/1.html?id=1', 'id=1&pid=1', 1682058987),
	(94, 105, 1, '127.0.0.1', '/admin/attachment/selectimage.html', '', 1682058989),
	(95, 41, 1, '127.0.0.1', '/admin/attachment/index.html', '', 1682059111),
	(96, 41, 1, '127.0.0.1', '/admin/attachment/index.html?page=1&limit=15', 'page=1&limit=15', 1682059111),
	(97, 41, 1, '127.0.0.1', '/admin/attachment/index.html', '', 1682059387),
	(98, 41, 1, '127.0.0.1', '/admin/attachment/index.html?page=1&limit=15', 'page=1&limit=15', 1682059388),
	(99, 44, 1, '127.0.0.1', '/admin/attachment/download.html?id=4', 'id=4', 1682059394),
	(100, 41, 1, '127.0.0.1', '/admin/attachment/index.html?page=1&limit=15', 'page=1&limit=15', 1682059395),
	(101, 41, 1, '127.0.0.1', '/admin/attachment/index.html', '', 1682059399),
	(102, 41, 1, '127.0.0.1', '/admin/attachment/index.html?page=1&limit=15', 'page=1&limit=15', 1682059400),
	(103, 53, 1, '127.0.0.1', '/admin/config_option/index.html?pid=1', 'pid=1', 1682059450),
	(104, 53, 1, '127.0.0.1', '/admin/config_option/index/pid/1.html?page=1&limit=15', 'page=1&limit=15&pid=1', 1682059451),
	(105, 54, 1, '127.0.0.1', '/admin/config_option/publish/pid/1.html?check_permission=true', 'check_permission=true&pid=1', 1682059457),
	(106, 54, 1, '127.0.0.1', '/admin/config_option/publish/pid/1.html', 'pid=1', 1682059457),
	(107, 105, 1, '127.0.0.1', '/admin/attachment/selectimage.html', '', 1682059462),
	(108, 108, 1, '127.0.0.1', '/admin/attachment/create.html', 'filepath=https://iph.href.lu/400x200/?text=%E8%BD%AE%E6%92%AD%E5%9B%BE%E7%89%873&fg=666666&bg=cccccc&use=/admin/config_option/publish/pid/1.html', 1682059473),
	(109, 108, 1, '127.0.0.1', '/admin/attachment/create.html', 'filepath=https://iph.href.lu/400x200/?text=%E8%BD%AE%E6%92%AD%E5%9B%BE%E7%89%873&fg=666666&bg=cccccc&use=/admin/config_option/publish/pid/1.html', 1682059480),
	(110, 108, 1, '127.0.0.1', '/admin/attachment/create.html', 'filepath=https://iph.href.lu/400x200/?text=%E8%BD%AE%E6%92%AD%E5%9B%BE%E7%89%873&fg=666666&bg=cccccc&use=/admin/config_option/publish/pid/1.html', 1682059505),
	(111, 54, 1, '127.0.0.1', '/admin/config_option/publish.html', 'name=图片2&value=&description=&image=5&pid=1', 1682059510),
	(112, 53, 1, '127.0.0.1', '/admin/config_option/index.html?pid=1', 'pid=1', 1682059512),
	(113, 53, 1, '127.0.0.1', '/admin/config_option/index/pid/1.html?page=1&limit=15', 'page=1&limit=15&pid=1', 1682059512),
	(114, 54, 1, '127.0.0.1', '/admin/config_option/publish/pid/1.html?id=3', 'id=3&pid=1', 1682059517),
	(115, 54, 1, '127.0.0.1', '/admin/config_option/publish.html', 'name=图片3&value=&description=&image=5&pid=1&id=3', 1682059521),
	(116, 53, 1, '127.0.0.1', '/admin/config_option/index.html?pid=1', 'pid=1', 1682059523),
	(117, 53, 1, '127.0.0.1', '/admin/config_option/index/pid/1.html?page=1&limit=15', 'page=1&limit=15&pid=1', 1682059523),
	(118, 53, 1, '127.0.0.1', '/admin/config_option/index.html?pid=2', 'pid=2', 1682059587),
	(119, 53, 1, '127.0.0.1', '/admin/config_option/index/pid/2.html?page=1&limit=15', 'page=1&limit=15&pid=2', 1682059588),
	(120, 10, 1, '127.0.0.1', '/admin/webconfig/index.html', '', 1682059619),
	(121, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&check_permission=true', 'tab_id=1&check_permission=true', 1682059621),
	(122, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1', 'tab_id=1', 1682059621),
	(123, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&page=1&limit=15', 'tab_id=1&page=1&limit=15', 1682059622),
	(124, 10, 1, '127.0.0.1', '/admin/webconfig/index.html', '', 1682059672),
	(125, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&check_permission=true', 'tab_id=1&check_permission=true', 1682059673),
	(126, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1', 'tab_id=1', 1682059674),
	(127, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&page=1&limit=15', 'tab_id=1&page=1&limit=15', 1682059675),
	(128, 53, 1, '127.0.0.1', '/admin/config_option/index.html?pid=2', 'pid=2', 1682059687),
	(129, 53, 1, '127.0.0.1', '/admin/config_option/index/pid/2.html?page=1&limit=15', 'page=1&limit=15&pid=2', 1682059687),
	(130, 53, 1, '127.0.0.1', '/admin/config_option/index.html?pid=2', 'pid=2', 1682059698),
	(131, 53, 1, '127.0.0.1', '/admin/config_option/index/pid/2.html?page=1&limit=15', 'page=1&limit=15&pid=2', 1682059698),
	(132, 54, 1, '127.0.0.1', '/admin/config_option/publish/pid/2.html?check_permission=true', 'check_permission=true&pid=2', 1682059702),
	(133, 54, 1, '127.0.0.1', '/admin/config_option/publish/pid/2.html', 'pid=2', 1682059702),
	(134, 105, 1, '127.0.0.1', '/admin/attachment/selectimage.html', '', 1682059711),
	(135, 105, 1, '127.0.0.1', '/admin/attachment/selectimage.html', '', 1682059719),
	(136, 108, 1, '127.0.0.1', '/admin/attachment/create.html', 'filepath=https://iph.href.lu/400x200/?text=%E5%BF%83%E9%87%8C%E5%92%A8%E8%AF%A2&fg=666666&bg=cccccc&use=/admin/config_option/publish/pid/2.html', 1682059751),
	(137, 54, 1, '127.0.0.1', '/admin/config_option/publish.html', 'name=心里咨询&value=&description=&image=6&pid=2', 1682059754),
	(138, 53, 1, '127.0.0.1', '/admin/config_option/index.html?pid=2', 'pid=2', 1682059756),
	(139, 53, 1, '127.0.0.1', '/admin/config_option/index/pid/2.html?page=1&limit=15', 'page=1&limit=15&pid=2', 1682059756),
	(140, 54, 1, '127.0.0.1', '/admin/config_option/publish/pid/2.html?check_permission=true', 'check_permission=true&pid=2', 1682059758),
	(141, 54, 1, '127.0.0.1', '/admin/config_option/publish/pid/2.html', 'pid=2', 1682059759),
	(142, 105, 1, '127.0.0.1', '/admin/attachment/selectimage.html', '', 1682059792),
	(143, 108, 1, '127.0.0.1', '/admin/attachment/create.html', 'filepath=https://iph.href.lu/400x200/?text=%E6%B3%95%E5%BE%8B%E5%92%A8%E8%AF%A2&fg=666666&bg=cccccc&use=/admin/config_option/publish/pid/2.html', 1682059794),
	(144, 54, 1, '127.0.0.1', '/admin/config_option/publish.html', 'name=法律咨询&value=&description=&image=7&pid=2', 1682059796),
	(145, 53, 1, '127.0.0.1', '/admin/config_option/index.html?pid=2', 'pid=2', 1682059797),
	(146, 53, 1, '127.0.0.1', '/admin/config_option/index/pid/2.html?page=1&limit=15', 'page=1&limit=15&pid=2', 1682059798),
	(147, 10, 1, '127.0.0.1', '/admin/webconfig/index.html', '', 1682059805),
	(148, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&check_permission=true', 'tab_id=1&check_permission=true', 1682059806),
	(149, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1', 'tab_id=1', 1682059807),
	(150, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&page=1&limit=15', 'tab_id=1&page=1&limit=15', 1682059807),
	(151, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&check_permission=true', 'tab_id=1&check_permission=true', 1682059813),
	(152, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1', 'tab_id=1', 1682059813),
	(153, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&check_permission=true', 'tab_id=1&check_permission=true', 1682059814),
	(154, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1', 'tab_id=1', 1682059815),
	(155, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&page=1&limit=15', 'tab_id=1&page=1&limit=15', 1682059815),
	(156, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&check_permission=true', 'tab_id=1&check_permission=true', 1682059817),
	(157, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1', 'tab_id=1', 1682059817),
	(158, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&page=1&limit=15', 'tab_id=1&page=1&limit=15', 1682059818),
	(159, 53, 1, '127.0.0.1', '/admin/config_option/index.html?pid=2', 'pid=2', 1682059821),
	(160, 53, 1, '127.0.0.1', '/admin/config_option/index/pid/2.html?page=1&limit=15', 'page=1&limit=15&pid=2', 1682059822),
	(161, 10, 1, '127.0.0.1', '/admin/webconfig/index.html', '', 1682061622),
	(162, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&check_permission=true', 'tab_id=1&check_permission=true', 1682061624),
	(163, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1', 'tab_id=1', 1682061624),
	(164, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&page=1&limit=15', 'tab_id=1&page=1&limit=15', 1682061625),
	(165, 10, 1, '127.0.0.1', '/admin/webconfig/index.html', '', 1682061640),
	(166, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&check_permission=true', 'tab_id=1&check_permission=true', 1682061789),
	(167, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1', 'tab_id=1', 1682061790),
	(168, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&page=1&limit=15', 'tab_id=1&page=1&limit=15', 1682061791),
	(169, 10, 1, '127.0.0.1', '/admin/webconfig/index.html?check_permission=true', 'check_permission=true', 1682062001),
	(170, 10, 1, '127.0.0.1', '/admin/webconfig/index.html', '', 1682062001),
	(171, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&check_permission=true', 'tab_id=1&check_permission=true', 1682062003),
	(172, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1', 'tab_id=1', 1682062004),
	(173, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&page=1&limit=15', 'tab_id=1&page=1&limit=15', 1682062004),
	(174, 10, 1, '127.0.0.1', '/admin/webconfig/index.html?check_permission=true', 'check_permission=true', 1682062028),
	(175, 10, 1, '127.0.0.1', '/admin/webconfig/index.html', '', 1682062028),
	(176, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&check_permission=true', 'tab_id=1&check_permission=true', 1682062030),
	(177, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1', 'tab_id=1', 1682062030),
	(178, 0, 1, '127.0.0.1', '/admin/config/indexwebconfig.html?tab_id=1&page=1&limit=15', 'tab_id=1&page=1&limit=15', 1682062031),
	(179, 10, 1, '127.0.0.1', '/admin/webconfig/index.html', '', 1682073850),
	(180, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html?check_permission=true', 'check_permission=true', 1682073852),
	(181, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html', '', 1682073853),
	(182, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html', '', 1682073868),
	(183, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html', '', 1682073955),
	(184, 10, 1, '127.0.0.1', '/admin/webconfig/index.html', '', 1682073967),
	(185, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html?check_permission=true', 'check_permission=true', 1682073968),
	(186, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html', '', 1682073969),
	(187, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html', '', 1682073988),
	(188, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html', '', 1682073998),
	(189, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html', '', 1682074006),
	(190, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html', '', 1682074023),
	(191, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html', '', 1682074133),
	(192, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html', '', 1682074163),
	(193, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html', '', 1682074206),
	(194, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html', '', 1682074224),
	(195, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html', '', 1682074238),
	(196, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html', '', 1682074261),
	(197, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html', '', 1682074271),
	(198, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html', '', 1682074345),
	(199, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html', '', 1682074382),
	(200, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html', '', 1682074389),
	(201, 0, 1, '127.0.0.1', '/admin/webconfig/appointmentconfig.html', '', 1682074499),
	(202, 11, 1, '127.0.0.1', '/admin/webconfig/publish.html', '上传附件：\\uploads\\admin\\article_content\\20230421\\ee2a2b125a3c174e11683530a931a69e.jpg 登录成功 登录成功', 1682074584);
/*!40000 ALTER TABLE `tplay_admin_log` ENABLE KEYS */;

-- 导出  表 appointment.tplay_admin_menu 结构
DROP TABLE IF EXISTS `tplay_admin_menu`;
CREATE TABLE IF NOT EXISTS `tplay_admin_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `module` varchar(50) NOT NULL COMMENT '模块',
  `controller` varchar(50) NOT NULL COMMENT '控制器',
  `function` varchar(50) NOT NULL COMMENT '方法',
  `parameter` varchar(50) NOT NULL DEFAULT '' COMMENT '参数',
  `description` varchar(50) NOT NULL DEFAULT '' 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为顶级菜单',
  `icon` varchar(50) NOT NULL DEFAULT '' COMMENT '图标',
  `is_open` int(1) NOT NULL DEFAULT '0' COMMENT '0默认闭合1默认展开',
  `orders` int(11) NOT NULL DEFAULT '0' COMMENT '排序值，越小越靠前',
  `create_time` int(11) NOT NULL,
  `update_time` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `module` (`module`) USING BTREE,
  KEY `controller` (`controller`) USING BTREE,
  KEY `function` (`function`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=188 DEFAULT CHARSET=utf8 COMMENT='系统菜单表';

-- 正在导出表  appointment.tplay_admin_menu 的数据：~165 rows (大约)
/*!40000 ALTER TABLE `tplay_admin_menu` DISABLE KEYS */;
INSERT INTO `tplay_admin_menu` (`id`, `name`, `module`, `controller`, `function`, `parameter`, `description`, `is_display`, `type`, `pid`, `icon`, `is_open`, `orders`, `create_time`, `update_time`) VALUES
	(1, '系统', '', '', '', '', '系统设置。', 1, 1, 0, 'fa-cog', 0, 10, 0, 1581073013),
	(2, '高级', '', '', '', '', '菜单管理。', 1, 1, 1, 'fa-paw', 0, 10, 0, 1649318909),
	(3, '系统菜单', 'admin', 'menu', 'index', '', '系统菜单管理', 1, 1, 2, 'fa-share-alt', 0, 0, 0, 1581073030),
	(4, '新增/修改', 'admin', 'menu', 'publish', '', '新增/修改系统菜单.', 2, 1, 3, '', 0, 0, 1516948769, 1516948769),
	(5, '删除', 'admin', 'menu', 'delete', '', '删除系统菜单。', 2, 1, 3, '', 0, 0, 1516948857, 1516948857),
	(7, '个人信息', 'admin', 'admin', 'personal', '', '个人信息修改。', 1, 1, 22, 'fa-user', 0, 0, 1516949435, 1608538891),
	(8, '修改密码', 'admin', 'admin', 'editpassword', '', '管理员修改个人密码。', 2, 1, 7, 'fa-unlock-alt', 0, 0, 1516949702, 1608538880),
	(10, '系统设置', 'admin', 'webconfig', 'index', '', '网站相关设置。', 1, 1, 1, 'fa-internet-explorer', 0, 0, 1516949994, 1649318636),
	(11, '保存修改', 'admin', 'webconfig', 'publish', '', '修改网站设置。', 2, 1, 10, 'fa-tag', 0, 1, 1516950047, 1670839634),
	(12, '邮件设置', 'admin', 'emailconfig', 'index', '', '邮件配置。', 2, 1, 10, 'fa-envelope', 0, 0, 1516950129, 1649318610),
	(13, '修改', 'admin', 'emailconfig', 'publish', '', '修改邮件设置。', 2, 1, 12, '', 0, 0, 1516950215, 1516950215),
	(14, '发送测试邮件', 'admin', 'emailconfig', 'mailto', '', '发送测试邮件。', 2, 1, 12, '', 0, 0, 1516950295, 1516950295),
	(15, '短信设置', 'admin', 'smsconfig', 'index', '', '短信设置。', 2, 1, 10, 'fa-comments', 0, 0, 1516950394, 1649318620),
	(16, '修改', 'admin', 'smsconfig', 'publish', '', '修改短信设置。', 2, 1, 15, '', 0, 0, 1516950447, 1516950447),
	(17, '发送测试短信', 'admin', 'smsconfig', 'smsto', '', '发送测试短信。', 2, 1, 15, '', 0, 0, 1516950483, 1516950483),
	(18, 'URL美化', 'admin', 'urlsconfig', 'index', '', 'URL美化', 1, 1, 2, 'fa-link', 0, 0, 1516950738, 1645173161),
	(19, '新增/修改', 'admin', 'urlsconfig', 'publish', '', '新增/修改url设置。', 2, 1, 18, '', 0, 0, 1516950850, 1516950850),
	(20, '启用/禁用', 'admin', 'urlsconfig', 'status', '', '启用/禁用url美化。', 2, 1, 18, '', 0, 0, 1516950909, 1516950909),
	(21, '删除', 'admin', 'urlsconfig', 'delete', '', ' 删除url美化规则。', 2, 1, 18, '', 0, 0, 1516950941, 1516950941),
	(22, '权限', '', '', '', '', '会员管理。', 1, 1, 0, 'fa-users', 0, 9, 1516950991, 1649318328),
	(24, '管理员', 'admin', 'admin', 'index', '', '系统管理员列表。', 1, 1, 22, 'fa-user-circle-o', 0, 0, 1516951163, 1649318427),
	(25, '新增/修改', 'admin', 'admin', 'publish', '', '新增/修改系统管理员。', 2, 1, 24, '', 0, 0, 1516951224, 1516951224),
	(26, '删除', 'admin', 'admin', 'delete', '', '删除管理员。', 2, 1, 24, '', 0, 0, 1516951253, 1516951253),
	(27, '权限组', 'admin', 'AdminCate', 'index', '', '权限分组。', 1, 1, 22, 'fa-dot-circle-o', 0, 0, 1516951353, 1649318367),
	(28, '新增/修改', 'admin', 'AdminCate', 'publish', '', '新增/修改权限组。', 2, 1, 27, '', 0, 0, 1516951483, 1516951483),
	(29, '删除', 'admin', 'AdminCate', 'delete', '', '删除权限组。', 2, 1, 27, '', 0, 0, 1516951515, 1516951515),
	(30, '操作日志', 'admin', 'AdminLog', 'index', '', '系统管理员操作日志。', 1, 1, 22, 'fa-pencil', 0, 0, 1516951754, 1681713740),
	(31, '内容', 'admin', '', '', '', 'CMS 内容管理。', 2, 2, 0, 'fa-th-large', 1, 2, 1516952262, 1682146898),
	(33, '分类', 'admin', 'Articlecate', 'index', '', '文章分类管理。', 1, 1, 31, 'fa-tag', 0, 3, 1516952856, 1681701848),
	(34, '新增/修改', 'admin', 'Articlecate', 'publish', '', '新增/修改文章分类。', 2, 1, 33, 'fa-tag', 0, 0, 1516952896, 1681701873),
	(35, '删除', 'admin', 'Articlecate', 'delete', '', '删除文章分类。', 2, 1, 33, 'fa-tag', 0, 0, 1516952942, 1681701879),
	(36, '文章', 'admin', 'Article', 'index', '', '文章管理。', 1, 1, 31, 'fa-bookmark', 0, 4, 1516953011, 1681701891),
	(37, '新增/修改', 'admin', 'Article', 'publish', '', '新增/修改文章。', 2, 1, 36, 'fa-tag', 0, 0, 1516953056, 1681701899),
	(38, '审核/拒绝', 'admin', 'article', 'status', '', '审核/拒绝文章。', 2, 1, 36, '', 0, 0, 1516953113, 1516953113),
	(39, '置顶/取消', 'admin', 'Article', 'istop_time', '', '置顶/取消置顶文章。', 2, 1, 36, 'fa-tag', 0, 0, 1516953162, 1681701921),
	(40, '删除', 'admin', 'article', 'delete', '', '删除文章。', 2, 1, 36, 'fa-asterisk', 0, 0, 1516953183, 1645180258),
	(41, '附件', 'admin', 'attachment', 'index', '', '附件管理。', 1, 1, 1, 'fa-cube', 0, 1, 1516953306, 1649318660),
	(42, '附件审核', 'admin', 'attachment', 'status', '', '附件审核。', 2, 1, 41, 'fa-asterisk', 0, 0, 1516953359, 1655952448),
	(43, '附件上传', 'admin', 'attachment', 'upload', '', '附件上传。', 2, 1, 41, '', 0, 1, 1516953392, 1516953392),
	(44, '附件下载', 'admin', 'attachment', 'download', '', '附件下载。', 2, 1, 41, '', 0, 0, 1516953430, 1516953430),
	(45, '附件删除', 'admin', 'attachment', 'delete', '', '附件删除。', 2, 1, 41, '', 0, 0, 1516953477, 1516953477),
	(50, '管理员登录', 'admin', 'common', 'login', '', '不可以加入权限路由', 2, 2, 104, 'fa-asterisk', 0, 3, 1516954517, 1645174792),
	(51, '排序', 'admin', 'menu', 'orders', '', '系统菜单排序。', 2, 1, 3, '', 0, 0, 1517562047, 1517562047),
	(52, '网站', 'admin', '', '', '', '', 1, 1, 0, 'fa-send', 1, 0, 1581067786, 1681897704),
	(53, '配置项', 'admin', 'ConfigOption', 'index', '', '', 2, 1, 57, '', 0, 10, 1581072344, 1617264867),
	(54, '新增/修改', 'admin', 'ConfigOption', 'publish', '', '', 2, 1, 53, '', 0, 0, 1581072401, 1581072401),
	(55, '删除', 'admin', 'ConfigOption', 'delete', '', '', 2, 1, 53, '', 0, 0, 1581072427, 1581072427),
	(56, '显示/隐藏', 'admin', 'ConfigOption', 'status', '', '', 2, 1, 53, '', 0, 0, 1581072456, 1581072456),
	(57, '扩展配置', 'admin', 'Config', 'index', '', '', 1, 1, 2, 'fa-grav', 0, 0, 1581072519, 1660029911),
	(58, '新增/修改', 'admin', 'Config', 'publish', '', '', 2, 1, 57, '', 0, 0, 1581072579, 1581072579),
	(59, '删除', 'admin', 'Config', 'delete', '', '', 2, 1, 57, '', 0, 0, 1581072605, 1581072605),
	(61, '批量删除', 'admin', 'ConfigOption', 'deletes', '', '', 2, 1, 53, '', 0, 0, 1581072664, 1581072664),
	(64, '模板', 'admin', 'Templet', 'index', '', '', 1, 1, 31, 'fa-copy', 0, 1, 1599644649, 1645173972),
	(65, '栏目', 'admin', 'Catalog', 'index', '', '', 1, 1, 31, 'fa-windows', 0, 2, 1599701321, 1645173987),
	(66, '新增/修改', 'admin', 'Templet', 'publish', '', '', 2, 1, 64, '', 0, 0, 1599705520, 1599705520),
	(67, '删除', 'admin', 'Templet', 'delete', '', '', 2, 1, 64, '', 0, 0, 1599705558, 1599705558),
	(68, '新增/修改', 'admin', 'Catalog', 'publish', '', '', 2, 1, 65, '', 0, 0, 1599710325, 1599721798),
	(69, '删除', 'admin', 'Catalog', 'delete', '', '', 2, 1, 65, '', 0, 0, 1599710355, 1599721809),
	(71, '上传模板', 'admin', 'Templet', 'upload', '', '', 2, 1, 64, '', 0, 0, 1599735854, 1599735854),
	(75, '生成静态页', 'admin', 'Catalog', 'exportHtml', '', '', 2, 1, 65, '', 0, 0, 1600134972, 1600134972),
	(76, '审核', 'admin', 'Articlecate', 'status', '', '', 2, 1, 33, '', 0, 0, 1600146630, 1600146630),
	(77, '数据备份', 'admin', 'Databackup', 'index', '', '', 1, 1, 2, 'fa-database', 0, 2, 1600936940, 1660029575),
	(78, '备份文件列表', 'admin', 'Databackup', 'importlist', '', '', 2, 1, 77, '', 0, 0, 1600938506, 1600938506),
	(79, '还原', 'admin', 'Databackup', 'import', '', '', 2, 1, 77, '', 0, 0, 1600938557, 1600938659),
	(80, '删除备份文件', 'admin', 'Databackup', 'del', '', '', 2, 1, 77, '', 0, 0, 1600938603, 1600938603),
	(81, '备份', 'admin', 'Databackup', 'export', '', '', 2, 1, 77, '', 0, 0, 1600938638, 1600938638),
	(82, '修复表', 'admin', 'Databackup', 'repair', '', '', 2, 1, 77, '', 0, 0, 1600938694, 1600938694),
	(83, '优化表', 'admin', 'Databackup', 'optimize', '', '', 2, 1, 77, '', 0, 0, 1600938718, 1600938718),
	(87, '用户', 'admin', 'User', 'index', '', '', 1, 1, 52, 'fa-user', 0, 0, 1604912892, 1681701781),
	(88, '新增/修改', 'admin', 'User', 'publish', '', '', 2, 1, 87, 'fa-tag', 0, 0, 1604912952, 1681701787),
	(91, '重置密码', 'admin', 'admin', 'resetpass', '', '', 2, 1, 24, '', 0, 0, 1612342055, 1612342055),
	(92, '代码生成', 'admin', 'CodeGeneration', 'index', '', '', 1, 1, 2, 'fa-asterisk', 0, 0, 1617266817, 1617266817),
	(94, '生成', 'admin', 'CodeGeneration', 'generation', '', '', 2, 1, 92, '', 0, 0, 1617336327, 1617336327),
	(96, '查看权限', 'admin', 'AdminCate', 'preview', '', '', 2, 1, 27, '', 0, 0, 1623230264, 1623230264),
	(97, '清空管理日志', 'admin', 'AdminLog', 'clearLog', '', '', 2, 1, 30, '', 0, 1, 1623230264, 1623230264),
	(98, '批量删除', 'admin', 'Article', 'deletes', '', '', 2, 1, 36, '', 0, 0, 1623230671, 1623230671),
	(99, '预览', 'admin', 'Article', 'perview', '', '', 2, 1, 36, '', 0, 0, 1623230671, 1623230671),
	(100, '排序', 'admin', 'Articlecate', 'sort', '', '', 2, 1, 33, '', 0, 0, 1623230671, 1623230671),
	(101, '预览', 'admin', 'Articlecate', 'perview', '', '', 2, 1, 33, '', 0, 0, 1623230671, 1623230671),
	(102, '排序', 'admin', 'Catalog', 'sort', '', '', 2, 1, 65, '', 0, 0, 1623230671, 1623230671),
	(103, '预览', 'admin', 'Catalog', 'perview', '', '', 2, 1, 65, '', 0, 0, 1623230671, 1623230671),
	(104, '其他', '', '', '', '', '登录后就能访问的路由', 2, 2, 0, 'fa-asterisk', 0, 20, 1623230716, 1649318243),
	(105, '图片选择/上传', 'admin', 'Attachment', 'selectImage', '', '', 2, 1, 41, '', 0, 1, 1623231185, 1623231185),
	(106, '附件网络图片持久化', 'admin', 'Attachment', 'imgPersistence', '', '', 2, 1, 41, '', 0, 0, 1623231185, 1623231185),
	(108, '添加网络图片', 'admin', 'Attachment', 'create', '', '', 2, 1, 41, '', 0, 1, 1623231185, 1623231185),
	(109, '退出登录', 'admin', 'Index', 'logout', '', '', 2, 2, 104, 'fa-asterisk', 0, 0, 1623231185, 1645174466),
	(110, '命令行备份', 'admin', 'Databackup', 'backup', '', '', 2, 1, 77, '', 0, 0, 1623231185, 1623231185),
	(111, '文件管理', 'admin', 'FileManage', 'index', '', '', 1, 1, 52, 'fa-tag', 0, 1, 1623231185, 1623231185),
	(112, '新增/编辑', 'admin', 'FileManage', 'publish', '', '', 2, 1, 111, '', 0, 0, 1623231379, 1623231379),
	(113, '删除', 'admin', 'FileManage', 'delete', '', '', 2, 1, 111, '', 0, 0, 1623231379, 1623231379),
	(114, '重命名', 'admin', 'FileManage', 'rename', '', '', 2, 1, 111, '', 0, 0, 1623231379, 1623231379),
	(115, '上传', 'admin', 'FileManage', 'upload', '', '', 2, 1, 111, '', 0, 0, 1623231379, 1623231379),
	(116, '新增目录', 'admin', 'FileManage', 'createDir', '', '', 2, 1, 111, '', 0, 0, 1623231379, 1623231379),
	(117, '批量添加', 'admin', 'Menu', 'batchAdd', '', '', 2, 1, 3, '', 0, 0, 1623231501, 1623231501),
	(118, '重命名', 'admin', 'Templet', 'rename', '', '', 2, 1, 64, '', 0, 0, 1623231501, 1623231501),
	(120, '删除', 'admin', 'User', 'delete', '', '', 2, 1, 87, '', 0, 0, 1623231501, 1623231501),
	(121, '修改积分', 'admin', 'User', 'setPoint', '', '', 2, 1, 87, '', 0, 0, 1623231501, 1623231501),
	(122, '排序', 'admin', 'ConfigOption', 'sort', '', '', 2, 1, 53, '', 0, 0, 1623231782, 1623231782),
	(123, '首页', 'admin', 'Main', 'index', '', '', 2, 2, 104, '', 0, 0, 1623231782, 1623231782),
	(124, '清理缓存', 'admin', 'Main', 'clear', '', '', 2, 2, 104, 'fa-asterisk', 0, 0, 1623231782, 1645173920),
	(126, '后台布局', 'admin', 'Index', 'index', '', '', 2, 2, 104, '', 0, 0, 1623232537, 1623232537),
	(128, '重新生成', 'admin', 'Article', 'createFile', '', '', 2, 1, 36, 'fa-asterisk', 0, 0, 1629975856, 1629975856),
	(129, '配置组标签', 'admin', 'ConfigTab', 'index', '', '', 2, 1, 57, 'fa-asterisk', 0, 1, 1629975856, 1629975856),
	(130, '排序', 'admin', 'Config', 'sort', '', '', 2, 1, 57, 'fa-asterisk', 0, 0, 1629975856, 1629975856),
	(131, '审核', 'admin', 'Config', 'status', '', '', 2, 1, 57, 'fa-asterisk', 0, 0, 1629975856, 1629975856),
	(132, '重置密码', 'admin', 'User', 'resetpass', '', '', 2, 1, 87, 'fa-asterisk', 0, 0, 1629975856, 1629975856),
	(133, '新增/修改', 'admin', 'ConfigTab', 'publish', '', '', 2, 1, 129, 'fa-asterisk', 0, 0, 1629975894, 1629975894),
	(134, '删除', 'admin', 'ConfigTab', 'delete', '', '', 2, 1, 129, 'fa-asterisk', 0, 0, 1629975894, 1629975894),
	(135, '排序', 'admin', 'ConfigTab', 'sort', '', '', 2, 1, 129, 'fa-asterisk', 0, 0, 1629975894, 1629975894),
	(136, '审核', 'admin', 'ConfigTab', 'status', '', '', 2, 1, 129, 'fa-asterisk', 0, 0, 1629975894, 1629975894),
	(137, '获取表字段信息', 'admin', 'CodeGeneration', 'getFieldsInfo', '', '', 2, 1, 92, 'fa-asterisk', 0, 0, 1645172736, 1645172736),
	(139, '设置会员', 'admin', 'User', 'setVips', '', '', 2, 1, 87, 'fa-asterisk', 0, 0, 1645172736, 1645172736),
	(140, '单选开关', 'admin', 'ConfigOption', 'single_status', '', '', 2, 1, 53, 'fa-asterisk', 0, 0, 1645180213, 1645180213),
	(141, '审核', 'admin', 'User', 'status', '', '', 2, 1, 87, 'fa-asterisk', 0, 0, 1650266964, 1650266964),
	(142, '解压', 'admin', 'FileManage', 'unzip', '', '', 2, 1, 111, 'fa-asterisk', 0, 0, 1650593397, 1650593397),
	(143, '更新treepath', 'admin', 'Articlecate', 'updateTreePath', '', '', 2, 1, 33, 'fa-asterisk', 0, 0, 1655952413, 1670839553),
	(145, '批量删除', 'admin', 'Attachment', 'deletes', '', '', 2, 1, 41, 'fa-asterisk', 0, 0, 1655952465, 1655952465),
	(146, '审核', 'admin', 'Catalog', 'status', '', '', 2, 1, 65, 'fa-tag', 0, 0, 1670839160, 1670839160),
	(147, '更新treepath', 'admin', 'Catalog', 'updateTreePath', '', '', 2, 1, 65, 'fa-tag', 0, 0, 1670839160, 1670839160),
	(148, '扩展配置', 'admin', 'Config', 'index2', '', '', 2, 1, 10, 'fa-tag', 0, 0, 1670839811, 1670839811),
	(149, '接口生成', 'admin', 'ApiGeneration', 'index', '', '', 2, 1, 92, 'fa-tag', 0, 0, 1681704332, 1681704332),
	(150, '生成', 'admin', 'ApiGeneration', 'generation', '', '', 2, 1, 149, 'fa-tag', 0, 0, 1681704470, 1681704470),
	(151, '获取字段信息', 'admin', 'ApiGeneration', 'getFieldsInfo', '', '', 2, 1, 149, 'fa-tag', 0, 0, 1681704470, 1681704470),
	(152, '地址管理', 'admin', 'Address', 'index', '', '', 1, 1, 52, 'fa-tag', 0, 0, 1681897725, 1681897757),
	(153, '反馈管理', 'admin', 'Feedback', 'index', '', '', 1, 1, 52, 'fa-tag', 0, 0, 1681986760, 1681986769),
	(154, '公告管理', 'admin', 'Announcement', 'index', '', '', 1, 1, 52, 'fa-tag', 0, 0, 1682005382, 1682005382),
	(155, '预约记录', 'admin', 'AppointmentApplication', 'index', '', '', 1, 1, 52, 'fa-tag', 0, 0, 1682006813, 1682006813),
	(156, '专家列表', 'admin', 'Specialist', 'index', '', '', 1, 1, 52, 'fa-tag', 0, 0, 1682006813, 1682006813),
	(157, '新增/修改', 'admin', 'Address', 'publish', '', '', 2, 1, 152, 'fa-tag', 0, 0, 1682145191, 1682145191),
	(158, '删除', 'admin', 'Address', 'delete', '', '', 2, 1, 152, 'fa-tag', 0, 0, 1682145191, 1682145191),
	(159, '批量删除', 'admin', 'Address', 'deletes', '', '', 2, 1, 152, 'fa-tag', 0, 0, 1682145191, 1682145191),
	(160, '新增/修改', 'admin', 'Announcement', 'publish', '', '', 2, 1, 154, 'fa-tag', 0, 0, 1682145274, 1682145274),
	(161, '删除', 'admin', 'Announcement', 'delete', '', '', 2, 1, 154, 'fa-tag', 0, 0, 1682145274, 1682145274),
	(162, '批量删除', 'admin', 'Announcement', 'deletes', '', '', 2, 1, 154, 'fa-tag', 0, 0, 1682145274, 1682145274),
	(163, '放号设置', 'admin', 'Appointment', 'index', '', '', 2, 1, 156, 'fa-tag', 0, 0, 1682145274, 1682145274),
	(164, '新增/修改', 'admin', 'Appointment', 'publish', '', '', 2, 1, 163, 'fa-tag', 0, 0, 1682145347, 1682145347),
	(165, '删除', 'admin', 'Appointment', 'delete', '', '', 2, 1, 163, 'fa-tag', 0, 0, 1682145347, 1682145347),
	(166, '批量删除', 'admin', 'Appointment', 'deletes', '', '', 2, 1, 163, 'fa-tag', 0, 0, 1682145347, 1682145347),
	(167, '新增/修改', 'admin', 'AppointmentApplication', 'publish', '', '', 2, 1, 155, 'fa-tag', 0, 0, 1682145347, 1682145347),
	(168, '删除', 'admin', 'AppointmentApplication', 'delete', '', '', 2, 1, 155, 'fa-tag', 0, 0, 1682145347, 1682145347),
	(169, '批量删', 'admin', 'AppointmentApplication', 'deletes', '', '', 2, 1, 155, 'fa-tag', 0, 0, 1682145347, 1682145347),
	(170, '预约签到设置', 'admin', 'Webconfig', 'appointmentConfig', '', '', 2, 1, 10, 'fa-tag', 0, 0, 1682145426, 1682145426),
	(171, '消息管理', 'admin', 'Tomessages', 'index', '', '', 2, 2, 87, 'fa-tag', 0, 0, 1682146722, 1682146722),
	(172, '新增/修改', 'admin', 'Tomessages', 'publish', '', '', 2, 1, 171, 'fa-tag', 0, 0, 1682146852, 1682146985),
	(173, '系统消息', 'admin', 'Tomessages', 'sysmessage', '', '', 2, 1, 171, 'fa-tag', 0, 0, 1682146852, 1682146852),
	(174, '阅读状态', 'admin', 'Tomessages', 'look', '', '', 2, 1, 171, 'fa-tag', 0, 0, 1682146852, 1682146852),
	(175, '审核状态', 'admin', 'Tomessages', 'status', '', '', 2, 1, 171, 'fa-tag', 0, 0, 1682146852, 1682146852),
	(176, '删除', 'admin', 'Tomessages', 'delete', '', '', 2, 1, 171, 'fa-tag', 0, 0, 1682146852, 1682146852),
	(177, '批量删除', 'admin', 'Tomessages', 'deletes', '', '', 2, 1, 171, 'fa-tag', 0, 0, 1682146852, 1682146852),
	(178, '积分记录', 'admin', 'PointLog', 'index', '', '', 2, 2, 87, 'fa-tag', 0, 0, 1682147077, 1682147782),
	(179, '显示扩展配置', 'admin', 'Config', 'indexWebconfig', '', '', 2, 1, 10, 'fa-tag', 0, 0, 1682147237, 1682147858),
	(180, '删除', 'admin', 'Feedback', 'delete', '', '', 2, 1, 153, 'fa-tag', 0, 0, 1682147237, 1682147237),
	(181, '批量删除', 'admin', 'Feedback', 'deletes', '', '', 2, 1, 153, 'fa-tag', 0, 0, 1682147237, 1682147237),
	(182, '发布远程', 'admin', 'FileManage', 'ftpCover', '', '', 2, 1, 111, 'fa-tag', 0, 0, 1682147237, 1682147237),
	(183, '批量删除', 'admin', 'PointLog', 'deletes', '', '', 2, 1, 178, 'fa-tag', 0, 0, 1682147237, 1682147237),
	(184, '新增/修改', 'admin', 'Specialist', 'publish', '', '', 2, 1, 156, 'fa-tag', 0, 0, 1682147237, 1682147237),
	(185, '删除', 'admin', 'Specialist', 'delete', '', '', 2, 1, 156, 'fa-tag', 0, 0, 1682147237, 1682147237),
	(186, '批量删除', 'admin', 'Specialist', 'deletes', '', '', 2, 1, 156, 'fa-tag', 0, 0, 1682147237, 1682147237),
	(187, '编辑', 'admin', 'Config', 'publishWebconfig', '', '', 2, 1, 179, 'fa-tag', 0, 0, 1682147737, 1682147737);
/*!40000 ALTER TABLE `tplay_admin_menu` ENABLE KEYS */;

-- 导出  表 appointment.tplay_announcement 结构
DROP TABLE IF EXISTS `tplay_announcement`;
CREATE TABLE IF NOT EXISTS `tplay_announcement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '标题',
  `content` varchar(5000) NOT NULL DEFAULT '' COMMENT '内容',
  `admin_id` int(11) NOT NULL DEFAULT '0' COMMENT '创建人',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='公告表';

-- 正在导出表  appointment.tplay_announcement 的数据：~2 rows (大约)
/*!40000 ALTER TABLE `tplay_announcement` DISABLE KEYS */;
INSERT INTO `tplay_announcement` (`id`, `title`, `content`, `admin_id`, `create_time`) VALUES
	(1, '联系我们', '<p>我们的地址是 xxx 市区 xxx 街道 xxx 号</p><p><br/></p><p><img src="http://local.appointment.com/static/public/images/tx.jpg" style="max-width:100%;"/><br/></p>', 1, 1682005712),
	(2, '测试', '<p>测试<img src="/uploads/admin/article_content/20230421/ee2a2b125a3c174e11683530a931a69e.jpg" style="max-width: 100%;"/></p>', 2, 1682074680);
/*!40000 ALTER TABLE `tplay_announcement` ENABLE KEYS */;

-- 导出  表 appointment.tplay_appointment 结构
DROP TABLE IF EXISTS `tplay_appointment`;
CREATE TABLE IF NOT EXISTS `tplay_appointment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL DEFAULT '咨询服务' COMMENT '服务名称',
  `provider_id` int(11) NOT NULL COMMENT '服务人',
  `phone` varchar(50) NOT NULL COMMENT '咨询电话',
  `start_time` int(11) NOT NULL DEFAULT '0' COMMENT '排号日期起始',
  `end_time` int(11) NOT NULL DEFAULT '0' COMMENT '排号日期结束',
  `morning_num` int(11) NOT NULL DEFAULT '20' COMMENT '上午放号个数',
  `morning_start_time` char(8) NOT NULL DEFAULT '08:00:00',
  `morning_end_time` char(8) NOT NULL DEFAULT '12:00:00',
  `afternoon_num` int(11) NOT NULL DEFAULT '20' COMMENT '下午放号个数',
  `afternoon_start_time` char(8) NOT NULL DEFAULT '14:00:00',
  `afternoon_end_time` char(8) NOT NULL DEFAULT '18:00:00',
  `night_num` int(11) NOT NULL DEFAULT '10' COMMENT '晚上放号个数',
  `night_start_time` char(8) NOT NULL DEFAULT '20:00:00',
  `night_end_time` char(8) NOT NULL DEFAULT '23:59:59',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='放号设置';

-- 正在导出表  appointment.tplay_appointment 的数据：~1 rows (大约)
/*!40000 ALTER TABLE `tplay_appointment` DISABLE KEYS */;
INSERT INTO `tplay_appointment` (`id`, `title`, `provider_id`, `phone`, `start_time`, `end_time`, `morning_num`, `morning_start_time`, `morning_end_time`, `afternoon_num`, `afternoon_start_time`, `afternoon_end_time`, `night_num`, `night_start_time`, `night_end_time`, `create_time`) VALUES
	(1, '咨询服务', 3, '12121', 1682092800, 1682784000, 11, '08:00:00', '12:00:00', 20, '14:00:00', '18:00:00', 10, '20:00:00', '23:59:59', 1682151842),
	(2, '咨询服务', 3, '1111', 1682092800, 1682784000, 20, '08:00:00', '12:00:00', 20, '14:00:00', '18:00:00', 10, '20:00:00', '23:59:59', 1682154903),
	(4, '心里咨询', 1, '11', 1682092800, 1682784000, 20, '08:00:00', '12:00:00', 20, '14:00:00', '18:00:00', 10, '20:00:00', '23:59:59', 1682155202);
/*!40000 ALTER TABLE `tplay_appointment` ENABLE KEYS */;

-- 导出  表 appointment.tplay_appointment_application 结构
DROP TABLE IF EXISTS `tplay_appointment_application`;
CREATE TABLE IF NOT EXISTS `tplay_appointment_application` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单id',
  `name` varchar(50) NOT NULL COMMENT '姓名',
  `user_id` int(11) NOT NULL,
  `phone` varchar(50) NOT NULL COMMENT '电话',
  `age` int(11) NOT NULL DEFAULT '0' COMMENT '年龄',
  `childs_num` int(11) NOT NULL DEFAULT '0' COMMENT '子女数量',
  `desc` varchar(200) NOT NULL COMMENT '问题描述',
  `appointment_id` int(11) NOT NULL COMMENT '预约放号ID',
  `time_period` tinyint(4) NOT NULL COMMENT '1上午2下午3晚上',
  `appointment_num` int(11) NOT NULL COMMENT '预约号码',
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '订单状态',
  `remark` varchar(200) NOT NULL DEFAULT '' COMMENT '备注',
  `create_time` int(11) NOT NULL COMMENT '下单时间',
  `finish_time` int(11) NOT NULL DEFAULT '0' COMMENT '完成时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='预约记录';

-- 正在导出表  appointment.tplay_appointment_application 的数据：~0 rows (大约)
/*!40000 ALTER TABLE `tplay_appointment_application` DISABLE KEYS */;
/*!40000 ALTER TABLE `tplay_appointment_application` ENABLE KEYS */;

-- 导出  表 appointment.tplay_article 结构
DROP TABLE IF EXISTS `tplay_article`;
CREATE TABLE IF NOT EXISTS `tplay_article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL COMMENT '标题',
  `seo_title` varchar(50) NOT NULL DEFAULT '',
  `seo_keyword` varchar(255) NOT NULL DEFAULT '',
  `seo_description` varchar(255) NOT NULL DEFAULT '',
  `tag` varchar(255) NOT NULL DEFAULT '' COMMENT '标签',
  `filename` varchar(255) NOT NULL DEFAULT '' COMMENT 'html文件名',
  `page_views` int(11) NOT NULL DEFAULT '0' COMMENT '浏览量',
  `article_cate_id` int(11) NOT NULL DEFAULT '0' COMMENT '分类id',
  `catalog_id` int(11) NOT NULL DEFAULT '0' COMMENT '栏目id',
  `thumb` int(11) NOT NULL DEFAULT '0',
  `content` mediumtext NOT NULL,
  `content2` mediumtext NOT NULL,
  `admin_id` int(11) NOT NULL COMMENT '发布人id',
  `edit_admin_id` int(11) NOT NULL COMMENT '修改人id',
  `uploadip` char(15) NOT NULL COMMENT '操作ip',
  `status` int(1) NOT NULL DEFAULT '0' COMMENT '0待审核1已审核',
  `article_editor` varchar(50) NOT NULL DEFAULT '' COMMENT '指定编辑器',
  `source` varchar(255) NOT NULL DEFAULT '' COMMENT '文章来源地址',
  `istop_time` int(11) NOT NULL DEFAULT '0',
  `create_time` int(11) NOT NULL,
  `update_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章';

-- 正在导出表  appointment.tplay_article 的数据：~0 rows (大约)
/*!40000 ALTER TABLE `tplay_article` DISABLE KEYS */;
/*!40000 ALTER TABLE `tplay_article` ENABLE KEYS */;

-- 导出  表 appointment.tplay_article_cate 结构
DROP TABLE IF EXISTS `tplay_article_cate`;
CREATE TABLE IF NOT EXISTS `tplay_article_cate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL DEFAULT '0' COMMENT ' 上级节点id',
  `title` varchar(50) NOT NULL COMMENT '分类名称',
  `en_name` varchar(50) NOT NULL DEFAULT '' COMMENT '英文别名',
  `seo_title` varchar(50) NOT NULL DEFAULT '' COMMENT 'SEO标题',
  `seo_keyword` varchar(255) NOT NULL DEFAULT '' COMMENT 'SEO关键词',
  `seo_description` varchar(255) NOT NULL DEFAULT '' COMMENT 'SEO描述',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态：1显示0隐藏',
  `tree_path` varchar(50) NOT NULL DEFAULT '0',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章分类';

-- 正在导出表  appointment.tplay_article_cate 的数据：~0 rows (大约)
/*!40000 ALTER TABLE `tplay_article_cate` DISABLE KEYS */;
/*!40000 ALTER TABLE `tplay_article_cate` ENABLE KEYS */;

-- 导出  表 appointment.tplay_attachment 结构
DROP TABLE IF EXISTS `tplay_attachment`;
CREATE TABLE IF NOT EXISTS `tplay_attachment` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `module` varchar(50) NOT NULL DEFAULT '' COMMENT '所属模块',
  `filename` varchar(255) NOT NULL DEFAULT '' COMMENT '文件名',
  `filepath` varchar(255) NOT NULL DEFAULT '' COMMENT '文件路径+文件名',
  `filesize` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
  `fileext` varchar(50) 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不通过',
  `admin_id` int(11) NOT NULL COMMENT '审核者id',
  `audit_time` int(11) NOT NULL COMMENT '审核时间',
  `use` varchar(255) NOT NULL DEFAULT '' COMMENT '用处',
  `download` int(11) NOT NULL DEFAULT '0' COMMENT '下载量',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='附件表';

-- 正在导出表  appointment.tplay_attachment 的数据：~6 rows (大约)
/*!40000 ALTER TABLE `tplay_attachment` DISABLE KEYS */;
INSERT INTO `tplay_attachment` (`id`, `module`, `filename`, `filepath`, `filesize`, `fileext`, `user_id`, `uploadip`, `status`, `admin_id`, `audit_time`, `use`, `download`, `create_time`) VALUES
	(3, 'admin', 'tx.jpg', 'https://iph.href.lu/400x200/?text=%E8%BD%AE%E6%92%AD%E5%9B%BE%E7%89%872&fg=666666&bg=cccccc', 0, 'jpg', 1, '127.0.0.1', 1, 0, 0, 'admin\\config_option\\publish\\pid\\1', 0, 1682058779),
	(4, 'admin', '879x200?fg=666666&bg=cccccc', 'https://iph.href.lu/400x200/?text=%E8%BD%AE%E6%92%AD%E5%9B%BE%E7%89%871&fg=666666&bg=cccccc', 0, 'webp', 1, '127.0.0.1', 1, 0, 0, 'admin\\config_option\\publish\\pid\\1', 1, 1682058974),
	(5, 'admin', '?text=%E8%BD%AE%E6%92%AD%E5%9B%BE%E7%89%873&fg=666666&bg=cccccc', 'https://iph.href.lu/400x200/?text=%E8%BD%AE%E6%92%AD%E5%9B%BE%E7%89%873&fg=666666&bg=cccccc', 0, 'webp', 1, '127.0.0.1', 1, 0, 0, 'admin\\config_option\\publish\\pid\\1', 0, 1682059505),
	(6, 'admin', '?text=%E5%BF%83%E9%87%8C%E5%92%A8%E8%AF%A2&fg=666666&bg=cccccc', 'https://iph.href.lu/400x200/?text=%E5%BF%83%E9%87%8C%E5%92%A8%E8%AF%A2&fg=666666&bg=cccccc', 0, 'webp', 1, '127.0.0.1', 1, 0, 0, 'admin\\config_option\\publish\\pid\\2', 0, 1682059751),
	(7, 'admin', '?text=%E6%B3%95%E5%BE%8B%E5%92%A8%E8%AF%A2&fg=666666&bg=cccccc', 'https://iph.href.lu/400x200/?text=%E6%B3%95%E5%BE%8B%E5%92%A8%E8%AF%A2&fg=666666&bg=cccccc', 0, 'webp', 1, '127.0.0.1', 1, 0, 0, 'admin\\config_option\\publish\\pid\\2', 0, 1682059794),
	(8, 'admin', 'ee2a2b125a3c174e11683530a931a69e.jpg', '\\uploads\\admin\\article_content\\20230421\\ee2a2b125a3c174e11683530a931a69e.jpg', 106558, 'jpg', 1, '127.0.0.1', 1, 1, 1682074697, 'article_content', 0, 1682074697);
/*!40000 ALTER TABLE `tplay_attachment` ENABLE KEYS */;

-- 导出  表 appointment.tplay_catalog 结构
DROP TABLE IF EXISTS `tplay_catalog`;
CREATE TABLE IF NOT EXISTS `tplay_catalog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL DEFAULT '0',
  `title` varchar(50) NOT NULL COMMENT '栏目名',
  `path` varchar(50) NOT NULL DEFAULT '' COMMENT '文件保存路径',
  `sort` tinyint(4) NOT NULL DEFAULT '0' COMMENT '排序',
  `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0单页1文章列表',
  `catalog_templet` varchar(50) NOT NULL DEFAULT '0' COMMENT '栏目模板',
  `article_templet` varchar(50) NOT NULL DEFAULT '0' COMMENT '文章模板',
  `article_rule` varchar(50) NOT NULL DEFAULT '' COMMENT '文章命名规则',
  `articlelist_rule` varchar(50) NOT NULL DEFAULT '' COMMENT '列表命名规则',
  `articlelist_rows` int(11) NOT NULL DEFAULT '10' COMMENT '分页',
  `articlelist_sort` varchar(50) NOT NULL DEFAULT 'create_time desc' COMMENT '分页排序',
  `articlelist_where` varchar(500) NOT NULL DEFAULT '' COMMENT '分页条件',
  `seo_title` varchar(50) NOT NULL DEFAULT '',
  `seo_keyword` varchar(500) NOT NULL DEFAULT '',
  `seo_description` varchar(500) NOT NULL DEFAULT '',
  `tree_path` varchar(50) NOT NULL DEFAULT '',
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='栏目';

-- 正在导出表  appointment.tplay_catalog 的数据：~0 rows (大约)
/*!40000 ALTER TABLE `tplay_catalog` DISABLE KEYS */;
/*!40000 ALTER TABLE `tplay_catalog` ENABLE KEYS */;

-- 导出  表 appointment.tplay_cate_catalog 结构
DROP TABLE IF EXISTS `tplay_cate_catalog`;
CREATE TABLE IF NOT EXISTS `tplay_cate_catalog` (
  `article_cate_id` int(11) NOT NULL,
  `catalog_id` int(11) NOT NULL,
  PRIMARY KEY (`article_cate_id`,`catalog_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 正在导出表  appointment.tplay_cate_catalog 的数据：~0 rows (大约)
/*!40000 ALTER TABLE `tplay_cate_catalog` DISABLE KEYS */;
/*!40000 ALTER TABLE `tplay_cate_catalog` ENABLE KEYS */;

-- 导出  表 appointment.tplay_config 结构
DROP TABLE IF EXISTS `tplay_config`;
CREATE TABLE IF NOT EXISTS `tplay_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tab_id` int(11) NOT NULL DEFAULT '0' COMMENT '标签id',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '名称',
  `value` varchar(50) NOT NULL DEFAULT '' COMMENT '配置值',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '类型',
  `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '审核,1:启用,0停用',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `image_open` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1启用图片配置',
  `image_label` varchar(50) NOT NULL DEFAULT '',
  `name_label` varchar(50) NOT NULL DEFAULT '',
  `value_label` varchar(50) NOT NULL DEFAULT '',
  `desc_label` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='配置';

-- 正在导出表  appointment.tplay_config 的数据：~2 rows (大约)
/*!40000 ALTER TABLE `tplay_config` DISABLE KEYS */;
INSERT INTO `tplay_config` (`id`, `tab_id`, `name`, `value`, `remark`, `type`, `status`, `sort`, `image_open`, `image_label`, `name_label`, `value_label`, `desc_label`) VALUES
	(1, 1, '首页轮播图', '', '', 1, 1, 0, 1, '轮播图', '图片标题', '跳转链接', ''),
	(2, 1, '模块配置', '', '网站首页模块配置', 1, 1, 0, 1, '', '模块名称', '跳转链接', '');
/*!40000 ALTER TABLE `tplay_config` ENABLE KEYS */;

-- 导出  表 appointment.tplay_config_option 结构
DROP TABLE IF EXISTS `tplay_config_option`;
CREATE TABLE IF NOT EXISTS `tplay_config_option` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '名称',
  `pid` int(11) NOT NULL DEFAULT '0' COMMENT '组id',
  `value` varchar(255) NOT NULL DEFAULT '' COMMENT '配置值',
  `description` varchar(500) NOT NULL DEFAULT '' COMMENT '描述',
  `image` int(11) NOT NULL DEFAULT '0' COMMENT '图标、图片',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '多选:1:启用,0停用',
  `single_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '单选:1:启用,0停用',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='配置项';

-- 正在导出表  appointment.tplay_config_option 的数据：~5 rows (大约)
/*!40000 ALTER TABLE `tplay_config_option` DISABLE KEYS */;
INSERT INTO `tplay_config_option` (`id`, `name`, `pid`, `value`, `description`, `image`, `status`, `single_status`, `sort`) VALUES
	(1, '图片1', 1, 'http://local.appointment.com/admin/index/index.html', '', 3, 1, 0, 0),
	(2, '图片2', 1, 'http://local.appointment.com/admin/index/index.html', '', 4, 1, 0, 0),
	(3, '图片3', 1, '', '', 5, 1, 0, 0),
	(4, '心里咨询', 2, '', '', 6, 1, 0, 0),
	(5, '法律咨询', 2, '', '', 7, 1, 0, 0);
/*!40000 ALTER TABLE `tplay_config_option` ENABLE KEYS */;

-- 导出  表 appointment.tplay_config_tab 结构
DROP TABLE IF EXISTS `tplay_config_tab`;
CREATE TABLE IF NOT EXISTS `tplay_config_tab` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '名称',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1显示到系统配置0不显示',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='配置标签';

-- 正在导出表  appointment.tplay_config_tab 的数据：~1 rows (大约)
/*!40000 ALTER TABLE `tplay_config_tab` DISABLE KEYS */;
INSERT INTO `tplay_config_tab` (`id`, `name`, `remark`, `status`, `sort`) VALUES
	(1, '网站配置', '网站相关配置项', 1, 0);
/*!40000 ALTER TABLE `tplay_config_tab` ENABLE KEYS */;

-- 导出  表 appointment.tplay_emailconfig 结构
DROP TABLE IF EXISTS `tplay_emailconfig`;
CREATE TABLE IF NOT EXISTS `tplay_emailconfig` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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 '邮件模板',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='邮件配置表';

-- 正在导出表  appointment.tplay_emailconfig 的数据：~1 rows (大约)
/*!40000 ALTER TABLE `tplay_emailconfig` DISABLE KEYS */;
INSERT INTO `tplay_emailconfig` (`id`, `email`, `from_email`, `from_name`, `smtp`, `username`, `password`, `title`, `content`) VALUES
	(1, 'email', '', 'Tplay', 'smtp.qq.com', '', '', '邮箱验证', '<div style="background-color: #ececec; padding: 35px;">\r\n<table style="width: 600px; margin: 0px auto; text-align: left; position: relative; border-top-left-radius: 5px; border-top-right-radius: 5px; border-bottom-right-radius: 5px; border-bottom-left-radius: 5px; font-size: 14px; font-family: 微软雅黑, 黑体; line-height: 1.5; box-shadow: #999999 0px 0px 5px; border-collapse: collapse; background-position: initial initial; background-repeat: initial initial; background: #fff;" cellpadding="0" align="center">\r\n<tbody>\r\n<tr>\r\n<th style="height: 25px; line-height: 25px; padding: 15px 35px; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: #42a3d3; background-color: #49bcff; border-top-left-radius: 5px; border-top-right-radius: 5px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px;" valign="middle"><span style="color: #ffffff; font-family: 微软雅黑; font-size: x-large;">请完成邮箱验证! </span></th>\r\n</tr>\r\n<tr>\r\n<td>\r\n<div style="padding: 25px 35px 40px; background-color: #fff;">\r\n<h2 style="margin: 5px 0px;"><span style="line-height: 20px; color: #333333;"> <span style="line-height: 22px; font-size: large;"> 亲爱的 {nickname}<br />您正在进行注册操作，请在浏览器打开以下链接，以完成激活操作</span></span></h2>\r\n<pre>{activation_url}</pre>\r\n<p>首先感谢您加入本站！下面是您的账号信息<br />您的账号：{passport}<br />您的邮箱：<strong>{email}</strong><br />当您在使用本网站时，遵守当地法律法规。<br />如果您有什么疑问可以联系网站管理员</p>\r\n<p align="right">此为系统邮件，请勿回复</p>\r\n<p align="right">{time}</p>\r\n<div style="width: 700px; margin: 0 auto;">\r\n<div style="padding: 10px 10px 0; border-top: 1px solid #ccc; color: #747474; margin-bottom: 20px; line-height: 1.3em; font-size: 12px;">\r\n<p>此为系统邮件，请勿回复<br />请保管好您的邮箱，避免账号被他人盗用</p>\r\n<p>©***</p>\r\n</div>\r\n</div>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>');
/*!40000 ALTER TABLE `tplay_emailconfig` ENABLE KEYS */;

-- 导出  表 appointment.tplay_feedback 结构
DROP TABLE IF EXISTS `tplay_feedback`;
CREATE TABLE IF NOT EXISTS `tplay_feedback` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` varchar(500) NOT NULL DEFAULT '' COMMENT '内容',
  `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '发布人',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='反馈表';

-- 正在导出表  appointment.tplay_feedback 的数据：~0 rows (大约)
/*!40000 ALTER TABLE `tplay_feedback` DISABLE KEYS */;
/*!40000 ALTER TABLE `tplay_feedback` ENABLE KEYS */;

-- 导出  表 appointment.tplay_messages 结构
DROP TABLE IF EXISTS `tplay_messages`;
CREATE TABLE IF NOT EXISTS `tplay_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `from_user_id` int(11) NOT NULL DEFAULT '0',
  `to_user_id` int(11) NOT NULL DEFAULT '0',
  `to_msg_id` int(11) NOT NULL DEFAULT '0',
  `ip` char(15) NOT NULL,
  `message` varchar(500) NOT NULL DEFAULT '',
  `is_look` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0未读1已读',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0待审核1通过-1拒绝',
  `create_time` int(11) NOT NULL,
  `update_time` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='消息';

-- 正在导出表  appointment.tplay_messages 的数据：~0 rows (大约)
/*!40000 ALTER TABLE `tplay_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `tplay_messages` ENABLE KEYS */;

-- 导出  表 appointment.tplay_point_log 结构
DROP TABLE IF EXISTS `tplay_point_log`;
CREATE TABLE IF NOT EXISTS `tplay_point_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `before` int(11) NOT NULL COMMENT '变化之前的积分',
  `symbol` char(1) NOT NULL COMMENT '+-符号',
  `change` int(11) NOT NULL COMMENT '变化的积分',
  `final` int(11) NOT NULL COMMENT '变换后的积分',
  `type` tinyint(4) NOT NULL COMMENT '类型',
  `remark` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '说明',
  `create_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='积分';

-- 正在导出表  appointment.tplay_point_log 的数据：~0 rows (大约)
/*!40000 ALTER TABLE `tplay_point_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `tplay_point_log` ENABLE KEYS */;

-- 导出  表 appointment.tplay_smsconfig 结构
DROP TABLE IF EXISTS `tplay_smsconfig`;
CREATE TABLE IF NOT EXISTS `tplay_smsconfig` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sms` varchar(10) NOT NULL DEFAULT 'sms' COMMENT '标识',
  `appkey` varchar(200) NOT NULL,
  `secretkey` varchar(200) NOT NULL,
  `type` varchar(100) NOT NULL DEFAULT 'normal' COMMENT '短信类型',
  `name` varchar(100) NOT NULL COMMENT '短信签名',
  `code` varchar(100) NOT NULL COMMENT '短信模板ID',
  `content` text NOT NULL COMMENT '短信默认模板',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='短信配置表';

-- 正在导出表  appointment.tplay_smsconfig 的数据：~1 rows (大约)
/*!40000 ALTER TABLE `tplay_smsconfig` DISABLE KEYS */;
INSERT INTO `tplay_smsconfig` (`id`, `sms`, `appkey`, `secretkey`, `type`, `name`, `code`, `content`) VALUES
	(1, 'sms', '', '', '', '', '', '');
/*!40000 ALTER TABLE `tplay_smsconfig` ENABLE KEYS */;

-- 导出  表 appointment.tplay_specialist 结构
DROP TABLE IF EXISTS `tplay_specialist`;
CREATE TABLE IF NOT EXISTS `tplay_specialist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '名字',
  `title` varchar(50) NOT NULL COMMENT '职称',
  `head_pic` varchar(255) NOT NULL DEFAULT '' COMMENT '头像',
  `sex` tinyint(4) NOT NULL DEFAULT '0' COMMENT '性别:0未知,1男,2女',
  `desc` varchar(500) NOT NULL DEFAULT '' COMMENT '简介',
  `consultation_direction` varchar(500) NOT NULL DEFAULT '' COMMENT '咨询方向',
  `address_id` int(11) NOT NULL COMMENT '地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='专家';

-- 正在导出表  appointment.tplay_specialist 的数据：~3 rows (大约)
/*!40000 ALTER TABLE `tplay_specialist` DISABLE KEYS */;
INSERT INTO `tplay_specialist` (`id`, `name`, `title`, `head_pic`, `sex`, `desc`, `consultation_direction`, `address_id`) VALUES
	(1, '张站长', '心里医生', '6', 2, '心里医生', '心里医生', 0),
	(2, '李医生', '男科专家', '8', 1, '男科主任', '妇科病', 1),
	(3, '王医生', '妇科大夫', '0', 0, '妇科大夫', '妇科大夫', 1);
/*!40000 ALTER TABLE `tplay_specialist` ENABLE KEYS */;

-- 导出  表 appointment.tplay_urlconfig 结构
DROP TABLE IF EXISTS `tplay_urlconfig`;
CREATE TABLE IF NOT EXISTS `tplay_urlconfig` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `aliases` varchar(200) NOT NULL COMMENT '别名',
  `url` varchar(200) NOT NULL COMMENT '原url结构',
  `desc` varchar(50) NOT NULL DEFAULT '' COMMENT '备注',
  `status` int(1) NOT NULL DEFAULT '1' COMMENT '0禁用1使用',
  `create_time` int(11) NOT NULL,
  `update_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='URL美化';

-- 正在导出表  appointment.tplay_urlconfig 的数据：~1 rows (大约)
/*!40000 ALTER TABLE `tplay_urlconfig` DISABLE KEYS */;
INSERT INTO `tplay_urlconfig` (`id`, `aliases`, `url`, `desc`, `status`, `create_time`, `update_time`) VALUES
	(1, 'admin_login', 'admin/common/login', '后台登录地址', 1, 1517621629, 1682134751);
/*!40000 ALTER TABLE `tplay_urlconfig` ENABLE KEYS */;

-- 导出  表 appointment.tplay_user 结构
DROP TABLE IF EXISTS `tplay_user`;
CREATE TABLE IF NOT EXISTS `tplay_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL DEFAULT '0' COMMENT '推荐人id',
  `passport` varchar(50) NOT NULL COMMENT '账号',
  `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '昵称',
  `password` varchar(50) NOT NULL DEFAULT '' COMMENT '密码',
  `user_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '账号类型',
  `user_cate` tinyint(4) NOT NULL DEFAULT '0' COMMENT '用户角色',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT '角色等级',
  `head_pic` varchar(255) NOT NULL DEFAULT '' COMMENT '头像',
  `point` int(11) NOT NULL DEFAULT '0' COMMENT '积分',
  `money` int(11) NOT NULL DEFAULT '0' COMMENT '余额',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '审核状态',
  `ip` char(15) NOT NULL DEFAULT '' COMMENT '注册ip',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `stop_time` int(11) NOT NULL DEFAULT '0' COMMENT '到期时间',
  `create_time` int(11) NOT NULL COMMENT '注册时间',
  `login_time` int(11) NOT NULL COMMENT '最后登录时间',
  `openid` varchar(50) NOT NULL DEFAULT '',
  `unionid` varchar(50) NOT NULL DEFAULT '',
  `sex` tinyint(4) NOT NULL DEFAULT '0' COMMENT '性别:0未知,1男,2女',
  `country` varchar(50) NOT NULL DEFAULT '' COMMENT '国家',
  `province` varchar(50) NOT NULL DEFAULT '' COMMENT '省份',
  `city` varchar(50) NOT NULL DEFAULT '' COMMENT '城市',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- 正在导出表  appointment.tplay_user 的数据：~1 rows (大约)
/*!40000 ALTER TABLE `tplay_user` DISABLE KEYS */;
INSERT INTO `tplay_user` (`id`, `pid`, `passport`, `nickname`, `password`, `user_type`, `user_cate`, `level`, `head_pic`, `point`, `money`, `status`, `ip`, `remark`, `stop_time`, `create_time`, `login_time`, `openid`, `unionid`, `sex`, `country`, `province`, `city`) VALUES
	(1, 0, '111', '111', '', 1, 0, 0, '1111', 0, 0, 1, '127.0.0.1', '', 0, 1682071180, 1682071180, '', '', 0, '', '', '');
/*!40000 ALTER TABLE `tplay_user` ENABLE KEYS */;

-- 导出  表 appointment.tplay_webconfig 结构
DROP TABLE IF EXISTS `tplay_webconfig`;
CREATE TABLE IF NOT EXISTS `tplay_webconfig` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '别名',
  `is_log` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1开启日志0关闭',
  `is_close_site` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1关闭网站0开启网站',
  `file_type` varchar(200) NOT NULL DEFAULT '' COMMENT '允许上传的类型',
  `file_size` bigint(20) NOT NULL DEFAULT '500' COMMENT '允许上传的最大值',
  `black_ip` varchar(2000) NOT NULL DEFAULT '' COMMENT 'ip黑名单',
  `article_editor` varchar(50) NOT NULL DEFAULT '' COMMENT '文章编辑器',
  `break_the_promise_times` int(11) NOT NULL DEFAULT '0' COMMENT '爽约次数',
  `stop_appointment_day` int(11) NOT NULL DEFAULT '0' COMMENT '多少天无法预约',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='系统配置';

-- 正在导出表  appointment.tplay_webconfig 的数据：~1 rows (大约)
/*!40000 ALTER TABLE `tplay_webconfig` DISABLE KEYS */;
INSERT INTO `tplay_webconfig` (`id`, `name`, `is_log`, `is_close_site`, `file_type`, `file_size`, `black_ip`, `article_editor`, `break_the_promise_times`, `stop_appointment_day`) VALUES
	(1, '咨询预约', 0, 0, 'jpg,png,gif,mp4,zip,jpeg,html', 1024, '', 'wangEditor', 1, 2);
/*!40000 ALTER TABLE `tplay_webconfig` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;