SCRIPT
BEGIN

BEGIN
   
   EXECUTE IMMEDIATE 'CREATE TABLE "TempArchiv"
(
"ObjectFileName"  VARCHAR(250) COLLATE "DEU_CI",
"SOPInstanceUID"  VARCHAR(64) COLLATE "DEU",
"StudyInstanceUID"  VARCHAR(64) COLLATE "DEU",
"PatientName"  VARCHAR(64) COLLATE "DEU",
"PatientBirthday"  VARCHAR(8) COLLATE "DEU",
"StudyDate"  VARCHAR(8) COLLATE "DEU"
)
VERSION 1
UNENCRYPTED
INDEX PAGE SIZE 4096
BLOB BLOCK SIZE 512
PUBLISH BLOCK SIZE 512
PUBLISH COMPRESSION 0
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768
MAX PUBLISH BUFFER SIZE 32768';
   
   EXECUTE IMMEDIATE 'CREATE INDEX "StudyInstanceUID_INX" ON "TempArchiv"
("StudyInstanceUID" COLLATE "DEU")';
   
   EXECUTE IMMEDIATE 'CREATE INDEX "StudyDate_INX" ON "TempArchiv"
("StudyDate" COLLATE "DEU")'; 

EXCEPTION
END;

BEGIN
   
   EXECUTE IMMEDIATE 'CREATE TABLE "TempResult"
(
"StudyDate"  VARCHAR(8) COLLATE "DEU",
"PatientName"  VARCHAR(64) COLLATE "DEU",
"AnzahlImages"  INTEGER,
"StudyInstanceUID"  VARCHAR(64) COLLATE "DEU"
)
VERSION 1
UNENCRYPTED
INDEX PAGE SIZE 4096
BLOB BLOCK SIZE 512
PUBLISH BLOCK SIZE 512
PUBLISH COMPRESSION 0
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768
MAX PUBLISH BUFFER SIZE 32768';
   
   EXECUTE IMMEDIATE 'ALTER TABLE "TempArchiv"
ADD CONSTRAINT "PrimaryKey" PRIMARY KEY ("ObjectFileName")';

EXCEPTION
END;

END

   