Project

General

Profile

Actions
Copy link

Bug #87055

closed

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

Added by Armin Vieweg over 5 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2018-12-02
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
9
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

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.

Actions
Copy link

Also available in: Atom PDF