diff options
author | Matias <matiassw@gmail.com> | 2013-06-25 16:59:44 -0400 |
---|---|---|
committer | Matias <matiassw@gmail.com> | 2013-06-25 16:59:44 -0400 |
commit | b40371d3a0772031d12f2782c10976413c6f34b9 (patch) | |
tree | 7aeed5544a9df524a834cc739d3f596b66d6a006 /sql-files/item_db2.sql | |
parent | 25914bae30eced388cf8640eead19fbb11a65ade (diff) | |
parent | 5785dbae3f513da20611e3147dadef2b9c911443 (diff) | |
download | hercules-b40371d3a0772031d12f2782c10976413c6f34b9.tar.gz hercules-b40371d3a0772031d12f2782c10976413c6f34b9.tar.bz2 hercules-b40371d3a0772031d12f2782c10976413c6f34b9.tar.xz hercules-b40371d3a0772031d12f2782c10976413c6f34b9.zip |
Merge branch 'master' of https://github.com/HerculesWS/Hercules
Diffstat (limited to 'sql-files/item_db2.sql')
-rw-r--r-- | sql-files/item_db2.sql | 38 |
1 files changed, 19 insertions, 19 deletions
diff --git a/sql-files/item_db2.sql b/sql-files/item_db2.sql index 9c4d2db47..00707f287 100644 --- a/sql-files/item_db2.sql +++ b/sql-files/item_db2.sql @@ -4,25 +4,25 @@ DROP TABLE IF EXISTS `item_db2`; CREATE TABLE `item_db2` ( - `id` smallint(5) unsigned NOT NULL default '0', - `name_english` varchar(50) NOT NULL default '', - `name_japanese` varchar(50) NOT NULL default '', - `type` tinyint(2) unsigned NOT NULL default '0', - `price_buy` mediumint(10) unsigned default NULL, - `price_sell` mediumint(10) unsigned default NULL, - `weight` smallint(5) unsigned NOT NULL default '0', - `attack` smallint(3) unsigned default NULL, - `defence` tinyint(3) unsigned default NULL, - `range` tinyint(2) unsigned default NULL, - `slots` tinyint(2) unsigned default NULL, - `equip_jobs` int(12) unsigned default NULL, - `equip_upper` tinyint(8) unsigned default NULL, - `equip_genders` tinyint(2) unsigned default NULL, - `equip_locations` smallint(4) unsigned default NULL, - `weapon_level` tinyint(2) unsigned default NULL, - `equip_level` tinyint(3) unsigned default NULL, - `refineable` tinyint(1) unsigned default NULL, - `view` smallint(3) unsigned default NULL, + `id` smallint(5) unsigned NOT NULL DEFAULT '0', + `name_english` varchar(50) NOT NULL DEFAULT '', + `name_japanese` varchar(50) NOT NULL DEFAULT '', + `type` tinyint(2) unsigned NOT NULL DEFAULT '0', + `price_buy` mediumint(10) unsigned NOT NULL DEFAULT '0', + `price_sell` mediumint(10) unsigned NOT NULL DEFAULT '0', + `weight` smallint(5) unsigned NOT NULL DEFAULT '0', + `atk` smallint(3) unsigned NOT NULL DEFAULT '0', + `defence` smallint(5) NOT NULL DEFAULT '0', + `range` tinyint(2) unsigned NOT NULL DEFAULT '0', + `slots` tinyint(2) unsigned NOT NULL DEFAULT '0', + `equip_jobs` int(12) unsigned NOT NULL DEFAULT '0', + `equip_upper` tinyint(8) unsigned NOT NULL DEFAULT '0', + `equip_genders` tinyint(2) unsigned NOT NULL DEFAULT '0', + `equip_locations` smallint(4) unsigned NOT NULL DEFAULT '0', + `weapon_level` tinyint(2) unsigned NOT NULL DEFAULT '0', + `equip_level` tinyint(3) unsigned NOT NULL DEFAULT '0', + `refineable` tinyint(1) unsigned NOT NULL DEFAULT '0', + `view` smallint(3) unsigned NOT NULL DEFAULT '0', `script` text, `equip_script` text, `unequip_script` text, |