GitLab

mysql变更格式

数据库：ucs

表名：tb_admin_for_user_note

sql

-- auto-generated definition
create table tb_admin_for_user_note
(
  id             int auto_increment
    primary key,
  pid            int                                 not null
  comment '档案提单id',
  note           varchar(255)                        null
  comment '备注内容',
  note_img_path  varchar(255)                        null
  comment '备注图片',
  status         tinyint(1) default '1'              not null
  comment '状态：1代表有效2代表无效',
  operation      varchar(255)                        null,
  add_time       timestamp default CURRENT_TIMESTAMP not null,
  lastupdatetime timestamp default CURRENT_TIMESTAMP not null
  on update CURRENT_TIMESTAMP
);

create index ix_pid
  on tb_admin_for_user_note (pid);