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.
25 lines
441 B
25 lines
441 B
--freemarker template |
|
--Werden immer ausgetauscht: |
|
delete from fm_templates where id in (select id from tmp_templates); |
|
|
|
|
|
<#if SQLdialect='Postgres'> |
|
select sp_update_sequence('fm_templates'); |
|
</#if> |
|
|
|
insert into fm_templates( |
|
id, |
|
content, |
|
description, |
|
comment, |
|
version) |
|
SELECT |
|
id, |
|
content, |
|
description, |
|
comment, |
|
version |
|
FROM tmp_templates; |
|
|
|
drop table tmp_templates; |
|
|
|
|