230410.sql 666 B

12345678910111213141516
  1. create table zhongzhi_input_record
  2. (
  3. id int auto_increment comment '主键id'
  4. primary key,
  5. req_type varchar(20) not null comment '请求业务类型',
  6. order_no varchar(64) null comment '三方订单号',
  7. req_body text null comment '请求body',
  8. create_time datetime default CURRENT_TIMESTAMP null comment '创建时间'
  9. )
  10. comment '中智回调异步通知记录';
  11. alter table sys_user
  12. add bank_name varchar(32) null comment '开户行';
  13. alter table sys_user_sub
  14. add bank_name varchar(64) null comment '开户行' after bank_phone;