Manual:Tabla protected_titles
↑ Manual:Contenido | MediaWiki database layout | protected_titles table |
Versión de MediaWiki: | ≥ 1.12 |
La tabla protected_titles contiene Protección de páginas inexistentes. Restrictions on existing pages are stored in the page_restrictions table.
The list of protected pages can be found at Special:Protectedtitles.
Campos
pt_namespace
pt_title
pt_user
Usuario id de usuario quién protegió el título de página.
pt_reason
Versión de MediaWiki: | ≤ 1.32 |
Comentario de protección.
(desaprobado) pt_reason_id y el comment tabla tendría que ser utilizada en cambio!
pt_reason_id
Versión de MediaWiki: | ≥ 1.30 |
Esta es una clave foránea a comment_id en la tabla comment .
pt_timestamp
Timestamp de cuándo se hizo la acción de protección
pt_expiry
El tiempo cuándo la protección expira
pt_create_perm
Resumen del esquema
Versión de MediaWiki: | ≥ 1.36 |
DESCRIBE protected_titles;
+----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | pt_namespace | int(11) | NO | PRI | NULL | | | pt_title | varbinary(255) | NO | PRI | NULL | | | pt_user | int(10) unsigned | NO | | NULL | | | pt_reason_id | bigint(20) unsigned | NO | | NULL | | | pt_timestamp | binary(14) | NO | MUL | NULL | | | pt_expiry | varbinary(14) | NO | | NULL | | | pt_create_perm | varbinary(60) | NO | | NULL | | +----------------+---------------------+------+-----+---------+-------+
Versiones de MediaWiki: | 1.33 – 1.35 |
DESCRIBE protected_titles;
+----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | pt_namespace | int(11) | NO | PRI | NULL | | | pt_title | varbinary(255) | NO | PRI | NULL | | | pt_user | int(10) unsigned | NO | | NULL | | | pt_reason_id | bigint(20) unsigned | NO | | NULL | | | pt_timestamp | binary(14) | NO | MUL | NULL | | | pt_expiry | varbinary(14) | NO | | | | | pt_create_perm | varbinary(60) | NO | | NULL | | +----------------+---------------------+------+-----+---------+-------+
Versiones de MediaWiki: | 1.30 – 1.32 |
DESCRIBE protected_titles;
+----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | pt_namespace | int(11) | NO | PRI | NULL | | | pt_title | varbinary(255) | NO | PRI | NULL | | | pt_user | int(10) unsigned | NO | | NULL | | | pt_reason | varbinary(767) | YES | | | | | pt_reason_id | bigint(20) unsigned | NO | | 0 | | | pt_timestamp | binary(14) | NO | MUL | NULL | | | pt_expiry | varbinary(14) | NO | | | | | pt_create_perm | varbinary(60) | NO | | NULL | | +----------------+---------------------+------+-----+---------+-------+
Versiones de MediaWiki: | 1.25 – 1.29 |
DESCRIBE protected_titles;
+----------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------+------+-----+---------+-------+ | pt_namespace | int(11) | NO | PRI | NULL | | | pt_title | varbinary(255) | NO | PRI | NULL | | | pt_user | int(10) unsigned | NO | | NULL | | | pt_reason | varbinary(767) | YES | | NULL | | | pt_timestamp | binary(14) | NO | MUL | NULL | | | pt_expiry | varbinary(14) | NO | | | | | pt_create_perm | varbinary(60) | NO | | NULL | | +----------------+------------------+------+-----+---------+-------+
Versiones de MediaWiki: | 1.12 – 1.24 |
DESCRIBE protected_titles;
+----------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------+------+-----+---------+-------+ | pt_namespace | int(11) | NO | PRI | NULL | | | pt_title | varbinary(255) | NO | PRI | NULL | | | pt_user | int(10) unsigned | NO | | NULL | | | pt_reason | tinyblob | YES | | NULL | | | pt_timestamp | binary(14) | NO | MUL | NULL | | | pt_expiry | varbinary(14) | NO | | | | | pt_create_perm | varbinary(60) | NO | | NULL | | +----------------+------------------+------+-----+---------+-------+