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/SQLiteDialect | |
| 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/SQLiteDialect')
| -rw-r--r-- | OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql index 336a277..4f09848 100644 --- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql +++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql | |||
| @@ -22,12 +22,12 @@ CREATE TABLE Regions ( | |||
| 22 | RegionUserURI VARCHAR(255) DEFAULT NULL, | 22 | RegionUserURI VARCHAR(255) DEFAULT NULL, |
| 23 | RegionUserRecvKey VARCHAR(128) DEFAULT NULL, | 23 | RegionUserRecvKey VARCHAR(128) DEFAULT NULL, |
| 24 | RegionUserSendKey VARCHAR(128) DEFAULT NULL, | 24 | RegionUserSendKey VARCHAR(128) DEFAULT NULL, |
| 25 | regionMapTexture VARCHAR(36) DEFAULT NULL, | 25 | RegionMapTextureId VARCHAR(36) DEFAULT NULL, |
| 26 | ServerHttpPort INT DEFAULT NULL, | 26 | ServerHttpPort INT DEFAULT NULL, |
| 27 | ServerRemotingPort INT DEFAULT NULL, | 27 | ServerRemotingPort INT DEFAULT NULL, |
| 28 | OwnerID VARCHAR(36) DEFAULT NULL, | 28 | OwnerID VARCHAR(36) DEFAULT NULL, |
| 29 | OriginID VARCHAR(36) DEFAULT NULL, | 29 | OriginID VARCHAR(36) DEFAULT NULL, |
| 30 | PRIMARY KEY (uuid), | 30 | PRIMARY KEY (RegionId) |
| 31 | ); | 31 | ); |
| 32 | 32 | ||
| 33 | CREATE INDEX RegionNameIndex ON Regions (RegionName); | 33 | CREATE INDEX RegionNameIndex ON Regions (RegionName); |