diff options
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql new file mode 100644 index 0000000..0dfec7f --- /dev/null +++ b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql | |||
@@ -0,0 +1,35 @@ | |||
1 | create table Regions ( | ||
2 | Uuid NVARCHAR(255) not null, | ||
3 | RegionHandle BIGINT null, | ||
4 | RegionName NVARCHAR(32) null, | ||
5 | RegionRecvKey NVARCHAR(128) null, | ||
6 | RegionSendKey NVARCHAR(128) null, | ||
7 | RegionSecret NVARCHAR(128) null, | ||
8 | RegionDataURI NVARCHAR(255) null, | ||
9 | ServerIP NVARCHAR(64) null, | ||
10 | ServerPort INT null, | ||
11 | ServerURI NVARCHAR(255) null, | ||
12 | RegionLocX INT null, | ||
13 | RegionLocY INT null, | ||
14 | RegionLocZ INT null, | ||
15 | EastOverrideHandle BIGINT null, | ||
16 | WestOverrideHandle BIGINT null, | ||
17 | SouthOverrideHandle BIGINT null, | ||
18 | NorthOverrideHandle BIGINT null, | ||
19 | RegionAssetURI NVARCHAR(255) null, | ||
20 | RegionAssetRecvKey NVARCHAR(128) null, | ||
21 | RegionAssetSendKey NVARCHAR(128) null, | ||
22 | RegionUserURI NVARCHAR(255) null, | ||
23 | RegionUserRecvKey NVARCHAR(128) null, | ||
24 | RegionUserSendKey NVARCHAR(128) null, | ||
25 | ServerHttpPort INT null, | ||
26 | ServerRemotingPort INT null, | ||
27 | RegionMapTextureID NVARCHAR(255) null, | ||
28 | Owner_uuid NVARCHAR(255) null, | ||
29 | OriginUUID NVARCHAR(255) null, | ||
30 | primary key (Uuid) | ||
31 | ) | ||
32 | create index region_handle on Regions (RegionHandle) | ||
33 | create index region_name on Regions (RegionName) | ||
34 | create index overrideHandles on Regions (EastOverrideHandle, WestOverrideHandle, SouthOverrideHandle, NorthOverrideHandle) | ||
35 | |||