Manual:Page table/yo

Eto Nomba ti Yoruba

Nọmba	Kika	Itumo 0	?	? 1	ikan	1* 2	meji	2 3	meta	3 4	merin	4 5	marun	5 6	mefa	6 7	meje	7 8	mejo	8 9	mesan	9 10	mewa	10 11	mokanla	1 + 10† 12	mejila	2 + 10† 13	metala	3 + 10† 14	merinla	4 + 10† 15	medogun	-5† + 20 16	merindilogun	4 from 20 17	metadilogun	3 from 20 18	mejidilogun	2 from 20 19	mokandilogun	1 from 20 20	ogun	20 21	mokanlelogun	1 and 20 22	mejilelogun	2 and 20 23	metalelogun	3 and 20 24	merinlelogun	4 and 20 25	medogbon	-5† + 30 26	merindilogbon	4 from 30 27	metadilogbon	3 from 30 28	mejidilogbon	2 from 30 29	mokandilogbon	1 from 30 30	ogbon	30 31	mokanlelogbon	1 and 30 32	mejilelogbon	2 and 30 33	metalelogbon	3 and 30 34	merinlelogbon	4 and 30 35	marundilogoji	5 from 20* × 2* 36	merindilogoji	4 from 20* × 2* 37	metadilogoji	3 from 20* × 2* 38	mejidilogoji	2 from 20* × 2* 39	mokandilogoji	1 from 20* × 2* 40	ogoji	20* × 2* 41	mokanlelogoji	1 and 20* × 2* 42	mejilelogoji	2 and 20* × 2* 43	metalelogoji	3 and 20* × 2* 44	merinlelogoji	4 and 20* × 2* 45	marundiladota	5 from 50 46	merindiladota	4 from 50 47	metadiladota	3 from 50 48	mejidiladota	2 from 50 49	mokandiladota	1 from 50 50	adota	50 51	mokanleladota	1 and 50 52	mejileladota	2 and 50 53	metaleladota	3 and 50 54	merinleladota	4 and 50 55	marundilogota	5 from 20* × 3* 56	merindilogota	4 from 20* × 3* 57	metadilogota	3 from 20* × 3* 58	mejidilogota	2 from 20* × 3* 59	mokandilogota	1 from 20* × 3* 60	ogota	20* × 3* 61	mokanlelogota	1 and 20* × 3* 62	mejilelogota	2 and 20* × 3* 63	metalelogota	3 and 20* × 3* 64	merinlelogota	4 and 20* × 3* 65	marundiladorin	5 from 70 66	merindiladorin	4 from 70 67	metadiladorin	3 from 70 68	mejidiladorin	2 from 70 69	mokandiladorin	1 from 70 70	adorin	70 71	mokanleladorin	1 and 70 72	mejileladorin	2 and 70 73	metaleladorin	3 and 70 74	merinleladorin	4 and 70 75	marundilogorin	5 from 20* × 4* 76	merindilogorin	4 from 20* × 4* 77	metadilogorin	3 from 20* × 4* 78	mejidilogorin	2 from 20* × 4* 79	mokandilogorin	1 from 20* × 4* 80	ogorin	20* × 4* 81	mokanlelogorin	1 and 20* × 4* 82	mejilelogorin	2 and 20* × 4* 83	metalelogorin	3 and 20* × 4* 84	merinlelogorin	4 and 20* × 4* 85	marundiladorun	5 from 90 86	merindiladorun	4 from 90 87	metadiladorun	3 from 90 88	mejidiladorun	2 from 90 89	mokandiladorun	1 from 90 90	adorun	90 91	mokanleladorun	1 and 90 92	mejileladorun	2 and 90 93	metaleladorun	3 and 90 94	merinleladorun	4 and 90 95	marundilogorun	5 from 20* × 5* 96	merindilogorun	4 from 20* × 5* 97	metadilogorun	3 from 20* × 5* 98	mejidilogorun	2 from 20* × 5* 99	mokandilogorun	1 from 20* × 5* 100	ogorun	20* × 5*

† Different word
 * Different form

