# 1 im权限表 ~~~ create table im_app_auth ( id int auto_increment, app_id varchar(45) not null comment 'app_id', app_secret varchar(99) not null, add_time int not null, is_deleted tinyint(1) default 0 null, constraint im_app_auth_pk primary key (id) ) comment 'webim权限认证'; create unique index im_app_auth_app_id_uindex on im_app_auth (app_id); ~~~