{"table_name":"bearmor_user_profiles","full_table_name":"wp_bearmor_user_profiles","description":"Stores bearmor user profiles data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_bearmor_user_profiles ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, user_id BIGINT UNSIGNED NOT NULL, known_ips TEXT, known_countries TEXT, known_user_agents TEXT, typical_login_hours VARCHAR(255), last_login_at DATETIME, last_login_ip VARCHAR(45), last_login_country VARCHAR(2), profile_created DATETIME NOT NULL, profile_updated DATETIME NOT NULL, UNIQUE KEY user_id (user_id), KEY user_id_index (user_id) ) $charset_collate;\"; dbDelta( $sql );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":true},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"known_ips","type":"TEXT","nullable":true,"primary_key":false},{"name":"known_countries","type":"TEXT","nullable":true,"primary_key":false},{"name":"known_user_agents","type":"TEXT","nullable":true,"primary_key":false},{"name":"typical_login_hours","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"last_login_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"last_login_ip","type":"VARCHAR(45)","nullable":true,"primary_key":false},{"name":"last_login_country","type":"VARCHAR(2)","nullable":true,"primary_key":false},{"name":"profile_created","type":"DATETIME","nullable":false,"primary_key":false},{"name":"profile_updated","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"bearmor-security","name":"Bearmor Security","active_installs":50,"version":"1.0.4","wp_org_url":"https://wordpress.org/plugins/bearmor-security/"}}