Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement