-- *********************************************************************
-- * Keycloak database creation script - apply this script to empty DB *
-- *********************************************************************

CREATE TABLE DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255));

-- *********************************************************************

-- *********************************************************************
-- Update Database Script
-- *********************************************************************
-- Change Log: META-INF/jpa-changelog-master.xml
-- Ran at: 10/25/17 3:46 PM
-- Against: @jdbc:ignite:thin://127.0.0.1
-- Liquibase version: 3.4.1
-- *********************************************************************

-- Changeset META-INF/jpa-changelog-1.0.0.Final.xml::1.0.0.Final::sthorger@redhat.com
CREATE TABLE APPLICATION_DEFAULT_ROLES (APPLICATION_ID VARCHAR(36) NOT NULL, ROLE_ID VARCHAR(36) NOT NULL);

CREATE TABLE CLIENT (DTYPE VARCHAR(31) NOT NULL, ID VARCHAR(36) NOT NULL, ALLOWED_CLAIMS_MASK BIGINT, ENABLED BOOLEAN DEFAULT FALSE NOT NULL, FULL_SCOPE_ALLOWED BOOLEAN DEFAULT FALSE NOT NULL, NAME VARCHAR(255), NOT_BEFORE INT, PUBLIC_CLIENT BOOLEAN DEFAULT FALSE NOT NULL, SECRET VARCHAR(255), BASE_URL VARCHAR(255), BEARER_ONLY BOOLEAN DEFAULT FALSE NOT NULL, MANAGEMENT_URL VARCHAR(255), SURROGATE_AUTH_REQUIRED BOOLEAN DEFAULT FALSE NOT NULL, DIRECT_GRANTS_ONLY BOOLEAN DEFAULT FALSE NOT NULL, REALM_ID VARCHAR(36));

CREATE TABLE CLIENT_SESSION (ID VARCHAR(36) NOT NULL, ACTION INT, CLIENT_ID VARCHAR(36), REDIRECT_URI VARCHAR(255), STATE VARCHAR(255), TIMESTAMP INT, SESSION_ID VARCHAR(36));

CREATE TABLE CLIENT_SESSION_ROLE (ROLE_ID VARCHAR(255) NOT NULL, CLIENT_SESSION VARCHAR(36) NOT NULL);

CREATE TABLE COMPOSITE_ROLE (COMPOSITE VARCHAR(36) NOT NULL, CHILD_ROLE VARCHAR(36) NOT NULL);

CREATE TABLE CREDENTIAL (ID VARCHAR(36) NOT NULL, DEVICE VARCHAR(255), HASH_ITERATIONS INT, SALT BLOB(16), TYPE VARCHAR(255), VALUE VARCHAR(255), USER_ID VARCHAR(36));

CREATE TABLE EVENT_ENTITY (ID VARCHAR(36) NOT NULL, CLIENT_ID VARCHAR(255), DETAILS_JSON VARCHAR(2550), ERROR VARCHAR(255), IP_ADDRESS VARCHAR(255), REALM_ID VARCHAR(255), SESSION_ID VARCHAR(255), TIME BIGINT, TYPE VARCHAR(255), USER_ID VARCHAR(255));

CREATE TABLE FED_PROVIDERS (REALM_ID VARCHAR(36) NOT NULL, USERFEDERATIONPROVIDERS_ID VARCHAR(36) NOT NULL);

CREATE TABLE KEYCLOAK_ROLE (ID VARCHAR(36) NOT NULL, APP_REALM_CONSTRAINT VARCHAR(36), APPLICATION_ROLE BOOLEAN DEFAULT FALSE NOT NULL, DESCRIPTION VARCHAR(255), NAME VARCHAR(255), REALM_ID VARCHAR(255), APPLICATION VARCHAR(36), REALM VARCHAR(36));

CREATE TABLE REALM (ID VARCHAR(36) NOT NULL, ACCESS_CODE_LIFESPAN INT, USER_ACTION_LIFESPAN INT, ACCESS_TOKEN_LIFESPAN INT, ACCOUNT_THEME VARCHAR(255), ADMIN_THEME VARCHAR(255), EMAIL_THEME VARCHAR(255), ENABLED BOOLEAN DEFAULT FALSE NOT NULL, EVENTS_ENABLED BOOLEAN DEFAULT FALSE NOT NULL, EVENTS_EXPIRATION BIGINT, LOGIN_THEME VARCHAR(255), NAME VARCHAR(255), NOT_BEFORE INT, PASSWORD_CRED_GRANT_ALLOWED BOOLEAN DEFAULT FALSE NOT NULL, PASSWORD_POLICY VARCHAR(255), PRIVATE_KEY VARCHAR(2048), PUBLIC_KEY VARCHAR(2048), REGISTRATION_ALLOWED BOOLEAN DEFAULT FALSE NOT NULL, REMEMBER_ME BOOLEAN DEFAULT FALSE NOT NULL, RESET_PASSWORD_ALLOWED BOOLEAN DEFAULT FALSE NOT NULL, SOCIAL BOOLEAN DEFAULT FALSE NOT NULL, SSL_REQUIRED VARCHAR(255), SSO_IDLE_TIMEOUT INT, SSO_MAX_LIFESPAN INT, UPDATE_PROFILE_ON_SOC_LOGIN BOOLEAN DEFAULT FALSE NOT NULL, VERIFY_EMAIL BOOLEAN DEFAULT FALSE NOT NULL, MASTER_ADMIN_APP VARCHAR(36));

CREATE TABLE REALM_APPLICATION (APPLICATION_ID VARCHAR(36) NOT NULL, REALM_ID VARCHAR(36) NOT NULL);

CREATE TABLE REALM_ATTRIBUTE (NAME VARCHAR(255) NOT NULL, VALUE VARCHAR(255), REALM_ID VARCHAR(36) NOT NULL);

CREATE TABLE REALM_DEFAULT_ROLES (REALM_ID VARCHAR(36) NOT NULL, ROLE_ID VARCHAR(36) NOT NULL);

CREATE TABLE REALM_EVENTS_LISTENERS (REALM_ID VARCHAR(36) NOT NULL, VALUE VARCHAR(255));

CREATE TABLE REALM_REQUIRED_CREDENTIAL (TYPE VARCHAR(255) NOT NULL, FORM_LABEL VARCHAR(255), INPUT BOOLEAN DEFAULT FALSE NOT NULL, SECRET BOOLEAN DEFAULT FALSE NOT NULL, REALM_ID VARCHAR(36) NOT NULL);

CREATE TABLE REALM_SMTP_CONFIG (REALM_ID VARCHAR(36) NOT NULL, VALUE VARCHAR(255), NAME VARCHAR(255) NOT NULL);

CREATE TABLE REALM_SOCIAL_CONFIG (REALM_ID VARCHAR(36) NOT NULL, VALUE VARCHAR(255), NAME VARCHAR(255) NOT NULL);

CREATE TABLE REDIRECT_URIS (CLIENT_ID VARCHAR(36) NOT NULL, VALUE VARCHAR(255));

CREATE TABLE SCOPE_MAPPING (CLIENT_ID VARCHAR(36) NOT NULL, ROLE_ID VARCHAR(36) NOT NULL);

CREATE TABLE USERNAME_LOGIN_FAILURE (REALM_ID VARCHAR(36) NOT NULL, USERNAME VARCHAR(200) NOT NULL, FAILED_LOGIN_NOT_BEFORE INT, LAST_FAILURE BIGINT, LAST_IP_FAILURE VARCHAR(255), NUM_FAILURES INT);

CREATE TABLE USER_ATTRIBUTE (NAME VARCHAR(255) NOT NULL, VALUE VARCHAR(255), USER_ID VARCHAR(36) NOT NULL);

CREATE TABLE USER_ENTITY (ID VARCHAR(36) NOT NULL, EMAIL VARCHAR(255), EMAIL_CONSTRAINT VARCHAR(255), EMAIL_VERIFIED BOOLEAN DEFAULT FALSE NOT NULL, ENABLED BOOLEAN DEFAULT FALSE NOT NULL, FEDERATION_LINK VARCHAR(255), FIRST_NAME VARCHAR(255), LAST_NAME VARCHAR(255), REALM_ID VARCHAR(255), TOTP BOOLEAN DEFAULT FALSE NOT NULL, USERNAME VARCHAR(255));

CREATE TABLE USER_FEDERATION_CONFIG (USER_FEDERATION_PROVIDER_ID VARCHAR(36) NOT NULL, VALUE VARCHAR(255), NAME VARCHAR(255) NOT NULL);

CREATE TABLE USER_FEDERATION_PROVIDER (ID VARCHAR(36) NOT NULL, CHANGED_SYNC_PERIOD INT, DISPLAY_NAME VARCHAR(255), FULL_SYNC_PERIOD INT, LAST_SYNC INT, PRIORITY INT, PROVIDER_NAME VARCHAR(255), REALM_ID VARCHAR(36));

CREATE TABLE USER_REQUIRED_ACTION (ACTION INT NOT NULL, USER_ID VARCHAR(36) NOT NULL);

CREATE TABLE USER_ROLE_MAPPING (ROLE_ID VARCHAR(255) NOT NULL, USER_ID VARCHAR(36) NOT NULL);

CREATE TABLE USER_SESSION (ID VARCHAR(36) NOT NULL, AUTH_METHOD VARCHAR(255), IP_ADDRESS VARCHAR(255), LAST_SESSION_REFRESH INT, LOGIN_USERNAME VARCHAR(255), REALM_ID VARCHAR(255), REMEMBER_ME BOOLEAN DEFAULT FALSE NOT NULL, STARTED INT, USER_ID VARCHAR(255));

CREATE TABLE USER_SOCIAL_LINK (SOCIAL_PROVIDER VARCHAR(255) NOT NULL, REALM_ID VARCHAR(255), SOCIAL_USER_ID VARCHAR(255), SOCIAL_USERNAME VARCHAR(255), USER_ID VARCHAR(36) NOT NULL);

CREATE TABLE WEB_ORIGINS (CLIENT_ID VARCHAR(36) NOT NULL, VALUE VARCHAR(255));

ALTER TABLE REALM_SOCIAL_CONFIG ADD CONSTRAINT CONSTRAINT_1 PRIMARY KEY (REALM_ID, NAME);

ALTER TABLE USERNAME_LOGIN_FAILURE ADD CONSTRAINT CONSTRAINT_17 PRIMARY KEY (REALM_ID, USERNAME);

ALTER TABLE USER_REQUIRED_ACTION ADD CONSTRAINT CONSTRAINT_2 PRIMARY KEY (ACTION, USER_ID);

ALTER TABLE USER_SOCIAL_LINK ADD CONSTRAINT CONSTRAINT_3 PRIMARY KEY (SOCIAL_PROVIDER, USER_ID);

ALTER TABLE EVENT_ENTITY ADD CONSTRAINT CONSTRAINT_4 PRIMARY KEY (ID);

ALTER TABLE REALM ADD CONSTRAINT CONSTRAINT_4A PRIMARY KEY (ID);

ALTER TABLE CLIENT_SESSION_ROLE ADD CONSTRAINT CONSTRAINT_5 PRIMARY KEY (CLIENT_SESSION, ROLE_ID);

ALTER TABLE USER_SESSION ADD CONSTRAINT CONSTRAINT_57 PRIMARY KEY (ID);

ALTER TABLE USER_FEDERATION_PROVIDER ADD CONSTRAINT CONSTRAINT_5C PRIMARY KEY (ID);

ALTER TABLE USER_ATTRIBUTE ADD CONSTRAINT CONSTRAINT_6 PRIMARY KEY (NAME, USER_ID);

ALTER TABLE CLIENT ADD CONSTRAINT CONSTRAINT_7 PRIMARY KEY (ID);

ALTER TABLE CLIENT_SESSION ADD CONSTRAINT CONSTRAINT_8 PRIMARY KEY (ID);

ALTER TABLE SCOPE_MAPPING ADD CONSTRAINT CONSTRAINT_81 PRIMARY KEY (CLIENT_ID, ROLE_ID);

ALTER TABLE REALM_ATTRIBUTE ADD CONSTRAINT CONSTRAINT_9 PRIMARY KEY (NAME, REALM_ID);

ALTER TABLE REALM_REQUIRED_CREDENTIAL ADD CONSTRAINT CONSTRAINT_92 PRIMARY KEY (REALM_ID, TYPE);

ALTER TABLE KEYCLOAK_ROLE ADD CONSTRAINT CONSTRAINT_A PRIMARY KEY (ID);

ALTER TABLE USER_ROLE_MAPPING ADD CONSTRAINT CONSTRAINT_C PRIMARY KEY (ROLE_ID, USER_ID);

ALTER TABLE REALM_SMTP_CONFIG ADD CONSTRAINT CONSTRAINT_E PRIMARY KEY (REALM_ID, NAME);

ALTER TABLE CREDENTIAL ADD CONSTRAINT CONSTRAINT_F PRIMARY KEY (ID);

ALTER TABLE USER_FEDERATION_CONFIG ADD CONSTRAINT CONSTRAINT_F9 PRIMARY KEY (USER_FEDERATION_PROVIDER_ID, NAME);

ALTER TABLE USER_ENTITY ADD CONSTRAINT CONSTRAINT_FB PRIMARY KEY (ID);

ALTER TABLE APPLICATION_DEFAULT_ROLES ADD CONSTRAINT UK_8AELWNIBJI49AVXSRTUF6XJOW UNIQUE (ROLE_ID);

ALTER TABLE CLIENT ADD CONSTRAINT UK_B71CJLBENV945RB6GCON438AT UNIQUE (REALM_ID, NAME);

ALTER TABLE FED_PROVIDERS ADD CONSTRAINT UK_DCCIRJLIPU1478VQC89DID88C UNIQUE (USERFEDERATIONPROVIDERS_ID);

ALTER TABLE USER_ENTITY ADD CONSTRAINT UK_DYKN684SL8UP1CRFEI6ECKHD7 UNIQUE (REALM_ID, EMAIL_CONSTRAINT);

ALTER TABLE REALM_DEFAULT_ROLES ADD CONSTRAINT UK_H4WPD7W4HSOOLNI3H0SW7BTJE UNIQUE (ROLE_ID);

ALTER TABLE KEYCLOAK_ROLE ADD CONSTRAINT UK_J3RWUVD56ONTGSUHOGM184WW2 UNIQUE (NAME, APP_REALM_CONSTRAINT);

ALTER TABLE REALM_APPLICATION ADD CONSTRAINT UK_L5QGA3RFME47335JY8JXYXH3I UNIQUE (REALM_ID);

ALTER TABLE REALM ADD CONSTRAINT UK_ORVSDMLA56612EAEFIQ6WL5OI UNIQUE (NAME);

ALTER TABLE USER_ENTITY ADD CONSTRAINT UK_RU8TT6T700S9V50BU18WS5HA6 UNIQUE (REALM_ID, USERNAME);

ALTER TABLE CLIENT_SESSION_ROLE ADD CONSTRAINT FK_11B7SGQW18I532811V7O2DV76 FOREIGN KEY (CLIENT_SESSION) REFERENCES CLIENT_SESSION (ID);

