{"table_name":"cg_checkout_attempts","full_table_name":"wp_cg_checkout_attempts","description":"Stores cg checkout attempts data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_cg_checkout_attempts ( id BIGINT(20) NOT NULL AUTO_INCREMENT, ip_address VARCHAR(45) DEFAULT '', email VARCHAR(100) DEFAULT '', phone VARCHAR(30) DEFAULT '', device_fingerprint VARCHAR(64) DEFAULT '', address_hash VARCHAR(64) DEFAULT '', attempt_result VARCHAR(30) NOT NULL DEFAULT 'allowed', block_reason TEXT DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_ip_time (ip_address, created_at), KEY idx_phone_time (phone, created_at), KEY idx_email_time (email, created_at), KEY idx_device_time (device_fingerprint, created_at) ) $charset_collate;\"; dbDelta($sql);","columns":[{"name":"id","type":"BIGINT(20)","nullable":false,"primary_key":true},{"name":"ip_address","type":"VARCHAR(45)","nullable":true,"primary_key":false},{"name":"email","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"phone","type":"VARCHAR(30)","nullable":true,"primary_key":false},{"name":"device_fingerprint","type":"VARCHAR(64)","nullable":true,"primary_key":false},{"name":"address_hash","type":"VARCHAR(64)","nullable":true,"primary_key":false},{"name":"attempt_result","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"block_reason","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false}],"plugin":{"slug":"checkoutguard","name":"CheckoutGuard","active_installs":90,"version":"1.2.1","wp_org_url":"https://wordpress.org/plugins/checkoutguard/"}}