-- ----------------------------
-- Table structure for item_data
-- ----------------------------
DROP TABLE IF EXISTS `item_data`;
CREATE TABLE `item_data` (
`id` int unsigned NOT NULL,
`box` tinyint unsigned NOT NULL,
`slot` int unsigned NOT NULL,
`entry` smallint unsigned NOT NULL,
`server` smallint unsigned NOT NULL,
`serial` int unsigned NOT NULL,
`serial_cash_shop` int unsigned NOT NULL,
`level` tinyint unsigned NOT NULL,
`durability` tinyint unsigned NOT NULL,
`durability_state` int(0) NOT NULL DEFAULT 0,
`skill` tinyint unsigned NOT NULL,
`luck` tinyint unsigned NOT NULL,
`option` tinyint unsigned NOT NULL,
`excellent` tinyint unsigned NOT NULL,
`ancient` tinyint unsigned NOT NULL,
`option_380` tinyint unsigned NOT NULL,
`harmony` tinyint unsigned NOT NULL,
`socket_1` smallint unsigned NOT NULL,
`socket_2` smallint unsigned NOT NULL,
`socket_3` smallint unsigned NOT NULL,
`socket_4` smallint unsigned NOT NULL,
`socket_5` smallint unsigned NOT NULL,
`socket_bonus` tinyint unsigned NOT NULL,
`locked` tinyint unsigned NOT NULL,
`data_1` int(0) NOT NULL DEFAULT 0,
`data_2` int(0) NOT NULL DEFAULT 0,
`data_3` int(0) NOT NULL DEFAULT 0,
`personal_store_price` int unsigned NOT NULL,
`personal_store_job` smallint unsigned NOT NULL,
`personal_store_jos` smallint unsigned NOT NULL,
`personal_store_joc` smallint unsigned NOT NULL,
`expire_date` bigint(0) NOT NULL DEFAULT 0,
`flags` int unsigned NOT NULL,
PRIMARY KEY (`id`, `box`, `slot`) USING BTREE,
UNIQUE INDEX `DupeInv`(`server`, `serial`, `serial_cash_shop`) USING BTREE,
INDEX `id`(`id`) USING BTREE,
INDEX `box`(`box`) USING BTREE,
INDEX `slot`(`slot`) USING BTREE,
INDEX `idx_id_and_box`(`id`, `box`) USING BTREE,
INDEX `idx_id_and_box_and_slot`(`id`, `box`, `slot`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;