if (decode_2bytes(data) != sizeof(TItemTable))
{
sys_err("item table size error");
thecore_shutdown();
return;
}

typedef struct SItemTable : public SEntityTable
{
DWORD dwVnumRange;
char szName[ITEM_NAME_MAX_LEN + 1];
char szLocaleName[ITEM_NAME_MAX_LEN + 1];
BYTE bType;
BYTE bSubType;

BYTE bWeight;
BYTE bSize;

DWORD dwAntiFlags;
DWORD dwFlags;
DWORD dwWearFlags;
DWORD dwImmuneFlag;

#ifdef __MAX_GOLD__
long long dwGold;
long long dwShopBuyPrice;
#else
DWORD dwGold;
DWORD dwShopBuyPrice;
#endif

TItemLimit aLimits[ITEM_LIMIT_MAX_NUM];
TItemApply aApplies[ITEM_APPLY_MAX_NUM];
long alValues[ITEM_VALUES_MAX_NUM];
long alSockets[ITEM_SOCKET_MAX_NUM];
DWORD dwRefinedVnum;
WORD wRefineSet;
BYTE bAlterToMagicItemPct;
BYTE bSpecular;
BYTE bGainSocketPct;

short int sAddonType;

char cLimitRealTimeFirstUseIndex;
char cLimitTimerBasedOnWearIndex;
} TItemTable;

CREATE TABLE `item_proto` (
`vnum` int(11) UNSIGNED NOT NULL DEFAULT 0,
`name` varbinary(200) NOT NULL DEFAULT 'Noname ',
`locale_name` varbinary(24) NOT NULL DEFAULT 'Noname ',
`type` tinyint(2) NOT NULL DEFAULT 0,
`subtype` tinyint(2) NOT NULL DEFAULT 0,
`weight` tinyint(3) DEFAULT 0,
`size` tinyint(3) DEFAULT 0,
`antiflag` int(11) DEFAULT 0,
`flag` int(11) DEFAULT 0,
`wearflag` int(11) DEFAULT 0,
`immuneflag` set('PARA','CURSE','STUN','SLEEP','SLOW','POISON','TERROR') CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL DEFAULT '',
`gold` int(11) DEFAULT 0,
`shop_buy_price` bigint(255) 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) DEFAULT 0,
`limitvalue0` int(11) DEFAULT 0,
`limittype1` tinyint(4) DEFAULT 0,
`limitvalue1` int(11) DEFAULT 0,
`applytype0` tinyint(4) DEFAULT 0,
`applyvalue0` int(11) DEFAULT 0,
`applytype1` tinyint(4) DEFAULT 0,
`applyvalue1` int(11) DEFAULT 0,
`applytype2` tinyint(4) DEFAULT 0,
`applyvalue2` int(11) DEFAULT 0,
`value0` int(11) DEFAULT 0,
`value1` int(11) DEFAULT 0,
`value2` int(11) DEFAULT 0,
`value3` int(11) DEFAULT 0,
`value4` int(11) DEFAULT 0,
`value5` int(11) DEFAULT 0,
`socket0` tinyint(4) DEFAULT -1,
`socket1` tinyint(4) DEFAULT -1,
`socket2` tinyint(4) DEFAULT -1,
`socket3` tinyint(4) DEFAULT -1,
`socket4` tinyint(4) DEFAULT -1,
`socket5` tinyint(4) DEFAULT -1,
`specular` tinyint(4) NOT NULL DEFAULT 0,
`socket_pct` tinyint(4) 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 = MyISAM CHARACTER SET = big5 COLLATE = big5_chinese_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;