class CreateTradePlusStatic < ActiveRecord::Migration
  def change
    create_table :trade_plus_static do |t|
      t.integer :id
      t.integer :year
      t.string :appendix
      t.string :taxon_name
      t.integer :taxon_id
      t.string :group_name
      t.string :kingdom_name
      t.string :phylum_name
      t.string :class_name
      t.string :order_name
      t.string :family_name
      t.string :genus_name
      t.string :importer
      t.string :importer_iso
      t.string :exporter
      t.string :exporter_iso
      t.string :origin
      t.string :origin_iso
      t.string :importer_reported_quantity
      t.string :exporter_reported_quantity
      t.string :term
      t.string :term_converted
      t.string :unit
      t.string :unit_converted
      t.string :purpose
      t.string :source
    end
  end
end

class CreateTradePlusStatic < ActiveRecord::Migration
  def change
    create_table :trade_plus_static do |t|
      t.integer :year
      t.string :appendix
      t.string :taxon_name
      t.integer :taxon_id
      t.string :group_name
      t.string :kingdom_name
      t.string :phylum_name
      t.string :class_name
      t.string :order_name
      t.string :family_name
      t.string :genus_name
      t.string :importer
      t.string :importer_iso
      t.string :exporter
      t.string :exporter_iso
      t.string :origin
      t.string :origin_iso
      t.string :importer_reported_quantity
      t.string :exporter_reported_quantity
      t.string :term
      t.string :term_converted
      t.string :unit
      t.string :unit_converted
      t.string :purpose
      t.string :source
    end
  end
end

Remove extra id column from trade_plus_static migration
Remove extra id column from trade_plus_static migration
