48 lines
3.0 KiB
Plaintext
Executable File
48 lines
3.0 KiB
Plaintext
Executable File
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 |