ALTER TABLE REDIRECT_URIS ADD CONSTRAINT FK_1BURS8PB4OUJ97H5WUPPAHV9F FOREIGN KEY (CLIENT_ID) REFERENCES CLIENT (ID);

ALTER TABLE USER_FEDERATION_PROVIDER ADD CONSTRAINT FK_1FJ32F6PTOLW2QY60CD8N01E8 FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE FED_PROVIDERS ADD CONSTRAINT FK_213LYQ09FKXQ8K8NY8DY3737T FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE REALM_REQUIRED_CREDENTIAL ADD CONSTRAINT FK_5HG65LYBEVAVKQFKI3KPONH9V FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE USER_ATTRIBUTE ADD CONSTRAINT FK_5HRM2VLF9QL5FU043KQEPOVBR FOREIGN KEY (USER_ID) REFERENCES USER_ENTITY (ID);

ALTER TABLE USER_SOCIAL_LINK ADD CONSTRAINT FK_68CJYS5UWM55UY823Y75XG4OM FOREIGN KEY (USER_ID) REFERENCES USER_ENTITY (ID);

ALTER TABLE USER_REQUIRED_ACTION ADD CONSTRAINT FK_6QJ3W1JW9CVAFHE19BWSIUVMD FOREIGN KEY (USER_ID) REFERENCES USER_ENTITY (ID);

ALTER TABLE KEYCLOAK_ROLE ADD CONSTRAINT FK_6VYQFE4CN4WLQ8R6KT5VDSJ5C FOREIGN KEY (REALM) REFERENCES REALM (ID);

ALTER TABLE REALM_SMTP_CONFIG ADD CONSTRAINT FK_70EJ8XDXGXD0B9HH6180IRR0O FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE REALM_APPLICATION ADD CONSTRAINT FK_71S3P0DIUXAWWQQSA528UBY2Q FOREIGN KEY (APPLICATION_ID) REFERENCES REALM (ID);

ALTER TABLE APPLICATION_DEFAULT_ROLES ADD CONSTRAINT FK_8AELWNIBJI49AVXSRTUF6XJOW FOREIGN KEY (ROLE_ID) REFERENCES KEYCLOAK_ROLE (ID);

ALTER TABLE REALM_ATTRIBUTE ADD CONSTRAINT FK_8SHXD6L3E9ATQUKACXGPFFPTW FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE COMPOSITE_ROLE ADD CONSTRAINT FK_A63WVEKFTU8JO1PNJ81E7MCE2 FOREIGN KEY (COMPOSITE) REFERENCES KEYCLOAK_ROLE (ID);

ALTER TABLE CLIENT_SESSION ADD CONSTRAINT FK_B4AO2VCVAT6UKAU74WBWTFQO1 FOREIGN KEY (SESSION_ID) REFERENCES USER_SESSION (ID);

ALTER TABLE USER_ROLE_MAPPING ADD CONSTRAINT FK_C4FQV34P1MBYLLOXANG7B1Q3L FOREIGN KEY (USER_ID) REFERENCES USER_ENTITY (ID);

ALTER TABLE FED_PROVIDERS ADD CONSTRAINT FK_DCCIRJLIPU1478VQC89DID88C FOREIGN KEY (USERFEDERATIONPROVIDERS_ID) REFERENCES USER_FEDERATION_PROVIDER (ID);

ALTER TABLE REALM_DEFAULT_ROLES ADD CONSTRAINT FK_EVUDB1PPW84OXFAX2DRS03ICC FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE COMPOSITE_ROLE ADD CONSTRAINT FK_GR7THLLB9LU8Q4VQA4524JJY8 FOREIGN KEY (CHILD_ROLE) REFERENCES KEYCLOAK_ROLE (ID);

ALTER TABLE REALM_DEFAULT_ROLES ADD CONSTRAINT FK_H4WPD7W4HSOOLNI3H0SW7BTJE FOREIGN KEY (ROLE_ID) REFERENCES KEYCLOAK_ROLE (ID);

ALTER TABLE REALM_EVENTS_LISTENERS ADD CONSTRAINT FK_H846O4H0W8EPX5NXEV9F5Y69J FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE REALM_APPLICATION ADD CONSTRAINT FK_L5QGA3RFME47335JY8JXYXH3I FOREIGN KEY (REALM_ID) REFERENCES CLIENT (ID);

ALTER TABLE WEB_ORIGINS ADD CONSTRAINT FK_LOJPHO213XCX4WNKOG82SSRFY FOREIGN KEY (CLIENT_ID) REFERENCES CLIENT (ID);

ALTER TABLE APPLICATION_DEFAULT_ROLES ADD CONSTRAINT FK_MAYLTS7KLWQW2H8M2B5JOYTKY FOREIGN KEY (APPLICATION_ID) REFERENCES CLIENT (ID);

ALTER TABLE SCOPE_MAPPING ADD CONSTRAINT FK_OUSE064PLMLR732LXJCN1Q5F1 FOREIGN KEY (CLIENT_ID) REFERENCES CLIENT (ID);

ALTER TABLE SCOPE_MAPPING ADD CONSTRAINT FK_P3RH9GRKU11KQFRS4FLTT7RNQ FOREIGN KEY (ROLE_ID) REFERENCES KEYCLOAK_ROLE (ID);

ALTER TABLE CLIENT ADD CONSTRAINT FK_P56CTINXXB9GSK57FO49F9TAC FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE CREDENTIAL ADD CONSTRAINT FK_PFYR0GLASQYL0DEI3KL69R6V0 FOREIGN KEY (USER_ID) REFERENCES USER_ENTITY (ID);

ALTER TABLE KEYCLOAK_ROLE ADD CONSTRAINT FK_PIMO5LE2C0RAL09FL8CM9WFW9 FOREIGN KEY (APPLICATION) REFERENCES CLIENT (ID);

ALTER TABLE REALM ADD CONSTRAINT FK_RSAF444KK6QRKMS7N56AIWQ5Y FOREIGN KEY (MASTER_ADMIN_APP) REFERENCES CLIENT (ID);

ALTER TABLE REALM_SOCIAL_CONFIG ADD CONSTRAINT FK_SV5I3C2TI7G0G922FGE683SOV FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE USER_FEDERATION_CONFIG ADD CONSTRAINT FK_T13HPU1J94R2EBPEKR39X5EU5 FOREIGN KEY (USER_FEDERATION_PROVIDER_ID) REFERENCES USER_FEDERATION_PROVIDER (ID);

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.0.0.Final', 'sthorger@redhat.com', 'META-INF/jpa-changelog-1.0.0.Final.xml', CURRENT_TIMESTAMP, 1, '7:00a57f7a6fb456639b34e62972e0ec02', 'createTable (x29), addPrimaryKey (x21), addUniqueConstraint (x9), addForeignKeyConstraint (x32)', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/db2-jpa-changelog-1.0.0.Final.xml::1.0.0.Final::sthorger@redhat.com
INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.0.0.Final', 'sthorger@redhat.com', 'META-INF/db2-jpa-changelog-1.0.0.Final.xml', CURRENT_TIMESTAMP, 2, '7:f061c3934594ee60a9b2343f5100ae4e', 'createTable (x29), addPrimaryKey (x21), addUniqueConstraint (x6), addForeignKeyConstraint (x30)', '', 'MARK_RAN', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-1.1.0.Beta1.xml::1.1.0.Beta1::sthorger@redhat.com
DELETE FROM CLIENT_SESSION_ROLE;

DELETE FROM CLIENT_SESSION;

DELETE FROM USER_SESSION;

CREATE TABLE CLIENT_ATTRIBUTES (CLIENT_ID VARCHAR(36) NOT NULL, VALUE VARCHAR(2048), NAME VARCHAR(255) NOT NULL);

CREATE TABLE CLIENT_SESSION_NOTE (NAME VARCHAR(255) NOT NULL, VALUE VARCHAR(255), CLIENT_SESSION VARCHAR(36) NOT NULL);

CREATE TABLE APP_NODE_REGISTRATIONS (APPLICATION_ID VARCHAR(36) NOT NULL, VALUE INT, NAME VARCHAR(255) NOT NULL);

ALTER TABLE CLIENT_SESSION ADD AUTH_METHOD VARCHAR(255);

ALTER TABLE CLIENT ADD PROTOCOL VARCHAR(255);

ALTER TABLE CLIENT_SESSION ADD REALM_ID VARCHAR(255);

ALTER TABLE REALM ADD CERTIFICATE VARCHAR(2048);

ALTER TABLE REALM ADD CODE_SECRET VARCHAR(255);

ALTER TABLE CLIENT ADD NODE_REREG_TIMEOUT INT DEFAULT 0;

ALTER TABLE CLIENT_ATTRIBUTES ADD CONSTRAINT CONSTRAINT_3C PRIMARY KEY (CLIENT_ID, NAME);

ALTER TABLE CLIENT_SESSION_NOTE ADD CONSTRAINT CONSTRAINT_5E PRIMARY KEY (CLIENT_SESSION, NAME);

ALTER TABLE APP_NODE_REGISTRATIONS ADD CONSTRAINT CONSTRAINT_84 PRIMARY KEY (APPLICATION_ID, NAME);

ALTER TABLE CLIENT_ATTRIBUTES ADD CONSTRAINT FK3C47C64BEACCA966 FOREIGN KEY (CLIENT_ID) REFERENCES CLIENT (ID);

ALTER TABLE CLIENT_SESSION_NOTE ADD CONSTRAINT FK5EDFB00FF51C2736 FOREIGN KEY (CLIENT_SESSION) REFERENCES CLIENT_SESSION (ID);

ALTER TABLE APP_NODE_REGISTRATIONS ADD CONSTRAINT FK8454723BA992F594 FOREIGN KEY (APPLICATION_ID) REFERENCES CLIENT (ID);

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.1.0.Beta1', 'sthorger@redhat.com', 'META-INF/jpa-changelog-1.1.0.Beta1.xml', CURRENT_TIMESTAMP, 3, '7:0310eb8ba07cec616460794d42ade0fa', 'delete (x3), createTable (x3), addColumn (x5), addPrimaryKey (x3), addForeignKeyConstraint (x3), customChange', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-1.1.0.Final.xml::1.1.0.Final::sthorger@redhat.com
ALTER TABLE EVENT_ENTITY RENAME COLUMN TIME TO EVENT_TIME;

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.1.0.Final', 'sthorger@redhat.com', 'META-INF/jpa-changelog-1.1.0.Final.xml', CURRENT_TIMESTAMP, 4, '7:5d25857e708c3233ef4439df1f93f012', 'renameColumn', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-1.2.0.Beta1.xml::1.2.0.Beta1::psilva@redhat.com
DELETE FROM CLIENT_SESSION_ROLE;

DELETE FROM CLIENT_SESSION_NOTE;

DELETE FROM CLIENT_SESSION;

DELETE FROM USER_SESSION;

CREATE TABLE PROTOCOL_MAPPER (ID VARCHAR(36) NOT NULL, NAME VARCHAR(255) NOT NULL, PROTOCOL VARCHAR(255) NOT NULL, PROTOCOL_MAPPER_NAME VARCHAR(255) NOT NULL, CONSENT_REQUIRED BOOLEAN DEFAULT FALSE NOT NULL, CONSENT_TEXT VARCHAR(255), CLIENT_ID VARCHAR(36) NOT NULL);

CREATE TABLE PROTOCOL_MAPPER_CONFIG (PROTOCOL_MAPPER_ID VARCHAR(36) NOT NULL, VALUE CLOB, NAME VARCHAR(255) NOT NULL);

CREATE TABLE FEDERATED_IDENTITY (IDENTITY_PROVIDER VARCHAR(255) NOT NULL, REALM_ID VARCHAR(36), FEDERATED_USER_ID VARCHAR(255), FEDERATED_USERNAME VARCHAR(255), TOKEN CLOB, USER_ID VARCHAR(36) NOT NULL);

CREATE TABLE IDENTITY_PROVIDER (INTERNAL_ID VARCHAR(36) NOT NULL, ENABLED BOOLEAN DEFAULT FALSE NOT NULL, PROVIDER_ALIAS VARCHAR(255), PROVIDER_ID VARCHAR(255), UPDATE_PROFILE_FIRST_LOGIN BOOLEAN DEFAULT FALSE NOT NULL, STORE_TOKEN BOOLEAN DEFAULT FALSE NOT NULL, AUTHENTICATE_BY_DEFAULT BOOLEAN DEFAULT FALSE NOT NULL, REALM_ID VARCHAR(36));

CREATE TABLE IDENTITY_PROVIDER_CONFIG (IDENTITY_PROVIDER_ID VARCHAR(36) NOT NULL, VALUE CLOB, NAME VARCHAR(255) NOT NULL);

CREATE TABLE CLIENT_IDENTITY_PROV_MAPPING (CLIENT_ID VARCHAR(36) NOT NULL, IDENTITY_PROVIDER_ID VARCHAR(36) NOT NULL, RETRIEVE_TOKEN BOOLEAN DEFAULT FALSE NOT NULL);

CREATE TABLE REALM_SUPPORTED_LOCALES (REALM_ID VARCHAR(36) NOT NULL, VALUE VARCHAR(255));

CREATE TABLE USER_SESSION_NOTE (USER_SESSION VARCHAR(36) NOT NULL, NAME VARCHAR(255) NOT NULL, VALUE VARCHAR(2048));

ALTER TABLE CLIENT ADD FRONTCHANNEL_LOGOUT BOOLEAN NOT NULL DEFAULT FALSE;

ALTER TABLE USER_SESSION ADD USER_SESSION_STATE INT;

ALTER TABLE USER_SESSION ADD BROKER_SESSION_ID VARCHAR(255);

ALTER TABLE USER_SESSION ADD BROKER_USER_ID VARCHAR(255);

ALTER TABLE PROTOCOL_MAPPER ADD CONSTRAINT CONSTRAINT_PCM PRIMARY KEY (ID);

ALTER TABLE IDENTITY_PROVIDER ADD CONSTRAINT CONSTRAINT_2B PRIMARY KEY (INTERNAL_ID);

ALTER TABLE FEDERATED_IDENTITY ADD CONSTRAINT CONSTRAINT_40 PRIMARY KEY (IDENTITY_PROVIDER, USER_ID);

ALTER TABLE IDENTITY_PROVIDER_CONFIG ADD CONSTRAINT CONSTRAINT_D PRIMARY KEY (IDENTITY_PROVIDER_ID, NAME);

ALTER TABLE PROTOCOL_MAPPER_CONFIG ADD CONSTRAINT CONSTRAINT_PMConfig PRIMARY KEY (PROTOCOL_MAPPER_ID, NAME);

ALTER TABLE USER_SESSION_NOTE ADD CONSTRAINT CONSTRAINT_USN_PK PRIMARY KEY (USER_SESSION, NAME);

ALTER TABLE IDENTITY_PROVIDER ADD CONSTRAINT FK2B4EBC52AE5C3B34 FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE PROTOCOL_MAPPER ADD CONSTRAINT FK_PCM_REALM FOREIGN KEY (CLIENT_ID) REFERENCES CLIENT (ID);

ALTER TABLE FEDERATED_IDENTITY ADD CONSTRAINT FK404288B92EF007A6 FOREIGN KEY (USER_ID) REFERENCES USER_ENTITY (ID);

