qimall/addons/HandBouns/install.sql

-- ----------------------------
-- Table structure for qimall_addons_hand_bouns
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_hand_bouns`;
CREATE TABLE `qimall_addons_hand_bouns`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT 0 COMMENT '商城ID',
  `bouns_file` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '导入文件路径',
  `operator_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作人昵称',
  `operator_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '操作人ID',
  `export_count` int(11) NOT NULL DEFAULT 0 COMMENT '总导入数量',
  `export_success_count` int(11) NOT NULL DEFAULT 0 COMMENT '导入成功数量',
  `export_fail_count` int(11) NOT NULL DEFAULT 0 COMMENT '导入失败数量',
  `status` int(1) NOT NULL DEFAULT 1 COMMENT '0是禁用，1是正常，-1是删除',
  `created_at` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  `export_status` int(1) NOT NULL DEFAULT 0 COMMENT '0是正在处理中，1是导入完成',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '手动分红记录' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for qimall_addons_hand_bouns_log
-- ----------------------------
DROP TABLE IF EXISTS `qimall_addons_hand_bouns_log`;
CREATE TABLE `qimall_addons_hand_bouns_log`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL DEFAULT 0 COMMENT '商城ID',
  `hand_bouns_id` int(11) NOT NULL DEFAULT 0 COMMENT '导入ID,qimall_addons_hand_bouns.id',
  `mobile` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手机号码,字段为字符串类型为了保存表格输入错误字段',
  `balance` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0.00' COMMENT '余额，字段为字符串类型为了保存表格输入错误字段',
  `score` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '积分，字段为字符串类型为了保存表格输入错误字段',
  `commission` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '佣金，字段为字符串类型为了保存表格输入错误字段',
  `export_status` int(1) NOT NULL DEFAULT 0 COMMENT '1是导入成功，2是导入失败',
  `status` int(1) NOT NULL DEFAULT 1 COMMENT '0是禁用，1是正常，-1是删除',
  `created_at` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间',
  `reason` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '失败原因',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '手动分红日志' ROW_FORMAT = DYNAMIC;