Halaman utama Jelajahi Bantuan
Daftar Masuk
jjhc
/
reservation_admin
1
0
Fork 0
Berkas Masalah 0 Permintaan Tarik 0 Wiki
Pohon: 4e26ae2bdb
Ranting Tag
reservation_adm...
/
db.sql

db.sql 46 KB
Riwayat Mentahan

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707 
  1. -- --------------------------------------------------------
    2. 

  2. -- 主机:                           127.0.0.1
    3. 

  3. -- 服务器版本:                        5.5.62-log - MySQL Community Server (GPL)
    4. 

  4. -- 服务器操作系统:                      Win64
    5. 

  5. -- HeidiSQL 版本:                  8.2.0.4675
    6. 

  6. -- --------------------------------------------------------
    7. 

  7. 

  8. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    9. 

  9. /*!40101 SET NAMES utf8 */;
    10. 

  10. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    11. 

  11. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    12. 

  12. 

  13. -- 导出  表 appointment.tplay_address 结构
    14. 

  14. DROP TABLE IF EXISTS `tplay_address`;
    15. 

  15. CREATE TABLE IF NOT EXISTS `tplay_address` (
    16. 

  16.   `id` int(11) NOT NULL AUTO_INCREMENT,
    17. 

  17.   `title` varchar(50) NOT NULL DEFAULT '' COMMENT '标题',
    18. 

  18.   `address` varchar(500) NOT NULL DEFAULT '' COMMENT '地址',
    19. 

  19.   PRIMARY KEY (`id`)
    20. 

  20. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='地址';
    21. 

  21. 

  22. -- 正在导出表  appointment.tplay_address 的数据：~0 rows (大约)
    23. 

  23. /*!40000 ALTER TABLE `tplay_address` DISABLE KEYS */;
    24. 

  24. /*!40000 ALTER TABLE `tplay_address` ENABLE KEYS */;
    25. 

  25. 

  26. 

  27. -- 导出  表 appointment.tplay_admin 结构
    28. 

  28. DROP TABLE IF EXISTS `tplay_admin`;
    29. 

  29. CREATE TABLE IF NOT EXISTS `tplay_admin` (
    30. 

  30.   `id` int(11) NOT NULL AUTO_INCREMENT,
    31. 

  31.   `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '昵称',
    32. 

  32.   `name` varchar(50) NOT NULL COMMENT '账号',
    33. 

  33.   `password` varchar(255) NOT NULL COMMENT '密码',
    34. 

  34.   `thumb` int(11) NOT NULL DEFAULT '0' COMMENT '头像',
    35. 

  35.   `login_time` int(11) NOT NULL DEFAULT '0' COMMENT '最后登录时间',
    36. 

  36.   `login_ip` char(15) NOT NULL DEFAULT '' COMMENT '最后登录ip',
    37. 

  37.   `admin_cate_id` int(2) NOT NULL DEFAULT '1' COMMENT '管理员分组',
    38. 

  38.   `create_time` int(11) NOT NULL,
    39. 

  39.   `update_time` int(11) NOT NULL,
    40. 

  40.   PRIMARY KEY (`id`)
    41. 

  41. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='管理员';
    42. 

  42. 

  43. -- 正在导出表  appointment.tplay_admin 的数据：~1 rows (大约)
    44. 

  44. /*!40000 ALTER TABLE `tplay_admin` DISABLE KEYS */;
    45. 

  45. INSERT INTO `tplay_admin` (`id`, `nickname`, `name`, `password`, `thumb`, `login_time`, `login_ip`, `admin_cate_id`, `create_time`, `update_time`) VALUES
    46. 

  46. 	(1, 'Tplay', 'admin', 'ecb2702e5545cd163a63b128a2cc010c', 0, 1681894142, '127.0.0.1', 1, 1649328230, 1651808242);
    47. 

  47. /*!40000 ALTER TABLE `tplay_admin` ENABLE KEYS */;
    48. 

  48. 

  49. 

  50. -- 导出  表 appointment.tplay_admin_cate 结构
    51. 

  51. DROP TABLE IF EXISTS `tplay_admin_cate`;
    52. 

  52. CREATE TABLE IF NOT EXISTS `tplay_admin_cate` (
    53. 

  53.   `id` int(11) NOT NULL AUTO_INCREMENT,
    54. 

  54.   `name` varchar(50) NOT NULL COMMENT '角色名称',
    55. 

  55.   `permissions` varchar(1000) NOT NULL DEFAULT '' COMMENT '权限',
    56. 

  56.   `desc` varchar(50) NOT NULL DEFAULT '' COMMENT '备注',
    57. 

  57.   `create_time` int(11) NOT NULL,
    58. 

  58.   `update_time` int(11) NOT NULL,
    59. 

  59.   PRIMARY KEY (`id`)
    60. 

  60. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='角色';
    61. 

  61. 

  62. -- 正在导出表  appointment.tplay_admin_cate 的数据：~1 rows (大约)
    63. 

  63. /*!40000 ALTER TABLE `tplay_admin_cate` DISABLE KEYS */;
    64. 

  64. INSERT INTO `tplay_admin_cate` (`id`, `name`, `permissions`, `desc`, `create_time`, `update_time`) VALUES
    65. 

  65. 	(1, '超级管理员', '52,87,88,120,121,132,139,141,89,138,46,48,84,85,86,119,144,152,153,154,155,156,111,112,113,114,115,116,127,142,64,66,67,71,118,65,68,69,75,102,103,146,147,33,34,35,76,100,101,143,36,37,38,39,40,98,99,128,22,7,8,24,25,26,91,27,28,29,96,30,97,1,10,12,13,14,15,16,17,148,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, 1682006828);
    66. 

  66. /*!40000 ALTER TABLE `tplay_admin_cate` ENABLE KEYS */;
    67. 

  67. 

  68. 

  69. -- 导出  表 appointment.tplay_admin_log 结构
    70. 

  70. DROP TABLE IF EXISTS `tplay_admin_log`;
    71. 

  71. CREATE TABLE IF NOT EXISTS `tplay_admin_log` (
    72. 

  72.   `id` int(11) NOT NULL AUTO_INCREMENT,
    73. 

  73.   `admin_menu_id` int(11) NOT NULL COMMENT '操作菜单id',
    74. 

  74.   `admin_id` int(11) NOT NULL COMMENT '操作者id',
    75. 

  75.   `ip` char(15) NOT NULL DEFAULT '' COMMENT '操作ip',
    76. 

  76.   `url` varchar(255) NOT NULL DEFAULT '',
    77. 

  77.   `params` varchar(2000) NOT NULL DEFAULT '',
    78. 

  78.   `create_time` int(11) NOT NULL COMMENT '操作时间',
    79. 

  79.   PRIMARY KEY (`id`)
    80. 

  80. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='后台日志';
    81. 

  81. 

  82. -- 正在导出表  appointment.tplay_admin_log 的数据：~0 rows (大约)
    83. 

  83. /*!40000 ALTER TABLE `tplay_admin_log` DISABLE KEYS */;
    84. 

  84. /*!40000 ALTER TABLE `tplay_admin_log` ENABLE KEYS */;
    85. 

  85. 

  86. 

  87. -- 导出  表 appointment.tplay_admin_menu 结构
    88. 

  88. DROP TABLE IF EXISTS `tplay_admin_menu`;
    89. 

  89. CREATE TABLE IF NOT EXISTS `tplay_admin_menu` (
    90. 

  90.   `id` int(11) NOT NULL AUTO_INCREMENT,
    91. 

  91.   `name` varchar(50) NOT NULL,
    92. 

  92.   `module` varchar(50) NOT NULL COMMENT '模块',
    93. 

  93.   `controller` varchar(50) NOT NULL COMMENT '控制器',
    94. 

  94.   `function` varchar(50) NOT NULL COMMENT '方法',
    95. 

  95.   `parameter` varchar(50) NOT NULL DEFAULT '' COMMENT '参数',
    96. 

  96.   `description` varchar(50) NOT NULL DEFAULT '' COMMENT '描述',
    97. 

  97.   `is_display` int(1) NOT NULL DEFAULT '1' COMMENT '1显示在左侧菜单2只作为节点',
    98. 

  98.   `type` int(1) NOT NULL DEFAULT '1' COMMENT '1权限节点2普通节点',
    99. 

  99.   `pid` int(11) NOT NULL DEFAULT '0' COMMENT '上级菜单0为顶级菜单',
    100. 

  100.   `icon` varchar(50) NOT NULL DEFAULT '' COMMENT '图标',
    101. 

  101.   `is_open` int(1) NOT NULL DEFAULT '0' COMMENT '0默认闭合1默认展开',
    102. 

  102.   `orders` int(11) NOT NULL DEFAULT '0' COMMENT '排序值，越小越靠前',
    103. 

  103.   `create_time` int(11) NOT NULL,
    104. 

  104.   `update_time` int(11) NOT NULL,
    105. 

  105.   PRIMARY KEY (`id`),
    106. 

  106.   KEY `module` (`module`) USING BTREE,
    107. 

  107.   KEY `controller` (`controller`) USING BTREE,
    108. 

  108.   KEY `function` (`function`) USING BTREE
    109. 

  109. ) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=utf8 COMMENT='系统菜单表';
    110. 

  110. 

  111. -- 正在导出表  appointment.tplay_admin_menu 的数据：~138 rows (大约)
    112. 

  112. /*!40000 ALTER TABLE `tplay_admin_menu` DISABLE KEYS */;
    113. 

  113. 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
    114. 

  114. 	(1, '系统', '', '', '', '', '系统设置。', 1, 1, 0, 'fa-cog', 0, 10, 0, 1581073013),
    115. 

  115. 	(2, '高级', '', '', '', '', '菜单管理。', 1, 1, 1, 'fa-paw', 0, 10, 0, 1649318909),
    116. 

  116. 	(3, '系统菜单', 'admin', 'menu', 'index', '', '系统菜单管理', 1, 1, 2, 'fa-share-alt', 0, 0, 0, 1581073030),
    117. 

  117. 	(4, '新增/修改', 'admin', 'menu', 'publish', '', '新增/修改系统菜单.', 2, 1, 3, '', 0, 0, 1516948769, 1516948769),
    118. 

  118. 	(5, '删除', 'admin', 'menu', 'delete', '', '删除系统菜单。', 2, 1, 3, '', 0, 0, 1516948857, 1516948857),
    119. 

  119. 	(7, '个人信息', 'admin', 'admin', 'personal', '', '个人信息修改。', 1, 1, 22, 'fa-user', 0, 0, 1516949435, 1608538891),
    120. 

  120. 	(8, '修改密码', 'admin', 'admin', 'editpassword', '', '管理员修改个人密码。', 2, 1, 7, 'fa-unlock-alt', 0, 0, 1516949702, 1608538880),
    121. 

  121. 	(10, '系统设置', 'admin', 'webconfig', 'index', '', '网站相关设置。', 1, 1, 1, 'fa-internet-explorer', 0, 0, 1516949994, 1649318636),
    122. 

  122. 	(11, '保存修改', 'admin', 'webconfig', 'publish', '', '修改网站设置。', 2, 1, 10, 'fa-tag', 0, 1, 1516950047, 1670839634),
    123. 

  123. 	(12, '邮件设置', 'admin', 'emailconfig', 'index', '', '邮件配置。', 2, 1, 10, 'fa-envelope', 0, 0, 1516950129, 1649318610),
    124. 

  124. 	(13, '修改', 'admin', 'emailconfig', 'publish', '', '修改邮件设置。', 2, 1, 12, '', 0, 0, 1516950215, 1516950215),
    125. 

  125. 	(14, '发送测试邮件', 'admin', 'emailconfig', 'mailto', '', '发送测试邮件。', 2, 1, 12, '', 0, 0, 1516950295, 1516950295),
    126. 

  126. 	(15, '短信设置', 'admin', 'smsconfig', 'index', '', '短信设置。', 2, 1, 10, 'fa-comments', 0, 0, 1516950394, 1649318620),
    127. 

  127. 	(16, '修改', 'admin', 'smsconfig', 'publish', '', '修改短信设置。', 2, 1, 15, '', 0, 0, 1516950447, 1516950447),
    128. 

  128. 	(17, '发送测试短信', 'admin', 'smsconfig', 'smsto', '', '发送测试短信。', 2, 1, 15, '', 0, 0, 1516950483, 1516950483),
    129. 

  129. 	(18, 'URL美化', 'admin', 'urlsconfig', 'index', '', 'URL美化', 1, 1, 2, 'fa-link', 0, 0, 1516950738, 1645173161),
    130. 

  130. 	(19, '新增/修改', 'admin', 'urlsconfig', 'publish', '', '新增/修改url设置。', 2, 1, 18, '', 0, 0, 1516950850, 1516950850),
    131. 

  131. 	(20, '启用/禁用', 'admin', 'urlsconfig', 'status', '', '启用/禁用url美化。', 2, 1, 18, '', 0, 0, 1516950909, 1516950909),
    132. 

  132. 	(21, '删除', 'admin', 'urlsconfig', 'delete', '', ' 删除url美化规则。', 2, 1, 18, '', 0, 0, 1516950941, 1516950941),
    133. 

  133. 	(22, '权限', '', '', '', '', '会员管理。', 1, 1, 0, 'fa-users', 0, 9, 1516950991, 1649318328),
    134. 

  134. 	(24, '管理员', 'admin', 'admin', 'index', '', '系统管理员列表。', 1, 1, 22, 'fa-user-circle-o', 0, 0, 1516951163, 1649318427),
    135. 

  135. 	(25, '新增/修改', 'admin', 'admin', 'publish', '', '新增/修改系统管理员。', 2, 1, 24, '', 0, 0, 1516951224, 1516951224),
    136. 

  136. 	(26, '删除', 'admin', 'admin', 'delete', '', '删除管理员。', 2, 1, 24, '', 0, 0, 1516951253, 1516951253),
    137. 

  137. 	(27, '权限组', 'admin', 'AdminCate', 'index', '', '权限分组。', 1, 1, 22, 'fa-dot-circle-o', 0, 0, 1516951353, 1649318367),
    138. 

  138. 	(28, '新增/修改', 'admin', 'AdminCate', 'publish', '', '新增/修改权限组。', 2, 1, 27, '', 0, 0, 1516951483, 1516951483),
    139. 

  139. 	(29, '删除', 'admin', 'AdminCate', 'delete', '', '删除权限组。', 2, 1, 27, '', 0, 0, 1516951515, 1516951515),
    140. 

  140. 	(30, '操作日志', 'admin', 'AdminLog', 'index', '', '系统管理员操作日志。', 1, 1, 22, 'fa-pencil', 0, 0, 1516951754, 1681713740),
    141. 

  141. 	(31, '内容', '', '', '', '', 'CMS 内容管理。', 1, 1, 0, 'fa-th-large', 1, 2, 1516952262, 1649318280),
    142. 

  142. 	(33, '分类', 'admin', 'Articlecate', 'index', '', '文章分类管理。', 1, 1, 31, 'fa-tag', 0, 3, 1516952856, 1681701848),
    143. 

  143. 	(34, '新增/修改', 'admin', 'Articlecate', 'publish', '', '新增/修改文章分类。', 2, 1, 33, 'fa-tag', 0, 0, 1516952896, 1681701873),
    144. 

  144. 	(35, '删除', 'admin', 'Articlecate', 'delete', '', '删除文章分类。', 2, 1, 33, 'fa-tag', 0, 0, 1516952942, 1681701879),
    145. 

  145. 	(36, '文章', 'admin', 'Article', 'index', '', '文章管理。', 1, 1, 31, 'fa-bookmark', 0, 4, 1516953011, 1681701891),
    146. 

  146. 	(37, '新增/修改', 'admin', 'Article', 'publish', '', '新增/修改文章。', 2, 1, 36, 'fa-tag', 0, 0, 1516953056, 1681701899),
    147. 

  147. 	(38, '审核/拒绝', 'admin', 'article', 'status', '', '审核/拒绝文章。', 2, 1, 36, '', 0, 0, 1516953113, 1516953113),
    148. 

  148. 	(39, '置顶/取消', 'admin', 'Article', 'istop_time', '', '置顶/取消置顶文章。', 2, 1, 36, 'fa-tag', 0, 0, 1516953162, 1681701921),
    149. 

  149. 	(40, '删除', 'admin', 'article', 'delete', '', '删除文章。', 2, 1, 36, 'fa-asterisk', 0, 0, 1516953183, 1645180258),
    150. 

  150. 	(41, '附件', 'admin', 'attachment', 'index', '', '附件管理。', 1, 1, 1, 'fa-cube', 0, 1, 1516953306, 1649318660),
    151. 

  151. 	(42, '附件审核', 'admin', 'attachment', 'status', '', '附件审核。', 2, 1, 41, 'fa-asterisk', 0, 0, 1516953359, 1655952448),
    152. 

  152. 	(43, '附件上传', 'admin', 'attachment', 'upload', '', '附件上传。', 2, 1, 41, '', 0, 1, 1516953392, 1516953392),
    153. 

  153. 	(44, '附件下载', 'admin', 'attachment', 'download', '', '附件下载。', 2, 1, 41, '', 0, 0, 1516953430, 1516953430),
    154. 

  154. 	(45, '附件删除', 'admin', 'attachment', 'delete', '', '附件删除。', 2, 1, 41, '', 0, 0, 1516953477, 1516953477),
    155. 

  155. 	(46, '消息', 'admin', 'Tomessages', 'index', '', '消息管理。', 2, 1, 87, 'fa-comments', 0, 2, 1516953526, 1681701805),
    156. 

  156. 	(48, '删除', 'admin', 'Tomessages', 'delete', '', '消息删除。', 2, 1, 46, 'fa-asterisk', 0, 0, 1516953648, 1681701813),
    157. 

  157. 	(50, '管理员登录', 'admin', 'common', 'login', '', '不可以加入权限路由', 2, 2, 104, 'fa-asterisk', 0, 3, 1516954517, 1645174792),
    158. 

  158. 	(51, '排序', 'admin', 'menu', 'orders', '', '系统菜单排序。', 2, 1, 3, '', 0, 0, 1517562047, 1517562047),
    159. 

  159. 	(52, '网站', 'admin', '', '', '', '', 1, 1, 0, 'fa-send', 1, 0, 1581067786, 1681897704),
    160. 

  160. 	(53, '配置项', 'admin', 'ConfigOption', 'index', '', '', 2, 1, 57, '', 0, 10, 1581072344, 1617264867),
    161. 

  161. 	(54, '新增/修改', 'admin', 'ConfigOption', 'publish', '', '', 2, 1, 53, '', 0, 0, 1581072401, 1581072401),
    162. 

  162. 	(55, '删除', 'admin', 'ConfigOption', 'delete', '', '', 2, 1, 53, '', 0, 0, 1581072427, 1581072427),
    163. 

  163. 	(56, '显示/隐藏', 'admin', 'ConfigOption', 'status', '', '', 2, 1, 53, '', 0, 0, 1581072456, 1581072456),
    164. 

  164. 	(57, '扩展配置', 'admin', 'Config', 'index', '', '', 1, 1, 2, 'fa-grav', 0, 0, 1581072519, 1660029911),
    165. 

  165. 	(58, '新增/修改', 'admin', 'Config', 'publish', '', '', 2, 1, 57, '', 0, 0, 1581072579, 1581072579),
    166. 

  166. 	(59, '删除', 'admin', 'Config', 'delete', '', '', 2, 1, 57, '', 0, 0, 1581072605, 1581072605),
    167. 

  167. 	(61, '批量删除', 'admin', 'ConfigOption', 'deletes', '', '', 2, 1, 53, '', 0, 0, 1581072664, 1581072664),
    168. 

  168. 	(64, '模板', 'admin', 'Templet', 'index', '', '', 1, 1, 31, 'fa-copy', 0, 1, 1599644649, 1645173972),
    169. 

  169. 	(65, '栏目', 'admin', 'Catalog', 'index', '', '', 1, 1, 31, 'fa-windows', 0, 2, 1599701321, 1645173987),
    170. 

  170. 	(66, '新增/修改', 'admin', 'Templet', 'publish', '', '', 2, 1, 64, '', 0, 0, 1599705520, 1599705520),
    171. 

  171. 	(67, '删除', 'admin', 'Templet', 'delete', '', '', 2, 1, 64, '', 0, 0, 1599705558, 1599705558),
    172. 

  172. 	(68, '新增/修改', 'admin', 'Catalog', 'publish', '', '', 2, 1, 65, '', 0, 0, 1599710325, 1599721798),
    173. 

  173. 	(69, '删除', 'admin', 'Catalog', 'delete', '', '', 2, 1, 65, '', 0, 0, 1599710355, 1599721809),
    174. 

  174. 	(71, '上传模板', 'admin', 'Templet', 'upload', '', '', 2, 1, 64, '', 0, 0, 1599735854, 1599735854),
    175. 

  175. 	(75, '生成静态页', 'admin', 'Catalog', 'exportHtml', '', '', 2, 1, 65, '', 0, 0, 1600134972, 1600134972),
    176. 

  176. 	(76, '审核', 'admin', 'Articlecate', 'status', '', '', 2, 1, 33, '', 0, 0, 1600146630, 1600146630),
    177. 

  177. 	(77, '数据备份', 'admin', 'Databackup', 'index', '', '', 1, 1, 2, 'fa-database', 0, 2, 1600936940, 1660029575),
    178. 

  178. 	(78, '备份文件列表', 'admin', 'Databackup', 'importlist', '', '', 2, 1, 77, '', 0, 0, 1600938506, 1600938506),
    179. 

  179. 	(79, '还原', 'admin', 'Databackup', 'import', '', '', 2, 1, 77, '', 0, 0, 1600938557, 1600938659),
    180. 

  180. 	(80, '删除备份文件', 'admin', 'Databackup', 'del', '', '', 2, 1, 77, '', 0, 0, 1600938603, 1600938603),
    181. 

  181. 	(81, '备份', 'admin', 'Databackup', 'export', '', '', 2, 1, 77, '', 0, 0, 1600938638, 1600938638),
    182. 

  182. 	(82, '修复表', 'admin', 'Databackup', 'repair', '', '', 2, 1, 77, '', 0, 0, 1600938694, 1600938694),
    183. 

  183. 	(83, '优化表', 'admin', 'Databackup', 'optimize', '', '', 2, 1, 77, '', 0, 0, 1600938718, 1600938718),
    184. 

  184. 	(84, '审核', 'admin', 'Tomessages', 'status', '', '', 2, 1, 46, '', 0, 0, 1604907214, 1604907214),
    185. 

  185. 	(85, '新增/编辑', 'admin', 'Tomessages', 'publish', '', '', 2, 1, 46, '', 0, 0, 1604908198, 1604908198),
    186. 

  186. 	(86, '发送系统消息', 'admin', 'Tomessages', 'sysmessage', '', '', 2, 1, 46, '', 0, 0, 1604908198, 1604908198),
    187. 

  187. 	(87, '用户', 'admin', 'User', 'index', '', '', 1, 1, 52, 'fa-user', 0, 0, 1604912892, 1681701781),
    188. 

  188. 	(88, '新增/修改', 'admin', 'User', 'publish', '', '', 2, 1, 87, 'fa-tag', 0, 0, 1604912952, 1681701787),
    189. 

  189. 	(89, '积分', 'admin', 'PointLog', 'index', '', '', 2, 1, 87, 'fa-bitcoin', 0, 1, 1604917674, 1681701707),
    190. 

  190. 	(91, '重置密码', 'admin', 'admin', 'resetpass', '', '', 2, 1, 24, '', 0, 0, 1612342055, 1612342055),
    191. 

  191. 	(92, '代码生成', 'admin', 'CodeGeneration', 'index', '', '', 1, 1, 2, 'fa-asterisk', 0, 0, 1617266817, 1617266817),
    192. 

  192. 	(94, '生成', 'admin', 'CodeGeneration', 'generation', '', '', 2, 1, 92, '', 0, 0, 1617336327, 1617336327),
    193. 

  193. 	(96, '查看权限', 'admin', 'AdminCate', 'preview', '', '', 2, 1, 27, '', 0, 0, 1623230264, 1623230264),
    194. 

  194. 	(97, '清空管理日志', 'admin', 'AdminLog', 'clearLog', '', '', 2, 1, 30, '', 0, 1, 1623230264, 1623230264),
    195. 

  195. 	(98, '批量删除', 'admin', 'Article', 'deletes', '', '', 2, 1, 36, '', 0, 0, 1623230671, 1623230671),
    196. 

  196. 	(99, '预览', 'admin', 'Article', 'perview', '', '', 2, 1, 36, '', 0, 0, 1623230671, 1623230671),
    197. 

  197. 	(100, '排序', 'admin', 'Articlecate', 'sort', '', '', 2, 1, 33, '', 0, 0, 1623230671, 1623230671),
    198. 

  198. 	(101, '预览', 'admin', 'Articlecate', 'perview', '', '', 2, 1, 33, '', 0, 0, 1623230671, 1623230671),
    199. 

  199. 	(102, '排序', 'admin', 'Catalog', 'sort', '', '', 2, 1, 65, '', 0, 0, 1623230671, 1623230671),
    200. 

  200. 	(103, '预览', 'admin', 'Catalog', 'perview', '', '', 2, 1, 65, '', 0, 0, 1623230671, 1623230671),
    201. 

  201. 	(104, '其他', '', '', '', '', '登录后就能访问的路由', 2, 2, 0, 'fa-asterisk', 0, 20, 1623230716, 1649318243),
    202. 

  202. 	(105, '图片选择/上传', 'admin', 'Attachment', 'selectImage', '', '', 2, 1, 41, '', 0, 1, 1623231185, 1623231185),
    203. 

  203. 	(106, '附件网络图片持久化', 'admin', 'Attachment', 'imgPersistence', '', '', 2, 1, 41, '', 0, 0, 1623231185, 1623231185),
    204. 

  204. 	(108, '添加网络图片', 'admin', 'Attachment', 'create', '', '', 2, 1, 41, '', 0, 1, 1623231185, 1623231185),
    205. 

  205. 	(109, '退出登录', 'admin', 'Index', 'logout', '', '', 2, 2, 104, 'fa-asterisk', 0, 0, 1623231185, 1645174466),
    206. 

  206. 	(110, '命令行备份', 'admin', 'Databackup', 'backup', '', '', 2, 1, 77, '', 0, 0, 1623231185, 1623231185),
    207. 

  207. 	(111, '文件管理', 'admin', 'FileManage', 'index', '', '', 1, 1, 52, 'fa-tag', 0, 1, 1623231185, 1623231185),
    208. 

  208. 	(112, '新增/编辑', 'admin', 'FileManage', 'publish', '', '', 2, 1, 111, '', 0, 0, 1623231379, 1623231379),
    209. 

  209. 	(113, '删除', 'admin', 'FileManage', 'delete', '', '', 2, 1, 111, '', 0, 0, 1623231379, 1623231379),
    210. 

  210. 	(114, '重命名', 'admin', 'FileManage', 'rename', '', '', 2, 1, 111, '', 0, 0, 1623231379, 1623231379),
    211. 

  211. 	(115, '上传', 'admin', 'FileManage', 'upload', '', '', 2, 1, 111, '', 0, 0, 1623231379, 1623231379),
    212. 

  212. 	(116, '新增目录', 'admin', 'FileManage', 'createDir', '', '', 2, 1, 111, '', 0, 0, 1623231379, 1623231379),
    213. 

  213. 	(117, '批量添加', 'admin', 'Menu', 'batchAdd', '', '', 2, 1, 3, '', 0, 0, 1623231501, 1623231501),
    214. 

  214. 	(118, '重命名', 'admin', 'Templet', 'rename', '', '', 2, 1, 64, '', 0, 0, 1623231501, 1623231501),
    215. 

  215. 	(119, '批量删除', 'admin', 'Tomessages', 'deletes', '', '', 2, 1, 46, '', 0, 0, 1623231501, 1623231501),
    216. 

  216. 	(120, '删除', 'admin', 'User', 'delete', '', '', 2, 1, 87, '', 0, 0, 1623231501, 1623231501),
    217. 

  217. 	(121, '修改积分', 'admin', 'User', 'setPoint', '', '', 2, 1, 87, '', 0, 0, 1623231501, 1623231501),
    218. 

  218. 	(122, '排序', 'admin', 'ConfigOption', 'sort', '', '', 2, 1, 53, '', 0, 0, 1623231782, 1623231782),
    219. 

  219. 	(123, '首页', 'admin', 'Main', 'index', '', '', 2, 2, 104, '', 0, 0, 1623231782, 1623231782),
    220. 

  220. 	(124, '清理缓存', 'admin', 'Main', 'clear', '', '', 2, 2, 104, 'fa-asterisk', 0, 0, 1623231782, 1645173920),
    221. 

  221. 	(126, '后台布局', 'admin', 'Index', 'index', '', '', 2, 2, 104, '', 0, 0, 1623232537, 1623232537),
    222. 

  222. 	(127, '发布到远程', 'admin', 'FileManage', 'ftpCover', '', '', 2, 1, 111, '', 0, 0, 1624613010, 1624613010),
    223. 

  223. 	(128, '重新生成', 'admin', 'Article', 'createFile', '', '', 2, 1, 36, 'fa-asterisk', 0, 0, 1629975856, 1629975856),
    224. 

  224. 	(129, '配置组标签', 'admin', 'ConfigTab', 'index', '', '', 2, 1, 57, 'fa-asterisk', 0, 1, 1629975856, 1629975856),
    225. 

  225. 	(130, '排序', 'admin', 'Config', 'sort', '', '', 2, 1, 57, 'fa-asterisk', 0, 0, 1629975856, 1629975856),
    226. 

  226. 	(131, '审核', 'admin', 'Config', 'status', '', '', 2, 1, 57, 'fa-asterisk', 0, 0, 1629975856, 1629975856),
    227. 

  227. 	(132, '重置密码', 'admin', 'User', 'resetpass', '', '', 2, 1, 87, 'fa-asterisk', 0, 0, 1629975856, 1629975856),
    228. 

  228. 	(133, '新增/修改', 'admin', 'ConfigTab', 'publish', '', '', 2, 1, 129, 'fa-asterisk', 0, 0, 1629975894, 1629975894),
    229. 

  229. 	(134, '删除', 'admin', 'ConfigTab', 'delete', '', '', 2, 1, 129, 'fa-asterisk', 0, 0, 1629975894, 1629975894),
    230. 

  230. 	(135, '排序', 'admin', 'ConfigTab', 'sort', '', '', 2, 1, 129, 'fa-asterisk', 0, 0, 1629975894, 1629975894),
    231. 

  231. 	(136, '审核', 'admin', 'ConfigTab', 'status', '', '', 2, 1, 129, 'fa-asterisk', 0, 0, 1629975894, 1629975894),
    232. 

  232. 	(137, '获取表字段信息', 'admin', 'CodeGeneration', 'getFieldsInfo', '', '', 2, 1, 92, 'fa-asterisk', 0, 0, 1645172736, 1645172736),
    233. 

  233. 	(138, '批量删除', 'admin', 'PointLog', 'deletes', '', '', 2, 1, 89, 'fa-asterisk', 0, 0, 1645172736, 1645172736),
    234. 

  234. 	(139, '设置会员', 'admin', 'User', 'setVips', '', '', 2, 1, 87, 'fa-asterisk', 0, 0, 1645172736, 1645172736),
    235. 

  235. 	(140, '单选开关', 'admin', 'ConfigOption', 'single_status', '', '', 2, 1, 53, 'fa-asterisk', 0, 0, 1645180213, 1645180213),
    236. 

  236. 	(141, '审核', 'admin', 'User', 'status', '', '', 2, 1, 87, 'fa-asterisk', 0, 0, 1650266964, 1650266964),
    237. 

  237. 	(142, '解压', 'admin', 'FileManage', 'unzip', '', '', 2, 1, 111, 'fa-asterisk', 0, 0, 1650593397, 1650593397),
    238. 

  238. 	(143, '更新treepath', 'admin', 'Articlecate', 'updateTreePath', '', '', 2, 1, 33, 'fa-asterisk', 0, 0, 1655952413, 1670839553),
    239. 

  239. 	(144, '阅读状态', 'admin', 'Tomessages', 'look', '', '', 2, 1, 46, 'fa-asterisk', 0, 0, 1655952414, 1655952414),
    240. 

  240. 	(145, '批量删除', 'admin', 'Attachment', 'deletes', '', '', 2, 1, 41, 'fa-asterisk', 0, 0, 1655952465, 1655952465),
    241. 

  241. 	(146, '审核', 'admin', 'Catalog', 'status', '', '', 2, 1, 65, 'fa-tag', 0, 0, 1670839160, 1670839160),
    242. 

  242. 	(147, '更新treepath', 'admin', 'Catalog', 'updateTreePath', '', '', 2, 1, 65, 'fa-tag', 0, 0, 1670839160, 1670839160),
    243. 

  243. 	(148, '扩展配置', 'admin', 'Config', 'index2', '', '', 2, 1, 10, 'fa-tag', 0, 0, 1670839811, 1670839811),
    244. 

  244. 	(149, '接口生成', 'admin', 'ApiGeneration', 'index', '', '', 2, 1, 92, 'fa-tag', 0, 0, 1681704332, 1681704332),
    245. 

  245. 	(150, '生成', 'admin', 'ApiGeneration', 'generation', '', '', 2, 1, 149, 'fa-tag', 0, 0, 1681704470, 1681704470),
    246. 

  246. 	(151, '获取字段信息', 'admin', 'ApiGeneration', 'getFieldsInfo', '', '', 2, 1, 149, 'fa-tag', 0, 0, 1681704470, 1681704470),
    247. 

  247. 	(152, '地址管理', 'admin', 'Address', 'index', '', '', 1, 1, 52, 'fa-tag', 0, 0, 1681897725, 1681897757),
    248. 

  248. 	(153, '反馈管理', 'admin', 'Feedback', 'index', '', '', 1, 1, 52, 'fa-tag', 0, 0, 1681986760, 1681986769),
    249. 

  249. 	(154, '公告管理', 'admin', 'Announcement', 'index', '', '', 1, 1, 52, 'fa-tag', 0, 0, 1682005382, 1682005382),
    250. 

  250. 	(155, '预约记录', 'admin', 'AppointmentApplication', 'index', '', '', 1, 1, 52, 'fa-tag', 0, 0, 1682006813, 1682006813),
    251. 

  251. 	(156, '专家列表', 'admin', 'Specialist', 'index', '', '', 1, 1, 52, 'fa-tag', 0, 0, 1682006813, 1682006813);
    252. 

  252. /*!40000 ALTER TABLE `tplay_admin_menu` ENABLE KEYS */;
    253. 

  253. 

  254. 

  255. -- 导出  表 appointment.tplay_announcement 结构
    256. 

  256. DROP TABLE IF EXISTS `tplay_announcement`;
    257. 

  257. CREATE TABLE IF NOT EXISTS `tplay_announcement` (
    258. 

  258.   `id` int(11) NOT NULL AUTO_INCREMENT,
    259. 

  259.   `title` varchar(50) NOT NULL DEFAULT '' COMMENT '标题',
    260. 

  260.   `content` varchar(5000) NOT NULL DEFAULT '' COMMENT '内容',
    261. 

  261.   `admin_id` int(11) NOT NULL DEFAULT '0' COMMENT '发布人',
    262. 

  262.   `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '日期',
    263. 

  263.   PRIMARY KEY (`id`)
    264. 

  264. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='公告表';
    265. 

  265. 

  266. -- 正在导出表  appointment.tplay_announcement 的数据：~1 rows (大约)
    267. 

  267. /*!40000 ALTER TABLE `tplay_announcement` DISABLE KEYS */;
    268. 

  268. INSERT INTO `tplay_announcement` (`id`, `title`, `content`, `admin_id`, `create_time`) VALUES
    269. 

  269. 	(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>', 0, 1682005712);
    270. 

  270. /*!40000 ALTER TABLE `tplay_announcement` ENABLE KEYS */;
    271. 

  271. 

  272. 

  273. -- 导出  表 appointment.tplay_appointment 结构
    274. 

  274. DROP TABLE IF EXISTS `tplay_appointment`;
    275. 

  275. CREATE TABLE IF NOT EXISTS `tplay_appointment` (
    276. 

  276.   `id` int(11) NOT NULL AUTO_INCREMENT,
    277. 

  277.   `title` varchar(50) NOT NULL COMMENT '服务名称',
    278. 

  278.   `provider_id` int(11) NOT NULL COMMENT '服务人',
    279. 

  279.   `phone` varchar(50) NOT NULL COMMENT '服务人电话',
    280. 

  280.   `start_time` int(11) NOT NULL DEFAULT '0' COMMENT '预约时间',
    281. 

  281.   `end_time` int(11) NOT NULL DEFAULT '0' COMMENT '预约时间',
    282. 

  282.   `morning_num` int(11) NOT NULL DEFAULT '20' COMMENT '上午放号个数',
    283. 

  283.   `morning_start_time` int(11) NOT NULL DEFAULT '20',
    284. 

  284.   `morning_end_time` int(11) NOT NULL DEFAULT '20',
    285. 

  285.   `afternoon_num` int(11) NOT NULL DEFAULT '20' COMMENT '下午放号个数',
    286. 

  286.   `afternoon_start_time` int(11) NOT NULL DEFAULT '20',
    287. 

  287.   `afternoon_end_time` int(11) NOT NULL DEFAULT '20',
    288. 

  288.   `night_num` int(11) NOT NULL DEFAULT '10' COMMENT '晚上放号个数',
    289. 

  289.   `night_start_time` int(11) NOT NULL DEFAULT '10',
    290. 

  290.   `night_end_time` int(11) NOT NULL DEFAULT '10',
    291. 

  291.   `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
    292. 

  292.   PRIMARY KEY (`id`)
    293. 

  293. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='预约放号管理';
    294. 

  294. 

  295. -- 正在导出表  appointment.tplay_appointment 的数据：~0 rows (大约)
    296. 

  296. /*!40000 ALTER TABLE `tplay_appointment` DISABLE KEYS */;
    297. 

  297. /*!40000 ALTER TABLE `tplay_appointment` ENABLE KEYS */;
    298. 

  298. 

  299. 

  300. -- 导出  表 appointment.tplay_appointment_application 结构
    301. 

  301. DROP TABLE IF EXISTS `tplay_appointment_application`;
    302. 

  302. CREATE TABLE IF NOT EXISTS `tplay_appointment_application` (
    303. 

  303.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单id',
    304. 

  304.   `name` varchar(50) NOT NULL COMMENT '姓名',
    305. 

  305.   `user_id` int(11) NOT NULL,
    306. 

  306.   `phone` varchar(50) NOT NULL COMMENT '电话',
    307. 

  307.   `age` int(11) NOT NULL DEFAULT '0' COMMENT '年龄',
    308. 

  308.   `childs_num` int(11) NOT NULL DEFAULT '0' COMMENT '子女数量',
    309. 

  309.   `desc` varchar(200) NOT NULL COMMENT '问题描述',
    310. 

  310.   `appointment_id` int(11) NOT NULL COMMENT '预约放号ID',
    311. 

  311.   `time_period` tinyint(4) NOT NULL COMMENT '1上午2下午3晚上',
    312. 

  312.   `appointment_num` int(11) NOT NULL COMMENT '预约号码',
    313. 

  313.   `status` int(11) NOT NULL DEFAULT '0' COMMENT '订单状态',
    314. 

  314.   `remark` varchar(200) NOT NULL DEFAULT '' COMMENT '备注',
    315. 

  315.   `create_time` int(11) NOT NULL COMMENT '下单时间',
    316. 

  316.   `finish_time` int(11) NOT NULL DEFAULT '0' COMMENT '完成时间',
    317. 

  317.   PRIMARY KEY (`id`)
    318. 

  318. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='预约记录';
    319. 

  319. 

  320. -- 正在导出表  appointment.tplay_appointment_application 的数据：~0 rows (大约)
    321. 

  321. /*!40000 ALTER TABLE `tplay_appointment_application` DISABLE KEYS */;
    322. 

  322. /*!40000 ALTER TABLE `tplay_appointment_application` ENABLE KEYS */;
    323. 

  323. 

  324. 

  325. -- 导出  表 appointment.tplay_article 结构
    326. 

  326. DROP TABLE IF EXISTS `tplay_article`;
    327. 

  327. CREATE TABLE IF NOT EXISTS `tplay_article` (
    328. 

  328.   `id` int(11) NOT NULL AUTO_INCREMENT,
    329. 

  329.   `title` varchar(50) NOT NULL COMMENT '标题',
    330. 

  330.   `seo_title` varchar(50) NOT NULL DEFAULT '',
    331. 

  331.   `seo_keyword` varchar(255) NOT NULL DEFAULT '',
    332. 

  332.   `seo_description` varchar(255) NOT NULL DEFAULT '',
    333. 

  333.   `tag` varchar(255) NOT NULL DEFAULT '' COMMENT '标签',
    334. 

  334.   `filename` varchar(255) NOT NULL DEFAULT '' COMMENT 'html文件名',
    335. 

  335.   `page_views` int(11) NOT NULL DEFAULT '0' COMMENT '浏览量',
    336. 

  336.   `article_cate_id` int(11) NOT NULL DEFAULT '0' COMMENT '分类id',
    337. 

  337.   `catalog_id` int(11) NOT NULL DEFAULT '0' COMMENT '栏目id',
    338. 

  338.   `thumb` int(11) NOT NULL DEFAULT '0',
    339. 

  339.   `content` mediumtext NOT NULL,
    340. 

  340.   `content2` mediumtext NOT NULL,
    341. 

  341.   `admin_id` int(11) NOT NULL COMMENT '发布人id',
    342. 

  342.   `edit_admin_id` int(11) NOT NULL COMMENT '修改人id',
    343. 

  343.   `uploadip` char(15) NOT NULL COMMENT '操作ip',
    344. 

  344.   `status` int(1) NOT NULL DEFAULT '0' COMMENT '0待审核1已审核',
    345. 

  345.   `article_editor` varchar(50) NOT NULL DEFAULT '' COMMENT '指定编辑器',
    346. 

  346.   `source` varchar(255) NOT NULL DEFAULT '' COMMENT '文章来源地址',
    347. 

  347.   `istop_time` int(11) NOT NULL DEFAULT '0',
    348. 

  348.   `create_time` int(11) NOT NULL,
    349. 

  349.   `update_time` int(11) NOT NULL,
    350. 

  350.   PRIMARY KEY (`id`)
    351. 

  351. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章';
    352. 

  352. 

  353. -- 正在导出表  appointment.tplay_article 的数据：~0 rows (大约)
    354. 

  354. /*!40000 ALTER TABLE `tplay_article` DISABLE KEYS */;
    355. 

  355. /*!40000 ALTER TABLE `tplay_article` ENABLE KEYS */;
    356. 

  356. 

  357. 

  358. -- 导出  表 appointment.tplay_article_cate 结构
    359. 

  359. DROP TABLE IF EXISTS `tplay_article_cate`;
    360. 

  360. CREATE TABLE IF NOT EXISTS `tplay_article_cate` (
    361. 

  361.   `id` int(11) NOT NULL AUTO_INCREMENT,
    362. 

  362.   `pid` int(11) NOT NULL DEFAULT '0' COMMENT ' 上级节点id',
    363. 

  363.   `title` varchar(50) NOT NULL COMMENT '分类名称',
    364. 

  364.   `en_name` varchar(50) NOT NULL DEFAULT '' COMMENT '英文别名',
    365. 

  365.   `seo_title` varchar(50) NOT NULL DEFAULT '' COMMENT 'SEO标题',
    366. 

  366.   `seo_keyword` varchar(255) NOT NULL DEFAULT '' COMMENT 'SEO关键词',
    367. 

  367.   `seo_description` varchar(255) NOT NULL DEFAULT '' COMMENT 'SEO描述',
    368. 

  368.   `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态：1显示0隐藏',
    369. 

  369.   `tree_path` varchar(50) NOT NULL DEFAULT '0',
    370. 

  370.   `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
    371. 

  371.   `create_time` int(11) NOT NULL,
    372. 

  372.   PRIMARY KEY (`id`)
    373. 

  373. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章分类';
    374. 

  374. 

  375. -- 正在导出表  appointment.tplay_article_cate 的数据：~0 rows (大约)
    376. 

  376. /*!40000 ALTER TABLE `tplay_article_cate` DISABLE KEYS */;
    377. 

  377. /*!40000 ALTER TABLE `tplay_article_cate` ENABLE KEYS */;
    378. 

  378. 

  379. 

  380. -- 导出  表 appointment.tplay_attachment 结构
    381. 

  381. DROP TABLE IF EXISTS `tplay_attachment`;
    382. 

  382. CREATE TABLE IF NOT EXISTS `tplay_attachment` (
    383. 

  383.   `id` int(10) NOT NULL AUTO_INCREMENT,
    384. 

  384.   `module` varchar(50) NOT NULL DEFAULT '' COMMENT '所属模块',
    385. 

  385.   `filename` varchar(50) NOT NULL DEFAULT '' COMMENT '文件名',
    386. 

  386.   `filepath` varchar(255) NOT NULL DEFAULT '' COMMENT '文件路径+文件名',
    387. 

  387.   `filesize` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
    388. 

  388.   `fileext` varchar(50) NOT NULL DEFAULT '' COMMENT '文件后缀',
    389. 

  389.   `user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
    390. 

  390.   `uploadip` char(15) NOT NULL DEFAULT '' COMMENT '上传IP',
    391. 

  391.   `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0未审核1已审核-1不通过',
    392. 

  392.   `admin_id` int(11) NOT NULL COMMENT '审核者id',
    393. 

  393.   `audit_time` int(11) NOT NULL COMMENT '审核时间',
    394. 

  394.   `use` varchar(255) NOT NULL DEFAULT '' COMMENT '用处',
    395. 

  395.   `download` int(11) NOT NULL DEFAULT '0' COMMENT '下载量',
    396. 

  396.   `create_time` int(11) unsigned NOT NULL DEFAULT '0',
    397. 

  397.   PRIMARY KEY (`id`)
    398. 

  398. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='附件表';
    399. 

  399. 

  400. -- 正在导出表  appointment.tplay_attachment 的数据：~0 rows (大约)
    401. 

  401. /*!40000 ALTER TABLE `tplay_attachment` DISABLE KEYS */;
    402. 

  402. /*!40000 ALTER TABLE `tplay_attachment` ENABLE KEYS */;
    403. 

  403. 

  404. 

  405. -- 导出  表 appointment.tplay_catalog 结构
    406. 

  406. DROP TABLE IF EXISTS `tplay_catalog`;
    407. 

  407. CREATE TABLE IF NOT EXISTS `tplay_catalog` (
    408. 

  408.   `id` int(11) NOT NULL AUTO_INCREMENT,
    409. 

  409.   `pid` int(11) NOT NULL DEFAULT '0',
    410. 

  410.   `title` varchar(50) NOT NULL COMMENT '栏目名',
    411. 

  411.   `path` varchar(50) NOT NULL DEFAULT '' COMMENT '文件保存路径',
    412. 

  412.   `sort` tinyint(4) NOT NULL DEFAULT '0' COMMENT '排序',
    413. 

  413.   `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0单页1文章列表',
    414. 

  414.   `catalog_templet` varchar(50) NOT NULL DEFAULT '0' COMMENT '栏目模板',
    415. 

  415.   `article_templet` varchar(50) NOT NULL DEFAULT '0' COMMENT '文章模板',
    416. 

  416.   `article_rule` varchar(50) NOT NULL DEFAULT '' COMMENT '文章命名规则',
    417. 

  417.   `articlelist_rule` varchar(50) NOT NULL DEFAULT '' COMMENT '列表命名规则',
    418. 

  418.   `articlelist_rows` int(11) NOT NULL DEFAULT '10' COMMENT '分页',
    419. 

  419.   `articlelist_sort` varchar(50) NOT NULL DEFAULT 'create_time desc' COMMENT '分页排序',
    420. 

  420.   `articlelist_where` varchar(500) NOT NULL DEFAULT '' COMMENT '分页条件',
    421. 

  421.   `seo_title` varchar(50) NOT NULL DEFAULT '',
    422. 

  422.   `seo_keyword` varchar(500) NOT NULL DEFAULT '',
    423. 

  423.   `seo_description` varchar(500) NOT NULL DEFAULT '',
    424. 

  424.   `tree_path` varchar(50) NOT NULL DEFAULT '',
    425. 

  425.   `status` tinyint(4) NOT NULL DEFAULT '1',
    426. 

  426.   PRIMARY KEY (`id`)
    427. 

  427. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='栏目';
    428. 

  428. 

  429. -- 正在导出表  appointment.tplay_catalog 的数据：~0 rows (大约)
    430. 

  430. /*!40000 ALTER TABLE `tplay_catalog` DISABLE KEYS */;
    431. 

  431. /*!40000 ALTER TABLE `tplay_catalog` ENABLE KEYS */;
    432. 

  432. 

  433. 

  434. -- 导出  表 appointment.tplay_cate_catalog 结构
    435. 

  435. DROP TABLE IF EXISTS `tplay_cate_catalog`;
    436. 

  436. CREATE TABLE IF NOT EXISTS `tplay_cate_catalog` (
    437. 

  437.   `article_cate_id` int(11) NOT NULL,
    438. 

  438.   `catalog_id` int(11) NOT NULL,
    439. 

  439.   PRIMARY KEY (`article_cate_id`,`catalog_id`)
    440. 

  440. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    441. 

  441. 

  442. -- 正在导出表  appointment.tplay_cate_catalog 的数据：~0 rows (大约)
    443. 

  443. /*!40000 ALTER TABLE `tplay_cate_catalog` DISABLE KEYS */;
    444. 

  444. /*!40000 ALTER TABLE `tplay_cate_catalog` ENABLE KEYS */;
    445. 

  445. 

  446. 

  447. -- 导出  表 appointment.tplay_config 结构
    448. 

  448. DROP TABLE IF EXISTS `tplay_config`;
    449. 

  449. CREATE TABLE IF NOT EXISTS `tplay_config` (
    450. 

  450.   `id` int(11) NOT NULL AUTO_INCREMENT,
    451. 

  451.   `tab_id` int(11) NOT NULL DEFAULT '0' COMMENT '标签id',
    452. 

  452.   `name` varchar(50) NOT NULL DEFAULT '' COMMENT '名称',
    453. 

  453.   `value` varchar(50) NOT NULL DEFAULT '' COMMENT '配置值',
    454. 

  454.   `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
    455. 

  455.   `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '类型',
    456. 

  456.   `status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '审核,1:启用,0停用',
    457. 

  457.   `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
    458. 

  458.   `hide` int(11) NOT NULL DEFAULT '0' COMMENT '0:显示1:隐藏',
    459. 

  459.   PRIMARY KEY (`id`)
    460. 

  460. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='配置';
    461. 

  461. 

  462. -- 正在导出表  appointment.tplay_config 的数据：~2 rows (大约)
    463. 

  463. /*!40000 ALTER TABLE `tplay_config` DISABLE KEYS */;
    464. 

  464. INSERT INTO `tplay_config` (`id`, `tab_id`, `name`, `value`, `remark`, `type`, `status`, `sort`, `hide`) VALUES
    465. 

  465. 	(1, 1, '首页轮播图', '', '', 1, 1, 0, 0),
    466. 

  466. 	(2, 1, '模块配置', '', '网站首页模块配置', 1, 1, 0, 0);
    467. 

  467. /*!40000 ALTER TABLE `tplay_config` ENABLE KEYS */;
    468. 

  468. 

  469. 

  470. -- 导出  表 appointment.tplay_config_option 结构
    471. 

  471. DROP TABLE IF EXISTS `tplay_config_option`;
    472. 

  472. CREATE TABLE IF NOT EXISTS `tplay_config_option` (
    473. 

  473.   `id` int(11) NOT NULL AUTO_INCREMENT,
    474. 

  474.   `name` varchar(30) NOT NULL DEFAULT '' COMMENT '名称',
    475. 

  475.   `pid` int(11) NOT NULL DEFAULT '0' COMMENT '组id',
    476. 

  476.   `value` varchar(255) NOT NULL DEFAULT '' COMMENT '配置值',
    477. 

  477.   `description` varchar(500) NOT NULL DEFAULT '' COMMENT '描述',
    478. 

  478.   `image` int(11) NOT NULL DEFAULT '0' COMMENT '图标、图片',
    479. 

  479.   `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '多选:1:启用,0停用',
    480. 

  480.   `single_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '单选:1:启用,0停用',
    481. 

  481.   `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
    482. 

  482.   `hide` int(11) NOT NULL DEFAULT '0' COMMENT '0:显示1:隐藏',
    483. 

  483.   PRIMARY KEY (`id`)
    484. 

  484. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='配置项';
    485. 

  485. 

  486. -- 正在导出表  appointment.tplay_config_option 的数据：~2 rows (大约)
    487. 

  487. /*!40000 ALTER TABLE `tplay_config_option` DISABLE KEYS */;
    488. 

  488. INSERT INTO `tplay_config_option` (`id`, `name`, `pid`, `value`, `description`, `image`, `status`, `single_status`, `sort`, `hide`) VALUES
    489. 

  489. 	(1, '图片1', 1, 'https://image.so.com/i?q=banner&listsrc=sobox&listsign=f5d475c6e55d2c989a9acb0be57af775&src=360pic_strong', '', 0, 1, 0, 0, 0),
    490. 

  490. 	(2, '图片2', 1, 'https://image.so.com/i?q=banner&listsrc=sobox&listsign=f5d475c6e55d2c989a9acb0be57af775&src=360pic_strong', '', 0, 1, 0, 0, 0);
    491. 

  491. /*!40000 ALTER TABLE `tplay_config_option` ENABLE KEYS */;
    492. 

  492. 

  493. 

  494. -- 导出  表 appointment.tplay_config_tab 结构
    495. 

  495. DROP TABLE IF EXISTS `tplay_config_tab`;
    496. 

  496. CREATE TABLE IF NOT EXISTS `tplay_config_tab` (
    497. 

  497.   `id` int(11) NOT NULL AUTO_INCREMENT,
    498. 

  498.   `name` varchar(50) NOT NULL DEFAULT '' COMMENT '名称',
    499. 

  499.   `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
    500. 

  500.   `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
    501. 

  501.   PRIMARY KEY (`id`) USING BTREE
    502. 

  502. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='配置标签';
    503. 

  503. 

  504. -- 正在导出表  appointment.tplay_config_tab 的数据：~1 rows (大约)
    505. 

  505. /*!40000 ALTER TABLE `tplay_config_tab` DISABLE KEYS */;
    506. 

  506. INSERT INTO `tplay_config_tab` (`id`, `name`, `remark`, `sort`) VALUES
    507. 

  507. 	(1, '网站配置', '', 0);
    508. 

  508. /*!40000 ALTER TABLE `tplay_config_tab` ENABLE KEYS */;
    509. 

  509. 

  510. 

  511. -- 导出  表 appointment.tplay_emailconfig 结构
    512. 

  512. DROP TABLE IF EXISTS `tplay_emailconfig`;
    513. 

  513. CREATE TABLE IF NOT EXISTS `tplay_emailconfig` (
    514. 

  514.   `id` int(11) NOT NULL AUTO_INCREMENT,
    515. 

  515.   `email` varchar(5) NOT NULL COMMENT '邮箱配置标识',
    516. 

  516.   `from_email` varchar(50) NOT NULL COMMENT '邮件来源也就是邮件地址',
    517. 

  517.   `from_name` varchar(50) NOT NULL,
    518. 

  518.   `smtp` varchar(50) NOT NULL COMMENT '邮箱smtp服务器',
    519. 

  519.   `username` varchar(100) NOT NULL COMMENT '邮箱账号',
    520. 

  520.   `password` varchar(100) NOT NULL COMMENT '邮箱密码',
    521. 

  521.   `title` varchar(200) NOT NULL COMMENT '邮件标题',
    522. 

  522.   `content` text NOT NULL COMMENT '邮件模板',
    523. 

  523.   PRIMARY KEY (`id`)
    524. 

  524. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='邮件配置表';
    525. 

  525. 

  526. -- 正在导出表  appointment.tplay_emailconfig 的数据：~1 rows (大约)
    527. 

  527. /*!40000 ALTER TABLE `tplay_emailconfig` DISABLE KEYS */;
    528. 

  528. INSERT INTO `tplay_emailconfig` (`id`, `email`, `from_email`, `from_name`, `smtp`, `username`, `password`, `title`, `content`) VALUES
    529. 

  529. 	(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>');
    530. 

  530. /*!40000 ALTER TABLE `tplay_emailconfig` ENABLE KEYS */;
    531. 

  531. 

  532. 

  533. -- 导出  表 appointment.tplay_feedback 结构
    534. 

  534. DROP TABLE IF EXISTS `tplay_feedback`;
    535. 

  535. CREATE TABLE IF NOT EXISTS `tplay_feedback` (
    536. 

  536.   `id` int(11) NOT NULL AUTO_INCREMENT,
    537. 

  537.   `content` varchar(500) NOT NULL DEFAULT '' COMMENT '内容',
    538. 

  538.   `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '发布人',
    539. 

  539.   `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '日期',
    540. 

  540.   PRIMARY KEY (`id`)
    541. 

  541. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='反馈表';
    542. 

  542. 

  543. -- 正在导出表  appointment.tplay_feedback 的数据：~0 rows (大约)
    544. 

  544. /*!40000 ALTER TABLE `tplay_feedback` DISABLE KEYS */;
    545. 

  545. /*!40000 ALTER TABLE `tplay_feedback` ENABLE KEYS */;
    546. 

  546. 

  547. 

  548. -- 导出  表 appointment.tplay_messages 结构
    549. 

  549. DROP TABLE IF EXISTS `tplay_messages`;
    550. 

  550. CREATE TABLE IF NOT EXISTS `tplay_messages` (
    551. 

  551.   `id` int(11) NOT NULL AUTO_INCREMENT,
    552. 

  552.   `from_user_id` int(11) NOT NULL DEFAULT '0',
    553. 

  553.   `to_user_id` int(11) NOT NULL DEFAULT '0',
    554. 

  554.   `to_msg_id` int(11) NOT NULL DEFAULT '0',
    555. 

  555.   `ip` char(15) NOT NULL,
    556. 

  556.   `message` varchar(500) NOT NULL DEFAULT '',
    557. 

  557.   `is_look` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0未读1已读',
    558. 

  558.   `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0待审核1通过-1拒绝',
    559. 

  559.   `create_time` int(11) NOT NULL,
    560. 

  560.   `update_time` int(11) NOT NULL,
    561. 

  561.   PRIMARY KEY (`id`) USING BTREE
    562. 

  562. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='消息';
    563. 

  563. 

  564. -- 正在导出表  appointment.tplay_messages 的数据：~0 rows (大约)
    565. 

  565. /*!40000 ALTER TABLE `tplay_messages` DISABLE KEYS */;
    566. 

  566. /*!40000 ALTER TABLE `tplay_messages` ENABLE KEYS */;
    567. 

  567. 

  568. 

  569. -- 导出  表 appointment.tplay_point_log 结构
    570. 

  570. DROP TABLE IF EXISTS `tplay_point_log`;
    571. 

  571. CREATE TABLE IF NOT EXISTS `tplay_point_log` (
    572. 

  572.   `id` int(11) NOT NULL AUTO_INCREMENT,
    573. 

  573.   `user_id` int(11) NOT NULL DEFAULT '0',
    574. 

  574.   `before` int(11) NOT NULL COMMENT '变化之前的积分',
    575. 

  575.   `symbol` char(1) NOT NULL COMMENT '+-符号',
    576. 

  576.   `change` int(11) NOT NULL COMMENT '变化的积分',
    577. 

  577.   `final` int(11) NOT NULL COMMENT '变换后的积分',
    578. 

  578.   `type` tinyint(4) NOT NULL COMMENT '类型',
    579. 

  579.   `remark` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '说明',
    580. 

  580.   `create_time` int(11) NOT NULL,
    581. 

  581.   PRIMARY KEY (`id`)
    582. 

  582. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='积分';
    583. 

  583. 

  584. -- 正在导出表  appointment.tplay_point_log 的数据：~0 rows (大约)
    585. 

  585. /*!40000 ALTER TABLE `tplay_point_log` DISABLE KEYS */;
    586. 

  586. /*!40000 ALTER TABLE `tplay_point_log` ENABLE KEYS */;
    587. 

  587. 

  588. 

  589. -- 导出  表 appointment.tplay_smsconfig 结构
    590. 

  590. DROP TABLE IF EXISTS `tplay_smsconfig`;
    591. 

  591. CREATE TABLE IF NOT EXISTS `tplay_smsconfig` (
    592. 

  592.   `id` int(11) NOT NULL AUTO_INCREMENT,
    593. 

  593.   `sms` varchar(10) NOT NULL DEFAULT 'sms' COMMENT '标识',
    594. 

  594.   `appkey` varchar(200) NOT NULL,
    595. 

  595.   `secretkey` varchar(200) NOT NULL,
    596. 

  596.   `type` varchar(100) NOT NULL DEFAULT 'normal' COMMENT '短信类型',
    597. 

  597.   `name` varchar(100) NOT NULL COMMENT '短信签名',
    598. 

  598.   `code` varchar(100) NOT NULL COMMENT '短信模板ID',
    599. 

  599.   `content` text NOT NULL COMMENT '短信默认模板',
    600. 

  600.   PRIMARY KEY (`id`)
    601. 

  601. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='短信配置表';
    602. 

  602. 

  603. -- 正在导出表  appointment.tplay_smsconfig 的数据：~1 rows (大约)
    604. 

  604. /*!40000 ALTER TABLE `tplay_smsconfig` DISABLE KEYS */;
    605. 

  605. INSERT INTO `tplay_smsconfig` (`id`, `sms`, `appkey`, `secretkey`, `type`, `name`, `code`, `content`) VALUES
    606. 

  606. 	(1, 'sms', '', '', '', '', '', '');
    607. 

  607. /*!40000 ALTER TABLE `tplay_smsconfig` ENABLE KEYS */;
    608. 

  608. 

  609. 

  610. -- 导出  表 appointment.tplay_specialist 结构
    611. 

  611. DROP TABLE IF EXISTS `tplay_specialist`;
    612. 

  612. CREATE TABLE IF NOT EXISTS `tplay_specialist` (
    613. 

  613.   `id` int(11) NOT NULL AUTO_INCREMENT,
    614. 

  614.   `name` varchar(50) NOT NULL DEFAULT '' COMMENT '名字',
    615. 

  615.   `head_pic` varchar(255) NOT NULL DEFAULT '' COMMENT '头像',
    616. 

  616.   `sex` tinyint(4) NOT NULL DEFAULT '0' COMMENT '性别',
    617. 

  617.   `desc` varchar(500) NOT NULL DEFAULT '' COMMENT '简介',
    618. 

  618.   `consultation_direction` varchar(500) NOT NULL DEFAULT '' COMMENT '咨询方向',
    619. 

  619.   `address_id` int(11) NOT NULL COMMENT '地址',
    620. 

  620.   PRIMARY KEY (`id`)
    621. 

  621. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='专家';
    622. 

  622. 

  623. -- 正在导出表  appointment.tplay_specialist 的数据：~0 rows (大约)
    624. 

  624. /*!40000 ALTER TABLE `tplay_specialist` DISABLE KEYS */;
    625. 

  625. /*!40000 ALTER TABLE `tplay_specialist` ENABLE KEYS */;
    626. 

  626. 

  627. 

  628. -- 导出  表 appointment.tplay_urlconfig 结构
    629. 

  629. DROP TABLE IF EXISTS `tplay_urlconfig`;
    630. 

  630. CREATE TABLE IF NOT EXISTS `tplay_urlconfig` (
    631. 

  631.   `id` int(11) NOT NULL AUTO_INCREMENT,
    632. 

  632.   `aliases` varchar(200) NOT NULL COMMENT '别名',
    633. 

  633.   `url` varchar(200) NOT NULL COMMENT '原url结构',
    634. 

  634.   `desc` varchar(50) NOT NULL DEFAULT '' COMMENT '备注',
    635. 

  635.   `status` int(1) NOT NULL DEFAULT '1' COMMENT '0禁用1使用',
    636. 

  636.   `create_time` int(11) NOT NULL,
    637. 

  637.   `update_time` int(11) NOT NULL,
    638. 

  638.   PRIMARY KEY (`id`)
    639. 

  639. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='URL美化';
    640. 

  640. 

  641. -- 正在导出表  appointment.tplay_urlconfig 的数据：~1 rows (大约)
    642. 

  642. /*!40000 ALTER TABLE `tplay_urlconfig` DISABLE KEYS */;
    643. 

  643. INSERT INTO `tplay_urlconfig` (`id`, `aliases`, `url`, `desc`, `status`, `create_time`, `update_time`) VALUES
    644. 

  644. 	(1, 'admin_login/6xy8h3PBxycrCsBj4pI8$', 'admin/common/login', '后台登录地址', 1, 1517621629, 1681894088);
    645. 

  645. /*!40000 ALTER TABLE `tplay_urlconfig` ENABLE KEYS */;
    646. 

  646. 

  647. 

  648. -- 导出  表 appointment.tplay_user 结构
    649. 

  649. DROP TABLE IF EXISTS `tplay_user`;
    650. 

  650. CREATE TABLE IF NOT EXISTS `tplay_user` (
    651. 

  651.   `id` int(11) NOT NULL AUTO_INCREMENT,
    652. 

  652.   `pid` int(11) NOT NULL DEFAULT '0' COMMENT '推荐人id',
    653. 

  653.   `passport` varchar(50) NOT NULL COMMENT '账号',
    654. 

  654.   `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '昵称',
    655. 

  655.   `password` varchar(50) NOT NULL DEFAULT '' COMMENT '密码',
    656. 

  656.   `user_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '账号类型',
    657. 

  657.   `user_cate` tinyint(4) NOT NULL DEFAULT '0' COMMENT '用户角色',
    658. 

  658.   `level` int(11) NOT NULL DEFAULT '0' COMMENT '角色等级',
    659. 

  659.   `head_pic` varchar(255) NOT NULL DEFAULT '' COMMENT '头像',
    660. 

  660.   `point` int(11) NOT NULL DEFAULT '0' COMMENT '积分',
    661. 

  661.   `money` int(11) NOT NULL DEFAULT '0' COMMENT '余额',
    662. 

  662.   `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '审核状态',
    663. 

  663.   `ip` char(15) NOT NULL DEFAULT '' COMMENT '注册ip',
    664. 

  664.   `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
    665. 

  665.   `stop_time` int(11) NOT NULL DEFAULT '0' COMMENT '到期时间',
    666. 

  666.   `create_time` int(11) NOT NULL COMMENT '注册时间',
    667. 

  667.   `login_time` int(11) NOT NULL COMMENT '最后登录时间',
    668. 

  668.   `openid` varchar(50) NOT NULL DEFAULT '',
    669. 

  669.   `unionid` varchar(50) NOT NULL DEFAULT '',
    670. 

  670.   `sex` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0未知1男2女',
    671. 

  671.   `country` varchar(50) NOT NULL DEFAULT '' COMMENT '国家',
    672. 

  672.   `province` varchar(50) NOT NULL DEFAULT '' COMMENT '省份',
    673. 

  673.   `city` varchar(50) NOT NULL DEFAULT '' COMMENT '城市',
    674. 

  674.   PRIMARY KEY (`id`) USING BTREE
    675. 

  675. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表';
    676. 

  676. 

  677. -- 正在导出表  appointment.tplay_user 的数据：~0 rows (大约)
    678. 

  678. /*!40000 ALTER TABLE `tplay_user` DISABLE KEYS */;
    679. 

  679. /*!40000 ALTER TABLE `tplay_user` ENABLE KEYS */;
    680. 

  680. 

  681. 

  682. -- 导出  表 appointment.tplay_webconfig 结构
    683. 

  683. DROP TABLE IF EXISTS `tplay_webconfig`;
    684. 

  684. CREATE TABLE IF NOT EXISTS `tplay_webconfig` (
    685. 

  685.   `id` int(11) NOT NULL AUTO_INCREMENT,
    686. 

  686.   `name` varchar(50) NOT NULL DEFAULT '' COMMENT '别名',
    687. 

  687.   `is_log` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1开启日志0关闭',
    688. 

  688.   `is_close_site` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1关闭网站0开启网站',
    689. 

  689.   `file_type` varchar(200) NOT NULL DEFAULT '' COMMENT '允许上传的类型',
    690. 

  690.   `file_size` bigint(20) NOT NULL DEFAULT '500' COMMENT '允许上传的最大值',
    691. 

  691.   `black_ip` varchar(2000) NOT NULL DEFAULT '' COMMENT 'ip黑名单',
    692. 

  692.   `article_ftp_config` varchar(500) NOT NULL DEFAULT '' COMMENT 'ftp配置',
    693. 

  693.   `article_editor` varchar(50) NOT NULL DEFAULT '' COMMENT '文章编辑器',
    694. 

  694.   `article_static_path` varchar(255) NOT NULL DEFAULT '' COMMENT '文章HTML目录',
    695. 

  695.   `data_backup_path` varchar(255) NOT NULL DEFAULT '' COMMENT '备份目录',
    696. 

  696.   `article_templet_path` varchar(255) NOT NULL DEFAULT '' COMMENT '文章模板目录',
    697. 

  697.   PRIMARY KEY (`id`)
    698. 

  698. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='系统配置';
    699. 

  699. 

  700. -- 正在导出表  appointment.tplay_webconfig 的数据：~1 rows (大约)
    701. 

  701. /*!40000 ALTER TABLE `tplay_webconfig` DISABLE KEYS */;
    702. 

  702. INSERT INTO `tplay_webconfig` (`id`, `name`, `is_log`, `is_close_site`, `file_type`, `file_size`, `black_ip`, `article_ftp_config`, `article_editor`, `article_static_path`, `data_backup_path`, `article_templet_path`) VALUES
    703. 

  703. 	(1, '咨询预约', 1, 0, 'jpg,png,gif,mp4,zip,jpeg,html', 1024, '', '', 'wangEditor', '', '', '');
    704. 

  704. /*!40000 ALTER TABLE `tplay_webconfig` ENABLE KEYS */;
    705. 

  705. /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
    706. 

  706. /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
    707. 

  707. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    708.