750XCmsV

1DROP TABLE IF EXISTS `items_crackable_rewards`;
2CREATE TABLE `items_crackable_rewards`  (
3  `item_id` int(11) NOT NULL,
4  `hit_requirement` int(11) NOT NULL,
5  `crackable_type` enum('PRIVATE','PUBLIC') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'PRIVATE',
6  `reward_type` enum('BADGE','ITEM','COINS','VIP_POINTS','ACTIVITY_POINTS','EFFECT') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'BADGE',
7  `reward_data` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
8  `reward_data_int` int(11) NOT NULL DEFAULT 11,
9  PRIMARY KEY (`item_id`) USING BTREE
10) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
11
12-- ----------------------------
13-- Records of items_crackable_rewards
14-- ----------------------------
15INSERT INTO `items_crackable_rewards` VALUES (3382, 16, 'PRIVATE', 'COINS', '0', 11);