{"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 Solutions","active_installs":0,"version":"1.14.6","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 UNSIGNED","nullable":true,"primary_key":true},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_dango_coh_clusters (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, created_at DATETIME NOT NULL) $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 UNSIGNED","nullable":true,"primary_key":true},{"name":"itype","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"ivalue","type":"VARCHAR(120)","nullable":false,"primary_key":false},{"name":"cluster_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_dango_coh_identities (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, itype TINYINT UNSIGNED NOT NULL, ivalue VARCHAR(120) NOT NULL, cluster_id BIGINT UNSIGNED NOT NULL, 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 UNSIGNED","nullable":true,"primary_key":true},{"name":"cluster_id","type":"BIGINT 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 UNSIGNED PRIMARY KEY, cluster_id BIGINT UNSIGNED NOT NULL, status VARCHAR(30) NOT NULL DEFAULT '', total DECIMAL(15,2) NOT NULL DEFAULT 0, 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 UNSIGNED","nullable":true,"primary_key":true},{"name":"total_orders","type":"SMALLINT UNSIGNED","nullable":true,"primary_key":false},{"name":"revenue_orders","type":"SMALLINT UNSIGNED","nullable":true,"primary_key":false},{"name":"total_spent","type":"DECIMAL(15,2)","nullable":true,"primary_key":false},{"name":"processing","type":"SMALLINT UNSIGNED","nullable":true,"primary_key":false},{"name":"on_hold","type":"SMALLINT UNSIGNED","nullable":true,"primary_key":false},{"name":"cancelled","type":"SMALLINT UNSIGNED","nullable":true,"primary_key":false},{"name":"failed","type":"SMALLINT UNSIGNED","nullable":true,"primary_key":false},{"name":"refunded","type":"SMALLINT UNSIGNED","nullable":true,"primary_key":false},{"name":"returned","type":"SMALLINT UNSIGNED","nullable":true,"primary_key":false},{"name":"other_count","type":"SMALLINT 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 UNSIGNED PRIMARY KEY, total_orders SMALLINT UNSIGNED DEFAULT 0, revenue_orders SMALLINT UNSIGNED DEFAULT 0, total_spent DECIMAL(15,2) DEFAULT 0, processing SMALLINT UNSIGNED DEFAULT 0, on_hold SMALLINT UNSIGNED DEFAULT 0, cancelled SMALLINT UNSIGNED DEFAULT 0, failed SMALLINT UNSIGNED DEFAULT 0, refunded SMALLINT UNSIGNED DEFAULT 0, returned SMALLINT UNSIGNED DEFAULT 0, other_count SMALLINT UNSIGNED DEFAULT 0, updated_at DATETIME) $cc;\");"}],"table_count":4}