wp_ezy_invoice_items
StaticStores ezy invoice items data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| invoice_id | bigint(20) unsigned | NO |
| product_id | bigint(20) unsigned | YES |
| item_name | varchar(255) | NO |
| item_description | text | NO |
| unit_price | decimal(15,2) | NO |
| quantity | decimal(10,2) | NO |
| line_total | decimal(15,2) | NO |
| sort_order | int(11) | NO |
CREATE TABLE Statement
CREATE TABLE wp_ezy_invoice_items ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, invoice_id bigint(20) unsigned NOT NULL DEFAULT 0, product_id bigint(20) unsigned DEFAULT NULL, item_name varchar(255) NOT NULL DEFAULT '', item_description text NOT NULL, unit_price decimal(15,2) NOT NULL DEFAULT 0.00, quantity decimal(10,2) NOT NULL DEFAULT 1.00, line_total decimal(15,2) NOT NULL DEFAULT 0.00, sort_order int(11) NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY invoice_id (invoice_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_invoice_items`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ezy E Invoice