mirror of
https://github.com/chylex/Lightning-Tracker.git
synced 2024-10-17 01:42:46 +02:00
18 lines
637 B
SQL
18 lines
637 B
SQL
CREATE TABLE IF NOT EXISTS `users` (
|
|
`id` CHAR(9) NOT NULL,
|
|
`name` VARCHAR(32) NOT NULL,
|
|
`email` VARCHAR(191) NOT NULL, # Size limit needed due to low key size limits in older versions of MySQL.
|
|
`password` VARCHAR(255) NOT NULL,
|
|
`role_id` SMALLINT DEFAULT NULL,
|
|
`date_registered` DATETIME NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `name` (`name`),
|
|
UNIQUE KEY `email` (`email`),
|
|
CONSTRAINT fk__user__role FOREIGN KEY (`role_id`)
|
|
REFERENCES `system_roles` (`id`)
|
|
ON UPDATE CASCADE
|
|
ON DELETE SET NULL
|
|
) ENGINE = InnoDB
|
|
DEFAULT CHARSET = utf8mb4
|
|
COLLATE utf8mb4_general_ci
|