{"slug":"better-payment","name":"Better Payment – Instant Payments, Donations, Fundraising with Subscriptions & More","description":"Accept payments, donations and subscriptions, run fundraising campaigns and sell products on your Elementor and Gutenberg website.","author":"WPDeveloper","active_installs":5000,"version":"2.4.2","wp_org_url":"https://wordpress.org/plugins/better-payment/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"better_payment","full_table_name":"wp_better_payment","description":"Stores better payment data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"order_id","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"transaction_id","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"source","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"payment_date","type":"datetime","nullable":true,"primary_key":false},{"name":"email","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"customer_info","type":"longtext","nullable":true,"primary_key":false},{"name":"form_fields_info","type":"longtext","nullable":true,"primary_key":false},{"name":"currency","type":"varchar(11)","nullable":false,"primary_key":false},{"name":"referer","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"obj_id","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_better_payment( id bigint(20) NOT NULL AUTO_INCREMENT, order_id varchar(50) NOT NULL, transaction_id varchar(50) DEFAULT '', amount decimal(10,2) NOT NULL, status varchar(50) DEFAULT NULL, source varchar(50) NOT NULL, payment_date datetime DEFAULT NULL, email varchar(50) NOT NULL DEFAULT '', customer_info longtext, form_fields_info longtext, currency varchar(11) NOT NULL DEFAULT '', referer varchar(64) DEFAULT NULL, obj_id text, PRIMARY KEY (id), KEY order_id (order_id), KEY status (status) ) ENGINE"},{"table_name":"better_payment_subscription_order","full_table_name":"wp_better_payment_subscription_order","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"subscription_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"order_item_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"source","type":"varchar(50)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_better_payment_subscription_order( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, subscription_id bigint(20) unsigned NOT NULL, order_id bigint(20) unsigned NOT NULL, order_item_id bigint(20) unsigned NOT NULL DEFAULT 0, type varchar(20) NOT NULL DEFAULT 'new', source varchar(50) NOT NULL, PRIMARY KEY (id), KEY subscription_id (subscription_id), KEY order_id (order_id), KEY source (source) ) ENGINE"}],"table_count":2}