summaryrefslogtreecommitdiff
path: root/sql-files/item_db2_re.sql
diff options
context:
space:
mode:
authorshennetsind <ind@henn.et>2013-06-14 08:50:45 -0300
committershennetsind <ind@henn.et>2013-06-14 08:50:45 -0300
commit5321d32c8d670fbfbfe02f7df5066170aa20ee2e (patch)
treeb87f8211e9ea2d486a8b172b3a5b97971e3643dc /sql-files/item_db2_re.sql
parente5e28d108ebc656fcb8a39775b84e725ca4abbb9 (diff)
downloadhercules-5321d32c8d670fbfbfe02f7df5066170aa20ee2e.tar.gz
hercules-5321d32c8d670fbfbfe02f7df5066170aa20ee2e.tar.bz2
hercules-5321d32c8d670fbfbfe02f7df5066170aa20ee2e.tar.xz
hercules-5321d32c8d670fbfbfe02f7df5066170aa20ee2e.zip
Updating .sql item db files
Also Introducing the official DB2SQL plugin to quickly update the .sql db files. http://hercules.ws/board/topic/1105-hercules-wpe-free-june-14th-patch Signed-off-by: shennetsind <ind@henn.et>
Diffstat (limited to 'sql-files/item_db2_re.sql')
-rw-r--r--sql-files/item_db2_re.sql40
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,