mirror of
https://github.com/chylex/Lightning-Tracker.git
synced 2024-09-19 01:42:49 +02:00
14 lines
459 B
SQL
14 lines
459 B
SQL
CREATE TABLE IF NOT EXISTS `user_logins` (
|
|
`id` CHAR(9) NOT NULL,
|
|
`token` VARCHAR(191) NOT NULL, # Size limit needed due to low key size limits in older versions of MySQL.
|
|
`expires` DATETIME NOT NULL,
|
|
PRIMARY KEY (`id`, `token`),
|
|
UNIQUE KEY (`token`),
|
|
CONSTRAINT fk__user_login__user FOREIGN KEY (`id`)
|
|
REFERENCES `users` (`id`)
|
|
ON UPDATE CASCADE
|
|
ON DELETE CASCADE
|
|
) ENGINE = InnoDB
|
|
DEFAULT CHARSET = utf8mb4
|
|
COLLATE utf8mb4_general_ci
|