前提

前面建的User表只是为了测试redis与mysql，下面是项目数据库

库

商品表
秒杀商品表
订单表
秒杀订单表
秒杀用户表

  1. /*
  2. Navicat MySQL Data Transfer
  4. Source Server         : box_net_test
  5. Source Server Version : 50568
  6. Source Host           : mysql-test.agilenaas.net:3307
  7. Source Database       : company
  9. Target Server Type    : MYSQL
  10. Target Server Version : 50568
  11. File Encoding         : 65001
  13. Date: 2021-12-17 11:12:49
  14. */
  16. SET FOREIGN_KEY_CHECKS=0;
  18. -- ----------------------------
  19. -- Table structure for goods
  20. -- ----------------------------
  21. DROP TABLE IF EXISTS `goods`;
  22. CREATE TABLE `goods` (
  23.   `id` bigint(11) NOT NULL AUTO_INCREMENT,
  24.   `goods_name` varchar(255) DEFAULT NULL,
  25.   `goods_title` varchar(255) DEFAULT NULL,
  26.   `goods_img` varchar(255) DEFAULT NULL,
  27.   `goods_detail` varchar(255) DEFAULT NULL,
  28.   `goods_price` decimal(10,0) DEFAULT NULL,
  29.   `goods_stock` int(11) DEFAULT NULL,
  30.   PRIMARY KEY (`id`)
  31. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  33. -- ----------------------------
  34. -- Records of goods
  35. -- ----------------------------
  37. -- ----------------------------
  38. -- Table structure for miaosha_goods
  39. -- ----------------------------
  40. DROP TABLE IF EXISTS `miaosha_goods`;
  41. CREATE TABLE `miaosha_goods` (
  42.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
  43.   `goods_id` bigint(20) DEFAULT NULL,
  44.   `stock_count` int(11) DEFAULT NULL,
  45.   `start_date` datetime DEFAULT NULL,
  46.   `end_date` datetime DEFAULT NULL,
  47.   PRIMARY KEY (`id`)
  48. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  50. -- ----------------------------
  51. -- Records of miaosha_goods
  52. -- ----------------------------
  54. -- ----------------------------
  55. -- Table structure for miaosha_order
  56. -- ----------------------------
  57. DROP TABLE IF EXISTS `miaosha_order`;
  58. CREATE TABLE `miaosha_order` (
  59.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
  60.   `user_id` bigint(20) DEFAULT NULL,
  61.   `order_id` bigint(20) DEFAULT NULL,
  62.   `goods_id` bigint(20) DEFAULT NULL,
  63.   PRIMARY KEY (`id`)
  64. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  66. -- ----------------------------
  67. -- Records of miaosha_order
  68. -- ----------------------------
  70. -- ----------------------------
  71. -- Table structure for miaosha_user
  72. -- ----------------------------
  73. DROP TABLE IF EXISTS `miaosha_user`;
  74. CREATE TABLE `miaosha_user` (
  75.   `id` bigint(11) NOT NULL AUTO_INCREMENT,
  76.   `nick_name` varchar(255) DEFAULT NULL,
  77.   `password` varchar(255) DEFAULT NULL,
  78.   `salt` varchar(255) DEFAULT NULL,
  79.   `head` varchar(255) DEFAULT NULL,
  80.   `register_date` datetime DEFAULT NULL,
  81.   `last_login_date` datetime DEFAULT NULL,
  82.   `login_count` varchar(255) DEFAULT NULL,
  83.   PRIMARY KEY (`id`)
  84. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  86. -- ----------------------------
  87. -- Records of miaosha_user
  88. -- ----------------------------
  90. -- ----------------------------
  91. -- Table structure for order_info
  92. -- ----------------------------
  93. DROP TABLE IF EXISTS `order_info`;
  94. CREATE TABLE `order_info` (
  95.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
  96.   `user_id` bigint(20) DEFAULT NULL,
  97.   `goods_id` bigint(20) DEFAULT NULL,
  98.   `delivery_addr_id` bigint(20) DEFAULT NULL,
  99.   `goods_name` varchar(255) DEFAULT NULL,
  100.   `goods_count` int(11) DEFAULT NULL,
  101.   `goods_price` decimal(10,0) DEFAULT NULL,
  102.   `order_channel` int(11) DEFAULT NULL,
  103.   `status` int(11) DEFAULT NULL,
  104.   `create_date` datetime DEFAULT NULL,
  105.   `pay_date` datetime DEFAULT NULL,
  106.   PRIMARY KEY (`id`)
  107. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  109. -- ----------------------------
  110. -- Records of order_info
  111. -- ----------------------------