{"table_name":"skrill_transaction_log","full_table_name":"wp_skrill_transaction_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS wp_skrill_transaction_log ( `id` int(20) unsigned NOT NULL AUTO_INCREMENT, `order_id` bigint(20) unsigned NOT NULL, `transaction_id` varchar(100), `mb_transaction_id` varchar(50) NOT NULL, `payment_method_id` varchar(30), `payment_type` varchar(16) NOT NULL, `payment_status` varchar(30), `amount` decimal(17,2) NOT NULL, `refunded_amount` decimal(17,2) DEFAULT '0', `currency` char(3) NOT NULL, `customer_id` int(11) unsigned DEFAULT NULL, `date` datetime NOT NULL, `additional_information` LONGTEXT NULL, `payment_response` LONGTEXT NULL, `active` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) $charset_collate;\"; dbDelta( $transaction_sql );","columns":[{"name":"id","type":"int(20) unsigned","nullable":false,"primary_key":true},{"name":"order_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"transaction_id","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"mb_transaction_id","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"payment_method_id","type":"varchar(30)","nullable":true,"primary_key":false},{"name":"payment_type","type":"varchar(16)","nullable":false,"primary_key":false},{"name":"payment_status","type":"varchar(30)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(17,2)","nullable":false,"primary_key":false},{"name":"refunded_amount","type":"decimal(17,2)","nullable":true,"primary_key":false},{"name":"currency","type":"char(3)","nullable":false,"primary_key":false},{"name":"customer_id","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"date","type":"datetime","nullable":false,"primary_key":false},{"name":"additional_information","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"payment_response","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"active","type":"tinyint(1) unsigned","nullable":false,"primary_key":false}],"plugin":{"slug":"official-skrill-woocommerce","name":"Skrill – WooCommerce","active_installs":400,"version":"1.0.73","wp_org_url":"https://wordpress.org/plugins/official-skrill-woocommerce/"}}