diff options
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_GridStore.sql')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_GridStore.sql | 70 |
1 files changed, 35 insertions, 35 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_GridStore.sql index efb889c..4366c1e 100644 --- a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_GridStore.sql +++ b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_GridStore.sql | |||
@@ -1,35 +1,35 @@ | |||
1 | CREATE TABLE Regions ( | 1 | CREATE TABLE Regions ( |
2 | RegionID VARCHAR(36) NOT NULL, | 2 | RegionID VARCHAR(36) NOT NULL, |
3 | OwnerID VARCHAR(36) DEFAULT NULL, | 3 | OwnerID VARCHAR(36) DEFAULT NULL, |
4 | OriginID VARCHAR(36) DEFAULT NULL, | 4 | OriginID VARCHAR(36) DEFAULT NULL, |
5 | RegionHandle BIGINT DEFAULT NULL, | 5 | RegionHandle BIGINT DEFAULT NULL, |
6 | RegionName VARCHAR(32) DEFAULT NULL, | 6 | RegionName VARCHAR(32) DEFAULT NULL, |
7 | RegionRecvKey VARCHAR(128) DEFAULT NULL, | 7 | RegionRecvKey VARCHAR(128) DEFAULT NULL, |
8 | RegionSendKey VARCHAR(128) DEFAULT NULL, | 8 | RegionSendKey VARCHAR(128) DEFAULT NULL, |
9 | RegionSecret VARCHAR(128) DEFAULT NULL, | 9 | RegionSecret VARCHAR(128) DEFAULT NULL, |
10 | RegionDataURI VARCHAR(255) DEFAULT NULL, | 10 | RegionDataURI VARCHAR(255) DEFAULT NULL, |
11 | ServerIP VARCHAR(64) DEFAULT NULL, | 11 | ServerIP VARCHAR(64) DEFAULT NULL, |
12 | ServerPort INT DEFAULT NULL, | 12 | ServerPort INT DEFAULT NULL, |
13 | ServerURI VARCHAR(255) DEFAULT NULL, | 13 | ServerURI VARCHAR(255) DEFAULT NULL, |
14 | RegionLocX INT DEFAULT NULL, | 14 | RegionLocX INT DEFAULT NULL, |
15 | RegionLocY INT DEFAULT NULL, | 15 | RegionLocY INT DEFAULT NULL, |
16 | RegionLocZ INT DEFAULT NULL, | 16 | RegionLocZ INT DEFAULT NULL, |
17 | EastOverrideHandle BIGINT DEFAULT NULL, | 17 | EastOverrideHandle BIGINT DEFAULT NULL, |
18 | WestOverrideHandle BIGINT DEFAULT NULL, | 18 | WestOverrideHandle BIGINT DEFAULT NULL, |
19 | SouthOverrideHandle BIGINT DEFAULT NULL, | 19 | SouthOverrideHandle BIGINT DEFAULT NULL, |
20 | NorthOverrideHandle BIGINT DEFAULT NULL, | 20 | NorthOverrideHandle BIGINT DEFAULT NULL, |
21 | RegionAssetURI VARCHAR(255) DEFAULT NULL, | 21 | RegionAssetURI VARCHAR(255) DEFAULT NULL, |
22 | RegionAssetRecvKey VARCHAR(128) DEFAULT NULL, | 22 | RegionAssetRecvKey VARCHAR(128) DEFAULT NULL, |
23 | RegionAssetSendKey VARCHAR(128) DEFAULT NULL, | 23 | RegionAssetSendKey VARCHAR(128) DEFAULT NULL, |
24 | RegionUserURI VARCHAR(255) DEFAULT NULL, | 24 | RegionUserURI VARCHAR(255) DEFAULT NULL, |
25 | RegionUserRecvKey VARCHAR(128) DEFAULT NULL, | 25 | RegionUserRecvKey VARCHAR(128) DEFAULT NULL, |
26 | RegionUserSendKey VARCHAR(128) DEFAULT NULL, | 26 | RegionUserSendKey VARCHAR(128) DEFAULT NULL, |
27 | RegionMapTextureId VARCHAR(36) DEFAULT NULL, | 27 | RegionMapTextureId VARCHAR(36) DEFAULT NULL, |
28 | ServerHttpPort INT DEFAULT NULL, | 28 | ServerHttpPort INT DEFAULT NULL, |
29 | ServerRemotingPort INT DEFAULT NULL, | 29 | ServerRemotingPort INT DEFAULT NULL, |
30 | PRIMARY KEY (RegionID) | 30 | PRIMARY KEY (RegionID) |
31 | ); | 31 | ); |
32 | 32 | ||
33 | CREATE INDEX RegionNameIndex ON Regions (RegionName); | 33 | CREATE INDEX RegionNameIndex ON Regions (RegionName); |
34 | CREATE INDEX RegionHandleIndex ON Regions (RegionHandle); | 34 | CREATE INDEX RegionHandleIndex ON Regions (RegionHandle); |
35 | CREATE INDEX RegionHandlesIndex ON Regions (EastOverrideHandle,WestOverrideHandle,SouthOverrideHandle,NorthOverrideHandle); | 35 | CREATE INDEX RegionHandlesIndex ON Regions (EastOverrideHandle,WestOverrideHandle,SouthOverrideHandle,NorthOverrideHandle); |