-- MySQL dump 10.14  Distrib 5.5.34-MariaDB, for Win32 (x86)
--
-- Host: localhost    Database: shopping
-- ------------------------------------------------------
-- Server version	5.5.34-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

-- 导出 mybatis 的数据库结构
DROP DATABASE IF EXISTS `shopping`;
CREATE DATABASE IF NOT EXISTS `shopping` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `shopping`;

--
-- Table structure for table `t_admin`
--

DROP TABLE IF EXISTS `t_admin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_admin` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '管理员编号',
  `name` varchar(20) DEFAULT NULL COMMENT '管理员名',
  `real_name` varchar(20) NOT NULL COMMENT '真实姓名',
  `pwd` varchar(20) NOT NULL COMMENT '管理员密码',
  `phone` varchar(20) DEFAULT NULL COMMENT '联系电话',
  `duty` varchar(50) DEFAULT NULL COMMENT '管理员职务',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态  0：禁用   1：正常',
  `photo` varchar(50) DEFAULT NULL COMMENT '管理员头像',
  `hiredate` datetime NOT NULL COMMENT '入职时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='管理员表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_admin`
--

LOCK TABLES `t_admin` WRITE;
/*!40000 ALTER TABLE `t_admin` DISABLE KEYS */;
INSERT INTO `t_admin` VALUES (1,'anlyt','小明','admin','18336954261','产品经理',1,'../../images/user3-128x128.jpg','2016-12-19 18:30:41'),(2,'admin','小花','admin','110','boss',1,'../../images/user3-128x128.jpg','1990-12-01 00:00:00'),(3,'freeman','张三','admin','15635968420','财务经理',1,'../../images/user3-128x128.jpg','2016-12-19 18:31:55'),(4,'jsonOBJECT','李四','admin','15842365978','市场经理',1,'../../images/user3-128x128.jpg','2016-12-19 18:33:10'),(5,'tom','苏三','admin','16489521036','人事经理',1,'../../images/user3-128x128.jpg','2016-12-19 18:35:35');
/*!40000 ALTER TABLE `t_admin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_admin_role`
--

DROP TABLE IF EXISTS `t_admin_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_admin_role` (
  `admin_id` int(10) NOT NULL,
  `role_id` int(10) NOT NULL,
  `id` int(10) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='管理员-角色关系表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_admin_role`
--

