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-12-24--00-15.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'sql-files/upgrades/2013-12-24--00-15.sql') diff --git a/sql-files/upgrades/2013-12-24--00-15.sql b/sql-files/upgrades/2013-12-24--00-15.sql index b1f8d019d..2de4771a6 100644 --- a/sql-files/upgrades/2013-12-24--00-15.sql +++ b/sql-files/upgrades/2013-12-24--00-15.sql @@ -1,8 +1,8 @@ #1387844126 CREATE TABLE IF NOT EXISTS `npc_market_data` ( - `name` varchar(24) NOT NULL default '', - `itemid` int(11) unsigned NOT NULL default '0', - `amount` int(11) unsigned NOT NULL default '0', - PRIMARY KEY (`name`,`itemid`) + `name` VARCHAR(24) NOT NULL DEFAULT '', + `itemid` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `amount` INT(11) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`name`,`itemid`) ) ENGINE=MyISAM; INSERT INTO `sql_updates` (`timestamp`) VALUES (1387844126); -- cgit v1.2.3-60-g2f50