CREATE TABLE "ACT"
("IDACT" NUMBER NOT NULL ENABLE, 
	"SFACT" VARCHAR2(1 CHAR), 
	"DB" VARCHAR2(40 CHAR), 
	"TBL" VARCHAR2(40 CHAR), 
	"USR" VARCHAR2(250 CHAR), 
	"CAS" DATE, 
	"ID" VARCHAR2(50 CHAR), 
	"CMP" VARCHAR2(30 CHAR), 
	"CNT"  CLOB, 
	"SFAPP" VARCHAR2(2 CHAR), 
	"OPOMBA" VARCHAR2(50 CHAR), 
	 CONSTRAINT "PK_ACT" PRIMARY KEY ("IDACT"));

CREATE INDEX "IX_ACT1" ON "ACT" ("TBL", "ID", "CAS");
CREATE INDEX "IX_ACT2" ON "ACT" ("USR", "CAS");


CREATE TABLE "PRINT_DOK"
("ID_PRINT_DOK" NUMBER(6,0) NOT NULL ENABLE, 
	"DATUM" DATE NOT NULL ENABLE, 
	"MODUL" VARCHAR2(30 CHAR) NOT NULL ENABLE, 
	"REFERENCA" VARCHAR2(20 CHAR) NOT NULL ENABLE, 
	"STEVILKA" VARCHAR2(20 CHAR) NOT NULL ENABLE, 
	"OPIS" VARCHAR2(150 CHAR) NOT NULL ENABLE, 
	"UPORABNIK" VARCHAR2(20 CHAR) NOT NULL ENABLE, 
	"DT_VPISA" DATE NOT NULL ENABLE, 
	"DATOTEKA" BLOB, 
	"PDF" BLOB, 
	"OBJAVI" VARCHAR2(1 CHAR), 
	"FILE_REFERENCE" VARCHAR2(20 CHAR), 
	"FILENAME" VARCHAR2(250 CHAR), 
        "ID_PRINT_PREVOD" NUMBER,
	 PRIMARY KEY ("ID_PRINT_DOK"));



CREATE TABLE "EMAILS_ATTACH" 
   (	"ID_EMAIL_ATTACH" NUMBER NOT NULL ENABLE, 
	"ID_EMAIL" NUMBER NOT NULL ENABLE, 
	"FILENAME" VARCHAR2(250 CHAR) NOT NULL ENABLE, 
	"FILEDATA" BLOB, 
	"USER_KREIRANJA" VARCHAR2(250 CHAR), 
	"DATUM_KREIRANJA" DATE, 
	"FILE_REFERENCE" VARCHAR2(20 CHAR), 
	  CONSTRAINT "PK_EMAILS_ATTACH" PRIMARY KEY ("ID_EMAIL_ATTACH") );


CREATE TABLE "DATOTEKE_KUPCEV" 
   (	"ID_DATOTEKE_KUPCEV" NUMBER NOT NULL ENABLE, 
	"ID_KUPCA" NUMBER NOT NULL ENABLE, 
	"VRSTA" VARCHAR2(3 CHAR), 
	"DATOTEKA" BLOB, 
	"IME_DATOTEKE" VARCHAR2(250 CHAR), 
	"KONCNICA" VARCHAR2(10 CHAR), 
	"KOMENTAR" VARCHAR2(1000 CHAR), 
	"USER_KREIRANJA" VARCHAR2(250 CHAR), 
	"DATUM_KREIRANJA" DATE, 
	"USER_SPREMEMBE" VARCHAR2(250 CHAR), 
	"DATUM_SPREMEMBE" DATE, 
	"STATUS" NUMBER, 
	"VALID" VARCHAR2(1 CHAR), 
	"FILE_REFERENCE" VARCHAR2(20 CHAR), 
	"ID_POGODBE" NUMBER, 
	"ID_PRINT_PREVOD" NUMBER, 
	"ISSUE_DATE" DATE, 
	"ID_DN" NUMBER, 
	"ID_STORITVE" NUMBER, 
	"NNLOCATION_ID" NUMBER, 
	"EXPIRY_DATE" DATE, 
	"FILE_ID" VARCHAR2(200 CHAR), 
	"ID_REZERVAC" NUMBER, 
	 CONSTRAINT "PK_DATOTEKE_KUPCEV" PRIMARY KEY ("ID_DATOTEKE_KUPCEV")
) ;


  CREATE TABLE "DATOTEKE_PLOVIL" 
   (	"ID" NUMBER(38,0) NOT NULL ENABLE, 
	"ZAPOREDNA" NUMBER(38,0) NOT NULL ENABLE, 
	"DOKUMENT" BLOB, 
	"DATOTEKA" VARCHAR2(250 CHAR), 
	"TIP" VARCHAR2(5 CHAR), 
	"GRUPA" NUMBER(38,0), 
	"KOMENTAR" VARCHAR2(1000 CHAR), 
	"AVTOR" VARCHAR2(40 CHAR), 
	"DATUM" DATE, 
	"USER_KREIRANJA" VARCHAR2(20 CHAR), 
	"DATUM_KREIRANJA" DATE, 
	"USER_SPREMEMBE" VARCHAR2(20 CHAR), 
	"DATUM_SPREMEMBE" DATE, 
	"STATUS" NUMBER(*,0), 
	"ARCHIVED" VARCHAR2(1 CHAR), 
	"DOCUMENTTYPE" VARCHAR2(5 CHAR), 
	"ISSUER" VARCHAR2(50 CHAR), 
	"DATEISSUE" DATE, 
	"ID_DATOTEKE_PLOVIL" NUMBER, 
	"VALID" VARCHAR2(1 CHAR), 
	"FILE_REFERENCE" VARCHAR2(20 CHAR), 
	"NNLOCATION_ID" NUMBER, 
	"EXPIRY_DATE" DATE, 
	"ID_POGODBE" NUMBER, 
	"FILE_ID" VARCHAR2(200 CHAR), 
	 CONSTRAINT "DATOTEKE_PLOVIL_ID_POGODBE_FK" FOREIGN KEY ("ID_POGODBE")
	 ) ;


