wp_ipenta_invoices
StaticStores ipenta invoices data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | INT | YES |
| invoice_number | VARCHAR(50) | YES |
| quote_id | INT | YES |
| client_id | INT | YES |
| client_name | VARCHAR(200) | YES |
| client_email | VARCHAR(200) | YES |
| client_address | TEXT | YES |
| client_company | VARCHAR(200) | YES |
| items | LONGTEXT | YES |
| subtotal | DECIMAL(12,2) | YES |
| tax_enabled | TINYINT | YES |
| tax_rate | DECIMAL(5,2) | YES |
| tax_amount | DECIMAL(12,2) | YES |
| total | DECIMAL(12,2) | YES |
| notes | TEXT | YES |
| status | VARCHAR(20) | YES |
| payment_status | VARCHAR(20) | YES |
| date_issued | DATE | YES |
| date_due | DATE | YES |
| date_paid | DATE | YES |
| amount_paid | DECIMAL(12,2) | YES |
| date_created | DATETIME | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_ipenta_invoices ( id INT AUTO_INCREMENT PRIMARY KEY, invoice_number VARCHAR(50) UNIQUE, quote_id INT DEFAULT 0, client_id INT DEFAULT 0, client_name VARCHAR(200), client_email VARCHAR(200), client_address TEXT, client_company VARCHAR(200), items LONGTEXT, subtotal DECIMAL(12,2) DEFAULT 0, tax_enabled TINYINT DEFAULT 0, tax_rate DECIMAL(5,2) DEFAULT 0, tax_amount DECIMAL(12,2) DEFAULT 0, total DECIMAL(12,2) DEFAULT 0, notes TEXT, status VARCHAR(20) DEFAULT 'draft', payment_status VARCHAR(20) DEFAULT 'unpaid', date_issued DATE, date_due DATE, date_paid DATE, amount_paid DECIMAL(12,2) DEFAULT 0, date_created DATETIME DEFAULT CURRENT_TIMESTAMP) $c");
Safe to delete?
If you have uninstalled SilverStream Invoicing, 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_ipenta_invoices`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from SilverStream Invoicing