-- ----------------------------
-- 日期:2021-08-15 13:22:18
DROP TABLE IF EXISTS `rtop_extends_params`;
CREATE TABLE `rtop_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=61 DEFAULT CHARSET=utf8 COMMENT='单面额外参数';
INSERT INTO `rtop_extends_params` (`id`,`cid`,`sid`,`type`,`key`,`title`,`value`) VALUES
('54','35','15','file','left_img','左边图片',''),
('55','35','15','file','right_img','右边图片',''),
('56','28','12','file','tell_leftimg','联系我们左图',''),
('57','28','12','file','tell_ritimg','联系我们右图',''),
('58','27','11','file','abuot_lfimg','关于我们左图',''),
('59','27','11','file','about_rtimg','关于我们右下图',''),
('60','27','11','file','tear_img','茶文化','');
DROP TABLE IF EXISTS `rtop_extends_product_17_params`;
CREATE TABLE `rtop_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 `rtop_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 `rtop_extends_single_1_params`;
CREATE TABLE `rtop_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,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `rtop_extends_single_21_params`;
CREATE TABLE `rtop_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 `rtop_extends_single_21_params` (`id`,`sid`) VALUES
('1','10');
DROP TABLE IF EXISTS `rtop_extends_single_27_params`;
CREATE TABLE `rtop_extends_single_27_params` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sid` int(11) DEFAULT '0' COMMENT '信息id',
`abuot_lfimg` varchar(180) DEFAULT NULL,
`about_rtimg` varchar(180) DEFAULT NULL,
`tear_img` varchar(180) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
INSERT INTO `rtop_extends_single_27_params` (`id`,`sid`,`abuot_lfimg`,`about_rtimg`,`tear_img`) VALUES
('1','11','/images//rTop_6ad010b5cbd5de658d313325a63f745e.png','/images//rTop_a8bd67f4ebe89c2b16f8f63989f29030.png','/images//rTop_62db185172d51134982a8fc15597ad23.jpeg');
DROP TABLE IF EXISTS `rtop_extends_single_28_params`;
CREATE TABLE `rtop_extends_single_28_params` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sid` int(11) DEFAULT '0' COMMENT '信息id',
`tell_leftimg` varchar(180) DEFAULT NULL,
`tell_ritimg` varchar(180) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
INSERT INTO `rtop_extends_single_28_params` (`id`,`sid`,`tell_leftimg`,`tell_ritimg`) VALUES
('1','12','/images//rTop_c265d57712b57b283b86c69bfbf8f636.jpg','/images//rTop_467c8adc6d30128f51c623200b786cda.jpeg');
DROP TABLE IF EXISTS `rtop_extends_single_29_params`;
CREATE TABLE `rtop_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 `rtop_extends_single_29_params` (`id`,`sid`) VALUES
('1','13');
DROP TABLE IF EXISTS `rtop_extends_single_2_params`;
CREATE TABLE `rtop_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 `rtop_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 `rtop_extends_single_30_params`;
CREATE TABLE `rtop_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 `rtop_extends_single_30_params` (`id`,`sid`) VALUES
('1','14');
DROP TABLE IF EXISTS `rtop_extends_single_35_params`;
CREATE TABLE `rtop_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 `rtop_extends_single_35_params` (`id`,`sid`,`left_img`,`right_img`) VALUES
('1','15','/images//rTop_5ec5038520f67d23bb523cd47d4db67b.jpg','/images//rTop_6fa94d002987abb9f23f24d7df5292d0.jpg');
DROP TABLE IF EXISTS `rtop_extends_single_8_params`;
CREATE TABLE `rtop_extends_single_8_params` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sid` int(11) DEFAULT '0' COMMENT '信息id',
`our_map` varchar(180) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `rtop_advertise`;
CREATE TABLE `rtop_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 `rtop_advertise` (`id`,`group_id`,`sort`,`title`,`desc`,`org_img`,`url`,`create_time`) VALUES
('5','1','1','图片1','12312312','/images//rTop_1c1f38825618f8cbb59b1017f58c37ee.jpeg','12313','1626873960'),
('6','1','1','图片2','','/images//rTop_9c48abb72fef704b0415705ce1c8352b.jpeg','111','1626876237');
DROP TABLE IF EXISTS `rtop_advertise_group`;
CREATE TABLE `rtop_advertise_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
INSERT INTO `rtop_advertise_group` (`id`,`title`) VALUES
('1','首页轮播');
DROP TABLE IF EXISTS `rtop_column`;
CREATE TABLE `rtop_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` varcha