Schnittstelle CampusOnline (TU Graz) zu SuperX-Modul COSTAGE
http://www.superx-projekt.de/doku/costage_modul/
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.
14 lines
562 B
14 lines
562 B
--Das Sachgebiet 311 wird installiert |
|
|
|
|
|
delete from sachgebiete where tid in (311); |
|
insert into sachgebiete(tid,name) values (311,'CO Basisdaten Administr.'); |
|
|
|
delete from group_sachgeb_bez where sachgebiete_id in (310,311) |
|
and groupinfo_id in (select G.tid from groupinfo G where G.name='Administratoren' or G.name='superx') ; |
|
|
|
insert into group_sachgeb_bez |
|
select G.tid,310 from groupinfo G where G.name='Administratoren' or G.name='superx'; |
|
insert into group_sachgeb_bez |
|
select G.tid,311 from groupinfo G where G.name='Administratoren' or G.name='superx'; |
|
|
|
|