ALTER TABLE IDENTITY_PROVIDER_CONFIG ADD CONSTRAINT FKDC4897CF864C4E43 FOREIGN KEY (IDENTITY_PROVIDER_ID) REFERENCES IDENTITY_PROVIDER (INTERNAL_ID);

ALTER TABLE PROTOCOL_MAPPER_CONFIG ADD CONSTRAINT FK_PMConfig FOREIGN KEY (PROTOCOL_MAPPER_ID) REFERENCES PROTOCOL_MAPPER (ID);

ALTER TABLE CLIENT_IDENTITY_PROV_MAPPING ADD CONSTRAINT FK_7CELWNIBJI49AVXSRTUF6XJ12 FOREIGN KEY (IDENTITY_PROVIDER_ID) REFERENCES IDENTITY_PROVIDER (INTERNAL_ID);

ALTER TABLE CLIENT_IDENTITY_PROV_MAPPING ADD CONSTRAINT FK_56ELWNIBJI49AVXSRTUF6XJ23 FOREIGN KEY (CLIENT_ID) REFERENCES CLIENT (ID);

ALTER TABLE REALM_SUPPORTED_LOCALES ADD CONSTRAINT FK_SUPPORTED_LOCALES_REALM FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE USER_SESSION_NOTE ADD CONSTRAINT FK5EDFB00FF51D3472 FOREIGN KEY (USER_SESSION) REFERENCES USER_SESSION (ID);

ALTER TABLE IDENTITY_PROVIDER ADD CONSTRAINT UK_2DAELWNIBJI49AVXSRTUF6XJ33 UNIQUE (PROVIDER_ALIAS, REALM_ID);

ALTER TABLE CLIENT_IDENTITY_PROV_MAPPING ADD CONSTRAINT UK_7CAELWNIBJI49AVXSRTUF6XJ12 UNIQUE (IDENTITY_PROVIDER_ID, CLIENT_ID);

ALTER TABLE REALM ADD LOGIN_LIFESPAN INT;

ALTER TABLE REALM ADD INTERNATIONALIZATION_ENABLED BOOLEAN NOT NULL DEFAULT FALSE;

ALTER TABLE REALM ADD DEFAULT_LOCALE VARCHAR(255);

ALTER TABLE REALM ADD REG_EMAIL_AS_USERNAME BOOLEAN NOT NULL DEFAULT FALSE;

ALTER TABLE REALM_APPLICATION DROP CONSTRAINT FK_71S3P0DIUXAWWQQSA528UBY2Q;

ALTER TABLE REALM_APPLICATION DROP CONSTRAINT FK_L5QGA3RFME47335JY8JXYXH3I;

ALTER TABLE REALM_APPLICATION DROP CONSTRAINT UK_L5QGA3RFME47335JY8JXYXH3I;

ALTER TABLE REALM_APPLICATION RENAME COLUMN APPLICATION_ID TO APPLICATION_ID_TMP;

ALTER TABLE REALM_APPLICATION RENAME COLUMN REALM_ID TO APPLICATION_ID;

ALTER TABLE REALM_APPLICATION RENAME COLUMN APPLICATION_ID_TMP TO REALM_ID;

ALTER TABLE REALM_APPLICATION ADD CONSTRAINT UK_M6QGA3RFME47335JY8JXYXH3I UNIQUE (APPLICATION_ID);

ALTER TABLE REALM_APPLICATION ADD CONSTRAINT FK_82S3P0DIUXAWWQQSA528UBY2Q FOREIGN KEY (APPLICATION_ID) REFERENCES CLIENT (ID);

ALTER TABLE REALM_APPLICATION ADD CONSTRAINT FK_M6QGA3RFME47335JY8JXYXH3I FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE USER_SOCIAL_LINK DROP CONSTRAINT FK_68CJYS5UWM55UY823Y75XG4OM;

DROP TABLE USER_SOCIAL_LINK;

ALTER TABLE REALM_SOCIAL_CONFIG DROP CONSTRAINT FK_SV5I3C2TI7G0G922FGE683SOV;

DROP TABLE REALM_SOCIAL_CONFIG;

ALTER TABLE CLIENT DROP COLUMN ALLOWED_CLAIMS_MASK;

CREATE TABLE REALM_ENABLED_EVENT_TYPES (REALM_ID VARCHAR(36) NOT NULL, VALUE VARCHAR(255));

ALTER TABLE REALM_ENABLED_EVENT_TYPES ADD CONSTRAINT FK_H846O4H0W8EPX5NWEDRF5Y69J FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.2.0.Beta1', 'psilva@redhat.com', 'META-INF/jpa-changelog-1.2.0.Beta1.xml', CURRENT_TIMESTAMP, 5, '7:c7a54a1041d58eb3817a4a883b4d4e84', 'delete (x4), createTable (x8), addColumn (x2), addPrimaryKey (x6), addForeignKeyConstraint (x9), addUniqueConstraint (x2), addColumn, dropForeignKeyConstraint (x2), dropUniqueConstraint, renameColumn (x3), addUniqueConstraint, addForeignKeyConstra...', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/db2-jpa-changelog-1.2.0.Beta1.xml::1.2.0.Beta1::psilva@redhat.com
INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.2.0.Beta1', 'psilva@redhat.com', 'META-INF/db2-jpa-changelog-1.2.0.Beta1.xml', CURRENT_TIMESTAMP, 6, '7:2e01012df20974c1c2a605ef8afe25b7', 'delete (x4), createTable (x8), addColumn (x2), addPrimaryKey (x6), addForeignKeyConstraint (x9), addUniqueConstraint (x2), addColumn, dropForeignKeyConstraint (x2), dropUniqueConstraint, renameColumn (x3), customChange, dropForeignKeyConstraint, d...', '', 'MARK_RAN', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-1.2.0.CR1.xml::1.2.0.RC1::bburke@redhat.com
DELETE FROM CLIENT_SESSION_ROLE;

DELETE FROM CLIENT_SESSION_NOTE;

DELETE FROM CLIENT_SESSION;

DELETE FROM USER_SESSION_NOTE;

DELETE FROM USER_SESSION;

CREATE TABLE MIGRATION_MODEL (ID VARCHAR(36) NOT NULL, VERSION VARCHAR(36));

CREATE TABLE IDENTITY_PROVIDER_MAPPER (ID VARCHAR(36) NOT NULL, NAME VARCHAR(255) NOT NULL, IDP_ALIAS VARCHAR(255) NOT NULL, IDP_MAPPER_NAME VARCHAR(255) NOT NULL, REALM_ID VARCHAR(36) NOT NULL);

CREATE TABLE IDP_MAPPER_CONFIG (IDP_MAPPER_ID VARCHAR(36) NOT NULL, VALUE CLOB, NAME VARCHAR(255) NOT NULL);

ALTER TABLE CREDENTIAL ADD CREATED_DATE BIGINT;

CREATE TABLE USER_CONSENT (ID VARCHAR(36) NOT NULL, CLIENT_ID VARCHAR(36) NOT NULL, USER_ID VARCHAR(36) NOT NULL);

CREATE TABLE USER_CONSENT_ROLE (USER_CONSENT_ID VARCHAR(36) NOT NULL, ROLE_ID VARCHAR(36) NOT NULL);

CREATE TABLE USER_CONSENT_PROT_MAPPER (USER_CONSENT_ID VARCHAR(36) NOT NULL, PROTOCOL_MAPPER_ID VARCHAR(36) NOT NULL);

CREATE TABLE CLIENT_SESSION_PROT_MAPPER (PROTOCOL_MAPPER_ID VARCHAR(36) NOT NULL, CLIENT_SESSION VARCHAR(36) NOT NULL);

ALTER TABLE MIGRATION_MODEL ADD CONSTRAINT CONSTRAINT_MIGMOD PRIMARY KEY (ID);

ALTER TABLE IDENTITY_PROVIDER_MAPPER ADD CONSTRAINT CONSTRAINT_IDPM PRIMARY KEY (ID);

ALTER TABLE IDP_MAPPER_CONFIG ADD CONSTRAINT CONSTRAINT_IDPMConfig PRIMARY KEY (IDP_MAPPER_ID, NAME);

ALTER TABLE USER_CONSENT ADD CONSTRAINT CONSTRAINT_GRNTCSNT_PM PRIMARY KEY (ID);

ALTER TABLE USER_CONSENT_ROLE ADD CONSTRAINT CONSTRAINT_GRNTCSNT_ROLE_PM PRIMARY KEY (USER_CONSENT_ID, ROLE_ID);

ALTER TABLE USER_CONSENT_PROT_MAPPER ADD CONSTRAINT CONSTRAINT_GRNTCSNT_PRM_PM PRIMARY KEY (USER_CONSENT_ID, PROTOCOL_MAPPER_ID);

ALTER TABLE CLIENT_SESSION_PROT_MAPPER ADD CONSTRAINT CONSTRAINT_CS_PMP_PK PRIMARY KEY (CLIENT_SESSION, PROTOCOL_MAPPER_ID);

ALTER TABLE IDENTITY_PROVIDER_MAPPER ADD CONSTRAINT FK_IDPM_REALM FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE IDP_MAPPER_CONFIG ADD CONSTRAINT FK_IDPMConfig FOREIGN KEY (IDP_MAPPER_ID) REFERENCES IDENTITY_PROVIDER_MAPPER (ID);

ALTER TABLE USER_CONSENT ADD CONSTRAINT FK_GRNTCSNT_USER FOREIGN KEY (USER_ID) REFERENCES USER_ENTITY (ID);

ALTER TABLE USER_CONSENT_ROLE ADD CONSTRAINT FK_GRNTCSNT_ROLE_GR FOREIGN KEY (USER_CONSENT_ID) REFERENCES USER_CONSENT (ID);

ALTER TABLE USER_CONSENT_PROT_MAPPER ADD CONSTRAINT FK_GRNTCSNT_PRM_GR FOREIGN KEY (USER_CONSENT_ID) REFERENCES USER_CONSENT (ID);

ALTER TABLE CLIENT_SESSION_PROT_MAPPER ADD CONSTRAINT FK_33A8SGQW18I532811V7O2DK89 FOREIGN KEY (CLIENT_SESSION) REFERENCES CLIENT_SESSION (ID);

ALTER TABLE CLIENT RENAME COLUMN NAME TO CLIENT_ID;

ALTER TABLE CLIENT ADD CONSENT_REQUIRED BOOLEAN NOT NULL DEFAULT FALSE;

ALTER TABLE CLIENT ADD NAME VARCHAR(255);

ALTER TABLE IDENTITY_PROVIDER ADD ADD_TOKEN_ROLE BOOLEAN NOT NULL DEFAULT TRUE;

UPDATE CLIENT SET CONSENT_REQUIRED = TRUE WHERE DTYPE = 'OAuthClientEntity';

ALTER TABLE CLIENT DROP COLUMN DTYPE;

ALTER TABLE REALM DROP CONSTRAINT FK_RSAF444KK6QRKMS7N56AIWQ5Y;

ALTER TABLE REALM RENAME COLUMN MASTER_ADMIN_APP TO MASTER_ADMIN_CLIENT;

ALTER TABLE REALM ADD CONSTRAINT FK_TRAF444KK6QRKMS7N56AIWQ5Y FOREIGN KEY (MASTER_ADMIN_CLIENT) REFERENCES CLIENT (ID);

ALTER TABLE REALM_APPLICATION DROP CONSTRAINT FK_82S3P0DIUXAWWQQSA528UBY2Q;

RENAME REALM_APPLICATION TO REALM_CLIENT;

ALTER TABLE REALM_CLIENT RENAME COLUMN APPLICATION_ID TO CLIENT_ID;

ALTER TABLE REALM_CLIENT ADD CONSTRAINT FK_93S3P0DIUXAWWQQSA528UBY2Q FOREIGN KEY (CLIENT_ID) REFERENCES CLIENT (ID);

ALTER TABLE APPLICATION_DEFAULT_ROLES DROP CONSTRAINT FK_MAYLTS7KLWQW2H8M2B5JOYTKY;

RENAME APPLICATION_DEFAULT_ROLES TO CLIENT_DEFAULT_ROLES;

ALTER TABLE CLIENT_DEFAULT_ROLES RENAME COLUMN APPLICATION_ID TO CLIENT_ID;

ALTER TABLE CLIENT_DEFAULT_ROLES ADD CONSTRAINT FK_NUILTS7KLWQW2H8M2B5JOYTKY FOREIGN KEY (CLIENT_ID) REFERENCES CLIENT (ID);

ALTER TABLE APP_NODE_REGISTRATIONS DROP CONSTRAINT FK8454723BA992F594;

RENAME APP_NODE_REGISTRATIONS TO CLIENT_NODE_REGISTRATIONS;

ALTER TABLE CLIENT_NODE_REGISTRATIONS RENAME COLUMN APPLICATION_ID TO CLIENT_ID;

ALTER TABLE CLIENT_NODE_REGISTRATIONS ADD CONSTRAINT FK4129723BA992F594 FOREIGN KEY (CLIENT_ID) REFERENCES CLIENT (ID);

ALTER TABLE KEYCLOAK_ROLE DROP CONSTRAINT FK_PIMO5LE2C0RAL09FL8CM9WFW9;

ALTER TABLE KEYCLOAK_ROLE RENAME COLUMN APPLICATION TO CLIENT;

ALTER TABLE KEYCLOAK_ROLE RENAME COLUMN APPLICATION_ROLE TO CLIENT_ROLE;

ALTER TABLE KEYCLOAK_ROLE RENAME COLUMN APP_REALM_CONSTRAINT TO CLIENT_REALM_CONSTRAINT;

ALTER TABLE KEYCLOAK_ROLE ADD CONSTRAINT FK_KJHO5LE2C0RAL09FL8CM9WFW9 FOREIGN KEY (CLIENT) REFERENCES CLIENT (ID);

ALTER TABLE KEYCLOAK_ROLE DROP CONSTRAINT UK_J3RWUVD56ONTGSUHOGM184WW2;

ALTER TABLE KEYCLOAK_ROLE ADD CONSTRAINT "UK_J3RWUVD56ONTGSUHOGM184WW2-2" UNIQUE (NAME, CLIENT_REALM_CONSTRAINT);

ALTER TABLE USER_CONSENT ADD CONSTRAINT UK_JKUWUVD56ONTGSUHOGM8UEWRT UNIQUE (CLIENT_ID, USER_ID);

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.2.0.RC1', 'bburke@redhat.com', 'META-INF/jpa-changelog-1.2.0.CR1.xml', CURRENT_TIMESTAMP, 7, '7:0f08df48468428e0f30ee59a8ec01a41', 'delete (x5), createTable (x3), addColumn, createTable (x4), addPrimaryKey (x7), addForeignKeyConstraint (x6), renameColumn, addColumn (x2), update, dropColumn, dropForeignKeyConstraint, renameColumn, addForeignKeyConstraint, dropForeignKeyConstrai...', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/db2-jpa-changelog-1.2.0.CR1.xml::1.2.0.RC1::bburke@redhat.com
INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.2.0.RC1', 'bburke@redhat.com', 'META-INF/db2-jpa-changelog-1.2.0.CR1.xml', CURRENT_TIMESTAMP, 8, '7:a77ea2ad226b345e7d689d366f185c8c', 'delete (x5), createTable (x3), addColumn, createTable (x4), addPrimaryKey (x7), addForeignKeyConstraint (x6), renameColumn, addUniqueConstraint, addColumn (x2), update, dropColumn, dropForeignKeyConstraint, renameColumn, addForeignKeyConstraint, r...', '', 'MARK_RAN', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-1.2.0.Final.xml::1.2.0.Final::keycloak
UPDATE CLIENT SET DIRECT_GRANTS_ONLY = FALSE WHERE DIRECT_GRANTS_ONLY is null;

