rendered paste body| 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 | |
+---------------+--------------+------+-----+---------+-------+