wp_epaka_carrier_group
StaticStores epaka carrier group data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) | NO |
| name | VARCHAR(255) | NO |
| color | VARCHAR(7) | NO |
| created_at | DATETIME | NO |
| zone_method_id | int(11) | NO |
| zone_id | int(11) | NO |
| shipment_type | int(11) | NO |
| parcel_type | int(11) | NO |
| sender_country_id | VARCHAR(10) | NO |
| receiver_country_id | VARCHAR(10) | NO |
| additional_options | TEXT | YES |
| epaka_curier_id | int(11) | NO |
| epaka_courier_name | VARCHAR(255) | NO |
| max_width | DECIMAL(10,2) | YES |
| max_height | DECIMAL(10,2) | YES |
| max_length | DECIMAL(10,2) | YES |
| max_weight | DECIMAL(10,2) | YES |
| updated_at | DATETIME | NO |
| created_at | DATETIME | NO |
| is_point | TINYINT(1) | NO |
| is_deleted | TINYINT(1) | NO |
| group_id | int(11) | YES |
| carrier_id | int(11) | NO |
| company_name | VARCHAR(255) | NO |
| first_name | VARCHAR(255) | NO |
| last_name | VARCHAR(255) | NO |
| country | VARCHAR(255) | NO |
| street | VARCHAR(255) | NO |
| house_number | VARCHAR(50) | NO |
| postal_code | VARCHAR(20) | NO |
| city | VARCHAR(255) | NO |
| phone | VARCHAR(50) | NO |
| VARCHAR(255) | NO | |
| created_at | DATETIME | NO |
| access_token | TEXT | NO |
| expires_at | DATETIME | NO |
| refresh_token | TEXT | NO |
| client_id | TEXT | NO |
| client_secret | TEXT | NO |
| created_at | DATETIME | NO |
| ps_order_id | int(11) | NO |
| carrier_id | int(11) | NO |
| tracking_number | VARCHAR(100) | YES |
| updated_at | DATETIME | NO |
| created_at | DATETIME | NO |
| is_deleted | TINYINT(1) | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_epaka_carrier_group ( id int(11) NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, color VARCHAR(7) NOT NULL DEFAULT '#17a2b8', created_at DATETIME NOT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS wp_epaka_carrier ( id int(11) NOT NULL AUTO_INCREMENT, zone_method_id int(11) NOT NULL, zone_id int(11) NOT NULL, shipment_type int(11) NOT NULL, parcel_type int(11) NOT NULL, sender_country_id VARCHAR(10) NOT NULL, receiver_country_id VARCHAR(10) NOT NULL, additional_options TEXT DEFAULT NULL, epaka_curier_id int(11) NOT NULL, epaka_courier_name VARCHAR(255) NOT NULL, max_width DECIMAL(10,2) DEFAULT 0.00, max_height DECIMAL(10,2) DEFAULT 0.00, max_length DECIMAL(10,2) DEFAULT 0.00, max_weight DECIMAL(10,2) DEFAULT 0.00, updated_at DATETIME NOT NULL, created_at DATETIME NOT NULL, is_point TINYINT(1) NOT NULL, is_deleted TINYINT(1) NOT NULL, group_id int(11) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS wp_epaka_sender ( id int(11) NOT NULL AUTO_INCREMENT, carrier_id int(11) NOT NULL, company_name VARCHAR(255) NOT NULL, first_name VARCHAR(255) NOT NULL, last_name VARCHAR(255) NOT NULL, country VARCHAR(255) NOT NULL, street VARCHAR(255) NOT NULL, house_number VARCHAR(50) NOT NULL, postal_code VARCHAR(20) NOT NULL, city VARCHAR(255) NOT NULL, phone VARCHAR(50) NOT NULL, email VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS wp_epaka_auth ( id int(11) NOT NULL AUTO_INCREMENT, access_token TEXT NOT NULL, expires_at DATETIME NOT NULL, refresh_token TEXT NOT NULL, client_id TEXT NOT NULL, client_secret TEXT NOT NULL, created_at DATETIME NOT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS wp_epaka_order ( id int(11) NOT NULL AUTO_INCREMENT, ps_order_id int(11) NOT NULL, carrier_id int(11) NOT NULL, tracking_number VARCHAR(100) DEFAULT NULL, updated_at DATETIME NOT NULL, created_at DATETIME NOT NULL, is_deleted TINYINT(1) NOT NULL, PRIMARY KEY (id), KEY ps_order_id (ps_order_id) ) ENGINE
Safe to delete?
If you have uninstalled Epaka Shipping for WooCommerce, 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_epaka_carrier_group`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Epaka Shipping for WooCommerce