From a9cc76e0efba7496909d613c75b81de6a9c5d979 Mon Sep 17 00:00:00 2001
From: Teravus Ovares
Date: Wed, 30 Apr 2008 16:08:24 +0000
Subject: * Long awaited patch from A_Biondi Mantis 923.  Kept alive by
 Melanie.  Thanks A_Biondi and Melanie! * This builds but might not work.  
 JustinCC will examine..   it may work out of the box.

---
 OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion3.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion3.sql

(limited to 'OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion3.sql')

diff --git a/OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion3.sql b/OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion3.sql
new file mode 100644
index 0000000..2b3b1f7
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion3.sql
@@ -0,0 +1,8 @@
+ALTER TABLE `inventoryitems` 
+	ADD COLUMN `salePrice` int(11) NOT NULL,
+	ADD COLUMN `saleType` tinyint(4) NOT NULL,
+	ADD COLUMN `creationDate` int(11) NOT NULL,
+	ADD COLUMN `groupID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
+	ADD COLUMN `groupOwned` tinyint(4) NOT NULL,
+	ADD COLUMN `flags` int(11) unsigned NOT NULL,
+COMMENT='Rev. 3';
-- 
cgit v1.1

