# out-authenticator

**Repository Path**: rollback/out-authenticator

## Basic Information

- **Project Name**: out-authenticator
- **Description**: 单点登陆解决方案
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-05-05
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# out-authenticator
## 1 建表语句
```sql
create table userContext (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
    `login_name` varchar(31) COMMENT '用户登陆名称',
    `password` varchar(255) NOT NULL COMMENT '密码',
    `nick_name` varchar(31) COMMENT '昵称',
    `avatar` varchar(123) COMMENT '头像地址',
    `mobile` varchar(123) COMMENT '手机号',
    `mail` varchar(123) COMMENT '邮箱',
    `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    PRIMARY KEY (`id`),
    UNIQUE KEY `unique_key_login_name` (`login_name`)
)  ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户信息表';
private long id;

create table user_login_history (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
    `user_id` bigint(20) NOT NULL COMMENT '用户ID',
    `style` varchar(31) NOT NULL COMMENT '登陆方式',
    `device` varchar(123) COMMENT '设备信息',
    `session` varchar(123) COMMENT 'session',
    `cookie` varchar(123) COMMENT 'cookie',
    `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    PRIMARY KEY (`id`),
    UNIQUE KEY `unique_key_userId` (`user_id`)
)  ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户登陆历史数据';

CREATE TABLE `session` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `session` varchar(124) DEFAULT NULL COMMENT 'session',
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `status` tinyint(2) DEFAULT NULL COMMENT '登陆状态',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_session` (`session`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='sessiond登陆管理';
```