From fdce1be3db287bed901332b90ba57165e201d3fc Mon Sep 17 00:00:00 2001 From: John Hurliman Date: Mon, 19 Oct 2009 16:52:27 -0700 Subject: * Removed OpenSim.Data.NHibernate * Replaced calls to ThreadPool.QueueUserWorkItem() with ThreadPool.UnsafeQueueUserWorkItem() since OpenSim does not use Code Access Security sandboxing --- .../PostgreSQLDialect/001_InventoryStore.sql | 39 ---------------------- 1 file changed, 39 deletions(-) delete mode 100644 OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql (limited to 'OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql') diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql deleted file mode 100644 index 42af659..0000000 --- a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql +++ /dev/null @@ -1,39 +0,0 @@ -CREATE TABLE InventoryFolders ( - ID VARCHAR(36) NOT NULL, - Type SMALLINT DEFAULT NULL, - Version INT DEFAULT NULL, - ParentID VARCHAR(36) DEFAULT NULL, - Owner VARCHAR(36) DEFAULT NULL, - Name VARCHAR(64) DEFAULT NULL, - PRIMARY KEY (ID) -); - -CREATE INDEX InventoryFoldersOwnerIdIndex ON InventoryFolders (Owner); -CREATE INDEX InventoryFoldersParentIdIndex ON InventoryFolders (ParentID); - -CREATE TABLE InventoryItems ( - ID VARCHAR(36) NOT NULL, - InvType INT DEFAULT NULL, - AssetType INT DEFAULT NULL, - AssetID VARCHAR(36) DEFAULT NULL, - Folder VARCHAR(36) DEFAULT NULL, - Owner VARCHAR(36) DEFAULT NULL, - Creator VARCHAR(36) DEFAULT NULL, - Name VARCHAR(64) DEFAULT NULL, - Description VARCHAR(64) DEFAULT NULL, - NextPermissions INT DEFAULT NULL, - CurrentPermissions INT DEFAULT NULL, - BasePermissions INT DEFAULT NULL, - EveryOnePermissions INT DEFAULT NULL, - GroupID VARCHAR(36) DEFAULT NULL, - GroupOwned BOOLEAN DEFAULT NULL, - SalePrice INT DEFAULT NULL, - SaleType SMALLINT DEFAULT NULL, - Flags INT DEFAULT NULL, - CreationDate INT DEFAULT NULL, - PRIMARY KEY (ID) -); - -CREATE INDEX InventoryItemsGroupIdIndex ON InventoryItems (GroupID); -CREATE INDEX InventoryItemsOwnerIdIndex ON InventoryItems (Owner); -CREATE INDEX InventoryItemsFolderIdIndex ON InventoryItems (Folder); -- cgit v1.1