代码拉取完成，页面将自动刷新
同步操作将从 DuxWeb/DuxCms 2.0 强制同步，此操作会覆盖自 Fork 仓库以来所做的任何修改，且无法恢复！！！
确定后同步将在后台操作，完成时将刷新页面，请耐心等待。
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50617
Source Host : localhost:3306
Source Database : duxcms2
Target Server Type : MYSQL
Target Server Version : 50617
File Encoding : 65001
Date: 2014-06-18 13:57:35
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for dux_admin_group
-- ----------------------------
DROP TABLE IF EXISTS `dux_admin_group`;
CREATE TABLE `dux_admin_group` (
`group_id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(20) DEFAULT NULL,
`base_purview` text,
`menu_purview` text,
`status` tinyint(1) DEFAULT '1',
PRIMARY KEY (`group_id`),
KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dux_admin_group
-- ----------------------------
INSERT INTO `dux_admin_group` VALUES ('1', '管理员', 'a:2:{i:0;s:15:\"Admin_AppManage\";i:1;s:21:\"Admin_AppManage_index\";}', 'a:2:{i:0;s:19:\"首页_管理首页\";i:1;s:22:\"系统_用户组管理\";}', '1');
-- ----------------------------
-- Table structure for dux_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `dux_admin_log`;
CREATE TABLE `dux_admin_log` (
`log_id` int(10) NOT NULL AUTO_INCREMENT,
`user_id` int(10) DEFAULT NULL,
`time` int(10) DEFAULT NULL,
`ip` varchar(250) DEFAULT NULL,
`app` varchar(250) DEFAULT '1',
`content` text,
PRIMARY KEY (`log_id`),
KEY `user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dux_admin_log
-- ----------------------------
-- ----------------------------
-- Table structure for dux_admin_user
-- ----------------------------
DROP TABLE IF EXISTS `dux_admin_user`;
CREATE TABLE `dux_admin_user` (
`user_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '用户IP',
`group_id` int(10) NOT NULL DEFAULT '1' COMMENT '用户组ID',
`username` varchar(20) NOT NULL COMMENT '登录名',
`password` varchar(32) NOT NULL COMMENT '密码',
`nicename` varchar(20) DEFAULT NULL COMMENT '昵称',
`email` varchar(50) DEFAULT NULL,
`status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态',
`level` int(5) DEFAULT '1' COMMENT '等级',
`reg_time` int(10) DEFAULT NULL COMMENT '注册时间',
`last_login_time` int(10) DEFAULT NULL COMMENT '最后登录时间',
`last_login_ip` varchar(15) DEFAULT '未知' COMMENT '登录IP',
PRIMARY KEY (`user_id`),
KEY `username` (`username`),
KEY `group_id` (`group_id`) USING BTREE,
KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='管理员信息表';
-- ----------------------------
-- Records of dux_admin_user
-- ----------------------------
INSERT INTO `dux_admin_user` VALUES ('1', '1', 'admin', '21232f297a57a5a743894a0e4a801fc3', '管理员', 'admin@duxcms.com', '1', '1', '1399361747', '1403058964', '127.0.0.1');
-- ----------------------------
-- Table structure for dux_category
-- ----------------------------
DROP TABLE IF EXISTS `dux_category`;
CREATE TABLE `dux_category` (
`class_id` int(10) NOT NULL AUTO_INCREMENT,
`parent_id` int(10) DEFAULT '0',
`app` varchar(20) DEFAULT NULL,
`show` tinyint(1) unsigned DEFAULT '1',
`sequence` int(10) DEFAULT '0',
`name` varchar(250) DEFAULT NULL,
`urlname` varchar(250) DEFAULT NULL,
`subname` varchar(250) DEFAULT NULL,
`image` varchar(250) DEFAULT NULL,
`class_tpl` varchar(250) DEFAULT NULL,
`keywords` varchar(250) DEFAULT NULL,
`description` varchar(250) DEFAULT NULL,
PRIMARY KEY (`class_id`),
UNIQUE KEY `urlname` (`urlname`) USING BTREE,
KEY `pid` (`parent_id`),
KEY `mid` (`app`),
KEY `sequence` (`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dux_category
-- ----------------------------
-- ----------------------------
-- Table structure for dux_category_article
-- ----------------------------
DROP TABLE IF EXISTS `dux_category_article`;
CREATE TABLE `dux_category_article` (
`class_id` int(10) NOT NULL,
`fieldset_id` int(10) NOT NULL,
`type` int(10) NOT NULL DEFAULT '1',
`content_tpl` varchar(250) NOT NULL,
`config_upload` text NOT NULL,
`content_order` varchar(250) NOT NULL,
`page` int(10) NOT NULL DEFAULT '10'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dux_category_article
-- ----------------------------
-- ----------------------------
-- Table structure for dux_category_page
-- ----------------------------
DROP TABLE IF EXISTS `dux_category_page`;
CREATE TABLE `dux_category_page` (
`class_id` int(10) unsigned NOT NULL DEFAULT '0',
`content` mediumtext COMMENT '内容',
KEY `cid` (`class_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dux_category_page
-- ----------------------------
-- ----------------------------
-- Table structure for dux_config
-- ----------------------------
DROP TABLE IF EXISTS `dux_config`;
CREATE TABLE `dux_config` (
`name` varchar(250) NOT NULL,
`data` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dux_config
-- ----------------------------
INSERT INTO `dux_config` VALUES ('site_title', 'DuxCms网站管理系统');
INSERT INTO `dux_config` VALUES ('site_subtitle', '简单、易用、轻巧');
INSERT INTO `dux_config` VALUES ('site_url', '');
INSERT INTO `dux_config` VALUES ('site_keywords', 'duxcms');
INSERT INTO `dux_config` VALUES ('site_description', '');
INSERT INTO `dux_config` VALUES ('site_email', 'admin@duxcms.com');
INSERT INTO `dux_config` VALUES ('site_copyright', '');
INSERT INTO `dux_config` VALUES ('site_statistics', '');
INSERT INTO `dux_config` VALUES ('tpl_name', 'default');
INSERT INTO `dux_config` VALUES ('tpl_index', 'index');
INSERT INTO `dux_config` VALUES ('tpl_search', 'search');
INSERT INTO `dux_config` VALUES ('tpl_tags', 'tag');
INSERT INTO `dux_config` VALUES ('upload_size', '10');
INSERT INTO `dux_config` VALUES ('upload_exts', 'jpg,gif,png,bmp');
INSERT INTO `dux_config` VALUES ('upload_replace', '1');
INSERT INTO `dux_config` VALUES ('thumb_status', '0');
INSERT INTO `dux_config` VALUES ('water_status', '1');
INSERT INTO `dux_config` VALUES ('thumb_type', '3');
INSERT INTO `dux_config` VALUES ('thumb_width', '500');
INSERT INTO `dux_config` VALUES ('thumb_height', '500');
INSERT INTO `dux_config` VALUES ('water_image', 'logo.png');
INSERT INTO `dux_config` VALUES ('water_position', '2');
-- ----------------------------
-- Table structure for dux_content
-- ----------------------------
DROP TABLE IF EXISTS `dux_content`;
CREATE TABLE `dux_content` (
`content_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '文章ID',
`class_id` int(10) DEFAULT NULL COMMENT '栏目ID',
`title` varchar(250) DEFAULT NULL COMMENT '标题',
`urltitle` varchar(250) DEFAULT NULL COMMENT 'URL路径',
`font_color` varchar(250) DEFAULT NULL COMMENT '颜色',
`font_bold` tinyint(1) DEFAULT NULL COMMENT '加粗',
`font_em` tinyint(1) DEFAULT NULL,
`position` varchar(250) DEFAULT NULL,
`keywords` varchar(250) DEFAULT NULL COMMENT '关键词',
`description` varchar(250) DEFAULT NULL COMMENT '描述',
`time` int(10) DEFAULT NULL COMMENT '更新时间',
`image` varchar(250) DEFAULT NULL COMMENT '封面图',
`url` varchar(250) DEFAULT NULL COMMENT '跳转',
`sequence` int(10) DEFAULT NULL COMMENT '排序',
`status` int(10) DEFAULT NULL COMMENT '状态',
`copyfrom` varchar(250) DEFAULT NULL COMMENT '来源',
`views` int(10) DEFAULT '0' COMMENT '浏览数',
`taglink` int(10) DEFAULT '0' COMMENT 'TAG链接',
`tpl` varchar(250) DEFAULT NULL,
`site` int(10) DEFAULT '1',
PRIMARY KEY (`content_id`),
UNIQUE KEY `urltitle` (`urltitle`) USING BTREE,
KEY `title` (`title`) USING BTREE,
KEY `description` (`description`) USING BTREE,
KEY `keywords` (`keywords`),
KEY `class_id` (`class_id`) USING BTREE,
KEY `time` (`time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dux_content
-- ----------------------------
-- ----------------------------
-- Table structure for dux_content_article
-- ----------------------------
DROP TABLE IF EXISTS `dux_content_article`;
CREATE TABLE `dux_content_article` (
`content_id` int(10) DEFAULT NULL,
`content` mediumtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dux_content_article
-- ----------------------------
-- ----------------------------
-- Table structure for dux_ext_guestbook
-- ----------------------------
DROP TABLE IF EXISTS `dux_ext_guestbook`;
CREATE TABLE `dux_ext_guestbook` (
`data_id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(250) DEFAULT NULL,
`status` text,
`content` text,
`time` int(10) DEFAULT NULL,
`email` varchar(250) DEFAULT NULL,
PRIMARY KEY (`data_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dux_ext_guestbook
-- ----------------------------
-- ----------------------------
-- Table structure for dux_field
-- ----------------------------
DROP TABLE IF EXISTS `dux_field`;
CREATE TABLE `dux_field` (
`field_id` int(10) NOT NULL AUTO_INCREMENT,
`fieldset_id` int(10) DEFAULT NULL,
`name` varchar(250) DEFAULT NULL,
`field` varchar(250) DEFAULT NULL,
`type` int(5) DEFAULT '1',
`tip` varchar(250) DEFAULT NULL,
`verify_type` varchar(250) DEFAULT NULL,
`verify_data` text,
`verify_data_js` text,
`verify_condition` tinyint(1) DEFAULT NULL,
`default` varchar(250) DEFAULT NULL,
`sequence` int(10) DEFAULT '0',
`errormsg` varchar(250) DEFAULT NULL,
`config` text,
PRIMARY KEY (`field_id`),
KEY `field` (`field`),
KEY `sequence` (`sequence`),
KEY `fieldset_id` (`fieldset_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dux_field
-- ----------------------------
INSERT INTO `dux_field` VALUES ('1', '1', '姓名', 'name', '1', '', 'regex', 'cmVxdWlyZQ==', 'Kg==', '1', '', '0', '请填写姓名', '');
INSERT INTO `dux_field` VALUES ('2', '1', '状态', 'status', '8', '', 'regex', '', '', '1', '1', '4', '', '通过,未审');
INSERT INTO `dux_field` VALUES ('4', '1', '留言内容', 'content', '2', '', 'regex', 'cmVxdWlyZQ==', 'Kg==', '1', '', '2', '请填写留言内容', '');
INSERT INTO `dux_field` VALUES ('5', '1', '时间', 'time', '10', '', 'regex', '', '', '1', '', '3', '', '');
INSERT INTO `dux_field` VALUES ('6', '1', '邮箱', 'email', '1', '', 'regex', 'ZW1haWw=', 'ZQ==', '1', '', '1', '邮箱地址不正确', '');
-- ----------------------------
-- Table structure for dux_fieldset
-- ----------------------------
DROP TABLE IF EXISTS `dux_fieldset`;
CREATE TABLE `dux_fieldset` (
`fieldset_id` int(10) NOT NULL AUTO_INCREMENT,
`table` varchar(250) DEFAULT NULL,
`name` varchar(250) DEFAULT NULL,
PRIMARY KEY (`fieldset_id`),
UNIQUE KEY `table` (`table`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dux_fieldset
-- ----------------------------
INSERT INTO `dux_fieldset` VALUES ('1', 'guestbook', '留言板');
-- ----------------------------
-- Table structure for dux_fieldset_expand
-- ----------------------------
DROP TABLE IF EXISTS `dux_fieldset_expand`;
CREATE TABLE `dux_fieldset_expand` (
`fieldset_id` int(10) DEFAULT NULL,
`status` tinyint(1) DEFAULT NULL,
UNIQUE KEY `fieldset_id` (`fieldset_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dux_fieldset_expand
-- ----------------------------
-- ----------------------------
-- Table structure for dux_fieldset_form
-- ----------------------------
DROP TABLE IF EXISTS `dux_fieldset_form`;
CREATE TABLE `dux_fieldset_form` (
`fieldset_id` int(10) DEFAULT NULL,
`show_list` tinyint(1) DEFAULT NULL,
`show_info` tinyint(1) DEFAULT NULL,
`list_page` int(5) DEFAULT NULL,
`list_where` varchar(250) DEFAULT NULL,
`list_order` varchar(250) DEFAULT NULL,
`tpl_list` varchar(250) DEFAULT NULL,
`tpl_info` varchar(250) DEFAULT NULL,
`post_status` tinyint(1) DEFAULT NULL,
`post_msg` varchar(250) DEFAULT NULL,
`post_return_url` varchar(250) DEFAULT NULL,
UNIQUE KEY `fieldset_id` (`fieldset_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dux_fieldset_form
-- ----------------------------
INSERT INTO `dux_fieldset_form` VALUES ('1', '1', '0', '10', '', 'data_id desc', 'guestbook', 'form_content', '1', '表单提交成功！', '');
-- ----------------------------
-- Table structure for dux_field_expand
-- ----------------------------
DROP TABLE IF EXISTS `dux_field_expand`;
CREATE TABLE `dux_field_expand` (
`field_id` int(10) DEFAULT NULL,
`post` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dux_field_expand
-- ----------------------------
-- ----------------------------
-- Table structure for dux_field_form
-- ----------------------------
DROP TABLE IF EXISTS `dux_field_form`;
CREATE TABLE `dux_field_form` (
`field_id` int(10) DEFAULT NULL,
`post` tinyint(1) DEFAULT '0',
`show` tinyint(1) DEFAULT '0',
`search` tinyint(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dux_field_form
-- ----------------------------
INSERT INTO `dux_field_form` VALUES ('1', '1', '1', '1');
INSERT INTO `dux_field_form` VALUES ('2', '1', '1', '1');
INSERT INTO `dux_field_form` VALUES ('4', '1', '1', '1');
INSERT INTO `dux_field_form` VALUES ('5', '1', '1', '1');
INSERT INTO `dux_field_form` VALUES ('6', '1', '1', '1');
-- ----------------------------
-- Table structure for dux_file
-- ----------------------------
DROP TABLE IF EXISTS `dux_file`;
CREATE TABLE `dux_file` (
`file_id` int(10) NOT NULL AUTO_INCREMENT,
`url` varchar(250) DEFAULT NULL,
`original` varchar(250) DEFAULT NULL,
`title` varchar(250) DEFAULT NULL,
`ext` varchar(250) DEFAULT NULL,
`size` int(10) DEFAULT NULL,
`time` int(10) DEFAULT NULL,
PRIMARY KEY (`file_id`),
KEY `ext` (`ext`),
KEY `time` (`time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dux_file
-- ----------------------------
-- ----------------------------
-- Table structure for dux_fragment
-- ----------------------------
DROP TABLE IF EXISTS `dux_fragment`;
CREATE TABLE `dux_fragment` (
`fragment_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章id',
`label` varchar(250) DEFAULT NULL,
`name` varchar(250) DEFAULT NULL,
`content` text,
PRIMARY KEY (`fragment_id`),
KEY `label` (`label`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章信息表';
-- ----------------------------
-- Records of dux_fragment
-- ----------------------------
-- ----------------------------
-- Table structure for dux_position
-- ----------------------------
DROP TABLE IF EXISTS `dux_position`;
CREATE TABLE `dux_position` (
`position_id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL,
`sequence` int(10) DEFAULT '0',
PRIMARY KEY (`position_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dux_position
-- ----------------------------
INSERT INTO `dux_position` VALUES ('1', '首页幻灯片', '0');
INSERT INTO `dux_position` VALUES ('2', '首页头条', '0');
INSERT INTO `dux_position` VALUES ('3', '首页推荐', '0');
-- ----------------------------
-- Table structure for dux_tags
-- ----------------------------
DROP TABLE IF EXISTS `dux_tags`;
CREATE TABLE `dux_tags` (
`tag_id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL,
`click` int(10) DEFAULT '1',
`quote` int(10) DEFAULT '1',
PRIMARY KEY (`tag_id`),
KEY `quote` (`quote`),
KEY `click` (`click`),
KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dux_tags
-- ----------------------------
-- ----------------------------
-- Table structure for dux_tags_has
-- ----------------------------
DROP TABLE IF EXISTS `dux_tags_has`;
CREATE TABLE `dux_tags_has` (
`content_id` int(10) DEFAULT NULL,
`tag_id` int(10) DEFAULT NULL,
KEY `aid` (`content_id`),
KEY `tid` (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of dux_tags_has
-- ----------------------------
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手