Advertisement
Guest User

Table users fix Quasar

a guest
Apr 23rd, 2017
643
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.23 KB | None | 0 0
  1. DROP TABLE IF EXISTS `users`;
  2. CREATE TABLE `users` (
  3. `id` int(11) NOT NULL AUTO_INCREMENT,
  4. `user_id` int(250) DEFAULT NULL,
  5. `username` varchar(125) NOT NULL,
  6. `password` varchar(255) DEFAULT NULL,
  7. `mail` varchar(255) DEFAULT 'defaultuser@meth0d.org',
  8. `auth_ticket` varchar(60) NOT NULL,
  9. `rank` int(1) unsigned DEFAULT '1',
  10. `rank_vip` int(1) DEFAULT '0',
  11. `credits` int(11) DEFAULT '50000',
  12. `vip_points` int(11) DEFAULT '0',
  13. `activity_points` int(11) DEFAULT '5000',
  14. `look` char(255) DEFAULT NULL,
  15. `gender` enum('M','F') DEFAULT 'M',
  16. `motto` char(50) DEFAULT NULL,
  17. `account_created` char(12) DEFAULT '0',
  18. `last_online` int(11) DEFAULT '0',
  19. `online` enum('0','1') DEFAULT '0',
  20. `ip_last` varchar(45) DEFAULT '',
  21. `ip_reg` varchar(45) DEFAULT NULL,
  22. `home_room` int(10) DEFAULT '2',
  23. `is_muted` enum('0','1') DEFAULT '0',
  24. `block_newfriends` enum('0','1') DEFAULT '0',
  25. `hide_online` enum('0','1') DEFAULT '0',
  26. `hide_inroom` enum('0','1') DEFAULT '0',
  27. `vip` enum('0','1') DEFAULT '0',
  28. `volume` varchar(15) DEFAULT '100,100,100',
  29. `last_change` int(20) DEFAULT '0',
  30. `machine_id` varchar(125) DEFAULT '',
  31. `focus_preference` enum('0','1') DEFAULT '0',
  32. `chat_preference` enum('0','1') DEFAULT '0',
  33. `pets_muted` enum('0','1') DEFAULT '0',
  34. `bots_muted` enum('0','1') DEFAULT '0',
  35. `advertising_report_blocked` enum('0','1') DEFAULT '0',
  36. `gotw_points` int(11) DEFAULT '0',
  37. `ignore_invites` enum('0','1') DEFAULT '0',
  38. `time_muted` double DEFAULT '0',
  39. `allow_gifts` enum('0','1') DEFAULT '1',
  40. `trading_locked` double DEFAULT '0',
  41. `friend_bar_state` enum('0','1') NOT NULL DEFAULT '1',
  42. `disable_forced_effects` enum('0','1') NOT NULL DEFAULT '0',
  43. `allow_mimic` enum('1','0') NOT NULL DEFAULT '1',
  44. `publi` enum('0','1','2','3') NOT NULL DEFAULT '0',
  45. `guia` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
  46. `tarea` varchar(50) NOT NULL DEFAULT '0',
  47. `cms_signature` text,
  48. `cms_currency` int(99) NOT NULL,
  49. `key_colour` int(11) NOT NULL DEFAULT '0',
  50. `userpo` int(99) NOT NULL,
  51. `user_points` int(99) NOT NULL,
  52. `acc_flagged` enum('0','1') NOT NULL DEFAULT '0',
  53. `country` text,
  54. `radio` varchar(100) NOT NULL DEFAULT 'autoplay',
  55. `bancobloq` int(99) NOT NULL,
  56. `builder` enum('0','1') DEFAULT '0',
  57. `croupier` enum('1','0') DEFAULT '0',
  58. `nux_user` enum('true','false') DEFAULT 'true',
  59. `pumpkins` int(11) DEFAULT '0',
  60. `targeted_buy` int(10) NOT NULL,
  61. `namecolor` varchar(125) CHARACTER SET armscii8 COLLATE armscii8_bin NOT NULL DEFAULT '000000',
  62. `bonus_points` int(11) NOT NULL,
  63. `nametag` varchar(125) DEFAULT '',
  64. PRIMARY KEY (`id`,`auth_ticket`),
  65. UNIQUE KEY `id` (`id`) USING HASH,
  66. UNIQUE KEY `username` (`username`) USING BTREE,
  67. KEY `rank` (`rank`),
  68. KEY `ip_last` (`ip_last`),
  69. KEY `ip_reg` (`ip_reg`),
  70. KEY `credits` (`credits`),
  71. KEY `activity_points` (`activity_points`),
  72. KEY `online` (`online`),
  73. KEY `mail` (`mail`),
  74. KEY `machine_id` (`machine_id`),
  75. KEY `auth_ticket` (`auth_ticket`),
  76. KEY `last_online` (`last_online`),
  77. KEY `home_room` (`home_room`),
  78. KEY `rank_vip` (`rank_vip`),
  79. KEY `messenger` (`id`,`username`,`look`,`motto`,`last_online`) USING BTREE
  80. ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement