aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/IM_Store.migrations
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/IM_Store.migrations')
-rw-r--r--OpenSim/Data/MySQL/Resources/IM_Store.migrations46
1 files changed, 10 insertions, 36 deletions
diff --git a/OpenSim/Data/MySQL/Resources/IM_Store.migrations b/OpenSim/Data/MySQL/Resources/IM_Store.migrations
index 79ead98..4f14826 100644
--- a/OpenSim/Data/MySQL/Resources/IM_Store.migrations
+++ b/OpenSim/Data/MySQL/Resources/IM_Store.migrations
@@ -1,42 +1,16 @@
1:VERSION 1 # -------------------------- 1:VERSION 5 # --------------------------
2 2
3BEGIN; 3BEGIN;
4 4
5CREATE TABLE `im_offline` ( 5CREATE TABLE IF NOT EXISTS `im_offline` (
6 `ID` MEDIUMINT NOT NULL AUTO_INCREMENT, 6 `ID` mediumint(9) NOT NULL AUTO_INCREMENT,
7 `PrincipalID` char(36) NOT NULL default '', 7 `PrincipalID` char(36) NOT NULL DEFAULT '',
8 `FromID` char(36) NOT NULL DEFAULT '',
8 `Message` text NOT NULL, 9 `Message` text NOT NULL,
9 `TMStamp` timestamp NOT NULL, 10 `TMStamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
10 PRIMARY KEY (`ID`), 11 PRIMARY KEY (`ID`),
11 KEY `PrincipalID` (`PrincipalID`) 12 KEY `PrincipalID` (`PrincipalID`),
12) ENGINE=MyISAM; 13 KEY `FromID` (`FromID`)
13 14) ENGINE=InnoDB DEFAULT CHARSET=utf8;
14COMMIT;
15
16:VERSION 2 # --------------------------
17
18BEGIN;
19
20INSERT INTO `im_offline` SELECT * from `diva_im_offline`;
21DROP TABLE `diva_im_offline`;
22DELETE FROM `migrations` WHERE name='diva_im_Store';
23
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;
35
36:VERSION 4 # --------------------------
37
38BEGIN;
39
40ALTER TABLE im_offline CONVERT TO CHARACTER SET utf8;
41 15
42COMMIT; 16COMMIT;