wp_invoice

Static

Stores invoice data created by this plugin.

Column Definitions

ColumnTypeNullable
🔑idint(11) unsignedNO
filenamevarchar(200)YES
datedateYES
amountdecimal(11,2)YES
payment_targetint(11)YES
start_texttextYES
end_texttextYES
customer_idint(11)YES
paiddateYES

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS `wp_invoice` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `filename` varchar(200) DEFAULT NULL, `date` date DEFAULT NULL, `amount` decimal(11,2) DEFAULT NULL, `payment_target` int(11) DEFAULT NULL, `start_text` text, `end_text` text, `customer_id` int(11) DEFAULT NULL, `paid` date DEFAULT NULL, PRIMARY KEY (`id`) ) 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`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from PDF-Rechnungsverwaltung