From 5321d32c8d670fbfbfe02f7df5066170aa20ee2e Mon Sep 17 00:00:00 2001
From: shennetsind <ind@henn.et>
Date: Fri, 14 Jun 2013 08:50:45 -0300
Subject: 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>
---
 sql-files/item_db2_re.sql | 40 +++++++++++++++++++++-------------------
 1 file changed, 21 insertions(+), 19 deletions(-)

(limited to 'sql-files/item_db2_re.sql')

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,
-- 
cgit v1.2.3-60-g2f50

