-- Online Database Management SQL Dump
-- 数据库名: sql1240
-- 生成日期: 2022-02-20 17:43:22
-- PHP 版本: 5.6.40


-- --------------------------------------------------------

--
-- 数据库名 `sql1240`
--

CREATE DATABASE IF NOT EXISTS `sql1240` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `sql1240`;

-- --------------------------------------------------------

--
-- 表的结构 `ay_area`
--

CREATE TABLE `ay_area` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '区域编号',
  `acode` varchar(20) NOT NULL COMMENT '区域编码',
  `pcode` varchar(20) NOT NULL COMMENT '区域父编码',
  `name` varchar(50) NOT NULL COMMENT '区域名称',
  `domain` varchar(100) NOT NULL COMMENT '区域绑定域名',
  `is_default` char(1) NOT NULL DEFAULT '0' COMMENT '是否默认',
  `create_user` varchar(30) NOT NULL COMMENT '添加人员',
  `update_user` varchar(30) NOT NULL COMMENT '更新人员',
  `create_time` datetime NOT NULL COMMENT '添加时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ay_area_acode` (`acode`),
  KEY `ay_area_pcode` (`pcode`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_area`
--

INSERT INTO `ay_area` (`id`,`acode`,`pcode`,`name`,`domain`,`is_default`,`create_user`,`update_user`,`create_time`,`update_time`) VALUES
('1','cn','0','中文','','1','admin','admin','2017-11-30 13:55:37','2018-04-13 11:40:49');

-- --------------------------------------------------------

--
-- 表的结构 `ay_company`
--

CREATE TABLE `ay_company` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '站点编号',
  `acode` varchar(20) NOT NULL COMMENT '区域代码',
  `name` varchar(100) NOT NULL COMMENT '公司名称',
  `address` varchar(200) NOT NULL COMMENT '公司地址',
  `postcode` varchar(6) NOT NULL COMMENT '邮政编码',
  `contact` varchar(10) NOT NULL COMMENT '公司联系人',
  `mobile` varchar(50) NOT NULL COMMENT '手机号码',
  `phone` varchar(50) NOT NULL COMMENT '电话号码',
  `fax` varchar(50) NOT NULL COMMENT '公司传真',
  `email` varchar(30) NOT NULL COMMENT '电子邮箱',
  `qq` varchar(50) NOT NULL COMMENT '公司QQ',
  `weixin` varchar(100) NOT NULL COMMENT '微信图标',
  `blicense` varchar(20) NOT NULL COMMENT '营业执照代码',
  `other` varchar(200) NOT NULL COMMENT '其他信息',
  PRIMARY KEY (`id`),
  KEY `ay_company_acode` (`acode`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_company`
--

INSERT INTO `ay_company` (`id`,`acode`,`name`,`address`,`postcode`,`contact`,`mobile`,`phone`,`fax`,`email`,`qq`,`weixin`,`blicense`,`other`) VALUES
('1','cn','湖南某某网络科技有限公司','湖南长沙岳麓区雷锋大道888号','410000','谢先生','13988886666','0731-88886666','0731-88886666','admin@pbootcms.com','88886666','/static/upload/image/20180715/1531651052464521.png','91430102567888888G','');

-- --------------------------------------------------------

--
-- 表的结构 `ay_config`
--

CREATE TABLE `ay_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `name` varchar(30) NOT NULL COMMENT '名称',
  `value` varchar(200) NOT NULL COMMENT '值',
  `type` char(1) NOT NULL DEFAULT '1' COMMENT '配置类型',
  `sorting` int(10) unsigned NOT NULL DEFAULT '255' COMMENT '排序',
  `description` varchar(30) NOT NULL COMMENT '描述文本',
  PRIMARY KEY (`id`),
  KEY `ay_config_name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_config`
--

INSERT INTO `ay_config` (`id`,`name`,`value`,`type`,`sorting`,`description`) VALUES
('1','open_wap','0','1','255','手机版'),
('2','message_check_code','1','1','255','留言验证码'),
('3','smtp_server','smtp.qq.com','2','255','邮件SMTP服务器'),
('4','smtp_port','465','2','255','邮件SMTP端口'),
('5','smtp_ssl','1','1','255','邮件是否安全连接'),
('6','smtp_username','','2','255','邮件发送账号'),
('7','smtp_password','','2','255','邮件发送密码'),
('8','admin_check_code','1','1','255','后台验证码'),
('9','weixin_appid','','2','255','微信APPID'),
('10','weixin_secret','','2','255','微信SECRET'),
('11','message_send_mail','1','1','255','留言发送邮件开关'),
('12','message_send_to','','1','255','留言发送到邮箱'),
('13','api_open','0','2','255','API开关'),
('14','api_auth','1','2','255','API强制认证'),
('15','api_appid','','2','255','API认证用户'),
('16','api_secret','','2','255','API认证密钥'),
('17','baidu_zz_token','','2','255','百度站长密钥'),
('18','baidu_xzh_appid','','2','255','熊掌号appid'),
('19','baidu_xzh_token','','2','255','熊掌号token'),
('20','wap_domain','','2','255','手机绑定域名'),
('21','gzip','0','2','255','GZIP压缩'),
('22','content_tags_replace_num','','2','255','内容关键字替换次数'),
('23','smtp_username_test','','2','255','测试邮箱'),
('24','form_send_mail','0','2','255','表单发送邮件'),
('25','baidu_xzh_type','0','2','255','熊掌号推送类型'),
('26','watermark_open','0','2','255','水印开关'),
('27','watermark_text','PbootCMS','2','255','水印文本'),
('28','watermark_text_font','','2','255','水印文本字体'),
('29','watermark_text_size','20','2','255','水印文本字号'),
('30','watermark_text_color','100,100,100','2','255','水印文本字体颜色'),
('31','watermark_pic','/static/images/logo.png','2','255','水印图片'),
('32','watermark_position','4','2','255','水印位置'),
('33','message_verify','1','2','255','留言审核'),
('34','form_check_code','0','2','255','表单验证码'),
('35','lock_count','5','2','255','登陆锁定阈值'),
('36','lock_time','900','2','255','登录锁定时间'),
('37','url_rule_type','3','2','255','路径类型'),
('38','message_status','1','2','255','留言开关'),
('39','form_status','1','2','255','表单开关'),
('40','tpl_html_dir','html','2','255','模板HTML目录'),
('41','ip_deny','','2','255','IP黑名单'),
('42','ip_allow','','2','255','IP白名单'),
('43','close_site','0','2','255',''),
('44','close_site_note','','2','255',''),
('45','lgautosw','1','2','255',''),
('46','to_https','0','2','255',''),
('47','to_main_domain','0','2','255',''),
('48','main_domain','','2','255',''),
('49','content_keyword_replace','','2','255','');

-- --------------------------------------------------------

--
-- 表的结构 `ay_content`
--

CREATE TABLE `ay_content` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `acode` varchar(20) NOT NULL COMMENT '区域',
  `scode` varchar(20) NOT NULL COMMENT '内容栏目',
  `subscode` varchar(20) NOT NULL COMMENT '副栏目',
  `title` varchar(100) NOT NULL COMMENT '标题',
  `titlecolor` varchar(7) NOT NULL COMMENT '标题颜色',
  `subtitle` varchar(100) NOT NULL COMMENT '副标题',
  `filename` varchar(50) NOT NULL COMMENT '自定义文件名',
  `author` varchar(30) NOT NULL COMMENT '作者',
  `source` varchar(30) NOT NULL COMMENT '来源',
  `outlink` varchar(100) NOT NULL COMMENT '外链地址',
  `date` datetime NOT NULL COMMENT '发布日期',
  `ico` varchar(100) NOT NULL COMMENT '缩略图',
  `pics` varchar(1000) NOT NULL COMMENT '多图片',
  `content` mediumtext NOT NULL COMMENT '内容',
  `tags` varchar(500) NOT NULL COMMENT 'tag关键字',
  `enclosure` varchar(100) NOT NULL COMMENT '附件',
  `keywords` varchar(200) NOT NULL COMMENT '关键字',
  `description` varchar(500) NOT NULL COMMENT '描述',
  `sorting` int(10) unsigned NOT NULL DEFAULT '255' COMMENT '内容排序',
  `status` char(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `istop` char(1) NOT NULL DEFAULT '0' COMMENT '是否置顶',
  `isrecommend` char(1) NOT NULL DEFAULT '0' COMMENT '是否推荐',
  `isheadline` char(1) NOT NULL DEFAULT '0' COMMENT '是否头条',
  `visits` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '访问数',
  `likes` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点赞数',
  `oppose` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '反对数',
  `create_user` varchar(30) NOT NULL COMMENT '创建人员',
  `update_user` varchar(20) NOT NULL COMMENT '更新人员',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `gtype` char(1) NOT NULL DEFAULT '4',
  `gid` varchar(20) NOT NULL DEFAULT '',
  `gnote` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `ay_content_scode` (`scode`),
  KEY `ay_content_subscode` (`subscode`),
  KEY `ay_content_acode` (`acode`),
  KEY `ay_content_filename` (`filename`),
  KEY `ay_content_date` (`date`),
  KEY `ay_content_sorting` (`sorting`),
  KEY `ay_content_status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_content`
--

INSERT INTO `ay_content` (`id`,`acode`,`scode`,`subscode`,`title`,`titlecolor`,`subtitle`,`filename`,`author`,`source`,`outlink`,`date`,`ico`,`pics`,`content`,`tags`,`enclosure`,`keywords`,`description`,`sorting`,`status`,`istop`,`isrecommend`,`isheadline`,`visits`,`likes`,`oppose`,`create_user`,`update_user`,`create_time`,`update_time`,`gtype`,`gid`,`gnote`) VALUES
('1','cn','1','','关于我们','#333333','','','admin','本站','','2018-04-11 17:26:11','','','<p style="margin-bottom: 0px; color: rgb(102, 102, 102); font-family: &quot;Microsoft Yahei&quot;, PingFangSC-Regular, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Hiragino Sans GB&quot;, &quot;Heiti SC&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; text-align: justify; white-space: normal; background-color: rgb(255, 255, 255);">北京某某科技有限公司是一家致力于新材料技术应用的高科技公司，集销售、服务于一体。目前我们已经推向市场的各系列产品全部拥有自主知识产权，拥有数十项产品发明专利与实用新型专利、产品特征围绕无毒、无腐蚀性、高稳定性、高可靠性。</p><p style="margin-bottom: 0px; color: rgb(102, 102, 102); font-family: &quot;Microsoft Yahei&quot;, PingFangSC-Regular, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Hiragino Sans GB&quot;, &quot;Heiti SC&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; text-align: justify; white-space: normal; background-color: rgb(255, 255, 255);">我们积极响应国家创新发展号召，致力于树立民族品牌，为合作伙伴及客户提供以设备为中心、以安全为核心的多元化养护方案及产品，以新的技术、优质的产品、好的服务满足客户的需求，赢得市场的信赖。</p><p style="margin-bottom: 0px; color: rgb(102, 102, 102); font-family: &quot;Microsoft Yahei&quot;, PingFangSC-Regular, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Hiragino Sans GB&quot;, &quot;Heiti SC&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; text-align: justify; white-space: normal; background-color: rgb(255, 255, 255);">Beijing XX Technology Co., Ltd. is a high-tech company dedicated to the application of new material technology, integrating sales and service. At present, all series of products we have launched to the market have independent intellectual property rights, dozens of product invention patents and utility model patents, and the product features are non-toxic, non corrosive, high stability and high reliability.</p><p style="margin-bottom: 0px; color: rgb(102, 102, 102); font-family: &quot;Microsoft Yahei&quot;, PingFangSC-Regular, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Hiragino Sans GB&quot;, &quot;Heiti SC&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; text-align: justify; white-space: normal; background-color: rgb(255, 255, 255);">We actively respond to the call of national innovation and development, and are committed to building national brands, providing our partners and customers with diversified maintenance programs and products with equipment as the center and safety as the core, satisfying customers&#39; needs with new technology, high-quality products and good services, and winning the trust of the market.</p><p><br/></p>','','','','PbootCMS是全新内核且永久开源免费的PHP企业网站开发建设管理系统，是一套高效、简洁、 强悍的可免费商用的PHP CMS源码，能够满足各类企业网站开发建设的需要。系统采用简单到想哭的模板标签，只要懂HTML就可快速开发企业网站。官方提供了大量网站模板免费下载和使用，将致力于为广大开发者和企','255','1','0','0','0','46','0','0','admin','admin','2018-04-11 17:26:11','2021-10-26 21:05:18','4','',''),
('22','cn','8','','产品名称4','#333333','','','超级管理员','本站','','2021-10-26 20:59:26','/static/upload/image/20211026/1635253182759586.jpg','','<p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法人身份证复印件、老的代码证原件到质量技术监督局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">4、变更税务登记证（拿着税务变更通知单到税务局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">5、变更银行信息（拿着银行变更通知单基本户开户银行办理）</p><p><br/></p>','','','','1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法','255','1','0','0','0','0','0','0','admin','admin','2021-10-26 20:59:43','2021-10-26 20:59:43','4','0',''),
('37','cn','13','','变更公司法人所需提供的资料','#333333','','','超级管理员','本站','','2021-10-26 21:09:43','/static/upload/image/20211026/1635253791774088.jpg','','<p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法人身份证复印件、老的代码证原件到质量技术监督局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">4、变更税务登记证（拿着税务变更通知单到税务局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">5、变更银行信息（拿着银行变更通知单基本户开户银行办理）</p><p><br/></p>','','','','1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法','255','1','0','0','0','0','0','0','admin','admin','2021-10-26 21:10:09','2021-10-26 21:10:09','4','0',''),
('38','cn','13','','公司名称变更完成时间','#333333','','','超级管理员','本站','','2021-10-26 21:10:11','/static/upload/image/20211026/1635253837741187.jpg','','<p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">1、公司名称变更核准&nbsp;&nbsp; 二个工作日<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">2、公司营业执照变更&nbsp;&nbsp; 五个工作日<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">3、组织机构代码变更&nbsp;&nbsp; 三个工作日<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">4、国地税登记证变更&nbsp;&nbsp; 五个工作日（有时候税务局会临时通知具体时间）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>&nbsp;</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">5、开户银行信息变更&nbsp;&nbsp; 五个工作日</p><div style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">&nbsp;</div><p><br/></p>','','','','1、公司名称变更核准 二个工作日2、公司营业执照变更 五个工作日3、组织机构代码变更 三个工作日4、国地税登记证变更 五个工作日（有时候税务局会临时通知具体时间）5、开户银行信息变更 五个工作日','255','1','0','0','0','0','0','0','admin','admin','2021-10-26 21:10:39','2021-10-26 21:10:39','4','0',''),
('30','cn','16','','案例名称4','#333333','','','超级管理员','本站','','2021-10-26 21:03:59','/static/upload/image/20211026/1635253457155091.jpg','','<p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法人身份证复印件、老的代码证原件到质量技术监督局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">4、变更税务登记证（拿着税务变更通知单到税务局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">5、变更银行信息（拿着银行变更通知单基本户开户银行办理）</p><p><br/></p>','','','','1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法','255','1','0','0','0','0','0','0','admin','admin','2021-10-26 21:04:18','2021-10-26 21:04:18','4','0',''),
('31','cn','16','','案例名称1','#333333','','','超级管理员','本站','','2021-10-26 21:04:20','/static/upload/image/20211026/1635253478353532.jpg','','<p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法人身份证复印件、老的代码证原件到质量技术监督局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">4、变更税务登记证（拿着税务变更通知单到税务局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">5、变更银行信息（拿着银行变更通知单基本户开户银行办理）</p><p><br/></p>','','','','1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法','255','1','0','0','0','1','0','0','admin','admin','2021-10-26 21:04:41','2021-10-26 21:04:41','4','0',''),
('27','cn','16','','案例名称1','#333333','','','超级管理员','本站','','2021-10-26 21:02:04','/static/upload/image/20211026/1635253387601872.jpg','','<p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法人身份证复印件、老的代码证原件到质量技术监督局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">4、变更税务登记证（拿着税务变更通知单到税务局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">5、变更银行信息（拿着银行变更通知单基本户开户银行办理）</p><p><br/></p>','','','','1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法','255','1','0','0','0','0','0','0','admin','admin','2021-10-26 21:03:09','2021-10-26 21:03:09','4','0',''),
('28','cn','16','','案例名称2','#333333','','','超级管理员','本站','','2021-10-26 21:03:11','/static/upload/image/20211026/1635253410331714.jpg','','<p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法人身份证复印件、老的代码证原件到质量技术监督局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">4、变更税务登记证（拿着税务变更通知单到税务局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">5、变更银行信息（拿着银行变更通知单基本户开户银行办理）</p><p><br/></p>','','','','1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法','255','1','0','0','0','0','0','0','admin','admin','2021-10-26 21:03:32','2021-10-26 21:03:32','4','0',''),
('29','cn','16','','案例名称3','#333333','','','超级管理员','本站','','2021-10-26 21:03:33','/static/upload/image/20211026/1635253436796594.jpg','','<p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法人身份证复印件、老的代码证原件到质量技术监督局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">4、变更税务登记证（拿着税务变更通知单到税务局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">5、变更银行信息（拿着银行变更通知单基本户开户银行办理）</p><p><br/></p>','','','','1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法','255','1','0','0','0','0','0','0','admin','admin','2021-10-26 21:03:58','2021-10-26 21:03:58','4','0',''),
('36','cn','13','','这些网站建设错误正在导致优化无效','#333333','','','超级管理员','本站','','2021-10-26 21:08:59','/static/upload/image/20211026/1635253779586302.jpg','','<p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法人身份证复印件、老的代码证原件到质量技术监督局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">4、变更税务登记证（拿着税务变更通知单到税务局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">5、变更银行信息（拿着银行变更通知单基本户开户银行办理）</p><p><br/></p>','','','','1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法','255','1','0','0','0','0','0','0','admin','admin','2021-10-26 21:09:42','2021-10-26 21:09:42','4','0',''),
('9','cn','7','','域名注册服务','#333333','','','admin','本站','','2018-04-12 10:11:20','/static/upload/image/20180412/1523499435499884.png','','<p>
    &nbsp;&nbsp;&nbsp;&nbsp;<span style="font-size: 18px;">PbootCMS是全新内核且永久开源免费的PHP企业网站开发建设管理系统，是一套高效、简洁、
 强悍的可免费商用的PHP 
CMS源码，能够满足各类企业网站开发建设的需要。系统采用简单到想哭的模板标签，只要懂HTML就可快速开发企业网站。官方提供了大量网站模板免费下载和使用，将致力于为广大开发者和企业提供最佳的网站开发建设解决方案。</span>
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;1、系统采用高效、简洁、强悍的模板标签，只要懂HTML就可快速开发企业网站；
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;2、系统采用PHP语言开发，使用自主研发的高速多层开发框架及缓存技术；
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;3、系统默认采用sqlite轻型数据库，放入PHP空间即可直接使用，可选mysql等数据库，满足各类存储需求；
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;4、系统采用响应式管理后台，满足各类设备随时管理的需要；
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;5、系统支持后台在线升级，满足系统及时升级更新的需要；
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;6、系统支持内容模型、多语言、自定义表单、筛选、多条件搜索、小程序、APP等功能；
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;7、系统支持多种URL模式及模型、栏目、内容自定义地址名称，满足各类网站推广优化的需要。<br/>
</p>
<p>
    <br/>
</p>
<p>
    <strong><span style="font-size: 18px;">源码托管地址：</span></strong>
</p>
<p>
    GitHub：<a href="https://github.com/hnaoyun/PbootCMS" target="_blank">https://github.com/hnaoyun/PbootCMS</a><br/>
</p>
<p>
    Gitee：<a href="https://gitee.com/hnaoyun/PbootCMS" target="_blank" title="https://gitee.com/hnaoyun/PbootCMS">https://gitee.com/hnaoyun/PbootCMS</a>
</p>
<p>
    <strong><span style="font-size: 18px;"><br/></span></strong>
</p>
<p>
    <strong><span style="font-size: 18px;">简单到想哭的标签：</span></strong>
</p>
<pre class="brush:html;toolbar:false">1、全局标签示意：
{pboot:sitetitle} 站点标题 
{pboot:sitelogo} 站点logo
2、列表页标签示意：
{pboot:list num=10 order=date}    
    <p><a href="[list:link]">[list:title]</a></p>
{/pboot:list}
3、内容页标签示意：
{content:title} 标题
{content:subtitle}副标题
{content:author} 作者
{content:source} 来源
更多简单到想哭的标签请参考开发手册...</pre>','','','','PbootCMS是全新内核且永久开源免费的PHP企业网站开发建设管理系统，是一套高效、简洁、 强悍的可免费商用的PHP CMS源码，能够满足各类企业网站开发建设的需要。系统采用简单到想哭的模板标签，只要懂HTML就可快速开发企业网站。官方提供了大量网站模板免费下载和使用，将致力于为广大开发','255','1','0','0','0','6','0','0','admin','admin','2018-04-12 10:20:28','2019-08-05 11:20:53','4','',''),
('10','cn','6','','网站建设基础版','#333333','','','admin','本站','','2018-04-12 10:23:07','/static/upload/image/20180412/1523499813391526.jpg','','<p>
    &nbsp;&nbsp;&nbsp;&nbsp;<span style="font-size: 18px;">PbootCMS是全新内核且永久开源免费的PHP企业网站开发建设管理系统，是一套高效、简洁、
 强悍的可免费商用的PHP 
CMS源码，能够满足各类企业网站开发建设的需要。系统采用简单到想哭的模板标签，只要懂HTML就可快速开发企业网站。官方提供了大量网站模板免费下载和使用，将致力于为广大开发者和企业提供最佳的网站开发建设解决方案。</span>
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;1、系统采用高效、简洁、强悍的模板标签，只要懂HTML就可快速开发企业网站；
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;2、系统采用PHP语言开发，使用自主研发的高速多层开发框架及缓存技术；
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;3、系统默认采用sqlite轻型数据库，放入PHP空间即可直接使用，可选mysql等数据库，满足各类存储需求；
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;4、系统采用响应式管理后台，满足各类设备随时管理的需要；
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;5、系统支持后台在线升级，满足系统及时升级更新的需要；
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;6、系统支持内容模型、多语言、自定义表单、筛选、多条件搜索、小程序、APP等功能；
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;7、系统支持多种URL模式及模型、栏目、内容自定义地址名称，满足各类网站推广优化的需要。<br/>
</p>
<p>
    <br/>
</p>
<p>
    <strong><span style="font-size: 18px;">源码托管地址：</span></strong>
</p>
<p>
    GitHub：<a href="https://github.com/hnaoyun/PbootCMS" target="_blank">https://github.com/hnaoyun/PbootCMS</a><br/>
</p>
<p>
    Gitee：<a href="https://gitee.com/hnaoyun/PbootCMS" target="_blank" title="https://gitee.com/hnaoyun/PbootCMS">https://gitee.com/hnaoyun/PbootCMS</a>
</p>
<p>
    <strong><span style="font-size: 18px;"><br/></span></strong>
</p>
<p>
    <strong><span style="font-size: 18px;">简单到想哭的标签：</span></strong>
</p>
<pre class="brush:html;toolbar:false">1、全局标签示意：
{pboot:sitetitle} 站点标题 
{pboot:sitelogo} 站点logo
2、列表页标签示意：
{pboot:list num=10 order=date}    
    <p><a href="[list:link]">[list:title]</a></p>
{/pboot:list}
3、内容页标签示意：
{content:title} 标题
{content:subtitle}副标题
{content:author} 作者
{content:source} 来源
更多简单到想哭的标签请参考开发手册...</pre>','','','','PbootCMS是全新内核且永久开源免费的PHP企业网站开发建设管理系统，是一套高效、简洁、 强悍的可免费商用的PHP CMS源码，能够满足各类企业网站开发建设的需要。系统采用简单到想哭的模板标签，只要懂HTML就可快速开发企业网站。官方提供了大量网站模板免费下载和使用，将致力于为广大开发','255','1','0','0','0','2','0','0','admin','admin','2018-04-12 10:23:34','2019-08-05 11:20:42','4','',''),
('11','cn','6','','网站建设专业版','#333333','','','admin','本站','','2018-04-12 10:23:37','/static/upload/image/20180412/1523501297516241.jpg','','<p>
    &nbsp;&nbsp;&nbsp;&nbsp;<span style="font-size: 18px;">PbootCMS是全新内核且永久开源免费的PHP企业网站开发建设管理系统，是一套高效、简洁、
 强悍的可免费商用的PHP 
CMS源码，能够满足各类企业网站开发建设的需要。系统采用简单到想哭的模板标签，只要懂HTML就可快速开发企业网站。官方提供了大量网站模板免费下载和使用，将致力于为广大开发者和企业提供最佳的网站开发建设解决方案。</span>
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;1、系统采用高效、简洁、强悍的模板标签，只要懂HTML就可快速开发企业网站；
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;2、系统采用PHP语言开发，使用自主研发的高速多层开发框架及缓存技术；
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;3、系统默认采用sqlite轻型数据库，放入PHP空间即可直接使用，可选mysql等数据库，满足各类存储需求；
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;4、系统采用响应式管理后台，满足各类设备随时管理的需要；
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;5、系统支持后台在线升级，满足系统及时升级更新的需要；
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;6、系统支持内容模型、多语言、自定义表单、筛选、多条件搜索、小程序、APP等功能；
</p>
<p>
    &nbsp;&nbsp;&nbsp;&nbsp;7、系统支持多种URL模式及模型、栏目、内容自定义地址名称，满足各类网站推广优化的需要。<br/>
</p>
<p>
    <br/>
</p>
<p>
    <strong><span style="font-size: 18px;">源码托管地址：</span></strong>
</p>
<p>
    GitHub：<a href="https://github.com/hnaoyun/PbootCMS" target="_blank">https://github.com/hnaoyun/PbootCMS</a><br/>
</p>
<p>
    Gitee：<a href="https://gitee.com/hnaoyun/PbootCMS" target="_blank" title="https://gitee.com/hnaoyun/PbootCMS">https://gitee.com/hnaoyun/PbootCMS</a>
</p>
<p>
    <strong><span style="font-size: 18px;"><br/></span></strong>
</p>
<p>
    <strong><span style="font-size: 18px;">简单到想哭的标签：</span></strong>
</p>
<pre class="brush:html;toolbar:false">1、全局标签示意：
{pboot:sitetitle} 站点标题 
{pboot:sitelogo} 站点logo
2、列表页标签示意：
{pboot:list num=10 order=date}    
    <p><a href="[list:link]">[list:title]</a></p>
{/pboot:list}
3、内容页标签示意：
{content:title} 标题
{content:subtitle}副标题
{content:author} 作者
{content:source} 来源
更多简单到想哭的标签请参考开发手册...</pre>','','','','PbootCMS是全新内核且永久开源免费的PHP企业网站开发建设管理系统，是一套高效、简洁、 强悍的可免费商用的PHP CMS源码，能够满足各类企业网站开发建设的需要。系统采用简单到想哭的模板标签，只要懂HTML就可快速开发企业网站。官方提供了大量网站模板免费下载和使用，将致力于为广大开发','255','1','0','0','0','5','0','0','admin','admin','2018-04-12 10:24:01','2019-08-05 11:20:33','4','',''),
('12','cn','6','','公司简介','#333333','','','admin','本站','','2018-04-12 10:24:04','','','<p style="margin-bottom: 0px; color: rgb(102, 102, 102); font-family: &quot;Microsoft Yahei&quot;, PingFangSC-Regular, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Hiragino Sans GB&quot;, &quot;Heiti SC&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; text-align: justify; white-space: normal; background-color: rgb(255, 255, 255);">北京某某科技有限公司是一家致力于新材料技术应用的高科技公司，集销售、服务于一体。目前我们已经推向市场的各系列产品全部拥有自主知识产权，拥有数十项产品发明专利与实用新型专利、产品特征围绕无毒、无腐蚀性、高稳定性、高可靠性。</p><p style="margin-bottom: 0px; color: rgb(102, 102, 102); font-family: &quot;Microsoft Yahei&quot;, PingFangSC-Regular, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Hiragino Sans GB&quot;, &quot;Heiti SC&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; text-align: justify; white-space: normal; background-color: rgb(255, 255, 255);">我们积极响应国家创新发展号召，致力于树立民族品牌，为合作伙伴及客户提供以设备为中心、以安全为核心的多元化养护方案及产品，以新的技术、优质的产品、好的服务满足客户的需求，赢得市场的信赖。</p><p style="margin-bottom: 0px; color: rgb(102, 102, 102); font-family: &quot;Microsoft Yahei&quot;, PingFangSC-Regular, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Hiragino Sans GB&quot;, &quot;Heiti SC&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; text-align: justify; white-space: normal; background-color: rgb(255, 255, 255);">Beijing XX Technology Co., Ltd. is a high-tech company dedicated to the application of new material technology, integrating sales and service. At present, all series of products we have launched to the market have independent intellectual property rights, dozens of product invention patents and utility model patents, and the product features are non-toxic, non corrosive, high stability and high reliability.</p><p style="margin-bottom: 0px; color: rgb(102, 102, 102); font-family: &quot;Microsoft Yahei&quot;, PingFangSC-Regular, &quot;Helvetica Neue&quot;, Helvetica, Arial, &quot;Hiragino Sans GB&quot;, &quot;Heiti SC&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif; text-align: justify; white-space: normal; background-color: rgb(255, 255, 255);">We actively respond to the call of national innovation and development, and are committed to building national brands, providing our partners and customers with diversified maintenance programs and products with equipment as the center and safety as the core, satisfying customers&#39; needs with new technology, high-quality products and good services, and winning the trust of the market.</p><p><br/></p>','','','','PbootCMS是全新内核且永久开源免费的PHP企业网站开发建设管理系统，是一套高效、简洁、 强悍的可免费商用的PHP CMS源码，能够满足各类企业网站开发建设的需要。系统采用简单到想哭的模板标签，只要懂HTML就可快速开发企业网站。官方提供了大量网站模板免费下载和使用，将致力于为广大开发','255','1','0','0','0','9','0','0','admin','admin','2018-04-12 10:24:25','2021-10-26 21:05:31','4','',''),
('13','cn','7','','企业文化','#333333','','','admin','本站','','2018-04-12 10:24:52','','','<p>企业文化填写企业文化填写企业文化填写企业文化填写企业文化填写企业文化填写</p>','','','','PbootCMS是全新内核且永久开源免费的PHP企业网站开发建设管理系统，是一套高效、简洁、 强悍的可免费商用的PHP CMS源码，能够满足各类企业网站开发建设的需要。系统采用简单到想哭的模板标签，只要懂HTML就可快速开发企业网站。官方提供了大量网站模板免费下载和使用，将致力于为广大开发','255','1','0','0','0','4','0','0','admin','admin','2018-04-12 10:26:20','2021-10-26 21:06:00','4','',''),
('32','cn','19','','荣誉证书','#333333','','','超级管理员','本站','','2021-10-26 21:06:35','/static/upload/image/20211026/1635253630611192.jpg','','<p style="text-align: center;"><img src="/static/upload/image/20211026/1635253622209227.jpg" title="1635253622209227.jpg" alt="1-2102111314490-L.jpg"/></p>','','','','','255','1','0','0','0','0','0','0','admin','admin','2021-10-26 21:07:13','2021-10-26 21:07:13','4','0',''),
('33','cn','19','','荣誉证书','#333333','','','超级管理员','本站','','2021-10-26 21:07:14','/static/upload/image/20211026/1635253654612117.jpg','','<p style="text-align: center;"><img src="/static/upload/image/20211026/1635253646196013.jpg" title="1635253646196013.jpg" alt="1-2102111314490-L.jpg"/></p>','','','','','255','1','0','0','0','0','0','0','admin','admin','2021-10-26 21:07:36','2021-10-26 21:07:36','4','0',''),
('34','cn','19','','荣誉证书','#333333','','','超级管理员','本站','','2021-10-26 21:07:37','/static/upload/image/20211026/1635253674946560.jpg','','<p style="text-align: center;"><img src="/static/upload/image/20211026/1635253668886229.jpg" title="1635253668886229.jpg" alt="1-2102111314490-L.jpg"/></p>','','','','','255','1','0','0','0','0','0','0','admin','admin','2021-10-26 21:07:56','2021-10-26 21:07:56','4','0',''),
('35','cn','19','','荣誉证书','#333333','','','超级管理员','本站','','2021-10-26 21:07:57','/static/upload/image/20211026/1635253690513585.jpg','','<p style="text-align: center;"><img src="/static/upload/image/20211026/1635253685213353.jpg" title="1635253685213353.jpg" alt="1-2102111314490-L.jpg"/></p>','','','','','255','1','0','0','0','0','0','0','admin','admin','2021-10-26 21:08:12','2021-10-26 21:08:12','4','0',''),
('21','cn','8','','产品名称3','#333333','','','超级管理员','本站','','2021-10-26 20:58:59','/static/upload/image/20211026/1635253155998718.jpg','','<p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法人身份证复印件、老的代码证原件到质量技术监督局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">4、变更税务登记证（拿着税务变更通知单到税务局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">5、变更银行信息（拿着银行变更通知单基本户开户银行办理）</p><p><br/></p>','','','','1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法','255','1','0','0','0','0','0','0','admin','admin','2021-10-26 20:59:17','2021-10-26 20:59:17','4','0',''),
('19','cn','8','','产品名称1','#333333','','','超级管理员','本站','','2021-10-26 20:55:51','/static/upload/image/20211026/1635253031574912.jpg','','<p>1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p>2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p>3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法人身份证复印件、老的代码证原件到质量技术监督局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p>4、变更税务登记证（拿着税务变更通知单到税务局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p>5、变更银行信息（拿着银行变更通知单基本户开户银行办理）</p><p><br/></p>','','','','1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法','255','1','0','0','0','2','0','0','admin','admin','2021-10-26 20:58:22','2021-10-26 20:59:25','4','0',''),
('20','cn','8','','产品名称2','#333333','','','超级管理员','本站','','2021-10-26 20:58:23','/static/upload/image/20211026/1635253136991168.jpg','','<p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法人身份证复印件、老的代码证原件到质量技术监督局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">4、变更税务登记证（拿着税务变更通知单到税务局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">5、变更银行信息（拿着银行变更通知单基本户开户银行办理）</p><p><br/></p>','','','','1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法','255','1','0','0','0','0','0','0','admin','admin','2021-10-26 20:58:57','2021-10-26 20:58:57','4','0',''),
('18','cn','5','','联系我们','#333333','','','超级管理员','本站','','2021-10-26 20:22:57','','','','','','','','255','1','0','0','0','2','0','0','admin','admin','2021-10-26 20:22:57','2021-10-26 21:06:13','4','0',''),
('23','cn','8','','产品名称5','#333333','','','超级管理员','本站','','2021-10-26 20:59:45','/static/upload/image/20211026/1635253198926739.jpg','','<p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法人身份证复印件、老的代码证原件到质量技术监督局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">4、变更税务登记证（拿着税务变更通知单到税务局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">5、变更银行信息（拿着银行变更通知单基本户开户银行办理）</p><p><br/></p>','','','','1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法','255','1','0','0','0','0','0','0','admin','admin','2021-10-26 20:59:59','2021-10-26 20:59:59','4','0',''),
('24','cn','8','','产品名称6','#333333','','','超级管理员','本站','','2021-10-26 21:00:01','/static/upload/image/20211026/1635253215921266.jpg','','<p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法人身份证复印件、老的代码证原件到质量技术监督局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">4、变更税务登记证（拿着税务变更通知单到税务局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">5、变更银行信息（拿着银行变更通知单基本户开户银行办理）</p><p><br/></p>','','','','1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法','255','1','0','0','0','0','0','0','admin','admin','2021-10-26 21:00:17','2021-10-26 21:00:17','4','0',''),
('25','cn','8','','产品名称7','#333333','','','超级管理员','本站','','2021-10-26 21:00:18','/static/upload/image/20211026/1635253230442742.jpg','','<p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法人身份证复印件、老的代码证原件到质量技术监督局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">4、变更税务登记证（拿着税务变更通知单到税务局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">5、变更银行信息（拿着银行变更通知单基本户开户银行办理）</p><p><br/></p>','','','','1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法','255','1','0','0','0','0','0','0','admin','admin','2021-10-26 21:00:31','2021-10-26 21:00:31','4','0',''),
('26','cn','8','','产品名称8','#333333','','','超级管理员','本站','','2021-10-26 21:00:33','/static/upload/image/20211026/1635253244412615.jpg','','<p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法人身份证复印件、老的代码证原件到质量技术监督局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">4、变更税务登记证（拿着税务变更通知单到税务局办理）<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 0px; padding: 0px;"/>　　</p><p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin-top: 0px; margin-bottom: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft Yahei&quot;, Arial; white-space: normal; background-color: rgb(255, 255, 255);">5、变更银行信息（拿着银行变更通知单基本户开户银行办理）</p><p><br/></p>','','','','1、领取《公司变更登记申请表》（工商局办证大厅窗口领取）2、变更营业执照（填写公司变更表格，加盖公章，整理公司章程修正案、股东会决议、股权转让协议、公司营业执照正副本原件到工商局办证大厅办理）3、变更组织机构代码证（填写企业代码证变更表格，加盖公章，整理公司变更通知书、营业执照副本复印件、企业法','255','1','0','0','0','2','0','0','admin','admin','2021-10-26 21:00:46','2021-10-26 21:00:46','4','0','');

-- --------------------------------------------------------

--
-- 表的结构 `ay_content_ext`
--

CREATE TABLE `ay_content_ext` (
  `extid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `contentid` int(10) unsigned NOT NULL,
  `ext_dd` varchar(200) DEFAULT NULL COMMENT '地点',
  `ext_tm` varchar(200) DEFAULT NULL COMMENT '时间',
  `ext_sb` varchar(200) DEFAULT NULL COMMENT '设备',
  PRIMARY KEY (`extid`),
  KEY `ay_content_ext_contentid` (`contentid`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_content_ext`
--

INSERT INTO `ay_content_ext` (`extid`,`contentid`,`ext_dd`,`ext_tm`,`ext_sb`) VALUES
('1','9','','',''),
('2','10','','',''),
('3','11','','',''),
('4','12','','',''),
('5','13','','',''),
('6','27','北京','2021-10-10','设备控制台'),
('7','28','北京','2021-10-10','设备控制台'),
('8','29','北京','2021-10-10','设备控制台'),
('9','30','北京','2021-10-10','设备控制台'),
('10','31','北京','2021-10-10','设备控制台'),
('11','32','','',''),
('12','33','','',''),
('13','34','','',''),
('14','35','','','');

-- --------------------------------------------------------

--
-- 表的结构 `ay_content_sort`
--

CREATE TABLE `ay_content_sort` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `acode` varchar(20) NOT NULL COMMENT '区域编码',
  `mcode` varchar(20) NOT NULL COMMENT '内容模型编码',
  `pcode` varchar(20) NOT NULL COMMENT '父编码',
  `scode` varchar(20) NOT NULL COMMENT '分类编码',
  `name` varchar(100) NOT NULL COMMENT '分类名称',
  `listtpl` varchar(50) NOT NULL COMMENT '列表页模板',
  `contenttpl` varchar(50) NOT NULL COMMENT '内容页模板',
  `status` char(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `outlink` varchar(100) NOT NULL COMMENT '转外链接',
  `subname` varchar(200) NOT NULL COMMENT '附加名称',
  `ico` varchar(100) NOT NULL COMMENT '分类缩略图',
  `pic` varchar(100) NOT NULL COMMENT '分类大图',
  `title` varchar(100) NOT NULL COMMENT 'seo标题',
  `keywords` varchar(200) NOT NULL COMMENT '分类关键字',
  `description` varchar(500) NOT NULL COMMENT '分类描述',
  `filename` varchar(30) NOT NULL COMMENT '自定义文件名',
  `sorting` int(10) unsigned NOT NULL DEFAULT '255' COMMENT '排序',
  `create_user` varchar(30) NOT NULL COMMENT '创建人员',
  `update_user` varchar(30) NOT NULL COMMENT '更新人员',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `gtype` char(1) NOT NULL DEFAULT '4',
  `gid` varchar(20) NOT NULL DEFAULT '',
  `gnote` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ay_content_sort_scode` (`scode`),
  KEY `ay_content_sort_pcode` (`pcode`),
  KEY `ay_content_sort_acode` (`acode`),
  KEY `ay_content_sort_mcode` (`mcode`),
  KEY `ay_content_sort_filename` (`filename`),
  KEY `ay_content_sort_sorting` (`sorting`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_content_sort`
--

INSERT INTO `ay_content_sort` (`id`,`acode`,`mcode`,`pcode`,`scode`,`name`,`listtpl`,`contenttpl`,`status`,`outlink`,`subname`,`ico`,`pic`,`title`,`keywords`,`description`,`filename`,`sorting`,`create_user`,`update_user`,`create_time`,`update_time`,`gtype`,`gid`,`gnote`) VALUES
('1','cn','1','0','1','关于我们','','about.html','1','','网站建设「一站式」服务商','','','','','','aboutus','255','admin','admin','2018-04-11 17:26:11','2021-10-26 20:21:24','4','0',''),
('2','cn','3','0','2','产品服务','productlist.html','product.html','1','','了解最新公司动态及行业资讯','','','','','','cp','255','admin','admin','2018-04-11 17:26:46','2021-10-26 20:21:49','4','0',''),
('3','cn','2','0','3','新闻中心','newslist.html','news.html','1','','了解最新公司动态及行业资讯','','','','','','xinwen','255','admin','admin','2018-04-11 17:27:05','2021-10-26 20:22:11','4','0',''),
('4','cn','4','0','4','案例分析','caselist.html','case.html','1','','了解最新公司动态及行业资讯','','','','','','anli','255','admin','admin','2018-04-11 17:27:30','2021-10-26 20:22:33','4','0',''),
('5','cn','1','0','5','联系我们','','contact.html','1','','服务创造价值、存在造就未来','','','','','','lianxi','255','admin','admin','2018-04-11 17:27:54','2021-10-26 20:53:17','4','0',''),
('6','cn','1','1','6','公司简介','','about.html','1','','服务创造价值、存在造就未来','','','','','','jianjie','255','admin','admin','2018-04-11 17:28:19','2021-10-26 20:23:25','4','0',''),
('7','cn','1','1','7','企业文化','','about.html','1','','服务创造价值、存在造就未来','','','','','','wenhua','255','admin','admin','2018-04-11 17:28:38','2021-10-26 20:23:46','4','0',''),
('8','cn','3','2','8','带电清洗系列','productlist.html','product.html','1','','服务创造价值、存在造就未来','','','','','','ddwx','255','admin','admin','2018-04-11 17:29:16','2021-10-26 20:24:17','4','0',''),
('9','cn','3','2','9','带电保护系列','productlist.html','product.html','1','','诚聘优秀人士加入我们的团队','','','','','','ddbh','255','admin','admin','2018-04-11 17:30:02','2021-10-26 20:24:36','4','0',''),
('10','cn','3','2','10','除味杀菌系列','productlist.html','product.html','1','','有什么问题欢迎您随时反馈','','','','','','cwxj','255','admin','admin','2018-04-11 17:30:36','2021-10-26 20:24:58','4','0',''),
('11','cn','3','2','11','甲醛处理系列','productlist.html','product.html','1','','能为您服务是我们的荣幸','','','','','','jqcl','255','admin','admin','2018-04-11 17:31:29','2021-10-26 20:25:17','4','0',''),
('12','cn','3','2','12','车体清洗系列','productlist.html','product.html','1','','','','','','','','ctqx','255','admin','admin','2021-10-26 20:25:38','2021-10-26 20:25:38','4','0',''),
('13','cn','2','3','13','公司新闻','newslist.html','news.html','1','','','','','','','','gongsi','255','admin','admin','2021-10-26 20:25:57','2021-10-26 20:25:57','4','0',''),
('14','cn','2','3','14','行业资讯','newslist.html','news.html','1','','','','','','','','hangye','255','admin','admin','2021-10-26 20:26:14','2021-10-26 20:26:14','4','0',''),
('15','cn','2','3','15','常见问题','newslist.html','news.html','1','','','','','','','','wenti','255','admin','admin','2021-10-26 20:26:31','2021-10-26 20:26:31','4','0',''),
('16','cn','4','4','16','通讯行业','caselist.html','case.html','1','','','','','','','','txhy','255','admin','admin','2021-10-26 20:26:55','2021-10-26 20:26:55','4','0',''),
('17','cn','4','4','17','IT行业','caselist.html','case.html','1','','','','','','','','it','255','admin','admin','2021-10-26 20:27:11','2021-10-26 20:27:11','4','0',''),
('18','cn','4','4','18','工业园及高校','caselist.html','case.html','1','','','','','','','','gyy','255','admin','admin','2021-10-26 20:27:26','2021-10-26 20:27:26','4','0',''),
('19','cn','4','1','19','荣誉资质','caselist.html','case.html','1','','','','','','','','rongyu','255','admin','admin','2021-10-26 20:49:56','2021-10-26 20:49:56','4','0','');

-- --------------------------------------------------------

--
-- 表的结构 `ay_diy_telephone`
--

CREATE TABLE `ay_diy_telephone` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `tel` varchar(20) DEFAULT NULL COMMENT '电话号码',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `ay_extfield`
--

CREATE TABLE `ay_extfield` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `mcode` varchar(20) NOT NULL COMMENT '模型编码',
  `name` varchar(30) NOT NULL COMMENT '字段名称',
  `type` char(1) NOT NULL COMMENT '字段类型',
  `value` varchar(500) NOT NULL COMMENT '单选或多选值',
  `description` varchar(30) NOT NULL COMMENT '描述文本',
  `sorting` int(11) NOT NULL COMMENT '排序',
  PRIMARY KEY (`id`),
  KEY `ay_extfield_mcode` (`mcode`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_extfield`
--

INSERT INTO `ay_extfield` (`id`,`mcode`,`name`,`type`,`value`,`description`,`sorting`) VALUES
('4','4','ext_dd','1','','地点','255'),
('5','4','ext_tm','1','','时间','255'),
('6','4','ext_sb','1','','设备','255');

-- --------------------------------------------------------

--
-- 表的结构 `ay_form`
--

CREATE TABLE `ay_form` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `fcode` varchar(20) NOT NULL COMMENT '表单编码',
  `form_name` varchar(30) NOT NULL COMMENT '表单名称',
  `table_name` varchar(30) NOT NULL COMMENT '表名称',
  `create_user` varchar(30) NOT NULL COMMENT '添加人员',
  `update_user` varchar(30) NOT NULL COMMENT '更新人员',
  `create_time` datetime NOT NULL COMMENT '添加时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ay_form_fcode` (`fcode`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_form`
--

INSERT INTO `ay_form` (`id`,`fcode`,`form_name`,`table_name`,`create_user`,`update_user`,`create_time`,`update_time`) VALUES
('1','1','在线留言','ay_message','admin','admin','2018-04-11 17:31:29','2018-04-11 17:31:29'),
('2','2','搜集电话','ay_diy_telephone','admin','admin','2018-11-30 15:17:40','2018-11-30 15:17:40');

-- --------------------------------------------------------

--
-- 表的结构 `ay_form_field`
--

CREATE TABLE `ay_form_field` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `fcode` varchar(20) NOT NULL COMMENT '表单编码',
  `name` varchar(30) NOT NULL COMMENT '字段名称',
  `length` int(10) unsigned NOT NULL COMMENT '字段长度',
  `required` char(1) NOT NULL DEFAULT '0' COMMENT '是否必填',
  `description` varchar(30) NOT NULL COMMENT '描述文本',
  `sorting` int(10) unsigned NOT NULL DEFAULT '255' COMMENT '排序',
  `create_user` varchar(30) NOT NULL COMMENT '添加人员',
  `update_user` varchar(30) NOT NULL COMMENT '更新人员',
  `create_time` datetime NOT NULL COMMENT '添加时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `ay_form_field_fcode` (`fcode`),
  KEY `ay_form_field_sorting` (`sorting`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_form_field`
--

INSERT INTO `ay_form_field` (`id`,`fcode`,`name`,`length`,`required`,`description`,`sorting`,`create_user`,`update_user`,`create_time`,`update_time`) VALUES
('1','1','contacts','10','1','联系人','255','admin','admin','2018-07-14 18:24:02','2018-07-15 17:47:43'),
('2','1','mobile','12','1','手机','255','admin','admin','2018-07-14 18:24:02','2018-07-15 17:47:44'),
('3','1','content','500','1','内容','255','admin','admin','2018-07-14 18:24:02','2018-07-15 17:47:45'),
('4','2','tel','20','1','电话号码','255','admin','admin','2018-11-30 15:18:00','2018-11-30 15:18:00');

-- --------------------------------------------------------

--
-- 表的结构 `ay_label`
--

CREATE TABLE `ay_label` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `name` varchar(100) NOT NULL COMMENT '名称',
  `value` varchar(500) NOT NULL COMMENT '值',
  `type` char(1) NOT NULL DEFAULT '1' COMMENT '字段类型',
  `description` varchar(30) NOT NULL COMMENT '描述',
  `create_user` varchar(30) NOT NULL COMMENT '创建人员',
  `update_user` varchar(20) NOT NULL COMMENT '更新人员',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_label`
--

INSERT INTO `ay_label` (`id`,`name`,`value`,`type`,`description`,`create_user`,`update_user`,`create_time`,`update_time`) VALUES
('1','downlink','https://gitee.com/hnaoyun/PbootCMS/releases','1','下载地址','admin','admin','2018-04-11 16:52:19','2021-10-26 20:50:58'),
('2','f_logo','/static/upload/image/20211026/1635252452773701.png','3','底部logo','admin','admin','2021-10-26 20:47:16','2021-10-26 20:50:58'),
('3','yw','北京某某科技有限公司是一家致力于新材料技术应用的高科技公司，集销售、服务于一体。我们的业务不仅基本覆盖全国各省（包括台湾地区），而且已经开展了韩国、马来西亚等国国际市场的业务。','7','业务分布','admin','admin','2021-10-26 20:50:46','2021-10-26 20:50:58');

-- --------------------------------------------------------

--
-- 表的结构 `ay_link`
--

CREATE TABLE `ay_link` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '序号',
  `acode` varchar(20) NOT NULL COMMENT '区域编码',
  `gid` int(10) unsigned NOT NULL COMMENT '分组序号',
  `name` varchar(50) NOT NULL COMMENT '链接名称',
  `link` varchar(100) NOT NULL COMMENT '跳转链接',
  `logo` varchar(100) NOT NULL COMMENT '图片地址',
  `sorting` int(11) NOT NULL COMMENT '排序',
  `create_user` varchar(30) NOT NULL COMMENT '创建人员',
  `update_user` varchar(30) NOT NULL COMMENT '更新人员',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `ay_link_acode` (`acode`),
  KEY `ay_link_gid` (`gid`),
  KEY `ay_link_sorting` (`sorting`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_link`
--

INSERT INTO `ay_link` (`id`,`acode`,`gid`,`name`,`link`,`logo`,`sorting`,`create_user`,`update_user`,`create_time`,`update_time`) VALUES
('1','cn','1','PbootCMS','https://www.pbootcms.com','/static/upload/image/20180412/1523501605180536.png','255','admin','admin','2018-04-12 10:53:06','2018-04-12 10:53:26');

-- --------------------------------------------------------

--
-- 表的结构 `ay_member_comment`
--

CREATE TABLE `ay_member_comment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) unsigned NOT NULL DEFAULT '0',
  `contentid` int(10) unsigned NOT NULL,
  `comment` varchar(1000) NOT NULL,
  `uid` int(10) unsigned NOT NULL,
  `puid` int(10) unsigned NOT NULL,
  `likes` int(10) unsigned NOT NULL DEFAULT '0',
  `oppose` int(10) unsigned NOT NULL DEFAULT '0',
  `status` char(1) NOT NULL,
  `user_ip` varchar(11) NOT NULL,
  `user_os` varchar(30) NOT NULL,
  `user_bs` varchar(30) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_user` varchar(30) NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ay_member_comment_pid` (`pid`),
  KEY `ay_member_comment_contentid` (`contentid`),
  KEY `ay_member_comment_uid` (`uid`),
  KEY `ay_member_comment_puid` (`puid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `ay_member_field`
--

CREATE TABLE `ay_member_field` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `length` int(10) unsigned NOT NULL,
  `required` char(1) NOT NULL,
  `description` varchar(30) NOT NULL,
  `sorting` int(10) unsigned NOT NULL,
  `status` char(1) NOT NULL,
  `create_user` varchar(30) NOT NULL,
  `update_user` varchar(30) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_member_field`
--

INSERT INTO `ay_member_field` (`id`,`name`,`length`,`required`,`description`,`sorting`,`status`,`create_user`,`update_user`,`create_time`,`update_time`) VALUES
('1','sex','2','0','性别','255','1','admin','admin','2020-06-25 00:00:00','2020-06-25 00:00:00'),
('2','birthday','20','0','生日','255','1','admin','admin','2020-06-25 00:00:00','2020-06-25 00:00:00'),
('3','qq','15','0','QQ','255','1','admin','admin','2020-06-25 00:00:00','2020-06-25 00:00:00');

-- --------------------------------------------------------

--
-- 表的结构 `ay_member_group`
--

CREATE TABLE `ay_member_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gcode` varchar(20) NOT NULL,
  `gname` varchar(100) NOT NULL,
  `description` varchar(200) NOT NULL,
  `status` varchar(1) NOT NULL,
  `lscore` int(10) unsigned NOT NULL DEFAULT '0',
  `uscore` int(10) unsigned NOT NULL DEFAULT '0',
  `create_user` varchar(30) NOT NULL,
  `update_user` varchar(30) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ay_member_group_gcode` (`gcode`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_member_group`
--

INSERT INTO `ay_member_group` (`id`,`gcode`,`gname`,`description`,`status`,`lscore`,`uscore`,`create_user`,`update_user`,`create_time`,`update_time`) VALUES
('1','1','初级会员','初级会员具备基本的权限','1','0','999','admin','admin','2020-06-25 00:00:00','2020-06-25 00:00:00'),
('2','2','中级会员','中级会员具备部分特殊权限','1','1000','9999','admin','admin','2020-06-25 00:00:00','2020-06-25 00:00:00'),
('3','3','高级会员','高级会员具备全部特殊权限','1','10000','4294967295','admin','admin','2020-06-25 00:00:00','2020-06-25 00:00:00');

-- --------------------------------------------------------

--
-- 表的结构 `ay_menu`
--

CREATE TABLE `ay_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '菜单编号',
  `mcode` varchar(20) NOT NULL COMMENT '菜单编码',
  `pcode` varchar(20) NOT NULL COMMENT '上级菜单',
  `name` varchar(50) NOT NULL COMMENT '菜单名称',
  `url` varchar(100) NOT NULL COMMENT '菜单地址',
  `sorting` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '菜单排序',
  `status` char(1) NOT NULL DEFAULT '1' COMMENT '是否启用',
  `shortcut` char(1) NOT NULL DEFAULT '0' COMMENT '桌面图标',
  `ico` varchar(30) NOT NULL COMMENT '菜单图标',
  `create_user` varchar(30) NOT NULL COMMENT '创建人员',
  `update_user` varchar(30) NOT NULL COMMENT '更新人员',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ay_menu_mcode` (`mcode`),
  KEY `ay_menu_pcode` (`pcode`),
  KEY `ay_menu_sorting` (`sorting`)
) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_menu`
--

INSERT INTO `ay_menu` (`id`,`mcode`,`pcode`,`name`,`url`,`sorting`,`status`,`shortcut`,`ico`,`create_user`,`update_user`,`create_time`,`update_time`) VALUES
('1','M101','0','系统管理','/admin/M101/index','900','1','0','fa-cog','admin','admin','0000-00-00 00:00:00','2018-04-30 14:52:57'),
('2','M102','M101','数据区域','/admin/Area/index','901','1','1','fa-sitemap','admin','admin','0000-00-00 00:00:00','2018-04-30 14:54:23'),
('3','M103','M101','系统菜单','/admin/Menu/index','902','0','0','fa-bars','admin','admin','0000-00-00 00:00:00','2018-04-30 14:54:35'),
('4','M104','M101','系统角色','/admin/Role/index','903','1','1','fa-hand-stop-o','admin','admin','0000-00-00 00:00:00','2018-04-30 14:54:43'),
('5','M105','M101','系统用户','/admin/User/index','904','1','1','fa-users','admin','admin','0000-00-00 00:00:00','2018-04-30 14:54:51'),
('6','M106','M101','系统日志','/admin/Syslog/index','905','1','1','fa-history','admin','admin','0000-00-00 00:00:00','2018-04-30 14:55:00'),
('7','M107','M101','类型管理','/admin/Type/index','906','0','0','fa-tags','admin','admin','0000-00-00 00:00:00','2018-04-30 14:55:13'),
('8','M108','M101','数据库管理','/admin/Database/index','907','1','1','fa-database','admin','admin','0000-00-00 00:00:00','2018-04-30 14:55:24'),
('9','M109','M101','服务器信息','/admin/Site/server','908','1','1','fa-info-circle','admin','admin','0000-00-00 00:00:00','2018-04-30 14:55:34'),
('10','M110','0','基础内容','/admin/M110/index','300','1','0','fa-sliders','admin','admin','2017-11-28 11:13:05','2018-04-30 14:48:29'),
('11','M111','M110','站点信息','/admin/Site/index','301','1','1','fa-cog','admin','admin','0000-00-00 00:00:00','2018-04-07 18:45:57'),
('12','M112','M110','公司信息','/admin/Company/index','302','1','1','fa-copyright','admin','admin','0000-00-00 00:00:00','2018-04-07 18:46:09'),
('29','M129','M110','内容栏目','/admin/ContentSort/index','303','1','1','fa-bars','admin','admin','2017-12-26 10:42:40','2018-04-07 18:46:25'),
('30','M130','0','文章内容','/admin/M130/index','400','1','0','fa-file-text-o','admin','admin','2017-12-26 10:45:36','2018-04-30 14:49:47'),
('31','M131','M130','单页内容','/admin/Single/index','401','0','0','fa-file-o','admin','admin','2017-12-26 10:46:35','2018-04-07 18:46:35'),
('32','M132','M130','列表内容','/admin/Content/index','402','0','0','fa-file-text-o','admin','admin','2017-12-26 10:48:17','2018-04-07 21:52:15'),
('36','M136','M156','定制标签','/admin/Label/index','203','1','1','fa-wrench','admin','admin','2018-01-03 11:52:40','2018-04-07 18:44:31'),
('50','M150','M157','留言信息','/admin/Message/index','501','1','1','fa-question-circle-o','admin','admin','2018-02-01 13:20:17','2018-07-07 23:45:09'),
('51','M151','M157','轮播图片','/admin/Slide/index','502','1','1','fa-picture-o','admin','admin','2018-03-01 14:57:41','2018-04-07 18:47:07'),
('52','M152','M157','友情链接','/admin/Link/index','503','1','1','fa-link','admin','admin','2018-03-01 14:58:45','2018-04-07 18:47:16'),
('53','M153','M156','配置参数','/admin/Config/index','201','1','1','fa-sliders','admin','admin','2018-03-21 14:52:05','2018-04-07 18:44:02'),
('61','M1000','M157','文章内链','/admin/Tags/index','505','1','0','fa-random','admin','admin','2019-07-12 08:25:41','2019-07-12 08:26:23'),
('55','M155','M156','模型管理','/admin/Model/index','204','1','1','fa-codepen','admin','admin','2018-03-25 17:16:06','2018-04-07 18:44:40'),
('56','M156','0','全局配置','/admin/M156/index','200','1','0','fa-globe','admin','admin','2018-03-25 17:20:43','2018-04-30 14:43:56'),
('58','M158','M156','模型字段','/admin/ExtField/index','205','1','1','fa-external-link','admin','admin','2018-03-25 21:24:43','2018-04-07 18:44:49'),
('57','M157','0','扩展内容','/admin/M157/index','500','1','0','fa-arrows-alt','admin','admin','2018-03-25 17:27:57','2018-04-30 14:50:34'),
('60','M160','M157','自定义表单','/admin/Form/index','504','1','1','fa-plus-square-o','admin','admin','2018-05-30 18:25:41','2018-05-31 23:55:10'),
('62','M1001','0','会员中心','/admin/M1001/index','600','1','0','fa-user-o','admin','admin','2019-10-04 08:25:41','2019-10-04 08:26:23'),
('63','M1002','M1001','会员等级','/admin/MemberGroup/index','601','1','0','fa-signal','admin','admin','2019-10-04 08:25:41','2019-10-04 08:26:23'),
('64','M1003','M1001','会员字段','/admin/MemberField/index','602','1','0','fa-wpforms','admin','admin','2019-10-04 08:25:41','2019-10-04 08:26:23'),
('65','M1004','M1001','会员管理','/admin/Member/index','603','1','0','fa-users','admin','admin','2019-10-04 08:25:41','2019-10-04 08:26:23'),
('66','M1005','M1001','文章评论','/admin/MemberComment/index','604','1','0','fa-commenting-o','admin','admin','2019-10-04 08:25:41','2019-10-04 08:26:23');

-- --------------------------------------------------------

--
-- 表的结构 `ay_menu_action`
--

CREATE TABLE `ay_menu_action` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mcode` varchar(20) NOT NULL COMMENT '菜单编码',
  `action` varchar(20) NOT NULL COMMENT '类型编码',
  PRIMARY KEY (`id`),
  KEY `ay_menu_action_mcode` (`mcode`)
) ENGINE=MyISAM AUTO_INCREMENT=79 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_menu_action`
--

INSERT INTO `ay_menu_action` (`id`,`mcode`,`action`) VALUES
('1','M102','mod'),
('2','M102','del'),
('3','M102','add'),
('4','M103','mod'),
('5','M103','del'),
('6','M103','add'),
('7','M104','mod'),
('8','M104','del'),
('9','M104','add'),
('10','M105','mod'),
('11','M105','del'),
('12','M105','add'),
('13','M107','mod'),
('14','M107','del'),
('15','M107','add'),
('16','M111','mod'),
('17','M112','mod'),
('18','M114','mod'),
('19','M114','del'),
('20','M114','add'),
('21','M120','mod'),
('22','M120','del'),
('23','M120','add'),
('24','M129','mod'),
('25','M129','del'),
('26','M129','add'),
('27','M131','mod'),
('28','M132','mod'),
('29','M132','del'),
('30','M132','add'),
('31','M136','mod'),
('32','M136','del'),
('33','M136','add'),
('34','M141','mod'),
('35','M141','del'),
('36','M141','add'),
('37','M142','mod'),
('38','M142','del'),
('39','M142','add'),
('40','M143','mod'),
('41','M143','del'),
('42','M143','add'),
('43','M144','mod'),
('44','M144','del'),
('45','M144','add'),
('46','M145','mod'),
('47','M145','del'),
('48','M145','add'),
('49','M150','del'),
('50','M150','mod'),
('51','M151','mod'),
('52','M151','del'),
('53','M151','add'),
('54','M152','mod'),
('55','M152','del'),
('56','M152','add'),
('57','M155','mod'),
('58','M155','del'),
('59','M155','add'),
('60','M158','mod'),
('61','M158','del'),
('62','M158','add'),
('63','M160','add'),
('64','M160','del'),
('65','M160','mod'),
('66','M1000','add'),
('67','M1000','del'),
('68','M1000','mod'),
('69','M1002','add'),
('70','M1002','del'),
('71','M1002','mod'),
('72','M1003','add'),
('73','M1003','del'),
('74','M1003','mod'),
('75','M1004','add'),
('76','M1004','del'),
('77','M1004','mod'),
('78','M1005','del');

-- --------------------------------------------------------

--
-- 表的结构 `ay_message`
--

CREATE TABLE `ay_message` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `acode` varchar(20) NOT NULL COMMENT '区域编码',
  `contacts` varchar(10) DEFAULT NULL COMMENT '联系人',
  `mobile` varchar(12) DEFAULT NULL COMMENT '联系电话',
  `content` varchar(500) DEFAULT NULL COMMENT '留言内容',
  `user_ip` varchar(11) NOT NULL DEFAULT '0' COMMENT 'IP地址',
  `user_os` varchar(30) NOT NULL COMMENT '操作系统',
  `user_bs` varchar(30) NOT NULL COMMENT '浏览器',
  `recontent` varchar(500) NOT NULL COMMENT '回复内容',
  `status` char(1) NOT NULL DEFAULT '1' COMMENT '是否前台显示',
  `create_user` varchar(30) NOT NULL COMMENT '创建人员',
  `update_user` varchar(30) NOT NULL COMMENT '更新人员',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `ay_message_acode` (`acode`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_message`
--

INSERT INTO `ay_message` (`id`,`acode`,`contacts`,`mobile`,`content`,`user_ip`,`user_os`,`user_bs`,`recontent`,`status`,`create_user`,`update_user`,`create_time`,`update_time`,`uid`) VALUES
('1','cn','星梦','16888888888','PbootCMS真心很不错哦！','2130706433','Windows 10','Firefox','谢谢您对我们的大力支持与肯定！','1','admin','admin','2018-04-12 10:56:09','2018-04-12 10:56:42','0');

-- --------------------------------------------------------

--
-- 表的结构 `ay_model`
--

CREATE TABLE `ay_model` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '序号',
  `mcode` varchar(20) NOT NULL COMMENT '模型编号',
  `name` varchar(50) NOT NULL COMMENT '模型名称',
  `type` char(1) NOT NULL DEFAULT '2' COMMENT '是否列表类型',
  `urlname` varchar(100) NOT NULL DEFAULT '' COMMENT 'URL名称',
  `listtpl` varchar(50) NOT NULL COMMENT '列表页模板',
  `contenttpl` varchar(50) NOT NULL COMMENT '内容页模板',
  `status` char(1) NOT NULL DEFAULT '1' COMMENT '模型状态',
  `issystem` char(1) NOT NULL DEFAULT '0' COMMENT '系统模型',
  `create_user` varchar(30) NOT NULL COMMENT '创建人员',
  `update_user` varchar(30) NOT NULL COMMENT '更新人员',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ay_model_mcode` (`mcode`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_model`
--

INSERT INTO `ay_model` (`id`,`mcode`,`name`,`type`,`urlname`,`listtpl`,`contenttpl`,`status`,`issystem`,`create_user`,`update_user`,`create_time`,`update_time`) VALUES
('1','1','专题','1','pages','','about.html','1','1','admin','admin','2018-04-11 17:16:01','2019-08-05 11:11:44'),
('2','2','新闻','2','news','newslist.html','news.html','1','1','admin','admin','2018-04-11 17:17:16','2019-08-05 11:12:04'),
('3','3','产品','2','products','productlist.html','product.html','1','0','admin','admin','2018-04-11 17:17:46','2019-08-05 11:12:17'),
('4','4','案例','2','cases','caselist.html','case.html','1','0','admin','admin','2018-04-11 17:19:53','2019-08-05 11:12:26');

-- --------------------------------------------------------

--
-- 表的结构 `ay_role`
--

CREATE TABLE `ay_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '角色编号',
  `rcode` varchar(20) NOT NULL COMMENT '角色编码',
  `name` varchar(30) NOT NULL COMMENT '角色名称',
  `description` varchar(50) NOT NULL COMMENT '角色描述',
  `create_user` varchar(30) NOT NULL COMMENT '创建人员',
  `update_user` varchar(30) NOT NULL COMMENT '更新人员',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ay_role_rcode` (`rcode`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_role`
--

INSERT INTO `ay_role` (`id`,`rcode`,`name`,`description`,`create_user`,`update_user`,`create_time`,`update_time`) VALUES
('1','R101','系统管理员','系统管理员具有所有权限','admin','admin','2017-03-22 11:33:32','2019-08-05 11:22:02'),
('2','R102','内容管理员','内容管理员具有基本内容管理权限','admin','admin','2017-06-01 00:32:02','2019-08-05 11:22:12');

-- --------------------------------------------------------

--
-- 表的结构 `ay_role_area`
--

CREATE TABLE `ay_role_area` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rcode` varchar(20) NOT NULL,
  `acode` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ay_role_area_rcode` (`rcode`),
  KEY `ay_role_area_acode` (`acode`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_role_area`
--

INSERT INTO `ay_role_area` (`id`,`rcode`,`acode`) VALUES
('3','R101','cn'),
('4','R102','cn');

-- --------------------------------------------------------

--
-- 表的结构 `ay_role_level`
--

CREATE TABLE `ay_role_level` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `rcode` varchar(20) NOT NULL COMMENT '角色编码',
  `level` varchar(50) NOT NULL COMMENT '权限地址',
  PRIMARY KEY (`id`),
  KEY `ay_role_level_rcode` (`rcode`)
) ENGINE=MyISAM AUTO_INCREMENT=216 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_role_level`
--

INSERT INTO `ay_role_level` (`id`,`rcode`,`level`) VALUES
('165','R101','/admin/Role/index'),
('164','R101','/admin/Menu/mod'),
('163','R101','/admin/Menu/del'),
('162','R101','/admin/Menu/add'),
('161','R101','/admin/Menu/index'),
('160','R101','/admin/Area/mod'),
('159','R101','/admin/Area/del'),
('158','R101','/admin/Area/add'),
('157','R101','/admin/Area/index'),
('156','R101','/admin/M101/index'),
('155','R101','/admin/Tags/mod'),
('154','R101','/admin/Tags/del'),
('153','R101','/admin/Tags/add'),
('152','R101','/admin/Tags/index'),
('151','R101','/admin/Form/mod'),
('150','R101','/admin/Form/del'),
('149','R101','/admin/Form/add'),
('148','R101','/admin/Form/index'),
('147','R101','/admin/Link/mod'),
('146','R101','/admin/Link/del'),
('145','R101','/admin/Link/add'),
('144','R101','/admin/Link/index'),
('143','R101','/admin/Slide/mod'),
('142','R101','/admin/Slide/del'),
('141','R101','/admin/Slide/add'),
('140','R101','/admin/Slide/index'),
('139','R101','/admin/Message/mod'),
('138','R101','/admin/Message/del'),
('137','R101','/admin/Message/index'),
('136','R101','/admin/M157/index'),
('135','R101','/admin/Content/mod'),
('134','R101','/admin/Content/del'),
('133','R101','/admin/Content/add'),
('132','R101','/admin/Content/index'),
('131','R101','/admin/Single/mod'),
('130','R101','/admin/Single/index'),
('129','R101','/admin/M130/index'),
('128','R101','/admin/ContentSort/mod'),
('127','R101','/admin/ContentSort/del'),
('126','R101','/admin/ContentSort/add'),
('125','R101','/admin/ContentSort/index'),
('124','R101','/admin/Company/mod'),
('123','R101','/admin/Company/index'),
('122','R101','/admin/Site/mod'),
('121','R101','/admin/Site/index'),
('120','R101','/admin/M110/index'),
('119','R101','/admin/ExtField/mod'),
('118','R101','/admin/ExtField/del'),
('117','R101','/admin/ExtField/add'),
('116','R101','/admin/ExtField/index'),
('115','R101','/admin/Model/mod'),
('114','R101','/admin/Model/del'),
('113','R101','/admin/Model/add'),
('112','R101','/admin/Model/index'),
('111','R101','/admin/Label/mod'),
('110','R101','/admin/Label/del'),
('109','R101','/admin/Label/add'),
('108','R101','/admin/Label/index'),
('107','R101','/admin/Config/index'),
('106','R101','/admin/M156/index'),
('205','R102','/admin/Link/add'),
('204','R102','/admin/Link/index'),
('203','R102','/admin/Slide/mod'),
('202','R102','/admin/Slide/del'),
('201','R102','/admin/Slide/add'),
('200','R102','/admin/Slide/index'),
('199','R102','/admin/Message/mod'),
('198','R102','/admin/Message/del'),
('197','R102','/admin/Message/index'),
('196','R102','/admin/M157/index'),
('195','R102','/admin/Content/mod'),
('194','R102','/admin/Content/del'),
('193','R102','/admin/Content/add'),
('192','R102','/admin/Content/index'),
('191','R102','/admin/Single/mod'),
('190','R102','/admin/Single/index'),
('189','R102','/admin/M130/index'),
('188','R102','/admin/ContentSort/mod'),
('187','R102','/admin/ContentSort/del'),
('186','R102','/admin/ContentSort/add'),
('185','R102','/admin/ContentSort/index'),
('184','R102','/admin/Company/mod'),
('183','R102','/admin/Company/index'),
('182','R102','/admin/Site/mod'),
('181','R102','/admin/Site/index'),
('180','R102','/admin/M110/index'),
('166','R101','/admin/Role/add'),
('167','R101','/admin/Role/del'),
('168','R101','/admin/Role/mod'),
('169','R101','/admin/User/index'),
('170','R101','/admin/User/add'),
('171','R101','/admin/User/del'),
('172','R101','/admin/User/mod'),
('173','R101','/admin/Syslog/index'),
('174','R101','/admin/Type/index'),
('175','R101','/admin/Type/add'),
('176','R101','/admin/Type/del'),
('177','R101','/admin/Type/mod'),
('178','R101','/admin/Database/index'),
('179','R101','/admin/Site/server'),
('206','R102','/admin/Link/del'),
('207','R102','/admin/Link/mod'),
('208','R102','/admin/Form/index'),
('209','R102','/admin/Form/add'),
('210','R102','/admin/Form/del'),
('211','R102','/admin/Form/mod'),
('212','R102','/admin/Tags/index'),
('213','R102','/admin/Tags/add'),
('214','R102','/admin/Tags/del'),
('215','R102','/admin/Tags/mod');

-- --------------------------------------------------------

--
-- 表的结构 `ay_site`
--

CREATE TABLE `ay_site` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '站点编号',
  `acode` varchar(20) NOT NULL COMMENT '区域代码',
  `title` varchar(100) NOT NULL COMMENT '站点标题',
  `subtitle` varchar(200) NOT NULL COMMENT '站点副标题',
  `domain` varchar(50) NOT NULL COMMENT '站点地址',
  `logo` varchar(100) NOT NULL COMMENT '站点LOGO地址',
  `keywords` varchar(200) NOT NULL COMMENT '站点关键字',
  `description` varchar(500) NOT NULL COMMENT '站点描述',
  `icp` varchar(30) NOT NULL COMMENT '站点备案',
  `theme` varchar(30) NOT NULL COMMENT '站点主题',
  `statistical` varchar(500) NOT NULL COMMENT '站点统计码',
  `copyright` varchar(200) NOT NULL COMMENT '版权信息',
  PRIMARY KEY (`id`),
  KEY `ay_site_acode` (`acode`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_site`
--

INSERT INTO `ay_site` (`id`,`acode`,`title`,`subtitle`,`domain`,`logo`,`keywords`,`description`,`icp`,`theme`,`statistical`,`copyright`) VALUES
('1','cn','某某科技有限公司','','http://pb0117.lovesucai.com','/static/upload/image/20211026/1635251444928163.png','','','湘ICP备88888888号','default','','Copyright © 2018-2020 PbootCMS All Rights Reserved.');

-- --------------------------------------------------------

--
-- 表的结构 `ay_slide`
--

CREATE TABLE `ay_slide` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '序号',
  `acode` varchar(20) NOT NULL COMMENT '区域编码',
  `gid` int(10) unsigned NOT NULL COMMENT '分组序号',
  `pic` varchar(100) NOT NULL COMMENT '图片地址',
  `link` varchar(100) NOT NULL COMMENT '跳转链接',
  `title` varchar(50) NOT NULL COMMENT '说明文字',
  `subtitle` varchar(100) NOT NULL COMMENT '副标题/描述',
  `sorting` int(11) NOT NULL COMMENT '排序',
  `create_user` varchar(30) NOT NULL COMMENT '创建人员',
  `update_user` varchar(30) NOT NULL COMMENT '更新人员',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `ay_slide_acode` (`acode`),
  KEY `ay_slide_gid` (`gid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_slide`
--

INSERT INTO `ay_slide` (`id`,`acode`,`gid`,`pic`,`link`,`title`,`subtitle`,`sorting`,`create_user`,`update_user`,`create_time`,`update_time`) VALUES
('1','cn','1','/static/upload/image/20180412/1523500997605565.jpg','http://www.pbootcms.com','PbootCMS','永久开源、免费的PHP建站系统','255','admin','admin','2018-03-01 16:19:03','2018-04-12 10:43:19'),
('2','cn','1','/static/upload/image/20180412/1523501147676550.jpg','http://www.pbootcms.com','PbootCMS','高效、简洁、强悍的PHP建站源码','255','admin','admin','2018-04-12 10:46:07','2018-04-12 10:46:07');

-- --------------------------------------------------------

--
-- 表的结构 `ay_syslog`
--

CREATE TABLE `ay_syslog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '日志编号',
  `level` varchar(20) NOT NULL COMMENT '信息等级',
  `event` varchar(200) NOT NULL COMMENT '事件',
  `user_ip` varchar(11) NOT NULL DEFAULT '0' COMMENT '客户端IP',
  `user_os` varchar(30) NOT NULL COMMENT '客户端系统',
  `user_bs` varchar(30) NOT NULL COMMENT '客户端浏览器',
  `create_user` varchar(30) NOT NULL COMMENT '创建人员',
  `create_time` datetime NOT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `ay_tags`
--

CREATE TABLE `ay_tags` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `acode` varchar(20) NOT NULL COMMENT '区域',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `link` varchar(200) NOT NULL COMMENT '链接',
  `create_user` varchar(30) NOT NULL COMMENT '添加人员',
  `update_user` varchar(30) NOT NULL COMMENT '更新人员',
  `create_time` datetime NOT NULL COMMENT '添加时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `ay_tags_acode` (`acode`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_tags`
--

INSERT INTO `ay_tags` (`id`,`acode`,`name`,`link`,`create_user`,`update_user`,`create_time`,`update_time`) VALUES
('1','cn','PbootCMS','https://www.pbootcms.com','admin','admin','2019-07-12 14:33:13','2019-07-12 14:33:13');

-- --------------------------------------------------------

--
-- 表的结构 `ay_type`
--

CREATE TABLE `ay_type` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '类型编号',
  `tcode` varchar(20) NOT NULL COMMENT '类型编码',
  `name` varchar(30) NOT NULL COMMENT '类型名称',
  `item` varchar(30) NOT NULL COMMENT '类型项',
  `value` varchar(20) NOT NULL DEFAULT '0' COMMENT '类型值',
  `sorting` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `create_user` varchar(30) NOT NULL COMMENT '添加人员',
  `update_user` varchar(30) NOT NULL COMMENT '更新时间',
  `create_time` datetime NOT NULL COMMENT '添加时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `ay_type_tcode` (`tcode`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_type`
--

INSERT INTO `ay_type` (`id`,`tcode`,`name`,`item`,`value`,`sorting`,`create_user`,`update_user`,`create_time`,`update_time`) VALUES
('1','T101','菜单功能','新增','add','1','admin','admin','2017-04-27 07:28:34','2017-08-09 15:25:56'),
('2','T101','菜单功能','删除','del','2','admin','admin','2017-04-27 07:29:08','2017-08-09 15:23:34'),
('3','T101','菜单功能','修改','mod','3','admin','admin','2017-04-27 07:29:34','2017-08-09 15:23:32'),
('4','T101','菜单功能','导出','export','4','admin','admin','2017-04-27 07:30:42','2017-08-09 15:23:29'),
('5','T101','菜单功能','导入','import','5','admin','admin','2017-04-27 07:31:38','2017-08-09 15:23:27');

-- --------------------------------------------------------

--
-- 表的结构 `ay_user_role`
--

CREATE TABLE `ay_user_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `ucode` varchar(20) NOT NULL COMMENT '用户编码',
  `rcode` varchar(20) NOT NULL COMMENT '角色编码',
  PRIMARY KEY (`id`),
  KEY `ay_user_role_ucode` (`ucode`),
  KEY `ay_user_role_rcode` (`rcode`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `ay_user_role`
--

INSERT INTO `ay_user_role` (`id`,`ucode`,`rcode`) VALUES
('1','10001','R101');

-- --------------------------------------------------------

