Bulk Insert Fields into cms_accounts table

Ok, so I installed the developer console plugin and found I can easily add additional fields using this code in the MYSQL Console:

ALTER TABLE `cmsb_accounts`
ADD COLUMN stage_1 MEDIUMTEXT,
ADD COLUMN stage_2 MEDIUMTEXT,
ADD COLUMN stage_3 MEDIUMTEXT,
ADD COLUMN stage_4 MEDIUMTEXT;

However I would also like to be able to specify the content for "Field Label" and "Field Type" for these new columns too... (field labels would be same as field names and all field types would be "textfield")

If someone can give me a few pointers on how to do this it would be much appreciated as my mysql skills are quite limited.

Hi dm,

If you're comfortable working with multidimensional arrays, you could work directly with the schema ini file for the accounts table. CMSB has an internal function that creates "missing" table fields from the schema ini php files. So potentially you could add new field arrays to the ini php file, upload the modified file, then go to the section editors admin menu and it will automatically create the new fields.

Just make sure to download the current file(s) from the server before making any changes, and always make backups of your files and database.

You may find this method a little bit faster if you're simply adding a bunch of common text fields. However, the field types do have different array structures so be mindful of that.

If you are planning on adding a bunch of different field types then you're better off just creating them directly through the cms admin using the standard add field process. There's also a "quick add field" feature so you could rapidly create a series of fields. That way you know they're being created properly, and it's likely a faster process anyway. 

Hope this info helps.

Best,
Steve

Hi Steve, thanks very much for suggestion!

I will investigate the schema files. :)