/*
Navicat MySQL Data Transfer

Source Server         : 123
Source Server Version : 50626
Source Host           : 123.56.44.104:3306
Source Database       : wx_xy

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

Date: 2015-12-15 13:26:38
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for xy_address
-- ----------------------------
DROP TABLE IF EXISTS `xy_address`;
CREATE TABLE `xy_address` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` int(11) NOT NULL,
  `address` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid` (`user_id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of xy_address
-- ----------------------------

-- ----------------------------
-- Table structure for xy_admin
-- ----------------------------
DROP TABLE IF EXISTS `xy_admin`;
CREATE TABLE `xy_admin` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `user` char(30) NOT NULL COMMENT '用户名',
  `psw` char(32) NOT NULL COMMENT '密码',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='后台用户表';

-- ----------------------------
-- Records of xy_admin
-- ----------------------------
INSERT INTO `xy_admin` VALUES ('1', 'zhang', '21232f297a57a5a743894a0e4a801fc3');
INSERT INTO `xy_admin` VALUES ('2', 'wuqiang', 'e10adc3949ba59abbe56e057f20f883e');

-- ----------------------------
-- Table structure for xy_buy
-- ----------------------------
DROP TABLE IF EXISTS `xy_buy`;
CREATE TABLE `xy_buy` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `xy_buycol` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='购买记录表';

-- ----------------------------
-- Records of xy_buy
-- ----------------------------

-- ----------------------------
-- Table structure for xy_jf
-- ----------------------------
DROP TABLE IF EXISTS `xy_jf`;
CREATE TABLE `xy_jf` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '用户id',
  `title` char(50) NOT NULL COMMENT '用户购买的产品标题，以及抵消的产品名称',
  `jifen` decimal(10,0) NOT NULL COMMENT '获取的积分或用掉的积分',
  `jj` char(5) NOT NULL COMMENT '加  或   减',
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '发生的时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of xy_jf
-- ----------------------------

-- ----------------------------
-- Table structure for xy_jg
-- ----------------------------
DROP TABLE IF EXISTS `xy_jg`;
CREATE TABLE `xy_jg` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `img` char(200) DEFAULT NULL COMMENT '图片',
  `monay` decimal(10,0) DEFAULT NULL COMMENT '金钱',
  `title` char(40) NOT NULL COMMENT '加工标题',
  `ftime` char(40) DEFAULT NULL COMMENT '发货时间',
  `qtime` char(40) DEFAULT NULL COMMENT '取货时间',
  `tel` bigint(11) NOT NULL COMMENT '用户的手机号',
  `jindu` char(30) NOT NULL COMMENT '再加工',
  `content` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='加工表';

-- ----------------------------
-- Records of xy_jg
-- ----------------------------
INSERT INTO `xy_jg` VALUES ('1', null, '1422', '我的名字叫张建强！123', '今天', '前天', '13611392611', '已完成', '');
INSERT INTO `xy_jg` VALUES ('3', '/Uploads/2015-12-01/565d0c52d65bf.jpg', '2078', '即可斩首', '今天12', '前天', '13611392611', '已完成', '即可斩首即可斩首12');

-- ----------------------------
-- Table structure for xy_pointlog
-- ----------------------------
DROP TABLE IF EXISTS `xy_pointlog`;
CREATE TABLE `xy_pointlog` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `user_id` int(10) NOT NULL COMMENT '用户id',
  `point` double(10,0) NOT NULL COMMENT '积分',
  `info` varchar(255) DEFAULT NULL COMMENT '积分操作描述',
  `time` int(10) NOT NULL COMMENT '操作时间',
  `type` int(2) NOT NULL COMMENT '改变类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of xy_pointlog
-- ----------------------------
INSERT INTO `xy_pointlog` VALUES ('1', '2', '2', '2', '1450103543', '2');
INSERT INTO `xy_pointlog` VALUES ('2', '2', '2', '2', '1450103741', '2');
INSERT INTO `xy_pointlog` VALUES ('3', '2', '2', '购买商品使用了2积分', '1450103788', '2');
INSERT INTO `xy_pointlog` VALUES ('4', '2', '2', '购买商品使用了2积分', '1450103937', '2');
INSERT INTO `xy_pointlog` VALUES ('5', '2', '2', '购买商品使用了2积分', '1450104030', '2');
INSERT INTO `xy_pointlog` VALUES ('6', '2', '2', '购买商品使用了2积分', '1450104668', '2');
INSERT INTO `xy_pointlog` VALUES ('7', '2', '2', '购买商品使用了2积分', '1450104706', '2');
INSERT INTO `xy_pointlog` VALUES ('8', '2', '2', '购买商品使用了2积分', '1450104800', '2');
INSERT INTO `xy_pointlog` VALUES ('9', '2', '2', '购买商品使用了2积分', '1450104844', '2');
INSERT INTO `xy_pointlog` VALUES ('10', '2', '2', '购买商品使用了2积分', '1450104921', '2');
INSERT INTO `xy_pointlog` VALUES ('11', '2', '8', '购买商品使用了8积分', '1450104952', '2');

-- ----------------------------
-- Table structure for xy_sp
-- ----------------------------
DROP TABLE IF EXISTS `xy_sp`;
CREATE TABLE `xy_sp` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '商品id',
  `title` varchar(45) NOT NULL DEFAULT '' COMMENT '产品名称',
  `bh` varchar(10) NOT NULL COMMENT '商品编号',
  `content` text NOT NULL COMMENT '内容',
  `monay` decimal(10,0) NOT NULL COMMENT '钱',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='商品表';

-- ----------------------------
-- Records of xy_sp
-- ----------------------------
INSERT INTO `xy_sp` VALUES ('4', '张建强玉器！', 'QWERTYUIOP', '', '132');
INSERT INTO `xy_sp` VALUES ('5', '玉器', 'QWERTYUIOO', ' ', '133');

-- ----------------------------
-- Table structure for xy_user
-- ----------------------------
DROP TABLE IF EXISTS `xy_user`;
CREATE TABLE `xy_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `openid` varchar(50) NOT NULL COMMENT '微信id',
  `nickname` varchar(30) NOT NULL COMMENT '用户名微信号',
  `sex` int(1) unsigned DEFAULT NULL COMMENT '性别',
  `city` varchar(20) DEFAULT '' COMMENT '城市',
  `provice` varchar(45) DEFAULT '' COMMENT '省份',
  `country` varchar(255) DEFAULT NULL COMMENT '国家',
  `headimgurl` varchar(255) DEFAULT NULL COMMENT '头像地址',
  `subscribe_time` int(11) DEFAULT NULL COMMENT '关注时间',
  `jifen` smallint(4) unsigned NOT NULL DEFAULT '0' COMMENT '用户积分',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  UNIQUE KEY `openid_UNIQUE` (`openid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of xy_user
-- ----------------------------
INSERT INTO `xy_user` VALUES ('1', '12', 'zhang', '0', '', '', null, null, null, '0');
INSERT INTO `xy_user` VALUES ('2', 'oEP3AuEZ21LPX8WRYHyGViSozc9E', '晓自由', '1', '', '', '阿尔巴尼亚', 'http://wx.qlogo.cn/mmopen/ajNVdqHZLLBkcJNzMNia0upPqNj7JkvQcQxeFYXw0CMjrCwK3R47jJIDHjcjQEKLfUQHeQ5BdoblIeQLnkv2UTg/0', '1449806364', '90');
INSERT INTO `xy_user` VALUES ('3', 'oEP3AuF_ELTXVNalnJZe6wUJfqow', 'Lgdragon', '2', '西雅图', '', '美国', 'http://wx.qlogo.cn/mmopen/AU36TKZwdgCHUWIc1vNicz7iagGkdddC7ze4jXkoqxdWic7uRqlmbxUDbMYwWt4uEUHG2xu8p06MceEBG6cQljgE56jXx8Ric5Ku/0', '1449825805', '0');
INSERT INTO `xy_user` VALUES ('4', 'oEP3AuDt4hb4Gs59ccPiFdnftuVQ', '大M', '1', '恩施', '', '中国', 'http://wx.qlogo.cn/mmopen/VEa6PLYpE7m4lkxHRFFIiaG3N8ohoUBsjwk8zs8qnrPjTVInReHUOTKiblCcgUBV0JHutsTu6aSicGATToKibBCSL7XCHsSnambB/0', '1450097358', '0');

-- ----------------------------
-- Table structure for xy_xw
-- ----------------------------
DROP TABLE IF EXISTS `xy_xw`;
CREATE TABLE `xy_xw` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` char(40) NOT NULL COMMENT '玉明斋',
  `content` text NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='新闻表';

-- ----------------------------
-- Records of xy_xw
-- ----------------------------
INSERT INTO `xy_xw` VALUES ('2', '我是一个粉刷匠！', '<p>我是一个粉刷匠！</p>', '2015-11-27 13:33:48');
INSERT INTO `xy_xw` VALUES ('3', '我是一个粉刷匠！123', '<p>我是一个粉刷匠！123</p>', '2015-11-27 13:33:58');