aboutsummaryrefslogtreecommitdiffstatshomepage
diff options
context:
space:
mode:
authorDiva Canto2011-06-01 20:19:22 -0700
committerDiva Canto2011-06-01 20:19:22 -0700
commitc13acdf5a1a94df9b0ef50b7b2739a9256656582 (patch)
tree0c43fb1631d08591453ef07d235cebc432d3e6b4
parentIt looks like there's a better solution for that problem. (diff)
downloadopensim-SC_OLD-c13acdf5a1a94df9b0ef50b7b2739a9256656582.zip
opensim-SC_OLD-c13acdf5a1a94df9b0ef50b7b2739a9256656582.tar.gz
opensim-SC_OLD-c13acdf5a1a94df9b0ef50b7b2739a9256656582.tar.bz2
opensim-SC_OLD-c13acdf5a1a94df9b0ef50b7b2739a9256656582.tar.xz
This is the better solution: make the combined key be only on the first 36 characters of each field -- that's the UUIDs. Thanks coyled. WARNING: Again, people who have gone through this migration and failed need to run it manually.
-rw-r--r--OpenSim/Data/MySQL/Resources/FriendsStore.migrations3
1 files changed, 2 insertions, 1 deletions
diff --git a/OpenSim/Data/MySQL/Resources/FriendsStore.migrations b/OpenSim/Data/MySQL/Resources/FriendsStore.migrations
index 35e5e93..7848e49 100644
--- a/OpenSim/Data/MySQL/Resources/FriendsStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/FriendsStore.migrations
@@ -25,7 +25,8 @@ COMMIT;
25 25
26BEGIN; 26BEGIN;
27 27
28ALTER TABLE `Friends` DROP PRIMARY KEY;
29ALTER TABLE `Friends` ADD PRIMARY KEY(PrincipalID(36), Friend(36));
28ALTER TABLE `Friends` MODIFY COLUMN PrincipalID varchar(255) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; 30ALTER TABLE `Friends` MODIFY COLUMN PrincipalID varchar(255) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';
29 31
30COMMIT; 32COMMIT;
31