TYPO3 Core

Bug #87055

Updated by Georg Ringer over 5 years ago

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

 <pre> 
 CREATE TABLE fe_users  
              (  
                           `identifier` varchar(85) (`identifier` VARCHAR(85) DEFAULT '' NOT NULL,  
                           pid            int unsigned INT UNSIGNED DEFAULT 0 NOT NULL,  
                           `tstamp`       int unsigned INT UNSIGNED DEFAULT 0 NOT NULL,  
                           `cruser_id`    int unsigned INT UNSIGNED DEFAULT 0 NOT NULL,  
                           `deleted`      smallint unsigned SMALLINT UNSIGNED DEFAULT 0 NOT NULL,  
                           `disable`      smallint unsigned SMALLINT UNSIGNED DEFAULT 0 NOT NULL,  
                           `starttime`    int unsigned INT UNSIGNED DEFAULT 0 NOT NULL,  
                           `endtime`      int unsigned INT UNSIGNED DEFAULT 0 NOT NULL,  
                           `description` text TEXT DEFAULT NULL,  
                           `tx_extbase_type` varchar(255) VARCHAR(255) DEFAULT '0' NOT NULL,  
                           `username`          varchar(255) VARCHAR(255) DEFAULT '' NOT NULL,  
                           `password`          varchar(100) VARCHAR(100) DEFAULT '' NOT NULL,  
                           `usergroup` tinytext TINYTEXT DEFAULT NULL,  
                           `NAME`           varchar(160) `name` VARCHAR(160) DEFAULT '' NOT NULL,  
                           `first_name`     varchar(50) VARCHAR(50) DEFAULT '' NOT NULL,  
                           `middle_name`    varchar(50) VARCHAR(50) DEFAULT '' NOT NULL,  
                           `last_name`      varchar(50) VARCHAR(50) DEFAULT '' NOT NULL,  
                           `address`        varchar(255) VARCHAR(255) DEFAULT '' NOT NULL,  
                           `telephone`      varchar(30) VARCHAR(30) DEFAULT '' NOT NULL,  
                           `fax`            varchar(30) VARCHAR(30) DEFAULT '' NOT NULL,  
                           `email`          varchar(255) VARCHAR(255) DEFAULT '' NOT NULL,  
                           `locktodomain` varchar(50) `lockToDomain` VARCHAR(50) DEFAULT '' NOT NULL,  
                           `uc` blob BLOB DEFAULT NULL,  
                           `title`     varchar(40) VARCHAR(40) DEFAULT '' NOT NULL,  
                           `zip`       varchar(10) VARCHAR(10) DEFAULT '' NOT NULL,  
                           `city`      varchar(50) VARCHAR(50) DEFAULT '' NOT NULL,  
                           `country` varchar(40) VARCHAR(40) DEFAULT '' NOT NULL,  
                           `www`       varchar(80) VARCHAR(80) DEFAULT '' NOT NULL,  
                           `company` varchar(80) VARCHAR(80) DEFAULT '' NOT NULL,  
                           `image` tinytext TINYTEXT DEFAULT NULL,  
                           `tsconfig` text `TSconfig` TEXT DEFAULT NULL,  
                           `lastlogin` int unsigned INT UNSIGNED DEFAULT 0 NOT NULL,  
                           `is_online` int unsigned INT UNSIGNED DEFAULT 0 NOT NULL,  
                           `felogin_redirectpid` tinytext `felogin_redirectPid` TINYTEXT DEFAULT NULL,  
                           `felogin_forgothash` varchar(80) `felogin_forgotHash` VARCHAR(80) DEFAULT '',  
                           `uid`                  int INT DEFAULT 0 NOT NULL,  
                           `crdate`               int INT DEFAULT 0 NOT NULL,  
                           `TABLE`                varchar(255) `table` VARCHAR(255) DEFAULT '' NOT NULL,  
                           INDEX `parent` (pid, username(100)),  
                           INDEX `username` (username(100)),  
                           INDEX `is_online` (is_online),  
                           PRIMARY KEY(identifier)  
              )  
              KEY(identifier)) DEFAULT character  
 SETSET CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci engine ENGINE = innodb InnoDB 
 </pre> 

 <pre>PRIMARY KEY(identifier)</pre> 

 This causes errors in backend. Tested with TYPO3 9.5.1.

Back