/*
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', '[REDACTED]', '0', '', '0', '');
INSERT INTO `onethink_website_datacall` VALUES ('3', '底部通知', 'INDEX_NOTICE_BOTTOM', '52', 'notice.get', '5', 'default5', '[REDACTED]', '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', '[REDACTED]', '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', '[REDACTED]', '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', '[REDACTED]', '0', '', '1521081730', '调用方式如下，直播拷贝放到模板代码中\n{:datacall(\'INDEX_AD_FOCUS_2\', array(\'code\' => \'INDEX_FOCUS\'))}');
