代码拉取完成，页面将自动刷新
同步操作将从 韩毅Evan/电商 强制同步，此操作会覆盖自 Fork 仓库以来所做的任何修改，且无法恢复！！！
确定后同步将在后台操作，完成时将刷新页面，请耐心等待。
/*
Navicat MySQL Data Transfer
Source Server : mysql
Source Server Version : 50718
Source Host : localhost:3306
Source Database : shopmall
Target Server Type : MYSQL
Target Server Version : 50718
File Encoding : 65001
Date: 2017-08-01 20:02:25
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for admin_menu
-- ----------------------------
DROP TABLE IF EXISTS `admin_menu`;
CREATE TABLE `admin_menu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL COMMENT '权限：商家管理；店铺管理',
`url` varchar(255) NOT NULL COMMENT '网址',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of admin_menu
-- ----------------------------
INSERT INTO `admin_menu` VALUES ('1', 'admin', 'das');
INSERT INTO `admin_menu` VALUES ('2', 'user', 'dasda');
-- ----------------------------
-- Table structure for admin_role
-- ----------------------------
DROP TABLE IF EXISTS `admin_role`;
CREATE TABLE `admin_role` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL COMMENT '身份：商户；管理员',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of admin_role
-- ----------------------------
INSERT INTO `admin_role` VALUES ('1', '管理员');
INSERT INTO `admin_role` VALUES ('2', '商户');
-- ----------------------------
-- Table structure for admin_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `admin_role_menu`;
CREATE TABLE `admin_role_menu` (
`rid` int(11) NOT NULL COMMENT '身份表id',
`mid` int(11) NOT NULL COMMENT '权限表id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of admin_role_menu
-- ----------------------------
INSERT INTO `admin_role_menu` VALUES ('1', '1');
INSERT INTO `admin_role_menu` VALUES ('2', '2');
-- ----------------------------
-- Table structure for admin_user
-- ----------------------------
DROP TABLE IF EXISTS `admin_user`;
CREATE TABLE `admin_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(255) NOT NULL COMMENT '邮箱',
`user_name` varchar(50) NOT NULL COMMENT '用户名',
`password` varchar(50) NOT NULL COMMENT '密码',
`is_valid` int(20) NOT NULL DEFAULT '1' COMMENT '是否有效：1有效；0无效',
PRIMARY KEY (`id`),
UNIQUE KEY `index_name` (`user_name`),
UNIQUE KEY `index_email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of admin_user
-- ----------------------------
INSERT INTO `admin_user` VALUES ('2', '844014005@qq.com', 'hanyiaidao', '123', '1');
INSERT INTO `admin_user` VALUES ('3', '13057572324@163.com', 'hanyi', '123', '1');
INSERT INTO `admin_user` VALUES ('4', '111@qq.com', '123', '123', '1');
-- ----------------------------
-- Table structure for admin_user_role
-- ----------------------------
DROP TABLE IF EXISTS `admin_user_role`;
CREATE TABLE `admin_user_role` (
`uid` int(11) NOT NULL COMMENT '用户表id',
`rid` int(11) NOT NULL DEFAULT '2' COMMENT '角色表id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of admin_user_role
-- ----------------------------
INSERT INTO `admin_user_role` VALUES ('2', '2');
INSERT INTO `admin_user_role` VALUES ('3', '2');
INSERT INTO `admin_user_role` VALUES ('4', '2');
-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编码',
`good_name` varchar(255) NOT NULL COMMENT '商品名称',
`good_type` int(11) DEFAULT NULL COMMENT '类目id（3级）',
`price` int(11) NOT NULL COMMENT '原价',
`promotion_price` int(10) NOT NULL COMMENT '促销价',
`bid` int(11) DEFAULT NULL COMMENT '商品品牌id',
`pic_url` varchar(255) DEFAULT NULL COMMENT '商品图片',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES ('1', '良品铺子 手剥松子218g 坚果炒货 巴西松子', null, '9800', '5690', null, 'images/01.jpg');
INSERT INTO `goods` VALUES ('2', '6期免息 Samsung/三星 Galaxy S8+ SM-G9550 4+64G 全网通手机', null, '618800', '618800', null, 'images/s8phone.png');
INSERT INTO `goods` VALUES ('3', '日式全实木床1.8/1.5/1.2米白橡木家具双人收纳箱体储物床带抽屉', null, '323300', '323300', null, 'images/bed.jpg');
-- ----------------------------
-- Table structure for goods_brand
-- ----------------------------
DROP TABLE IF EXISTS `goods_brand`;
CREATE TABLE `goods_brand` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`bname` varchar(255) DEFAULT NULL COMMENT '品牌名称',
`burl` varchar(255) DEFAULT NULL COMMENT '品牌网址',
`blogo` varchar(255) DEFAULT NULL COMMENT '品牌logo',
`bdesc` varchar(255) DEFAULT NULL COMMENT '品牌描述',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of goods_brand
-- ----------------------------
-- ----------------------------
-- Table structure for goods_type
-- ----------------------------
DROP TABLE IF EXISTS `goods_type`;
CREATE TABLE `goods_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type_name` varchar(50) NOT NULL COMMENT '类目名称',
`pid` int(11) NOT NULL COMMENT '本表id',
`picture` varchar(255) DEFAULT NULL COMMENT '一级类目图片',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of goods_type
-- ----------------------------
INSERT INTO `goods_type` VALUES ('1', '点心\\蛋糕', '0', '/images/cake.png');
INSERT INTO `goods_type` VALUES ('2', '饼干\\膨化', '0', '/images/cookies.png');
INSERT INTO `goods_type` VALUES ('3', '点心', '1', null);
INSERT INTO `goods_type` VALUES ('4', '蛋糕', '1', null);
INSERT INTO `goods_type` VALUES ('5', '饼干', '2', null);
INSERT INTO `goods_type` VALUES ('6', '薯片', '2', null);
INSERT INTO `goods_type` VALUES ('7', '虾条', '2', null);
INSERT INTO `goods_type` VALUES ('8', '蒸蛋糕', '4', null);
INSERT INTO `goods_type` VALUES ('9', '脱水蛋糕', '4', null);
INSERT INTO `goods_type` VALUES ('10', '马卡龙', '3', null);
INSERT INTO `goods_type` VALUES ('11', '铜锣烧', '3', null);
INSERT INTO `goods_type` VALUES ('12', '夹心饼干', '5', null);
INSERT INTO `goods_type` VALUES ('13', '曲奇饼干', '5', null);
INSERT INTO `goods_type` VALUES ('14', '碳烤薯片', '6', null);
INSERT INTO `goods_type` VALUES ('15', '原为薯片', '6', null);
INSERT INTO `goods_type` VALUES ('16', '海鲜虾条', '7', null);
INSERT INTO `goods_type` VALUES ('17', '原味虾条', '7', null);
INSERT INTO `goods_type` VALUES ('18', '熟食\\肉类', '0', '/images/meat.png');
-- ----------------------------
-- Table structure for mall_pay
-- ----------------------------
DROP TABLE IF EXISTS `mall_pay`;
CREATE TABLE `mall_pay` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID',
`amount` varchar(255) NOT NULL DEFAULT '' COMMENT '总金额',
`biz_id` varchar(255) NOT NULL DEFAULT '' COMMENT '业务订单ID 关联第三方的ID',
`status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0-未支付 1-支付成功 2-支付失败 3-失效',
`bank_id` varchar(255) DEFAULT '' COMMENT '银行ID',
`create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
`modify_time` varchar(255) NOT NULL DEFAULT '' COMMENT '修改时间',
`detail_msg` varchar(255) DEFAULT '' COMMENT '订单备注',
`pay_channel` int(11) NOT NULL DEFAULT '0' COMMENT '支付通道',
PRIMARY KEY (`Id`),
UNIQUE KEY `uk_usre_id_biz_id` (`user_id`,`biz_id`) COMMENT '用户ID和业务ID唯一约束'
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='支付订单表';
-- ----------------------------
-- Records of mall_pay
-- ----------------------------
INSERT INTO `mall_pay` VALUES ('14', '48', '56900', '14', '1', null, '2017-07-13 18:33:22', '2017-07-13 18:33:32', '若爆了', '4');
-- ----------------------------
-- Table structure for mall_sina_bank_order
-- ----------------------------
DROP TABLE IF EXISTS `mall_sina_bank_order`;
CREATE TABLE `mall_sina_bank_order` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`merchant_id` varchar(255) NOT NULL DEFAULT '' COMMENT '商户ID',
`order_amount` varchar(255) NOT NULL DEFAULT '' COMMENT '商户订单金额',
`order_id` varchar(255) NOT NULL DEFAULT '' COMMENT '商户订单ID',
`sign_type` varchar(255) NOT NULL DEFAULT '' COMMENT '签名类型',
`order_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '商户提交订单时间',
`create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '订单创建时间',
`modify_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '订单修改时间',
`pay_amount` varchar(255) NOT NULL DEFAULT '' COMMENT '实际支付金额',
`fee` varchar(255) NOT NULL DEFAULT '' COMMENT '手续费',
`status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '订单状态 0-未支付 1-支付中 2-支付成功 3-支付失败 4-订单过期',
`notify_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0-未通知 1-通知中 2-已通知',
`notify_times` tinyint(3) NOT NULL DEFAULT '0' COMMENT '通知的次数 最大30次',
`notify_merchant_url` varchar(255) NOT NULL DEFAULT '' COMMENT '异步通知商户地址',
`synch_merchant_url` varchar(255) DEFAULT '' COMMENT '商户同步通知地址',
`merchant_name` varchar(255) NOT NULL DEFAULT '' COMMENT '商户名称',
PRIMARY KEY (`Id`),
UNIQUE KEY `uk_merchant_id_order_id` (`merchant_id`,`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='新浪订单表';
-- ----------------------------
-- Records of mall_sina_bank_order
-- ----------------------------
INSERT INTO `mall_sina_bank_order` VALUES ('10', '1000000000999', '56900', '14', '1', '2017-07-13 06:33:22', '2017-07-13 18:33:27', '2017-07-13 18:33:27', '56900', '2', '1', '2', '1', 'http://pay.dayuanit.com:8088/payOrder/sinaNotify.do', 'http://pay.dayuanit.com:8088/payOrder/sinaNotify.do', '大猿商城');
-- ----------------------------
-- Table structure for order_details
-- ----------------------------
DROP TABLE IF EXISTS `order_details`;
CREATE TABLE `order_details` (
`order_id` int(11) NOT NULL COMMENT '订单主表id',
`goods_id` int(11) NOT NULL COMMENT '商品详情表id',
`price` int(11) NOT NULL COMMENT '单价',
`Number` int(11) NOT NULL COMMENT '数量',
PRIMARY KEY (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of order_details
-- ----------------------------
INSERT INTO `order_details` VALUES ('14', '1', '5690', '10');
-- ----------------------------
-- Table structure for shopcart
-- ----------------------------
DROP TABLE IF EXISTS `shopcart`;
CREATE TABLE `shopcart` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL COMMENT '所属用户',
`creat_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of shopcart
-- ----------------------------
INSERT INTO `shopcart` VALUES ('1', '48', '2017-06-29 11:19:02');
INSERT INTO `shopcart` VALUES ('3', '49', '2017-06-29 20:20:20');
-- ----------------------------
-- Table structure for shopcart_info
-- ----------------------------
DROP TABLE IF EXISTS `shopcart_info`;
CREATE TABLE `shopcart_info` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '购物车详表id',
`goods_id` int(11) NOT NULL COMMENT '商品详细表id',
`Number` int(11) NOT NULL COMMENT '购物车商品数量',
`shopcart_id` int(11) NOT NULL COMMENT '购物车主表id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of shopcart_info
-- ----------------------------
INSERT INTO `shopcart_info` VALUES ('1', '2', '10', '1');
INSERT INTO `shopcart_info` VALUES ('3', '1', '3', '1');
INSERT INTO `shopcart_info` VALUES ('8', '2', '1', '3');
INSERT INTO `shopcart_info` VALUES ('11', '1', '3', '3');
-- ----------------------------
-- Table structure for t_address
-- ----------------------------
DROP TABLE IF EXISTS `t_address`;
CREATE TABLE `t_address` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL COMMENT '用户表id',
`receiver` varchar(255) NOT NULL COMMENT '收货人',
`receiver_phone` varchar(255) NOT NULL COMMENT '收货人手机号',
`is_default` int(11) NOT NULL DEFAULT '2' COMMENT '是否为默认：1默认；2不是默认',
`province` varchar(255) NOT NULL COMMENT '省',
`city` varchar(255) NOT NULL COMMENT '市',
`area` varchar(255) NOT NULL COMMENT '区',
`detailed_address` varchar(255) NOT NULL COMMENT '详细地址',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_address
-- ----------------------------
INSERT INTO `t_address` VALUES ('1', '48', '韩毅', '13057572324', '1', '江苏', '南京', '浦口', '星火E方');
INSERT INTO `t_address` VALUES ('2', '48', '韩毅', '13057572324', '2', '江苏', '扬州', '仪征', '仓桥新村');
-- ----------------------------
-- Table structure for t_order
-- ----------------------------
DROP TABLE IF EXISTS `t_order`;
CREATE TABLE `t_order` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单号',
`money` int(11) DEFAULT NULL COMMENT '金额',
`pay_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '支付时间',
`order_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '下单时间',
`state` int(11) NOT NULL DEFAULT '1' COMMENT '是否有效：1代付款，2代发货，3待收货，4待评价',
`user_id` int(11) NOT NULL COMMENT '用户id',
`receiver` varchar(255) DEFAULT NULL COMMENT '收货人',
`receiver_address` varchar(255) DEFAULT NULL COMMENT '收货地址',
`receiver_phone` varchar(255) DEFAULT NULL COMMENT '收货人手机号',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_order
-- ----------------------------
INSERT INTO `t_order` VALUES ('14', '56900', '2017-07-13 18:33:22', '2017-07-13 18:33:22', '2', '48', null, null, null);
-- ----------------------------
-- Table structure for t_stock
-- ----------------------------
DROP TABLE IF EXISTS `t_stock`;
CREATE TABLE `t_stock` (
`goods_id` int(11) NOT NULL COMMENT '库存id',
`Number` int(11) NOT NULL COMMENT '商品库存余量',
PRIMARY KEY (`goods_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_stock
-- ----------------------------
INSERT INTO `t_stock` VALUES ('1', '1865');
INSERT INTO `t_stock` VALUES ('2', '1994');
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`username` varchar(50) DEFAULT NULL COMMENT '用户名',
`email` varchar(50) DEFAULT NULL COMMENT '邮箱',
`mobile` varchar(50) DEFAULT NULL COMMENT '电话号码',
`password` varchar(50) NOT NULL COMMENT '密码',
`is_valid` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否有效：1有效；0无效',
PRIMARY KEY (`id`),
KEY `moblie` (`mobile`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('48', null, null, '13057572324', '123', '1');
INSERT INTO `user` VALUES ('49', null, '844014005@qq.com', null, '123', '1');
INSERT INTO `user` VALUES ('50', null, null, '13057572322', '123', '1');
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手