<?xml version="1.0" encoding="utf-8" ?>
<database Name="otrs">

<!-- Drop old sessions table and create the new one -->
<TableDrop Name="sessions"/>
<TableCreate Name="sessions">
    <Column Name="id" Required="true" PrimaryKey="true" AutoIncrement="true" Type="BIGINT"/>
    <Column Name="session_id" Required="true" Size="100" Type="VARCHAR"/>
    <Column Name="data_key" Required="true" Size="100" Type="VARCHAR"/>
    <Column Name="data_value" Required="false" Size="10000" Type="VARCHAR"/>
    <Column Name="serialized" Required="true" Type="SMALLINT"/>
    <Index Name="sessions_session_id_data_key">
        <IndexColumn Name="session_id"/>
        <IndexColumn Name="data_key"/>
    </Index>
    <Index Name="sessions_data_key">
        <IndexColumn Name="data_key"/>
    </Index>
</TableCreate>

</database>