UPDATE CLIENT SET BEARER_ONLY = FALSE WHERE BEARER_ONLY is null;

UPDATE CLIENT SET SURROGATE_AUTH_REQUIRED = FALSE WHERE SURROGATE_AUTH_REQUIRED is null;

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.2.0.Final', 'keycloak', 'META-INF/jpa-changelog-1.2.0.Final.xml', CURRENT_TIMESTAMP, 9, '7:a3377a2059aefbf3b90ebb4c4cc8e2ab', 'update (x3)', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-1.3.0.xml::1.3.0::bburke@redhat.com
DELETE FROM CLIENT_SESSION_ROLE;

DELETE FROM CLIENT_SESSION_PROT_MAPPER;

DELETE FROM CLIENT_SESSION_NOTE;

DELETE FROM CLIENT_SESSION;

DELETE FROM USER_SESSION_NOTE;

DELETE FROM USER_SESSION;

CREATE TABLE ADMIN_EVENT_ENTITY (ID VARCHAR(36) NOT NULL, ADMIN_EVENT_TIME BIGINT, REALM_ID VARCHAR(255), OPERATION_TYPE VARCHAR(255), AUTH_REALM_ID VARCHAR(255), AUTH_CLIENT_ID VARCHAR(255), AUTH_USER_ID VARCHAR(255), IP_ADDRESS VARCHAR(255), RESOURCE_PATH VARCHAR(2550), REPRESENTATION CLOB(25500), ERROR VARCHAR(255));

CREATE TABLE AUTHENTICATOR (ID VARCHAR(36) NOT NULL, ALIAS VARCHAR(255), REALM_ID VARCHAR(36), PROVIDER_ID VARCHAR(255));

CREATE TABLE AUTHENTICATION_FLOW (ID VARCHAR(36) NOT NULL, ALIAS VARCHAR(255), DESCRIPTION VARCHAR(255), REALM_ID VARCHAR(36));

CREATE TABLE AUTHENTICATION_EXECUTION (ID VARCHAR(36) NOT NULL, ALIAS VARCHAR(255), AUTHENTICATOR VARCHAR(36), REALM_ID VARCHAR(36), FLOW_ID VARCHAR(36), REQUIREMENT INT, PRIORITY INT, USER_SETUP_ALLOWED BOOLEAN DEFAULT FALSE NOT NULL, AUTHENTICATOR_FLOW BOOLEAN DEFAULT FALSE NOT NULL);

CREATE TABLE AUTHENTICATOR_CONFIG (AUTHENTICATOR_ID VARCHAR(36) NOT NULL, VALUE CLOB, NAME VARCHAR(255) NOT NULL);

CREATE TABLE USER_FEDERATION_MAPPER (ID VARCHAR(36) NOT NULL, NAME VARCHAR(255) NOT NULL, FEDERATION_PROVIDER_ID VARCHAR(36) NOT NULL, FEDERATION_MAPPER_TYPE VARCHAR(255) NOT NULL, REALM_ID VARCHAR(36) NOT NULL);

CREATE TABLE USER_FEDERATION_MAPPER_CONFIG (USER_FEDERATION_MAPPER_ID VARCHAR(36) NOT NULL, VALUE VARCHAR(255), NAME VARCHAR(255) NOT NULL);

ALTER TABLE REALM ADD ADMIN_EVENTS_ENABLED BOOLEAN NOT NULL DEFAULT FALSE;

ALTER TABLE REALM ADD ADMIN_EVENTS_DETAILS_ENABLED BOOLEAN NOT NULL DEFAULT FALSE;

ALTER TABLE REALM ADD EDIT_USERNAME_ALLOWED BOOLEAN NOT NULL DEFAULT FALSE;

CREATE TABLE CLIENT_SESSION_AUTH_STATUS (AUTHENTICATOR VARCHAR(36) NOT NULL, STATUS INT, CLIENT_SESSION VARCHAR(36) NOT NULL);

ALTER TABLE CLIENT_SESSION ADD AUTH_USER_ID VARCHAR(36);

ALTER TABLE IDENTITY_PROVIDER ADD TRUST_EMAIL BOOLEAN NOT NULL DEFAULT FALSE;

ALTER TABLE IDENTITY_PROVIDER ADD UPDATE_PROFILE_FIRST_LGN_MD VARCHAR(255) NOT NULL DEFAULT 'on';

UPDATE IDENTITY_PROVIDER SET UPDATE_PROFILE_FIRST_LGN_MD = 'off' WHERE UPDATE_PROFILE_FIRST_LOGIN = FALSE;

ALTER TABLE IDENTITY_PROVIDER ALTER COLUMN  UPDATE_PROFILE_FIRST_LOGIN SET DEFAULT NULL;

ALTER TABLE IDENTITY_PROVIDER DROP COLUMN UPDATE_PROFILE_FIRST_LOGIN;

ALTER TABLE USER_REQUIRED_ACTION ADD REQUIRED_ACTION VARCHAR(255) NOT NULL DEFAULT ' ';

UPDATE USER_REQUIRED_ACTION SET REQUIRED_ACTION = 'VERIFY_EMAIL' WHERE ACTION = 0;

UPDATE USER_REQUIRED_ACTION SET REQUIRED_ACTION = 'UPDATE_PROFILE' WHERE ACTION = 1;

UPDATE USER_REQUIRED_ACTION SET REQUIRED_ACTION = 'CONFIGURE_TOTP' WHERE ACTION = 2;

UPDATE USER_REQUIRED_ACTION SET REQUIRED_ACTION = 'UPDATE_PASSWORD' WHERE ACTION = 3;

ALTER TABLE AUTHENTICATOR ADD CONSTRAINT CONSTRAINT_AUTH_PK PRIMARY KEY (ID);

ALTER TABLE AUTHENTICATION_FLOW ADD CONSTRAINT CONSTRAINT_AUTH_FLOW_PK PRIMARY KEY (ID);

ALTER TABLE AUTHENTICATION_EXECUTION ADD CONSTRAINT CONSTRAINT_AUTH_EXEC_PK PRIMARY KEY (ID);

ALTER TABLE AUTHENTICATOR_CONFIG ADD CONSTRAINT CONSTRAINT_AUTH_CFG_PK PRIMARY KEY (AUTHENTICATOR_ID, NAME);

ALTER TABLE USER_REQUIRED_ACTION DROP PRIMARY KEY;

ALTER TABLE USER_REQUIRED_ACTION DROP COLUMN ACTION;

ALTER TABLE USER_REQUIRED_ACTION ADD CONSTRAINT CONSTRAINT_REQUIRED_ACTION PRIMARY KEY (REQUIRED_ACTION, USER_ID);

ALTER TABLE CLIENT_SESSION_AUTH_STATUS ADD CONSTRAINT CONSTRAINT_AUTH_STATUS_PK PRIMARY KEY (CLIENT_SESSION, AUTHENTICATOR);

ALTER TABLE USER_FEDERATION_MAPPER ADD CONSTRAINT CONSTRAINT_FEDMAPPERPM PRIMARY KEY (ID);

ALTER TABLE USER_FEDERATION_MAPPER_CONFIG ADD CONSTRAINT CONSTRAINT_FEDMAPPER_CFG_PM PRIMARY KEY (USER_FEDERATION_MAPPER_ID, NAME);

ALTER TABLE CLIENT_SESSION_AUTH_STATUS ADD CONSTRAINT AUTH_STATUS_CONSTRAINT FOREIGN KEY (CLIENT_SESSION) REFERENCES CLIENT_SESSION (ID);

ALTER TABLE AUTHENTICATOR ADD CONSTRAINT FK_AUTH_REALM FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE AUTHENTICATION_FLOW ADD CONSTRAINT FK_AUTH_FLOW_REALM FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE AUTHENTICATION_EXECUTION ADD CONSTRAINT FK_AUTH_EXEC_REALM FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE AUTHENTICATION_EXECUTION ADD CONSTRAINT FK_AUTH_EXEC_FLOW FOREIGN KEY (FLOW_ID) REFERENCES AUTHENTICATION_FLOW (ID);

ALTER TABLE USER_FEDERATION_MAPPER ADD CONSTRAINT FK_FEDMAPPERPM_REALM FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE USER_FEDERATION_MAPPER ADD CONSTRAINT FK_FEDMAPPERPM_FEDPRV FOREIGN KEY (FEDERATION_PROVIDER_ID) REFERENCES USER_FEDERATION_PROVIDER (ID);

ALTER TABLE USER_FEDERATION_MAPPER_CONFIG ADD CONSTRAINT FK_FEDMAPPER_CFG FOREIGN KEY (USER_FEDERATION_MAPPER_ID) REFERENCES USER_FEDERATION_MAPPER (ID);

ALTER TABLE REALM ALTER COLUMN  PASSWORD_CRED_GRANT_ALLOWED SET DEFAULT NULL;

ALTER TABLE REALM DROP COLUMN PASSWORD_CRED_GRANT_ALLOWED;

ALTER TABLE PROTOCOL_MAPPER_CONFIG DROP CONSTRAINT FK_PMConfig;

ALTER TABLE PROTOCOL_MAPPER_CONFIG DROP PRIMARY KEY;

ALTER TABLE PROTOCOL_MAPPER_CONFIG ADD CONSTRAINT CONSTRAINT_PMCONFIG PRIMARY KEY (PROTOCOL_MAPPER_ID, NAME);

ALTER TABLE PROTOCOL_MAPPER_CONFIG ADD CONSTRAINT FK_PMCONFIG FOREIGN KEY (PROTOCOL_MAPPER_ID) REFERENCES PROTOCOL_MAPPER (ID);

ALTER TABLE IDP_MAPPER_CONFIG DROP CONSTRAINT FK_IDPMConfig;

ALTER TABLE IDP_MAPPER_CONFIG DROP PRIMARY KEY;

ALTER TABLE IDP_MAPPER_CONFIG ADD CONSTRAINT CONSTRAINT_IDPMCONFIG PRIMARY KEY (IDP_MAPPER_ID, NAME);

ALTER TABLE IDP_MAPPER_CONFIG ADD CONSTRAINT FK_IDPMCONFIG FOREIGN KEY (IDP_MAPPER_ID) REFERENCES IDENTITY_PROVIDER_MAPPER (ID);

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.3.0', 'bburke@redhat.com', 'META-INF/jpa-changelog-1.3.0.xml', CURRENT_TIMESTAMP, 10, '7:04c1dbedc2aa3e9756d1a1668e003451', 'delete (x6), createTable (x7), addColumn, createTable, addColumn (x2), update, dropDefaultValue, dropColumn, addColumn, update (x4), addPrimaryKey (x4), dropPrimaryKey, dropColumn, addPrimaryKey (x4), addForeignKeyConstraint (x8), dropDefaultValue...', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-1.4.0.xml::1.4.0::bburke@redhat.com
DELETE FROM CLIENT_SESSION_AUTH_STATUS;

DELETE FROM CLIENT_SESSION_ROLE;

DELETE FROM CLIENT_SESSION_PROT_MAPPER;

DELETE FROM CLIENT_SESSION_NOTE;

DELETE FROM CLIENT_SESSION;

DELETE FROM USER_SESSION_NOTE;

DELETE FROM USER_SESSION;

ALTER TABLE CLIENT ADD SERVICE_ACCOUNTS_ENABLED BOOLEAN NOT NULL DEFAULT FALSE;

ALTER TABLE CLIENT_SESSION ADD CURRENT_ACTION VARCHAR(36);

ALTER TABLE AUTHENTICATION_FLOW ADD PROVIDER_ID VARCHAR(36) NOT NULL DEFAULT 'basic-flow';

ALTER TABLE AUTHENTICATION_FLOW ADD TOP_LEVEL BOOLEAN NOT NULL DEFAULT FALSE;

ALTER TABLE AUTHENTICATION_FLOW ADD BUILT_IN BOOLEAN NOT NULL DEFAULT FALSE;

ALTER TABLE AUTHENTICATION_EXECUTION ADD AUTH_FLOW_ID VARCHAR(36);

ALTER TABLE AUTHENTICATION_EXECUTION ADD AUTH_CONFIG VARCHAR(36);

ALTER TABLE USER_ATTRIBUTE ADD ID VARCHAR(36) NOT NULL DEFAULT 'sybase-needs-something-here';

ALTER TABLE AUTHENTICATOR DROP COLUMN PROVIDER_ID;

RENAME AUTHENTICATOR_CONFIG TO AUTHENTICATOR_CONFIG_ENTRY;

RENAME AUTHENTICATOR TO AUTHENTICATOR_CONFIG;

UPDATE CLIENT_SESSION SET CURRENT_ACTION = 'OAUTH_GRANT' WHERE ACTION = 0;

UPDATE CLIENT_SESSION SET CURRENT_ACTION = 'CODE_TO_TOKEN' WHERE ACTION = 1;

UPDATE CLIENT_SESSION SET CURRENT_ACTION = 'VERIFY_EMAIL' WHERE ACTION = 2;

UPDATE CLIENT_SESSION SET CURRENT_ACTION = 'UPDATE_PROFILE' WHERE ACTION = 3;

UPDATE CLIENT_SESSION SET CURRENT_ACTION = 'CONFIGURE_TOTP' WHERE ACTION = 4;

UPDATE CLIENT_SESSION SET CURRENT_ACTION = 'UPDATE_PASSWORD' WHERE ACTION = 5;

UPDATE CLIENT_SESSION SET CURRENT_ACTION = 'RECOVER_PASSWORD' WHERE ACTION = 6;

UPDATE CLIENT_SESSION SET CURRENT_ACTION = 'AUTHENTICATE' WHERE ACTION = 7;

UPDATE CLIENT_SESSION SET CURRENT_ACTION = 'SOCIAL_CALLBACK' WHERE ACTION = 8;

UPDATE CLIENT_SESSION SET CURRENT_ACTION = 'LOGGED_OUT' WHERE ACTION = 9;

CREATE TABLE CLIENT_USER_SESSION_NOTE (NAME VARCHAR(255) NOT NULL, VALUE VARCHAR(2048), CLIENT_SESSION VARCHAR(36) NOT NULL);

CREATE TABLE REQUIRED_ACTION_PROVIDER (ID VARCHAR(36) NOT NULL, ALIAS VARCHAR(255), NAME VARCHAR(255), REALM_ID VARCHAR(36), ENABLED BOOLEAN DEFAULT FALSE NOT NULL, DEFAULT_ACTION BOOLEAN DEFAULT FALSE NOT NULL, PROVIDER_ID VARCHAR(255));

CREATE TABLE REQUIRED_ACTION_CONFIG (REQUIRED_ACTION_ID VARCHAR(36) NOT NULL, VALUE CLOB, NAME VARCHAR(255) NOT NULL);

