1 -- @tag: periodic_invoices_send_email
2 -- @description: Wiederkehrende Rechnungen automatisch per E-Mail verschicken
3 -- @depends: release_3_4_0
4 ALTER TABLE periodic_invoices_configs ADD COLUMN send_email BOOLEAN;
5 ALTER TABLE periodic_invoices_configs ADD COLUMN email_recipient_contact_id INTEGER;
6 ALTER TABLE periodic_invoices_configs ADD COLUMN email_recipient_address TEXT;
7 ALTER TABLE periodic_invoices_configs ADD COLUMN email_sender TEXT;
8 ALTER TABLE periodic_invoices_configs ADD COLUMN email_subject TEXT;
9 ALTER TABLE periodic_invoices_configs ADD COLUMN email_body TEXT;
11 UPDATE periodic_invoices_configs SET send_email = FALSE;
13 ALTER TABLE periodic_invoices_configs ALTER COLUMN send_email SET DEFAULT FALSE;
14 ALTER TABLE periodic_invoices_configs ALTER COLUMN send_email SET NOT NULL;
16 ALTER TABLE periodic_invoices_configs
17 ADD FOREIGN KEY (email_recipient_contact_id) REFERENCES contacts (cp_id)