wp_colisly_clients
StaticStores colisly clients data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| user_id | BIGINT UNSIGNED | NO |
| reference | VARCHAR(20) | NO |
| phone | VARCHAR(50) | NO |
| admin_notes | TEXT | YES |
| discount_rate | DECIMAL(5,2) | NO |
| discount_scope | VARCHAR(10) | NO |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
| reference | VARCHAR(20) | NO |
| client_id | BIGINT UNSIGNED | NO |
| tracking_number | VARCHAR(100) | NO |
| weight | DECIMAL(10,3) | NO |
| length | DECIMAL(10,2) | YES |
| width | DECIMAL(10,2) | YES |
| height | DECIMAL(10,2) | YES |
| photo_id | BIGINT UNSIGNED | YES |
| photo_path | VARCHAR(255) | NO |
| internal_note | TEXT | YES |
| allow_grouping | TINYINT(1) | NO |
| allowed_carriers | TEXT | YES |
| price | DECIMAL(12,2) | NO |
| advanced_fees | DECIMAL(12,2) | NO |
| advanced_fees_label | VARCHAR(190) | NO |
| status | VARCHAR(30) | NO |
| shipment_id | BIGINT UNSIGNED | YES |
| received_at | DATETIME | NO |
| shipped_at | DATETIME | YES |
| created_by | BIGINT UNSIGNED | NO |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
| reference | VARCHAR(20) | NO |
| client_id | BIGINT UNSIGNED | NO |
| order_id | BIGINT UNSIGNED | NO |
| carrier | VARCHAR(100) | NO |
| status | VARCHAR(30) | NO |
| total_weight | DECIMAL(10,3) | NO |
| total_price | DECIMAL(12,2) | NO |
| storage_fees | DECIMAL(12,2) | NO |
| carrier_price | DECIMAL(12,2) | NO |
| destination_country | VARCHAR(2) | NO |
| insured_value | DECIMAL(12,2) | NO |
| insurance_price | DECIMAL(12,2) | NO |
| discount | DECIMAL(12,2) | NO |
| discount_label | VARCHAR(190) | NO |
| requested_at | DATETIME | NO |
| shipped_at | DATETIME | YES |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
| parcel_id | BIGINT UNSIGNED | NO |
| shipment_id | BIGINT UNSIGNED | NO |
| description | VARCHAR(255) | NO |
| quantity | INT UNSIGNED | NO |
| unit_weight | DECIMAL(10,3) | NO |
| unit_value | DECIMAL(12,2) | NO |
| origin_country | VARCHAR(2) | NO |
| hs_code | VARCHAR(20) | NO |
| position | INT UNSIGNED | NO |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
| client_id | BIGINT UNSIGNED | NO |
| attachment_id | BIGINT UNSIGNED | NO |
| file_path | VARCHAR(255) | NO |
| file_name | VARCHAR(255) | NO |
| mime_type | VARCHAR(100) | NO |
| title | VARCHAR(255) | NO |
| visibility | VARCHAR(20) | NO |
| uploaded_by | BIGINT UNSIGNED | NO |
| parcel_id | BIGINT UNSIGNED | NO |
| shipment_id | BIGINT UNSIGNED | NO |
| kind | VARCHAR(20) | NO |
| created_at | DATETIME | NO |
| client_id | BIGINT UNSIGNED | NO |
| parcel_id | BIGINT UNSIGNED | YES |
| shipment_id | BIGINT UNSIGNED | YES |
| event | VARCHAR(50) | NO |
| message | TEXT | YES |
| user_id | BIGINT UNSIGNED | NO |
| created_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE wp_colisly_clients ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT UNSIGNED NOT NULL, reference VARCHAR(20) NOT NULL DEFAULT '', phone VARCHAR(50) NOT NULL DEFAULT '', admin_notes TEXT NULL, discount_rate DECIMAL(5,2) NOT NULL DEFAULT 0, discount_scope VARCHAR(10) NOT NULL DEFAULT 'handling', created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), UNIQUE KEY user_id (user_id), UNIQUE KEY reference (reference) ) $collate; CREATE TABLE wp_colisly_parcels ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, reference VARCHAR(20) NOT NULL DEFAULT '', client_id BIGINT UNSIGNED NOT NULL, tracking_number VARCHAR(100) NOT NULL DEFAULT '', weight DECIMAL(10,3) NOT NULL DEFAULT 0, length DECIMAL(10,2) NULL, width DECIMAL(10,2) NULL, height DECIMAL(10,2) NULL, photo_id BIGINT UNSIGNED NULL, photo_path VARCHAR(255) NOT NULL DEFAULT '', internal_note TEXT NULL, allow_grouping TINYINT(1) NOT NULL DEFAULT 1, allowed_carriers TEXT NULL, price DECIMAL(12,2) NOT NULL DEFAULT 0, advanced_fees DECIMAL(12,2) NOT NULL DEFAULT 0, advanced_fees_label VARCHAR(190) NOT NULL DEFAULT '', status VARCHAR(30) NOT NULL DEFAULT 'available', shipment_id BIGINT UNSIGNED NULL, received_at DATETIME NOT NULL, shipped_at DATETIME NULL, created_by BIGINT UNSIGNED NOT NULL DEFAULT 0, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), UNIQUE KEY reference (reference), KEY client_id (client_id), KEY status (status), KEY shipment_id (shipment_id) ) $collate; CREATE TABLE wp_colisly_shipments ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, reference VARCHAR(20) NOT NULL DEFAULT '', client_id BIGINT UNSIGNED NOT NULL, order_id BIGINT UNSIGNED NOT NULL DEFAULT 0, carrier VARCHAR(100) NOT NULL DEFAULT '', status VARCHAR(30) NOT NULL DEFAULT 'requested', total_weight DECIMAL(10,3) NOT NULL DEFAULT 0, total_price DECIMAL(12,2) NOT NULL DEFAULT 0, storage_fees DECIMAL(12,2) NOT NULL DEFAULT 0, carrier_price DECIMAL(12,2) NOT NULL DEFAULT 0, destination_country VARCHAR(2) NOT NULL DEFAULT '', insured_value DECIMAL(12,2) NOT NULL DEFAULT 0, insurance_price DECIMAL(12,2) NOT NULL DEFAULT 0, discount DECIMAL(12,2) NOT NULL DEFAULT 0, discount_label VARCHAR(190) NOT NULL DEFAULT '', requested_at DATETIME NOT NULL, shipped_at DATETIME NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), UNIQUE KEY reference (reference), KEY client_id (client_id), KEY status (status) ) $collate; CREATE TABLE wp_colisly_customs_items ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, parcel_id BIGINT UNSIGNED NOT NULL DEFAULT 0, shipment_id BIGINT UNSIGNED NOT NULL DEFAULT 0, description VARCHAR(255) NOT NULL DEFAULT '', quantity INT UNSIGNED NOT NULL DEFAULT 1, unit_weight DECIMAL(10,3) NOT NULL DEFAULT 0, unit_value DECIMAL(12,2) NOT NULL DEFAULT 0, origin_country VARCHAR(2) NOT NULL DEFAULT '', hs_code VARCHAR(20) NOT NULL DEFAULT '', position INT UNSIGNED NOT NULL DEFAULT 0, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), KEY parcel_id (parcel_id), KEY shipment_id (shipment_id) ) $collate; CREATE TABLE wp_colisly_documents ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, client_id BIGINT UNSIGNED NOT NULL, attachment_id BIGINT UNSIGNED NOT NULL DEFAULT 0, file_path VARCHAR(255) NOT NULL DEFAULT '', file_name VARCHAR(255) NOT NULL DEFAULT '', mime_type VARCHAR(100) NOT NULL DEFAULT '', title VARCHAR(255) NOT NULL DEFAULT '', visibility VARCHAR(20) NOT NULL DEFAULT 'client', uploaded_by BIGINT UNSIGNED NOT NULL DEFAULT 0, parcel_id BIGINT UNSIGNED NOT NULL DEFAULT 0, shipment_id BIGINT UNSIGNED NOT NULL DEFAULT 0, kind VARCHAR(20) NOT NULL DEFAULT '', created_at DATETIME NOT NULL, PRIMARY KEY (id), KEY client_id (client_id), KEY parcel_id (parcel_id), KEY shipment_id (shipment_id) ) $collate; CREATE TABLE wp_colisly_history ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, client_id BIGINT UNSIGNED NOT NULL, parcel_id BIGINT UNSIGNED NULL, shipment_id BIGINT UNSIGNED NULL, event VARCHAR(50) NOT NULL DEFAULT '', message TEXT NULL, user_id BIGINT UNSIGNED NOT NULL DEFAULT 0, created_at DATETIME NOT NULL, PRIMARY KEY (id), KEY client_id (client_id), KEY parcel_id (parcel_id), KEY event (event) ) $collate; "; dbDelta( $tables );
Safe to delete?
If you have uninstalled Parcel Forwarding & Package Consolidation 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_colisly_clients`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Parcel Forwarding & Package Consolidation for WooCommerce