db/migrate/20120307143552_create_ontologies.rb

	20120307143552_create_ontologies.rb revision 22e260fcd85642794d99c2ffaa333f2ef6ed7828
class CreateOntologies < ActiveRecord::Migration
  def change
    create_table :ontologies do |t|
      t.references :language
      t.references :logic
      t.references :ontology_version
      t.string :iri, :null => false
      t.string :state, :default => 'pending', :null => false
      t.string :name
      t.text :description
      t.boolean :distributed, :default => false
      t.boolean :auxiliary, :default => false

      t.integer :entities_count, :sentences_count
      t.integer :versions_count, :metadata_count, :comments_count, :null => false, :default => 0

      t.timestamps :null => false
    end

    change_table :ontologies do |t|
      t.index :iri, :unique => true
      t.index :state
      t.index :language_id
      t.index :logic_id
      t.foreign_key :languages
    end
  end
end