DROP TABLE IF EXISTS `jc_acquisition`;
CREATE TABLE `jc_acquisition` (
`acquisition_id` int(11) NOT NULL auto_increment,
`site_id` int(11) NOT NULL,
`channel_id` int(11) NOT NULL,
`type_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`acq_name` varchar(50) NOT NULL COMMENT '采集名称',
`start_time` datetime default NULL COMMENT '开始时间',
`end_time` datetime default NULL COMMENT '停止时间',
`status` int(11) NOT NULL default '0' COMMENT '当前状态(0:静止;1:采集;2:暂停)',
`curr_num` int(11) NOT NULL default '0' COMMENT '当前号码',
`curr_item` int(11) NOT NULL default '0' COMMENT '当前条数',
`total_item` int(11) NOT NULL default '0' COMMENT '每页总条数',
`pause_time` int(11) NOT NULL default '0' COMMENT '暂停时间(毫秒)',
`page_encoding` varchar(20) NOT NULL default 'GBK' COMMENT '页面编码',
`plan_list` longtext COMMENT '采集列表',
`dynamic_addr` varchar(255) default NULL COMMENT '动态地址',
`dynamic_start` int(11) default NULL COMMENT '页码开始',
`dynamic_end` int(11) default NULL COMMENT '页码结束',
`linkset_start` varchar(255) default NULL COMMENT '内容链接区开始',
`linkset_end` varchar(255) default NULL COMMENT '内容链接区结束',
`link_start` varchar(255) default NULL COMMENT '内容链接开始',
`link_end` varchar(255) default NULL COMMENT '内容链接结束',
`title_start` varchar(255) default NULL COMMENT '标题开始',
`title_end` varchar(255) default NULL COMMENT '标题结束',
`keywords_start` varchar(255) default NULL COMMENT '关键字开始',
`keywords_end` varchar(255) default NULL COMMENT '关键字结束',
`description_start` varchar(255) default NULL COMMENT '描述开始',
`description_end` varchar(255) default NULL COMMENT '描述结束',
`content_start` varchar(255) default NULL COMMENT '内容开始',
`content_end` varchar(255) default NULL COMMENT '内容结束',
`pagination_start` varchar(255) default NULL COMMENT '内容分页开始',
`pagination_end` varchar(255) default NULL COMMENT '内容分页结束',
`queue` int(11) NOT NULL default '0' COMMENT '队列',
`repeat_check_type` varchar(20) NOT NULL default 'NONE' COMMENT '重复类型',
`img_acqu` tinyint(1) NOT NULL default '0' COMMENT '是否采集图片',
`content_prefix` varchar(255) default NULL COMMENT '内容地址补全url',
`img_prefix` varchar(255) default NULL COMMENT '图片地址补全url',
`view_start` varchar(255) default NULL COMMENT '浏览量开始',
`view_end` varchar(255) default NULL COMMENT '浏览量结束',
`view_id_start` varchar(255) default NULL COMMENT 'id前缀',
`view_id_end` varchar(255) default NULL COMMENT 'id后缀',
`view_link` varchar(255) default NULL COMMENT '浏览量动态访问地址',
`releaseTime_start` varchar(255) default NULL COMMENT '发布时间开始',
`releaseTime_end` varchar(255) default NULL COMMENT '发布时间结束',
`author_start` varchar(255) default NULL COMMENT '作者开始',
`author_end` varchar(255) default NULL COMMENT '作者结束',
`origin_start` varchar(255) default NULL COMMENT '来源开始',
`origin_end` varchar(255) default NULL COMMENT '来源结束',
`releaseTime_format` varchar(255) default NULL COMMENT '发布时间格式',
PRIMARY KEY (`acquisition_id`),
KEY `fk_jc_acquisition_channel` (`channel_id`),
KEY `fk_jc_acquisition_contenttype` (`type_id`),
KEY `fk_jc_acquisition_site` (`site_id`),
KEY `fk_jc_acquisition_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='CMS采集表';
DROP TABLE IF EXISTS `jc_acquisition_history`;
CREATE TABLE `jc_acquisition_history` (
`history_id` int(11) NOT NULL auto_increment,
`channel_url` varchar(255) NOT NULL default '' COMMENT '栏目地址',
`content_url` varchar(255) NOT NULL default '' COMMENT '内容地址',
`title` varchar(255) default NULL COMMENT '标题',
`description` varchar(20) NOT NULL default '' COMMENT '描述',
`acquisition_id` int(11) default NULL COMMENT '采集源',
`content_id` int(11) default NULL COMMENT '内容',
PRIMARY KEY (`history_id`),
KEY `fk_acquisition_history_acquisition` (`acquisition_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='采集历史记录表';
DROP TABLE IF EXISTS `jc_acquisition_temp`;
CREATE TABLE `jc_acquisition_temp` (
`temp_id` int(11) NOT NULL auto_increment,
`site_id` int(11) default NULL,
`channel_url` varchar(255) NOT NULL default '' COMMENT '栏目地址',
`content_url` varchar(255) NOT NULL default '' COMMENT '内容地址',
`title` varchar(255) default NULL COMMENT '标题',
`finish_percent` int(3) NOT NULL default '0' COMMENT '百分比',
`description` varchar(20) NOT NULL default '' COMMENT '描述',
`seq` int(3) NOT NULL default '0' COMMENT '顺序',
PRIMARY KEY (`temp_id`),
KEY `fk_jc_temp_site` (`site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='采集进度临时表';
DROP TABLE IF EXISTS `jc_advertising`;
CREATE TABLE `jc_advertising` (
`advertising_id` int(11) NOT NULL auto_increment,
`adspace_id` int(11) NOT NULL,
`site_id` int(11) NOT NULL,
`ad_name` varchar(100) NOT NULL COMMENT '广告名称',
`category` varchar(50) NOT NULL COMMENT '广告类型',
`ad_code` longtext COMMENT '广告代码',
`ad_weight` int(11) NOT NULL default '1' COMMENT ' 广告权重',
`display_count` bigint(20) NOT NULL default '0' COMMENT '展现次数',
`click_count` bigint(20) NOT NULL default '0' COMMENT '点击次数',
`start_time` date default NULL COMMENT '开始时间',
`end_time` date default NULL COMMENT '结束时间',
`is_enabled` char(1) NOT NULL default '1' COMMENT '是否启用',
PRIMARY KEY (`advertising_id`),
KEY `fk_jc_advertising_site` (`site_id`),
KEY `fk_jc_space_advertising` (`adspace_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='CMS广告表';
INSERT INTO `jc_advertising` VALUES (1,1,1,'banner','image',NULL,1,130,0,NULL,NULL,'1');
INSERT INTO `jc_advertising` VALUES (2,2,1,'通栏广告1','image',NULL,1,123,2,NULL,NULL,'1');
INSERT INTO `jc_advertising` VALUES (3,3,1,'视频广告上','image',NULL,1,0,0,NULL,NULL,'1');
INSERT INTO `jc_advertising` VALUES (4,4,1,'视频广告下','image',NULL,1,0,0,NULL,NULL,'1');
INSERT INTO `jc_advertising` VALUES (5,5,1,'留言板本周热点广告','image',NULL,1,0,0,'2014-07-19','2014-07-01','1');
DROP TABLE IF EXISTS `jc_advertising_attr`;
CREATE TABLE `jc_advertising_attr` (
`advertising_id` int(11) NOT NULL,
`attr_name` varchar(50) NOT NULL COMMENT '名称',
`attr_value` varchar(255) default NULL COMMENT '值',
KEY `fk_jc_params_advertising` (`advertising_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='CMS广告属性表';
INSERT INTO `jc_advertising_attr` VALUES (1,'image_title','查看JEECMS官方网站');
INSERT INTO `jc_advertising_attr` VALUES (1,'image_url','/v6/u/cms/www/201404/30140543hzlx.gif');
INSERT INTO `jc_advertising_attr` VALUES (1,'image_target','_blank');
INSERT INTO `jc_advertising_attr` VALUES (1,'image_link','http://www.jeecms.com');
INSERT INTO `jc_advertising_attr` VALUES (1,'image_width','735');
INSERT INTO `jc_advertising_attr` VALUES (1,'image_height','70');
INSERT INTO `jc_advertising_attr` VALUES (2,'image_title','JEECMS官方网站');
INSERT INTO `jc_advertising_attr` VALUES (2,'image_url','/r/cms/www/red/img/banner1.jpg');
INSERT INTO `jc_advertising_attr` VALUES (2,'image_target','_blank');
INSERT INTO `jc_advertising_attr` VALUES (2,'image_link','http://www.jeecms.com');
INSERT INTO `jc_advertising_attr` VALUES (2,'image_width','960');
INSERT INTO `jc_advertising_attr` VALUES (2,'image_height','60');
INSERT INTO `jc_advertising_attr` VALUES (3,'image_height','89');
INSERT INTO `jc_advertising_attr` VALUES (3,'image_link','http://');
INSERT INTO `jc_advertising_attr` VALUES (3,'image_target','_
java开源论坛jeebbs v7.0 系统安装包.zip
5星 · 超过95%的资源 78 浏览量
2023-06-15
17:07:36
上传
评论
收藏 64.39MB ZIP 举报 
java开源论坛jeebbs v7.0 系统安装包.zip （2000个子文件） 
.#add.html.1.1 2KB .#edit.html.1.1 2KB .#user_left.html.1.1 2KB .#member_edit.html.1.1 2KB .#reply.html.1.1 2KB .#messages_zh_CN.properties.1.2 42KB .#ContentMngImpl.java.1.2 25KB .#top.html.1.2 8KB .#Content.hbm.xml.1.2 4KB ContentAct.class 48KB ContentMngImpl.class 36KB ContentDaoImpl.class 30KB Content.class 28KB DirectiveAct.class 23KB Channel.class 23KB MessageAct.class 21KB CmsMessageAct.class 21KB CmsStatisticAct.class 20KB ChannelAct.class 20KB TemplateAct.class 19KB CmsUserMngImpl.class 19KB UeditorAct.class 18KB UeditorAct.class 17KB ImageInfo.class 17KB CmsAcquisitionAct.class 17KB AcquisitionSvcImpl$AcquisitionThread.class 17KB MysqlDataAct.class 16KB CmsSiteFlowCacheImpl.class 16KB AbstractContentMemberAct.class 16KB PlugAct.class 15KB CmsVoteTopicAct.class 15KB ChannelMngImpl.class 15KB CmsSqlserverDataBackDaoImpl.class 14KB StaticPageDaoImpl.class 14KB BaseCmsAcquisition.class 14KB AbstractContentDirective.class 14KB CmsAdvertisingAct.class 14KB ResourceAct.class 14KB CmsTaskAct.class 14KB CmsConfigAct.class 14KB BaseContent.class 14KB CmsUser.class 14KB CmsAdminGlobalAct.class 14KB WeiXinSvcImpl.class 13KB CmsResourceMngImpl.class 13KB CmsAdminLocalAct.class 13KB FrontUtils.class 13KB CmsTopicAct.class 13KB ContributeAct.class 13KB CmsRoleAct.class 13KB CmsMemberAct.class 12KB VoteAct.class 12KB RegisterAct.class 12KB BaseCmsUser.class 12KB FckAct.class 12KB FckAct.class 12KB CmsFileAct.class 12KB CmsAcquisitionMngImpl.class 12KB CmsAuthenticationFilter.class 12KB CmsModelItemAct.class 12KB ImageUploadAct.class 11KB UnifiedUserMngImpl.class 11KB CmsGuestbookAct.class 11KB CmsSiteAccessDaoImpl.class 11KB CommonUpload.class 11KB BaseCmsSite.class 11KB LuceneContentSvcImpl.class 11KB CmsGroupAct.class 11KB TreeIntercptor.class 11KB Finder.class 11KB AdminContextInterceptor.class 11KB CmsOracleDataBackDaoImpl.class 10KB BaseChannelExt.class 10KB ResumeAct.class 10KB CmsFriendlinkAct.class 10KB ThirdLoginAct.class 10KB DynamicPageAct.class 10KB CmsDb2DataBackMngImpl.class 10KB CmsDictionaryAct.class 10KB StaticPageSvcImpl.class 10KB DirectiveUtils.class 9KB CmsCommentMngImpl.class 9KB StaticAct.class 9KB CmsSiteAct.class 9KB CmsOriginAct.class 9KB CmsCommentAct.class 9KB ContentMng.class 9KB CmsStatisticSvcImpl.class 9KB CmsAdvertisingSpaceAct.class 9KB CommentAct.class 9KB CmsGuestbookCtgAct.class 9KB BaseChannel.class 8KB BaseCmsConfig.class 8KB CmsSite.class 8KB ContentTagAct.class 8KB LuceneContent.class 8KB CmsVoteTopicMngImpl.class 8KB CmsSearchWordsAct.class 8KB CmsSiteAccessStatisticDaoImpl.class 8KB ImageUploadAct.class 8KB共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
米唐糖儿2023-06-18#完美解决问题 #运行顺畅
