#!/bin/bash


DOQUERY "create table tmp_repository(
	tid SERIAL  not null, 
id CHAR(200)  not null, 
content TEXT , 
caption CHAR(200) , 
comment TEXT , 
version SMALLINT , 
art CHAR(200) , 
art2 CHAR(200) , 
art3 CHAR(200) , 
sachgebiete_id INTEGER , 
sort1 INTEGER , 
sort2 INTEGER , 
sort3 INTEGER , 
geaendert_am DATE , 
aktiv smallint , 
gueltig_seit DATE , 
gueltig_bis DATE 
);"

sx_auto_upload_table.x tmp_repository sx_repository.unl

DOSQL sx_repository_fuellen.sql