in /var/www/html/vendor/typo3/cms-core/Classes/Database/Schema/SchemaMigrator.php
line 323
$currentTableDefinition = $return[$tableName];
$return[$tableName] = new Table(
$tableName,
$this->mergeColumns(...$currentTableDefinition->getColumns(), ...$table->getColumns()),
$this->mergeIndexes(...$currentTableDefinition->getIndexes(), ...$table->getIndexes()),
[],
array_merge($currentTableDefinition->getForeignKeys(), $table->getForeignKeys()),
array_merge($currentTableDefinition->getOptions(), $table->getOptions())
);
at TYPO3\CMS\Core\Database\Schema\SchemaMigrator
->
mergeTableDefinitions
(
array
(object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table), object
(Doctrine\DBAL\Schema\Table))
)
in /var/www/html/vendor/typo3/cms-core/Classes/Database/Schema/SchemaMigrator.php
line 217
protected function parseCreateTableStatements(array $statements): array
{
$tables = $this->prepareTablesFromStatements($statements);
$tables = $this->ensureTableDefinitionForAllTCAManagedTables($tables);
$tables = $this->mergeTableDefinitions($tables);
$tables = $this->enrichTablesFromDefaultTCASchema($tables);
$tables = $this->ensureDefaultTCAFieldsAreOrdered($tables);
return $tables;
}
at TYPO3\CMS\Core\Database\Schema\SchemaMigrator
->
parseCreateTableStatements
(
array
('CREATE TABLE be_sessions ( ses_id varchar(190) DEFAULT \'\' NOT NULL, ses_iplock varchar(39) DEFAULT \'\' NOT NULL, ses_userid int(11) unsigned DEFAULT \'0\' NOT NULL, ses_tstamp int(11) unsigned DEFAULT \'0\' NOT NULL, ses_data longblob, PRIMARY KEY (ses_id), KEY ses_tstamp (ses_tstamp) );', 'CREATE TABLE be_users ( lang varchar(10) DEFAULT \'default\' NOT NULL, uc mediumblob, workspace_id int(11) DEFAULT \'0\' NOT NULL, mfa mediumblob, KEY username (username) );', 'CREATE TABLE be_groups( tables_select longtext );', 'CREATE TABLE pages ( perms_userid int(11) unsigned DEFAULT \'0\' NOT NULL, perms_groupid int(11) unsigned DEFAULT \'0\' NOT NULL, perms_user tinyint(4) unsigned DEFAULT \'0\' NOT NULL, perms_group tinyint(4) unsigned DEFAULT \'0\' NOT NULL, perms_everybody tinyint(4) unsigned DEFAULT \'0\' NOT NULL, SYS_LASTCHANGED int(10) unsigned DEFAULT \'0\' NOT NULL, shortcut int(10) unsigned DEFAULT \'0\' NOT NULL, content_from_pid int(10) unsigned DEFAULT \'0\' NOT NULL, mount_pid int(10) unsigned DEFAULT \'0\' NOT NULL, KEY determineSiteRoot (is_siteroot), KEY language_identifier (l10n_parent,sys_language_uid), KEY slug (slug(127)) );', 'CREATE TABLE sys_registry ( uid int(11) unsigned NOT NULL auto_increment, entry_namespace varchar(128) DEFAULT \'\' NOT NULL, entry_key varchar(128) DEFAULT \'\' NOT NULL, entry_value mediumblob, PRIMARY KEY (uid), UNIQUE KEY entry_identifier (entry_namespace,entry_key) );', 'CREATE TABLE sys_be_shortcuts ( uid int(11) unsigned NOT NULL auto_increment, userid int(11) unsigned DEFAULT \'0\' NOT NULL, route varchar(255) DEFAULT \'\' NOT NULL, arguments text, description varchar(255) DEFAULT \'\' NOT NULL, sorting int(11) DEFAULT \'0\' NOT NULL, sc_group tinyint(4) DEFAULT \'0\' NOT NULL, PRIMARY KEY (uid), KEY event (userid) );', 'CREATE TABLE sys_file_storage ( is_public tinyint(4) DEFAULT \'0\' NOT NULL, processingfolder tinytext );', 'CREATE TABLE sys_file ( last_indexed int(11) DEFAULT \'0\' NOT NULL, identifier text, identifier_hash char(40) DEFAULT \'\' NOT NULL, folder_hash char(40) DEFAULT \'\' NOT NULL, extension varchar(255) DEFAULT \'\' NOT NULL, name tinytext, sha1 char(40) DEFAULT \'\' NOT NULL, creation_date int(11) DEFAULT \'0\' NOT NULL, modification_date int(11) DEFAULT \'0\' NOT NULL, KEY sel01 (storage,identifier_hash), KEY folder (storage,folder_hash), KEY tstamp (tstamp), KEY lastindex (last_indexed), KEY sha1 (sha1) );', 'CREATE TABLE sys_file_metadata ( title tinytext, alternative text, KEY file (file), KEY fal_filelist (l10n_parent,sys_language_uid) );', 'CREATE TABLE sys_file_processedfile ( uid int(11) NOT NULL auto_increment, tstamp int(11) DEFAULT \'0\' NOT NULL, crdate int(11) DEFAULT \'0\' NOT NULL, storage int(11) DEFAULT \'0\' NOT NULL, original int(11) DEFAULT \'0\' NOT NULL, identifier varchar(512) DEFAULT \'\' NOT NULL, name tinytext, processing_url text, configuration blob, configurationsha1 char(40) DEFAULT \'\' NOT NULL, originalfilesha1 char(40) DEFAULT \'\' NOT NULL, task_type varchar(200) DEFAULT \'\' NOT NULL, checksum char(32) DEFAULT \'\' NOT NULL, width int(11) DEFAULT \'0\', height int(11) DEFAULT \'0\', PRIMARY KEY (uid), KEY combined_1 (original,task_type(100),configurationsha1), KEY identifier (storage,identifier(180)) );', 'CREATE TABLE sys_file_reference ( uid_local int(11) DEFAULT \'0\' NOT NULL, title tinytext, alternative text, KEY tablenames_fieldname (tablenames(32),fieldname(12)), KEY deleted (deleted), KEY uid_local (uid_local), KEY uid_foreign (uid_foreign), KEY combined_1 (l10n_parent, t3ver_oid, t3ver_wsid, t3ver_state, deleted) );', 'CREATE TABLE sys_file_collection ( title tinytext, type varchar(30) DEFAULT \'static\' NOT NULL, );', 'CREATE TABLE sys_history ( uid int(11) unsigned NOT NULL auto_increment, tstamp int(11) unsigned DEFAULT \'0\' NOT NULL, actiontype tinyint(3) DEFAULT \'0\' NOT NULL, usertype varchar(2) DEFAULT \'BE\' NOT NULL, userid int(11) unsigned, originaluserid int(11) unsigned, recuid int(11) DEFAULT \'0\' NOT NULL, tablename varchar(255) DEFAULT \'\' NOT NULL, history_data mediumtext, workspace int(11) DEFAULT \'0\', correlation_id varchar(255) DEFAULT \'\' NOT NULL, PRIMARY KEY (uid), KEY recordident_1 (tablename(100),recuid), KEY recordident_2 (tablename(100),tstamp) ) ENGINE=InnoDB;', 'CREATE TABLE sys_lockedrecords ( uid int(11) unsigned NOT NULL auto_increment, userid int(11) unsigned DEFAULT \'0\' NOT NULL, tstamp int(11) unsigned DEFAULT \'0\' NOT NULL, record_table varchar(255) DEFAULT \'\' NOT NULL, record_uid int(11) DEFAULT \'0\' NOT NULL, record_pid int(11) DEFAULT \'0\' NOT NULL, username varchar(50) DEFAULT \'\' NOT NULL, feuserid int(11) unsigned DEFAULT \'0\' NOT NULL, PRIMARY KEY (uid), KEY event (userid,tstamp) );', 'CREATE TABLE sys_refindex ( hash varchar(32) DEFAULT \'\' NOT NULL, tablename varchar(64) DEFAULT \'\' NOT NULL, recuid int unsigned DEFAULT 0 NOT NULL, field varchar(64) DEFAULT \'\' NOT NULL, hidden smallint unsigned DEFAULT 0 NOT NULL, starttime int unsigned DEFAULT 0 NOT NULL, endtime int unsigned DEFAULT 2147483647 NOT NULL, t3ver_state int unsigned DEFAULT 0 NOT NULL, flexpointer varchar(255) DEFAULT \'\' NOT NULL, softref_key varchar(30) DEFAULT \'\' NOT NULL, softref_id varchar(40) DEFAULT \'\' NOT NULL, sorting int DEFAULT 0 NOT NULL, workspace int unsigned DEFAULT 0 NOT NULL, ref_table varchar(64) DEFAULT \'\' NOT NULL, ref_uid int DEFAULT 0 NOT NULL, ref_field varchar(64) DEFAULT \'\' NOT NULL, ref_hidden smallint unsigned DEFAULT 0 NOT NULL, ref_starttime int unsigned DEFAULT 0 NOT NULL, ref_endtime int unsigned DEFAULT 2147483647 NOT NULL, ref_t3ver_state int unsigned DEFAULT 0 NOT NULL, ref_sorting int DEFAULT 0 NOT NULL, ref_string varchar(1024) DEFAULT \'\' NOT NULL, PRIMARY KEY (hash), KEY lookup_rec (tablename,recuid,field,workspace,ref_t3ver_state,ref_hidden,ref_starttime,ref_endtime), KEY lookup_ref (ref_table,ref_uid,tablename,workspace,t3ver_state,hidden,starttime,endtime), );', 'CREATE TABLE sys_log ( uid int(11) unsigned NOT NULL auto_increment, tstamp int(11) unsigned DEFAULT \'0\' NOT NULL, userid int(11) unsigned DEFAULT \'0\' NOT NULL, action tinyint(4) unsigned DEFAULT \'0\' NOT NULL, recuid int(11) unsigned DEFAULT \'0\' NOT NULL, tablename varchar(255) DEFAULT \'\' NOT NULL, recpid int(11) DEFAULT \'0\' NOT NULL, error tinyint(4) unsigned DEFAULT \'0\' NOT NULL, details text, type tinyint(3) unsigned DEFAULT \'0\' NOT NULL, channel varchar(20) DEFAULT \'default\' NOT NULL, details_nr tinyint(3) DEFAULT \'0\' NOT NULL, IP varchar(39) DEFAULT \'\' NOT NULL, log_data text, event_pid int(11) DEFAULT \'-1\' NOT NULL, workspace int(11) DEFAULT \'0\' NOT NULL, NEWid varchar(30) DEFAULT \'\' NOT NULL, request_id varchar(13) DEFAULT \'\' NOT NULL, time_micro float DEFAULT \'0\' NOT NULL, component varchar(255) DEFAULT \'\' NOT NULL, level varchar(10) DEFAULT \'info\' NOT NULL, message text, data text, PRIMARY KEY (uid), KEY event (userid, event_pid), KEY recuidIdx (recuid), KEY user_auth (type, action, tstamp), KEY request (request_id), KEY combined_1 (tstamp, type, userid), KEY errorcount (tstamp, error), KEY index_channel (channel), KEY index_level (level) ) ENGINE=InnoDB;', 'CREATE TABLE sys_category ( items int(11) DEFAULT \'0\' NOT NULL, KEY category_parent (parent), KEY category_list (pid,deleted,sys_language_uid) );', 'CREATE TABLE `sys_messenger_messages` ( id int(11) unsigned NOT NULL auto_increment, body longtext NOT NULL, headers longtext NOT NULL, queue_name varchar(190) NOT NULL, created_at datetime NOT NULL, available_at datetime NOT NULL, delivered_at datetime DEFAULT NULL, PRIMARY KEY (id), KEY queue_name (queue_name), KEY available_at (available_at), KEY delivered_at (delivered_at) ) ENGINE=InnoDB;', 'CREATE TABLE sys_http_report ( uuid varchar(36) NOT NULL, status tinyint(1) unsigned DEFAULT \'0\' NOT NULL, created int(11) unsigned NOT NULL, changed int(11) unsigned NOT NULL, type varchar(32) NOT NULL, scope varchar(32) NOT NULL, request_time bigint(20) unsigned NOT NULL, meta mediumtext, details mediumtext, summary varchar(40) NOT NULL, PRIMARY KEY (uuid), KEY type_scope (type,scope), KEY created (created), KEY changed (changed), KEY request_time (request_time), KEY summary_created (summary,created), KEY all_conditions (type,status,scope,summary,request_time) ) ENGINE=InnoDB;', 'CREATE TABLE sys_csp_resolution ( summary varchar(40) NOT NULL, created int(11) unsigned NOT NULL, scope varchar(264) NOT NULL, mutation_identifier text, mutation_collection mediumtext, meta mediumtext, PRIMARY KEY (summary), KEY created (created), ) ENGINE=InnoDB;', 'CREATE TABLE fe_users ( tx_extbase_type varchar(255) DEFAULT \'0\' NOT NULL );', 'CREATE TABLE be_users ( password_reset_token varchar(100) DEFAULT \'\' NOT NULL );', 'CREATE TABLE tx_extensionmanager_domain_model_extension ( extension_key varchar(60) NOT NULL default \'\', remote varchar(100) NOT NULL default \'ter\', version varchar(15) NOT NULL default \'\', alldownloadcounter int(11) unsigned NOT NULL default \'0\', downloadcounter int(11) unsigned NOT NULL default \'0\', title varchar(150) NOT NULL default \'\', serialized_dependencies mediumtext, author_name varchar(255) NOT NULL default \'\', author_email varchar(255) NOT NULL default \'\', ownerusername varchar(50) NOT NULL default \'\', md5hash varchar(35) NOT NULL default \'\', authorcompany varchar(255) NOT NULL default \'\', integer_version int(11) NOT NULL default \'0\', lastreviewedversion int(3) NOT NULL default \'0\', documentation_link varchar(2048), distribution_image varchar(255), distribution_welcome_image varchar(255), KEY index_extrepo (extension_key,remote), KEY index_versionrepo (integer_version,remote,extension_key), KEY index_currentversions (current_version,review_state), UNIQUE versionextrepo (extension_key,version,remote) );', 'CREATE TABLE fe_sessions ( ses_id varchar(190) DEFAULT \'\' NOT NULL, ses_iplock varchar(39) DEFAULT \'\' NOT NULL, ses_userid int(11) unsigned DEFAULT \'0\' NOT NULL, ses_tstamp int(11) unsigned DEFAULT \'0\' NOT NULL, ses_data mediumblob, ses_permanent tinyint(1) unsigned DEFAULT \'0\' NOT NULL, PRIMARY KEY (ses_id), KEY ses_tstamp (ses_tstamp) ) ENGINE=InnoDB;', 'CREATE TABLE fe_users ( uc blob, is_online int(10) unsigned DEFAULT \'0\' NOT NULL, mfa mediumblob, KEY parent (pid,username(100)), KEY username (username(100)), KEY is_online (is_online) );', 'CREATE TABLE sys_template ( KEY roottemplate (deleted,hidden,root) );', 'CREATE TABLE tt_content ( frame_class varchar(60) DEFAULT \'default\' NOT NULL, colPos int(11) unsigned DEFAULT \'0\' NOT NULL, table_caption varchar(255) DEFAULT NULL, KEY parent (pid,sorting), KEY t3ver_oid (t3ver_oid,t3ver_wsid), KEY language (l18n_parent,sys_language_uid) );', 'CREATE TABLE static_countries ( uid int(11) UNSIGNED NOT NULL auto_increment, pid int(11) UNSIGNED DEFAULT \'0\' NOT NULL, deleted smallint(6) UNSIGNED DEFAULT \'0\' NOT NULL, cn_iso_2 varchar(2) DEFAULT \'\' NOT NULL, cn_iso_3 varchar(3) DEFAULT \'\' NOT NULL, cn_iso_nr int(11) DEFAULT \'0\' NOT NULL, cn_parent_territory_uid int(11) DEFAULT \'0\' NOT NULL, cn_parent_tr_iso_nr int(11) DEFAULT \'0\' NOT NULL, cn_official_name_local varchar(128) DEFAULT \'\' NOT NULL, cn_official_name_en varchar(128) DEFAULT \'\' NOT NULL, cn_capital varchar(45) DEFAULT \'\' NOT NULL, cn_tldomain varchar(2) DEFAULT \'\' NOT NULL, cn_currency_uid int(11) DEFAULT \'0\' NOT NULL, cn_currency_iso_3 varchar(3) DEFAULT \'\' NOT NULL, cn_currency_iso_nr int(11) DEFAULT \'0\' NOT NULL, cn_phone int(11) DEFAULT \'0\' NOT NULL, cn_eu_member smallint(6) DEFAULT \'0\' NOT NULL, cn_uno_member smallint(6) DEFAULT \'0\' NOT NULL, cn_address_format smallint(6) DEFAULT \'0\' NOT NULL, cn_zone_flag smallint(6) DEFAULT \'0\' NOT NULL, cn_short_local varchar(70) DEFAULT \'\' NOT NULL, cn_short_en varchar(50) DEFAULT \'\' NOT NULL, cn_country_zones int(11) DEFAULT \'0\' NOT NULL, PRIMARY KEY (uid), KEY parent (pid,deleted) );', 'CREATE TABLE static_country_zones ( uid int(11) UNSIGNED NOT NULL auto_increment, pid int(11) UNSIGNED DEFAULT \'0\' NOT NULL, deleted smallint(6) UNSIGNED DEFAULT \'0\' NOT NULL, zn_country_iso_2 varchar(2) DEFAULT \'\' NOT NULL, zn_country_iso_3 varchar(3) DEFAULT \'\' NOT NULL, zn_country_iso_nr int(11) DEFAULT \'0\' NOT NULL, zn_code varchar(45) DEFAULT \'\' NOT NULL, zn_name_local varchar(128) DEFAULT \'\' NOT NULL, zn_name_en varchar(50) DEFAULT \'\' NOT NULL, zn_country_uid int(11) DEFAULT \'0\' NOT NULL, zn_country_table tinytext, PRIMARY KEY (uid), KEY parent (pid,deleted) );', 'CREATE TABLE static_currencies ( uid int(11) UNSIGNED NOT NULL auto_increment, pid int(11) UNSIGNED DEFAULT \'0\' NOT NULL, deleted smallint(6) UNSIGNED DEFAULT \'0\' NOT NULL, cu_iso_3 varchar(3) DEFAULT \'\' NOT NULL, cu_iso_nr int(11) DEFAULT \'0\' NOT NULL, cu_name_en varchar(50) DEFAULT \'\' NOT NULL, cu_symbol_left varchar(12) DEFAULT \'\' NOT NULL, cu_symbol_right varchar(12) DEFAULT \'\' NOT NULL, cu_thousands_point varchar(1) DEFAULT \'\' NOT NULL, cu_decimal_point varchar(1) DEFAULT \'\' NOT NULL, cu_decimal_digits smallint(6) DEFAULT \'0\' NOT NULL, cu_sub_name_en varchar(20) DEFAULT \'\' NOT NULL, cu_sub_divisor int(11) DEFAULT \'1\' NOT NULL, cu_sub_symbol_left varchar(12) DEFAULT \'\' NOT NULL, cu_sub_symbol_right varchar(12) DEFAULT \'\' NOT NULL, PRIMARY KEY (uid), KEY parent (pid,deleted) );', 'CREATE TABLE static_languages ( uid int(11) UNSIGNED NOT NULL auto_increment, pid int(11) UNSIGNED DEFAULT \'0\' NOT NULL, deleted smallint(6) UNSIGNED DEFAULT \'0\' NOT NULL, lg_iso_2 varchar(2) DEFAULT \'\' NOT NULL, lg_name_local varchar(99) DEFAULT \'\' NOT NULL, lg_name_en varchar(50) DEFAULT \'\' NOT NULL, lg_typo3 varchar(2) DEFAULT \'\' NOT NULL, lg_country_iso_2 varchar(2) DEFAULT \'\' NOT NULL, lg_collate_locale varchar(5) DEFAULT \'\' NOT NULL, lg_sacred smallint(6) DEFAULT \'0\' NOT NULL, lg_constructed smallint(6) DEFAULT \'0\' NOT NULL, PRIMARY KEY (uid), KEY parent (pid,deleted) );', 'CREATE TABLE static_territories ( uid int(11) UNSIGNED NOT NULL auto_increment, pid int(11) UNSIGNED DEFAULT \'0\' NOT NULL, deleted smallint(6) UNSIGNED DEFAULT \'0\' NOT NULL, tr_iso_nr int(11) DEFAULT \'0\' NOT NULL, tr_parent_territory_uid int(11) DEFAULT \'0\' NOT NULL, tr_parent_iso_nr int(11) DEFAULT \'0\' NOT NULL, tr_name_en varchar(50) DEFAULT \'\' NOT NULL, PRIMARY KEY (uid), KEY parent (pid,deleted) );', 'CREATE TABLE static_countries ( uid int unsigned NOT NULL auto_increment, pid int unsigned NOT NULL default \'0\', deleted smallint unsigned NOT NULL default \'0\', cn_iso_2 varchar(2) NOT NULL default \'\', cn_iso_3 varchar(3) NOT NULL default \'\', cn_iso_nr int NOT NULL default \'0\', cn_parent_territory_uid int NOT NULL default \'0\', cn_parent_tr_iso_nr int NOT NULL default \'0\', cn_official_name_local varchar(128) NOT NULL default \'\', cn_official_name_en varchar(128) NOT NULL default \'\', cn_capital varchar(45) NOT NULL default \'\', cn_tldomain varchar(2) NOT NULL default \'\', cn_currency_uid int NOT NULL default \'0\', cn_currency_iso_3 varchar(3) NOT NULL default \'\', cn_currency_iso_nr int NOT NULL default \'0\', cn_phone int NOT NULL default \'0\', cn_eu_member smallint NOT NULL default \'0\', cn_uno_member smallint NOT NULL default \'0\', cn_address_format smallint NOT NULL default \'0\', cn_zone_flag smallint NOT NULL default \'0\', cn_short_local varchar(70) NOT NULL default \'\', cn_short_en varchar(50) NOT NULL default \'\', cn_country_zones int NOT NULL default \'0\', PRIMARY KEY (uid), KEY parent (pid,deleted) );', 'CREATE TABLE static_country_zones ( uid int unsigned NOT NULL auto_increment, pid int unsigned NOT NULL default \'0\', deleted smallint unsigned NOT NULL default \'0\', zn_country_iso_2 varchar(2) NOT NULL default \'\', zn_country_iso_3 varchar(3) NOT NULL default \'\', zn_country_iso_nr int NOT NULL default \'0\', zn_code varchar(45) NOT NULL default \'\', zn_name_local varchar(128) NOT NULL default \'\', zn_name_en varchar(50) NOT NULL default \'\', zn_country_uid int NOT NULL default \'0\', zn_country_table tinytext, PRIMARY KEY (uid), KEY parent (pid,deleted) );', 'CREATE TABLE static_currencies ( uid int unsigned NOT NULL auto_increment, pid int unsigned NOT NULL default \'0\', deleted smallint unsigned NOT NULL default \'0\', cu_iso_3 varchar(3) NOT NULL default \'\', cu_iso_nr int NOT NULL default \'0\', cu_name_en varchar(50) NOT NULL default \'\', cu_symbol_left varchar(12) NOT NULL default \'\', cu_symbol_right varchar(12) NOT NULL default \'\', cu_thousands_point varchar(1) NOT NULL default \'\', cu_decimal_point varchar(1) NOT NULL default \'\', cu_decimal_digits smallint NOT NULL default \'0\', cu_sub_name_en varchar(20) NOT NULL default \'\', cu_sub_divisor int NOT NULL default \'1\', cu_sub_symbol_left varchar(12) NOT NULL default \'\', cu_sub_symbol_right varchar(12) NOT NULL default \'\', PRIMARY KEY (uid), KEY parent (pid,deleted) );', 'CREATE TABLE static_languages ( uid int unsigned NOT NULL auto_increment, pid int unsigned NOT NULL default \'0\', deleted smallint unsigned NOT NULL default \'0\', lg_iso_2 varchar(2) NOT NULL default \'\', lg_name_local varchar(99) NOT NULL default \'\', lg_name_en varchar(50) NOT NULL default \'\', lg_typo3 varchar(2) NOT NULL default \'\', lg_country_iso_2 varchar(2) NOT NULL default \'\', lg_collate_locale varchar(5) NOT NULL default \'\', lg_sacred smallint NOT NULL default \'0\', lg_constructed smallint NOT NULL default \'0\', PRIMARY KEY (uid), KEY parent (pid,deleted) );', 'CREATE TABLE static_territories ( uid int unsigned NOT NULL auto_increment, pid int unsigned NOT NULL default \'0\', deleted smallint unsigned NOT NULL default \'0\', tr_iso_nr int NOT NULL default \'0\', tr_parent_territory_uid int NOT NULL default \'0\', tr_parent_iso_nr int NOT NULL default \'0\', tr_name_en varchar(50) NOT NULL default \'\', PRIMARY KEY (uid), KEY parent (pid,deleted) );', 'CREATE TABLE fe_users ( activated_on int(11) unsigned DEFAULT \'0\' NOT NULL, pseudonym varchar(50) DEFAULT \'\', gender int(11) unsigned DEFAULT \'0\' NOT NULL, date_of_birth int(11) DEFAULT \'0\' NOT NULL, language char(2) DEFAULT \'\' NOT NULL, zone varchar(45) DEFAULT \'\' NOT NULL, static_info_country char(3) DEFAULT \'\' NOT NULL, timezone float DEFAULT \'0\' NOT NULL, daylight tinyint(4) unsigned DEFAULT \'0\' NOT NULL, mobilephone varchar(20) DEFAULT \'\' NOT NULL, gtc tinyint(4) unsigned DEFAULT \'0\' NOT NULL, privacy tinyint(4) unsigned DEFAULT \'0\' NOT NULL, status int(11) unsigned DEFAULT \'0\' NOT NULL, by_invitation tinyint(4) unsigned DEFAULT \'0\' NOT NULL, comments text, module_sys_dmail_newsletter tinyint(3) unsigned DEFAULT \'0\' NOT NULL, module_sys_dmail_html tinyint(3) unsigned DEFAULT \'0\' NOT NULL, module_sys_dmail_category text, email_new varchar(254) DEFAULT \'\' NOT NULL, invitation_email varchar(254) DEFAULT \'\' NOT NULL );', 'CREATE TABLE fe_groups ( felogin_redirectPid tinytext );', 'CREATE TABLE tx_storefinder_domain_model_location ( name varchar(255) DEFAULT \'\' NOT NULL, storeid varchar(60) DEFAULT \'\' NOT NULL, address varchar(255) DEFAULT \'\' NOT NULL, additionaladdress varchar(255) DEFAULT \'\' NOT NULL, person varchar(255) DEFAULT \'\' NOT NULL, city varchar(255) DEFAULT \'\' NOT NULL, zipcode varchar(10) DEFAULT \'\' NOT NULL, state varchar(3) DEFAULT \'\' NOT NULL, country varchar(3) DEFAULT \'\' NOT NULL, products varchar(255) DEFAULT \'\' NOT NULL, phone varchar(20) DEFAULT \'\' NOT NULL, mobile varchar(20) DEFAULT \'\' NOT NULL, fax varchar(20) DEFAULT \'\' NOT NULL, hours text, email varchar(255) DEFAULT \'\' NOT NULL, url varchar(2048) DEFAULT \'\' NOT NULL, notes text, attributes int(11) unsigned DEFAULT \'0\' NOT NULL, categories int(11) unsigned DEFAULT \'0\' NOT NULL, content_elements int(11) unsigned DEFAULT \'0\' NOT NULL, related int(11) unsigned DEFAULT \'0\' NOT NULL, image int(11) unsigned DEFAULT \'0\' NOT NULL, media int(11) unsigned DEFAULT \'0\' NOT NULL, layer int(11) unsigned DEFAULT \'0\' NOT NULL, icon int(11) unsigned DEFAULT \'0\' NOT NULL, map int(11) unsigned DEFAULT \'0\' NOT NULL, latitude double(11,7) DEFAULT \'0.0000000\' NOT NULL, longitude double(11,7) DEFAULT \'0.0000000\' NOT NULL, center int(4) DEFAULT \'0\' NOT NULL, geocode int(4) DEFAULT \'0\' NOT NULL, import_id int(11) DEFAULT \'0\' NOT NULL, KEY import_id (import_id) );', 'CREATE TABLE tx_storefinder_domain_model_attribute ( icon varchar(255) DEFAULT \'\' NOT NULL, name varchar(255) DEFAULT \'\' NOT NULL, description text, css_class varchar(255) DEFAULT \'\' NOT NULL, import_id int(11) DEFAULT \'0\' NOT NULL, KEY import_id (import_id) );', 'CREATE TABLE tx_storefinder_location_attribute_mm ( uid_local int(11) DEFAULT \'0\' NOT NULL, uid_foreign int(11) DEFAULT \'0\' NOT NULL, sorting int(11) unsigned DEFAULT \'0\' NOT NULL, sorting_foreign int(11) unsigned DEFAULT \'0\' NOT NULL, tablenames varchar(255) DEFAULT \'\' NOT NULL, fieldname varchar(255) DEFAULT \'\' NOT NULL, KEY uid_local (uid_local), KEY uid_foreign (uid_foreign) );', 'CREATE TABLE tx_storefinder_location_location_mm ( uid_local int(11) DEFAULT \'0\' NOT NULL, uid_foreign int(11) DEFAULT \'0\' NOT NULL, sorting int(11) DEFAULT \'0\' NOT NULL, sorting_foreign int(11) unsigned DEFAULT \'0\' NOT NULL, tablenames varchar(255) DEFAULT \'\' NOT NULL, fieldname varchar(255) DEFAULT \'\' NOT NULL, KEY uid_local (uid_local), KEY uid_foreign (uid_foreign) );', 'CREATE TABLE sys_category ( children int(11) unsigned DEFAULT \'0\' NOT NULL, import_id varchar(100) DEFAULT \'\' NOT NULL );', 'CREATE TABLE tx_sfbooks_domain_model_book ( number tinytext NOT NULL, title tinytext NOT NULL, path_segment varchar(2048), subtitle tinytext NOT NULL, author tinytext NOT NULL, isbn tinytext NOT NULL, series int(11) unsigned DEFAULT \'0\' NOT NULL, category int(11) unsigned DEFAULT \'0\' NOT NULL, description text NOT NULL, extras int(11) unsigned DEFAULT \'0\' NOT NULL, cover int(11) unsigned DEFAULT \'0\' NOT NULL, cover_large int(11) unsigned DEFAULT \'0\' NOT NULL, sample_pdf int(11) unsigned DEFAULT \'0\' NOT NULL, year varchar(4) DEFAULT \'\' NOT NULL, location1 int(11) unsigned DEFAULT \'0\' NOT NULL, location2 int(11) unsigned DEFAULT \'0\' NOT NULL, location3 int(11) unsigned DEFAULT \'0\' NOT NULL );', 'CREATE TABLE tx_sfbooks_domain_model_book_author_mm ( uid_local int(11) unsigned DEFAULT \'0\' NOT NULL, uid_foreign int(11) unsigned DEFAULT \'0\' NOT NULL, sorting int(11) unsigned DEFAULT \'0\' NOT NULL, sorting_foreign int(11) unsigned DEFAULT \'0\' NOT NULL, KEY uid_local (uid_local), KEY uid_foreign (uid_foreign) );', 'CREATE TABLE tx_sfbooks_domain_model_author ( lastname tinytext NOT NULL, firstname tinytext NOT NULL, path_segment varchar(2048), description text NOT NULL, books tinytext NOT NULL );', 'CREATE TABLE tx_sfbooks_domain_model_book_series_mm ( uid_local int(11) unsigned DEFAULT \'0\' NOT NULL, uid_foreign int(11) unsigned DEFAULT \'0\' NOT NULL, sorting int(11) unsigned DEFAULT \'0\' NOT NULL, sorting_foreign int(11) unsigned DEFAULT \'0\' NOT NULL, KEY uid_local (uid_local), KEY uid_foreign (uid_foreign) );', 'CREATE TABLE tx_sfbooks_domain_model_series ( title tinytext NOT NULL, path_segment varchar(2048), info text NOT NULL, description text NOT NULL, books tinytext NOT NULL );', 'CREATE TABLE tx_sfbooks_domain_model_book_category_mm ( uid_local int(11) unsigned DEFAULT \'0\' NOT NULL, uid_foreign int(11) unsigned DEFAULT \'0\' NOT NULL, sorting int(11) unsigned DEFAULT \'0\' NOT NULL, sorting_foreign int(11) unsigned DEFAULT \'0\' NOT NULL, KEY uid_local (uid_local), KEY uid_foreign (uid_foreign) );', 'CREATE TABLE tx_sfbooks_domain_model_category ( title tinytext NOT NULL, path_segment varchar(2048), parent int(11) unsigned DEFAULT \'0\' NOT NULL, children int(11) unsigned DEFAULT \'0\' NOT NULL, description text NOT NULL, books tinytext NOT NULL );', 'CREATE TABLE tx_sfbooks_domain_model_extras ( parent int(11) DEFAULT \'0\' NOT NULL, type int(11) DEFAULT \'0\' NOT NULL, label int(11) unsigned DEFAULT \'0\' NOT NULL, content text NOT NULL );', 'CREATE TABLE tx_sfbooks_domain_model_extraslabels ( label tinytext NOT NULL );', 'CREATE TABLE cache_hash ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) DEFAULT \'\' NOT NULL, expires int(11) unsigned DEFAULT \'0\' NOT NULL, content longblob, PRIMARY KEY (id), KEY cache_id (identifier(180),expires) ) ENGINE=InnoDB;', 'CREATE TABLE cache_hash_tags ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) DEFAULT \'\' NOT NULL, tag varchar(250) DEFAULT \'\' NOT NULL, PRIMARY KEY (id), KEY cache_id (identifier(191)), KEY cache_tag (tag(191)) ) ENGINE=InnoDB;', 'CREATE TABLE cache_pages ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) DEFAULT \'\' NOT NULL, expires int(11) unsigned DEFAULT \'0\' NOT NULL, content longblob, PRIMARY KEY (id), KEY cache_id (identifier(180),expires) ) ENGINE=InnoDB;', 'CREATE TABLE cache_pages_tags ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) DEFAULT \'\' NOT NULL, tag varchar(250) DEFAULT \'\' NOT NULL, PRIMARY KEY (id), KEY cache_id (identifier(191)), KEY cache_tag (tag(191)) ) ENGINE=InnoDB;', 'CREATE TABLE cache_rootline ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) DEFAULT \'\' NOT NULL, expires int(11) unsigned DEFAULT \'0\' NOT NULL, content longblob, PRIMARY KEY (id), KEY cache_id (identifier(180),expires) ) ENGINE=InnoDB;', 'CREATE TABLE cache_rootline_tags ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) DEFAULT \'\' NOT NULL, tag varchar(250) DEFAULT \'\' NOT NULL, PRIMARY KEY (id), KEY cache_id (identifier(191)), KEY cache_tag (tag(191)) ) ENGINE=InnoDB;', 'CREATE TABLE cache_store_finder_coordinate_cache ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) DEFAULT \'\' NOT NULL, expires int(11) unsigned DEFAULT \'0\' NOT NULL, content longblob, PRIMARY KEY (id), KEY cache_id (identifier(180),expires) ) ENGINE=InnoDB;', 'CREATE TABLE cache_store_finder_coordinate_cache_tags ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) DEFAULT \'\' NOT NULL, tag varchar(250) DEFAULT \'\' NOT NULL, PRIMARY KEY (id), KEY cache_id (identifier(191)), KEY cache_tag (tag(191)) ) ENGINE=InnoDB;', 'CREATE TABLE cache_store_finder_middleware_cache ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) DEFAULT \'\' NOT NULL, expires int(11) unsigned DEFAULT \'0\' NOT NULL, content longblob, PRIMARY KEY (id), KEY cache_id (identifier(180),expires) ) ENGINE=InnoDB;', 'CREATE TABLE cache_store_finder_middleware_cache_tags ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) DEFAULT \'\' NOT NULL, tag varchar(250) DEFAULT \'\' NOT NULL, PRIMARY KEY (id), KEY cache_id (identifier(191)), KEY cache_tag (tag(191)) ) ENGINE=InnoDB;')
)
in /var/www/html/vendor/typo3/cms-core/Classes/Database/Schema/SchemaMigrator.php
line 149
* @throws StatementException
*/
public function install(array $statements, bool $createOnly = false): array
{
$tables = $this->parseCreateTableStatements($statements);
$result = [];
foreach ($this->connectionPool->getConnectionNames() as $connectionName) {
$connection = $this->connectionPool->getConnectionByName($connectionName);
$connectionMigrator = ConnectionMigrator::create($connectionName, $connection, $tables);
at TYPO3\CMS\Core\Database\Schema\SchemaMigrator
->
install
(
array
('CREATE TABLE be_sessions ( ses_id varchar(190) DEFAULT \'\' NOT NULL, ses_iplock varchar(39) DEFAULT \'\' NOT NULL, ses_userid int(11) unsigned DEFAULT \'0\' NOT NULL, ses_tstamp int(11) unsigned DEFAULT \'0\' NOT NULL, ses_data longblob, PRIMARY KEY (ses_id), KEY ses_tstamp (ses_tstamp) );', 'CREATE TABLE be_users ( lang varchar(10) DEFAULT \'default\' NOT NULL, uc mediumblob, workspace_id int(11) DEFAULT \'0\' NOT NULL, mfa mediumblob, KEY username (username) );', 'CREATE TABLE be_groups( tables_select longtext );', 'CREATE TABLE pages ( perms_userid int(11) unsigned DEFAULT \'0\' NOT NULL, perms_groupid int(11) unsigned DEFAULT \'0\' NOT NULL, perms_user tinyint(4) unsigned DEFAULT \'0\' NOT NULL, perms_group tinyint(4) unsigned DEFAULT \'0\' NOT NULL, perms_everybody tinyint(4) unsigned DEFAULT \'0\' NOT NULL, SYS_LASTCHANGED int(10) unsigned DEFAULT \'0\' NOT NULL, shortcut int(10) unsigned DEFAULT \'0\' NOT NULL, content_from_pid int(10) unsigned DEFAULT \'0\' NOT NULL, mount_pid int(10) unsigned DEFAULT \'0\' NOT NULL, KEY determineSiteRoot (is_siteroot), KEY language_identifier (l10n_parent,sys_language_uid), KEY slug (slug(127)) );', 'CREATE TABLE sys_registry ( uid int(11) unsigned NOT NULL auto_increment, entry_namespace varchar(128) DEFAULT \'\' NOT NULL, entry_key varchar(128) DEFAULT \'\' NOT NULL, entry_value mediumblob, PRIMARY KEY (uid), UNIQUE KEY entry_identifier (entry_namespace,entry_key) );', 'CREATE TABLE sys_be_shortcuts ( uid int(11) unsigned NOT NULL auto_increment, userid int(11) unsigned DEFAULT \'0\' NOT NULL, route varchar(255) DEFAULT \'\' NOT NULL, arguments text, description varchar(255) DEFAULT \'\' NOT NULL, sorting int(11) DEFAULT \'0\' NOT NULL, sc_group tinyint(4) DEFAULT \'0\' NOT NULL, PRIMARY KEY (uid), KEY event (userid) );', 'CREATE TABLE sys_file_storage ( is_public tinyint(4) DEFAULT \'0\' NOT NULL, processingfolder tinytext );', 'CREATE TABLE sys_file ( last_indexed int(11) DEFAULT \'0\' NOT NULL, identifier text, identifier_hash char(40) DEFAULT \'\' NOT NULL, folder_hash char(40) DEFAULT \'\' NOT NULL, extension varchar(255) DEFAULT \'\' NOT NULL, name tinytext, sha1 char(40) DEFAULT \'\' NOT NULL, creation_date int(11) DEFAULT \'0\' NOT NULL, modification_date int(11) DEFAULT \'0\' NOT NULL, KEY sel01 (storage,identifier_hash), KEY folder (storage,folder_hash), KEY tstamp (tstamp), KEY lastindex (last_indexed), KEY sha1 (sha1) );', 'CREATE TABLE sys_file_metadata ( title tinytext, alternative text, KEY file (file), KEY fal_filelist (l10n_parent,sys_language_uid) );', 'CREATE TABLE sys_file_processedfile ( uid int(11) NOT NULL auto_increment, tstamp int(11) DEFAULT \'0\' NOT NULL, crdate int(11) DEFAULT \'0\' NOT NULL, storage int(11) DEFAULT \'0\' NOT NULL, original int(11) DEFAULT \'0\' NOT NULL, identifier varchar(512) DEFAULT \'\' NOT NULL, name tinytext, processing_url text, configuration blob, configurationsha1 char(40) DEFAULT \'\' NOT NULL, originalfilesha1 char(40) DEFAULT \'\' NOT NULL, task_type varchar(200) DEFAULT \'\' NOT NULL, checksum char(32) DEFAULT \'\' NOT NULL, width int(11) DEFAULT \'0\', height int(11) DEFAULT \'0\', PRIMARY KEY (uid), KEY combined_1 (original,task_type(100),configurationsha1), KEY identifier (storage,identifier(180)) );', 'CREATE TABLE sys_file_reference ( uid_local int(11) DEFAULT \'0\' NOT NULL, title tinytext, alternative text, KEY tablenames_fieldname (tablenames(32),fieldname(12)), KEY deleted (deleted), KEY uid_local (uid_local), KEY uid_foreign (uid_foreign), KEY combined_1 (l10n_parent, t3ver_oid, t3ver_wsid, t3ver_state, deleted) );', 'CREATE TABLE sys_file_collection ( title tinytext, type varchar(30) DEFAULT \'static\' NOT NULL, );', 'CREATE TABLE sys_history ( uid int(11) unsigned NOT NULL auto_increment, tstamp int(11) unsigned DEFAULT \'0\' NOT NULL, actiontype tinyint(3) DEFAULT \'0\' NOT NULL, usertype varchar(2) DEFAULT \'BE\' NOT NULL, userid int(11) unsigned, originaluserid int(11) unsigned, recuid int(11) DEFAULT \'0\' NOT NULL, tablename varchar(255) DEFAULT \'\' NOT NULL, history_data mediumtext, workspace int(11) DEFAULT \'0\', correlation_id varchar(255) DEFAULT \'\' NOT NULL, PRIMARY KEY (uid), KEY recordident_1 (tablename(100),recuid), KEY recordident_2 (tablename(100),tstamp) ) ENGINE=InnoDB;', 'CREATE TABLE sys_lockedrecords ( uid int(11) unsigned NOT NULL auto_increment, userid int(11) unsigned DEFAULT \'0\' NOT NULL, tstamp int(11) unsigned DEFAULT \'0\' NOT NULL, record_table varchar(255) DEFAULT \'\' NOT NULL, record_uid int(11) DEFAULT \'0\' NOT NULL, record_pid int(11) DEFAULT \'0\' NOT NULL, username varchar(50) DEFAULT \'\' NOT NULL, feuserid int(11) unsigned DEFAULT \'0\' NOT NULL, PRIMARY KEY (uid), KEY event (userid,tstamp) );', 'CREATE TABLE sys_refindex ( hash varchar(32) DEFAULT \'\' NOT NULL, tablename varchar(64) DEFAULT \'\' NOT NULL, recuid int unsigned DEFAULT 0 NOT NULL, field varchar(64) DEFAULT \'\' NOT NULL, hidden smallint unsigned DEFAULT 0 NOT NULL, starttime int unsigned DEFAULT 0 NOT NULL, endtime int unsigned DEFAULT 2147483647 NOT NULL, t3ver_state int unsigned DEFAULT 0 NOT NULL, flexpointer varchar(255) DEFAULT \'\' NOT NULL, softref_key varchar(30) DEFAULT \'\' NOT NULL, softref_id varchar(40) DEFAULT \'\' NOT NULL, sorting int DEFAULT 0 NOT NULL, workspace int unsigned DEFAULT 0 NOT NULL, ref_table varchar(64) DEFAULT \'\' NOT NULL, ref_uid int DEFAULT 0 NOT NULL, ref_field varchar(64) DEFAULT \'\' NOT NULL, ref_hidden smallint unsigned DEFAULT 0 NOT NULL, ref_starttime int unsigned DEFAULT 0 NOT NULL, ref_endtime int unsigned DEFAULT 2147483647 NOT NULL, ref_t3ver_state int unsigned DEFAULT 0 NOT NULL, ref_sorting int DEFAULT 0 NOT NULL, ref_string varchar(1024) DEFAULT \'\' NOT NULL, PRIMARY KEY (hash), KEY lookup_rec (tablename,recuid,field,workspace,ref_t3ver_state,ref_hidden,ref_starttime,ref_endtime), KEY lookup_ref (ref_table,ref_uid,tablename,workspace,t3ver_state,hidden,starttime,endtime), );', 'CREATE TABLE sys_log ( uid int(11) unsigned NOT NULL auto_increment, tstamp int(11) unsigned DEFAULT \'0\' NOT NULL, userid int(11) unsigned DEFAULT \'0\' NOT NULL, action tinyint(4) unsigned DEFAULT \'0\' NOT NULL, recuid int(11) unsigned DEFAULT \'0\' NOT NULL, tablename varchar(255) DEFAULT \'\' NOT NULL, recpid int(11) DEFAULT \'0\' NOT NULL, error tinyint(4) unsigned DEFAULT \'0\' NOT NULL, details text, type tinyint(3) unsigned DEFAULT \'0\' NOT NULL, channel varchar(20) DEFAULT \'default\' NOT NULL, details_nr tinyint(3) DEFAULT \'0\' NOT NULL, IP varchar(39) DEFAULT \'\' NOT NULL, log_data text, event_pid int(11) DEFAULT \'-1\' NOT NULL, workspace int(11) DEFAULT \'0\' NOT NULL, NEWid varchar(30) DEFAULT \'\' NOT NULL, request_id varchar(13) DEFAULT \'\' NOT NULL, time_micro float DEFAULT \'0\' NOT NULL, component varchar(255) DEFAULT \'\' NOT NULL, level varchar(10) DEFAULT \'info\' NOT NULL, message text, data text, PRIMARY KEY (uid), KEY event (userid, event_pid), KEY recuidIdx (recuid), KEY user_auth (type, action, tstamp), KEY request (request_id), KEY combined_1 (tstamp, type, userid), KEY errorcount (tstamp, error), KEY index_channel (channel), KEY index_level (level) ) ENGINE=InnoDB;', 'CREATE TABLE sys_category ( items int(11) DEFAULT \'0\' NOT NULL, KEY category_parent (parent), KEY category_list (pid,deleted,sys_language_uid) );', 'CREATE TABLE `sys_messenger_messages` ( id int(11) unsigned NOT NULL auto_increment, body longtext NOT NULL, headers longtext NOT NULL, queue_name varchar(190) NOT NULL, created_at datetime NOT NULL, available_at datetime NOT NULL, delivered_at datetime DEFAULT NULL, PRIMARY KEY (id), KEY queue_name (queue_name), KEY available_at (available_at), KEY delivered_at (delivered_at) ) ENGINE=InnoDB;', 'CREATE TABLE sys_http_report ( uuid varchar(36) NOT NULL, status tinyint(1) unsigned DEFAULT \'0\' NOT NULL, created int(11) unsigned NOT NULL, changed int(11) unsigned NOT NULL, type varchar(32) NOT NULL, scope varchar(32) NOT NULL, request_time bigint(20) unsigned NOT NULL, meta mediumtext, details mediumtext, summary varchar(40) NOT NULL, PRIMARY KEY (uuid), KEY type_scope (type,scope), KEY created (created), KEY changed (changed), KEY request_time (request_time), KEY summary_created (summary,created), KEY all_conditions (type,status,scope,summary,request_time) ) ENGINE=InnoDB;', 'CREATE TABLE sys_csp_resolution ( summary varchar(40) NOT NULL, created int(11) unsigned NOT NULL, scope varchar(264) NOT NULL, mutation_identifier text, mutation_collection mediumtext, meta mediumtext, PRIMARY KEY (summary), KEY created (created), ) ENGINE=InnoDB;', 'CREATE TABLE fe_users ( tx_extbase_type varchar(255) DEFAULT \'0\' NOT NULL );', 'CREATE TABLE be_users ( password_reset_token varchar(100) DEFAULT \'\' NOT NULL );', 'CREATE TABLE tx_extensionmanager_domain_model_extension ( extension_key varchar(60) NOT NULL default \'\', remote varchar(100) NOT NULL default \'ter\', version varchar(15) NOT NULL default \'\', alldownloadcounter int(11) unsigned NOT NULL default \'0\', downloadcounter int(11) unsigned NOT NULL default \'0\', title varchar(150) NOT NULL default \'\', serialized_dependencies mediumtext, author_name varchar(255) NOT NULL default \'\', author_email varchar(255) NOT NULL default \'\', ownerusername varchar(50) NOT NULL default \'\', md5hash varchar(35) NOT NULL default \'\', authorcompany varchar(255) NOT NULL default \'\', integer_version int(11) NOT NULL default \'0\', lastreviewedversion int(3) NOT NULL default \'0\', documentation_link varchar(2048), distribution_image varchar(255), distribution_welcome_image varchar(255), KEY index_extrepo (extension_key,remote), KEY index_versionrepo (integer_version,remote,extension_key), KEY index_currentversions (current_version,review_state), UNIQUE versionextrepo (extension_key,version,remote) );', 'CREATE TABLE fe_sessions ( ses_id varchar(190) DEFAULT \'\' NOT NULL, ses_iplock varchar(39) DEFAULT \'\' NOT NULL, ses_userid int(11) unsigned DEFAULT \'0\' NOT NULL, ses_tstamp int(11) unsigned DEFAULT \'0\' NOT NULL, ses_data mediumblob, ses_permanent tinyint(1) unsigned DEFAULT \'0\' NOT NULL, PRIMARY KEY (ses_id), KEY ses_tstamp (ses_tstamp) ) ENGINE=InnoDB;', 'CREATE TABLE fe_users ( uc blob, is_online int(10) unsigned DEFAULT \'0\' NOT NULL, mfa mediumblob, KEY parent (pid,username(100)), KEY username (username(100)), KEY is_online (is_online) );', 'CREATE TABLE sys_template ( KEY roottemplate (deleted,hidden,root) );', 'CREATE TABLE tt_content ( frame_class varchar(60) DEFAULT \'default\' NOT NULL, colPos int(11) unsigned DEFAULT \'0\' NOT NULL, table_caption varchar(255) DEFAULT NULL, KEY parent (pid,sorting), KEY t3ver_oid (t3ver_oid,t3ver_wsid), KEY language (l18n_parent,sys_language_uid) );', 'CREATE TABLE static_countries ( uid int(11) UNSIGNED NOT NULL auto_increment, pid int(11) UNSIGNED DEFAULT \'0\' NOT NULL, deleted smallint(6) UNSIGNED DEFAULT \'0\' NOT NULL, cn_iso_2 varchar(2) DEFAULT \'\' NOT NULL, cn_iso_3 varchar(3) DEFAULT \'\' NOT NULL, cn_iso_nr int(11) DEFAULT \'0\' NOT NULL, cn_parent_territory_uid int(11) DEFAULT \'0\' NOT NULL, cn_parent_tr_iso_nr int(11) DEFAULT \'0\' NOT NULL, cn_official_name_local varchar(128) DEFAULT \'\' NOT NULL, cn_official_name_en varchar(128) DEFAULT \'\' NOT NULL, cn_capital varchar(45) DEFAULT \'\' NOT NULL, cn_tldomain varchar(2) DEFAULT \'\' NOT NULL, cn_currency_uid int(11) DEFAULT \'0\' NOT NULL, cn_currency_iso_3 varchar(3) DEFAULT \'\' NOT NULL, cn_currency_iso_nr int(11) DEFAULT \'0\' NOT NULL, cn_phone int(11) DEFAULT \'0\' NOT NULL, cn_eu_member smallint(6) DEFAULT \'0\' NOT NULL, cn_uno_member smallint(6) DEFAULT \'0\' NOT NULL, cn_address_format smallint(6) DEFAULT \'0\' NOT NULL, cn_zone_flag smallint(6) DEFAULT \'0\' NOT NULL, cn_short_local varchar(70) DEFAULT \'\' NOT NULL, cn_short_en varchar(50) DEFAULT \'\' NOT NULL, cn_country_zones int(11) DEFAULT \'0\' NOT NULL, PRIMARY KEY (uid), KEY parent (pid,deleted) );', 'CREATE TABLE static_country_zones ( uid int(11) UNSIGNED NOT NULL auto_increment, pid int(11) UNSIGNED DEFAULT \'0\' NOT NULL, deleted smallint(6) UNSIGNED DEFAULT \'0\' NOT NULL, zn_country_iso_2 varchar(2) DEFAULT \'\' NOT NULL, zn_country_iso_3 varchar(3) DEFAULT \'\' NOT NULL, zn_country_iso_nr int(11) DEFAULT \'0\' NOT NULL, zn_code varchar(45) DEFAULT \'\' NOT NULL, zn_name_local varchar(128) DEFAULT \'\' NOT NULL, zn_name_en varchar(50) DEFAULT \'\' NOT NULL, zn_country_uid int(11) DEFAULT \'0\' NOT NULL, zn_country_table tinytext, PRIMARY KEY (uid), KEY parent (pid,deleted) );', 'CREATE TABLE static_currencies ( uid int(11) UNSIGNED NOT NULL auto_increment, pid int(11) UNSIGNED DEFAULT \'0\' NOT NULL, deleted smallint(6) UNSIGNED DEFAULT \'0\' NOT NULL, cu_iso_3 varchar(3) DEFAULT \'\' NOT NULL, cu_iso_nr int(11) DEFAULT \'0\' NOT NULL, cu_name_en varchar(50) DEFAULT \'\' NOT NULL, cu_symbol_left varchar(12) DEFAULT \'\' NOT NULL, cu_symbol_right varchar(12) DEFAULT \'\' NOT NULL, cu_thousands_point varchar(1) DEFAULT \'\' NOT NULL, cu_decimal_point varchar(1) DEFAULT \'\' NOT NULL, cu_decimal_digits smallint(6) DEFAULT \'0\' NOT NULL, cu_sub_name_en varchar(20) DEFAULT \'\' NOT NULL, cu_sub_divisor int(11) DEFAULT \'1\' NOT NULL, cu_sub_symbol_left varchar(12) DEFAULT \'\' NOT NULL, cu_sub_symbol_right varchar(12) DEFAULT \'\' NOT NULL, PRIMARY KEY (uid), KEY parent (pid,deleted) );', 'CREATE TABLE static_languages ( uid int(11) UNSIGNED NOT NULL auto_increment, pid int(11) UNSIGNED DEFAULT \'0\' NOT NULL, deleted smallint(6) UNSIGNED DEFAULT \'0\' NOT NULL, lg_iso_2 varchar(2) DEFAULT \'\' NOT NULL, lg_name_local varchar(99) DEFAULT \'\' NOT NULL, lg_name_en varchar(50) DEFAULT \'\' NOT NULL, lg_typo3 varchar(2) DEFAULT \'\' NOT NULL, lg_country_iso_2 varchar(2) DEFAULT \'\' NOT NULL, lg_collate_locale varchar(5) DEFAULT \'\' NOT NULL, lg_sacred smallint(6) DEFAULT \'0\' NOT NULL, lg_constructed smallint(6) DEFAULT \'0\' NOT NULL, PRIMARY KEY (uid), KEY parent (pid,deleted) );', 'CREATE TABLE static_territories ( uid int(11) UNSIGNED NOT NULL auto_increment, pid int(11) UNSIGNED DEFAULT \'0\' NOT NULL, deleted smallint(6) UNSIGNED DEFAULT \'0\' NOT NULL, tr_iso_nr int(11) DEFAULT \'0\' NOT NULL, tr_parent_territory_uid int(11) DEFAULT \'0\' NOT NULL, tr_parent_iso_nr int(11) DEFAULT \'0\' NOT NULL, tr_name_en varchar(50) DEFAULT \'\' NOT NULL, PRIMARY KEY (uid), KEY parent (pid,deleted) );', 'CREATE TABLE static_countries ( uid int unsigned NOT NULL auto_increment, pid int unsigned NOT NULL default \'0\', deleted smallint unsigned NOT NULL default \'0\', cn_iso_2 varchar(2) NOT NULL default \'\', cn_iso_3 varchar(3) NOT NULL default \'\', cn_iso_nr int NOT NULL default \'0\', cn_parent_territory_uid int NOT NULL default \'0\', cn_parent_tr_iso_nr int NOT NULL default \'0\', cn_official_name_local varchar(128) NOT NULL default \'\', cn_official_name_en varchar(128) NOT NULL default \'\', cn_capital varchar(45) NOT NULL default \'\', cn_tldomain varchar(2) NOT NULL default \'\', cn_currency_uid int NOT NULL default \'0\', cn_currency_iso_3 varchar(3) NOT NULL default \'\', cn_currency_iso_nr int NOT NULL default \'0\', cn_phone int NOT NULL default \'0\', cn_eu_member smallint NOT NULL default \'0\', cn_uno_member smallint NOT NULL default \'0\', cn_address_format smallint NOT NULL default \'0\', cn_zone_flag smallint NOT NULL default \'0\', cn_short_local varchar(70) NOT NULL default \'\', cn_short_en varchar(50) NOT NULL default \'\', cn_country_zones int NOT NULL default \'0\', PRIMARY KEY (uid), KEY parent (pid,deleted) );', 'CREATE TABLE static_country_zones ( uid int unsigned NOT NULL auto_increment, pid int unsigned NOT NULL default \'0\', deleted smallint unsigned NOT NULL default \'0\', zn_country_iso_2 varchar(2) NOT NULL default \'\', zn_country_iso_3 varchar(3) NOT NULL default \'\', zn_country_iso_nr int NOT NULL default \'0\', zn_code varchar(45) NOT NULL default \'\', zn_name_local varchar(128) NOT NULL default \'\', zn_name_en varchar(50) NOT NULL default \'\', zn_country_uid int NOT NULL default \'0\', zn_country_table tinytext, PRIMARY KEY (uid), KEY parent (pid,deleted) );', 'CREATE TABLE static_currencies ( uid int unsigned NOT NULL auto_increment, pid int unsigned NOT NULL default \'0\', deleted smallint unsigned NOT NULL default \'0\', cu_iso_3 varchar(3) NOT NULL default \'\', cu_iso_nr int NOT NULL default \'0\', cu_name_en varchar(50) NOT NULL default \'\', cu_symbol_left varchar(12) NOT NULL default \'\', cu_symbol_right varchar(12) NOT NULL default \'\', cu_thousands_point varchar(1) NOT NULL default \'\', cu_decimal_point varchar(1) NOT NULL default \'\', cu_decimal_digits smallint NOT NULL default \'0\', cu_sub_name_en varchar(20) NOT NULL default \'\', cu_sub_divisor int NOT NULL default \'1\', cu_sub_symbol_left varchar(12) NOT NULL default \'\', cu_sub_symbol_right varchar(12) NOT NULL default \'\', PRIMARY KEY (uid), KEY parent (pid,deleted) );', 'CREATE TABLE static_languages ( uid int unsigned NOT NULL auto_increment, pid int unsigned NOT NULL default \'0\', deleted smallint unsigned NOT NULL default \'0\', lg_iso_2 varchar(2) NOT NULL default \'\', lg_name_local varchar(99) NOT NULL default \'\', lg_name_en varchar(50) NOT NULL default \'\', lg_typo3 varchar(2) NOT NULL default \'\', lg_country_iso_2 varchar(2) NOT NULL default \'\', lg_collate_locale varchar(5) NOT NULL default \'\', lg_sacred smallint NOT NULL default \'0\', lg_constructed smallint NOT NULL default \'0\', PRIMARY KEY (uid), KEY parent (pid,deleted) );', 'CREATE TABLE static_territories ( uid int unsigned NOT NULL auto_increment, pid int unsigned NOT NULL default \'0\', deleted smallint unsigned NOT NULL default \'0\', tr_iso_nr int NOT NULL default \'0\', tr_parent_territory_uid int NOT NULL default \'0\', tr_parent_iso_nr int NOT NULL default \'0\', tr_name_en varchar(50) NOT NULL default \'\', PRIMARY KEY (uid), KEY parent (pid,deleted) );', 'CREATE TABLE fe_users ( activated_on int(11) unsigned DEFAULT \'0\' NOT NULL, pseudonym varchar(50) DEFAULT \'\', gender int(11) unsigned DEFAULT \'0\' NOT NULL, date_of_birth int(11) DEFAULT \'0\' NOT NULL, language char(2) DEFAULT \'\' NOT NULL, zone varchar(45) DEFAULT \'\' NOT NULL, static_info_country char(3) DEFAULT \'\' NOT NULL, timezone float DEFAULT \'0\' NOT NULL, daylight tinyint(4) unsigned DEFAULT \'0\' NOT NULL, mobilephone varchar(20) DEFAULT \'\' NOT NULL, gtc tinyint(4) unsigned DEFAULT \'0\' NOT NULL, privacy tinyint(4) unsigned DEFAULT \'0\' NOT NULL, status int(11) unsigned DEFAULT \'0\' NOT NULL, by_invitation tinyint(4) unsigned DEFAULT \'0\' NOT NULL, comments text, module_sys_dmail_newsletter tinyint(3) unsigned DEFAULT \'0\' NOT NULL, module_sys_dmail_html tinyint(3) unsigned DEFAULT \'0\' NOT NULL, module_sys_dmail_category text, email_new varchar(254) DEFAULT \'\' NOT NULL, invitation_email varchar(254) DEFAULT \'\' NOT NULL );', 'CREATE TABLE fe_groups ( felogin_redirectPid tinytext );', 'CREATE TABLE tx_storefinder_domain_model_location ( name varchar(255) DEFAULT \'\' NOT NULL, storeid varchar(60) DEFAULT \'\' NOT NULL, address varchar(255) DEFAULT \'\' NOT NULL, additionaladdress varchar(255) DEFAULT \'\' NOT NULL, person varchar(255) DEFAULT \'\' NOT NULL, city varchar(255) DEFAULT \'\' NOT NULL, zipcode varchar(10) DEFAULT \'\' NOT NULL, state varchar(3) DEFAULT \'\' NOT NULL, country varchar(3) DEFAULT \'\' NOT NULL, products varchar(255) DEFAULT \'\' NOT NULL, phone varchar(20) DEFAULT \'\' NOT NULL, mobile varchar(20) DEFAULT \'\' NOT NULL, fax varchar(20) DEFAULT \'\' NOT NULL, hours text, email varchar(255) DEFAULT \'\' NOT NULL, url varchar(2048) DEFAULT \'\' NOT NULL, notes text, attributes int(11) unsigned DEFAULT \'0\' NOT NULL, categories int(11) unsigned DEFAULT \'0\' NOT NULL, content_elements int(11) unsigned DEFAULT \'0\' NOT NULL, related int(11) unsigned DEFAULT \'0\' NOT NULL, image int(11) unsigned DEFAULT \'0\' NOT NULL, media int(11) unsigned DEFAULT \'0\' NOT NULL, layer int(11) unsigned DEFAULT \'0\' NOT NULL, icon int(11) unsigned DEFAULT \'0\' NOT NULL, map int(11) unsigned DEFAULT \'0\' NOT NULL, latitude double(11,7) DEFAULT \'0.0000000\' NOT NULL, longitude double(11,7) DEFAULT \'0.0000000\' NOT NULL, center int(4) DEFAULT \'0\' NOT NULL, geocode int(4) DEFAULT \'0\' NOT NULL, import_id int(11) DEFAULT \'0\' NOT NULL, KEY import_id (import_id) );', 'CREATE TABLE tx_storefinder_domain_model_attribute ( icon varchar(255) DEFAULT \'\' NOT NULL, name varchar(255) DEFAULT \'\' NOT NULL, description text, css_class varchar(255) DEFAULT \'\' NOT NULL, import_id int(11) DEFAULT \'0\' NOT NULL, KEY import_id (import_id) );', 'CREATE TABLE tx_storefinder_location_attribute_mm ( uid_local int(11) DEFAULT \'0\' NOT NULL, uid_foreign int(11) DEFAULT \'0\' NOT NULL, sorting int(11) unsigned DEFAULT \'0\' NOT NULL, sorting_foreign int(11) unsigned DEFAULT \'0\' NOT NULL, tablenames varchar(255) DEFAULT \'\' NOT NULL, fieldname varchar(255) DEFAULT \'\' NOT NULL, KEY uid_local (uid_local), KEY uid_foreign (uid_foreign) );', 'CREATE TABLE tx_storefinder_location_location_mm ( uid_local int(11) DEFAULT \'0\' NOT NULL, uid_foreign int(11) DEFAULT \'0\' NOT NULL, sorting int(11) DEFAULT \'0\' NOT NULL, sorting_foreign int(11) unsigned DEFAULT \'0\' NOT NULL, tablenames varchar(255) DEFAULT \'\' NOT NULL, fieldname varchar(255) DEFAULT \'\' NOT NULL, KEY uid_local (uid_local), KEY uid_foreign (uid_foreign) );', 'CREATE TABLE sys_category ( children int(11) unsigned DEFAULT \'0\' NOT NULL, import_id varchar(100) DEFAULT \'\' NOT NULL );', 'CREATE TABLE tx_sfbooks_domain_model_book ( number tinytext NOT NULL, title tinytext NOT NULL, path_segment varchar(2048), subtitle tinytext NOT NULL, author tinytext NOT NULL, isbn tinytext NOT NULL, series int(11) unsigned DEFAULT \'0\' NOT NULL, category int(11) unsigned DEFAULT \'0\' NOT NULL, description text NOT NULL, extras int(11) unsigned DEFAULT \'0\' NOT NULL, cover int(11) unsigned DEFAULT \'0\' NOT NULL, cover_large int(11) unsigned DEFAULT \'0\' NOT NULL, sample_pdf int(11) unsigned DEFAULT \'0\' NOT NULL, year varchar(4) DEFAULT \'\' NOT NULL, location1 int(11) unsigned DEFAULT \'0\' NOT NULL, location2 int(11) unsigned DEFAULT \'0\' NOT NULL, location3 int(11) unsigned DEFAULT \'0\' NOT NULL );', 'CREATE TABLE tx_sfbooks_domain_model_book_author_mm ( uid_local int(11) unsigned DEFAULT \'0\' NOT NULL, uid_foreign int(11) unsigned DEFAULT \'0\' NOT NULL, sorting int(11) unsigned DEFAULT \'0\' NOT NULL, sorting_foreign int(11) unsigned DEFAULT \'0\' NOT NULL, KEY uid_local (uid_local), KEY uid_foreign (uid_foreign) );', 'CREATE TABLE tx_sfbooks_domain_model_author ( lastname tinytext NOT NULL, firstname tinytext NOT NULL, path_segment varchar(2048), description text NOT NULL, books tinytext NOT NULL );', 'CREATE TABLE tx_sfbooks_domain_model_book_series_mm ( uid_local int(11) unsigned DEFAULT \'0\' NOT NULL, uid_foreign int(11) unsigned DEFAULT \'0\' NOT NULL, sorting int(11) unsigned DEFAULT \'0\' NOT NULL, sorting_foreign int(11) unsigned DEFAULT \'0\' NOT NULL, KEY uid_local (uid_local), KEY uid_foreign (uid_foreign) );', 'CREATE TABLE tx_sfbooks_domain_model_series ( title tinytext NOT NULL, path_segment varchar(2048), info text NOT NULL, description text NOT NULL, books tinytext NOT NULL );', 'CREATE TABLE tx_sfbooks_domain_model_book_category_mm ( uid_local int(11) unsigned DEFAULT \'0\' NOT NULL, uid_foreign int(11) unsigned DEFAULT \'0\' NOT NULL, sorting int(11) unsigned DEFAULT \'0\' NOT NULL, sorting_foreign int(11) unsigned DEFAULT \'0\' NOT NULL, KEY uid_local (uid_local), KEY uid_foreign (uid_foreign) );', 'CREATE TABLE tx_sfbooks_domain_model_category ( title tinytext NOT NULL, path_segment varchar(2048), parent int(11) unsigned DEFAULT \'0\' NOT NULL, children int(11) unsigned DEFAULT \'0\' NOT NULL, description text NOT NULL, books tinytext NOT NULL );', 'CREATE TABLE tx_sfbooks_domain_model_extras ( parent int(11) DEFAULT \'0\' NOT NULL, type int(11) DEFAULT \'0\' NOT NULL, label int(11) unsigned DEFAULT \'0\' NOT NULL, content text NOT NULL );', 'CREATE TABLE tx_sfbooks_domain_model_extraslabels ( label tinytext NOT NULL );', 'CREATE TABLE cache_hash ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) DEFAULT \'\' NOT NULL, expires int(11) unsigned DEFAULT \'0\' NOT NULL, content longblob, PRIMARY KEY (id), KEY cache_id (identifier(180),expires) ) ENGINE=InnoDB;', 'CREATE TABLE cache_hash_tags ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) DEFAULT \'\' NOT NULL, tag varchar(250) DEFAULT \'\' NOT NULL, PRIMARY KEY (id), KEY cache_id (identifier(191)), KEY cache_tag (tag(191)) ) ENGINE=InnoDB;', 'CREATE TABLE cache_pages ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) DEFAULT \'\' NOT NULL, expires int(11) unsigned DEFAULT \'0\' NOT NULL, content longblob, PRIMARY KEY (id), KEY cache_id (identifier(180),expires) ) ENGINE=InnoDB;', 'CREATE TABLE cache_pages_tags ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) DEFAULT \'\' NOT NULL, tag varchar(250) DEFAULT \'\' NOT NULL, PRIMARY KEY (id), KEY cache_id (identifier(191)), KEY cache_tag (tag(191)) ) ENGINE=InnoDB;', 'CREATE TABLE cache_rootline ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) DEFAULT \'\' NOT NULL, expires int(11) unsigned DEFAULT \'0\' NOT NULL, content longblob, PRIMARY KEY (id), KEY cache_id (identifier(180),expires) ) ENGINE=InnoDB;', 'CREATE TABLE cache_rootline_tags ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) DEFAULT \'\' NOT NULL, tag varchar(250) DEFAULT \'\' NOT NULL, PRIMARY KEY (id), KEY cache_id (identifier(191)), KEY cache_tag (tag(191)) ) ENGINE=InnoDB;', 'CREATE TABLE cache_store_finder_coordinate_cache ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) DEFAULT \'\' NOT NULL, expires int(11) unsigned DEFAULT \'0\' NOT NULL, content longblob, PRIMARY KEY (id), KEY cache_id (identifier(180),expires) ) ENGINE=InnoDB;', 'CREATE TABLE cache_store_finder_coordinate_cache_tags ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) DEFAULT \'\' NOT NULL, tag varchar(250) DEFAULT \'\' NOT NULL, PRIMARY KEY (id), KEY cache_id (identifier(191)), KEY cache_tag (tag(191)) ) ENGINE=InnoDB;', 'CREATE TABLE cache_store_finder_middleware_cache ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) DEFAULT \'\' NOT NULL, expires int(11) unsigned DEFAULT \'0\' NOT NULL, content longblob, PRIMARY KEY (id), KEY cache_id (identifier(180),expires) ) ENGINE=InnoDB;', 'CREATE TABLE cache_store_finder_middleware_cache_tags ( id int(11) unsigned NOT NULL auto_increment, identifier varchar(250) DEFAULT \'\' NOT NULL, tag varchar(250) DEFAULT \'\' NOT NULL, PRIMARY KEY (id), KEY cache_id (identifier(191)), KEY cache_tag (tag(191)) ) ENGINE=InnoDB;')
)
in /var/www/html/vendor/typo3/cms-install/Classes/Service/SetupDatabaseService.php
line 525
$sqlReader = $container->get(SqlReader::class);
$sqlCode = $sqlReader->getTablesDefinitionString(true);
$createTableStatements = $sqlReader->getCreateTableStatementArray($sqlCode);
$results = $this->schemaMigrator->install($createTableStatements);
// Only keep statements with error messages
$results = array_filter($results);
if (count($results) === 0) {
at TYPO3\CMS\Install\Service\SetupDatabaseService
->
importDatabaseData
(
)
in /var/www/html/vendor/typo3/cms-install/Classes/Controller/InstallerController.php
line 559
if (!empty($postValues['sitename'])) {
$this->setupService->setSiteName($postValues['sitename']);
}
try {
$messages = $this->setupDatabaseService->importDatabaseData();
if (!empty($messages)) {
return new JsonResponse([
'success' =>false,
'status' =>$messages,
at TYPO3\CMS\Install\Controller\InstallerController
->
executeDatabaseDataAction
(
object
(TYPO3\CMS\Core\Http\ServerRequest)
)
in /var/www/html/vendor/typo3/cms-install/Classes/Middleware/Installer.php
line 110
1505687700
);
}
$response = $controller->$action($request);
if ($actionName === 'executeDefaultConfiguration') {
// Executing last step cleans session
$this->sessionService->destroySession($request);
at TYPO3\CMS\Install\Middleware\Installer
->
process
(
object
(TYPO3\CMS\Core\Http\ServerRequest), object
(Psr\Http\Server\RequestHandlerInterface@anonymous /var/www/html/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php:128$98)
)
in /var/www/html/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php
line 162
if (!$middleware instanceof MiddlewareInterface) {
throw new \InvalidArgumentException(get_class($middleware) . ' does not implement ' . MiddlewareInterface::class, 1516821342);
}
return $middleware->process($request, $this->next);
}
};
}
}
at Psr\Http\Server\RequestHandlerInterface@anonymous /var/www/html/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php:128$98
->
handle
(
object
(TYPO3\CMS\Core\Http\ServerRequest)
)
in /var/www/html/vendor/typo3/cms-install/Classes/Middleware/Maintenance.php
line 84
*/
public function process(ServerRequestInterface $request, RequestHandlerInterface $handler): ResponseInterface
{
if (!$this->canHandleRequest()) {
return $handler->handle($request);
}
if (($GLOBALS['TYPO3_CONF_VARS']['BE']['installToolPassword'] ?? '') === '') {
return new HtmlResponse('$GLOBALS[\'TYPO3_CONF_VARS\'][\'BE\'][\'installToolPassword\'] must not be empty.', 500);
at TYPO3\CMS\Install\Middleware\Maintenance
->
process
(
object
(TYPO3\CMS\Core\Http\ServerRequest), object
(Psr\Http\Server\RequestHandlerInterface@anonymous /var/www/html/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php:128$98)
)
in /var/www/html/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php
line 111
}
public function handle(ServerRequestInterface $request): ResponseInterface
{
return $this->middleware->process($request, $this->next);
}
};
}
at Psr\Http\Server\RequestHandlerInterface@anonymous /var/www/html/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php:93$97
->
handle
(
object
(TYPO3\CMS\Core\Http\ServerRequest)
)
in /var/www/html/vendor/typo3/cms-core/Classes/Middleware/NormalizedParamsAttribute.php
line 44
$normalizedParams = $request->getAttribute('normalizedParams', null);
if ($normalizedParams === null) {
$request = $request->withAttribute('normalizedParams', NormalizedParams::createFromRequest($request));
}
return $handler->handle($request);
}
}
at TYPO3\CMS\Core\Middleware\NormalizedParamsAttribute
->
process
(
object
(TYPO3\CMS\Core\Http\ServerRequest), object
(Psr\Http\Server\RequestHandlerInterface@anonymous /var/www/html/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php:93$97)
)
in /var/www/html/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php
line 162
if (!$middleware instanceof MiddlewareInterface) {
throw new \InvalidArgumentException(get_class($middleware) . ' does not implement ' . MiddlewareInterface::class, 1516821342);
}
return $middleware->process($request, $this->next);
}
};
}
}
at Psr\Http\Server\RequestHandlerInterface@anonymous /var/www/html/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php:128$98
->
handle
(
object
(TYPO3\CMS\Core\Http\ServerRequest)
)
in /var/www/html/vendor/typo3/cms-core/Classes/Http/MiddlewareDispatcher.php
line 70
* Invoke the middleware stack
*/
public function handle(ServerRequestInterface $request): ResponseInterface
{
return $this->tip->handle($request);
}
/**
* Seed the middleware stack with the inner request handler
at TYPO3\CMS\Core\Http\MiddlewareDispatcher
->
handle
(
object
(TYPO3\CMS\Core\Http\ServerRequest)
)
in /var/www/html/vendor/typo3/cms-core/Classes/Http/AbstractApplication.php
line 80
public function handle(ServerRequestInterface $request): ResponseInterface
{
try {
$response = $this->requestHandler->handle($request);
} catch (ImmediateResponseException $exception) {
$response = $exception->getResponse();
}
return $response;
at TYPO3\CMS\Core\Http\AbstractApplication
->
handle
(
object
(TYPO3\CMS\Core\Http\ServerRequest)
)
in /var/www/html/vendor/typo3/cms-install/Classes/Http/Application.php
line 46
public function handle(ServerRequestInterface $request): ResponseInterface
{
$this->initializeContext();
$request = $request->withAttribute('applicationType', SystemEnvironmentBuilder::REQUESTTYPE_INSTALL);
return parent::handle($request)
->withHeader('X-Frame-Options', 'SAMEORIGIN');
}
/**
at TYPO3\CMS\Install\Http\Application
->
handle
(
object
(TYPO3\CMS\Core\Http\ServerRequest)
)
in /var/www/html/vendor/typo3/cms-core/Classes/Http/AbstractApplication.php
line 92
* Set up the application and shut it down afterwards
*/
final public function run()
{
$response = $this->handle(ServerRequestFactory::fromGlobals());
$this->sendResponse($response);
}
}
at TYPO3\CMS\Core\Http\AbstractApplication
->
run
(
)
in /var/www/html/public/typo3/install.php
line 19
call_user_func(static function () {
$classLoader = require dirname(dirname(__DIR__)).'/vendor/autoload.php';
\TYPO3\CMS\Core\Core\SystemEnvironmentBuilder::run(1);
\TYPO3\CMS\Core\Core\Bootstrap::init($classLoader, true)->get(\TYPO3\CMS\Install\Http\Application::class)->run();
});
at
{closure}
(
)
in /var/www/html/public/typo3/install.php
line 20
call_user_func(static function () {
$classLoader = require dirname(dirname(__DIR__)).'/vendor/autoload.php';
\TYPO3\CMS\Core\Core\SystemEnvironmentBuilder::run(1);
\TYPO3\CMS\Core\Core\Bootstrap::init($classLoader, true)->get(\TYPO3\CMS\Install\Http\Application::class)->run();
});