LOCK TABLES `t_admin_role` WRITE;
/*!40000 ALTER TABLE `t_admin_role` DISABLE KEYS */;
INSERT INTO `t_admin_role` VALUES (1,2,1),(2,1,2),(3,4,3),(4,3,4),(5,5,5);
/*!40000 ALTER TABLE `t_admin_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_advertisement`
--

DROP TABLE IF EXISTS `t_advertisement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_advertisement` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `name` varchar(50) NOT NULL COMMENT '广告名',
  `path` varchar(100) NOT NULL COMMENT '广告图片路径',
  `add_ad_time` datetime NOT NULL COMMENT '广告添加时间;默认系统时间',
  `goods_id` int(10) NOT NULL COMMENT '商品id',
  `add_people_name` varchar(20) DEFAULT NULL COMMENT '添加人姓名',
  `add_time_` datetime DEFAULT NULL COMMENT '添加时间',
  `alt_people_name` varchar(20) DEFAULT NULL COMMENT '修改人姓名',
  `alt_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='首页广告表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_advertisement`
--

LOCK TABLES `t_advertisement` WRITE;
/*!40000 ALTER TABLE `t_advertisement` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_advertisement` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_attribute`
--

DROP TABLE IF EXISTS `t_attribute`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_attribute` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '商品编号',
  `type` varchar(20) NOT NULL COMMENT '商品类型',
  `raw_place` varchar(20) NOT NULL COMMENT '原料产地',
  `pro_place` varchar(20) NOT NULL COMMENT '产地',
  `burdening` varchar(20) NOT NULL COMMENT '配料表',
  `weight` int(10) NOT NULL COMMENT '商品规格（重量g）(扩展通过重量来衡量是否包邮)',
  `expirattrtion` int(10) NOT NULL COMMENT '保质期（天',
  `standard_num` varchar(20) NOT NULL COMMENT '商品标准号',
  `licence_num` varchar(20) NOT NULL COMMENT '商品许可证号',
  `store_methods` varchar(20) NOT NULL COMMENT '储存方法',
  `eat_methods` varchar(20) NOT NULL COMMENT '使用方法',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='商品属性表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_attribute`
--

LOCK TABLES `t_attribute` WRITE;
/*!40000 ALTER TABLE `t_attribute` DISABLE KEYS */;
INSERT INTO `t_attribute` VALUES (1,'硬质糖类','广西','郑州市中原区','白砂糖',250,360,'A-001','XK-001','置于避光，避高温处','开袋即食，请勿整块吞下');
/*!40000 ALTER TABLE `t_attribute` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_authority`
--

DROP TABLE IF EXISTS `t_authority`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_authority` (
  `auth_id` int(8) NOT NULL AUTO_INCREMENT COMMENT '权限编号',
  `auth_name` varchar(20) NOT NULL COMMENT '权限名',
  `auth` varchar(20) NOT NULL COMMENT '权限',
  `auth_value` varchar(20) NOT NULL COMMENT 'url',
  PRIMARY KEY (`auth_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='权限表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_authority`
--

LOCK TABLES `t_authority` WRITE;
/*!40000 ALTER TABLE `t_authority` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_authority` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_brand`
--

DROP TABLE IF EXISTS `t_brand`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_brand` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '品牌编号',
  `name` varchar(20) NOT NULL COMMENT '品牌名称',
  `add_people_name` varchar(20) DEFAULT NULL COMMENT '添加人姓名',
  `add_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '增加时间',
  `alt_people_name` varchar(20) DEFAULT NULL COMMENT '修改人姓名',
  `alt_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='品牌表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_brand`
--

LOCK TABLES `t_brand` WRITE;
/*!40000 ALTER TABLE `t_brand` DISABLE KEYS */;
INSERT INTO `t_brand` VALUES (1,'金丝猴','ly','2016-12-12 06:35:27','ly','2016-12-12 14:35:27'),(2,'德芙','ly','2016-12-14 01:39:09','ly','2016-12-14 09:39:52');
/*!40000 ALTER TABLE `t_brand` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_brand_cate`
--

DROP TABLE IF EXISTS `t_brand_cate`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_brand_cate` (
  `brandid` int(10) NOT NULL COMMENT '品牌表id',
  `cateid` int(10) NOT NULL COMMENT '种类表id',
  PRIMARY KEY (`brandid`,`cateid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='品牌种类关系表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_brand_cate`
--

LOCK TABLES `t_brand_cate` WRITE;
/*!40000 ALTER TABLE `t_brand_cate` DISABLE KEYS */;
INSERT INTO `t_brand_cate` VALUES (1,1001),(1,1002),(2,1003),(2,1004),(2,1005),(2,1006),(2,1007),(2,1008),(2,1009);
/*!40000 ALTER TABLE `t_brand_cate` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_category`
--

DROP TABLE IF EXISTS `t_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_category` (
  `id` int(10) NOT NULL COMMENT '种类编号(手动添加)',
  `name` varchar(20) NOT NULL COMMENT '种类名称',
  `pid` int(10) NOT NULL COMMENT '种类父id',
  `path` varchar(100) NOT NULL COMMENT '父类的位置',
  `add_people_name` varchar(20) DEFAULT NULL COMMENT '添加人姓名',
  `add_time` datetime DEFAULT NULL COMMENT '添加时间',
  `alt_people_name` varchar(20) DEFAULT NULL COMMENT '修改人姓名',
  `alt_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商品种类表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_category`
--

LOCK TABLES `t_category` WRITE;
/*!40000 ALTER TABLE `t_category` DISABLE KEYS */;
INSERT INTO `t_category` VALUES (1,'糖果',0,'/0','ly','2016-12-12 14:53:18','ly','2016-12-12 14:53:22'),(2,'糖果原料',0,'/0','chen','2016-12-12 15:08:37','chen','2016-12-12 15:08:41'),(3,'巧克力原料',0,'/0','chen','2016-12-12 15:09:05','chen','2016-12-12 15:09:09'),(101,'硬糖',1,'/0/1','ly','2016-12-12 14:53:59','ly','2016-12-12 14:54:02'),(102,'巧克力',1,'/0/1','chen','2016-12-12 15:30:20','chen','2016-12-12 15:30:23'),(103,'软糖',1,'/0/1','chen','2016-12-13 16:55:40','chen','2016-12-13 16:55:43'),(104,'棉花糖',1,'/0/1','chen','2016-12-13 16:56:14','chen','2016-12-13 16:56:16'),(105,'可可豆',3,'/0/1','chen','2016-12-13 16:57:25','chen','2016-12-13 16:57:27'),(1001,'块糖',101,'/0/1/101','ly','2016-12-12 14:55:44','ly','2016-12-12 14:55:46'),(1002,'棒棒糖',101,'/0/1/101','ly','2016-12-12 14:56:15','ly','2016-12-12 14:56:17'),(1003,'夹心巧克力',102,'/0/1/102','chen','2016-12-12 15:32:18','chen','2016-12-12 15:32:20'),(1004,'果仁巧克力',102,'/0/1/102','chen','2016-12-12 15:32:58','chen','2016-12-12 15:33:01'),(1005,'酒心巧克力',102,'/0/1/102','chen','2016-12-12 15:33:32','chen','2016-12-12 15:33:34'),(1006,'黑巧克力',102,'/0/1/102','chen','2016-12-12 15:34:10','chen','2016-12-12 15:34:12'),(1007,'白巧克力',102,'/0/1/102','chen','2016-12-12 15:59:16','chen','2016-12-12 15:59:18'),(1008,'手工巧克力',102,'/0/1/102','chen','2016-12-12 15:59:51','chen','2016-12-12 15:59:53'),(1009,'白巧克力',105,'/0/1/105','chen','2016-12-14 17:23:48','chen','2016-12-14 17:23:50');
/*!40000 ALTER TABLE `t_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_coupon`
--

DROP TABLE IF EXISTS `t_coupon`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_coupon` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '优惠券id',
  `info` varchar(20) NOT NULL COMMENT '优惠券信息',
  `start_time` datetime NOT NULL COMMENT '优惠券开始时间',
  `end_time` datetime NOT NULL COMMENT '优惠券结束时间',
  `value` int(10) NOT NULL COMMENT '优惠券面值',
  `rule` int(10) NOT NULL COMMENT '使用优惠券的条件;超过该值可使用',
  `add_people_name` varchar(20) DEFAULT NULL COMMENT '添加人姓名',
  `add_time` datetime DEFAULT NULL COMMENT '增加时间',
  `alt_people_name` varchar(20) DEFAULT NULL COMMENT '修改人姓名',
  `alt_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='优惠劵表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_coupon`
--

LOCK TABLES `t_coupon` WRITE;
/*!40000 ALTER TABLE `t_coupon` DISABLE KEYS */;
INSERT INTO `t_coupon` VALUES (1,'用100减50','2016-12-21 11:11:27','2016-12-21 11:11:28',50,100,'chen','2016-12-21 11:12:00','chen','2016-12-21 11:12:03'),(2,'用200减100','2016-12-21 11:35:26','2016-12-21 11:35:26',100,200,'chen','2016-12-21 11:35:41','chen','2016-12-21 11:35:43');
/*!40000 ALTER TABLE `t_coupon` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_goods`
--

DROP TABLE IF EXISTS `t_goods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_goods` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '商品编号',
  `name` varchar(20) NOT NULL COMMENT '商品名称',
  `cate_id` int(10) NOT NULL COMMENT '商品种类; t_category表',
  `brand_id` int(10) NOT NULL COMMENT '商品品牌 ;参考t_brand表',
  `attr_id` int(10) NOT NULL COMMENT '商品属性; t_attribute表',
  `discount` double NOT NULL COMMENT '商品折扣 ;小数点后存两位',
  `is_free` int(1) NOT NULL COMMENT '商品是否包邮;1:包邮 2:不包邮',
  `displsy` int(1) NOT NULL DEFAULT '1' COMMENT '首页显示;1:不显示(默认),2:显示',
  `is_integral` int(1) NOT NULL COMMENT '商品是否可用积分;1:可用(最高可用积分为商品价格)2:不可用',
  `status` int(1) NOT NULL DEFAULT '1' COMMENT '商品状态;1:上架(默认) 2:下架',
  `repertory` int(10) NOT NULL COMMENT '库存',
  `add_people_name` varchar(20) DEFAULT NULL COMMENT '添加人姓名',
  `add_time` datetime DEFAULT NULL COMMENT '增加时间',
  `alt_people_name` varchar(20) DEFAULT NULL COMMENT '修改人姓名',
  `alt_time` datetime DEFAULT NULL COMMENT '修改时间',
  `description` varchar(100) DEFAULT NULL COMMENT '商品描述（关键字）',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='商品表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_goods`
--

LOCK TABLES `t_goods` WRITE;
/*!40000 ALTER TABLE `t_goods` DISABLE KEYS */;
INSERT INTO `t_goods` VALUES (1,'金丝猴玉米糖',1001,1,1,0.8,2,1,1,1,300,'ly','2016-12-12 15:24:25','ly','2016-12-12 15:24:27','金丝猴，玉米糖，硬糖，块糖，玉米味，甜品'),(2,'金丝猴硬糖（苹果味）',1002,1,1,1,2,1,1,1,200,'ly','2016-12-13 15:51:07','ly','2016-12-13 15:51:08','金丝猴，硬糖，块糖，苹果味，苹果糖，甜品'),(3,'巧克力原料',1009,1,1,1,2,1,1,1,100,'chen','2016-12-14 17:24:38','chen','2016-12-14 17:24:41','金丝猴，巧克力原料，甜品');
/*!40000 ALTER TABLE `t_goods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_img`
--

DROP TABLE IF EXISTS `t_img`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_img` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '图片id',
  `goods_id` int(10) NOT NULL COMMENT '商品id',
  `path` varchar(100) NOT NULL COMMENT '商品图片路径',
  `postion` int(1) NOT NULL COMMENT '商品显示位置;1:商品详情2:商品图片',
  `is_show` int(1) DEFAULT '1' COMMENT '商品图片是否默认显示; 1：默认显示图片',
  `add_people_name` varchar(20) DEFAULT NULL COMMENT '添加人姓名',
  `add_time` datetime DEFAULT NULL COMMENT '添加时间',
  `alt_people_name` varchar(20) DEFAULT NULL COMMENT '修改人姓名',
  `alt_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='商品图片表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_img`
--

LOCK TABLES `t_img` WRITE;
/*!40000 ALTER TABLE `t_img` DISABLE KEYS */;
INSERT INTO `t_img` VALUES (1,1,'C:/Users/Administrator/git/candystore/src/main/webapp/images/9.jpg',2,1,'chen','2016-12-15 19:29:11','chen','2016-12-15 19:29:13'),(2,1,'C:/Users/Administrator/git/candystore/src/main/webapp/images/g.jpg',2,1,'chen','2016-12-16 10:28:17','chen','2016-12-16 10:28:20'),(3,1,'C:/Users/Administrator/git/candystore/src/main/webapp/images/1bg.jpg',1,1,'chen','2016-12-16 20:36:10','chen','2016-12-16 20:36:12'),(4,1,'C:/Users/Administrator/git/candystore/src/main/webapp/images/2bg.jpg',1,1,'chen','2016-12-16 20:36:29','chen','2016-12-16 20:36:30'),(5,1,'C:/Users/Administrator/git/candystore/src/main/webapp/images/3bg.jpg',1,1,'chen','2016-12-16 20:36:46','chen','2016-12-16 20:36:48'),(6,1,'C:/Users/Administrator/git/candystore/src/main/webapp/images/4bg.jpg',1,1,'chen','2016-12-16 20:37:09','chen','2016-12-16 20:37:10'),(7,1,'C:/Users/Administrator/git/candystore/src/main/webapp/images/5bg.jpg',1,1,'chen','2016-12-16 20:37:24','chen','2016-12-16 20:37:26'),(8,2,'C:/Users/Administrator/git/candystore/src/main/webapp/images/9.jpg',2,1,'chen','2016-12-20 11:35:31','chen','2016-12-20 11:35:33'),(9,2,'C:/Users/Administrator/git/candystore/src/main/webapp/images/g.jpg',2,1,'chen','2016-12-20 11:36:01','chen','2016-12-20 11:36:04'),(10,2,'C:/Users/Administrator/git/candystore/src/main/webapp/images/1bg.jpg',1,1,'chen','2016-12-20 11:51:30','chen','2016-12-20 11:51:32'),(11,2,'C:/Users/Administrator/git/candystore/src/main/webapp/images/2bg.jpg',1,1,'chen','2016-12-20 11:52:00','chen','2016-12-20 11:52:03'),(12,2,'C:/Users/Administrator/git/candystore/src/main/webapp/images/3bg.jpg',1,1,'chen','2016-12-20 11:52:24',NULL,'2016-12-20 11:52:25');
/*!40000 ALTER TABLE `t_img` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_logger`
--

DROP TABLE IF EXISTS `t_logger`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_logger` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '日志id',
  `admin_id` int(10) NOT NULL COMMENT '操作人员id',
  `log_time` datetime NOT NULL COMMENT '操作时间',
  `log_table` int(10) NOT NULL COMMENT '要操作的表编号',
  `log_statue` int(2) NOT NULL COMMENT '操作类型;1:添加 2:修改3:删除',
  `log_info_id` int(10) NOT NULL COMMENT '操作的行id',
  `log_level` varchar(20) NOT NULL COMMENT '日志级别',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='日志表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_logger`
--

LOCK TABLES `t_logger` WRITE;
/*!40000 ALTER TABLE `t_logger` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_logger` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_menu`
--

DROP TABLE IF EXISTS `t_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_menu` (
  `menu_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
  `name` varchar(50) DEFAULT NULL COMMENT '菜单名称',
  `url` varchar(200) DEFAULT NULL COMMENT '菜单URL',
  `perms` varchar(500) DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
  `type` int(11) DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',
  `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `order_num` int(11) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='菜单管理';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_menu`
--

LOCK TABLES `t_menu` WRITE;
/*!40000 ALTER TABLE `t_menu` DISABLE KEYS */;
INSERT INTO `t_menu` VALUES (1,0,'权限管理','#','perm:*',0,'fa fa-dashboard',NULL),(2,1,'角色管理','','role:*',1,NULL,NULL),(3,0,'会员管理','#','user:*',0,'fa fa-th',NULL),(4,3,'会员列表',NULL,'user:*',1,NULL,NULL),(5,3,'数据导出',NULL,'user:*',1,NULL,NULL),(6,0,'产品管理','#','goods:*',0,'fa fa-laptop',NULL),(7,6,'产品添加',NULL,'goods:*',1,NULL,NULL),(8,6,'产品添加',NULL,'goods:*',1,NULL,NULL),(9,0,'积分管理','#','vip:*',0,'fa fa-edit',NULL),(10,9,'会员等级规则',NULL,'vip:*',1,NULL,NULL),(11,9,'消费积分规则',NULL,'vip:*',1,NULL,NULL),(12,0,'订单管理','#','order:*',0,'fa fa-table',NULL),(13,12,'订单列表',NULL,'order:*',1,NULL,NULL),(14,12,'订单报表',NULL,'order:*',1,NULL,NULL),(16,0,'财务管理','#','money:*',0,'fa fa-folder',NULL),(17,16,'财务列表',NULL,'money:*',1,NULL,NULL),(18,16,'财务报表',NULL,'money:*',1,NULL,NULL),(19,0,'数据统计','#','data:*',0,'fa fa-pie-chart',NULL),(20,19,'销售量统计',NULL,'data:*',1,NULL,NULL),(21,19,'销售额统计',NULL,'data:*',1,NULL,NULL),(22,19,'会员统计',NULL,'data:*',1,NULL,NULL),(23,0,'优惠劵管理','#','coupon:*',0,'fa fa-calendar',NULL),(24,23,'添加优惠劵',NULL,'coupon:*',1,NULL,NULL),(25,23,'查看优惠劵',NULL,'coupon:*',1,NULL,NULL),(26,0,'商城头条','#','news:*',0,'fa fa-envelope',NULL),(27,26,'添加头条',NULL,'news:*',1,NULL,NULL),(28,26,'查看头条',NULL,'news:*',1,NULL,NULL);
/*!40000 ALTER TABLE `t_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_news`
--

DROP TABLE IF EXISTS `t_news`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_news` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `title` varchar(20) NOT NULL COMMENT '头条标题',
  `summary` varchar(50) NOT NULL COMMENT '头条摘要',
  `content` text NOT NULL COMMENT '头条内容',
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '头条发布时间;默认系统时间',
  `add_people_name` varchar(20) DEFAULT NULL COMMENT '添加人姓名',
  `add_time` datetime DEFAULT NULL COMMENT '添加时间',
  `alt_people_name` varchar(20) DEFAULT NULL COMMENT '修改人姓名',
  `alt_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COMMENT='头条';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_news`
--

LOCK TABLES `t_news` WRITE;
/*!40000 ALTER TABLE `t_news` DISABLE KEYS */;
INSERT INTO `t_news` VALUES (2,'1','1','','2016-12-15 09:52:49',NULL,NULL,NULL,NULL),(3,'2','2','','2016-12-15 09:54:16',NULL,NULL,NULL,NULL),(4,'ww','打工行','国防生的风格<b>的分公司答复<i>答复是大法官1<img src=\"http://localhost:8080/plugins/layui/images/face/16.gif\" alt=\"[太开心]\"></i></b>','2016-12-15 10:00:26',NULL,NULL,NULL,NULL),(5,'秦莞尔','人员投入','打工行是大法官<b>速度发货速度<i>是大法官<img src=\"http://localhost:8080/plugins/layui/images/face/10.gif\" alt=\"[鄙视]\"></i></b>','2016-12-15 10:04:19','瑞文',NULL,NULL,NULL),(6,'请求','的规划法规','复合风管是梵蒂冈啊','2016-12-15 10:08:49','实施',NULL,NULL,NULL),(7,'qq群','水电费','发动机内水电费','2016-12-15 10:12:39','大富豪',NULL,NULL,NULL),(8,'32','233','4t6562','2016-12-16 12:31:31',NULL,NULL,NULL,NULL),(9,'555','555','丰田公司的尽快的肺结核<img src=\"http://localhost:8080/js/layui/images/face/1.gif\" alt=\"[嘻嘻]\">','2016-12-16 12:32:55',NULL,NULL,NULL,NULL),(10,'全文','如啼眼','uilrdhj多少分工会大风歌会计算的','2016-12-16 12:39:33',NULL,NULL,NULL,NULL),(11,'是大法官','上大人发过去啊','图可让她很感动反射','2016-12-16 12:41:35',NULL,NULL,NULL,NULL),(12,'44','44','44444444444444444444','2016-12-16 12:42:53',NULL,NULL,NULL,NULL),(13,'SDR','圣达菲','然后就儿童','2016-12-16 12:43:24',NULL,NULL,NULL,NULL),(14,'打撒','il','体育一厅','2016-12-16 12:44:15',NULL,NULL,NULL,NULL),(15,'风格化','接口','烦得很和法国获得<img src=\"http://localhost:8080/js/layui/images/face/4.gif\" alt=\"[可怜]\">大发光火','2016-12-16 12:48:24',NULL,NULL,NULL,NULL),(16,'就看见个','大风歌','的丰田公司国家法规','2016-12-16 12:49:09',NULL,NULL,NULL,NULL),(17,'预热','阿尔大风歌','想找个vfsfdgsd四方达嘎斯十多个发斯蒂芬都发生过<img src=\"http://localhost:8080/js/layui/images/face/30.gif\" alt=\"[思考]\">','2016-12-16 12:53:30','与科技',NULL,NULL,NULL),(18,'6534','3423','<p><span class=\"Apple-tab-span\">				</span>&lt;button type=\"reset\" class=\"layui-btn layui-btn-primary\"&gt;重置&lt;/button&gt;</p><p><span class=\"Apple-tab-span\">			</span>&lt;/div&gt;</p><p><span class=\"Apple-tab-span\">		</span>&lt;/div&gt;</p><p><span class=\"Apple-tab-span\">	</span>&lt;script type=\"text/javascript\"</p><p><span class=\"Apple-tab-span\">		</span>src=\"../../js/jquery-1.7.2.min.js\"&gt;&lt;/script&gt;</p><p><span class=\"Apple-tab-span\">	</span>&lt;script&gt;</p><p><span class=\"Apple-tab-span\">		</span>//Demo</p><p><span class=\"Apple-tab-span\">		</span>layui.use([ \'form\',\'layer\', \'layedit\' ], function() {</p><p><span class=\"Apple-tab-span\">			</span>var form = layui.form();</p><p><span class=\"Apple-tab-span\">			</span>var layedit = layui.layedit;</p><p><span class=\"Apple-tab-span\">			</span>var layer = layui.layer;</p><p><br></p><p><span class=\"Apple-tab-span\">			</span>var index = layedit.build(\'content\', {</p><p><span class=\"Apple-tab-span\">				</span>height : 500</p><p><span class=\"Apple-tab-span\">			</span>}); //建立编辑器</p>','2016-12-16 12:56:15','345',NULL,NULL,NULL),(19,'手动','圣达菲','水电费水电费','2016-12-16 12:57:52','圣达菲发改委',NULL,NULL,NULL),(20,'儿童','如啼眼','与他的发挥','2016-12-16 12:59:01','让他也',NULL,NULL,NULL),(21,'是','飞','圣达菲','2016-12-16 13:01:04','会员',NULL,NULL,NULL),(22,'很快乐','kl','iui环境的法规及','2016-12-16 13:04:56','体育台',NULL,NULL,NULL),(23,'发过很多','分公司的','非国家和德国','2016-12-16 13:05:52','输入方式',NULL,NULL,NULL),(24,'dfg ','jgk ','rtywaer','2016-12-17 00:52:14','rty',NULL,NULL,NULL),(25,'sd','sdfsd','aadfasd','2016-12-21 01:26:17','sdfsd',NULL,NULL,NULL);
/*!40000 ALTER TABLE `t_news` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_package`
--

DROP TABLE IF EXISTS `t_package`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_package` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '包装id',
  `goods_id` int(10) NOT NULL COMMENT '商品id',
  `name` varchar(20) NOT NULL COMMENT '包装名称',
  `price` double NOT NULL COMMENT '价格',
  `add_people_name` varchar(20) DEFAULT NULL COMMENT '添加人姓名',
  `add_time` datetime DEFAULT NULL COMMENT '增加时间',
  `alt_people_name` varchar(20) DEFAULT NULL COMMENT '修改人姓名',
  `alt_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='包装表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_package`
--

LOCK TABLES `t_package` WRITE;
/*!40000 ALTER TABLE `t_package` DISABLE KEYS */;
INSERT INTO `t_package` VALUES (1,1,'包装',0.2,'suns','2016-12-13 15:54:49','sss','2016-12-13 15:55:00'),(2,1,'新包装',20,'chen','2016-12-15 10:05:37','chen','2016-12-15 10:05:41'),(3,1,'第三个包装',100,'chen','2016-12-15 10:06:54','chen','2016-12-15 10:06:56'),(4,2,'这个包装',0.1,'ly','2016-12-19 15:45:26','ly','2016-12-19 15:45:29'),(5,3,'包装包装',0.5,'ly','2016-12-19 17:39:50','ly','2016-12-19 17:39:55');
/*!40000 ALTER TABLE `t_package` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_role`
--

DROP TABLE IF EXISTS `t_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_role` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '角色id',
  `name` varchar(20) NOT NULL COMMENT '角色名字',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='角色表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_role`
--

LOCK TABLES `t_role` WRITE;
/*!40000 ALTER TABLE `t_role` DISABLE KEYS */;
INSERT INTO `t_role` VALUES (1,'boss'),(2,'产品经理'),(3,'市场经理'),(4,'财务经理'),(5,'人事经理');
/*!40000 ALTER TABLE `t_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_role_menu`
--

DROP TABLE IF EXISTS `t_role_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_role_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) DEFAULT NULL COMMENT '角色ID',
  `menu_id` int(11) DEFAULT NULL COMMENT '菜单ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='角色与菜单对应关系';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_role_menu`
--

LOCK TABLES `t_role_menu` WRITE;
/*!40000 ALTER TABLE `t_role_menu` DISABLE KEYS */;
INSERT INTO `t_role_menu` VALUES (1,1,NULL),(2,2,6),(3,2,23),(4,2,26),(5,3,19),(6,4,16),(7,5,3),(8,5,9),(9,2,12);
/*!40000 ALTER TABLE `t_role_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_taste`
--

DROP TABLE IF EXISTS `t_taste`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_taste` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '口味id',
  `goods_id` int(10) NOT NULL COMMENT '商品id',
  `type` varchar(20) NOT NULL COMMENT '口味名称',
  `add_people_name` varchar(20) DEFAULT NULL COMMENT '添加人姓名',
  `add_time` datetime DEFAULT NULL COMMENT '增加时间',
  `alt_people_name` varchar(20) DEFAULT NULL COMMENT '修改人姓名',
  `alt_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='口味表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_taste`
--

LOCK TABLES `t_taste` WRITE;
/*!40000 ALTER TABLE `t_taste` DISABLE KEYS */;
INSERT INTO `t_taste` VALUES (1,1,'口味','chen','2016-12-15 10:46:33','chen','2016-12-15 10:46:35'),(2,1,'新口味','chen','2016-12-15 10:46:50','chen','2016-12-15 10:46:51'),(3,1,'原味','chen','2016-12-15 10:47:04','chen','2016-12-15 10:47:06'),(4,2,'牛奶味','chen','2016-12-20 11:36:56','chen','2016-12-20 11:36:58');
/*!40000 ALTER TABLE `t_taste` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_user`
--

DROP TABLE IF EXISTS `t_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_user` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(20) NOT NULL COMMENT '用户名 唯一约束',
  `pwd` varchar(20) DEFAULT NULL COMMENT '用户密码',
  `nickname` varchar(20) DEFAULT NULL COMMENT '用户的昵称',
  `sex` int(1) NOT NULL DEFAULT '1' COMMENT '用户性 1:男(默认) 2:女',
  `birthday` date DEFAULT NULL COMMENT '用户生日',
  `email` varchar(20) DEFAULT NULL COMMENT '用户邮箱',
  `phone` varchar(20) DEFAULT NULL COMMENT '用户手机号',
  `last_login` datetime DEFAULT NULL COMMENT '用户最后一次登录的时间',
  `register_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '用户注册的时间, 默认系统当前时间',
  `score` int(8) NOT NULL DEFAULT '0' COMMENT '用户积分 默认为0',
  `level_score` int(8) NOT NULL DEFAULT '0' COMMENT '用户等级积分 默认0  (参考等级表)',
  `status` int(1) NOT NULL DEFAULT '1' COMMENT '用户的状态 1:正常(默认) 2:冻结',
  `add_people_name` varchar(20) DEFAULT NULL COMMENT '添加人姓名',
  `add_time` timestamp NULL DEFAULT NULL COMMENT '添加时间',
  `alt_people_name` varchar(20) DEFAULT NULL COMMENT '修改人姓名',
  `alt_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COMMENT='用户基本信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_user`
--

LOCK TABLES `t_user` WRITE;
/*!40000 ALTER TABLE `t_user` DISABLE KEYS */;
INSERT INTO `t_user` VALUES (1,'admin','admin','w2e',2,'2015-05-29',NULL,NULL,'2016-12-19 09:04:16','2016-12-19 01:12:50',45,0,1,'','2016-12-19 01:04:21',NULL,NULL),(50,'324','211221','324',1,NULL,'2434@432','323325',NULL,'2016-12-19 08:26:32',0,0,1,NULL,NULL,NULL,NULL),(51,'342','12345','24',1,'2014-12-19','2323@24','32424',NULL,'2016-12-19 09:02:35',0,0,1,NULL,NULL,NULL,NULL),(52,'234','211221','342',1,'2014-12-19','2433@423','3242',NULL,'2016-12-19 09:13:54',0,0,1,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `t_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_user_address`
--

DROP TABLE IF EXISTS `t_user_address`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_user_address` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '收货地址id',
  `receive_name` varchar(20) NOT NULL COMMENT '收货人姓名',
  `phone` varchar(20) NOT NULL COMMENT '收货人电话',
  `address` varchar(50) NOT NULL COMMENT '收货地址',
  `user_id` int(10) NOT NULL COMMENT '所属用户id',
  `is_default` int(1) NOT NULL DEFAULT '1' COMMENT '默认地址1:默认2:不默认',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='收货地址表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_user_address`
--

LOCK TABLES `t_user_address` WRITE;
/*!40000 ALTER TABLE `t_user_address` DISABLE KEYS */;
INSERT INTO `t_user_address` VALUES (1,'王小乐','12345678901','河南省郑州市高新区',1,1),(2,'高小超','12345678901','宁夏自治区银川市西夏区',1,0),(3,'马小英','12345678901','湖南省长沙市芙蓉区',1,0);
/*!40000 ALTER TABLE `t_user_address` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_user_comment`
--

DROP TABLE IF EXISTS `t_user_comment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_user_comment` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '评价编号',
  `user_id` int(10) NOT NULL COMMENT '评价人id',
  `is_anonymity` int(1) NOT NULL DEFAULT '1' COMMENT '是否匿名 2 匿名 1:不匿名(默认)',
  `goods_id` int(10) NOT NULL COMMENT '评价商品id',
  `level` int(2) NOT NULL DEFAULT '1' COMMENT '评价等级 1:好(默认) 2:中 3:差',
  `content` text NOT NULL COMMENT '评价内容 (必须在12字以上)',
  `comtime` datetime NOT NULL COMMENT '评论时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='会员评价表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_user_comment`
--

LOCK TABLES `t_user_comment` WRITE;
/*!40000 ALTER TABLE `t_user_comment` DISABLE KEYS */;
INSERT INTO `t_user_comment` VALUES (1,1,1,1,1,'商品很不错，很满意','2016-12-09 11:47:10'),(2,1,1,1,1,'下次还来买','2016-12-09 11:47:30'),(3,1,1,1,1,'很好的','2016-12-19 15:55:20'),(4,1,1,1,2,'还行吧','2016-12-19 15:55:43'),(5,1,1,1,3,'东西太差了','2016-12-19 15:56:01'),(6,1,1,1,3,'不满意','2016-12-19 15:56:17'),(7,1,1,2,1,'很不错','2016-12-19 19:38:52'),(8,1,1,3,1,'很垃圾，再也不来了','2016-12-19 19:46:45');
/*!40000 ALTER TABLE `t_user_comment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_user_coupon`
--

DROP TABLE IF EXISTS `t_user_coupon`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_user_coupon` (
  `user_id` int(10) NOT NULL COMMENT '所属用户id',
  `coupon_id` int(10) NOT NULL COMMENT '优惠券id',
  `coupon_status` int(2) NOT NULL DEFAULT '1' COMMENT '优惠券状态(1:可用2:已使用3:失效)',
  PRIMARY KEY (`user_id`,`coupon_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户优惠券使用表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_user_coupon`
--

LOCK TABLES `t_user_coupon` WRITE;
/*!40000 ALTER TABLE `t_user_coupon` DISABLE KEYS */;
INSERT INTO `t_user_coupon` VALUES (1,1,1);
/*!40000 ALTER TABLE `t_user_coupon` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_user_like`
--

DROP TABLE IF EXISTS `t_user_like`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_user_like` (
  `goods_id` int(10) NOT NULL COMMENT '商品的id',
  `user_id` int(10) NOT NULL COMMENT 'user的id',
  PRIMARY KEY (`goods_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户收藏表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_user_like`
--

LOCK TABLES `t_user_like` WRITE;
/*!40000 ALTER TABLE `t_user_like` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_user_like` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_user_order`
--

DROP TABLE IF EXISTS `t_user_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_user_order` (
  `id` varchar(20) NOT NULL COMMENT '订单编号 Redis生成一个有规律的,当redis出现异常是,随机产生uuid',
  `begin_time` datetime NOT NULL COMMENT '订单开始时间;提交订单时生成',
  `end_time` datetime DEFAULT NULL COMMENT '订单成交时间;用户付款后生成',
  `status` int(1) NOT NULL DEFAULT '1' COMMENT '订单状态;1:未付款(默认) 2:已付款未发货 3:未收货 4:未评价 5:已评价',
  `user_id` int(10) NOT NULL COMMENT '关联用户',
  `logistics_id` varchar(20) DEFAULT NULL COMMENT '物流编号 ;发货后添加',
  `is_available` int(1) NOT NULL DEFAULT '1' COMMENT '订单是否有效;1:订单有效(默认) 2:订单失效',
  `total_price` double NOT NULL COMMENT '订单总价',
  `express_fee` double DEFAULT NULL COMMENT '邮费',
  `alt_people_name` varchar(20) DEFAULT NULL COMMENT '修改人姓名',
  `alt_time` datetime DEFAULT NULL COMMENT '修改时间',
  `is_receive` int(1) NOT NULL COMMENT '判断交易是否成功1:交易成功2:交易失败',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会员订单表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_user_order`
--

LOCK TABLES `t_user_order` WRITE;
/*!40000 ALTER TABLE `t_user_order` DISABLE KEYS */;
INSERT INTO `t_user_order` VALUES ('1','2016-12-15 15:09:58','2016-12-15 15:10:00',1,1,NULL,1,11,10,'chen','2016-12-15 15:10:33',1),('2','2016-12-20 11:43:46','2016-12-20 11:43:46',1,1,NULL,1,13,10,'chen','2016-12-20 11:44:06',1);
/*!40000 ALTER TABLE `t_user_order` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_user_order_item`
--

DROP TABLE IF EXISTS `t_user_order_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_user_order_item` (
  `goods_id` int(10) NOT NULL COMMENT '商品id',
  `order_id` varchar(20) NOT NULL COMMENT '订单编号',
  `goods_count` int(10) NOT NULL COMMENT '商品个数',
  `goods_name` varchar(20) NOT NULL COMMENT '商品名称(冗余)',
  `goods_price` double NOT NULL COMMENT '商品价格(冗余)',
  PRIMARY KEY (`goods_id`,`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单详情表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_user_order_item`
--

LOCK TABLES `t_user_order_item` WRITE;
/*!40000 ALTER TABLE `t_user_order_item` DISABLE KEYS */;
INSERT INTO `t_user_order_item` VALUES (1,'1',3,'硬糖',10.1),(1,'2',4,'硬糖',10.1),(2,'3',5,'苹果味',13);
/*!40000 ALTER TABLE `t_user_order_item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_vip`
--

DROP TABLE IF EXISTS `t_vip`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_vip` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '会员编号',
  `level_name` varchar(20) NOT NULL COMMENT '会员等级表 1普通2银牌3金牌',
  `add_people_name` varchar(20) DEFAULT NULL COMMENT '添加人姓名',
  `add_time` datetime DEFAULT NULL COMMENT '添加时间',
  `alt_people_name` varchar(20) DEFAULT NULL COMMENT '修改人姓名',
  `alt_time` datetime DEFAULT NULL COMMENT '修改时间',
  `max_grade` int(10) NOT NULL COMMENT '最大限度积分',
  `min_grade` int(10) NOT NULL COMMENT '最小限度积分',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会员等级表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_vip`
--

LOCK TABLES `t_vip` WRITE;
/*!40000 ALTER TABLE `t_vip` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_vip` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2016-12-21 14:14:00