aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql')
-rw-r--r--OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql
index 9d0f711..42af659 100644
--- a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql
@@ -1,7 +1,7 @@
1CREATE TABLE InventoryFolders ( 1CREATE TABLE InventoryFolders (
2 ID VARCHAR(36) NOT NULL, 2 ID VARCHAR(36) NOT NULL,
3 Type SMALLINT DEFAULT NULL, 3 Type SMALLINT DEFAULT NULL,
4 Version SMALLINT DEFAULT NULL, 4 Version INT DEFAULT NULL,
5 ParentID VARCHAR(36) DEFAULT NULL, 5 ParentID VARCHAR(36) DEFAULT NULL,
6 Owner VARCHAR(36) DEFAULT NULL, 6 Owner VARCHAR(36) DEFAULT NULL,
7 Name VARCHAR(64) DEFAULT NULL, 7 Name VARCHAR(64) DEFAULT NULL,
@@ -13,8 +13,8 @@ CREATE INDEX InventoryFoldersParentIdIndex ON InventoryFolders (ParentID);
13 13
14CREATE TABLE InventoryItems ( 14CREATE TABLE InventoryItems (
15 ID VARCHAR(36) NOT NULL, 15 ID VARCHAR(36) NOT NULL,
16 InvType SMALLINT DEFAULT NULL, 16 InvType INT DEFAULT NULL,
17 AssetType SMALLINT DEFAULT NULL, 17 AssetType INT DEFAULT NULL,
18 AssetID VARCHAR(36) DEFAULT NULL, 18 AssetID VARCHAR(36) DEFAULT NULL,
19 Folder VARCHAR(36) DEFAULT NULL, 19 Folder VARCHAR(36) DEFAULT NULL,
20 Owner VARCHAR(36) DEFAULT NULL, 20 Owner VARCHAR(36) DEFAULT NULL,