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/MySQLDialect | |
| parent | * Apply http://opensimulator.org/mantis/view.php?id=3012 (diff) | |
| download | opensim-SC-37f7c5a0ea272761793e072f2439e5b8e5f30e13.zip opensim-SC-37f7c5a0ea272761793e072f2439e5b8e5f30e13.tar.gz opensim-SC-37f7c5a0ea272761793e072f2439e5b8e5f30e13.tar.bz2 opensim-SC-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/MySQLDialect')
| -rw-r--r-- | OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql index 5fb1c19..c6fe620 100644 --- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql +++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql | |||
| @@ -24,10 +24,10 @@ CREATE TABLE Regions ( | |||
| 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 | RegionMapTexture 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 (uuid), | 30 | PRIMARY KEY (RegionID) |
| 31 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; | 31 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; |
| 32 | 32 | ||
| 33 | CREATE INDEX RegionNameIndex ON Regions (RegionName); | 33 | CREATE INDEX RegionNameIndex ON Regions (RegionName); |