* 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)

2 files changed, 8 insertions, 2 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
diff --git a/OpenSim/Data/MySQL/Resources/CreateItemsTable.sql b/OpenSim/Data/MySQL/Resources/CreateItemsTable.sql
index c8b7481..24ebccd 100644
--- a/OpenSim/Data/MySQL/Resources/CreateItemsTable.sql
+++ b/OpenSim/Data/MySQL/Resources/CreateItemsTable.sql
@@ -15,7 +15,7 @@ CREATE TABLE `inventoryitems` (
   `salePrice` int(11) default NULL,
   `saleType` tinyint(4) default NULL,
   `creationDate` int(11) default NULL,
-  `groupID` varchar(63) default NULL,
+  `groupID` varchar(36) default NULL,
   `groupOwned` tinyint(4) default NULL,
   `flags` int(11) unsigned default NULL,
   PRIMARY KEY  (`inventoryID`),