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 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

(limited to 'OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql')

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