[TYPO3-english] Changes in sys_file_reference?

Urs Braem info at ursbraem.ch
Sun Apr 24 17:26:24 CEST 2016


I have a site that was probably installed from scratch with TYPO3 7.6.4 or 7.6.3. 
When I run the database analyzer, it proposes many changes to sys_file_reference:

ALTER TABLE sys_file_reference CHANGE tstamp tstamp int(11) NOT NULL default '0'; 
Current value: int(11) unsigned NOT NULL default '0'
 ALTER TABLE sys_file_reference CHANGE crdate crdate int(11) NOT NULL default '0'; 
Current value: int(11) unsigned NOT NULL default '0'
 ALTER TABLE sys_file_reference CHANGE cruser_id cruser_id int(11) NOT NULL default '0'; 
Current value: int(11) unsigned NOT NULL default '0'
 ALTER TABLE sys_file_reference CHANGE sorting sorting int(10) NOT NULL default '0'; 
Current value: int(11) NOT NULL default '0'
 ALTER TABLE sys_file_reference CHANGE deleted deleted tinyint(4) NOT NULL default '0'; 
Current value: tinyint(4) unsigned NOT NULL default '0'
 ALTER TABLE sys_file_reference CHANGE hidden hidden tinyint(4) NOT NULL default '0'; 
Current value: tinyint(4) unsigned NOT NULL default '0'
 ALTER TABLE sys_file_reference CHANGE t3ver_label t3ver_label varchar(30) NOT NULL default ''; 
Current value: varchar(255) NOT NULL default ''
 ALTER TABLE sys_file_reference CHANGE l10n_diffsource l10n_diffsource mediumblob NOT NULL; 
Current value: mediumblob
 ALTER TABLE sys_file_reference DROP KEY parent;
 ALTER TABLE sys_file_reference ADD KEY parent (pid,deleted);

and

 ALTER TABLE sys_file_reference CHANGE starttime zzz_deleted_starttime int(11) unsigned NOT NULL default '0';
 ALTER TABLE sys_file_reference CHANGE endtime zzz_deleted_endtime int(11) unsigned NOT NULL default '0';
 ALTER TABLE sys_file_reference CHANGE parentid zzz_deleted_parentid int(11) NOT NULL default '0';
 ALTER TABLE sys_file_reference CHANGE parenttable zzz_deleted_parenttable varchar(255) default '';

I tried googling such changes to sys_file_reference, but didn't find anything in the recent releases.

Can you relate to that, should I run these changes?


More information about the TYPO3-english mailing list