ALTER TABLE table_info add user_type INT default 0 COMMENT "用户类型";
CREATE TABLE `表名` (
`id` bigint NOT NULL COMMENT '主键',
`user_id` bigint NOT NULL COMMENT '用户id',
`account_type` INT DEFAULT NULL COMMENT '账户类型(0:普通,1:冻结)',
`balance` decimal(16,4) DEFAULT NULL COMMENT '账户余额',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='佣金管理表';
CREATE TABLE `表名` (
`id` bigint NOT NULL COMMENT '主键',
`user_id` bigint NOT NULL COMMENT '用户id',
`account_type` INT DEFAULT NULL COMMENT '账户类型(0:普通,1:冻结)',
`order_id` bigint DEFAULT NULL COMMENT '订单Id',
`change_type` INT DEFAULT NULL COMMENT '变动类型 1: 解冻 2: 冻结 3: 取现',
`change_money` decimal(16,4) DEFAULT NULL COMMENT '本次变动金额',
`change_before_money` decimal(16,4) DEFAULT NULL COMMENT '变动前金额',
`change_after_money` decimal(16,4) DEFAULT NULL COMMENT '变动后金额',
`reason` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='佣金明细表';