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.
56 lines
853 B
56 lines
853 B
|
|
--freemarker template |
|
|
|
<#if SQLdialect='Postgres'> |
|
select sp_update_sequence('sx_repository'); |
|
|
|
</#if> |
|
|
|
|
|
delete from tmp_repository where id in (select id from sx_repository); |
|
|
|
insert into sx_repository |
|
( |
|
id, |
|
content, |
|
caption, |
|
comment, |
|
version, |
|
art, |
|
art2, |
|
art3, |
|
sachgebiete_id, |
|
sort1, |
|
sort2, |
|
sort3, |
|
geaendert_am, |
|
aktiv, |
|
gueltig_seit, |
|
gueltig_bis |
|
) |
|
|
|
SELECT |
|
id, |
|
content, |
|
caption, |
|
comment, |
|
version, |
|
art, |
|
art2, |
|
art3, |
|
sachgebiete_id, |
|
sort1, |
|
sort2, |
|
sort3, |
|
geaendert_am, |
|
aktiv, |
|
gueltig_seit, |
|
gueltig_bis |
|
FROM tmp_repository; |
|
|
|
<#if SQLdialect='Postgres'> |
|
select sp_update_sequence('sx_repository'); |
|
</#if> |
|
|
|
drop table tmp_repository; |
|
|
|
|