From 98f7e84cd7692c8cc982ea15ce26c4d546e705b5 Mon Sep 17 00:00:00 2001
From: skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec>
Date: Wed, 15 Mar 2006 14:00:32 +0000
Subject: - Added item_db2.sql and mob_db2.sql, thanks to Joshuaali - Added
 more usage of msg_athena on the slave atcommands.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5609 54d463be-8e91-2dee-dedb-b68131a5f0ec
---
 sql-files/item_db2.sql | 38 ++++++++++++++++++++++++++++++++++++++
 1 file changed, 38 insertions(+)
 create mode 100755 sql-files/item_db2.sql

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

diff --git a/sql-files/item_db2.sql b/sql-files/item_db2.sql
new file mode 100755
index 000000000..136b77e81
--- /dev/null
+++ b/sql-files/item_db2.sql
@@ -0,0 +1,38 @@
+--
+-- Table structure for table `item_db2`
+--
+
+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` tinyint(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` tinyint(3) unsigned default NULL,
+  `script` text,
+  PRIMARY KEY  (`id`)
+) TYPE=MyISAM;
+
+-- ID,'Name','Name','Type','Price','Sell','Weight','ATK','DEF','Range','Slot','Job','Upper','Gender','Loc','wLV','eLV','Refineable','View','Script');
+-- =============================================================
+-- THQ Quest Items
+-- =============================================================
+REPLACE INTO `item_db2` VALUES (7950,'THG_Membership','THG Membership',3,NULL,10,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+REPLACE INTO `item_db2` VALUES (7951,'Token_Bag','Token Bag',3,NULL,10,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+REPLACE INTO `item_db2` VALUES (1998,'Jeramiah\'s_Jur','Jeramiah\'s Jur',3,NULL,10,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+REPLACE INTO `item_db2` VALUES (1999,'Zed\'s_Staff','Zed\'s Staff',3,NULL,10,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+
-- 
cgit v1.2.3-60-g2f50