rendered paste body*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