/* Navicat Premium Data Transfer Source Server : 10.2.2.16 Source Server Type : MySQL Source Server Version : 50728 Source Host : 10.2.2.16:3306 Source Schema : water_service Target Server Type : MySQL Target Server Version : 50728 File Encoding : 65001 Date: 18/12/2024 09:41:03 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for feedback -- ---------------------------- DROP TABLE IF EXISTS `feedback`; CREATE TABLE `feedback` ( `id` int(11) NOT NULL AUTO_INCREMENT, `telphone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名字', `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱', `area` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '区', `address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地址', `ptype` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型（在线咨询、意见、投诉、服务咨询）', `ftype` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `contents` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内容', `status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态（0：未处理 0.5：已受理 1：已处理）', `publictime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发布时间', `feedtime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '反馈时间', `isread` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '是否已读（0：未读 ，1：已读）', `isshow` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '是否显示改内容（0：不显示 ，1：显示）', `feedcontent` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '反馈内容', `source` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '来源（phone，web）', `levels` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `userid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户id', `street` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '街道', `community` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '小区', `building` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '楼栋', `unit` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '单元', `room` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '室', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 368 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_account_draw -- ---------------------------- DROP TABLE IF EXISTS `jc_account_draw`; CREATE TABLE `jc_account_draw` ( `account_draw_id` int(11) NOT NULL AUTO_INCREMENT, `draw_user_id` int(11) NOT NULL DEFAULT 0 COMMENT '提现申请者', `apply_account` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '申请账户（微信号或支付宝账户）', `apply_amount` double NOT NULL DEFAULT 0 COMMENT '提现申请金额', `apply_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '处理状态(0申请中 1申请成功待支付 2申请失败 3提现成功)', `account_pay_id` int(11) NULL DEFAULT NULL COMMENT '申请成功后支付ID', `apply_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '申请时间', PRIMARY KEY (`account_draw_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户账户提现申请' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_account_pay -- ---------------------------- DROP TABLE IF EXISTS `jc_account_pay`; CREATE TABLE `jc_account_pay` ( `account_pay_id` bigint(20) NOT NULL AUTO_INCREMENT, `draw_num` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '内部流水号', `pay_user_id` int(11) NOT NULL DEFAULT 0 COMMENT '支付者', `draw_user_id` int(11) NOT NULL DEFAULT 0 COMMENT '提现者', `pay_account` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '支出账户', `draw_account` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '收入账户(微信账户名)', `pay_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '支付时间', `weixin_num` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信流水号', `alipay_num` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '支付宝流水号', PRIMARY KEY (`account_pay_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户账户提现支付' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_acquisition -- ---------------------------- 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) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '采集名称', `start_time` datetime NULL DEFAULT NULL COMMENT '开始时间', `end_time` datetime NULL 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) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'GBK' COMMENT '页面编码', `plan_list` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '采集列表', `dynamic_addr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '动态地址', `dynamic_start` int(11) NULL DEFAULT NULL COMMENT '页码开始', `dynamic_end` int(11) NULL DEFAULT NULL COMMENT '页码结束', `linkset_start` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容链接区开始', `linkset_end` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容链接区结束', `link_start` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容链接开始', `link_end` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容链接结束', `title_start` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题开始', `title_end` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题结束', `keywords_start` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关键字开始', `keywords_end` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关键字结束', `description_start` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述开始', `description_end` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述结束', `content_start` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容开始', `content_end` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容结束', `pagination_start` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容分页开始', `pagination_end` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容分页结束', `queue` int(11) NOT NULL DEFAULT 0 COMMENT '队列', `repeat_check_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'NONE' COMMENT '重复类型', `img_acqu` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否采集图片', `content_prefix` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容地址补全url', `img_prefix` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片地址补全url', `view_start` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '浏览量开始', `view_end` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '浏览量结束', `view_id_start` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'id前缀', `view_id_end` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'id后缀', `view_link` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '浏览量动态访问地址', `releaseTime_start` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发布时间开始', `releaseTime_end` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发布时间结束', `author_start` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作者开始', `author_end` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作者结束', `origin_start` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来源开始', `origin_end` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来源结束', `releaseTime_format` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发布时间格式', `origin_appoint` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '指定来源', PRIMARY KEY (`acquisition_id`) USING BTREE, INDEX `fk_jc_acquisition_channel`(`channel_id`) USING BTREE, INDEX `fk_jc_acquisition_contenttype`(`type_id`) USING BTREE, INDEX `fk_jc_acquisition_site`(`site_id`) USING BTREE, INDEX `fk_jc_acquisition_user`(`user_id`) USING BTREE, CONSTRAINT `fk_jc_acquisition_channel` FOREIGN KEY (`channel_id`) REFERENCES `jc_channel` (`channel_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_acquisition_contenttype` FOREIGN KEY (`type_id`) REFERENCES `jc_content_type` (`type_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_acquisition_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_acquisition_user` FOREIGN KEY (`user_id`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS采集表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_acquisition_history -- ---------------------------- DROP TABLE IF EXISTS `jc_acquisition_history`; CREATE TABLE `jc_acquisition_history` ( `history_id` int(11) NOT NULL AUTO_INCREMENT, `channel_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '栏目地址', `content_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '内容地址', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题', `description` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '描述', `acquisition_id` int(11) NULL DEFAULT NULL COMMENT '采集源', `content_id` int(11) NULL DEFAULT NULL COMMENT '内容', PRIMARY KEY (`history_id`) USING BTREE, INDEX `fk_acquisition_history_acquisition`(`acquisition_id`) USING BTREE, CONSTRAINT `fk_jc_history_acquisition` FOREIGN KEY (`acquisition_id`) REFERENCES `jc_acquisition` (`acquisition_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '采集历史记录表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_acquisition_temp -- ---------------------------- DROP TABLE IF EXISTS `jc_acquisition_temp`; CREATE TABLE `jc_acquisition_temp` ( `temp_id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NULL DEFAULT NULL, `channel_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '栏目地址', `content_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '内容地址', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题', `finish_percent` int(3) NOT NULL DEFAULT 0 COMMENT '百分比', `description` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '描述', `seq` int(3) NOT NULL DEFAULT 0 COMMENT '顺序', PRIMARY KEY (`temp_id`) USING BTREE, INDEX `fk_jc_temp_site`(`site_id`) USING BTREE, CONSTRAINT `fk_jc_temp_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '采集进度临时表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_advertising -- ---------------------------- 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) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '广告名称', `category` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '广告类型', `ad_code` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL 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 NULL DEFAULT NULL COMMENT '开始时间', `end_time` date NULL DEFAULT NULL COMMENT '结束时间', `is_enabled` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1' COMMENT '是否启用', PRIMARY KEY (`advertising_id`) USING BTREE, INDEX `fk_jc_advertising_site`(`site_id`) USING BTREE, INDEX `fk_jc_space_advertising`(`adspace_id`) USING BTREE, CONSTRAINT `fk_jc_advertising_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_space_advertising` FOREIGN KEY (`adspace_id`) REFERENCES `jc_advertising_space` (`adspace_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS广告表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_advertising_attr -- ---------------------------- DROP TABLE IF EXISTS `jc_advertising_attr`; CREATE TABLE `jc_advertising_attr` ( `advertising_id` int(11) NOT NULL, `attr_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `attr_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '值', INDEX `fk_jc_params_advertising`(`advertising_id`) USING BTREE, CONSTRAINT `fk_jc_params_advertising` FOREIGN KEY (`advertising_id`) REFERENCES `jc_advertising` (`advertising_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS广告属性表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_advertising_space -- ---------------------------- DROP TABLE IF EXISTS `jc_advertising_space`; CREATE TABLE `jc_advertising_space` ( `adspace_id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL, `ad_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述', `is_enabled` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '是否启用', PRIMARY KEY (`adspace_id`) USING BTREE, INDEX `fk_jc_adspace_site`(`site_id`) USING BTREE, CONSTRAINT `fk_jc_adspace_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS广告版位表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_api_account -- ---------------------------- DROP TABLE IF EXISTS `jc_api_account`; CREATE TABLE `jc_api_account` ( `id` int(11) NOT NULL AUTO_INCREMENT, `app_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'appId', `app_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'appKey', `aes_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'AES加解密密钥', `disabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否禁用', `iv_key` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'AES iv key', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'API应用账户' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_api_info -- ---------------------------- DROP TABLE IF EXISTS `jc_api_info`; CREATE TABLE `jc_api_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `api_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '接口名称', `api_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '接口URL', `api_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '接口代码', `disabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否禁用', `limit_call_day` int(11) NOT NULL DEFAULT 0 COMMENT '每日限制调用次数(0无限制)', `call_total_count` int(11) NOT NULL DEFAULT 0 COMMENT '总调用次数', `call_month_count` int(11) NOT NULL DEFAULT 0 COMMENT '月调用次数', `call_week_count` int(11) NOT NULL DEFAULT 0 COMMENT '周调用次数', `call_day_count` int(11) NOT NULL DEFAULT 0 COMMENT '日调用次数', `last_call_time` timestamp NULL DEFAULT NULL COMMENT '最后一次调用时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 77 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'API接口信息' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_api_record -- ---------------------------- DROP TABLE IF EXISTS `jc_api_record`; CREATE TABLE `jc_api_record` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `api_account` int(11) NOT NULL DEFAULT 0 COMMENT '调用的账户', `call_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '调用的IP', `api_info_id` int(11) NULL DEFAULT 0 COMMENT '接口', `api_call_time` datetime NOT NULL COMMENT '调用时间', `call_time_stamp` bigint(20) NOT NULL DEFAULT 0 COMMENT '调用的时间戳', `sign` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '签名数据(不允许重复调用)', PRIMARY KEY (`id`) USING BTREE, INDEX `fk_api_record_account`(`api_account`) USING BTREE, INDEX `fk_api_info`(`api_info_id`) USING BTREE, INDEX `index_jc_api_record_sign`(`sign`) USING BTREE, CONSTRAINT `fk_api_info` FOREIGN KEY (`api_info_id`) REFERENCES `jc_api_info` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_api_record_account` FOREIGN KEY (`api_account`) REFERENCES `jc_api_account` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'API调用记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_api_user_login -- ---------------------------- DROP TABLE IF EXISTS `jc_api_user_login`; CREATE TABLE `jc_api_user_login` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `session_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'sesssionKey', `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户名', `login_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '登陆时间', `login_count` int(11) NOT NULL DEFAULT 0 COMMENT '登陆次数', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'API用户登录表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_channel -- ---------------------------- DROP TABLE IF EXISTS `jc_channel`; CREATE TABLE `jc_channel` ( `channel_id` int(11) NOT NULL AUTO_INCREMENT, `model_id` int(11) NOT NULL COMMENT '模型ID', `site_id` int(11) NOT NULL COMMENT '站点ID', `parent_id` int(11) NULL DEFAULT NULL COMMENT '父栏目ID', `channel_path` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '访问路径', `lft` int(11) NOT NULL DEFAULT 1 COMMENT '树左边', `rgt` int(11) NOT NULL DEFAULT 2 COMMENT '树右边', `priority` int(11) NOT NULL DEFAULT 10 COMMENT '排列顺序', `has_content` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否有内容', `is_display` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否显示', PRIMARY KEY (`channel_id`) USING BTREE, INDEX `fk_jc_channel_model`(`model_id`) USING BTREE, INDEX `fk_jc_channel_parent`(`parent_id`) USING BTREE, INDEX `fk_jc_channel_site`(`site_id`) USING BTREE, INDEX `index_jc_channel_lft`(`lft`) USING BTREE, INDEX `index_jc_channel_rgt`(`rgt`) USING BTREE, CONSTRAINT `fk_jc_channel_model` FOREIGN KEY (`model_id`) REFERENCES `jc_model` (`model_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_channel_parent` FOREIGN KEY (`parent_id`) REFERENCES `jc_channel` (`channel_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_channel_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 241 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS栏目表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_channel_attr -- ---------------------------- DROP TABLE IF EXISTS `jc_channel_attr`; CREATE TABLE `jc_channel_attr` ( `channel_id` int(11) NOT NULL, `attr_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `attr_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '值', INDEX `fk_jc_attr_channel`(`channel_id`) USING BTREE, CONSTRAINT `fk_jc_attr_channel` FOREIGN KEY (`channel_id`) REFERENCES `jc_channel` (`channel_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS栏目扩展属性表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_channel_count -- ---------------------------- DROP TABLE IF EXISTS `jc_channel_count`; CREATE TABLE `jc_channel_count` ( `channel_id` int(11) NOT NULL, `views` int(11) NOT NULL DEFAULT 0 COMMENT '总访问数', `views_month` int(11) NOT NULL DEFAULT 0 COMMENT '月访问数', `views_week` int(11) NOT NULL DEFAULT 0 COMMENT '周访问数', `views_day` int(11) NOT NULL DEFAULT 0 COMMENT '日访问数', `content_count_total` int(11) NOT NULL DEFAULT 0 COMMENT '内容发布数', `content_count_day` int(11) NOT NULL DEFAULT 0 COMMENT '内容今日发布数', `content_count_week` int(11) NOT NULL DEFAULT 0 COMMENT '内容本周发布数', `content_count_month` int(11) NOT NULL DEFAULT 0 COMMENT '内容本月发布数', `content_count_year` int(11) NOT NULL DEFAULT 0 COMMENT '内容今年发布数', PRIMARY KEY (`channel_id`) USING BTREE, CONSTRAINT `fk_jc_count_channel` FOREIGN KEY (`channel_id`) REFERENCES `jc_channel` (`channel_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS栏目访问量计数表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_channel_ext -- ---------------------------- DROP TABLE IF EXISTS `jc_channel_ext`; CREATE TABLE `jc_channel_ext` ( `channel_id` int(11) NOT NULL, `channel_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `final_step` tinyint(4) NULL DEFAULT 2 COMMENT '终审级别', `after_check` tinyint(4) NULL DEFAULT NULL COMMENT '审核后(1:不能修改删除;2:修改后退回;3:修改后不变)', `is_static_channel` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '是否栏目静态化', `is_static_content` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '是否内容静态化', `is_access_by_dir` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1' COMMENT '是否使用目录访问', `is_list_child` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '是否使用子栏目列表', `page_size` int(11) NOT NULL DEFAULT 20 COMMENT '每页多少条记录', `channel_rule` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '栏目页生成规则', `content_rule` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容页生成规则', `link` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外部链接', `tpl_channel` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '栏目页模板', `tpl_content` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容页模板', `title_img` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '缩略图', `content_img` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容图', `has_title_img` tinyint(1) NOT NULL DEFAULT 0 COMMENT '内容是否有缩略图', `has_content_img` tinyint(1) NOT NULL DEFAULT 0 COMMENT '内容是否有内容图', `title_img_width` int(11) NOT NULL DEFAULT 139 COMMENT '内容标题图宽度', `title_img_height` int(11) NOT NULL DEFAULT 139 COMMENT '内容标题图高度', `content_img_width` int(11) NOT NULL DEFAULT 310 COMMENT '内容内容图宽度', `content_img_height` int(11) NOT NULL DEFAULT 310 COMMENT '内容内容图高度', `comment_control` int(11) NOT NULL DEFAULT 0 COMMENT '评论(0:匿名;1:会员一次;2:关闭,3会员多次)', `allow_updown` tinyint(1) NOT NULL DEFAULT 1 COMMENT '顶踩(true:开放;false:关闭)', `is_blank` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否新窗口打开', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'TITLE', `keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'KEYWORDS', `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'DESCRIPTION', `allow_share` tinyint(1) NOT NULL DEFAULT 0 COMMENT '分享(true:开放;false:关闭)', `allow_score` tinyint(1) NOT NULL DEFAULT 0 COMMENT '评分(true:开放;false:关闭)', `tpl_mobile_channel` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机栏目页模板', PRIMARY KEY (`channel_id`) USING BTREE, CONSTRAINT `fk_jc_ext_channel` FOREIGN KEY (`channel_id`) REFERENCES `jc_channel` (`channel_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS栏目内容表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_channel_model -- ---------------------------- DROP TABLE IF EXISTS `jc_channel_model`; CREATE TABLE `jc_channel_model` ( `channel_id` int(11) NOT NULL, `model_id` int(11) NOT NULL COMMENT '模型id', `tpl_content` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容模板', `priority` int(11) NOT NULL DEFAULT 10 COMMENT '排序', `tpl_mobile_content` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机内容页模板', PRIMARY KEY (`channel_id`, `priority`) USING BTREE, INDEX `fk_jc_model_channel_m`(`model_id`) USING BTREE, CONSTRAINT `fk_jc_channel_model_c` FOREIGN KEY (`channel_id`) REFERENCES `jc_channel` (`channel_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_model_channel_m` FOREIGN KEY (`model_id`) REFERENCES `jc_model` (`model_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '栏目可选内容模型表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_channel_txt -- ---------------------------- DROP TABLE IF EXISTS `jc_channel_txt`; CREATE TABLE `jc_channel_txt` ( `channel_id` int(11) NOT NULL, `txt` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '栏目内容', `txt1` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '扩展内容1', `txt2` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '扩展内容2', `txt3` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '扩展内容3', PRIMARY KEY (`channel_id`) USING BTREE, CONSTRAINT `fk_jc_txt_channel` FOREIGN KEY (`channel_id`) REFERENCES `jc_channel` (`channel_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS栏目文本表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_channel_user -- ---------------------------- DROP TABLE IF EXISTS `jc_channel_user`; CREATE TABLE `jc_channel_user` ( `channel_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, PRIMARY KEY (`channel_id`, `user_id`) USING BTREE, INDEX `fk_jc_channel_user`(`user_id`) USING BTREE, CONSTRAINT `fk_jc_channel_user` FOREIGN KEY (`user_id`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_user_channel` FOREIGN KEY (`channel_id`) REFERENCES `jc_channel` (`channel_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS栏目用户关联表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_chnl_group_contri -- ---------------------------- DROP TABLE IF EXISTS `jc_chnl_group_contri`; CREATE TABLE `jc_chnl_group_contri` ( `channel_id` int(11) NOT NULL, `group_id` int(11) NOT NULL, PRIMARY KEY (`channel_id`, `group_id`) USING BTREE, INDEX `fk_jc_channel_group_c`(`group_id`) USING BTREE, CONSTRAINT `fk_jc_channel_group_c` FOREIGN KEY (`group_id`) REFERENCES `jc_group` (`group_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_group_channel_c` FOREIGN KEY (`channel_id`) REFERENCES `jc_channel` (`channel_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS栏目投稿会员组关联表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_chnl_group_view -- ---------------------------- DROP TABLE IF EXISTS `jc_chnl_group_view`; CREATE TABLE `jc_chnl_group_view` ( `channel_id` int(11) NOT NULL, `group_id` int(11) NOT NULL, PRIMARY KEY (`channel_id`, `group_id`) USING BTREE, INDEX `fk_jc_channel_group_v`(`group_id`) USING BTREE, CONSTRAINT `fk_jc_channel_group_v` FOREIGN KEY (`group_id`) REFERENCES `jc_group` (`group_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_group_channel_v` FOREIGN KEY (`channel_id`) REFERENCES `jc_channel` (`channel_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS栏目浏览会员组关联表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_comment -- ---------------------------- DROP TABLE IF EXISTS `jc_comment`; CREATE TABLE `jc_comment` ( `comment_id` int(11) NOT NULL AUTO_INCREMENT, `comment_user_id` int(11) NULL DEFAULT NULL COMMENT '评论用户ID', `reply_user_id` int(11) NULL DEFAULT NULL COMMENT '回复用户ID', `content_id` int(11) NOT NULL COMMENT '内容ID', `site_id` int(11) NOT NULL COMMENT '站点ID', `create_time` datetime NOT NULL COMMENT '评论时间', `reply_time` datetime NULL DEFAULT NULL COMMENT '回复时间', `ups` smallint(6) NOT NULL DEFAULT 0 COMMENT '支持数', `downs` smallint(6) NOT NULL DEFAULT 0 COMMENT '反对数', `is_recommend` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否推荐', `is_checked` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否审核', `score` int(11) NULL DEFAULT NULL COMMENT '评分', `parent_id` int(11) NULL DEFAULT NULL COMMENT '父级评论', `reply_count` int(11) NULL DEFAULT 0 COMMENT '回复数', PRIMARY KEY (`comment_id`) USING BTREE, INDEX `fk_jc_comment_content`(`content_id`) USING BTREE, INDEX `fk_jc_comment_reply`(`reply_user_id`) USING BTREE, INDEX `fk_jc_comment_site`(`site_id`) USING BTREE, INDEX `fk_jc_comment_user`(`comment_user_id`) USING BTREE, CONSTRAINT `fk_jc_comment_content` FOREIGN KEY (`content_id`) REFERENCES `jc_content` (`content_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_comment_reply` FOREIGN KEY (`reply_user_id`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_comment_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_comment_user` FOREIGN KEY (`comment_user_id`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS评论表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_comment_ext -- ---------------------------- DROP TABLE IF EXISTS `jc_comment_ext`; CREATE TABLE `jc_comment_ext` ( `comment_id` int(11) NOT NULL, `ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'IP地址', `text` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '评论内容', `reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复内容', INDEX `fk_jc_ext_comment`(`comment_id`) USING BTREE, CONSTRAINT `fk_jc_ext_comment` FOREIGN KEY (`comment_id`) REFERENCES `jc_comment` (`comment_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS评论扩展表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_config -- ---------------------------- DROP TABLE IF EXISTS `jc_config`; CREATE TABLE `jc_config` ( `config_id` int(11) NOT NULL, `context_path` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '/JeeCms' COMMENT '部署路径', `servlet_point` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Servlet挂载点', `port` int(11) NULL DEFAULT NULL COMMENT '端口', `db_file_uri` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '/dbfile.svl?n=' COMMENT '数据库附件访问地址', `is_upload_to_db` tinyint(1) NOT NULL DEFAULT 0 COMMENT '上传附件至数据库', `def_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '/JeeCms/r/cms/www/default/no_picture.gif' COMMENT '图片不存在时默认图片', `login_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '/login.jspx' COMMENT '登录地址', `process_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录后处理地址', `mark_on` tinyint(1) NOT NULL DEFAULT 1 COMMENT '开启图片水印', `mark_width` int(11) NOT NULL DEFAULT 120 COMMENT '图片最小宽度', `mark_height` int(11) NOT NULL DEFAULT 120 COMMENT '图片最小高度', `mark_image` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '/r/cms/www/watermark.png' COMMENT '图片水印', `mark_content` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'www.jeecms.com' COMMENT '文字水印内容', `mark_size` int(11) NOT NULL DEFAULT 20 COMMENT '文字水印大小', `mark_color` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '#FF0000' COMMENT '文字水印颜色', `mark_alpha` int(11) NOT NULL DEFAULT 50 COMMENT '水印透明度（0-100）', `mark_position` int(11) NOT NULL DEFAULT 1 COMMENT '水印位置(0-5)', `mark_offset_x` int(11) NOT NULL DEFAULT 0 COMMENT 'x坐标偏移量', `mark_offset_y` int(11) NOT NULL DEFAULT 0 COMMENT 'y坐标偏移量', `count_clear_time` date NOT NULL COMMENT '计数器清除时间', `count_copy_time` datetime NOT NULL COMMENT '计数器拷贝时间', `download_code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'jeecms' COMMENT '下载防盗链md5混淆码', `download_time` int(11) NOT NULL DEFAULT 12 COMMENT '下载有效时间（小时）', `email_host` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮件发送服务器', `email_encoding` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮件发送编码', `email_username` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱用户名', `email_password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱密码', `email_personal` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱发件人', `email_validate` tinyint(1) NULL DEFAULT 0 COMMENT '开启邮箱验证', `view_only_checked` tinyint(1) NOT NULL DEFAULT 0 COMMENT '只有终审才能浏览内容页', `flow_clear_time` date NOT NULL COMMENT '流量统计清除时间', `channel_count_clear_time` date NOT NULL COMMENT '栏目发布内容计数器清除时间', PRIMARY KEY (`config_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS配置表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_config_attr -- ---------------------------- DROP TABLE IF EXISTS `jc_config_attr`; CREATE TABLE `jc_config_attr` ( `config_id` int(11) NOT NULL, `attr_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `attr_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '值', INDEX `fk_jc_attr_config`(`config_id`) USING BTREE, CONSTRAINT `fk_jc_attr_config` FOREIGN KEY (`config_id`) REFERENCES `jc_config` (`config_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS配置属性表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_config_content_charge -- ---------------------------- DROP TABLE IF EXISTS `jc_config_content_charge`; CREATE TABLE `jc_config_content_charge` ( `config_content_id` int(11) NOT NULL DEFAULT 1, `weixin_appid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信服务号APPID', `weixin_secret` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信公众号secret', `weixin_account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信支付商户号', `weixin_password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '微信支付商户密钥', `alipay_partner_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '支付宝合作者ID', `alipay_account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '支付宝签约账户', `alipay_key` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '支付宝公钥', `alipay_appid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '支付宝应用ID', `alipay_public_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '支付宝RSA公钥', `alipay_private_key` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '支付宝RSA私钥', `charge_ratio` double(5, 2) NOT NULL DEFAULT 0.00 COMMENT '抽成比例', `min_draw_amount` double(11, 2) NOT NULL DEFAULT 1.00 COMMENT '最小提现额', `commission_total` double(15, 4) NOT NULL DEFAULT 0.0000 COMMENT '佣金抽成总金额', `commission_year` double(15, 4) NOT NULL DEFAULT 0.0000 COMMENT '佣金抽成年金额', `commission_month` double(15, 4) NOT NULL DEFAULT 0.0000 COMMENT '佣金抽成月金额', `commission_day` double(15, 4) NOT NULL DEFAULT 0.0000 COMMENT '佣金抽成日金额', `last_buy_time` timestamp NULL DEFAULT NULL COMMENT '最后购买时间', `pay_transfer_password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '5f4dcc3b5aa765d61d8327deb882cf99' COMMENT '转账支付密码（管理后台验证）', `transfer_api_password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '企业转账接口API密钥', `reward_min` double(11, 2) NOT NULL DEFAULT 0.00 COMMENT '打赏随机数最小值', `reward_max` double(11, 2) NOT NULL DEFAULT 0.00 COMMENT '打赏随机数最小值', `reward_pattern` tinyint(1) NOT NULL DEFAULT 0 COMMENT '打赏模式(0随机 1固定)', PRIMARY KEY (`config_content_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '内容收费配置' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_config_item -- ---------------------------- DROP TABLE IF EXISTS `jc_config_item`; CREATE TABLE `jc_config_item` ( `modelitem_id` int(11) NOT NULL AUTO_INCREMENT, `config_id` int(11) NOT NULL, `field` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段', `item_label` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `priority` int(11) NOT NULL DEFAULT 70 COMMENT '排列顺序', `def_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '默认值', `opt_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '可选项', `text_size` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '长度', `area_rows` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文本行数', `area_cols` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文本列数', `help` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '帮助信息', `help_position` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '帮助位置', `data_type` int(11) NOT NULL DEFAULT 1 COMMENT '数据类型 \"1\":\"字符串文本\",\"2\":\"整型文本\",\"3\":\"浮点型文本\",\"4\":\"文本区\",\"5\":\"日期\",\"6\":\"下拉列表\",\"7\":\"复选框\",\"8\":\"单选框\"', `is_required` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否必填', `category` int(11) NOT NULL DEFAULT 1 COMMENT '模型项目所属分类（1注册模型）', PRIMARY KEY (`modelitem_id`) USING BTREE, INDEX `fk_jc_item_config`(`config_id`) USING BTREE, CONSTRAINT `fk_jc_item_config` FOREIGN KEY (`config_id`) REFERENCES `jc_config` (`config_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS配置模型项表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_content -- ---------------------------- DROP TABLE IF EXISTS `jc_content`; CREATE TABLE `jc_content` ( `content_id` int(11) NOT NULL AUTO_INCREMENT, `channel_id` int(11) NOT NULL COMMENT '栏目ID', `user_id` int(11) NOT NULL COMMENT '用户ID', `type_id` int(11) NOT NULL COMMENT '属性ID', `model_id` int(11) NOT NULL COMMENT '模型ID', `site_id` int(11) NOT NULL COMMENT '站点ID', `sort_date` datetime NOT NULL COMMENT '排序日期', `top_level` tinyint(4) NOT NULL DEFAULT 0 COMMENT '固顶级别', `has_title_img` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否有标题图', `is_recommend` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否推荐', `status` tinyint(4) NOT NULL DEFAULT 2 COMMENT '状态(0:草稿;1:审核中;2:审核通过;3:回收站;4:投稿;5:归档)', `views_day` int(11) NOT NULL DEFAULT 0 COMMENT '日访问数', `comments_day` smallint(6) NOT NULL DEFAULT 0 COMMENT '日评论数', `downloads_day` smallint(6) NOT NULL DEFAULT 0 COMMENT '日下载数', `ups_day` smallint(6) NOT NULL DEFAULT 0 COMMENT '日顶数', `score` int(11) NOT NULL DEFAULT 0 COMMENT '得分', `recommend_level` tinyint(4) NOT NULL DEFAULT 0 COMMENT '推荐级别', PRIMARY KEY (`content_id`) USING BTREE, INDEX `fk_jc_content_site`(`site_id`) USING BTREE, INDEX `fk_jc_content_type`(`type_id`) USING BTREE, INDEX `fk_jc_content_user`(`user_id`) USING BTREE, INDEX `fk_jc_contentchannel`(`channel_id`) USING BTREE, INDEX `fk_jc_content_model`(`model_id`) USING BTREE, INDEX `index_jc_content_top_level_sort`(`top_level`, `sort_date`) USING BTREE, INDEX `index_jc_content_status`(`status`) USING BTREE, INDEX `index_jc_content_sort_date`(`sort_date`) USING BTREE, INDEX `index_jc_content_is_recommend`(`is_recommend`) USING BTREE, INDEX `index_jc_content_recommend_level`(`recommend_level`) USING BTREE, CONSTRAINT `fk_jc_content_model` FOREIGN KEY (`model_id`) REFERENCES `jc_model` (`model_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_content_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_content_type` FOREIGN KEY (`type_id`) REFERENCES `jc_content_type` (`type_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_content_user` FOREIGN KEY (`user_id`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_contentchannel` FOREIGN KEY (`channel_id`) REFERENCES `jc_channel` (`channel_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 6272 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS内容表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_content_attachment -- ---------------------------- DROP TABLE IF EXISTS `jc_content_attachment`; CREATE TABLE `jc_content_attachment` ( `content_id` int(11) NOT NULL, `priority` int(11) NOT NULL COMMENT '排列顺序', `attachment_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '附件路径', `attachment_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '附件名称', `filename` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名', `download_count` int(11) NOT NULL DEFAULT 0 COMMENT '下载次数', INDEX `fk_jc_attachment_content`(`content_id`) USING BTREE, CONSTRAINT `fk_jc_attachment_content` FOREIGN KEY (`content_id`) REFERENCES `jc_content` (`content_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS内容附件表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_content_attr -- ---------------------------- DROP TABLE IF EXISTS `jc_content_attr`; CREATE TABLE `jc_content_attr` ( `content_id` int(11) NOT NULL, `attr_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `attr_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '值', INDEX `fk_jc_attr_content`(`content_id`) USING BTREE, CONSTRAINT `fk_jc_attr_content` FOREIGN KEY (`content_id`) REFERENCES `jc_content` (`content_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS内容扩展属性表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_content_buy -- ---------------------------- DROP TABLE IF EXISTS `jc_content_buy`; CREATE TABLE `jc_content_buy` ( `content_buy_id` bigint(20) NOT NULL AUTO_INCREMENT, `order_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '订单号', `content_id` int(11) NOT NULL COMMENT '内容ID', `buy_user_id` int(11) NULL DEFAULT NULL COMMENT '购买用户ID', `author_user_id` int(11) NOT NULL COMMENT '笔者ID', `charge_amount` double(11, 2) NOT NULL DEFAULT 0.00 COMMENT '成交金额', `author_amount` double(11, 4) NOT NULL DEFAULT 0.0000 COMMENT '笔者所得', `plat_amount` double(11, 4) NOT NULL DEFAULT 0.0000 COMMENT '平台所得', `buy_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '成交时间', `has_paid_author` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已经结算给作者(0未结算 1已经结算)', `order_num_weixin` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信支付订单号', `order_num_alipay` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '支付宝订单号', `charge_reward` tinyint(1) NOT NULL DEFAULT 1 COMMENT '模式 1收费 2打赏', PRIMARY KEY (`content_buy_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '收费文章购买记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_content_channel -- ---------------------------- DROP TABLE IF EXISTS `jc_content_channel`; CREATE TABLE `jc_content_channel` ( `channel_id` int(11) NOT NULL, `content_id` int(11) NOT NULL, PRIMARY KEY (`channel_id`, `content_id`) USING BTREE, INDEX `fk_jc_channel_content`(`content_id`) USING BTREE, CONSTRAINT `fk_jc_channel_content` FOREIGN KEY (`content_id`) REFERENCES `jc_content` (`content_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_content_channel` FOREIGN KEY (`channel_id`) REFERENCES `jc_channel` (`channel_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS内容栏目关联表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_content_charge -- ---------------------------- DROP TABLE IF EXISTS `jc_content_charge`; CREATE TABLE `jc_content_charge` ( `content_id` int(11) NOT NULL DEFAULT 0, `charge_amount` double(11, 2) NOT NULL DEFAULT 0.00 COMMENT '收费金额', `total_amount` double(11, 2) NOT NULL DEFAULT 0.00 COMMENT '已累计收费', `year_amount` double(11, 2) NOT NULL DEFAULT 0.00 COMMENT '年金额', `month_amount` double(11, 2) NOT NULL DEFAULT 0.00 COMMENT '月金额', `day_amount` double(11, 2) NOT NULL DEFAULT 0.00 COMMENT '日金额', `last_buy_time` timestamp NULL DEFAULT NULL COMMENT '最后购买时间', `charge_reward` tinyint(1) NOT NULL DEFAULT 0 COMMENT '模式，1收费 2打赏', `reward_random_min` double(11, 2) NOT NULL DEFAULT 0.00 COMMENT '随机 最小值', `reward_random_max` double(11, 2) NOT NULL DEFAULT 0.00 COMMENT '随机 最大值', `reward_pattern` tinyint(1) NOT NULL DEFAULT 0 COMMENT '打赏模式(0随机 1固定)', PRIMARY KEY (`content_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '收费内容配置' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_content_check -- ---------------------------- DROP TABLE IF EXISTS `jc_content_check`; CREATE TABLE `jc_content_check` ( `content_id` int(11) NOT NULL, `check_step` tinyint(4) NOT NULL DEFAULT 0 COMMENT '审核步数', `check_opinion` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核意见', `is_rejected` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否退回', `reviewer` int(11) NULL DEFAULT NULL COMMENT '终审者', `check_date` datetime NULL DEFAULT NULL COMMENT '终审时间', PRIMARY KEY (`content_id`) USING BTREE, INDEX `fk_jc_content_check_user`(`reviewer`) USING BTREE, CONSTRAINT `fk_jc_check_content` FOREIGN KEY (`content_id`) REFERENCES `jc_content` (`content_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_content_check_user` FOREIGN KEY (`reviewer`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS内容审核信息表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_content_count -- ---------------------------- DROP TABLE IF EXISTS `jc_content_count`; CREATE TABLE `jc_content_count` ( `content_id` int(11) NOT NULL, `views` int(11) NOT NULL DEFAULT 0 COMMENT '总访问数', `views_month` int(11) NOT NULL DEFAULT 0 COMMENT '月访问数', `views_week` int(11) NOT NULL DEFAULT 0 COMMENT '周访问数', `views_day` int(11) NOT NULL DEFAULT 0 COMMENT '日访问数', `comments` int(11) NOT NULL DEFAULT 0 COMMENT '总评论数', `comments_month` int(11) NOT NULL DEFAULT 0 COMMENT '月评论数', `comments_week` smallint(6) NOT NULL DEFAULT 0 COMMENT '周评论数', `comments_day` smallint(6) NOT NULL DEFAULT 0 COMMENT '日评论数', `downloads` int(11) NOT NULL DEFAULT 0 COMMENT '总下载数', `downloads_month` int(11) NOT NULL DEFAULT 0 COMMENT '月下载数', `downloads_week` smallint(6) NOT NULL DEFAULT 0 COMMENT '周下载数', `downloads_day` smallint(6) NOT NULL DEFAULT 0 COMMENT '日下载数', `ups` int(11) NOT NULL DEFAULT 0 COMMENT '总顶数', `ups_month` int(11) NOT NULL DEFAULT 0 COMMENT '月顶数', `ups_week` smallint(6) NOT NULL DEFAULT 0 COMMENT '周顶数', `ups_day` smallint(6) NOT NULL DEFAULT 0 COMMENT '日顶数', `downs` int(11) NOT NULL DEFAULT 0 COMMENT '总踩数', PRIMARY KEY (`content_id`) USING BTREE, INDEX `index_jc_content_count_views_day`(`views_day`) USING BTREE, INDEX `index_jc_content_count_views_week`(`views_week`) USING BTREE, INDEX `index_jc_content_count_views_month`(`views_month`) USING BTREE, INDEX `index_jc_content_count_views`(`views`) USING BTREE, INDEX `index_jc_content_count_comments_day`(`comments_day`) USING BTREE, INDEX `index_jc_content_count_comments_month`(`comments_month`) USING BTREE, INDEX `index_jc_content_count_comments_week`(`comments_week`) USING BTREE, INDEX `index_jc_content_count_comments`(`comments`) USING BTREE, INDEX `index_jc_content_count_downloads_day`(`downloads_day`) USING BTREE, INDEX `index_jc_content_count_downloads_month`(`downloads_month`) USING BTREE, INDEX `index_jc_content_count_downloads_week`(`downloads_week`) USING BTREE, INDEX `index_jc_content_count_downloads`(`downloads`) USING BTREE, INDEX `index_jc_content_count_ups_day`(`ups_day`) USING BTREE, INDEX `index_jc_content_count_ups_week`(`ups_week`) USING BTREE, INDEX `index_jc_content_count_ups_month`(`ups_month`) USING BTREE, INDEX `index_jc_content_count_ups`(`ups`) USING BTREE, CONSTRAINT `fk_jc_count_content` FOREIGN KEY (`content_id`) REFERENCES `jc_content` (`content_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS内容计数表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_content_ext -- ---------------------------- DROP TABLE IF EXISTS `jc_content_ext`; CREATE TABLE `jc_content_ext` ( `content_id` int(11) NOT NULL, `title` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标题', `short_title` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简短标题', `author` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作者', `origin` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来源', `origin_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来源链接', `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述', `release_date` datetime NOT NULL COMMENT '发布日期', `media_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '媒体路径', `media_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '媒体类型', `title_color` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题颜色', `is_bold` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否加粗', `title_img` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题图片', `content_img` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容图片', `type_img` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型图片', `link` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外部链接', `tpl_content` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '指定模板', `need_regenerate` tinyint(1) NOT NULL DEFAULT 1 COMMENT '需要重新生成静态页', `tpl_mobile_content` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机内容页模板', `toplevel_date` datetime NULL DEFAULT NULL COMMENT '固顶到期日期', `pigeonhole_date` datetime NULL DEFAULT NULL COMMENT '归档日期', PRIMARY KEY (`content_id`) USING BTREE, CONSTRAINT `fk_jc_ext_content` FOREIGN KEY (`content_id`) REFERENCES `jc_content` (`content_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS内容扩展表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_content_group_view -- ---------------------------- DROP TABLE IF EXISTS `jc_content_group_view`; CREATE TABLE `jc_content_group_view` ( `content_id` int(11) NOT NULL, `group_id` int(11) NOT NULL, PRIMARY KEY (`content_id`, `group_id`) USING BTREE, INDEX `fk_jc_content_group_v`(`group_id`) USING BTREE, CONSTRAINT `fk_jc_content_group_v` FOREIGN KEY (`group_id`) REFERENCES `jc_group` (`group_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_group_content_v` FOREIGN KEY (`content_id`) REFERENCES `jc_content` (`content_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS内容浏览会员组关联表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_content_picture -- ---------------------------- DROP TABLE IF EXISTS `jc_content_picture`; CREATE TABLE `jc_content_picture` ( `content_id` int(11) NOT NULL, `priority` int(11) NOT NULL COMMENT '排列顺序', `img_path` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '图片地址', `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述', PRIMARY KEY (`content_id`, `priority`) USING BTREE, CONSTRAINT `fk_jc_picture_content` FOREIGN KEY (`content_id`) REFERENCES `jc_content` (`content_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS内容图片表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_content_record -- ---------------------------- DROP TABLE IF EXISTS `jc_content_record`; CREATE TABLE `jc_content_record` ( `content_record_id` bigint(20) NOT NULL AUTO_INCREMENT, `content_id` int(11) NOT NULL DEFAULT 0 COMMENT '文章ID', `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '操作人', `operate_time` datetime NOT NULL COMMENT '操作时间', `operate_type` tinyint(2) NOT NULL DEFAULT 0 COMMENT '0 新增 1修改 2审核 3退回 4移动 5生成静态页 6删除到回收站 7归档 8出档 9推送共享', PRIMARY KEY (`content_record_id`) USING BTREE, INDEX `fk_index_jc_content_record_content`(`content_id`) USING BTREE, INDEX `fk_index_jc_content_record_user`(`user_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6386 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文章操作记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_content_reward_fix -- ---------------------------- DROP TABLE IF EXISTS `jc_content_reward_fix`; CREATE TABLE `jc_content_reward_fix` ( `content_id` int(11) NOT NULL DEFAULT 0, `priority` int(11) NOT NULL DEFAULT 10, `reward_fix` double NOT NULL DEFAULT 0 COMMENT '固定值', UNIQUE INDEX `jc_content_reward_fix`(`content_id`, `priority`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '内容打赏设置固定值' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_content_tag -- ---------------------------- DROP TABLE IF EXISTS `jc_content_tag`; CREATE TABLE `jc_content_tag` ( `tag_id` int(11) NOT NULL AUTO_INCREMENT, `tag_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'tag名称', `ref_counter` int(11) NOT NULL DEFAULT 1 COMMENT '被引用的次数', PRIMARY KEY (`tag_id`) USING BTREE, UNIQUE INDEX `ak_tag_name`(`tag_name`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2186 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS内容TAG表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_content_topic -- ---------------------------- DROP TABLE IF EXISTS `jc_content_topic`; CREATE TABLE `jc_content_topic` ( `content_id` int(11) NOT NULL, `topic_id` int(11) NOT NULL, PRIMARY KEY (`content_id`, `topic_id`) USING BTREE, INDEX `fk_jc_content_topic`(`topic_id`) USING BTREE, CONSTRAINT `fk_jc_content_topic` FOREIGN KEY (`topic_id`) REFERENCES `jc_topic` (`topic_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_topic_content` FOREIGN KEY (`content_id`) REFERENCES `jc_content` (`content_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS专题内容关联表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_content_txt -- ---------------------------- DROP TABLE IF EXISTS `jc_content_txt`; CREATE TABLE `jc_content_txt` ( `content_id` int(11) NOT NULL, `txt` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '文章内容', `txt1` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '扩展内容1', `txt2` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '扩展内容2', `txt3` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '扩展内容3', PRIMARY KEY (`content_id`) USING BTREE, CONSTRAINT `fk_jc_txt_content` FOREIGN KEY (`content_id`) REFERENCES `jc_content` (`content_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS内容文本表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_content_type -- ---------------------------- DROP TABLE IF EXISTS `jc_content_type`; CREATE TABLE `jc_content_type` ( `type_id` int(11) NOT NULL, `type_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `img_width` int(11) NULL DEFAULT NULL COMMENT '图片宽', `img_height` int(11) NULL DEFAULT NULL COMMENT '图片高', `has_image` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否有图片', `is_disabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否禁用', PRIMARY KEY (`type_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS内容类型表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_contenttag -- ---------------------------- DROP TABLE IF EXISTS `jc_contenttag`; CREATE TABLE `jc_contenttag` ( `content_id` int(11) NOT NULL, `tag_id` int(11) NOT NULL, `priority` int(11) NOT NULL, INDEX `fk_jc_content_tag`(`tag_id`) USING BTREE, INDEX `fk_jc_tag_content`(`content_id`) USING BTREE, CONSTRAINT `fk_jc_content_tag` FOREIGN KEY (`tag_id`) REFERENCES `jc_content_tag` (`tag_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_tag_content` FOREIGN KEY (`content_id`) REFERENCES `jc_content` (`content_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS内容标签关联表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_department -- ---------------------------- DROP TABLE IF EXISTS `jc_department`; CREATE TABLE `jc_department` ( `depart_id` int(11) NOT NULL AUTO_INCREMENT, `depart_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '部门名称', `site_id` int(11) NULL DEFAULT 0 COMMENT '站点', `priority` int(11) NOT NULL DEFAULT 1 COMMENT '排序', `weights` int(11) NOT NULL DEFAULT 1 COMMENT '权重(值越大，级别越高)', `parent_id` int(11) NULL DEFAULT NULL COMMENT '父级部门ID', PRIMARY KEY (`depart_id`) USING BTREE, INDEX `fk_jc_department_site`(`site_id`) USING BTREE, INDEX `fk_jc_jc_department_parent`(`parent_id`) USING BTREE, CONSTRAINT `fk_jc_jc_department_parent` FOREIGN KEY (`parent_id`) REFERENCES `jc_department` (`depart_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '部门' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_dictionary -- ---------------------------- DROP TABLE IF EXISTS `jc_dictionary`; CREATE TABLE `jc_dictionary` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'name', `value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'value', `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'type', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_directive_tpl -- ---------------------------- DROP TABLE IF EXISTS `jc_directive_tpl`; CREATE TABLE `jc_directive_tpl` ( `tpl_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标签名称', `description` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标签描述', `code` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '标签代码', `user_id` int(11) NOT NULL COMMENT '标签创建者', PRIMARY KEY (`tpl_id`) USING BTREE, INDEX `fk_jc_directive_tpl_user`(`user_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'FComment' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_file -- ---------------------------- DROP TABLE IF EXISTS `jc_file`; CREATE TABLE `jc_file` ( `file_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文件路径', `file_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '文件名字', `file_isvalid` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否有效', `content_id` int(11) NULL DEFAULT NULL COMMENT '内容id', PRIMARY KEY (`file_path`) USING BTREE, INDEX `fk_jc_file_content`(`content_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_friendlink -- ---------------------------- DROP TABLE IF EXISTS `jc_friendlink`; CREATE TABLE `jc_friendlink` ( `friendlink_id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL, `friendlinkctg_id` int(11) NOT NULL, `site_name` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '网站名称', `domain` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '网站地址', `logo` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标', `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '站长邮箱', `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述', `views` int(11) NOT NULL DEFAULT 0 COMMENT '点击次数', `is_enabled` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1' COMMENT '是否显示', `priority` int(11) NOT NULL DEFAULT 10 COMMENT '排列顺序', PRIMARY KEY (`friendlink_id`) USING BTREE, INDEX `fk_jc_ctg_friendlink`(`friendlinkctg_id`) USING BTREE, INDEX `fk_jc_friendlink_site`(`site_id`) USING BTREE, CONSTRAINT `fk_jc_ctg_friendlink` FOREIGN KEY (`friendlinkctg_id`) REFERENCES `jc_friendlink_ctg` (`friendlinkctg_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_friendlink_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS友情链接' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_friendlink_ctg -- ---------------------------- DROP TABLE IF EXISTS `jc_friendlink_ctg`; CREATE TABLE `jc_friendlink_ctg` ( `friendlinkctg_id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL, `friendlinkctg_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `priority` int(11) NOT NULL DEFAULT 10 COMMENT '排列顺序', PRIMARY KEY (`friendlinkctg_id`) USING BTREE, INDEX `fk_jc_friendlinkctg_site`(`site_id`) USING BTREE, CONSTRAINT `fk_jc_friendlinkctg_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS友情链接类别' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_group -- ---------------------------- DROP TABLE IF EXISTS `jc_group`; CREATE TABLE `jc_group` ( `group_id` int(11) NOT NULL AUTO_INCREMENT, `group_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `priority` int(11) NOT NULL DEFAULT 10 COMMENT '排列顺序', `need_captcha` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否需要验证码', `need_check` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否需要审核', `allow_per_day` int(11) NOT NULL DEFAULT 4096 COMMENT '每日允许上传KB', `allow_max_file` int(11) NOT NULL DEFAULT 1024 COMMENT '每个文件最大KB', `allow_suffix` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'jpg,jpeg,gif,png,bmp' COMMENT '允许上传的后缀', `is_reg_def` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否默认会员组', PRIMARY KEY (`group_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS会员组表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_guestbook -- ---------------------------- DROP TABLE IF EXISTS `jc_guestbook`; CREATE TABLE `jc_guestbook` ( `guestbook_id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL, `guestbookctg_id` int(11) NOT NULL, `member_id` int(11) NULL DEFAULT NULL COMMENT '留言会员', `admin_id` int(11) NULL DEFAULT NULL COMMENT '回复管理员', `ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '留言IP', `create_time` datetime NOT NULL COMMENT '留言时间', `replay_time` datetime NULL DEFAULT NULL COMMENT '回复时间', `is_checked` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否审核', `is_recommend` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否推荐', PRIMARY KEY (`guestbook_id`) USING BTREE, INDEX `fk_jc_ctg_guestbook`(`guestbookctg_id`) USING BTREE, INDEX `fk_jc_guestbook_admin`(`admin_id`) USING BTREE, INDEX `fk_jc_guestbook_member`(`member_id`) USING BTREE, INDEX `fk_jc_guestbook_site`(`site_id`) USING BTREE, CONSTRAINT `fk_jc_ctg_guestbook` FOREIGN KEY (`guestbookctg_id`) REFERENCES `jc_guestbook_ctg` (`guestbookctg_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_guestbook_admin` FOREIGN KEY (`admin_id`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_guestbook_member` FOREIGN KEY (`member_id`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_guestbook_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS留言' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_guestbook_ctg -- ---------------------------- DROP TABLE IF EXISTS `jc_guestbook_ctg`; CREATE TABLE `jc_guestbook_ctg` ( `guestbookctg_id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL, `ctg_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `priority` int(11) NOT NULL DEFAULT 10 COMMENT '排列顺序', `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述', PRIMARY KEY (`guestbookctg_id`) USING BTREE, INDEX `fk_jc_guestbookctg_site`(`site_id`) USING BTREE, CONSTRAINT `fk_jc_guestbookctg_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS留言类别' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_guestbook_ext -- ---------------------------- DROP TABLE IF EXISTS `jc_guestbook_ext`; CREATE TABLE `jc_guestbook_ext` ( `guestbook_id` int(11) NOT NULL, `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '留言标题', `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '留言内容', `reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复内容', `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电子邮件', `phone` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话', `qq` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'QQ', INDEX `fk_jc_ext_guestbook`(`guestbook_id`) USING BTREE, CONSTRAINT `fk_jc_ext_guestbook` FOREIGN KEY (`guestbook_id`) REFERENCES `jc_guestbook` (`guestbook_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS留言内容' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_job_apply -- ---------------------------- DROP TABLE IF EXISTS `jc_job_apply`; CREATE TABLE `jc_job_apply` ( `job_apply_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用户id', `content_id` int(11) NOT NULL COMMENT '职位id', `apply_time` datetime NOT NULL COMMENT '申请时间', PRIMARY KEY (`job_apply_id`) USING BTREE, INDEX `fk_jc_job_apply_user`(`user_id`) USING BTREE, INDEX `fk_jc_job_apply_content`(`content_id`) USING BTREE, CONSTRAINT `fk_jc_job_apply_content` FOREIGN KEY (`content_id`) REFERENCES `jc_content` (`content_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_job_apply_user` FOREIGN KEY (`user_id`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '职位申请表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_keyword -- ---------------------------- DROP TABLE IF EXISTS `jc_keyword`; CREATE TABLE `jc_keyword` ( `keyword_id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NULL DEFAULT NULL COMMENT '站点ID', `keyword_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '链接', `is_disabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否禁用', PRIMARY KEY (`keyword_id`) USING BTREE, INDEX `fk_jc_keyword_site`(`site_id`) USING BTREE, CONSTRAINT `fk_jc_keyword_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS内容关键词表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_log -- ---------------------------- DROP TABLE IF EXISTS `jc_log`; CREATE TABLE `jc_log` ( `log_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NULL DEFAULT NULL, `site_id` int(11) NULL DEFAULT NULL, `category` int(11) NOT NULL COMMENT '日志类型', `log_time` datetime NOT NULL COMMENT '日志时间', `ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'IP地址', `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'URL地址', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志标题', `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志内容', PRIMARY KEY (`log_id`) USING BTREE, INDEX `fk_jc_log_site`(`site_id`) USING BTREE, INDEX `fk_jc_log_user`(`user_id`) USING BTREE, CONSTRAINT `fk_jc_log_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_log_user` FOREIGN KEY (`user_id`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 7441 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS日志表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_message -- ---------------------------- DROP TABLE IF EXISTS `jc_message`; CREATE TABLE `jc_message` ( `msg_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '消息id', `msg_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '标题', `msg_content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '站内信息内容', `send_time` timestamp NULL DEFAULT NULL COMMENT '发送时间', `msg_send_user` int(11) NOT NULL DEFAULT 1 COMMENT '发信息人', `msg_receiver_user` int(11) NOT NULL DEFAULT 0 COMMENT '接收人', `site_id` int(11) NOT NULL DEFAULT 1 COMMENT '站点', `msg_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '消息状态0未读，1已读', `msg_box` int(2) NOT NULL DEFAULT 1 COMMENT '消息信箱 0收件箱 1发件箱 2草稿箱 3垃圾箱', PRIMARY KEY (`msg_id`) USING BTREE, INDEX `fk_jc_message_user_send`(`msg_send_user`) USING BTREE, INDEX `fk_jc_message_user_receiver`(`msg_receiver_user`) USING BTREE, INDEX `fk_jc_message_site`(`site_id`) USING BTREE, CONSTRAINT `fk_jc_message_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_message_user_receiver` FOREIGN KEY (`msg_receiver_user`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_message_user_send` FOREIGN KEY (`msg_send_user`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '站内信' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_model -- ---------------------------- DROP TABLE IF EXISTS `jc_model`; CREATE TABLE `jc_model` ( `model_id` int(11) NOT NULL, `model_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `model_path` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '路径', `tpl_channel_prefix` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '栏目模板前缀', `tpl_content_prefix` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容模板前缀', `title_img_width` int(11) NOT NULL DEFAULT 139 COMMENT '栏目标题图宽度', `title_img_height` int(11) NOT NULL DEFAULT 139 COMMENT '栏目标题图高度', `content_img_width` int(11) NOT NULL DEFAULT 310 COMMENT '栏目内容图宽度', `content_img_height` int(11) NOT NULL DEFAULT 310 COMMENT '栏目内容图高度', `priority` int(11) NOT NULL DEFAULT 10 COMMENT '排列顺序', `has_content` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否有内容', `is_disabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否禁用', `is_def` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否默认模型', `is_global` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否全站模型', `site_id` int(11) NULL DEFAULT NULL COMMENT '非全站模型所属站点', PRIMARY KEY (`model_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS模型表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_model_item -- ---------------------------- DROP TABLE IF EXISTS `jc_model_item`; CREATE TABLE `jc_model_item` ( `modelitem_id` int(11) NOT NULL AUTO_INCREMENT, `model_id` int(11) NOT NULL, `field` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段', `item_label` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `priority` int(11) NOT NULL DEFAULT 70 COMMENT '排列顺序', `def_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '默认值', `opt_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '可选项', `text_size` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '长度', `area_rows` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文本行数', `area_cols` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文本列数', `help` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '帮助信息', `help_position` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '帮助位置', `data_type` int(11) NOT NULL DEFAULT 1 COMMENT '数据类型', `is_single` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否独占一行', `is_channel` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否栏目模型项', `is_custom` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否自定义', `is_display` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否显示', `is_required` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否必填项', `image_width` int(11) NULL DEFAULT NULL COMMENT '图片宽度', `image_height` int(11) NULL DEFAULT NULL COMMENT '图片宽度', PRIMARY KEY (`modelitem_id`) USING BTREE, INDEX `fk_jc_item_model`(`model_id`) USING BTREE, CONSTRAINT `fk_jc_item_model` FOREIGN KEY (`model_id`) REFERENCES `jc_model` (`model_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 467 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS模型项表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_origin -- ---------------------------- DROP TABLE IF EXISTS `jc_origin`; CREATE TABLE `jc_origin` ( `origin_id` int(11) NOT NULL AUTO_INCREMENT, `origin_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '来源名称', `ref_count` int(11) NOT NULL DEFAULT 0 COMMENT '来源文章总数', PRIMARY KEY (`origin_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '来源' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_plug -- ---------------------------- DROP TABLE IF EXISTS `jc_plug`; CREATE TABLE `jc_plug` ( `plug_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '插件名称', `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文件路径', `description` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述', `author` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作者', `upload_time` datetime NOT NULL COMMENT '上传时间', `install_time` datetime NULL DEFAULT NULL COMMENT '安装时间', `uninstall_time` datetime NULL DEFAULT NULL COMMENT '卸载时间', `file_conflict` tinyint(1) NOT NULL DEFAULT 0 COMMENT '包含文件是否冲突', `is_used` tinyint(1) NOT NULL DEFAULT 0 COMMENT '使用状态(0未使用,1使用中)', `plug_perms` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '插件权限（,分隔各个权限配置）', `plug_repair` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否修复类插件(0 新功能插件 1修复类)', PRIMARY KEY (`plug_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '插件' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_plug_store_config -- ---------------------------- DROP TABLE IF EXISTS `jc_plug_store_config`; CREATE TABLE `jc_plug_store_config` ( `config_id` int(11) NOT NULL DEFAULT 1, `server_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '接口根地址', `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '应用商店密码', PRIMARY KEY (`config_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_receiver_message -- ---------------------------- DROP TABLE IF EXISTS `jc_receiver_message`; CREATE TABLE `jc_receiver_message` ( `msg_re_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '消息id', `msg_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '标题', `msg_content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '站内信息内容', `send_time` timestamp NULL DEFAULT NULL COMMENT '发送时间', `msg_send_user` int(11) NOT NULL DEFAULT 1 COMMENT '发信息人', `msg_receiver_user` int(11) NOT NULL DEFAULT 0 COMMENT '接收人', `site_id` int(11) NOT NULL DEFAULT 1 COMMENT '站点', `msg_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '消息状态0未读，1已读', `msg_box` int(2) NOT NULL DEFAULT 1 COMMENT '消息信箱 0收件箱 1发件箱 2草稿箱 3垃圾箱', `msg_id` int(11) NULL DEFAULT NULL COMMENT '发信的信件id', PRIMARY KEY (`msg_re_id`) USING BTREE, INDEX `jc_receiver_message_user_send`(`msg_send_user`) USING BTREE, INDEX `jc_receiver_message_user_receiver`(`msg_receiver_user`) USING BTREE, INDEX `jc_receiver_message_site`(`site_id`) USING BTREE, INDEX `jc_receiver_message_message`(`msg_re_id`) USING BTREE, INDEX `fk_jc_receiver_message_message`(`msg_id`) USING BTREE, CONSTRAINT `fk_jc_receiver_message_message` FOREIGN KEY (`msg_id`) REFERENCES `jc_message` (`msg_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_receiver_message_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_receiver_message_user_receiver` FOREIGN KEY (`msg_receiver_user`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_receiver_message_user_send` FOREIGN KEY (`msg_send_user`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '站内信收信表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_role -- ---------------------------- DROP TABLE IF EXISTS `jc_role`; CREATE TABLE `jc_role` ( `role_id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NULL DEFAULT NULL, `role_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称', `priority` int(11) NOT NULL DEFAULT 10 COMMENT '排列顺序', `is_super` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '拥有所有权限', `role_level` int(11) NOT NULL DEFAULT 10 COMMENT '角色等级', PRIMARY KEY (`role_id`) USING BTREE, INDEX `fk_jc_role_site`(`site_id`) USING BTREE, CONSTRAINT `fk_jc_role_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS角色表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_role_permission -- ---------------------------- DROP TABLE IF EXISTS `jc_role_permission`; CREATE TABLE `jc_role_permission` ( `role_id` int(11) NOT NULL, `uri` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, INDEX `fk_jc_permission_role`(`role_id`) USING BTREE, CONSTRAINT `fk_jc_permission_role` FOREIGN KEY (`role_id`) REFERENCES `jc_role` (`role_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS角色授权表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_score_group -- ---------------------------- DROP TABLE IF EXISTS `jc_score_group`; CREATE TABLE `jc_score_group` ( `score_group_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分组名', `description` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述', `enable` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否启用', `def` tinyint(3) NOT NULL DEFAULT 0 COMMENT '是否默认', `site_id` int(11) NOT NULL COMMENT '站点', PRIMARY KEY (`score_group_id`) USING BTREE, INDEX `fk_jc_score_group_site`(`site_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'FComment' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_score_item -- ---------------------------- DROP TABLE IF EXISTS `jc_score_item`; CREATE TABLE `jc_score_item` ( `score_item_id` int(11) NOT NULL AUTO_INCREMENT, `score_group_id` int(11) NOT NULL COMMENT '评分组', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评分名', `score` int(11) NOT NULL COMMENT '分值', `image_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评分图标路径', `priority` int(11) NOT NULL DEFAULT 10 COMMENT '排序', PRIMARY KEY (`score_item_id`) USING BTREE, INDEX `fk_jc_score_item_group`(`score_group_id`) USING BTREE, CONSTRAINT `fk_jc_score_item_group` FOREIGN KEY (`score_group_id`) REFERENCES `jc_score_group` (`score_group_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '评分项' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_score_record -- ---------------------------- DROP TABLE IF EXISTS `jc_score_record`; CREATE TABLE `jc_score_record` ( `score_record_id` int(11) NOT NULL AUTO_INCREMENT, `score_item_id` int(11) NOT NULL COMMENT '评分项', `content_id` int(11) NOT NULL COMMENT '内容', `score_count` int(11) NOT NULL COMMENT '评分次数', PRIMARY KEY (`score_record_id`) USING BTREE, INDEX `fk_jc_record_score_item`(`score_item_id`) USING BTREE, INDEX `index_score_record_content`(`content_id`) USING BTREE, CONSTRAINT `fk_jc_record_score_item` FOREIGN KEY (`score_item_id`) REFERENCES `jc_score_item` (`score_item_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '评分纪录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_search_words -- ---------------------------- DROP TABLE IF EXISTS `jc_search_words`; CREATE TABLE `jc_search_words` ( `word_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '搜索词汇', `hit_count` int(11) NOT NULL DEFAULT 0 COMMENT '搜索次数', `priority` int(11) NOT NULL DEFAULT 10 COMMENT '优先级', `name_initial` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '拼音首字母', `is_recommend` tinyint(1) NOT NULL DEFAULT 0 COMMENT '推荐', `site_id` int(11) NOT NULL DEFAULT 1 COMMENT '站点', PRIMARY KEY (`word_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 380 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '搜索热词' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_sensitivity -- ---------------------------- DROP TABLE IF EXISTS `jc_sensitivity`; CREATE TABLE `jc_sensitivity` ( `sensitivity_id` int(11) NOT NULL AUTO_INCREMENT, `search` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '敏感词', `replacement` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '替换词', PRIMARY KEY (`sensitivity_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS敏感词表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_site -- ---------------------------- DROP TABLE IF EXISTS `jc_site`; CREATE TABLE `jc_site` ( `site_id` int(11) NOT NULL AUTO_INCREMENT, `config_id` int(11) NOT NULL COMMENT '配置ID', `ftp_upload_id` int(11) NULL DEFAULT NULL COMMENT '上传ftp', `domain` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '域名', `site_path` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '路径', `site_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '网站名称', `short_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '简短名称', `protocol` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'http://' COMMENT '协议', `dynamic_suffix` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '.jhtml' COMMENT '动态页后缀', `static_suffix` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '.html' COMMENT '静态页后缀', `static_dir` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '静态页存放目录', `is_index_to_root` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '是否使用将首页放在根目录下', `is_static_index` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '是否静态化首页', `locale_admin` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'zh_CN' COMMENT '后台本地化', `locale_front` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'zh_CN' COMMENT '前台本地化', `tpl_solution` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'default' COMMENT '模板方案', `final_step` tinyint(4) NOT NULL DEFAULT 2 COMMENT '终审级别', `after_check` tinyint(4) NOT NULL DEFAULT 2 COMMENT '审核后(1:不能修改删除;2:修改后退回;3:修改后不变)', `is_relative_path` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1' COMMENT '是否使用相对路径', `is_recycle_on` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1' COMMENT '是否开启回收站', `domain_alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '域名别名', `domain_redirect` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '域名重定向', `tpl_index` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '首页模板', `keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '站点关键字', `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '站点描述', `tpl_mobile_solution` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'mobile' COMMENT '手机站模板方案', `mobile_static_dir` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '/wap' COMMENT '手机站静态页存放目录', `mobile_static_sync` tinyint(1) NOT NULL DEFAULT 0 COMMENT '手机站静态页同步生成', `ftp_sync_page_id` int(11) NULL DEFAULT NULL COMMENT '静态页同步FTP', `page_is_sync_ftp` tinyint(1) NOT NULL DEFAULT 0 COMMENT '静态页同步发布FTP', `resouce_is_sync_ftp` tinyint(1) NOT NULL DEFAULT 0 COMMENT '资源同步发布FTP', PRIMARY KEY (`site_id`) USING BTREE, UNIQUE INDEX `ak_domain_path`(`domain`) USING BTREE, INDEX `fk_jc_site_config`(`config_id`) USING BTREE, INDEX `fk_jc_site_upload_ftp`(`ftp_upload_id`) USING BTREE, CONSTRAINT `fk_jc_site_config` FOREIGN KEY (`config_id`) REFERENCES `jc_config` (`config_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_site_upload_ftp` FOREIGN KEY (`ftp_upload_id`) REFERENCES `jo_ftp` (`ftp_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS站点表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_site_access -- ---------------------------- DROP TABLE IF EXISTS `jc_site_access`; CREATE TABLE `jc_site_access` ( `access_id` int(11) NOT NULL AUTO_INCREMENT, `session_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', `site_id` int(11) NOT NULL COMMENT '站点id', `access_time` time NOT NULL COMMENT '访问时间', `access_date` date NOT NULL COMMENT '访问日期', `ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', `area` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '访问地区', `access_source` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '访问来源', `external_link` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外部链接网址', `engine` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '搜索引擎', `entry_page` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '入口页面', `last_stop_page` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后停留页面', `visit_second` int(11) NULL DEFAULT NULL COMMENT '访问时长(秒)', `visit_page_count` int(11) NULL DEFAULT NULL COMMENT '访问页面数', `operating_system` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作系统', `browser` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '浏览器', `keyword` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来访关键字', PRIMARY KEY (`access_id`) USING BTREE, INDEX `fk_jc_access_site`(`site_id`) USING BTREE, CONSTRAINT `fk_jc_access_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '站点访问表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_site_access_count -- ---------------------------- DROP TABLE IF EXISTS `jc_site_access_count`; CREATE TABLE `jc_site_access_count` ( `access_count` int(11) NOT NULL AUTO_INCREMENT, `page_count` int(11) NOT NULL DEFAULT 1 COMMENT '访问页数', `visitors` int(11) NOT NULL DEFAULT 0 COMMENT '用户数', `statistic_date` date NOT NULL COMMENT '统计日期', `site_id` int(11) NOT NULL COMMENT '统计站点', PRIMARY KEY (`access_count`) USING BTREE, INDEX `fk_jc_access_count_site`(`site_id`) USING BTREE, CONSTRAINT `fk_jc_access_count_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 2350 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '每日统计页数访问情况' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_site_access_pages -- ---------------------------- DROP TABLE IF EXISTS `jc_site_access_pages`; CREATE TABLE `jc_site_access_pages` ( `access_pages_id` int(11) NOT NULL AUTO_INCREMENT, `access_page` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '访问页面', `session_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `access_date` date NOT NULL COMMENT '访问日期', `access_time` time NOT NULL COMMENT '访问时间', `visit_second` int(11) NOT NULL DEFAULT 0 COMMENT '停留时长（秒）', `page_index` int(11) NOT NULL DEFAULT 0 COMMENT '用户访问页面的索引', `site_id` int(11) NOT NULL DEFAULT 1, PRIMARY KEY (`access_pages_id`) USING BTREE, INDEX `fk_jc_access_pages_access`(`session_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '访问详细页面表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_site_access_statistic -- ---------------------------- DROP TABLE IF EXISTS `jc_site_access_statistic`; CREATE TABLE `jc_site_access_statistic` ( `access_statistic_id` int(11) NOT NULL AUTO_INCREMENT, `statistic_date` date NOT NULL COMMENT '统计日期', `pv` int(11) NOT NULL DEFAULT 0 COMMENT 'pv量', `ip` int(11) NOT NULL DEFAULT 0 COMMENT 'ip量', `visitors` int(11) NOT NULL DEFAULT 0 COMMENT '访客数量', `pages_aver` int(11) NOT NULL DEFAULT 0 COMMENT '人均浏览次数', `visit_second_aver` int(11) NOT NULL DEFAULT 0 COMMENT '人均访问时长（秒）', `site_id` int(11) NOT NULL COMMENT '站点id', `statisitc_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'all' COMMENT '统计分类（all代表当天所有访问量的统计）', `statistic_column_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '统计列值', PRIMARY KEY (`access_statistic_id`) USING BTREE, INDEX `fk_jc_access_statistic_site`(`site_id`) USING BTREE, CONSTRAINT `fk_jc_access_statistic_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1961 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '访问统计表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_site_attr -- ---------------------------- DROP TABLE IF EXISTS `jc_site_attr`; CREATE TABLE `jc_site_attr` ( `site_id` int(11) NOT NULL, `attr_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `attr_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '值', INDEX `fk_jc_attr_site`(`site_id`) USING BTREE, CONSTRAINT `fk_jc_attr_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS站点属性表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_site_cfg -- ---------------------------- DROP TABLE IF EXISTS `jc_site_cfg`; CREATE TABLE `jc_site_cfg` ( `site_id` int(11) NOT NULL, `cfg_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `cfg_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '值', INDEX `fk_jc_cfg_site`(`site_id`) USING BTREE, CONSTRAINT `fk_jc_cfg_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS站点配置表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_site_company -- ---------------------------- DROP TABLE IF EXISTS `jc_site_company`; CREATE TABLE `jc_site_company` ( `site_id` int(11) NOT NULL, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '公司名称', `scale` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司规模', `nature` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司性质', `industry` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司行业', `contact` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系方式', `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '公司简介', `address` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司地址', `longitude` float(5, 2) NULL DEFAULT NULL COMMENT '经度', `latitude` float(4, 2) NULL DEFAULT NULL COMMENT '纬度', PRIMARY KEY (`site_id`) USING BTREE, CONSTRAINT `fk_jc_company_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '公司信息' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_site_model -- ---------------------------- DROP TABLE IF EXISTS `jc_site_model`; CREATE TABLE `jc_site_model` ( `model_id` int(11) NOT NULL AUTO_INCREMENT, `field` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字段', `model_label` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `priority` int(11) NOT NULL DEFAULT 10 COMMENT '排列顺序', `upload_path` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上传路径', `text_size` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '长度', `area_rows` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文本行数', `area_cols` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文本列数', `help` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '帮助信息', `help_position` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '帮助位置', `data_type` int(11) NULL DEFAULT 1 COMMENT '0:编辑器;1:文本框;2:文本区;3:图片;4:附件', `is_single` tinyint(1) NULL DEFAULT 1 COMMENT '是否独占一行', PRIMARY KEY (`model_id`) USING BTREE, UNIQUE INDEX `ak_field`(`field`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS站点信息模型表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_site_txt -- ---------------------------- DROP TABLE IF EXISTS `jc_site_txt`; CREATE TABLE `jc_site_txt` ( `site_id` int(11) NOT NULL, `txt_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `txt_value` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '值', INDEX `fk_jc_txt_site`(`site_id`) USING BTREE, CONSTRAINT `fk_jc_txt_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS站点文本表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_task -- ---------------------------- DROP TABLE IF EXISTS `jc_task`; CREATE TABLE `jc_task` ( `task_id` int(11) NOT NULL AUTO_INCREMENT, `task_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务执行代码', `task_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '任务类型(1首页静态化、2栏目页静态化、3内容页静态化、4采集、5分发)', `task_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '任务名称', `job_class` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '任务类', `execycle` tinyint(1) NOT NULL DEFAULT 1 COMMENT '执行周期分类(1非表达式 2 cron表达式)', `day_of_month` int(11) NULL DEFAULT NULL COMMENT '每月的哪天', `day_of_week` tinyint(1) NULL DEFAULT NULL COMMENT '周几', `hour` int(11) NULL DEFAULT NULL COMMENT '小时', `minute` int(11) NULL DEFAULT NULL COMMENT '分钟', `interval_hour` int(11) NULL DEFAULT NULL COMMENT '间隔小时', `interval_minute` int(11) NULL DEFAULT NULL COMMENT '间隔分钟', `task_interval_unit` tinyint(1) NULL DEFAULT NULL COMMENT '1分钟、2小时、3日、4周、5月', `cron_expression` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规则表达式', `is_enable` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否启用', `task_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务说明', `site_id` int(11) NOT NULL COMMENT '站点', `user_id` int(11) NOT NULL COMMENT '创建者', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`task_id`) USING BTREE, INDEX `fk_jc_task_site`(`site_id`) USING BTREE, CONSTRAINT `fk_jc_task_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '任务表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_task_attr -- ---------------------------- DROP TABLE IF EXISTS `jc_task_attr`; CREATE TABLE `jc_task_attr` ( `task_id` int(11) NOT NULL, `param_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '参数名称', `param_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参数值', INDEX `fk_jc_attr_task`(`task_id`) USING BTREE, CONSTRAINT `fk_jc_attr_task` FOREIGN KEY (`task_id`) REFERENCES `jc_task` (`task_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '任务参数表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_third_account -- ---------------------------- DROP TABLE IF EXISTS `jc_third_account`; CREATE TABLE `jc_third_account` ( `account_id` bigint(20) NOT NULL AUTO_INCREMENT, `account_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '第三方账号key', `username` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '关联用户名', `source` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '第三方账号平台(QQ、新浪微博等)', `user_id` int(11) NULL DEFAULT NULL COMMENT '用户iD', PRIMARY KEY (`account_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '第三方登录平台账号' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_topic -- ---------------------------- DROP TABLE IF EXISTS `jc_topic`; CREATE TABLE `jc_topic` ( `topic_id` int(11) NOT NULL AUTO_INCREMENT, `channel_id` int(11) NULL DEFAULT NULL, `topic_name` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `short_name` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简称', `keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关键字', `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述', `title_img` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题图', `content_img` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容图', `tpl_content` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专题模板', `priority` int(11) NOT NULL DEFAULT 10 COMMENT '排列顺序', `is_recommend` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否推??', PRIMARY KEY (`topic_id`) USING BTREE, INDEX `fk_jc_topic_channel`(`channel_id`) USING BTREE, CONSTRAINT `fk_jc_topic_channel` FOREIGN KEY (`channel_id`) REFERENCES `jc_channel` (`channel_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS专题表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_topic_channel -- ---------------------------- DROP TABLE IF EXISTS `jc_topic_channel`; CREATE TABLE `jc_topic_channel` ( `topic_id` int(11) NOT NULL, `channel_id` int(11) NOT NULL, PRIMARY KEY (`topic_id`, `channel_id`) USING BTREE, INDEX `fk_jc_topic_channel_channel`(`channel_id`) USING BTREE, INDEX `fk_jc_topic_channel_topic`(`topic_id`) USING BTREE, CONSTRAINT `fk_jc_topic_channel_channel` FOREIGN KEY (`channel_id`) REFERENCES `jc_channel` (`channel_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_topic_channel_topic` FOREIGN KEY (`topic_id`) REFERENCES `jc_topic` (`topic_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_user -- ---------------------------- DROP TABLE IF EXISTS `jc_user`; CREATE TABLE `jc_user` ( `user_id` int(11) NOT NULL, `group_id` int(11) NOT NULL, `username` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名', `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱', `register_time` datetime NOT NULL COMMENT '注册时间', `register_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '127.0.0.1' COMMENT '注册IP', `last_login_time` datetime NOT NULL COMMENT '最后登录时间', `last_login_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '127.0.0.1' COMMENT '最后登录IP', `login_count` int(11) NOT NULL DEFAULT 0 COMMENT '登录次数', `rank` int(11) NOT NULL DEFAULT 0 COMMENT '管理员级别', `upload_total` bigint(20) NOT NULL DEFAULT 0 COMMENT '上传总大小', `upload_size` int(11) NOT NULL DEFAULT 0 COMMENT '上传大小', `upload_date` date NULL DEFAULT NULL COMMENT '上传日期', `is_admin` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否管理员', `is_self_admin` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否只管理自己的数据', `is_disabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否禁用', `session_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `feed_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '反馈id', PRIMARY KEY (`user_id`) USING BTREE, UNIQUE INDEX `ak_username`(`username`) USING BTREE, INDEX `fk_jc_user_group`(`group_id`) USING BTREE, CONSTRAINT `fk_jc_user_group` FOREIGN KEY (`group_id`) REFERENCES `jc_group` (`group_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS用户表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_user_account -- ---------------------------- DROP TABLE IF EXISTS `jc_user_account`; CREATE TABLE `jc_user_account` ( `user_id` int(11) NOT NULL, `account_weixin` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信账号名', `account_weixin_openId` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信账号openid', `account_alipy` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '支付宝账号', `draw_account` tinyint(1) NOT NULL DEFAULT 0 COMMENT '提现账户(0微信 1支付宝)', `content_total_amount` double(15, 4) NULL DEFAULT 0.0000 COMMENT '稿费总金额', `content_no_pay_amount` double(15, 4) NULL DEFAULT 0.0000 COMMENT '待提现稿费金额', `content_year_amount` double(15, 4) NOT NULL DEFAULT 0.0000 COMMENT '稿费年金额', `content_month_amount` double(15, 4) NOT NULL DEFAULT 0.0000 COMMENT '稿费本月金额', `content_day_amount` double(15, 4) NOT NULL DEFAULT 0.0000 COMMENT '稿费本日金额', `content_buy_count` int(11) NULL DEFAULT NULL COMMENT '被用户购买次数', `draw_count` int(11) NULL DEFAULT 0 COMMENT '累计提现次数', `last_draw_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '上次提现时间', `last_buy_time` timestamp NULL DEFAULT NULL COMMENT '上次用户购买时间', PRIMARY KEY (`user_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户稿费收费配置' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_user_attr -- ---------------------------- DROP TABLE IF EXISTS `jc_user_attr`; CREATE TABLE `jc_user_attr` ( `user_id` int(11) NOT NULL, `attr_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `attr_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, INDEX `fk_jc_attr_user`(`user_id`) USING BTREE, CONSTRAINT `fk_jc_attr_user` FOREIGN KEY (`user_id`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户属性表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_user_collection -- ---------------------------- DROP TABLE IF EXISTS `jc_user_collection`; CREATE TABLE `jc_user_collection` ( `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户id', `content_id` int(11) NOT NULL DEFAULT 0 COMMENT '内容id', PRIMARY KEY (`user_id`, `content_id`) USING BTREE, INDEX `fk_jc_user_collection_con`(`content_id`) USING BTREE, CONSTRAINT `fk_jc_user_collection_con` FOREIGN KEY (`content_id`) REFERENCES `jc_content` (`content_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_user_collection_user` FOREIGN KEY (`user_id`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户收藏关联表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_user_ext -- ---------------------------- DROP TABLE IF EXISTS `jc_user_ext`; CREATE TABLE `jc_user_ext` ( `user_id` int(11) NOT NULL, `realname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '真实姓名', `gender` tinyint(1) NULL DEFAULT NULL COMMENT '性别', `birthday` datetime NULL DEFAULT NULL COMMENT '出生日期', `intro` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '个人介绍', `comefrom` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来自', `qq` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'QQ', `msn` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'MSN', `phone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话', `mobile` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机', `user_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户头像', `user_signature` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户个性签名', PRIMARY KEY (`user_id`) USING BTREE, CONSTRAINT `fk_jc_ext_user` FOREIGN KEY (`user_id`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS用户扩展信息表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_user_menu -- ---------------------------- DROP TABLE IF EXISTS `jc_user_menu`; CREATE TABLE `jc_user_menu` ( `menu_id` int(11) NOT NULL AUTO_INCREMENT, `menu_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单名称', `menu_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单地址', `priority` int(11) NOT NULL DEFAULT 10, `user_id` int(11) NOT NULL, PRIMARY KEY (`menu_id`) USING BTREE, INDEX `fk_jc_menu_user`(`user_id`) USING BTREE, CONSTRAINT `fk_jc_menu_user` FOREIGN KEY (`user_id`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户常用菜单' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_user_resume -- ---------------------------- DROP TABLE IF EXISTS `jc_user_resume`; CREATE TABLE `jc_user_resume` ( `user_id` int(11) NOT NULL, `resume_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '简历名称', `target_worknature` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '期望工作性质', `target_workplace` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '期望工作地点', `target_category` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '期望职位类别', `target_salary` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '期望月薪', `edu_school` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '毕业学校', `edu_graduation` datetime NULL DEFAULT NULL COMMENT '毕业时间', `edu_back` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学历', `edu_discipline` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专业', `recent_company` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最近工作公司名称', `company_industry` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最近公司所属行业', `company_scale` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公司规模', `job_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职位名称', `job_category` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职位类别', `job_start` datetime NULL DEFAULT NULL COMMENT '工作起始时间', `subordinates` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '下属人数', `job_description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '工作描述', `self_evaluation` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '自我评价', PRIMARY KEY (`user_id`) USING BTREE, CONSTRAINT `fk_jc_resume_user` FOREIGN KEY (`user_id`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户简历' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_user_role -- ---------------------------- DROP TABLE IF EXISTS `jc_user_role`; CREATE TABLE `jc_user_role` ( `role_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, PRIMARY KEY (`role_id`, `user_id`) USING BTREE, INDEX `fk_jc_role_user`(`user_id`) USING BTREE, CONSTRAINT `fk_jc_role_user` FOREIGN KEY (`user_id`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_user_role` FOREIGN KEY (`role_id`) REFERENCES `jc_role` (`role_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS用户角色关联表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_user_site -- ---------------------------- DROP TABLE IF EXISTS `jc_user_site`; CREATE TABLE `jc_user_site` ( `usersite_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `site_id` int(11) NOT NULL, `check_step` tinyint(4) NOT NULL DEFAULT 1 COMMENT '审核级别', `is_all_channel` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否拥有所有栏目的权限', PRIMARY KEY (`usersite_id`) USING BTREE, INDEX `fk_jc_site_user`(`user_id`) USING BTREE, INDEX `fk_jc_user_site`(`site_id`) USING BTREE, CONSTRAINT `fk_jc_site_user` FOREIGN KEY (`user_id`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_user_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS管理员站点表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_vote_item -- ---------------------------- DROP TABLE IF EXISTS `jc_vote_item`; CREATE TABLE `jc_vote_item` ( `voteitem_id` int(11) NOT NULL AUTO_INCREMENT, `votetopic_id` int(11) NOT NULL, `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标题', `vote_count` int(11) NOT NULL DEFAULT 0 COMMENT '投票数量', `priority` int(11) NOT NULL DEFAULT 10 COMMENT '排列顺序', `subtopic_id` int(11) NULL DEFAULT NULL, `picture` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片', PRIMARY KEY (`voteitem_id`) USING BTREE, INDEX `fk_jc_vote_item_topic`(`votetopic_id`) USING BTREE, INDEX `FK_jc_vote_item_subtopic`(`subtopic_id`) USING BTREE, CONSTRAINT `FK_jc_vote_item_subtopic` FOREIGN KEY (`subtopic_id`) REFERENCES `jc_vote_subtopic` (`subtopic_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_vote_item_topic` FOREIGN KEY (`votetopic_id`) REFERENCES `jc_vote_topic` (`votetopic_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 64 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS投票项' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_vote_record -- ---------------------------- DROP TABLE IF EXISTS `jc_vote_record`; CREATE TABLE `jc_vote_record` ( `voterecored_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NULL DEFAULT NULL, `votetopic_id` int(11) NOT NULL, `vote_time` datetime NOT NULL COMMENT '投票时间', `vote_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '投票IP', `vote_cookie` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '投票COOKIE', `wx_open_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信投票者openId', PRIMARY KEY (`voterecored_id`) USING BTREE, INDEX `fk_jc_vote_record_topic`(`votetopic_id`) USING BTREE, INDEX `fk_jc_voterecord_user`(`user_id`) USING BTREE, CONSTRAINT `fk_jc_vote_record_topic` FOREIGN KEY (`votetopic_id`) REFERENCES `jc_vote_topic` (`votetopic_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk_jc_voterecord_user` FOREIGN KEY (`user_id`) REFERENCES `jc_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 81 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS投票记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_vote_reply -- ---------------------------- DROP TABLE IF EXISTS `jc_vote_reply`; CREATE TABLE `jc_vote_reply` ( `votereply_id` int(11) NOT NULL AUTO_INCREMENT, `reply` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复内容', `subtopic_id` int(11) NULL DEFAULT NULL, PRIMARY KEY (`votereply_id`) USING BTREE, INDEX `FK_jc_vote_reply_sub`(`subtopic_id`) USING BTREE, CONSTRAINT `FK_jc_vote_reply_sub` FOREIGN KEY (`subtopic_id`) REFERENCES `jc_vote_subtopic` (`subtopic_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 151 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '投票文本题目回复表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_vote_subtopic -- ---------------------------- DROP TABLE IF EXISTS `jc_vote_subtopic`; CREATE TABLE `jc_vote_subtopic` ( `subtopic_id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '标题', `votetopic_id` int(11) NOT NULL DEFAULT 0 COMMENT '投票（调查）', `subtopic_type` int(2) NOT NULL DEFAULT 1 COMMENT '类型（1单选，2多选，3文本）', `priority` int(11) NULL DEFAULT NULL, PRIMARY KEY (`subtopic_id`) USING BTREE, INDEX `FK_jc_vote_subtopic_vote`(`votetopic_id`) USING BTREE, CONSTRAINT `FK_jc_vote_subtopic_vote` FOREIGN KEY (`votetopic_id`) REFERENCES `jc_vote_topic` (`votetopic_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '投票子题目' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_vote_topic -- ---------------------------- DROP TABLE IF EXISTS `jc_vote_topic`; CREATE TABLE `jc_vote_topic` ( `votetopic_id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL, `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标题', `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述', `start_time` datetime NULL DEFAULT NULL COMMENT '开始时间', `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间', `repeate_hour` int(11) NULL DEFAULT NULL COMMENT '重复投票限制时间，单位小时，为空不允许重复投票', `total_count` int(11) NOT NULL DEFAULT 0 COMMENT '总投票数', `multi_select` int(11) NOT NULL DEFAULT 1 COMMENT '最多可以选择几项', `is_restrict_member` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否限制会员', `is_restrict_ip` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否限制IP', `is_restrict_cookie` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否限制COOKIE', `is_disabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否禁用', `is_def` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否默认主题', `limit_weixin` tinyint(1) NULL DEFAULT 0 COMMENT '是否限制微信', `vote_day` int(11) NULL DEFAULT 0 COMMENT '限定微信投票每个用户每日投票次数,为0时则投票期内限定投票一次', PRIMARY KEY (`votetopic_id`) USING BTREE, INDEX `fk_jc_votetopic_site`(`site_id`) USING BTREE, CONSTRAINT `fk_jc_votetopic_site` FOREIGN KEY (`site_id`) REFERENCES `jc_site` (`site_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'CMS投票主题' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_webservice -- ---------------------------- DROP TABLE IF EXISTS `jc_webservice`; CREATE TABLE `jc_webservice` ( `service_id` int(11) NOT NULL AUTO_INCREMENT, `service_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '接口地址', `target_namespace` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `success_result` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '正确返回值', `service_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接口类型', `service_operate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接口操作', PRIMARY KEY (`service_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '接口表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_webservice_auth -- ---------------------------- DROP TABLE IF EXISTS `jc_webservice_auth`; CREATE TABLE `jc_webservice_auth` ( `auth_id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名', `password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码', `system` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '系统', `is_enable` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否启用', PRIMARY KEY (`auth_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'webservices认证表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_webservice_call_record -- ---------------------------- DROP TABLE IF EXISTS `jc_webservice_call_record`; CREATE TABLE `jc_webservice_call_record` ( `record_id` int(11) NOT NULL AUTO_INCREMENT, `service_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '接口识别码', `auth_id` int(11) NOT NULL COMMENT '调用的认证', `record_time` datetime NOT NULL COMMENT '调用时间', PRIMARY KEY (`record_id`) USING BTREE, INDEX `fk_webservice_record_auth`(`auth_id`) USING BTREE, CONSTRAINT `fk_webservice_record_auth` FOREIGN KEY (`auth_id`) REFERENCES `jc_webservice_auth` (`auth_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '接口调用记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jc_webservice_param -- ---------------------------- DROP TABLE IF EXISTS `jc_webservice_param`; CREATE TABLE `jc_webservice_param` ( `service_id` int(11) NOT NULL DEFAULT 0, `priority` int(11) NOT NULL DEFAULT 0 COMMENT '排列顺序', `param_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '参数名', `default_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '默认值', INDEX `fk_param_webservice`(`service_id`) USING BTREE, CONSTRAINT `fk_param_webservice` FOREIGN KEY (`service_id`) REFERENCES `jc_webservice` (`service_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '接口参数表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jg_weixin -- ---------------------------- DROP TABLE IF EXISTS `jg_weixin`; CREATE TABLE `jg_weixin` ( `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点ID', `wx_pic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信二维码', `wx_welcome` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '关注欢迎语' ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jg_weixinmenu -- ---------------------------- DROP TABLE IF EXISTS `jg_weixinmenu`; CREATE TABLE `jg_weixinmenu` ( `wm_id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点ID', `wm_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信菜单名称', `wm_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信菜单类别', `wm_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '链接地址', `wm_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '点击key', `wm_parent_id` int(11) NULL DEFAULT NULL COMMENT '父节点', PRIMARY KEY (`wm_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jg_weixinmessage -- ---------------------------- DROP TABLE IF EXISTS `jg_weixinmessage`; CREATE TABLE `jg_weixinmessage` ( `wm_id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点ID', `wm_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '序号', `wm_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题', `wm_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片地址', `wm_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '链接地址', `wm_content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '内容', `is_welcome` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否欢迎页', `wm_msg_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '消息类型(0带图文链接 1内容加关键字提示 2仅有内容)', PRIMARY KEY (`wm_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jo_authentication -- ---------------------------- DROP TABLE IF EXISTS `jo_authentication`; CREATE TABLE `jo_authentication` ( `authentication_id` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '认证ID', `userid` int(11) NOT NULL COMMENT '用户ID', `username` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名', `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱', `login_time` datetime NOT NULL COMMENT '登录时间', `login_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录ip', `update_time` datetime NOT NULL COMMENT '更新时间', PRIMARY KEY (`authentication_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '认证信息表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jo_config -- ---------------------------- DROP TABLE IF EXISTS `jo_config`; CREATE TABLE `jo_config` ( `cfg_key` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配置KEY', `cfg_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置VALUE', PRIMARY KEY (`cfg_key`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jo_ftp -- ---------------------------- DROP TABLE IF EXISTS `jo_ftp`; CREATE TABLE `jo_ftp` ( `ftp_id` int(11) NOT NULL AUTO_INCREMENT, `ftp_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'IP', `port` int(11) NOT NULL DEFAULT 21 COMMENT '端口号', `username` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录名', `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登陆密码', `encoding` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'UTF-8' COMMENT '编码', `timeout` int(11) NULL DEFAULT NULL COMMENT '超时时间', `ftp_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路径', `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '访问URL', PRIMARY KEY (`ftp_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'FTP表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jo_template -- ---------------------------- DROP TABLE IF EXISTS `jo_template`; CREATE TABLE `jo_template` ( `tpl_name` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板名称', `tpl_source` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '模板内容', `last_modified` bigint(20) NOT NULL COMMENT '最后修改时间', `is_directory` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否目录', PRIMARY KEY (`tpl_name`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '模板表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jo_upload -- ---------------------------- DROP TABLE IF EXISTS `jo_upload`; CREATE TABLE `jo_upload` ( `filename` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文件名', `length` int(11) NOT NULL COMMENT '文件大小(字节)', `last_modified` bigint(20) NOT NULL COMMENT '最后修改时间', `content` longblob NOT NULL COMMENT '内容', PRIMARY KEY (`filename`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '上传附件表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for jo_user -- ---------------------------- DROP TABLE IF EXISTS `jo_user`; CREATE TABLE `jo_user` ( `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID', `username` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名', `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电子邮箱', `password` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码', `register_time` datetime NOT NULL COMMENT '注册时间', `register_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '127.0.0.1' COMMENT '注册IP', `last_login_time` datetime NOT NULL COMMENT '最后登录时间', `last_login_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '127.0.0.1' COMMENT '最后登录IP', `login_count` int(11) NOT NULL DEFAULT 0 COMMENT '登录次数', `reset_key` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '重置密码KEY', `reset_pwd` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '重置密码VALUE', `error_time` datetime NULL DEFAULT NULL COMMENT '登录错误时间', `error_count` int(11) NOT NULL DEFAULT 0 COMMENT '登录错误次数', `error_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录错误IP', `activation` tinyint(1) NOT NULL DEFAULT 1 COMMENT '激活状态', `activation_code` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '激活码', `feed_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`user_id`) USING BTREE, UNIQUE INDEX `ak_username`(`username`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4273 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for opinion_collection -- ---------------------------- DROP TABLE IF EXISTS `opinion_collection`; CREATE TABLE `opinion_collection` ( `id` int(11) NOT NULL, `question1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `question2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `telephone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `createtime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `loginuser` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `timelimit` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT '30', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for satisfaction_survey -- ---------------------------- DROP TABLE IF EXISTS `satisfaction_survey`; CREATE TABLE `satisfaction_survey` ( `id` int(11) NOT NULL AUTO_INCREMENT, `question1` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `question2` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `question3` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `question4` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `question5` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `question6` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `question7` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `question8` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `question9` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `question10` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `question11` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `createtime` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `loginuser` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL, `timelimit` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT '30', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC; SET FOREIGN_KEY_CHECKS = 1;