From ef8700dfa9e21acf1963fd8a139e79bf5dec0dd9 Mon Sep 17 00:00:00 2001 From: Shido Date: Fri, 30 May 2014 10:15:22 +0800 Subject: Updated sql-upgrade files. --- sql-files/upgrades/2013-11-18--08-23.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'sql-files/upgrades/2013-11-18--08-23.sql') diff --git a/sql-files/upgrades/2013-11-18--08-23.sql b/sql-files/upgrades/2013-11-18--08-23.sql index d5da5fd95..d7100d78a 100644 --- a/sql-files/upgrades/2013-11-18--08-23.sql +++ b/sql-files/upgrades/2013-11-18--08-23.sql @@ -4,7 +4,7 @@ -- you'll need to run the following queries manually: -- -- [ Both Pre-Renewal and Renewal ] --- ALTER TABLE item_db2 ADD COLUMN `bindonequip` tinyint(1) unsigned DEFAULT NULL AFTER `view`; +-- ALTER TABLE item_db2 ADD COLUMN `bindonequip` TINYINT(1) UNSIGNED DEFAULT NULL AFTER `view`; -- INSERT INTO `sql_updates` (`timestamp`) VALUES (1384763034); -- -- [ End ] @@ -55,7 +55,7 @@ BEGIN END $$ -CALL alter_if_not_exists('item_db2', 'bindonequip', 'ADD COLUMN', 'tinyint(1) unsigned DEFAULT NULL AFTER `view`') $$ +CALL alter_if_not_exists('item_db2', 'bindonequip', 'ADD COLUMN', 'TINYINT(1) UNSIGNED DEFAULT NULL AFTER `view`') $$ DROP PROCEDURE IF EXISTS alter_if_not_exists $$ DROP PROCEDURE IF EXISTS alter_if_exists $$ -- cgit v1.2.3-70-g09d2