SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS `item_proto`;
CREATE TABLE `item_proto` (
`vnum` int(11) UNSIGNED NOT NULL DEFAULT 0,
`name` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Noname ',
`locale_name` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Noname ',
`type` tinyint(2) NOT NULL DEFAULT 0,
`subtype` tinyint(2) NOT NULL DEFAULT 0,
`weight` tinyint(3) NOT NULL DEFAULT 0,
`size` tinyint(3) NOT NULL DEFAULT 0,
`antiflag` int(11) NOT NULL DEFAULT 0,
`flag` int(11) NOT NULL DEFAULT 0,
`wearflag` int(11) NOT NULL DEFAULT 0,
`immuneflag` set('PARA','CURSE','STUN','SLEEP','SLOW','POISON','TERROR') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`gold` int(11) NOT NULL DEFAULT 0,
`shop_buy_price` int(10) UNSIGNED NOT NULL DEFAULT 0,
`refined_vnum` int(10) UNSIGNED NOT NULL DEFAULT 0,
`refine_set` smallint(11) UNSIGNED NOT NULL DEFAULT 0,
`magic_pct` tinyint(4) NOT NULL DEFAULT 0,
`limittype0` tinyint(4) NOT NULL DEFAULT 0,
`limitvalue0` int(11) NOT NULL DEFAULT 0,
`limittype1` tinyint(4) NOT NULL DEFAULT 0,
`limitvalue1` int(11) NOT NULL DEFAULT 0,
`applytype0` tinyint(4) NOT NULL DEFAULT 0,
`applyvalue0` int(11) NOT NULL DEFAULT 0,
`applytype1` tinyint(4) NOT NULL DEFAULT 0,
`applyvalue1` int(11) NOT NULL DEFAULT 0,
`applytype2` tinyint(4) NOT NULL DEFAULT 0,
`applyvalue2` int(11) NOT NULL DEFAULT 0,
`value0` int(11) NOT NULL DEFAULT 0,
`value1` int(11) NOT NULL DEFAULT 0,
`value2` int(11) NOT NULL DEFAULT 0,
`value3` int(11) NOT NULL DEFAULT 0,
`value4` int(11) NOT NULL DEFAULT 0,
`value5` int(11) NOT NULL DEFAULT 0,
`socket0` tinyint(4) NOT NULL DEFAULT -1,
`socket1` tinyint(4) NOT NULL DEFAULT -1,
`socket2` tinyint(4) NOT NULL DEFAULT -1,
`socket3` tinyint(4) NOT NULL DEFAULT -1,
`socket4` tinyint(4) NOT NULL DEFAULT -1,
`socket5` tinyint(4) NOT NULL DEFAULT -1,
`specular` tinyint(4) NOT NULL DEFAULT 0,
`socket_pct` smallint(5) NOT NULL DEFAULT 0,
`addon_type` smallint(6) NOT NULL DEFAULT 0,
`vnum_range` tinyint(4) NOT NULL DEFAULT 0,
PRIMARY KEY (`vnum`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;