Migrations?

[dolugen]

I was getting some database errors today on emit_notices command. Here is the end of the traceback:

...
OperationalError: (1054, "Unknown column 'recipient_id' in 'field list'")

What? The notification model says there is recipient_id (as well as sender_id), but my database have user_id field instead in notification_notice table...

Hmm, my version is 0.2, but my database structure differs. Finally, I checked the model of 0.1 and there it was: user_id.

So, I had to do:

ALTER TABLE  `notification_notice` CHANGE  `user_id`  `recipient_id` INT( 11 ) NOT NULL;
ALTER TABLE  `notification_notice` ADD  `sender_id` INT NULL AFTER  `recipient_id`;

No South migration was supplied for upgrading from 0.1 to 0.2. But I guess everyone is using "fresh" 0.2 install, so no one complained before. I'm just reporting this in case anyone did a late upgrade like I did and had the same trouble.