97 Star 546 Fork 200

若水印象 / tp6

Create your Gitee Account
Explore and code with more than 6 million developers,Free private repositories !:)
Sign up
Clone or download
siyucms.sql 260.02 KB
Copy Edit Web IDE Raw Blame History
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505
/*
Navicat MySQL Data Transfer
Source Server : 本地
Source Server Version : 50726
Source Host : localhost:3306
Source Database : tp6
Target Server Type : MYSQL
Target Server Version : 50726
File Encoding : 65001
Date: 2021-04-16 14:01:53
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for tp_ad
-- ----------------------------
DROP TABLE IF EXISTS `tp_ad`;
CREATE TABLE `tp_ad` (
`id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`create_time` int(11) NOT NULL,
`update_time` int(11) NOT NULL,
`sort` mediumint(8) DEFAULT '50' COMMENT '排序',
`status` tinyint(1) DEFAULT NULL COMMENT '状态',
`type_id` text NOT NULL COMMENT '广告位',
`name` varchar(255) NOT NULL DEFAULT '' COMMENT '广告名称',
`image` varchar(80) NOT NULL DEFAULT '' COMMENT '图片',
`thumb` varchar(80) NOT NULL DEFAULT '' COMMENT '缩略图',
`url` varchar(255) NOT NULL DEFAULT '' COMMENT '链接地址',
`description` varchar(250) NOT NULL DEFAULT '' COMMENT '备注',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='广告列表';
-- ----------------------------
-- Records of tp_ad
-- ----------------------------
INSERT INTO `tp_ad` VALUES ('1', '1580378718', '1580378718', '1', '1', '1', 'banner_1 ', '/uploads/20181225/b671c6f234a72c2e6560c63ddd9dc0ff.jpg', '/uploads/20181225/b671c6f234a72c2e6560c63ddd9dc0ff.jpg', '', '免费、开源\n快速、简单');
INSERT INTO `tp_ad` VALUES ('2', '1580378773', '1583585682', '2', '1', '1', 'banner_2', '/uploads/20181225/25670f5712b4acfb61c5d2a1bce79225.jpg', '/uploads/20181225/25670f5712b4acfb61c5d2a1bce79225.jpg', '', 'banner_2');
-- ----------------------------
-- Table structure for tp_admin
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin`;
CREATE TABLE `tp_admin` (
`id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`create_time` int(11) NOT NULL,
`update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
`status` tinyint(1) DEFAULT NULL COMMENT '状态',
`username` varchar(25) NOT NULL DEFAULT '' COMMENT '用户名',
`password` varchar(255) NOT NULL DEFAULT '' COMMENT '密码',
`login_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登录时间',
`login_ip` varchar(255) NOT NULL DEFAULT '' COMMENT '登录IP',
`nickname` varchar(25) NOT NULL DEFAULT '' COMMENT '昵称',
`image` varchar(80) NOT NULL DEFAULT '' COMMENT '头像',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='管理员列表';
-- ----------------------------
-- Records of tp_admin
-- ----------------------------
INSERT INTO `tp_admin` VALUES ('1', '1580695622', '1583672118', '1', 'admin', '21232f297a57a5a743894a0e4a801fc3', '1583748582', '127.0.0.1', 'admin', '/static/plugins/AdminLTE/dist/img/user2-160x160.jpg');
INSERT INTO `tp_admin` VALUES ('2', '1583727997', '1583749457', '0', 'test', 'e10adc3949ba59abbe56e057f20f883e', '1583748408', '127.0.0.1', 'test', '/static/plugins/AdminLTE/dist/img/user2-160x160.jpg');
-- ----------------------------
-- Table structure for tp_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin_log`;
CREATE TABLE `tp_admin_log` (
`id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`create_time` int(11) NOT NULL,
`update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
`admin_id` text NOT NULL COMMENT '管理员',
`url` varchar(255) NOT NULL DEFAULT '' COMMENT '操作页面 ',
`title` varchar(100) NOT NULL DEFAULT '' COMMENT '日志标题',
`content` text NOT NULL COMMENT '日志内容',
`ip` varchar(20) NOT NULL DEFAULT '' COMMENT '操作IP',
`user_agent` text NOT NULL COMMENT 'User-Agent',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理员日志';
-- ----------------------------
-- Records of tp_admin_log
-- ----------------------------
-- ----------------------------
-- Table structure for tp_ad_type
-- ----------------------------
DROP TABLE IF EXISTS `tp_ad_type`;
CREATE TABLE `tp_ad_type` (
`id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`create_time` int(11) NOT NULL,
`update_time` int(11) NOT NULL,
`name` varchar(255) NOT NULL DEFAULT '' COMMENT '分组名称',
`description` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
`sort` int(10) unsigned NOT NULL DEFAULT '50' COMMENT '排序',
`status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='广告分组';
-- ----------------------------
-- Records of tp_ad_type
-- ----------------------------
INSERT INTO `tp_ad_type` VALUES ('1', '1580372414', '1580372414', '【首页】顶部通栏', '导航下的焦点图', '1', '1');
INSERT INTO `tp_ad_type` VALUES ('2', '1580372431', '1580372431', '【内页】顶部通栏', '内页顶部通栏', '2', '1');
-- ----------------------------
-- Table structure for tp_article
-- ----------------------------
DROP TABLE IF EXISTS `tp_article`;
CREATE TABLE `tp_article` (
`id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`create_time` int(11) NOT NULL,
`update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
`sort` mediumint(8) DEFAULT '50' COMMENT '排序',
`status` tinyint(1) DEFAULT NULL COMMENT '状态',
`cate_id` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '栏目',
`title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
`author` varchar(255) NOT NULL DEFAULT '' COMMENT '作者',
`source` varchar(255) NOT NULL DEFAULT '' COMMENT '来源',
`content` text NOT NULL COMMENT '内容',
`summary` text NOT NULL COMMENT '摘要',
`image` varchar(80) NOT NULL DEFAULT '' COMMENT '图片',
`images` text COMMENT '图片集',
`download` varchar(80) NOT NULL DEFAULT '' COMMENT '文件下载',
`tags` varchar(255) NOT NULL DEFAULT '' COMMENT 'TAG',
`hits` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点击次数',
`keywords` varchar(255) NOT NULL DEFAULT '' COMMENT '关键词',
`description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
`template` varchar(30) NOT NULL DEFAULT '' COMMENT '模板',
`url` varchar(255) NOT NULL DEFAULT '' COMMENT '跳转地址',
`view_auth` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '阅读权限',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='文章模块';
-- ----------------------------
-- Records of tp_article
-- ----------------------------
INSERT INTO `tp_article` VALUES ('1', '1581052220', '1581052220', '50', '1', '5', '为什么学习PHP?', '未知', 'php中文网', '<p>回答本书的几个问题吧。你到底,为什么要学习PHP?</p>\n\n<p>全国都缺PHP人才,非常好就业,PHP现在的工资水平很高,刚毕业可以拿到5000-9000每个月,特别优秀还可以破万。并且有非常多的就业机会。</p>\n\n<p>PHP入门简单,学习入门易入手。</p>\n\n<p>很多人反馈上完大学的C语言课程、java课程不会写任何东西。<br />\n诚然,中国的大学都以C语言作为主要的入门语言。但是,我们认为PHP是最简单入门,也是最合适入门的语言。</p>\n\n<p>你将学习到编程的思路,更加程序化的去处理问题。处理问题,将会更加规范化。</p>\n\n<p>如果你要创业,如果你要与互联网人沟通。未来互联网、移动互联网、信息化将会进一步围绕在你身边。你需要与人沟通,与人打交道。</p>\n\n<p>还有机会进入BAT(百度、阿里、腾讯),BAT这些企业他们在用PHP。国内和国外超一线的互联网公司,在超过90%在使用PHP来做手机API或者是网站。连微信等开放平台中的公众号的服务端也可以使用到PHP。</p>\n\n<p>大并发,还能免费。一天1个亿的访问量怎么办?PHP拥有大量优秀的开发者,在一定数据量的情况下完全能满足你的需求。国内外一线的互联网公司,很多将自己的大并发方案进行开源了。你可以免费获得很多成熟的、免费的、开源的大并发解决方案。</p>\n\n<p>开源更加节约成本也更加安全。windows很多都要收取授权费用,而使用linux的LAMP架构或者LNMP架构会更加安全。全球的黑客在帮你找漏洞。全球的工程师在帮忙修复漏洞。你发现一个他人已经消灭10个。</p>\n', '回答本书的几个问题吧。你到底,为什么要学习PHP?\n全国都缺PHP人才,非常好就业,PHP现在的工资水平很高,刚毕业可以拿到5000-9000每个月,特别优秀还可以破万。并且有非常多的就业机会。', '/uploads/20181224/168eb2135c7abbc3f2efcad91c7106e3.jpg', '', '', 'php', '0', '', '', '', '', '0');
INSERT INTO `tp_article` VALUES ('2', '1581052888', '1581052888', '50', '1', '5', 'PHP是什么', '未知', 'php中文网', '<p>PHP(外文名:PHP: Hypertext Preprocessor,中文名:&ldquo;超文本预处理器&rdquo;)是一种通用开源脚本语言。语法吸收了C语言、Java和Perl的特点,利于学习,使用广泛,主要适用于Web开发领域。</p>\n\n<p>用PHP做出的动态页面与其他的编程语言相比,PHP是将程序嵌入到HTML(标准通用标记语言下的一个应用)文档中去执行,执行效率比完全生成HTML标记的CGI要高许多;PHP还可以执行编译后代码,编译可以达到加密和优化代码运行,使代码运行更快。</p>\n\n<p>全球市场分析</p>\n\n<p>目前PHP在全球网页市场、手机网页市场还有为手机提供API(程序接口)排名第一。</p>\n\n<p>在中国微信开发大量使用PHP来进行开发。</p>\n', 'PHP(外文名:PHP: Hypertext Preprocessor,中文名:“超文本预处理器”)是一种通用开源脚本语言。语法吸收了C语言、Java和Perl的特点,利于学习,使用广泛,主要适用于Web开发领域。', '/uploads/20181224/fc3112ab0fab9f255726674dc1fd0d17.jpg', '', '', 'PHP', '0', '', '', '', '', '0');
INSERT INTO `tp_article` VALUES ('3', '1581052950', '1581052950', '50', '1', '5', '零基础也能学习', '未知', 'php中文网', '<p>学习PHP前很多人担心PHP是不是能真的学会。</p>\n\n<p>学习PHP学历要求不高,数学水平要求也不高,只需要会下面这些,你就可以跟着PHP中文网,开始愉快、高薪的PHP学习之旅:</p>\n\n<p>有一台电脑</p>\n\n<p>初中及以上文化水平</p>\n\n<p>必须会打字(五笔、拼音均可)</p>\n\n<p>会word(微软的office办公软件中的文字编辑软件)</p>\n\n<p>会上网(QQ,写邮件,玩微信,看小说,看电影,注册网站帐号,网上购物等)</p>\n\n<p>有一颗坚持的心</p>\n\n<p>如果会一点html就更好了.学习HTML可以去看我们开源的另外一本HTML入门书籍。</p>\n\n<p>不会HTML怎么办?也可以学习我们免费的HTML入门视频。</p>\n', '学习PHP前很多人担心PHP是不是能真的学会。\n学习PHP学历要求不高,数学水平要求也不高,只需要会下面这些,你就可以跟着PHP中文网,开始愉快、高薪的PHP学习之旅:\n有一台电脑', '/uploads/20181224/894485902f96b13551b5450c7ddca081.jpg', '', '', '零基础', '0', '', '', '', '', '0');
INSERT INTO `tp_article` VALUES ('4', '1581053047', '1581053047', '50', '1', '5', '为什么有些人学不会', '未知', 'php中文网', '<p>互联网进入到人们生活中的方方面面了,世界首富比尔盖茨多次提到青少年编程,而编程是一种思维习惯的转化。</p>\n\n<p>作为写了10几年程序的人,我听到过一些说编程不好学的抱怨。</p>\n\n<p>从目前见到的数据统计,主要是因为在大学学习时遇到了C语言,学完后还不知道能干什么。很多人大学上完也就这么糊涂、恐惧的就过来了。</p>\n\n<p>只有很少的不到1%的人学不会,这部份往往是专业的艺术家,在艺术家里面极少一部份人外,他们的思维模式和我们遇到的大多数人不太一样,并且不进行编程思维的训练,所以学不会。</p>\n\n<p>而造成这个原因主要是因为社会、文化、背景、生活圈子多方面造成的。而不是因为笨。</p>\n\n<p>那我们绝大多数的人是哪些原因学不会的呢?</p>\n\n<p>1. 不相信自己能学会</p>\n\n<p>这一块很多人可能不相信,涉及到很深的心理学知识。与心理暗示、诅咒的原理一样。</p>\n\n<p>如果不相信自己能够学好,心里潜意识的念头里如果总是:PHP很难,我学不会。那么这个人肯定很难学会。</p>\n\n<p>把不相信自己能学会的负面情绪和观念给抛掉。</p>\n\n<p>只要你每天练习代码并相信自己。你肯定能学会,并且能学得很好,代码写的很成功,成为大牛!</p>\n\n<p>2. 懒</p>\n\n<p>人的天性有善有恶,而学不好程序的人,身上的一个通病,只有一个字就是&mdash;&mdash;&mdash;&mdash;懒!<br />\n基本语法,需要去背<br />\n函数需要去默写</p>\n\n<p>3. 自以为是</p>\n\n<p>一看就会,一写就错。以为自己是神童。</p>\n\n<p>4. 英文单词</p>\n\n<p>计算机里面常用的英文单词就那么一些。</p>\n\n<p>不要找英语的借口。本书会把英语单词都会跟你标注出来。看到不会的,就去翻一翻。</p>\n\n<p>5. 不坚持</p>\n\n<p>学着学着就放弃了。</p>\n\n<p>6. 不去提问,不会提问,不去思考</p>\n\n<p>解决问题前,先去搜索</p>\n\n<p>搜索解决不了再去提问</p>\n\n<p>PHP学院为大家准备了视频,也为大家准备了问答中心。</p>\n\n<p>大多数的人,不把问题详述清楚,不把错误代码贴完整。</p>\n\n<p>张嘴就来提问。我想神仙也不知道你的问题是什么吧?问题发出来前。换位思考一下自己看不看得懂这个问题。</p>\n\n<p>7. 你还需要自我鼓励</p>\n\n<p>在学习过程中,你会否定自己。其实任何人都会。大多数人都会遇到跟你一样的困难。只不过他们在克服困难,而一些人在逃避困难。</p>\n\n<p>学累的时候,放松一会儿。再去多读几遍。不断的告诉自己,你就是最棒的!</p>\n\n<p>学会交流和倾诉而非抱怨,并且不断的自我鼓励</p>\n', '', '/uploads/20181224/b640f82ccf862c3b34e11f792220a1f5.jpg', '', '', '不会', '0', '', '', '', '', '0');
INSERT INTO `tp_article` VALUES ('5', '1581053131', '1581053131', '50', '1', '5', '开发环境是什么?', '未知', 'php中文网', '<p>PHP是一门开发语言。而开发语言写出来的代码,通常需要在指定的软件下才能运行。因此,我们写好的代码需要(运行)显示出来看到,就需要安装这几个软件来运行代码。</p>\n\n<p>我们把运行我们写代码的几个软件和运行代码的软件统一都可称为开发环境。</p>\n\n<p>新手学习前常遇到的环境问题</p>\n\n<p>很多朋友最开始学习的时候,听说某个环境好就安装某些软件。由于缺乏相关知识,所以没有主见。陷入人云即云的怪圈里。今天换这个,明天换那个。</p>\n\n<p>当前验证真理的唯一标准,请始终保证一点:</p>\n\n<p>环境能满足你的学习需求。不要在环境上面反复纠结,耽误宝贵的学习时间。</p>\n\n<p>我们认为环境只要能满足学习要求即可。等学会了后,再去着磨一些更加复杂的互联网线上的、生产环境中的具体配置。</p>\n', 'PHP是一门开发语言。而开发语言写出来的代码,通常需要在指定的软件下才能运行。因此,我们写好的代码需要(运行)显示出来看到,就需要安装这几个软件来运行代码。', '/uploads/20181224/a11e9ab3e8dc289dca70a105a7f177ee.jpg', '', '', '开发环境', '0', '', '', '', '', '0');
INSERT INTO `tp_article` VALUES ('6', '1581053179', '1581053179', '50', '1', '5', 'windows环境安装', '未知', 'php中文网', '<p>所谓服务器:不要把它想的太过于高深,不过就是提供一项特殊功能(服务)的电脑而已。</p>\n\n<p>显示网页的叫网页(web)服务器(server)。</p>\n\n<p>帮我们代为收发电子邮件(Email)的服务器叫邮件服务器。</p>\n\n<p>帮我们把各个游戏玩家连接在一起的叫游戏服务器。</p>\n\n<p>帮我们存储数据的叫数据库服务器</p>\n\n<p>... ...等等</p>\n\n<p>我们现在使用的一部手机的性能比10年前的一台电脑和服务器的性能还要强劲、给力。</p>\n\n<p>而我们的学习过程当中完全可以把自己使用的这一台windows电脑作为服务器来使用。</p>\n\n<p>原来如此,一讲就通了吧?</p>\n\n<p>我们大多数人使用的电脑通常是windows操作系统的电脑。而我们的讲解主要在windows电脑上进行。</p>\n\n<p>你不需要去理解所谓高深的电脑知识、操作系统原型等。在这一章节当中,你只需要会安装QQ、杀毒软件一样,点击:下一步、下一步即可完成本章的学习。</p>\n\n<p>在最开始学习时,我们强烈建议初学者使用集成环境包进行安装。</p>\n\n<p>什么是集成环境包?</p>\n\n<p>我们学习PHP要安装的东西有很多。例如:网页服务器、数据库服务器和PHP语言核心的解释器。</p>\n\n<p>我们可以分开安装各部份,也可以合在一起安装一个集成好的软件。</p>\n\n<p>将这些合在一起的一个软件我们就叫作:集成环境包。</p>\n\n<p>这个过程需要修改很多配置文件才能完成。并且每个人的电脑情况,权限,经常容易操作出错。</p>\n\n<p>很容易因为环境问题影响到心情,我们的学习计划在初期非常绝对化:</p>\n\n<p>请使用集成环境包完成最开始的学习。</p>\n\n<p>等你学好PHP NB后,你爱用啥用啥,网上成堆的文章教你配置各种环境。</p>\n\n<p>选用什么样的集成环境包?</p>\n\n<p>集成环境包比较多。以下的这些全是各种英文名。只不过代表的是不同集成环境包的名字,不用去深纠。如下所示:</p>\n\n<p>AppServ</p>\n\n<p>PHPStudy</p>\n\n<p>APMserv</p>\n\n<p>XAMPP</p>\n\n<p>WAMPServer<br />\n... ...等等</p>\n\n<p>对于我们才入门的学习者来说,选择集成环境包的原则:</p>\n\n<p>更新快,版本比较新</p>\n\n<p>操作简单易于上手</p>\n\n<p>选择项不要过多</p>\n\n<p>因此,我们下面使用的集成环境包是:PHPstudy。当然,如果你对此块很熟悉了,也可以自行选择选择集成环境包。</p>\n\n<p>可以以在官方网址下载:<br />\nhttp://www.phpstudy.net/&nbsp;</p>\n\n<p>也可以在百度中搜索:*PHPstudy *&nbsp;&nbsp;这个5个字文字母进行下载。</p>\n\n<p>对学习PHP的新手来说,WINDOWS下PHP环境配置是一件很困难的事,就是老手也是一件烦琐的事。因此,无论你是新手还是老手,phpStudy 2016都是一个不错的选择,该程序集成Apache+PHP+MySQL+phpMyAdmin+ZendOptimizer,最新版本已集成最新的&nbsp;PHP7。</p>\n', '所谓服务器:不要把它想的太过于高深,不过就是提供一项特殊功能(服务)的电脑而已。\n显示网页的叫网页(web)服务器(server)。', '/uploads/20181224/f5421f965b0f46d9c1b8f1a927df7894.jpg', '', '', '开发环境', '0', '', '', '', '', '0');
INSERT INTO `tp_article` VALUES ('7', '1581053231', '1581053231', '50', '1', '5', 'Linux环境安装', '未知', 'php中文网', '<p>这一个章节是本书中永远不会写的一个章节,很多人被一些市面上的书籍误导,认为学习PHP前要学习Linux。结果,一看Linux,就对人生和学习失去了希望。我们作为有过10年以上开发经验和内部训经验的专业人士告戒各位:</p>\n\n<p>Linux学习与PHP学习没有必然的联系,这是两个不同的知识体系。</p>\n\n<p>作为有多年开发经验和教学经验的我们。</p>\n\n<p>我们强烈不建议没有接触过Linux的学生,为了学习PHP而去安装Linux环境</p>\n\n<p>如果您有经验,我们相信你一定能解决,如果解决不了。</p>\n\n<p>请加QQ群和访问官网:PHP中文网&nbsp;学习视频和提问。</p>\n', '这一个章节是本书中永远不会写的一个章节,很多人被一些市面上的书籍误导,认为学习PHP前要学习Linux。结果,一看Linux,就对人生和学习失去了希望。我们作为有过10年以上开发经验和内部训经验的专业人士告戒各位:', '/uploads/20181224/5cd61fb68c8bc8fe6d24be4229ec0ca5.jpg', '', '', '开发环境', '0', '', '', '', '', '0');
INSERT INTO `tp_article` VALUES ('8', '1581054083', '1581054083', '50', '1', '5', '其他开发环境', '未知', 'php中文网', '<p>对本章不感兴趣,可以略过,只是介绍和说明。</p>\n\n<p>其他开发环境有很多:</p>\n\n<p>1,比如 苹果电脑的系统 Mac os</p>\n\n<p>2,比如 &nbsp;在线环境(你使用了百度、新浪、阿里等云计算环境)</p>\n\n<p>3,其他更多... ...</p>\n\n<p>当然,你甚至可以使用安卓手机和苹果手机来部署你的开发环境。就像有些人可以在各种复杂的环境,甚至U衣酷的试衣间里M..L。我想,这应该不是正常人类该进行的尝试吧。</p>\n\n<p>如果你在使用这些环境遇到了问题,相信你已经有过一定的开发经验和处理问题的经验了,这不是刚开始学习编程该掌握的内容。</p>\n\n<p>但是,如果你真遇到了这些问题。你可以上PHP中文网来提问。</p>\n', '对本章不感兴趣,可以略过,只是介绍和说明。\n其他开发环境有很多:\n1,比如 苹果电脑的系统 Mac os\n2,比如 在线环境(你使用了百度、新浪、阿里等云计算环境)\n3,其他更多... ...', '', '', '', '开发环境,其他', '0', '', '', '', '', '0');
INSERT INTO `tp_article` VALUES ('9', '1581054168', '1581054168', '50', '1', '5', '写代码的工具选择', '未知', 'php中文网', '<p>写代码的工具有很多。对于刚开始学习PHP的朋友来说。选择工具有几个原则:</p>\n\n<p>1,不要使用带自动提示的工具(例如eclipse、zend studio等PHP开发工具集)</p>\n\n<p>2,写完的代码必须要有颜色高亮显示。(不能使用:txt文本编辑器等无代码颜色显示的编辑器)</p>\n\n<p>你可能想问,为什么呀?</p>\n\n<p>我们发现电视、电影和现实生活中的编程高手,噼里哗啦就写一堆代码,一点都不报错,点击就能运行。而我们对着他们的代码抄袭反倒抄错。这种感觉特别不好!!!</p>\n\n<p>&mdash;&mdash;传说中的这些高手,他们都曾经在基础代码上反复练习过,所以他们不会写错。</p>\n\n<p>而我们需要高手之境界,在学习初期就不能使用先进的工具。这样会浪费我们保贵的练习代码的机会、调试错误的机会。</p>\n\n<p>因为先进的编辑器通常有很多先进的功能,例如:</p>\n\n<p>代码自动显示错误</p>\n\n<p>代码自动换行</p>\n\n<p>这些先进的工具,对于开始入门学习的你,不利于新手产生独立解决问题的能力!</p>\n\n<p>推荐的开发工具</p>\n\n<p>1. NotePad++&nbsp;</p>\n\n<p>https://notepad-plus-plus.org/&nbsp;由于某些不可抗的原因,请使用百度搜索NotePad++&nbsp;</p>\n\n<p>2.phpstorm(强烈推荐)</p>\n\n<p>https://www.jetbrains.com/phpstorm/&nbsp;</p>\n\n<p>这些工具,你只需要下载下来,一直点击下一步,安装到你的电脑上即可。</p>\n', '写代码的工具有很多。对于刚开始学习PHP的朋友来说。选择工具有几个原则:\n1,不要使用带自动提示的工具(例如eclipse、zend studio等PHP开发工具集)\n2,写完的代码必须要有颜色高亮显示。(不能使用:txt文本编辑器等无代码颜色显示的编辑器)', '', '', '', '代码工具', '0', '', '', '', '', '0');
INSERT INTO `tp_article` VALUES ('10', '1581054212', '1581054212', '50', '1', '5', 'php中的变量-读过初中你就会变量', '未知', 'php中文网', '<p>大家在读初中的时候呀。老师经常会这么教大家。</p>\n\n<p>请问,李磊和韩梅梅同学,假如:</p>\n\n<p>x&nbsp;=&nbsp;5<br />\ny&nbsp;=&nbsp;6</p>\n\n<p>那么x + y 等于多少呢?大家会义无反顾的回答。x + y 等于11。</p>\n\n<p>接下来我们看下面的初中的数学知识,请问x + y 的结果是多少?</p>\n\n<p>x&nbsp;=&nbsp;5<br />\ny&nbsp;=&nbsp;6<br />\nx&nbsp;=&nbsp;8</p>\n\n<p>我估计大家也会义无反顾的回答:x + y 的结果为14。</p>\n\n<p>这就是变量!</p>\n\n<p>变量的几个特点:</p>\n\n<p>1.x = 5 将右边值5,赋值给左边的x</p>\n\n<p>2.第二段x = 8,最后x + y 的结果等于14,说明x在从上到下的运算(执行)中,可以被重新赋值。</p>\n\n<p>我们在PHP中的变量也是如此。不过有几个特点:</p>\n\n<p>1.必须要以$开始。如变量x必须要写成$x</p>\n\n<p>2.变量的首字母不能以数字开始</p>\n\n<p>3.变量的名字区分大小写</p>\n\n<p>4.变量不要用特殊符号、中文,_不算特殊符号</p>\n\n<p>5.变量命名要有意义(别写xxx,aaa,ccc这种 变量名)</p>\n\n<p>错误举列:</p>\n\n<p>错误:变量以数字开始</p>\n\n<p><!--?php<br/-->$123&nbsp;=&nbsp;345;<br />\n?&gt;</p>\n\n<p>错误:变量中有特殊字符,中文</p>\n\n<p><!--?php<br/-->//$a*d&nbsp;=&nbsp;345;<br />\n<br />\n//$中国&nbsp;=&nbsp;123;<br />\n?&gt;</p>\n\n<p>错误:变量命名没有意义aaa容易数错,也没有含意</p>\n\n<p><!--?php<br/-->$aaaaaaa&nbsp;=&nbsp;345;<br />\n?&gt;</p>\n\n<p>错误:变量严格区分大小写 $dog 和 $Dog是PHP学院的变量,尝试将$dog的值改为8.结果D写成了大写。</p>\n\n<p><!--?php<br/-->$dog&nbsp;=&nbsp;5;<br />\n//重新修改$dog的值,将$dog改为8<br />\n$Dog&nbsp;=&nbsp;8;<br />\n?&gt;</p>\n\n<p>正确举例:</p>\n\n<p>正确:变量不能以数字开始,但是数字可以夹在变量名中间和结尾</p>\n\n<p><!--?php<br/-->$iphone6&nbsp;=&nbsp;5880;<br />\n$iphone6plus&nbsp;=&nbsp;6088;<br />\n?&gt;</p>\n\n<p>正确:变量不能有特殊符号,但是_(下划线不算特殊符号)</p>\n\n<p><!--?php<br/-->$_cup&nbsp;=&nbsp;123;<br />\n?&gt;</p>\n\n<p>注:你会发现代码是从上向下执行的。</p>\n\n<p>$ 叫作美元符,英文单词:dollar。PHP的变量必须以美元符开始。说明搞PHP有&ldquo;钱&rdquo;途。</p>\n\n<p>dollar<br />\n读音:[&#39;dɒlə(r)]<br />\n解释:美元</p>\n', '大家在读初中的时候呀。老师经常会这么教大家。\n请问,李磊和韩梅梅同学,假如:', '', '', '', 'PHP变量', '0', '', '', '', '', '0');
INSERT INTO `tp_article` VALUES ('11', '1581054249', '1581054249', '50', '1', '5', 'echo 显示命令', '未知', 'php中文网', '<p>echo 是在PHP里面最常用的一个输出、显示功能的命令。</p>\n\n<p>我们可以让他显示任何可见的字符。</p>\n\n<p><!--?php<br/--><br />\necho&nbsp;123;<br />\n<br />\n?&gt;<br />\n<!--?php<br/--><br />\n$iphone&nbsp;=&nbsp;6088;<br />\n<br />\necho&nbsp;$iphone;<br />\n<br />\n?&gt;</p>\n\n<p>你可以对着做做实验。等下一章,我们讲数据类型的时候,我教大家输出中文和用PHP显示网页内容。</p>\n\n<p>单词:</p>\n\n<p>*echo *&nbsp;读音: [&#39;ekoʊ]<br />\n解释:发出回声;回响。<br />\n功能解释:输出、显示</p>\n', 'echo 是在PHP里面最常用的一个输出、显示功能的命令。\n我们可以让他显示任何可见的字符。', '', '', '', 'echo,echo命令', '0', '', '', '', '', '0');
INSERT INTO `tp_article` VALUES ('12', '1581054302', '1581054302', '50', '1', '5', 'php注释的学习', '未知', 'php中文网', '<p>注释的功能很强大</p>\n\n<p>所谓注释,汉语解释可以为:注解。更为准确一些。<br />\n因为代码是英文的、并且代码很长,时间长了人会忘。<br />\n所以我们会加上注释。</p>\n\n<p>注释的功能有很多:</p>\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;1.对重点进行标注</p>\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;2.时间长了容易忘快速回忆,方便查找</p>\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;3.让其他人看的时候快速看懂</p>\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;4.还可以生成文档,代码写完相关的文档就写完了,提高工作效率</p>\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;5.注释、空行、回车之后的代码看起来更优美</p>\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;6.注释可用来排错。不确定代码中哪一块写错了,可以将一大段注释,确定错误区间</p>\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;7.注释中间的部份的内容,电脑不会执行它</p>\n\n<p>先给大家看看我们觉得优美的代码,整齐、规范、说明清楚、一看就懂。(不需要理解代码的含义):</p>\n\n<p>&nbsp;</p>\n\n<p>再看看我们眼中觉得丑陋的代码,对齐丑陋不说,并且没有功能说明(不需要理解代码的含义):</p>\n\n<p>&nbsp;</p>\n\n<p>我们了解了注释的好处,接下来我们来说PHP的注释,注释分别:</p>\n\n<p>单行注释(只注释一行)</p>\n\n<p>多行注释(注释多行)</p>\n\n<p>单行注释</p>\n\n<p>//&nbsp;&nbsp;&nbsp;表示单行注释<br />\n#&nbsp;&nbsp;&nbsp;&nbsp;#号也表示单行注释,用的比较少</p>\n\n<p>多行注释</p>\n\n<p>/*&nbsp;<br />\n多行注释&nbsp;这里是注释区域代码<br />\n&nbsp;*/</p>\n\n<p>单行注释举例:</p>\n\n<p><!--?php<br/--><br />\n//声明一部iphone6手机的价格变量<br />\n$iphone6_price&nbsp;=&nbsp;6088;<br />\n<br />\n//显示输出手机价格<br />\necho&nbsp;$iphone6_price;<br />\n?&gt;</p>\n\n<p>注:通过上例我们知道,注释通常写代码上面。</p>\n\n<p>多行注释举例:</p>\n\n<p><!--?php<br/-->/*<br />\n作者:PHP中文网<br />\n时间:2048.12.23<br />\n功能:这是一个假的多行注释的例子<br />\n*/<br />\n<br />\n/*<br />\n&nbsp;&nbsp;声明一个爱情变量<br />\n&nbsp;&nbsp;$love&nbsp;是指爱情<br />\n&nbsp;&nbsp;爱情是一个变量,因为人的爱总是在发生变化<br />\n&nbsp;&nbsp;所以,爱情变量的值为250<br />\n*/<br />\n$love&nbsp;=&nbsp;250;<br />\n<br />\n?&gt;</p>\n\n<p>注:通过上面的例子我们发现,我们要写上很多注释的时候,释用多行注释。</p>\n\n<p>注:暂进不讲解如何通过专门的工具生成注释</p>\n', '注释的功能很强大\n所谓注释,汉语解释可以为:注解。更为准确一些。\n因为代码是英文的、并且代码很长,时间长了人会忘。', '/uploads/20181224/2d208c7893a9981a6216b83ef9fcb11f.jpg', '', '', 'php,php注释', '0', '', '', '', '', '0');
INSERT INTO `tp_article` VALUES ('13', '1581054369', '1581054369', '50', '1', '5', 'php整型就是整数', '未知', 'php中文网', '<p>我&nbsp; &nbsp;一直在讲,不要被名词的含义所吓唬住。</p>\n\n<p>到底什么是整型呀?</p>\n\n<p>所谓整型,就是大家数学中所学的整数。</p>\n\n<p>整型&mdash;&mdash;整数也,英文称之:integer。英文简写:int</p>\n\n<p>整型分为:</p>\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;1.10进行</p>\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;2.8进制 (了解,基本不用)</p>\n\n<p>&nbsp;&nbsp;&nbsp;&nbsp;3.16进制(了解,基本不用)</p>\n\n<p>整型(整数)在计算机里面是有最大值和最小值范围的。</p>\n\n<p>【了解知识点,开发中不常用】大家经常听说32位计算机,也就是32位计算机一次运算处理的最大范围为-232至232-1。<br />\n64位计算机呢?&mdash;&mdash;</p>\n\n<p>10 进制声明:</p>\n\n<p><!--?php<br-->//为了方便大家记忆和前期学习,英文不好的朋友也可用拼音来声明变量。以后再用英文来声明变量也无所谓<br />\n//声明变量&nbsp;整数,英文&nbsp;int<br />\n//$int&nbsp;=&nbsp;1000;<br />\n$zhengshu&nbsp;=&nbsp;1000;<br />\necho&nbsp;$zhengshu;<br />\n?&gt;</p>\n\n<p>8进制声明:&nbsp;以0开始,后面跟0-7的整数(了解知识点)</p>\n\n<p><!--?php<br-->//8进制的取值范围最大为0-7,即0,1,2,3,4,5,6,7<br />\n<br />\n$bajingzhi&nbsp;=&nbsp;&nbsp;033145;<br />\necho&nbsp;$bajingzhi;<br />\n<br />\n?&gt;</p>\n\n<p>16进制声明:&nbsp;以0x开始,后面跟0-f的,0x的abcdef不区分大小写。(了解知识点)</p>\n\n<p><!--?php<br-->//16进制的取值范围最大为0-f,即0,1,2,3,4,5,6,7,8,9,a,b,c,d,e,f<br />\n$shiliu&nbsp;=&nbsp;&nbsp;0x6ff;<br />\necho&nbsp;$shiliu;<br />\n?&gt;</p>\n\n<p>本章学习重点,学会如何声明10制制整数即可。了解8制制和16进制的声明,实在不会也不要紧。</p>\n\n<p>思维误区:容易去考虑8进制和16进制到底是怎么产生的。</p>\n', '我一直在讲,不要被名词的含义所吓唬住。\n到底什么是整型呀?\n所谓整型,就是大家数学中所学的整数。', '/uploads/20181224/588ac2b0eca6de73b61c125db692e020.jpg', '', '', 'php,php整型', '0', '', '', '', '', '0');
INSERT INTO `tp_article` VALUES ('14', '1581054439', '1581054439', '50', '1', '6', 'PHP中的流程控制', '未知', 'php中文网', '<p>流程控制就是人类社会的做事和思考和处理问题的方式和方法。通过本章,你将会发现采用计算机的思维去考虑问题,我们在做事的过程当中会更加严谨。</p>\n\n<p>我们通过一个一个的场景来去推理流程:</p>\n\n<p>有一个高富帅,他姓王。他的名字叫&mdash;&mdash;王。王同学计划要投资一个项目。如果这个项目计划开始,为了这个投资项目每周往返一次北京和大连。什么时候王思总同学不再往返呢?项目失败后或者万(da)集团临时除知除外,他就可以不再这么每周往返了。</p>\n\n<p>王同学呢,有一个好习惯,就是每次往返的时候,害怕自己到底一年往返了多少次。王同学都会在自己的记事本上记上往返的次数,第一次就写上一,第2次就写上2... ...直至最后项目停止。</p>\n\n<p>王同学家里头特别有钱,所以他的行程方式和正常人的又有些不同。不仅有更多的方式,而且王同学还迷信。</p>\n\n<p>他的出行方式呢有6种,如下:</p>\n\n<p>1,司机开车<br />\n2,民航<br />\n3,自己家的专机<br />\n4,火车动车<br />\n5,骑马<br />\n6,游轮</p>\n\n<p>每次王同学,都自己会在骰子上写上1,2,3,4,5,6。摇到哪种方式,王同学就会采用哪种方式进行往返两地。</p>\n\n<p>并且呢,王同学是生活极度充满娱乐化和享受生活的人。他抵达北京或者大连的时候不同,他抵达后做的事情都不同,如下:</p>\n\n<p>半夜到达,先去夜店参加假面舞会<br />\n早上抵达,爱在酒店泡个澡<br />\n中午到达,会吃上一份神户牛肉<br />\n晚上到达,总爱去找朋友去述说一下心中的寂寞</p>\n\n<p>王同学在出行和项目中也是极度有计划性。他给自己的生活秘书和工作秘书分别指派了出差的行程:</p>\n\n<p>生活上:<br />\n先查天气,下雨带雨具和毛巾。不下雨要带防晒霜<br />\n雨具、毛巾和防晒霜的情况要提前检查,如果没有要及时买</p>\n\n<p>工作上:<br />\n要提前沟通去大连前的工作计划,准备好了要及时检查,检查合格,要提前打印现来。<br />\n及时没有及时准备好的情况下,要列出主要的项目沟通议题。</p>\n', '流程控制就是人类社会的做事和思考和处理问题的方式和方法。通过本章,你将会发现采用计算机的思维去考虑问题,我们在做事的过程当中会更加严谨。我们通过一个一个的场景来去推理流程:', '', '', '', 'php,php流程', '0', '', '', '', '', '0');
INSERT INTO `tp_article` VALUES ('15', '1581054482', '1581054482', '50', '1', '6', 'php流程控制之if条件结构流程', '未知', 'php中文网', '<p>if条件结构流程</p>\n\n<p>if和else 语句,在之前的3.2.5章节中已经做了说明。我们配合王思总同学的例子,再次进行说明,方便大家对此章节的理解。</p>\n\n<p>本章的知识点为:【默写级】</p>\n\n<p>基本语法,不能有半点马乎,完全是语法规范规定的,不这么写就错!</p>\n\n<p><!--?php <br/-->$week=date(&quot;4&quot;);<br />\n//判断星期小于6,则输出:还没到周末,继续上班.....<br />\nif&nbsp;($week&lt;&quot;6&quot;)&nbsp;{<br />\n&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;&quot;还没到周末,继续上班.....&quot;;<br />\n}&nbsp;<br />\n?&gt;</p>\n\n<p>在之前我们也讲过,因此if的结构可以根据人类思维推理出来两种结构:</p>\n\n<p>//if单行判断<br />\nif(布尔值判断)<br />\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;只写一句话;<br />\n后续代码<br />\n//if多行判断<br />\nif(布尔值判断){<br />\n&nbsp;&nbsp;&nbsp;&nbsp;可以写多句话;<br />\n}<br />\n后续代码</p>\n', 'if条件结构流程\nif和else 语句,在之前的3.2.5章节中已经做了说明。我们配合王思总同学的例子,再次进行说明,方便大家对此章节的理解。\n本章的知识点为:【默写级】', '', '', '', 'php,php流程', '0', '', '', '', '', '0');
INSERT INTO `tp_article` VALUES ('16', '1581054524', '1581054524', '50', '1', '6', 'PHP流程控制之if语句', '未知', 'php中文网', '<p>我们为了加强大家对代码的理解,我们串了一个故事恶搞了一个王思总同学。</p>\n\n<p>在4.1和3.2.5这两个章节中我们都介绍到了if和if...else结构。并且我们讲解的很清楚。</p>\n\n<p>我们现在来用if...else结构来写一个小东西,加强大家对逻辑的理解。</p>\n', '我们为了加强大家对代码的理解,我们串了一个故事恶搞了一个王思总同学。\n在4.1和3.2.5这两个章节中我们都介绍到了if和if...else结构。并且我们讲解的很清楚。\n我们现在来用if...else结构来写一个小东西,加强大家对逻辑的理解。', '', '', '', 'php,if', '45', '', '', '', '', '0');
INSERT INTO `tp_article` VALUES ('17', '1581054590', '1581054590', '50', '1', '6', 'PHP流程控制之嵌套if...else...elseif结构', '未知', 'php中文网', '<p>还记得本章开篇我们讲了一个王思总同学的例子:</p>\n\n<p>王同学是生活极度充满娱乐化和享受生活的人。他抵达北京或者大连的时候做的事,他抵达后做的事情,如下:</p>\n\n<p>半夜到达,先去夜店参加假面舞会<br />\n&nbsp;早上抵达,爱在酒店泡个澡<br />\n&nbsp;中午到达,会吃上一份神户牛肉<br />\n&nbsp;晚上到达,总爱去找朋友去述说一下心中的寂寞</p>\n\n<p>我们来了解一下他的语法规则【知识点要求:默写】</p>\n\n<p><!--?php<br/-->if(判断语句1){<br />\n&nbsp;&nbsp;&nbsp;&nbsp;执行语句体1<br />\n}elseif(判断语句2){<br />\n&nbsp;&nbsp;&nbsp;&nbsp;执行语句体2<br />\n}else&nbsp;if(判断语句n){<br />\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;执行语句体n<br />\n}else{<br />\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;最后的else语句可选<br />\n}<br />\n<br />\n//后续代码<br />\n?&gt;</p>\n', '还记得本章开篇我们讲了一个王思总同学的例子:\n王同学是生活极度充满娱乐化和享受生活的人。他抵达北京或者大连的时候做的事,他抵达后做的事情。', '', '', '', 'if', '7', '', '', '', '', '0');
-- ----------------------------
-- Table structure for tp_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `tp_auth_group`;
CREATE TABLE `tp_auth_group` (
`id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`create_time` int(11) NOT NULL,
`update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
`status` tinyint(1) DEFAULT NULL COMMENT '状态',
`title` varchar(255) NOT NULL DEFAULT '' COMMENT '角色组',
`rules` text COMMENT '权限',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='角色组管理';
-- ----------------------------
-- Records of tp_auth_group
-- ----------------------------
INSERT INTO `tp_auth_group` VALUES ('1', '1580633995', '1583732574', '1', '超级管理员', '0,157,92,93,94,95,96,97,98,99,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,171,172,173,174,175,176,268,269,270,271,272,273,274,275,276,158,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,106,107,108,109,110,111,112,113,114,115,100,101,102,103,104,105,159,163,164,165,166,167,168,169,170,160,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,39,40,41,42,43,44,45,46,47,48,187,177,178,179,180,181,182,183,184,185,186,161,49,50,51,52,53,54,55,56,57,58,69,70,71,72,73,74,75,76,77,78,59,60,61,62,63,64,65,66,67,68,79,80,81,82,83,84,85,86,87,88,162,1,2,3,4,5,6,7,8,29,30,31,32,33,34,35,36,37,38,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,260,261,262,263,264,265,266,267,');
INSERT INTO `tp_auth_group` VALUES ('2', '1580634019', '1613634834', '1', '测试组', '0,157,92,93,95,99,9,10,12,16,19,20,22,26,171,174,268,269,271,274,277,278,158,116,117,119,123,125,126,128,132,134,106,107,109,113,100,101,105,159,163,164,165,166,167,169,170,160,136,137,139,143,147,148,150,154,39,40,42,46,187,177,178,180,184,281,161,49,50,52,56,69,70,72,76,59,60,62,66,79,80,82,86,162,1,2,4,8,29,30,32,36,188,189,190,192,196,199,200,202,206,209,210,212,216,219,220,222,226,229,230,232,236,239,240,242,246,249,252,256,258,260,261,262,263,264,265,266,267,');
-- ----------------------------
-- Table structure for tp_auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `tp_auth_group_access`;
CREATE TABLE `tp_auth_group_access` (
`uid` mediumint(8) unsigned NOT NULL,
`group_id` mediumint(8) unsigned NOT NULL,
`create_time` int(11) DEFAULT '0' COMMENT '添加时间',
`update_time` int(11) DEFAULT '0' COMMENT '修改时间',
UNIQUE KEY `uid_group_id` (`uid`,`group_id`),
KEY `uid` (`uid`),
KEY `group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tp_auth_group_access
-- ----------------------------
INSERT INTO `tp_auth_group_access` VALUES ('1', '1', '1553846932', '1553846932');
INSERT INTO `tp_auth_group_access` VALUES ('2', '2', '1583728403', '1583748601');
-- ----------------------------
-- Table structure for tp_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `tp_auth_rule`;
CREATE TABLE `tp_auth_rule` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父ID',
`name` varchar(255) NOT NULL DEFAULT '' COMMENT '控制器/方法',
`title` char(20) NOT NULL DEFAULT '',
`type` tinyint(1) NOT NULL DEFAULT '1',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '菜单状态',
`condition` char(100) NOT NULL DEFAULT '',
`sort` mediumint(8) NOT NULL DEFAULT '0' COMMENT '排序',
`auth_open` tinyint(2) DEFAULT '1',
`icon` char(50) DEFAULT '',
`create_time` int(11) DEFAULT '0' COMMENT '添加时间',
`update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
`param` varchar(50) NOT NULL DEFAULT '' COMMENT '参数',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=283 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tp_auth_rule
-- ----------------------------
INSERT INTO `tp_auth_rule` VALUES ('1', '162', 'Users/index', '会员管理', '1', '1', '', '71', '1', 'fa fa-user', '1580861016', '1580908159', '');
INSERT INTO `tp_auth_rule` VALUES ('2', '1', 'Users/add', '操作-添加', '1', '0', '', '1', '1', '', '1580861016', '1580861016', '');
INSERT INTO `tp_auth_rule` VALUES ('3', '1', 'Users/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1580861016', '1580861016', '');
INSERT INTO `tp_auth_rule` VALUES ('4', '1', 'Users/edit', '操作-修改', '1', '0', '', '3', '1', '', '1580861016', '1580861016', '');
INSERT INTO `tp_auth_rule` VALUES ('5', '1', 'Users/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1580861016', '1580861016', '');
INSERT INTO `tp_auth_rule` VALUES ('6', '1', 'Users/del', '操作-删除', '1', '0', '', '5', '1', '', '1580861016', '1580861016', '');
INSERT INTO `tp_auth_rule` VALUES ('7', '1', 'Users/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1580861016', '1580861016', '');
INSERT INTO `tp_auth_rule` VALUES ('8', '1', 'Users/export', '操作-导出', '1', '0', '', '7', '1', '', '1580861016', '1580861016', '');
INSERT INTO `tp_auth_rule` VALUES ('9', '157', 'DictionaryType/index', '字典类型', '1', '1', '', '12', '1', '', '1580861057', '1580861057', '');
INSERT INTO `tp_auth_rule` VALUES ('10', '9', 'DictionaryType/add', '操作-添加', '1', '0', '', '1', '1', '', '1580861057', '1580861057', '');
INSERT INTO `tp_auth_rule` VALUES ('11', '9', 'DictionaryType/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1580861057', '1580861057', '');
INSERT INTO `tp_auth_rule` VALUES ('12', '9', 'DictionaryType/edit', '操作-修改', '1', '0', '', '3', '1', '', '1580861057', '1580861057', '');
INSERT INTO `tp_auth_rule` VALUES ('13', '9', 'DictionaryType/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1580861057', '1580861057', '');
INSERT INTO `tp_auth_rule` VALUES ('14', '9', 'DictionaryType/del', '操作-删除', '1', '0', '', '5', '1', '', '1580861057', '1580861057', '');
INSERT INTO `tp_auth_rule` VALUES ('15', '9', 'DictionaryType/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1580861057', '1580861057', '');
INSERT INTO `tp_auth_rule` VALUES ('16', '9', 'DictionaryType/export', '操作-导出', '1', '0', '', '7', '1', '', '1580861057', '1580861057', '');
INSERT INTO `tp_auth_rule` VALUES ('17', '9', 'DictionaryType/sort', '操作-排序', '1', '0', '', '8', '1', '', '1580861057', '1580861057', '');
INSERT INTO `tp_auth_rule` VALUES ('18', '9', 'DictionaryType/state', '操作-状态', '1', '0', '', '9', '1', '', '1580861057', '1580861057', '');
INSERT INTO `tp_auth_rule` VALUES ('19', '157', 'Dictionary/index', '字典数据', '1', '1', '', '13', '1', '', '1580861065', '1580861065', '');
INSERT INTO `tp_auth_rule` VALUES ('20', '19', 'Dictionary/add', '操作-添加', '1', '0', '', '1', '1', '', '1580861065', '1580861065', '');
INSERT INTO `tp_auth_rule` VALUES ('21', '19', 'Dictionary/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1580861065', '1580861065', '');
INSERT INTO `tp_auth_rule` VALUES ('22', '19', 'Dictionary/edit', '操作-修改', '1', '0', '', '3', '1', '', '1580861065', '1580861065', '');
INSERT INTO `tp_auth_rule` VALUES ('23', '19', 'Dictionary/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1580861065', '1580861065', '');
INSERT INTO `tp_auth_rule` VALUES ('24', '19', 'Dictionary/del', '操作-删除', '1', '0', '', '5', '1', '', '1580861065', '1580861065', '');
INSERT INTO `tp_auth_rule` VALUES ('25', '19', 'Dictionary/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1580861065', '1580861065', '');
INSERT INTO `tp_auth_rule` VALUES ('26', '19', 'Dictionary/export', '操作-导出', '1', '0', '', '7', '1', '', '1580861065', '1580861065', '');
INSERT INTO `tp_auth_rule` VALUES ('27', '19', 'Dictionary/sort', '操作-排序', '1', '0', '', '8', '1', '', '1580861065', '1580861065', '');
INSERT INTO `tp_auth_rule` VALUES ('28', '19', 'Dictionary/state', '操作-状态', '1', '0', '', '9', '1', '', '1580861065', '1580861065', '');
INSERT INTO `tp_auth_rule` VALUES ('29', '162', 'UsersType/index', '会员分组', '1', '1', '', '72', '1', 'fa fa-users', '1580861073', '1580908165', '');
INSERT INTO `tp_auth_rule` VALUES ('30', '29', 'UsersType/add', '操作-添加', '1', '0', '', '1', '1', '', '1580861073', '1580861073', '');
INSERT INTO `tp_auth_rule` VALUES ('31', '29', 'UsersType/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1580861073', '1580861073', '');
INSERT INTO `tp_auth_rule` VALUES ('32', '29', 'UsersType/edit', '操作-修改', '1', '0', '', '3', '1', '', '1580861073', '1580861073', '');
INSERT INTO `tp_auth_rule` VALUES ('33', '29', 'UsersType/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1580861073', '1580861073', '');
INSERT INTO `tp_auth_rule` VALUES ('34', '29', 'UsersType/del', '操作-删除', '1', '0', '', '5', '1', '', '1580861073', '1580861073', '');
INSERT INTO `tp_auth_rule` VALUES ('35', '29', 'UsersType/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1580861073', '1580861073', '');
INSERT INTO `tp_auth_rule` VALUES ('36', '29', 'UsersType/export', '操作-导出', '1', '0', '', '7', '1', '', '1580861073', '1580861073', '');
INSERT INTO `tp_auth_rule` VALUES ('37', '29', 'UsersType/sort', '操作-排序', '1', '0', '', '8', '1', '', '1580861073', '1580861073', '');
INSERT INTO `tp_auth_rule` VALUES ('38', '29', 'UsersType/state', '操作-状态', '1', '0', '', '9', '1', '', '1580861073', '1580861073', '');
INSERT INTO `tp_auth_rule` VALUES ('39', '160', 'FieldGroup/index', '字段分组', '1', '1', '', '43', '1', 'fa fa-bullseye', '1580861081', '1580861081', '');
INSERT INTO `tp_auth_rule` VALUES ('40', '39', 'FieldGroup/add', '操作-添加', '1', '0', '', '1', '1', '', '1580861081', '1580861081', '');
INSERT INTO `tp_auth_rule` VALUES ('41', '39', 'FieldGroup/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1580861081', '1580861081', '');
INSERT INTO `tp_auth_rule` VALUES ('42', '39', 'FieldGroup/edit', '操作-修改', '1', '0', '', '3', '1', '', '1580861081', '1580861081', '');
INSERT INTO `tp_auth_rule` VALUES ('43', '39', 'FieldGroup/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1580861081', '1580861081', '');
INSERT INTO `tp_auth_rule` VALUES ('44', '39', 'FieldGroup/del', '操作-删除', '1', '0', '', '5', '1', '', '1580861081', '1580861081', '');
INSERT INTO `tp_auth_rule` VALUES ('45', '39', 'FieldGroup/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1580861081', '1580861081', '');
INSERT INTO `tp_auth_rule` VALUES ('46', '39', 'FieldGroup/export', '操作-导出', '1', '0', '', '7', '1', '', '1580861081', '1580861081', '');
INSERT INTO `tp_auth_rule` VALUES ('47', '39', 'FieldGroup/sort', '操作-排序', '1', '0', '', '8', '1', '', '1580861081', '1580861081', '');
INSERT INTO `tp_auth_rule` VALUES ('48', '39', 'FieldGroup/state', '操作-状态', '1', '0', '', '9', '1', '', '1580861081', '1580861081', '');
INSERT INTO `tp_auth_rule` VALUES ('49', '161', 'Link/index', '友情链接', '1', '1', '', '61', '1', 'fa fa-link', '1580861091', '1580908119', '');
INSERT INTO `tp_auth_rule` VALUES ('50', '49', 'Link/add', '操作-添加', '1', '0', '', '1', '1', '', '1580861091', '1580861091', '');
INSERT INTO `tp_auth_rule` VALUES ('51', '49', 'Link/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1580861091', '1580861091', '');
INSERT INTO `tp_auth_rule` VALUES ('52', '49', 'Link/edit', '操作-修改', '1', '0', '', '3', '1', '', '1580861091', '1580861091', '');
INSERT INTO `tp_auth_rule` VALUES ('53', '49', 'Link/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1580861091', '1580861091', '');
INSERT INTO `tp_auth_rule` VALUES ('54', '49', 'Link/del', '操作-删除', '1', '0', '', '5', '1', '', '1580861091', '1580861091', '');
INSERT INTO `tp_auth_rule` VALUES ('55', '49', 'Link/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1580861091', '1580861091', '');
INSERT INTO `tp_auth_rule` VALUES ('56', '49', 'Link/export', '操作-导出', '1', '0', '', '7', '1', '', '1580861091', '1580861091', '');
INSERT INTO `tp_auth_rule` VALUES ('57', '49', 'Link/sort', '操作-排序', '1', '0', '', '8', '1', '', '1580861091', '1580861091', '');
INSERT INTO `tp_auth_rule` VALUES ('58', '49', 'Link/state', '操作-状态', '1', '0', '', '9', '1', '', '1580861091', '1580861091', '');
INSERT INTO `tp_auth_rule` VALUES ('59', '161', 'AdType/index', '广告分组', '1', '1', '', '63', '1', 'fa fa-tv', '1580861099', '1580908135', '');
INSERT INTO `tp_auth_rule` VALUES ('60', '59', 'AdType/add', '操作-添加', '1', '0', '', '1', '1', '', '1580861099', '1580861099', '');
INSERT INTO `tp_auth_rule` VALUES ('61', '59', 'AdType/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1580861099', '1580861099', '');
INSERT INTO `tp_auth_rule` VALUES ('62', '59', 'AdType/edit', '操作-修改', '1', '0', '', '3', '1', '', '1580861099', '1580861099', '');
INSERT INTO `tp_auth_rule` VALUES ('63', '59', 'AdType/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1580861099', '1580861099', '');
INSERT INTO `tp_auth_rule` VALUES ('64', '59', 'AdType/del', '操作-删除', '1', '0', '', '5', '1', '', '1580861099', '1580861099', '');
INSERT INTO `tp_auth_rule` VALUES ('65', '59', 'AdType/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1580861099', '1580861099', '');
INSERT INTO `tp_auth_rule` VALUES ('66', '59', 'AdType/export', '操作-导出', '1', '0', '', '7', '1', '', '1580861099', '1580861099', '');
INSERT INTO `tp_auth_rule` VALUES ('67', '59', 'AdType/sort', '操作-排序', '1', '0', '', '8', '1', '', '1580861099', '1580861099', '');
INSERT INTO `tp_auth_rule` VALUES ('68', '59', 'AdType/state', '操作-状态', '1', '0', '', '9', '1', '', '1580861099', '1580861099', '');
INSERT INTO `tp_auth_rule` VALUES ('69', '161', 'Ad/index', '广告管理', '1', '1', '', '62', '1', 'fa fa-tv', '1580861106', '1580908132', '');
INSERT INTO `tp_auth_rule` VALUES ('70', '69', 'Ad/add', '操作-添加', '1', '0', '', '1', '1', '', '1580861106', '1580861106', '');
INSERT INTO `tp_auth_rule` VALUES ('71', '69', 'Ad/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1580861106', '1580861106', '');
INSERT INTO `tp_auth_rule` VALUES ('72', '69', 'Ad/edit', '操作-修改', '1', '0', '', '3', '1', '', '1580861106', '1580861106', '');
INSERT INTO `tp_auth_rule` VALUES ('73', '69', 'Ad/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1580861106', '1580861106', '');
INSERT INTO `tp_auth_rule` VALUES ('74', '69', 'Ad/del', '操作-删除', '1', '0', '', '5', '1', '', '1580861106', '1580861106', '');
INSERT INTO `tp_auth_rule` VALUES ('75', '69', 'Ad/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1580861106', '1580861106', '');
INSERT INTO `tp_auth_rule` VALUES ('76', '69', 'Ad/export', '操作-导出', '1', '0', '', '7', '1', '', '1580861106', '1580861106', '');
INSERT INTO `tp_auth_rule` VALUES ('77', '69', 'Ad/sort', '操作-排序', '1', '0', '', '8', '1', '', '1580861107', '1580861107', '');
INSERT INTO `tp_auth_rule` VALUES ('78', '69', 'Ad/state', '操作-状态', '1', '0', '', '9', '1', '', '1580861107', '1580861107', '');
INSERT INTO `tp_auth_rule` VALUES ('79', '161', 'Debris/index', '碎片管理', '1', '1', '', '64', '1', 'fa fa-gift', '1580861113', '1580908138', '');
INSERT INTO `tp_auth_rule` VALUES ('80', '79', 'Debris/add', '操作-添加', '1', '0', '', '1', '1', '', '1580861113', '1580861113', '');
INSERT INTO `tp_auth_rule` VALUES ('81', '79', 'Debris/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1580861113', '1580861113', '');
INSERT INTO `tp_auth_rule` VALUES ('82', '79', 'Debris/edit', '操作-修改', '1', '0', '', '3', '1', '', '1580861113', '1580861113', '');
INSERT INTO `tp_auth_rule` VALUES ('83', '79', 'Debris/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1580861113', '1580861113', '');
INSERT INTO `tp_auth_rule` VALUES ('84', '79', 'Debris/del', '操作-删除', '1', '0', '', '5', '1', '', '1580861113', '1580861113', '');
INSERT INTO `tp_auth_rule` VALUES ('85', '79', 'Debris/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1580861113', '1580861113', '');
INSERT INTO `tp_auth_rule` VALUES ('86', '79', 'Debris/export', '操作-导出', '1', '0', '', '7', '1', '', '1580861113', '1580861113', '');
INSERT INTO `tp_auth_rule` VALUES ('87', '79', 'Debris/sort', '操作-排序', '1', '0', '', '8', '1', '', '1580861113', '1580861113', '');
INSERT INTO `tp_auth_rule` VALUES ('88', '79', 'Debris/state', '操作-状态', '1', '0', '', '9', '1', '', '1580861113', '1580861113', '');
INSERT INTO `tp_auth_rule` VALUES ('92', '157', 'System/index', '系统设置', '1', '1', '', '11', '1', 'fa fa-cog', '1580861127', '1580874204', '');
INSERT INTO `tp_auth_rule` VALUES ('93', '92', 'System/add', '操作-添加', '1', '0', '', '1', '1', '', '1580861127', '1580861127', '');
INSERT INTO `tp_auth_rule` VALUES ('94', '92', 'System/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1580861127', '1580861127', '');
INSERT INTO `tp_auth_rule` VALUES ('95', '92', 'System/edit', '操作-修改', '1', '0', '', '3', '1', '', '1580861127', '1580861127', '');
INSERT INTO `tp_auth_rule` VALUES ('96', '92', 'System/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1580861127', '1580861127', '');
INSERT INTO `tp_auth_rule` VALUES ('97', '92', 'System/del', '操作-删除', '1', '0', '', '5', '1', '', '1580861127', '1580861127', '');
INSERT INTO `tp_auth_rule` VALUES ('98', '92', 'System/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1580861127', '1580861127', '');
INSERT INTO `tp_auth_rule` VALUES ('99', '92', 'System/export', '操作-导出', '1', '0', '', '7', '1', '', '1580861127', '1580861127', '');
INSERT INTO `tp_auth_rule` VALUES ('100', '158', 'AdminLog/index', '管理员日志', '1', '1', '', '24', '1', 'fa fa-book', '1580871750', '1580871750', '');
INSERT INTO `tp_auth_rule` VALUES ('101', '100', 'AdminLog/edit', '操作-修改', '1', '0', '', '3', '1', '', '1580871750', '1580871750', '');
INSERT INTO `tp_auth_rule` VALUES ('102', '100', 'AdminLog/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1580871750', '1580871750', '');
INSERT INTO `tp_auth_rule` VALUES ('103', '100', 'AdminLog/del', '操作-删除', '1', '0', '', '5', '1', '', '1580871750', '1580871750', '');
INSERT INTO `tp_auth_rule` VALUES ('104', '100', 'AdminLog/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1580871750', '1580871750', '');
INSERT INTO `tp_auth_rule` VALUES ('105', '100', 'AdminLog/export', '操作-导出', '1', '0', '', '7', '1', '', '1580871750', '1580871750', '');
INSERT INTO `tp_auth_rule` VALUES ('106', '158', 'AuthRule/index', '菜单规则', '1', '1', '', '23', '1', 'fa fa-bars', '1580871826', '1580871826', '');
INSERT INTO `tp_auth_rule` VALUES ('107', '106', 'AuthRule/add', '操作-添加', '1', '0', '', '1', '1', '', '1580871826', '1580871826', '');
INSERT INTO `tp_auth_rule` VALUES ('108', '106', 'AuthRule/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1580871826', '1580871826', '');
INSERT INTO `tp_auth_rule` VALUES ('109', '106', 'AuthRule/edit', '操作-修改', '1', '0', '', '3', '1', '', '1580871826', '1580871826', '');
INSERT INTO `tp_auth_rule` VALUES ('110', '106', 'AuthRule/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1580871826', '1580871826', '');
INSERT INTO `tp_auth_rule` VALUES ('111', '106', 'AuthRule/del', '操作-删除', '1', '0', '', '5', '1', '', '1580871826', '1580871826', '');
INSERT INTO `tp_auth_rule` VALUES ('112', '106', 'AuthRule/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1580871826', '1580871826', '');
INSERT INTO `tp_auth_rule` VALUES ('113', '106', 'AuthRule/export', '操作-导出', '1', '0', '', '7', '1', '', '1580871826', '1580871826', '');
INSERT INTO `tp_auth_rule` VALUES ('114', '106', 'AuthRule/sort', '操作-排序', '1', '0', '', '8', '1', '', '1580871826', '1580871826', '');
INSERT INTO `tp_auth_rule` VALUES ('115', '106', 'AuthRule/state', '操作-状态', '1', '0', '', '9', '1', '', '1580871826', '1580871826', '');
INSERT INTO `tp_auth_rule` VALUES ('116', '158', 'Admin/index', '管理员管理', '1', '1', '', '21', '1', 'fa fa-user', '1580871882', '1580871882', '');
INSERT INTO `tp_auth_rule` VALUES ('117', '116', 'Admin/add', '操作-添加', '1', '0', '', '1', '1', '', '1580871882', '1580871882', '');
INSERT INTO `tp_auth_rule` VALUES ('118', '116', 'Admin/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1580871882', '1580871882', '');
INSERT INTO `tp_auth_rule` VALUES ('119', '116', 'Admin/edit', '操作-修改', '1', '0', '', '3', '1', '', '1580871882', '1580871882', '');
INSERT INTO `tp_auth_rule` VALUES ('120', '116', 'Admin/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1580871882', '1580871882', '');
INSERT INTO `tp_auth_rule` VALUES ('121', '116', 'Admin/del', '操作-删除', '1', '0', '', '5', '1', '', '1580871882', '1580871882', '');
INSERT INTO `tp_auth_rule` VALUES ('122', '116', 'Admin/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1580871882', '1580871882', '');
INSERT INTO `tp_auth_rule` VALUES ('123', '116', 'Admin/export', '操作-导出', '1', '0', '', '7', '1', '', '1580871882', '1580871882', '');
INSERT INTO `tp_auth_rule` VALUES ('124', '116', 'Admin/state', '操作-状态', '1', '0', '', '9', '1', '', '1580871882', '1580871882', '');
INSERT INTO `tp_auth_rule` VALUES ('125', '158', 'AuthGroup/index', '角色组管理', '1', '1', '', '22', '1', 'fas fa-user-shield', '1580871965', '1580871965', '');
INSERT INTO `tp_auth_rule` VALUES ('126', '125', 'AuthGroup/add', '操作-添加', '1', '0', '', '1', '1', '', '1580871965', '1580871965', '');
INSERT INTO `tp_auth_rule` VALUES ('127', '125', 'AuthGroup/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1580871965', '1580871965', '');
INSERT INTO `tp_auth_rule` VALUES ('128', '125', 'AuthGroup/edit', '操作-修改', '1', '0', '', '3', '1', '', '1580871965', '1580871965', '');
INSERT INTO `tp_auth_rule` VALUES ('129', '125', 'AuthGroup/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1580871965', '1580871965', '');
INSERT INTO `tp_auth_rule` VALUES ('130', '125', 'AuthGroup/del', '操作-删除', '1', '0', '', '5', '1', '', '1580871965', '1580871965', '');
INSERT INTO `tp_auth_rule` VALUES ('131', '125', 'AuthGroup/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1580871965', '1580871965', '');
INSERT INTO `tp_auth_rule` VALUES ('132', '125', 'AuthGroup/export', '操作-导出', '1', '0', '', '7', '1', '', '1580871965', '1580871965', '');
INSERT INTO `tp_auth_rule` VALUES ('133', '125', 'AuthGroup/state', '操作-状态', '1', '0', '', '9', '1', '', '1580871965', '1580871965', '');
INSERT INTO `tp_auth_rule` VALUES ('134', '125', 'AuthGroup/access', '操作-权限', '1', '0', '', '10', '1', '', '1580872096', '1580872096', '');
INSERT INTO `tp_auth_rule` VALUES ('135', '125', 'AuthGroup/accessPost', '操作-权限保存', '1', '0', '', '11', '1', '', '1580872132', '1580872132', '');
INSERT INTO `tp_auth_rule` VALUES ('136', '160', 'Module/index', '模块管理', '1', '1', '', '41', '1', 'fa fa-th-list', '1580872182', '1580878146', '');
INSERT INTO `tp_auth_rule` VALUES ('137', '136', 'Module/add', '操作-添加', '1', '0', '', '1', '1', '', '1580872182', '1580872182', '');
INSERT INTO `tp_auth_rule` VALUES ('138', '136', 'Module/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1580872182', '1580872182', '');
INSERT INTO `tp_auth_rule` VALUES ('139', '136', 'Module/edit', '操作-修改', '1', '0', '', '3', '1', '', '1580872182', '1580872182', '');
INSERT INTO `tp_auth_rule` VALUES ('140', '136', 'Module/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1580872182', '1580872182', '');
INSERT INTO `tp_auth_rule` VALUES ('141', '136', 'Module/del', '操作-删除', '1', '0', '', '5', '1', '', '1580872182', '1580872182', '');
INSERT INTO `tp_auth_rule` VALUES ('142', '136', 'Module/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1580872182', '1580872182', '');
INSERT INTO `tp_auth_rule` VALUES ('143', '136', 'Module/export', '操作-导出', '1', '0', '', '7', '1', '', '1580872182', '1580872182', '');
INSERT INTO `tp_auth_rule` VALUES ('144', '136', 'Module/sort', '操作-排序', '1', '0', '', '8', '1', '', '1580872182', '1580872182', '');
INSERT INTO `tp_auth_rule` VALUES ('145', '136', 'Module/build', '操作-生成代码', '1', '0', '', '9', '1', '', '1580872699', '1580872699', '');
INSERT INTO `tp_auth_rule` VALUES ('146', '136', 'Module/makeRule', '操作-生成菜单规则', '1', '0', '', '10', '1', '', '1580872730', '1580872730', '');
INSERT INTO `tp_auth_rule` VALUES ('147', '160', 'Field/index', '字段管理', '1', '1', '', '42', '1', 'fa fa-bullhorn', '1580872859', '1580872859', '');
INSERT INTO `tp_auth_rule` VALUES ('148', '147', 'Field/add', '操作-添加', '1', '0', '', '1', '1', '', '1580872859', '1580872859', '');
INSERT INTO `tp_auth_rule` VALUES ('149', '147', 'Field/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1580872859', '1580872859', '');
INSERT INTO `tp_auth_rule` VALUES ('150', '147', 'Field/edit', '操作-修改', '1', '0', '', '3', '1', '', '1580872859', '1580872859', '');
INSERT INTO `tp_auth_rule` VALUES ('151', '147', 'Field/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1580872859', '1580872859', '');
INSERT INTO `tp_auth_rule` VALUES ('152', '147', 'Field/del', '操作-删除', '1', '0', '', '5', '1', '', '1580872859', '1580872859', '');
INSERT INTO `tp_auth_rule` VALUES ('153', '147', 'Field/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1580872859', '1580872859', '');
INSERT INTO `tp_auth_rule` VALUES ('154', '147', 'Field/changeType', '操作-加载配置', '1', '0', '', '7', '1', '', '1580872859', '1580872859', '');
INSERT INTO `tp_auth_rule` VALUES ('155', '147', 'Field/sort', '操作-排序', '1', '0', '', '8', '1', '', '1580872859', '1580872859', '');
INSERT INTO `tp_auth_rule` VALUES ('156', '147', 'Field/state', '操作-状态', '1', '0', '', '9', '1', '', '1580872859', '1580872859', '');
INSERT INTO `tp_auth_rule` VALUES ('157', '0', 'System', '系统管理', '1', '1', '', '1', '1', 'fa fa-cogs', '1580874149', '1580874149', '');
INSERT INTO `tp_auth_rule` VALUES ('158', '0', 'Auth', '权限管理', '1', '1', '', '2', '1', 'fas fa-user-cog', '1580874265', '1580874265', '');
INSERT INTO `tp_auth_rule` VALUES ('159', '0', 'Database', '数据库管理', '1', '1', '', '3', '1', 'fa fa-database', '1580876394', '1580876394', '');
INSERT INTO `tp_auth_rule` VALUES ('160', '0', 'Module', '模块管理', '1', '1', '', '4', '1', 'fa fa-bolt', '1580876437', '1580876437', '');
INSERT INTO `tp_auth_rule` VALUES ('161', '0', 'Link', '网站功能', '1', '1', '', '6', '1', 'fas fa-layer-group', '1580878492', '1580908102', '');
INSERT INTO `tp_auth_rule` VALUES ('162', '0', 'Users', '会员管理', '1', '1', '', '7', '1', 'fa fa-user', '1580878687', '1580908154', '');
INSERT INTO `tp_auth_rule` VALUES ('163', '159', 'Database/database', '数据库备份', '1', '1', '', '31', '1', 'fa fa-server', '1580881507', '1580881507', '');
INSERT INTO `tp_auth_rule` VALUES ('164', '163', 'Database/backup', '操作-备份', '1', '0', '', '1', '1', '', '1580881536', '1580881536', '');
INSERT INTO `tp_auth_rule` VALUES ('165', '163', 'Database/repair', '操作-修复', '1', '0', '', '2', '1', '', '1580881567', '1580881567', '');
INSERT INTO `tp_auth_rule` VALUES ('166', '163', 'Database/optimize', '操作-优化', '1', '0', '', '3', '1', '', '1580881596', '1580881596', '');
INSERT INTO `tp_auth_rule` VALUES ('167', '159', 'Database/restore', '数据库还原', '1', '1', '', '32', '1', 'fa fa-recycle', '1580881718', '1580881729', '');
INSERT INTO `tp_auth_rule` VALUES ('168', '167', 'Database/import', '操作-还原', '1', '0', '', '1', '1', '', '1580881791', '1580881791', '');
INSERT INTO `tp_auth_rule` VALUES ('169', '167', 'Database/downFile', '操作-下载', '1', '0', '', '2', '1', '', '1580881823', '1580881823', '');
INSERT INTO `tp_auth_rule` VALUES ('170', '167', 'Database/del', '操作-删除', '1', '0', '', '3', '1', '', '1580881861', '1580881861', '');
INSERT INTO `tp_auth_rule` VALUES ('171', '157', 'Config/email', '邮件配置', '1', '1', '', '14', '1', 'fas fa-envelope nav-icon', '1580882102', '1580882122', '');
INSERT INTO `tp_auth_rule` VALUES ('172', '171', 'Config/emailPost', '操作-修改保存', '1', '0', '', '1', '1', '', '1580882214', '1580882214', '');
INSERT INTO `tp_auth_rule` VALUES ('173', '171', 'Config/emailSend', '操作-测试邮箱', '1', '0', '', '2', '1', '', '1580882294', '1580882294', '');
INSERT INTO `tp_auth_rule` VALUES ('174', '157', 'Config/sms', '短信配置', '1', '1', '', '15', '1', 'fas fa-comment-dots', '1580882360', '1580882360', '');
INSERT INTO `tp_auth_rule` VALUES ('175', '174', 'Config/smsPost', '操作-修改保存', '1', '0', '', '1', '1', '', '1580882449', '1580882449', '');
INSERT INTO `tp_auth_rule` VALUES ('176', '174', 'Config/smsSend', '操作-测试短信', '1', '0', '', '2', '1', '', '1580882486', '1580882486', '');
INSERT INTO `tp_auth_rule` VALUES ('177', '187', 'Cate/index', '栏目管理', '1', '1', '', '51', '1', 'fas fa-th-list', '1580907966', '1580908113', '');
INSERT INTO `tp_auth_rule` VALUES ('178', '177', 'Cate/add', '操作-添加', '1', '0', '', '1', '1', '', '1580907966', '1580907966', '');
INSERT INTO `tp_auth_rule` VALUES ('179', '177', 'Cate/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1580907966', '1580907966', '');
INSERT INTO `tp_auth_rule` VALUES ('180', '177', 'Cate/edit', '操作-修改', '1', '0', '', '3', '1', '', '1580907966', '1580907966', '');
INSERT INTO `tp_auth_rule` VALUES ('181', '177', 'Cate/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1580907966', '1580907966', '');
INSERT INTO `tp_auth_rule` VALUES ('182', '177', 'Cate/del', '操作-删除', '1', '0', '', '5', '1', '', '1580907966', '1580907966', '');
INSERT INTO `tp_auth_rule` VALUES ('183', '177', 'Cate/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1580907966', '1580907966', '');
INSERT INTO `tp_auth_rule` VALUES ('184', '177', 'Cate/export', '操作-导出', '1', '0', '', '7', '1', '', '1580907966', '1580907966', '');
INSERT INTO `tp_auth_rule` VALUES ('185', '177', 'Cate/sort', '操作-排序', '1', '0', '', '8', '1', '', '1580907966', '1580907966', '');
INSERT INTO `tp_auth_rule` VALUES ('186', '177', 'Cate/state', '操作-状态', '1', '0', '', '9', '1', '', '1580907966', '1580907966', '');
INSERT INTO `tp_auth_rule` VALUES ('187', '0', 'Cate', '栏目管理', '1', '1', '', '5', '1', 'fa fa-th', '1580908039', '1580908039', '');
INSERT INTO `tp_auth_rule` VALUES ('188', '0', 'Page', '内容管理', '1', '1', '', '8', '1', 'fa fa-briefcase', '1581080617', '1581080617', '');
INSERT INTO `tp_auth_rule` VALUES ('189', '188', 'Page/index', '单页模块', '1', '1', '', '81', '1', '', '1581080630', '1581080705', '');
INSERT INTO `tp_auth_rule` VALUES ('190', '189', 'Page/add', '操作-添加', '1', '0', '', '1', '1', '', '1581080630', '1581080630', '');
INSERT INTO `tp_auth_rule` VALUES ('191', '189', 'Page/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1581080630', '1581080630', '');
INSERT INTO `tp_auth_rule` VALUES ('192', '189', 'Page/edit', '操作-修改', '1', '0', '', '3', '1', '', '1581080630', '1581080630', '');
INSERT INTO `tp_auth_rule` VALUES ('193', '189', 'Page/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1581080630', '1581080630', '');
INSERT INTO `tp_auth_rule` VALUES ('194', '189', 'Page/del', '操作-删除', '1', '0', '', '5', '1', '', '1581080630', '1581080630', '');
INSERT INTO `tp_auth_rule` VALUES ('195', '189', 'Page/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1581080630', '1581080630', '');
INSERT INTO `tp_auth_rule` VALUES ('196', '189', 'Page/export', '操作-导出', '1', '0', '', '7', '1', '', '1581080630', '1581080630', '');
INSERT INTO `tp_auth_rule` VALUES ('197', '189', 'Page/sort', '操作-排序', '1', '0', '', '8', '1', '', '1581080630', '1581080630', '');
INSERT INTO `tp_auth_rule` VALUES ('198', '189', 'Page/state', '操作-状态', '1', '0', '', '9', '1', '', '1581080630', '1581080630', '');
INSERT INTO `tp_auth_rule` VALUES ('199', '188', 'Article/index', '文章模块', '1', '1', '', '82', '1', '', '1581080635', '1581080712', '');
INSERT INTO `tp_auth_rule` VALUES ('200', '199', 'Article/add', '操作-添加', '1', '0', '', '1', '1', '', '1581080635', '1581080635', '');
INSERT INTO `tp_auth_rule` VALUES ('201', '199', 'Article/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1581080635', '1581080635', '');
INSERT INTO `tp_auth_rule` VALUES ('202', '199', 'Article/edit', '操作-修改', '1', '0', '', '3', '1', '', '1581080635', '1581080635', '');
INSERT INTO `tp_auth_rule` VALUES ('203', '199', 'Article/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1581080635', '1581080635', '');
INSERT INTO `tp_auth_rule` VALUES ('204', '199', 'Article/del', '操作-删除', '1', '0', '', '5', '1', '', '1581080635', '1581080635', '');
INSERT INTO `tp_auth_rule` VALUES ('205', '199', 'Article/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1581080635', '1581080635', '');
INSERT INTO `tp_auth_rule` VALUES ('206', '199', 'Article/export', '操作-导出', '1', '0', '', '7', '1', '', '1581080635', '1581080635', '');
INSERT INTO `tp_auth_rule` VALUES ('207', '199', 'Article/sort', '操作-排序', '1', '0', '', '8', '1', '', '1581080635', '1581080635', '');
INSERT INTO `tp_auth_rule` VALUES ('208', '199', 'Article/state', '操作-状态', '1', '0', '', '9', '1', '', '1581080635', '1581080635', '');
INSERT INTO `tp_auth_rule` VALUES ('209', '188', 'Picture/index', '图片模块', '1', '1', '', '83', '1', '', '1581080640', '1581080717', '');
INSERT INTO `tp_auth_rule` VALUES ('210', '209', 'Picture/add', '操作-添加', '1', '0', '', '1', '1', '', '1581080640', '1581080640', '');
INSERT INTO `tp_auth_rule` VALUES ('211', '209', 'Picture/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1581080640', '1581080640', '');
INSERT INTO `tp_auth_rule` VALUES ('212', '209', 'Picture/edit', '操作-修改', '1', '0', '', '3', '1', '', '1581080640', '1581080640', '');
INSERT INTO `tp_auth_rule` VALUES ('213', '209', 'Picture/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1581080640', '1581080640', '');
INSERT INTO `tp_auth_rule` VALUES ('214', '209', 'Picture/del', '操作-删除', '1', '0', '', '5', '1', '', '1581080640', '1581080640', '');
INSERT INTO `tp_auth_rule` VALUES ('215', '209', 'Picture/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1581080640', '1581080640', '');
INSERT INTO `tp_auth_rule` VALUES ('216', '209', 'Picture/export', '操作-导出', '1', '0', '', '7', '1', '', '1581080640', '1581080640', '');
INSERT INTO `tp_auth_rule` VALUES ('217', '209', 'Picture/sort', '操作-排序', '1', '0', '', '8', '1', '', '1581080640', '1581080640', '');
INSERT INTO `tp_auth_rule` VALUES ('218', '209', 'Picture/state', '操作-状态', '1', '0', '', '9', '1', '', '1581080640', '1581080640', '');
INSERT INTO `tp_auth_rule` VALUES ('219', '188', 'Product/index', '产品模块', '1', '1', '', '84', '1', '', '1581080644', '1581080721', '');
INSERT INTO `tp_auth_rule` VALUES ('220', '219', 'Product/add', '操作-添加', '1', '0', '', '1', '1', '', '1581080644', '1581080644', '');
INSERT INTO `tp_auth_rule` VALUES ('221', '219', 'Product/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1581080644', '1581080644', '');
INSERT INTO `tp_auth_rule` VALUES ('222', '219', 'Product/edit', '操作-修改', '1', '0', '', '3', '1', '', '1581080644', '1581080644', '');
INSERT INTO `tp_auth_rule` VALUES ('223', '219', 'Product/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1581080644', '1581080644', '');
INSERT INTO `tp_auth_rule` VALUES ('224', '219', 'Product/del', '操作-删除', '1', '0', '', '5', '1', '', '1581080644', '1581080644', '');
INSERT INTO `tp_auth_rule` VALUES ('225', '219', 'Product/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1581080644', '1581080644', '');
INSERT INTO `tp_auth_rule` VALUES ('226', '219', 'Product/export', '操作-导出', '1', '0', '', '7', '1', '', '1581080644', '1581080644', '');
INSERT INTO `tp_auth_rule` VALUES ('227', '219', 'Product/sort', '操作-排序', '1', '0', '', '8', '1', '', '1581080644', '1581080644', '');
INSERT INTO `tp_auth_rule` VALUES ('228', '219', 'Product/state', '操作-状态', '1', '0', '', '9', '1', '', '1581080644', '1581080644', '');
INSERT INTO `tp_auth_rule` VALUES ('229', '188', 'Download/index', '下载模块', '1', '1', '', '85', '1', '', '1581080647', '1581080726', '');
INSERT INTO `tp_auth_rule` VALUES ('230', '229', 'Download/add', '操作-添加', '1', '0', '', '1', '1', '', '1581080647', '1581080647', '');
INSERT INTO `tp_auth_rule` VALUES ('231', '229', 'Download/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1581080647', '1581080647', '');
INSERT INTO `tp_auth_rule` VALUES ('232', '229', 'Download/edit', '操作-修改', '1', '0', '', '3', '1', '', '1581080647', '1581080647', '');
INSERT INTO `tp_auth_rule` VALUES ('233', '229', 'Download/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1581080647', '1581080647', '');
INSERT INTO `tp_auth_rule` VALUES ('234', '229', 'Download/del', '操作-删除', '1', '0', '', '5', '1', '', '1581080647', '1581080647', '');
INSERT INTO `tp_auth_rule` VALUES ('235', '229', 'Download/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1581080647', '1581080647', '');
INSERT INTO `tp_auth_rule` VALUES ('236', '229', 'Download/export', '操作-导出', '1', '0', '', '7', '1', '', '1581080647', '1581080647', '');
INSERT INTO `tp_auth_rule` VALUES ('237', '229', 'Download/sort', '操作-排序', '1', '0', '', '8', '1', '', '1581080647', '1581080647', '');
INSERT INTO `tp_auth_rule` VALUES ('238', '229', 'Download/state', '操作-状态', '1', '0', '', '9', '1', '', '1581080647', '1581080647', '');
INSERT INTO `tp_auth_rule` VALUES ('239', '188', 'Team/index', '团队模块', '1', '1', '', '86', '1', '', '1581080650', '1581080731', '');
INSERT INTO `tp_auth_rule` VALUES ('240', '239', 'Team/add', '操作-添加', '1', '0', '', '1', '1', '', '1581080650', '1581080650', '');
INSERT INTO `tp_auth_rule` VALUES ('241', '239', 'Team/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1581080650', '1581080650', '');
INSERT INTO `tp_auth_rule` VALUES ('242', '239', 'Team/edit', '操作-修改', '1', '0', '', '3', '1', '', '1581080650', '1581080650', '');
INSERT INTO `tp_auth_rule` VALUES ('243', '239', 'Team/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1581080650', '1581080650', '');
INSERT INTO `tp_auth_rule` VALUES ('244', '239', 'Team/del', '操作-删除', '1', '0', '', '5', '1', '', '1581080650', '1581080650', '');
INSERT INTO `tp_auth_rule` VALUES ('245', '239', 'Team/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1581080650', '1581080650', '');
INSERT INTO `tp_auth_rule` VALUES ('246', '239', 'Team/export', '操作-导出', '1', '0', '', '7', '1', '', '1581080650', '1581080650', '');
INSERT INTO `tp_auth_rule` VALUES ('247', '239', 'Team/sort', '操作-排序', '1', '0', '', '8', '1', '', '1581080650', '1581080650', '');
INSERT INTO `tp_auth_rule` VALUES ('248', '239', 'Team/state', '操作-状态', '1', '0', '', '9', '1', '', '1581080650', '1581080650', '');
INSERT INTO `tp_auth_rule` VALUES ('249', '188', 'Message/index', '留言模块', '1', '1', '', '87', '1', '', '1581080655', '1581080741', '');
INSERT INTO `tp_auth_rule` VALUES ('250', '249', 'Message/add', '操作-添加', '1', '0', '', '1', '1', '', '1581080655', '1581080655', '');
INSERT INTO `tp_auth_rule` VALUES ('251', '249', 'Message/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1581080655', '1581080655', '');
INSERT INTO `tp_auth_rule` VALUES ('252', '249', 'Message/edit', '操作-修改', '1', '0', '', '3', '1', '', '1581080655', '1581080655', '');
INSERT INTO `tp_auth_rule` VALUES ('253', '249', 'Message/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1581080655', '1581080655', '');
INSERT INTO `tp_auth_rule` VALUES ('254', '249', 'Message/del', '操作-删除', '1', '0', '', '5', '1', '', '1581080655', '1581080655', '');
INSERT INTO `tp_auth_rule` VALUES ('255', '249', 'Message/selectDel', '操作-批量删除', '1', '0', '', '6', '1', '', '1581080655', '1581080655', '');
INSERT INTO `tp_auth_rule` VALUES ('256', '249', 'Message/export', '操作-导出', '1', '0', '', '7', '1', '', '1581080655', '1581080655', '');
INSERT INTO `tp_auth_rule` VALUES ('257', '249', 'Message/state', '操作-状态', '1', '0', '', '9', '1', '', '1581080655', '1581214069', '');
INSERT INTO `tp_auth_rule` VALUES ('258', '0', 'Demo', '实例演示', '1', '1', '', '9', '1', 'fa fa-desktop', '1581210913', '1581210922', '');
INSERT INTO `tp_auth_rule` VALUES ('260', '258', 'Demo/button', '按钮', '1', '1', '', '91', '1', '', '1581212447', '1581212473', '');
INSERT INTO `tp_auth_rule` VALUES ('261', '258', 'Demo/icons', '图标', '1', '1', '', '92', '1', '', '1581217423', '1581217753', '');
INSERT INTO `tp_auth_rule` VALUES ('262', '258', 'Demo/general', '常规', '1', '1', '', '93', '1', '', '1581217729', '1581217756', '');
INSERT INTO `tp_auth_rule` VALUES ('263', '258', 'Demo/modals', '模态框', '1', '1', '', '94', '1', '', '1581218146', '1581218146', '');
INSERT INTO `tp_auth_rule` VALUES ('264', '258', 'Demo/timeline', '时间轴', '1', '1', '', '95', '1', '', '1581218342', '1581218342', '');
INSERT INTO `tp_auth_rule` VALUES ('265', '258', 'Demo/layer', '弹层', '1', '1', '', '96', '1', '', '1581223849', '1581223863', '');
INSERT INTO `tp_auth_rule` VALUES ('266', '258', 'Demo/layerForm', 'layer表单', '1', '1', '', '97', '1', '', '1581297357', '1581297367', '');
INSERT INTO `tp_auth_rule` VALUES ('267', '258', 'Demo/addPost', '提交演示', '1', '0', '', '98', '0', '', '1581299002', '1581299009', '');
INSERT INTO `tp_auth_rule` VALUES ('268', '157', 'Template/index', '模板管理', '1', '1', '', '16', '1', 'fa fa-code', '1581385089', '1581385089', '');
INSERT INTO `tp_auth_rule` VALUES ('269', '268', 'Template/add', '操作-添加', '1', '0', '', '1', '1', '', '1581385125', '1581385125', '');
INSERT INTO `tp_auth_rule` VALUES ('270', '268', 'Template/addPost', '操作-添加保存', '1', '0', '', '2', '1', '', '1581385157', '1581385157', '');
INSERT INTO `tp_auth_rule` VALUES ('271', '268', 'Template/edit', '操作-修改', '1', '0', '', '3', '1', '', '1581385175', '1581385175', '');
INSERT INTO `tp_auth_rule` VALUES ('272', '268', 'Template/editPost', '操作-修改保存', '1', '0', '', '4', '1', '', '1581385230', '1581385230', '');
INSERT INTO `tp_auth_rule` VALUES ('273', '268', 'Template/del', '操作-删除', '1', '0', '', '5', '1', '', '1581385315', '1581385315', '');
INSERT INTO `tp_auth_rule` VALUES ('274', '268', 'Template/img', '媒体文件-列表', '1', '0', '', '6', '1', '', '1581385347', '1581385347', '');
INSERT INTO `tp_auth_rule` VALUES ('275', '268', 'Template/imgDel', '媒体文件-删除', '1', '0', '', '7', '1', '', '1581385377', '1581385377', '');
INSERT INTO `tp_auth_rule` VALUES ('276', '268', 'Template/selectDel', '操作-批量删除', '1', '0', '', '8', '1', '', '1583732028', '1583732057', '');
INSERT INTO `tp_auth_rule` VALUES ('277', '157', 'Plugin/index', '插件管理', '1', '1', '', '17', '1', 'fa fa-plug', '1583976240', '1583976276', '');
INSERT INTO `tp_auth_rule` VALUES ('278', '277', 'Plugin/config', '操作-配置', '1', '0', '', '1', '1', '', '1583976343', '1583976343', '');
INSERT INTO `tp_auth_rule` VALUES ('279', '277', 'Plugin/configSave', '操作-配置保存', '1', '0', '', '2', '1', '', '1583976405', '1583976405', '');
INSERT INTO `tp_auth_rule` VALUES ('280', '277', 'Plugin/state', '操作-安装/卸载', '1', '0', '', '3', '1', '', '1583976450', '1583976450', '');
INSERT INTO `tp_auth_rule` VALUES ('281', '177', 'Cate/batchAdd', '操作-批量添加', '1', '0', '', '10', '1', '', '1613634680', '1613634680', '');
INSERT INTO `tp_auth_rule` VALUES ('282', '177', 'Cate/batchAddPost', '操作-批量添加保存', '1', '0', '', '11', '1', '', '1613634757', '1613634784', '');
-- ----------------------------
-- Table structure for tp_cate
-- ----------------------------
DROP TABLE IF EXISTS `tp_cate`;
CREATE TABLE `tp_cate` (
`id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`create_time` int(11) NOT NULL,
`update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
`sort` int(8) unsigned NOT NULL DEFAULT '50' COMMENT '排序',
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
`cate_name` varchar(255) NOT NULL DEFAULT '' COMMENT '栏目名称',
`en_name` varchar(255) NOT NULL DEFAULT '' COMMENT '英文名称',
`cate_folder` varchar(255) NOT NULL DEFAULT '' COMMENT '栏目目录',
`parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级栏目',
`module_id` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '所属模块',
`url` varchar(255) NOT NULL DEFAULT '' COMMENT '外部链接',
`image` varchar(255) NOT NULL DEFAULT '' COMMENT '栏目图片',
`ico_image` varchar(255) NOT NULL DEFAULT '' COMMENT 'ICO图片',
`title` varchar(255) NOT NULL DEFAULT '' COMMENT 'SEO标题',
`keywords` varchar(255) NOT NULL DEFAULT '' COMMENT 'SEO关键字',
`description` varchar(255) NOT NULL DEFAULT '' COMMENT 'SEO描述',
`summary` text NOT NULL COMMENT '简介',
`template_list` varchar(255) NOT NULL DEFAULT '' COMMENT '列表模板',
`template_show` varchar(255) NOT NULL DEFAULT '' COMMENT '详情模版',
`page_size` char(5) NOT NULL DEFAULT '0' COMMENT '分页条数',
`is_menu` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '导航状态',
`is_next` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '跳转下级',
`is_blank` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '新窗口打开',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='栏目管理';
-- ----------------------------
-- Records of tp_cate
-- ----------------------------
INSERT INTO `tp_cate` VALUES ('1', '1580900049', '1583671301', '1', '1', '关于我们', 'About Us', 'about', '0', '18', '', '/uploads/20181224/65ea8dcb1cbd16c8dc46144069afeaf5.jpg', '', '', '', '', '', '', '', '0', '1', '0', '0');
INSERT INTO `tp_cate` VALUES ('2', '1580906596', '1580906596', '11', '1', '公司介绍', 'Company Introduction', 'introduction', '1', '18', '', '', '', '', '', '', '', '', '', '0', '1', '0', '0');
INSERT INTO `tp_cate` VALUES ('3', '1580907009', '1580907009', '12', '1', '公司文化', 'culture', 'culture', '1', '18', '', '', '', '', '', '', '', '', '', '0', '1', '0', '0');
INSERT INTO `tp_cate` VALUES ('4', '1580907057', '1580907057', '2', '1', '新闻中心', 'News Center', 'news', '0', '19', '', '/uploads/20181224/65ea8dcb1cbd16c8dc46144069afeaf5.jpg', '', '', '', '', '', '', '', '0', '1', '0', '0');
INSERT INTO `tp_cate` VALUES ('5', '1580907159', '1580907159', '21', '1', '公司新闻', '', '', '4', '19', '', '', '', '', '', '', '', '', '', '0', '1', '0', '0');
INSERT INTO `tp_cate` VALUES ('6', '1580907197', '1580907197', '22', '1', '行业资讯', 'Industry Information', 'information', '4', '19', '', '', '', '', '', '', '', '', '', '0', '1', '0', '0');
INSERT INTO `tp_cate` VALUES ('7', '1580907252', '1580907252', '3', '1', '资质荣誉', 'Qualifications & Honours', 'honours', '0', '21', '', '/uploads/20181224/bf913edfcd8dcdeeec910860f12a0542.jpg', '', '', '', '', '', '', '', '0', '1', '0', '0');
INSERT INTO `tp_cate` VALUES ('8', '1580907289', '1580907289', '4', '1', '产品中心', 'Pdoduct Center', 'product', '0', '22', '', '/uploads/20181224/643f5b9e297a0bd3accd79981ce347a1.jpg', '', '', '', '', '', '', '', '0', '1', '0', '0');
INSERT INTO `tp_cate` VALUES ('9', '1580907315', '1580907315', '41', '1', '精选产品', '', '', '8', '22', '', '', '', '', '', '', '', '', '', '0', '1', '0', '0');
INSERT INTO `tp_cate` VALUES ('10', '1580907339', '1580907339', '42', '1', '热销产品', '', '', '8', '22', '', '', '', '', '', '', '', '', '', '0', '1', '0', '0');
INSERT INTO `tp_cate` VALUES ('11', '1580907374', '1580907374', '5', '1', '资料下载', 'Download', 'download', '0', '23', '', '/uploads/20181224/f4ef6f5df6abac86e8c685b2f2549079.jpg', '', '', '', '', '', '', '', '0', '1', '0', '0');
INSERT INTO `tp_cate` VALUES ('12', '1580907407', '1580907407', '6', '1', '优秀团队', 'Team', 'team', '0', '24', '', '/uploads/20181224/bf3d6e8ff8f21760572ac25dd216daf9.jpg', '', '', '', '', '', '', '', '4', '1', '0', '0');
INSERT INTO `tp_cate` VALUES ('13', '1580907441', '1580907441', '7', '1', '联系我们', 'Contact Us', 'contact', '0', '25', '', '/uploads/20181224/65ea8dcb1cbd16c8dc46144069afeaf5.jpg', '', '', '', '', '', '', '', '0', '1', '0', '0');
-- ----------------------------
-- Table structure for tp_config
-- ----------------------------
DROP TABLE IF EXISTS `tp_config`;
CREATE TABLE `tp_config` (
`id` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '表id',
`name` varchar(50) DEFAULT NULL COMMENT '配置的key键名',
`value` varchar(512) DEFAULT NULL COMMENT '配置的val值',
`inc_type` varchar(64) DEFAULT NULL COMMENT '配置分组',
`desc` varchar(50) DEFAULT NULL COMMENT '描述',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=95 DEFAULT CHARSET=utf8 COMMENT='配置表';
-- ----------------------------
-- Records of tp_config
-- ----------------------------
INSERT INTO `tp_config` VALUES ('60', 'smtp_server', 'smtp.qq.com', 'smtp', '0');
INSERT INTO `tp_config` VALUES ('61', 'smtp_port', '465', 'smtp', '0');
INSERT INTO `tp_config` VALUES ('62', 'smtp_user', '407593529@qq.com', 'smtp', '0');
INSERT INTO `tp_config` VALUES ('63', 'smtp_pwd', '发ff', 'smtp', '0');
INSERT INTO `tp_config` VALUES ('64', 'regis_smtp_enable', '测试', 'smtp', '0');
INSERT INTO `tp_config` VALUES ('65', 'test_eamil', '123@qq.com', 'smtp', '0');
INSERT INTO `tp_config` VALUES ('88', 'email_id', 'SIYUCMS', 'smtp', '0');
INSERT INTO `tp_config` VALUES ('89', 'test_eamil_info', '<p>您好!这是一封来自SIYUCMS的测试邮件!</p>\n', 'smtp', '0');
INSERT INTO `tp_config` VALUES ('90', 'accessKeyId', 'LTAIqinwPNwEawUK', 'sms', null);
INSERT INTO `tp_config` VALUES ('91', 'accessKeySecret', '', 'sms', null);
INSERT INTO `tp_config` VALUES ('92', 'templateCode', '', 'sms', null);
INSERT INTO `tp_config` VALUES ('93', 'signName', '', 'sms', null);
INSERT INTO `tp_config` VALUES ('94', 'test_mobile', '', 'sms', null);
-- ----------------------------
-- Table structure for tp_debris
-- ----------------------------
DROP TABLE IF EXISTS `tp_debris`;
CREATE TABLE `tp_debris` (
`id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`create_time` int(11) NOT NULL,
`update_time` int(11) NOT NULL,
`sort` mediumint(8) DEFAULT '50' COMMENT '排序',
`status` tinyint(1) DEFAULT NULL COMMENT '状态',
`title` varchar(255) NOT NULL DEFAULT '' COMMENT '碎片标题',
`name` varchar(255) NOT NULL DEFAULT '' COMMENT '调用名称',
`content` text NOT NULL COMMENT '碎片内容',
`url` varchar(255) NOT NULL DEFAULT '' COMMENT '链接地址',
`image` varchar(80) NOT NULL DEFAULT '' COMMENT '图片',
`description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='碎片列表';
-- ----------------------------
-- Records of tp_debris
-- ----------------------------
INSERT INTO `tp_debris` VALUES ('1', '1580388141', '1580388225', '1', '1', '关于我们', 'AboutUs', '<p>SIYUCMS内容管理系统,包含系统设置,权限管理,模型管理,数据库管理,栏目管理,会员管理,网站功能,模版管理,微信管理等相关模块。<br />\nSIYUCMS内容管理系统,包含系统设置,权限管理,模型管理,数据库管理,栏目管理,会员管理,网站功能,模版管理,微信管理等相关模块。&nbsp;&nbsp;</p>\n\n<p>&nbsp;</p>\n', '', '', '首页调用');
-- ----------------------------
-- Table structure for tp_dictionary
-- ----------------------------
DROP TABLE IF EXISTS `tp_dictionary`;
CREATE TABLE `tp_dictionary` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`dict_label` varchar(100) NOT NULL DEFAULT '' COMMENT '字典标签',
`dict_value` varchar(255) NOT NULL DEFAULT '' COMMENT '字典键值',
`dict_type` char(5) NOT NULL DEFAULT '' COMMENT '字典类型',
`remark` varchar(200) NOT NULL DEFAULT '' COMMENT '备注',
`create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
`update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
`sort` int(5) unsigned NOT NULL DEFAULT '50' COMMENT '排序',
`status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tp_dictionary
-- ----------------------------
INSERT INTO `tp_dictionary` VALUES ('1', '显示', '1', '1', '显示', '1579227398', '1579484762', '1', '1');
INSERT INTO `tp_dictionary` VALUES ('2', '隐藏', '0', '1', '隐藏', '1579227507', '1579484767', '2', '1');
INSERT INTO `tp_dictionary` VALUES ('3', '是', '1', '2', '是', '1579227536', '1579227536', '1', '1');
INSERT INTO `tp_dictionary` VALUES ('4', '否', '0', '2', '否', '1579227552', '1579488433', '2', '1');
INSERT INTO `tp_dictionary` VALUES ('5', 'CMS', '1', '3', 'CMS', '1579490699', '1579490699', '1', '1');
INSERT INTO `tp_dictionary` VALUES ('6', '后台', '2', '3', '后台', '1579490732', '1579490732', '2', '1');
INSERT INTO `tp_dictionary` VALUES ('7', '保密', '0', '4', '', '1579586378', '1579586378', '1', '1');
INSERT INTO `tp_dictionary` VALUES ('8', '男', '1', '4', '', '1579586392', '1579586392', '1', '1');
INSERT INTO `tp_dictionary` VALUES ('9', '女', '2', '4', '', '1579586406', '1579586406', '2', '1');
INSERT INTO `tp_dictionary` VALUES ('10', '已验证', '1', '5', '', '1579587175', '1579587175', '1', '1');
INSERT INTO `tp_dictionary` VALUES ('11', '未验证', '0', '5', '', '1579587190', '1579587190', '2', '1');
INSERT INTO `tp_dictionary` VALUES ('12', '新增', 'add', '6', '新增按钮', '1580442656', '1580442656', '1', '1');
INSERT INTO `tp_dictionary` VALUES ('13', '修改', 'edit', '6', '修改按钮', '1580442715', '1580442715', '2', '1');
INSERT INTO `tp_dictionary` VALUES ('14', '删除', 'del', '6', '批量删除按钮', '1580442742', '1580442742', '3', '1');
INSERT INTO `tp_dictionary` VALUES ('15', '导出', 'export', '6', '导出按钮', '1580442770', '1580442770', '4', '1');
INSERT INTO `tp_dictionary` VALUES ('16', '修改', 'edit', '7', '修改按钮', '1580444389', '1585894146', '2', '1');
INSERT INTO `tp_dictionary` VALUES ('17', '删除', 'delete', '7', '删除按钮', '1580444406', '1585894149', '3', '1');
INSERT INTO `tp_dictionary` VALUES ('18', '开启', '1', '8', '开启', '1580559235', '1580559235', '1', '1');
INSERT INTO `tp_dictionary` VALUES ('19', '关闭', '0', '8', '关闭', '1580559262', '1580559262', '2', '1');
INSERT INTO `tp_dictionary` VALUES ('20', '字段本身', '0', '9', '字段本身', '1580793928', '1580793928', '1', '1');
INSERT INTO `tp_dictionary` VALUES ('21', '系统字典', '1', '9', '系统字典', '1580793956', '1580793956', '2', '1');
INSERT INTO `tp_dictionary` VALUES ('22', '模型数据', '2', '9', '模型数据', '1580793975', '1580793975', '3', '1');
INSERT INTO `tp_dictionary` VALUES ('23', '国内', '1', '10', '', '1584510855', '1584510855', '1', '1');
INSERT INTO `tp_dictionary` VALUES ('24', '国外', '2', '10', '', '1584510871', '1584510871', '2', '1');
INSERT INTO `tp_dictionary` VALUES ('25', '预览', 'preview', '7', '预览按钮', '1585894123', '1585894136', '1', '1');
INSERT INTO `tp_dictionary` VALUES ('26', '本地上传', '1', '11', '本地上传', '1586855924', '1586855935', '1', '1');
INSERT INTO `tp_dictionary` VALUES ('27', 'CKEditor', '0', '12', 'CKEditor', '1612507944', '1612508054', '1', '1');
-- ----------------------------
-- Table structure for tp_dictionary_type
-- ----------------------------
DROP TABLE IF EXISTS `tp_dictionary_type`;
CREATE TABLE `tp_dictionary_type` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`dict_name` char(100) NOT NULL DEFAULT '' COMMENT '字典名称',
`status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
`create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
`update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
`remark` varchar(200) NOT NULL DEFAULT '' COMMENT '备注',
`sort` int(5) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tp_dictionary_type
-- ----------------------------
INSERT INTO `tp_dictionary_type` VALUES ('1', '显示状态', '1', '1579167978', '1579167978', '1 显示, 0 隐藏', '1');
INSERT INTO `tp_dictionary_type` VALUES ('2', '系统是否', '1', '1579168087', '1579168087', '1 是, 0 否', '2');
INSERT INTO `tp_dictionary_type` VALUES ('3', '表类型', '1', '1579168087', '1581165223', '1 CMS,2 后台', '7');
INSERT INTO `tp_dictionary_type` VALUES ('4', '性别', '1', '1579586355', '1581165215', '0 保密,1 男,2 女', '9');
INSERT INTO `tp_dictionary_type` VALUES ('5', '验证状态', '1', '1579587122', '1581165094', '1 已验证, 0 未验证 ', '4');
INSERT INTO `tp_dictionary_type` VALUES ('6', '顶部按钮', '1', '1580442606', '1581165100', '列表页顶部按钮组', '5');
INSERT INTO `tp_dictionary_type` VALUES ('7', '右侧按钮', '1', '1580444354', '1581165102', '列表页右侧按钮组', '6');
INSERT INTO `tp_dictionary_type` VALUES ('8', '开关状态', '1', '1580559205', '1581165084', '1 开启, 0 关闭 ', '3');
INSERT INTO `tp_dictionary_type` VALUES ('9', '数据源', '1', '1580793811', '1581165226', '0 字段本身,1 系统字典, 2 模型数据', '8');
INSERT INTO `tp_dictionary_type` VALUES ('10', '所属地区', '1', '1584510809', '1584510822', '', '10');
INSERT INTO `tp_dictionary_type` VALUES ('11', '上传驱动', '1', '1586855872', '1586855880', '上传驱动', '11');
INSERT INTO `tp_dictionary_type` VALUES ('12', '编辑器', '1', '1612507874', '1612508175', '编辑器', '12');
-- ----------------------------
-- Table structure for tp_download
-- ----------------------------
DROP TABLE IF EXISTS `tp_download`;
CREATE TABLE `tp_download` (
`id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`create_time` int(11) NOT NULL,
`update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
`sort` mediumint(8) DEFAULT '50' COMMENT '排序',
`status` tinyint(1) DEFAULT NULL COMMENT '状态',
`cate_id` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '栏目',
`title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
`author` varchar(255) NOT NULL DEFAULT '' COMMENT '作者',
`source` varchar(255) NOT NULL DEFAULT '' COMMENT '来源',
`content` text NOT NULL COMMENT '内容',
`summary` text NOT NULL COMMENT '摘要',
`image` varchar(80) NOT NULL DEFAULT '' COMMENT '图片',
`images` text COMMENT '图片集',
`download` varchar(80) NOT NULL DEFAULT '' COMMENT '文件下载',
`tags` varchar(255) NOT NULL DEFAULT '' COMMENT 'TAG',
`hits` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点击次数',
`keywords` varchar(255) NOT NULL DEFAULT '' COMMENT '关键词',
`description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
`template` varchar(30) NOT NULL DEFAULT '' COMMENT '模板',
`url` varchar(255) NOT NULL DEFAULT '' COMMENT '跳转地址',
`view_auth` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '阅读权限',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='下载模块';
-- ----------------------------
-- Records of tp_download
-- ----------------------------
INSERT INTO `tp_download` VALUES ('1', '1581079500', '1581079500', '50', '1', '11', '招聘表格下载', '管理员', '本站', '', '', '/uploads/20181224/6b449574a2358edd20c10f10f64bd09c.jpg', '', '/uploads/20181224/06d08f008e54d9ac4eae3d0a6d53cff7.rar', '', '0', '', '', '', '', '0');
INSERT INTO `tp_download` VALUES ('2', '1581079531', '1581079531', '50', '1', '11', '报名表格下载', '管理员', '本站', '', '', '/uploads/20181224/d6df5528408d8974777ae29280428ad6.jpg', '', '/uploads/20181224/4d3569541beb373334582df5aaaa126b.rar', '', '0', '', '', '', '', '0');
INSERT INTO `tp_download` VALUES ('3', '1581079561', '1581079561', '50', '1', '11', '供应商表格下载', '管理员', '本站', '', '', '/uploads/20181224/363944f333897882e4424bacb186e693.jpg', '', '/uploads/20181224/d21fb51f503d487d67a4c8c10577c458.rar', '', '0', '', '', '', '', '0');
-- ----------------------------
-- Table structure for tp_field
-- ----------------------------
DROP TABLE IF EXISTS `tp_field`;
CREATE TABLE `tp_field` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`module_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '所属模块',
`field` varchar(100) NOT NULL DEFAULT '' COMMENT '字段名',
`name` varchar(100) NOT NULL DEFAULT '' COMMENT '字段别名',
`tips` varchar(200) NOT NULL DEFAULT '' COMMENT '提示信息',
`required` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否必填',
`minlength` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最小长度',
`maxlength` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最大长度',
`type` varchar(20) NOT NULL DEFAULT '' COMMENT '字段类型',
`data_source` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '数据源',
`relation_model` varchar(100) NOT NULL DEFAULT '' COMMENT '模型关联',
`relation_field` varchar(100) NOT NULL DEFAULT '' COMMENT '展示字段',
`dict_code` varchar(100) NOT NULL DEFAULT '' COMMENT '字典类型',
`is_add` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否可插入',
`is_edit` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否可编辑',
`is_list` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否可列表展示',
`is_search` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否可查询',
`is_sort` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否可排序',
`search_type` varchar(100) NOT NULL DEFAULT '' COMMENT '查询类型',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`sort` int(10) unsigned NOT NULL DEFAULT '0',
`remark` varchar(200) NOT NULL DEFAULT '' COMMENT '备注',
`setup` text COMMENT '其他设置',
`group_id` char(8) NOT NULL DEFAULT '0' COMMENT '字段分组',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=356 DEFAULT CHARSET=utf8 COMMENT='模型字段表';
-- ----------------------------
-- Records of tp_field
-- ----------------------------
INSERT INTO `tp_field` VALUES ('1', '2', 'id', '编号', '', '0', '0', '0', 'hidden', '0', '', '', '', '0', '0', '1', '0', '0', '=', '1', '1', '自增ID', 'array (\r\n \'default\' => \'0\',\r\n \'extra_attr\' => \'\',\r\n \'extra_class\' => \'\',\r\n \'step\' => \'1\',\r\n \'fieldtype\' => \'int\',\r\n \'group\' => \'\',\r\n)', '0');
INSERT INTO `tp_field` VALUES ('2', '1', 'email', '邮箱', '', '1', '0', '100', 'text', '0', '', '', '', '1', '0', '1', '1', '0', '=', '1', '2', '邮箱', 'array (\n \'default\' => \'\',\n \'extra_attr\' => \'\',\n \'extra_class\' => \'\',\n \'placeholder\' => \'\',\n \'fieldtype\' => \'varchar\',\n \'group\' => \'\',\n)', '0');
INSERT INTO `tp_field` VALUES ('4', '3', 'id', '编号', '', '0', '0', '0', 'hidden', '0', '', '', '', '0', '0', '1', '0', '0', '=', '1', '1', '自增ID', 'array (\n \'default\' => \'0\',\n \'extra_attr\' => \'\',\n \'extra_class\' => \'\',\n \'fieldtype\' => \'int\',\n)', '');
INSERT INTO `tp_field` VALUES ('6', '4', 'id', '编号', '', '0', '0', '0', 'hidden', '0', '', '', '', '0', '0', '1', '1', '0', '=', '1', '1', '自增ID', 'array (\r\n \'default\' => \'0\',\r\n \'extra_attr\' => \'\',\r\n \'extra_class\' => \'\',\r\n \'step\' => \'1\',\r\n \'fieldtype\' => \'int\',\r\n \'group\' => \'\',\r\n)', '0');
INSERT INTO `tp_field` VALUES ('7', '4', 'dict_name', '字典名称', '', '1', '0', '100', 'text', '0', '', '', '', '1', '1', '1', '1', '0', '=', '1', '2', '', 'array (\n \'default\' => \'\',\n \'extra_attr\' => \'\',\n \'extra_class\' => \'\',\n \'placeholder\' => \'\',\n \'fieldtype\' => \'char\',\n \'group\' => \'\',\n)', '0');
INSERT INTO `tp_field` VALUES ('9', '4', 'status', '状态', '', '1', '0', '0', 'radio', '1', '', '', '2', '1', '1', '1', '1', '0', '=', '1', '3', '', 'array (\n \'default\' => \'0\',\n \'extra_attr\' => \'\',\n \'extra_class\' => \'\',\n \'fieldtype\' => \'tinyint\',\n)', '0');
INSERT INTO `tp_field` VALUES ('10', '4', 'create_time', '创建时间', '', '0', '0', '11', 'datetime', '0', '', '', '', '0', '0', '1', '0', '0', '=', '1', '5', '', 'array (\n \'default\' => \'0\',\n \'format\' => \'Y-m-d H:i:s\',\n \'extra_attr\' => \'\',\n \'extra_class\' => \'\',\n \'placeholder\' => \'\',\n \'fieldtype\' => \'int\',\n)', '0');
INSERT INTO `tp_field` VALUES ('11', '4', 'update_time', '更新时间', '', '0', '0', '11', 'datetime', '0', '', '', '', '0', '0', '1', '0', '0', '=', '1', '6', '', 'array (\n \'default\' => \'0\',\n \'format\' => \'Y-m-d H:i:s\',\n \'extra_attr\' => \'\',\n \'extra_class\' => \'\',\n \'placeholder\' => \'\',\n \'fieldtype\' => \'int\',\n)', '0');
INSERT INTO `tp_field` VALUES ('12', '4', 'remark', '备注', '', '0', '0', '200', 'textarea', '0', '', '', '', '1', '1', '0', '0', '0', '=', '1', '7', '', 'array (\n \'default\' => \'\',\n \'extra_attr\' => \'\',\n \'extra_class\' => \'\',\n \'placeholder\' => \'\',\n \'fieldtype\' => \'varchar\',\n)', '0');
INSERT INTO `tp_field` VALUES ('13', '5', 'dict_label', '字典标签', '通常用做展示,如:男,女', '1', '0', '100', 'text', '0', '', '', '', '1', '1', '1', '1', '0', '=', '1', '1', '', 'array (\n \'default\' => \'\',\n \'extra_attr\' => \'\',\n \'extra_class\' => \'\',\n \'placeholder\' => \'\',\n \'fieldtype\' => \'varchar\',\n \'group\' => \'\',\n)', '0');
INSERT INTO `tp_field` VALUES ('14', '5', 'dict_value', '字典键值', '通常用做键值,如:0,1', '1', '0', '0', 'text', '0', '', '', '', '1', '1', '1', '1', '1', '='