B5ChKXdC

1DB modifications
2
3ALTER TABLE `loginlog` ADD `unique_id` INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `rcode`;
4
5ALTER TABLE  `login` ADD  `last_unique_id` INT( 11 ) UNSIGNED NOT NULL DEFAULT  '0';
6
7ALTER TABLE  `login` ADD  `blocked_unique_id` INT( 11 ) UNSIGNED NOT NULL DEFAULT  '0';
8
9CREATE 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
16CREATE 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;