wp_better_payment_subscription_order

Static

Stores order records and related transaction data.

Column Definitions

Column	Type	Nullable
🔑id	bigint(20) unsigned	NO
subscription_id	bigint(20) unsigned	NO
order_id	bigint(20) unsigned	NO
order_item_id	bigint(20) unsigned	NO
type	varchar(20)	NO
source	varchar(50)	NO

CREATE TABLE Statement

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

Safe to delete?

If you have uninstalled Better Payment – Instant Payments, Donations, Fundraising with Subscriptions & More, this table is generally safe to remove. However, always back up your database first.

Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.

How to remove this table

DROP TABLE IF EXISTS `wp_better_payment_subscription_order`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Better Payment – Instant Payments, Donations, Fundraising with Subscriptions & More

wp_better_payment