qimall/addons/Bargain/install.sql

-- ----------------------------
-- Table structure for qimall_addons_bargain_active
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_bargain_active`;
CREATE TABLE `qimall_addons_bargain_active`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `cate_id` int(11) NOT NULL DEFAULT 0,
  `goods_id` int(11) NOT NULL DEFAULT 0,
  `attr_id` int(11) NOT NULL DEFAULT 0,
  `mall_id` int(11) NOT NULL DEFAULT 0,
  `min_price` decimal(11, 2) NOT NULL DEFAULT 0.00 COMMENT '最低价',
  `begin_time` int(11) NOT NULL DEFAULT 0 COMMENT '活动开始时间',
  `end_time` int(11) NOT NULL DEFAULT 0 COMMENT '活动结束时间',
  `time` tinyint(3) NOT NULL DEFAULT 0 COMMENT '砍价小时数',
  `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否允许中途下单 1--允许 2--不允许',
  `stock` int(11) NOT NULL DEFAULT 0 COMMENT '活动库存',
  `mode_data` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '砍价方式数据',
  `active_status` tinyint(3) NOT NULL DEFAULT 0 COMMENT '活动状态， 0--未开始，1--进行中,2--已结束',
  `initiator` int(11) NOT NULL DEFAULT 0 COMMENT '发起人数',
  `participant` int(11) NOT NULL DEFAULT 0 COMMENT '参与人数',
  `min_price_goods` int(11) NOT NULL DEFAULT 0 COMMENT '砍到最小价格数',
  `underway` int(11) NOT NULL DEFAULT 0 COMMENT '进行中的',
  `success` int(11) NOT NULL DEFAULT 0 COMMENT '成功的',
  `fail` int(11) NOT NULL DEFAULT 0 COMMENT '失败的',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT 0,
  `updated_at` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_mall_id_goods_id`(`mall_id`, `goods_id`) USING BTREE,
  INDEX `idx_cate_id`(`cate_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '砍价活动商品设置' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for qimall_addons_bargain_cate
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_bargain_cate`;
CREATE TABLE `qimall_addons_bargain_cate`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL COMMENT '商城id',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT 0,
  `updated_at` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_mall_id`(`mall_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '砍价分类表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for qimall_addons_bargain_order
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_bargain_order`;
CREATE TABLE `qimall_addons_bargain_order`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT 0,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `order_id` int(11) NOT NULL DEFAULT 0 COMMENT '主订订单id',
  `order_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '订单编号',
  `bargain_active_id` int(11) NOT NULL DEFAULT 0 COMMENT '砍价活动id',
  `cover_pic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `goods_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '售价',
  `min_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '最低价',
  `time` int(11) NOT NULL DEFAULT 0 COMMENT '砍价时间',
  `order_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态 0--进行中 1--成功 2--失败',
  `is_pay` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否支付:0否；1：是',
  `bargain_goods_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '砍价设置',
  `mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '收货人的手机号码',
  `receiver_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '收货人姓名',
  `province` int(11) NULL DEFAULT 0 COMMENT '收货人所在省',
  `city` int(11) NULL DEFAULT 0 COMMENT '收货人所在城市',
  `area` int(11) NULL DEFAULT 0 COMMENT '收货人所在街道',
  `zip` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '收货人邮编',
  `address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '详细地址',
  `region_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '地区名称（省市区[乡/镇]）',
  `bargain_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '砍后商品价格',
  `reduce_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '减少价格',
  `num` int(10) NOT NULL DEFAULT 0 COMMENT '购买数量',
  `payment_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '支付方式：1.在线支付 2.货到付款 3.余额支付',
  `pay_time` int(11) NOT NULL DEFAULT 0 COMMENT '支付时间',
  `shipping_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '订单配送方式【1物流配送 2买家自提 3货到付款 4本地配送】',
  `shipping_money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '运费',
  `total_pay_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '实际支付总费用(含运费）',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户订单备注',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT 0,
  `updated_at` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_bargain_active_id`(`bargain_active_id`) USING BTREE,
  INDEX `idx_mid_uid`(`mall_id`, `user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '砍价订单表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for qimall_addons_bargain_user_order
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_bargain_user_order`;
CREATE TABLE `qimall_addons_bargain_user_order`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT 0,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `bargain_order_id` int(11) NOT NULL DEFAULT 0 COMMENT '砍价订单ID',
  `price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '砍价的金额',
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT 0,
  `updated_at` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_bargain_order_id`(`bargain_order_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户参与砍价所砍的金额记录表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- 插入定时任务表
-- ----------------------------
INSERT INTO `qimall_crontab_task`(`name`, `command`, `type`, `rule`, `is_warning`, `status`, `created_at`, `updated_at`) VALUES 
('砍价订单自动取消', 'bargain-order/auto-close', 2, '0 */2 * * * *', 0, 1, 1641952763, 1641968929),
('自动结束过期砍价活动', 'bargain-order/auto-finish-active', 2, '0 31 0 * * *', 0, 1, 1641952825, 1641968938);


-- ----------------------------
-- 链接分类
-- ----------------------------
INSERT INTO `qimall_link_category` (`name`, `title`, `pid`, `is_list`, `remark`, `status`, `created_at`, `updated_at`) VALUES
('bargain_active', '砍价活动', 19, 1, NULL, 1, 1641457908, 1641457908),
('bargain_cate', '砍价分类', 19, 1, NULL, 1, 1641457941, 1641457941);

-- ----------------------------
-- 装修组件
-- ----------------------------
INSERT INTO `qimall_diy_components` (`code`, `title`, `group`, `icon`, `count`, `is_top`, `permission`, `sort`, `source`, `status`, `created_at`, `updated_at`) VALUES
('bargain-goods', '砍价', 'marketing', '', 999, 0, '{\"is_drag\":\"true\",\"is_up\":\"true\",\"id_down\":\"true\",\"is_copy\":\"true\"}', 999, 'Bargain', 1, 1634538238, 1634538238);