Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <changeSet id="2d4d5b8d-c571-4fc7-bcf7-28888efb2c8c" author="martin">
- <createTable tableName="token">
- <column name="id" type="VARCHAR(255)">
- <constraints nullable="false"/>
- </column>
- <column name="token" type="VARCHAR(255)">
- <constraints nullable="false"/>
- </column>
- <column name="time_generate" type="datetime(6)">
- <constraints nullable="false"/>
- </column>
- <column name="user_id" type="VARCHAR(255)">
- <constraints nullable="false"/>
- </column>
- </createTable>
- </changeSet>
- <changeSet author="martin" id="f2065804-0ca9-4a80-99d1-b5b4fa5c0db0">
- <createIndex indexName="FK_1459773192024-41" tableName="token">
- <column name="user_id"/>
- </createIndex>
- </changeSet>
- <changeSet author="martin" id="add-foreign-key-on-token">
- <addForeignKeyConstraint baseColumnNames="user_id" baseTableName="token"
- constraintName="FK_1459773192024-41" deferrable="false"
- initiallyDeferred="false" onDelete="NO ACTION" onUpdate="NO ACTION"
- referencedColumnNames="id" referencedTableName="user"/>
- </changeSet>
- <changeSet id="add-version-to-token-table" author="martin">
- <addColumn tableName="token">
- <column name="version" type="BIGINT">
- <constraints nullable="false"/>
- </column>
- </addColumn>
- </changeSet>
- <changeSet id="drop-date-of-generation-column" author="martin">
- <dropColumn tableName="token" columnName="time_generate"/>
- </changeSet>
- <changeSet id="adding-date-created-and-date-modified-to-token-table" author="martin">
- <addColumn tableName="token">
- <column name="date_created" type="datetime(6)">
- <constraints nullable="false"/>
- </column>
- </addColumn>
- <addColumn tableName="token">
- <column name="last_updated" type="datetime(6)">
- <constraints nullable="false"/>
- </column>
- </addColumn>
- </changeSet>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement