CREATE DATABASE `saas_auth` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
use `saas_auth`;

create table `au_authorize_log` (
  id int unsigned primary key not null auto_increment,
  app_id varchar(30) comment '应用',
  account_id int unsigned not null comment '账号',
  client_ip varchar(100) comment '客户端IP',
  user_agent varchar(300) comment 'User Agent',
  login_time datetime comment '登录时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='登录日志';

create table `au_virtual_authorize_log` (
  id int unsigned primary key not null auto_increment,
  app_id varchar(30) comment '应用',
  mobile varchar(20) not null comment '手机号',
  client_ip varchar(100) comment '客户端IP',
  user_agent varchar(300) comment 'User Agent',
  login_time datetime comment '登录时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='登录日志';