wp_invoice_position
StaticStores invoice position data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| invoice_id | int(11) unsigned | NO |
| position | int(11) | NO |
| description | text | YES |
| price | decimal(11,2) | YES |
| amount | decimal(11,2) | YES |
| unit | varchar(200) | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_invoice_position` ( `invoice_id` int(11) unsigned NOT NULL, `position` int(11) NOT NULL, `description` text, `price` decimal(11,2) DEFAULT NULL, `amount` decimal(11,2) DEFAULT NULL, `unit` varchar(200) DEFAULT NULL, PRIMARY KEY (`invoice_id`,`position`) ) ENGINE
Safe to delete?
If you have uninstalled PDF-Rechnungsverwaltung, 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_invoice_position`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from PDF-Rechnungsverwaltung