23 lines
655 B
SQL
23 lines
655 B
SQL
CREATE TABLE `auth_user` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`password` VARCHAR(128) NOT NULL,
|
|
`last_login` DATETIME(6) DEFAULT NULL,
|
|
`is_superuser` TINYINT(1) NOT NULL,
|
|
`username` VARCHAR(150) NOT NULL,
|
|
`first_name` VARCHAR(150) NOT NULL,
|
|
`last_name` VARCHAR(150) NOT NULL,
|
|
`email` VARCHAR(254) NOT NULL,
|
|
`is_staff` TINYINT(1) NOT NULL,
|
|
`is_active` TINYINT(1) NOT NULL,
|
|
`date_joined` DATETIME(6) NOT NULL,
|
|
PRIMARY KEY (id)
|
|
)
|
|
ENGINE = INNODB,
|
|
AUTO_INCREMENT = 20,
|
|
AVG_ROW_LENGTH = 4096,
|
|
CHARACTER SET utf8mb4,
|
|
COLLATE utf8mb4_general_ci,
|
|
ROW_FORMAT = DYNAMIC;
|
|
|
|
ALTER TABLE `auth_user`
|
|
ADD UNIQUE INDEX username(username); |