*Column Information For - l2jdb.character_inventory*/ ------------------------------------------------------ Field Type Collation Null Key Default Extra Privileges Comment ------------- ------------- ----------------- ------ ------ ------- ------ ------------------------------- ------- char_obj_id decimal(10,0) NULL YES (NULL) select,insert,update,references object_id decimal(11,0) NULL PRI 0 select,insert,update,references item_id decimal(6,0) NULL YES (NULL) select,insert,update,references name varchar(25) latin1_general_ci YES (NULL) select,insert,update,references count decimal(10,0) NULL YES (NULL) select,insert,update,references equipSlot decimal(11,0) NULL YES (NULL) select,insert,update,references enchant_level decimal(2,0) NULL YES (NULL) select,insert,update,references /*Index Information For - l2jdb.character_inventory*/ ----------------------------------------------------- Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment ------------------- ---------- -------- ------------ ----------- --------- ----------- -------- ------ ------ ---------- ------- character_inventory 0 PRIMARY 1 object_id A 16520 (NULL) (NULL) BTREE /*DDL Information For - l2jdb.character_inventory*/ --------------------------------------------------- Table Create Table ------------------- ------------------------------------------------------------------ character_inventory CREATE TABLE `character_inventory` ( `char_obj_id` decimal(10,0) default NULL, `object_id` decimal(11,0) NOT NULL default '0', `item_id` decimal(6,0) default NULL, `name` varchar(25) collate latin1_general_ci default NULL, `count` decimal(10,0) default NULL, `equipSlot` decimal(11,0) default NULL, `enchant_level` decimal(2,0) default NULL, PRIMARY KEY (`object_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci