summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorkenpachi2k11 <kenpachi2k11@54d463be-8e91-2dee-dedb-b68131a5f0ec>2012-08-16 08:40:58 +0000
committerkenpachi2k11 <kenpachi2k11@54d463be-8e91-2dee-dedb-b68131a5f0ec>2012-08-16 08:40:58 +0000
commit2ae1c92108191ec37c438dab6a6cdc6a710ac365 (patch)
tree5bb991ba1597b59ec20bc0f4b84f721f0dbe19c4
parent5af651caf5cf6e10ec2f53ed751011435876b983 (diff)
downloadhercules-2ae1c92108191ec37c438dab6a6cdc6a710ac365.tar.gz
hercules-2ae1c92108191ec37c438dab6a6cdc6a710ac365.tar.bz2
hercules-2ae1c92108191ec37c438dab6a6cdc6a710ac365.tar.xz
hercules-2ae1c92108191ec37c438dab6a6cdc6a710ac365.zip
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
-rw-r--r--sql-files/item_db_re.sql4
-rw-r--r--sql-files/upgrade_svn16645.sql2
2 files changed, 4 insertions, 2 deletions
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