From b5de2a1f90c0ac6b16ca372c7e55e8277996182b Mon Sep 17 00:00:00 2001 From: vbenincasa <vbenincasa@gmail.com> Date: Sun, 07 Mar 2010 14:13:01 -0500 Subject: [PATCH] - Update pt_BR translation --- SQL/mysql.update.sql | 18 ++++++++++++------ 1 files changed, 12 insertions(+), 6 deletions(-) diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql index 5ad03d4..8d86867 100644 --- a/SQL/mysql.update.sql +++ b/SQL/mysql.update.sql @@ -61,7 +61,7 @@ -- Updates from version 0.3.1 /* MySQL bug workaround: http://bugs.mysql.com/bug.php?id=46293 */ -/*!40014 SET FOREIGN_KEY_CHECKS=0; */ +/*!40014 SET FOREIGN_KEY_CHECKS=0 */; ALTER TABLE `messages` DROP FOREIGN KEY `user_id_fk_messages`; ALTER TABLE `cache` DROP FOREIGN KEY `user_id_fk_cache`; @@ -69,12 +69,18 @@ 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`) /*!40008 ON DELETE CASCADE ON UPDATE CASCADE */; + REFERENCES `users`(`user_id`); ALTER TABLE `cache` ADD CONSTRAINT `user_id_fk_cache` FOREIGN KEY (`user_id`) - REFERENCES `users`(`user_id`) /*!40008 ON DELETE CASCADE ON UPDATE CASCADE */; + REFERENCES `users`(`user_id`); ALTER TABLE `contacts` ADD CONSTRAINT `user_id_fk_contacts` FOREIGN KEY (`user_id`) - REFERENCES `users`(`user_id`) /*!40008 ON DELETE CASCADE ON UPDATE CASCADE */; + REFERENCES `users`(`user_id`); ALTER TABLE `identities` ADD CONSTRAINT `user_id_fk_identities` FOREIGN KEY (`user_id`) - REFERENCES `users`(`user_id`) /*!40008 ON DELETE CASCADE ON UPDATE CASCADE */; + REFERENCES `users`(`user_id`); -/*!40014 SET FOREIGN_KEY_CHECKS=1; */ +ALTER TABLE `contacts` ALTER `name` SET DEFAULT ''; +ALTER TABLE `contacts` ALTER `firstname` SET DEFAULT ''; +ALTER TABLE `contacts` ALTER `surname` SET DEFAULT ''; + +ALTER TABLE `identities` INDEX `user_identities_index` (`user_id`, `del`); + +/*!40014 SET FOREIGN_KEY_CHECKS=1 */; -- Gitblit v1.9.1