-- ABS-65154 / ABS-83420

-------------- SECURITYCERTIFICATE ----------------

CREATE SEQUENCE SEQ_SECURITYCERTIFICATE
START WITH 1 
INCREMENT BY 1;

CREATE TABLE SECURITYCERTIFICATE 
(
  SECURITYCERTIFICATE_ID NUMBER NOT NULL,
  CERTIFICATE BLOB NOT NULL,
  SYSTEMUSER_ID NUMBER DEFAULT 0 NOT NULL,
  TIMESTAMP DATE DEFAULT SYSDATE NOT NULL
);

ALTER TABLE SECURITYCERTIFICATE ADD CONSTRAINT XPK_SECURITYCERTIFICATE PRIMARY KEY (SECURITYCERTIFICATE_ID);