ALTER TABLE "GRC2"."SEAL_DOMAIN_WAS_BLACKLIST" ADD CONSTRAINT "SEAL_DOMAIN_WAS_BLACKLIST_FK1" FOREIGN KEY ("EXCEPTION_REQUESTOR_ID")
	  REFERENCES "GRC2"."USER_LOCAL" ("ID") ON DELETE SET NULL ENABLE;


ALTER TABLE SEAL_DOMAIN_WAS_BLACKLIST
add(

EXCEPTION_STATUS 	VARCHAR(200) DEFAULT NULL,
EXCEPTION_EXP_DATE 	DATE DEFAULT NULL,
EXCEPTION_REASON	VARCHAR(500) DEFAULT NULL,
EXCEPTION_RESPONSE	VARCHAR(500) DEFAULT NULL,
EXCEPTION_REQ_DATE  DATE DEFAULT NULL,
EXCEPTION_RESP_DATE DATE DEFAULT NULL,

EXCEPTION_REQUESTOR_ID NUMBER(38,0)

);

CREATE INDEX SEAL_DOMAIN_WAS_BLACKLIST_IX2
ON SEAL_DOMAIN_WAS_BLACKLIST (EXCEPTION_STATUS);

 ALTER TABLE "SEAL_DOMAIN_WAS_BLACKLIST"
 ADD CONSTRAINT "SEAL_DOMAIN_WAS_BLACKLIST_FK1" FOREIGN KEY ("EXCEPTION_REQUESTOR_ID")
	  REFERENCES "USER_LOCAL" ("ID") ON DELETE SET NULL ENABLE;