wp_dwdpm_orders
StaticStores order records and related transaction data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| order_key | varchar(64) | NO |
| user_id | bigint(20) unsigned | NO |
| varchar(190) | NO | |
| status | varchar(30) | NO |
| currency | varchar(10) | NO |
| subtotal | decimal(12,2) | NO |
| discount_code | varchar(80) | NO |
| discount_amount | decimal(12,2) | NO |
| total | decimal(12,2) | NO |
| payment_provider | varchar(30) | NO |
| payment_reference | varchar(190) | NO |
| fulfilled_at | datetime | YES |
| created_at | datetime | NO |
| updated_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_dwdpm_orders ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, order_key varchar(64) NOT NULL, user_id bigint(20) unsigned NOT NULL DEFAULT 0, email varchar(190) NOT NULL DEFAULT '', status varchar(30) NOT NULL DEFAULT 'pending', currency varchar(10) NOT NULL DEFAULT 'AUD', subtotal decimal(12,2) NOT NULL DEFAULT 0.00, discount_code varchar(80) NOT NULL DEFAULT '', discount_amount decimal(12,2) NOT NULL DEFAULT 0.00, total decimal(12,2) NOT NULL DEFAULT 0.00, payment_provider varchar(30) NOT NULL DEFAULT '', payment_reference varchar(190) NOT NULL DEFAULT '', fulfilled_at datetime NULL, created_at datetime NOT NULL, updated_at datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY order_key (order_key), KEY user_id (user_id), KEY email (email), KEY status (status) ) $c;");
Safe to delete?
If you have uninstalled Delicious Digital Product Manager, 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_dwdpm_orders`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Delicious Digital Product Manager