diff options
author | Jeff Ames | 2009-01-24 08:18:41 +0000 |
---|---|---|
committer | Jeff Ames | 2009-01-24 08:18:41 +0000 |
commit | 676b7c107358fa29e5716e68f65b39da586aa99a (patch) | |
tree | 366fd52db79cd2f35ebe3b8342dc26db810e14e7 /OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql | |
parent | * minor: remove mono compiler warning (diff) | |
download | opensim-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.sql | 78 |
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 @@ | |||
1 | CREATE TABLE InventoryFolders ( | 1 | CREATE 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 | ||
11 | CREATE INDEX InventoryFoldersOwnerIdIndex ON InventoryFolders (Owner); | 11 | CREATE INDEX InventoryFoldersOwnerIdIndex ON InventoryFolders (Owner); |
12 | CREATE INDEX InventoryFoldersParentIdIndex ON InventoryFolders (ParentID); | 12 | CREATE INDEX InventoryFoldersParentIdIndex ON InventoryFolders (ParentID); |
13 | 13 | ||
14 | CREATE TABLE InventoryItems ( | 14 | CREATE 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 | ||
37 | CREATE INDEX InventoryItemsGroupIdIndex ON InventoryItems (GroupID); | 37 | CREATE INDEX InventoryItemsGroupIdIndex ON InventoryItems (GroupID); |
38 | CREATE INDEX InventoryItemsOwnerIdIndex ON InventoryItems (Owner); | 38 | CREATE INDEX InventoryItemsOwnerIdIndex ON InventoryItems (Owner); |
39 | CREATE INDEX InventoryItemsFolderIdIndex ON InventoryItems (Folder); | 39 | CREATE INDEX InventoryItemsFolderIdIndex ON InventoryItems (Folder); |