aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/FriendsStore.migrations
diff options
context:
space:
mode:
authorDiva Canto2011-06-01 20:02:26 -0700
committerDiva Canto2011-06-01 20:02:26 -0700
commit3fa54a156a83e498a7d5d0949a5f848fe82fe86f (patch)
tree5869a6a85e68fcc83470ba355b81a045a1fbc8e3 /OpenSim/Data/MySQL/Resources/FriendsStore.migrations
parent[Profiles] --> [Profile] (diff)
downloadopensim-SC_OLD-3fa54a156a83e498a7d5d0949a5f848fe82fe86f.zip
opensim-SC_OLD-3fa54a156a83e498a7d5d0949a5f848fe82fe86f.tar.gz
opensim-SC_OLD-3fa54a156a83e498a7d5d0949a5f848fe82fe86f.tar.bz2
opensim-SC_OLD-3fa54a156a83e498a7d5d0949a5f848fe82fe86f.tar.xz
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.
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/FriendsStore.migrations')
-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..5abacf5 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` MODIFY COLUMN PrincipalID varchar(255) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; 28ALTER TABLE `Friends` MODIFY COLUMN PrincipalID varchar(165) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';
29ALTER TABLE `Friends` MODIFY COLUMN Friend varchar(165) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';
29 30
30COMMIT; 31COMMIT;
31 32