[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