wp_ezyqb_clients
StaticStores ezyqb clients data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| company_name | varchar(200) | NO |
| contact_name | varchar(200) | NO |
| varchar(200) | NO | |
| phone | varchar(50) | NO |
| address_line1 | varchar(255) | NO |
| address_line2 | varchar(255) | NO |
| city | varchar(100) | NO |
| state_province | varchar(100) | NO |
| country | varchar(100) | NO |
| postal_code | varchar(20) | NO |
| tax_number | varchar(100) | NO |
| notes | text | NO |
| status | varchar(20) | NO |
| created_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_ezyqb_clients ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, company_name varchar(200) NOT NULL DEFAULT '', contact_name varchar(200) NOT NULL DEFAULT '', email varchar(200) NOT NULL DEFAULT '', phone varchar(50) NOT NULL DEFAULT '', address_line1 varchar(255) NOT NULL DEFAULT '', address_line2 varchar(255) NOT NULL DEFAULT '', city varchar(100) NOT NULL DEFAULT '', state_province varchar(100) NOT NULL DEFAULT '', country varchar(100) NOT NULL DEFAULT '', postal_code varchar(20) NOT NULL DEFAULT '', tax_number varchar(100) NOT NULL DEFAULT '', notes text NOT NULL, status varchar(20) NOT NULL DEFAULT 'active', created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), KEY email (email(50)) ) $c;" );
Safe to delete?
If you have uninstalled ezy Quotation Builder, 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_ezyqb_clients`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ezy Quotation Builder