diff options
| author | kenpachi2k11 <kenpachi2k11@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2012-08-16 08:40:58 +0000 |
|---|---|---|
| committer | kenpachi2k11 <kenpachi2k11@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2012-08-16 08:40:58 +0000 |
| commit | 2ae1c92108191ec37c438dab6a6cdc6a710ac365 (patch) | |
| tree | 5bb991ba1597b59ec20bc0f4b84f721f0dbe19c4 /sql-files | |
| parent | 5af651caf5cf6e10ec2f53ed751011435876b983 (diff) | |
| download | hercules-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
Diffstat (limited to 'sql-files')
| -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 |