-- ----------------------------
-- 日期：2022-01-10 11:13:36
DROP TABLE IF EXISTS `rmtop_extends_params`;
CREATE TABLE `rmtop_extends_params` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) DEFAULT '0',
  `sid` int(11) NOT NULL DEFAULT '0',
  `type` varchar(50) NOT NULL DEFAULT 'text',
  `key` varchar(50) NOT NULL DEFAULT '0',
  `title` varchar(80) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8 COMMENT='单面额外参数';

INSERT INTO `rmtop_extends_params` (`id`,`cid`,`sid`,`type`,`key`,`title`,`value`) VALUES
('52','1','1','file','news_topimg','隔层背景图',''),
('53','1','1','text','all_tell','官方电话','');

DROP TABLE IF EXISTS `rmtop_extends_product_17_params`;
CREATE TABLE `rmtop_extends_product_17_params` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) DEFAULT '0' COMMENT '信息id',
  `free_price` varchar(200) NOT NULL,
  `author` varchar(200) NOT NULL,
  `versions` varchar(200) NOT NULL,
  `author_img` varchar(180) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_extends_product_17_params` (`id`,`sid`,`free_price`,`author`,`versions`,`author_img`) VALUES
('1','15','免费使用','Karn','rmTop v1.0.1','/images//rTop_aa58163ede2ab8816193bff63fdb801a.png');

DROP TABLE IF EXISTS `rmtop_extends_single_19_params`;
CREATE TABLE `rmtop_extends_single_19_params` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) DEFAULT '0' COMMENT '信息id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_extends_single_19_params` (`id`,`sid`) VALUES
('1','9');

DROP TABLE IF EXISTS `rmtop_extends_single_1_params`;
CREATE TABLE `rmtop_extends_single_1_params` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) DEFAULT '0' COMMENT '信息id',
  `kefu_weixin` varchar(180) NOT NULL,
  `title_key` varchar(200) NOT NULL,
  `scheme_one` varchar(200) DEFAULT NULL,
  `scheme_two` varchar(200) DEFAULT NULL,
  `scheme_three` varchar(200) DEFAULT NULL,
  `scheme_take` text,
  `scheme_img` varchar(180) DEFAULT NULL,
  `news_topimg` varchar(180) DEFAULT NULL,
  `all_tell` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_extends_single_1_params` (`id`,`sid`,`kefu_weixin`,`title_key`,`scheme_one`,`scheme_two`,`scheme_three`,`scheme_take`,`scheme_img`,`news_topimg`,`all_tell`) VALUES
('1','1','/images//rTop_3c9336ffd417cd26d148c74f17fc5960.png','企业官网、官网、通用官网、企业网站、响应式网站，自适应','宣传企业的服务，展示企业形象，并通过网络与各行各业进行交流和合作','网站在百度搜索不到，前面都是竞争对手的网站？','以互联网为基本手段营造网上经营环境的各种活动。','网络营销是企业整体营销战略的一个组成部分，是为实现企业总体经营目标所进行的，以互联网为基本手段营造网上经营环境的各种活动。其中可以利用多种手段，如E-mail营销、博客与微博营销、网络广告营销、视频营销、媒体营销、竞价推广营销、SEO优化排名营销等。 总体来讲，凡是以互联网或移动互联为主要平台开展的各种营销活动，都可称之为整合网络营销。','/images//rTop_b084f060f47c873f979e3492c561e3e8.png','/images///rTop_17313071542e6fee2a2acc1334dab73fbaeeff4786e.jpg','400-123-4567');

DROP TABLE IF EXISTS `rmtop_extends_single_21_params`;
CREATE TABLE `rmtop_extends_single_21_params` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) DEFAULT '0' COMMENT '信息id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_extends_single_21_params` (`id`,`sid`) VALUES
('1','10');

DROP TABLE IF EXISTS `rmtop_extends_single_22_params`;
CREATE TABLE `rmtop_extends_single_22_params` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) DEFAULT '0' COMMENT '信息id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_extends_single_22_params` (`id`,`sid`) VALUES
('1','12');

