SQL code to create custom fields

Dear Tuan,

When we install the membership pro component, it automatically creates a number of custom fields...

I am trying to make a plugin that creates / deletes custom fields as part of the installation and uninstall process..

Can you point me to the right area ?

The custom fields are stored in #__osmembership_fields table. So I guess somehow, you will have to insert data into that table manually

Not sure if it gives you the information? Or you want to know something else?

Tuan

Thanks Tuan,

I am guessing they get populated as part of install.sql script or something. I just wanted to look at that and maybe copy it for the ones that I want to install

Yes. It is included in administrator/components/com_osmembership/sql/fields.osmembership.sql file. And during the install/upgrade process, we check and if there are no fields in the table, execute that script to insert these default fields.

Something like that

Regards,

Tuan