| Field            | Type         | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| content_id       | int(11)      |      | PRI | 0       |       |
| content_name     | varchar(255) | YES  |     | NULL    |       |
| type             | varchar(25)  | YES  |     | NULL    |       |
| owner_id         | int(11)      | YES  |     | NULL    |       |
| parent_id        | int(11)      | YES  | MUL | NULL    |       |
| template_id      | int(11)      | YES  |     | NULL    |       |
| item_order       | int(11)      | YES  |     | NULL    |       |
| hierarchy        | varchar(255) | YES  |     | NULL    |       |
| default_content  | tinyint(4)   | YES  | MUL | NULL    |       |
| menu_text        | varchar(255) | YES  |     | NULL    |       |
| content_alias    | varchar(255) | YES  | MUL | NULL    |       |
| show_in_menu     | tinyint(4)   | YES  |     | NULL    |       |
| collapsed        | tinyint(4)   | YES  |     | NULL    |       |
| markup           | varchar(25)  | YES  |     | NULL    |       |
| active           | tinyint(4)   | YES  |     | NULL    |       |
| cachable         | tinyint(4)   | YES  |     | NULL    |       |
| id_hierarchy     | varchar(255) | YES  |     | NULL    |       |
| hierarchy_path   | text         | YES  |     | NULL    |       |
| prop_names       | text         | YES  |     | NULL    |       |
| metadata         | text         | YES  |     | NULL    |       |
| titleattribute   | varchar(255) | YES  |     | NULL    |       |
| tabindex         | varchar(10)  | YES  |     | NULL    |       |
| accesskey        | varchar(5)   | YES  |     | NULL    |       |
| last_modified_by | int(11)      | YES  |     | NULL    |       |
| create_date      | datetime     | YES  |     | NULL    |       |
| modified_date    | datetime     | YES  |     | NULL    |       |
+------------------+--------------+------+-----+---------+-------+

mysql> desc cms_content_props;
+---------------+--------------+------+-----+---------+-------+
| Field         | Type         | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| content_id    | int(11)      | YES  | MUL | NULL    |       |
| type          | varchar(25)  | YES  |     | NULL    |       |
| prop_name     | varchar(255) | YES  |     | NULL    |       |
| param1        | varchar(255) | YES  |     | NULL    |       |
| param2        | varchar(255) | YES  |     | NULL    |       |
| param3        | varchar(255) | YES  |     | NULL    |       |
| content       | text         | YES  |     | NULL    |       |
| create_date   | datetime     | YES  |     | NULL    |       |
| modified_date | datetime     | YES  |     | NULL    |       |
+---------------+--------------+------+-----+---------+-------+