-
Notifications
You must be signed in to change notification settings - Fork 0
/
easybuy.sql
160 lines (117 loc) · 17.7 KB
/
easybuy.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
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 COMMENT '商品主键',
`quantity` int(10) NOT NULL COMMENT '数量',
`cost` float NOT NULL COMMENT '消费',
PRIMARY KEY (`id`),
UNIQUE KEY `PK__EASYBUY___66E1BD8E2F10007B` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*Data for the table `easybuy_order_detail` */
insert into `easybuy_order_detail`(`id`,`orderId`,`productId`,`quantity`,`cost`) values (1,1,733,5,760),(2,1,734,4,608),(3,1,735,1,152),(4,1,738,1,45),(5,1,739,1,156),(6,2,755,1,8596),(7,3,733,1,152),(8,3,734,1,152),(9,3,735,1,152);
/*Table structure for table `easybuy_product` */
DROP TABLE IF EXISTS `easybuy_product`;
CREATE TABLE `easybuy_product` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(20) NOT NULL COMMENT '名称',
`description` varchar(1024) DEFAULT NULL COMMENT '描述',
`price` float NOT NULL COMMENT '价格',
`stock` int(10) NOT NULL COMMENT '库存',
`categoryLevel1Id` int(10) DEFAULT NULL COMMENT '分类1',
`categoryLevel2Id` int(10) DEFAULT NULL COMMENT '分类2',
`categoryLevel3Id` int(10) DEFAULT NULL COMMENT '分类3',
`fileName` varchar(200) DEFAULT NULL COMMENT '文件名称',
`isDelete` int(1) DEFAULT '0' COMMENT '是否删除(1：删除 0：未删除)',
PRIMARY KEY (`id`),
UNIQUE KEY `PK__EASYBUY___94F6E55132E0915F` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=771 DEFAULT CHARSET=utf8;
/*Data for the table `easybuy_product` */
insert into `easybuy_product`(`id`,`name`,`description`,`price`,`stock`,`categoryLevel1Id`,`categoryLevel2Id`,`categoryLevel3Id`,`fileName`,`isDelete`) values (733,'香奈儿','订单',152,94,548,654,655,'27A1789ED5764D82A5506DF3DC3933F9.jpg',0),(734,'洗面奶','',152,995,548,654,655,'D6C9BD438C5643D6B1A6C52E5426FE22.jpg',0),(735,'啫喱水','',152,998,548,654,655,'1A836D2B3A3348DDAB19807E6CEA8028.jpg',0),(736,'香水5852','',152,1000,548,654,655,'4D9499BAD92A42D291094E797BA2EA3F.jpg',0),(737,'香水','',152,111,548,654,655,'A9924F9DB68B4DF99FDBF05902075AF0.jpg',0),(738,'润肤露','',45,109,548,654,655,'3B059EDB5237407980458CE9EA9D3204.jpg',0),(739,'洁面装','',156,99,548,654,655,'A62C6DF55116440CA3DE9DB37901ED4F.jpg',0),(740,'电饭锅','',158,100,628,656,659,'40C3B76BA31246618E3CFC8723D33517.jpg',0),(741,'婴儿喂奶装','',569,100,632,637,653,'401004B3D47C4C6FB1BC5EF19C21FC77.jpg',0),(742,'坚果套餐','',158,1000,660,661,662,'E03D74145A034F6D909879829CB99D80.jpg',0),(743,'超甜蜜崭','',589,1000,660,661,663,'7121E55099FC477680B1229205CE3D29.jpg',0),(744,'华为2566','',589,1000,670,671,672,'F24B4140A2284B3788A38F3B5AD1809A.jpg',0),(745,'荣耀3C','',589,100,670,671,672,'F3921E12552A4D0AA3F75467B146A959.jpg',0),(746,'小米手环','',963,100,670,674,675,'72F75A371B0B4C26A7F72FAAEF96FC68.jpg',0),(747,'华为2265','',896,1000,670,671,673,'161F355A8A8549BA8F7F4CE3B4F07E40.jpg',0),(748,'越南坚果','',520,1000,660,661,662,'CBC98D3C9E544830821632F5C313D93E.jpg',0),(749,'日本进口马桶','',5866,100,628,657,0,'A5AF40825E6940B2A59A040100E181A8.jpg',0),(750,'联想Y系列','',569,1000,670,690,691,'956DB0BEC41B41B8A06C05C950130E23.jpg',0),(751,'脑白金1号','',589,1000,676,677,680,'66E96AF9E9714A5C9EA901811173D662.jpg',0),(752,'莫里斯按','',589,1000,676,678,0,'A7436BC607E74C81B392DCFE69D4AEAB.jpg',0),(753,'三鹿好奶粉','',859,100,676,679,0,'3C465E7B8A324A8DA2A2EEE202E36166.jpg',0),(754,'儿童牛奶','',5896,100,676,679,0,'D1AC9AE71ED348FA8D880FD4279D3422.jpg',0),(755,'软沙发','',8596,99,628,696,0,'ED7921DE40FC47E18365754709A21194.jpg',0),(756,'收纳盒','',5966,100,628,696,0,'DB86CA25CA4F4B4AA906F46BE542C6A6.jpg',0),(757,'洗衣液','',58,1000,628,696,0,'E6CCDC343ACC471C908E9748776C6421.jpg',0),(758,'红短沙发','',596,123,628,696,0,'BD5C77465DC2466BBCE7F95FB9764392.jpg',0),(759,'新西兰奶粉','',5896,100,676,679,0,'9ED375098D42497B8FC33167E06D0EE8.jpg',0),(760,'婴儿车','',11000,100,681,682,687,'1DBC0930641D43C29D74A9E1B40FEEBB.jpg',0),(761,'夏款婴儿车','',963,100,681,682,688,'16290C4DBEAC4F00A636667019621468.jpg',0),(762,'抗压旅行箱','',569,1000,681,683,685,'272CC434BE7A4469AB0E7882BD1A85FF.jpg',0),(763,'透明手提箱','',8596,1000,681,683,684,'EAA8E66259BF4239B4A2237B62520EF1.jpg',0),(764,'婴儿果粉','',5896,1000,660,661,662,'08BE30BF7B5F4930B0093D8CC4056057.jpg',0),(765,'椰子粉','',5963,1000,660,661,662,'9C006B8BD1AD45398F474A8471ADC50B.jpg',0),(766,'坚果蛋糕','',200,100,660,661,663,'2E5A16E21E0640E0BAE03E9B995DCD28.jpg',0),(767,'编制手提箱','',5896,1000,681,682,688,'2E1D2A5E65A94FEEA17C72E47C530057.jpg',0),(768,'纸箱','',5896,100,681,682,687,'443E5A4122064209AFE89250179A2FF0.jpg',0),(769,'健胃液','',152,1000,676,679,0,'30B5547CD7384DAA8A2F4F4D8C0BBF89.jpg',0),(770,'联想NTC','',8596,100,670,671,673,'48BC371A85A548B7A7589E3F542D911D.jpg',0);
/*Table structure for table `easybuy_product_category` */
DROP TABLE IF EXISTS `easybuy_product_category`;
CREATE TABLE `easybuy_product_category` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(20) NOT NULL COMMENT '名称',
`parentId` int(10) NOT NULL COMMENT '父级目录id',
`type` int(11) DEFAULT NULL COMMENT '级别(1:一级 2：二级 3：三级)',
`iconClass` varchar(255) DEFAULT NULL COMMENT '图标',
PRIMARY KEY (`id`),
UNIQUE KEY `PK__EASYBUY___9EC2A4E236B12243` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=697 DEFAULT CHARSET=utf8;
/*Data for the table `easybuy_product_category` */
insert into `easybuy_product_category`(`id`,`name`,`parentId`,`type`,`iconClass`) values (548,'化妆品',0,1,''),(628,'家用商品',0,1,''),(654,'面部护理',548,2,''),(655,'少女派',654,3,''),(656,'餐具',628,2,''),(657,'卫具',628,2,''),(658,'叉子',656,3,''),(659,'锅',656,3,''),(660,'进口食品,生鲜',0,1,''),(661,'零食/糖果/巧克力',660,2,''),(662,'坚果',661,3,''),(663,'蜜饯',661,3,''),(669,'孕期教育',546,3,''),(670,'电子商品',0,1,''),(671,'手机',670,2,''),(672,'华为手机',671,3,''),(673,'联想手机',671,3,''),(674,'手环',670,2,''),(675,'小米手环',674,3,''),(676,'保健食品',0,1,''),(677,'老年保健品',676,2,''),(678,'中年营养品',676,2,''),(679,'儿童保健品',676,2,''),(680,'脑白金',677,3,''),(681,'箱包',0,1,''),(682,'旅行箱',681,2,''),(683,'手提箱',681,2,''),(684,'大型',683,3,''),(685,'小型',683,3,''),(686,'中型',683,3,''),(687,'大型',682,3,''),(688,'中型',682,3,''),(689,'小型',682,3,''),(690,'电脑',670,2,''),(691,'联想电脑',690,3,''),(692,'刀叉',656,3,NULL),(693,'碗筷',656,3,NULL),(696,'客厅专用',628,2,'');
/*Table structure for table `easybuy_user` */
DROP TABLE IF EXISTS `easybuy_user`;
CREATE TABLE `easybuy_user` (
`id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`loginName` varchar(255) NOT NULL COMMENT '登录名',
`userName` varchar(255) NOT NULL COMMENT '用户名',
`password` varchar(255) NOT NULL COMMENT '密码',
`sex` int(2) NOT NULL DEFAULT '1' COMMENT '性别(1:男 0：女)',
`identityCode` varchar(60) DEFAULT NULL COMMENT '身份证号',
`email` varchar(80) DEFAULT NULL COMMENT '邮箱',
`mobile` varchar(11) DEFAULT NULL COMMENT '手机',
`type` int(2) DEFAULT '0' COMMENT '类型（1：后台 0:前台）',
PRIMARY KEY (`id`),
UNIQUE KEY `PK__EASYBUY___C96109CC3A81B327` (`loginName`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
/*Data for the table `easybuy_user` */
insert into `easybuy_user`(`id`,`loginName`,`userName`,`password`,`sex`,`identityCode`,`email`,`mobile`,`type`) values (2,'admin','系统管理员','e10adc3949ba59abbe56e057f20f883e',1,'130406198302141869','[email protected]','1583233515',1),(10,'cgn','程广宁','e10adc3949ba59abbe56e057f20f883e',1,'140225189987854589','[email protected]','13366055011',0),(11,'hyl','韩语良','e10adc3949ba59abbe56e057f20f883e',1,'140225198874584539','[email protected]','13366055010',0),(12,'ck','陈康','e10adc3949ba59abbe56e057f20f883e',1,'140225189987854589','[email protected]','13366055010',0),(13,'kys','康有沈','e10adc3949ba59abbe56e057f20f883e',1,'1402251985512541525','[email protected]','13366055010',0),(14,'sb','沈白','e10adc3949ba59abbe56e057f20f883e',1,'140225158987854589','[email protected]','13366055010',0),(15,'lb','李白','e10adc3949ba59abbe56e057f20f883e',1,'140225189987854589','[email protected]','1336998554',0),(16,'lgw','李高伟','e10adc3949ba59abbe56e057f20f883e',1,'140225189987854589','[email protected]','1336998554',0),(18,'shangzezhong','尚泽忠','4297f44b13955235245b2497399d7a93',1,'140225198810013745','[email protected]','13366528458',0),(19,'liguangliang','李光亮','25f9e794323b453885f5181f1b624d0b',1,'140225198841547785','[email protected]','13366055048',0),(20,'szz','李光亮','e10adc3949ba59abbe56e057f20f883e',1,'140225198810013748','[email protected]','13366555010',1);
/*Table structure for table `easybuy_user_address` */
DROP TABLE IF EXISTS `easybuy_user_address`;
CREATE TABLE `easybuy_user_address` (
`id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`userId` int(255) DEFAULT NULL COMMENT '用户主键',
`address` varchar(255) DEFAULT NULL COMMENT '地址',
`createTime` datetime DEFAULT NULL COMMENT '创建时间',
`isDefault` int(2) DEFAULT '0' COMMENT '是否是默认地址（1:是 0否）',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
/*Data for the table `easybuy_user_address` */
insert into `easybuy_user_address`(`id`,`userId`,`address`,`createTime`,`isDefault`,`remark`) values (11,2,'北京市海淀区大有庄',NULL,0,'朋友家'),(12,2,'北京市海淀区大有庄',NULL,0,'女朋友公司'),(13,9,'北京市西直门大桥芬兰国际大厦',NULL,0,'女朋友地址'),(14,18,'北京市花园路小区',NULL,0,'家里'),(15,18,'北京市海淀区成府路',NULL,0,'公司');
/*Table structure for table `result` */
DROP TABLE IF EXISTS `result`;
CREATE TABLE `result` (
`stuno` char(10) DEFAULT NULL,
`subjectName` char(10) DEFAULT NULL,
`score` int(10) DEFAULT NULL,
`age` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `result` */
insert into `result`(`stuno`,`subjectName`,`score`,`age`) values ('1','java',80,11),('1','c',78,12),('2','c',60,13),('3','java',75,14),('2','java',75,15),('4','java',90,16);
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;