ALTER TABLE USER_ATTRIBUTE DROP PRIMARY KEY;

ALTER TABLE USER_ATTRIBUTE ADD CONSTRAINT CONSTRAINT_USER_ATTRIBUTE_PK PRIMARY KEY (ID);

ALTER TABLE REQUIRED_ACTION_PROVIDER ADD CONSTRAINT CONSTRAINT_REQ_ACT_PRV_PK PRIMARY KEY (ID);

ALTER TABLE REQUIRED_ACTION_CONFIG ADD CONSTRAINT CONSTRAINT_REQ_ACT_CFG_PK PRIMARY KEY (REQUIRED_ACTION_ID, NAME);

ALTER TABLE CLIENT_USER_SESSION_NOTE ADD CONSTRAINT CONSTR_CL_USR_SES_NOTE PRIMARY KEY (CLIENT_SESSION, NAME);

ALTER TABLE REQUIRED_ACTION_PROVIDER ADD CONSTRAINT FK_REQ_ACT_REALM FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE CLIENT_USER_SESSION_NOTE ADD CONSTRAINT FK_CL_USR_SES_NOTE FOREIGN KEY (CLIENT_SESSION) REFERENCES CLIENT_SESSION (ID);

ALTER TABLE CLIENT_SESSION DROP COLUMN ACTION;

ALTER TABLE USER_ENTITY ADD CREATED_TIMESTAMP BIGINT;

ALTER TABLE USER_ENTITY ADD SERVICE_ACCOUNT_CLIENT_LINK VARCHAR(36);

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.4.0', 'bburke@redhat.com', 'META-INF/jpa-changelog-1.4.0.xml', CURRENT_TIMESTAMP, 11, '7:36ef39ed560ad07062d956db861042ba', 'delete (x7), addColumn (x5), dropColumn, renameTable (x2), update (x10), createTable (x3), customChange, dropPrimaryKey, addPrimaryKey (x4), addForeignKeyConstraint (x2), dropColumn, addColumn', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/db2-jpa-changelog-1.4.0.xml::1.4.0::bburke@redhat.com
INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.4.0', 'bburke@redhat.com', 'META-INF/db2-jpa-changelog-1.4.0.xml', CURRENT_TIMESTAMP, 12, '7:d909180b2530479a716d3f9c9eaea3d7', 'delete (x7), addColumn (x5), dropColumn, renameTable, dropForeignKeyConstraint, renameTable, addForeignKeyConstraint, update (x10), createTable (x3), customChange, dropPrimaryKey, addPrimaryKey (x4), addForeignKeyConstraint (x2), dropColumn, addCo...', '', 'MARK_RAN', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-1.5.0.xml::1.5.0::bburke@redhat.com
DELETE FROM CLIENT_SESSION_AUTH_STATUS;

DELETE FROM CLIENT_SESSION_ROLE;

DELETE FROM CLIENT_SESSION_PROT_MAPPER;

DELETE FROM CLIENT_SESSION_NOTE;

DELETE FROM CLIENT_SESSION;

DELETE FROM USER_SESSION_NOTE;

DELETE FROM USER_SESSION;

ALTER TABLE AUTHENTICATION_EXECUTION ALTER COLUMN  USER_SETUP_ALLOWED SET DEFAULT NULL;

ALTER TABLE AUTHENTICATION_EXECUTION DROP COLUMN USER_SETUP_ALLOWED;

ALTER TABLE CREDENTIAL ADD COUNTER INT DEFAULT 0;

ALTER TABLE CREDENTIAL ADD DIGITS INT DEFAULT 6;

ALTER TABLE CREDENTIAL ADD PERIOD INT DEFAULT 30;

ALTER TABLE CREDENTIAL ADD ALGORITHM VARCHAR(36) DEFAULT 'HmacSHA1';

ALTER TABLE REALM ADD OTP_POLICY_COUNTER INT DEFAULT 0;

ALTER TABLE REALM ADD OTP_POLICY_WINDOW INT DEFAULT 1;

ALTER TABLE REALM ADD OTP_POLICY_PERIOD INT DEFAULT 30;

ALTER TABLE REALM ADD OTP_POLICY_DIGITS INT DEFAULT 6;

ALTER TABLE REALM ADD OTP_POLICY_ALG VARCHAR(36) DEFAULT 'HmacSHA1';

ALTER TABLE REALM ADD OTP_POLICY_TYPE VARCHAR(36) DEFAULT 'totp';

ALTER TABLE REALM ADD BROWSER_FLOW VARCHAR(36);

ALTER TABLE REALM ADD REGISTRATION_FLOW VARCHAR(36);

ALTER TABLE REALM ADD DIRECT_GRANT_FLOW VARCHAR(36);

ALTER TABLE REALM ADD RESET_CREDENTIALS_FLOW VARCHAR(36);

ALTER TABLE REALM ADD CLIENT_AUTH_FLOW VARCHAR(36);

ALTER TABLE CLIENT ADD CLIENT_AUTHENTICATOR_TYPE VARCHAR(255);

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.5.0', 'bburke@redhat.com', 'META-INF/jpa-changelog-1.5.0.xml', CURRENT_TIMESTAMP, 13, '7:cf12b04b79bea5152f165eb41f3955f6', 'delete (x7), dropDefaultValue, dropColumn, addColumn (x3)', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-1.6.1.xml::1.6.1_from15::mposolda@redhat.com
ALTER TABLE REALM ADD OFFLINE_SESSION_IDLE_TIMEOUT INT DEFAULT 0;

ALTER TABLE REALM ADD REVOKE_REFRESH_TOKEN BOOLEAN NOT NULL DEFAULT FALSE;

ALTER TABLE KEYCLOAK_ROLE ADD SCOPE_PARAM_REQUIRED BOOLEAN NOT NULL DEFAULT FALSE;

ALTER TABLE CLIENT ADD ROOT_URL VARCHAR(255);

ALTER TABLE CLIENT ADD DESCRIPTION VARCHAR(255);

CREATE TABLE OFFLINE_USER_SESSION (USER_SESSION_ID VARCHAR(36) NOT NULL, USER_ID VARCHAR(36) NOT NULL, REALM_ID VARCHAR(36) NOT NULL, LAST_SESSION_REFRESH INT, OFFLINE_FLAG VARCHAR(4) NOT NULL, DATA CLOB);

CREATE TABLE OFFLINE_CLIENT_SESSION (CLIENT_SESSION_ID VARCHAR(36) NOT NULL, USER_SESSION_ID VARCHAR(36) NOT NULL, CLIENT_ID VARCHAR(36) NOT NULL, OFFLINE_FLAG VARCHAR(4) NOT NULL, TIMESTAMP INT, DATA CLOB);

ALTER TABLE OFFLINE_USER_SESSION ADD CONSTRAINT CONSTRAINT_OFFL_US_SES_PK2 PRIMARY KEY (USER_SESSION_ID, OFFLINE_FLAG);

ALTER TABLE OFFLINE_CLIENT_SESSION ADD CONSTRAINT CONSTRAINT_OFFL_CL_SES_PK2 PRIMARY KEY (CLIENT_SESSION_ID, OFFLINE_FLAG);

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.6.1_from15', 'mposolda@redhat.com', 'META-INF/jpa-changelog-1.6.1.xml', CURRENT_TIMESTAMP, 14, '7:7e32c8f05c755e8675764e7d5f514509', 'addColumn (x3), createTable (x2), addPrimaryKey (x2)', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-1.6.1.xml::1.6.1_from16-pre::mposolda@redhat.com
INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.6.1_from16-pre', 'mposolda@redhat.com', 'META-INF/jpa-changelog-1.6.1.xml', CURRENT_TIMESTAMP, 15, '7:980ba23cc0ec39cab731ce903dd01291', 'delete (x2)', '', 'MARK_RAN', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-1.6.1.xml::1.6.1_from16::mposolda@redhat.com
INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.6.1_from16', 'mposolda@redhat.com', 'META-INF/jpa-changelog-1.6.1.xml', CURRENT_TIMESTAMP, 16, '7:2fa220758991285312eb84f3b4ff5336', 'dropPrimaryKey (x2), addColumn, update, dropColumn, addColumn, update, dropColumn, addPrimaryKey (x2)', '', 'MARK_RAN', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-1.6.1.xml::1.6.1::mposolda@redhat.com
INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.6.1', 'mposolda@redhat.com', 'META-INF/jpa-changelog-1.6.1.xml', CURRENT_TIMESTAMP, 17, '7:d41d8cd98f00b204e9800998ecf8427e', 'Empty', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-1.7.0.xml::1.7.0::bburke@redhat.com
CREATE TABLE KEYCLOAK_GROUP (ID VARCHAR(36) NOT NULL, NAME VARCHAR(255), PARENT_GROUP VARCHAR(36), REALM_ID VARCHAR(36));

CREATE TABLE GROUP_ROLE_MAPPING (ROLE_ID VARCHAR(36) NOT NULL, GROUP_ID VARCHAR(36) NOT NULL);

CREATE TABLE GROUP_ATTRIBUTE (ID VARCHAR(36) DEFAULT 'sybase-needs-something-here' NOT NULL, NAME VARCHAR(255) NOT NULL, VALUE VARCHAR(255), GROUP_ID VARCHAR(36) NOT NULL);

CREATE TABLE USER_GROUP_MEMBERSHIP (GROUP_ID VARCHAR(36) NOT NULL, USER_ID VARCHAR(36) NOT NULL);

CREATE TABLE REALM_DEFAULT_GROUPS (REALM_ID VARCHAR(36) NOT NULL, GROUP_ID VARCHAR(36) NOT NULL);

ALTER TABLE IDENTITY_PROVIDER ADD FIRST_BROKER_LOGIN_FLOW_ID VARCHAR(36);

ALTER TABLE REALM ADD ACCESS_TOKEN_LIFE_IMPLICIT INT DEFAULT 0;

ALTER TABLE IDENTITY_PROVIDER ALTER COLUMN  UPDATE_PROFILE_FIRST_LGN_MD SET DEFAULT NULL;

ALTER TABLE IDENTITY_PROVIDER DROP COLUMN UPDATE_PROFILE_FIRST_LGN_MD;

ALTER TABLE KEYCLOAK_GROUP ADD CONSTRAINT CONSTRAINT_GROUP PRIMARY KEY (ID);

ALTER TABLE KEYCLOAK_GROUP ADD CONSTRAINT FK_GROUP_REALM FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE GROUP_ATTRIBUTE ADD CONSTRAINT CONSTRAINT_GROUP_ATTRIBUTE_PK PRIMARY KEY (ID);

ALTER TABLE GROUP_ATTRIBUTE ADD CONSTRAINT FK_GROUP_ATTRIBUTE_GROUP FOREIGN KEY (GROUP_ID) REFERENCES KEYCLOAK_GROUP (ID);

ALTER TABLE USER_GROUP_MEMBERSHIP ADD CONSTRAINT CONSTRAINT_USER_GROUP PRIMARY KEY (GROUP_ID, USER_ID);

ALTER TABLE USER_GROUP_MEMBERSHIP ADD CONSTRAINT FK_USER_GROUP_USER FOREIGN KEY (USER_ID) REFERENCES USER_ENTITY (ID);

ALTER TABLE GROUP_ROLE_MAPPING ADD CONSTRAINT CONSTRAINT_GROUP_ROLE PRIMARY KEY (ROLE_ID, GROUP_ID);

ALTER TABLE GROUP_ROLE_MAPPING ADD CONSTRAINT FK_GROUP_ROLE_GROUP FOREIGN KEY (GROUP_ID) REFERENCES KEYCLOAK_GROUP (ID);

ALTER TABLE GROUP_ROLE_MAPPING ADD CONSTRAINT FK_GROUP_ROLE_ROLE FOREIGN KEY (ROLE_ID) REFERENCES KEYCLOAK_ROLE (ID);

ALTER TABLE REALM_DEFAULT_GROUPS ADD CONSTRAINT CON_GROUP_ID_DEF_GROUPS UNIQUE (GROUP_ID);

ALTER TABLE REALM_DEFAULT_GROUPS ADD CONSTRAINT FK_DEF_GROUPS_REALM FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE REALM_DEFAULT_GROUPS ADD CONSTRAINT FK_DEF_GROUPS_GROUP FOREIGN KEY (GROUP_ID) REFERENCES KEYCLOAK_GROUP (ID);

ALTER TABLE CLIENT ADD REGISTRATION_TOKEN VARCHAR(255);

ALTER TABLE CLIENT ADD STANDARD_FLOW_ENABLED BOOLEAN NOT NULL DEFAULT TRUE;

ALTER TABLE CLIENT ADD IMPLICIT_FLOW_ENABLED BOOLEAN NOT NULL DEFAULT FALSE;

ALTER TABLE CLIENT ADD DIRECT_ACCESS_GRANTS_ENABLED BOOLEAN NOT NULL DEFAULT FALSE;

UPDATE CLIENT SET DIRECT_ACCESS_GRANTS_ENABLED = TRUE, STANDARD_FLOW_ENABLED = FALSE WHERE DIRECT_GRANTS_ONLY = TRUE;

ALTER TABLE CLIENT ALTER COLUMN  DIRECT_GRANTS_ONLY SET DEFAULT NULL;

ALTER TABLE CLIENT DROP COLUMN DIRECT_GRANTS_ONLY;

ALTER TABLE REALM ALTER COLUMN PASSWORD_POLICY TYPE VARCHAR(2550);

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.7.0', 'bburke@redhat.com', 'META-INF/jpa-changelog-1.7.0.xml', CURRENT_TIMESTAMP, 18, '7:91ace540896df890cc00a0490ee52bbc', 'createTable (x5), addColumn (x2), dropDefaultValue, dropColumn, addPrimaryKey, addForeignKeyConstraint, addPrimaryKey, addForeignKeyConstraint, addPrimaryKey, addForeignKeyConstraint, addPrimaryKey, addForeignKeyConstraint (x2), addUniqueConstrain...', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-1.8.0.xml::1.8.0::mposolda@redhat.com
ALTER TABLE IDENTITY_PROVIDER ADD POST_BROKER_LOGIN_FLOW_ID VARCHAR(36);

CREATE TABLE CLIENT_TEMPLATE (ID VARCHAR(36) NOT NULL, NAME VARCHAR(255), REALM_ID VARCHAR(36), DESCRIPTION VARCHAR(255), PROTOCOL VARCHAR(255), FULL_SCOPE_ALLOWED BOOLEAN DEFAULT FALSE NOT NULL, CONSENT_REQUIRED BOOLEAN DEFAULT FALSE NOT NULL, STANDARD_FLOW_ENABLED BOOLEAN DEFAULT TRUE NOT NULL, IMPLICIT_FLOW_ENABLED BOOLEAN DEFAULT FALSE NOT NULL, DIRECT_ACCESS_GRANTS_ENABLED BOOLEAN DEFAULT FALSE NOT NULL, SERVICE_ACCOUNTS_ENABLED BOOLEAN DEFAULT FALSE NOT NULL, FRONTCHANNEL_LOGOUT BOOLEAN DEFAULT FALSE NOT NULL, BEARER_ONLY BOOLEAN DEFAULT FALSE NOT NULL, PUBLIC_CLIENT BOOLEAN DEFAULT FALSE NOT NULL);

