text: DROP INDEX IF EXISTS IDX_AT_TI_UD;
  DROP INDEX IF EXISTS IDX_AUTHORIZATION_CODE_AU_TI;
  DROP INDEX IF EXISTS IDX_IDN_SCIM_GROUP_TI_RN;
  DROP INDEX IF EXISTS IDX_IDN_SCIM_GROUP_TI_RN_AN;
  DROP INDEX IF EXISTS IDX_IDN_AUTH_SESSION_TIME;
  DROP INDEX IF EXISTS IDX_IDN_AUTH_TMP_SESSION_TIME;
  
  ALTER TABLE IDN_OAUTH_CONSUMER_APPS ADD ID_TOKEN_EXPIRE_TIME BIGINT DEFAULT 3600;
  
  DROP TABLE IF EXISTS IDN_AUTH_TEMP_SESSION_STORE;
  CREATE TABLE IDN_AUTH_TEMP_SESSION_STORE (
              SESSION_ID VARCHAR(100) NOT NULL,
              SESSION_TYPE VARCHAR(100) NOT NULL,
              OPERATION VARCHAR(10) NOT NULL,
              SESSION_OBJECT BYTEA,
              TIME_CREATED BIGINT,
              TENANT_ID INTEGER DEFAULT -1,
              EXPIRY_TIME BIGINT,
              PRIMARY KEY (SESSION_ID, SESSION_TYPE, TIME_CREATED, OPERATION)
  );
  ALTER TABLE IDN_AUTH_SESSION_STORE ADD EXPIRY_TIME BIGINT;
  
  CREATE INDEX IDX_AT_TI_UD ON IDN_OAUTH2_ACCESS_TOKEN(AUTHZ_USER, TENANT_ID, TOKEN_STATE, USER_DOMAIN);
  
  CREATE INDEX IDX_AUTHORIZATION_CODE_AU_TI ON IDN_OAUTH2_AUTHORIZATION_CODE (AUTHZ_USER,TENANT_ID, USER_DOMAIN, STATE);
  
  CREATE INDEX IDX_IDN_SCIM_GROUP_TI_RN ON IDN_SCIM_GROUP (TENANT_ID, ROLE_NAME);
  
  CREATE INDEX IDX_IDN_SCIM_GROUP_TI_RN_AN ON IDN_SCIM_GROUP (TENANT_ID, ROLE_NAME, ATTR_NAME);
  
  CREATE INDEX IDX_IDN_AUTH_SESSION_TIME ON IDN_AUTH_SESSION_STORE (TIME_CREATED);
  
  CREATE INDEX IDX_IDN_AUTH_TMP_SESSION_TIME ON IDN_AUTH_TEMP_SESSION_STORE (TIME_CREATED);
  