wp_dpd_barcodes
StaticStores dpd barcodes data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| order_id | BIGINT UNSIGNED | NO |
| dpd_barcode | varchar(50) | NO |
| LONGTEXT | NO | |
| date | DATE | NO |
| parcelshop_id | varchar(20) | NO |
| company | varchar(40) | NO |
| country | varchar(2) | NO |
| city | varchar(40) | NO |
| pcode | varchar(7) | NO |
| street | varchar(40) | NO |
| varchar(30) | YES | |
| phone | varchar(30) | YES |
| mon | text | NO |
| tue | text | NO |
| wed | text | NO |
| thu | text | NO |
| fri | text | NO |
| sat | text | NO |
| sun | text | NO |
| distance | int(30) | NO |
| longitude | float | YES |
| latitude | float | YES |
| cod | tinyint(1) | NO |
| status | int | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_dpd_barcodes ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, order_id BIGINT UNSIGNED NOT NULL, dpd_barcode varchar(50) NOT NULL, PRIMARY KEY (id), KEY (order_id), UNIQUE KEY dpd_barcode (dpd_barcode) ) $collate; "; $tables[] = " CREATE TABLE IF NOT EXISTS wp_dpd_manifests ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, pdf LONGTEXT NOT NULL, date DATE NOT NULL, PRIMARY KEY (id), KEY (date) ) $collate; "; $tables[] = " CREATE TABLE IF NOT EXISTS wp_dpd_terminals ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, parcelshop_id varchar(20) NOT NULL DEFAULT '', company varchar(40) NOT NULL DEFAULT '', country varchar(2) NOT NULL DEFAULT '', city varchar(40) NOT NULL DEFAULT '', pcode varchar(7) NOT NULL DEFAULT '', street varchar(40) NOT NULL DEFAULT '', email varchar(30) NULL, phone varchar(30) NULL, mon text NOT NULL, tue text NOT NULL, wed text NOT NULL, thu text NOT NULL, fri text NOT NULL, sat text NOT NULL, sun text NOT NULL, distance int(30) NOT NULL DEFAULT 0, longitude float NULL, latitude float NULL, cod tinyint(1) NOT NULL DEFAULT 0, status int NOT NULL DEFAULT 1, PRIMARY KEY (id), UNIQUE KEY parcelshop_id (parcelshop_id) ) $collate; "; foreach ( $tables as $table ) { dbDelta( $table );Safe to delete?
If you have uninstalled DPD Baltic Shipping, 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_dpd_barcodes`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from DPD Baltic Shipping