From f63e67acf46f345a5102840cc12eda17c0357fe5 Mon Sep 17 00:00:00 2001 From: 彭雪彬 <1724387007@qq.com> Date: Fri, 07 Nov 2025 14:55:51 +0800 Subject: [PATCH] 邀请新用户记录添加 --- oying-system/src/main/resources/sql/update-2025年11月7日.sql | 50 ++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 50 insertions(+), 0 deletions(-) diff --git "a/oying-system/src/main/resources/sql/update-2025\345\271\26411\346\234\2107\346\227\245.sql" "b/oying-system/src/main/resources/sql/update-2025\345\271\26411\346\234\2107\346\227\245.sql" new file mode 100644 index 0000000..0d8bf77 --- /dev/null +++ "b/oying-system/src/main/resources/sql/update-2025\345\271\26411\346\234\2107\346\227\245.sql" @@ -0,0 +1,50 @@ +/* + Navicat Premium Data Transfer + + Source Server : 118.145.136.116 + Source Server Type : MySQL + Source Server Version : 80041 + Source Host : 118.145.136.116:3306 + Source Schema : oying + + Target Server Type : MySQL + Target Server Version : 80041 + File Encoding : 65001 + + Date: 22/10/2025 16:46:07 +*/ + +SET NAMES utf8mb4; +SET FOREIGN_KEY_CHECKS = 0; + +-- ---------------------------- +-- Table structure for sys_invitations +-- ---------------------------- +DROP TABLE IF EXISTS `sys_invitations`; +CREATE TABLE `sys_invitations` ( + `invitations_id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT 'ID', + `inviter_id` bigint(0) NULL DEFAULT NULL COMMENT '邀请人ID', + `inviter_phone` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邀请人电话', + `inviter_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邀请人姓名', + `inviter_open_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邀请人openid', + `new_user_open_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '新用户openid', + `new_user_id` bigint(0) NULL DEFAULT 0 COMMENT '新用户ID', + `new_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '新用户姓名', + `new_user_phone` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '新用户电话', + `type` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '记录类型', + `user_type` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户类型', + `status` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '1success 0pending 2failed', + `reward_value` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '奖励数值', + `reward_type` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '奖励类型', + `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建者', + `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新者', + `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建日期', + `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', + PRIMARY KEY (`invitations_id`) USING BTREE +) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '邀请新用户记录' ROW_FORMAT = Dynamic; + +-- ---------------------------- +-- Records of sys_invitations +-- ---------------------------- + +SET FOREIGN_KEY_CHECKS = 1; -- Gitblit v1.9.3