From 6e9042c3d34f5e7169eac146b48eec8fe0b406cb Mon Sep 17 00:00:00 2001
From: Justin Clarke Casey
Date: Thu, 1 May 2008 12:33:05 +0000
Subject: * Change mysql inventory items table version 3 upgrade sql to provide
 explicit default values

---
 OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion3.sql | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

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

diff --git a/OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion3.sql b/OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion3.sql
index 2b3b1f7..5bd6994 100644
--- a/OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion3.sql
+++ b/OpenSim/Data/MySQL/Resources/UpgradeItemsTableToVersion3.sql
@@ -1,8 +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 `salePrice` int(11) NOT NULL default 0,
+	ADD COLUMN `saleType` tinyint(4) NOT NULL default 0,
+	ADD COLUMN `creationDate` int(11) NOT NULL default 3000,
 	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,
+	ADD COLUMN `groupOwned` tinyint(4) NOT NULL default 0,
+	ADD COLUMN `flags` int(11) unsigned NOT NULL default 0,
 COMMENT='Rev. 3';
-- 
cgit v1.1