Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision f26687f6

Von Tamino Steinert vor mehr als 1 Jahr hinzugefügt

  • ID f26687f6fc501b81b4f5834b2270c9c058c27782
  • Vorgänger 940b81b3
  • Nachfolger 41e6b1ba

Default(ClientConfig): Felder für Email-Server-Konfigurationen

Unterschiede anzeigen:

SL/DB/MetaSetup/Default.pm
116 116 
  gl_changeable                             => { type => 'integer', default => 2, not_null => 1 },
117 117 
  global_bcc                                => { type => 'text', default => '' },
118 118 
  id                                        => { type => 'serial', not_null => 1 },
119 
  imap_client_base_folder                   => { type => 'text', default => 'INBOX', not_null => 1 },
120 
  imap_client_enabled                       => { type => 'boolean', default => 'false', not_null => 1 },
121 
  imap_client_hostname                      => { type => 'text', default => '', not_null => 1 },
122 
  imap_client_password                      => { type => 'text', default => '', not_null => 1 },
123 
  imap_client_port                          => { type => 'integer', default => 993, not_null => 1 },
124 
  imap_client_ssl                           => { type => 'boolean', default => 'true', not_null => 1 },
125 
  imap_client_username                      => { type => 'text', default => '', not_null => 1 },
119 126 
  income_accno_id                           => { type => 'integer' },
120 127 
  inventory_accno_id                        => { type => 'integer' },
121 128 
  inventory_system                          => { type => 'text' },
......
132 139 
  letternumber                              => { type => 'integer' },
133 140 
  lock_oe_subversions                       => { type => 'boolean', default => 'false', not_null => 1 },
134 141 
  loss_carried_forward_chart_id             => { type => 'integer' },
142 
  mail_delivery_host                        => { type => 'text', default => '', not_null => 1 },
143 
  mail_delivery_login                       => { type => 'text', default => '', not_null => 1 },
144 
  mail_delivery_password                    => { type => 'text', default => '', not_null => 1 },
145 
  mail_delivery_port                        => { type => 'integer', default => 25, not_null => 1 },
146 
  mail_delivery_security                    => { type => 'text', default => 'tls', not_null => 1 },
135 147 
  max_future_booking_interval               => { type => 'integer', default => 360 },
136 148 
  mtime                                     => { type => 'timestamp' },
137 149 
  normalize_part_descriptions               => { type => 'boolean', default => 'true' },
......
187 199 
  sales_reclamation_show_delete             => { type => 'boolean', default => 'true', not_null => 1 },
188 200 
  sales_serial_eq_charge                    => { type => 'boolean', default => 'false', not_null => 1 },
189 201 
  sdonumber                                 => { type => 'text' },
202 
  sent_emails_in_imap_enabled               => { type => 'boolean', default => 'false', not_null => 1 },
203 
  sent_emails_in_imap_folder                => { type => 'text', default => 'Sent', not_null => 1 },
204 
  sent_emails_in_imap_hostname              => { type => 'text', default => '', not_null => 1 },
205 
  sent_emails_in_imap_password              => { type => 'text', default => '', not_null => 1 },
206 
  sent_emails_in_imap_port                  => { type => 'integer', default => 993, not_null => 1 },
207 
  sent_emails_in_imap_ssl                   => { type => 'boolean', default => 'true', not_null => 1 },
208 
  sent_emails_in_imap_username              => { type => 'text', default => '', not_null => 1 },
190 209 
  sepa_creditor_id                          => { type => 'text' },
191 210 
  sepa_reference_add_vc_vc_id               => { type => 'boolean', default => 'false' },
192 211 
  sepa_set_duedate_as_default_exec_date     => { type => 'boolean', default => 'false' },
sql/Pg-upgrade2/defaults_add_email_server_configs.sql
1 
-- @tag: defaults_add_email_server_configs
2 
-- @description: Email-Server-Konfigurationen pro Mandant
3 
-- @depends: release_3_8_0
4 

  		




  
  5
  
    
ALTER TABLE defaults ADD COLUMN mail_delivery_host     TEXT NOT NULL DEFAULT '';


  		




  
  6
  
    
ALTER TABLE defaults ADD COLUMN mail_delivery_security TEXT NOT NULL DEFAULT 'tls';


  		




  
  7
  
    
ALTER TABLE defaults ADD COLUMN mail_delivery_port     INTEGER NOT NULL DEFAULT 25;


  		




  
  8
  
    
ALTER TABLE defaults ADD COLUMN mail_delivery_login    TEXT NOT NULL DEFAULT '';


  		




  
  9
  
    
ALTER TABLE defaults ADD COLUMN mail_delivery_password TEXT NOT NULL DEFAULT '';


  		




  
  10
  
    

  		




  
  11
  
    
ALTER TABLE defaults ADD COLUMN imap_client_enabled     boolean NOT NULL DEFAULT FALSE;


  		




  
  12
  
    
ALTER TABLE defaults ADD COLUMN imap_client_ssl         boolean NOT NULL DEFAULT TRUE;


  		




  
  13
  
    
ALTER TABLE defaults ADD COLUMN imap_client_base_folder TEXT NOT NULL DEFAULT 'INBOX';


  		




  
  14
  
    
ALTER TABLE defaults ADD COLUMN imap_client_hostname    TEXT NOT NULL DEFAULT '';


  		




  
  15
  
    
ALTER TABLE defaults ADD COLUMN imap_client_port        INTEGER NOT NULL DEFAULT 993;


  		




  
  16
  
    
ALTER TABLE defaults ADD COLUMN imap_client_username    TEXT NOT NULL DEFAULT '';


  		




  
  17
  
    
ALTER TABLE defaults ADD COLUMN imap_client_password    TEXT NOT NULL DEFAULT '';


  		




  
  18
  
    

  		




  
  19
  
    
ALTER TABLE defaults ADD COLUMN sent_emails_in_imap_enabled  boolean NOT NULL DEFAULT FALSE;


  		




  
  20
  
    
ALTER TABLE defaults ADD COLUMN sent_emails_in_imap_ssl      boolean NOT NULL DEFAULT TRUE;


  		




  
  21
  
    
ALTER TABLE defaults ADD COLUMN sent_emails_in_imap_folder   TEXT NOT NULL DEFAULT 'Sent';


  		




  
  22
  
    
ALTER TABLE defaults ADD COLUMN sent_emails_in_imap_hostname TEXT NOT NULL DEFAULT '';


  		




  
  23
  
    
ALTER TABLE defaults ADD COLUMN sent_emails_in_imap_port     INTEGER NOT NULL DEFAULT 993;


  		




  
  24
  
    
ALTER TABLE defaults ADD COLUMN sent_emails_in_imap_username TEXT NOT NULL DEFAULT '';


  		




  
  25
  
    
ALTER TABLE defaults ADD COLUMN sent_emails_in_imap_password TEXT NOT NULL DEFAULT '';


  		












Auch abrufbar als:  Unified diff