DROP TABLE IF EXISTS `pk_app_hadskycloudserver_cloudpay_record`;
CREATE TABLE `pk_app_hadskycloudserver_cloudpay_record` (
  `id` int(11) NOT NULL,
  `hs_id` bigint(20) NOT NULL DEFAULT '0',
  `uid` int(11) NOT NULL DEFAULT '0',
  `rmb` int(11) NOT NULL DEFAULT '0',
  `tiandou` int(11) NOT NULL DEFAULT '0',
  `createtime` int(11) NOT NULL DEFAULT '0',
  `finishtime` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `pk_app_hadskycloudserver_weixinlogin_record`;
CREATE TABLE `pk_app_hadskycloudserver_weixinlogin_record` (
  `id` bigint(20) NOT NULL,
  `uid` bigint(20) NOT NULL DEFAULT '0',
  `openid` varchar(255) NOT NULL DEFAULT '',
  `idcode` varchar(255) NOT NULL DEFAULT '',
  `regtime` int(11) NOT NULL DEFAULT '0',
  `logtime` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `pk_app_puyuetian_sms_record`;
CREATE TABLE `pk_app_puyuetian_sms_record` (
  `id` int(11) NOT NULL,
  `pn` varchar(11) NOT NULL,
  `ip` varchar(255) NOT NULL,
  `date` int(8) NOT NULL,
  `state` varchar(255) NOT NULL DEFAULT 'no',
  `msg` text,
  `datetime` datetime NOT NULL,
  `code` varchar(1024) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `pk_download_record`;
CREATE TABLE `pk_download_record` (
  `id` int(11) NOT NULL,
  `downloadid` int(11) NOT NULL DEFAULT '0',
  `uid` int(11) NOT NULL DEFAULT '0',
  `tiandou` int(11) NOT NULL DEFAULT '0',
  `datetime` bigint(20) NOT NULL DEFAULT '20000101000000',
  `leixing` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `pk_read`;
CREATE TABLE `pk_read` (
  `id` int(11) UNSIGNED NOT NULL COMMENT '文章的id',
  `sortid` int(11) NOT NULL DEFAULT '0' COMMENT '文章所属版块id',
  `uid` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '发布人uid',
  `title` text NOT NULL COMMENT '文章标题',
  `content` longtext NOT NULL COMMENT '文章内容',
  `looknum` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '浏览次数',
  `zannum` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '被赞次数',
  `posttime` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '发布时间',
  `readlevel` int(11) NOT NULL DEFAULT '0' COMMENT '文章阅读权限',
  `replyuid` int(11) UNSIGNED NOT NULL DEFAULT '2' COMMENT '最后回复人uid',
  `replycontent` text COMMENT '最新回复内容',
  `replytime` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最后回复时间',
  `replyip` varchar(255) DEFAULT NULL COMMENT '最后回复人的ip',
  `postip` varchar(255) DEFAULT NULL COMMENT '发布人的ip',
  `top` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '文章置顶',
  `high` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '文章精华',
  `locked` tinyint(3) NOT NULL DEFAULT '0',
  `replyafterlook` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '回复后可见',
  `data` longtext COMMENT '文章其他数据',
  `del` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '1为删除，0为正常',
  `activetime` int(11) NOT NULL DEFAULT '0' COMMENT '最后活动时间',
  `replyid` int(11) NOT NULL DEFAULT '0' COMMENT '回复的id',
  `fs` int(11) NOT NULL DEFAULT '1' COMMENT '回复的楼层数',
  `label` text COMMENT '标签',
  `jvhuo_gid` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文章表' ROW_FORMAT=COMPACT;
INSERT INTO `pk_read` (`id`, `sortid`, `uid`, `title`, `content`, `looknum`, `zannum`, `posttime`, `readlevel`, `replyuid`, `replycontent`, `replytime`, `replyip`, `postip`, `top`, `high`, `locked`, `replyafterlook`, `data`, `del`, `activetime`, `replyid`, `fs`, `label`, `jvhuo_gid`) VALUES
(1, 1, 1, '欢迎您使用HadSky轻论坛！', '您好，我是乐天，HadSky轻论坛的创始人及开发者，很高兴您选择HadSky轻论坛，HadSky是一款国产、原创、开源、免费的掌上轻论坛系统，HadSky基于puyuetianPHP和puyuetianUI开发，整套软件版权都归作者蒲乐天所有，整套原创，您可以放心使用。<p><br></p><p>使用HadSky轻论坛您必须遵守HadSky用户协议<a target=\"_blank\" href=\"http://www.hadsky.com/index.php?c=read&amp;id=281&amp;page=1\">http://www.hadsky.com/index.php?c=read&amp;id=281&amp;page=1</a>，请您仔细阅读用户协议，并遵守协议，我们才能更好的为您服务。</p><p><br></p><p>购买授权成为VIP会员享受更好的待遇和服务，个人版授权77元/年，尊享版授权770元/年，买2年送1年，买5年送3年，同时拥有会员标识VIP或SVIP，赠送海量天豆和高级群待遇，购买地址：<a target=\"_blank\" href=\"http://www.hadsky.com/htmlpage-purchase.html\">http://www.hadsky.com/htmlpage-purchase.html</a></p><p><br></p><p>若您在试用过程中遇到了bug或问题，请及时反馈到我们的官坛<a target=\"_blank\" href=\"http://www.hadsky.com\">http://www.hadsky.com</a></p><p></p><p><br></p><p>感谢您选择HadSky，让我们一起努力让HadSky更好、更美、更强大！</p><p><br></p><p style=\"text-align: right;\">By puyuetian</p><p style=\"text-align: right;\">2018年07月07日</p>', 8, 0, 1469069740, 0, 2, NULL, 0, NULL, '::1', 1, 1, 0, 0, NULL, 0, 1554345863, 1, 2, '原创,爆料', 0),
(2, 1, 1, 'HadSky云服务，免签约在线支付及短信发送功能！', 'HadSky开启了云登录与云支付功能，只要您配置好与HadSky的sitekey即可实现免签约在线支付宝支付和免签约登录第三方账号！<p>同时还具有云短信发送功能及其他更多高级功能，欢迎大家使用！<br></p><p><br></p><p>详情地址：<a target=\"_blank\" href=\"http://www.hadsky.com/app-puyuetian_documents-index.html#rid1924\">http://www.hadsky.com/app-puyuetian_documents-index.html#rid1924</a></p><p><br></p><p>HadSky发展离不开大家的支持，欢迎大家提出建议和反馈问题！</p><p></p>', 7, 0, 1500722725, 0, 2, NULL, 0, NULL, '::1', 0, 0, 0, 0, NULL, 0, 1500722725, 0, 1, '原创', 0),
(3, 1, 1, '感谢您安装及使用HadSky轻论坛，送您一套新模板！', '感谢您安装及使用HadSky轻论坛，送您一套新模板 - FlyTemplate轻社区模板，您可以在后台 - 应用 - 本地模板处进行模板的切换。', 1, 0, 1603766768, 0, 2, NULL, 0, NULL, '127.0.0.1', 0, 0, 0, 0, NULL, 0, 1603766768, 0, 1, '', 0),
(4, 1, 1, '<font class=\"pk-hadsky\" color=\"#FF0000\">在线发卡、发激活码就上聚货网！</font>', '聚货网免费开店，在线直接发卡、发卡密、发激活，个人站长建站首选店铺！<p><br></p><p>直达链接：<a target=\"_blank\" href=\"https://www.jvhuo.com/?from=install_hadsky\">https://www.jvhuo.com/?from=install_hadsky</a></p>', 1, 0, 1603766890, 0, 2, NULL, 0, NULL, '127.0.0.1', 0, 0, 0, 0, NULL, 0, 1603766890, 0, 1, '', 0),
(5, 1, 1, '搜可得SEO外链网在线免费发布外链网', '搜可得SEO外链网在线免费发布外链网，提高网站曝光率，增加流量！<p><br></p><p>直达链接：<a target=\"_blank\" href=\"https://www.sokede.com/\">https://www.sokede.com/</a></p>', 1, 0, 1603767231, 0, 2, NULL, 0, NULL, '127.0.0.1', 0, 0, 0, 0, NULL, 0, 1603767231, 0, 1, '爆料', 0);
DROP TABLE IF EXISTS `pk_readsort`;
CREATE TABLE `pk_readsort` (
  `id` int(11) UNSIGNED NOT NULL COMMENT '版块的id',
  `pid` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '所属父版块的id',
  `rank` int(11) NOT NULL DEFAULT '0' COMMENT '版块排序，从小到大',
  `title` text NOT NULL COMMENT '版块名称',
  `content` text COMMENT '版块说明',
  `url` text COMMENT '点击分类跳转的url',
  `logourl` text COMMENT '版块logo图片地址',
  `postlevel` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户发帖需要的阅读权限',
  `replylevel` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户回复需要的阅读权限',
  `adminuids` text COMMENT '管理员uid',
  `looklevel` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户看帖需要的阅读权限',
  `show` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '1:显示 0:隐藏',
  `showchildlist` tinyint(3) NOT NULL DEFAULT '0' COMMENT '是否显示想下级版块文章',
  `label` text COMMENT '标签',
  `banpostread` int(11) NOT NULL DEFAULT '0' COMMENT '该板块是否允许发帖',
  `allowgroupids` text COMMENT '允许进入的用户组',
  `webtitle` text,
  `webkeywords` text,
  `webdescription` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='版块分类表' ROW_FORMAT=COMPACT;
INSERT INTO `pk_readsort` (`id`, `pid`, `rank`, `title`, `content`, `url`, `logourl`, `postlevel`, `replylevel`, `adminuids`, `looklevel`, `show`, `showchildlist`, `label`, `banpostread`, `allowgroupids`, `webtitle`, `webkeywords`, `webdescription`) VALUES
(1, 0, 0, '新版块', '', '', '', 0, 0, '', 0, 1, 0, '原创,爆料', 0, NULL, NULL, NULL, NULL),
(2, 1, 0, '子版块', '', '', '', 0, 0, '', 0, 1, 0, '', 0, '', '', '', '');
DROP TABLE IF EXISTS `pk_reply`;
CREATE TABLE `pk_reply` (
  `id` int(11) NOT NULL COMMENT '回复的id',
  `rid` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '回复的文章id',
  `uid` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '回复人uid',
  `content` text NOT NULL COMMENT '回复内容',
  `posttime` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '回复时间',
  `postip` varchar(255) DEFAULT NULL COMMENT '发布人的ip',
  `zannum` int(11) NOT NULL DEFAULT '0' COMMENT '赞数',
  `top` tinyint(3) NOT NULL DEFAULT '0' COMMENT '置顶',
  `del` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1删除，0正常',
  `fnum` int(11) NOT NULL DEFAULT '0' COMMENT '当前回复的楼层数',
  `data` longtext
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='回复表';
INSERT INTO `pk_reply` (`id`, `rid`, `uid`, `content`, `posttime`, `postip`, `zannum`, `top`, `del`, `fnum`, `data`) VALUES
(1, 1, 1, 'HS7beta版本发布', 1554345863, '::1', 0, 0, 0, 2, NULL);
DROP TABLE IF EXISTS `pk_set`;
CREATE TABLE `pk_set` (
  `id` int(11) UNSIGNED NOT NULL COMMENT '基本设置id',
  `setname` char(255) NOT NULL COMMENT '变量名称',
  `setvalue` text COMMENT '变量值',
  `noload` tinyint(3) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='系统设置表' ROW_FORMAT=COMPACT;
INSERT INTO `pk_set` (`id`, `setname`, `setvalue`, `noload`) VALUES
(2, 'bbcodemarks', '<b><i><u><strong><font><pre><code><p><span><table><thead><tbody><tfoot><tr><td><th><a><em><h1><h2><h3><h4><h5><h6><img><label><ul><ol><li><br><audio><embed><video>', 0),
(3, 'footerhtmlcode', '<a target=\"_blank\" href=\"https://www.hadsky.com\" class=\"\" onclick=\"\">HadSky轻论坛</a>\n\n			<a href=\"https://www.jvhuo.com\" class=\"\" target=\"_blank\" onclick=\"\">聚货网|在线发卡</a><a href=\"https://www.sokede.com/\" class=\"\" target=\"_blank\" onclick=\"\">搜可得SEO外链网</a>', 0),
(4, 'headerhtmlcode', '<a target=\"_blank\" href=\"https://www.hadsky.com\" class=\"\" onclick=\"\">官方论坛</a>', 0),
(5, 'quotes', '支持原创软件，抵制盗版，共创美好明天！', 0),
(6, 'templatename', 'puyuetian_fly', 0),
(7, 'webdescription', 'HadSky轻论坛 - 轻、快、简的原创论坛系统！这是一款对非营利性个人用户免费开放的论坛系统，基于原创的puyuetianPHP快速开发框架设计，新的论坛，新的世界！', 0),
(8, 'webkeywords', 'hadsky,有天,轻论坛,puyuetian,蒲乐天', 0),
(9, 'weblogo', 'template/default/img/logo.png', 0),
(10, 'webname', '有天轻论坛', 0),
(11, 'reg', '1', 0),
(12, 'reguserquanxian', 'bbcode,login,lookuser,postreply,uploadfile,uploadhead,search,postread,lookread,download', 0),
(13, 'readlistnum', '10', 0),
(14, 'replylistnum', '10', 0),
(15, 'logotext', 'HadSky', 0),
(16, 'qiandaojifen', '10', 0),
(17, 'qiandaotiandou', '10', 0),
(18, 'readsort', '', 0),
(19, 'navhtmlcode', '<li><a href=\"index.php?c=home\">首页</a></li>\n<li><a href=\"index.php?c=list\">动态</a></li>\n<li><a href=\"index.php?c=forum\">版块</a></li>\n<li><a target=\"_blank\" href=\"http://www.hadsky.com/app-puyuetian_documents-index.html\">使用文档</a></li>\n\n<li><a target=\"_blank\" href=\"http://www.hadsky.com/htmlpage-purchase.html\">购买产品</a></li>\n<li><a target=\"_blank\" href=\"http://www.hadsky.com/read-281-1.html\">用户协议</a></li>', 0),
(20, 'uploadfiletypes', 'jpg|jpeg|gif|bmp|png|zip|rar|txt|doc', 0),
(21, 'uploadfilesize', '2000', 0),
(22, 'postreadjifen', '5', 0),
(23, 'postreadtiandou', '5', 0),
(24, 'postreplyjifen', '2', 0),
(25, 'postreplytiandou', '2', 0),
(27, 'defaultpage', 'list', 0),
(29, 'rewriteurl', '0', 0),
(30, 'downloadfilernd', '258', 0),
(31, 'openverifycode', '0', 0),
(32, 'phonetemplatename', 'puyuetian_fly', 0),
(33, 'regmessage', '恭喜您注册成功！', 0),
(44, 'jifenname', '经验', 0),
(45, 'tiandouname', '金钱', 0),
(46, 'regjifen', '0', 0),
(47, 'regtiandou', '0', 0),
(48, 'friendlinks', '<a target=\"_blank\" href=\"https://www.hadsky.com\" class=\"\" onclick=\"\">HadSky轻论坛</a><a href=\"https://www.jvhuo.com\" class=\"\" target=\"_blank\" onclick=\"\">聚货网|在线发卡</a><a href=\"https://www.sokede.com/\" class=\"\" target=\"_blank\" onclick=\"\">搜可得SEO外链网</a>', 0),
(49, 'postingtimeinterval', '30', 0),
(50, 'postaudit', '0', 0),
(51, 'newuserpostwaittime', '0', 0),
(52, 'beianhao', '&nbsp;免备案', 0),
(53, 'bbcodeattrs', 'class,style,href,target,src,width,height,title,alt,border,align,valign,color,size,controls,autoplay,loop,type,face,id,lang', 0),
(54, 'readtitlemin', '1', 0),
(55, 'readtitlemax', '1250', 0),
(56, 'readcontentmin', '1', 0),
(57, 'readcontentmax', '999999', 0),
(58, 'replycontentmin', '1', 0),
(59, 'replycontentmax', '999999', 0),
(60, 'replyorder', '1', 0),
(61, 'readtopnum', '3', 0),
(62, 'webtitle', 'HadSky', 0),
(63, 'template_default_headhtml', '', 0),
(64, 'template_default_banner', '<div class=\"pk-padding-top-30 pk-padding-bottom-30\"><a title=\"HadSky轻论坛\" href=\"/\"><img src=\"template/default/img/logo.png\" alt=\"HadSky\"></a></div>', 0),
(65, 'template_default_searchrighthtml', '<div class=\"pk-text-right pk-text-xs pk-text-default\">支持原创软件，共创美好明天！</div>', 0),
(66, 'template_default_tjwzids', '', 0),
(67, 'template_default_jhnum', '0', 0),
(68, 'template_default_rtnum', '0', 0),
(69, 'defaulttemplates', 'default', 0),
(70, 'runerrordisplay', '1', 0),
(71, 'openreg', '1', 0),
(85, 'app_superadmin_load', '1', 0),
(88, 'app_puyuetianeditor_load', 'embed', 0),
(89, 'template_default_ad1htmlcode', '', 0),
(90, 'template_default_ad2htmlcode', '', 0),
(91, 'template_default_ad3htmlcode', '', 0),
(92, 'guestdata', '{\"username\":\"guest\",\"nickname\":\"游客\",\"quanxian\":\"bbcode,lookuser,postreply,search,lookread,download,nopostingtimeinterval\",\"readlevel\":\"0\",\"data\":\"{\\\"htmlcodemarks\\\":\\\"\\\",\\\"htmlcodeattrs\\\":\\\"\\\",\\\"uploadsize\\\":\\\"\\\"}\"}', 0),
(93, 'template_default_randheadcount', '24', 0),
(95, 'novicetraineetime', '2', 0),
(96, 'postreadcheck', '0', 0),
(97, 'postreplycheck', '0', 0),
(107, 'app_puyuetian_search_load', '1', 0),
(108, 'app_puyuetian_search_showcount', '20', 0),
(109, 'readlistorder', 'posttime', 0),
(110, 'showmessagecount', '50', 0),
(111, 'closeregtip', '本站暂未开启注册功能！', 0),
(112, 'uploadheadsize', '500', 0),
(113, 'trylogincount', '10', 0),
(114, 'changeuserinfoverify', '0', 0),
(115, 'app_puyuetianeditor_pceditconfig', 'var PytConfig = \'Html,Bold,Italic,Underline,Strikethrough,Removemarks,Fontname,Fontsize,Forecolor,Backcolor,Justifyleft,Justifycenter,Justifyright,Link,Unlink,Table,Emotion,Image,File,Video,Music,Myfiles,Code,Replylook,Undo,Redo\';', 0),
(116, 'app_puyuetianeditor_pcreadconfig', 'var PytConfig = \'Html,Bold,Italic,Underline,Emotion,Image,Code\';', 0),
(117, 'app_puyuetianeditor_phoneeditconfig', 'var PytConfig = \'Emotion,Image,File,Link,Code,Replylook\';', 0),
(118, 'app_puyuetianeditor_phonereadconfig', 'var PytConfig = \'Emotion,Image,Code\';', 0),
(119, 'yunserver', '1', 0),
(120, 'phonedomains', '', 0),
(121, 'ifpccomephonego', '1', 0),
(122, 'phonedefaulttemplates', 'default', 0),
(123, 'readlistshowbks', '', 0),
(124, 'readlisthiddenbks', '', 0),
(125, 'usernameeverychars', '1', 0),
(126, 'regway', 'normal', 0),
(127, 'regreadlevel', '10', 0),
(128, 'reguserdata', '', 0),
(129, 'app_puyuetianeditor_quickpost', '1', 0),
(130, 'app_puyuetianeditor_quickeditconfig', 'var PytConfig = \'Html,Bold,Italic,Underline,Strikethrough,Justifyleft,Justifycenter,Justifyright,Link,Unlink,Emotion,Image,Code,Replylook,Undo,Redo\';', 0),
(131, 'chkcsrfval', 'b02e0dae59241656173c568fb32d0287', 0),
(132, 'uploadfilecount', '5', 0),
(133, 'dayuploadfilesize', '10000', 0),
(134, 'downloadedrecord', '1', 0),
(147, 'key', 's8FkqUQQelhAmyiMaXQMZr6YwoiATHsj', 0),
(148, 'chkcsrf', '0', 0),
(149, 'chkcsrfpages', '', 0),
(150, 'sitestatus', '0', 0),
(151, 'siteclosedtip', '维护中...', 0),
(152, 'usercookieslife', '31536000', 0),
(153, 'userloginemailtip', '0', 0),
(154, 'regusergroupid', '1', 0),
(155, 'app_verifycode_load', '1', 0),
(156, 'app_verifycode_page', '', 0),
(157, 'app_verifycode_chars', '1234567890', 0),
(158, 'app_verifycode_length', '', 0),
(159, 'app_verifycode_width', '', 0),
(160, 'app_verifycode_height', '', 0),
(161, 'app_verifycode_fontsize', '', 0),
(162, 'app_puyuetianeditor_watermark_text', '', 0),
(163, 'app_puyuetianeditor_watermark_textcolor_r', '255', 0),
(164, 'app_puyuetianeditor_watermark_textcolor_g', '255', 0),
(165, 'app_puyuetianeditor_watermark_textcolor_b', '255', 0),
(166, 'app_puyuetianeditor_watermark_pp', '0', 0),
(167, 'app_puyuetianeditor_watermark_px', '5', 0),
(168, 'app_puyuetianeditor_watermark_py', '24', 0),
(169, 'app_puyuetianeditor_watermark_fontsize', '14', 0),
(170, 'defaultlabel', '原创,爆料', 0),
(171, 'app_hadskycloudserver_load', 'embed', 0),
(172, 'app_hadskycloudserver_sitekey', '', 0),
(173, 'app_hadskycloudserver_qqlogin_openreg', '0', 0),
(174, 'app_hadskycloudserver_weibologin_openreg', '0', 0),
(175, 'app_hadskycloudserver_baidulogin_openreg', '0', 0),
(176, 'app_hadskycloudserver_tiandouduihuanshu', '10', 0),
(177, 'phonedefaultpage', 'list', 0),
(178, 'mysqlcachecycle', '0', 0),
(179, 'mysqlcachetables', 'read', 0),
(180, 'safe_request_uri', '0', 0),
(181, '_webos', 'HadSky', 0),
(182, 'oldusercentertonewusercenter', '1', 0),
(183, 'postmessagemaxnum', '1000', 0),
(184, 'postreadtitlecolorusergroup', '', 0),
(185, 'banpostwords', '', 0),
(186, 'regfriends', '', 0),
(187, 'regagreement', '请在后台 - 全局 - 注册相关 - 用户注册协议处设置内容', 0),
(188, 'banregwords', '', 0),
(189, 'webaddedwords', 'HadSky', 0),
(190, 'mustrewriteurl', '1', 0),
(191, 'cookie_domain', '', 0),
(192, 'usermultipleonline', '1', 0),
(193, 'supermanloginemailtip', '1', 0),
(194, 'app_verifycode_opensliding', '0', 0),
(195, 'app_puyuetianeditor_pcheight', '500px', 0),
(196, 'app_puyuetianeditor_phoneheight', '200px', 0),
(197, 'app_puyuetianeditor_compress_wh', '1366,0', 0),
(198, 'app_puyuetianeditor_showfile_ad1', '', 0),
(199, 'app_puyuetianeditor_showfile_ad2', '', 0),
(200, 'app_hadskycloudserver_nodes', '{\"shanghai\":\"\\u534e\\u4e1c\\uff08\\u4e0a\\u6d77\\uff09\",\"guangzhou\":\"\\u534e\\u5357\\uff08\\u5e7f\\u5dde\\uff09\",\"hk\":\"\\u9999\\u6e2f\"}', 0),
(201, 'app_hadskycloudserver_node', 'auto', 0),
(202, 'app_hadskycloudserver_weixinlogin_openreg', '0', 0),
(203, 'app_hadskycloudserver_sms_open', '1', 0),
(204, 'app_puyuetian_sms_verifycode', '1', 0),
(205, 'app_puyuetian_sms_mustreg', '0', 0),
(206, 'app_puyuetian_sms_pnmax', '', 0),
(207, 'app_puyuetian_sms_ipmax', '', 0),
(208, 'app_filesmanager_load', '1', 0),
(209, 'app_jvhuo_load', '1', 0),
(210, 'app_jvhuo_apiuid', '', 0),
(211, 'app_jvhuo_apicode', '', 0),
(212, 'app_jvhuo_postuids', '', 0),
(213, 'app_jvhuo_postbkid', '', 0),
(214, 'app_jvhuo_postlabel', '', 0),
(215, 'app_mysqlmanager_load', '1', 0),
(216, 'securelogin', '1', 0),
(217, 'template_puyuetian_fly_hotreadsortids', '', 0),
(218, 'template_puyuetian_fly_hotreadcount', '10', 0),
(219, 'template_puyuetian_fly_hotreaddays', '', 0),
(220, 'template_puyuetian_fly_ad_yc1', '<div class=\"fly-panel\">\n	<h3 class=\"fly-panel-title\">后台 - 应用 - 本地模板 - FlyTemplate设置 - 右侧广告位1</h3>\n	<ul class=\"fly-panel-main fly-list-static\">\n		<li><a target=\"_blank\" href=\"https://www.hadsky.com/app-puyuetian_documents-index.html\">HadSky使用文档</a></li>\n		<li><a target=\"_blank\" href=\"https://www.hadsky.com/read-4673-1.html\">HS建站攻略，花最少的钱，建最“骚”的站！</a></li>\n		<li><a target=\"_blank\" href=\"https://www.hadsky.com/app-hadskydownload-app.html\">官方APP体验</a></li>\n		<li><a target=\"_blank\" href=\"https://www.hadsky.com/read-6221-1.html\">HS仿抖音插件：HS轻视频</a></li>\n		<li><a target=\"_blank\" href=\"https://www.hadsky.com/appstore.html?auto=1&dir=puyuetian_copyweibo&rid=4645\">仿微博手机模板</a></li>\n	</ul>\n</div>', 0),
(221, 'template_puyuetian_fly_ad_yc2', '<div class=\"fly-panel\">\n	<div class=\"fly-panel-main\">\n		<a href=\"#\"><img src=\"template/puyuetian_fly/res/images/350ad.png\" alt=\"ad\"></a>\n	</div>\n</div>', 0),
(222, 'template_puyuetian_fly_ad_yc3', '<div class=\"fly-panel\">\n	<div class=\"fly-panel-title\">后台 - 应用 - 本地模板 - FlyTemplate设置 - 右侧广告位3</div>\n	<div class=\"fly-panel-main\">\n		<a target=\"_blank\" href=\"https://www.jvhuo.com/?from=install_hadsky\">聚货网 - 免费在线开店发卡</a>\n	</div>\n</div>', 0),
(223, 'template_puyuetian_fly_ad_yc4', '<div class=\"fly-panel\">\n	<a href=\"#\"><img src=\"template/puyuetian_fly/res/images/380ad.png\" alt=\"ad\"></a>\n</div>', 0),
(224, 'template_puyuetian_fly_listshowvideo', '1', 0),
(225, 'template_puyuetian_fly_readimgnum', '3', 0),
(226, 'admin_login_notice_phone', '1', 0),
(227, 'app_puyuetian_sms_signname', '', 0),
(228, 'globalcdn', '0', 0),
(229, 'app_systememail_load', '0', 0),
(230, 'app_systememail_phpmailer', '0', 0),
(231, 'app_systememail_debug', '0', 0),
(232, 'app_systememail_timeoutseconds', '', 0),
(233, 'app_systememail_smtp', '', 0),
(234, 'app_systememail_port', '', 0),
(235, 'app_systememail_user', '', 0),
(236, 'app_systememail_pass', '', 0),
(237, 'app_systememail_emailverify', '0', 0),
(238, 'app_systememail_regsendemail', '1', 0),
(239, 'app_systememail_replysendemail', '1', 0),
(240, 'app_puyuetianeditor_pceasypostread', '0', 0),
(241, 'app_puyuetianeditor_pceasypostreply', '0', 0),
(242, 'app_puyuetianeditor_phoneeasypostread', '1', 0),
(243, 'app_puyuetianeditor_phoneeasypostreply', '1', 0),
(244, 'app_puyuetianeditor_editconfig', '', 0),
(245, 'app_puyuetianeditor_readconfig', '', 0);
DROP TABLE IF EXISTS `pk_upload`;
CREATE TABLE `pk_upload` (
  `id` int(11) UNSIGNED NOT NULL,
  `uid` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上传用户',
  `rid` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '所在的帖子id',
  `name` text COMMENT '上传的文件名',
  `suffix` text COMMENT '文件后缀',
  `uploadtime` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上传时间',
  `datetime` bigint(20) NOT NULL DEFAULT '0' COMMENT '上传时间YYYYMMDDHHIISS',
  `rand` varchar(255) NOT NULL DEFAULT '' COMMENT '产生的随机数',
  `idcode` varchar(255) NOT NULL DEFAULT '' COMMENT '识别码',
  `jifen` int(11) NOT NULL DEFAULT '0' COMMENT '消耗积分',
  `tiandou` int(11) NOT NULL DEFAULT '0' COMMENT '消耗的天豆',
  `target` varchar(255) NOT NULL DEFAULT '' COMMENT '所存在的文件夹',
  `downloadcount` int(11) NOT NULL DEFAULT '0' COMMENT '下载次数',
  `downloadeduids` longtext COMMENT '已下载用户的uid',
  `url` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='论坛附件上传记录';
DROP TABLE IF EXISTS `pk_user`;
CREATE TABLE `pk_user` (
  `id` int(11) UNSIGNED NOT NULL COMMENT '用户的uid',
  `username` char(255) NOT NULL DEFAULT '' COMMENT '用户名，仅允许字母和数字和下划线',
  `password` text NOT NULL COMMENT '加密后的密码',
  `nickname` text COMMENT '用户昵称',
  `quanxian` text COMMENT '用户具有的权限',
  `tiandou` int(11) NOT NULL DEFAULT '0' COMMENT '天豆数',
  `jifen` int(11) NOT NULL DEFAULT '0' COMMENT '积分数',
  `logininfo` text COMMENT '最后一次登录信息',
  `reginfo` text COMMENT '用户注册信息',
  `sex` text COMMENT '性别',
  `birthday` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '生日',
  `email` varchar(255) DEFAULT NULL COMMENT 'email地址',
  `qq` text COMMENT 'QQ',
  `phone` text COMMENT '手机号',
  `adress` text COMMENT '联系地址',
  `sign` text COMMENT '用户个性签名',
  `friends` text COMMENT '用户好友',
  `readlevel` int(11) NOT NULL DEFAULT '0' COMMENT '用户阅读权限',
  `qqopenid` varchar(255) DEFAULT NULL COMMENT 'qq登录openid',
  `data` longtext COMMENT '用户数据',
  `logintime` int(11) NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `regtime` int(11) NOT NULL DEFAULT '0' COMMENT '注册时间',
  `session_token` varchar(255) DEFAULT NULL COMMENT '登录时产生的识别码',
  `groupid` int(11) NOT NULL DEFAULT '0' COMMENT '用户组id',
  `wxopenid` varchar(255) DEFAULT NULL COMMENT '微信登录openid',
  `weibo_uid` varchar(255) DEFAULT NULL,
  `baidu_userid` varchar(255) DEFAULT NULL,
  `regip` varchar(255) DEFAULT NULL,
  `loginip` varchar(255) DEFAULT NULL,
  `weixin_openids` text,
  `idol` longtext,
  `fans` longtext,
  `collect` longtext
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户表';
INSERT INTO `pk_user` (`id`, `username`, `password`, `nickname`, `quanxian`, `tiandou`, `jifen`, `logininfo`, `reginfo`, `sex`, `birthday`, `email`, `qq`, `phone`, `adress`, `sign`, `friends`, `readlevel`, `qqopenid`, `data`, `logintime`, `regtime`, `session_token`, `groupid`, `wxopenid`, `weibo_uid`, `baidu_userid`, `regip`, `loginip`, `weixin_openids`, `idol`, `fans`, `collect`) VALUES
(1, 'admin', '27da85f99b6e1207a71b6c4dd6404ddb', '创始人', 'bbcode,login,lookuser,postreply,uploadfile,delread,editread,nopostreadcheck,noverifycode,admin,htmlcode,superman,nopostingtimeinterval,nopostreplycheck,editreply,delreply,uploadhead,search,postread,lookread,download', 27, 27, NULL, NULL, 's', 20180709, 'admin@hadsky.com', '', '', '', '有些梦虽然遥不可及，但并不是不可能实现。', NULL, 0, NULL, '{\"trylogindata\":\"{\\\"127.0.0.1\\\":0}\",\"logindate\":\"20201027\",\"lasttimereadposttime\":\"1603767253\",\"privacysettings\":\"0\",\"lasttimereplyposttime\":\"1554345863\"}', 1603764522, 0, 'iPkkF6v', 0, NULL, NULL, NULL, NULL, '127.0.0.1', NULL, NULL, NULL, NULL);
DROP TABLE IF EXISTS `pk_usergroup`;
CREATE TABLE `pk_usergroup` (
  `id` int(11) NOT NULL,
  `usergroupname` varchar(255) NOT NULL DEFAULT '' COMMENT '用户组名称',
  `quanxian` text COMMENT '用户组权限',
  `readlevel` int(11) NOT NULL DEFAULT '0' COMMENT '阅读权限',
  `data` longtext COMMENT '其他数据'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `pk_usergroup` (`id`, `usergroupname`, `quanxian`, `readlevel`, `data`) VALUES
(1, '普通会员', 'bbcode,login,lookuser,postreply,uploadfile,uploadhead,search,postread,lookread,download', 10, '{\"htmlcodemarks\":\"\",\"htmlcodeattrs\":\"\",\"signcodemarks\":\"\",\"signcodeattrs\":\"\",\"uploadsize\":\"\",\"dayuploadfilesize\":\"\"}');
DROP TABLE IF EXISTS `pk_user_message`;
CREATE TABLE `pk_user_message` (
  `id` int(11) UNSIGNED NOT NULL COMMENT '消息的id',
  `uid` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '消息用户的uid',
  `fid` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '来自哪个用户的uid',
  `content` text COMMENT '消息内容',
  `islook` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '此消息是否被查看',
  `addtime` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '消息添加时间'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户消息表';
ALTER TABLE `pk_app_hadskycloudserver_cloudpay_record`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `pk_app_hadskycloudserver_weixinlogin_record`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `pk_app_puyuetian_sms_record`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `pk_download_record`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `pk_read`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `pk_readsort`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `pk_reply`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `pk_set`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `setname` (`setname`);
ALTER TABLE `pk_upload`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `pk_user`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`);
ALTER TABLE `pk_usergroup`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `pk_user_message`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `pk_app_hadskycloudserver_cloudpay_record`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
ALTER TABLE `pk_app_hadskycloudserver_weixinlogin_record`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
ALTER TABLE `pk_app_puyuetian_sms_record`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
ALTER TABLE `pk_download_record`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
ALTER TABLE `pk_read`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '文章的id', AUTO_INCREMENT=6;
ALTER TABLE `pk_readsort`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '版块的id', AUTO_INCREMENT=3;
ALTER TABLE `pk_reply`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '回复的id', AUTO_INCREMENT=2;
ALTER TABLE `pk_set`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '基本设置id', AUTO_INCREMENT=246;
ALTER TABLE `pk_upload`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `pk_user`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户的uid', AUTO_INCREMENT=2;
ALTER TABLE `pk_usergroup`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
ALTER TABLE `pk_user_message`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '消息的id';
