* Change new inventory groupID field to 36 rather than 63

* Add updated stub mssql inventory sql (only really because I was in the middle of this when I spotted the numeric transposition)

1 files changed, 7 insertions, 1 deletions

diff --git a/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql b/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql
index 5bb27ba..435d269 100644
--- a/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql
+++ b/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql
@@ -17,7 +17,13 @@ CREATE TABLE [inventoryitems] (
   [invType] [int] default NULL,
   [creatorID] [varchar](36) default NULL,
   [inventoryBasePermissions] [int] NOT NULL default 0,
-  [inventoryEveryOnePermissions] [int] NOT NULL default 0, 
+  [inventoryEveryOnePermissions] [int] NOT NULL default 0,
+  [salePrice] [int] default NULL,
+  [saleType] [smallint] default NULL,
+  [creationDate] [int] default NULL,
+  [groupID] [varchar](36) default NULL,
+  [groupOwned] [smallint] default NULL,
+  [flags] [int] unsigned default NULL,
   PRIMARY KEY CLUSTERED
 (
         [inventoryID] ASC