Resolves issue 4880
@@ -64,6 +64,11 @@ CREATE TABLE IDN_OAUTH1A_ACCESS_TOKEN (
PRIMARY KEY (ACCESS_TOKEN),
FOREIGN KEY (CONSUMER_KEY_ID) REFERENCES IDN_OAUTH_CONSUMER_APPS(ID) ON DELETE CASCADE)
/
+CREATE BUFFERPOOL BP32K IMMEDIATE SIZE 250 AUTOMATIC PAGESIZE 32K
+/
+CREATE LARGE TABLESPACE TS32K PAGESIZE 32K MANAGED by AUTOMATIC
+STORAGE BUFFERPOOL BP32K
+/
CREATE TABLE IDN_OAUTH2_ACCESS_TOKEN (
TOKEN_ID VARCHAR (255) NOT NULL,
ACCESS_TOKEN VARCHAR (2048) NOT NULL,
@@ -87,7 +92,7 @@ CREATE TABLE IDN_OAUTH2_ACCESS_TOKEN (
PRIMARY KEY (TOKEN_ID),
FOREIGN KEY (CONSUMER_KEY_ID) REFERENCES IDN_OAUTH_CONSUMER_APPS(ID) ON DELETE CASCADE,
CONSTRAINT CON_APP_KEY UNIQUE (CONSUMER_KEY_ID,AUTHZ_USER,TENANT_ID,USER_DOMAIN,USER_TYPE,TOKEN_SCOPE_HASH,
- TOKEN_STATE,TOKEN_STATE_ID))
+ TOKEN_STATE,TOKEN_STATE_ID)) INDEX IN TS32K
/
CREATE TABLE IDN_OAUTH2_ACCESS_TOKEN_AUDIT (
@@ -112,7 +117,6 @@ CREATE TABLE IDN_OAUTH2_ACCESS_TOKEN_AUDIT (
REFRESH_TOKEN_HASH VARCHAR(512),
INVALIDATED_TIME TIMESTAMP NULL)
/
-
CREATE TABLE IDN_OAUTH2_AUTHORIZATION_CODE (
CODE_ID VARCHAR (255) NOT NULL,
AUTHORIZATION_CODE VARCHAR (2048) NOT NULL,
@@ -132,6 +136,7 @@ CREATE TABLE IDN_OAUTH2_AUTHORIZATION_CODE (
AUTHORIZATION_CODE_HASH VARCHAR (512),
PRIMARY KEY (CODE_ID),
FOREIGN KEY (CONSUMER_KEY_ID) REFERENCES IDN_OAUTH_CONSUMER_APPS(ID) ON DELETE CASCADE)
+ INDEX IN TS32K
/
CREATE TABLE IDN_OAUTH2_ACCESS_TOKEN_SCOPE (
@@ -173,14 +178,6 @@ CREATE TABLE IDN_OAUTH2_RESOURCE_SCOPE (
PRIMARY KEY (RESOURCE_PATH),
FOREIGN KEY (SCOPE_ID) REFERENCES IDN_OAUTH2_SCOPE (SCOPE_ID) ON DELETE CASCADE)
/
-
-CREATE BUFFERPOOL BP32K IMMEDIATE SIZE 250 AUTOMATIC PAGESIZE 32K
-/
-
-CREATE LARGE TABLESPACE TS32K PAGESIZE 32K MANAGED by AUTOMATIC
-STORAGE BUFFERPOOL BP32K
-/
-
CREATE TABLE IDN_SCIM_GROUP (
ID INTEGER NOT NULL,
TENANT_ID INTEGER NOT NULL,
@@ -450,7 +447,6 @@ CREATE TRIGGER SP_CLAIM_DIALECT_TRIG NO CASCADE
/
ALTER TABLE SP_CLAIM_DIALECT ADD CONSTRAINT DIALECTID_APPID_CONSTRAINT FOREIGN KEY (APP_ID) REFERENCES SP_APP (ID) ON DELETE CASCADE
/
-
CREATE TABLE SP_CLAIM_MAPPING (
ID INTEGER NOT NULL,
TENANT_ID INTEGER NOT NULL,
