ALTER TABLE `stan_dienststellen_tmp` ADD `mail` VARCHAR(200) NOT NULL AFTER `staat`;
ALTER TABLE `stan_printqueue_antrag` ADD `versandart` VARCHAR(5) NOT NULL COMMENT 'Brief, Mail' AFTER `druckstatus`, ADD `mail_intern_office` DATETIME NOT NULL AFTER `versandart`;
ALTER TABLE `stan_printqueue_hist` ADD `versandart` VARCHAR(5) NOT NULL COMMENT 'Brief, Mail' AFTER `druckstatus`, ADD `mail_intern_office` DATETIME NOT NULL AFTER `versandart`;
INSERT INTO `parameter` (`PID`, `Beschreibung`, `Wert1`, `Wert2`) VALUES ('15', 'Stellenantrag: Name und Mail Ansprechpartner', 'Johannes Fien', 'praxisstellenanmeldung@hs-kehl.de');
ALTER TABLE `stan_printqueue_antrag` ADD `dokument` VARCHAR(200) NOT NULL AFTER `versandart`;
INSERT INTO `parameter` (`PID`, `Beschreibung`, `Wert1`, `Wert2`) VALUES ('16', 'International Office Kehl (Stellenantrag)', 'international-office@hs-kehl.de', NULL), ('17', 'International Office Kehl (Ludwigsburg)', 'international.office@hs-ludwigsburg.de', NULL);
UPDATE `stan_dienststellen` set mail=lower(mail);
ALTER TABLE `stan_antrag` ADD `dummy_dst` VARCHAR(1) NOT NULL AFTER `art`;
DROP VIEW stan_zuw_so_neu;
CREATE VIEW stan_zuw_so_neu
AS
    SELECT a.wagsid          AS wagsid,
           b.UID             AS UID,
           b.vorname         AS vorname,
           b.nachname        AS nachname,
           b.mail            AS mail,
           b.hs              AS hs,
           b.poplz           AS poplz,
           b.poOrt           AS poOrt,
           b.poStrasse       AS poStrasse,
           b.AG              AS AG,
           b.Jahrgang        AS Jahrgang,
           d.standort        AS standort,
           a.block           AS block,
           d.abdatum         AS abdatum,
           d.pendler         AS pendler,
           e.bezeichnung     AS bezeichnung
      FROM ( (((stan_ag_standort_wunsch a JOIN stud b  ) join stan_ag_standort c) join stan_standort d) join stan_vertiefungsbereich e) 
      where ((a.uid = b.uid) 
      and (c.agsid = a.wagsid) 
      and (c.sid = d.sid) 
      and (c.vbid = e.vbid) 
      and (b.durchgefallen <> 'Y') 
      and (a.block <> '') 
      and (a.prio = 0) 
      and (not(a.uid in (select c.uid from stan_printqueue_antrag c where ((c.block = a.block) and (a.uid = c.uid)))))) 
      order by b.nachname;
ALTER TABLE `stan_printqueue_antrag` ADD `wagsid` VARCHAR(255) NOT NULL COMMENT 'Bei SOZ' AFTER `printed_obj`;
ALTER TABLE `stan_printqueue_hist` ADD `wagsid` VARCHAR(255) NOT NULL COMMENT 'Bei SOZ' AFTER `printed_obj`;
DELETE FROM `stan_dienststellen_tmp` where dst_id not in (select dst_id from stan_antrag);
UPDATE `stan_printqueue_antrag` SET versandart='B' WHERE versandart='' AND druckstatus='G';
ALTER TABLE `stan_printqueue_hist` ADD `dokument` VARCHAR(200) NOT NULL AFTER `versandart`;
ALTER TABLE `stud` ADD `geschlecht` VARCHAR(1) NOT NULL AFTER `vorname`;

@updates_dienststellen_2019.sql      
@update_geschlechter.sql
      
Verzeichnis anlegen: .../admin/drucke_mailversand