[Dbmail-dev] [PATCH] mysql innodb migration fix from 1.x to 2.0

[Eric Wong]

diff -ruNp dbmail-2.0rc7/sql/mysql/migrate_from_1.x_to_2.0_innodb.mysql 
dbmail-2.0rc7.b/sql/mysql/migrate_from_1.x_to_2.0_innodb.mysql
--- dbmail-2.0rc7/sql/mysql/migrate_from_1.x_to_2.0_innodb.mysql        
2004-06-11 02:04:05.000000000 -0700
+++ dbmail-2.0rc7.b/sql/mysql/migrate_from_1.x_to_2.0_innodb.mysql      
2004-07-27 19:20:26.000000000 -0700
@@ -110,7 +110,7 @@ CREATE TABLE subscription (
        FOREIGN KEY (`user_id`) 
                REFERENCES `users` (`user_idnr`) ON DELETE CASCADE,
        FOREIGN KEY (`mailbox_id`) 
-               REFERENCES `mailboxes` (`mailbox_idnr`) ON DELETE CASCADE,
+               REFERENCES `mailboxes` (`mailbox_idnr`) ON DELETE CASCADE
        
 ) TYPE=InnoDB;
 

-- 
Eric Wong

signature.asc
Description: Digital signature