aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources
diff options
context:
space:
mode:
authorDiva Canto2011-06-01 20:09:59 -0700
committerDiva Canto2011-06-01 20:09:59 -0700
commit43ecc46a224d07661af42379f12f394e1bd873fd (patch)
tree366e1f63d0c5503a57981fa08f3213725f88be31 /OpenSim/Data/MySQL/Resources
parentChanged Friends table to have 165-sized varchars on PrincipalID and FriendID.... (diff)
downloadopensim-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 'OpenSim/Data/MySQL/Resources')
-rw-r--r--OpenSim/Data/MySQL/Resources/FriendsStore.migrations3
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
26BEGIN; 26BEGIN;
27 27
28ALTER TABLE `Friends` MODIFY COLUMN PrincipalID varchar(165) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; 28ALTER TABLE `Friends` MODIFY COLUMN PrincipalID varchar(255) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';
29ALTER TABLE `Friends` MODIFY COLUMN Friend varchar(165) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';
30 29
31COMMIT; 30COMMIT;
32 31