qimall/addons/ShortVideo/install.sql

-- ----------------------------
-- Table structure for qimall_addons_short_video
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_short_video`;
CREATE TABLE `qimall_addons_short_video`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) UNSIGNED NOT NULL COMMENT '商家id',
  `user_id` int(10) UNSIGNED NOT NULL COMMENT '用户id',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '标题',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '内容',
  `video_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '视频路径',
  `first_frame` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '首帧',
  `video_wide` int(11) NOT NULL DEFAULT 0 COMMENT '视频宽度',
  `video_long` int(11) NOT NULL DEFAULT 0 COMMENT '视频长度',
  `duration_str` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '视频时长（时分秒字符串形式），upload_type = video 时才有意义',
  `duration_seconds` float(6, 2) NOT NULL DEFAULT 0.00 COMMENT '视频时长（秒为单位浮点数形式），upload_type = video 时才有意义',
  `related_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '关联类型1：关联商品 2：关联店铺 3：关联地址',
  `related_goods_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '关联商品id',
  `related_store_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '关联门店id',
  `related_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '关联地址',
  `related_detailed_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '关联详细地址',
  `related_lon` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '关联经度',
  `related_lat` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '关联维度',
  `tag_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '标签id',
  `open_integral_award` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启积分奖励 0：未开启 1：开启',
  `open_money_award` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启现金奖励 0：未开启 1：开启',
  `max_integral` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '积分最大值',
  `surplus_integral` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '剩余的积分',
  `spend_integral` decimal(12, 2) NOT NULL DEFAULT 0.00 COMMENT '花费积分',
  `max_money` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '金额最大值',
  `surplus_money` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '剩余金额',
  `spend_money` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '花费金额',
  `watch_integral_sum` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '观看奖励积分总和',
  `watch_integral` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '观看奖励积分百分比',
  `watch_integral_one` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '观看奖励积分一级百分比',
  `watch_integral_two` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '观看奖励现金二级百分比',
  `watch_money_sum` decimal(10, 0) UNSIGNED NOT NULL DEFAULT 0 COMMENT '观看现金奖励总和',
  `watch_money` decimal(10, 0) UNSIGNED NOT NULL DEFAULT 0 COMMENT '观看奖励现金百分比',
  `watch_money_one` decimal(10, 0) UNSIGNED NOT NULL DEFAULT 0 COMMENT '观看奖励现金一级百分比',
  `watch_money_two` decimal(10, 0) UNSIGNED NOT NULL DEFAULT 0 COMMENT '观看奖励现金二级百分比',
  `check_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '审核备注',
  `check_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '审核状态：0：未审核 1：审核通过 2：审核不通过',
  `comment_num` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '评论量',
  `like_num` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '点赞量',
  `look_people_num` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '观看人数',
  `look_complete_num` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '完整观看人数',
  `look_num` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '浏览量',
  `share_num` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '分享数量',
  `share_click_num` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '分享点击次数',
  `is_blacklist` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否拉黑0：否 1：是',
  `is_top` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否置顶0：否 1：是',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `check_time` int(11) NOT NULL DEFAULT 0 COMMENT '审核时间',
  `top_time` int(11) NOT NULL DEFAULT 0 COMMENT '置顶时间',
  `blacklist_time` int(11) NOT NULL DEFAULT 0 COMMENT '拉黑时间',
  `created_at` int(11) NOT NULL DEFAULT 0,
  `updated_at` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_mu_id`(`mall_id`, `user_id`) USING BTREE,
  INDEX `related_type`(`related_type`) USING BTREE,
  INDEX `is_blacklist`(`is_blacklist`) USING BTREE,
  INDEX `check_status`(`check_status`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '视频列表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_short_video_browse
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_short_video_browse`;
CREATE TABLE `qimall_addons_short_video_browse`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) UNSIGNED NOT NULL,
  `video_id` int(10) UNSIGNED NOT NULL COMMENT '视频id',
  `user_id` int(10) UNSIGNED NOT NULL COMMENT '用户id',
  `is_share` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否分享观看 0：否 1：是',
  `is_complete_look` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否完整观看0：否 1：是',
  `complete_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '完整观看时间',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `updated_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_mvu_id`(`mall_id`, `video_id`, `user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '视频浏览记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_short_video_browse_award
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_short_video_browse_award`;
CREATE TABLE `qimall_addons_short_video_browse_award`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) UNSIGNED NOT NULL,
  `video_id` int(10) UNSIGNED NOT NULL COMMENT '视频id',
  `user_id` int(10) UNSIGNED NOT NULL COMMENT '用户id',
  `source_user_id` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '源头id',
  `user_type` tinyint(4) NULL DEFAULT 0 COMMENT '用户类型：0：本人 1：一级 2：二级',
  `award_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '奖励类型 0：积分 1：现金',
  `award_integral` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '奖励积分',
  `award_money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '奖励金额',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `updated_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_mvu_id`(`mall_id`, `video_id`, `user_id`) USING BTREE,
  INDEX `award_type`(`award_type`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '观看视频奖励' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_short_video_browse_num
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_short_video_browse_num`;
CREATE TABLE `qimall_addons_short_video_browse_num`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `look_num` int(10) UNSIGNED NULL DEFAULT 1 COMMENT '观看次数',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `updated_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_mu_id`(`mall_id`, `user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户观看视频次数' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_short_video_comment
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_short_video_comment`;
CREATE TABLE `qimall_addons_short_video_comment`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `video_id` int(10) UNSIGNED NOT NULL COMMENT '视频id',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '评论内容',
  `like_num` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '点赞量',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `updated_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_mall_video_id`(`mall_id`, `video_id`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '视频评论列表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_short_video_comment_like
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_short_video_comment_like`;
CREATE TABLE `qimall_addons_short_video_comment_like`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL COMMENT '用戶id',
  `comment_id` int(10) UNSIGNED NOT NULL COMMENT '评论ID',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `updated_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_muc_id`(`mall_id`, `user_id`, `comment_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '评论点赞表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_short_video_commission_item_setting
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_short_video_commission_item_setting`;
CREATE TABLE `qimall_addons_short_video_commission_item_setting`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL COMMENT '商城ID',
  `is_enable` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否启用带货奖励：0:否;1是',
  `is_alone` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否独立设置：0:否;1是',
  `is_extra` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启额外分红：0:否;1是',
  `item_id` int(11) NOT NULL DEFAULT 0 COMMENT '项目id',
  `item_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '项目类型：商品goods',
  `commission_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '分佣类型：佣金：commission',
  `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_item_id`(`mall_id`, `item_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '短视频项目带货奖励设置' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_short_video_commission_item_setting_detail
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_short_video_commission_item_setting_detail`;
CREATE TABLE `qimall_addons_short_video_commission_item_setting_detail`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL COMMENT '商城ID',
  `short_video_commission_item_setting_id` int(11) NOT NULL,
  `level` int(11) NOT NULL DEFAULT 0,
  `calculate_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '计算方式，1：百分比，2：固定值',
  `value` decimal(12, 2) NOT NULL DEFAULT 0.00 COMMENT '值，calculate_type = 1 时表示百分比（计算时需要 /100）;calculate_type = 2 时表示设置的固定值',
  `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_m_c_id`(`mall_id`, `short_video_commission_item_setting_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '短视频项目带货奖励设置详情' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_short_video_config
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_short_video_config`;
CREATE TABLE `qimall_addons_short_video_config`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) UNSIGNED NOT NULL,
  `is_enabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启 0--关闭|1--开启',
  `is_check` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否需要审核0：否 1：是',
  `release_rule` tinyint(4) NOT NULL DEFAULT 0 COMMENT '发布权限：0：无条件 1：有条件',
  `award_status` tinyint(4) NULL DEFAULT 0 COMMENT '是否开启全局带货奖励0：否 1：是',
  `award_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '奖励类型 0：金额 1：百分比',
  `award_percentage` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '奖励百分比',
  `award_money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '奖励金额',
  `purchase_times_status` tinyint(4) NULL DEFAULT 0 COMMENT '消费达到多少次 是否开启 0：未开启 1：开启',
  `purchase_times` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '消费达到多少次',
  `purchase_cost_status` tinyint(4) NULL DEFAULT 0 COMMENT '消费达标是否开启0：未开启 1：已开启',
  `purchase_cost` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '消费达到多少钱',
  `purchase_goods_status` tinyint(4) NULL DEFAULT 0 COMMENT '消费商品是否开启0：未开启 1：已开启',
  `purchase_goods_id` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '消费某个商品',
  `video_lenght` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '视频发布时长',
  `agreement` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '视频协议',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `client_status` tinyint(4) NULL DEFAULT 0 COMMENT '是否开启文本审核 0：否 1：是',
  `start_up_diagram` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '启动图',
  `share_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '分享图片',
  `share_title` varchar(65) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '分享标题',
  `share_content` varchar(65) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '分享内容',
  `created_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `updated_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `mall_id`(`mall_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '视频配置' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_short_video_goods
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_short_video_goods`;
CREATE TABLE `qimall_addons_short_video_goods`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) UNSIGNED NOT NULL,
  `goods_id` int(10) UNSIGNED NOT NULL COMMENT '商品ID',
  `share_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '佣金类型 0，固定金额，1百分比',
  `percentage` decimal(10, 0) NULL DEFAULT 0 COMMENT '百分比',
  `fixed_value` decimal(10, 0) NULL DEFAULT 0 COMMENT '固定值',
  `is_alone` tinyint(4) NOT NULL DEFAULT 0 COMMENT '独立设置 0：否 1：是',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `updated_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_mg_id`(`mall_id`, `goods_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '短视频商品设置' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_short_video_like
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_short_video_like`;
CREATE TABLE `qimall_addons_short_video_like`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL COMMENT '用户id',
  `video_id` int(10) UNSIGNED NOT NULL COMMENT '视频id',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `updated_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_muv_id`(`mall_id`, `user_id`, `video_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '点赞记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_short_video_order_award
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_short_video_order_award`;
CREATE TABLE `qimall_addons_short_video_order_award`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) UNSIGNED NOT NULL,
  `video_id` int(10) UNSIGNED NOT NULL COMMENT '视频id',
  `order_id` int(10) UNSIGNED NOT NULL COMMENT '子订单id',
  `user_id` int(10) UNSIGNED NOT NULL COMMENT '用户id',
  `goods_id` int(10) UNSIGNED NOT NULL COMMENT '商品id',
  `goods_price` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '商品售价',
  `money` decimal(12, 2) NOT NULL DEFAULT 0.00 COMMENT '奖励金额',
  `award_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '奖励类型 0：金额 1：百分比',
  `award_percentage` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '奖励百分比',
  `award_money` decimal(12, 2) NOT NULL DEFAULT 0.00 COMMENT '奖励金额',
  `is_settlement` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否结算 0：否 1：是',
  `settlement_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '结算时间',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `goods_num` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品数量',
  `is_award` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '是否带货奖励商品 0：否 1：是',
  `created_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `updated_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `mall_id`(`mall_id`) USING BTREE,
  INDEX `order_id`(`order_id`) USING BTREE,
  INDEX `is_settlement`(`is_settlement`) USING BTREE,
  INDEX `video_id`(`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '短视频带货订单奖励' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_short_video_related_goods
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_short_video_related_goods`;
CREATE TABLE `qimall_addons_short_video_related_goods`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) UNSIGNED NOT NULL,
  `video_id` int(10) UNSIGNED NOT NULL,
  `goods_id` int(10) UNSIGNED NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
  `updated_at` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_mv_id`(`mall_id`, `video_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '视频商品关联记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_short_video_share
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_short_video_share`;
CREATE TABLE `qimall_addons_short_video_share`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL COMMENT '分享视频的会员的id',
  `share_to_user_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '观看分享的会员的id',
  `video_id` int(10) UNSIGNED NOT NULL COMMENT '视频id',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `updated_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_muv_id`(`mall_id`, `user_id`, `video_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '视频分享记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for qimall_addons_short_video_tag
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_short_video_tag`;
CREATE TABLE `qimall_addons_short_video_tag`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '标签名称',
  `create_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '创建类型1：用户创建 2：平台创建',
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '发布用户id',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '发布管理员id',
  `is_recommend` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否推荐 0：否 1：是',
  `recommend_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '推荐时间',
  `hot_num` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '热量',
  `usage_num` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '使用次数',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `updated_at` int(10) UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '视频标签' ROW_FORMAT = Dynamic;