{
    "database": {
        "collation": "utf8mb4",
        "character_set": "utf8mb4_unicode_520_ci"
    },
    "tables": [
        {
            "Table": "resource",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "search_metadata",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "user_groups",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "resource_url",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "user_keywordgroups",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "wordprocessor",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "resource_page",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "bibtex_string",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "resource_creator",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "search_custom",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "resource_misc",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "user_tags",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "search_ideas",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "subcategory",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "news",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "publisher",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "user_bibliography_resource",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "tag",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "version",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "import_raw",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "session_browser_tab",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "session",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "config",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "ideas_keyword",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "custom",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "resource_metadata",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "resource_category",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "cache",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "statistics_attachment_downloads",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "resource_timestamp",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "resource_custom",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "publication_list_bib",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "resource_year",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "user_groups_users",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "ideas",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "search_abstractnotes",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "users_basket",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "users_bookmarks",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "user_register",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "user_bibliography",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "statistics_resource_views",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "resource_keyword",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "resource_text",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "creator",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "resource_attachments",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "collection",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "search_resources",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "category",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "keyword",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "publication_list",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "users",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "user_kg_usergroups",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "resource_user_tags",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        },
        {
            "Table": "user_kg_keywords",
            "Engine": "InnoDB",
            "Collation": "utf8mb4_unicode_520_ci"
        }
    ],
    "fields": [
        {
            "Table": "resource",
            "Field": "resourceId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "resource",
            "Field": "resourceType",
            "Type": "varchar(100)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceTitle",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceSubtitle",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceShortTitle",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceTransTitle",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceTransSubtitle",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceTransShortTitle",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceField1",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceField2",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceField3",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceField4",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceField5",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceField6",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceField7",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceField8",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceField9",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceNoSort",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceTransNoSort",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceIsbn",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceBibtexKey",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceDoi",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceTitleSort",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource",
            "Field": "resourceLanguage",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "search_metadata",
            "Field": "searchmetadataId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "search_metadata",
            "Field": "searchmetadataResourceId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "search_metadata",
            "Field": "searchmetadataMetadataId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "search_metadata",
            "Field": "searchmetadataAddUserId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "search_metadata",
            "Field": "searchmetadataType",
            "Type": "varchar(10)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "search_metadata",
            "Field": "searchmetadataPrivate",
            "Type": "varchar(8)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": "N",
            "Extra": ""
        },
        {
            "Table": "search_metadata",
            "Field": "searchmetadataText",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "user_groups",
            "Field": "usergroupsId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "user_groups",
            "Field": "usergroupsTitle",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "user_groups",
            "Field": "usergroupsDescription",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "user_groups",
            "Field": "usergroupsAdminId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_url",
            "Field": "resourceurlId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "resource_url",
            "Field": "resourceurlResourceId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_url",
            "Field": "resourceurlUrl",
            "Type": "varchar(10000)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_url",
            "Field": "resourceurlName",
            "Type": "varchar(768)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": "",
            "Extra": ""
        },
        {
            "Table": "resource_url",
            "Field": "resourceurlPrimary",
            "Type": "tinyint",
            "Collation": null,
            "Null": "NO",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "user_keywordgroups",
            "Field": "userkeywordgroupsId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "user_keywordgroups",
            "Field": "userkeywordgroupsUserId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "user_keywordgroups",
            "Field": "userkeywordgroupsName",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "user_keywordgroups",
            "Field": "userkeywordgroupsDescription",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "wordprocessor",
            "Field": "wordprocessorId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "wordprocessor",
            "Field": "wordprocessorUserId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "wordprocessor",
            "Field": "wordprocessorTimestamp",
            "Type": "datetime",
            "Collation": null,
            "Null": "NO",
            "Default": "CURRENT_TIMESTAMP",
            "Extra": "on update CURRENT_TIMESTAMP"
        },
        {
            "Table": "wordprocessor",
            "Field": "wordprocessorPreferences",
            "Type": "mediumblob",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "wordprocessor",
            "Field": "wordprocessorTitle",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "wordprocessor",
            "Field": "wordprocessorPaper",
            "Type": "longtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_page",
            "Field": "resourcepageId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_page",
            "Field": "resourcepagePageStart",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_page",
            "Field": "resourcepagePageEnd",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "bibtex_string",
            "Field": "bibtexstringId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "bibtex_string",
            "Field": "bibtexstringText",
            "Type": "mediumblob",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_creator",
            "Field": "resourcecreatorId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "resource_creator",
            "Field": "resourcecreatorResourceId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_creator",
            "Field": "resourcecreatorCreatorId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_creator",
            "Field": "resourcecreatorOrder",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_creator",
            "Field": "resourcecreatorRole",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_creator",
            "Field": "resourcecreatorCreatorMain",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_creator",
            "Field": "resourcecreatorCreatorSurname",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "search_custom",
            "Field": "searchcustomId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "search_custom",
            "Field": "searchcustomResourceId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "search_custom",
            "Field": "searchcustomCustomId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "search_custom",
            "Field": "searchcustomText",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_misc",
            "Field": "resourcemiscId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_misc",
            "Field": "resourcemiscCollection",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_misc",
            "Field": "resourcemiscPublisher",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_misc",
            "Field": "resourcemiscField1",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_misc",
            "Field": "resourcemiscField2",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_misc",
            "Field": "resourcemiscField3",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_misc",
            "Field": "resourcemiscField4",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_misc",
            "Field": "resourcemiscField5",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_misc",
            "Field": "resourcemiscField6",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_misc",
            "Field": "resourcemiscTag",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_misc",
            "Field": "resourcemiscAddUserIdResource",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_misc",
            "Field": "resourcemiscEditUserIdResource",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_misc",
            "Field": "resourcemiscMaturityIndex",
            "Type": "double",
            "Collation": null,
            "Null": "YES",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "resource_misc",
            "Field": "resourcemiscPeerReviewed",
            "Type": "varchar(1)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": "N",
            "Extra": ""
        },
        {
            "Table": "resource_misc",
            "Field": "resourcemiscQuarantine",
            "Type": "varchar(1)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": "N",
            "Extra": ""
        },
        {
            "Table": "resource_misc",
            "Field": "resourcemiscMetadata",
            "Type": "tinyint",
            "Collation": null,
            "Null": "NO",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "resource_misc",
            "Field": "resourcemiscPublicationStatus",
            "Type": "tinyint",
            "Collation": null,
            "Null": "NO",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "user_tags",
            "Field": "usertagsId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "user_tags",
            "Field": "usertagsUserId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "user_tags",
            "Field": "usertagsTag",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "search_ideas",
            "Field": "searchideasId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "search_ideas",
            "Field": "searchideasIdeasId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "search_ideas",
            "Field": "searchideasAddUserId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "search_ideas",
            "Field": "searchideasPrivate",
            "Type": "varchar(1)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": "N",
            "Extra": ""
        },
        {
            "Table": "search_ideas",
            "Field": "searchideasText",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "subcategory",
            "Field": "subcategoryId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "subcategory",
            "Field": "subcategoryCategoryId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "subcategory",
            "Field": "subcategorySubcategory",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "news",
            "Field": "newsId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "news",
            "Field": "newsTitle",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "news",
            "Field": "newsNews",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "news",
            "Field": "newsTimestamp",
            "Type": "datetime",
            "Collation": null,
            "Null": "NO",
            "Default": "CURRENT_TIMESTAMP",
            "Extra": "on update CURRENT_TIMESTAMP"
        },
        {
            "Table": "news",
            "Field": "newsEmailSent",
            "Type": "varchar(1)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": "N",
            "Extra": ""
        },
        {
            "Table": "publisher",
            "Field": "publisherId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "publisher",
            "Field": "publisherName",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "publisher",
            "Field": "publisherLocation",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "publisher",
            "Field": "publisherType",
            "Type": "varchar(100)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "user_bibliography_resource",
            "Field": "userbibliographyresourceId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "user_bibliography_resource",
            "Field": "userbibliographyresourceBibliographyId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "user_bibliography_resource",
            "Field": "userbibliographyresourceResourceId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "tag",
            "Field": "tagId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "tag",
            "Field": "tagTag",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "tag",
            "Field": "tagUserId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "version",
            "Field": "versionComponentType",
            "Type": "varchar(32)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "version",
            "Field": "versionComponentId",
            "Type": "varchar(256)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "version",
            "Field": "versionInternalVersion",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "import_raw",
            "Field": "importrawId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "import_raw",
            "Field": "importrawStringId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "import_raw",
            "Field": "importrawText",
            "Type": "mediumblob",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "import_raw",
            "Field": "importrawImportType",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "session_browser_tab",
            "Field": "sessionbrowsertabId",
            "Type": "varchar(36)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "session_browser_tab",
            "Field": "sessionbrowsertabUserId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "session_browser_tab",
            "Field": "sessionbrowsertabTimestamp",
            "Type": "datetime",
            "Collation": null,
            "Null": "NO",
            "Default": "CURRENT_TIMESTAMP",
            "Extra": "on update CURRENT_TIMESTAMP"
        },
        {
            "Table": "session_browser_tab",
            "Field": "sessionbrowsertabData",
            "Type": "longblob",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "session",
            "Field": "sessionId",
            "Type": "varchar(256)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "session",
            "Field": "sessionUserId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "session",
            "Field": "sessionLastAccessTimestamp",
            "Type": "datetime",
            "Collation": null,
            "Null": "NO",
            "Default": "CURRENT_TIMESTAMP",
            "Extra": "on update CURRENT_TIMESTAMP"
        },
        {
            "Table": "session",
            "Field": "sessionData",
            "Type": "longblob",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "config",
            "Field": "configId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "config",
            "Field": "configName",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "config",
            "Field": "configInt",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "config",
            "Field": "configVarchar",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "config",
            "Field": "configText",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "config",
            "Field": "configBoolean",
            "Type": "tinyint",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "config",
            "Field": "configDatetime",
            "Type": "datetime",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "ideas_keyword",
            "Field": "ideaskeywordId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "ideas_keyword",
            "Field": "ideaskeywordIdeasId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "ideas_keyword",
            "Field": "ideaskeywordKeywordId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "custom",
            "Field": "customId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "custom",
            "Field": "customLabel",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "custom",
            "Field": "customSize",
            "Type": "varchar(1)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": "S",
            "Extra": ""
        },
        {
            "Table": "resource_metadata",
            "Field": "resourcemetadataId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "resource_metadata",
            "Field": "resourcemetadataResourceId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_metadata",
            "Field": "resourcemetadataMetadataId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_metadata",
            "Field": "resourcemetadataAddUserId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_metadata",
            "Field": "resourcemetadataPageStart",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_metadata",
            "Field": "resourcemetadataPageEnd",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_metadata",
            "Field": "resourcemetadataParagraph",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_metadata",
            "Field": "resourcemetadataSection",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_metadata",
            "Field": "resourcemetadataChapter",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_metadata",
            "Field": "resourcemetadataType",
            "Type": "varchar(2)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_metadata",
            "Field": "resourcemetadataPrivate",
            "Type": "varchar(8)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": "N",
            "Extra": ""
        },
        {
            "Table": "resource_metadata",
            "Field": "resourcemetadataText",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_metadata",
            "Field": "resourcemetadataTimestamp",
            "Type": "datetime",
            "Collation": null,
            "Null": "YES",
            "Default": "CURRENT_TIMESTAMP",
            "Extra": ""
        },
        {
            "Table": "resource_metadata",
            "Field": "resourcemetadataTimestampEdited",
            "Type": "datetime",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_category",
            "Field": "resourcecategoryId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "resource_category",
            "Field": "resourcecategoryResourceId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_category",
            "Field": "resourcecategoryCategoryId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_category",
            "Field": "resourcecategorySubcategoryId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "cache",
            "Field": "cacheId",
            "Type": "varchar(256)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "cache",
            "Field": "cacheData",
            "Type": "longblob",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "cache",
            "Field": "cacheTimestamp",
            "Type": "datetime",
            "Collation": null,
            "Null": "NO",
            "Default": "CURRENT_TIMESTAMP",
            "Extra": "on update CURRENT_TIMESTAMP"
        },
        {
            "Table": "statistics_attachment_downloads",
            "Field": "statisticsattachmentdownloadsId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "statistics_attachment_downloads",
            "Field": "statisticsattachmentdownloadsResourceId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "statistics_attachment_downloads",
            "Field": "statisticsattachmentdownloadsAttachmentId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "statistics_attachment_downloads",
            "Field": "statisticsattachmentdownloadsCount",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "statistics_attachment_downloads",
            "Field": "statisticsattachmentdownloadsMonth",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "resource_timestamp",
            "Field": "resourcetimestampId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_timestamp",
            "Field": "resourcetimestampTimestamp",
            "Type": "datetime",
            "Collation": null,
            "Null": "YES",
            "Default": "CURRENT_TIMESTAMP",
            "Extra": ""
        },
        {
            "Table": "resource_timestamp",
            "Field": "resourcetimestampTimestampAdd",
            "Type": "datetime",
            "Collation": null,
            "Null": "YES",
            "Default": "CURRENT_TIMESTAMP",
            "Extra": ""
        },
        {
            "Table": "resource_custom",
            "Field": "resourcecustomId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "resource_custom",
            "Field": "resourcecustomCustomId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_custom",
            "Field": "resourcecustomResourceId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_custom",
            "Field": "resourcecustomText",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_custom",
            "Field": "resourcecustomAddUserIdCustom",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_custom",
            "Field": "resourcecustomEditUserIdCustom",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "publication_list_bib",
            "Field": "publicationlistbibListId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "publication_list_bib",
            "Field": "publicationlistbibBibId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_year",
            "Field": "resourceyearId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_year",
            "Field": "resourceyearYear1",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_year",
            "Field": "resourceyearYear2",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_year",
            "Field": "resourceyearYear3",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_year",
            "Field": "resourceyearYear4",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "user_groups_users",
            "Field": "usergroupsusersId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "user_groups_users",
            "Field": "usergroupsusersGroupId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "user_groups_users",
            "Field": "usergroupsusersUserId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "ideas",
            "Field": "ideasId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "ideas",
            "Field": "ideasIdeasId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "ideas",
            "Field": "ideasAddUserId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "ideas",
            "Field": "ideasTimestamp",
            "Type": "datetime",
            "Collation": null,
            "Null": "YES",
            "Default": "CURRENT_TIMESTAMP",
            "Extra": ""
        },
        {
            "Table": "ideas",
            "Field": "ideasTimestampEdited",
            "Type": "datetime",
            "Collation": null,
            "Null": "NO",
            "Default": "CURRENT_TIMESTAMP",
            "Extra": "on update CURRENT_TIMESTAMP"
        },
        {
            "Table": "ideas",
            "Field": "ideasPrivate",
            "Type": "varchar(8)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": "N",
            "Extra": ""
        },
        {
            "Table": "ideas",
            "Field": "ideasText",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "search_abstractnotes",
            "Field": "searchabstractnotesId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "search_abstractnotes",
            "Field": "searchabstractnotesResourceId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "search_abstractnotes",
            "Field": "searchabstractnotesType",
            "Type": "varchar(10)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "search_abstractnotes",
            "Field": "searchabstractnotesText",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "users_basket",
            "Field": "usersbasketId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "users_basket",
            "Field": "usersbasketUserId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "users_basket",
            "Field": "usersbasketBasket",
            "Type": "mediumblob",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "users_basket",
            "Field": "usersbasketIdeasbasket",
            "Type": "mediumblob",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "users_bookmarks",
            "Field": "usersbookmarksId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "users_bookmarks",
            "Field": "usersbookmarksUserId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "users_bookmarks",
            "Field": "usersbookmarksBookmarks",
            "Type": "mediumblob",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "user_register",
            "Field": "userregisterId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "user_register",
            "Field": "userregisterHashKey",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "user_register",
            "Field": "userregisterEmail",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "user_register",
            "Field": "userregisterTimestamp",
            "Type": "datetime",
            "Collation": null,
            "Null": "YES",
            "Default": "CURRENT_TIMESTAMP",
            "Extra": ""
        },
        {
            "Table": "user_register",
            "Field": "userregisterConfirmed",
            "Type": "varchar(1)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": "N",
            "Extra": ""
        },
        {
            "Table": "user_register",
            "Field": "userregisterRequest",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "user_bibliography",
            "Field": "userbibliographyId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "user_bibliography",
            "Field": "userbibliographyUserId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "user_bibliography",
            "Field": "userbibliographyUserGroupId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "user_bibliography",
            "Field": "userbibliographyTitle",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "user_bibliography",
            "Field": "userbibliographyDescription",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "statistics_resource_views",
            "Field": "statisticsresourceviewsId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "statistics_resource_views",
            "Field": "statisticsresourceviewsResourceId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "statistics_resource_views",
            "Field": "statisticsresourceviewsCount",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "statistics_resource_views",
            "Field": "statisticsresourceviewsMonth",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "resource_keyword",
            "Field": "resourcekeywordId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "resource_keyword",
            "Field": "resourcekeywordResourceId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_keyword",
            "Field": "resourcekeywordKeywordId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_keyword",
            "Field": "resourcekeywordMetadataId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_text",
            "Field": "resourcetextId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_text",
            "Field": "resourcetextAddUserIdNote",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_text",
            "Field": "resourcetextEditUserIdNote",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_text",
            "Field": "resourcetextAddUserIdAbstract",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_text",
            "Field": "resourcetextEditUserIdAbstract",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_text",
            "Field": "resourcetextNote",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_text",
            "Field": "resourcetextAbstract",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "creator",
            "Field": "creatorId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "creator",
            "Field": "creatorSurname",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "creator",
            "Field": "creatorFirstname",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "creator",
            "Field": "creatorInitials",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "creator",
            "Field": "creatorPrefix",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "creator",
            "Field": "creatorSameAs",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_attachments",
            "Field": "resourceattachmentsId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "resource_attachments",
            "Field": "resourceattachmentsHashFilename",
            "Type": "varchar(40)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_attachments",
            "Field": "resourceattachmentsResourceId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_attachments",
            "Field": "resourceattachmentsFileName",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_attachments",
            "Field": "resourceattachmentsFileType",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_attachments",
            "Field": "resourceattachmentsFileSize",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "resource_attachments",
            "Field": "resourceattachmentsPrimary",
            "Type": "varchar(1)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": "N",
            "Extra": ""
        },
        {
            "Table": "resource_attachments",
            "Field": "resourceattachmentsTimestamp",
            "Type": "datetime",
            "Collation": null,
            "Null": "YES",
            "Default": "CURRENT_TIMESTAMP",
            "Extra": ""
        },
        {
            "Table": "resource_attachments",
            "Field": "resourceattachmentsEmbargo",
            "Type": "varchar(1)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": "N",
            "Extra": ""
        },
        {
            "Table": "resource_attachments",
            "Field": "resourceattachmentsEmbargoUntil",
            "Type": "datetime",
            "Collation": null,
            "Null": "YES",
            "Default": "CURRENT_TIMESTAMP",
            "Extra": ""
        },
        {
            "Table": "resource_attachments",
            "Field": "resourceattachmentsDescription",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_attachments",
            "Field": "resourceattachmentsText",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "collection",
            "Field": "collectionId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "collection",
            "Field": "collectionTitle",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "collection",
            "Field": "collectionTitleShort",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "collection",
            "Field": "collectionType",
            "Type": "varchar(100)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "collection",
            "Field": "collectionDefault",
            "Type": "longblob",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "search_resources",
            "Field": "searchresourcesId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "search_resources",
            "Field": "searchresourcesResourceId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "search_resources",
            "Field": "searchresourcesType",
            "Type": "varchar(10)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "search_resources",
            "Field": "searchresourcesText",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "category",
            "Field": "categoryId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "category",
            "Field": "categoryCategory",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "keyword",
            "Field": "keywordId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "keyword",
            "Field": "keywordKeyword",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "keyword",
            "Field": "keywordGlossary",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "publication_list",
            "Field": "publicationlistId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "publication_list",
            "Field": "publicationlistTitle",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "publication_list",
            "Field": "publicationlistDescription",
            "Type": "mediumtext",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "publication_list",
            "Field": "publicationlistViewAttach",
            "Type": "varchar(1)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": "N",
            "Extra": ""
        },
        {
            "Table": "publication_list",
            "Field": "publicationlistLanguage",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": "auto",
            "Extra": ""
        },
        {
            "Table": "publication_list",
            "Field": "publicationlistStyle",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": "apa",
            "Extra": ""
        },
        {
            "Table": "publication_list",
            "Field": "publicationlistTemplate",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": "default",
            "Extra": ""
        },
        {
            "Table": "publication_list",
            "Field": "publicationlistUserId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": "1",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "users",
            "Field": "usersUsername",
            "Type": "varchar(188)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersPassword",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": "",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersFullname",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": "",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersEmail",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": "",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersTimestamp",
            "Type": "datetime",
            "Collation": null,
            "Null": "NO",
            "Default": "CURRENT_TIMESTAMP",
            "Extra": "on update CURRENT_TIMESTAMP"
        },
        {
            "Table": "users",
            "Field": "usersAdmin",
            "Type": "tinyint",
            "Collation": null,
            "Null": "NO",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersAuthRememberMe",
            "Type": "varchar(1)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": "N",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersPaging",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": "20",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersPagingMaxLinks",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": "11",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersPagingStyle",
            "Type": "varchar(1)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": "N",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersStringLimit",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": "40",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersLanguage",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": "auto",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersStyle",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": "apa",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersTemplate",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": "default",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersNotify",
            "Type": "varchar(1)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": "N",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersNotifyAddEdit",
            "Type": "varchar(1)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": "A",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersNotifyThreshold",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersNotifyTimestamp",
            "Type": "datetime",
            "Collation": null,
            "Null": "NO",
            "Default": "CURRENT_TIMESTAMP",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersPagingTagCloud",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": "100",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersUseBibtexKey",
            "Type": "tinyint",
            "Collation": null,
            "Null": "NO",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersUseWikindxKey",
            "Type": "tinyint",
            "Collation": null,
            "Null": "NO",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersDisplayCmsLink",
            "Type": "tinyint",
            "Collation": null,
            "Null": "NO",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersIsCreator",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersListLink",
            "Type": "tinyint",
            "Collation": null,
            "Null": "NO",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersDepartment",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersTemplateMenu",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersInstitution",
            "Type": "varchar(1020)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersNotifyDigestThreshold",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": "100",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersGDPR",
            "Type": "varchar(1)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": "N",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersBlock",
            "Type": "varchar(1)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": "N",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersHomeBib",
            "Type": "tinyint",
            "Collation": null,
            "Null": "NO",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersBrowseBibliography",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersLastInternalVersion",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersDisplayResourceStatistics",
            "Type": "tinyint",
            "Collation": null,
            "Null": "NO",
            "Default": "0",
            "Extra": ""
        },
        {
            "Table": "users",
            "Field": "usersTimezone",
            "Type": "varchar(200)",
            "Collation": "utf8mb4_unicode_520_ci",
            "Null": "NO",
            "Default": "auto",
            "Extra": ""
        },
        {
            "Table": "user_kg_usergroups",
            "Field": "userkgusergroupsId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "user_kg_usergroups",
            "Field": "userkgusergroupsKeywordGroupId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "user_kg_usergroups",
            "Field": "userkgusergroupsUserGroupId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_user_tags",
            "Field": "resourceusertagsId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "resource_user_tags",
            "Field": "resourceusertagsTagId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "resource_user_tags",
            "Field": "resourceusertagsResourceId",
            "Type": "int",
            "Collation": null,
            "Null": "YES",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "user_kg_keywords",
            "Field": "userkgkeywordsId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": "auto_increment"
        },
        {
            "Table": "user_kg_keywords",
            "Field": "userkgkeywordsKeywordGroupId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        },
        {
            "Table": "user_kg_keywords",
            "Field": "userkgkeywordsKeywordId",
            "Type": "int",
            "Collation": null,
            "Null": "NO",
            "Default": null,
            "Extra": ""
        }
    ],
    "indices": [
        {
            "Table": "resource",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "resourceId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource",
            "Non_unique": "1",
            "Key_name": "resourceTitle",
            "Seq_in_index": "1",
            "Column_name": "resourceTitle",
            "Collation": "A",
            "Sub_part": "768",
            "Index_type": "BTREE"
        },
        {
            "Table": "resource",
            "Non_unique": "1",
            "Key_name": "resourceType",
            "Seq_in_index": "1",
            "Column_name": "resourceType",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "search_metadata",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "searchmetadataId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "search_metadata",
            "Non_unique": "1",
            "Key_name": "searchmetadataResourceId",
            "Seq_in_index": "1",
            "Column_name": "searchmetadataResourceId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "search_metadata",
            "Non_unique": "1",
            "Key_name": "searchmetadataMetadataId",
            "Seq_in_index": "1",
            "Column_name": "searchmetadataMetadataId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "search_metadata",
            "Non_unique": "1",
            "Key_name": "searchmetadataAddUserId",
            "Seq_in_index": "1",
            "Column_name": "searchmetadataAddUserId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "search_metadata",
            "Non_unique": "1",
            "Key_name": "searchmetadataText",
            "Seq_in_index": "1",
            "Column_name": "searchmetadataText",
            "Collation": null,
            "Sub_part": null,
            "Index_type": "FULLTEXT"
        },
        {
            "Table": "user_groups",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "usergroupsId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_groups",
            "Non_unique": "1",
            "Key_name": "usergroupsAdminId",
            "Seq_in_index": "1",
            "Column_name": "usergroupsAdminId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_url",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "resourceurlId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_url",
            "Non_unique": "1",
            "Key_name": "resourceurlPrimary",
            "Seq_in_index": "1",
            "Column_name": "resourceurlPrimary",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_url",
            "Non_unique": "1",
            "Key_name": "resourceurlResourceId",
            "Seq_in_index": "1",
            "Column_name": "resourceurlResourceId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_keywordgroups",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "userkeywordgroupsId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_keywordgroups",
            "Non_unique": "1",
            "Key_name": "userkeywordgroupsUserId",
            "Seq_in_index": "1",
            "Column_name": "userkeywordgroupsUserId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "wordprocessor",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "wordprocessorId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "wordprocessor",
            "Non_unique": "1",
            "Key_name": "wordprocessorUserId",
            "Seq_in_index": "1",
            "Column_name": "wordprocessorUserId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_page",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "resourcepageId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "bibtex_string",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "bibtexstringId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_creator",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "resourcecreatorId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_creator",
            "Non_unique": "1",
            "Key_name": "resourcecreatorCreatorId",
            "Seq_in_index": "1",
            "Column_name": "resourcecreatorCreatorId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_creator",
            "Non_unique": "1",
            "Key_name": "resourcecreatorCreatorSurname",
            "Seq_in_index": "1",
            "Column_name": "resourcecreatorCreatorSurname",
            "Collation": "A",
            "Sub_part": "100",
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_creator",
            "Non_unique": "1",
            "Key_name": "resourcecreatorResourceId",
            "Seq_in_index": "1",
            "Column_name": "resourcecreatorResourceId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_creator",
            "Non_unique": "1",
            "Key_name": "resourcecreatorRole",
            "Seq_in_index": "1",
            "Column_name": "resourcecreatorRole",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "search_custom",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "searchcustomId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "search_custom",
            "Non_unique": "1",
            "Key_name": "searchcustomResourceId",
            "Seq_in_index": "1",
            "Column_name": "searchcustomResourceId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "search_custom",
            "Non_unique": "1",
            "Key_name": "searchcustomCustomId",
            "Seq_in_index": "1",
            "Column_name": "searchcustomCustomId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "search_custom",
            "Non_unique": "1",
            "Key_name": "searchcustomText",
            "Seq_in_index": "1",
            "Column_name": "searchcustomText",
            "Collation": null,
            "Sub_part": null,
            "Index_type": "FULLTEXT"
        },
        {
            "Table": "resource_misc",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "resourcemiscId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_misc",
            "Non_unique": "1",
            "Key_name": "resourcemiscAddUserIdResource",
            "Seq_in_index": "1",
            "Column_name": "resourcemiscAddUserIdResource",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_misc",
            "Non_unique": "1",
            "Key_name": "resourcemiscCollection",
            "Seq_in_index": "1",
            "Column_name": "resourcemiscCollection",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_misc",
            "Non_unique": "1",
            "Key_name": "resourcemiscEditUserIdResource",
            "Seq_in_index": "1",
            "Column_name": "resourcemiscEditUserIdResource",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_misc",
            "Non_unique": "1",
            "Key_name": "resourcemiscPeerReviewed",
            "Seq_in_index": "1",
            "Column_name": "resourcemiscPeerReviewed",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_misc",
            "Non_unique": "1",
            "Key_name": "resourcemiscPublisher",
            "Seq_in_index": "1",
            "Column_name": "resourcemiscPublisher",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_misc",
            "Non_unique": "1",
            "Key_name": "resourcemiscQuarantine",
            "Seq_in_index": "1",
            "Column_name": "resourcemiscQuarantine",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_tags",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "usertagsId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_tags",
            "Non_unique": "1",
            "Key_name": "usertagsUserId",
            "Seq_in_index": "1",
            "Column_name": "usertagsUserId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "search_ideas",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "searchideasId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "search_ideas",
            "Non_unique": "1",
            "Key_name": "searchideasIdeasId",
            "Seq_in_index": "1",
            "Column_name": "searchideasIdeasId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "search_ideas",
            "Non_unique": "1",
            "Key_name": "searchideasAddUserId",
            "Seq_in_index": "1",
            "Column_name": "searchideasAddUserId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "search_ideas",
            "Non_unique": "1",
            "Key_name": "searchideasText",
            "Seq_in_index": "1",
            "Column_name": "searchideasText",
            "Collation": null,
            "Sub_part": null,
            "Index_type": "FULLTEXT"
        },
        {
            "Table": "subcategory",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "subcategoryId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "subcategory",
            "Non_unique": "1",
            "Key_name": "subcategoryCategoryId",
            "Seq_in_index": "1",
            "Column_name": "subcategoryCategoryId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "news",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "newsId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "publisher",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "publisherId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "publisher",
            "Non_unique": "1",
            "Key_name": "publisherName",
            "Seq_in_index": "1",
            "Column_name": "publisherName",
            "Collation": "A",
            "Sub_part": "100",
            "Index_type": "BTREE"
        },
        {
            "Table": "publisher",
            "Non_unique": "1",
            "Key_name": "publisherType",
            "Seq_in_index": "1",
            "Column_name": "publisherType",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_bibliography_resource",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "userbibliographyresourceId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_bibliography_resource",
            "Non_unique": "1",
            "Key_name": "userbibliographyresourceBibliographyId",
            "Seq_in_index": "1",
            "Column_name": "userbibliographyresourceBibliographyId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_bibliography_resource",
            "Non_unique": "1",
            "Key_name": "userbibliographyresourceResourceId",
            "Seq_in_index": "1",
            "Column_name": "userbibliographyresourceResourceId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "tag",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "tagId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "version",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "versionComponentType",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "version",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "2",
            "Column_name": "versionComponentId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "import_raw",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "importrawId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "session_browser_tab",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "sessionbrowsertabId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "session_browser_tab",
            "Non_unique": "1",
            "Key_name": "sessionbrowsertabUserId",
            "Seq_in_index": "1",
            "Column_name": "sessionbrowsertabUserId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "session_browser_tab",
            "Non_unique": "1",
            "Key_name": "sessionbrowsertabTimestamp",
            "Seq_in_index": "1",
            "Column_name": "sessionbrowsertabTimestamp",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "session",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "sessionId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "session",
            "Non_unique": "1",
            "Key_name": "sessionLastAccessTimestamp",
            "Seq_in_index": "1",
            "Column_name": "sessionLastAccessTimestamp",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "session",
            "Non_unique": "1",
            "Key_name": "sessionUserId",
            "Seq_in_index": "1",
            "Column_name": "sessionUserId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "config",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "configId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "config",
            "Non_unique": "1",
            "Key_name": "configName",
            "Seq_in_index": "1",
            "Column_name": "configName",
            "Collation": "A",
            "Sub_part": "100",
            "Index_type": "BTREE"
        },
        {
            "Table": "ideas_keyword",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "ideaskeywordId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "ideas_keyword",
            "Non_unique": "1",
            "Key_name": "ideaskeywordKeywordId",
            "Seq_in_index": "1",
            "Column_name": "ideaskeywordKeywordId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "ideas_keyword",
            "Non_unique": "1",
            "Key_name": "ideaskeywordIdeasId",
            "Seq_in_index": "1",
            "Column_name": "ideaskeywordIdeasId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "custom",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "customId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_metadata",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "resourcemetadataId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_metadata",
            "Non_unique": "1",
            "Key_name": "resourcemetadataAddUserId",
            "Seq_in_index": "1",
            "Column_name": "resourcemetadataAddUserId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_metadata",
            "Non_unique": "1",
            "Key_name": "resourcemetadataMetadataId",
            "Seq_in_index": "1",
            "Column_name": "resourcemetadataMetadataId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_metadata",
            "Non_unique": "1",
            "Key_name": "resourcemetadataPrivate",
            "Seq_in_index": "1",
            "Column_name": "resourcemetadataPrivate",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_metadata",
            "Non_unique": "1",
            "Key_name": "resourcemetadataResourceId",
            "Seq_in_index": "1",
            "Column_name": "resourcemetadataResourceId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_metadata",
            "Non_unique": "1",
            "Key_name": "resourcemetadataType",
            "Seq_in_index": "1",
            "Column_name": "resourcemetadataType",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_metadata",
            "Non_unique": "1",
            "Key_name": "resourcemetadataText",
            "Seq_in_index": "1",
            "Column_name": "resourcemetadataText",
            "Collation": null,
            "Sub_part": null,
            "Index_type": "FULLTEXT"
        },
        {
            "Table": "resource_category",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "resourcecategoryId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_category",
            "Non_unique": "1",
            "Key_name": "resourcecategoryCategoryId",
            "Seq_in_index": "1",
            "Column_name": "resourcecategoryCategoryId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_category",
            "Non_unique": "1",
            "Key_name": "resourcecategoryResourceId",
            "Seq_in_index": "1",
            "Column_name": "resourcecategoryResourceId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_category",
            "Non_unique": "1",
            "Key_name": "resourcecategorySubcategoryId",
            "Seq_in_index": "1",
            "Column_name": "resourcecategorySubcategoryId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "cache",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "cacheId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "cache",
            "Non_unique": "1",
            "Key_name": "cacheTimestamp",
            "Seq_in_index": "1",
            "Column_name": "cacheTimestamp",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "statistics_attachment_downloads",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "statisticsattachmentdownloadsId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "statistics_attachment_downloads",
            "Non_unique": "1",
            "Key_name": "statisticsattachmentdownloadsAttachmentId",
            "Seq_in_index": "1",
            "Column_name": "statisticsattachmentdownloadsAttachmentId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "statistics_attachment_downloads",
            "Non_unique": "1",
            "Key_name": "statisticsattachmentdownloadsResourceId",
            "Seq_in_index": "1",
            "Column_name": "statisticsattachmentdownloadsResourceId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_timestamp",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "resourcetimestampId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_timestamp",
            "Non_unique": "1",
            "Key_name": "resourcetimestampTimestamp",
            "Seq_in_index": "1",
            "Column_name": "resourcetimestampTimestamp",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_timestamp",
            "Non_unique": "1",
            "Key_name": "resourcetimestampTimestampAdd",
            "Seq_in_index": "1",
            "Column_name": "resourcetimestampTimestampAdd",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_custom",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "resourcecustomId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_custom",
            "Non_unique": "1",
            "Key_name": "resourcecustomCustomId",
            "Seq_in_index": "1",
            "Column_name": "resourcecustomCustomId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_custom",
            "Non_unique": "1",
            "Key_name": "resourcecustomResourceId",
            "Seq_in_index": "1",
            "Column_name": "resourcecustomResourceId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_custom",
            "Non_unique": "1",
            "Key_name": "resourcecustomText",
            "Seq_in_index": "1",
            "Column_name": "resourcecustomText",
            "Collation": null,
            "Sub_part": null,
            "Index_type": "FULLTEXT"
        },
        {
            "Table": "publication_list_bib",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "publicationlistbibListId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "publication_list_bib",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "2",
            "Column_name": "publicationlistbibBibId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_year",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "resourceyearId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_year",
            "Non_unique": "1",
            "Key_name": "resourceyearYear1",
            "Seq_in_index": "1",
            "Column_name": "resourceyearYear1",
            "Collation": "A",
            "Sub_part": "100",
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_year",
            "Non_unique": "1",
            "Key_name": "resourceyearYear2",
            "Seq_in_index": "1",
            "Column_name": "resourceyearYear2",
            "Collation": "A",
            "Sub_part": "100",
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_year",
            "Non_unique": "1",
            "Key_name": "resourceyearYear3",
            "Seq_in_index": "1",
            "Column_name": "resourceyearYear3",
            "Collation": "A",
            "Sub_part": "100",
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_year",
            "Non_unique": "1",
            "Key_name": "resourceyearYear4",
            "Seq_in_index": "1",
            "Column_name": "resourceyearYear4",
            "Collation": "A",
            "Sub_part": "100",
            "Index_type": "BTREE"
        },
        {
            "Table": "user_groups_users",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "usergroupsusersId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_groups_users",
            "Non_unique": "1",
            "Key_name": "usergroupsusersGroupId",
            "Seq_in_index": "1",
            "Column_name": "usergroupsusersGroupId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_groups_users",
            "Non_unique": "1",
            "Key_name": "usergroupsusersUserId",
            "Seq_in_index": "1",
            "Column_name": "usergroupsusersUserId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "ideas",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "ideasId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "ideas",
            "Non_unique": "1",
            "Key_name": "ideasIdeasId",
            "Seq_in_index": "1",
            "Column_name": "ideasIdeasId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "ideas",
            "Non_unique": "1",
            "Key_name": "ideasAddUserId",
            "Seq_in_index": "1",
            "Column_name": "ideasAddUserId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "ideas",
            "Non_unique": "1",
            "Key_name": "ideasPrivate",
            "Seq_in_index": "1",
            "Column_name": "ideasPrivate",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "ideas",
            "Non_unique": "1",
            "Key_name": "ideasText",
            "Seq_in_index": "1",
            "Column_name": "ideasText",
            "Collation": null,
            "Sub_part": null,
            "Index_type": "FULLTEXT"
        },
        {
            "Table": "search_abstractnotes",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "searchabstractnotesId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "search_abstractnotes",
            "Non_unique": "1",
            "Key_name": "searchabstractnotesResourceId",
            "Seq_in_index": "1",
            "Column_name": "searchabstractnotesResourceId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "search_abstractnotes",
            "Non_unique": "1",
            "Key_name": "searchabstractnotesText",
            "Seq_in_index": "1",
            "Column_name": "searchabstractnotesText",
            "Collation": null,
            "Sub_part": null,
            "Index_type": "FULLTEXT"
        },
        {
            "Table": "users_basket",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "usersbasketId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "users_basket",
            "Non_unique": "1",
            "Key_name": "usersbasketUserId",
            "Seq_in_index": "1",
            "Column_name": "usersbasketUserId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "users_bookmarks",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "usersbookmarksId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "users_bookmarks",
            "Non_unique": "1",
            "Key_name": "usersbookmarksUserId",
            "Seq_in_index": "1",
            "Column_name": "usersbookmarksUserId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_register",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "userregisterId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_register",
            "Non_unique": "1",
            "Key_name": "userregisterConfirmed",
            "Seq_in_index": "1",
            "Column_name": "userregisterConfirmed",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_register",
            "Non_unique": "1",
            "Key_name": "userregisterTimestamp",
            "Seq_in_index": "1",
            "Column_name": "userregisterTimestamp",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_bibliography",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "userbibliographyId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_bibliography",
            "Non_unique": "1",
            "Key_name": "userbibliographyTitle",
            "Seq_in_index": "1",
            "Column_name": "userbibliographyTitle",
            "Collation": "A",
            "Sub_part": "100",
            "Index_type": "BTREE"
        },
        {
            "Table": "user_bibliography",
            "Non_unique": "1",
            "Key_name": "userbibliographyUserGroupId",
            "Seq_in_index": "1",
            "Column_name": "userbibliographyUserGroupId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_bibliography",
            "Non_unique": "1",
            "Key_name": "userbibliographyUserId",
            "Seq_in_index": "1",
            "Column_name": "userbibliographyUserId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "statistics_resource_views",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "statisticsresourceviewsId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "statistics_resource_views",
            "Non_unique": "1",
            "Key_name": "statisticsresourceviewsResourceId",
            "Seq_in_index": "1",
            "Column_name": "statisticsresourceviewsResourceId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_keyword",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "resourcekeywordId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_keyword",
            "Non_unique": "1",
            "Key_name": "resourcekeywordKeywordId",
            "Seq_in_index": "1",
            "Column_name": "resourcekeywordKeywordId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_keyword",
            "Non_unique": "1",
            "Key_name": "resourcekeywordMetadataId",
            "Seq_in_index": "1",
            "Column_name": "resourcekeywordMetadataId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_keyword",
            "Non_unique": "1",
            "Key_name": "resourcekeywordResourceId",
            "Seq_in_index": "1",
            "Column_name": "resourcekeywordResourceId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_text",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "resourcetextId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_text",
            "Non_unique": "1",
            "Key_name": "resourcetextAddUserIdAbstract",
            "Seq_in_index": "1",
            "Column_name": "resourcetextAddUserIdAbstract",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_text",
            "Non_unique": "1",
            "Key_name": "resourcetextAddUserIdNote",
            "Seq_in_index": "1",
            "Column_name": "resourcetextAddUserIdNote",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_text",
            "Non_unique": "1",
            "Key_name": "resourcetextEditUserIdAbstract",
            "Seq_in_index": "1",
            "Column_name": "resourcetextEditUserIdAbstract",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_text",
            "Non_unique": "1",
            "Key_name": "resourcetextEditUserIdNote",
            "Seq_in_index": "1",
            "Column_name": "resourcetextEditUserIdNote",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_text",
            "Non_unique": "1",
            "Key_name": "resourcetextAbstract",
            "Seq_in_index": "1",
            "Column_name": "resourcetextAbstract",
            "Collation": null,
            "Sub_part": null,
            "Index_type": "FULLTEXT"
        },
        {
            "Table": "resource_text",
            "Non_unique": "1",
            "Key_name": "resourcetextNote",
            "Seq_in_index": "1",
            "Column_name": "resourcetextNote",
            "Collation": null,
            "Sub_part": null,
            "Index_type": "FULLTEXT"
        },
        {
            "Table": "creator",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "creatorId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "creator",
            "Non_unique": "1",
            "Key_name": "creatorSameAs",
            "Seq_in_index": "1",
            "Column_name": "creatorSameAs",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "creator",
            "Non_unique": "1",
            "Key_name": "creatorSurname",
            "Seq_in_index": "1",
            "Column_name": "creatorSurname",
            "Collation": "A",
            "Sub_part": "100",
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_attachments",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "resourceattachmentsId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_attachments",
            "Non_unique": "1",
            "Key_name": "resourceattachmentsEmbargo",
            "Seq_in_index": "1",
            "Column_name": "resourceattachmentsEmbargo",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_attachments",
            "Non_unique": "1",
            "Key_name": "resourceattachmentsEmbargoUntil",
            "Seq_in_index": "1",
            "Column_name": "resourceattachmentsEmbargoUntil",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_attachments",
            "Non_unique": "1",
            "Key_name": "resourceattachmentsHashFilename",
            "Seq_in_index": "1",
            "Column_name": "resourceattachmentsHashFilename",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_attachments",
            "Non_unique": "1",
            "Key_name": "resourceattachmentsPrimary",
            "Seq_in_index": "1",
            "Column_name": "resourceattachmentsPrimary",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_attachments",
            "Non_unique": "1",
            "Key_name": "resourceattachmentsResourceId",
            "Seq_in_index": "1",
            "Column_name": "resourceattachmentsResourceId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_attachments",
            "Non_unique": "1",
            "Key_name": "resourceattachmentsTimestamp",
            "Seq_in_index": "1",
            "Column_name": "resourceattachmentsTimestamp",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_attachments",
            "Non_unique": "1",
            "Key_name": "resourceattachmentsText",
            "Seq_in_index": "1",
            "Column_name": "resourceattachmentsText",
            "Collation": null,
            "Sub_part": null,
            "Index_type": "FULLTEXT"
        },
        {
            "Table": "collection",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "collectionId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "collection",
            "Non_unique": "1",
            "Key_name": "collectionTitle",
            "Seq_in_index": "1",
            "Column_name": "collectionTitle",
            "Collation": "A",
            "Sub_part": "100",
            "Index_type": "BTREE"
        },
        {
            "Table": "collection",
            "Non_unique": "1",
            "Key_name": "collectionType",
            "Seq_in_index": "1",
            "Column_name": "collectionType",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "search_resources",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "searchresourcesId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "search_resources",
            "Non_unique": "1",
            "Key_name": "searchresourcesResourceId",
            "Seq_in_index": "1",
            "Column_name": "searchresourcesResourceId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "search_resources",
            "Non_unique": "1",
            "Key_name": "searchresourcesText",
            "Seq_in_index": "1",
            "Column_name": "searchresourcesText",
            "Collation": "A",
            "Sub_part": "768",
            "Index_type": "BTREE"
        },
        {
            "Table": "category",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "categoryId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "category",
            "Non_unique": "1",
            "Key_name": "categoryCategory",
            "Seq_in_index": "1",
            "Column_name": "categoryCategory",
            "Collation": "A",
            "Sub_part": "768",
            "Index_type": "BTREE"
        },
        {
            "Table": "keyword",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "keywordId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "keyword",
            "Non_unique": "1",
            "Key_name": "keywordKeyword",
            "Seq_in_index": "1",
            "Column_name": "keywordKeyword",
            "Collation": "A",
            "Sub_part": "768",
            "Index_type": "BTREE"
        },
        {
            "Table": "publication_list",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "publicationlistId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "publication_list",
            "Non_unique": "1",
            "Key_name": "publicationlistTitle",
            "Seq_in_index": "1",
            "Column_name": "publicationlistTitle",
            "Collation": "A",
            "Sub_part": "100",
            "Index_type": "BTREE"
        },
        {
            "Table": "users",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "usersId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "users",
            "Non_unique": "0",
            "Key_name": "usersUsernameUnique",
            "Seq_in_index": "1",
            "Column_name": "usersUsername",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "users",
            "Non_unique": "1",
            "Key_name": "usersBlock",
            "Seq_in_index": "1",
            "Column_name": "usersBlock",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_kg_usergroups",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "userkgusergroupsId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_kg_usergroups",
            "Non_unique": "1",
            "Key_name": "userkgusergroupsKeywordGroupId",
            "Seq_in_index": "1",
            "Column_name": "userkgusergroupsKeywordGroupId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_kg_usergroups",
            "Non_unique": "1",
            "Key_name": "userkgusergroupsUserGroupId",
            "Seq_in_index": "1",
            "Column_name": "userkgusergroupsUserGroupId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_user_tags",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "resourceusertagsId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_user_tags",
            "Non_unique": "1",
            "Key_name": "resourceusertagsResourceId",
            "Seq_in_index": "1",
            "Column_name": "resourceusertagsResourceId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "resource_user_tags",
            "Non_unique": "1",
            "Key_name": "resourceusertagsTagId",
            "Seq_in_index": "1",
            "Column_name": "resourceusertagsTagId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_kg_keywords",
            "Non_unique": "0",
            "Key_name": "PRIMARY",
            "Seq_in_index": "1",
            "Column_name": "userkgkeywordsId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_kg_keywords",
            "Non_unique": "1",
            "Key_name": "userkgkeywordsKeywordGroupId",
            "Seq_in_index": "1",
            "Column_name": "userkgkeywordsKeywordGroupId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        },
        {
            "Table": "user_kg_keywords",
            "Non_unique": "1",
            "Key_name": "userkgkeywordsKeywordId",
            "Seq_in_index": "1",
            "Column_name": "userkgkeywordsKeywordId",
            "Collation": "A",
            "Sub_part": null,
            "Index_type": "BTREE"
        }
    ]
}