75 lines
4.4 KiB
Plaintext
75 lines
4.4 KiB
Plaintext
推广商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-辣椒业绩
|
||
|
||
添加字典
|