-- ----------------------------------------
-- EyouCms MySQL Data Transfer
--
-- Server : 127.0.0.1_3306
-- Server Version : 5.5.53
-- Host : 127.0.0.1:3306
-- Database : eyoucms_develop
--
-- Part : #1
-- Version : #v1.3.0
-- Date : 2019-05-06 11:24:33
-- -----------------------------------------
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for ey_ad
-- ----------------------------
DROP TABLE IF EXISTS `ey_ad`;
CREATE TABLE `ey_ad` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '广告id',
`pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '广告位置ID',
`media_type` tinyint(1) DEFAULT '0' COMMENT '广告类型',
`title` varchar(60) DEFAULT '' COMMENT '广告名称',
`links` varchar(255) DEFAULT '' COMMENT '广告链接',
`litpic` varchar(255) DEFAULT '' COMMENT '图片地址',
`start_time` int(11) DEFAULT '0' COMMENT '投放时间',
`end_time` int(11) DEFAULT '0' COMMENT '结束时间',
`intro` text COMMENT '描述',
`link_man` varchar(60) DEFAULT '' COMMENT '添加人',
`link_email` varchar(60) DEFAULT '' COMMENT '添加人邮箱',
`link_phone` varchar(60) DEFAULT '' COMMENT '添加人联系电话',
`click` int(11) DEFAULT '0' COMMENT '点击量',
`bgcolor` varchar(30) DEFAULT '' COMMENT '背景颜色',
`status` tinyint(1) unsigned DEFAULT '1' COMMENT '1=显示,0=屏蔽',
`sort_order` int(11) DEFAULT '0' COMMENT '排序',
`target` varchar(50) DEFAULT '' COMMENT '是否开启浏览器新窗口',
`admin_id` int(10) DEFAULT '0' COMMENT '管理员ID',
`is_del` tinyint(1) DEFAULT '0' COMMENT '伪删除,1=是,0=否',
`lang` varchar(50) DEFAULT 'cn' COMMENT '多语言',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `position_id` (`pid`) USING BTREE,
KEY `status` (`status`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='广告表';
-- ----------------------------
-- Records of ey_ad
-- ----------------------------
-- ----------------------------
-- Table structure for ey_admin
-- ----------------------------
DROP TABLE IF EXISTS `ey_admin`;
CREATE TABLE `ey_admin` (
`admin_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户id',
`user_name` varchar(20) NOT NULL DEFAULT '' COMMENT '用户名',
`pen_name` varchar(50) DEFAULT '' COMMENT '笔名(发布文章后显示责任编辑的名字)',
`true_name` varchar(20) DEFAULT '' COMMENT '真实姓名',
`mobile` varchar(11) DEFAULT '' COMMENT '手机号码',
`email` varchar(60) DEFAULT '' COMMENT 'email',
`password` varchar(32) NOT NULL DEFAULT '' COMMENT '密码',
`last_login` int(11) DEFAULT '0' COMMENT '最后登录时间',
`last_ip` varchar(15) DEFAULT '' COMMENT '最后登录ip',
`login_cnt` int(11) DEFAULT '0' COMMENT '登录次数',
`session_id` varchar(50) DEFAULT '' COMMENT 'session_id',
`parent_id` int(10) DEFAULT '0' COMMENT '父管理员ID',
`role_id` int(10) NOT NULL DEFAULT '-1' COMMENT '角色组ID(-1表示超级管理员)',
`mark_lang` varchar(50) DEFAULT 'cn' COMMENT '当前语言标识',
`status` tinyint(1) DEFAULT '1' COMMENT '状态(0=屏蔽,1=正常)',
`add_time` int(11) DEFAULT '0' COMMENT '添加时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`admin_id`),
KEY `user_name` (`user_name`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='管理员表';
-- ----------------------------
-- Records of ey_admin
-- ----------------------------
INSERT INTO `ey_admin` VALUES ('1', 'admin', '', 'admin', '', '', '7959ec68e999edd0380ff0809f76fa42', '1531800409', '127.0.0.1', '2', 'r76o49mvds8mv8tgerd6uslct3', '0', '-1', 'cn', '1', '1531800397', '0');
-- ----------------------------
-- Table structure for ey_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `ey_admin_log`;
CREATE TABLE `ey_admin_log` (
`log_id` bigint(16) unsigned NOT NULL AUTO_INCREMENT COMMENT '表id',
`admin_id` int(10) NOT NULL DEFAULT '-1' COMMENT '管理员id',
`log_info` varchar(255) DEFAULT '' COMMENT '日志描述',
`log_ip` varchar(30) DEFAULT '' COMMENT 'ip地址',
`log_url` varchar(255) DEFAULT '' COMMENT 'url',
`log_time` int(11) DEFAULT '0' COMMENT '日志时间',
PRIMARY KEY (`log_id`),
KEY `admin_id` (`admin_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='管理员操作日志表';
-- ----------------------------
-- Records of ey_admin_log
-- ----------------------------
-- ----------------------------
-- Table structure for ey_ad_position
-- ----------------------------
DROP TABLE IF EXISTS `ey_ad_position`;
CREATE TABLE `ey_ad_position` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(60) DEFAULT '' COMMENT '广告位置名称',
`width` smallint(5) unsigned DEFAULT '0' COMMENT '广告位宽度',
`height` smallint(5) unsigned DEFAULT '0' COMMENT '广告位高度',
`intro` text COMMENT '广告描述',
`status` tinyint(1) DEFAULT '1' COMMENT '0关闭1开启',
`lang` varchar(50) DEFAULT 'cn' COMMENT '多语言',
`admin_id` int(10) DEFAULT '0' COMMENT '管理员ID',
`is_del` tinyint(1) DEFAULT '0' COMMENT '伪删除,1=是,0=否',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='广告位置表';
-- ----------------------------
-- Records of ey_ad_position
-- ----------------------------
-- ----------------------------
-- Table structure for ey_archives
-- ----------------------------
DROP TABLE IF EXISTS `ey_archives`;
CREATE TABLE `ey_archives` (
`aid` int(10) NOT NULL AUTO_INCREMENT,
`typeid` int(10) NOT NULL DEFAULT '0' COMMENT '当前栏目',
`channel` int(10) NOT NULL DEFAULT '0' COMMENT '模型ID',
`is_b` tinyint(1) DEFAULT '0' COMMENT '加粗',
`title` varchar(200) DEFAULT '' COMMENT '标题',
`litpic` varchar(250) DEFAULT '' COMMENT '封面图片',
`is_head` tinyint(1) DEFAULT '0' COMMENT '头条(0=否,1=是)',
`is_special` tinyint(1) DEFAULT '0' COMMENT '特荐(0=否,1=是)',
`is_top` tinyint(1) DEFAULT '0' COMMENT '置顶(0=否,1=是)',
`is_recom` tinyint(1) DEFAULT '0' COMMENT '推荐(0=否,1=是)',
`is_jump` tinyint(1) DEFAULT '0' COMMENT '跳转链接(0=否,1=是)',
`author` varchar(200) DEFAULT '' COMMENT '作者',
`click` int(10) DEFAULT '0' COMMENT '浏览量',
`arcrank` tinyint(1) DEFAULT '0' COMMENT '阅读权限:0=开放浏览,-1=待审核稿件',
`jumplinks` varchar(200) DEFAULT '' COMMENT '外链跳转',
`ismake` tinyint(1) DEFAULT '0' COMMENT '是否静态页面(0=动态,1=静态)',
`seo_title` varchar(200) DEFAULT '' COMMENT 'SEO标题',
`seo_keywords` varchar(200) DEFAULT '' COMMENT 'SEO关键词',
`seo_description` text COMMENT 'SEO描述',
`status` tinyint(1) DEFAULT '1' COMMENT '状态(0=屏蔽,1=正常)',
`sort_order` int(10) DEFAULT '0' COMMENT '排序号',
`lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
`admin_id` int(10) DEFAULT '0' COMMENT '管理员ID',
`is_del` tinyint(1) DEFAULT '0' COMMENT '伪删除,1=是,0=否',
`del_method` tinyint(1) DEFAULT '0' COMMENT '伪删除状态,1为主动删除,2为跟随上级栏目被动删除',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`aid`),
KEY `aid` (`typeid`,`channel`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文档主表';
-- ----------------------------
-- Records of ey_archives
-- ----------------------------
-- ----------------------------
-- Table structure for ey_arcmulti
-- ----------------------------
DROP TABLE IF EXISTS `ey_arcmulti`;
CREATE TABLE `ey_arcmulti` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`tagid` varchar(60) NOT NULL DEFAULT '' COMMENT '标签ID',
`tagname` varchar(60) NOT NULL DEFAULT '' COMMENT '标签名',
`innertext` text NOT NULL COMMENT '标签模板代码',
`pagesize` int(10) NOT NULL DEFAULT '0' COMMENT '分页列表',
`querysql` text NOT NULL COMMENT '完整SQL',
`ordersql` varchar(200) DEFAULT '' COMMENT '排序SQL',
`addfieldsSql` varchar(255) DEFAULT '' COMMENT '附加字段SQL',
`addtableName` varchar(50) DEFAULT '' COMMENT '附加字段的数据表,不包含表前缀',
`attstr` text COMMENT '属性字符串',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='多页标记存储数据表';
-- ----------------------------
-- Records of ey_arcmulti
-- ----------------------------
-- ----------------------------
-- Table structure for ey_arcrank
-- ----------------------------
DROP TABLE IF EXISTS `ey_arcrank`;
CREATE TABLE `ey_arcrank` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '权限ID',
`rank` smallint(6) DEFAULT '0' COMMENT '权限值',
`name` char(20) DEFAULT '' COMMENT '会员名称',
`lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='文档阅读权限表';
-- ----------------------------
-- Records of ey_arcrank
-- ----------------------------
INSERT INTO `ey_arcrank` VALUES ('1', '0', '开放浏览', 'cn', '0', '1552376880');
INSERT INTO `ey_arcrank` VALUES ('2', '-1', '待审核稿件', 'cn', '0', '1552376880');
-- ----------------------------
-- Table structure for ey_arctype
-- ----------------------------
DROP TABLE IF EXISTS `ey_arctype`;
CREATE TABLE `ey_arctype` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '栏目ID',
`channeltype` int(10) DEFAULT '0' COMMENT '栏目顶级模型ID',
`current_channel` int(10) DEFAULT '0' COMMENT '栏目当前模型ID',
`parent_id` int(10) DEFAULT '0' COMMENT '栏目上级ID',
`typename` varchar(200) DEFAULT '' COMMENT '栏目名称',
`dirname` varchar(200) DEFAULT '' COMMENT '目录英文名',
`dirpath` varchar(200) DEFAULT '' COMMENT '目录存放HTML路径',
`englist_name` varchar(200) DEFAULT '' COMMENT '栏目英文名',
`grade` tinyint(1) DEFAULT '0' COMMENT '栏目等级',
`typelink` varchar(200) DEFAULT '' COMMENT '栏目链接',
`litpic` varchar(250) DEFAULT '' COMMENT '栏目图片',
`templist` varchar(200) DEFAULT '' COMMENT '列表模板文件名',
`tempview` varchar(200) DEFAULT '' COMMENT '文档模板文件名',
`seo_title` varchar(200) DEFAULT '' COMMENT 'SEO标题',
`seo_keywords` varchar(200) DEFAULT '' COMMENT 'seo关键字',
`seo_description` text COMMENT 'seo描述',
`sort_order` int(10) DEFAULT '0' COMMENT '排序号',
`is_hidden` tinyint(1) DEFAULT '0' COMMENT '是否隐藏栏目:0=显示,1=隐藏',
`is_part` tinyint(1) DEFAULT '0' COMMENT '栏目属性:0=内容栏目,1=外部链接',
`admin_id` int(10) DEFAULT '0' COMMENT '管理员ID',
`is_del` tinyint(1) DEFAULT '0' COMMENT '伪删除,1=是,0=否',
`del_method` tinyint(1) DEFAULT '0' COMMENT '伪删除状态,1为主动删除,2为跟随上级栏目被动删除',
`status` tinyint(1) DEFAULT '1' COMMENT '启用 (1=正常,0=屏蔽)',
`lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `dirname` (`dirname`,`lang`) USING BTREE,
KEY `parent_id` (`channeltype`,`parent_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文档栏目表';
-- ----------------------------
-- Records of ey_arctype
-- ----------------------------
-- ----------------------------
-- Table structure for ey_article_content
-- ----------------------------
DROP TABLE IF EXISTS `ey_article_content`;
CREATE TABLE `ey_article_content` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`aid` int(10) DEFAULT '0' COMMENT '文档ID',
`content` longtext COMMENT '内容详情',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `news_id` (`aid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='资讯内容表_存储正常内容';
-- ----------------------------
-- Records of ey_article_content
-- ----------------------------
-- ----------------------------
-- Table structure for ey_auth_role
-- ----------------------------
DROP TABLE IF EXISTS `ey_auth_role`;
CREATE TABLE `ey_auth_role` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT '' COMMENT '角色名',
`pid` int(10) DEFAULT '0' COMMENT '父角色ID',
`remark` text COMMENT '备注信息',
`grade` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '级别',
`language` text COMMENT '多语言权限',
`online_update` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '在线升级',
`only_oneself` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '只看自己发布',
`cud` varchar(255) DEFAULT '' COMMENT '增改删',
`permission` text COMMENT '已允许的权限',
`built_in` tinyint(1) DEFAULT '0' COMMENT '内置用户组,1表示内置',
`sort_order` int(10) DEFAULT '0' COMMENT '排序号',
`status` tinyint(1) DEFAULT '1' COMMENT '状态(1=正常,0=屏蔽)',
`admin_id` int(10) DEFAULT '0' COMMENT '操作管理员ID',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='管理员角色表';
-- ----------------------------
-- Records of ey_auth_role
-- ----------------------------
INSERT INTO `ey_auth_role` VALUES ('1', '优化推广员', '0', '', '0', null, '0', '1', 'a:3:{i:0;s:3:\"add\";i:1;s:4:\"edit\";i:2;s:3:\"del\";}', 'a:2:{s:5:\"rules\";a:8:{i:0;s:1:\"1\";i:1;s:1:\"3\";i:2;s:1:\"4\";i:3;s:1:\"8\";i:4;s:1:\"9\";i:5;s:2:\"10\";i:6;s:2:\"14\";i:7;i:2;}s:7:\"arctype\";a:27:{i:0;s:1:\"1\";i:1;s:1:\"2\";i:2;s:1:\"3\";i:3;s:1:\"4\";i:4;s:1:\"5\";i:5;s:1:\"6\";i:6;s:2:\"33\";i:7;s:2:\"34\";i:8;s:2:\"35\";i:9;s:1:\"8\";i:10;s:2:\"32\";i:11;s:1:\"9\";i:12;s:2:\"30\";i:13;s:2:\"31\";i:14;s:2:\"11\";i:15;s:2:\"12\";i:16;s:2:\"13\";i:17;s:2:\"23\";i:18;s:2:\"20\";i:19;s:2:\"24\";i:20;s:2:\"25\";i:21;s:2:\"21\";i:22;s:2:\"26\";i:23;s:2:\"22\";i:24;s:2:\"27\";i:25;s:2:\"28\";i:26;s:2:\"29\";}}', '1', '100', '1', '0', '1541058693', '1541058693');
INSERT INTO `ey_auth_role` VALUES ('2', '内容管理员', '0', '', '0', null, '0', '1', 'a:3:{i:0;s:3:\"add\";i:1;s:4:\"edit\";i:2;s:3:\"del\";}', 'a:2:{s:5:\"rules\";a:4:{i:0;s:1:\"1\";i:1;s:2:\"10\";i:2;s:2:\"14\";i:3;i:2;}s:7:\"arctype\";a:27:{i:0;s:1:\"1\";i:1;s:1:\"2\";i:2;s:1:\"3\";i:3;s:1:\"4\";i:4;s:1:\"5\";i:5;s:1:\"6\";i:6;s:2:\"33\";i:7;s:2:\"34\";i:8;s:2:\"35\";i:9;s:1:\"8\";i:10;s:2:\"32\";i:11;s:1:\"9\";i:12;s:2:\"30\";i:13;s:2:\"31\";i:14;s:2:\"11\";i:15;s:2:\"12\";i:16;s:2:\"13\";i:17;s:2:\"23\";i:18;s:2:\"20\";i:19;s:2:\"24\";i:20;s:2:\"25\";i:21;s:2:\"21\";i:22;s:2:\"26\";i:23;s:2:\"22\";i:24;s:2:\"27\";i:25;s:2:\"28\";i:26;s:2:\"29\";}}', '1', '100', '1', '0', '1541059290', '1541059290');
-- ----------------------------
-- Table structure for ey_channelfield
-- ----------------------------
DROP TABLE IF EXISTS `ey_channelfield`;
CREATE TABLE `ey_channelfield` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`name` varchar(32) NOT NULL DEFAULT '' COMMENT '字段名称',
`channel_id` int(10) NOT NULL DEFAULT '0' COMMENT '所属文档模型id',
`title` varchar(32) NOT NULL DEFAULT '' COMMENT '字段标题',
`dtype` varchar(32) NOT NULL DEFAULT '' COMMENT '字段类型',
`define` varchar(128) NOT NULL DEFAULT '' COMMENT '字段定义',
`maxlength` int(10) NOT NULL DEFAULT '0' COMMENT '最大长度,文本数据必须填写,大于255为text类型',
`dfvalue` varchar(1000) NOT NULL DEFAULT '' COMMENT '默认值',
`dfvalue_unit` varchar(50) NOT NULL DEFAULT '' COMMENT '数值单位',
`remark` varchar(256) NOT NULL DEFAULT '' COMMENT '提示说明',
`ifeditable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否在编辑页显示',
`ifrequire` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否必填',
`ifsystem` tinyint(1) NOT NULL DEFAULT '0' COMMENT '字段分类,1=系统(不可修改),0=自定义',
`ifmain` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否主表字段',
`ifcontrol` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态,控制该条数据是否允许被控制,1为不允许控制,0为允许控制',
`sort_order` int(5) NOT NULL DEFAULT '100' COMMENT '排序',
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
`add_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
`update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`,`channel_id`)
) ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='自定义字段表';
-- ----------------------------
-- Records of ey_channelfield
-- ----------------------------
INSERT INTO `ey_channelfield` VALUES ('1', 'add_time', '0', '新增时间', 'datetime', 'int(11)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533091575', '1533091575');
INSERT INTO `ey_channelfield` VALUES ('2', 'update_time', '0', '更新时间', 'datetime', 'int(11)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533091601', '1533091601');
INSERT INTO `ey_channelfield` VALUES ('3', 'aid', '0', '文档ID', 'int', 'int(11)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533091624', '1533091624');
INSERT INTO `ey_channelfield` VALUES ('4', 'typeid', '0', '当前栏目ID', 'int', 'int(11)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533091930', '1533091930');
INSERT INTO `ey_channelfield` VALUES ('5', 'channel', '0', '模型ID', 'int', 'int(11)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533092214', '1533092214');
INSERT INTO `ey_channelfield` VALUES ('6', 'is_b', '0', '是否加粗', 'switch', 'tinyint(1)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533092246', '1533092246');
INSERT INTO `ey_channelfield` VALUES ('7', 'title', '0', '文档标题', 'text', 'varchar(250)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533092381', '1533092381');
INSERT INTO `ey_channelfield` VALUES ('8', 'litpic', '0', '封面图片', 'img', 'varchar(250)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533092398', '1533092398');
INSERT INTO `ey_channelfield` VALUES ('9', 'is_head', '0', '是否头条', 'switch', 'tinyint(1)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533092420', '1533092420');
INSERT INTO `ey_channelfield` VALUES ('10', 'is_special', '0', '是否特荐', 'switch', 'tinyint(1)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533092439', '1533092439');
INSERT INTO `ey_channelfield` VALUES ('11', 'is_top', '0', '是否置顶', 'switch', 'tinyint(1)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533092454', '1533092454');
INSERT INTO `ey_channelfield` VALUES ('12', 'is_recom', '0', '是否推荐', 'switch', 'tinyint(1)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533092468', '1533092468');
INSERT INTO `ey_channelfield` VALUES ('13', 'is_jump', '0', '是否跳转', 'switch', 'tinyint(1)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533092484', '1533092484');
INSERT INTO `ey_channelfield` VALUES ('14', 'author', '0', '作者', 'text', 'varchar(250)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533092498', '1533092498');
INSERT INTO `ey_channelfield` VALUES ('15', 'click', '0', '浏览量', 'int', 'int(11)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533092512', '1533092512');
INSERT INTO `ey_channelfield` VALUES ('16', 'arcrank', '0', '阅读权限', 'select', 'tinyint(1)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533092534', '1533092534');
INSERT INTO `ey_channelfield` VALUES ('17', 'jumplinks', '0', '跳转链接', 'text', 'varchar(250)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533092553', '1533092553');
INSERT INTO `ey_channelfield` VALUES ('18', 'ismake', '0', '是否静态页面', 'switch', 'tinyint(1)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533092698', '1533092698');
INSERT INTO `ey_channelfield` VALUES ('19', 'seo_title', '0', 'SEO标题', 'text', 'varchar(250)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533092713', '1533092713');
INSERT INTO `ey_channelfield` VALUES ('20', 'seo_keywords', '0', 'SEO关键词', 'text', 'varchar(250)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533092725', '1533092725');
INSERT INTO `ey_channelfield` VALUES ('21', 'seo_description', '0', 'SEO描述', 'text', 'varchar(250)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533092739', '1533092739');
INSERT INTO `ey_channelfield` VALUES ('22', 'status', '0', '状态', 'switch', 'tinyint(1)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533092753', '1533092753');
INSERT INTO `ey_channelfield` VALUES ('23', 'sort_order', '0', '排序号', 'int', 'int(11)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533092766', '1533092766');
INSERT INTO `ey_channelfield` VALUES ('24', 'content', '2', '内容', 'htmltext', 'longtext', '250', '', '', '', '1', '0', '1', '0', '0', '100', '1', '1533359739', '1533359739');
INSERT INTO `ey_channelfield` VALUES ('25', 'content', '3', '内容详情', 'htmltext', 'longtext', '250', '', '', '', '1', '0', '1', '0', '0', '100', '1', '1533359588', '1533359588');
INSERT INTO `ey_channelfield` VALUES ('26', 'content', '4', '内容详情', 'htmltext', 'longtext', '250', '', '', '', '1', '0', '1', '0', '0', '100', '1', '1533359752', '1533359752');
INSERT INTO `ey_channelfield` VALUES ('27', 'content', '6', '内容详情', 'htmltext', 'longtext', '250', '', '', '', '1', '0', '1', '0', '0', '100', '1', '1533464715', '1533464715');
INSERT INTO `ey_channelfield` VALUES ('29', 'content', '1', '内容详情', 'htmltext', 'longtext', '250', '', '', '', '1', '0', '1', '0', '0', '100', '1', '1533464713', '1533464713');
INSERT INTO `ey_channelfield` VALUES ('30', 'update_time', '-99', '更新时间', 'datetime', 'int(11)', '11', '0', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('31', 'add_time', '-99', '新增时间', 'datetime', 'int(11)', '11', '0', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('32', 'status', '-99', '启用 (1=正常,0=屏蔽)', 'switch', 'tinyint(1)', '1', '1', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('33', 'is_part', '-99', '栏目属性:0=内容栏目,1=外部链接', 'switch', 'tinyint(1)', '1', '0', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('34', 'is_hidden', '-99', '是否隐藏栏目:0=显示,1=隐藏', 'switch', 'tinyint(1)', '1', '0', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('35', 'sort_order', '-99', '排序号', 'int', 'int(10)', '10', '0', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('36', 'seo_description', '-99', 'seo描述', 'multitext', 'text', '0', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('37', 'seo_keywords', '-99', 'seo关键字', 'text', 'varchar(200)', '200', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('38', 'seo_title', '-99', 'SEO标题', 'text', 'varchar(200)', '200', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('39', 'tempview', '-99', '文档模板文件名', 'text', 'varchar(200)', '200', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('40', 'templist', '-99', '列表模板文件名', 'text', 'varchar(200)', '200', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('41', 'litpic', '-99', '栏目图片', 'img', 'varchar(250)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('42', 'typelink', '-99', '栏目链接', 'text', 'varchar(200)', '200', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('43', 'grade', '-99', '栏目等级', 'switch', 'tinyint(1)', '1', '0', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('44', 'englist_name', '-99', '栏目英文名', 'text', 'varchar(200)', '200', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('45', 'dirpath', '-99', '目录存放HTML路径', 'text', 'varchar(200)', '200', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('46', 'dirname', '-99', '目录英文名', 'text', 'varchar(200)', '200', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('47', 'typename', '-99', '栏目名称', 'text', 'varchar(200)', '200', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('48', 'parent_id', '-99', '栏目上级ID', 'int', 'int(10)', '10', '0', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('49', 'current_channel', '-99', '栏目当前模型ID', 'int', 'int(10)', '10', '0', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('50', 'channeltype', '-99', '栏目顶级模型ID', 'int', 'int(10)', '10', '0', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('51', 'id', '-99', '栏目ID', 'int', 'int(10)', '10', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1533524780', '1533524780');
INSERT INTO `ey_channelfield` VALUES ('52', 'del_method', '-99', '伪删除状态,1为主动删除,2为跟随上级栏目被动删除', 'switch', 'tinyint(1)', '1', '0', '', '', '1', '0', '1', '1', '1', '100', '1', '1547890773', '1547890773');
INSERT INTO `ey_channelfield` VALUES ('53', 'is_del', '0', '伪删除,1=是,0=否', 'switch', 'tinyint(1)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1547890773', '1547890773');
INSERT INTO `ey_channelfield` VALUES ('54', 'del_method', '0', '伪删除状态,1为主动删除,2为跟随上级栏目被动删除', 'switch', 'tinyint(1)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1547890773', '1547890773');
INSERT INTO `ey_channelfield` VALUES ('55', 'admin_id', '0', '管理员ID', 'int', 'int(10)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1547890773', '1547890773');
INSERT INTO `ey_channelfield` VALUES ('56', 'lang', '0', '语言标识', 'text', 'varchar(250)', '250', '', '', '', '1', '0', '1', '1', '1', '100', '1', '1547890773', '1547890773');
-- ----------------------------
-- Table structure for ey_channelfield_bind
-- ----------------------------
DROP TABLE IF EXISTS `ey_channelfield_bind`;
CREATE TABLE `ey_channelfield_bind` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`typeid` int(10) DEFAULT '0' COMMENT '栏目ID',
`field_id` int(10) DEFAULT '0' COMMENT '自定义字段ID',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='栏目与自定义字段绑定表';
-- ----------------------------
-- Records of ey_channelfield_bind
-- ----------------------------
-- ----------------------------
-- Table structure for ey_channeltype
-- ----------------------------
DROP TABLE IF EXISTS `ey_channeltype`;
CREATE TABLE `ey_channeltype` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nid` varchar(50) NOT NULL DEFAULT '' COMMENT '识别id',
`title` varchar(30) DEFAULT '' COMMENT '名称',
`ntitle` varchar(30) DEFAULT '' COMMENT '左侧菜单名称',
`table` varchar(50) DEFAULT '' COMMENT '表名',
`ctl_name` varchar(50) DEFAULT '' COMMENT '控制器名称(区分大小写)',
`status` tinyint(1) DEFAULT '1' COMMENT '状态(1=启用,0=屏蔽)',
`ifsystem` tinyint(1) DEFAULT '0' COMMENT '字段分类,1=系统(不可修改),0=自定义',
`is_repeat_title` tinyint(1) DEFAULT '1' COMMENT '文档标题重复,1=允许,0=不允许',
`is_del` tinyint(1) DEFAULT '0' COMMENT '伪删除,1=是,0=否',
`sort_order` smallint(6) DEFAULT '50' COMMENT '排序',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `idention` (`nid`) USING BTREE,
UNIQUE KEY `ctl_name` (`ctl_name`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='系统模型表';
-- ----------------------------
-- Records of ey_channeltype
-- ----------------------------
INSERT INTO `ey_channeltype` VALUES ('1', 'article', '文章模型', '文章', 'article', 'Article', '1', '1', '1', '0', '1', '0', '1531800410');
INSERT INTO `ey_channeltype` VALUES ('4', 'download', '下载模型', '下载', 'download', 'Download', '1', '1', '1', '0', '4', '0', '1531800410');
INSERT INTO `ey_channeltype` VALUES ('2', 'product', '产品模型', '产品', 'product', 'Product', '1', '1', '1', '0', '2', '0', '1531800410');
INSERT INTO `ey_channeltype` VALUES ('8', 'guestbook', '留言模型', '留言', 'guestbook', 'Guestbook', '1', '1', '1', '0', '8', '1509197711', '1531800410');
INSERT INTO `ey_channeltype` VALUES ('6', 'single', '单页模型', '单页', 'single', 'Single', '1', '1', '1', '0', '6', '1523091961', '1531800410');
INSERT INTO `ey_channeltype` VALUES ('3', 'images', '图集模型', '图集', 'images', 'Images', '1', '1', '1', '0', '3', '1523929121', '1531800410');
-- ----------------------------
-- Table structure for ey_config
-- ----------------------------
DROP TABLE IF EXISTS `ey_config`;
CREATE TABLE `ey_config` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT '' COMMENT '配置的key键名',
`value` text,
`inc_type` varchar(64) DEFAULT '' COMMENT '配置分组',
`desc` varchar(50) DEFAULT '' COMMENT '描述',
`lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
`is_del` tinyint(1) DEFAULT '0' COMMENT '是否已删除,0=否,1=是',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=utf8 COMMENT='系统配置表';
-- ----------------------------
-- Records of ey_config
-- ----------------------------
INSERT INTO `ey_config` VALUES ('1', 'is_mark', '0', 'water', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('2', 'mark_txt', '易优Cms', 'water', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('3', 'mark_img', '/public/upload/water/2018/05/08/93806077e5a4c4e12ceed30df5cde761.png', 'water', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('4', 'mark_width', '200', 'water', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('5', 'mark_height', '50', 'water', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('6', 'mark_degree', '54', 'water', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('7', 'mark_quality', '56', 'water', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('8', 'mark_sel', '9', 'water', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('9', 'sms_time_out', '120', 'sms', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('10', 'theme_style', '1', 'basic', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('11', 'file_size', '500', 'basic', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('12', 'image_type', 'jpg|gif|png|bmp|jpeg|ico', 'basic', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('13', 'file_type', 'zip|gz|rar|iso|doc|xsl|ppt|wps', 'basic', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('14', 'media_type', 'swf|mpg|mp3|rm|rmvb|wmv|wma|wav|mid|mov|mp4', 'basic', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('15', 'web_keywords', '', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('17', 'sms_platform', '1', 'sms', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('18', 'seo_viewtitle_format', '2', 'seo', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('19', 'smtp_server', 'smtp.qq.com', 'smtp', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('20', 'smtp_port', '465', 'smtp', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('21', 'smtp_user', 'xxxxxxxxx@qq.com', 'smtp', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('22', 'smtp_pwd', 'xxxxxxxxxxx', 'smtp', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('23', 'inc_type', 'smtp', 'smtp', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('24', 'mark_type', 'img', 'water', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('25', 'mark_txt_size', '30', 'water', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('26', 'mark_txt_color', '#000000', 'water', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('27', 'oss_switch', '0', 'oss', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('28', 'web_name', '易优Cms-演示站', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('29', 'web_logo', '/public/upload/system/2018/05/24/8c675d3dae162ebc1936f3ab43d58960.png', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('30', 'web_ico', '/favicon.ico', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('31', 'web_basehost', 'http://127.0.0.5', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('32', 'web_description', '', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('79', 'web_recordnum', '琼ICP备xxxxxxxx号', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('33', 'web_copyright', 'Copyright © 2012-2018 EYOUCMS. 易优CMS 版权所有', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('34', 'web_thirdcode_pc', '', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('35', 'web_thirdcode_wap', '', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('39', 'seo_arcdir', '/html', 'seo', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('40', 'seo_pseudo', '1', 'seo', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('41', 'list_symbol', '>', 'basic', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('42', 'sitemap_auto', '1', 'sitemap', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('43', 'sitemap_not1', '0', 'sitemap', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('44', 'sitemap_not2', '1', 'sitemap', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('45', 'sitemap_xml', '1', 'sitemap', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('46', 'sitemap_txt', '0', 'sitemap', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('47', 'sitemap_zzbaidutoken', '', 'sitemap', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('48', 'seo_expires_in', '7200', 'seo', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('55', 'web_title', '易优CMS - Powered by Eyoucms.com', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('56', 'smtp_test_eamil', 'xxxxxxxx@qq.com', 'smtp', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('57', 'web_authortoken', '', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('62', 'seo_inlet', '1', 'seo', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('63', 'web_cmspath', '', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('64', 'web_sqldatapath', '/data/sqldata', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('65', 'web_cmsurl', '', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('66', 'web_templets_dir', '/template', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('67', 'web_templeturl', '/template', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('68', 'web_templets_pc', '/template/pc', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('69', 'web_templets_m', '/template/mobile', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('70', 'web_eyoucms', 'http://www.eyoucms.com', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('78', '_cmscopyright', 'jdFbzvsEHAAzE6PfTTropP7s', 'php', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('76', 'seo_liststitle_format', '2', 'seo', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('77', 'web_status', '0', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('80', 'web_is_authortoken', '-1', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('81', 'web_adminbasefile', '/login.php', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('82', 'seo_rewrite_format', '1', 'seo', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('83', 'web_cmsmode', '2', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('84', 'web_htmlcache_expires_in', '7200', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('85', 'web_show_popup_upgrade', '1', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('86', 'web_weapp_switch', '-1', 'web', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('88', 'seo_dynamic_format', '1', 'seo', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('89', 'system_sql_mode', 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION', 'system', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('90', 'system_home_default_lang', 'cn', 'system', '', 'cn', '0', '0');
INSERT INTO `ey_config` VALUES ('91', 'system_langnum', '1', 'system', '', 'cn', '0', '0');
-- ----------------------------
-- Table structure for ey_config_attribute
-- ----------------------------
DROP TABLE IF EXISTS `ey_config_attribute`;
CREATE TABLE `ey_config_attribute` (
`attr_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '表单id',
`inc_type` varchar(20) DEFAULT '' COMMENT '变量分组',
`attr_name` varchar(60) DEFAULT '' COMMENT '变量标题',
`attr_var_name` varchar(50) DEFAULT '' COMMENT '变量名',
`attr_input_type` tinyint(1) unsigned DEFAULT '0' COMMENT ' 0=文本框,1=下拉框,2=多行文本框,3=上传图片',
`lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`attr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='自定义变量表';
-- ----------------------------
-- Records of ey_config_attribute
-- ----------------------------
-- ----------------------------
-- Table structure for ey_download_content
-- ----------------------------
DROP TABLE IF EXISTS `ey_download_content`;
CREATE TABLE `ey_download_content` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`aid` int(10) DEFAULT '0' COMMENT '文档ID',
`content` longtext COMMENT '内容详情',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `news_id` (`aid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='资讯内容表_存储正常内容';
-- ----------------------------
-- Records of ey_download_content
-- ----------------------------
-- ----------------------------
-- Table structure for ey_download_file
-- ----------------------------
DROP TABLE IF EXISTS `ey_download_file`;
CREATE TABLE `ey_download_file` (
`file_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`aid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '产品ID',
`title` varchar(200) DEFAULT '' COMMENT '产品标题',
`file_url` varchar(255) DEFAULT '' COMMENT '文件存储路径',
`file_size` varchar(255) DEFAULT '' COMMENT '文件大小',
`file_ext` varchar(50) DEFAULT '' COMMENT '文件后缀名',
`file_name` varchar(200) DEFAULT '' COMMENT '文件名',
`file_mime` varchar(200) DEFAULT '' COMMENT '文件类型',
`uhash` varchar(200) DEFAULT '' COMMENT '自定义的一种加密方式,用于文件下载权限验证',
`md5file` varchar(200) DEFAULT '' COMMENT 'md5_file加密,可以检测上传/下载的文件包是否损坏',
`sort_order` smallint(5) DEFAULT '0' COMMENT '排序',
`add_time` int(10) unsigned DEFAULT '0' COMMENT '上传时间',
PRIMARY KEY (`file_id`),
KEY `arcid` (`aid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='下载附件表';
-- ----------------------------
-- Records of ey_download_file
-- ----------------------------
-- ----------------------------
-- Table structure for ey_field_type
-- ----------------------------
DROP TABLE IF EXISTS `ey_field_type`;
CREATE TABLE `ey_field_type` (
`name` varchar(32) NOT NULL DEFAULT '' COMMENT '字段类型',
`title` varchar(64) NOT NULL DEFAULT '' COMMENT '中文类型名',
`ifoption` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否需要设置选项',
`sort_order` int(10) NOT NULL DEFAULT '0' COMMENT '排序',
`add_time` int(11) NOT NULL DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`name`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='字段类型表';
-- ----------------------------
-- Records of ey_field_type
-- ----------------------------
INSERT INTO `ey_field_type` VALUES ('text', '单行文本', '0', '1', '1532485708', '1532485708');
INSERT INTO `ey_field_type` VALUES ('checkbox', '多选项', '1', '5', '1532485708', '1532485708');
INSERT INTO `ey_field_type` VALUES ('multitext', '多行文本', '0', '2', '1532485708', '1532485708');
INSERT INTO `ey_field_type` VALUES ('radio', '单选项', '1', '4', '1532485708', '1532485708');
INSERT INTO `ey_field_type` VALUES ('switch', '开关', '0', '13', '1532485708', '1532485708');
INSERT INTO `ey_field_type` VALUES ('select', '下拉框', '1', '6', '1532485708', '1532485708');
INSERT INTO `ey_field_type` VALUES ('img', '单张图', '0', '10', '1532485708', '1532485708');
INSERT INTO `ey_field_type` VALUES ('int', '整数类型', '0', '7', '1532485708', '1532485708');
INSERT INTO `ey_field_type` VALUES ('datetime', '日期和时间', '0', '12', '1532485708', '1532485708');
INSERT INTO `ey_field_type` VALUES ('htmltext', 'HTML文本', '0', '3', '1532485708', '1532485708');
INSERT INTO `ey_field_type` VALUES ('imgs', '多张图', '0', '11', '1532485708', '1532485708');
INSERT INTO `ey_field_type` VALUES ('decimal', '金额类型', '0', '9', '1532485708', '1532485708');
INSERT INTO `ey_field_type` VALUES ('float', '小数类型', '0', '8', '1532485708', '1532485708');
-- ----------------------------
-- Table structure for ey_guestbook
-- ----------------------------
DROP TABLE IF EXISTS `ey_guestbook`;
CREATE TABLE `ey_guestbook` (
`aid` int(11) NOT NULL AUTO_INCREMENT,
`typeid` int(11) DEFAULT '0' COMMENT '栏目ID',
`channel` smallint(5) DEFAULT '0' COMMENT '模型ID',
`md5data` varchar(50) DEFAULT '' COMMENT '数据序列化之后的MD5加密,提交内容的唯一性',
`ip` varchar(255) DEFAULT '' COMMENT 'ip地址',
`lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='留言主表';
-- ----------------------------
-- Records of ey_guestbook
-- ----------------------------
-- ----------------------------
-- Table structure for ey_guestbook_attr
-- ----------------------------
DROP TABLE IF EXISTS `ey_guestbook_attr`;
CREATE TABLE `ey_guestbook_attr` (
`guest_attr_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '留言表单id自增',
`aid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '留言id',
`attr_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '表单id',
`attr_value` text COMMENT '表单值',
`lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`guest_attr_id`),
KEY `attr_id` (`attr_id`) USING BTREE,
KEY `guest_id` (`aid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='留言表单属性值';
-- ----------------------------
-- Records of ey_guestbook_attr
-- ----------------------------
-- ----------------------------
-- Table structure for ey_guestbook_attribute
-- ----------------------------
DROP TABLE IF EXISTS `ey_guestbook_attribute`;
CREATE TABLE `ey_guestbook_attribute` (
`attr_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '表单id',
`attr_name` varchar(60) DEFAULT '' COMMENT '表单名称',
`typeid` int(11) unsigned DEFAULT '0' COMMENT '栏目ID',
`attr_input_type` tinyint(1) unsigned DEFAULT '0' COMMENT ' 0=文本框,1=下拉框,2=多行文本框',
`attr_values` text COMMENT '可选值列表',
`sort_order` int(11) unsigned DEFAULT '0' COMMENT '表单排序',
`lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
`is_del` tinyint(1) DEFAULT '0' COMMENT '是否已删除,0=否,1=是',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`attr_id`),
KEY `guest_id` (`typeid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='留言表单属性';
-- ----------------------------
-- Records of ey_guestbook_attribute
-- ----------------------------
-- ----------------------------
-- Table structure for ey_hooks
-- ----------------------------
DROP TABLE IF EXISTS `ey_hooks`;
CREATE TABLE `ey_hooks` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '钩子名称',
`description` text COMMENT '描述',
`module` varchar(50) DEFAULT '' COMMENT '钩子挂载的插件',
`status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态:0=无效,1=有效',
`add_time` int(10) DEFAULT NULL,
`update_time` int(10) unsigned DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `name` (`name`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='插件钩子表';
-- ----------------------------
-- Records of ey_hooks
-- ----------------------------
-- ----------------------------
-- Table structure for ey_images_content
-- ----------------------------
DROP TABLE IF EXISTS `ey_images_content`;
CREATE TABLE `ey_images_content` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`aid` int(10) DEFAULT '0' COMMENT '文档ID',
`content` longtext COMMENT '内容详情',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `news_id` (`aid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='资讯内容表_存储正常内容';
-- ----------------------------
-- Records of ey_images_content
-- ----------------------------
-- ----------------------------
-- Table structure for ey_images_upload
-- ----------------------------
DROP TABLE IF EXISTS `ey_images_upload`;
CREATE TABLE `ey_images_upload` (
`img_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`aid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '图集ID',
`title` varchar(200) DEFAULT '' COMMENT '产品标题',
`image_url` varchar(255) DEFAULT '' COMMENT '文件存储路径',
`width` int(11) DEFAULT '0' COMMENT '图片宽度',
`height` int(11) DEFAULT '0' COMMENT '图片高度',
`filesize` mediumint(8) unsigned DEFAULT '0' COMMENT '文件大小',
`mime` varchar(50) DEFAULT '' COMMENT '图片类型',
`sort_order` smallint(5) DEFAULT '0' COMMENT '排序',
`add_time` int(10) unsigned DEFAULT '0' COMMENT '上传时间',
PRIMARY KEY (`img_id`),
KEY `arcid` (`aid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='图集图片表';
-- ----------------------------
-- Records of ey_images_upload
-- ----------------------------
-- ----------------------------
-- Table structure for ey_language
-- ----------------------------
DROP TABLE IF EXISTS `ey_language`;
CREATE TABLE `ey_language` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '信息ID,自增',
`title` varchar(100) NOT NULL DEFAULT '' COMMENT '语言名称',
`mark` varchar(50) NOT NULL DEFAULT '' COMMENT '语言标识(唯一)',
`url` varchar(200) NOT NULL DEFAULT '' COMMENT '单独域名(外部链接)',
`target` tinyint(1) NOT NULL DEFAULT '0' COMMENT '新窗口打开,0=否,1=是',
`is_home_default` tinyint(1) DEFAULT '0' COMMENT '默认前台语言,1=是,0=否',
`is_admin_default` tinyint(1) DEFAULT '0' COMMENT '默认后台语言,1=是,0=否',
`syn_pack_id` int(10) DEFAULT '0' COMMENT '最后一次同步官方语言包ID',
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '语言状态,0=关闭,1=开启',
`sort_order` int(10) DEFAULT '0' COMMENT '排序号',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='多语言主表';
-- ----------------------------
-- Records of ey_language
-- ----------------------------
INSERT INTO `ey_language` VALUES ('1', '简体中文', 'cn', '', '0', '1', '1', '24', '1', '100', '1541583096', '1543890743');
-- ----------------------------
-- Table structure for ey_language_attr
-- ----------------------------
DROP TABLE IF EXISTS `ey_language_attr`;
CREATE TABLE `ey_language_attr` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '信息ID,自增',
`attr_name` varchar(200) NOT NULL DEFAULT '' COMMENT '来自ey_weapp_language_attr表的attr_name',
`attr_value` text NOT NULL COMMENT '变量值',
`attr_group` varchar(50) DEFAULT '' COMMENT '分组,以表名划分(不含表前缀)',
`lang` varchar(50) NOT NULL DEFAULT '' COMMENT '所属语言',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `attr_value` (`attr_name`,`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='多语言模板变量关联绑定表';
-- ----------------------------
-- Records of ey_language_attr
-- ----------------------------
-- ----------------------------
-- Table structure for ey_language_attribute
-- ----------------------------
DROP TABLE IF EXISTS `ey_language_attribute`;
CREATE TABLE `ey_language_attribute` (
`attr_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '信息ID,自增',
`attr_title` varchar(200) NOT NULL DEFAULT '' COMMENT '变量标题',
`attr_name` varchar(200) NOT NULL DEFAULT '' COMMENT '变量名称',
`attr_group` varchar(50) DEFAULT '' COMMENT '分组,以表名划分(不含表前缀)',
`is_del` tinyint(1) DEFAULT '0' COMMENT '伪删除,0=否,1=是',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`attr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='多语言模板变量表';
-- ----------------------------
-- Records of ey_language_attribute
-- ----------------------------
-- ----------------------------
-- Table structure for ey_language_mark
-- ----------------------------
DROP TABLE IF EXISTS `ey_language_mark`;
CREATE TABLE `ey_language_mark` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`title` varchar(50) NOT NULL DEFAULT '' COMMENT '国家语言名称',
`cn_title` varchar(50) NOT NULL DEFAULT '' COMMENT '中文名称',
`mark` varchar(50) DEFAULT '' COMMENT '多语言标识',
`pinyin` varchar(100) DEFAULT '' COMMENT '拼音',
`sort_order` int(10) NOT NULL DEFAULT '0' COMMENT '排序号',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='国家语言表';
-- ----------------------------
-- Records of ey_language_mark
-- ----------------------------
INSERT INTO `ey_language_mark` VALUES ('1', '简体中文', '简体中文', 'cn', 'zhongwenjianti', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('2', 'Vietnamese', '越南语', 'vi', 'yuenanyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('3', '繁体中文', '繁体中文', 'zh', 'zhongwenfanti', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('4', 'English', '英语', 'en', 'yingyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('5', 'Indonesian', '印尼语', 'id', 'yinniyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('6', 'Urdu', '乌尔都语', 'ur', 'wuerduyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('7', 'Yiddish', '意第绪语', 'yi', 'yidixuyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('8', 'Italian', '意大利语', 'it', 'yidaliyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('9', 'Greek', '希腊语', 'el', 'xilayu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('10', 'Spanish Basque', '西班牙的巴斯克语', 'eu', 'xibanyadebasikeyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('11', 'Spanish', '西班牙语', 'es', 'xibanyayu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('12', 'Hungarian', '匈牙利语', 'hu', 'xiongyaliyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('13', 'Hebrew', '希伯来语', 'iw', 'xibolaiyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('14', 'Ukrainian', '乌克兰语', 'uk', 'wukelanyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('15', 'Welsh', '威尔士语', 'cy', 'weiershiyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('16', 'Thai', '泰语', 'th', 'taiyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('17', 'Turkish', '土耳其语', 'tr', 'tuerqiyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('18', 'Swahili', '斯瓦希里语', 'sw', 'siwaxiliyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('19', 'Japanese', '日语', 'ja', 'riyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('20', 'Swedish', '瑞典语', 'sv', 'ruidianyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('21', 'Serbian', '塞尔维亚语', 'sr', 'saierweiyayu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('22', 'Slovak', '斯洛伐克语', 'sk', 'siluofakeyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('23', 'Slovenian', '斯洛文尼亚语', 'sl', 'siluowenniyayu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('24', 'Portuguese', '葡萄牙语', 'pt', 'putaoyayu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('25', 'Norwegian', '挪威语', 'no', 'nuoweiyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('26', 'Macedonian', '马其顿语', 'mk', 'maqidunyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('27', 'Malay', '马来语', 'ms', 'malaiyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('28', 'Maltese', '马耳他语', 'mt', 'maertayu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('29', 'Romanian', '罗马尼亚语', 'ro', 'luomaniyayu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('30', 'Lithuanian', '立陶宛语', 'lt', 'litaowanyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('31', 'Latvian', '拉脱维亚语', 'lv', 'latuoweiyayu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('32', 'Latin', '拉丁语', 'la', 'ladingyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('33', 'Croatian', '克罗地亚语', 'hr', 'keluodiyayu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('34', 'Czech', '捷克语', 'cs', 'jiekeyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('35', 'Catalan', '加泰罗尼亚语', 'ca', 'jiatailuoniyayu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('36', 'Galician', '加利西亚语', 'gl', 'jialixiyayu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('37', 'Dutch', '荷兰语', 'nl', 'helanyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('38', 'Korean', '韩语', 'ko', 'hanyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('39', 'Haitian Creole', '海地克里奥尔语', 'ht', 'haidikeliaoeryu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('40', 'Finnish', '芬兰语', 'fi', 'fenlanyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('41', 'Filipino', '菲律宾语', 'tl', 'feilvbinyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('42', 'Russian', '俄语', 'ru', 'eyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('43', 'Boolean (Afrikaans)', '布尔语(南非荷兰语)', 'af', 'bueryunanfeihelanyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('44', 'French', '法语', 'fr', 'fayu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('45', 'Danish', '丹麦语', 'da', 'danmaiyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('46', 'German', '德语', 'de', 'deyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('47', 'Azerbaijani', '阿塞拜疆语', 'az', 'asaibaijiangyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('48', 'Irish', '爱尔兰语', 'ga', 'aierlanyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('49', 'Estonian', '爱沙尼亚语', 'et', 'aishaniyayu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('50', 'Belarusian', '白俄罗斯语', 'be', 'baieluosiyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('51', 'Bulgarian', '保加利亚语', 'bg', 'baojialiyayu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('52', 'Icelandic', '冰岛语', 'is', 'bingdaoyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('53', 'Polish', '波兰语', 'pl', 'bolanyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('54', 'Persian', '波斯语', 'fa', 'bosiyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('55', 'Arabic', '阿拉伯语', 'ar', 'alaboyu', '100', '0', '1541583096');
INSERT INTO `ey_language_mark` VALUES ('56', 'Albanian', '阿尔巴尼亚语', 'sq', 'aerbaniyayu', '100', '0', '1541583096');
-- ----------------------------
-- Table structure for ey_language_pack
-- ----------------------------
DROP TABLE IF EXISTS `ey_language_pack`;
CREATE TABLE `ey_language_pack` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '变量名',
`value` text NOT NULL COMMENT '变量值',
`is_syn` tinyint(1) DEFAULT '0' COMMENT '同步官方语言包:0=否,1=是',
`lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
`sort_order` int(10) DEFAULT '0' COMMENT '排序号',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='模板语言包变量';
-- ----------------------------
-- Records of ey_language_pack
-- ----------------------------
INSERT INTO `ey_language_pack` VALUES ('1', 'sys1', '首页', '1', 'cn', '100', '1543890216', '1543890216');
INSERT INTO `ey_language_pack` VALUES ('2', 'sys2', '上一页', '1', 'cn', '100', '1543890216', '1543890216');
INSERT INTO `ey_language_pack` VALUES ('3', 'sys3', '下一页', '1', 'cn', '100', '1543890216', '1543890216');
INSERT INTO `ey_language_pack` VALUES ('4', 'sys4', '末页', '1', 'cn', '100', '1543890216', '1543890216');
INSERT INTO `ey_language_pack` VALUES ('5', 'sys5', '共%s页 %s条', '1', 'cn', '100', '1543890216', '1543890216');
INSERT INTO `ey_language_pack` VALUES ('6', 'sys6', '全部', '1', 'cn', '100', '1543890216', '1543890216');
INSERT INTO `ey_language_pack` VALUES ('7', 'sys7', '搜索', '1', 'cn', '100', '1543890216', '1543890216');
INSERT INTO `ey_language_pack` VALUES ('8', 'sys8', '查看详情', '1', 'cn', '100', '1543890216', '1543890216');
INSERT INTO `ey_language_pack` VALUES ('9', 'sys9', '网站首页', '1', 'cn', '100', '1543890216', '1543890216');
INSERT INTO `ey_language_pack` VALUES ('10', 'sys10', '暂无', '1', 'cn', '100', '1543890216', '1543890216');
INSERT INTO `ey_language_pack` VALUES ('11', 'sys11', '上一篇', '1', 'cn', '100', '1543890216', '1543890216');
INSERT INTO `ey_language_pack` VALUES ('12', 'sys12', '下一篇', '1', 'cn', '100', '1543890216', '1543890216');
-- ----------------------------
-- Table structure for ey_links
-- ----------------------------
DROP TABLE IF EXISTS `ey_links`;
CREATE TABLE `ey_links` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`typeid` tinyint(1) DEFAULT '1' COMMENT '类型:1=文字链接,2=图片链接',
`title` varchar(50) DEFAULT '' COMMENT '网站标题',
`url` varchar(100) DEFAULT '' COMMENT '网站地址',
`logo` varchar(255) DEFAULT '' COMMENT '网站LOGO',
`sort_order` int(11) DEFAULT '0' COMMENT '排序号',
`target` tinyint(1) DEFAULT '0' COMMENT '是否开启浏览器新窗口',
`email` varchar(50) DEFAULT NULL,
`intro` text COMMENT '网站简况',
`status` tinyint(1) DEFAULT '1' COMMENT '状态(1=显示,0=屏蔽)',
`lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
`delete_time` int(11) DEFAULT '0' COMMENT '软删除时间',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='友情链接表';
-- ----------------------------
-- Records of ey_links
-- ----------------------------
INSERT INTO `ey_links` VALUES ('1', '1', '百度', 'http://www.baidu.com', '', '100', '1', '', '', '1', 'cn', '0', '1524975826', '1537585074');
INSERT INTO `ey_links` VALUES ('2', '1', '腾讯', 'http://www.qq.com', '', '100', '1', '', '', '1', 'cn', '0', '1524976095', '1537585061');
INSERT INTO `ey_links` VALUES ('3', '1', '新浪', 'http://www.sina.com.cn', '', '100', '1', '', '', '1', 'cn', '0', '1532414285', '1537585047');
INSERT INTO `ey_links` VALUES ('4', '1', '淘宝', 'http://www.taobao.com', '', '100', '1', '', '', '1', 'cn', '0', '1532414529', '1537585013');
INSERT INTO `ey_links` VALUES ('5', '1', '微博', 'http://www.weibo.com', '', '100', '1', '', '', '1', 'cn', '0', '1532414726', '1537585146');
-- ----------------------------
-- Table structure for ey_product_attr
-- ----------------------------
DROP TABLE IF EXISTS `ey_product_attr`;
CREATE TABLE `ey_product_attr` (
`product_attr_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '产品属性id自增',
`aid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '产品id',
`attr_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '属性id',
`attr_value` text COMMENT '属性值',
`attr_price` varchar(255) DEFAULT '' COMMENT '属性价格',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`product_attr_id`),
KEY `aid` (`aid`) USING BTREE,
KEY `attr_id` (`attr_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='产品表单属性值';
-- ----------------------------
-- Records of ey_product_attr
-- ----------------------------
-- ----------------------------
-- Table structure for ey_product_attribute
-- ----------------------------
DROP TABLE IF EXISTS `ey_product_attribute`;
CREATE TABLE `ey_product_attribute` (
`attr_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '属性id',
`attr_name` varchar(60) DEFAULT '' COMMENT '属性名称',
`typeid` int(11) unsigned DEFAULT '0' COMMENT '栏目id',
`attr_index` tinyint(1) unsigned DEFAULT '0' COMMENT '0不需要检索 1关键字检索 2范围检索',
`attr_input_type` tinyint(1) unsigned DEFAULT '0' COMMENT ' 0=文本框,1=下拉框,2=多行文本框',
`attr_values` text COMMENT '可选值列表',
`sort_order` int(11) unsigned DEFAULT '0' COMMENT '属性排序',
`lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
`is_del` tinyint(1) DEFAULT '0' COMMENT '是否已删除,0=否,1=是',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`attr_id`),
KEY `cat_id` (`typeid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='产品表单属性表';
-- ----------------------------
-- Records of ey_product_attribute
-- ----------------------------
-- ----------------------------
-- Table structure for ey_product_content
-- ----------------------------
DROP TABLE IF EXISTS `ey_product_content`;
CREATE TABLE `ey_product_content` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`aid` int(10) DEFAULT '0' COMMENT '文档ID',
`content` longtext COMMENT '内容详情',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `news_id` (`aid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='资讯内容表_存储正常内容';
-- ----------------------------
-- Records of ey_product_content
-- ----------------------------
-- ----------------------------
-- Table structure for ey_product_img
-- ----------------------------
DROP TABLE IF EXISTS `ey_product_img`;
CREATE TABLE `ey_product_img` (
`img_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`aid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '产品ID',
`title` varchar(200) DEFAULT '' COMMENT '产品标题',
`image_url` varchar(255) DEFAULT '' COMMENT '文件存储路径',
`width` int(11) DEFAULT '0' COMMENT '图片宽度',
`height` int(11) DEFAULT '0' COMMENT '图片高度',
`filesize` varchar(255) DEFAULT '' COMMENT '文件大小',
`mime` varchar(50) DEFAULT '' COMMENT '图片类型',
`sort_order` smallint(5) DEFAULT '0' COMMENT '排序',
`add_time` int(10) unsigned DEFAULT '0' COMMENT '上传时间',
PRIMARY KEY (`img_id`),
KEY `arcid` (`aid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='产品图片表';
-- ----------------------------
-- Records of ey_product_img
-- ----------------------------
-- ----------------------------
-- Table structure for ey_single_content
-- ----------------------------
DROP TABLE IF EXISTS `ey_single_content`;
CREATE TABLE `ey_single_content` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
`typeid` int(10) DEFAULT '0' COMMENT '栏目ID',
`content` longtext COMMENT '内容详情',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `aid` (`aid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of ey_single_content
-- ----------------------------
-- ----------------------------
-- Table structure for ey_smtp_record
-- ----------------------------
DROP TABLE IF EXISTS `ey_smtp_record`;
CREATE TABLE `ey_smtp_record` (
`record_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`source` tinyint(1) DEFAULT '0' COMMENT '来源,与场景ID对应:0=默认,2=注册,3=绑定邮箱,4=找回密码',
`email` varchar(50) DEFAULT '' COMMENT '邮件地址',
`users_id` int(10) DEFAULT '0' COMMENT '用户ID',
`code` varchar(20) DEFAULT '' COMMENT '发送邮件内容',
`status` tinyint(1) DEFAULT '0' COMMENT '是否使用,默认0,0为未使用,1为使用',
`lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`record_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='邮件发送记录表';
-- ----------------------------
-- Records of ey_smtp_record
-- ----------------------------
-- ----------------------------
-- Table structure for ey_smtp_tpl
-- ----------------------------
DROP TABLE IF EXISTS `ey_smtp_tpl`;
CREATE TABLE `ey_smtp_tpl` (
`tpl_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`tpl_name` varchar(200) DEFAULT '' COMMENT '模板名称',
`tpl_title` varchar(200) DEFAULT '' COMMENT '邮件标题',
`tpl_content` text COMMENT '发送邮件内容',
`send_scene` tinyint(1) DEFAULT '0' COMMENT '邮件发送场景(1=留言表单)',
`is_open` tinyint(1) DEFAULT '0' COMMENT '是否开启使用这个模板,1为是,0为否。',
`lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
`add_time` int(11) DEFAULT '0' COMMENT '添加时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`tpl_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='邮件模板表';
-- ----------------------------
-- Records of ey_smtp_tpl
-- ----------------------------
INSERT INTO `ey_smtp_tpl` VALUES ('1', '留言表单', '您有新的留言消息,请查收!', '${content}', '1', '1', 'cn', '1544763495', '1552638302');
INSERT INTO `ey_smtp_tpl` VALUES ('2', '会员注册', '验证码已发送至您的邮箱,请登录邮箱查看验证码!', '${content}', '2', '1', 'cn', '1544763495', '1552667056');
INSERT INTO `ey_smtp_tpl` VALUES ('3', '绑定邮箱', '验证码已发送至您的邮箱,请登录邮箱查看验证码!', '${content}', '3', '1', 'cn', '1544763495', '1552667400');
INSERT INTO `ey_smtp_tpl` VALUES ('4', '找回密码', '验证码已发送至您的邮箱,请登录邮箱查看验证码!', '${content}', '4', '1', 'cn', '1544763495', '1552663577');
-- ----------------------------
-- Table structure for ey_tagindex
-- ----------------------------
DROP TABLE IF EXISTS `ey_tagindex`;
CREATE TABLE `ey_tagindex` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'tagid',
`tag` varchar(50) NOT NULL DEFAULT '' COMMENT 'tag内容',
`typeid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '栏目ID',
`count` int(10) unsigned DEFAULT '0' COMMENT '点击',
`total` int(10) unsigned DEFAULT '0' COMMENT '文档数',
`weekcc` int(10) unsigned DEFAULT '0' COMMENT '周统计',
`monthcc` int(10) unsigned DEFAULT '0' COMMENT '月统计',
`weekup` int(10) unsigned DEFAULT '0' COMMENT '每周更新',
`monthup` int(10) unsigned DEFAULT '0' COMMENT '每月更新',
`lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
`add_time` int(10) unsigned DEFAULT '0' COMMENT '添加时间',
PRIMARY KEY (`id`),
KEY `typeid` (`typeid`) USING BTREE,
KEY `count` (`count`,`total`,`weekcc`,`monthcc`,`weekup`,`monthup`,`add_time`) USING BTREE,
KEY `tag` (`tag`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='标签索引表';
-- ----------------------------
-- Records of ey_tagindex
-- ----------------------------
-- ----------------------------
-- Table structure for ey_taglist
-- ----------------------------
DROP TABLE IF EXISTS `ey_taglist`;
CREATE TABLE `ey_taglist` (
`tid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'tagid',
`aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文档ID',
`typeid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '栏目ID',
`tag` varchar(50) DEFAULT '' COMMENT 'tag内容',
`arcrank` tinyint(1) DEFAULT '0' COMMENT '阅读权限',
`lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`tid`,`aid`),
KEY `aid` (`aid`,`typeid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文章标签表';
-- ----------------------------
-- Records of ey_taglist
-- ----------------------------
-- ----------------------------
-- Table structure for ey_ui_config
-- ----------------------------
DROP TABLE IF EXISTS `ey_ui_config`;
CREATE TABLE `ey_ui_config` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '表id',
`md5key` varchar(100) NOT NULL DEFAULT '' COMMENT '唯一键值(由 theme_style、page、name)组成',
`theme_style` varchar(20) DEFAULT 'pc' COMMENT '模板风格',
`page` varchar(64) DEFAULT '' COMMENT '页面分组',
`type` varchar(50) DEFAULT '' COMMENT '编辑类型',
`name` varchar(50) DEFAULT '' COMMENT '与页面的e-id对应',
`value` text COMMENT '页面美化的val值',
`lang` varchar(50) DEFAULT 'cn' COMMENT '语言标识',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `md5key` (`md5key`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='可视化参数设置';
-- ----------------------------
-- Records of ey_ui_config
-- ----------------------------
-- ----------------------------
-- Table structure for ey_weapp
-- ----------------------------
DROP TABLE IF EXISTS `ey_weapp`;
CREATE TABLE `ey_weapp` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(50) DEFAULT '' COMMENT '插件标识',
`name` varchar(55) DEFAULT '' COMMENT '中文名字',
`config` text COMMENT '配置信息',
`data` text COMMENT '额外序列化存储数据,简单插件可以不创建表,存储这里即可',
`status` tinyint(1) DEFAULT '0' COMMENT '状态:0=未安装,1=启用,-1=禁用',
`tag_weapp` tinyint(1) DEFAULT '1' COMMENT '1=自动绑定,2=手工调用。关联模板标签weapp,自动调用内置的show钩子方法',
`thorough` tinyint(1) DEFAULT '0' COMMENT '彻底卸载:0=是,1=否',
`position` varchar(30) DEFAULT 'default' COMMENT '插件位置',
`add_time` int(11) DEFAULT '0' COMMENT '新增时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `code` (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='插件应用表';
-- ----------------------------
-- Records of ey_weapp
-- ----------------------------