Fix oracle_rac script errors
@@ -553,7 +553,7 @@ CREATE TABLE SP_TEMPLATE (
DESCRIPTION VARCHAR(1023),
CONTENT BLOB DEFAULT NULL,
PRIMARY KEY (ID),
- CONSTRAINT SP_TEMPLATE_CONSTRAINT UNIQUE (TENANT_ID, NAME))
+ CONSTRAINT SP_TEMPLATE_CONSTRAINT UNIQUE (TENANT_ID, NAME)
)
/
CREATE SEQUENCE SP_TEMPLATE_SEQ START WITH 1 INCREMENT BY 1 NOCACHE
@@ -573,7 +573,7 @@ CREATE TABLE IDN_AUTH_WAIT_STATUS (
ID INTEGER NOT NULL,
TENANT_ID INTEGER NOT NULL,
LONG_WAIT_KEY VARCHAR(255) NOT NULL,
- WAIT_STATUS CHAR(1) NOT NULL DEFAULT '1',
+ WAIT_STATUS CHAR(1) DEFAULT '1' NOT NULL,
TIME_CREATED TIMESTAMP,
EXPIRE_TIME TIMESTAMP,
PRIMARY KEY (ID),
@@ -1323,8 +1323,8 @@ CREATE TABLE IDN_OIDC_SCOPE_CLAIM_MAPPING (
SCOPE_ID INTEGER,
EXTERNAL_CLAIM_ID INTEGER,
PRIMARY KEY (ID),
- FOREIGN KEY (SCOPE_ID) REFERENCES IDN_CLAIM(ID) ON DELETE CASCADE,
- FOREIGN KEY (EXTERNAL_CLAIM_ID) REFERENCES IDN_OIDC_SCOPE(ID) ON DELETE CASCADE)
+ FOREIGN KEY (SCOPE_ID) REFERENCES IDN_OIDC_SCOPE(ID) ON DELETE CASCADE,
+ FOREIGN KEY (EXTERNAL_CLAIM_ID) REFERENCES IDN_CLAIM(ID) ON DELETE CASCADE)
/
CREATE SEQUENCE IDN_OIDC_SCOPE_CLAIM_MAP_SEQ START WITH 1 INCREMENT BY 1 NOCACHE
/