DROP TABLE IF EXISTS `rmtop_extends_single_23_params`;
CREATE TABLE `rmtop_extends_single_23_params` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) DEFAULT '0' COMMENT '信息id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_extends_single_23_params` (`id`,`sid`) VALUES
('1','13');

DROP TABLE IF EXISTS `rmtop_extends_single_27_params`;
CREATE TABLE `rmtop_extends_single_27_params` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) DEFAULT '0' COMMENT '信息id',
  `verison` varchar(200) DEFAULT NULL,
  `kefu_weixin` varchar(180) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_extends_single_27_params` (`id`,`sid`,`verison`,`kefu_weixin`) VALUES
('1','11','','');

DROP TABLE IF EXISTS `rmtop_extends_single_28_params`;
CREATE TABLE `rmtop_extends_single_28_params` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) DEFAULT '0' COMMENT '信息id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_extends_single_28_params` (`id`,`sid`) VALUES
('1','12');

DROP TABLE IF EXISTS `rmtop_extends_single_29_params`;
CREATE TABLE `rmtop_extends_single_29_params` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) DEFAULT '0' COMMENT '信息id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_extends_single_29_params` (`id`,`sid`) VALUES
('1','13');

DROP TABLE IF EXISTS `rmtop_extends_single_2_params`;
CREATE TABLE `rmtop_extends_single_2_params` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) DEFAULT '0' COMMENT '信息id',
  `free_price` varchar(200) NOT NULL,
  `base_price` varchar(200) NOT NULL,
  `specialty_price` varchar(200) NOT NULL,
  `page_title` varchar(200) NOT NULL,
  `auth_price` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_extends_single_2_params` (`id`,`sid`,`free_price`,`base_price`,`specialty_price`,`page_title`,`auth_price`) VALUES
('1','2','0','1800','5888','服务内容','198');

DROP TABLE IF EXISTS `rmtop_extends_single_30_params`;
CREATE TABLE `rmtop_extends_single_30_params` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) DEFAULT '0' COMMENT '信息id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_extends_single_30_params` (`id`,`sid`) VALUES
('1','14');

DROP TABLE IF EXISTS `rmtop_extends_single_32_params`;
CREATE TABLE `rmtop_extends_single_32_params` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) DEFAULT '0' COMMENT '信息id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_extends_single_32_params` (`id`,`sid`) VALUES
('1','11');

DROP TABLE IF EXISTS `rmtop_extends_single_35_params`;
CREATE TABLE `rmtop_extends_single_35_params` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` int(11) DEFAULT '0' COMMENT '信息id',
  `left_img` varchar(180) DEFAULT NULL,
  `right_img` varchar(180) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_extends_single_35_params` (`id`,`sid`,`left_img`,`right_img`) VALUES
('1','15','/images//rTop_49e966466b483ecd3edfbb93d2915dc0.jpg','/images//rTop_76d3957a24188bcb1144e5dc6283a973.jpg');

