{"table_name":"kc_ml_audit_log","full_table_name":"wp_kc_ml_audit_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE `wp_kc_ml_audit_log` ( id bigint(20) NOT NULL AUTO_INCREMENT, event_type varchar(32) NOT NULL, user_id bigint(20) NOT NULL DEFAULT 0, link_id bigint(20) NOT NULL DEFAULT 0, email varchar(190) DEFAULT '', ip_address varchar(45) DEFAULT '', user_agent varchar(255) DEFAULT '', country varchar(8) DEFAULT '', meta_json longtext, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY event_type (event_type), KEY user_id (user_id), KEY created_at (created_at), KEY email (email) ) $collate; \"; } /** * @param string $collate * * @return string * * @since 1.1.0 * */ public static function get_110_schema( $collate = '' ) { global $wpdb; $tables = \" CREATE TABLE `wp_kc_ml_magic_links` ( id bigint(20) NOT NULL AUTO_INCREMENT, user_id bigint(20) NOT NULL, token varchar(64) NOT NULL, expires datetime NOT NULL, used tinyint(1) DEFAULT 0, ip_address varchar(45), created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY token (token), KEY user_id (user_id), KEY expires (expires) ) $collate; \"; return $tables; } /** * Get files to create * * @return array[] * * @since 1.1.0 */ public static function get_files() { // If we need to create more files/ dirs in the future // use following code return array_merge( [], self::get_110_files() );","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"event_type","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"link_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(190)","nullable":true,"primary_key":false},{"name":"ip_address","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"user_agent","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"country","type":"varchar(8)","nullable":true,"primary_key":false},{"name":"meta_json","type":"longtext","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"token","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"expires","type":"datetime","nullable":false,"primary_key":false},{"name":"used","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"ip_address","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"magic-link","name":"Magic Link – Secure one click passwordless login","active_installs":10,"version":"1.5.0","wp_org_url":"https://wordpress.org/plugins/magic-link/"}}