Tabela ipblocks przechowuje szczegółowe informacje na temat adresów IP i użytkowników, którzy zostali pozbawieni praw edycji.
+----------------------+------------------+------+-----+-----------+-------------+
| Pole | Typ | Null |Klucz| Domyślnie | Extra |
+----------------------+------------------+------+-----+-----------+-------------+
| ipb_id | int(11) | NO | PRI | | auto_increment |
| ipb_address | tinyblob | NO | | | |
| ipb_user | int(10) unsigned | NO | MUL | 0 | |
| ipb_by | int(10) unsigned | NO | | 0 | |
| ipb_by_text | varbinary(255) | NO | | | |
| ipb_reason | tinyblob | NO | | | |
| ipb_timestamp | binary(14) | NO | MUL | | |
| ipb_auto | bool | NO | | 0 | |
| ipb_anon_only | bool | NO | | 0 | |
| ipb_create_account | bool | NO | | 1 | |
| ipb_enable_autoblock | bool | NO | | 1 | |
| ipb_expiry | varbinary(14) | NO | MUL | | |
| ipb_range_start | tinyblob | NO | MUL | NULL | |
| ipb_range_end | tinyblob | NO | | NULL | |
| ipb_deleted | bool | NO | | 0 | |
| ipb_block_email | bool | NO | | 0 | |
| ipb_allow_usertalk | bool | NO | | 0 | |
+----------------------+------------------+------+-----+----------------+----------------+
- ipb_id
- Primary key, wprowadzony dla prywatności.
- ipb_address
- Blocked IP address in dotted-quad form or user name.
- ipb_user
- ID użytkownika zablokowanego lub 0 jeżeli IP.
- ipb_by
- ID użytkownika(administratora), który nałożył blokadę.
- ipb_by_text
- Nazwa użytkownika(administratora), który nałożył blokadę.
- ipb_reason
- Powód blokady.
- ipb_timestamp
- Czas utworzenia lub aktualizacji w formie YMDHMS.
- ipb_auto
- Indicates that the IP address was banned because a banned user accessed a page through it. If this is 1, ipb_address will be hidden.
- ipb_anon_only
- Jeżeli ustawione na "1", blokada będzie dotyczyć tylko niezalogowanych użytkowników.
- ipb_create_account
- Zapobiega tworzeniu nowych kont z podanego adresu IP.
- ipb_enable_autoblock
- Enables autoblock on the block.
- ipb_expiry
- Czas wygaśnięcia ustawiony przez administratora lub 'infinity' dla niewygasających.
- ipb_range_start
- Pierwszy IP w blokowanym zakresie IP.
- ipb_range_end
- Ostatni IP w blokowanym zakresie IP.
- ipb_deleted
- Allows the entry to be flagged, hiding it from users and sysops.
- ipb_block_email
- Zapobiega dostępowi do Special:Emailuser
- ipb_allow_usertalk
- Zapobiega edycji zablokowanemu użytkownikowi edycji swojej strony dyskusji.
Podobne strony: blokowanie zakresów, przewodnik administratora-blokowanie, bans/pl, bans and blocks/pl.
Poprzednie wersje [edit]
+----------------------+------------------+------+-----+-----------+-------------+
| Pole | Typ | Null |Klucz| Domyślnie | Extra |
+----------------------+------------------+------+-----+-----------+-------------+
| ipb_id | int(11) | NO | PRI | NULL | auto_increment |
| ipb_address | tinyblob | NO | MUL | NULL | |
| ipb_user | int(10) unsigned | NO | MUL | 0 | |
| ipb_by | int(10) unsigned | NO | | 0 | |
| ipb_by_text | varchar(255) | NO | | | |
| ipb_reason | tinyblob | NO | | NULL | |
| ipb_timestamp | binary(14) | NO | MUL | | |
| ipb_auto | bool | NO | | 0 | |
| ipb_anon_only | bool | NO | | 0 | |
| ipb_create_account | bool | NO | | 1 | |
| ipb_enable_autoblock | bool | NO | | 1 | |
| ipb_expiry | varbinary(14) | NO | MUL | | |
| ipb_range_start | tinyblob | NO | MUL | NULL | |
| ipb_range_end | tinyblob | NO | | NULL | |
| ipb_deleted | bool | NO | | 0 | |
| ipb_block_email | bool | NO | | 0 | |
+----------------------+------------------+------+-----+----------------+----------------+
+----------------------+------------------+------+-----+-----------+-------------+
| Pole | Typ | Null |Klucz| Domyślnie | Extra |
+----------------------+------------------+------+-----+-----------+-------------+
| ipb_id | int(11) | NO | PRI | NULL | auto_increment |
| ipb_address | tinyblob | NO | MUL | NULL | |
| ipb_user | int(10) unsigned | NO | MUL | 0 | |
| ipb_by | int(10) unsigned | NO | | 0 | |
| ipb_by_text | varchar(255) | NO | | | |
| ipb_reason | tinyblob | NO | | NULL | |
| ipb_timestamp | binary(14) | NO | MUL | | |
| ipb_auto | bool | NO | | 0 | |
| ipb_anon_only | bool | NO | | 0 | |
| ipb_create_account | bool | NO | | 1 | |
| ipb_enable_autoblock | bool | NO | | 1 | |
| ipb_expiry | varbinary(14) | NO | MUL | | |
| ipb_range_start | tinyblob | NO | MUL | NULL | |
| ipb_range_end | tinyblob | NO | | NULL | |
| ipb_deleted | bool | NO | | 0 | |
+----------------------+------------------+------+-----+----------------+----------------+
+----------------------+------------------+------+-----+-----------+-------------+
| Pole | Typ | Null |Klucz| Domyślnie | Extra |
+----------------------+------------------+------+-----+-----------+-------------+
| ipb_id | int(8) | NO | PRI | NULL | auto_increment |
| ipb_address | tinyblob | NO | MUL | NULL | |
| ipb_user | int(8) unsigned | NO | MUL | 0 | |
| ipb_by | int(8) unsigned | NO | | 0 | |
| ipb_reason | tinyblob | NO | | NULL | |
| ipb_timestamp | char(14) | NO | MUL | NULL | |
| ipb_auto | bool | NO | | 0 | |
| ipb_anon_only | bool | NO | | 0 | |
| ipb_create_account | bool | NO | | 1 | |
| ipb_enable_autoblock | bool | NO | | 1 | |
| ipb_expiry | char(14) | NO | MUL | NULL | |
| ipb_range_start | tinyblob | NO | MUL | NULL | |
| ipb_range_end | tinyblob | NO | | NULL | |
+----------------------+-----------------+------+-----+---------+----------------+
+----------------------+------------------+------+-----+-----------+-------------+
| Pole | Typ | Null |Klucz| Domyślnie | Extra |
+----------------------+------------------+------+-----+-----------+-------------+| ipb_id | int(8) | NO | PRI | NULL | auto_increment |
| ipb_address | tinyblob | NO | MUL | NULL | |
| ipb_user | int(8) unsigned | NO | MUL | 0 | |
| ipb_by | int(8) unsigned | NO | | 0 | |
| ipb_reason | tinyblob | NO | | NULL | |
| ipb_timestamp | char(14) | NO | MUL | NULL | |
| ipb_auto | bool | NO | | 0 | |
| ipb_anon_only | bool | NO | | 0 | |
| ipb_create_account | bool | NO | | 1 | |
| ipb_expiry | char(14) | NO | MUL | NULL | |
| ipb_range_start | tinyblob | NO | MUL | NULL | |
| ipb_range_end | tinyblob | NO | | NULL | |
+--------------------+-----------------+------+-----+---------+----------------+
+----------------------+------------------+------+-----+-----------+-------------+
| Pole | Typ | Null |Klucz| Domyślnie | Extra |
+----------------------+------------------+------+-----+-----------+-------------+| ipb_id | int(8) | NO | PRI | NULL | auto_increment |
| ipb_address | tinyblob | NO | MUL | NULL | |
| ipb_user | int(8) unsigned | NO | MUL | 0 | |
| ipb_by | int(8) unsigned | NO | | 0 | |
| ipb_reason | tinyblob | NO | | NULL | |
| ipb_timestamp | char(14) | NO | MUL | NULL | |
| ipb_auto | tinyint(1) | NO | | 0 | |
| ipb_expiry | char(14) | NO | MUL | NULL | |
| ipb_range_start | tinyblob | NO | MUL | NULL | |
| ipb_range_end | tinyblob | NO | | NULL | |
+--------------------+-----------------+------+-----+---------+----------------+
+----------------------+------------------+------+-----+-----------+-------------+
| Pole | Typ | Null |Klucz| Domyślnie | Extra |
+----------------------+------------------+------+-----+-----------+-------------+
| ipb_id | int(8) | NO | PRI | NULL | auto_increment |
| ipb_address | tinyblob | NO | MUL | NULL | |
| ipb_user | int(8) unsigned | NO | MUL | 0 | |
| ipb_by | int(8) unsigned | NO | | 0 | |
| ipb_reason | tinyblob | NO | | NULL | |
| ipb_timestamp | char(14) | NO | MUL | NULL | |
| ipb_auto | tinyint(1) | NO | | 0 | |
| ipb_expiry | char(14) | NO | MUL | NULL | |
+--------------------+-----------------+------+-----+---------+----------------+