CREATE TABLE CLIENT_TEMPLATE_ATTRIBUTES (TEMPLATE_ID VARCHAR(36) NOT NULL, VALUE VARCHAR(2048), NAME VARCHAR(255) NOT NULL);

CREATE TABLE TEMPLATE_SCOPE_MAPPING (TEMPLATE_ID VARCHAR(36) NOT NULL, ROLE_ID VARCHAR(36) NOT NULL);

ALTER TABLE PROTOCOL_MAPPER ALTER COLUMN  CLIENT_ID DROP NOT NULL;

ALTER TABLE CLIENT ADD CLIENT_TEMPLATE_ID VARCHAR(36);

ALTER TABLE CLIENT ADD USE_TEMPLATE_CONFIG BOOLEAN NOT NULL DEFAULT FALSE;

ALTER TABLE CLIENT ADD USE_TEMPLATE_SCOPE BOOLEAN NOT NULL DEFAULT FALSE;

ALTER TABLE CLIENT ADD USE_TEMPLATE_MAPPERS BOOLEAN NOT NULL DEFAULT FALSE;

ALTER TABLE PROTOCOL_MAPPER ADD CLIENT_TEMPLATE_ID VARCHAR(36);

CREATE TABLE REALM_CLIENT_TEMPLATE (CLIENT_TEMPLATE_ID VARCHAR(36) NOT NULL, REALM_ID VARCHAR(36) NOT NULL);

ALTER TABLE CLIENT_TEMPLATE ADD CONSTRAINT PK_CLI_TEMPLATE PRIMARY KEY (ID);

ALTER TABLE CLIENT_TEMPLATE ADD CONSTRAINT UK_CLI_TEMPLATE UNIQUE (REALM_ID, NAME);

ALTER TABLE CLIENT_TEMPLATE ADD CONSTRAINT FK_REALM_CLI_TMPLT FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE PROTOCOL_MAPPER ADD CONSTRAINT FK_CLI_TMPLT_MAPPER FOREIGN KEY (CLIENT_TEMPLATE_ID) REFERENCES CLIENT_TEMPLATE (ID);

ALTER TABLE CLIENT ADD CONSTRAINT FK_CLI_TMPLT_CLIENT FOREIGN KEY (CLIENT_TEMPLATE_ID) REFERENCES CLIENT_TEMPLATE (ID);

ALTER TABLE REALM_CLIENT_TEMPLATE ADD CONSTRAINT FK_RLM_CLI_TMPLT_RLM FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE REALM_CLIENT_TEMPLATE ADD CONSTRAINT FK_RLM_CLI_TMPLT_CLI FOREIGN KEY (CLIENT_TEMPLATE_ID) REFERENCES CLIENT_TEMPLATE (ID);

ALTER TABLE TEMPLATE_SCOPE_MAPPING ADD CONSTRAINT PK_TEMPLATE_SCOPE PRIMARY KEY (TEMPLATE_ID, ROLE_ID);

ALTER TABLE TEMPLATE_SCOPE_MAPPING ADD CONSTRAINT FK_TEMPL_SCOPE_TEMPL FOREIGN KEY (TEMPLATE_ID) REFERENCES CLIENT_TEMPLATE (ID);

ALTER TABLE TEMPLATE_SCOPE_MAPPING ADD CONSTRAINT FK_TEMPL_SCOPE_ROLE FOREIGN KEY (ROLE_ID) REFERENCES KEYCLOAK_ROLE (ID);

ALTER TABLE CLIENT_TEMPLATE_ATTRIBUTES ADD CONSTRAINT PK_CL_TMPL_ATTR PRIMARY KEY (TEMPLATE_ID, NAME);

ALTER TABLE CLIENT_TEMPLATE_ATTRIBUTES ADD CONSTRAINT FK_CL_TEMPL_ATTR_TEMPL FOREIGN KEY (TEMPLATE_ID) REFERENCES CLIENT_TEMPLATE (ID);

UPDATE CREDENTIAL SET ALGORITHM = 'pbkdf2' WHERE TYPE in ('password-history', 'password') AND ALGORITHM is NULL;

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.8.0', 'mposolda@redhat.com', 'META-INF/jpa-changelog-1.8.0.xml', CURRENT_TIMESTAMP, 19, '7:c31d1646dfa2618a9335c00e07f89f24', 'addColumn, createTable (x3), dropNotNullConstraint, addColumn (x2), createTable, addPrimaryKey, addUniqueConstraint, addForeignKeyConstraint (x5), addPrimaryKey, addForeignKeyConstraint (x2), addPrimaryKey, addForeignKeyConstraint, update', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-1.8.0.xml::1.8.0-2::keycloak
ALTER TABLE CREDENTIAL ALTER COLUMN  ALGORITHM SET DEFAULT NULL;

UPDATE CREDENTIAL SET ALGORITHM = 'pbkdf2' WHERE TYPE in ('password-history', 'password') AND ALGORITHM = 'HmacSHA1';

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.8.0-2', 'keycloak', 'META-INF/jpa-changelog-1.8.0.xml', CURRENT_TIMESTAMP, 20, '7:df8bc21027a4f7cbbb01f6344e89ce07', 'dropDefaultValue, update', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/db2-jpa-changelog-1.8.0.xml::1.8.0::mposolda@redhat.com
INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.8.0', 'mposolda@redhat.com', 'META-INF/db2-jpa-changelog-1.8.0.xml', CURRENT_TIMESTAMP, 21, '7:f987971fe6b37d963bc95fee2b27f8df', 'addColumn, createTable (x3), dropNotNullConstraint, addColumn (x2), createTable, addPrimaryKey, addUniqueConstraint, addForeignKeyConstraint (x5), addPrimaryKey, addForeignKeyConstraint (x2), addPrimaryKey, addForeignKeyConstraint, update', '', 'MARK_RAN', NULL, NULL, '3.4.1');

-- Changeset META-INF/db2-jpa-changelog-1.8.0.xml::1.8.0-2::keycloak
INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.8.0-2', 'keycloak', 'META-INF/db2-jpa-changelog-1.8.0.xml', CURRENT_TIMESTAMP, 22, '7:df8bc21027a4f7cbbb01f6344e89ce07', 'dropDefaultValue, update', '', 'MARK_RAN', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-1.9.0.xml::1.9.0::mposolda@redhat.com
UPDATE REALM SET OTP_POLICY_COUNTER = 0 WHERE OTP_POLICY_COUNTER is NULL;

UPDATE REALM SET OTP_POLICY_WINDOW = 1 WHERE OTP_POLICY_WINDOW is NULL;

UPDATE REALM SET OTP_POLICY_PERIOD = 30 WHERE OTP_POLICY_PERIOD is NULL;

UPDATE REALM SET OTP_POLICY_DIGITS = 6 WHERE OTP_POLICY_DIGITS is NULL;

UPDATE CREDENTIAL SET COUNTER = 0 WHERE COUNTER is NULL;

UPDATE CREDENTIAL SET DIGITS = 6 WHERE DIGITS is NULL;

UPDATE CREDENTIAL SET PERIOD = 30 WHERE PERIOD is NULL;

UPDATE REALM SET OFFLINE_SESSION_IDLE_TIMEOUT = 2592000 WHERE OFFLINE_SESSION_IDLE_TIMEOUT is NULL;

UPDATE REALM SET ACCESS_TOKEN_LIFE_IMPLICIT = 900 WHERE ACCESS_TOKEN_LIFE_IMPLICIT is NULL;

ALTER TABLE REALM_CLIENT DROP CONSTRAINT FK_93S3P0DIUXAWWQQSA528UBY2Q;

ALTER TABLE REALM_CLIENT DROP CONSTRAINT FK_M6QGA3RFME47335JY8JXYXH3I;

ALTER TABLE REALM_CLIENT DROP CONSTRAINT UK_M6QGA3RFME47335JY8JXYXH3I;

DROP TABLE REALM_CLIENT;

ALTER TABLE REALM_CLIENT_TEMPLATE DROP CONSTRAINT FK_RLM_CLI_TMPLT_RLM;

ALTER TABLE REALM_CLIENT_TEMPLATE DROP CONSTRAINT FK_RLM_CLI_TMPLT_CLI;

DROP TABLE REALM_CLIENT_TEMPLATE;

ALTER TABLE FED_PROVIDERS DROP CONSTRAINT FK_213LYQ09FKXQ8K8NY8DY3737T;

ALTER TABLE FED_PROVIDERS DROP CONSTRAINT FK_DCCIRJLIPU1478VQC89DID88C;

ALTER TABLE FED_PROVIDERS DROP CONSTRAINT UK_DCCIRJLIPU1478VQC89DID88C;

DROP TABLE FED_PROVIDERS;

CREATE INDEX IDX_US_SESS_ID_ON_CL_SESS ON OFFLINE_CLIENT_SESSION(USER_SESSION_ID);

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.9.0', 'mposolda@redhat.com', 'META-INF/jpa-changelog-1.9.0.xml', CURRENT_TIMESTAMP, 23, '7:ed2dc7f799d19ac452cbcda56c929e47', 'update (x9), customChange, dropForeignKeyConstraint (x2), dropUniqueConstraint, dropTable, dropForeignKeyConstraint (x2), dropTable, dropForeignKeyConstraint (x2), dropUniqueConstraint, dropTable, createIndex', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-1.9.1.xml::1.9.1::keycloak
ALTER TABLE REALM ALTER COLUMN PRIVATE_KEY TYPE VARCHAR(4000);

ALTER TABLE REALM ALTER COLUMN PUBLIC_KEY TYPE VARCHAR(4000);

ALTER TABLE REALM ALTER COLUMN CERTIFICATE TYPE VARCHAR(4000);

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.9.1', 'keycloak', 'META-INF/jpa-changelog-1.9.1.xml', CURRENT_TIMESTAMP, 24, '7:80b5db88a5dda36ece5f235be8757615', 'modifyDataType (x3)', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/db2-jpa-changelog-1.9.1.xml::1.9.1::keycloak
INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.9.1', 'keycloak', 'META-INF/db2-jpa-changelog-1.9.1.xml', CURRENT_TIMESTAMP, 25, '7:1437310ed1305a9b93f8848f301726ce', 'modifyDataType (x2)', '', 'MARK_RAN', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-1.9.2.xml::1.9.2::keycloak
CREATE INDEX IDX_USER_EMAIL ON USER_ENTITY(EMAIL);

CREATE INDEX IDX_USER_ROLE_MAPPING ON USER_ROLE_MAPPING(USER_ID);

CREATE INDEX IDX_USER_GROUP_MAPPING ON USER_GROUP_MEMBERSHIP(USER_ID);

CREATE INDEX IDX_USER_CONSENT ON USER_CONSENT(USER_ID);

CREATE INDEX IDX_CONSENT_PROTMAPPER ON USER_CONSENT_PROT_MAPPER(USER_CONSENT_ID);

CREATE INDEX IDX_CONSENT_ROLE ON USER_CONSENT_ROLE(USER_CONSENT_ID);

CREATE INDEX IDX_USER_ATTRIBUTE ON USER_ATTRIBUTE(USER_ID);

CREATE INDEX IDX_USER_CREDENTIAL ON CREDENTIAL(USER_ID);

CREATE INDEX IDX_USER_REQACTIONS ON USER_REQUIRED_ACTION(USER_ID);

CREATE INDEX IDX_FEDIDENTITY_USER ON FEDERATED_IDENTITY(USER_ID);

