search

spicecrm / spicecrm_be_release_core

Release Repository for Core Release SpiceCRM Backend
GNU Affero General Public License v3.0
8 stars 5 forks source link

module or module_cstm Table in DB #2

Open sscheuring opened 5 years ago

sscheuring commented 5 years ago

Hi! I know from the "old" Sugar Studio, that adding fields to modules, the data was stored in module_cstm db Table. I added some fields via backend/custom/Extension/modules//Ext/Vardefs/field.php

If i make in backend a Quick Repair, the field's are added to module table and not module_cstm table. Is this a problem for the future (Upgrading)?

Regards, Sebastian

maretval commented 5 years ago

Hi Sebastian, using Studio is not recommended and might be not supported in future anymore. At least the backend interface. Internally data should still be retrieved from defined cstm tables. That's why we customize using clean defined variables as you did in backend/custom/Extension/modules//Ext/Vardefs/field.php Yes, db fields are added to original table. We recommend to use an abbreviation in name fields to allow faster recognition of which fields are custom fields. Example: if you a field "location" name it "my_location" or "sch_location" or whatever you think suits the project. To answer your question: in the future in might be a problem. The Studio backend interface is no longer tested, it therefore might not work anymore. Retrieving data from cstm table is still implemented and shall remain intact. Since we plan to administrate all variables in database and not in file system anymore, I would move away from the studio.

Regards, Val

sscheuring commented 5 years ago

Hi Val! Thx for the fast feedback. I see, we are on the right path.. :) Regards, Sebastian