{"slug":"safeship-pk","name":"SafeShip Pakistan","description":"Stop dispatching COD orders blind — check every customer against Pakistan's shared fraud database before you ship.","author":"DANGO","active_installs":0,"version":"1.14.19","wp_org_url":"https://wordpress.org/plugins/safeship-pk/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"dango_coh_clusters","full_table_name":"wp_dango_coh_clusters","description":"Stores dango coh clusters data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_dango_coh_clusters ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, created_at datetime NOT NULL, PRIMARY KEY (id) ) $cc;\");"},{"table_name":"dango_coh_identities","full_table_name":"wp_dango_coh_identities","description":"Stores dango coh identities data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"itype","type":"tinyint(3) unsigned","nullable":false,"primary_key":false},{"name":"ivalue","type":"varchar(120)","nullable":false,"primary_key":false},{"name":"cluster_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_dango_coh_identities ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, itype tinyint(3) unsigned NOT NULL, ivalue varchar(120) NOT NULL, cluster_id bigint(20) unsigned NOT NULL, PRIMARY KEY (id), UNIQUE KEY uq_id (itype,ivalue), KEY k_cluster (cluster_id) ) $cc;\");"},{"table_name":"dango_coh_orders","full_table_name":"wp_dango_coh_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[{"name":"order_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"cluster_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"status","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"total","type":"decimal(15,2)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_dango_coh_orders ( order_id bigint(20) unsigned NOT NULL, cluster_id bigint(20) unsigned NOT NULL, status varchar(30) NOT NULL DEFAULT '', total decimal(15,2) NOT NULL DEFAULT 0, PRIMARY KEY (order_id), KEY k_cluster (cluster_id) ) $cc;\");"},{"table_name":"dango_coh_stats","full_table_name":"wp_dango_coh_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[{"name":"cluster_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"total_orders","type":"smallint(5) unsigned","nullable":true,"primary_key":false},{"name":"revenue_orders","type":"smallint(5) unsigned","nullable":true,"primary_key":false},{"name":"total_spent","type":"decimal(15,2)","nullable":true,"primary_key":false},{"name":"processing","type":"smallint(5) unsigned","nullable":true,"primary_key":false},{"name":"on_hold","type":"smallint(5) unsigned","nullable":true,"primary_key":false},{"name":"cancelled","type":"smallint(5) unsigned","nullable":true,"primary_key":false},{"name":"failed","type":"smallint(5) unsigned","nullable":true,"primary_key":false},{"name":"refunded","type":"smallint(5) unsigned","nullable":true,"primary_key":false},{"name":"returned","type":"smallint(5) unsigned","nullable":true,"primary_key":false},{"name":"other_count","type":"smallint(5) unsigned","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_dango_coh_stats ( cluster_id bigint(20) unsigned NOT NULL, total_orders smallint(5) unsigned DEFAULT 0, revenue_orders smallint(5) unsigned DEFAULT 0, total_spent decimal(15,2) DEFAULT 0, processing smallint(5) unsigned DEFAULT 0, on_hold smallint(5) unsigned DEFAULT 0, cancelled smallint(5) unsigned DEFAULT 0, failed smallint(5) unsigned DEFAULT 0, refunded smallint(5) unsigned DEFAULT 0, returned smallint(5) unsigned DEFAULT 0, other_count smallint(5) unsigned DEFAULT 0, updated_at datetime DEFAULT NULL, PRIMARY KEY (cluster_id) ) $cc;\");"}],"table_count":4}