diff options
author | Oren Hurvitz | 2013-10-29 16:03:58 +0200 |
---|---|---|
committer | Justin Clark-Casey (justincc) | 2014-01-16 00:16:33 +0000 |
commit | 46c2791fe2f9ea92535d3933602e24dcba8f96f9 (patch) | |
tree | f57849d8fe1568a7ce49aceda182f2d81e885f70 /OpenSim/Data/MySQL/Resources | |
parent | Fixed offline IM (diff) | |
download | opensim-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/Resources')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/IM_Store.migrations | 12 |
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`; | |||
21 | DROP TABLE `diva_im_offline`; | 21 | DROP TABLE `diva_im_offline`; |
22 | DELETE FROM `migrations` WHERE name='diva_im_Store'; | 22 | DELETE FROM `migrations` WHERE name='diva_im_Store'; |
23 | 23 | ||
24 | COMMIT; \ No newline at end of file | 24 | COMMIT; |
25 | |||
26 | :VERSION 3 # -------------------------- | ||
27 | |||
28 | BEGIN; | ||
29 | |||
30 | ALTER TABLE `im_offline` | ||
31 | ADD `FromID` char(36) NOT NULL default '' AFTER `PrincipalID`, | ||
32 | ADD KEY `FromID` (`FromID`); | ||
33 | |||
34 | COMMIT; | ||