From 2ae1c92108191ec37c438dab6a6cdc6a710ac365 Mon Sep 17 00:00:00 2001 From: kenpachi2k11 Date: Thu, 16 Aug 2012 08:40:58 +0000 Subject: Follow up r16641 - updated table layout for item_db_re. (bugreport:6478) git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16645 54d463be-8e91-2dee-dedb-b68131a5f0ec --- sql-files/item_db_re.sql | 4 ++-- sql-files/upgrade_svn16645.sql | 2 ++ 2 files changed, 4 insertions(+), 2 deletions(-) create mode 100644 sql-files/upgrade_svn16645.sql (limited to 'sql-files') diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql index 734d26102..42a783f0e 100644 --- a/sql-files/item_db_re.sql +++ b/sql-files/item_db_re.sql @@ -11,8 +11,8 @@ CREATE TABLE `item_db_re` ( `price_buy` mediumint(10) unsigned default NULL, `price_sell` mediumint(10) unsigned default NULL, `weight` smallint(5) unsigned NOT NULL default '0', - `atk:matk` varchar(10) default '', - `defence` tinyint(3) unsigned default NULL, + `atk:matk` varchar(11) default '', + `defence` smallint(5) unsigned default NULL, `range` tinyint(2) unsigned default NULL, `slots` tinyint(2) unsigned default NULL, `equip_jobs` int(12) unsigned default NULL, diff --git a/sql-files/upgrade_svn16645.sql b/sql-files/upgrade_svn16645.sql new file mode 100644 index 000000000..9a3237ad8 --- /dev/null +++ b/sql-files/upgrade_svn16645.sql @@ -0,0 +1,2 @@ +ALTER TABLE `item_db_re` MODIFY COLUMN `atk:matk` VARCHAR(11) DEFAULT ''; +ALTER TABLE `item_db_re` MODIFY COLUMN `defence` SMALLINT(5) UNSIGNED DEFAULT NULL; \ No newline at end of file -- cgit v1.2.3-60-g2f50