CREATE TABLE "BATCH_PRINT"  
   (	"ID_BATCH_PRINT" NUMBER NOT NULL ENABLE,  
	"ID_BATCH" NUMBER NOT NULL ENABLE,  
	"VRSTA" VARCHAR2(20 CHAR) NOT NULL ENABLE,  
	"ID" NUMBER NOT NULL ENABLE,  
	"COMPLETE" VARCHAR2(1 CHAR),  
	"CREATE_TIME" DATE,  
	"SEND_TO_PRINTER" VARCHAR2(1 CHAR),  
	"REPORT_FILENAME" VARCHAR2(250 CHAR),  
	"REPORT_FILTER" VARCHAR2(250 CHAR),  
	"REPORT_TRANSLATE" VARCHAR2(100 CHAR),  
	"ID_KUPCA" NUMBER,  
	"REPORT_PDF" BLOB,  
	"PRIORITY" NUMBER DEFAULT 2,  
	"UPORABNIK" VARCHAR2(20 CHAR),  
	"SQL_FILENAME" VARCHAR2(250 CHAR),  
	"ID_POROCILA" NUMBER,  
	"AUTO_CREATE" VARCHAR2(1 CHAR),  
	"MESSAGE_LOG" VARCHAR2(250 CHAR),  
	"SEND_TO_EMAIL" VARCHAR2(1 CHAR),  
	"ID_EMAIL_TEMPLATE" NUMBER,  
	"NNLOCATION_ID" NUMBER,  
	"TABLE_NAME" VARCHAR2(50 CHAR),  
	"ID_PRINT_PREVOD" NUMBER,  
	"FILE_NAME" VARCHAR2(250 CHAR),  
	"FILE_REFERENCE" VARCHAR2(20 CHAR),  
	 CONSTRAINT "PK_BATCH_PRINT" PRIMARY KEY ("ID_BATCH_PRINT") );