DROP TABLE IF EXISTS `rmtop_advertise`;
CREATE TABLE `rmtop_advertise` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL DEFAULT '0',
  `sort` int(11) NOT NULL DEFAULT '0',
  `title` varchar(120) DEFAULT NULL COMMENT '标题',
  `desc` text COMMENT '广告简述',
  `org_img` varchar(160) DEFAULT NULL COMMENT '图片',
  `url` varchar(160) DEFAULT NULL COMMENT '地址',
  `create_time` varchar(160) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_advertise` (`id`,`group_id`,`sort`,`title`,`desc`,`org_img`,`url`,`create_time`) VALUES
('5','1','1','美容整形','12312312','/images///rTop_1105587001493b3726c60e360ed0b6dff5cec965e39.jpg','12313','1626873960'),
('6','1','2','医疗美容','','/images///rTop_1106184671806d27c52a7c65f77d34e64412d22707a.jpg','222','1626876237'),
('7','2','1','品牌网站设计','应用各种网络程序开发技术和网页设计技术','/images//rTop_235fc48cc54040f43383d5d67ae9a0b4.webp','111','1628132398'),
('8','2','2','小程序定制开发','小程序专属定制服务','/images//rTop_4d238e16e5ee1bef9016bd4a406a32d5.png','11','1628149669'),
('9','2','3','来稿定制开发','根据您的需求，量身定制服务系统','/images//rTop_665eb3016b1df3d1038999946a513d3b.png','11','1628149699'),
('10','2','4','系统运维托管','有针对性的运维、系统托管','/images//rTop_25aa4e69fd49d1fd9765291c4c7d1f41.png','111','1628149726'),
('11','2','5','物联网开发定制','万物互联 , 物联网定制开发。','/images//rTop_1b571179fa44e323c7e52ad82428b492.png','111','1628149755'),
('12','2','6','APP开发','专注于手机应用软件开发与服务','/images//rTop_5442b78a617fca733f244be8bfff8b58.png','111','1628149818');

DROP TABLE IF EXISTS `rmtop_advertise_group`;
CREATE TABLE `rmtop_advertise_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_advertise_group` (`id`,`title`) VALUES
('1','首页轮播');

DROP TABLE IF EXISTS `rmtop_column`;
CREATE TABLE `rmtop_column` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(11) DEFAULT '0' COMMENT '父级别ID',
  `sort` int(10) DEFAULT '0',
  `title` varchar(100) DEFAULT NULL COMMENT '名称',
  `en_title` char(120) DEFAULT NULL COMMENT '英文别名',
  `org_img` varchar(150) DEFAULT NULL COMMENT '栏目图片',
  `type` tinyint(1) unsigned DEFAULT '1' COMMENT '栏目类型 1外部url 2内部',
  `type_url` varchar(225) DEFAULT NULL COMMENT 'url 链接',
  `directory_name` varchar(120) DEFAULT NULL COMMENT '目录名称',
  `model` varchar(80) DEFAULT NULL COMMENT '栏目模型',
  `model_title` varchar(150) DEFAULT NULL COMMENT '模型名称',
  `list_tmp` varchar(100) DEFAULT NULL COMMENT '列表模版',
  `info_tmp` varchar(100) DEFAULT NULL COMMENT '详情模板',
  `seo_title` varchar(225) DEFAULT NULL COMMENT 'Seo标题',
  `seo_key` varchar(200) DEFAULT NULL COMMENT 'Seo 关键词',
  `seo_des` text COMMENT 'Seo 描述',
  `is_show` tinyint(1) DEFAULT '0' COMMENT '1 隐藏 0 不隐藏',
  `is_index` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_column` (`id`,`pid`,`sort`,`title`,`en_title`,`org_img`,`type`,`type_url`,`directory_name`,`model`,`model_title`,`list_tmp`,`info_tmp`,`seo_title`,`seo_key`,`seo_des`,`is_show`,`is_index`) VALUES
