Got a project coded by a former employee. Using Symfony 1.4 and doctrine. I try to update some MySQL tables, by adding some new columns. Problem is, if I run "symfony doctrine:build-schema" something is wrong with the schema. In origin, the tables have the columns "created_at" and "updated_at". But the original schema does'nt include these columns (Not even a single table!). When I run the command, then all the tables in the schema.yml contain the 2 columns. Problem is, I run into some tuple-update-errors (less an error, more a tough problem) afterwards.
1. How to make the schema automatically without the 2 columns. I think I have read somewhere, that it is not neccessary to put them into the schema, symfony does auto update/set them.
2. May it be, that I run "symfony doctrine:build-model" afterwards? (Does this destroy/overwrite existing and modified Tableclasses in lib/model/doctrine? That would be bad.)
3. Is there a "how to" to update tables as simple as possible without touching any modified files?