[TYPO3-dam-devel] RFC: file_path dam/ext_tables.sql

[Peter Kuehn [wmdb]]

Hi yall,

the repository version defines the field tx_dam.file_path as

   file_path varchar(255) DEFAULT '' NOT NULL,
   [...]
   KEY file_path (file_path)

somewhere in the process weve decided to change the fielddefinition to

   file_path text NOT NULL,

and to *remove* the KEY same time.

if you now upgrade from 1.0.11 to latest sources the
   ALTER TABLE tx_dam CHANGE file_path file_path text NOT NULL;
statement in the extension manager is not executed due to an
   BLOB/TEXT column 'file_path' used in key specification
   without a key length
error *without any notice or message*.

I think mostly noone will recognise the change that way.

please discuss how to fix this:
- keep the old field definition or
- keep the key

gRTz
pekue