aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL
diff options
context:
space:
mode:
authorOren Hurvitz2013-10-29 16:03:58 +0200
committerJustin Clark-Casey (justincc)2014-01-16 00:16:33 +0000
commit46c2791fe2f9ea92535d3933602e24dcba8f96f9 (patch)
treef57849d8fe1568a7ce49aceda182f2d81e885f70 /OpenSim/Data/MySQL
parentFixed offline IM (diff)
downloadopensim-SC_OLD-46c2791fe2f9ea92535d3933602e24dcba8f96f9.zip
opensim-SC_OLD-46c2791fe2f9ea92535d3933602e24dcba8f96f9.tar.gz
opensim-SC_OLD-46c2791fe2f9ea92535d3933602e24dcba8f96f9.tar.bz2
opensim-SC_OLD-46c2791fe2f9ea92535d3933602e24dcba8f96f9.tar.xz
In the offline message table, store the sender.
This data is useful for preventing abuse (e.g., someone who sends too many messages), or for deleting message if their sender has been deleted.
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r--OpenSim/Data/MySQL/Resources/IM_Store.migrations12
1 files changed, 11 insertions, 1 deletions
diff --git a/OpenSim/Data/MySQL/Resources/IM_Store.migrations b/OpenSim/Data/MySQL/Resources/IM_Store.migrations
index 7cfcd43..f73475e 100644
--- a/OpenSim/Data/MySQL/Resources/IM_Store.migrations
+++ b/OpenSim/Data/MySQL/Resources/IM_Store.migrations
@@ -21,4 +21,14 @@ INSERT INTO `im_offline` SELECT * from `diva_im_offline`;
21DROP TABLE `diva_im_offline`; 21DROP TABLE `diva_im_offline`;
22DELETE FROM `migrations` WHERE name='diva_im_Store'; 22DELETE FROM `migrations` WHERE name='diva_im_Store';
23 23
24COMMIT; \ No newline at end of file 24COMMIT;
25
26:VERSION 3 # --------------------------
27
28BEGIN;
29
30ALTER TABLE `im_offline`
31 ADD `FromID` char(36) NOT NULL default '' AFTER `PrincipalID`,
32 ADD KEY `FromID` (`FromID`);
33
34COMMIT;