Note: Number	Reading	Meaning 100	ogorun	20* × 5* 200	ogorun meji	(20* × 5*) × 2 300	ogorun meta	(20* × 5*) × 3 400	ogorun merin	(20* × 5*) × 4 500	ogorun marun	(20* × 5*) × 5 600	ogorun mefa	(20* × 5*) × 6 700	ogorun meje	(20* × 5*) × 7 800	ogorun mejo	(20* × 5*) × 8 900	ogorun mesan	(20* × 5*) × 9 1000	egberun	1000 Each page in a MediaWiki installation has an entry here which identifies it by title and contains some essential metadata. It was first introduced in r6710, in MediaWiki 1.5.

The text of the page itself is stored in the table. To retrieve the text of an article, MediaWiki first searches for page_title in the page table. Then, page_latest is used to search the table for, and  is obtained in the process. The value obtained for is used to search for  in the text table to retrieve the text. When a page is deleted, the revisions are moved to the table.

page_id
Uniquely identifying primary key. This value is preserved across edits and renames.

Page IDs do not change when pages are moved, but they may change when pages are deleted and then restored. As of MediaWiki 1.27, the historical page ID is persisted in the table, and restored pages attempt to reclaim their old page ID.

MediaWiki offers a number of relevant tools:

For example, Special:Redirect/page/, redirects to the present page. For example, [///w/index.php?curid= /w/index.php?curid=] will load the present page.
 * The page ID of any page (except special pages) can be looked up in the "page information" link from the Tools menu.
 * The magic word  can be used to return the page id of a page.
 * The special page Special:Redirect can be used to access pages via their page IDs.
 * index.php accepts the parameter  to access pages via their page IDs.

There are also many API features that either return the page ID or use it as an input. For example, for the present page,, see https://www.mediawiki.org/w/api.php?action=query&prop=info&titles=Manual:Page%20table and https://www.mediawiki.org/w/api.php?action=query&prop=info&pageids=10501. This field can be accessed by, , etc.

page_namespace
A page name is broken into a namespace and a title. The namespace keys are UI-language-independent constants, defined in.

This field contains the number of the page's namespace. The values range from 0 to 99 for the core namespaces, and from 100 to 10,000 for custom namespaces.

page_title
The sanitized page title, without the namespace, with a maximum of 255 characters (binary). It is stored as text, with spaces replaced by underscores. The real title shown in articles is just this title with underscores (_) converted to spaces. For example, a page titled "Talk:Foo Bar" would have "Foo_Bar" in this field.

page_restrictions
Comma-separated set of permission keys indicating who can move or edit the page. Edit and move sections are separated by a colon (e.g., "edit=autoconfirmed,sysop:move=sysop").

page_counter
Number of times the page has been viewed. This feature was completely removed in MediaWiki 1.25, following a request for comment. Even before that, many sites including Wikimedia projects disabled it to increase performance; see for details.

page_is_redirect
A value of   here indicates the article is a redirect; it is   in all other cases.

page_is_new
This field stores whether the page is a new, meaning it either has only one revision or has not been edited since being restored, even if there is more than one revision. If the field contains a value of  , then it indicates that the page is a new; otherwise, it is  . links are not displayed if the page is new, since there is nothing to roll back to.

page_random
Random decimal value, between 0 and 1, used for Special:Random (see for more details). Generated by.

Around 2005, a bug caused these random values to be non-uniform. Since the field is set at page creation, wikis that have existed for a long time might still have some of these erroneous values. See T208909.

page_touched
This timestamp is updated whenever the page changes in a way requiring it to be re-rendered, invalidating caches. Aside from editing, this includes permission changes, creation or deletion of linked pages, and alteration of contained templates. Set to at the time of page creation.

page_links_updated
This timestamp is updated whenever a page is re-parsed and it has all the link tracking tables updated for it. This is useful for de-duplicating expensive backlink update jobs. Set to the default value of NULL when the page is created by WikiPage::insertOn.

page_latest
This is a foreign key to rev_id for the current revision. It may be 0 during page creation. It needs to link to a revision with a valid, or there will be the "The revision #0 of the page named 'Foo' does not exist" error when one tries to view the page. Can be obtained via.

page_len
Uncompressed length in bytes of the page's current source text.

This however, does not apply to images which still have records in this table. Instead, the uncompressed length in bytes of the  for the file is used as the latter is in the   field.

The  class in   has two methods, viz.,   and   that are responsible for populating these details.

page_content_model
Content model, see CONTENT_MODEL_XXX constants. Comparable to.

page_lang
Page content language. Set to the default value of NULL at the time of page creation.

Schema summary
++-+--+-+-++ ++-+--+-+-++ ++-+--+-+-++
 * Field             | Type                | Null | Key | Default | Extra          |
 * page_id           | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
 * page_namespace    | int(11)             | NO   | MUL | NULL    |                |
 * page_title        | varbinary(255)      | NO   |     | NULL    |                |
 * page_restrictions | tinyblob            | YES  |     | NULL    |                |
 * page_is_redirect  | tinyint(3) unsigned | NO   | MUL | 0       |                |
 * page_is_new       | tinyint(3) unsigned | NO   |     | 0       |                |
 * page_random       | double unsigned     | NO   | MUL | NULL    |                |
 * page_touched      | binary(14)          | NO   |     | NULL    |                |
 * page_links_updated | varbinary(14)      | YES  |     | NULL    |                |
 * page_latest       | int(10) unsigned    | NO   |     | NULL    |                |
 * page_len          | int(10) unsigned    | NO   | MUL | NULL    |                |
 * page_content_model | varbinary(32)      | YES  |     | NULL    |                |
 * page_lang         | varbinary(35)       | YES  |     | NULL    |                |

++-+--+-+++ ++-+--+-+++ ++-+--+-+++
 * Field             | Type                | Null | Key | Default        | Extra          |
 * page_id           | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
 * page_namespace    | int(11)             | NO   | MUL | NULL           |                |
 * page_title        | varbinary(255)      | NO   |     | NULL           |                |
 * page_restrictions | tinyblob            | YES  |     | NULL           |                |
 * page_is_redirect  | tinyint(3) unsigned | NO   | MUL | 0              |                |
 * page_is_new       | tinyint(3) unsigned | NO   |     | 0              |                |
 * page_random       | double unsigned     | NO   | MUL | NULL           |                |
 * page_touched      | binary(14)          | NO   |     |                |                |
 * page_links_updated | varbinary(14)      | YES  |     | NULL           |                |
 * page_latest       | int(10) unsigned    | NO   |     | NULL           |                |
 * page_len          | int(10) unsigned    | NO   | MUL | NULL           |                |
 * page_content_model | varbinary(32)      | YES  |     | NULL           |                |
 * page_lang         | varbinary(35)       | YES  |     | NULL           |                |

++-+--+-+++ ++-+--+-+++ ++-+--+-+++
 * Field             | Type                | Null | Key | Default        | Extra          |
 * page_id           | int(10) unsigned    | NO   | PRI | NULL           | auto_increment |
 * page_namespace    | int(11)             | NO   | MUL | NULL           |                |
 * page_title        | varbinary(255)      | NO   |     | NULL           |                |
 * page_restrictions | tinyblob            | NO   |     | NULL           |                |
 * page_is_redirect  | tinyint(3) unsigned | NO   | MUL | 0              |                |
 * page_is_new       | tinyint(3) unsigned | NO   |     | 0              |                |
 * page_random       | double unsigned     | NO   | MUL | NULL           |                |
 * page_touched      | binary(14)          | NO   |     |                |                |
 * page_links_updated | varbinary(14)      | YES  |     | NULL           |                |
 * page_latest       | int(10) unsigned    | NO   |     | NULL           |                |
 * page_len          | int(10) unsigned    | NO   | MUL | NULL           |                |
 * page_content_model | varbinary(32)      | YES  |     | NULL           |                |
 * page_lang         | varbinary(35)       | YES  |     | NULL           |                |

++-+--+-+-++ ++-+--+-+-++ ++-+--+-+-++
 * Field             | Type                | Null | Key | Default | Extra          |
 * page_id           | int(10) unsigned    | NO   | PRI | NULL    | AUTO_INCREMENT |
 * page_namespace    | int(11)             | NO   | MUL | NULL    |                |
 * page_title        | varchar(255) binary | NO   |     | NULL    |                |
 * page_restrictions | tinyblob            | NO   |     | NULL    |                |
 * page_counter      | bigint(20) unsigned | NO   |     | 0       |                |
 * page_is_redirect  | tinyint(3) unsigned | NO   | MUL | 0       |                |
 * page_is_new       | tinyint(3) unsigned | NO   |     | 0       |                |
 * page_random       | real unsigned       | NO   | MUL | NULL    |                |
 * page_touched      | binary(14)          | NO   |     | NULL    |                |
 * page_links_updated | varbinary(14)      | YES  |     | NULL    |                |
 * page_latest       | int(10) unsigned    | NO   |     | NULL    |                |
 * page_len          | int(10) unsigned    | NO   | MUL | NULL    |                |
 * page_content_model | varbinary(32)      | YES  |     | NULL    |                |
 * page_lang         | varbinary(35)       | YES  |     | NULL    |                |

++-+--+-+-++ ++-+--+-+-++ ++-+--+-+-++
 * Field             | Type                | Null | Key | Default | Extra          |
 * page_id           | int(10) unsigned    | NO   | PRI | NULL    | AUTO_INCREMENT |
 * page_namespace    | int(11)             | NO   | MUL | NULL    |                |
 * page_title        | varchar(255) binary | NO   |     | NULL    |                |
 * page_restrictions | tinyblob            | NO   |     | NULL    |                |
 * page_counter      | bigint(20) unsigned | NO   |     | 0       |                |
 * page_is_redirect  | tinyint(3) unsigned | NO   | MUL | 0       |                |
 * page_is_new       | tinyint(3) unsigned | NO   |     | 0       |                |
 * page_random       | real unsigned       | NO   | MUL | NULL    |                |
 * page_touched      | binary(14)          | NO   |     | NULL    |                |
 * page_links_updated | varbinary(14)      | YES  |     | NULL    |                |
 * page_latest       | int(10) unsigned    | NO   |     | NULL    |                |
 * page_len          | int(10) unsigned    | NO   | MUL | NULL    |                |
 * page_content_model | varbinary(32)      | YES  |     | NULL    |                |

++-+--+-+-++ ++-+--+-+-++ ++-+--+-+-++
 * Field             | Type                | Null | Key | Default | Extra          |
 * page_id           | int(10) unsigned    | NO   | PRI | NULL    | AUTO_INCREMENT |
 * page_namespace    | int(11)             | NO   | MUL | NULL    |                |
 * page_title        | varchar(255) binary | NO   |     | NULL    |                |
 * page_restrictions | tinyblob            | NO   |     | NULL    |                |
 * page_counter      | bigint(20) unsigned | NO   |     | 0       |                |
 * page_is_redirect  | tinyint(3) unsigned | NO   | MUL | 0       |                |
 * page_is_new       | tinyint(3) unsigned | NO   |     | 0       |                |
 * page_random       | real unsigned       | NO   | MUL | NULL    |                |
 * page_touched      | binary(14)          | NO   |     | NULL    |                |
 * page_latest       | int(10) unsigned    | NO   |     | NULL    |                |
 * page_len          | int(10) unsigned    | NO   | MUL | NULL    |                |
 * page_content_model | varbinary(32)      | YES  |     | NULL    |                |

+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field            | Type                | Null | Key | Default | Extra          |
 * page_id          | int(10) unsigned    | NO   | PRI | NULL    | AUTO_INCREMENT |
 * page_namespace   | int(11)             | NO   | MUL | NULL    |                |
 * page_title       | varchar(255) binary | NO   |     | NULL    |                |
 * page_restrictions | tinyblob           | NO   |     | NULL    |                |
 * page_counter     | bigint(20) unsigned | NO   |     | 0       |                |
 * page_is_redirect | tinyint(3) unsigned | NO   | MUL | 0       |                |
 * page_is_new      | tinyint(3) unsigned | NO   |     | 0       |                |
 * page_random      | real unsigned       | NO   | MUL | NULL    |                |
 * page_touched     | binary(14)          | NO   |     | NULL    |                |
 * page_latest      | int(10) unsigned    | NO   |     | NULL    |                |
 * page_len         | int(10) unsigned    | NO   | MUL | NULL    |                |

+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field            | Type                | Null | Key | Default | Extra          |
 * page_id          | int(10) unsigned    | NO   | PRI | NULL    | AUTO_INCREMENT |
 * page_namespace   | int(11)             | NO   | MUL | NULL    |                |
 * page_title       | varchar(255) binary | NO   |     | NULL    |                |
 * page_restrictions | tinyblob           | NO   |     | NULL    |                |
 * page_counter     | bigint(20) unsigned | NO   |     | 0       |                |
 * page_is_redirect | tinyint(3) unsigned | NO   |     | 0       |                |
 * page_is_new      | tinyint(3) unsigned | NO   |     | 0       |                |
 * page_random      | real unsigned       | NO   | MUL | NULL    |                |
 * page_touched     | binary(14)          | NO   |     | NULL    |                |
 * page_latest      | int(10) unsigned    | NO   |     | NULL    |                |
 * page_len         | int(10) unsigned    | NO   | MUL | NULL    |                |

+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field            | Type                | Null | Key | Default | Extra          |
 * page_id          | int(8) unsigned     | NO   | PRI | NULL    | AUTO_INCREMENT |
 * page_namespace   | int(11)             | NO   | MUL | NULL    |                |
 * page_title       | varchar(255) binary | NO   |     | NULL    |                |
 * page_restrictions | tinyblob           | NO   |     | NULL    |                |
 * page_counter     | bigint(20) unsigned | NO   |     | 0       |                |
 * page_is_redirect | tinyint(1) unsigned | NO   |     | 0       |                |
 * page_is_new      | tinyint(1) unsigned | NO   |     | 0       |                |
 * page_random      | real unsigned       | NO   | MUL | NULL    |                |
 * page_touched     | char(14) binary     | NO   |     | NULL    |                |
 * page_latest      | int(8) unsigned     | NO   |     | NULL    |                |
 * page_len         | int(8) unsigned     | NO   | MUL | NULL    |                |

Indexes
 +---++-+--+--+---+-+--++--++-+---+ +---++-+--+--+---+-+--++--++-+---+ +---++-+--+--+---+-+--++--++-+---+
 * Table | Non_unique | Key_name                   | Seq_in_index | Column_name      | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
 * page |          0 | PRIMARY                     |            1 | page_id          | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * page |          0 | page_name_title             |            1 | page_namespace   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * page |          0 | page_name_title             |            2 | page_title       | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * page |          1 | page_random                 |            1 | page_random      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * page |          1 | page_len                    |            1 | page_len         | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * page |          1 | page_redirect_namespace_len |            1 | page_is_redirect | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * page |          1 | page_redirect_namespace_len |            2 | page_namespace   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * page |          1 | page_redirect_namespace_len |            3 | page_len         | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |

Listing pages and relations with other essential tables
The following code will select the most recent versions of all articles from core tables: [page, revision, text]:

Other important considerations:


 * to find undeleted pages add
 * to find pages in namespace 0 add
 * to find pages that are not redirects add

These additional statements can be added either as conditions to a Where statement or as conditions on the appropriate Inner Join statement.

Deleting pages with their relationships in text and revision tables
The following shows the steps to run to help you delete pages and their children from the main pages in the page, revision and text tables.

Listing all related table keys

Deleting from database the rows

You should have a result set like this

 +--+--+--+ +--+--+--+ +--+--+--+ 1 row in set (0.07 sec)
 * page                                            | revision                                         | text                                             |
 * IN(5530,5528,5529,5530,5529,5528,5532,5532,5532) | IN(9918,9921,9917,9919,9920,9916,9922,9915,9923) | IN(9918,9921,9917,9919,9920,9916,9922,9915,9923) |

Replace the concatenated id in the following query

After, you can do some cleanup using this maintenance script: