-
Notifications
You must be signed in to change notification settings - Fork 0
/
seckill.sql
117 lines (103 loc) · 4.78 KB
/
seckill.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
/*
Navicat MySQL Data Transfer
Source Server : 本地虚拟机mysql
Source Server Version : 50736
Source Host : 192.168.37.141:3306
Source Database : seckill
Target Server Type : MYSQL
Target Server Version : 50736
File Encoding : 65001
Date: 2022-07-23 16:37:59
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `t_goods`
-- ----------------------------
DROP TABLE IF EXISTS `t_goods`;
CREATE TABLE `t_goods` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '商品id',
`goods_name` varchar(16) CHARACTER SET latin1 DEFAULT NULL COMMENT '商品名称',
`goods_title` varchar(64) CHARACTER SET latin1 DEFAULT NULL COMMENT '商品标题',
`goods_img` varchar(64) CHARACTER SET latin1 DEFAULT NULL COMMENT '商品图片',
`goods_detail` longtext CHARACTER SET latin1 COMMENT '商品详情',
`goods_price` decimal(10,2) DEFAULT '0.00' COMMENT '商品价格',
`goods_stock` int(11) DEFAULT '0' COMMENT '商品库存',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of t_goods
-- ----------------------------
INSERT INTO `t_goods` VALUES ('1', 'IPHONE12', 'IPHONE 12 64GB', '/img/iphone12.png', 'IPHONE 12 64GB', '4799.00', '100');
INSERT INTO `t_goods` VALUES ('2', 'IPHONE12PRO', 'IPHONE 12 PRO 256GB', '/img/iphone12 pro.png', 'IPHONE 12 PRO 256GB', '7299.00', '100');
-- ----------------------------
-- Table structure for `t_order`
-- ----------------------------
DROP TABLE IF EXISTS `t_order`;
CREATE TABLE `t_order` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '订单id',
`user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
`goods_id` bigint(20) DEFAULT NULL COMMENT '商品id',
`delivery_addr_id` bigint(20) DEFAULT NULL COMMENT '收货地址',
`goods_name` varchar(16) DEFAULT NULL COMMENT '冗余过来的商品名称',
`goods_count` int(11) DEFAULT '0' COMMENT '商品数量',
`goods_price` decimal(10,2) DEFAULT '0.00' COMMENT '商品单价',
`order_channel` tinyint(4) DEFAULT '0' COMMENT '1pc,2android,3ios',
`status` tinyint(4) DEFAULT '0' COMMENT '订单转态,0新建未支付,1已支付,2已发货,3已收货,4已退款,5已完成',
`create_date` datetime DEFAULT NULL COMMENT '订单创建时间',
`pay_date` datetime DEFAULT NULL COMMENT '支付时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=222 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of t_order
-- ----------------------------
-- ----------------------------
-- Table structure for `t_seckill_goods`
-- ----------------------------
DROP TABLE IF EXISTS `t_seckill_goods`;
CREATE TABLE `t_seckill_goods` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '秒杀商品id',
`goods_id` bigint(20) DEFAULT NULL COMMENT '商品id',
`seckill_price` decimal(10,2) DEFAULT '0.00' COMMENT '秒杀价',
`stock_count` int(10) DEFAULT NULL COMMENT '库存数量',
`start_date` datetime DEFAULT NULL COMMENT '秒杀开始时间',
`end_date` datetime DEFAULT NULL COMMENT '秒杀结束时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of t_seckill_goods
-- ----------------------------
INSERT INTO `t_seckill_goods` VALUES ('1', '1', '4000.00', '10', '2022-07-21 18:33:22', '2022-07-23 18:33:28');
INSERT INTO `t_seckill_goods` VALUES ('2', '2', '6900.00', '10', '2022-07-20 18:33:56', '2022-07-22 18:33:58');
-- ----------------------------
-- Table structure for `t_seckill_order`
-- ----------------------------
DROP TABLE IF EXISTS `t_seckill_order`;
CREATE TABLE `t_seckill_order` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '秒杀订单id',
`user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
`order_id` bigint(20) DEFAULT NULL COMMENT '订单id',
`goods_id` bigint(20) DEFAULT NULL COMMENT '商品id',
PRIMARY KEY (`id`),
UNIQUE KEY `seckill_uid_gid` (`user_id`,`goods_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=222 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of t_seckill_order
-- ----------------------------
-- ----------------------------
-- Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`id` bigint(20) NOT NULL COMMENT '用户id,手机号码',
`nickname` varchar(255) NOT NULL,
`password` varchar(32) DEFAULT NULL,
`salt` varchar(10) DEFAULT NULL,
`head` varchar(128) DEFAULT NULL COMMENT '头像',
`register_date` date DEFAULT NULL COMMENT '注册时间',
`last_login_date` date DEFAULT NULL COMMENT '最后一次登录时间',
`login_count` int(11) NOT NULL DEFAULT '0' COMMENT '登录次数',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of t_user
-- ----------------------------