('1','0','0','首页','index','','1','','','single','单页模型','index','','[入目三分科技]，有技术，有创新，有未来！官方热线：0871-65338812 / 65814748','入目三分科技|云南入目三分科技|微信公众号开发 微信公众号开发教程|支付宝小程序开发|网站制作|官网建设|H5页面开发|云南app开发|云南科技|云南互联网|云南系统开发|云南系统集成|云南小程序开发 小程序开发 微信小程序开发 小程序开发文档 微信小程序开发教程','云南入目三分科技有限公司，有技术，有创新，有未来。『云南入目三分科技有限公司』
服务项目包括网站开发、小程序开发、APP开发、域名注册、 虚拟主机、VPS、云主机、企业邮箱、主机租用、主机托管、CDN网站加速、网络营销服务等，以帮助客户轻松、高速、 高效的应用互联网，提高企业竞争能力。
『云南入目三分科技有限公司』正在以创新、引领互联网科技前沿作为自身进步的灵魂和事业兴旺发达的不懈动力，积极建立适应知识经济、技术创新的机制与经营方式，全力向技术产业方面发展。','0','0'),
('9','4','0','新手指引','guide','','1','','','article','文章模型','doclist','docinfo','','','','0','0'),
('10','4','0','产品介绍','Introduction','','1','','','article','文章模型','doclist','docinfo','','','','0','0'),
('11','4','0','操作手册','handbook','','1','','','article','文章模型','doclist','docinfo','','','','0','0'),
('13','4','0','模板知识','template','','1','','','article','文章模型','doclist','docinfo','','','','0','0'),
('15','4','0','SEO知识','seo','','1','','','article','文章模型','doclist','docinfo','','','','0','0'),
('16','4','0','安全相关','safe','','1','','','article','文章模型','doclist','docinfo','','','','0','0'),
('18','0','0','服务范围','server','/images//rTop_41fa832694ced86299d0dd7052872ef3.webp','1','','','article','文章模型','servelist','servinfo','','','','0','0'),
('19','0','0','专家团队','team','/images//rTop_35d7b748b65b8325132b8a14f3134d45.jpg','1','','','article','文章模型','teams','teaminfo','专家团队','专家团队','专家团队','0','0'),
('20','0','0','先进设备','facility','/images//rTop_41fa832694ced86299d0dd7052872ef3.webp','1','','','article','文章模型','facility','facilityinfo','','','','0','0'),
('21','0','0','新闻动态','news','/images//rTop_41fa832694ced86299d0dd7052872ef3.webp','1','','','article','文章模型','newslist','newsinfo','','','','0','0'),
('23','18','0','美容整形','cosmet','/images//rTop_41fa832694ced86299d0dd7052872ef3.webp','1','','','article','文章模型','servelist','servinfo','','','用心服务，竭诚为您。','0','0'),
('24','18','0','口腔美容','cavity','/images//rTop_216fcacc2842cc8432530453e206675d.jpg','1','','','article','文章模型','servelist','servinfo','','','','0','0'),
('25','19','0','内科专家','internal','/images//rTop_41fa832694ced86299d0dd7052872ef3.webp','1','','','article','文章模型','teams','teaminfo','内科专家','内科专家','内科专家','0','0'),
('26','19','0','外科专家','surgery','/images//rTop_35d7b748b65b8325132b8a14f3134d45.jpg','1','','','article','文章模型','teams','teaminfo','外科专家','外科专家','外科专家','0','0'),
('27','19','0','整形专家','plastic','','1','','','article','文章模型','teams','teaminfo','','','','0','0'),
('28','18','0','无创整形','wucts','','1','','','article','文章模型','servelist','servinfo','','','','0','0'),
('29','21','0','医院公告','ctnotice','','1','','','article','文章模型','newslist','newsinfo','','','','0','0'),
('30','21','0','行业动态','hotnews','','1','','','article','文章模型','newslist','newsinfo','','','','0','0'),
('31','0','0','联系我们','contact','','1','','','message','留言模型','contact','','','','','0','0'),
('32','0','0','关于我们','aboutus','','1','','','single','单页模型','aboutus','','','','','0','0');

DROP TABLE IF EXISTS `rmtop_config`;
CREATE TABLE `rmtop_config` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `zh_name` varchar(80) DEFAULT NULL COMMENT '中文名称',
  `en_name` varchar(80) DEFAULT NULL COMMENT '英文名称',
  `value` text COMMENT '配置值',
  `is_true` int(11) DEFAULT '0',
  `sort` int(11) DEFAULT '0',
  `group_id` int(11) DEFAULT '0' COMMENT '配置分组',
  `delete_time` int(11) DEFAULT '0' COMMENT '1 不可删除 0可删除',
  `create_time` int(11) DEFAULT '0',
  `update_time` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_config` (`id`,`zh_name`,`en_name`,`value`,`is_true`,`sort`,`group_id`,`delete_time`,`create_time`,`update_time`) VALUES
('1','系统加密密匙','sys_crypto','123456','1','0','0','0','0','0'),
('2','网站状态','is_open','0','0','0','0','0','0','0'),
('3','网站标题','web_title',' rmTopCMS——轻便、多变的CMS服务系统','0','0','0','0','0','0'),
('4','网站域名','web_host','http://ljg.317.ink/','0','0','0','0','0','0'),
('5','网站logo','web_logo','http://static-img.rmsf.top/rmTop/20211228/rTop_00475129417fecea6ee3ccaefc02d677e74e653b7fd','0','0','0','0','0','0'),
('6','网站关键词','web_keyword','rmTopCMS|企业官网制作|免费企业官网|信息发布系统|产品展示官网|企业模板|手机网站|企营销网站|微信网站|H5网站|外贸建站|高端网站|政府CMS|企业级CMS|网站群|内容管理系统|网站内容管理|门户系统|rmcms|cms|rmtop|','0','0','0','0','0','0'),
('7','网站描述','web_desc',' 开源、跨平台、企业级的CMS内容管理系统，能够以最低的成本、最少的人力投入在最短的时间内架设一个功能齐全、性能优异、易于维护的网站平台.','0','0','0','0','0','0'),
('8','网站版权','web_copyright','rmTopCMS','0','0','0','0','0','0'),
('9','网站备案号','web_icp','滇ICP备17002956号','0','0','0','0','0','0'),
('10','闭站提示','close_tip','维护中...','0','0','0','0','0','0'),
('29','文件储存位置','static_path','/public/images/','0','0','0','0','0','0'),
('30','当前模板','tmp_path','hospital','0','0','0','0','0','0'),
('31','客服电话','kefu_mobile','0871-65814748','0','1','6','0','1625592100','1625592100'),
('32','公司地址:','kefu_adress','云南省 • 昆明市五华区金鼎科技园','0','3','6','0','1625592990','1625592990'),
('33','文件可访问路径','view_static_path','/images/','0','0','0','0','0','0'),
('34','网站ico','web_ico','https://static-img.rmsf.top/rmTop/20211228/rTop_11520299844ede97db02616448d331e2922ab800565','0','0','0','0','0','0'),
('35','登录页面Logo','login_logo','https://static-img.rmsf.top/rmTop/20211228/rTop_1157513925937f902511bcbb8b25f8207fd53c3b508','0','0','0','0','0','0'),
('36','推送授权信息','baiduSpiderAuth','https://www.rmsf.top&token=sccjW6o5UJy58D6z','0','1','7','0','1627196891','1627196891'),
('37','访问推送','visit_push_open','1','0','2','7','0','1627219477','1627219477'),
('38','主动推送开关','add_push_open','1','0','3','7','0','1627219574','1627219574'),
('39','邮箱','kefu_email','hezuo@ynrmsf.com','0','2','6','0','1627486751','1627486751'),
('40','开发者模式','developer','1','0','0','0','0','0','0'),
('41','Top应用中心','app_center','2','0','0','0','0','0','0'),
('42','Region','cosRegion','','0','1','8','0','1640619895','1640619895'),
('43','buckName','cosBuckName','','0','2','8','0','1640619915','1640619915'),
('44','资源域名','cosHost','','0','3','8','0','1640619951','1640619951'),
('45','SecretId','SecretId','','0','0','8','0','1640620052','1640620052'),
('46','SecretKey','SecretKey','','0','0','8','0','1640620062','1640620062'),
('47','存储方式|local|cos|oss','save_type','local','0','0','8','0','1640622758','1640622758');

DROP TABLE IF EXISTS `rmtop_config_group`;
CREATE TABLE `rmtop_config_group` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(11) DEFAULT NULL COMMENT '分组名称',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `ident` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_config_group` (`id`,`title`,`sort`,`ident`) VALUES
('5','短信配置','1','sms'),
('6','客服配置','1','kefu');

DROP TABLE IF EXISTS `rmtop_extends_category`;
CREATE TABLE `rmtop_extends_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `col_id` int(11) DEFAULT '0' COMMENT '栏目ID',
  `pid` int(11) DEFAULT '0',
  `title` varchar(100) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='分类栏目';

DROP TABLE IF EXISTS `rmtop_navs`;
CREATE TABLE `rmtop_navs` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` int(11) DEFAULT '0' COMMENT '分组ID',
  `pid` int(11) DEFAULT '0' COMMENT '父级ID',
  `title` varchar(150) DEFAULT NULL COMMENT '导航名称',
  `url` varchar(255) DEFAULT NULL COMMENT '导航URl',
  `click_times` int(11) DEFAULT '0' COMMENT '点击次数',
  `target` varchar(60) DEFAULT NULL COMMENT '打开方式',
  `create_time` int(11) DEFAULT '0',
  `update_time` int(11) DEFAULT '0',
  `delete_time` int(11) DEFAULT '0',
  `sort` int(11) DEFAULT '0' COMMENT '排序',
  `status` int(11) DEFAULT '0',
  `nav_type` int(11) DEFAULT '0' COMMENT '内部栏目',
  `column_id` varchar(11) DEFAULT '0' COMMENT '栏目ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_navs` (`id`,`group_id`,`pid`,`title`,`url`,`click_times`,`target`,`create_time`,`update_time`,`delete_time`,`sort`,`status`,`nav_type`,`column_id`) VALUES
('29','7','0','网站首页','','0','0','1625455168','1625455168','0','1','0','0','1'),
('44','7','0','楼盘展示','','0','0','1626922898','1626922898','0','2','0','0','18'),
('45','7','0','楼盘资讯','','0','0','1626922943','1626922943','0','3','0','0','19'),
('46','7','0','关于我们','','0','0','1626922961','1626922961','0','4','0','0','20'),
('47','7','0','联系我们','','0','0','1626922980','1626922980','0','5','0','0','21'),
('48','7','0','企业文化','','0','0','1626923005','1626923005','0','7','0','0','31'),
('49','10','44','五华区楼盘','','0','0','1626923099','1626923099','0','7','0','0','23'),
('50','10','44','西山区楼盘','','0','0','1626923135','1626923135','0','8','0','0','24'),
('51','6','45','五华区楼盘资讯','','0','0','1626923172','1626923172','0','9','0','0','25'),
('52','6','45','西山区楼盘资讯','','0','0','1626923203','1626923203','0','10','0','0','26'),
('59','10','44','官渡区楼盘','','0','0','1641522004','1641522004','0','9','0','0','28'),
('62','6','45','官渡区楼盘资讯','','0','0','1641630852','1641630852','0','11','0','0','27'),
('63','6','45','盘龙区楼盘资讯','','0','0','1641630902','1641630902','0','12','0','0','36'),
('64','10','44','盘龙区楼盘','','0','0','1641631043','1641631043','0','10','0','0','35');

DROP TABLE IF EXISTS `rmtop_navs_category`;
CREATE TABLE `rmtop_navs_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(150) DEFAULT NULL COMMENT '分组名称',
  `sort` int(11) DEFAULT '0' COMMENT '排序',
  `create_time` varchar(255) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_navs_category` (`id`,`title`,`sort`,`create_time`) VALUES
('2','底部导航','2','1617549550'),
('4','侧边导航','4','1617585437'),
('6','楼盘资讯','5','1624878826'),
('7','顶部导航','1','1625208782'),
('9','友情链接','7','1626678034'),
('10','楼盘展示','8','1626922815'),
('11','专家团队','9','1641521618');

DROP TABLE IF EXISTS `rmtop_extends_single`;
CREATE TABLE `rmtop_extends_single` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uqid` varchar(80) NOT NULL DEFAULT '0',
  `seo_title` varchar(255) DEFAULT NULL,
  `seo_key` varchar(255) DEFAULT NULL,
  `seo_des` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL COMMENT '单页标题',
  `img_lists` varchar(255) DEFAULT NULL,
  `text` text COMMENT '单页内容',
  `view_path` varchar(255) DEFAULT NULL COMMENT '模板',
  `views` int(11) DEFAULT '0' COMMENT '浏览次数',
  `create_time` varchar(255) DEFAULT NULL,
  `doc_type` varchar(255) DEFAULT NULL,
  `col_id` int(11) DEFAULT '0' COMMENT '模型标识',
  `author` varchar(120) DEFAULT NULL,
  `access` int(11) DEFAULT '0',
  `tags` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

INSERT INTO `rmtop_extends_single` (`id`,`uqid`,`seo_title`,`seo_key`,`seo_des`,`title`,`img_lists`,`text`,`view_path`,`views`,`create_time`,`doc_type`,`col_id`,`author`,`access`,`tags`) VALUES
('1','0','宜居房地产','宜居房地产','宜居房地产专注五华区、西山区、盘龙区、官渡区各大新楼盘','','','','0','367','','','1','','0','宜居房地产'),
('9','0','','','','','','演示数据演示数据演示数据演示数据演示数据演示数据演示数据演示数据','','0','','','19','','0',''),
('10','bfb56eb1debbc4b0','','','','','','<p>有理想 ， 有拼劲 ！</p><p><br/></p><p><br/></p>','','58','1626922576','','21','','0','');

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

