===Fields===
===Schema summary===
%% DESCRIBE page; %%
====6.1====
%%
+------------------+---------------------+------+-----+---------+----------------+
| 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(191) | NO | MUL | | |
| tag | varchar(191) | NO | UNI | | |
| menu_tag | varchar(250) | NO | | NULL | |
| 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 | | NULL | |
| minor_edit | tinyint(1) unsigned | YES | MUL | 0 | |
| page_size | int(10) unsigned | NO | | 0 | |
| license_id | 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(45) | NO | | NULL | |
| 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 | |
| files | int(4) unsigned | NO | | 0 | |
| revisions | int(10) unsigned | NO | | 0 | |
| hits | int(10) unsigned | NO | | 0 | |
| theme | varchar(20) | YES | | NULL | |
| page_lang | varchar(5) | NO | | NULL | |
| commented | datetime | YES | MUL | NULL | |
| description | varchar(250) | NO | | NULL | |
| keywords | varchar(250) | NO | | NULL | |
| footer_comments | tinyint(1) unsigned | YES | | NULL | |
| footer_files | 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 | |
| typografica | tinyint(1) unsigned | YES | | NULL | |
| noindex | tinyint(1) unsigned | YES | | 0 | |
| deleted | tinyint(1) unsigned | YES | MUL | 0 | |
+------------------+---------------------+------+-----+---------+----------------+
%%
====6.0====
%%
+------------------+---------------------+------+-----+---------+----------------+
| 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(191) | NO | MUL | | |
| tag | varchar(191) | NO | UNI | | |
| menu_tag | varchar(250) | NO | | NULL | |
| 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 | | NULL | |
| minor_edit | tinyint(1) unsigned | YES | MUL | 0 | |
| page_size | int(10) unsigned | NO | | 0 | |
| license_id | 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(45) | NO | | NULL | |
| 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 | |
| files | int(4) unsigned | NO | | 0 | |
| revisions | int(10) unsigned | NO | | 0 | |
| hits | int(10) unsigned | NO | | 0 | |
| theme | varchar(20) | YES | | NULL | |
| page_lang | varchar(5) | NO | | NULL | |
| commented | datetime | YES | MUL | NULL | |
| description | varchar(250) | NO | | NULL | |
| keywords | varchar(250) | NO | | NULL | |
| 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 | |
+------------------+---------------------+------+-----+---------+----------------+
%%
===Indices===
%% SHOW INDEX IN page; %%
%%(cl)
+------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wacko_page | 0 | PRIMARY | 1 | page_id | A | 145 | NULL | NULL | | BTREE | | |
| wacko_page | 0 | idx_tag | 1 | tag | A | 145 | NULL | NULL | | BTREE | | |
| wacko_page | 1 | idx_user_id | 1 | user_id | A | 24 | NULL | NULL | | BTREE | | |
| wacko_page | 1 | idx_owner_id | 1 | owner_id | A | 24 | NULL | NULL | | BTREE | | |
| wacko_page | 1 | idx_depth | 1 | depth | A | 14 | NULL | NULL | | BTREE | | |
| wacko_page | 1 | idx_created | 1 | created | A | 145 | NULL | NULL | YES | BTREE | | |
| wacko_page | 1 | idx_modified | 1 | modified | A | 145 | NULL | NULL | YES | BTREE | | |
| wacko_page | 1 | idx_minor_edit | 1 | minor_edit | A | 2 | NULL | NULL | YES | BTREE | | |
| wacko_page | 1 | idx_deleted | 1 | deleted | A | 4 | NULL | NULL | YES | BTREE | | |
| wacko_page | 1 | idx_reviewed | 1 | reviewed | A | 2 | NULL | NULL | | BTREE | | |
| wacko_page | 1 | idx_comment_on_id | 1 | comment_on_id | A | 24 | NULL | NULL | | BTREE | | |
| wacko_page | 1 | idx_commented | 1 | commented | A | 145 | NULL | NULL | YES | BTREE | | |
| wacko_page | 1 | idx_title | 1 | title | A | 145 | NULL | NULL | | BTREE | | |
| wacko_page | 1 | body | 1 | body | NULL | 145 | NULL | NULL | | FULLTEXT | | |
+------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
%%