/*
SQLyog 企业版 - MySQL GUI v8.14
MySQL - 5.5.40 : Database - easybuy
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`easybuy` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `easybuy`;
/*Table structure for table `easybuy_news` */
DROP TABLE IF EXISTS `easybuy_news`;
CREATE TABLE `easybuy_news` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
`title` varchar(40) NOT NULL COMMENT '标题',
`content` varchar(1000) NOT NULL COMMENT '内容',
`createTime` varchar(10) NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`),
UNIQUE KEY `PK__EASYBUY___C63B5EE724927208` (`id`),
UNIQUE KEY `UQ__EASYBUY___C12AD09D276EDEB3` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=704 DEFAULT CHARSET=utf8;
/*Data for the table `easybuy_news` */
insert into `easybuy_news`(`id`,`title`,`content`,`createTime`) values (531,'会员特惠月开始了','会员特惠月开始了,亲们赶快下单啊,不到剁手誓不罢休啊,不到离婚誓不清空购物车啊。更多优惠，尽在易买网。','2010-12-22'),(597,'迎双旦促销大酬宾','迎双旦促销大酬宾','2010-12-24'),(649,'加入会员，赢千万大礼包','加入会员，赢千万大礼包','2010-12-22'),(650,'新年不夜天，通宵也是开张了','新年不夜天，通宵也是开张了','2011-05-22'),(651,'积分兑换开始了','积分兑换开始了','2010-12-22'),(653,'团购阿迪1折起','团购阿迪1折起','2010-12-22'),(664,'最新酷睿笔记本','IBME系列全场促销中，最新酷睿双核处理器，保证CPU更高效的运转。','2013-08-05'),(675,'aa','012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789','2013-08-14'),(676,'ResultR','ResultResultResultResultResu','2016-03-28'),(677,'会员特惠月开始了1','会员特惠月开始了','2010-12-22'),(678,'迎双旦促销大酬宾2','迎双旦促销大酬宾','2010-12-24'),(679,'加入会员，赢千万大礼包3','加入会员，赢千万大礼包','2010-12-22'),(680,'新年不夜天，通宵也是开张了4','新年不夜天，通宵也是开张了','2011-05-22'),(681,'积分兑换开始了5','积分兑换开始了','2010-12-22'),(682,'团购阿迪1折起6','团购阿迪1折起','2010-12-22'),(683,'最新酷睿笔记本7','IBME系列全场促销中，最新酷睿双核处理器，保证CPU更高效的运转。','2013-08-05'),(684,'aa8','012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789','2013-08-14'),(685,'ResultR9','ResultResultResultResultResu','2016-03-28'),(686,'会员特惠月开始了11','会员特惠月开始了','2010-12-22'),(687,'迎双旦促销大酬宾21','迎双旦促销大酬宾','2010-12-24'),(688,'加入会员，赢千万大礼包31','加入会员，赢千万大礼包','2010-12-22'),(689,'新年不夜天，通宵也是开张了41','新年不夜天，通宵也是开张了','2011-05-22'),(690,'积分兑换开始了51','积分兑换开始了','2010-12-22'),(691,'团购阿迪1折起61','团购阿迪1折起','2010-12-22'),(692,'最新酷睿笔记本71','IBME系列全场促销中，最新酷睿双核处理器，保证CPU更高效的运转。','2013-08-05'),(693,'aa81','012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789','2013-08-14'),(694,'ResultR91','ResultResultResultResultResu','2016-03-28'),(695,'会员特惠月开始了111','会员特惠月开始了','2010-12-22'),(696,'迎双旦促销大酬宾211','迎双旦促销大酬宾','2010-12-24'),(697,'加入会员，赢千万大礼包311','加入会员，赢千万大礼包','2010-12-22'),(698,'新年不夜天，通宵也是开张了411','新年不夜天，通宵也是开张了','2011-05-22'),(699,'积分兑换开始了511','积分兑换开始了','2010-12-22'),(700,'团购阿迪1折起611','团购阿迪1折起','2010-12-22'),(701,'最新酷睿笔记本711','IBME系列全场促销中，最新酷睿双核处理器，保证CPU更高效的运转。','2013-08-05'),(702,'aa811','012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789','2013-08-14'),(703,'ResultR911','ResultResultResultResultResu','2016-03-28');
/*Table structure for table `easybuy_order` */
DROP TABLE IF EXISTS `easybuy_order`;
CREATE TABLE `easybuy_order` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`userId` int(255) DEFAULT NULL COMMENT '用户主键',
`loginName` varchar(255) DEFAULT NULL,
`userAddress` varchar(255) DEFAULT NULL COMMENT '用户地址',
`createTime` datetime DEFAULT NULL COMMENT '创建时间',
`cost` float DEFAULT NULL COMMENT '总消费',
`serialNumber` varchar(255) DEFAULT NULL COMMENT '订单号',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*Data for the table `easybuy_order` */
insert into `easybuy_order`(`id`,`userId`,`loginName`,`userAddress`,`createTime`,`cost`,`serialNumber`) values (1,18,'shangzezhong','北京市花园路小区','2016-06-02 14:51:46',1721,'60B7487F47F9434EAA5FD1D9E22CB06C'),(2,18,'shangzezhong','北京市海淀区成府路','2016-06-02 14:52:49',8596,'8EF5E1557D55413781658A65FC301B8A'),(3,2,'admin','北京市海淀区大有庄','2016-06-03 11:41:09',456,'51718726C1274CC59504AB4E6FD64BA0');
/*Table structure for table `easybuy_order_detail` */
DROP TABLE IF EXISTS `easybuy_order_detail`;
CREATE TABLE `easybuy_order_detail` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
`orderId` int(10) NOT NULL COMMENT '订单主键',
`productId` int(10) NOT NULL COMM
