mirror of
https://github.com/chylex/Lightning-Tracker.git
synced 2024-11-24 22:42:50 +01:00
19 lines
670 B
SQL
19 lines
670 B
SQL
CREATE TABLE IF NOT EXISTS `users` (
|
|
`id` INT NOT NULL AUTO_INCREMENT,
|
|
`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,
|
|
`admin` BOOL NOT NULL DEFAULT FALSE,
|
|
`date_registered` DATETIME NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `name` (`name`),
|
|
UNIQUE KEY `email` (`email`),
|
|
FOREIGN KEY (`role_id`)
|
|
REFERENCES `system_roles` (`id`)
|
|
ON UPDATE CASCADE
|
|
ON DELETE SET NULL
|
|
) ENGINE = InnoDB
|
|
DEFAULT CHARSET = utf8mb4
|
|
COLLATE utf8mb4_general_ci
|