3vCtbsha

11 	2012-09-27 12:45:11 	samuelpr_o 	DROP TABLE IF EXISTS `phpbb_banlist` ;
2
32 	2012-09-27 12:45:11 	samuelpr_o 	CREATE TABLE `phpbb_banlist` (
4`ban_id` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
5`ban_userid` mediumint( 8 ) unsigned NOT NULL DEFAULT '0',
6`ban_ip` varchar( 40 ) COLLATE utf8_bin NOT NULL DEFAULT '',
7`ban_email` varchar( 100 ) COLLATE utf8_bin NOT NULL DEFAULT '',
8`ban_start` int( 11 ) unsigned NOT NULL DEFAULT '0',
9`ban_end` int( 11 ) unsigned NOT NULL DEFAULT '0',
10`ban_exclude` tinyint( 1 ) unsigned NOT NULL DEFAULT '0',
11`ban_reason` varchar( 255 ) COLLATE utf8_bin NOT NULL DEFAULT '',
12`ban_give_reason` varchar( 255 ) COLLATE utf8_bin NOT NULL DEFAULT '',
13PRIMARY KEY ( `ban_id` ) ,
14KEY `ban_end` ( `ban_end` ) ,
15KEY `ban_user` ( `ban_userid` , `ban_exclude` ) ,
16KEY `ban_email` ( `ban_email` , `ban_exclude` ) ,
17KEY `ban_ip` ( `ban_ip` , `ban_exclude` )
18) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
19
20# 	Data 	Nazwa użytkownika 	Instrukcja przetwarzania danych
213 	2012-09-27 13:05:20 	samuelpr_o 	DELETE FROM `phpbb_banlist` WHERE `phpbb_banlist`.`ban_id` =137;