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.
26 lines
441 B
26 lines
441 B
3 years ago
|
--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;
|
||
|
|