diff options
| -rw-r--r-- | sql-files/item_db_re.sql | 4 | ||||
| -rw-r--r-- | sql-files/upgrade_svn16645.sql | 2 |
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 |