Issue Bug Closed

#87055fe_users table sets "identifier" as primary key, instead of "uid"

Armin Vieweg 12/02/18, 22:24 updated 12/05/18, 23:37

Description

This is what my TYPO3 want to create in Database Compare:

CREATE TABLE fe_users 
             ( 
                          `identifier` varchar(85) DEFAULT '' NOT NULL, 
                          pid          int unsigned DEFAULT 0 NOT NULL, 
                          `tstamp`     int unsigned DEFAULT 0 NOT NULL, 
                          `cruser_id`  int unsigned DEFAULT 0 NOT NULL, 
                          `deleted`    smallint unsigned DEFAULT 0 NOT NULL, 
                          `disable`    smallint unsigned DEFAULT 0 NOT NULL, 
                          `starttime`  int unsigned DEFAULT 0 NOT NULL, 
                          `endtime`    int unsigned DEFAULT 0 NOT NULL, 
                          `description` text DEFAULT NULL, 
                          `tx_extbase_type` varchar(255) DEFAULT '0' NOT NULL, 
                          `username`        varchar(255) DEFAULT '' NOT NULL, 
                          `password`        varchar(100) DEFAULT '' NOT NULL, 
                          `usergroup` tinytext DEFAULT NULL, 
                          `NAME`         varchar(160) DEFAULT '' NOT NULL, 
                          `first_name`   varchar(50) DEFAULT '' NOT NULL, 
                          `middle_name`  varchar(50) DEFAULT '' NOT NULL, 
                          `last_name`    varchar(50) DEFAULT '' NOT NULL, 
                          `address`      varchar(255) DEFAULT '' NOT NULL, 
                          `telephone`    varchar(30) DEFAULT '' NOT NULL, 
                          `fax`          varchar(30) DEFAULT '' NOT NULL, 
                          `email`        varchar(255) DEFAULT '' NOT NULL, 
                          `locktodomain` varchar(50) DEFAULT '' NOT NULL, 
                          `uc` blob DEFAULT NULL, 
                          `title`   varchar(40) DEFAULT '' NOT NULL, 
                          `zip`     varchar(10) DEFAULT '' NOT NULL, 
                          `city`    varchar(50) DEFAULT '' NOT NULL, 
                          `country` varchar(40) DEFAULT '' NOT NULL, 
                          `www`     varchar(80) DEFAULT '' NOT NULL, 
                          `company` varchar(80) DEFAULT '' NOT NULL, 
                          `image` tinytext DEFAULT NULL, 
                          `tsconfig` text DEFAULT NULL, 
                          `lastlogin` int unsigned DEFAULT 0 NOT NULL, 
                          `is_online` int unsigned DEFAULT 0 NOT NULL, 
                          `felogin_redirectpid` tinytext DEFAULT NULL, 
                          `felogin_forgothash` varchar(80) DEFAULT '', 
                          `uid`                int DEFAULT 0 NOT NULL, 
                          `crdate`             int DEFAULT 0 NOT NULL, 
                          `TABLE`              varchar(255) DEFAULT '' NOT NULL, 
                          INDEX `parent` (pid, username(100)), 
                          INDEX `username` (username(100)), 
                          INDEX `is_online` (is_online), 
                          PRIMARY KEY(identifier) 
             ) 
             DEFAULT character 
SETSET utf8mb4 COLLATE utf8mb4_unicode_ci engine = innodb
PRIMARY KEY(identifier)

This causes errors in backend. Tested with TYPO3 9.5.1.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.