Fixing DB2 Identity script errors.
@@ -463,7 +463,7 @@ CREATE TABLE SP_AUTH_SCRIPT (
APP_ID INTEGER NOT NULL,
TYPE VARCHAR(255) NOT NULL,
CONTENT BLOB DEFAULT NULL,
- IS_ENABLED BOOLEAN DEFAULT FALSE,
+ IS_ENABLED CHAR(1) DEFAULT '0',
PRIMARY KEY (ID))
/
CREATE SEQUENCE SP_AUTH_SCRIPT_SEQ START WITH 1 INCREMENT BY 1 NOCACHE
@@ -1058,7 +1058,7 @@ CREATE TRIGGER IDN_SAML2_ASSERTION_STORE_TRIG NO CASCADE
CREATE TABLE IDN_OIDC_JTI (
JWT_ID VARCHAR(255) NOT NULL,
EXP_TIME TIMESTAMP NOT NULL,
- TIME_CREATED NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ TIME_CREATED TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (JWT_ID))
/
@@ -1111,11 +1111,11 @@ CREATE TABLE IDN_OIDC_REQ_OBJECT_CLAIMS (
ID INTEGER NOT NULL,
REQ_OBJECT_ID INTEGER ,
CLAIM_ATTRIBUTE VARCHAR(255),
- ESSENTIAL BOOLEAN ,
+ ESSENTIAL CHAR (1),
VALUE VARCHAR(255),
- IS_USERINFO BOOLEAN,
+ IS_USERINFO CHAR (1),
PRIMARY KEY (ID),
- FOREIGN KEY (REQ_OBJECT_ID) REFERENCES IIDN_OIDC_REQ_OBJECT_REFERENCE(ID) ON DELETE CASCADE)
+ FOREIGN KEY (REQ_OBJECT_ID) REFERENCES IDN_OIDC_REQ_OBJECT_REFERENCE(ID) ON DELETE CASCADE)
/
CREATE SEQUENCE IDN_OIDC_REQ_OBJECT_CLAIMS_SEQ START WITH 1 INCREMENT BY 1 NOCACHE
/
@@ -1125,7 +1125,7 @@ CREATE TRIGGER IDN_OIDC_REQ_OBJECT_CLAIMS_TRIG NO CASCADE
REFERENCING NEW AS NEW
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
- SET (NEW.ID) = (NEXTVAL FOR IDN_OIDC_REQUEST_OBJECT_CLAIMS_SEQ);
+ SET (NEW.ID) = (NEXTVAL FOR IDN_OIDC_REQ_OBJECT_CLAIMS_SEQ);
END
/
@@ -1150,9 +1150,9 @@ CREATE TRIGGER IDN_OIDC_REQ_OBJECT_CLAIM_VALUES_TRIG
CREATE TABLE IDN_CERTIFICATE (
ID INTEGER NOT NULL,
- NAME VARCHAR(100),
- CERTIFICATE_IN_PEM VARCHAR(40960),
- TENANT_ID INTEGER DEFAULT 0,
+ NAME VARCHAR(100) NOT NULL,
+ CERTIFICATE_IN_PEM BLOB,
+ TENANT_ID INTEGER NOT NULL,
CONSTRAINT CERTIFICATE_UNIQUE_KEY UNIQUE (NAME, TENANT_ID),
PRIMARY KEY (ID))
/
