rendered paste body| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| content_id | int(11) | | PRI | 0 | | -- id, obvious
| content_name | varchar(255) | YES | | NULL | | -- name, obvious
| type | varchar(25) | YES | | NULL | | -- should be "content"
| owner_id | int(11) | YES | | NULL | | -- 1 (admin user -- can change later)
| parent_id | int(11) | YES | MUL | NULL | | -- id of the parent node in the hierarchy
| template_id | int(11) | YES | | NULL | | -- id of your template -- just pick one that's active from the templates table
| item_order | int(11) | YES | | NULL | | -- order of the item in relation to it's siblings (same parent_id)
| hierarchy | varchar(255) | YES | | NULL | | -- String showing the items orders and hierarchy. For example: 00001.00001.00001 -- First child of the first child of the first item
| default_content | tinyint(4) | YES | MUL | NULL | | -- 1/0 Is this the page that shows when you go to the site without a page name? Only one can be set to 1.
| menu_text | varchar(255) | YES | | NULL | | -- Text that shows in the menu
| content_alias | varchar(255) | YES | MUL | NULL | | -- Text used in the URL (?page=alias)
| show_in_menu | tinyint(4) | YES | | NULL | | -- 1/0
| collapsed | tinyint(4) | YES | | NULL | | -- 0 -- Doesn't get used anymore
| markup | varchar(25) | YES | | NULL | | -- 'html'
| active | tinyint(4) | YES | | NULL | | -- 1/0
| cachable | tinyint(4) | YES | | NULL | | -- 1/0 -- Most likely should be 1
| id_hierarchy | varchar(255) | YES | | NULL | | -- Hierarchy, but using id's instead. 1.23.41
| hierarchy_path | text | YES | | NULL | | -- Path using aliases eg: extensions/modules/news
| prop_names | text | YES | | NULL | | -- Most likely 'content_en'
| metadata | text | YES | | NULL | | -- Can be null
| titleattribute | varchar(255) | YES | | NULL | | -- Can be null
| tabindex | varchar(10) | YES | | NULL | | -- Can be null
| accesskey | varchar(5) | YES | | NULL | | -- Can be null
| last_modified_by | int(11) | YES | | NULL | | -- User ID
| create_date | datetime | YES | | NULL | | -- timestamp
| modified_date | datetime | YES | | NULL | | -- timestamp
+------------------+--------------+------+-----+---------+-------+
mysql> desc cms_content_props;
+---------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| content_id | int(11) | YES | MUL | NULL | | -- Well content id
| type | varchar(25) | YES | | NULL | | -- 'string'
| prop_name | varchar(255) | YES | | NULL | | -- 'content_en'
| param1 | varchar(255) | YES | | NULL | | -- null
| param2 | varchar(255) | YES | | NULL | | -- null
| param3 | varchar(255) | YES | | NULL | | -- null
| content | text | YES | | NULL | | -- The page's html content
| create_date | datetime | YES | | NULL | | -- timestamp
| modified_date | datetime | YES | | NULL | | -- timestamp
+---------------+--------------+------+-----+---------+-------+