{
    "cms_page_widget_areas": {
        "name": "cms_page_widget_areas",
        "columns": {
            "area_page_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "The page ID",
                "decimals": null,
                "default": "0",
                "length": 20,
                "name": "area_page_id",
                "type": "BIGINT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            },
            "area_widgets": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "area_widgets",
                "type": "MEDIUMTEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "area_area": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "area_area",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "area_orientation": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "horizontal",
                "length": 0,
                "name": "area_orientation",
                "type": "ENUM",
                "unsigned": false,
                "values": [
                    "horizontal",
                    "vertical"
                ],
                "zerofill": false
            },
            "area_tree": {
                "name": "area_tree",
                "type": "TEXT",
                "length": null,
                "decimals": null,
                "values": null,
                "allow_null": false,
                "default": null,
                "comment": "",
                "unsigned": false,
                "auto_increment": false
            }
        },
        "indexes": {
            "area_page_area": {
                "type": "unique",
                "name": "area_page_area",
                "length": [
                    null,
                    191
                ],
                "columns": [
                    "area_page_id",
                    "area_area"
                ]
            }
        }
    },
    "cms_url_store": {
        "name": "cms_url_store",
        "columns": {
            "store_path": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "Path part of the URL",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "store_path",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "store_current_id": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "store_current_id",
                "type": "INT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            },
            "store_type": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 32,
                "name": "store_type",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            }
        },
        "indexes": {
            "path_lookup": {
                "type": "key",
                "name": "path_lookup",
                "length": [
                    28,
                    221
                ],
                "columns": [
                    "store_type",
                    "store_path"
                ]
            }
        },
        "collation": "utf8mb4_unicode_ci"
    },
    "cms_blocks": {
        "name": "cms_blocks",
        "columns": {
            "block_id": {
                "allow_null": false,
                "auto_increment": true,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 9,
                "name": "block_id",
                "type": "MEDIUMINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "block_active": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "block_active",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "block_key": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "",
                "length": 255,
                "name": "block_key",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "block_template": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 255,
                "name": "block_template",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "block_template_params": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "Vars for any ad-hoc template",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "block_template_params",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "block_type": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "",
                "length": 32,
                "name": "block_type",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "block_config": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "block_config",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "block_content": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "block_content",
                "type": "MEDIUMTEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "block_position": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 9,
                "name": "block_position",
                "type": "MEDIUMINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "block_category": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 9,
                "name": "block_category",
                "type": "MEDIUMINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "block_plugin": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "block_plugin",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "block_plugin_config": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "block_plugin_config",
                "type": "MEDIUMTEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "block_plugin_app": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 100,
                "name": "block_plugin_app",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "block_cache": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "block_cache",
                "type": "TINYINT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            }
        },
        "indexes": {
            "PRIMARY": {
                "type": "primary",
                "name": "PRIMARY",
                "length": [
                    null
                ],
                "columns": [
                    "block_id"
                ]
            },
            "block_active": {
                "type": "key",
                "name": "block_active",
                "length": [
                    null
                ],
                "columns": [
                    "block_active"
                ]
            },
            "block_key": {
                "type": "key",
                "name": "block_key",
                "length": [
                    191
                ],
                "columns": [
                    "block_key"
                ]
            },
            "block_category": {
                "type": "key",
                "name": "block_category",
                "length": [
                    null
                ],
                "columns": [
                    "block_category"
                ]
            },
            "block_template": {
                "type": "key",
                "name": "block_template",
                "length": [
                    191
                ],
                "columns": [
                    "block_template"
                ]
            }
        },
        "collation": "utf8mb4_unicode_ci",
        "comment": "",
        "reporting": "count"
    },
    "cms_containers": {
        "name": "cms_containers",
        "columns": {
            "container_id": {
                "allow_null": false,
                "auto_increment": true,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 11,
                "name": "container_id",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "container_name": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "container_name",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "container_type": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "",
                "length": 32,
                "name": "container_type",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "container_order": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 9,
                "name": "container_order",
                "type": "MEDIUMINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "container_parent_id": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "container_parent_id",
                "type": "INT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            },
            "container_key": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 150,
                "name": "container_key",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            }
        },
        "indexes": {
            "PRIMARY": {
                "type": "primary",
                "name": "PRIMARY",
                "length": [
                    null
                ],
                "columns": [
                    "container_id"
                ]
            },
            "container_type": {
                "type": "key",
                "name": "container_type",
                "length": [
                    null,
                    null
                ],
                "columns": [
                    "container_type",
                    "container_order"
                ]
            },
            "container_parent_id": {
                "type": "key",
                "name": "container_parent_id",
                "columns": [
                    "container_parent_id"
                ],
                "length": [
                    null
                ]
            }
        }
    },
    "cms_databases": {
        "name": "cms_databases",
        "columns": {
            "database_id": {
                "allow_null": false,
                "auto_increment": true,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 9,
                "name": "database_id",
                "type": "MEDIUMINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_key": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "",
                "length": 255,
                "name": "database_key",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_record_count": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 9,
                "name": "database_record_count",
                "type": "MEDIUMINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_all_editable": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "database_all_editable",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_revisions": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "database_revisions",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_field_title": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "database_field_title",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_field_sort": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "database_field_sort",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_field_direction": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "desc",
                "length": 4,
                "name": "database_field_direction",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_field_perpage": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "25",
                "length": 6,
                "name": "database_field_perpage",
                "type": "SMALLINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_comment_approve": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "database_comment_approve",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_record_approve": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "database_record_approve",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_rss": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 11,
                "name": "database_rss",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_field_content": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "database_field_content",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_comment_bump": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "database_comment_bump",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_forum_record": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "database_forum_record",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_forum_comments": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "database_forum_comments",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_forum_delete": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "database_forum_delete",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_forum_forum": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 9,
                "name": "database_forum_forum",
                "type": "MEDIUMINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_forum_prefix": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "database_forum_prefix",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_forum_suffix": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "database_forum_suffix",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_search": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "database_search",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_tags_enabled": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 4,
                "name": "database_tags_enabled",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_tags_noprefixes": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 4,
                "name": "database_tags_noprefixes",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_tags_predefined": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "database_tags_predefined",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_fixed_field_perms": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "Contains a JSON object of fixed field permissions.",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "database_fixed_field_perms",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_page_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "Page ID this database is used on (if any)",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "database_page_id",
                "type": "INT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            },
            "database_use_categories": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "1",
                "length": 1,
                "name": "database_use_categories",
                "type": "TINYINT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            },
            "database_default_category": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "database_default_category",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_options": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "database_options",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_fixed_field_settings": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "database_fixed_field_settings",
                "type": "MEDIUMTEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "database_use_as_page_title": {
                "name": "database_use_as_page_title",
                "type": "TINYINT",
                "length": 1,
                "decimals": null,
                "values": null,
                "allow_null": false,
                "default": "1",
                "comment": "Use database name as page title, or retain page title",
                "unsigned": true,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            },
            "database_canonical_flag": {
                "name": "database_canonical_flag",
                "type": "TINYINT",
                "length": 1,
                "decimals": null,
                "values": null,
                "allow_null": true,
                "default": "0",
                "comment": "",
                "unsigned": true,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            },
            "database_comments_perpage": {
                "name": "database_comments_perpage",
                "type": "TINYINT",
                "length": null,
                "decimals": null,
                "values": null,
                "allow_null": false,
                "default": 0,
                "comment": "",
                "unsigned": false,
                "auto_increment": false
            },
            "database_allow_club_categories": {
                "name": "database_allow_club_categories",
                "type": "TINYINT",
                "length": null,
                "decimals": null,
                "values": null,
                "allow_null": false,
                "default": 0,
                "comment": "Whether this database will allow club categories",
                "unsigned": true,
                "auto_increment": false
            },
            "database_display_settings": {
                "name": "database_display_settings",
                "type": "TEXT",
                "length": null,
                "decimals": null,
                "values": null,
                "allow_null": true,
                "default": null,
                "comment": "Layouts and Templates",
                "unsigned": false,
                "auto_increment": false
            }
        },
        "indexes": {
            "PRIMARY": {
                "type": "primary",
                "name": "PRIMARY",
                "length": [
                    null
                ],
                "columns": [
                    "database_id"
                ]
            },
            "database_key": {
                "type": "unique",
                "name": "database_key",
                "length": [
                    191
                ],
                "columns": [
                    "database_key"
                ]
            },
            "forum_lookup": {
                "type": "key",
                "name": "forum_lookup",
                "length": [
                    null,
                    null,
                    null
                ],
                "columns": [
                    "database_forum_record",
                    "database_forum_forum",
                    "database_forum_comments"
                ]
            }
        },
        "collation": "utf8mb4_unicode_ci",
        "engine": "InnoDB",
        "comment": "",
        "reporting": "count"
    },
    "cms_database_categories": {
        "name": "cms_database_categories",
        "columns": {
            "category_id": {
                "allow_null": false,
                "auto_increment": true,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 11,
                "name": "category_id",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_database_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 9,
                "name": "category_database_id",
                "type": "MEDIUMINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_name": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "category_name",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_parent_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 11,
                "name": "category_parent_id",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_last_record_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 11,
                "name": "category_last_record_id",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_last_record_date": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 11,
                "name": "category_last_record_date",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_last_record_member": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 20,
                "name": "category_last_record_member",
                "type": "BIGINT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            },
            "category_last_record_name": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "category_last_record_name",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_last_record_seo_name": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "category_last_record_seo_name",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_position": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 11,
                "name": "category_position",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_records": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 11,
                "name": "category_records",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_records_queued": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 11,
                "name": "category_records_queued",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_record_comments": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 11,
                "name": "category_record_comments",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_record_comments_queued": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 11,
                "name": "category_record_comments_queued",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_has_perms": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "category_has_perms",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_show_records": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "1",
                "length": 1,
                "name": "category_show_records",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_furl_name": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "category_furl_name",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_meta_keywords": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "category_meta_keywords",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_meta_description": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "category_meta_description",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_forum_override": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "category_forum_override",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_forum_record": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "category_forum_record",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_forum_comments": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "category_forum_comments",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_forum_delete": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "category_forum_delete",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_forum_forum": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 9,
                "name": "category_forum_forum",
                "type": "MEDIUMINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_forum_prefix": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "category_forum_prefix",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_forum_suffix": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "category_forum_suffix",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_page_title": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "category_page_title",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_full_path": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "category_full_path",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_last_title": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "category_last_title",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_last_seo_title": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "category_last_seo_title",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_allow_rating": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "category_allow_rating",
                "type": "TINYINT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            },
            "category_fields": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "JSON object of permitted form fields to show.",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "category_fields",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_records_future": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 11,
                "name": "category_records_future",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "category_record_reviews": {
                "name": "category_record_reviews",
                "type": "INT",
                "length": 10,
                "decimals": null,
                "values": [],
                "allow_null": false,
                "default": "0",
                "comment": "",
                "unsigned": true,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            },
            "category_record_reviews_queued": {
                "name": "category_record_reviews_queued",
                "type": "INT",
                "length": 10,
                "decimals": null,
                "values": [],
                "allow_null": false,
                "default": "0",
                "comment": "",
                "unsigned": true,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            },
            "category_options": {
                "name": "category_options",
                "type": "INT",
                "length": 10,
                "decimals": null,
                "values": [],
                "allow_null": false,
                "default": "0",
                "comment": "",
                "unsigned": false,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            },
            "category_template_listing": {
                "name": "category_template_listing",
                "type": "VARCHAR",
                "length": 250,
                "decimals": null,
                "values": [],
                "allow_null": true,
                "default": null,
                "comment": "",
                "unsigned": false,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            },
            "category_template_display": {
                "name": "category_template_display",
                "type": "VARCHAR",
                "length": 250,
                "decimals": null,
                "values": [],
                "allow_null": true,
                "default": null,
                "comment": "",
                "unsigned": false,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            },
            "category_can_view_others": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "1",
                "length": 1,
                "name": "category_can_view_others",
                "type": "TINYINT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            },
            "category_allow_anonymous": {
                "name": "category_allow_anonymous",
                "type": "TINYINT",
                "length": null,
                "decimals": null,
                "values": null,
                "allow_null": false,
                "default": "0",
                "comment": "",
                "unsigned": true,
                "auto_increment": false
            },
            "category_last_poster_anon": {
                "name": "category_last_poster_anon",
                "type": "TINYINT",
                "length": null,
                "decimals": null,
                "values": null,
                "allow_null": true,
                "default": "0",
                "comment": "",
                "unsigned": true,
                "auto_increment": false
            },
            "category_image": {
                "name": "category_image",
                "type": "VARCHAR",
                "length": 255,
                "decimals": null,
                "values": null,
                "allow_null": true,
                "default": null,
                "comment": "",
                "unsigned": false,
                "auto_increment": false
            },
            "category_club_id": {
                "allow_null": true,
                "auto_increment": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "category_club_id",
                "type": "BIGINT",
                "unsigned": true,
                "values": []
            },
            "category_club_view_permission": {
                "allow_null": false,
                "auto_increment": false,
                "comment": "",
                "decimals": null,
                "default": "*",
                "length": 500,
                "name": "category_club_view_permission",
                "type": "VARCHAR",
                "unsigned": false,
                "values": []
            },
            "category_club_category_meta_index": {
                "name": "category_club_category_meta_index",
                "type": "TINYINT",
                "length": 0,
                "decimals": null,
                "values": [],
                "allow_null": true,
                "default": "1",
                "comment": "",
                "unsigned": true,
                "auto_increment": false
            }
        },
        "indexes": {
            "PRIMARY": {
                "type": "primary",
                "name": "PRIMARY",
                "length": [
                    null
                ],
                "columns": [
                    "category_id"
                ]
            },
            "category_database_id": {
                "type": "key",
                "name": "category_database_id",
                "columns": [
                    "category_database_id",
                    "category_club_id"
                ],
                "length": [
                    null,
                    null
                ]
            },
            "category_select": {
                "type": "key",
                "name": "category_select",
                "columns": [
                    "category_parent_id",
                    "category_position"
                ],
                "length": [
                    null,
                    null
                ]
            },
            "forum_integration": {
                "type": "key",
                "name": "forum_integration",
                "columns": [
                    "category_forum_record",
                    "category_forum_comments"
                ],
                "length": [
                    null,
                    null
                ]
            }
        },
        "comment": "",
        "reporting": "count"
    },
    "cms_database_comments": {
        "name": "cms_database_comments",
        "columns": {
            "comment_id": {
                "allow_null": false,
                "auto_increment": true,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 11,
                "name": "comment_id",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "comment_user": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 20,
                "name": "comment_user",
                "type": "BIGINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "comment_database_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 9,
                "name": "comment_database_id",
                "type": "MEDIUMINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "comment_record_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 11,
                "name": "comment_record_id",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "comment_date": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 11,
                "name": "comment_date",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "comment_ip_address": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 46,
                "name": "comment_ip_address",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "comment_post": {
                "name": "comment_post",
                "type": "MEDIUMTEXT",
                "length": 0,
                "decimals": null,
                "values": [],
                "allow_null": true,
                "default": null,
                "comment": "",
                "unsigned": false,
                "auto_increment": false
            },
            "comment_approved": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "comment_approved",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "comment_author": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "comment_author",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "comment_edit_date": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 11,
                "name": "comment_edit_date",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "comment_edit_reason": {
                "name": "comment_edit_reason",
                "type": "VARCHAR",
                "length": 255,
                "decimals": null,
                "values": [],
                "allow_null": true,
                "default": null,
                "comment": "",
                "unsigned": false,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            },
            "comment_edit_member_name": {
                "name": "comment_edit_member_name",
                "type": "VARCHAR",
                "length": 255,
                "decimals": null,
                "values": [],
                "allow_null": true,
                "default": null,
                "comment": "",
                "unsigned": false,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            },
            "comment_edit_member_id": {
                "name": "comment_edit_member_id",
                "type": "BIGINT",
                "length": 20,
                "decimals": null,
                "values": [],
                "allow_null": false,
                "default": "0",
                "comment": "",
                "unsigned": true,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            },
            "comment_edit_show": {
                "name": "comment_edit_show",
                "type": "SMALLINT",
                "length": 1,
                "decimals": null,
                "values": [],
                "allow_null": false,
                "default": "0",
                "comment": "",
                "unsigned": true,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            },
            "comment_is_anon": {
                "name": "comment_is_anon",
                "type": "TINYINT",
                "length": null,
                "decimals": null,
                "values": null,
                "allow_null": false,
                "default": "0",
                "comment": "",
                "unsigned": true,
                "auto_increment": false
            }
        },
        "indexes": {
            "PRIMARY": {
                "type": "primary",
                "name": "PRIMARY",
                "length": [
                    null
                ],
                "columns": [
                    "comment_id"
                ]
            },
            "comment_user": {
                "type": "key",
                "name": "comment_user",
                "length": [
                    null
                ],
                "columns": [
                    "comment_user"
                ]
            },
            "comment_database_id": {
                "type": "key",
                "name": "comment_database_id",
                "length": [
                    null,
                    null,
                    null
                ],
                "columns": [
                    "comment_database_id",
                    "comment_record_id",
                    "comment_date"
                ]
            },
            "comment_approved": {
                "type": "key",
                "name": "comment_approved",
                "columns": [
                    "comment_approved"
                ],
                "length": [
                    null
                ]
            },
            "comment_ip_address": {
                "type": "key",
                "name": "comment_ip_address",
                "columns": [
                    "comment_ip_address"
                ],
                "length": [
                    null
                ]
            },
            "comment_indexing": {
                "type": "key",
                "name": "comment_indexing",
                "columns": [
                    "comment_record_id",
                    "comment_user"
                ],
                "length": [
                    null,
                    null
                ]
            }
        },
        "comment": "",
        "reporting": "count"
    },
    "cms_database_fields": {
        "name": "cms_database_fields",
        "columns": {
            "field_id": {
                "allow_null": false,
                "auto_increment": true,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 11,
                "name": "field_id",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_database_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 9,
                "name": "field_database_id",
                "type": "MEDIUMINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_key": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "",
                "length": 255,
                "name": "field_key",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_type": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "field_type",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_required": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "field_required",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_user_editable": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "field_user_editable",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_position": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 11,
                "name": "field_position",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_max_length": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 9,
                "name": "field_max_length",
                "type": "MEDIUMINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_extra": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "field_extra",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_html": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 4,
                "name": "field_html",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_truncate": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "100",
                "length": 9,
                "name": "field_truncate",
                "type": "MEDIUMINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_default_value": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "field_default_value",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_display_listing": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "1",
                "length": 1,
                "name": "field_display_listing",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_display_display": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "1",
                "length": 1,
                "name": "field_display_display",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_format_opts": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "field_format_opts",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_validator": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "field_validator",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_topic_format": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "field_topic_format",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_filter": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "field_filter",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_allowed_extensions": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "field_allowed_extensions",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_is_multiple": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "field_is_multiple",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_is_searchable": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "1",
                "length": 1,
                "name": "field_is_searchable",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_validator_custom": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "field_validator_custom",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_display_commentform": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "Determines if this field should show and be editable on the comment reply form.",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "field_display_commentform",
                "type": "TINYINT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            },
            "field_display_json": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "JSON array of custom display HTML",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "field_display_json",
                "type": "MEDIUMTEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "field_unique": {
                "name": "field_unique",
                "type": "TINYINT",
                "length": 1,
                "decimals": null,
                "values": null,
                "allow_null": false,
                "default": "0",
                "comment": "",
                "unsigned": true,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            },
            "field_allow_attachments": {
                "name": "field_allow_attachments",
                "type": "TINYINT",
                "length": 1,
                "decimals": null,
                "values": null,
                "allow_null": false,
                "default": "1",
                "comment": "",
                "unsigned": true,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            },
            "field_toggles": {
                "name": "field_toggles",
                "type": "TEXT",
                "length": null,
                "decimals": null,
                "values": null,
                "allow_null": true,
                "default": null,
                "comment": "",
                "unsigned": false,
                "auto_increment": false
            }
        },
        "indexes": {
            "PRIMARY": {
                "type": "primary",
                "name": "PRIMARY",
                "length": [
                    null
                ],
                "columns": [
                    "field_id"
                ]
            },
            "field_database_id": {
                "type": "key",
                "name": "field_database_id",
                "length": [
                    null
                ],
                "columns": [
                    "field_database_id"
                ]
            },
            "field_key": {
                "type": "key",
                "name": "field_key",
                "length": [
                    191
                ],
                "columns": [
                    "field_key"
                ]
            }
        },
        "collation": "utf8mb4_unicode_ci",
        "engine": "InnoDB",
        "comment": "",
        "reporting": "count"
    },
    "cms_database_revisions": {
        "name": "cms_database_revisions",
        "columns": {
            "revision_id": {
                "allow_null": false,
                "auto_increment": true,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 11,
                "name": "revision_id",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "revision_database_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 9,
                "name": "revision_database_id",
                "type": "MEDIUMINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "revision_record_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 11,
                "name": "revision_record_id",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "revision_data": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "revision_data",
                "type": "LONGTEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "revision_date": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 13,
                "name": "revision_date",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "revision_member_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 20,
                "name": "revision_member_id",
                "type": "BIGINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            }
        },
        "indexes": {
            "PRIMARY": {
                "type": "primary",
                "name": "PRIMARY",
                "length": [
                    null
                ],
                "columns": [
                    "revision_id"
                ]
            },
            "revision_database_id": {
                "type": "key",
                "name": "revision_database_id",
                "length": [
                    null,
                    null
                ],
                "columns": [
                    "revision_database_id",
                    "revision_record_id"
                ]
            },
            "revision_member_id": {
                "type": "key",
                "name": "revision_member_id",
                "length": [
                    null
                ],
                "columns": [
                    "revision_member_id"
                ]
            }
        },
        "comment": "",
        "reporting": "count"
    },
    "cms_folders": {
        "name": "cms_folders",
        "columns": {
            "folder_path": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "folder_path",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "folder_last_modified": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 11,
                "name": "folder_last_modified",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "folder_id": {
                "allow_null": false,
                "auto_increment": true,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 10,
                "name": "folder_id",
                "type": "INT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            },
            "folder_parent_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "folder_parent_id",
                "type": "INT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            },
            "folder_name": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 250,
                "name": "folder_name",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            }
        },
        "indexes": {
            "PRIMARY": {
                "type": "primary",
                "name": "PRIMARY",
                "length": [
                    null
                ],
                "columns": [
                    "folder_id"
                ]
            },
            "folder_path": {
                "type": "key",
                "name": "folder_path",
                "length": [
                    191
                ],
                "columns": [
                    "folder_path"
                ]
            },
            "folder_parent_id": {
                "type": "key",
                "name": "folder_parent_id",
                "columns": [
                    "folder_parent_id"
                ],
                "length": [
                    null
                ]
            }
        },
        "collation": "utf8mb4_unicode_ci",
        "comment": "",
        "reporting": "count"
    },
    "cms_pages": {
        "name": "cms_pages",
        "columns": {
            "page_id": {
                "allow_null": false,
                "auto_increment": true,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 11,
                "name": "page_id",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "page_name": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "page_name",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "page_seo_name": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "page_seo_name",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "page_content": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "page_content",
                "type": "MEDIUMTEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "page_type": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 32,
                "name": "page_type",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "page_theme": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 8,
                "name": "page_theme",
                "type": "INT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            },
            "page_meta_keywords": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "page_meta_keywords",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "page_meta_description": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "page_meta_description",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "page_template": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "page_template",
                "type": "MEDIUMTEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "page_ipb_wrapper": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "page_ipb_wrapper",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "page_title": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "page_title",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "page_quicknav": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "1",
                "length": 4,
                "name": "page_quicknav",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "page_folder_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "page_folder_id",
                "type": "INT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            },
            "page_full_path": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "page_full_path",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "page_default": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "page_default",
                "type": "TINYINT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            },
            "page_js_css_ids": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "JSON array storing CSS and JS template IDs for inclusion on this page.",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "page_js_css_ids",
                "type": "MEDIUMTEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "page_js_css_objects": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "JSON array of file objects",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "page_js_css_objects",
                "type": "MEDIUMTEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "page_wrapper_template": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "page_wrapper_template",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "page_has_error": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "page_has_error",
                "type": "TINYINT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            },
            "page_meta_index": {
                "name": "page_meta_index",
                "type": "TINYINT",
                "length": null,
                "decimals": null,
                "values": null,
                "allow_null": false,
                "default": "1",
                "comment": "",
                "unsigned": false,
                "auto_increment": false
            },
            "page_meta_image": {
                "name": "page_meta_image",
                "type": "VARCHAR",
                "length": 255,
                "decimals": null,
                "values": null,
                "allow_null": true,
                "default": null,
                "comment": "",
                "unsigned": false,
                "auto_increment": false
            },
            "page_views": {
                "name": "page_views",
                "type": "INT",
                "length": null,
                "decimals": null,
                "values": null,
                "allow_null": false,
                "default": 0,
                "comment": "",
                "unsigned": false,
                "auto_increment": false
            },
            "page_group_defaults": {
                "name": "page_group_defaults",
                "type": "VARCHAR",
                "length": 255,
                "decimals": null,
                "values": null,
                "allow_null": true,
                "default": null,
                "comment": "",
                "unsigned": false,
                "auto_increment": false
            }
        },
        "indexes": {
            "PRIMARY": {
                "type": "primary",
                "name": "PRIMARY",
                "length": [
                    null
                ],
                "columns": [
                    "page_id"
                ]
            },
            "page_seo_name": {
                "type": "key",
                "name": "page_seo_name",
                "length": [
                    100
                ],
                "columns": [
                    "page_seo_name"
                ]
            },
            "page_default": {
                "type": "key",
                "name": "page_default",
                "length": [
                    null,
                    null
                ],
                "columns": [
                    "page_default",
                    "page_folder_id"
                ]
            },
            "page_full_path": {
                "type": "key",
                "name": "page_full_path",
                "length": [
                    191
                ],
                "columns": [
                    "page_full_path"
                ]
            },
            "page_folder": {
                "type": "key",
                "name": "page_folder",
                "length": [
                    null,
                    181
                ],
                "columns": [
                    "page_folder_id",
                    "page_seo_name"
                ]
            }
        },
        "collation": "utf8mb4_unicode_ci",
        "comment": "",
        "reporting": "count"
    },
    "cms_templates": {
        "name": "cms_templates",
        "columns": {
            "template_id": {
                "allow_null": false,
                "auto_increment": true,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 10,
                "name": "template_id",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "template_key": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "template_key",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "template_title": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "template_title",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "template_desc": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "template_desc",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "template_content": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "template_content",
                "type": "MEDIUMTEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "template_location": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "template_location",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "template_group": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "template_group",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "template_container": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "template_container",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "template_position": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 3,
                "name": "template_position",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "template_rel_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "template_rel_id",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "template_updated": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "template_updated",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "template_user_created": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "template_user_created",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "template_user_edited": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "template_user_edited",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "template_params": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "template_params",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "template_app": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 100,
                "name": "template_app",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "template_rel_type": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 150,
                "name": "template_rel_type",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "template_master": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "template_master",
                "type": "TINYINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "template_type": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "template",
                "length": 0,
                "name": "template_type",
                "type": "SET",
                "unsigned": false,
                "values": [
                    "css",
                    "template",
                    "js"
                ],
                "zerofill": false
            },
            "template_original_group": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 255,
                "name": "template_original_group",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "template_file_object": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "The URL for the file object that corresponds with this item.",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "template_file_object",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            }
        },
        "indexes": {
            "PRIMARY": {
                "type": "primary",
                "name": "PRIMARY",
                "length": [
                    null
                ],
                "columns": [
                    "template_id"
                ]
            },
            "template_location": {
                "type": "key",
                "name": "template_location",
                "length": [
                    190,
                    null
                ],
                "columns": [
                    "template_location",
                    "template_user_edited"
                ]
            },
            "template_key": {
                "type": "key",
                "name": "template_key",
                "length": [
                    191
                ],
                "columns": [
                    "template_key"
                ]
            },
            "template_type": {
                "type": "key",
                "name": "template_type",
                "columns": [
                    "template_type",
                    "template_user_edited"
                ],
                "length": [
                    null,
                    null
                ]
            }
        },
        "collation": "utf8mb4_unicode_ci"
    },
    "cms_database_reviews": {
        "name": "cms_database_reviews",
        "columns": {
            "review_id": {
                "allow_null": false,
                "auto_increment": true,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 20,
                "name": "review_id",
                "type": "BIGINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "review_database_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "review_database_id",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "review_item": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "review_item",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "review_author": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 20,
                "name": "review_author",
                "type": "BIGINT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "review_author_name": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "",
                "length": 255,
                "name": "review_author_name",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "review_content": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "review_content",
                "type": "MEDIUMTEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "review_date": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "review_date",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "review_ip_address": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "",
                "length": 46,
                "name": "review_ip_address",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "review_edit_time": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "review_edit_time",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "review_edit_member_name": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "",
                "length": 255,
                "name": "review_edit_member_name",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "review_edit_show": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "review_edit_show",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "review_rating": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "review_rating",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "review_votes_total": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "review_votes_total",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "review_votes_helpful": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "review_votes_helpful",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "review_votes_data": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "review_votes_data",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "review_approved": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 1,
                "name": "review_approved",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "review_author_response": {
                "name": "review_author_response",
                "type": "MEDIUMTEXT",
                "length": null,
                "decimals": null,
                "values": null,
                "allow_null": true,
                "default": null,
                "comment": "",
                "unsigned": false,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            }
        },
        "indexes": {
            "PRIMARY": {
                "type": "primary",
                "name": "PRIMARY",
                "length": [
                    null
                ],
                "columns": [
                    "review_id"
                ]
            },
            "review_database_id": {
                "type": "key",
                "name": "review_database_id",
                "length": [
                    null
                ],
                "columns": [
                    "review_database_id"
                ]
            },
            "review_approved": {
                "type": "key",
                "name": "review_approved",
                "columns": [
                    "review_approved"
                ],
                "length": [
                    null
                ]
            },
            "review_ip": {
                "type": "key",
                "name": "review_ip",
                "columns": [
                    "review_ip_address"
                ],
                "length": [
                    null
                ]
            },
            "review_author": {
                "type": "key",
                "name": "review_author",
                "columns": [
                    "review_author",
                    "review_date"
                ],
                "length": [
                    null,
                    null
                ]
            },
            "review_item": {
                "type": "key",
                "name": "review_item",
                "columns": [
                    "review_item",
                    "review_author"
                ],
                "length": [
                    null,
                    null
                ]
            }
        },
        "comment": "",
        "reporting": "count"
    },
    "cms_media": {
        "name": "cms_media",
        "columns": {
            "media_id": {
                "allow_null": false,
                "auto_increment": true,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 10,
                "name": "media_id",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "media_parent": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "media_parent",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "media_filename": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "",
                "length": 255,
                "name": "media_filename",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "media_added": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "media_added",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "media_full_path": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "media_full_path",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "media_file_object": {
                "name": "media_file_object",
                "type": "TEXT",
                "length": 0,
                "decimals": null,
                "values": [],
                "allow_null": true,
                "default": null,
                "comment": "",
                "unsigned": false,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            },
            "media_filename_stored": {
                "name": "media_filename_stored",
                "type": "TEXT",
                "length": 0,
                "decimals": null,
                "values": [],
                "allow_null": true,
                "default": null,
                "comment": "",
                "unsigned": false,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            },
            "media_is_image": {
                "name": "media_is_image",
                "type": "TINYINT",
                "length": 1,
                "decimals": null,
                "values": [],
                "allow_null": false,
                "default": "0",
                "comment": "",
                "unsigned": true,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            }
        },
        "indexes": {
            "PRIMARY": {
                "type": "primary",
                "name": "PRIMARY",
                "length": [
                    null
                ],
                "columns": [
                    "media_id"
                ]
            }
        },
        "collation": "utf8mb4_unicode_ci",
        "comment": "",
        "reporting": "count"
    },
    "cms_media_folders": {
        "name": "cms_media_folders",
        "columns": {
            "media_folder_id": {
                "allow_null": false,
                "auto_increment": true,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 10,
                "name": "media_folder_id",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "media_folder_parent": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "media_folder_parent",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "media_folder_name": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "",
                "length": 255,
                "name": "media_folder_name",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "media_folder_path": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "media_folder_path",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            }
        },
        "indexes": {
            "PRIMARY": {
                "type": "primary",
                "name": "PRIMARY",
                "length": [
                    null
                ],
                "columns": [
                    "media_folder_id"
                ]
            },
            "media_folder_parent": {
                "type": "key",
                "name": "media_folder_parent",
                "length": [
                    null
                ],
                "columns": [
                    "media_folder_parent"
                ]
            }
        },
        "collation": "utf8mb4_unicode_ci",
        "comment": "",
        "reporting": "count"
    },
    "cms_database_fields_reciprocal_map": {
        "name": "cms_database_fields_reciprocal_map",
        "columns": {
            "map_origin_database_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "map_origin_database_id",
                "type": "INT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            },
            "map_foreign_database_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "map_foreign_database_id",
                "type": "INT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            },
            "map_origin_item_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "map_origin_item_id",
                "type": "INT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            },
            "map_foreign_item_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "map_foreign_item_id",
                "type": "INT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            },
            "map_field_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "map_field_id",
                "type": "INT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            }
        },
        "indexes": {
            "map_origin": {
                "type": "key",
                "name": "map_origin",
                "length": [
                    null,
                    null
                ],
                "columns": [
                    "map_origin_database_id",
                    "map_origin_item_id"
                ]
            },
            "map_foreign": {
                "type": "key",
                "name": "map_foreign",
                "length": [
                    null,
                    null
                ],
                "columns": [
                    "map_foreign_database_id",
                    "map_foreign_item_id"
                ]
            }
        },
        "collation": "utf8mb4_unicode_ci",
        "engine": "InnoDB"
    },
    "cms_database_fields_thumbnails": {
        "name": "cms_database_fields_thumbnails",
        "columns": {
            "thumb_original_location": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "",
                "length": 255,
                "name": "thumb_original_location",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "thumb_location": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "",
                "length": 255,
                "name": "thumb_location",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "thumb_field_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "thumb_field_id",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "thumb_database_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "thumb_database_id",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "thumb_record_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "thumb_record_id",
                "type": "INT",
                "unsigned": true,
                "values": [],
                "zerofill": false
            }
        },
        "indexes": {
            "PRIMARY": {
                "type": "primary",
                "name": "PRIMARY",
                "length": [
                    null
                ],
                "columns": [
                    "thumb_original_location"
                ]
            }
        },
        "collation": "utf8_general_ci",
        "engine": "InnoDB"
    },
    "cms_template_conflicts": {
        "name": "cms_template_conflicts",
        "columns": {
            "conflict_id": {
                "allow_null": false,
                "auto_increment": true,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 10,
                "name": "conflict_id",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "conflict_key": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "",
                "length": 32,
                "name": "conflict_key",
                "type": "CHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "conflict_item_id": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "conflict_item_id",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "conflict_type": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "template",
                "length": 10,
                "name": "conflict_type",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "conflict_original_group": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "",
                "length": 100,
                "name": "conflict_original_group",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "conflict_group": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "",
                "length": 100,
                "name": "conflict_group",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "conflict_location": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "",
                "length": 255,
                "name": "conflict_location",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "conflict_title": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "",
                "length": 255,
                "name": "conflict_title",
                "type": "VARCHAR",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "conflict_data": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "conflict_data",
                "type": "TEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "conflict_content": {
                "allow_null": true,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "conflict_content",
                "type": "MEDIUMTEXT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            },
            "conflict_date": {
                "allow_null": false,
                "auto_increment": false,
                "binary": false,
                "comment": "",
                "decimals": null,
                "default": "0",
                "length": 10,
                "name": "conflict_date",
                "type": "INT",
                "unsigned": false,
                "values": [],
                "zerofill": false
            }
        },
        "indexes": {
            "PRIMARY": {
                "type": "primary",
                "name": "PRIMARY",
                "length": [
                    null
                ],
                "columns": [
                    "conflict_id"
                ]
            },
            "conflict_key": {
                "type": "key",
                "name": "conflict_key",
                "length": [
                    null,
                    null
                ],
                "columns": [
                    "conflict_key",
                    "conflict_type"
                ]
            }
        },
        "collation": "utf8_general_ci",
        "engine": "InnoDB"
    },
    "cms_page_revisions": {
        "name": "cms_page_revisions",
        "columns": {
            "revision_id": {
                "allow_null": false,
                "auto_increment": true,
                "comment": "ID Number",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "revision_id",
                "type": "BIGINT",
                "unsigned": true,
                "values": []
            },
            "revision_date": {
                "allow_null": true,
                "auto_increment": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "revision_date",
                "type": "INT",
                "unsigned": false,
                "values": []
            },
            "revision_member_id": {
                "allow_null": true,
                "auto_increment": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "revision_member_id",
                "type": "BIGINT",
                "unsigned": true,
                "values": []
            },
            "revision_page_id": {
                "allow_null": true,
                "auto_increment": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "revision_page_id",
                "type": "BIGINT",
                "unsigned": true,
                "values": []
            },
            "revision_data": {
                "allow_null": true,
                "auto_increment": false,
                "comment": "",
                "decimals": null,
                "default": null,
                "length": 0,
                "name": "revision_data",
                "type": "LONGTEXT",
                "unsigned": false,
                "values": []
            },
            "revision_manual_save": {
                "allow_null": false,
                "auto_increment": false,
                "comment": "",
                "decimals": null,
                "default": 0,
                "length": 1,
                "name": "revision_manual_save",
                "type": "TINYINT",
                "unsigned": false,
                "values": []
            }
        },
        "indexes": {
            "PRIMARY": {
                "type": "primary",
                "name": "PRIMARY",
                "length": [
                    null
                ],
                "columns": [
                    "revision_id"
                ]
            },
            "revision_page_id": {
                "type": "key",
                "name": "revision_page_id",
                "length": [
                    null
                ],
                "columns": [
                    "revision_page_id"
                ]
            }
        },
        "collation": "utf8mb4_unicode_ci"
    }
}