Adding a field completely manually

Hello - we have a unique situation where we are unable to run repair and rebuild on our current CRM. I am in the process of fixing this. However, in the meantime, I am needing to “manually” add a field to the leads_cstm table.

I would assume I would need to perform the following steps:

  • add the field manually to the mysql db table leads_cstm.
  • add the field manually to the fields_meta_data table.
  • add the field name and properties to both the vardefs files (the one that says do not touch it will auto-generate and the other one).

Is there anything I am missing here? I am assuming that once I perform the above steps, the new field would be available to me as well as future proof it for when I can run repair and rebuild again. Am I correct or is there a step I have missed?


If it’s not too hard for you to rehearse this in a separate system, like a test installation, or even a new one set up just for this purpose… then that would be a great way of doing things: do it in Studio, copy-paste the SQL it generates… use git on the source tree to catch any other changes. And check the fields_metadata manually.