diff options
| author | Diva Canto | 2011-06-01 20:19:22 -0700 |
|---|---|---|
| committer | Diva Canto | 2011-06-01 20:19:22 -0700 |
| commit | c13acdf5a1a94df9b0ef50b7b2739a9256656582 (patch) | |
| tree | 0c43fb1631d08591453ef07d235cebc432d3e6b4 | |
| parent | It looks like there's a better solution for that problem. (diff) | |
| download | opensim-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.migrations | 3 |
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 | ||
| 26 | BEGIN; | 26 | BEGIN; |
| 27 | 27 | ||
| 28 | ALTER TABLE `Friends` DROP PRIMARY KEY; | ||
| 29 | ALTER TABLE `Friends` ADD PRIMARY KEY(PrincipalID(36), Friend(36)); | ||
| 28 | ALTER TABLE `Friends` MODIFY COLUMN PrincipalID varchar(255) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; | 30 | ALTER TABLE `Friends` MODIFY COLUMN PrincipalID varchar(255) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; |
| 29 | 31 | ||
| 30 | COMMIT; | 32 | COMMIT; |
| 31 | |||