aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql
diff options
context:
space:
mode:
authorJeff Ames2009-01-24 08:18:41 +0000
committerJeff Ames2009-01-24 08:18:41 +0000
commit676b7c107358fa29e5716e68f65b39da586aa99a (patch)
tree366fd52db79cd2f35ebe3b8342dc26db810e14e7 /OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql
parent* minor: remove mono compiler warning (diff)
downloadopensim-SC-676b7c107358fa29e5716e68f65b39da586aa99a.zip
opensim-SC-676b7c107358fa29e5716e68f65b39da586aa99a.tar.gz
opensim-SC-676b7c107358fa29e5716e68f65b39da586aa99a.tar.bz2
opensim-SC-676b7c107358fa29e5716e68f65b39da586aa99a.tar.xz
Update svn properties.
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql')
-rw-r--r--OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql78
1 files changed, 39 insertions, 39 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql
index 767d351..9d0f711 100644
--- a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql
@@ -1,39 +1,39 @@
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 SMALLINT 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,
8 PRIMARY KEY (ID) 8 PRIMARY KEY (ID)
9); 9);
10 10
11CREATE INDEX InventoryFoldersOwnerIdIndex ON InventoryFolders (Owner); 11CREATE INDEX InventoryFoldersOwnerIdIndex ON InventoryFolders (Owner);
12CREATE INDEX InventoryFoldersParentIdIndex ON InventoryFolders (ParentID); 12CREATE 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 SMALLINT DEFAULT NULL,
17 AssetType SMALLINT DEFAULT NULL, 17 AssetType SMALLINT 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,
21 Creator VARCHAR(36) DEFAULT NULL, 21 Creator VARCHAR(36) DEFAULT NULL,
22 Name VARCHAR(64) DEFAULT NULL, 22 Name VARCHAR(64) DEFAULT NULL,
23 Description VARCHAR(64) DEFAULT NULL, 23 Description VARCHAR(64) DEFAULT NULL,
24 NextPermissions INT DEFAULT NULL, 24 NextPermissions INT DEFAULT NULL,
25 CurrentPermissions INT DEFAULT NULL, 25 CurrentPermissions INT DEFAULT NULL,
26 BasePermissions INT DEFAULT NULL, 26 BasePermissions INT DEFAULT NULL,
27 EveryOnePermissions INT DEFAULT NULL, 27 EveryOnePermissions INT DEFAULT NULL,
28 GroupID VARCHAR(36) DEFAULT NULL, 28 GroupID VARCHAR(36) DEFAULT NULL,
29 GroupOwned BOOLEAN DEFAULT NULL, 29 GroupOwned BOOLEAN DEFAULT NULL,
30 SalePrice INT DEFAULT NULL, 30 SalePrice INT DEFAULT NULL,
31 SaleType SMALLINT DEFAULT NULL, 31 SaleType SMALLINT DEFAULT NULL,
32 Flags INT DEFAULT NULL, 32 Flags INT DEFAULT NULL,
33 CreationDate INT DEFAULT NULL, 33 CreationDate INT DEFAULT NULL,
34 PRIMARY KEY (ID) 34 PRIMARY KEY (ID)
35); 35);
36 36
37CREATE INDEX InventoryItemsGroupIdIndex ON InventoryItems (GroupID); 37CREATE INDEX InventoryItemsGroupIdIndex ON InventoryItems (GroupID);
38CREATE INDEX InventoryItemsOwnerIdIndex ON InventoryItems (Owner); 38CREATE INDEX InventoryItemsOwnerIdIndex ON InventoryItems (Owner);
39CREATE INDEX InventoryItemsFolderIdIndex ON InventoryItems (Folder); 39CREATE INDEX InventoryItemsFolderIdIndex ON InventoryItems (Folder);