Lise table structure
Posted: Fri Dec 01, 2023 2:52 pm
Hello,
During uploads the client published files with endless names containing many spaces and special characters.
Obviously in the worst case the file is not uploaded, but quite often the URL is incorrectly transcribed. As there were a lot of elements in Lise's instance I wanted to process the names (take the first x characters, remove spaces, etc.) automatically with a little code.
In the cms_module_myinstancename_fieldval table I have a value_index field defined as primary key. Unfortunately the value is 0 for each of the records. Would it be problematic to put an auto increment on this column in order to easily loop over all the records for futures versions?
Is this value 0 used anywhere else?
During uploads the client published files with endless names containing many spaces and special characters.
Obviously in the worst case the file is not uploaded, but quite often the URL is incorrectly transcribed. As there were a lot of elements in Lise's instance I wanted to process the names (take the first x characters, remove spaces, etc.) automatically with a little code.
In the cms_module_myinstancename_fieldval table I have a value_index field defined as primary key. Unfortunately the value is 0 for each of the records. Would it be problematic to put an auto increment on this column in order to easily loop over all the records for futures versions?
Is this value 0 used anywhere else?