{"table_name":"tlwp_activity_logs","full_table_name":"wp_tlwp_activity_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE `wp_tlwp_activity_logs` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `alert_id` BIGINT(20) DEFAULT NULL, `object` VARCHAR(255) NOT NULL, `action` VARCHAR(255) NOT NULL, `user_roles` VARCHAR(255) NOT NULL, `username` VARCHAR(255) NULL, `user_id` BIGINT(20) NULL, `post_status` VARCHAR(255) NOT NULL, `post_type` VARCHAR(255) NOT NULL, `post_id` BIGINT(20) NOT NULL, `created_on` DOUBLE NOT NULL, `client_ip` VARCHAR(255) NOT NULL, `user_agent` VARCHAR(255) NOT NULL, PRIMARY KEY (id) ) $collate; CREATE TABLE `wp_tlwp_activity_logs_meta` ( `meta_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `activity_log_id` BIGINT(20) UNSIGNED NOT NULL, `meta_key` VARCHAR(255) DEFAULT NULL, `meta_value` LONGTEXT DEFAULT NULL, PRIMARY KEY (meta_id), KEY activity_log_id (activity_log_id), KEY meta_key (meta_key) ) $collate; \"; return $tables; } public static function get_tlwp_193_schema( $collate = '' ) { global $wpdb; $tables = \" CREATE TABLE wp_tlwp_user_temp_import ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `data` longtext NOT NULL, `identifier` char(13) NOT NULL, PRIMARY KEY (ID) ) $collate; \"; return $tables; } /** * Collect multiple version schema * * @param string $collate * * @return string * * @since 4.2.0 */ private static function get_schema( $collate = '' ) { $tables = self::get_tlwp_192_schema( $collate );","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"alert_id","type":"BIGINT(20)","nullable":true,"primary_key":false},{"name":"object","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"action","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"user_roles","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"username","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"user_id","type":"BIGINT(20)","nullable":true,"primary_key":false},{"name":"post_status","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"post_type","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"post_id","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"created_on","type":"DOUBLE","nullable":false,"primary_key":false},{"name":"client_ip","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"user_agent","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"activity_log_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"meta_key","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"data","type":"longtext","nullable":false,"primary_key":false},{"name":"identifier","type":"char(13)","nullable":false,"primary_key":false}],"plugin":{"slug":"temporary-login-without-password","name":"Temporary Login Without Password","active_installs":100000,"version":"1.9.7","wp_org_url":"https://wordpress.org/plugins/temporary-login-without-password/"}}