Advertisement
Guest User

Untitled

a guest
Jun 4th, 2015
29
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.91 KB | None | 0 0
  1. -- ----------------------------
  2. -- Table structure for ranks
  3. -- ----------------------------
  4. DROP TABLE IF EXISTS `ranks`;
  5. CREATE TABLE `ranks` (
  6. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  7. `name` varchar(50) NOT NULL,
  8. `badgeid` varchar(5) DEFAULT NULL,
  9. PRIMARY KEY (`id`)
  10. ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
  11.  
  12. -- ----------------------------
  13. -- Records of ranks
  14. -- ----------------------------
  15. INSERT INTO `ranks` VALUES ('1', 'User', 'HH1');
  16. INSERT INTO `ranks` VALUES ('2', 'VIP', 'VIP');
  17. INSERT INTO `ranks` VALUES ('3', 'Ambassador', 'ADM');
  18. INSERT INTO `ranks` VALUES ('4', 'Moderator', 'ADM');
  19. INSERT INTO `ranks` VALUES ('5', 'Senior Moderator', 'ADM');
  20. INSERT INTO `ranks` VALUES ('7', 'Administrator', 'ADM');
  21. INSERT INTO `ranks` VALUES ('8', 'Manager', 'ADM');
  22. INSERT INTO `ranks` VALUES ('9', 'Co-Owner', 'ADM');
  23. INSERT INTO `ranks` VALUES ('10', 'Owner', 'ADM');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement