推广商1-5级数据库变更情况
1-投资记录添加字段   tuiguang_flag   int类型    对应字典

   CREATE TABLE `investment_record` (
     `investment_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '投资记录编号',
     `investment_member_id` bigint DEFAULT NULL COMMENT '投资人ID',
     `investment_type_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '投资类型名称',
     `investment_yield` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '6%-20%' COMMENT '投资收益率',
     `investment_month_income` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0-1000' COMMENT '投资月预计收益',
     `investment_predict_income` decimal(10,2) DEFAULT '0.00' COMMENT '投资三年预计收益',
     `investment_count` decimal(20,4) DEFAULT '0.0000' COMMENT '投资数量',
     `investment_price` decimal(10,2) DEFAULT '0.00' COMMENT '投资单价（单位：40棵）',
     `investment_unit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '40棵/份' COMMENT '投资单位',
     `investment_amount` decimal(10,2) DEFAULT '0.00' COMMENT '投资总金额',
     `investment_money_pay` decimal(20,6) DEFAULT '0.000000' COMMENT '投资需支付余额',
     `investment_lsjf_pay` decimal(20,6) DEFAULT '0.000000' COMMENT '投资需支付绿色积分',
     `investment_reward_ratio` decimal(10,2) DEFAULT '0.00' COMMENT '投资打赏比例',
     `investment_xfz_mul` decimal(10,2) DEFAULT '0.00' COMMENT '投资奖励消费值倍数',
     `investment_xfz_par_mul` decimal(10,2) DEFAULT '0.00' COMMENT '投资上级奖励消费值倍数',
     `investment_xfz_merchant_mul` decimal(10,2) DEFAULT '0.00' COMMENT '投资商家获得消费值倍数',
     `investment_earnings_months` decimal(30,1) DEFAULT '6.0' COMMENT '投资收益开始月数',
     `investment_pay_status` int DEFAULT '0' COMMENT '投资支付状态 0-未支付 1-支付 2-已取消',
     `investment_pay_time` datetime DEFAULT NULL COMMENT '投资支付时间',
     `is_pay` int DEFAULT '1' COMMENT '是否是购买的 0-不是 1-是',
     `investment_push_reward` int DEFAULT '0' COMMENT '投资直推奖发放状态 0-未发放 1-发放',
     `investment_team_reward` int DEFAULT '0' COMMENT '投资团队奖发放状态 0-未发放 1-发放',
     `del_flag` int DEFAULT '0' COMMENT '软删除 0-未删除 1-删除',
     `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
     `update_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
     `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
     `tuiguang_flag` int DEFAULT '0' COMMENT '推广商奖励发放状态0未发放 1已发放',
     PRIMARY KEY (`investment_code`) USING BTREE
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='投资记录表'


2-会员升级记录  rank_change_info

      CREATE TABLE `rank_change_info` (
        `id` bigint NOT NULL AUTO_INCREMENT,
        `user_id` bigint DEFAULT NULL,
        `username` varchar(255) DEFAULT NULL,
        `grade` int DEFAULT NULL COMMENT '级别1-5级',
        `grade_old` int DEFAULT NULL COMMENT '级别1-5级',
        `grade_name` varchar(255) DEFAULT NULL COMMENT '级别名称',
        `grade_name_old` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '级别名称',
        `create_time` datetime DEFAULT NULL,
        `update_time` datetime DEFAULT NULL,
        `status` int DEFAULT NULL COMMENT '级别状态0失效(级别被出掉或者级别升高了之前的级别弃用了)1-有效状态',
        `remark` varchar(255) DEFAULT NULL,
        PRIMARY KEY (`id`) USING BTREE
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3

3-会员业绩表    team_achievements
   CREATE TABLE `team_achievements` (
     `id` bigint NOT NULL,
     `ac_amount` decimal(30,2) DEFAULT NULL,
     `type` int DEFAULT NULL COMMENT '业绩类型1辣椒业绩',
     `ac_name` varchar(255) DEFAULT NULL COMMENT '业绩名称',
     PRIMARY KEY (`id`)
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3


4-辣椒  身份表  为防止  后添加数据 导致查询不到
UPDATE  user_identity   set  tuiguang=0 ,tuiguang_level=0 WHERE  tuiguang is  NULL  Or  tuiguang_level is  null;



5-推广商  先分钱的账户   11054722  username 7011781



6-辣椒业绩

添加字典