/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50624
Source Host           : localhost:3306
Source Database       : db_wxcms

Target Server Type    : MYSQL
Target Server Version : 50624
File Encoding         : 65001

Date: 2015-09-26 14:33:18
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `cms_access`
-- ----------------------------
DROP TABLE IF EXISTS `cms_access`;
CREATE TABLE `cms_access` (
  `role_id` smallint(6) unsigned NOT NULL,
  `node_id` smallint(6) unsigned NOT NULL,
  `level` tinyint(1) NOT NULL,
  `pid` smallint(6) NOT NULL,
  `module` varchar(50) DEFAULT NULL,
  KEY `groupId` (`role_id`),
  KEY `nodeId` (`node_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cms_access
-- ----------------------------
INSERT INTO `cms_access` VALUES ('1', '1', '1', '0', null);
INSERT INTO `cms_access` VALUES ('1', '103', '2', '1', null);
INSERT INTO `cms_access` VALUES ('1', '85', '2', '1', null);
INSERT INTO `cms_access` VALUES ('1', '83', '2', '1', null);
INSERT INTO `cms_access` VALUES ('1', '50', '3', '40', null);
INSERT INTO `cms_access` VALUES ('1', '86', '3', '40', null);
INSERT INTO `cms_access` VALUES ('1', '84', '2', '1', null);
INSERT INTO `cms_access` VALUES ('1', '101', '3', '83', null);
INSERT INTO `cms_access` VALUES ('1', '100', '3', '83', null);
INSERT INTO `cms_access` VALUES ('1', '30', '2', '1', null);
INSERT INTO `cms_access` VALUES ('1', '96', '3', '85', null);
INSERT INTO `cms_access` VALUES ('1', '95', '3', '85', null);
INSERT INTO `cms_access` VALUES ('1', '94', '3', '85', null);
INSERT INTO `cms_access` VALUES ('1', '93', '3', '85', null);
INSERT INTO `cms_access` VALUES ('1', '92', '3', '85', null);
INSERT INTO `cms_access` VALUES ('1', '102', '3', '85', null);
INSERT INTO `cms_access` VALUES ('1', '87', '3', '84', null);
INSERT INTO `cms_access` VALUES ('1', '88', '3', '84', null);
INSERT INTO `cms_access` VALUES ('1', '89', '3', '84', null);
INSERT INTO `cms_access` VALUES ('1', '90', '3', '84', null);
INSERT INTO `cms_access` VALUES ('1', '91', '3', '84', null);
INSERT INTO `cms_access` VALUES ('1', '97', '3', '84', null);
INSERT INTO `cms_access` VALUES ('1', '98', '3', '84', null);
INSERT INTO `cms_access` VALUES ('1', '99', '3', '84', null);
INSERT INTO `cms_access` VALUES ('1', '40', '2', '1', null);
INSERT INTO `cms_access` VALUES ('1', '110', '3', '103', null);
INSERT INTO `cms_access` VALUES ('1', '109', '3', '103', null);
INSERT INTO `cms_access` VALUES ('1', '108', '3', '103', null);
INSERT INTO `cms_access` VALUES ('1', '107', '3', '103', null);
INSERT INTO `cms_access` VALUES ('1', '106', '3', '103', null);
INSERT INTO `cms_access` VALUES ('1', '105', '3', '103', null);
INSERT INTO `cms_access` VALUES ('1', '104', '3', '103', null);
INSERT INTO `cms_access` VALUES ('1', '112', '2', '1', null);
INSERT INTO `cms_access` VALUES ('1', '114', '3', '112', null);
INSERT INTO `cms_access` VALUES ('1', '113', '3', '112', null);
INSERT INTO `cms_access` VALUES ('1', '115', '3', '112', null);
INSERT INTO `cms_access` VALUES ('1', '116', '3', '112', null);
INSERT INTO `cms_access` VALUES ('1', '117', '3', '112', null);
INSERT INTO `cms_access` VALUES ('1', '118', '3', '112', null);
INSERT INTO `cms_access` VALUES ('1', '119', '3', '112', null);
INSERT INTO `cms_access` VALUES ('1', '120', '3', '112', null);
INSERT INTO `cms_access` VALUES ('1', '121', '3', '112', null);
INSERT INTO `cms_access` VALUES ('1', '122', '3', '112', null);
INSERT INTO `cms_access` VALUES ('1', '111', '3', '103', null);
INSERT INTO `cms_access` VALUES ('2', '1', '1', '0', null);
INSERT INTO `cms_access` VALUES ('2', '112', '2', '1', null);
INSERT INTO `cms_access` VALUES ('2', '118', '3', '112', null);
INSERT INTO `cms_access` VALUES ('8', '129', '1', '0', null);
INSERT INTO `cms_access` VALUES ('8', '1', '1', '0', null);
INSERT INTO `cms_access` VALUES ('8', '30', '2', '1', null);
INSERT INTO `cms_access` VALUES ('8', '122', '3', '112', null);
INSERT INTO `cms_access` VALUES ('8', '121', '3', '112', null);
INSERT INTO `cms_access` VALUES ('8', '120', '3', '112', null);
INSERT INTO `cms_access` VALUES ('8', '119', '3', '112', null);
INSERT INTO `cms_access` VALUES ('8', '118', '3', '112', null);
INSERT INTO `cms_access` VALUES ('8', '117', '3', '112', null);
INSERT INTO `cms_access` VALUES ('8', '116', '3', '112', null);
INSERT INTO `cms_access` VALUES ('8', '115', '3', '112', null);
INSERT INTO `cms_access` VALUES ('8', '114', '3', '112', null);
INSERT INTO `cms_access` VALUES ('8', '40', '2', '1', null);
INSERT INTO `cms_access` VALUES ('8', '112', '2', '1', null);
INSERT INTO `cms_access` VALUES ('8', '50', '3', '40', null);
INSERT INTO `cms_access` VALUES ('8', '86', '3', '40', null);
INSERT INTO `cms_access` VALUES ('8', '113', '3', '112', null);

-- ----------------------------
-- Table structure for `cms_artc`
-- ----------------------------
DROP TABLE IF EXISTS `cms_artc`;
CREATE TABLE `cms_artc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) unsigned NOT NULL,
  `title` varchar(100) NOT NULL,
  `img` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `author` varchar(20) NOT NULL,
  `src` varchar(30) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `content` text NOT NULL,
  `small_content` varchar(500) NOT NULL,
  `web_title` varchar(500) NOT NULL,
  `web_key` varchar(500) NOT NULL,
  `web_desc` varchar(500) NOT NULL,
  `content_tpl_id` int(10) unsigned NOT NULL,
  `extend_tpl` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `top` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `sort` smallint(5) unsigned NOT NULL DEFAULT '500',
  `visit_count` int(10) unsigned NOT NULL,
  `checked` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `is_show` tinyint(3) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cms_artc
-- ----------------------------

-- ----------------------------
-- Table structure for `cms_group`
-- ----------------------------
DROP TABLE IF EXISTS `cms_group`;
CREATE TABLE `cms_group` (
  `id` smallint(3) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(25) NOT NULL,
  `title` varchar(50) NOT NULL,
  `create_time` int(11) unsigned NOT NULL,
  `update_time` int(11) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `sort` smallint(3) unsigned NOT NULL DEFAULT '0',
  `show` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `url` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cms_group
-- ----------------------------
INSERT INTO `cms_group` VALUES ('2', 'WebSet', '网站设置', '1222841259', '0', '1', '1', '0', '');
INSERT INTO `cms_group` VALUES ('6', 'TplMng', '模板管理', '0', '0', '1', '2', '0', '');
INSERT INTO `cms_group` VALUES ('7', 'SortSet', '栏目设置', '0', '0', '1', '3', '0', 'Sort');
INSERT INTO `cms_group` VALUES ('8', 'ContentMng', '内容管理', '0', '0', '1', '4', '0', 'Artc/list_sort');
INSERT INTO `cms_group` VALUES ('9', 'UserMng', '系统管理', '0', '0', '1', '0', '0', '');
INSERT INTO `cms_group` VALUES ('10', 'content_check', '审核内容', '0', '0', '1', '6', '1', '');

-- ----------------------------
-- Table structure for `cms_node`
-- ----------------------------
DROP TABLE IF EXISTS `cms_node`;
CREATE TABLE `cms_node` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `title` varchar(50) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '0',
  `remark` varchar(255) DEFAULT NULL,
  `sort` smallint(6) unsigned DEFAULT NULL,
  `pid` smallint(6) unsigned NOT NULL,
  `level` tinyint(1) unsigned NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `group_id` tinyint(3) unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `level` (`level`),
  KEY `pid` (`pid`),
  KEY `status` (`status`),
  KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=131 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cms_node
-- ----------------------------
INSERT INTO `cms_node` VALUES ('49', 'read', '查看', '-1', '', null, '30', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('40', 'Index', '默认模块', '1', '', '8', '1', '2', '0', '0');
INSERT INTO `cms_node` VALUES ('39', 'index', '列表', '-1', '', null, '30', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('37', 'resume', '恢复', '-1', '', null, '30', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('36', 'forbid', '禁用', '-1', '', null, '30', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('35', 'foreverdelete', '删除', '-1', '', null, '30', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('34', 'update', '更新', '-1', '', null, '30', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('33', 'edit', '编辑', '-1', '', null, '30', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('32', 'insert', '写入', '-1', '', null, '30', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('31', 'add', '新增', '-1', '', null, '30', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('30', 'Public', '公共模块', '1', '', '10', '1', '2', '0', '0');
INSERT INTO `cms_node` VALUES ('84', 'Tpl', '模板管理', '1', '', '1', '1', '2', '0', '6');
INSERT INTO `cms_node` VALUES ('7', 'User', '后台用户', '1', '', '12', '1', '2', '0', '9');
INSERT INTO `cms_node` VALUES ('6', 'Role', '角色管理', '1', '', '11', '1', '2', '0', '9');
INSERT INTO `cms_node` VALUES ('2', 'Node', '节点管理', '1', '', '9', '1', '2', '0', '9');
INSERT INTO `cms_node` VALUES ('1', 'Admin', '网站管理后台', '1', '', null, '0', '1', '0', '0');
INSERT INTO `cms_node` VALUES ('50', 'main', '空白首页', '1', '', null, '40', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('83', 'WebInfo', '基本信息管理', '1', '', '4', '1', '2', '0', '2');
INSERT INTO `cms_node` VALUES ('85', 'TplVar', '模板变量', '1', '', '2', '1', '2', '0', '6');
INSERT INTO `cms_node` VALUES ('86', 'index', '后台首页', '1', '', null, '40', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('87', 'index', '列表', '1', '', null, '84', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('88', 'Add', '增加', '1', '', null, '84', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('89', 'update_tpl', '更新模板', '1', '', null, '84', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('90', 'create_tpl', '更新模板', '1', '', null, '84', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('91', 'del_cache', '删除缓存', '1', '', null, '84', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('92', 'Add', '增加', '1', '', null, '85', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('93', 'insert', '保存增加', '1', '', null, '85', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('94', 'edit', '修改', '1', '', null, '85', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('95', 'update', '保存修改', '1', '', null, '85', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('96', 'del', '删除', '1', '', null, '85', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('97', 'insert', '保存增加', '1', '', null, '84', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('98', 'update', '保存修改', '1', '', null, '84', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('99', 'del', '删除', '1', '', null, '84', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('100', 'index', '模块首页', '1', '', null, '83', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('101', 'update', '保存', '1', '', null, '83', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('102', 'index', '列表', '1', '', null, '85', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('103', 'Sort', '栏目管理', '1', '', '3', '1', '2', '0', '7');
INSERT INTO `cms_node` VALUES ('104', 'index', '栏目列表', '1', '', null, '103', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('105', 'sel_sort', '选择栏目', '1', '', null, '103', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('106', 'moveTo', '移动栏目', '1', '', null, '103', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('107', 'add', '新增', '1', '', null, '103', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('108', 'edit', '编辑', '1', '', null, '103', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('109', 'insert', '保存新增', '1', '', null, '103', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('110', 'update', '保存修改', '1', '', null, '103', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('111', 'del', '删除', '1', '', null, '103', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('112', 'Artc', '文章管理', '1', '', '2', '1', '2', '0', '0');
INSERT INTO `cms_node` VALUES ('113', 'list_sort', '栏目列表', '1', '', '1', '112', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('114', 'index', '文章列表', '1', '', '11', '112', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('115', 'moveTo', '移动文章', '1', '', '9', '112', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('116', 'setTop', '置顶', '1', '', '8', '112', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('117', 'save_sort', '文章排序', '1', '', '7', '112', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('118', 'add', '新增', '1', '', '6', '112', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('119', 'edit', '编辑', '1', '', '5', '112', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('120', 'insert', '保存新增', '1', '', '4', '112', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('121', 'update', '保存修改', '1', '', '3', '112', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('122', 'del', '删除', '1', '', '2', '112', '3', '0', '0');
INSERT INTO `cms_node` VALUES ('123', 'ArtcCheck', '文章审核', '1', '', '7', '1', '2', '0', '10');
INSERT INTO `cms_node` VALUES ('128', 'Form', '表单管理', '1', '', '1', '1', '2', '0', '12');
INSERT INTO `cms_node` VALUES ('130', 'setShow', '屏蔽', '1', '屏蔽、显示文章', '10', '112', '3', '0', '0');

-- ----------------------------
-- Table structure for `cms_role`
-- ----------------------------
DROP TABLE IF EXISTS `cms_role`;
CREATE TABLE `cms_role` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `pid` smallint(6) DEFAULT NULL,
  `status` tinyint(1) unsigned DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `ename` varchar(5) DEFAULT NULL,
  `create_time` int(11) unsigned NOT NULL,
  `update_time` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `parentId` (`pid`),
  KEY `ename` (`ename`),
  KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cms_role
-- ----------------------------

-- ----------------------------
-- Table structure for `cms_role_user`
-- ----------------------------
DROP TABLE IF EXISTS `cms_role_user`;
CREATE TABLE `cms_role_user` (
  `role_id` mediumint(9) unsigned DEFAULT NULL,
  `user_id` char(32) DEFAULT NULL,
  KEY `group_id` (`role_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cms_role_user
-- ----------------------------
INSERT INTO `cms_role_user` VALUES ('3', '39');

-- ----------------------------
-- Table structure for `cms_sort`
-- ----------------------------
DROP TABLE IF EXISTS `cms_sort`;
CREATE TABLE `cms_sort` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) unsigned NOT NULL,
  `name` varchar(50) NOT NULL,
  `link` varchar(255) NOT NULL,
  `img` varchar(255) NOT NULL,
  `list_tpl_id` int(10) unsigned DEFAULT NULL,
  `extend_tpl` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `content_tpl_id` int(10) unsigned DEFAULT NULL,
  `sort` smallint(5) unsigned NOT NULL DEFAULT '500',
  `small_content` varchar(500) NOT NULL,
  `form_id` int(10) unsigned NOT NULL,
  `email` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cms_sort
-- ----------------------------

-- ----------------------------
-- Table structure for `cms_tpl`
-- ----------------------------
DROP TABLE IF EXISTS `cms_tpl`;
CREATE TABLE `cms_tpl` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(30) NOT NULL,
  `tpl_type` varchar(50) NOT NULL,
  `content` text NOT NULL,
  `is_default` tinyint(4) NOT NULL DEFAULT '0',
  `is_sys` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `model` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cms_tpl
-- ----------------------------
INSERT INTO `cms_tpl` VALUES ('5', '默认文章列表页', 'list', '<taglib name=\'artc\' />\r\n<include file=\"./Public/Tpl/3.html\" /><!-- 加载头部公共文件 -->\r\n <!-- 头部banner 开始 -->\r\n  <div id=\"top_banner\"><img src=\"{$vo.img_url|default=\'/Web/Tpl/default/Public/images/banner.jpg\'}\" width=\"984\" style=\"max-height:300px\" /></div>\r\n  <!-- 头部banner 结束 -->\r\n  <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n    <tr>\r\n      <td height=\"36\" background=\"/Web/Tpl/default/Public/images/bg1.jpg\"> </td>\r\n    </tr>\r\n  </table>\r\n  <table width=\"100%\" height=\"112\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n    <tr>\r\n      <td width=\"124\" height=\"235\" valign=\"top\" class=\"sort_list\">\r\n      	<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n      	  <tr>\r\n      	    <td width=\"124\" height=\"34\" align=\"center\" background=\"/Web/Tpl/default/Public/images/left_sort_bg.jpg\" class=\"sort_title2\">{$vo.name}</td>\r\n   	      </tr>\r\n   	    </table>\r\n      	<artc:sort_list pid=\"this\" size=\"8\" tpl=\"7\" />  \r\n      </td>\r\n      <td width=\"35\"> </td>\r\n      <td valign=\"top\"><table background=\"/Web/Tpl/default/Public/images/sort_bg.jpg\" style=\"background-repeat:no-repeat\" width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n        <tr>\r\n          <td width=\"85%\" height=\"34\" class=\"sort_title\">{$vo.name}</td>\r\n          <td width=\"15%\">当前位置：{$vo.name} </td>\r\n        </tr>\r\n      </table>\r\n        <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n          <tr>\r\n            <td>\r\n            	<div style=\"height:6px;\"></div>\r\n            	<div id=\"main_content\" class=\"news_list\">\r\n                  <artc:list pid=\"this\" pager=\"1\" size=\"15\" tpl=\"29\" />     \r\n                  <div id=\"pager\"><artc:pager /></div>\r\n                </div>\r\n            </td>\r\n          </tr>\r\n      </table></td>\r\n    </tr>\r\n  </table>\r\n<!-- 加载尾部公共文件 -->\r\n<include file=\"./Public/Tpl/4.html\" />', '1', '1', 'Artc');
INSERT INTO `cms_tpl` VALUES ('6', '默认文章内容页', 'content', '<taglib name=\'artc\' />\r\n<include file=\"./Public/Tpl/3.html\" /><!-- 加载头部公共文件 -->\r\n <!-- 头部banner 开始 -->\r\n  <div id=\"top_banner\"><img src=\"{$vo.img_url|default=\'/Web/Tpl/default/Public/images/banner.jpg\'}\" width=\"984\" style=\"max-height:300px\" /></div>\r\n  <!-- 头部banner 结束 -->\r\n  <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n    <tr>\r\n      <td height=\"36\" background=\"/Web/Tpl/default/Public/images/bg1.jpg\"> </td>\r\n    </tr>\r\n  </table>\r\n  <table width=\"100%\" height=\"112\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n    <tr>\r\n      <td width=\"124\" height=\"235\" valign=\"top\" class=\"sort_list\">\r\n      	<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n      	  <tr>\r\n      	    <td width=\"124\" height=\"34\" align=\"center\" background=\"/Web/Tpl/default/Public/images/left_sort_bg.jpg\" class=\"sort_title2\">{$sort.name}</td>\r\n   	      </tr>\r\n   	    </table>\r\n      	<artc:sort_list pid=\"this\" size=\"8\" tpl=\"7\" />  \r\n      </td>\r\n      <td width=\"35\"> </td>\r\n      <td valign=\"top\"><table background=\"/Web/Tpl/default/Public/images/sort_bg.jpg\" style=\"background-repeat:no-repeat\" width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n        <tr>\r\n          <td width=\"79%\" height=\"34\" class=\"sort_title\">{$sort.name}</td>\r\n          <td width=\"21%\"> </td>\r\n        </tr>\r\n      </table>\r\n        <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n          <tr>\r\n            <td>\r\n            	<div style=\"height:6px;\"></div>\r\n            	<div id=\"main_content\" class=\"artc_content\">\r\n					<div class=\"artc_title\">{$vo.title}</div>\r\n                     {$vo.content}          \r\n                </div>\r\n            </td>\r\n          </tr>\r\n      </table></td>\r\n    </tr>\r\n  </table>\r\n<!-- 加载尾部公共文件 -->\r\n<include file=\"./Public/Tpl/4.html\" />', '1', '1', 'Artc');
INSERT INTO `cms_tpl` VALUES ('7', '通用文章列表', 'tag', '<ul>\r\n<volist name=\"list\" id=\"vo\">\r\n	<li><a href=\"{$vo.url}\" title=\"{$vo.title}\" target=\"{$target}\">{$vo.title}</a></li>\r\n</volist>\r\n</ul>', '0', '1', 'Artc');
INSERT INTO `cms_tpl` VALUES ('2', '首页', 'base', '<taglib name=\'artc\' />\r\n<include file=\"./Public/Tpl/3.html\" /><!-- 加载头部公共文件 -->\r\n\r\n首页\r\n\r\n<!-- 加载尾部公共文件 -->\r\n<include file=\"./Public/Tpl/4.html\" />\r\n', '0', '1', 'Artc');
INSERT INTO `cms_tpl` VALUES ('3', '头部', 'base', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n<head>\r\n	<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\r\n    <title>{$web_title}</title>	\r\n	<meta name=\"keywords\" content=\"{$web_key}\"/>\r\n	<meta name=\"description\" content=\"{$web_desc}\" />\r\n\r\n    <link href=\"/Web/Tpl/default/Public/css/style.css\" rel=\"stylesheet\" type=\"text/css\" />\r\n   \r\n</head>\r\n\r\n<body>', '0', '1', 'Artc');
INSERT INTO `cms_tpl` VALUES ('4', '尾部', 'base', '\r\n</body>\r\n</html>', '0', '1', 'Artc');
INSERT INTO `cms_tpl` VALUES ('1', '封面（引导动画）', 'base', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n<head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\r\n<title>{$web_title}</title>\r\n	\r\n	<meta name=\"keywords\" content=\"{$web_key}\"/>\r\n	<meta name=\"description\" content=\"{$web_desc}\" /><script src=\"/Public/Js/swfobject_modified.js\" type=\"text/javascript\"></script>\r\n</head>\r\n\r\n<body style=\"text-align:center\">\r\n<object id=\"FlashID\" classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\" width=\"1002\" height=\"650\">\r\n  <param name=\"movie\" value=\"/Web/Tpl/default/Public/images/index.swf\" />\r\n  <param name=\"quality\" value=\"high\" />\r\n  <param name=\"wmode\" value=\"opaque\" />\r\n  <param name=\"swfversion\" value=\"9.0.45.0\" />\r\n  <!-- 此 param 标签提示使用 Flash Player 6.0 r65 和更高版本的用户下载最新版本的 Flash Player。如果您不想让用户看到该提示，请将其删除。 -->\r\n  <param name=\"expressinstall\" value=\"/Web/Tpl/default/Public/images/expressInstall.swf\" />\r\n  <!-- 下一个对象标签用于非 IE 浏览器。所以使用 IECC 将其从 IE 隐藏。 -->\r\n  <!--[if !IE]>-->\r\n  <object type=\"application/x-shockwave-flash\" data=\"/Web/Tpl/default/Public/images/index.swf\" width=\"1002\" height=\"650\">\r\n    <!--<![endif]-->\r\n    <param name=\"quality\" value=\"high\" />\r\n    <param name=\"wmode\" value=\"opaque\" />\r\n    <param name=\"swfversion\" value=\"9.0.45.0\" />\r\n    <param name=\"expressinstall\" value=\"/Scripts/expressInstall.swf\" />\r\n    <!-- 浏览器将以下替代内容显示给使用 Flash Player 6.0 和更低版本的用户。 -->\r\n    <div>\r\n      <h4>此页面上的内容需要较新版本的 Adobe Flash Player。</h4>\r\n      <p><a href=\"http://www.adobe.com/go/getflashplayer\"><img src=\"http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif\" alt=\"获取 Adobe Flash Player\" width=\"112\" height=\"33\" /></a></p>\r\n    </div>\r\n    <!--[if !IE]>-->\r\n  </object>\r\n  <!--<![endif]-->\r\n</object>\r\n<script type=\"text/javascript\">\r\n<!--\r\nswfobject.registerObject(\"FlashID\");\r\n//-->\r\n</script>\r\n</body>\r\n</html>\r\n', '0', '1', 'Artc');

-- ----------------------------
-- Table structure for `cms_tpl_var`
-- ----------------------------
DROP TABLE IF EXISTS `cms_tpl_var`;
CREATE TABLE `cms_tpl_var` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `name` varchar(20) NOT NULL,
  `content` text NOT NULL,
  `is_sys` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cms_tpl_var
-- ----------------------------

-- ----------------------------
-- Table structure for `cms_user`
-- ----------------------------
DROP TABLE IF EXISTS `cms_user`;
CREATE TABLE `cms_user` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `account` varchar(64) NOT NULL,
  `nickname` varchar(50) NOT NULL,
  `password` char(32) NOT NULL,
  `bind_account` varchar(50) NOT NULL,
  `last_login_time` int(11) unsigned DEFAULT '0',
  `last_login_ip` varchar(40) DEFAULT NULL,
  `login_count` mediumint(8) unsigned DEFAULT '0',
  `verify` varchar(32) DEFAULT NULL,
  `email` varchar(50) NOT NULL,
  `remark` varchar(255) NOT NULL,
  `create_time` int(11) unsigned NOT NULL,
  `update_time` int(11) unsigned NOT NULL,
  `status` tinyint(1) DEFAULT '0',
  `type_id` tinyint(2) unsigned DEFAULT '0',
  `info` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `account` (`account`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cms_user
-- ----------------------------
INSERT INTO `cms_user` VALUES ('1', 'admin', '管理员', '21232f297a57a5a743894a0e4a801fc3', '', '1443247758', '127.0.0.1', '994', '8888', 'liu21st@gmail.com', '备注信息', '1222907803', '1239977420', '1', '0', '');
INSERT INTO `cms_user` VALUES ('39', 'test', 'test', 'e10adc3949ba59abbe56e057f20f883e', '', '0', null, '0', null, '', '', '1443246750', '0', '1', '0', '');

-- ----------------------------
-- Table structure for `cms_user_sort`
-- ----------------------------
DROP TABLE IF EXISTS `cms_user_sort`;
CREATE TABLE `cms_user_sort` (
  `uid` int(10) unsigned NOT NULL,
  `sid` int(10) unsigned NOT NULL,
  PRIMARY KEY (`uid`,`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cms_user_sort
-- ----------------------------
INSERT INTO `cms_user_sort` VALUES ('35', '1');
INSERT INTO `cms_user_sort` VALUES ('35', '8');
INSERT INTO `cms_user_sort` VALUES ('35', '9');
INSERT INTO `cms_user_sort` VALUES ('35', '10');
INSERT INTO `cms_user_sort` VALUES ('35', '11');
INSERT INTO `cms_user_sort` VALUES ('35', '12');
INSERT INTO `cms_user_sort` VALUES ('36', '1');
INSERT INTO `cms_user_sort` VALUES ('36', '8');
INSERT INTO `cms_user_sort` VALUES ('36', '9');
INSERT INTO `cms_user_sort` VALUES ('36', '10');
INSERT INTO `cms_user_sort` VALUES ('36', '11');
INSERT INTO `cms_user_sort` VALUES ('36', '12');
INSERT INTO `cms_user_sort` VALUES ('37', '8');
INSERT INTO `cms_user_sort` VALUES ('37', '9');
INSERT INTO `cms_user_sort` VALUES ('38', '24');
INSERT INTO `cms_user_sort` VALUES ('38', '26');
INSERT INTO `cms_user_sort` VALUES ('38', '27');

-- ----------------------------
-- Table structure for `cms_web_info`
-- ----------------------------
DROP TABLE IF EXISTS `cms_web_info`;
CREATE TABLE `cms_web_info` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `enable_cover` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `web_title` varchar(500) NOT NULL,
  `web_key` varchar(500) NOT NULL,
  `web_desc` varchar(500) NOT NULL,
  `addr` varchar(255) NOT NULL,
  `linkman` varchar(50) NOT NULL,
  `postcode` varchar(20) NOT NULL,
  `fax` varchar(30) NOT NULL,
  `mphone` varchar(50) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `email` varchar(255) NOT NULL,
  `qq1` varchar(20) NOT NULL,
  `qq2` varchar(20) NOT NULL,
  `artc_check` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `job_check` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cms_web_info
-- ----------------------------
INSERT INTO `cms_web_info` VALUES ('1', '0', '网站标题', '', '', '', '', '', '', '', '', '', '', '', '0', '0');