/* Navicat MySQL Data Transfer Source Server : 192.168.7.151 Source Server Version : 50173 Source Host : 192.168.7.151:3306 Source Database : labwe Target Server Type : MYSQL Target Server Version : 50173 File Encoding : 65001 Date: 2016-04-18 19:50:30 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `onethink_website_content` -- ---------------------------- DROP TABLE IF EXISTS `onethink_website_content`; CREATE TABLE `onethink_website_content` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `catid` int(10) NOT NULL DEFAULT '0' COMMENT '二级分类ID（ID=0则为单页）', `parentcatid` int(10) NOT NULL DEFAULT '0' COMMENT '栏目分类ID', `title` varchar(150) NOT NULL DEFAULT '' COMMENT '内容标题', `short_title` varchar(150) DEFAULT '' COMMENT '短标题（用于单页时左边导航）', `description` varchar(500) NOT NULL DEFAULT '' COMMENT '简短描述（可填，不填则自动生成）', `tags` varchar(100) NOT NULL DEFAULT '' COMMENT '标签，可填，多个用英文逗号分隔', `pic` varchar(100) NOT NULL DEFAULT '' COMMENT '内容图片URL（缩略图）', `source` varchar(50) NOT NULL DEFAULT '' COMMENT '内容来源，如：中国青年报', `content` text NOT NULL DEFAULT '' COMMENT '内容正文', `viewcount` int(10) NOT NULL DEFAULT '0' COMMENT '浏览数量', `goodcount` int(10) NOT NULL DEFAULT '0' COMMENT '点赞好评数量', `badcount` int(10) NOT NULL DEFAULT '0' COMMENT '差评数量', `commentcount` int(10) NOT NULL DEFAULT '0' COMMENT '评论数量', `position` varchar(50) NOT NULL DEFAULT '0' COMMENT '推荐位置代码', `content_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '文章类型，1-文字，2-图文，3-视频文章', `uid` int(10) NOT NULL DEFAULT '0' COMMENT '用户ID', `update_time` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间', `create_time` int(10) NOT NULL DEFAULT '0' COMMENT '发布时间', `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '状态 0-草稿箱，1-已发布', `schoolcode` varchar(20) NOT NULL DEFAULT '' COMMENT '学校代码', `from_school` varchar(100) NOT NULL DEFAULT '' COMMENT '推荐文章过来的学校名', `recommend_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '推荐标记 0：没有向教育局推荐过 1：已向教育局推荐过', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章内容表'; -- ---------------------------- -- Table structure for `onethink_website_index_module` -- ---------------------------- DROP TABLE IF EXISTS `onethink_website_index_module`; CREATE TABLE `onethink_website_index_module` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID', `title` varchar(32) NOT NULL DEFAULT '' COMMENT '模块标题', `code` varchar(32) NOT NULL DEFAULT '' COMMENT '模块唯一标识', `option` text NOT NULL COMMENT '模块配置项', `icon` varchar(200) NOT NULL DEFAULT '' COMMENT '模块ICON图标URL', `itemcount` smallint(11) unsigned NOT NULL DEFAULT '1' COMMENT '可显示数量，默认每个模块只能显示1个', `createtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `schoolcode` char(50) NOT NULL DEFAULT '' COMMENT '学校代码', `uid` int(11) NOT NULL DEFAULT '0' COMMENT '创建用户ID', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态 1-启用 0-禁用', PRIMARY KEY (`id`), UNIQUE KEY `code` (`code`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='学校首页模块'; -- ---------------------------- -- Records of onethink_website_index_module -- ---------------------------- -- ---------------------------- -- Table structure for `onethink_website_setting` -- ---------------------------- DROP TABLE IF EXISTS `onethink_website_setting`; CREATE TABLE `onethink_website_setting` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `schoolcode` char(50) NOT NULL DEFAULT '' COMMENT '学校代码', `name` VARCHAR(32) NOT NULL DEFAULT '' COMMENT '标识', `value` text NOT NULL COMMENT '值', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='学校设置表'; -- ---------------------------- -- Records of onethink_website_setting -- ---------------------------- -- ---------------------------- -- Table structure for `onethink_website_template` -- ---------------------------- DROP TABLE IF EXISTS `onethink_website_template`; CREATE TABLE `onethink_website_template` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(32) NOT NULL DEFAULT '' COMMENT '模板标题', `code` varchar(32) NOT NULL DEFAULT '' COMMENT '模板标识 模板文件名：学校代码_code', `modulecode` varchar(11) NOT NULL DEFAULT '' COMMENT '模板类型 module-首页模块模板 list-列表页模板 detail-详情页模板', `themecode` varchar(32) NOT NULL DEFAULT '' COMMENT '主题代码', `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建用户ID', `createtime` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间', `schoolcode` char(50) NOT NULL DEFAULT '' COMMENT '学校代码', `isdefault` tinyint(1) NOT NULL DEFAULT '0' COMMENT '默认模板（当前主题当前模块下）', PRIMARY KEY (`id`), KEY `code` (`code`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8 COMMENT='学校网站模板表'; INSERT INTO `onethink_website_template` VALUES ('1', '链接-文字链接列表', 'link_default1', 'Module', 'default', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('2', '内容-文字内容列表', 'news_default1', 'Module', 'default', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('4', '内容-图片内容轮播', 'news_default2', 'Module', 'default', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('5', '内容-图片内容列表1', 'news_default3', 'Module', 'default', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('6', '内容-图片内容列表2', 'news_default4', 'Module', 'default', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('11', '链接-图片链接列表', 'link_default1', 'Module', 'default2', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('12', '应用-图片应用列表', 'application_default1', 'Module', 'default2', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('13', '内容-图片内容列表', 'news_default1', 'Module', 'default2', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('14', '内容-文字内容列表', 'news_default2', 'Module', 'default2', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('15', '内容-多分类文字内容列表1', 'news_default3', 'Module', 'default2', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('16', '内容-多分类文字内容列表2', 'news_default4', 'Module', 'default2', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('17', '内容-图片内容轮播', 'news_default5', 'Module', 'default2', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('18', '链接-图片链接', 'link_default2', 'Module', 'default2', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('19', '内容-图片内容列表', 'news_default1', 'Module', 'default3', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('20', '内容-文字内容列表1', 'news_default2', 'Module', 'default3', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('21', '内容-文字内容列表2', 'news_default3', 'Module', 'default3', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('22', '链接-图片链接列表', 'link_default1', 'Module', 'default3', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('23', '应用-图片应用列表', 'application_default1', 'Module', 'default3', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('24', '内容-图片内容轮播', 'news_default1', 'Module', 'default4', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('25', '内容-文字内容列表1', 'news_default2', 'Module', 'default4', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('26', '内容-文字内容列表2', 'news_default3', 'Module', 'default4', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('27', '链接-图片链接', 'link_default1', 'Module', 'default4', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('28', '内容-图片内容列表1', 'news_default4', 'Module', 'default4', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('29', '内容-图片内容列表2', 'news_default5', 'Module', 'default4', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('30', '链接-文字链接列表1', 'link_default1', 'Module', 'default5', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('31', '链接-文字链接列表2', 'link_default2', 'Module', 'default5', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('32', '内容-图片内容轮播', 'news_default1', 'Module', 'default5', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('33', '内容-文字内容列表', 'news_default2', 'Module', 'default5', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('34', '无标题格式内容', 'detail_default', 'detail', 'default', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('35', '无图列表', 'list_default', 'list', 'default', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('36', '有标题格式内容', 'detail_default', 'detail', 'default2', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('37', '无标题格式内容', 'detail_no_style', 'detail', 'default2', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('38', '无图列表', 'list_default', 'list', 'default3', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('39', '有标题格式内容', 'detail_default', 'detail', 'default3', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('40', '有标题格式内容', 'detail_default', 'detail', 'default4', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('41', '无图列表', 'list_default', 'list', 'default4', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('42', '有标题格式内容', 'detail_default', 'detail', 'default5', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('43', '无图列表', 'list_default', 'list', 'default5', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('44', '有图列表', 'list_have_img', 'list', 'default5', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('45', '应用-图片应用列表', 'application_default1', 'Module', 'default4', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('46', '无图列表', 'list_default', 'list', 'default2', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('47', '应用-图片应用列表', 'application_default1', 'Module', 'default', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('48', '应用-图片应用列表', 'application_default1', 'Module', 'default5', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('49', '图片浏览--内容', 'detail_default2', 'detail', 'default5', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('50', '橱窗列表', 'list_window', 'list', 'default5', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('88', '无标题格式内容', 'detail_no_style', 'detail', 'default3', 0, 0, '', 0); INSERT INTO `onethink_website_template` VALUES ('51', '橱窗列表', 'list_window', 'list', 'default', 0, 0, '', 0); INSERT INTO `onethink_website_template` VALUES ('52', '图片浏览--内容', 'detail_default2', 'detail', 'default', 0, 0, '', 0); INSERT INTO `onethink_website_template` VALUES ('53', '图片浏览--内容', 'detail_default2', 'detail', 'default2', 0, 0, '', 0); INSERT INTO `onethink_website_template` VALUES ('54', '橱窗列表', 'list_window', 'list', 'default2', 0, 0, '', 0); INSERT INTO `onethink_website_template` VALUES ('55', '橱窗列表', 'list_window', 'list', 'default3', 0, 0, '', 0); INSERT INTO `onethink_website_template` VALUES ('56', '图片浏览--内容', 'detail_default2', 'detail', 'default3', 0, 0, '', 0); INSERT INTO `onethink_website_template` VALUES ('57', '橱窗列表', 'list_window', 'list', 'default4', 0, 0, '', 0); INSERT INTO `onethink_website_template` VALUES ('58', '图片浏览--内容', 'detail_default2', 'detail', 'default4', 0, 0, '', 0); INSERT INTO `onethink_website_template` VALUES ('68', '底部通知', '1ea7f0eabd022b406ff1346acf1ed7af', 'datacall', 'default5', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('69', '主题5首页焦点图', 'cf5fa68883a2d17d94094926a386d2f4', 'datacall', 'default5', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('70', '主题1首页焦点图', 'c3968a79ba8947d4de78947b3c0bd063', 'datacall', 'default2', '0', '0', '', '0'); INSERT INTO `onethink_website_template` VALUES ('71', ' 主题2首页焦点图', 'fd7e798b8801cd712dcc0aebebca9bab', 'datacall', 'default', '0', '0', '', '0'); -- INSERT INTO `onethink_website_template` VALUES ('99', '点播-文字列表', 'elive_default1', 'Module', 'default2', '0', '0', '', '0'); -- INSERT INTO `onethink_website_template` VALUES ('100', '点播-图文橱窗', 'elive_default2', 'Module', 'default2', '0', '0', '', '0'); -- INSERT INTO `onethink_website_template` VALUES ('102', '点播-图片轮播', 'elive_default3', 'Module', 'default2', '0', '0', '', '0'); -- INSERT INTO `onethink_website_template` VALUES ('103', '点播-文字列表', 'elive_default1', 'Module', 'default3', '0', '0', '', '0'); -- INSERT INTO `onethink_website_template` VALUES ('104', '点播-文字橱窗', 'elive_default2', 'Module', 'default3', '0', '0', '', '0'); -- INSERT INTO `onethink_website_template` VALUES ('105', '点播-图文橱窗', 'elive_default3', 'Module', 'default3', '0', '0', '', '0'); -- INSERT INTO `onethink_website_template` VALUES ('106', '点播-文字列表', 'elive_default1', 'Module', 'default4', '0', '0', '', '0'); -- INSERT INTO `onethink_website_template` VALUES ('107', '点播-图文橱窗', 'elive_default2', 'Module', 'default4', '0', '0', '', '0'); -- INSERT INTO `onethink_website_template` VALUES ('108', '点播-图片轮播', 'elive_default3', 'Module', 'default4', '0', '0', '', '0'); -- INSERT INTO `onethink_website_template` VALUES ('109', '点播-文字列表', 'elive_default1', 'Module', 'default5', '0', '0', '', '0'); -- INSERT INTO `onethink_website_template` VALUES ('111', '点播-图片轮播', 'elive_default3', 'Module', 'default5', '0', '0', '', '0'); -- INSERT INTO `onethink_website_template` VALUES ('112', '点播-文字列表', 'elive_default1', 'Module', 'default', '0', '0', '', '0'); -- INSERT INTO `onethink_website_template` VALUES ('113', '点播-图文橱窗', 'elive_default2', 'Module', 'default', '0', '0', '', '0'); -- INSERT INTO `onethink_website_template` VALUES ('114', '点播-图片轮播', 'elive_default3', 'Module', 'default', '0', '0', '', '0'); -- ---------------------------- -- Table structure for `onethink_website_theme` -- ---------------------------- DROP TABLE IF EXISTS `onethink_website_theme`; CREATE TABLE `onethink_website_theme` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(32) NOT NULL DEFAULT '' COMMENT '主题名称', `themecode` varchar(16) NOT NULL DEFAULT '' COMMENT '主题标识 主题目录：[schoolcode]_[themecode]', `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '主题创建人 0-默认主题，禁止删除和编辑', `layout` varchar(1000) NOT NULL DEFAULT '' COMMENT '布局', `module` text NOT NULL COMMENT '模块', `style` varchar(1000) NOT NULL DEFAULT '' COMMENT '样式 json', `schoolcode` char(50) NOT NULL DEFAULT '' COMMENT '学校代码', `createtime` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间', `themepic` varchar(255) NOT NULL DEFAULT '' COMMENT '主题封面图片', PRIMARY KEY (`id`), UNIQUE KEY `themecode` (`themecode`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='学校网站主题表'; INSERT INTO `onethink_website_theme` VALUES ('1', '默认主题1', 'default2', '0', '{\"name\":\"5BR\"}', '{\"box_0\":[{\"code\":\"news\",\"title\":\"\\u5185\\u5bb9\",\"params\":{\"category\":[],\"template\":\"news_default5\",\"position\":\"0\",\"count\":\"5\"},\"width\":\"100%\",\"class\":\"\"}],\"box_1\":[{\"code\":\"news\",\"title\":\"\\u5185\\u5bb9\",\"params\":{\"category\":[],\"template\":\"news_default4\",\"position\":\"0\",\"count\":\"5\"},\"width\":\"100%\",\"class\":\"\"},{\"code\":\"news\",\"title\":\"\\u56fd\\u9645\\u6559\\u80b2\",\"params\":{\"category\":[],\"template\":\"news_default2\",\"position\":\"0\",\"count\":\"5\"},\"width\":\"100%\",\"class\":\"\"}],\"box_2\":[{\"code\":\"application\",\"title\":\"\\u5e94\\u7528\",\"params\":{\"template\":\"application_default1\",\"selected\":[]},\"width\":\"100%\",\"class\":\"\"},{\"code\":\"news\",\"title\":\"\\u901a\\u77e5\\u516c\\u544a\",\"params\":{\"category\":[],\"template\":\"news_default2\",\"position\":\"0\",\"count\":\"5\"},\"width\":\"100%\",\"class\":\"\"}],\"box_3\":[{\"code\":\"news\",\"title\":\"\\u540d\\u5e08\\u63a8\\u8350\",\"params\":{\"category\":[],\"template\":\"news_default1\",\"position\":\"0\",\"count\":\"5\"},\"width\":\"100%\",\"class\":\"\"},{\"code\":\"news\",\"title\":\"\\u6821\\u56ed\\u751f\\u6d3b\",\"params\":{\"category\":[],\"template\":\"news_default3\",\"position\":\"0\",\"count\":\"5\"},\"width\":\"100%\",\"class\":\"\"}],\"box_4\":[{\"code\":\"link\",\"title\":\"\\u94fe\\u63a5\",\"params\":{\"category\":\"\",\"template\":\"link_default2\",\"count\":\"1\"},\"width\":\"100%\",\"class\":\"\"},{\"code\":\"link\",\"title\":\"\\u94fe\\u63a5\",\"params\":{\"category\":\"\",\"template\":\"link_default2\",\"count\":\"1\"},\"width\":\"100%\",\"class\":\"\"},{\"code\":\"link\",\"title\":\"\\u94fe\\u63a5\",\"params\":{\"category\":\"\",\"template\":\"link_default2\",\"count\":\"1\"},\"width\":\"100%\",\"class\":\"\"},{\"code\":\"link\",\"title\":\"\\u94fe\\u63a5\",\"params\":{\"category\":\"\",\"template\":\"link_default1\",\"count\":\"3\"},\"width\":\"100%\",\"class\":\"\"}]}', '{\"t_family\":\"\\u5fae\\u8f6f\\u96c5\\u9ed1\",\"t_color\":\"5A83C0\",\"f_family\":\"\\u5fae\\u8f6f\\u96c5\\u9ed1\",\"f_color\":\"\",\"a_color\":\"\",\"a_mcolor\":\"\",\"nav_limit\":11,\"body_bg\":{\"img\":\"\",\"type\":\"background-size:auto;background-repeat:no-repeat;background-position:center;\"},\"header_bg\":{\"img\":\"\",\"type\":\"background-size:auto;background-repeat:no-repeat;background-position:center;\"},\"img_size\":{\"h_logo\":\"253px*72px\",\"b_logo\":\"199px*58px\",\"qr_code\":\"90px*90px\"}}', '', '0', 'Application/Index/View/default2/Public/static/images/theme-icon.jpg'); INSERT INTO `onethink_website_theme` VALUES ('2', '默认主题2', 'default', '0', '{\"name\":\"5BR\"}', '{\"box_0\":[{\"code\":\"news\",\"title\":\"\\u65b0\\u95fb\",\"params\":{\"category\":[],\"template\":\"news_default3\",\"position\":\"0\",\"count\":\"5\"},\"width\":\"100%\",\"class\":\"\"}],\"box_1\":[{\"code\":\"news\",\"title\":\"\\u4e00\\u4e2d\\u65b0\\u95fb\",\"params\":{\"category\":[],\"template\":\"news_default1\",\"position\":\"0\",\"count\":\"5\"},\"width\":\"100%\",\"class\":\"\"}],\"box_2\":[{\"code\":\"link\",\"title\":\"\\u6821\\u56ed\\u516c\\u544a\",\"params\":{\"category\":\"\",\"template\":\"link_default1\",\"count\":\"5\"},\"width\":\"100%\",\"class\":\"\"}],\"box_3\":[{\"code\":\"news\",\"title\":\"\\u540d\\u5e08\\u63a8\\u8350\",\"params\":{\"category\":[],\"template\":\"news_default4\",\"position\":\"0\",\"count\":\"5\"},\"width\":\"100%\",\"class\":\"\"}],\"box_4\":[{\"code\":\"news\",\"title\":\"\\u5b66\\u4e60\\u4e4b\\u661f\",\"params\":{\"template\":\"news_default2\",\"position\":\"0\",\"count\":\"5\"},\"width\":\"100%\",\"class\":\"\"}]}', '{\"t_family\":\"\\u5fae\\u8f6f\\u96c5\\u9ed1\",\"t_color\":\"2744E3\",\"f_family\":\"\\u5fae\\u8f6f\\u96c5\\u9ed1\",\"f_color\":\"#666666\",\"a_color\":\"\",\"a_mcolor\":\"\",\"nav_limit\":11,\"body_bg\":{\"img\":\"\",\"type\":\"\"},\"header_bg\":{\"img\":\"\",\"type\":\"\"},\"img_size\":{\"h_logo\":\"136px*40px\",\"b_logo\":\"\",\"qr_code\":\"80px*80px\"}}', '', '0', 'Application/Index/View/default/Public/static/images/theme-icon.jpg'); INSERT INTO `onethink_website_theme` VALUES ('3', '默认主题3', 'default3', '0', '{\"name\":\"3TB\"}', '{\"box_0\":[{\"code\":\"link\",\"title\":\"\\u94fe\\u63a5\",\"params\":{\"category\":\"1\",\"template\":\"link_default1\",\"count\":\"5\"},\"width\":\"100%\",\"class\":\"\"}],\"box_1\":[{\"code\":\"news\",\"title\":\"\\u65b0\\u95fb\\u52a8\\u6001\",\"params\":{\"template\":\"news_default1\",\"position\":\"0\",\"count\":\"2\"},\"width\":\"100%\",\"class\":\"\"},{\"code\":\"news\",\"title\":\"\\u901a\\u77e5\\u516c\\u544a\",\"params\":{\"template\":\"news_default3\",\"position\":\"0\",\"count\":\"6\"},\"width\":\"100%\",\"class\":\"\"}],\"box_2\":[{\"code\":\"news\",\"title\":\"\\u6700\\u65b0\\u52a8\\u6001\",\"params\":{\"template\":\"news_default2\",\"position\":\"0\",\"count\":\"6\"},\"width\":\"100%\",\"class\":\"\"},{\"code\":\"application\",\"title\":\"\\u5e94\\u7528\",\"params\":{\"template\":\"application_default1\"},\"width\":\"100%\",\"class\":\"\"}]}', '{\"t_family\":\"\\u5fae\\u8f6f\\u96c5\\u9ed1\",\"t_color\":\"961A1F\",\"f_family\":\"\\u5fae\\u8f6f\\u96c5\\u9ed1\",\"f_color\":\"\",\"a_color\":\"\",\"a_mcolor\":\"\",\"nav_limit\":8,\"body_bg\":{\"img\":\"\",\"type\":\"background-size:auto;background-repeat:no-repeat;background-position:center;\"},\"header_bg\":{\"img\":\"\",\"type\":\"background-size:auto;background-repeat:no-repeat;background-position:center;\"},\"img_size\":{\"h_logo\":\"454px*92px\",\"b_logo\":\"\",\"qr_code\":\"\"}}', '', '0', 'Application/Index/View/default3/Public/static/images/theme-icon.jpg'); INSERT INTO `onethink_website_theme` VALUES ('4', '默认主题4', 'default4', '0', '{\"name\":\"8ETB\"}', '{\"box_0\":[{\"code\":\"news\",\"title\":\"\\u5185\\u5bb9\",\"params\":{\"template\":\"news_default1\",\"position\":\"0\",\"count\":\"5\"},\"width\":\"100%\",\"class\":\"\"}],\"box_1\":[{\"code\":\"news\",\"title\":\"\\u5b66\\u6821\\u65b0\\u95fb\",\"params\":{\"template\":\"news_default2\",\"position\":\"0\",\"count\":\"8\"},\"width\":\"100%\",\"class\":\"\"}],\"box_2\":[{\"code\":\"news\",\"title\":\"\\u6821\\u56ed\\u516c\\u544a\",\"params\":{\"template\":\"news_default3\",\"position\":\"0\",\"count\":\"4\"},\"width\":\"100%\",\"class\":\"\"}],\"box_3\":[{\"code\":\"link\",\"title\":\"\\u94fe\\u63a5\",\"params\":{\"category\":\"\",\"template\":\"link_default1\",\"count\":\"1\"},\"width\":\"100%\",\"class\":\"\"}],\"box_4\":[{\"code\":\"news\",\"title\":\"\\u680f\\u76ee\\u6587\\u7ae0\",\"params\":{\"template\":\"news_default4\",\"position\":\"0\",\"count\":\"6\"},\"width\":\"100%\",\"class\":\"\"}],\"box_5\":[{\"code\":\"news\",\"title\":\"\\u680f\\u76ee\\u6587\\u7ae0\",\"params\":{\"template\":\"news_default4\",\"position\":\"0\",\"count\":\"6\"},\"width\":\"100%\",\"class\":\"\"}],\"box_6\":[{\"code\":\"application\",\"title\":\"\\u5e94\\u7528\",\"params\":{\"template\":\"application_default1\"},\"width\":\"100%\",\"class\":\"\"}],"box_7\":[{\"code\":\"news\",\"title\":\"\\u5185\\u5bb9\",\"params\":{\"template\":\"news_default5\",\"position\":\"0\",\"count\":\"6\"},\"width\":\"100%\",\"class\":\"\"}]}', '{\"t_family\":\"\\u5fae\\u8f6f\\u96c5\\u9ed1\",\"t_color\":\"022237\",\"f_family\":\"\\u5fae\\u8f6f\\u96c5\\u9ed1\",\"f_color\":\"\",\"a_color\":\"\",\"a_mcolor\":\"\",\"nav_limit\":10,\"body_bg\":{\"img\":\"\",\"type\":\"background-size:auto;background-repeat:no-repeat;background-position:center;\"},\"header_bg\":{\"img\":\"\",\"type\":\"background-size:auto;background-repeat:no-repeat;background-position:center;\"},\"img_size\":{\"h_logo\":\"\",\"b_logo\":\"\",\"qr_code\":\"100px*100px\"}}', '', '0', 'Application/Index/View/default4/Public/static/images/theme-icon.jpg'); INSERT INTO `onethink_website_theme` VALUES ('5', '默认主题5', 'default5', '0', '{\"name\":\"other\",\"value\":[{\"id\":\"0\",\"w\":\"5\"},{\"id\":\"1\",\"w\":\"7\"},{\"id\":\"2\",\"w\":\"12\"}]}', '{\"box_0\":[{\"code\":\"news\",\"title\":\"\\u65b0\\u95fb\\u8f6e\\u64ad\",\"params\":{\"template\":\"news_default1\",\"position\":\"0\",\"count\":\"5\"},\"width\":\"100%\",\"class\":\"\"}],\"box_1\":[{\"code\":\"news\",\"title\":\"\\u65b0\\u95fb\\u52a8\\u6001\",\"params\":{\"template\":\"news_default2\",\"position\":\"0\",\"count\":\"4\"},\"width\":\"100%\",\"class\":\"\"}],\"box_2\":[{\"code\":\"link\",\"title\":\"\\u5feb\\u901f\\u8bbf\\u95ee\",\"params\":{\"category\":\"\",\"template\":\"link_default1\",\"count\":\"5\"},\"width\":\"100%\",\"class\":\"\"},{\"code\":\"link\",\"title\":\"\\u53cb\\u60c5\\u94fe\\u63a5\",\"params\":{\"category\":\"\",\"template\":\"link_default2\",\"count\":\"5\"},\"width\":\"100%\",\"class\":\"\"}]}', '{\"t_family\":\"\\u5fae\\u8f6f\\u96c5\\u9ed1\",\"t_color\":\"\",\"a_color\":\"\",\"a_mcolor\":\"\",\"body_bg\":{\"img\":\"\",\"type\":\"background-size:auto;background-repeat:no-repeat;background-position:center;\"},\"header_bg\":{\"img\":\"\",\"type\":\"background-size:auto;background-repeat:no-repeat;background-position:center;\"},\"width\":{\"class\":\"container\",\"css\":\"\"},\"img_size\":{\"h_logo\":\"365px*75px\",\"b_logo\":\"\",\"qr_code\":\"85px*103px\"}}', '', '0', 'Application/Index/View/default5/Public/static/images/theme-icon.jpg'); -- ---------------------------- -- Table structure for `onethink_website_friendlink` -- ---------------------------- DROP TABLE IF EXISTS `onethink_website_friendlink`; CREATE TABLE `onethink_website_friendlink` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL DEFAULT '' COMMENT '链接名称', `href` varchar(150) NOT NULL DEFAULT '' COMMENT '链接URL', `logo` varchar(150) NOT NULL DEFAULT '' COMMENT '链接LOGO图片', `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建人UID', `linktype` tinyint(1) NOT NULL DEFAULT '0' COMMENT '链接类型 1-合作链接,2-友情链接', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态 2-禁用,1-可用', `createtime` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间', `schoolcode` char(50) NOT NULL DEFAULT '' COMMENT '学校代码', `sort` int(255) DEFAULT '0' COMMENT '前台排序', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='友情链接表'; -- ---------------------------- -- Table structure for `onethink_website_illegalwords` -- ---------------------------- DROP TABLE IF EXISTS `onethink_website_illegalwords`; CREATE TABLE `onethink_website_illegalwords` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `groupname` varchar(150) NOT NULL DEFAULT '' COMMENT '分组名', `words` text NOT NULL COMMENT '评论非法词，多个用英文逗号分隔', `create_time` int(10) NOT NULL DEFAULT '0' COMMENT '添加时间', `update_time` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间', `schoolcode` varchar(20) NOT NULL DEFAULT '' COMMENT '学校代码', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='评论非法词'; -- ---------------------------- -- Table structure for `onethink_website_comments` -- ---------------------------- DROP TABLE IF EXISTS `onethink_website_comments`; CREATE TABLE `onethink_website_comments` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID', `contentid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '评论文章ID', `content` varchar(2000) NOT NULL DEFAULT '' COMMENT '评论内容', `score` smallint(11) unsigned NOT NULL DEFAULT '0' COMMENT '评论打分（1-5分）', `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '评论时间', `schoolcode` varchar(20) NOT NULL DEFAULT '' COMMENT '学校代码', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章评论表'; -- ---------------------------- -- Table structure for `onethink_website_file` -- ---------------------------- DROP TABLE IF EXISTS `onethink_website_file`; CREATE TABLE `onethink_website_file` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文件ID', `name` varchar(50) NOT NULL DEFAULT '' COMMENT '原始文件名', `savename` varchar(50) NOT NULL DEFAULT '' COMMENT '保存名称', `savepath` varchar(80) NOT NULL DEFAULT '' COMMENT '文件保存路径', `ext` char(5) NOT NULL DEFAULT '' COMMENT '文件后缀', `mime` char(40) NOT NULL DEFAULT '' COMMENT '文件mime类型', `size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小', `md5` char(32) NOT NULL DEFAULT '' COMMENT '文件md5', `sha1` char(40) NOT NULL DEFAULT '' COMMENT '文件 sha1编码', `location` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '文件保存位置', `create_time` int(11) unsigned NOT NULL COMMENT '上传时间', `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '上传用户UID', `schoolcode` varchar(20) NOT NULL DEFAULT '' COMMENT '学校代码', PRIMARY KEY (`id`), UNIQUE KEY `uk_md5` (`md5`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章内容图片或文件管理表'; -- ---------------------------- -- Table structure for `onethink_website_column` -- ---------------------------- DROP TABLE IF EXISTS `onethink_website_column`; CREATE TABLE `onethink_website_column` ( `column_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '栏目id', `column_name` varchar(50) NOT NULL COMMENT '栏目名', `parent_id` int(10) NOT NULL DEFAULT '0', `level` int(3) NOT NULL DEFAULT '0' COMMENT '栏目级别1为第一级，2为第二级，3为第三级', `sort` int(3) NOT NULL DEFAULT '1' COMMENT '栏目排序，如果sort值一样安录入顺序', `status` int(3) NOT NULL DEFAULT '1' COMMENT '栏目状态，1显示，2不显示', `change_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间', `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `schoolcode` varchar(50) NOT NULL DEFAULT '' COMMENT '学校代码', `single` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否为单页 0:否 1：是', `list_mod_id` varchar(50) NOT NULL DEFAULT '0' COMMENT '列表模板code', `detail_mod_id` varchar(50) NOT NULL DEFAULT '0' COMMENT '详情内容模板code', `column_img` varchar(200) DEFAULT '' COMMENT '栏目横图', `column_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '栏目类型 0：自定义栏目 1：新闻栏目 2：资源栏目', `create_type` tinyint(1) DEFAULT '0' COMMENT '创建类型：0:是用户创建 1:系统自建', `subject_code` varchar(50) NOT NULL DEFAULT '' COMMENT '资源平台的科目code,用在资栏目的应用', `allow_menu` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否在导航显示下拉 1:不显示 0：显示', PRIMARY KEY (`column_id`), KEY `i_parent_id` (`parent_id`) USING BTREE, KEY `i_status` (`status`) USING BTREE, KEY `i_single` (`single`) USING BTREE, KEY `i_create_time` (`create_time`) USING BTREE, KEY `i_schoolcode` (`schoolcode`) USING BTREE, KEY `i_column_type` (`column_type`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='栏目表'; -- ---------------------------- -- Table structure for onethink_website_forbidwords -- ---------------------------- DROP TABLE IF EXISTS `onethink_website_forbidwords`; CREATE TABLE `onethink_website_forbidwords` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `groupname` varchar(150) NOT NULL DEFAULT '' COMMENT '分组名', `words` text NOT NULL COMMENT '评论非法词，多个用英文逗号分隔', `create_time` int(10) NOT NULL DEFAULT '0' COMMENT '添加时间', `update_time` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间', `schoolcode` varchar(20) NOT NULL DEFAULT '' COMMENT '学校代码', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='评论非法词'; -- ---------------------------- -- Table structure for onethink_website_recommend_list -- ---------------------------- DROP TABLE IF EXISTS `onethink_website_recommend_list`; CREATE TABLE `onethink_website_recommend_list` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID', `title` varchar(200) NOT NULL DEFAULT '' COMMENT '标题', `short_title` varchar(100) NOT NULL DEFAULT '' COMMENT '短标题', `desc` varchar(500) NOT NULL DEFAULT '' COMMENT '描述', `pic` varchar(255) NOT NULL DEFAULT '' COMMENT '缩略图完整URL', `content` varchar(500) NOT NULL DEFAULT '' COMMENT '完整访问地址', `content_type` tinyint(4) DEFAULT '1' COMMENT '内容类型（1url，2文本，3json）', `recommend_manage_id` int(11) DEFAULT NULL COMMENT '推荐位管理id', `sort` int(11) DEFAULT '0' COMMENT '排序', `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=849 DEFAULT CHARSET=utf8 COMMENT='推荐位资源列表'; -- ---------------------------- -- Table structure for onethink_website_recommend_manage -- ---------------------------- DROP TABLE IF EXISTS `onethink_website_recommend_manage`; CREATE TABLE `onethink_website_recommend_manage` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID', `name` varchar(100) DEFAULT '' COMMENT '推荐位名称', `ename` varchar(100) DEFAULT NULL COMMENT '英文名称', `code` varchar(30) DEFAULT '' COMMENT '推荐位标识代码（唯一）', `count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '资源数量', `desc` varchar(200) NOT NULL COMMENT '推荐位其他属性', `height` varchar(10) DEFAULT NULL COMMENT '高度', `width` varchar(10) DEFAULT NULL COMMENT '宽度', `schoolcode` varchar(255) DEFAULT NULL COMMENT '区域code', `view_count` int(11) DEFAULT '1' COMMENT '显示条数', `status` tinyint(4) DEFAULT '1' COMMENT '状态（1使用， 2禁用）', PRIMARY KEY (`id`), KEY `name` (`name`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8 COMMENT='推荐位管理'; -- ---------------------------- -- Table structure for `onethink_website_datacall` -- ---------------------------- DROP TABLE IF EXISTS `onethink_website_datacall`; CREATE TABLE `onethink_website_datacall` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '' COMMENT '调用名称', `datacode` varchar(30) NOT NULL DEFAULT '' COMMENT '数据调用代码，通过datacall函数调用', `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建人UID 0-系统默认调用', `method` varchar(200) NOT NULL DEFAULT '' COMMENT '执行方法（获取数据接口）', `count` smallint(5) NOT NULL DEFAULT '0' COMMENT '调用数据条数', `themecode` varchar(50) NOT NULL DEFAULT '' COMMENT '主题CODE', `tplcode` varchar(50) NOT NULL DEFAULT '' COMMENT '模板代码（主题模板中读取）', `cachetime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '缓存时长（秒）', `schoolcode` char(50) NOT NULL DEFAULT '' COMMENT '学校代码', `createtime` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间', `remark` varchar(200) DEFAULT '' COMMENT '数据备注', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='数据调用表'; INSERT INTO `onethink_website_datacall` VALUES ('2', '底部友情链接', 'friendlink', '52', 'friendlink.get', '5', 'default', '6bf57c02fdbf4fd5524d5737871e0fd2', '0', '', '0', ''); INSERT INTO `onethink_website_datacall` VALUES ('3', '底部通知', 'INDEX_NOTICE_BOTTOM', '52', 'notice.get', '5', 'default5', '1ea7f0eabd022b406ff1346acf1ed7af', '0', '', '1517887795', '调用方式如下，直播拷贝放到模板代码中\n{:datacall(\'INDEX_NOTICE_BOTTOM\', array(\'parentcatid\' => \'栏目ID\', \'catid\' => \'分类ID\'))}'); INSERT INTO `onethink_website_datacall` VALUES ('4', '主题5首页焦点图', 'INDEX_AD_FOCUS_5', '52', 'recommend.get', '5', 'default5', 'cf5fa68883a2d17d94094926a386d2f4', '0', '', '1518056226', '调用方式如下，直播拷贝放到模板代码中\n{:datacall(\'INDEX_AD_FOCUS_5\', array(\'code\' => \'INDEX_FOCUS\'))}'); INSERT INTO `onethink_website_datacall` VALUES ('5', '主题1首页焦点图', 'INDEX_AD_FOCUS_1', '2', 'recommend.get', '5', 'default2', 'c3968a79ba8947d4de78947b3c0bd063', '0', '', '1521080660', '调用方式如下，直播拷贝放到模板代码中\n{:datacall(\'INDEX_AD_FOCUS_1\', array(\'code\' => \'INDEX_FOCUS\'))}'); INSERT INTO `onethink_website_datacall` VALUES ('6', '主题2首页焦点图', 'INDEX_AD_FOCUS_2', '2', 'recommend.get', '5', 'default', 'fd7e798b8801cd712dcc0aebebca9bab', '0', '', '1521081730', '调用方式如下，直播拷贝放到模板代码中\n{:datacall(\'INDEX_AD_FOCUS_2\', array(\'code\' => \'INDEX_FOCUS\'))}');