page

1. Fields

2. Schema summary


WackoWiki 5.5


DESCRIBE page;


+------------------+---------------------+------+-----+---------+----------------+
| Field            | Type                | Null | Key | Default | Extra          |
+------------------+---------------------+------+-----+---------+----------------+
| page_id          | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| version_id       | int(10) unsigned    | NO   |     | 1       |                |
| owner_id         | int(10) unsigned    | NO   | MUL | 0       |                |
| user_id          | int(10) unsigned    | NO   | MUL | 0       |                |
| title            | varchar(250)        | NO   | MUL |         |                |
| tag              | varchar(250)        | NO   | UNI |         |                |
| supertag         | varchar(250)        | NO   | MUL |         |                |
| menu_tag         | varchar(250)        | NO   |     |         |                |
| depth            | int(10) unsigned    | NO   | MUL | 0       |                |
| parent_id        | int(10) unsigned    | NO   |     | 0       |                |
| created          | datetime            | YES  | MUL | NULL    |                |                                                                         
| modified         | datetime            | YES  | MUL | NULL    |                |
| body             | mediumtext          | NO   | MUL | NULL    |                |
| body_r           | mediumtext          | NO   |     | NULL    |                |
| body_toc         | text                | NO   |     | NULL    |                |
| formatting       | varchar(20)         | NO   |     | wacko   |                |
| edit_note        | varchar(200)        | NO   |     |         |                |
| minor_edit       | tinyint(1) unsigned | YES  | MUL | 0       |                |
| page_size        | int(10) unsigned    | NO   |     | 0       |                |
| reviewed         | tinyint(1) unsigned | NO   | MUL | 0       |                |
| reviewed_time    | datetime            | YES  |     | NULL    |                |
| reviewer_id      | int(10) unsigned    | NO   |     | 0       |                |
| ip               | varchar(15)         | NO   |     |         |                |
| latest           | tinyint(1) unsigned | YES  |     | 1       |                |
| handler          | varchar(30)         | NO   |     | page    |                |
| comment_on_id    | int(10) unsigned    | NO   | MUL | 0       |                |
| comments         | int(4) unsigned     | NO   |     | 0       |                |
| hits             | int(10) unsigned    | NO   |     | 0       |                |
| theme            | varchar(20)         | YES  |     | NULL    |                |
| page_lang        | varchar(2)          | NO   |     |         |                |
| commented        | datetime            | YES  | MUL | NULL    |                |
| description      | varchar(250)        | NO   |     |         |                |
| keywords         | varchar(250)        | NO   |     |         |                |
| footer_comments  | tinyint(1) unsigned | YES  |     | NULL    |                |
| footer_files     | tinyint(1) unsigned | YES  |     | NULL    |                |
| footer_rating    | tinyint(1) unsigned | YES  |     | NULL    |                |
| hide_toc         | tinyint(1) unsigned | YES  |     | NULL    |                |
| hide_index       | tinyint(1) unsigned | YES  |     | NULL    |                |
| tree_level       | tinyint(1) unsigned | NO   |     | 0       |                |
| show_menu_tag    | tinyint(1) unsigned | NO   |     | 0       |                |
| allow_rawhtml    | tinyint(1) unsigned | YES  |     | NULL    |                |
| disable_safehtml | tinyint(1) unsigned | YES  |     | NULL    |                |
| noindex          | tinyint(1) unsigned | YES  |     | 0       |                |
| deleted          | tinyint(1) unsigned | YES  | MUL | 0       |                |
+------------------+---------------------+------+-----+---------+----------------+

3. Indices


SHOW INDEX IN page;