-- Add display name columns to invoices table (SQLite syntax)
ALTER TABLE invoices ADD COLUMN display_name_option VARCHAR(50) DEFAULT 'client_name';
ALTER TABLE invoices ADD COLUMN custom_display_name VARCHAR(255) NULL;

-- Note: invoice_subject, tax_method, and invoice_level_tax_bracket_id columns may already exist
-- If they don't exist, uncomment the following lines:

-- ALTER TABLE invoices ADD COLUMN invoice_subject VARCHAR(255) NULL;
-- ALTER TABLE invoices ADD COLUMN tax_method VARCHAR(50) DEFAULT 'per_item';
-- ALTER TABLE invoices ADD COLUMN invoice_level_tax_bracket_id INT NULL;
