Project

General

Profile

Actions
Copy link

Bug #63599

closed

Fresh TYPO3 7.0.0 install - Install tool - analyze database

Added by Riccardo De Contardi almost 10 years ago. Updated over 9 years ago.

Status:
Closed
Priority:
Must have
Assignee:
Mathias Schreiber
Category:
Install Tool
Target version:
7.1 (Cleanup)
Start date:
2014-12-05
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
7
PHP Version:
5.5
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

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);

Files

Download all files
Cattura_MAC.tiff (105 KB) Cattura_MAC.tiff Riccardo De Contardi, 2015-01-12 15:14
Cattura_WINDOWS.PNG (33.4 KB) Cattura_WINDOWS.PNG Riccardo De Contardi, 2015-01-12 15:14
cattura_MAC_fromphpmyadmin.tiff (103 KB) cattura_MAC_fromphpmyadmin.tiff Riccardo De Contardi, 2015-01-12 16:22

Related issues 1 (0 open — 1 closed)

Has duplicate TYPO3 Core - Bug #38932: EM creates INDEX with space after the commas again and againClosed2012-07-13

Actions
Actions
Copy link

Also available in: Atom PDF