wp_ezy_invoices
StaticStores ezy invoices data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| invoice_number | varchar(50) | NO |
| client_id | bigint(20) unsigned | NO |
| issue_date | date | NO |
| due_date | date | NO |
| status | varchar(20) | NO |
| subtotal | decimal(15,2) | NO |
| tax_rate | decimal(5,2) | NO |
| tax_amount | decimal(15,2) | NO |
| service_charge_rate | decimal(5,2) | NO |
| service_charge_amount | decimal(15,2) | NO |
| discount_amount | decimal(15,2) | NO |
| total | decimal(15,2) | NO |
| notes | text | NO |
| pdf_path | varchar(500) | NO |
| email_sent_at | datetime | YES |
| created_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_ezy_invoices ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, invoice_number varchar(50) NOT NULL DEFAULT '', client_id bigint(20) unsigned NOT NULL DEFAULT 0, issue_date date NOT NULL DEFAULT '0000-00-00', due_date date NOT NULL DEFAULT '0000-00-00', status varchar(20) NOT NULL DEFAULT 'draft', subtotal decimal(15,2) NOT NULL DEFAULT 0.00, tax_rate decimal(5,2) NOT NULL DEFAULT 0.00, tax_amount decimal(15,2) NOT NULL DEFAULT 0.00, service_charge_rate decimal(5,2) NOT NULL DEFAULT 0.00, service_charge_amount decimal(15,2) NOT NULL DEFAULT 0.00, discount_amount decimal(15,2) NOT NULL DEFAULT 0.00, total decimal(15,2) NOT NULL DEFAULT 0.00, notes text NOT NULL, pdf_path varchar(500) NOT NULL DEFAULT '', email_sent_at datetime DEFAULT NULL, created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (id), UNIQUE KEY invoice_number (invoice_number), KEY client_id (client_id) ) $c;" );
Safe to delete?
If you have uninstalled ezy E Invoice, 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_ezy_invoices`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ezy E Invoice