Issue Bug Closed

#63599Fresh TYPO3 7.0.0 install - Install tool - analyze database

Riccardo De Contardi 12/05/14, 11:49 updated 08/18/15, 12:33

Description

Is it normal that after a fresh install of TYPO3 7.0.0 (I repeat: fresh, it means a completely new installation, without any distribution or package, no pages created, no filemount created, no typoscript template created, just the admin be-user created, with any extension installed apart from scheduler, linkvalidator and recycler), if I open the install tool and run the Analyze Database, I already have a lot of fixes that must be done on the db?

ALTER TABLE sys_file_processedfile DROP KEY combined_1;

ALTER TABLE sys_file_processedfile ADD KEY combined_1 (original,task_type,configurationsha1);

ALTER TABLE sys_file_processedfile DROP KEY identifier;

ALTER TABLE sys_file_processedfile ADD KEY identifier (storage,identifier(199));

ALTER TABLE sys_history DROP KEY recordident_1;

ALTER TABLE sys_history ADD KEY recordident_1 (tablename,recuid);

ALTER TABLE sys_history DROP KEY recordident_2;

ALTER TABLE sys_history ADD KEY recordident_2 (tablename,tstamp);

ALTER TABLE sys_refindex DROP KEY lookup_rec;

ALTER TABLE sys_refindex ADD KEY lookup_rec (tablename,recuid);

ALTER TABLE sys_refindex DROP KEY lookup_uid;

ALTER TABLE sys_refindex ADD KEY lookup_uid (ref_table,ref_uid);

ALTER TABLE sys_refindex DROP KEY lookup_string;

ALTER TABLE sys_refindex ADD KEY lookup_string (ref_string);

ALTER TABLE sys_category_record_mm DROP KEY uid_foreign_tablenames;

ALTER TABLE sys_category_record_mm ADD KEY uid_foreign_tablenames (uid_foreign,tablenames);

ALTER TABLE sys_domain DROP KEY getSysDomain;

ALTER TABLE sys_domain ADD KEY getSysDomain (redirectTo,hidden);

ALTER TABLE cf_cache_hash DROP KEY cache_id;

ALTER TABLE cf_cache_hash ADD KEY cache_id (identifier,expires);

ALTER TABLE cf_cache_hash_tags DROP KEY cache_id;

ALTER TABLE cf_cache_hash_tags ADD KEY cache_id (identifier);

ALTER TABLE cf_cache_hash_tags DROP KEY cache_tag;

ALTER TABLE cf_cache_hash_tags ADD KEY cache_tag (tag);

ALTER TABLE cf_cache_pages DROP KEY cache_id;

ALTER TABLE cf_cache_pages ADD KEY cache_id (identifier,expires);

ALTER TABLE cf_cache_pages_tags DROP KEY cache_id;

ALTER TABLE cf_cache_pages_tags ADD KEY cache_id (identifier);

ALTER TABLE cf_cache_pages_tags DROP KEY cache_tag;

ALTER TABLE cf_cache_pages_tags ADD KEY cache_tag (tag);

ALTER TABLE cf_cache_pagesection DROP KEY cache_id;

ALTER TABLE cf_cache_pagesection ADD KEY cache_id (identifier,expires);

ALTER TABLE cf_cache_pagesection_tags DROP KEY cache_id;

ALTER TABLE cf_cache_pagesection_tags ADD KEY cache_id (identifier);

ALTER TABLE cf_cache_pagesection_tags DROP KEY cache_tag;

ALTER TABLE cf_cache_pagesection_tags ADD KEY cache_tag (tag);

ALTER TABLE cf_cache_rootline DROP KEY cache_id;

ALTER TABLE cf_cache_rootline ADD KEY cache_id (identifier,expires);

ALTER TABLE cf_cache_rootline_tags DROP KEY cache_id;

ALTER TABLE cf_cache_rootline_tags ADD KEY cache_id (identifier);

ALTER TABLE cf_cache_rootline_tags DROP KEY cache_tag;

ALTER TABLE cf_cache_rootline_tags ADD KEY cache_tag (tag);

ALTER TABLE cf_extbase_reflection DROP KEY cache_id;

ALTER TABLE cf_extbase_reflection ADD KEY cache_id (identifier,expires);

ALTER TABLE cf_extbase_reflection_tags DROP KEY cache_id;

ALTER TABLE cf_extbase_reflection_tags ADD KEY cache_id (identifier);

ALTER TABLE cf_extbase_reflection_tags DROP KEY cache_tag;

ALTER TABLE cf_extbase_reflection_tags ADD KEY cache_tag (tag);

ALTER TABLE cf_extbase_typo3dbbackend_tablecolumns DROP KEY cache_id;

ALTER TABLE cf_extbase_typo3dbbackend_tablecolumns ADD KEY cache_id (identifier,expires);

ALTER TABLE cf_extbase_typo3dbbackend_tablecolumns_tags DROP KEY cache_id;

ALTER TABLE cf_extbase_typo3dbbackend_tablecolumns_tags ADD KEY cache_id (identifier);

ALTER TABLE cf_extbase_typo3dbbackend_tablecolumns_tags DROP KEY cache_tag;

ALTER TABLE cf_extbase_typo3dbbackend_tablecolumns_tags ADD KEY cache_tag (tag);

ALTER TABLE cf_extbase_typo3dbbackend_queries DROP KEY cache_id;

ALTER TABLE cf_extbase_typo3dbbackend_queries ADD KEY cache_id (identifier,expires);

ALTER TABLE cf_extbase_typo3dbbackend_queries_tags DROP KEY cache_id;

ALTER TABLE cf_extbase_typo3dbbackend_queries_tags ADD KEY cache_id (identifier);

ALTER TABLE cf_extbase_typo3dbbackend_queries_tags DROP KEY cache_tag;

ALTER TABLE cf_extbase_typo3dbbackend_queries_tags ADD KEY cache_tag (tag);

ALTER TABLE cf_extbase_datamapfactory_datamap DROP KEY cache_id;

ALTER TABLE cf_extbase_datamapfactory_datamap ADD KEY cache_id (identifier,expires);

ALTER TABLE cf_extbase_datamapfactory_datamap_tags DROP KEY cache_id;

ALTER TABLE cf_extbase_datamapfactory_datamap_tags ADD KEY cache_id (identifier);

ALTER TABLE cf_extbase_datamapfactory_datamap_tags DROP KEY cache_tag;

ALTER TABLE cf_extbase_datamapfactory_datamap_tags ADD KEY cache_tag (tag);

ALTER TABLE cf_extbase_object DROP KEY cache_id;

ALTER TABLE cf_extbase_object ADD KEY cache_id (identifier,expires);

ALTER TABLE cf_extbase_object_tags DROP KEY cache_id;

ALTER TABLE cf_extbase_object_tags ADD KEY cache_id (identifier);

ALTER TABLE cf_extbase_object_tags DROP KEY cache_tag;

ALTER TABLE cf_extbase_object_tags ADD KEY cache_tag (tag);

Reviews 0

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