diff options
author | Diva Canto | 2011-06-01 20:09:59 -0700 |
---|---|---|
committer | Diva Canto | 2011-06-01 20:09:59 -0700 |
commit | 43ecc46a224d07661af42379f12f394e1bd873fd (patch) | |
tree | 366e1f63d0c5503a57981fa08f3213725f88be31 /OpenSim/Data/MySQL/Resources | |
parent | Changed Friends table to have 165-sized varchars on PrincipalID and FriendID.... (diff) | |
download | opensim-SC_OLD-43ecc46a224d07661af42379f12f394e1bd873fd.zip opensim-SC_OLD-43ecc46a224d07661af42379f12f394e1bd873fd.tar.gz opensim-SC_OLD-43ecc46a224d07661af42379f12f394e1bd873fd.tar.bz2 opensim-SC_OLD-43ecc46a224d07661af42379f12f394e1bd873fd.tar.xz |
It looks like there's a better solution for that problem.
Revert "Changed Friends table to have 165-sized varchars on PrincipalID and FriendID. The reason for this number is the following: there is a combined key of these 2 fields; apparently MySql can't handle keys larger than 1000 bytes; when the table is created with utf8 encoding, this combined key is bigger than 1000 bytes, and the migration fails. WARNING: this is not a new migration! People who have gone through this migration and failed should update the sizes of these fields manually."
This reverts commit 3fa54a156a83e498a7d5d0949a5f848fe82fe86f.
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/FriendsStore.migrations | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/OpenSim/Data/MySQL/Resources/FriendsStore.migrations b/OpenSim/Data/MySQL/Resources/FriendsStore.migrations index 5abacf5..35e5e93 100644 --- a/OpenSim/Data/MySQL/Resources/FriendsStore.migrations +++ b/OpenSim/Data/MySQL/Resources/FriendsStore.migrations | |||
@@ -25,8 +25,7 @@ COMMIT; | |||
25 | 25 | ||
26 | BEGIN; | 26 | BEGIN; |
27 | 27 | ||
28 | ALTER TABLE `Friends` MODIFY COLUMN PrincipalID varchar(165) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; | 28 | ALTER TABLE `Friends` MODIFY COLUMN PrincipalID varchar(255) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; |
29 | ALTER TABLE `Friends` MODIFY COLUMN Friend varchar(165) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; | ||
30 | 29 | ||
31 | COMMIT; | 30 | COMMIT; |
32 | 31 | ||