I've read the docs and know that once the table is created it skips it, because the table already exists.
However, are we able to handle additional fields using the Custom Table Extension? How should we go about when, as time progresses, there is sometimes a need for extra data/fields to be stored in the same table.
Don't worry, if you update the table structure, the plugin automatically update the structure in the database. So you can add more fields without any problem.
I tried the following:
- Created custom table via UI/interface (so ALL fields are text)
- Changed one field in the DB from text to varchar(10)
- afterwards updated the field (e.g. to put a new field to the custom fields form) Result: ALL formats of all fields are reset now in the DB to text again.
So updating does not to be as safe as you indicate.
Maybe I am missing something?
Can I store the field format somewhere in the UI, so it will be applied correctly (and NOT changed)?
The documentation says nothing in this regards.
Is there an autocheck if I have only 10 chars?
Thanks for your clarification.