CREATE TABLE "EMAILS"  
   (	"ID_EMAIL" NUMBER NOT NULL ENABLE,  
	"DATUM_KREIRANJA" DATE,  
	"USER_KREIRANJA" VARCHAR2(250 CHAR),  
	"ZADEVA" VARCHAR2(500 CHAR),  
	"POSILJATELJ" VARCHAR2(200 CHAR),  
	"STATUS" NUMBER,  
	"DATUM_POSILJANJA" DATE,  
	"AVTOMATSKO_KREIRANJE" VARCHAR2(1 CHAR),  
	"PREJEMNIK_CC" VARCHAR2(4000 CHAR),  
	"PREJEMNIK_BCC" VARCHAR2(4000 CHAR),  
	"PREJEMNIK" CLOB,  
	"TEKST" CLOB,  
	"MESSAGE_ID" VARCHAR2(250 CHAR),  
	"DATUM_PREJEMA" DATE,  
	"PREBRANO" VARCHAR2(1 CHAR),  
	"STATUS_MESSAGE" VARCHAR2(2000 CHAR),  
	"CONTENT_HASH" VARCHAR2(50 CHAR),  
	"CHECKED_ERROR" VARCHAR2(1 CHAR),  
	"REFERENCE_ID" NUMBER,  
	"REFERENCE_TABLE" VARCHAR2(40 CHAR),  
	"CONTENT_FILE_NAME" VARCHAR2(30 CHAR),  
	"CONTENT_FILE_REFERENCE" VARCHAR2(20 CHAR),  
	"UNIQUE_ID" NUMBER,  
	 CONSTRAINT "PK_EMAILS" PRIMARY KEY ("ID_EMAIL")
) ;


 CREATE TABLE "PAYMENT_LINK"  
   (	"ID" NUMBER NOT NULL ENABLE,  
	"ID_SALDKONT" NUMBER,  
	"LINK" VARCHAR2(1000 CHAR),  
	"LINK_REFERENCE_ID" VARCHAR2(50 CHAR),  
	"UNIQUE_CODE" VARCHAR2(100 CHAR),  
	"PRODUCT" VARCHAR2(250 CHAR),  
	"AMOUNT" NUMBER,  
	"CURRENCY" VARCHAR2(10 CHAR),  
	"EXPIRY" DATE,  
	"DATE_CREATED" DATE,  
	"USER_CREATED" VARCHAR2(250 CHAR),  
	"STATUS" NUMBER,  
	"ID_DN" NUMBER,  
	"TRANSACTION_ID" VARCHAR2(100 CHAR),  
	"CAPTURE" VARCHAR2(1 CHAR),  
	"ID_LASTNIKA" NUMBER,  
	"REQUEST_TYPE" VARCHAR2(30 CHAR),  
	"REQUEST_ID" VARCHAR2(100 CHAR),  
	"VOIDED" VARCHAR2(1 CHAR),  
	"PAGE_CONTENT" CLOB,  
	"CREDIT_CARD_ISSUER" VARCHAR2(20 CHAR),  
	"ID_RACUNA" NUMBER,  
	"TEMPORARY_CREDIT_CARD" VARCHAR2(1 CHAR),  
	"NNLOCATION_ID" NUMBER,  
	"COMMISSION_AMOUNT" NUMBER,  
	"ID_CARDS" VARCHAR2(3 CHAR),  
	"ID_POGODBE" NUMBER,  
	"CALLER_URL_ACTION" VARCHAR2(50 CHAR),  
	"ID_PLOVILA" NUMBER,  
	"APPLICATION_ID" VARCHAR2(3 CHAR),  
	"INTERNAL" VARCHAR2(1 CHAR),  
	"RESPONSE_MESSAGE" VARCHAR2(1000 CHAR),  
	"ID_PAYMENT_RESPONSE" NUMBER,  
	 CONSTRAINT "PAYMENT_LINK_PK" PRIMARY KEY ("ID") 
) ;


CREATE TABLE "FISCALLOG"  
   (	"IDFISCALLOG" NUMBER(*,0),  
	"ID_RACUN" NUMBER(*,0),  
	"TS" TIMESTAMP (6),  
	"IDPORUKE" VARCHAR2(36 CHAR),  
	"ZASTITNIKOD" VARCHAR2(32 CHAR),  
	"JIR" VARCHAR2(50 CHAR),  
	"ERRORCODE" VARCHAR2(30 CHAR),  
	"ERRORMSG" VARCHAR2(500 CHAR),  
	"STATUS" CHAR(1 CHAR),  
	"ID_SALDKONT_FISC" NUMBER,  
	"XML" CLOB,  
	"LOKAC" VARCHAR2(20 CHAR),  
	"BLAGAJNA" VARCHAR2(20 CHAR),  
	 CONSTRAINT "PK_FISCALLOG" PRIMARY KEY ("IDFISCALLOG") 
) ; 
  CREATE INDEX "FISCALLOG_IX1" ON "FISCALLOG" ("ID_SALDKONT_FISC") ; 
  CREATE INDEX "FISCALLOG_IX2" ON "FISCALLOG" ("TS", "STATUS")  ;

CREATE TABLE "DOCUMENT_FILES"  
   (	"ID_DOC_FILES" NUMBER NOT NULL ENABLE,  
	"TABLENAME" VARCHAR2(200 CHAR) NOT NULL ENABLE,  
	"ID_MASTER" NUMBER NOT NULL ENABLE,  
	"USER_COMMENT" VARCHAR2(250 CHAR),  
	"USER_CREATE" VARCHAR2(30 CHAR),  
	"DATE_CREATE" DATE,  
	"FILENAME" VARCHAR2(200 CHAR),  
	"FILEDATA" BLOB,  
	"STATUS" NUMBER,  
	"TYPE" NUMBER,  
	"FILE_REFERENCE" VARCHAR2(20 CHAR),  
	"ID" VARCHAR2(100 CHAR),  
	 CONSTRAINT "PK_DOCUMENT_FILES" PRIMARY KEY ("ID_DOC_FILES")) ; 
  CREATE INDEX "IX_DOCUMENT_FILES1" ON "DOCUMENT_FILES" ("TABLENAME", "ID_MASTER") ;