Fix wso2/product-is#2879: Oracle Rac scripts issues in IS 5.5.0
@@ -130,7 +130,7 @@ CREATE TABLE IDN_OAUTH2_SCOPE (
NAME VARCHAR2(255) NOT NULL,
DISPLAY_NAME VARCHAR2(255) NOT NULL,
DESCRIPTION VARCHAR2(512),
- TENANT_ID INTEGER NOT NULL DEFAULT -1,
+ TENANT_ID INTEGER DEFAULT -1 NOT NULL,
PRIMARY KEY (SCOPE_ID))
/
CREATE SEQUENCE IDN_OAUTH2_SCOPE_SEQUENCE START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
@@ -444,7 +444,7 @@ CREATE TABLE SP_PROVISIONING_CONNECTOR (
APP_ID INTEGER NOT NULL,
IS_JIT_ENABLED CHAR(1) DEFAULT '0',
BLOCKING CHAR(1) DEFAULT '0',
- RULE_ENABLED CHAR(1) NOT NULL DEFAULT '0',
+ RULE_ENABLED CHAR(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (ID))
/
CREATE SEQUENCE SP_PROV_CONNECTOR_SEQ START WITH 1 INCREMENT BY 1 CACHE 20 ORDER
@@ -900,11 +900,11 @@ CREATE TABLE IDN_RECOVERY_DATA (
CODE VARCHAR2(255) NOT NULL,
SCENARIO VARCHAR2(255) NOT NULL,
STEP VARCHAR2(127) NOT NULL,
- TIME_CREATED TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
- REMAINING_SETS VARCHAR2(2500) DEFAULT NULL),
+ TIME_CREATED TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
+ REMAINING_SETS VARCHAR2(2500) DEFAULT NULL,
PRIMARY KEY(USER_NAME, USER_DOMAIN, TENANT_ID, SCENARIO,STEP),
UNIQUE(CODE)
-
+)
/
CREATE TABLE IDN_PASSWORD_HISTORY_DATA (
ID INTEGER,
@@ -1065,7 +1065,7 @@ CREATE OR REPLACE TRIGGER IDN_SAML2_ASSERTION_STORE_TRIG
CREATE TABLE IDN_OIDC_JTI (
JWT_ID VARCHAR(255) ,
EXP_TIME TIMESTAMP NOT NULL,
- TIME_CREATED TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ TIME_CREATED TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
PRIMARY KEY (JWT_ID))
/
