{"slug":"checkoutguard","name":"CheckoutGuard","description":"Track incomplete WooCommerce checkouts, recover lost sales, block fraudulent orders, analyze courier success rates, and manage order statuses.","author":"Coder Zone BD","active_installs":90,"version":"1.2.1","wp_org_url":"https://wordpress.org/plugins/checkoutguard/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"cg_blocked_addresses","full_table_name":"wp_cg_blocked_addresses","description":"Stores cg blocked addresses data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20)","nullable":false,"primary_key":true},{"name":"address_hash","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"address_text","type":"TEXT","nullable":false,"primary_key":false},{"name":"added_by","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"reason","type":"TEXT","nullable":true,"primary_key":false},{"name":"expires_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"auto_blocked","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_cg_blocked_addresses ( id BIGINT(20) NOT NULL AUTO_INCREMENT, address_hash VARCHAR(64) NOT NULL, address_text TEXT NOT NULL, added_by BIGINT(20) UNSIGNED DEFAULT NULL, reason TEXT DEFAULT NULL, expires_at DATETIME DEFAULT NULL, auto_blocked TINYINT(1) DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY address_hash (address_hash) ) $charset_collate;\"; dbDelta($sql);"},{"table_name":"cg_blocked_devices","full_table_name":"wp_cg_blocked_devices","description":"Stores cg blocked devices data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20)","nullable":false,"primary_key":true},{"name":"device_fingerprint","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"device_info","type":"TEXT","nullable":true,"primary_key":false},{"name":"added_by","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"reason","type":"TEXT","nullable":true,"primary_key":false},{"name":"expires_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"auto_blocked","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_cg_blocked_devices ( id BIGINT(20) NOT NULL AUTO_INCREMENT, device_fingerprint VARCHAR(64) NOT NULL, device_info TEXT DEFAULT NULL, added_by BIGINT(20) UNSIGNED DEFAULT NULL, reason TEXT DEFAULT NULL, expires_at DATETIME DEFAULT NULL, auto_blocked TINYINT(1) DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY device_fingerprint (device_fingerprint) ) $charset_collate;\"; dbDelta($sql);"},{"table_name":"cg_blocked_domains","full_table_name":"wp_cg_blocked_domains","description":"Stores cg blocked domains data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20)","nullable":false,"primary_key":true},{"name":"domain","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"added_by","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"reason","type":"TEXT","nullable":true,"primary_key":false},{"name":"expires_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"auto_blocked","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_cg_blocked_domains ( id BIGINT(20) NOT NULL AUTO_INCREMENT, domain VARCHAR(255) NOT NULL, added_by BIGINT(20) UNSIGNED DEFAULT NULL, reason TEXT DEFAULT NULL, expires_at DATETIME DEFAULT NULL, auto_blocked TINYINT(1) DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY domain (domain) ) $charset_collate;\"; dbDelta($sql);"},{"table_name":"cg_blocked_emails","full_table_name":"wp_cg_blocked_emails","description":"Stores cg blocked emails data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"cg_blocked_ips","full_table_name":"wp_cg_blocked_ips","description":"Stores cg blocked ips data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"cg_blocked_numbers","full_table_name":"wp_cg_blocked_numbers","description":"Stores cg blocked numbers data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"cg_blocked_orders","full_table_name":"wp_cg_blocked_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"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","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}],"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);"},{"table_name":"cg_incomplete_checkouts","full_table_name":"wp_cg_incomplete_checkouts","description":"Stores cg incomplete checkouts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":9}