From d99277939750247ad100395394720c73a3580c72 Mon Sep 17 00:00:00 2001
From: Diva Canto
Date: Sat, 11 Jun 2011 09:36:57 -0700
Subject: Switched order of SQL statements in Friends migration -- resulted in
 the wrong key

---
 OpenSim/Data/MySQL/Resources/FriendsStore.migrations | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'OpenSim')

diff --git a/OpenSim/Data/MySQL/Resources/FriendsStore.migrations b/OpenSim/Data/MySQL/Resources/FriendsStore.migrations
index 7848e49..55d82ec 100644
--- a/OpenSim/Data/MySQL/Resources/FriendsStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/FriendsStore.migrations
@@ -25,8 +25,8 @@ COMMIT;
 
 BEGIN;
 
+ALTER TABLE `Friends` MODIFY COLUMN PrincipalID varchar(255) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';
 ALTER TABLE `Friends` DROP PRIMARY KEY;
 ALTER TABLE `Friends` ADD PRIMARY KEY(PrincipalID(36), Friend(36));
-ALTER TABLE `Friends` MODIFY COLUMN PrincipalID varchar(255) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';
 
 COMMIT;
-- 
cgit v1.1