opensim-development – Blame information for rev 1

Subversion Repositories:
Rev:
Rev Author Line No. Line
1 eva 1 :VERSION 1 # --------------------------
2  
3 BEGIN;
4  
5 CREATE TABLE `im_offline` (
6 `ID` MEDIUMINT NOT NULL AUTO_INCREMENT,
7 `PrincipalID` char(36) NOT NULL default '',
8 `Message` text NOT NULL,
9 `TMStamp` timestamp NOT NULL,
10 PRIMARY KEY (`ID`),
11 KEY `PrincipalID` (`PrincipalID`)
12 ) ENGINE=MyISAM;
13  
14 COMMIT;
15  
16 :VERSION 2 # --------------------------
17  
18 BEGIN;
19  
20 INSERT INTO `im_offline` SELECT * from `diva_im_offline`;
21 DROP TABLE `diva_im_offline`;
22 DELETE FROM `migrations` WHERE name='diva_im_Store';
23  
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;