@@ -0,0 +1,1164 @@
+package uk.gov.migration;%0A%0Aimport java.sql.Connection;%0Aimport java.sql.ResultSet;%0Aimport java.sql.Statement;%0A%0Aimport org.flywaydb.core.api.migration.MigrationChecksumProvider;%0Aimport org.flywaydb.core.api.migration.jdbc.BaseJdbcMigration;%0A%0Apublic class V__14_New_hashing_algorithm extends BaseJdbcMigration implements MigrationChecksumProvider %7B%0A    @Override%0A    public void migrate(Connection connection) throws Exception %7B%0A        Statement stmt = connection.createStatement();%0A        try %7B%0A            stmt.execute(%22alter table entry add column blob_hash varchar%22);%0A            stmt.execute(%22alter table entry_system add column blob_hash varchar%22);%0A            stmt.execute(%22alter table item add column blob_hash varchar%22);%0A%0A            stmt.execute(%22update entry set blob_hash = sha256hex;%22);%0A            stmt.execute(%22update entry_system set blob_hash = sha256hex;%22);%0A            stmt.execute(%22update item set blob_hash = sha256hex;%22);%0A%0A            stmt.execute(%22alter table item alter column blob_hash set not null%22);%0A        %7D finally %7B%0A            stmt.close();%0A        %7D%0A    %7D%0A%0A    @Override%0A    public Integer getChecksum() %7B%0A        return 1;%0A    %7D%0A%7D%0A

Add new column to represent the new item hashes