diff options
| author | skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-03-15 14:00:32 +0000 |
|---|---|---|
| committer | skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-03-15 14:00:32 +0000 |
| commit | 98f7e84cd7692c8cc982ea15ce26c4d546e705b5 (patch) | |
| tree | a8c938592eb6eacdf54c1006e594793e8358636d /sql-files/item_db2.sql | |
| parent | fac79cd757f3441741f4ad70d9ce511781f8be3f (diff) | |
| download | hercules-98f7e84cd7692c8cc982ea15ce26c4d546e705b5.tar.gz hercules-98f7e84cd7692c8cc982ea15ce26c4d546e705b5.tar.bz2 hercules-98f7e84cd7692c8cc982ea15ce26c4d546e705b5.tar.xz hercules-98f7e84cd7692c8cc982ea15ce26c4d546e705b5.zip | |
- 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
Diffstat (limited to 'sql-files/item_db2.sql')
| -rwxr-xr-x | sql-files/item_db2.sql | 38 |
1 files changed, 38 insertions, 0 deletions
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);
+
|