75 lines
1.8 KiB
SQL
75 lines
1.8 KiB
SQL
--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)
|
|
;
|