19 lines
866 B
SQL
19 lines
866 B
SQL
CREATE TABLE IF NOT EXISTS `supplied_user` (
|
|
`id` INT NOT NULL AUTO_INCREMENT,
|
|
`username` VARCHAR(64) NULL,
|
|
`virtualId` VARCHAR(191) COLLATE utf8mb4_bin NULL,
|
|
`passwordHash` VARCHAR(255) NULL,
|
|
`nickname` VARCHAR(64) NOT NULL DEFAULT '管理员',
|
|
`enabled` BOOLEAN NOT NULL DEFAULT TRUE,
|
|
`tokenHash` CHAR(64) NULL,
|
|
`tokenExpiresAt` DATETIME(3) NULL,
|
|
`failedLoginCount` INT NOT NULL DEFAULT 0,
|
|
`lockedUntil` DATETIME(3) NULL,
|
|
`createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
|
|
`updatedAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `supplied_user_username_key` (`username`),
|
|
UNIQUE KEY `supplied_user_virtualId_key` (`virtualId`),
|
|
UNIQUE KEY `supplied_user_tokenHash_key` (`tokenHash`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|