keycloak-aplcache

migrate fix

1/31/2018 4:11:46 PM

Bill Burke

Commit: 26411a1

Tree: 62e013f

Parents: 126dd70

Changes

model/jpa/src/main/resources/META-INF/jpa-changelog-4.0.0.xml 9(+7 -2)

Details

model/jpa/src/main/resources/META-INF/jpa-changelog-4.0.0.xml 9(+7 -2)

diff --git a/model/jpa/src/main/resources/META-INF/jpa-changelog-4.0.0.xml b/model/jpa/src/main/resources/META-INF/jpa-changelog-4.0.0.xml
index 3a81cba..00f1a11 100644
--- a/model/jpa/src/main/resources/META-INF/jpa-changelog-4.0.0.xml
+++ b/model/jpa/src/main/resources/META-INF/jpa-changelog-4.0.0.xml
@@ -69,7 +69,6 @@
         </createIndex>
 
         <!-- Modify OFFLINE_CLIENT_SESSION -->
-        <dropPrimaryKey tableName="OFFLINE_CLIENT_SESSION" constraintName="CONSTRAINT_OFFL_CL_SES_PK3"/>
         <addColumn tableName="OFFLINE_CLIENT_SESSION">
             <column name="CLIENT_STORAGE_PROVIDER" type="VARCHAR(36)" defaultValue="local">
                 <constraints nullable="false"/>
@@ -78,7 +77,13 @@
                 <constraints nullable="false"/>
             </column>
         </addColumn>
-        <modifyDataType tableName="OFFLINE_CLIENT_SESSION" columnName="CLIENT_ID" newDataType="VARCHAR(255)"/>
+        <update tableName="OFFLINE_CLIENT_SESSION">
+            <column name="CLIENT_STORAGE_PROVIDER" value="local"/>
+        </update>
+        <update tableName="EXTERNAL_CLIENT_ID">
+            <column name="EXTERNAL_CLIENT_ID" value="local"/>
+        </update>
+        <dropPrimaryKey tableName="OFFLINE_CLIENT_SESSION" constraintName="CONSTRAINT_OFFL_CL_SES_PK3"/>
         <addPrimaryKey columnNames="USER_SESSION_ID,CLIENT_ID, CLIENT_STORAGE_PROVIDER, EXTERNAL_CLIENT_ID, OFFLINE_FLAG" constraintName="CONSTRAINT_OFFL_CL_SES_PK3" tableName="OFFLINE_CLIENT_SESSION"/>
 
      </changeSet>