Prepare db migration.
authorFlorent Bruneau <florent.bruneau@polytechnique.org>
Sat, 20 Feb 2010 14:24:18 +0000 (15:24 +0100)
committerFlorent Bruneau <florent.bruneau@polytechnique.org>
Sat, 20 Feb 2010 20:21:34 +0000 (21:21 +0100)
commit100e66fc8ab2b48621b287d50079558d83187278
tree6cf92a5582fd5fae0432776456bdc25a9710e66f
parentb4816e6f8d43f267a1cfba62ab9d67e5575822e6
Prepare db migration.

Note:
 * migration must not alter the old db, so we should create a new db and a
   user with only read privileges on previous db.
 * migration procedure will contain at least 4 steps:
   1 - copy old tables that will still exist in the new db
   2 - create new tables
   3 - perform data insertion
   4 - remove temporary tables

Signed-off-by: Florent Bruneau <florent.bruneau@polytechnique.org>
21 files changed:
upgrade/account/02_carnet.sql [moved from upgrade/account/03_carnet.sql with 100% similarity]
upgrade/account/02_forums.sql [deleted file]
upgrade/account/03_carva.sql [moved from upgrade/account/04_carva.sql with 100% similarity]
upgrade/account/04_emails.sql [moved from upgrade/account/05_emails.sql with 100% similarity]
upgrade/account/06_logs.sql [deleted file]
upgrade/account/07_payment.sql [deleted file]
upgrade/account/08_groups.sql [deleted file]
upgrade/account/09_photos.sql [deleted file]
upgrade/account/20_naming_convention.sql [new file with mode: 0644]
upgrade/account/99_insertion.sql
upgrade/account/copy_tables.php [new file with mode: 0755]
upgrade/account/upgrade.sh
upgrade/inc/pervasive.sh
upgrade/newdirectory-0.0.1/00_names.sql
upgrade/newdirectory-0.0.1/01_addrcomment.sql [deleted file]
upgrade/newdirectory-0.0.1/02_networking.sql
upgrade/newdirectory-0.0.1/05_nationalities.sql [deleted file]
upgrade/newdirectory-0.0.1/06_education.sql
upgrade/newdirectory-0.0.1/11_jobs.sql
upgrade/newdirectory-0.0.1/13_mentoring.sql
upgrade/newdirectory-0.0.1/15_addresses.sql