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
1.0 KiB
26 lines
1.0 KiB
--Freemarker Template |
|
-- TableFieldExists wird genutzt, um zu prüfen, ob die entsprechende Tabelle existiert |
|
--Geschlecht |
|
<#if TableFieldExists('sxc_stud_sem_da_geschl_hs','auspraegung_code_3')> |
|
delete from xcube_dims where id='auspraegung_code_3'; |
|
INSERT INTO xcube_dims (id,apnr,name,sort1) values |
|
('auspraegung_code_3','GESM','männlich',1); |
|
INSERT INTO xcube_dims (id,apnr,name,sort1) values |
|
('auspraegung_code_3','GESW','weiblich',2); |
|
INSERT INTO xcube_dims (id,apnr,name,sort1) values |
|
('auspraegung_code_3','UNB','nicht bekannt',3); |
|
</#if> |
|
<#if TableFieldExists('sxc_stud_sem_da_geschl_hs','auspraegung_code_2')> |
|
delete from xcube_dims where id='auspraegung_code_2'; |
|
INSERT INTO xcube_dims (id,apnr,name,sort1) values |
|
('auspraegung_code_2','NATD','Deutschland',1); |
|
INSERT INTO xcube_dims (id,apnr,name,sort1) values |
|
('auspraegung_code_2','NATA','Ausland',2); |
|
</#if> |
|
|
|
|
|
--Zum Testen |
|
--INSERT INTO xcube_dims (id,apnr,name,sort1,parent,strukturstr) |
|
--VALUES |
|
-- -('fs4','0','FS<4',1,NULL,NULL), |
|
-- ('fs4','1','FS>=4',2,NULL,NULL); |