update interface_info set api_comment = '' where api_comment is null;
update interface_info set api_schema = '{}' where api_schema is null;
update interface_info set api_sample = '{}' where api_sample is null;
update interface_info set api_option = '{}' where api_option is null;
update interface_info set api_create_time = now() where api_create_time is null;
update interface_info set api_gmt_time = now() where api_gmt_time is null;
update interface_release set pub_script = '' where pub_script is null;
update interface_release set pub_script_ori = '' where pub_script_ori is null;
update interface_release set pub_schema = '{}' where pub_schema is null;
update interface_release set pub_sample = '{}' where pub_sample is null;
update interface_release set pub_option = '{}' where pub_option is null;
update interface_release set pub_release_time = now() where pub_release_time is null;
alter table interface_info
modify api_id varchar(64) not null comment 'ID';
alter table interface_info
modify api_status varchar(4) not null comment '状态:0,1,2,3';
alter table interface_info
modify api_comment varchar(255) not null comment '注释';
alter table interface_info
modify api_schema mediumtext not null comment '接口的请求/响应数据结构';
alter table interface_info
modify api_sample mediumtext not null comment '请求/响应/请求头样本数据';
alter table interface_info
modify api_option mediumtext not null comment '扩展配置信息';
alter table interface_info
modify api_create_time varchar(32) not null comment '创建时间';
alter table interface_info
modify api_gmt_time varchar(32) not null comment '修改时间';
alter table interface_release
modify pub_id varchar(64) not null comment 'Publish ID';
alter table interface_release
modify pub_api_id varchar(64) not null comment '所属API ID';
alter table interface_release
modify pub_status varchar(4) not null comment '状态:0有效,1无效(可能被下线)';
alter table interface_release
modify pub_script mediumtext not null comment '查询脚本:xxxxxxx';
alter table interface_release
modify pub_script_ori mediumtext not null comment '原始查询脚本,仅当类型为SQL时不同';
alter table interface_release
modify pub_schema mediumtext not null comment '接口的请求/响应数据结构';
alter table interface_release
modify pub_sample mediumtext not null comment '请求/响应/请求头样本数据';
alter table interface_release
modify pub_option mediumtext not null comment '扩展配置信息';
alter table interface_release
modify pub_release_time varchar(32) not null comment '发布时间(下线不更新)';
alter table interface_release
add pub_comment varchar(255) default '' not null comment '备注';
alter table interface_release
modify pub_comment varchar(255) not null comment '备注';
alter table interface_info drop key idx_interface_info;
alter table interface_info
add constraint idx_interface_info
unique (api_path);
create index idx_interface_release_path
on interface_release (pub_path);
update interface_info set
api_create_time = UNIX_TIMESTAMP(STR_TO_DATE(api_create_time, '%Y-%m-%d %H:%i:%s')) * 1000,
api_gmt_time = UNIX_TIMESTAMP(STR_TO_DATE(api_gmt_time, '%Y-%m-%d %H:%i:%s')) * 1000;
update interface_release set
pub_release_time = UNIX_TIMESTAMP(STR_TO_DATE(pub_release_time, '%Y-%m-%d %H:%i:%s')) * 1000;