{"slug":"smobilplay-edd-gateway","name":"SmobilPay for e-commerce Gateway for Easy Digital Downloads","description":"SmobilPay Easy Digital Downloads is a secure and seamless plugin to receive and manage Cash, Mobile, and Card payments in Cameroon on your e-shop or w …","author":"smobilpay","active_installs":10,"version":"1.0.2","wp_org_url":"https://wordpress.org/plugins/smobilplay-edd-gateway/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"edd_enkap_payments","full_table_name":"wp_edd_enkap_payments","description":"Stores edd enkap payments data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"enkap_payments","full_table_name":"wp_enkap_payments","description":"Stores enkap payments data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int unsigned","nullable":false,"primary_key":true},{"name":"currency","type":"varchar(5)","nullable":true,"primary_key":false},{"name":"country_code","type":"varchar(3)","nullable":true,"primary_key":false},{"name":"customer_name","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"description","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(128)","nullable":true,"primary_key":false},{"name":"client_ip","type":"varbinary(64)","nullable":false,"primary_key":false},{"name":"user_id","type":"int","nullable":false,"primary_key":false},{"name":"items","type":"json","nullable":true,"primary_key":false},{"name":"merchant_reference_id","type":"char(36)","nullable":false,"primary_key":false},{"name":"order_transaction_id","type":"varchar(128)","nullable":true,"primary_key":false},{"name":"opt_ref_one","type":"text","nullable":true,"primary_key":false},{"name":"opt_ref_two","type":"text","nullable":true,"primary_key":false},{"name":"expiry_date","type":"datetime","nullable":false,"primary_key":false},{"name":"order_date","type":"datetime","nullable":false,"primary_key":false},{"name":"phone_number","type":"int","nullable":false,"primary_key":false},{"name":"total_amount","type":"decimal(32, 2)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"status_date","type":"datetime","nullable":false,"primary_key":false},{"name":"created_at","type":"timestamp","nullable":false,"primary_key":false},{"name":"updated_at","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `enkap_payments` ( id int unsigned NOT NULL AUTO_INCREMENT, currency varchar(5) default 'XAF', country_code varchar(3) default 'CM', customer_name varchar(200) DEFAULT NULL, description varchar(200) DEFAULT NULL, email varchar(128) DEFAULT NULL, client_ip varbinary(64) NOT NULL DEFAULT '0.0.0.0', user_id int NOT NULL DEFAULT '0', items json, merchant_reference_id char(36) NOT NULL DEFAULT '', order_transaction_id varchar(128) DEFAULT NULL, opt_ref_one text, opt_ref_two text, expiry_date datetime NOT NULL DEFAULT '2021-05-20 00:00:00', order_date datetime NOT NULL DEFAULT '2021-05-20 00:00:00', phone_number int NOT NULL DEFAULT '0', total_amount decimal(32, 2) DEFAULT '0.00', status varchar(50) DEFAULT NULL, status_date datetime NOT NULL DEFAULT '2021-05-20 00:00:00', created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY index_user_id (user_id), UNIQUE KEY index_merchant_reference_id (merchant_reference_id), UNIQUE KEY index_order_transaction_id (order_transaction_id) ) ENGINE"}],"table_count":2}