sql/Pg-upgrade2/defaults_invoice_mail_priority.pl

   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;
   5
   6 use utf8;
   7
   8 use parent qw(SL::DBUpgrade2::Base);
   9 use strict;
  10
  11 sub run {
  12   my ($self) = @_;
  13
  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'|);
  17   return 1;
  18 }
  19
  20 1;