| 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
+---------------+--------------+------+-----+---------+-------+