subscription query

DROP TABLE IF EXISTS `subscriptions`;
CREATE TABLE `subscriptions`  (
  `id` int(10) NOT NULL DEFAULT 0,
  `name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `badge_code` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `credits` int(11) NOT NULL DEFAULT 100,
  `duckets` int(11) NOT NULL DEFAULT 100,
  `respects` int(11) NOT NULL DEFAULT 3,
  `diamonds` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of subscriptions
-- ----------------------------
INSERT INTO `subscriptions` VALUES (1, 'Silver VIP', 'SVIP', 200, 150, 15, 0);
INSERT INTO `subscriptions` VALUES (2, 'Gold VIP', 'GVIP', 300, 200, 20, 0);
INSERT INTO `subscriptions` VALUES (3, 'Events Staff', 'EVENT', 500, 250, 20, 0);