Manual:Ipblocks table/ja

Ipblocks テーブルは、編集からブロックされた IP アドレスと利用者の詳細を保管します.

ipb_id
主キー、プライバシーのために導入されました.

ipb_address
ブロックされた dotted-quad 形式の IP アドレスあるいは利用者 ID.

ipb_user
ブロックされた利用者 ID. IP ブロックの場合 0.

ipb_by
ブロックした管理者の利用者 ID.

ipb_by_text
ブロックした管理者の利用者名 (テキスト形式).

ipb_reason
管理者が入力したブロック理由.

ipb_timestamp
Creation (or refresh) date in standard YMDHMS form.

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
If set to 1, the block only applies to logged out users.

ipb_create_account
Prevents account creation from matching IP addresses.

ipb_enable_autoblock
Enables autoblock on the block.

ipb_expiry
Expiry time set by the administrator at the time of the block. A standard timestamp or the string 'infinity'

ipb_range_start
The first IP in an IP range block.

ipb_range_end
The last IP in an IP range block.

ipb_deleted
Allows the entry to be flagged, hiding it from users and sysops.

ipb_block_email
Prevents the user from accessing Special:Emailuser

ipb_allow_usertalk
Prevents a blocked user from editing their talk page. A value of 1 means that the user is not allowed to edit his user talk page. (Thus, a less confusing name would have been ipb_block_usertalk).

ipb_parent_block_id
ID of the block that caused this block to exist. Autoblocks set this to the original block so that the original block being deleted also deletes the autoblocks.

関連ページ: range blocks, admininstrator's guide to blocking, bans, bans and blocks.

現在のバージョン
mysql> describe ipblocks; +--+--+--+-+++ +--+--+--+-+++ +--+--+--+-+++ 18 rows in set (0.00 sec)
 * Field               | Type             | Null | Key | Default        | 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         | varbinary(255)   | NO   |     |                |                |
 * ipb_reason          | tinyblob         | NO   |     | NULL           |                |
 * ipb_timestamp       | binary(14)       | NO   | MUL |                |                |
 * ipb_auto            | tinyint(1)       | NO   |     | 0              |                |
 * ipb_anon_only       | tinyint(1)       | NO   |     | 0              |                |
 * ipb_create_account  | tinyint(1)       | NO   |     | 1              |                |
 * ipb_enable_autoblock | tinyint(1)      | NO   |     | 1              |                |
 * ipb_expiry          | varbinary(14)    | NO   | MUL |                |                |
 * ipb_range_start     | tinyblob         | NO   | MUL | NULL           |                |
 * ipb_range_end       | tinyblob         | NO   |     | NULL           |                |
 * ipb_deleted         | tinyint(1)       | NO   |     | 0              |                |
 * ipb_block_email     | tinyint(1)       | NO   |     | 0              |                |
 * ipb_allow_usertalk  | tinyint(1)       | NO   |     | 0              |                |
 * ipb_parent_block_id | int(11)          | YES  | MUL | NULL           |                |

過去のバージョン
+--+--+--+-+++ +--+--+--+-+++ +--+--+--+-+++
 * Field               | Type             | Null | Key | Default        | 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              |                |

+--+--+--+-+++ +--+--+--+-+++ +--+--+--+-+++
 * Field               | Type             | Null | Key | Default        | 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              |                |

+--+--+--+-+++ +--+--+--+-+++ +--+--+--+-+++
 * Field               | Type             | Null | Key | Default        | 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              |                |

+--+-+--+-+-++ +--+-+--+-+-++ +--+-+--+-+-++
 * Field               | Type            | Null | Key | Default | 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    |                |

++-+--+-+-++ ++-+--+-+-++ ++-+--+-+-++
 * Field             | Type            | Null | Key | Default | 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    |                |

++-+--+-+-++ ++-+--+-+-++ ++-+--+-+-++
 * Field             | Type            | Null | Key | Default | 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    |                |

++-+--+-+-++ ++-+--+-+-++ ++-+--+-+-++
 * Field             | Type            | Null | Key | Default | 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    |                |