master

分支 (1)

管理

管理

master

jfinal-shop-b2b2c
/
jfinal-shop-b2b2c.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50154
Source Host           : localhost:3306
Source Database       : jfinal-shop-b2b2c

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

Date: 2016-12-10 16:42:45
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for xm_admin
-- ----------------------------
DROP TABLE IF EXISTS `xm_admin`;
CREATE TABLE `xm_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `password` varchar(40) NOT NULL,
  `email` varchar(40) DEFAULT NULL,
  `phone` varchar(40) DEFAULT NULL,
  `headImg` varchar(120) DEFAULT 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif',
  `registDate` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of xm_admin
-- ----------------------------
INSERT INTO `xm_admin` VALUES ('1', '紫电清霜', '4297f44b13955235245b2497399d7a93', 'iveryang@sina.cn', null, 'http://static.tieba.baidu.com/tb/editor/images/tsj/t_0002.gif', '2013-05-09');
INSERT INTO `xm_admin` VALUES ('3', 'xx', 'e10adc3949ba59abbe56e057f20f883e', '502713994@qq.com', null, 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', '2013-05-10');
INSERT INTO `xm_admin` VALUES ('4', '老北', 'eee85e1ec1ad81aa3d39353dc7d13f52', 'yswj81@163.com', null, 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', '2013-05-10');
INSERT INTO `xm_admin` VALUES ('5', 'bob', 'cf8e54a307ca7105d2562107f28a4559', 'yzqb@qq.com', null, 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', '2013-05-10');
INSERT INTO `xm_admin` VALUES ('6', '佩恩', '4cc79d0f881308a24f291d6f4e750830', 'sqhua@163.com', null, 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', '2013-05-10');
INSERT INTO `xm_admin` VALUES ('7', 'Mike_Liu', 'be9dbde87909c957ab8ba9709415ee92', '871005789@qq.com', null, 'http://mikeliu.cloudfoundry.com/img/s/me_mini.jpg', '2013-05-10');
INSERT INTO `xm_admin` VALUES ('8', '十二', '3fde6bb0541387e4ebdadf7c2ff31123', '785042976@qq.com', null, 'http://www.gravatar.com/avatar/f9d61d8de55171c2046fd587764a3386?d=mm', '2013-05-10');
INSERT INTO `xm_admin` VALUES ('9', 'mai', 'e10adc3949ba59abbe56e057f20f883e', '183591360@qq.com', null, 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', '2013-05-10');
INSERT INTO `xm_admin` VALUES ('10', 'JFinal', '446818b28bc03176a3991c2be86ea327', 'jfinal@126.com', '18637889898', 'http://static.oschina.net/uploads/user/100/201137_100.jpg', '2013-05-10');
INSERT INTO `xm_admin` VALUES ('95', '123123', '4297f44b13955235245b2497399d7a93', '123123@qq.com', '18637889898', 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', '2016-10-26');
INSERT INTO `xm_admin` VALUES ('96', '111122', '4297f44b13955235245b2497399d7a93', '4444@qq.com', '18678787878', 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', '2016-10-26');
INSERT INTO `xm_admin` VALUES ('97', '夏，朵儿', '4297f44b13955235245b2497399d7a93', null, null, 'http://qzapp.qlogo.cn/qzapp/100413274/60020C76D261E780795037611877E328/100', '2016-11-03');

-- ----------------------------
-- Table structure for xm_dict
-- ----------------------------
DROP TABLE IF EXISTS `xm_dict`;
CREATE TABLE `xm_dict` (
  `id` int(11) NOT NULL COMMENT '编号',
  `value` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '数据值',
  `label` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '标签名',
  `type` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '类型',
  `description` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '描述',
  `sort` decimal(10,0) NOT NULL COMMENT '排序（升序）',
  `parentId` varchar(64) COLLATE utf8_bin DEFAULT '0' COMMENT '父级编号',
  `createBy` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '创建者',
  `createDate` datetime NOT NULL COMMENT '创建时间',
  `updateBy` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '更新者',
  `updateDate` datetime NOT NULL COMMENT '更新时间',
  `remarks` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '备注信息',
  `del` char(1) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '删除标记',
  PRIMARY KEY (`id`),
  KEY `sys_dict_value` (`value`),
  KEY `sys_dict_label` (`label`),
  KEY `sys_dict_del_flag` (`del`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='字典表';

-- ----------------------------
-- Records of xm_dict
-- ----------------------------
INSERT INTO `xm_dict` VALUES ('1', '0', '正常', 'del_flag', '删除标记', '10', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('2', '1', '删除', 'del_flag', '删除标记', '20', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('3', '1', '显示', 'show_hide', '显示/隐藏', '10', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('4', '0', '隐藏', 'show_hide', '显示/隐藏', '20', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('5', '1', '是', 'yes_no', '是/否', '10', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('6', '0', '否', 'yes_no', '是/否', '20', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('7', 'red', '红色', 'color', '颜色值', '10', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('8', 'green', '绿色', 'color', '颜色值', '20', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('9', 'blue', '蓝色', 'color', '颜色值', '30', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('10', 'yellow', '黄色', 'color', '颜色值', '40', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('11', 'orange', '橙色', 'color', '颜色值', '50', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('12', 'default', '默认主题', 'theme', '主题方案', '10', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('13', 'cerulean', '天蓝主题', 'theme', '主题方案', '20', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('14', 'readable', '橙色主题', 'theme', '主题方案', '30', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('15', 'united', '红色主题', 'theme', '主题方案', '40', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('16', 'flat', 'Flat主题', 'theme', '主题方案', '60', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('17', '1', '国家', 'sys_area_type', '区域类型', '10', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('18', '2', '省份、直辖市', 'sys_area_type', '区域类型', '20', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('19', '3', '地市', 'sys_area_type', '区域类型', '30', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('20', '4', '区县', 'sys_area_type', '区域类型', '40', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('21', '1', '公司', 'sys_office_type', '机构类型', '60', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('22', '2', '部门', 'sys_office_type', '机构类型', '70', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('23', '3', '小组', 'sys_office_type', '机构类型', '80', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('24', '4', '其它', 'sys_office_type', '机构类型', '90', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('25', '1', '综合部', 'sys_office_common', '快捷通用部门', '30', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('26', '2', '开发部', 'sys_office_common', '快捷通用部门', '40', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('27', '3', '人力部', 'sys_office_common', '快捷通用部门', '50', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('28', '1', '一级', 'sys_office_grade', '机构等级', '10', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('29', '2', '二级', 'sys_office_grade', '机构等级', '20', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('30', '3', '三级', 'sys_office_grade', '机构等级', '30', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('31', '4', '四级', 'sys_office_grade', '机构等级', '40', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('32', '1', '所有数据', 'sys_data_scope', '数据范围', '10', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('33', '2', '所在公司及以下数据', 'sys_data_scope', '数据范围', '20', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('34', '3', '所在公司数据', 'sys_data_scope', '数据范围', '30', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('35', '4', '所在部门及以下数据', 'sys_data_scope', '数据范围', '40', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('36', '5', '所在部门数据', 'sys_data_scope', '数据范围', '50', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('37', '8', '仅本人数据', 'sys_data_scope', '数据范围', '90', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('38', '9', '按明细设置', 'sys_data_scope', '数据范围', '100', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('39', '1', '系统管理', 'sys_user_type', '用户类型', '10', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('40', '2', '部门经理', 'sys_user_type', '用户类型', '20', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('41', '3', '普通用户', 'sys_user_type', '用户类型', '30', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('42', 'basic', '基础主题', 'cms_theme', '站点主题', '10', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('43', 'blue', '蓝色主题', 'cms_theme', '站点主题', '20', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('44', 'red', '红色主题', 'cms_theme', '站点主题', '30', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('45', 'article', '文章模型', 'cms_module', '栏目模型', '10', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('46', 'picture', '图片模型', 'cms_module', '栏目模型', '20', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('47', 'download', '下载模型', 'cms_module', '栏目模型', '30', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('48', 'link', '链接模型', 'cms_module', '栏目模型', '40', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('49', 'special', '专题模型', 'cms_module', '栏目模型', '50', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('50', '0', '默认展现方式', 'cms_show_modes', '展现方式', '10', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('51', '1', '首栏目内容列表', 'cms_show_modes', '展现方式', '20', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('52', '2', '栏目第一条内容', 'cms_show_modes', '展现方式', '30', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('53', '0', '发布', 'cms_del_flag', '内容状态', '10', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('54', '1', '删除', 'cms_del_flag', '内容状态', '20', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('55', '2', '审核', 'cms_del_flag', '内容状态', '15', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('56', '1', '首页焦点图', 'cms_posid', '推荐位', '10', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('57', '2', '栏目页文章推荐', 'cms_posid', '推荐位', '20', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('58', '1', '咨询', 'cms_guestbook', '留言板分类', '10', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('59', '2', '建议', 'cms_guestbook', '留言板分类', '20', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('60', '3', '投诉', 'cms_guestbook', '留言板分类', '30', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('61', '4', '其它', 'cms_guestbook', '留言板分类', '40', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('62', '1', '公休', 'oa_leave_type', '请假类型', '10', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('63', '2', '病假', 'oa_leave_type', '请假类型', '20', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('64', '3', '事假', 'oa_leave_type', '请假类型', '30', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('65', '4', '调休', 'oa_leave_type', '请假类型', '40', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('66', '5', '婚假', 'oa_leave_type', '请假类型', '60', '0', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('67', '1', '接入日志', 'sys_log_type', '日志类型', '30', '0', '1', '2013-06-03 08:00:00', '1', '2013-06-03 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('68', '2', '异常日志', 'sys_log_type', '日志类型', '40', '0', '1', '2013-06-03 08:00:00', '1', '2013-06-03 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('69', 'leave', '请假流程', 'act_type', '流程类型', '10', '0', '1', '2013-06-03 08:00:00', '1', '2013-06-03 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('70', 'test_audit', '审批测试流程', 'act_type', '流程类型', '20', '0', '1', '2013-06-03 08:00:00', '1', '2013-06-03 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('71', '1', '分类1', 'act_category', '流程分类', '10', '0', '1', '2013-06-03 08:00:00', '1', '2013-06-03 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('72', '2', '分类2', 'act_category', '流程分类', '20', '0', '1', '2013-06-03 08:00:00', '1', '2013-06-03 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('73', 'crud', '增删改查', 'gen_category', '代码生成分类', '10', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('74', 'crud_many', '增删改查（包含从表）', 'gen_category', '代码生成分类', '20', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('75', 'tree', '树结构', 'gen_category', '代码生成分类', '30', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('76', '=', '=', 'gen_query_type', '查询方式', '10', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('77', '!=', '!=', 'gen_query_type', '查询方式', '20', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('78', '&gt;', '&gt;', 'gen_query_type', '查询方式', '30', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('79', '&lt;', '&lt;', 'gen_query_type', '查询方式', '40', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('80', 'between', 'Between', 'gen_query_type', '查询方式', '50', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('81', 'like', 'Like', 'gen_query_type', '查询方式', '60', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('82', 'left_like', 'Left Like', 'gen_query_type', '查询方式', '70', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('83', 'right_like', 'Right Like', 'gen_query_type', '查询方式', '80', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('84', 'input', '文本框', 'gen_show_type', '字段生成方案', '10', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('85', 'textarea', '文本域', 'gen_show_type', '字段生成方案', '20', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('86', 'select', '下拉框', 'gen_show_type', '字段生成方案', '30', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('87', 'checkbox', '复选框', 'gen_show_type', '字段生成方案', '40', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('88', 'radiobox', '单选框', 'gen_show_type', '字段生成方案', '50', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('89', 'dateselect', '日期选择', 'gen_show_type', '字段生成方案', '60', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('90', 'userselect', '人员选择\0', 'gen_show_type', '字段生成方案', '70', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('91', 'officeselect', '部门选择', 'gen_show_type', '字段生成方案', '80', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('92', 'areaselect', '区域选择', 'gen_show_type', '字段生成方案', '90', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('93', 'String', 'String', 'gen_java_type', 'Java类型', '10', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('94', 'Long', 'Long', 'gen_java_type', 'Java类型', '20', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('95', 'dao', '仅持久层', 'gen_category', '代码生成分类\0\0\0\0\0\0', '40', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('96', '1', '男', 'sex', '性别', '10', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('97', '2', '女', 'sex', '性别', '20', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('98', 'Integer', 'Integer', 'gen_java_type', 'Java类型\0\0', '30', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('99', 'Double', 'Double', 'gen_java_type', 'Java类型\0\0', '40', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('100', 'java.util.Date', 'Date', 'gen_java_type', 'Java类型\0\0', '50', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('101', 'com.thinkgem.jeesite.modules.sys.entity.User', 'User', 'gen_java_type', 'Java类型\0\0', '60', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('102', 'com.thinkgem.jeesite.modules.sys.entity.Office', 'Office', 'gen_java_type', 'Java类型\0\0', '70', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('103', 'com.thinkgem.jeesite.modules.sys.entity.Area', 'Area', 'gen_java_type', 'Java类型\0\0', '80', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('104', 'Custom', 'Custom', 'gen_java_type', 'Java类型\0\0', '90', '0', '1', '2013-10-28 08:00:00', '1', '2013-10-28 08:00:00', null, '1');
INSERT INTO `xm_dict` VALUES ('105', '1', '会议通告\0\0\0\0', 'oa_notify_type', '通知通告类型', '10', '0', '1', '2013-11-08 08:00:00', '1', '2013-11-08 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('106', '2', '奖惩通告\0\0\0\0', 'oa_notify_type', '通知通告类型', '20', '0', '1', '2013-11-08 08:00:00', '1', '2013-11-08 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('107', '3', '活动通告\0\0\0\0', 'oa_notify_type', '通知通告类型', '30', '0', '1', '2013-11-08 08:00:00', '1', '2013-11-08 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('108', '0', '草稿', 'oa_notify_status', '通知通告状态', '10', '0', '1', '2013-11-08 08:00:00', '1', '2013-11-08 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('109', '1', '发布', 'oa_notify_status', '通知通告状态', '20', '0', '1', '2013-11-08 08:00:00', '1', '2013-11-08 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('110', '0', '未读', 'oa_notify_read', '通知通告状态', '10', '0', '1', '2013-11-08 08:00:00', '1', '2013-11-08 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('111', '1', '已读', 'oa_notify_read', '通知通告状态', '20', '0', '1', '2013-11-08 08:00:00', '1', '2013-11-08 08:00:00', null, '0');
INSERT INTO `xm_dict` VALUES ('234', 'online', '在线支付', 'shop_payment_method_type', '支付方式类型', '10', '0', '1', '2016-08-31 23:16:52', '1', '2016-08-31 23:16:52', '', '0');
INSERT INTO `xm_dict` VALUES ('345', '2', '底部', 'shop_navigation_flag', '导航位置', '20', '0', '1', '2016-03-03 11:01:01', '1', '2016-03-03 11:01:01', '', '0');
INSERT INTO `xm_dict` VALUES ('544', '0', '正常', 'shop_member_flag', '会员状态', '10', '0', '1', '2016-03-03 13:09:24', '1', '2016-03-03 13:09:24', '', '0');
INSERT INTO `xm_dict` VALUES ('564', '0', '普通商品', 'shop_goods_type', '商品类型', '10', '0', '1', '2016-03-21 22:04:03', '1', '2016-03-21 22:04:03', '', '0');
INSERT INTO `xm_dict` VALUES ('654', '0', '入库', 'shop_stock_type', '库存类型', '10', '0', '1', '2016-08-24 23:21:31', '1', '2016-08-24 23:21:31', '', '0');
INSERT INTO `xm_dict` VALUES ('675', '1', '上部', 'shop_navigation_flag', '导航位置', '20', '0', '1', '2016-03-03 11:00:38', '1', '2016-03-03 11:00:38', '', '0');
INSERT INTO `xm_dict` VALUES ('676', 'image', '图片', 'shop_brand_type', '广告类型', '10', '0', '1', '2016-03-22 13:23:40', '1', '2016-03-22 13:23:40', '', '0');
INSERT INTO `xm_dict` VALUES ('678', '3', '团购商品', 'shop_tag_flag', '标签类型', '30', '0', '1', '2016-03-04 22:21:57', '1', '2016-03-04 22:21:57', '', '0');
INSERT INTO `xm_dict` VALUES ('787', '1', '积分商品', 'shop_goods_type', '商品类型', '20', '0', '1', '2016-03-21 22:04:14', '1', '2016-03-21 22:04:14', '', '0');
INSERT INTO `xm_dict` VALUES ('2343', 'text', '文字', 'shop_brand_type', '广告类型', '20', '0', '1', '2016-03-22 13:23:52', '1', '2016-03-22 13:23:52', '', '0');
INSERT INTO `xm_dict` VALUES ('4532', 'offline', '货到付款', 'shop_payment_method_type', '支付方式类型', '20', '0', '1', '2016-08-31 23:17:17', '1', '2016-08-31 23:17:17', '', '0');
INSERT INTO `xm_dict` VALUES ('5544', '1', '积分商品', 'shop_tag_flag', '标签类型', '20', '0', '1', '2016-03-04 22:21:26', '1', '2016-03-04 22:21:26', '', '0');
INSERT INTO `xm_dict` VALUES ('5675', '0', '中间', 'shop_navigation_flag', '导航位置', '10', '0', '1', '2016-03-03 11:00:11', '1', '2016-03-03 11:00:11', '', '0');
INSERT INTO `xm_dict` VALUES ('5784', '1', '出库', 'shop_stock_type', '库存类型', '20', '0', '1', '2016-08-24 23:21:44', '1', '2016-08-24 23:21:44', '', '0');
INSERT INTO `xm_dict` VALUES ('6786', '0', '正常商品', 'shop_tag_flag', '标签类型', '10', '0', '1', '2016-03-04 22:21:11', '1', '2016-03-04 22:21:11', '', '0');
INSERT INTO `xm_dict` VALUES ('7886', '1', '禁用', 'shop_member_flag', '会员状态', '20', '0', '1', '2016-03-03 13:09:37', '1', '2016-03-03 13:09:37', '', '0');

-- ----------------------------
-- Table structure for xm_goods
-- ----------------------------
DROP TABLE IF EXISTS `xm_goods`;
CREATE TABLE `xm_goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sn` varchar(60) NOT NULL,
  `sellerId` int(11) DEFAULT '0',
  `name` varchar(60) NOT NULL,
  `price` decimal(60,0) NOT NULL,
  `adminId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of xm_goods
