m1Kc90Kq

1DROP TABLE IF EXISTS `offline_shop_item`;
2CREATE TABLE `offline_shop_item`  (
3  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
4  `owner_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
5  `pos` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
6  `count` int(11) UNSIGNED NOT NULL DEFAULT 0,
7  `vnum` int(11) UNSIGNED NOT NULL DEFAULT 0,
8  `socket0` int(10) UNSIGNED NOT NULL DEFAULT 0,
9  `socket1` int(10) UNSIGNED NOT NULL DEFAULT 0,
10  `socket2` int(10) UNSIGNED NOT NULL DEFAULT 0,
11  `socket3` int(10) UNSIGNED NOT NULL DEFAULT 0,
12  `socket4` int(10) UNSIGNED NOT NULL DEFAULT 0,
13  `socket5` int(10) UNSIGNED NOT NULL DEFAULT 0,
14  `attrtype0` tinyint(4) NOT NULL DEFAULT 0,
15  `attrvalue0` smallint(6) NOT NULL DEFAULT 0,
16  `attrtype1` tinyint(4) NOT NULL DEFAULT 0,
17  `attrvalue1` smallint(6) NOT NULL DEFAULT 0,
18  `attrtype2` tinyint(4) NOT NULL DEFAULT 0,
19  `attrvalue2` smallint(6) NOT NULL DEFAULT 0,
20  `attrtype3` tinyint(4) NOT NULL DEFAULT 0,
21  `attrvalue3` smallint(6) NOT NULL DEFAULT 0,
22  `attrtype4` tinyint(4) NOT NULL DEFAULT 0,
23  `attrvalue4` smallint(6) NOT NULL DEFAULT 0,
24  `attrtype5` tinyint(4) NOT NULL DEFAULT 0,
25  `attrvalue5` smallint(6) NOT NULL DEFAULT 0,
26  `attrtype6` tinyint(4) NOT NULL DEFAULT 0,
27  `attrvalue6` smallint(6) NOT NULL DEFAULT 0,
28  `price` bigint(11) NOT NULL DEFAULT 0,
29  `status` smallint(1) NOT NULL DEFAULT 0,
30  `currency` tinyint(2) UNSIGNED NOT NULL DEFAULT 0,
31  `transmutation` int(11) NOT NULL DEFAULT 0,
32  PRIMARY KEY (`id`) USING BTREE,
33  INDEX `owner_id_idx`(`owner_id`) USING BTREE,
34  INDEX `item_vnum_index`(`vnum`) USING BTREE
35) ENGINE = InnoDB AUTO_INCREMENT = 3470068488 CHARACTER SET = latin1 COLLATE = latin1_german1_ci ROW_FORMAT = Dynamic;