opensim-development – Blame information for rev 1

Subversion Repositories:
Rev:
Rev Author Line No. Line
1 eva 1 :VERSION 1
2  
3 CREATE TABLE `regions` (
4 `uuid` varchar(36) NOT NULL,
5 `regionHandle` bigint(20) unsigned NOT NULL,
6 `regionName` varchar(32) default NULL,
7 `regionRecvKey` varchar(128) default NULL,
8 `regionSendKey` varchar(128) default NULL,
9 `regionSecret` varchar(128) default NULL,
10 `regionDataURI` varchar(255) default NULL,
11 `serverIP` varchar(64) default NULL,
12 `serverPort` int(10) unsigned default NULL,
13 `serverURI` varchar(255) default NULL,
14 `locX` int(10) unsigned default NULL,
15 `locY` int(10) unsigned default NULL,
16 `locZ` int(10) unsigned default NULL,
17 `eastOverrideHandle` bigint(20) unsigned default NULL,
18 `westOverrideHandle` bigint(20) unsigned default NULL,
19 `southOverrideHandle` bigint(20) unsigned default NULL,
20 `northOverrideHandle` bigint(20) unsigned default NULL,
21 `regionAssetURI` varchar(255) default NULL,
22 `regionAssetRecvKey` varchar(128) default NULL,
23 `regionAssetSendKey` varchar(128) default NULL,
24 `regionUserURI` varchar(255) default NULL,
25 `regionUserRecvKey` varchar(128) default NULL,
26 `regionUserSendKey` varchar(128) default NULL, `regionMapTexture` varchar(36) default NULL,
27 `serverHttpPort` int(10) default NULL, `serverRemotingPort` int(10) default NULL,
28 `owner_uuid` varchar(36) default '00000000-0000-0000-0000-000000000000' not null,
29 `originUUID` varchar(36),
30 PRIMARY KEY (`uuid`),
31 KEY `regionName` (`regionName`),
32 KEY `regionHandle` (`regionHandle`),
33 KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`)
34 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Rev. 3';
35  
36 :VERSION 2
37  
38 BEGIN;
39  
40 ALTER TABLE regions add column access integer unsigned default 1;
41  
42 COMMIT;
43  
44 :VERSION 3
45  
46 BEGIN;
47  
48 ALTER TABLE regions add column ScopeID char(36) not null default '00000000-0000-0000-0000-000000000000';
49  
50 create index ScopeID on regions(ScopeID);
51  
52 COMMIT;
53  
54 :VERSION 4
55  
56 BEGIN;
57  
58 ALTER TABLE regions add column sizeX integer not null default 0;
59 ALTER TABLE regions add column sizeY integer not null default 0;
60  
61 COMMIT;
62  
63 :VERSION 5
64  
65 BEGIN;
66  
67 ALTER TABLE `regions` ADD COLUMN `flags` integer NOT NULL DEFAULT 0;
68 CREATE INDEX flags ON regions(flags);
69  
70 COMMIT;
71  
72 :VERSION 6
73  
74 BEGIN;
75  
76 ALTER TABLE `regions` ADD COLUMN `last_seen` integer NOT NULL DEFAULT 0;
77  
78 COMMIT;
79  
80 :VERSION 7
81  
82 BEGIN;
83  
84 ALTER TABLE `regions` ADD COLUMN `PrincipalID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';
85 ALTER TABLE `regions` ADD COLUMN `Token` varchar(255) NOT NULL;
86  
87 COMMIT;
88  
89  
90 :VERSION 8 # ------------
91  
92 BEGIN;
93  
94 alter table regions modify column regionName varchar(128) default NULL;
95  
96 COMMIT;
97  
98 :VERSION 9 # ------------
99  
100 BEGIN;
101  
102 alter table regions add column `parcelMapTexture` varchar(36) default NULL;
103  
104 COMMIT;
105