-- ----------------------------
INSERT INTO `xm_goods` VALUES ('1', '1', '0', '1', '1', '1');

-- ----------------------------
-- Table structure for xm_member
-- ----------------------------
DROP TABLE IF EXISTS `xm_member`;
CREATE TABLE `xm_member` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `password` varchar(40) NOT NULL,
  `sex` bit(1) NOT NULL DEFAULT b'1',
  `email` varchar(30) DEFAULT NULL,
  `headImg` varchar(120) DEFAULT 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif',
  `blogUrl` varchar(80) DEFAULT NULL,
  `feeling` varchar(300) DEFAULT NULL,
  `registDate` date DEFAULT NULL,
  `point` int(11) NOT NULL DEFAULT '0',
  `rank` varchar(30) DEFAULT NULL,
  `tag` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of xm_member
-- ----------------------------
INSERT INTO `xm_member` VALUES ('1', '紫电清霜', '4297f44b13955235245b2497399d7a93', '', 'iveryang@sina.cn', 'http://static.tieba.baidu.com/tb/editor/images/tsj/t_0002.gif', 'http://iver.cloudfoundry.com', '天下风云出我辈， 一入江湖岁月催； 皇图霸业谈笑中， 不胜人生一场醉； 提剑跨骑挥鬼雨， 白骨如山鸟惊飞； 尘事如潮人如水， 只叹江湖几人回。', '2013-05-09', '33902', 'VIP1', '状元');
INSERT INTO `xm_member` VALUES ('3', 'xx', 'e10adc3949ba59abbe56e057f20f883e', '', '502713994@qq.com', 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', null, null, '2013-05-10', '0', null, null);
INSERT INTO `xm_member` VALUES ('4', '老北', 'eee85e1ec1ad81aa3d39353dc7d13f52', '', 'yswj81@163.com', 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', null, null, '2013-05-10', '0', null, null);
INSERT INTO `xm_member` VALUES ('5', 'bob', 'cf8e54a307ca7105d2562107f28a4559', '', 'yzqb@qq.com', 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', 'www.eytest.com', '想得到 做得到', '2013-05-10', '0', null, null);
INSERT INTO `xm_member` VALUES ('6', '佩恩', '4cc79d0f881308a24f291d6f4e750830', '', 'sqhua@163.com', 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', null, null, '2013-05-10', '0', null, null);
INSERT INTO `xm_member` VALUES ('7', 'Mike_Liu', 'be9dbde87909c957ab8ba9709415ee92', '', '871005789@qq.com', 'http://mikeliu.cloudfoundry.com/img/s/me_mini.jpg', 'http://mikeliu.cloudfoundry.com/', null, '2013-05-10', '0', null, null);
INSERT INTO `xm_member` VALUES ('8', '十二', '3fde6bb0541387e4ebdadf7c2ff31123', '', '785042976@qq.com', 'http://www.gravatar.com/avatar/f9d61d8de55171c2046fd587764a3386?d=mm', null, null, '2013-05-10', '0', null, null);
INSERT INTO `xm_member` VALUES ('9', 'mai', 'e10adc3949ba59abbe56e057f20f883e', '', '183591360@qq.com', 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', null, '赱', '2013-05-10', '0', null, null);
INSERT INTO `xm_member` VALUES ('10', 'JFinal', '446818b28bc03176a3991c2be86ea327', '', 'jfinal@126.com', 'http://static.oschina.net/uploads/user/100/201137_100.jpg', null, null, '2013-05-10', '0', null, null);
INSERT INTO `xm_member` VALUES ('95', '123123', '4297f44b13955235245b2497399d7a93', '', '123123@qq.com', 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', null, null, '2016-10-26', '0', null, null);
INSERT INTO `xm_member` VALUES ('96', '111122', '4297f44b13955235245b2497399d7a93', '', '4444@qq.com', 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', null, null, '2016-10-26', '0', null, null);
INSERT INTO `xm_member` VALUES ('97', '夏，朵儿', '4297f44b13955235245b2497399d7a93', '', null, 'http://qzapp.qlogo.cn/qzapp/100413274/60020C76D261E780795037611877E328/100', null, null, '2016-11-03', '0', 'VIP1', '小白');

-- ----------------------------
-- Table structure for xm_model
-- ----------------------------
DROP TABLE IF EXISTS `xm_model`;
CREATE TABLE `xm_model` (
  `id` int(11) NOT NULL,
  `type` varchar(100) NOT NULL COMMENT '类型(info:文档,node:栏目,node_home:首页;special:专题)',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `number` varchar(100) DEFAULT NULL COMMENT '代码',
  `sort` int(11) NOT NULL DEFAULT '10' COMMENT '顺序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='模型表';

-- ----------------------------
-- Records of xm_model
-- ----------------------------
INSERT INTO `xm_model` VALUES ('1', 'node_home', '首页', null, '0');
INSERT INTO `xm_model` VALUES ('2', 'info', '新闻', null, '0');
INSERT INTO `xm_model` VALUES ('3', 'node', '新闻', null, '0');
INSERT INTO `xm_model` VALUES ('4', 'node', '图集', null, '1');
INSERT INTO `xm_model` VALUES ('5', 'info', '图集', null, '1');
INSERT INTO `xm_model` VALUES ('6', 'node', '下载', null, '2');
INSERT INTO `xm_model` VALUES ('7', 'info', '下载', null, '2');
INSERT INTO `xm_model` VALUES ('8', 'node', '视频', null, '3');
INSERT INTO `xm_model` VALUES ('9', 'info', '视频(电影)', null, '3');
INSERT INTO `xm_model` VALUES ('10', 'node', '产品', null, '4');
INSERT INTO `xm_model` VALUES ('11', 'info', '产品(服饰/内衣)', null, '7');
INSERT INTO `xm_model` VALUES ('12', 'site', '站点模型', null, '2147483647');
INSERT INTO `xm_model` VALUES ('13', 'node', '招聘', null, '6');
INSERT INTO `xm_model` VALUES ('15', 'global', '系统', null, '2147483647');
INSERT INTO `xm_model` VALUES ('16', 'node', '转向链接', null, '7');
INSERT INTO `xm_model` VALUES ('17', 'special', '专题', null, '10');
INSERT INTO `xm_model` VALUES ('19', 'node', '文库', 'doc', '5');
INSERT INTO `xm_model` VALUES ('20', 'info', '文库', 'doc', '10');
INSERT INTO `xm_model` VALUES ('21', 'info', '招聘', null, '11');
INSERT INTO `xm_model` VALUES ('23', 'info', '视频(综艺)', null, '4');
INSERT INTO `xm_model` VALUES ('24', 'info', '产品(手机数码)', null, '5');
INSERT INTO `xm_model` VALUES ('25', 'info', '产品(电脑办公)', null, '6');
INSERT INTO `xm_model` VALUES ('26', 'info', '产品(图书/音像)', null, '8');
INSERT INTO `xm_model` VALUES ('27', 'info', '产品(家用电器)', null, '9');
INSERT INTO `xm_model` VALUES ('28', 'site', '站点模型', null, '2147483647');
INSERT INTO `xm_model` VALUES ('29', 'node_home', '首页', null, '0');
INSERT INTO `xm_model` VALUES ('30', 'node', '新闻', null, '0');
INSERT INTO `xm_model` VALUES ('31', 'info', '新闻', null, '0');

-- ----------------------------
-- Table structure for xm_order
-- ----------------------------
DROP TABLE IF EXISTS `xm_order`;
CREATE TABLE `xm_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sn` varchar(60) NOT NULL,
  `sellerId` int(11) DEFAULT '0',
  `name` varchar(60) NOT NULL,
  `price` decimal(60,0) NOT NULL,
  `adminId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of xm_order
-- ----------------------------
INSERT INTO `xm_order` VALUES ('1', '1', '0', '1', '1', '1');

-- ----------------------------
-- Table structure for xm_resource
-- ----------------------------
DROP TABLE IF EXISTS `xm_resource`;
CREATE TABLE `xm_resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `href` varchar(40) DEFAULT NULL,
  `icon` varchar(100) DEFAULT NULL,
  `isShow` bit(1) NOT NULL DEFAULT b'1',
  `permission` varchar(80) DEFAULT NULL,
  `createId` varchar(300) DEFAULT NULL,
  `createDate` date DEFAULT NULL,
  `isDel` bit(1) NOT NULL DEFAULT b'1',
  `sort` int(11) DEFAULT NULL,
  `parentId` int(11) DEFAULT NULL,
  `childrenIds` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of xm_resource
-- ----------------------------
INSERT INTO `xm_resource` VALUES ('1', '系统管理', '#22', 'fa-cubes', '\0', 'cc', '1', '2013-05-09', '\0', '1', '0', '98');
INSERT INTO `xm_resource` VALUES ('98', '管理员列表', 'admin/admin/list', 'fa-cubes', '\0', 'cc', '1', null, '', null, '1', null);
INSERT INTO `xm_resource` VALUES ('101', '资源列表', 'admin/resource/list', 'fa-cubes', '', null, null, null, '', null, '1', null);
INSERT INTO `xm_resource` VALUES ('102', '卖家管理', '#', 'fa-cubes', '', null, null, null, '', null, '0', null);
INSERT INTO `xm_resource` VALUES ('103', '卖家列表', 'admin/seller/list', 'fa-cubes', '', null, null, null, '', null, '102', null);
INSERT INTO `xm_resource` VALUES ('104', '会员管理', '##', 'fa-cubes', '', null, null, null, '', null, '0', null);
INSERT INTO `xm_resource` VALUES ('105', '会员列表', 'admin/member/list', 'fa-cubes', '', null, null, null, '', null, '104', null);
INSERT INTO `xm_resource` VALUES ('106', '模型管理', null, 'fa-cubes', '', null, null, null, '', null, '0', null);
INSERT INTO `xm_resource` VALUES ('107', '模型分类', null, 'fa-cubes', '', null, null, null, '', null, '106', null);
INSERT INTO `xm_resource` VALUES ('108', '模型列表', null, 'fa-cubes', '', null, null, null, '', null, '106', null);
INSERT INTO `xm_resource` VALUES ('109', '数据字典', 'admin/dict/list', 'fa-cubes', '', null, null, null, '', null, '1', null);
INSERT INTO `xm_resource` VALUES ('110', '商品管理', null, null, '', null, null, null, '', null, '0', null);
INSERT INTO `xm_resource` VALUES ('111', '商品列表', 'admin/goods/list', null, '', null, null, null, '', null, '110', null);
INSERT INTO `xm_resource` VALUES ('112', '订单管理', null, null, '', null, null, null, '', null, '0', null);
INSERT INTO `xm_resource` VALUES ('113', '订单列表', 'admin/order/list', null, '', null, null, null, '', null, '112', null);

-- ----------------------------
-- Table structure for xm_seller
-- ----------------------------
DROP TABLE IF EXISTS `xm_seller`;
CREATE TABLE `xm_seller` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL,
  `password` varchar(40) NOT NULL,
  `sex` bit(1) NOT NULL DEFAULT b'1',
  `email` varchar(30) DEFAULT NULL,
  `headImg` varchar(120) DEFAULT 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif',
  `blogUrl` varchar(80) DEFAULT NULL,
  `feeling` varchar(300) DEFAULT NULL,
  `registDate` date DEFAULT NULL,
  `point` int(11) NOT NULL DEFAULT '0',
  `rank` varchar(30) DEFAULT NULL,
  `tag` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of xm_seller
-- ----------------------------
INSERT INTO `xm_seller` VALUES ('1', '紫电清霜', '4297f44b13955235245b2497399d7a93', '', 'iveryang@sina.cn', 'http://static.tieba.baidu.com/tb/editor/images/tsj/t_0002.gif', 'http://iver.cloudfoundry.com', '天下风云出我辈， 一入江湖岁月催； 皇图霸业谈笑中， 不胜人生一场醉； 提剑跨骑挥鬼雨， 白骨如山鸟惊飞； 尘事如潮人如水， 只叹江湖几人回。', '2013-05-09', '33902', 'VIP1', '状元');
INSERT INTO `xm_seller` VALUES ('3', 'xx', 'e10adc3949ba59abbe56e057f20f883e', '', '502713994@qq.com', 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', null, null, '2013-05-10', '0', null, null);
INSERT INTO `xm_seller` VALUES ('4', '老北', 'eee85e1ec1ad81aa3d39353dc7d13f52', '', 'yswj81@163.com', 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', null, null, '2013-05-10', '0', null, null);
INSERT INTO `xm_seller` VALUES ('5', 'bob', 'cf8e54a307ca7105d2562107f28a4559', '', 'yzqb@qq.com', 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', 'www.eytest.com', '想得到 做得到', '2013-05-10', '0', null, null);
INSERT INTO `xm_seller` VALUES ('6', '佩恩', '4cc79d0f881308a24f291d6f4e750830', '', 'sqhua@163.com', 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', null, null, '2013-05-10', '0', null, null);
INSERT INTO `xm_seller` VALUES ('7', 'Mike_Liu', 'be9dbde87909c957ab8ba9709415ee92', '', '871005789@qq.com', 'http://mikeliu.cloudfoundry.com/img/s/me_mini.jpg', 'http://mikeliu.cloudfoundry.com/', null, '2013-05-10', '0', null, null);
INSERT INTO `xm_seller` VALUES ('8', '十二', '3fde6bb0541387e4ebdadf7c2ff31123', '', '785042976@qq.com', 'http://www.gravatar.com/avatar/f9d61d8de55171c2046fd587764a3386?d=mm', null, null, '2013-05-10', '0', null, null);
INSERT INTO `xm_seller` VALUES ('9', 'mai', 'e10adc3949ba59abbe56e057f20f883e', '', '183591360@qq.com', 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', null, '赱', '2013-05-10', '0', null, null);
INSERT INTO `xm_seller` VALUES ('10', 'JFinal', '446818b28bc03176a3991c2be86ea327', '', 'jfinal@126.com', 'http://static.oschina.net/uploads/user/100/201137_100.jpg', null, null, '2013-05-10', '0', null, null);
INSERT INTO `xm_seller` VALUES ('95', '123123', '4297f44b13955235245b2497399d7a93', '', '123123@qq.com', 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', null, null, '2016-10-26', '0', null, null);
INSERT INTO `xm_seller` VALUES ('96', '111122', '4297f44b13955235245b2497399d7a93', '', '4444@qq.com', 'http://static.tieba.baidu.com/tb/editor/images/ali/ali_008.gif', null, null, '2016-10-26', '0', null, null);
INSERT INTO `xm_seller` VALUES ('97', '夏，朵儿', '4297f44b13955235245b2497399d7a93', '', null, 'http://qzapp.qlogo.cn/qzapp/100413274/60020C76D261E780795037611877E328/100', null, null, '2016-11-03', '0', 'VIP1', '小白');