aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/GridStore.migrations
diff options
context:
space:
mode:
authorAlexRa2010-05-01 17:43:10 +0300
committerAlexRa2010-05-16 17:04:13 +0300
commitee713cb253c1ef2d09de235964e02e7621649dd8 (patch)
treeb85373e71ddc2ece69726ea60c0f636ccc302c72 /OpenSim/Data/MySQL/Resources/GridStore.migrations
parentAdded MySqlMigrations.cs (supports stored proc/funcs) (diff)
downloadopensim-SC_OLD-ee713cb253c1ef2d09de235964e02e7621649dd8.zip
opensim-SC_OLD-ee713cb253c1ef2d09de235964e02e7621649dd8.tar.gz
opensim-SC_OLD-ee713cb253c1ef2d09de235964e02e7621649dd8.tar.bz2
opensim-SC_OLD-ee713cb253c1ef2d09de235964e02e7621649dd8.tar.xz
Converted MySQL migration history to the new format
Replaced all NNN_StoreName.sql migration resources with a more readable, single-file-per-store
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/GridStore.migrations')
-rw-r--r--OpenSim/Data/MySQL/Resources/GridStore.migrations89
1 files changed, 89 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/GridStore.migrations b/OpenSim/Data/MySQL/Resources/GridStore.migrations
new file mode 100644
index 0000000..523a8ac
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/GridStore.migrations
@@ -0,0 +1,89 @@
1:VERSION 1
2
3CREATE 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
38BEGIN;
39
40ALTER TABLE regions add column access integer unsigned default 1;
41
42COMMIT;
43
44:VERSION 3
45
46BEGIN;
47
48ALTER TABLE regions add column ScopeID char(36) not null default '00000000-0000-0000-0000-000000000000';
49
50create index ScopeID on regions(ScopeID);
51
52COMMIT;
53
54:VERSION 4
55
56BEGIN;
57
58ALTER TABLE regions add column sizeX integer not null default 0;
59ALTER TABLE regions add column sizeY integer not null default 0;
60
61COMMIT;
62
63:VERSION 5
64
65BEGIN;
66
67ALTER TABLE `regions` ADD COLUMN `flags` integer NOT NULL DEFAULT 0;
68CREATE INDEX flags ON regions(flags);
69
70COMMIT;
71
72:VERSION 6
73
74BEGIN;
75
76ALTER TABLE `regions` ADD COLUMN `last_seen` integer NOT NULL DEFAULT 0;
77
78COMMIT;
79
80:VERSION 7
81
82BEGIN;
83
84ALTER TABLE `regions` ADD COLUMN `PrincipalID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';
85ALTER TABLE `regions` ADD COLUMN `Token` varchar(255) NOT NULL;
86
87COMMIT;
88
89