1 # @tag: defaults_invoice_mail_priority
2 # @description: Einstellen der Priorität der generischen E-Mail für Rechnungen (Verkauf)
3 # @depends: release_3_5_3
4 package SL::DBUpgrade2::defaults_invoice_mail_priority;
8 use parent qw(SL::DBUpgrade2::Base);
14 # this query will fail if column already exist (new database)
15 $self->db_query(qq|CREATE TYPE invoice_mail_settings AS ENUM ('cp', 'invoice_mail', 'invoice_mail_cc_cp');
16 ALTER TABLE defaults ADD COLUMN invoice_mail_settings invoice_mail_settings default 'cp'|);