diff options
| author | j-tkay <joseph.tk.ea@gmail.com> | 2013-06-19 11:59:28 +0800 |
|---|---|---|
| committer | j-tkay <joseph.tk.ea@gmail.com> | 2013-06-19 11:59:28 +0800 |
| commit | de7919f0f59f47473e6de709b5d5287a4a55e18d (patch) | |
| tree | 5967ef231271682ebf9db27185e7e86bbdbc57d4 /sql-files/item_db2_re.sql | |
| parent | 98fe7e4770376ca66590b5a1e75ce3a848d032a9 (diff) | |
| parent | bd95eccf047bda9d72abcea0724ad34b31131ab0 (diff) | |
| download | hercules-de7919f0f59f47473e6de709b5d5287a4a55e18d.tar.gz hercules-de7919f0f59f47473e6de709b5d5287a4a55e18d.tar.bz2 hercules-de7919f0f59f47473e6de709b5d5287a4a55e18d.tar.xz hercules-de7919f0f59f47473e6de709b5d5287a4a55e18d.zip | |
Merge branch 'master' of https://github.com/HerculesWS/Hercules
Diffstat (limited to 'sql-files/item_db2_re.sql')
| -rw-r--r-- | sql-files/item_db2_re.sql | 40 |
1 files changed, 21 insertions, 19 deletions
diff --git a/sql-files/item_db2_re.sql b/sql-files/item_db2_re.sql index 0f4d01bac..affa0dc79 100644 --- a/sql-files/item_db2_re.sql +++ b/sql-files/item_db2_re.sql @@ -4,25 +4,27 @@ 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', - `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, - `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` varchar(10) default '', - `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) NOT NULL DEFAULT '0', + `price_sell` mediumint(10) NOT NULL DEFAULT '0', + `weight` smallint(5) unsigned NOT NULL DEFAULT '0', + `atk` smallint(5) unsigned NOT NULL DEFAULT '0', + `matk` smallint(5) unsigned NOT NULL DEFAULT '0', + `defence` smallint(5) unsigned 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 DEFAULT NULL, + `equip_level_min` smallint(5) unsigned NOT NULL DEFAULT '0', + `equip_level_max` smallint(5) unsigned NOT NULL DEFAULT '0', + `refineable` tinyint(1) unsigned NOT NULL DEFAULT '0', + `view` smallint(3) unsigned DEFAULT NULL, `script` text, `equip_script` text, `unequip_script` text, |