ALTER TABLE nav_invoices ADD COLUMN deleted_trans smallint;
ALTER TABLE nav_invoices ALTER COLUMN deleted_trans SET DEFAULT 0;
UPDATE nav_invoices SET deleted_trans = 0; 