[Svn] r3751 - trunk/roundcubemail/SQL

trac at roundcube.net trac at roundcube.net
Mon Jun 14 20:56:52 CEST 2010


Author: alec
Date: 2010-06-14 13:56:52 -0500 (Mon, 14 Jun 2010)
New Revision: 3751

Modified:
   trunk/roundcubemail/SQL/mysql.update.sql
Log:
- fix foreign keys defs unintentionally broken in r3333


Modified: trunk/roundcubemail/SQL/mysql.update.sql
===================================================================
--- trunk/roundcubemail/SQL/mysql.update.sql	2010-06-14 11:36:02 UTC (rev 3750)
+++ trunk/roundcubemail/SQL/mysql.update.sql	2010-06-14 18:56:52 UTC (rev 3751)
@@ -69,13 +69,13 @@
 ALTER TABLE `identities` DROP FOREIGN KEY `user_id_fk_identities`;
 
 ALTER TABLE `messages` ADD CONSTRAINT `user_id_fk_messages` FOREIGN KEY (`user_id`)
- REFERENCES `users`(`user_id`);
+ REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE `cache` ADD CONSTRAINT `user_id_fk_cache` FOREIGN KEY (`user_id`)
- REFERENCES `users`(`user_id`);
+ REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE `contacts` ADD CONSTRAINT `user_id_fk_contacts` FOREIGN KEY (`user_id`)
- REFERENCES `users`(`user_id`);
+ REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE `identities` ADD CONSTRAINT `user_id_fk_identities` FOREIGN KEY (`user_id`)
- REFERENCES `users`(`user_id`);
+ REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
 
 ALTER TABLE `contacts` ALTER `name` SET DEFAULT '';
 ALTER TABLE `contacts` ALTER `firstname` SET DEFAULT '';

_______________________________________________
http://lists.roundcube.net/mailman/listinfo/svn



More information about the Svn mailing list