structure

SET FOREIGN_KEY_CHECKS=0;

ALTER TABLE avatar_0916_2.ai_article ADD COLUMN type tinyint(4) NOT NULL DEFAULT 1 COMMENT '教程类型:1-文章,2-视频' AFTER cid;

ALTER TABLE avatar_0916_2.ai_article ADD COLUMN cost text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '消耗算力' AFTER desc;

ALTER TABLE avatar_0916_2.ai_article ADD COLUMN video_url varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '视频地址' AFTER author;

CREATE TABLE avatar_0916_2.ai_article_order (
id int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
tenant_id int(11) NOT NULL DEFAULT 0 COMMENT '租户ID',
article_id int(11) NOT NULL DEFAULT 0 COMMENT '教程ID',
user_id int(11) NOT NULL DEFAULT 0 COMMENT '下单用户ID',
order_sn varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '订单编号',
pay_time int(11) NULL DEFAULT NULL COMMENT '支付时间',
cost int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '算力消耗',
remarks varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
create_time int(10) NULL DEFAULT NULL COMMENT '创建时间',
update_time int(10) NULL DEFAULT NULL COMMENT '更新时间',
delete_time int(10) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '教程订单表' ROW_FORMAT = DYNAMIC;

CREATE TABLE avatar_0916_2.ai_distribution_log (
id int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
tenant_id int(11) NOT NULL DEFAULT 0 COMMENT '租户ID',
order_type tinyint(1) NOT NULL DEFAULT 0 COMMENT '订单类型：1-充值订单；2-会员订单；',
user_id int(11) NOT NULL DEFAULT 0 COMMENT '下单用户ID',
order_id int(11) NOT NULL DEFAULT 0 COMMENT '订单ID',
order_sn varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '订单编号',
pay_time int(11) NULL DEFAULT NULL COMMENT '支付时间',
origin_amount decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '订单金额',
order_amount decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '实付金额',
reward_user_id int(11) NOT NULL DEFAULT 0 COMMENT '分销用户ID',
level_id int(11) NOT NULL DEFAULT 0 COMMENT '分销用户等级',
rebate_config text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '分销配置',
ratio_type varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '分销佣金类型',
ratio decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '分销佣金比例',
reward decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '分销奖励',
remarks varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
create_time int(10) NULL DEFAULT NULL COMMENT '创建时间',
update_time int(10) NULL DEFAULT NULL COMMENT '更新时间',
delete_time int(10) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '分销记录表' ROW_FORMAT = DYNAMIC;

CREATE TABLE avatar_0916_2.ai_power_exchange_log (
id int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
tenant_id int(11) NOT NULL DEFAULT 0 COMMENT '租户ID',
user_id int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
order_sn varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '订单编号',
type varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '兑换类型',
count int(11) NOT NULL DEFAULT 0 COMMENT '兑换数量',
cost int(11) NOT NULL DEFAULT 0 COMMENT '单价',
total_cost int(11) NOT NULL DEFAULT 0 COMMENT '总价',
exchange_config text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '兑换配置',
remarks varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
create_time int(10) NULL DEFAULT NULL COMMENT '创建时间',
update_time int(10) NULL DEFAULT NULL COMMENT '更新时间',
delete_time int(10) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '资产兑换记录表' ROW_FORMAT = DYNAMIC;

ALTER TABLE avatar_0916_2.ai_recharge_order ADD COLUMN origin_amount decimal(10, 2) NOT NULL COMMENT '订单金额' AFTER pay_time;

ALTER TABLE avatar_0916_2.ai_recharge_order ADD COLUMN order_remarks text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '订单备注' AFTER refund_transaction_id;

ALTER TABLE avatar_0916_2.ai_tenant ADD COLUMN team_distribution_status tinyint(4) NOT NULL DEFAULT 0 COMMENT '团队分销:1-启用,0-禁用' AFTER domain_alias_enable;

ALTER TABLE avatar_0916_2.ai_tenant_agent ADD COLUMN background varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '背景' AFTER logo;

ALTER TABLE avatar_0916_2.ai_tenant_power_package ADD COLUMN level_price text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '会员折扣价' AFTER benefits;

ALTER TABLE avatar_0916_2.ai_tenant_video ADD COLUMN clone_type tinyint(4) NOT NULL DEFAULT 1 COMMENT '克隆类型:1-普通,2-专业(数字人混剪)' AFTER uid;

ALTER TABLE avatar_0916_2.ai_tenant_video ADD COLUMN mix_file_list text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '专业数字人素材' AFTER file_id;

ALTER TABLE avatar_0916_2.ai_tenant_video ADD COLUMN mix_job_id varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '专业数字人混剪任务ID' AFTER terminal;

ALTER TABLE avatar_0916_2.ai_tenant_video ADD COLUMN mix_job_status tinyint(4) NOT NULL DEFAULT 0 COMMENT '专业数字人混剪任务状态:0-待处理,1-处理中,2-处理完成,3-处理失败' AFTER mix_job_id;

ALTER TABLE avatar_0916_2.ai_tenant_video ADD COLUMN mix_job_remark varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '专业数字人混剪任务状态说明' AFTER mix_job_status;

ALTER TABLE avatar_0916_2.ai_user ADD COLUMN level_id int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '会员等级ID' AFTER vip_expire;

ALTER TABLE avatar_0916_2.ai_user ADD COLUMN level_path text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '会员等级路径' AFTER level_id;

ALTER TABLE avatar_0916_2.ai_user ADD COLUMN wechat varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '微信号' AFTER level_path;

ALTER TABLE avatar_0916_2.ai_user ADD COLUMN wechat_code varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '微信号' AFTER wechat;

ALTER TABLE avatar_0916_2.ai_user ADD COLUMN contact_mobile varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '联系手机号' AFTER wechat_code;

CREATE TABLE avatar_0916_2.ai_user_level (
id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
tenant_id int(11) NULL DEFAULT NULL COMMENT '租户ID',
title varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '标题',
level int(11) NOT NULL DEFAULT 0 COMMENT '会员等级',
level_type tinyint(4) NOT NULL DEFAULT 1 COMMENT '等级类型:1-普通,2-团长',
desc varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '描述',
logo varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'logo',
icon varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'icon',
status tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态:1-启用,0-禁用',
upgrade_config text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '升级条件',
rebate_config text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '返佣配置',
right_config text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '权益配置',
create_time int(11) NULL DEFAULT NULL,
update_time int(11) NULL DEFAULT NULL,
delete_time int(11) NULL DEFAULT NULL,
PRIMARY KEY (id) USING BTREE,
INDEX level(level) USING BTREE,
INDEX level_type(level_type) USING BTREE,
INDEX status(status) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员等级表' ROW_FORMAT = DYNAMIC;

CREATE TABLE avatar_0916_2.ai_user_upgrade_log (
id int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
tenant_id int(11) NOT NULL DEFAULT 0 COMMENT '租户ID',
user_id int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
old_level_id int(11) NOT NULL DEFAULT 0 COMMENT '等级ID',
new_level_id int(11) NOT NULL DEFAULT 0 COMMENT '等级ID',
direct_count int(11) NOT NULL DEFAULT 0 COMMENT '直推人数',
commission decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '累计佣金',
upgrade_config text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '升级条件',
create_time int(11) NULL DEFAULT NULL,
update_time int(11) NULL DEFAULT NULL,
delete_time int(11) NULL DEFAULT NULL,
PRIMARY KEY (id) USING BTREE,
INDEX tenant_id(tenant_id) USING BTREE,
INDEX user_id(user_id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员升级记录表' ROW_FORMAT = DYNAMIC;

SET FOREIGN_KEY_CHECKS=1;