Single file version available here.
Last updated on 2008-05-28.
To discuss, comment here.
| Prev | Next | |
| Home |
http://www.symfony-project.org/forum/index.php?t=msg&th=9439
I used to use the following code when I update my schema.
symfony propel-build-model symfony propel-build-sql symfony propel-insert-sql
But now the system is in beta phase, with tables filled with data and the user requesting to add extra fields to one table.
How should I tackle that?
> But now the system is in beta phase, with tables filled with data and the user requesting to add extra fields to one table.
Do not use 'symfony propel-insert-sql'. It will clear all existing data in the database.
From http://www.symfony-project.org/book/1_0/08-Inside-the-Model-Layer
Do up to:
symfony propel-build-sql
It will generate a SQL-DDL that creates the database tables from the schema.yml data model. The created file is myproject/data/sql/lib.model.schema.sql.
That's all symfony needs to know about the data model. You can then either use the schema.sql file directly to build the tables, or manually update a single table def in database. For instance, in MySQL, type this:
mysql -u root -p blog < striped.schema.updated.sql
documented on: 29 October 2007, sfxpt
| Prev | Next | |
| Home |