5CrjiXP7

1DROP TABLE IF EXISTS `items_crackable`;
2CREATE TABLE `items_crackable`  (
3  `item_id` int(11) NOT NULL,
4  `count` int(11) NOT NULL,
5  `prizes` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'Used in the format of item_id:chance;item_id_2:chance. item_id must be id in the items_base table. Default value for chance is 100.',
6  `achievement_tick` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
7  `achievement_cracked` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
8  `required_effect` int(3) NOT NULL DEFAULT 0,
9  `subscription_duration` int(3) NULL DEFAULT NULL,
10  `subscription_type` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT 'hc for Habbo Club, bc for Builders Club',
11  PRIMARY KEY (`item_id`) USING BTREE
12) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;