wp_accounts_invoices
StaticStores accounts invoices data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑ID | int(11) | NO |
| client | int(11) | NO |
| invoice_date | date | NO |
| monthly | tinyint(1) | NO |
| yearly | tinyint(1) | NO |
| item1 | varchar(255) | NO |
| price1 | decimal(10, 2) | NO |
| item2 | varchar(255) | YES |
| price2 | decimal(10, 2) | YES |
| item3 | varchar(255) | YES |
| price3 | decimal(10, 2) | YES |
| item4 | varchar(255) | YES |
| price4 | decimal(10, 2) | YES |
| item5 | varchar(255) | YES |
| price5 | decimal(10, 2) | YES |
| invoice_status | int(11) | NO |
| date_paid | date | YES |
| payment_method | int(11) | YES |
| mileage | int(11) | YES |
| notes | text | YES |
CREATE TABLE Statement
CREATE TABLE wp_accounts_invoices ( ID int(11) NOT NULL AUTO_INCREMENT, client int(11) NOT NULL, invoice_date date NOT NULL, monthly tinyint(1) NOT NULL DEFAULT '0', yearly tinyint(1) NOT NULL DEFAULT '0', item1 varchar(255) NOT NULL, price1 decimal(10, 2) NOT NULL, item2 varchar(255) DEFAULT NULL, price2 decimal(10, 2) DEFAULT NULL, item3 varchar(255) DEFAULT NULL, price3 decimal(10, 2) DEFAULT NULL, item4 varchar(255) DEFAULT NULL, price4 decimal(10, 2) DEFAULT NULL, item5 varchar(255) DEFAULT NULL, price5 decimal(10, 2) DEFAULT NULL, invoice_status int(11) NOT NULL DEFAULT '1', date_paid date DEFAULT NULL, payment_method int(11) DEFAULT NULL, mileage int(11) DEFAULT '0', notes text DEFAULT NULL, PRIMARY KEY (ID), KEY client (client), KEY payment_method (payment_method), KEY invoice_status (invoice_status) ) {$wpdb->get_charset_collate()} AUTO_INCREMENT=1;" );Safe to delete?
If you have uninstalled Web:D Accounts, 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_accounts_invoices`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Web:D Accounts