At the moment it looks like we won't have many changes to the DB schema that would justify the complexity of this task. I'd propose we drastically reduce the complexity of this task (to 5), add comments comments here if we make changes to the DB and how to (manually) incorporate those changes into an existing database.
Fundraising Store 2.0: Changed date fields in donation and added a subscription table. Removed GUID from membership table.
Migration SQL can be generated with the command
Tested the migration on in the test database with all the data. Took 8 minutes, but had no errors:
mysql> ALTER TABLE spenden CHANGE dt_new dt_new DATETIME NOT NULL; Query OK, 1765420 rows affected (7 min 27.92 sec) Records: 1765420 Duplicates: 0 Warnings: 0 mysql> ALTER TABLE request DROP type, DROP guid, CHANGE timestamp timestamp DATETIME NOT NULL, CHANGE dob dob DATE DEFAULT NULL; Query OK, 17801 rows affected (0.48 sec) Records: 17801 Duplicates: 0 Warnings: 0