CREATE INDEX IDX_FEDIDENTITY_FEDUSER ON FEDERATED_IDENTITY(FEDERATED_USER_ID);

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('1.9.2', 'keycloak', 'META-INF/jpa-changelog-1.9.2.xml', CURRENT_TIMESTAMP, 26, '7:b82ffb34850fa0836be16deefc6a87c4', 'createIndex (x11)', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-authz-2.0.0.xml::authz-2.0.0::psilva@redhat.com
CREATE TABLE RESOURCE_SERVER (ID VARCHAR(36) NOT NULL, CLIENT_ID VARCHAR(36) NOT NULL, ALLOW_RS_REMOTE_MGMT BOOLEAN DEFAULT FALSE NOT NULL, POLICY_ENFORCE_MODE VARCHAR(15) NOT NULL);

ALTER TABLE RESOURCE_SERVER ADD CONSTRAINT CONSTRAINT_FARS PRIMARY KEY (ID);

ALTER TABLE RESOURCE_SERVER ADD CONSTRAINT UK_AU8TT6T700S9V50BU18WS5HA6 UNIQUE (CLIENT_ID);

CREATE TABLE RESOURCE_SERVER_RESOURCE (ID VARCHAR(36) NOT NULL, NAME VARCHAR(255) NOT NULL, URI VARCHAR(255), TYPE VARCHAR(255), ICON_URI VARCHAR(255), OWNER VARCHAR(36) NOT NULL, RESOURCE_SERVER_ID VARCHAR(36) NOT NULL);

ALTER TABLE RESOURCE_SERVER_RESOURCE ADD CONSTRAINT CONSTRAINT_FARSR PRIMARY KEY (ID);

ALTER TABLE RESOURCE_SERVER_RESOURCE ADD CONSTRAINT FK_FRSRHO213XCX4WNKOG82SSRFY FOREIGN KEY (RESOURCE_SERVER_ID) REFERENCES RESOURCE_SERVER (ID);

ALTER TABLE RESOURCE_SERVER_RESOURCE ADD CONSTRAINT UK_FRSR6T700S9V50BU18WS5HA6 UNIQUE (NAME, OWNER, RESOURCE_SERVER_ID);

CREATE TABLE RESOURCE_SERVER_SCOPE (ID VARCHAR(36) NOT NULL, NAME VARCHAR(255) NOT NULL, ICON_URI VARCHAR(255), RESOURCE_SERVER_ID VARCHAR(36) NOT NULL);

ALTER TABLE RESOURCE_SERVER_SCOPE ADD CONSTRAINT CONSTRAINT_FARSRS PRIMARY KEY (ID);

ALTER TABLE RESOURCE_SERVER_SCOPE ADD CONSTRAINT FK_FRSRSO213XCX4WNKOG82SSRFY FOREIGN KEY (RESOURCE_SERVER_ID) REFERENCES RESOURCE_SERVER (ID);

ALTER TABLE RESOURCE_SERVER_SCOPE ADD CONSTRAINT UK_FRSRST700S9V50BU18WS5HA6 UNIQUE (NAME, RESOURCE_SERVER_ID);

CREATE TABLE RESOURCE_SERVER_POLICY (ID VARCHAR(36) NOT NULL, NAME VARCHAR(255) NOT NULL, DESCRIPTION VARCHAR(255), TYPE VARCHAR(255) NOT NULL, DECISION_STRATEGY VARCHAR(20), LOGIC VARCHAR(20), RESOURCE_SERVER_ID VARCHAR(36) NOT NULL);

ALTER TABLE RESOURCE_SERVER_POLICY ADD CONSTRAINT CONSTRAINT_FARSRP PRIMARY KEY (ID);

ALTER TABLE RESOURCE_SERVER_POLICY ADD CONSTRAINT FK_FRSRPO213XCX4WNKOG82SSRFY FOREIGN KEY (RESOURCE_SERVER_ID) REFERENCES RESOURCE_SERVER (ID);

ALTER TABLE RESOURCE_SERVER_POLICY ADD CONSTRAINT UK_FRSRPT700S9V50BU18WS5HA6 UNIQUE (NAME, RESOURCE_SERVER_ID);

CREATE TABLE POLICY_CONFIG (POLICY_ID VARCHAR(36) NOT NULL, NAME VARCHAR(255) NOT NULL, VALUE CLOB);

ALTER TABLE POLICY_CONFIG ADD CONSTRAINT CONSTRAINT_DPC PRIMARY KEY (POLICY_ID, NAME);

ALTER TABLE POLICY_CONFIG ADD CONSTRAINT FKDC34197CF864C4E43 FOREIGN KEY (POLICY_ID) REFERENCES RESOURCE_SERVER_POLICY (ID);

CREATE TABLE RESOURCE_SCOPE (RESOURCE_ID VARCHAR(36) NOT NULL, SCOPE_ID VARCHAR(36) NOT NULL);

ALTER TABLE RESOURCE_SCOPE ADD CONSTRAINT CONSTRAINT_FARSRSP PRIMARY KEY (RESOURCE_ID, SCOPE_ID);

ALTER TABLE RESOURCE_SCOPE ADD CONSTRAINT FK_FRSRPOS13XCX4WNKOG82SSRFY FOREIGN KEY (RESOURCE_ID) REFERENCES RESOURCE_SERVER_RESOURCE (ID);

ALTER TABLE RESOURCE_SCOPE ADD CONSTRAINT FK_FRSRPS213XCX4WNKOG82SSRFY FOREIGN KEY (SCOPE_ID) REFERENCES RESOURCE_SERVER_SCOPE (ID);

CREATE TABLE RESOURCE_POLICY (RESOURCE_ID VARCHAR(36) NOT NULL, POLICY_ID VARCHAR(36) NOT NULL);

ALTER TABLE RESOURCE_POLICY ADD CONSTRAINT CONSTRAINT_FARSRPP PRIMARY KEY (RESOURCE_ID, POLICY_ID);

ALTER TABLE RESOURCE_POLICY ADD CONSTRAINT FK_FRSRPOS53XCX4WNKOG82SSRFY FOREIGN KEY (RESOURCE_ID) REFERENCES RESOURCE_SERVER_RESOURCE (ID);

ALTER TABLE RESOURCE_POLICY ADD CONSTRAINT FK_FRSRPP213XCX4WNKOG82SSRFY FOREIGN KEY (POLICY_ID) REFERENCES RESOURCE_SERVER_POLICY (ID);

CREATE TABLE SCOPE_POLICY (SCOPE_ID VARCHAR(36) NOT NULL, POLICY_ID VARCHAR(36) NOT NULL);

ALTER TABLE SCOPE_POLICY ADD CONSTRAINT CONSTRAINT_FARSRSPS PRIMARY KEY (SCOPE_ID, POLICY_ID);

ALTER TABLE SCOPE_POLICY ADD CONSTRAINT FK_FRSRPASS3XCX4WNKOG82SSRFY FOREIGN KEY (SCOPE_ID) REFERENCES RESOURCE_SERVER_SCOPE (ID);

ALTER TABLE SCOPE_POLICY ADD CONSTRAINT FK_FRSRASP13XCX4WNKOG82SSRFY FOREIGN KEY (POLICY_ID) REFERENCES RESOURCE_SERVER_POLICY (ID);

CREATE TABLE ASSOCIATED_POLICY (POLICY_ID VARCHAR(36) NOT NULL, ASSOCIATED_POLICY_ID VARCHAR(36) NOT NULL);

ALTER TABLE ASSOCIATED_POLICY ADD CONSTRAINT CONSTRAINT_FARSRPAP PRIMARY KEY (POLICY_ID, ASSOCIATED_POLICY_ID);

ALTER TABLE ASSOCIATED_POLICY ADD CONSTRAINT FK_FRSRPAS14XCX4WNKOG82SSRFY FOREIGN KEY (POLICY_ID) REFERENCES RESOURCE_SERVER_POLICY (ID);

ALTER TABLE ASSOCIATED_POLICY ADD CONSTRAINT FK_FRSR5S213XCX4WNKOG82SSRFY FOREIGN KEY (ASSOCIATED_POLICY_ID) REFERENCES RESOURCE_SERVER_POLICY (ID);

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('authz-2.0.0', 'psilva@redhat.com', 'META-INF/jpa-changelog-authz-2.0.0.xml', CURRENT_TIMESTAMP, 27, '7:9cc98082921330d8d9266decdd4bd658', 'createTable, addPrimaryKey, addUniqueConstraint, createTable, addPrimaryKey, addForeignKeyConstraint, addUniqueConstraint, createTable, addPrimaryKey, addForeignKeyConstraint, addUniqueConstraint, createTable, addPrimaryKey, addForeignKeyConstrain...', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-authz-2.5.1.xml::authz-2.5.1::psilva@redhat.com
UPDATE RESOURCE_SERVER_POLICY SET TYPE = 'rules' WHERE TYPE = 'drools';

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('authz-2.5.1', 'psilva@redhat.com', 'META-INF/jpa-changelog-authz-2.5.1.xml', CURRENT_TIMESTAMP, 28, '7:03d64aeed9cb52b969bd30a7ac0db57e', 'update', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-2.1.0.xml::2.1.0::bburke@redhat.com
CREATE TABLE BROKER_LINK (IDENTITY_PROVIDER VARCHAR(255) NOT NULL, STORAGE_PROVIDER_ID VARCHAR(255), REALM_ID VARCHAR(36) NOT NULL, BROKER_USER_ID VARCHAR(255), BROKER_USERNAME VARCHAR(255), TOKEN CLOB, USER_ID VARCHAR(255) NOT NULL);

CREATE TABLE FED_USER_ATTRIBUTE (ID VARCHAR(36) NOT NULL, NAME VARCHAR(255) NOT NULL, USER_ID VARCHAR(255) NOT NULL, REALM_ID VARCHAR(36) NOT NULL, STORAGE_PROVIDER_ID VARCHAR(36), VALUE VARCHAR(2024));

CREATE TABLE FED_USER_CONSENT (ID VARCHAR(36) NOT NULL, CLIENT_ID VARCHAR(36) NOT NULL, USER_ID VARCHAR(255) NOT NULL, REALM_ID VARCHAR(36) NOT NULL, STORAGE_PROVIDER_ID VARCHAR(36));

CREATE TABLE FED_USER_CONSENT_ROLE (USER_CONSENT_ID VARCHAR(36) NOT NULL, ROLE_ID VARCHAR(36) NOT NULL);

CREATE TABLE FED_USER_CONSENT_PROT_MAPPER (USER_CONSENT_ID VARCHAR(36) NOT NULL, PROTOCOL_MAPPER_ID VARCHAR(36) NOT NULL);

CREATE TABLE FED_USER_CREDENTIAL (ID VARCHAR(36) NOT NULL, DEVICE VARCHAR(255), HASH_ITERATIONS INT, SALT BLOB(16), TYPE VARCHAR(255), VALUE VARCHAR(255), CREATED_DATE BIGINT, COUNTER INT DEFAULT 0, DIGITS INT DEFAULT 6, PERIOD INT DEFAULT 30, ALGORITHM VARCHAR(36) DEFAULT 'HmacSHA1', USER_ID VARCHAR(255) NOT NULL, REALM_ID VARCHAR(36) NOT NULL, STORAGE_PROVIDER_ID VARCHAR(36));

CREATE TABLE FED_USER_GROUP_MEMBERSHIP (GROUP_ID VARCHAR(36) NOT NULL, USER_ID VARCHAR(255) NOT NULL, REALM_ID VARCHAR(36) NOT NULL, STORAGE_PROVIDER_ID VARCHAR(36));

CREATE TABLE FED_USER_REQUIRED_ACTION (REQUIRED_ACTION VARCHAR(255) DEFAULT ' ' NOT NULL, USER_ID VARCHAR(255) NOT NULL, REALM_ID VARCHAR(36) NOT NULL, STORAGE_PROVIDER_ID VARCHAR(36));

CREATE TABLE FED_USER_ROLE_MAPPING (ROLE_ID VARCHAR(36) NOT NULL, USER_ID VARCHAR(255) NOT NULL, REALM_ID VARCHAR(36) NOT NULL, STORAGE_PROVIDER_ID VARCHAR(36));

CREATE TABLE COMPONENT_CONFIG (ID VARCHAR(36) NOT NULL, COMPONENT_ID VARCHAR(36) NOT NULL, NAME VARCHAR(255) NOT NULL, VALUE VARCHAR(4000));

CREATE TABLE COMPONENT (ID VARCHAR(36) NOT NULL, NAME VARCHAR(255), PARENT_ID VARCHAR(36), PROVIDER_ID VARCHAR(36), PROVIDER_TYPE VARCHAR(255), REALM_ID VARCHAR(36));

ALTER TABLE BROKER_LINK ADD CONSTRAINT CONSTR_BROKER_LINK_PK PRIMARY KEY (IDENTITY_PROVIDER, USER_ID);

ALTER TABLE FED_USER_ATTRIBUTE ADD CONSTRAINT CONSTR_FED_USER_ATTR_PK PRIMARY KEY (ID);

ALTER TABLE FED_USER_CONSENT ADD CONSTRAINT CONSTR_FED_USER_CONSENT_PK PRIMARY KEY (ID);

ALTER TABLE FED_USER_CONSENT_ROLE ADD CONSTRAINT CONSTR_USER_CONSENT_ROLE_PK PRIMARY KEY (USER_CONSENT_ID, ROLE_ID);

ALTER TABLE FED_USER_CONSENT_PROT_MAPPER ADD CONSTRAINT CONSTR_USER_CONSENT_PROTM_PK PRIMARY KEY (USER_CONSENT_ID, PROTOCOL_MAPPER_ID);

ALTER TABLE FED_USER_CREDENTIAL ADD CONSTRAINT CONSTR_FED_USER_CRED_PK PRIMARY KEY (ID);

ALTER TABLE FED_USER_GROUP_MEMBERSHIP ADD CONSTRAINT CONSTR_FED_USER_GROUP PRIMARY KEY (GROUP_ID, USER_ID);

ALTER TABLE FED_USER_ROLE_MAPPING ADD CONSTRAINT CONSTR_FED_USER_ROLE PRIMARY KEY (ROLE_ID, USER_ID);

ALTER TABLE FED_USER_REQUIRED_ACTION ADD CONSTRAINT CONSTR_FED_REQUIRED_ACTION PRIMARY KEY (REQUIRED_ACTION, USER_ID);

ALTER TABLE COMPONENT ADD CONSTRAINT CONSTR_COMPONENT_PK PRIMARY KEY (ID);

ALTER TABLE COMPONENT_CONFIG ADD CONSTRAINT CONSTR_COMPONENT_CONFIG_PK PRIMARY KEY (ID);

ALTER TABLE COMPONENT ADD CONSTRAINT FK_COMPONENT_REALM FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

ALTER TABLE COMPONENT_CONFIG ADD CONSTRAINT FK_COMPONENT_CONFIG FOREIGN KEY (COMPONENT_ID) REFERENCES COMPONENT (ID);

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('2.1.0', 'bburke@redhat.com', 'META-INF/jpa-changelog-2.1.0.xml', CURRENT_TIMESTAMP, 29, '7:e01599a82bf8d6dc22a9da506e22e868', 'createTable (x11), addPrimaryKey (x11), addForeignKeyConstraint (x2)', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-2.2.0.xml::2.2.0::bburke@redhat.com
ALTER TABLE ADMIN_EVENT_ENTITY ADD RESOURCE_TYPE VARCHAR(64);

CREATE TABLE CREDENTIAL_ATTRIBUTE (ID VARCHAR(36) NOT NULL, CREDENTIAL_ID VARCHAR(36) NOT NULL, NAME VARCHAR(255) NOT NULL, VALUE VARCHAR(4000));

CREATE TABLE FED_CREDENTIAL_ATTRIBUTE (ID VARCHAR(36) NOT NULL, CREDENTIAL_ID VARCHAR(36) NOT NULL, NAME VARCHAR(255) NOT NULL, VALUE VARCHAR(4000));

ALTER TABLE CREDENTIAL ALTER COLUMN VALUE TYPE VARCHAR(4000);

ALTER TABLE FED_CREDENTIAL_ATTRIBUTE ADD CONSTRAINT FK_FED_CRED_ATTR FOREIGN KEY (CREDENTIAL_ID) REFERENCES FED_USER_CREDENTIAL (ID);

ALTER TABLE CREDENTIAL_ATTRIBUTE ADD CONSTRAINT FK_CRED_ATTR FOREIGN KEY (CREDENTIAL_ID) REFERENCES CREDENTIAL (ID);

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('2.2.0', 'bburke@redhat.com', 'META-INF/jpa-changelog-2.2.0.xml', CURRENT_TIMESTAMP, 30, '7:53188c3eb1107546e6f765835705b6c1', 'addColumn, createTable (x2), modifyDataType, addForeignKeyConstraint (x2)', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-2.3.0.xml::2.3.0::bburke@redhat.com
CREATE TABLE FEDERATED_USER (ID VARCHAR(255) NOT NULL, STORAGE_PROVIDER_ID VARCHAR(255), REALM_ID VARCHAR(36) NOT NULL);

ALTER TABLE FEDERATED_USER ADD CONSTRAINT CONSTR_FEDERATED_USER PRIMARY KEY (ID);

ALTER TABLE USER_ENTITY ALTER COLUMN  TOTP SET DEFAULT NULL;

ALTER TABLE USER_ENTITY DROP COLUMN TOTP;

ALTER TABLE IDENTITY_PROVIDER ADD PROVIDER_DISPLAY_NAME VARCHAR(255);

ALTER TABLE COMPONENT ADD SUB_TYPE VARCHAR(255);

ALTER TABLE REALM DROP COLUMN CODE_SECRET;

ALTER TABLE REALM DROP COLUMN PRIVATE_KEY;

ALTER TABLE REALM DROP COLUMN PUBLIC_KEY;

ALTER TABLE REALM DROP COLUMN CERTIFICATE;

ALTER TABLE USER_CONSENT ADD CREATED_DATE BIGINT;

ALTER TABLE USER_CONSENT ADD LAST_UPDATED_DATE BIGINT;

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('2.3.0', 'bburke@redhat.com', 'META-INF/jpa-changelog-2.3.0.xml', CURRENT_TIMESTAMP, 31, '7:d6e6f3bc57a0c5586737d1351725d4d4', 'createTable, addPrimaryKey, dropDefaultValue, dropColumn, addColumn (x2), customChange, dropColumn (x4), addColumn', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-2.4.0.xml::2.4.0::bburke@redhat.com
INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('2.4.0', 'bburke@redhat.com', 'META-INF/jpa-changelog-2.4.0.xml', CURRENT_TIMESTAMP, 32, '7:454d604fbd755d9df3fd9c6329043aa5', 'customChange', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-2.5.0.xml::2.5.0::bburke@redhat.com
ALTER TABLE OFFLINE_USER_SESSION ALTER COLUMN USER_ID TYPE VARCHAR(255);

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('2.5.0', 'bburke@redhat.com', 'META-INF/jpa-changelog-2.5.0.xml', CURRENT_TIMESTAMP, 33, '7:57e98a3077e29caf562f7dbf80c72600', 'customChange, modifyDataType', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-2.5.0.xml::2.5.0-unicode-oracle::hmlnarik@redhat.com
INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('2.5.0-unicode-oracle', 'hmlnarik@redhat.com', 'META-INF/jpa-changelog-2.5.0.xml', CURRENT_TIMESTAMP, 34, '7:e4c7e8f2256210aee71ddc42f538b57a', 'modifyDataType (x13), addColumn, sql, dropColumn, renameColumn, modifyDataType (x2)', '', 'MARK_RAN', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-2.5.0.xml::2.5.0-unicode-other-dbs::hmlnarik@redhat.com
ALTER TABLE AUTHENTICATION_FLOW ALTER COLUMN DESCRIPTION TYPE NVARCHAR(255);

ALTER TABLE CLIENT_TEMPLATE ALTER COLUMN DESCRIPTION TYPE NVARCHAR(255);

ALTER TABLE RESOURCE_SERVER_POLICY ALTER COLUMN DESCRIPTION TYPE NVARCHAR(255);

ALTER TABLE CLIENT ALTER COLUMN DESCRIPTION TYPE NVARCHAR(255);

ALTER TABLE CLIENT ALTER COLUMN NAME TYPE NVARCHAR(255);

ALTER TABLE USER_ENTITY DROP CONSTRAINT UK_RU8TT6T700S9V50BU18WS5HA6;

ALTER TABLE USER_ENTITY ALTER COLUMN FIRST_NAME TYPE NVARCHAR(255);

ALTER TABLE USER_ENTITY ALTER COLUMN LAST_NAME TYPE NVARCHAR(255);

ALTER TABLE USER_ENTITY ALTER COLUMN USERNAME TYPE NVARCHAR(255);

ALTER TABLE USER_ENTITY ADD CONSTRAINT UK_RU8TT6T700S9V50BU18WS5HA6 UNIQUE (REALM_ID, USERNAME);

ALTER TABLE USERNAME_LOGIN_FAILURE DROP PRIMARY KEY;

ALTER TABLE USERNAME_LOGIN_FAILURE ALTER COLUMN USERNAME TYPE NVARCHAR(255);

ALTER TABLE USERNAME_LOGIN_FAILURE ALTER COLUMN  USERNAME SET NOT NULL;

ALTER TABLE USERNAME_LOGIN_FAILURE ADD CONSTRAINT "CONSTRAINT_17-2" PRIMARY KEY (REALM_ID, USERNAME);

ALTER TABLE KEYCLOAK_GROUP ALTER COLUMN NAME TYPE NVARCHAR(255);

ALTER TABLE USER_ATTRIBUTE ALTER COLUMN VALUE TYPE NVARCHAR(255);

ALTER TABLE GROUP_ATTRIBUTE ALTER COLUMN VALUE TYPE NVARCHAR(255);

ALTER TABLE REALM_ATTRIBUTE ALTER COLUMN VALUE TYPE NVARCHAR(255);

ALTER TABLE COMPONENT_CONFIG ALTER COLUMN VALUE TYPE NVARCHAR(4000);

ALTER TABLE KEYCLOAK_ROLE DROP CONSTRAINT "UK_J3RWUVD56ONTGSUHOGM184WW2-2";

ALTER TABLE KEYCLOAK_ROLE ALTER COLUMN NAME TYPE NVARCHAR(255);

ALTER TABLE KEYCLOAK_ROLE ADD CONSTRAINT "UK_J3RWUVD56ONTGSUHOGM184WW2-2" UNIQUE (NAME, CLIENT_REALM_CONSTRAINT);

ALTER TABLE KEYCLOAK_ROLE ALTER COLUMN DESCRIPTION TYPE NVARCHAR(255);

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('2.5.0-unicode-other-dbs', 'hmlnarik@redhat.com', 'META-INF/jpa-changelog-2.5.0.xml', CURRENT_TIMESTAMP, 35, '7:09a43c97e49bc626460480aa1379b522', 'modifyDataType (x5), dropUniqueConstraint, modifyDataType (x3), addUniqueConstraint, dropPrimaryKey, modifyDataType, addNotNullConstraint, addPrimaryKey, modifyDataType (x5), dropUniqueConstraint, modifyDataType, addUniqueConstraint, modifyDataType', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-2.5.0.xml::2.5.0-duplicate-email-support::slawomir@dabek.name
ALTER TABLE REALM ADD LOGIN_WITH_EMAIL_ALLOWED BOOLEAN NOT NULL DEFAULT TRUE;

ALTER TABLE REALM ADD DUPLICATE_EMAILS_ALLOWED BOOLEAN NOT NULL DEFAULT FALSE;

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('2.5.0-duplicate-email-support', 'slawomir@dabek.name', 'META-INF/jpa-changelog-2.5.0.xml', CURRENT_TIMESTAMP, 36, '7:26bfc7c74fefa9126f2ce702fb775553', 'addColumn', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-2.5.0.xml::2.5.0-unique-group-names::hmlnarik@redhat.com
ALTER TABLE KEYCLOAK_GROUP ADD CONSTRAINT SIBLING_NAMES UNIQUE (REALM_ID, PARENT_GROUP, NAME);

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('2.5.0-unique-group-names', 'hmlnarik@redhat.com', 'META-INF/jpa-changelog-2.5.0.xml', CURRENT_TIMESTAMP, 37, '7:a161e2ae671a9020fff61e996a207377', 'addUniqueConstraint', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-2.5.1.xml::2.5.1::bburke@redhat.com
ALTER TABLE FED_USER_CONSENT ADD CREATED_DATE BIGINT;

ALTER TABLE FED_USER_CONSENT ADD LAST_UPDATED_DATE BIGINT;

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('2.5.1', 'bburke@redhat.com', 'META-INF/jpa-changelog-2.5.1.xml', CURRENT_TIMESTAMP, 38, '7:37fc1781855ac5388c494f1442b3f717', 'addColumn', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-3.0.0.xml::3.0.0::bburke@redhat.com
ALTER TABLE IDENTITY_PROVIDER ADD LINK_ONLY BOOLEAN NOT NULL DEFAULT FALSE;

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('3.0.0', 'bburke@redhat.com', 'META-INF/jpa-changelog-3.0.0.xml', CURRENT_TIMESTAMP, 39, '7:13a27db0dae6049541136adad7261d27', 'addColumn', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-3.2.0.xml::3.2.0-fix::keycloak
ALTER TABLE CLIENT_INITIAL_ACCESS ALTER COLUMN  REALM_ID SET NOT NULL;

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('3.2.0-fix', 'keycloak', 'META-INF/jpa-changelog-3.2.0.xml', CURRENT_TIMESTAMP, 40, '7:550300617e3b59e8af3a6294df8248a3', 'addNotNullConstraint', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-3.2.0.xml::3.2.0-fixed::keycloak
ALTER TABLE REALM ADD DOCKER_AUTH_FLOW VARCHAR(36);

ALTER TABLE OFFLINE_CLIENT_SESSION DROP PRIMARY KEY;

ALTER TABLE OFFLINE_CLIENT_SESSION DROP COLUMN CLIENT_SESSION_ID;

ALTER TABLE OFFLINE_CLIENT_SESSION ADD CONSTRAINT CONSTRAINT_OFFL_CL_SES_PK3 PRIMARY KEY (USER_SESSION_ID, CLIENT_ID, OFFLINE_FLAG);

CREATE TABLE CLIENT_INITIAL_ACCESS (ID VARCHAR(36) NOT NULL, REALM_ID VARCHAR(36) NOT NULL, TIMESTAMP INT, EXPIRATION INT, COUNT INT, REMAINING_COUNT INT);

ALTER TABLE CLIENT_INITIAL_ACCESS ADD CONSTRAINT CNSTR_CLIENT_INIT_ACC_PK PRIMARY KEY (ID);

ALTER TABLE CLIENT_INITIAL_ACCESS ADD CONSTRAINT FK_CLIENT_INIT_ACC_REALM FOREIGN KEY (REALM_ID) REFERENCES REALM (ID);

CREATE INDEX IDX_ASSOC_POL_ASSOC_POL_ID ON ASSOCIATED_POLICY(ASSOCIATED_POLICY_ID);

CREATE INDEX IDX_AUTH_EXEC_REALM_FLOW ON AUTHENTICATION_EXECUTION(REALM_ID, FLOW_ID);

CREATE INDEX IDX_AUTH_EXEC_FLOW ON AUTHENTICATION_EXECUTION(FLOW_ID);

CREATE INDEX IDX_AUTH_FLOW_REALM ON AUTHENTICATION_FLOW(REALM_ID);

CREATE INDEX IDX_AUTH_CONFIG_REALM ON AUTHENTICATOR_CONFIG(REALM_ID);

CREATE INDEX IDX_CLIENT_CLIENT_TEMPL_ID ON CLIENT(CLIENT_TEMPLATE_ID);

CREATE INDEX IDX_CLIENT_DEF_ROLES_CLIENT ON CLIENT_DEFAULT_ROLES(CLIENT_ID);

CREATE INDEX IDX_CLIENT_ID_PROV_MAP_CLIENT ON CLIENT_IDENTITY_PROV_MAPPING(CLIENT_ID);

CREATE INDEX IDX_CLIENT_SESSION_SESSION ON CLIENT_SESSION(SESSION_ID);

CREATE INDEX IDX_COMPONENT_REALM ON COMPONENT(REALM_ID);

CREATE INDEX IDX_COMPO_CONFIG_COMPO ON COMPONENT_CONFIG(COMPONENT_ID);

CREATE INDEX IDX_COMPOSITE ON COMPOSITE_ROLE(COMPOSITE);

CREATE INDEX IDX_COMPOSITE_CHILD ON COMPOSITE_ROLE(CHILD_ROLE);

CREATE INDEX IDX_CREDENTIAL_ATTR_CRED ON CREDENTIAL_ATTRIBUTE(CREDENTIAL_ID);

CREATE INDEX IDX_FED_CRED_ATTR_CRED ON FED_CREDENTIAL_ATTRIBUTE(CREDENTIAL_ID);

CREATE INDEX IDX_GROUP_ATTR_GROUP ON GROUP_ATTRIBUTE(GROUP_ID);

CREATE INDEX IDX_GROUP_ROLE_MAPP_GROUP ON GROUP_ROLE_MAPPING(GROUP_ID);

CREATE INDEX IDX_IDENT_PROV_REALM ON IDENTITY_PROVIDER(REALM_ID);

CREATE INDEX IDX_ID_PROV_MAPP_REALM ON IDENTITY_PROVIDER_MAPPER(REALM_ID);

CREATE INDEX IDX_KEYCLOAK_ROLE_CLIENT ON KEYCLOAK_ROLE(CLIENT);

CREATE INDEX IDX_KEYCLOAK_ROLE_REALM ON KEYCLOAK_ROLE(REALM);

CREATE INDEX IDX_PROTOCOL_MAPPER_CLIENT ON PROTOCOL_MAPPER(CLIENT_ID);

CREATE INDEX IDX_PROTO_MAPP_CLIENT_TEMPL ON PROTOCOL_MAPPER(CLIENT_TEMPLATE_ID);

CREATE INDEX IDX_REALM_MASTER_ADM_CLI ON REALM(MASTER_ADMIN_CLIENT);

CREATE INDEX IDX_REALM_ATTR_REALM ON REALM_ATTRIBUTE(REALM_ID);

CREATE INDEX IDX_REALM_DEF_GRP_REALM ON REALM_DEFAULT_GROUPS(REALM_ID);

CREATE INDEX IDX_REALM_DEF_ROLES_REALM ON REALM_DEFAULT_ROLES(REALM_ID);

CREATE INDEX IDX_REALM_EVT_TYPES_REALM ON REALM_ENABLED_EVENT_TYPES(REALM_ID);

CREATE INDEX IDX_REALM_EVT_LIST_REALM ON REALM_EVENTS_LISTENERS(REALM_ID);

CREATE INDEX IDX_REALM_SUPP_LOCAL_REALM ON REALM_SUPPORTED_LOCALES(REALM_ID);

CREATE INDEX IDX_REDIR_URI_CLIENT ON REDIRECT_URIS(CLIENT_ID);

CREATE INDEX IDX_REQ_ACT_PROV_REALM ON REQUIRED_ACTION_PROVIDER(REALM_ID);

CREATE INDEX IDX_RES_POLICY_POLICY ON RESOURCE_POLICY(POLICY_ID);

CREATE INDEX IDX_RES_SCOPE_SCOPE ON RESOURCE_SCOPE(SCOPE_ID);

CREATE INDEX IDX_RES_SERV_POL_RES_SERV ON RESOURCE_SERVER_POLICY(RESOURCE_SERVER_ID);

CREATE INDEX IDX_RES_SRV_RES_RES_SRV ON RESOURCE_SERVER_RESOURCE(RESOURCE_SERVER_ID);

CREATE INDEX IDX_RES_SRV_SCOPE_RES_SRV ON RESOURCE_SERVER_SCOPE(RESOURCE_SERVER_ID);

CREATE INDEX IDX_SCOPE_MAPPING_ROLE ON SCOPE_MAPPING(ROLE_ID);

CREATE INDEX IDX_SCOPE_POLICY_POLICY ON SCOPE_POLICY(POLICY_ID);

CREATE INDEX IDX_TEMPL_SCOPE_MAPP_ROLE ON TEMPLATE_SCOPE_MAPPING(ROLE_ID);

CREATE INDEX IDX_USR_FED_MAP_FED_PRV ON USER_FEDERATION_MAPPER(FEDERATION_PROVIDER_ID);

CREATE INDEX IDX_USR_FED_MAP_REALM ON USER_FEDERATION_MAPPER(REALM_ID);

CREATE INDEX IDX_USR_FED_PRV_REALM ON USER_FEDERATION_PROVIDER(REALM_ID);

CREATE INDEX IDX_WEB_ORIG_CLIENT ON WEB_ORIGINS(CLIENT_ID);

CREATE INDEX IDX_CLIENT_INIT_ACC_REALM ON CLIENT_INITIAL_ACCESS(REALM_ID);

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('3.2.0-fixed', 'keycloak', 'META-INF/jpa-changelog-3.2.0.xml', CURRENT_TIMESTAMP, 41, '7:a72a7858967bd414835d19e04d880312', 'addColumn, dropPrimaryKey, dropColumn, addPrimaryKey, createTable, addPrimaryKey, addForeignKeyConstraint, createIndex (x45)', '', 'EXECUTED', NULL, NULL, '3.4.1');

-- Changeset META-INF/jpa-changelog-3.3.0.xml::3.3.0::keycloak
ALTER TABLE USER_ENTITY ADD NOT_BEFORE INT NOT NULL DEFAULT 0;

INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE) VALUES ('3.3.0', 'keycloak', 'META-INF/jpa-changelog-3.3.0.xml', CURRENT_TIMESTAMP, 42, '7:94edff7cf9ce179e7e85f0cd78a3cf2c', 'addColumn', '', 'EXECUTED', NULL, NULL, '3.4.1');