CREATE TABLE IF NOT EXISTS `player_inventory` (
        `id` int(11) NOT NULL AUTO_INCREMENT,
        `item_id` mediumint(7) NOT NULL,
        `pid` int(11) NOT NULL,
        `type` tinyint(3) NOT NULL,
        `on` tinyint(1) NOT NULL DEFAULT '0',
        `amount` mediumint(7) NOT NULL,
        `bone` tinyint(2),
        `offset_x` double NOT NULL DEFAULT '0.0',
        `offset_y` double NOT NULL DEFAULT '0.0',
        `offset_z` double NOT NULL DEFAULT '0.0',
        `rot_x` double NOT NULL DEFAULT '0.0',
        `rot_y` double NOT NULL DEFAULT '0.0',
        `rot_z` double NOT NULL DEFAULT '0.0',
        `materialc1` int(11) NOT NULL,
        `materialc2` int(11) NOT NULL,
        PRIMARY KEY (`id`),
        UNIQUE KEY `id` (`id`),
        KEY `pid` (`pid`),
        KEY `itemid` (`itemid`),
        KEY `type` (`type`)) ENGINE=MyISAM AUTO_INCREMENT=60000 DEFAULT CHARSET=utf8;