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_InventoryStore.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_InventoryStore.sql')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql new file mode 100644 index 0000000..767d351 --- /dev/null +++ b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql | |||
@@ -0,0 +1,39 @@ | |||
1 | CREATE TABLE InventoryFolders ( | ||
2 | ID VARCHAR(36) NOT NULL, | ||
3 | Type SMALLINT DEFAULT NULL, | ||
4 | Version SMALLINT DEFAULT NULL, | ||
5 | ParentID VARCHAR(36) DEFAULT NULL, | ||
6 | Owner VARCHAR(36) DEFAULT NULL, | ||
7 | Name VARCHAR(64) DEFAULT NULL, | ||
8 | PRIMARY KEY (ID) | ||
9 | ); | ||
10 | |||
11 | CREATE INDEX InventoryFoldersOwnerIdIndex ON InventoryFolders (Owner); | ||
12 | CREATE INDEX InventoryFoldersParentIdIndex ON InventoryFolders (ParentID); | ||
13 | |||
14 | CREATE TABLE InventoryItems ( | ||
15 | ID VARCHAR(36) NOT NULL, | ||
16 | InvType SMALLINT DEFAULT NULL, | ||
17 | AssetType SMALLINT DEFAULT NULL, | ||
18 | AssetID VARCHAR(36) DEFAULT NULL, | ||
19 | Folder VARCHAR(36) DEFAULT NULL, | ||
20 | Owner VARCHAR(36) DEFAULT NULL, | ||
21 | Creator VARCHAR(36) DEFAULT NULL, | ||
22 | Name VARCHAR(64) DEFAULT NULL, | ||
23 | Description VARCHAR(64) DEFAULT NULL, | ||
24 | NextPermissions INT DEFAULT NULL, | ||
25 | CurrentPermissions INT DEFAULT NULL, | ||
26 | BasePermissions INT DEFAULT NULL, | ||
27 | EveryOnePermissions INT DEFAULT NULL, | ||
28 | GroupID VARCHAR(36) DEFAULT NULL, | ||
29 | GroupOwned BOOLEAN DEFAULT NULL, | ||
30 | SalePrice INT DEFAULT NULL, | ||
31 | SaleType SMALLINT DEFAULT NULL, | ||
32 | Flags INT DEFAULT NULL, | ||
33 | CreationDate INT DEFAULT NULL, | ||
34 | PRIMARY KEY (ID) | ||
35 | ); | ||
36 | |||
37 | CREATE INDEX InventoryItemsGroupIdIndex ON InventoryItems (GroupID); | ||
38 | CREATE INDEX InventoryItemsOwnerIdIndex ON InventoryItems (Owner); | ||
39 | CREATE INDEX InventoryItemsFolderIdIndex ON InventoryItems (Folder); | ||