kxmall-main/doc/sql/increment/20240522kxmall3.sql

INSERT INTO `sys_menu` VALUES (1790733695359569921, '商品秒杀', 1680424073923559425, 2, 'storeSeckill', 'seckill/storeSeckill/index', NULL, 1, 0, 'C', '0', '0', 'seckill:storeSeckill:list', '#', 'admin', '2024-05-15 21:21:09', 'admin', '2024-05-15 21:39:30', '商品秒杀菜单');
INSERT INTO `sys_menu` VALUES (1790733695359569922, '商品秒杀查询', 1790733695359569921, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'seckill:storeSeckill:query', '#', 'admin', '2024-05-15 21:21:09', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1790733695359569923, '商品秒杀新增', 1790733695359569921, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'seckill:storeSeckill:add', '#', 'admin', '2024-05-15 21:21:09', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1790733695359569924, '商品秒杀修改', 1790733695359569921, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'seckill:storeSeckill:edit', '#', 'admin', '2024-05-15 21:21:09', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1790733695359569925, '商品秒杀删除', 1790733695359569921, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'seckill:storeSeckill:remove', '#', 'admin', '2024-05-15 21:21:09', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1790733695359569926, '商品秒杀导出', 1790733695359569921, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'seckill:storeSeckill:export', '#', 'admin', '2024-05-15 21:21:09', '', NULL, '');

DROP TABLE IF EXISTS `kx_store_seckill`;
CREATE TABLE `kx_store_seckill` (
        `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '商品秒杀产品表id',
        `storage_id` bigint(20) NOT NULL COMMENT '前置仓id',
        `product_id` bigint(20) unsigned NOT NULL COMMENT '商品id',
        `image` varchar(255) NOT NULL COMMENT '推荐图',
        `images` varchar(2000) DEFAULT NULL COMMENT '轮播图',
        `title` varchar(255) DEFAULT NULL COMMENT '活动标题',
        `info` varchar(255) DEFAULT NULL COMMENT '简介',
        `price` decimal(10,2) unsigned DEFAULT NULL COMMENT '价格',
        `cost` decimal(8,2) unsigned DEFAULT '0.00' COMMENT '成本',
        `ot_price` decimal(10,2) unsigned DEFAULT NULL COMMENT '原价',
        `give_integral` decimal(10,2) unsigned DEFAULT NULL COMMENT '返多少积分',
        `sort` int(10) unsigned DEFAULT NULL COMMENT '排序',
        `stock` int(10) unsigned NOT NULL COMMENT '库存',
        `sales` int(10) unsigned DEFAULT '0' COMMENT '销量',
        `unit_name` varchar(16) DEFAULT NULL COMMENT '单位名',
        `postage` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '邮费',
        `description` text COMMENT '内容',
        `start_time` date NOT NULL COMMENT '开始时间',
        `stop_time` date NOT NULL COMMENT '结束时间',
        `status` tinyint(1) unsigned NOT NULL COMMENT '产品状态',
        `is_postage` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否包邮',
        `is_hot` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '热门推荐',
        `num` int(11) unsigned NOT NULL COMMENT '最多秒杀几个',
        `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '显示',
        `time_id` int(10) unsigned DEFAULT '0' COMMENT '时间段id',
        `spec_type` tinyint(1) DEFAULT NULL COMMENT '规格 0单 1多',
        `temp_id` int(10) DEFAULT NULL COMMENT '运费模板id',
        `create_time` datetime DEFAULT NULL,
        `update_time` datetime DEFAULT NULL,
        `is_del` tinyint(1) DEFAULT '0',
        `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
        `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
        `seckill_start_time` varchar(20) NOT NULL COMMENT '范围开始时间',
        `seckill_stop_time` varchar(20) NOT NULL COMMENT '范围结束时间',
        PRIMARY KEY (`id`) USING BTREE,
        KEY `storage_id` (`storage_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1792453957469806594 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='商品秒杀表';