From 0a5d8711e5294c36d40b779187e1718d3365f5fa Mon Sep 17 00:00:00 2001
From: runningnak3d <runningnak3d@gmail.com>
Date: Wed, 2 Feb 2011 07:50:21 -0700
Subject: Misc: Restructuring directory layout to accomodate the fact that we
 will be pushing DB content. We will no longer have a seperate DB repo.

---
 sql/old/3.1.3/05177_characters.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 sql/old/3.1.3/05177_characters.sql

(limited to 'sql/old/3.1.3/05177_characters.sql')

diff --git a/sql/old/3.1.3/05177_characters.sql b/sql/old/3.1.3/05177_characters.sql
new file mode 100644
index 00000000000..6b8f85ac527
--- /dev/null
+++ b/sql/old/3.1.3/05177_characters.sql
@@ -0,0 +1,8 @@
+ALTER TABLE `auctionhousebot`
+	  CHANGE COLUMN `maxstackgrey`  `maxstackgrey` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
+	  CHANGE COLUMN `maxstackwhite`  `maxstackwhite` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
+	  CHANGE COLUMN `maxstackgreen`  `maxstackgreen` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
+	  CHANGE COLUMN `maxstackblue`  `maxstackblue` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
+	  CHANGE COLUMN `maxstackpurple`  `maxstackpurple` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
+	  CHANGE COLUMN `maxstackorange`  `maxstackorange` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.',
+	  CHANGE COLUMN `maxstackyellow`  `maxstackyellow` int(11) default '0' COMMENT 'Stack size limits for item qualities - a value of 0 will disable a maximum stack size for that quality, which will allow the bot to create items in stack as large as the item allows.';
-- 
cgit v1.2.3

