Berichte zur ZSL-Mittelverteilung in SuperX-KENN
http://www.superx-projekt.de/doku/kenn_modul/zsl/
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
74 lines
1.8 KiB
74 lines
1.8 KiB
--Alte Version umhängen: |
|
delete from themenbaum where maskeninfo_id=32560 and name='ZSL-Mittelverteilung (Einzeltabelle)'; |
|
delete from themenbaum where maskeninfo_id=32580 and name='ZSL-Mittelverteilung (Gesamtbericht)'; |
|
|
|
|
|
select sp_update_sequence('themenbaum'); |
|
insert into themenbaum(name, |
|
-- maskeninfo_id, |
|
parent, |
|
gueltig_seit, |
|
gueltig_bis, |
|
erlaeuterung, |
|
sort, |
|
css_class) |
|
SELECT |
|
'ZSL-Mittelverteilung' as name, |
|
-- maskeninfo_id, |
|
tid as parent, |
|
gueltig_seit, |
|
gueltig_bis, |
|
erlaeuterung, |
|
sort, |
|
css_class |
|
FROM themenbaum |
|
where name='Grunddaten Studierende, Prüfungen' |
|
-- name like '%ZSL%' |
|
and 0=(select count(*) from themenbaum where name='ZSL-Mittelverteilung') |
|
; |
|
|
|
insert into themenbaum(name, |
|
maskeninfo_id, |
|
parent, |
|
gueltig_seit, |
|
gueltig_bis, |
|
erlaeuterung, |
|
sort, |
|
css_class) |
|
SELECT |
|
'ZSL-Mittelverteilung (Einzelbericht)' as name, |
|
24570 as maskeninfo_id, |
|
tid as parent, |
|
gueltig_seit, |
|
gueltig_bis, |
|
erlaeuterung, |
|
sort, |
|
css_class |
|
FROM themenbaum |
|
where name='ZSL-Mittelverteilung' |
|
-- name like '%ZSL%' |
|
and 0=(select count(*) from themenbaum where maskeninfo_id=24570) |
|
; |
|
|
|
insert into themenbaum(name, |
|
maskeninfo_id, |
|
parent, |
|
gueltig_seit, |
|
gueltig_bis, |
|
erlaeuterung, |
|
sort, |
|
css_class) |
|
SELECT |
|
'ZSL-Mittelverteilung (Gesamtbericht)' as name, |
|
24600 as maskeninfo_id, |
|
tid as parent, |
|
gueltig_seit, |
|
gueltig_bis, |
|
erlaeuterung, |
|
sort, |
|
css_class |
|
FROM themenbaum |
|
where name='ZSL-Mittelverteilung' |
|
-- name like '%ZSL%' |
|
and 0=(select count(*) from themenbaum where maskeninfo_id=24600) |
|
;
|
|
|