From f57ff4c36bab3b9e26c55d64afde251bf07a2de3 Mon Sep 17 00:00:00 2001
From: Justin Clarke Casey
Date: Wed, 30 Apr 2008 19:13:06 +0000
Subject: * 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)

---
 OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql | 8 +++++++-
 OpenSim/Data/MySQL/Resources/CreateItemsTable.sql | 2 +-
 2 files changed, 8 insertions(+), 2 deletions(-)

(limited to 'OpenSim/Data')

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`),
-- 
cgit v1.1