{
"blog_blogs": {
"name": "blog_blogs",
"columns": {
"blog_id": {
"allow_null": false,
"auto_increment": true,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 10,
"name": "blog_id",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"blog_member_id": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 20,
"name": "blog_member_id",
"type": "BIGINT",
"unsigned": true,
"values": [],
"zerofill": false
},
"blog_num_views": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 10,
"name": "blog_num_views",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"blog_pinned": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 1,
"name": "blog_pinned",
"type": "TINYINT",
"unsigned": false,
"values": [],
"zerofill": false
},
"blog_disabled": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 1,
"name": "blog_disabled",
"type": "TINYINT",
"unsigned": false,
"values": [],
"zerofill": false
},
"blog_allowguests": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "1",
"length": 1,
"name": "blog_allowguests",
"type": "TINYINT",
"unsigned": false,
"values": [],
"zerofill": false
},
"blog_rating_total": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 10,
"name": "blog_rating_total",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"blog_rating_count": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 10,
"name": "blog_rating_count",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"blog_settings": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 0,
"name": "blog_settings",
"type": "TEXT",
"unsigned": false,
"values": [],
"zerofill": false
},
"blog_last_visitors": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 0,
"name": "blog_last_visitors",
"type": "TEXT",
"unsigned": false,
"values": [],
"zerofill": false
},
"blog_seo_name": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 255,
"name": "blog_seo_name",
"type": "VARCHAR",
"unsigned": false,
"values": [],
"zerofill": false
},
"blog_editors": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 3,
"name": "blog_editors",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"blog_groupblog_ids": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "",
"length": 255,
"name": "blog_groupblog_ids",
"type": "VARCHAR",
"unsigned": false,
"values": [],
"zerofill": false
},
"blog_last_edate": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 10,
"name": "blog_last_edate",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"blog_count_entries": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 11,
"name": "blog_count_entries",
"type": "INT",
"unsigned": true,
"values": [],
"zerofill": false
},
"blog_count_comments": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 11,
"name": "blog_count_comments",
"type": "INT",
"unsigned": true,
"values": [],
"zerofill": false
},
"blog_count_entries_hidden": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 11,
"name": "blog_count_entries_hidden",
"type": "INT",
"unsigned": true,
"values": [],
"zerofill": false
},
"blog_count_comments_hidden": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 11,
"name": "blog_count_comments_hidden",
"type": "INT",
"unsigned": true,
"values": [],
"zerofill": false
},
"blog_rating_average": {
"name": "blog_rating_average",
"type": "DECIMAL",
"length": 11,
"decimals": 1,
"values": [],
"allow_null": false,
"default": "0",
"comment": "",
"unsigned": true,
"zerofill": false,
"auto_increment": false,
"binary": false
},
"blog_cover_photo": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 0,
"name": "blog_cover_photo",
"type": "TEXT",
"unsigned": false,
"values": [],
"zerofill": false
},
"blog_cover_photo_offset": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 10,
"name": "blog_cover_photo_offset",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"blog_social_group": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "The social group ID, is this is a private blog",
"decimals": null,
"default": null,
"length": 10,
"name": "blog_social_group",
"type": "INT",
"unsigned": true,
"values": [],
"zerofill": false
},
"blog_count_entries_future": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 10,
"name": "blog_count_entries_future",
"type": "INT",
"unsigned": true,
"values": [],
"zerofill": false
},
"blog_name": {
"name": "blog_name",
"type": "TEXT",
"length": null,
"decimals": null,
"values": [],
"allow_null": true,
"default": null,
"comment": "",
"unsigned": false,
"zerofill": false,
"auto_increment": false,
"binary": false
},
"blog_desc": {
"name": "blog_desc",
"type": "TEXT",
"length": null,
"decimals": null,
"values": [],
"allow_null": true,
"default": null,
"comment": "",
"unsigned": false,
"zerofill": false,
"auto_increment": false,
"binary": false
},
"blog_club_id": {
"name": "blog_club_id",
"type": "BIGINT",
"length": 20,
"decimals": null,
"values": null,
"allow_null": true,
"default": null,
"comment": "The club ID if this blog belongs to a club, or NULL",
"unsigned": true,
"zerofill": false,
"auto_increment": false,
"binary": false
},
"blog_sidebar": {
"name": "blog_sidebar",
"type": "TEXT",
"length": null,
"decimals": null,
"values": null,
"allow_null": true,
"default": null,
"comment": "",
"unsigned": false,
"zerofill": false,
"auto_increment": false,
"binary": false
},
"blog_category_id": {
"name": "blog_category_id",
"type": "BIGINT",
"length": 20,
"decimals": null,
"values": null,
"allow_null": true,
"default": null,
"comment": "",
"unsigned": true,
"zerofill": false,
"auto_increment": false,
"binary": false
},
"blog_allow_anonymous": {
"name": "blog_allow_anonymous",
"type": "TINYINT",
"length": null,
"decimals": null,
"values": null,
"allow_null": false,
"default": "0",
"comment": "",
"unsigned": true,
"auto_increment": false
},
"blog_last_poster_anon": {
"name": "blog_last_poster_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": [
"blog_id"
]
},
"blog_grabber": {
"type": "key",
"name": "blog_grabber",
"length": [
null
],
"columns": [
"blog_disabled"
]
},
"blog_pinned": {
"type": "key",
"name": "blog_pinned",
"length": [
null
],
"columns": [
"blog_pinned"
]
},
"blog_last_edate": {
"type": "key",
"name": "blog_last_edate",
"length": [
null
],
"columns": [
"blog_last_edate"
]
},
"blog_member_id": {
"type": "key",
"name": "blog_member_id",
"length": [
null
],
"columns": [
"blog_member_id"
]
},
"as_list_view": {
"type": "key",
"name": "as_list_view",
"length": [
null,
null,
null,
null
],
"columns": [
"blog_pinned",
"blog_disabled",
"blog_allowguests",
"blog_last_edate"
]
},
"blog_category_id": {
"type": "key",
"name": "blog_category_id",
"columns": [
"blog_category_id"
],
"length": [
null
]
}
},
"collation": "utf8mb4_unicode_ci",
"comment": "",
"reporting": "count"
},
"blog_entries": {
"name": "blog_entries",
"columns": {
"entry_id": {
"allow_null": false,
"auto_increment": true,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 10,
"name": "entry_id",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_blog_id": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 10,
"name": "entry_blog_id",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_author_id": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 20,
"name": "entry_author_id",
"type": "BIGINT",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_author_name": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "",
"length": 255,
"name": "entry_author_name",
"type": "VARCHAR",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_date": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 10,
"name": "entry_date",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_name": {
"name": "entry_name",
"type": "VARCHAR",
"length": 255,
"decimals": null,
"values": [],
"allow_null": true,
"default": null,
"comment": "",
"unsigned": false,
"zerofill": false,
"auto_increment": false,
"binary": false
},
"entry_content": {
"name": "entry_content",
"type": "MEDIUMTEXT",
"length": 0,
"decimals": null,
"values": [],
"allow_null": true,
"default": null,
"comment": "",
"unsigned": false,
"zerofill": false,
"auto_increment": false,
"binary": false
},
"entry_status": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 10,
"name": "entry_status",
"type": "VARCHAR",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_locked": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 1,
"name": "entry_locked",
"type": "TINYINT",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_num_comments": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 10,
"name": "entry_num_comments",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_last_comment_mid": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 20,
"name": "entry_last_comment_mid",
"type": "BIGINT",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_queued_comments": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 5,
"name": "entry_queued_comments",
"type": "SMALLINT",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_post_key": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 32,
"name": "entry_post_key",
"type": "VARCHAR",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_edit_time": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 10,
"name": "entry_edit_time",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_edit_name": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 255,
"name": "entry_edit_name",
"type": "VARCHAR",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_last_update": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 10,
"name": "entry_last_update",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_gallery_album": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 10,
"name": "entry_gallery_album",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_poll_state": {
"name": "entry_poll_state",
"type": "INT",
"length": 8,
"decimals": null,
"values": [],
"allow_null": true,
"default": null,
"comment": "",
"unsigned": true,
"zerofill": false,
"auto_increment": false,
"binary": false
},
"entry_featured": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 1,
"name": "entry_featured",
"type": "TINYINT",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_name_seo": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 255,
"name": "entry_name_seo",
"type": "VARCHAR",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_publish_date": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 10,
"name": "entry_publish_date",
"type": "INT",
"unsigned": true,
"values": [],
"zerofill": false
},
"entry_image": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "",
"length": 255,
"name": "entry_image",
"type": "VARCHAR",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_views": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 10,
"name": "entry_views",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_hidden": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 1,
"name": "entry_hidden",
"type": "TINYINT",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_pinned": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 1,
"name": "entry_pinned",
"type": "TINYINT",
"unsigned": true,
"values": [],
"zerofill": false
},
"entry_ip_address": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 46,
"name": "entry_ip_address",
"type": "VARCHAR",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_cover_photo": {
"name": "entry_cover_photo",
"type": "TEXT",
"length": null,
"decimals": null,
"values": [],
"allow_null": true,
"default": null,
"comment": "",
"unsigned": false,
"zerofill": false,
"auto_increment": false,
"binary": false
},
"entry_cover_photo_offset": {
"name": "entry_cover_photo_offset",
"type": "INT",
"length": 10,
"decimals": null,
"values": [],
"allow_null": true,
"default": null,
"comment": "",
"unsigned": true,
"zerofill": false,
"auto_increment": false,
"binary": false
},
"entry_hidden_comments": {
"name": "entry_hidden_comments",
"type": "INT",
"length": 10,
"decimals": null,
"values": [],
"allow_null": true,
"default": null,
"comment": "",
"unsigned": true,
"zerofill": false,
"auto_increment": false,
"binary": false
},
"entry_is_future_entry": {
"name": "entry_is_future_entry",
"type": "TINYINT",
"length": 1,
"decimals": null,
"values": [],
"allow_null": false,
"default": "0",
"comment": "Flag to show if an entry is set to be published in the future via the task",
"unsigned": true,
"zerofill": false,
"auto_increment": false,
"binary": false
},
"entry_meta_data": {
"name": "entry_meta_data",
"type": "TINYINT",
"length": 1,
"decimals": null,
"values": null,
"allow_null": false,
"default": "0",
"comment": "",
"unsigned": true,
"auto_increment": false
},
"entry_category_id": {
"name": "entry_category_id",
"type": "INT",
"length": 10,
"decimals": null,
"values": null,
"allow_null": true,
"default": null,
"comment": "",
"unsigned": true,
"zerofill": false,
"auto_increment": false,
"binary": false
},
"entry_append_edit": {
"name": "entry_append_edit",
"type": "TINYINT",
"length": 1,
"decimals": null,
"values": null,
"allow_null": false,
"default": "0",
"comment": "",
"unsigned": false,
"zerofill": false,
"auto_increment": false,
"binary": false
},
"entry_edit_reason": {
"name": "entry_edit_reason",
"type": "VARCHAR",
"length": 255,
"decimals": null,
"values": null,
"allow_null": true,
"default": null,
"comment": "",
"unsigned": false,
"zerofill": false,
"auto_increment": false,
"binary": false
},
"entry_is_anon": {
"name": "entry_is_anon",
"type": "TINYINT",
"length": null,
"decimals": null,
"values": null,
"allow_null": false,
"default": "0",
"comment": "",
"unsigned": true,
"auto_increment": false
},
"entry_last_poster_anon": {
"name": "entry_last_poster_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": [
"entry_id"
]
},
"entry_blog_id": {
"type": "key",
"name": "entry_blog_id",
"length": [
null,
null,
null
],
"columns": [
"entry_blog_id",
"entry_status",
"entry_date"
]
},
"entry_last_update": {
"type": "key",
"name": "entry_last_update",
"length": [
null,
null,
null
],
"columns": [
"entry_blog_id",
"entry_status",
"entry_last_update"
]
},
"entry_featured": {
"type": "key",
"name": "entry_featured",
"length": [
null
],
"columns": [
"entry_featured"
]
},
"entry_date": {
"type": "key",
"name": "entry_date",
"length": [
null
],
"columns": [
"entry_date"
]
},
"entry_status": {
"type": "key",
"name": "entry_status",
"length": [
null,
null
],
"columns": [
"entry_status",
"entry_last_update"
]
},
"entry_future_date": {
"type": "key",
"name": "entry_future_date",
"length": [
null,
null
],
"columns": [
"entry_publish_date",
"entry_date"
]
},
"ip_lookup": {
"type": "key",
"name": "ip_lookup",
"columns": [
"entry_ip_address"
],
"length": [
null
]
},
"entry_author_id": {
"type": "key",
"name": "entry_author_id",
"columns": [
"entry_author_id",
"entry_last_update"
],
"length": [
null,
null
]
}
},
"comment": "",
"reporting": "count"
},
"blog_comments": {
"name": "blog_comments",
"columns": {
"comment_id": {
"allow_null": false,
"auto_increment": true,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 10,
"name": "comment_id",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"comment_entry_id": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 10,
"name": "comment_entry_id",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"comment_member_id": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 20,
"name": "comment_member_id",
"type": "BIGINT",
"unsigned": true,
"values": [],
"zerofill": false
},
"comment_member_name": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 255,
"name": "comment_member_name",
"type": "VARCHAR",
"unsigned": false,
"values": [],
"zerofill": false
},
"comment_ip_address": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 46,
"name": "comment_ip_address",
"type": "VARCHAR",
"unsigned": false,
"values": [],
"zerofill": false
},
"comment_date": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 10,
"name": "comment_date",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"comment_edit_time": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 10,
"name": "comment_edit_time",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"comment_text": {
"name": "comment_text",
"type": "MEDIUMTEXT",
"length": 0,
"decimals": null,
"values": [],
"allow_null": true,
"default": null,
"comment": "",
"unsigned": false,
"auto_increment": false
},
"comment_approved": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 1,
"name": "comment_approved",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"comment_edit_member_name": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 255,
"name": "comment_edit_member_name",
"type": "VARCHAR",
"unsigned": false,
"values": [],
"zerofill": false
},
"comment_edit_show": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 1,
"name": "comment_edit_show",
"type": "TINYINT",
"unsigned": true,
"values": [],
"zerofill": 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_member_id": {
"type": "key",
"name": "comment_member_id",
"length": [
null,
null
],
"columns": [
"comment_member_id",
"comment_date"
]
},
"entry_comment": {
"type": "key",
"name": "entry_comment",
"length": [
null,
null
],
"columns": [
"comment_id",
"comment_entry_id"
]
},
"entry_id": {
"type": "key",
"name": "entry_id",
"length": [
null,
null
],
"columns": [
"comment_entry_id",
"comment_approved"
]
},
"comment_approved": {
"type": "key",
"name": "comment_approved",
"columns": [
"comment_approved"
],
"length": [
null
]
},
"ip_lookup": {
"type": "key",
"name": "ip_lookup",
"columns": [
"comment_ip_address"
],
"length": [
null
]
}
},
"comment": "",
"reporting": "count"
},
"blog_categories": {
"name": "blog_categories",
"columns": {
"category_id": {
"allow_null": false,
"auto_increment": true,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 5,
"name": "category_id",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"category_seo_name": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 255,
"name": "category_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": 5,
"name": "category_position",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"category_parent": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 5,
"name": "category_parent",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
}
},
"indexes": {
"PRIMARY": {
"type": "primary",
"name": "PRIMARY",
"length": [
null
],
"columns": [
"category_id"
]
},
"pg_position": {
"type": "key",
"name": "pg_position",
"length": [
null
],
"columns": [
"category_position"
]
},
"pg_parent": {
"type": "key",
"name": "pg_parent",
"length": [
null
],
"columns": [
"category_parent"
]
}
},
"collation": "utf8mb4_unicode_ci",
"engine": "InnoDB"
},
"blog_entry_categories": {
"name": "blog_entry_categories",
"columns": {
"entry_category_id": {
"allow_null": false,
"auto_increment": true,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 10,
"name": "entry_category_id",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_category_name": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 255,
"name": "entry_category_name",
"type": "VARCHAR",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_category_seo_name": {
"allow_null": true,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": null,
"length": 255,
"name": "entry_category_seo_name",
"type": "VARCHAR",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_category_position": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 5,
"name": "entry_category_position",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_category_blog_id": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "",
"length": 10,
"name": "entry_category_blog_id",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
},
"entry_category_count": {
"allow_null": false,
"auto_increment": false,
"binary": false,
"comment": "",
"decimals": null,
"default": "0",
"length": 10,
"name": "entry_category_count",
"type": "INT",
"unsigned": false,
"values": [],
"zerofill": false
}
},
"indexes": {
"PRIMARY": {
"type": "primary",
"name": "PRIMARY",
"length": [
null
],
"columns": [
"entry_category_id"
]
},
"pg_position": {
"type": "key",
"name": "pg_position",
"length": [
null
],
"columns": [
"entry_category_position"
]
}
},
"collation": "utf8mb4_unicode_ci",
"engine": "InnoDB"
}
}