aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/GridStore.migrations
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/GridStore.migrations')
-rw-r--r--OpenSim/Data/MySQL/Resources/GridStore.migrations141
1 files changed, 42 insertions, 99 deletions
diff --git a/OpenSim/Data/MySQL/Resources/GridStore.migrations b/OpenSim/Data/MySQL/Resources/GridStore.migrations
index 52ced24..e4c8fc3 100644
--- a/OpenSim/Data/MySQL/Resources/GridStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/GridStore.migrations
@@ -1,109 +1,52 @@
1:VERSION 1 1:VERSION 10
2 2
3BEGIN; 3BEGIN;
4 4
5CREATE TABLE `regions` ( 5CREATE TABLE IF NOT EXISTS `regions` (
6 `uuid` varchar(36) NOT NULL, 6 `uuid` varchar(36) NOT NULL,
7 `regionHandle` bigint(20) unsigned NOT NULL, 7 `regionHandle` bigint(20) unsigned NOT NULL,
8 `regionName` varchar(32) default NULL, 8 `regionName` varchar(128) DEFAULT NULL,
9 `regionRecvKey` varchar(128) default NULL, 9 `regionRecvKey` varchar(128) DEFAULT NULL,
10 `regionSendKey` varchar(128) default NULL, 10 `regionSendKey` varchar(128) DEFAULT NULL,
11 `regionSecret` varchar(128) default NULL, 11 `regionSecret` varchar(128) DEFAULT NULL,
12 `regionDataURI` varchar(255) default NULL, 12 `regionDataURI` varchar(255) DEFAULT NULL,
13 `serverIP` varchar(64) default NULL, 13 `serverIP` varchar(64) DEFAULT NULL,
14 `serverPort` int(10) unsigned default NULL, 14 `serverPort` int(10) unsigned DEFAULT NULL,
15 `serverURI` varchar(255) default NULL, 15 `serverURI` varchar(255) DEFAULT NULL,
16 `locX` int(10) unsigned default NULL, 16 `locX` int(10) unsigned DEFAULT NULL,
17 `locY` int(10) unsigned default NULL, 17 `locY` int(10) unsigned DEFAULT NULL,
18 `locZ` int(10) unsigned default NULL, 18 `locZ` int(10) unsigned DEFAULT NULL,
19 `eastOverrideHandle` bigint(20) unsigned default NULL, 19 `eastOverrideHandle` bigint(20) unsigned DEFAULT NULL,
20 `westOverrideHandle` bigint(20) unsigned default NULL, 20 `westOverrideHandle` bigint(20) unsigned DEFAULT NULL,
21 `southOverrideHandle` bigint(20) unsigned default NULL, 21 `southOverrideHandle` bigint(20) unsigned DEFAULT NULL,
22 `northOverrideHandle` bigint(20) unsigned default NULL, 22 `northOverrideHandle` bigint(20) unsigned DEFAULT NULL,
23 `regionAssetURI` varchar(255) default NULL, 23 `regionAssetURI` varchar(255) DEFAULT NULL,
24 `regionAssetRecvKey` varchar(128) default NULL, 24 `regionAssetRecvKey` varchar(128) DEFAULT NULL,
25 `regionAssetSendKey` varchar(128) default NULL, 25 `regionAssetSendKey` varchar(128) DEFAULT NULL,
26 `regionUserURI` varchar(255) default NULL, 26 `regionUserURI` varchar(255) DEFAULT NULL,
27 `regionUserRecvKey` varchar(128) default NULL, 27 `regionUserRecvKey` varchar(128) DEFAULT NULL,
28 `regionUserSendKey` varchar(128) default NULL, `regionMapTexture` varchar(36) default NULL, 28 `regionUserSendKey` varchar(128) DEFAULT NULL,
29 `serverHttpPort` int(10) default NULL, `serverRemotingPort` int(10) default NULL, 29 `regionMapTexture` varchar(36) DEFAULT NULL,
30 `owner_uuid` varchar(36) default '00000000-0000-0000-0000-000000000000' not null, 30 `serverHttpPort` int(10) DEFAULT NULL,
31 `originUUID` varchar(36), 31 `serverRemotingPort` int(10) DEFAULT NULL,
32 PRIMARY KEY (`uuid`), 32 `owner_uuid` varchar(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
33 `originUUID` varchar(36) DEFAULT NULL,
34 `access` int(10) unsigned DEFAULT '1',
35 `ScopeID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
36 `sizeX` int(11) NOT NULL DEFAULT '0',
37 `sizeY` int(11) NOT NULL DEFAULT '0',
38 `flags` int(11) NOT NULL DEFAULT '0',
39 `last_seen` int(11) NOT NULL DEFAULT '0',
40 `PrincipalID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
41 `Token` varchar(255) NOT NULL,
42 `parcelMapTexture` varchar(36) DEFAULT NULL,
43 PRIMARY KEY (`uuid`),
33 KEY `regionName` (`regionName`), 44 KEY `regionName` (`regionName`),
34 KEY `regionHandle` (`regionHandle`), 45 KEY `regionHandle` (`regionHandle`),
35 KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`) 46 KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`),
36) ENGINE=MyISAM DEFAULT CHARSET=utf8; 47 KEY `ScopeID` (`ScopeID`),
37 48 KEY `flags` (`flags`)
38COMMIT; 49) ENGINE=InnoDB DEFAULT CHARSET=utf8;
39
40:VERSION 2
41
42BEGIN;
43
44ALTER TABLE regions add column access integer unsigned default 1;
45
46COMMIT;
47
48:VERSION 3
49
50BEGIN;
51
52ALTER TABLE regions add column ScopeID char(36) not null default '00000000-0000-0000-0000-000000000000';
53
54create index ScopeID on regions(ScopeID);
55
56COMMIT;
57
58:VERSION 4
59
60BEGIN;
61
62ALTER TABLE regions add column sizeX integer not null default 0;
63ALTER TABLE regions add column sizeY integer not null default 0;
64
65COMMIT;
66
67:VERSION 5
68
69BEGIN;
70
71ALTER TABLE `regions` ADD COLUMN `flags` integer NOT NULL DEFAULT 0;
72CREATE INDEX flags ON regions(flags);
73
74COMMIT;
75
76:VERSION 6
77
78BEGIN;
79
80ALTER TABLE `regions` ADD COLUMN `last_seen` integer NOT NULL DEFAULT 0;
81
82COMMIT;
83
84:VERSION 7
85
86BEGIN;
87
88ALTER TABLE `regions` ADD COLUMN `PrincipalID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';
89ALTER TABLE `regions` ADD COLUMN `Token` varchar(255) NOT NULL;
90
91COMMIT;
92
93
94:VERSION 8 # ------------
95
96BEGIN;
97
98alter table regions modify column regionName varchar(128) default NULL;
99
100COMMIT;
101
102:VERSION 9 # ------------
103
104BEGIN;
105
106alter table regions add column `parcelMapTexture` varchar(36) default NULL;
107 50
108COMMIT; 51COMMIT;
109 52