Thursday, February 18, 2016

Sql Commands to clear all Entries of invoiceplane

TRUNCATE ip_invoices;
TRUNCATE ip_invoice_amounts;
TRUNCATE ip_invoice_custom;
TRUNCATE ip_invoice_items;
TRUNCATE ip_invoice_item_amounts;
TRUNCATE ip_invoice_tax_rates;
TRUNCATE ip_payments;
TRUNCATE ip_payment_custom;
TRUNCATE ip_quotes;
TRUNCATE ip_quote_amounts;
TRUNCATE ip_quote_custom;
TRUNCATE ip_quote_items;
TRUNCATE ip_quote_item_amounts;
TRUNCATE ip_quote_tax_rates;

ALTER TABLE ip_invoices AUTO_INCREMENT = 1;
ALTER TABLE ip_invoice_amounts AUTO_INCREMENT = 1;
ALTER TABLE ip_invoice_custom AUTO_INCREMENT = 1;
ALTER TABLE ip_invoice_items AUTO_INCREMENT = 1;
ALTER TABLE ip_invoice_item_amounts AUTO_INCREMENT = 1;
ALTER TABLE ip_invoice_tax_rates AUTO_INCREMENT = 1;
ALTER TABLE ip_payments AUTO_INCREMENT = 1;
ALTER TABLE ip_payment_custom AUTO_INCREMENT = 1;
ALTER TABLE ip_quotes AUTO_INCREMENT = 1;
ALTER TABLE ip_quote_amounts AUTO_INCREMENT = 1;
ALTER TABLE ip_quote_custom AUTO_INCREMENT = 1;
ALTER TABLE ip_quote_items AUTO_INCREMENT = 1;
ALTER TABLE ip_quote_item_amounts AUTO_INCREMENT = 1;
ALTER TABLE ip_quote_tax_rates AUTO_INCREMENT = 1;

UPDATE ip_invoice_groups SET invoice_group_next_id = 1 WHERE invoice_group_id = 3;
UPDATE ip_invoice_groups SET invoice_group_next_id = 1 WHERE invoice_group_id = 4;

No comments:

Post a Comment

Linuxmint 64bit vs cannon lbp2900b

i have no idea about other printers but cannon lbp2900b and my linuxmint 64 bit never jelled together after trying out most of the solutions...