| 1 | # |
|---|
| 2 | # Table structure for table `item_db2` |
|---|
| 3 | # |
|---|
| 4 | |
|---|
| 5 | DROP TABLE IF EXISTS `item_db2`; |
|---|
| 6 | CREATE TABLE `item_db2` ( |
|---|
| 7 | `id` smallint(5) unsigned NOT NULL default '0', |
|---|
| 8 | `name_english` varchar(50) NOT NULL default '', |
|---|
| 9 | `name_japanese` varchar(50) NOT NULL default '', |
|---|
| 10 | `type` tinyint(2) unsigned NOT NULL default '0', |
|---|
| 11 | `price_buy` mediumint(10) unsigned default NULL, |
|---|
| 12 | `price_sell` mediumint(10) unsigned default NULL, |
|---|
| 13 | `weight` smallint(5) unsigned NOT NULL default '0', |
|---|
| 14 | `attack` smallint(3) unsigned default NULL, |
|---|
| 15 | `defence` tinyint(3) unsigned default NULL, |
|---|
| 16 | `range` tinyint(2) unsigned default NULL, |
|---|
| 17 | `slots` tinyint(2) unsigned default NULL, |
|---|
| 18 | `equip_jobs` int(12) unsigned default NULL, |
|---|
| 19 | `equip_upper` tinyint(8) unsigned default NULL, |
|---|
| 20 | `equip_genders` tinyint(2) unsigned default NULL, |
|---|
| 21 | `equip_locations` smallint(4) unsigned default NULL, |
|---|
| 22 | `weapon_level` tinyint(2) unsigned default NULL, |
|---|
| 23 | `equip_level` tinyint(3) unsigned default NULL, |
|---|
| 24 | `refineable` tinyint(1) unsigned default NULL, |
|---|
| 25 | `view` smallint(3) unsigned default NULL, |
|---|
| 26 | `script` text, |
|---|
| 27 | `equip_script` text, |
|---|
| 28 | `unequip_script` text, |
|---|
| 29 | PRIMARY KEY (`id`) |
|---|
| 30 | ) ENGINE=MyISAM; |
|---|
| 31 | |
|---|
| 32 | # Items Additional Database - Custom Items go here |
|---|
| 33 | # |
|---|
| 34 | # Structure of Database: |
|---|
| 35 | # REPLACE INTO `item_db` VALUES ( ID,'Name','Name',Type,Price,Sell,Weight,ATK,DEF,Range,Slot,Job,Upper,Gender,Loc,wLV,eLV,Refineable,View,' Script ',' OnEquip_Script ',' OnUnequip_Script '); |
|---|
| 36 | # |
|---|
| 37 | # THQ Quest Items |
|---|
| 38 | # ============================================================= |
|---|
| 39 | # 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,NULL,NULL); |
|---|
| 40 | # 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,NULL,NULL); |
|---|
| 41 | # 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,NULL,NULL); |
|---|
| 42 | # 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,NULL,NULL); |
|---|
