daily pastebin goal
9%
SHARE
TWEET

subscription query

a guest Oct 12th, 2017 85 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DROP TABLE IF EXISTS `subscriptions`;
  2. CREATE TABLE `subscriptions`  (
  3.   `id` int(10) NOT NULL DEFAULT 0,
  4.   `name` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  5.   `badge_code` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  6.   `credits` int(11) NOT NULL DEFAULT 100,
  7.   `duckets` int(11) NOT NULL DEFAULT 100,
  8.   `respects` int(11) NOT NULL DEFAULT 3,
  9.   `diamonds` int(11) NOT NULL,
  10.   PRIMARY KEY (`id`) USING BTREE
  11. ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
  12.  
  13. -- ----------------------------
  14. -- Records of subscriptions
  15. -- ----------------------------
  16. INSERT INTO `subscriptions` VALUES (1, 'Silver VIP', 'SVIP', 200, 150, 15, 0);
  17. INSERT INTO `subscriptions` VALUES (2, 'Gold VIP', 'GVIP', 300, 200, 20, 0);
  18. INSERT INTO `subscriptions` VALUES (3, 'Events Staff', 'EVENT', 500, 250, 20, 0);
RAW Paste Data
Top