Advertisement
Guest User

Untitled

a guest
Jun 24th, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. DB modifications
  2.  
  3. ALTER TABLE `loginlog` ADD `unique_id` INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `rcode`;
  4.  
  5. ALTER TABLE `login` ADD `last_unique_id` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
  6.  
  7. ALTER TABLE `login` ADD `blocked_unique_id` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
  8.  
  9. CREATE TABLE IF NOT EXISTS `gepard_block` (
  10. `unique_id` int(11) unsigned NOT NULL DEFAULT '0',
  11. `unban_time` datetime NOT NULL,
  12. `reason` varchar(50) NOT NULL,
  13. UNIQUE KEY `unique_id` (`unique_id`)
  14. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  15.  
  16. CREATE TABLE IF NOT EXISTS `gepard_block_log` (
  17. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  18. `unique_id` int(11) unsigned NOT NULL DEFAULT '0',
  19. `block_time` datetime NOT NULL,
  20. `unban_time` datetime NOT NULL,
  21. `violator_name` varchar(24) NOT NULL,
  22. `violator_account_id` int(11) NOT NULL,
  23. `initiator_name` varchar(24) NOT NULL,
  24. `initiator_account_id` int(11) NOT NULL,
  25. `reason` varchar(50) NOT NULL,
  26. PRIMARY KEY (`id`)
  27. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement