Contents

Sequel.migration do
  up do
    create_table(:manual_approvals) do
      primary_key :id
      foreign_key :dependency_id, :dependencies, unique: true, on_delete: :cascade
      String :approver, null: true
      String :notes, null: true
    end

    LicenseFinder::DB << <<-SQL
      INSERT INTO manual_approvals
        (dependency_id)
      SELECT id
      FROM dependencies
      WHERE approved_manually;
    SQL

    alter_table(:dependencies) do
      drop_column :approved_manually
    end
  end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
license_finder-1.2	db/migrate/201403190028_add_manual_approvals.rb
license_finder-1.2-java	db/migrate/201403190028_add_manual_approvals.rb
license_finder-1.1.1-java	db/migrate/201403190028_add_manual_approvals.rb
license_finder-1.1.1	db/migrate/201403190028_add_manual_approvals.rb
license_finder-1.1.0	db/migrate/201403190028_add_manual_approvals.rb
license_finder-1.0.1	db/migrate/201403190028_add_manual_approvals.rb
license_finder-1.0.0.1	db/migrate/201403190028_add_manual_approvals.rb