diff options
| author | Justin Clarke Casey | 2009-01-20 18:38:51 +0000 |
|---|---|---|
| committer | Justin Clarke Casey | 2009-01-20 18:38:51 +0000 |
| commit | 37f7c5a0ea272761793e072f2439e5b8e5f30e13 (patch) | |
| tree | 53199c878a8d509b1dc04274357c6e910f597f79 /OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql | |
| parent | * Apply http://opensimulator.org/mantis/view.php?id=3012 (diff) | |
| download | opensim-SC_OLD-37f7c5a0ea272761793e072f2439e5b8e5f30e13.zip opensim-SC_OLD-37f7c5a0ea272761793e072f2439e5b8e5f30e13.tar.gz opensim-SC_OLD-37f7c5a0ea272761793e072f2439e5b8e5f30e13.tar.bz2 opensim-SC_OLD-37f7c5a0ea272761793e072f2439e5b8e5f30e13.tar.xz | |
* Apply http://opensimulator.org/mantis/view.php?id=3020
* Adds a grid db implementation and unit tests to the NHibernate module
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql')
| -rw-r--r-- | OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql index 0dfec7f..e4ad525 100644 --- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql +++ b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_GridStore.sql | |||
| @@ -1,5 +1,5 @@ | |||
| 1 | create table Regions ( | 1 | create table Regions ( |
| 2 | Uuid NVARCHAR(255) not null, | 2 | Uuid NVARCHAR(36) not null, |
| 3 | RegionHandle BIGINT null, | 3 | RegionHandle BIGINT null, |
| 4 | RegionName NVARCHAR(32) null, | 4 | RegionName NVARCHAR(32) null, |
| 5 | RegionRecvKey NVARCHAR(128) null, | 5 | RegionRecvKey NVARCHAR(128) null, |
| @@ -24,9 +24,9 @@ create table Regions ( | |||
| 24 | RegionUserSendKey NVARCHAR(128) null, | 24 | RegionUserSendKey NVARCHAR(128) null, |
| 25 | ServerHttpPort INT null, | 25 | ServerHttpPort INT null, |
| 26 | ServerRemotingPort INT null, | 26 | ServerRemotingPort INT null, |
| 27 | RegionMapTextureID NVARCHAR(255) null, | 27 | RegionMapTextureID NVARCHAR(36) null, |
| 28 | Owner_uuid NVARCHAR(255) null, | 28 | Owner_uuid NVARCHAR(36) null, |
| 29 | OriginUUID NVARCHAR(255) null, | 29 | OriginUUID NVARCHAR(36) null, |
| 30 | primary key (Uuid) | 30 | primary key (Uuid) |
| 31 | ) | 31 | ) |
| 32 | create index region_handle on Regions (RegionHandle) | 32 | create index region_handle on Regions (RegionHandle) |