DROP TABLE IF EXISTS `items_crackable_rewards`;
CREATE TABLE `items_crackable_rewards`  (
  `item_id` int(11) NOT NULL,
  `hit_requirement` int(11) NOT NULL,
  `crackable_type` enum('PRIVATE','PUBLIC') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'PRIVATE',
  `reward_type` enum('BADGE','ITEM','COINS','VIP_POINTS','ACTIVITY_POINTS','EFFECT') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'BADGE',
  `reward_data` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `reward_data_int` int(11) NOT NULL DEFAULT 11,
  PRIMARY KEY (`item_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of items_crackable_rewards
-- ----------------------------
INSERT INTO `items_crackable_rewards` VALUES (3382, 16, 'PRIVATE', 'COINS', '0', 11);