Project

General

Profile

Actions

Bug #54848

closed

Important Actions - Endless DB-analyser alter table

Added by Thomas Skierlo over 10 years ago. Updated over 8 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Install Tool
Target version:
Start date:
2014-01-08
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
6.2
PHP Version:
5.3
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

TYPO3 6.2.0beta3 (TYPO3.CMS-HEAD-6335a24) - fresh install (no upgrade)

Install tool's db-analyser change fields are shown endless:

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 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_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_workspaces_cache DROP KEY cache_id;
ALTER TABLE cf_workspaces_cache ADD KEY cache_id (identifier,expires);
ALTER TABLE cf_workspaces_cache_tags DROP KEY cache_id;
ALTER TABLE cf_workspaces_cache_tags ADD KEY cache_id (identifier);
ALTER TABLE cf_workspaces_cache_tags DROP KEY cache_tag;
ALTER TABLE cf_workspaces_cache_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); 

After first run db fields are changed, but message to change field is shown again (endless).

Actions

Also available in: Atom PDF