diff options
author | Charles Krinke | 2009-01-23 20:21:43 +0000 |
---|---|---|
committer | Charles Krinke | 2009-01-23 20:21:43 +0000 |
commit | bd2c345e56f0857d4d48e8bea509e00954be5d9f (patch) | |
tree | 7161fc65dc3b945aa233cf31b680fc6183dd6609 /OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_GridStore.sql | |
parent | * Extend archive test to check for the presence of a control file in a saved ... (diff) | |
download | opensim-SC_OLD-bd2c345e56f0857d4d48e8bea509e00954be5d9f.zip opensim-SC_OLD-bd2c345e56f0857d4d48e8bea509e00954be5d9f.tar.gz opensim-SC_OLD-bd2c345e56f0857d4d48e8bea509e00954be5d9f.tar.bz2 opensim-SC_OLD-bd2c345e56f0857d4d48e8bea509e00954be5d9f.tar.xz |
Thank you kindly, TLaukkan (Tommil) for a patch that:
* Added Npgsql.dll and Mono.Security.dll which are NpgsqlDriver dlls.
* Added missing field to schema creation scripts: PathTaperY.
* Added schema creation scripts for PostgreSQL.
* Added unit test classes for PostgreSQL.
* Added schema creation script folder to NHibernate project in prebuild.xml
* Added Npgsql.dll to NHibernate test project dependencies in prebuild.xml
* Ensured that build works with both nant and Visual Studio.
* Executed build unit tests with nant and NHibernate unit tests with NUnitGUI
- Couple of region tests fail due to double precission float rounding errors need to sort out how these are handles in unit tests and if higher precission numeric field needs to be used in Postgresql.
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_GridStore.sql')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_GridStore.sql | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_GridStore.sql new file mode 100644 index 0000000..efb889c --- /dev/null +++ b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_GridStore.sql | |||
@@ -0,0 +1,35 @@ | |||
1 | CREATE TABLE Regions ( | ||
2 | RegionID VARCHAR(36) NOT NULL, | ||
3 | OwnerID VARCHAR(36) DEFAULT NULL, | ||
4 | OriginID VARCHAR(36) DEFAULT NULL, | ||
5 | RegionHandle BIGINT DEFAULT NULL, | ||
6 | RegionName VARCHAR(32) DEFAULT NULL, | ||
7 | RegionRecvKey VARCHAR(128) DEFAULT NULL, | ||
8 | RegionSendKey VARCHAR(128) DEFAULT NULL, | ||
9 | RegionSecret VARCHAR(128) DEFAULT NULL, | ||
10 | RegionDataURI VARCHAR(255) DEFAULT NULL, | ||
11 | ServerIP VARCHAR(64) DEFAULT NULL, | ||
12 | ServerPort INT DEFAULT NULL, | ||
13 | ServerURI VARCHAR(255) DEFAULT NULL, | ||
14 | RegionLocX INT DEFAULT NULL, | ||
15 | RegionLocY INT DEFAULT NULL, | ||
16 | RegionLocZ INT DEFAULT NULL, | ||
17 | EastOverrideHandle BIGINT DEFAULT NULL, | ||
18 | WestOverrideHandle BIGINT DEFAULT NULL, | ||
19 | SouthOverrideHandle BIGINT DEFAULT NULL, | ||
20 | NorthOverrideHandle BIGINT DEFAULT NULL, | ||
21 | RegionAssetURI VARCHAR(255) DEFAULT NULL, | ||
22 | RegionAssetRecvKey VARCHAR(128) DEFAULT NULL, | ||
23 | RegionAssetSendKey VARCHAR(128) DEFAULT NULL, | ||
24 | RegionUserURI VARCHAR(255) DEFAULT NULL, | ||
25 | RegionUserRecvKey VARCHAR(128) DEFAULT NULL, | ||
26 | RegionUserSendKey VARCHAR(128) DEFAULT NULL, | ||
27 | RegionMapTextureId VARCHAR(36) DEFAULT NULL, | ||
28 | ServerHttpPort INT DEFAULT NULL, | ||
29 | ServerRemotingPort INT DEFAULT NULL, | ||
30 | PRIMARY KEY (RegionID) | ||
31 | ); | ||
32 | |||
33 | CREATE INDEX RegionNameIndex ON Regions (RegionName); | ||
34 | CREATE INDEX RegionHandleIndex ON Regions (RegionHandle); | ||
35 | CREATE INDEX RegionHandlesIndex ON Regions (EastOverrideHandle,WestOverrideHandle,SouthOverrideHandle,NorthOverrideHandle); | ||