{"table_name":"ceovw_logs","full_table_name":"wp_ceovw_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_ceovw_logs ( id mediumint(9) NOT NULL AUTO_INCREMENT, user_id bigint(20) NOT NULL DEFAULT 0, email varchar(100) NOT NULL, ip_address varchar(50) NOT NULL, action_type varchar(20) NOT NULL, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id) ) $charset_collate;\"; $sql2 = \"CREATE TABLE wp_ceovw_otps ( id mediumint(9) NOT NULL AUTO_INCREMENT, email varchar(100) NOT NULL, otp varchar(10) NOT NULL, flow varchar(20) NOT NULL, payload text, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id) ) $charset_collate;\"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );","columns":[{"name":"id","type":"mediumint(9)","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"ip_address","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"action_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"email","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"otp","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"flow","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"payload","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"plugin":{"slug":"naimur-email-otp-for-woocommerce","name":"Naimur Email OTP Verification for WooCommerce","active_installs":20,"version":"2.1.0","wp_org_url":"https://wordpress.org/plugins/naimur-email-otp-for-woocommerce/"}}