keycloak-plugins/radius-disconnect-plugin/src/main/resources/dm-changelog.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd">
<changeSet author="vaszakharchenko@gmail.com" id="dm-1.0.1">
<validCheckSum>7:137aaa40d056e0c13a09a945a52fda58</validCheckSum>
<createTable tableName="RADIUS_DM_SESSION">
<column name="SESSION_ID" type="VARCHAR(128)">
<constraints nullable="false"/>
</column>
<column name="CLIENT_ID" type="VARCHAR(36)">
<constraints nullable="false"/>
</column>
<column name="USER_ID" type="VARCHAR(36)">
<constraints nullable="false"/>
</column>
<column name="REALM_ID" type="VARCHAR(36)">
<constraints nullable="false"/>
</column>
<column name="KEYCLOAK_SESSION_ID" type="VARCHAR(36)">
<constraints nullable="false"/>
</column>
<column name="REMOTE_ADDRESS" type="VARCHAR(256)">
<constraints nullable="false"/>
</column>
<column name="USER_NAME" type="VARCHAR(256)">
<constraints nullable="false"/>
</column>
<column name="NAS_PORT" type="VARCHAR(36)"/>
<column name="NAS_PORT_TYPE" type="VARCHAR(36)"/>
<column name="NAS_IP_ADDRESS" type="VARCHAR(64)"/>
<column name="FRAMED_IP_ADDRESS" type="VARCHAR(36)"/>
<column name="CALLING_STATION_ID" type="VARCHAR(36)"/>
<column name="CREATED_DATE" type="TIMESTAMP">
<constraints nullable="false"/>
</column>
<column name="END_DATE" type="TIMESTAMP">
<constraints nullable="false"/>
</column>
</createTable>
<addPrimaryKey
constraintName="PK_RADIUS_DM_SESSION"
tableName="RADIUS_DM_SESSION"
columnNames="SESSION_ID"
/>
<addForeignKeyConstraint baseTableName="RADIUS_DM_SESSION" baseColumnNames="REALM_ID"
constraintName="fk_dm_session_realm" referencedTableName="REALM"
referencedColumnNames="ID" onDelete="CASCADE"/>
<addForeignKeyConstraint baseTableName="RADIUS_DM_SESSION" baseColumnNames="USER_ID"
constraintName="fk_dm_session_user" referencedTableName="USER_ENTITY"
referencedColumnNames="ID" onDelete="CASCADE"/>
<addForeignKeyConstraint baseTableName="RADIUS_DM_SESSION" baseColumnNames="CLIENT_ID"
constraintName="fk_dm_client_user" referencedTableName="CLIENT"
referencedColumnNames="ID" onDelete="CASCADE"/>
</changeSet>
<changeSet author="vaszakharchenko@gmail.com" id="dm-1.0.1_2">
<validCheckSum>7:8ea61f55f1ffe230e4c21a3e668f0090</validCheckSum>
<dropNotNullConstraint tableName="RADIUS_DM_SESSION" columnName="END_DATE" columnDataType="TIMESTAMP"/>
</changeSet>
<changeSet author="vaszakharchenko@gmail.com" id="dm-1.0.1_3">
<validCheckSum>7:d44077774930b99384c8e4dd8182f15e</validCheckSum>
<addColumn tableName="RADIUS_DM_SESSION">
<column name="END_STATUS" type="VARCHAR(36)"/>
<column name="SECRET" type="VARCHAR(36)"/>
<column name="END_MESSAGE" type="VARCHAR(256)"/>
<column name="END_ATTEMPTS" type="INTEGER" defaultValue="0"/>
</addColumn>
</changeSet>
<changeSet author="vaszakharchenko@gmail.com" id="dm-1.0.1_4">
<validCheckSum>7:eb05e954dcc4aa1fba085b69748a02ff</validCheckSum>
<addColumn tableName="RADIUS_DM_SESSION">
<column name="RADIUS_SESSION_ID" type="VARCHAR(36)"/>
<column name="MODIFY_DATE" type="TIMESTAMP">
<constraints nullable="false"/>
</column>
</addColumn>
</changeSet>
<changeSet author="vaszakharchenko@gmail.com" id="dm-1.0.1_5">
<validCheckSum>7:a943a809d598b5586a87ea01cfab075f</validCheckSum>
<addColumn tableName="RADIUS_DM_SESSION">
<column name="END_CAUSE" type="VARCHAR(256)"/>
</addColumn>
</changeSet>
<changeSet author="vaszakharchenko@gmail.com" id="dm-1.0.1_6">
<validCheckSum>7:201d7b0e8be839107c2ef220bd83f6b5</validCheckSum>
<dropColumn columnName="END_CAUSE" tableName="RADIUS_DM_SESSION"/>
<dropColumn columnName="END_STATUS" tableName="RADIUS_DM_SESSION"/>
<dropColumn columnName="END_MESSAGE" tableName="RADIUS_DM_SESSION"/>
<dropColumn columnName="END_ATTEMPTS" tableName="RADIUS_DM_SESSION"/>
<dropColumn columnName="END_DATE" tableName="RADIUS_DM_SESSION"/>
<createTable tableName="RADIUS_DM_CLIENT_END_SESSION">
<column name="SESSION_ID" type="VARCHAR(128)">
<constraints nullable="false"/>
</column>
<column name="END_CAUSE" type="VARCHAR(256)"/>
<column name="END_DATE" type="TIMESTAMP">
<constraints nullable="false"/>
</column>
<column name="MODIFY_DATE" type="TIMESTAMP">
<constraints nullable="false"/>
</column>
</createTable>
<addPrimaryKey
constraintName="PK_RADIUS_C_DM_END_SESSION"
tableName="RADIUS_DM_CLIENT_END_SESSION"
columnNames="SESSION_ID"
/>
<addForeignKeyConstraint baseTableName="RADIUS_DM_CLIENT_END_SESSION" baseColumnNames="SESSION_ID"
constraintName="fk_dm_e_session_id" referencedTableName="RADIUS_DM_SESSION"
referencedColumnNames="SESSION_ID" onDelete="CASCADE"/>
<createTable tableName="RADIUS_DM_KEYCLOAK_END_SESSION">
<column name="SESSION_ID" type="VARCHAR(128)">
<constraints nullable="false"/>
</column>
<column name="END_DATE" type="TIMESTAMP">
<constraints nullable="false"/>
</column>
<column name="MODIFY_DATE" type="TIMESTAMP">
<constraints nullable="false"/>
</column>
<column name="END_STATUS" type="VARCHAR(36)"/>
<column name="END_MESSAGE" type="VARCHAR(256)"/>
<column name="END_ATTEMPTS" type="INTEGER" defaultValue="0"/>
</createTable>
<addPrimaryKey
constraintName="PK_RADIUS_DM_END_SESSION"
tableName="RADIUS_DM_KEYCLOAK_END_SESSION"
columnNames="SESSION_ID"
/>
<addForeignKeyConstraint baseTableName="RADIUS_DM_KEYCLOAK_END_SESSION" baseColumnNames="SESSION_ID"
constraintName="fk_dm_k_session_id" referencedTableName="RADIUS_DM_SESSION"
referencedColumnNames="SESSION_ID" onDelete="CASCADE"/>
</changeSet>
<changeSet author="vaszakharchenko@gmail.com" id="dm-1.0.1_7">
<validCheckSum>7:060fcc94974472cf8012b77e533e2bff</validCheckSum>
<dropNotNullConstraint tableName="RADIUS_DM_KEYCLOAK_END_SESSION" columnName="END_DATE" columnDataType="TIMESTAMP"/>
</changeSet>
<changeSet author="vaszakharchenko@gmail.com" id="dm-1.3.3">
<validCheckSum>7:c71fd24ff2f1165fb18411238ee45f97</validCheckSum>
<addColumn tableName="RADIUS_DM_SESSION">
<column name="CALLED_STATION_ID" type="VARCHAR(36)"/>
</addColumn>
</changeSet>
</databaseChangeLog>