From 8ed9e578968539ff991ffa8215e715c0e4c3be5d Mon Sep 17 00:00:00 2001
From: Justin Clarke Casey
Date: Wed, 30 Apr 2008 19:28:36 +0000
Subject: * Add a scratch implementation of the new inventory fields to the
 mssql database adapter * I don't use mssql so this may not work, corrections
 (in the form of patches) are welcome. * Unlike mysql, mssql requires manual
 updating of existing tables here (which should mean just adding the new
 fields manually)

---
 OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'OpenSim/Data/MSSQL/Resources')

diff --git a/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql b/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql
index 435d269..6f6bb43 100644
--- a/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql
+++ b/OpenSim/Data/MSSQL/Resources/CreateItemsTable.sql
@@ -19,10 +19,10 @@ CREATE TABLE [inventoryitems] (
   [inventoryBasePermissions] [int] NOT NULL default 0,
   [inventoryEveryOnePermissions] [int] NOT NULL default 0,
   [salePrice] [int] default NULL,
-  [saleType] [smallint] default NULL,
+  [saleType] [tinyint] default NULL,
   [creationDate] [int] default NULL,
   [groupID] [varchar](36) default NULL,
-  [groupOwned] [smallint] default NULL,
+  [groupOwned] [tinyint] default NULL,
   [flags] [int] unsigned default NULL,
   PRIMARY KEY CLUSTERED
 (
-- 
cgit v1.1