GitLab

mysql变更格式

数据库：wiki

表名：tb_open_link_analysis

-- auto-generated definition
create table tb_open_link_analysis
(
  id                  int auto_increment
    primary key,
  company_name_digest varchar(32) default ''              not null
  comment 'digest',
  company_name        varchar(255) default ''             not null
  comment '公司名',
  agent_name          varchar(255) default ''             not null
  comment '代理商名',
  pv                  int default '0'                     null
  comment '统计pv',
  uv                  int default '0'                     null
  comment '统计uv',
  level               int(10)                             null
  comment '版本',
  status              tinyint(1) default '1'              null
  comment '状态，默认1',
  operator            varchar(255) default ''             not null
  comment '操作者',
  create_time         datetime default CURRENT_TIMESTAMP  not null,
  last_update_time    timestamp default CURRENT_TIMESTAMP not null
  on update CURRENT_TIMESTAMP
)
  comment '外链信息收集表';

create index tb_open_link_analysis_agent
  on tb_open_link_analysis (agent_name);

create index tb_open_link_analysis_cname
  on tb_open_link_analysis (company_name);

create index tb_open_link_analysis_digest
  on tb_open_link_analysis (company_name_digest);