From debb7b1ef8bb4e96e09b2d878ad821b4b2f3a110 Mon Sep 17 00:00:00 2001 From: xin <1099200748@qq.com> Date: Fri, 07 Nov 2025 22:00:17 +0800 Subject: [PATCH] 短信api更新维护（未完成） --- oying-system/src/main/resources/sql/update-2025年11月7日.sql | 51 +++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 51 insertions(+), 0 deletions(-) diff --git "a/oying-system/src/main/resources/sql/update-2025\345\271\2649\346\234\21029\346\227\245.sql" "b/oying-system/src/main/resources/sql/update-2025\345\271\26411\346\234\2107\346\227\245.sql" similarity index 80% rename from "oying-system/src/main/resources/sql/update-2025\345\271\2649\346\234\21029\346\227\245.sql" rename to "oying-system/src/main/resources/sql/update-2025\345\271\26411\346\234\2107\346\227\245.sql" index 6214b7e..31c73d0 100644 --- "a/oying-system/src/main/resources/sql/update-2025\345\271\2649\346\234\21029\346\227\245.sql" +++ "b/oying-system/src/main/resources/sql/update-2025\345\271\26411\346\234\2107\346\227\245.sql" @@ -1,3 +1,54 @@ +/* + 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; + DROP TABLE IF EXISTS fee_city_levels; CREATE TABLE fee_city_levels ( -- Gitblit v1.9.3