#87055fe_users table sets "identifier" as primary key, instead of "uid"
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.