db/migrate/20120307143553_create_ontology_versions.rb

	20120307143553_create_ontology_versions.rb revision c6d4b32b59680b497a857241b2f1911fdcc22680
class CreateOntologyVersions < ActiveRecord::Migration
  def change
    create_table :ontology_versions do |t|
      t.references :user, :null => false
      t.references :ontology, :null => false
      t.string :source_url
      t.string :raw_file
      t.string :xml_file
      t.string :state, :default => 'pending'
      t.text :last_error
      t.string :checksum

      t.timestamps :null => false
    end

    change_table :ontology_versions do |t|
      t.index :user_id
      t.index :ontology_id
      t.index :checksum
      t.foreign_key :users
      t.foreign_key :ontologies, :dependent => :delete
    end
  end
end