#!/usr/bin/env ruby
require 'rubygems'
require 'activerecord'

File.unlink('biology_data.db') rescue nil
File.unlink('life_form_data.db') rescue nil

ActiveRecord::Base.establish_connection(
:adapter => "sqlite3",
:dbfile => "biology_data.db"
)

ActiveRecord::Schema.define do
  create_table :phyla do |t|
    t.string :name
  end

  insert("insert into phyla(name) values('Acanthocephala')")
  insert("insert into phyla(name) values('Brachiopoda')")
  insert("insert into phyla(name) values('Chaetognatha')")


  create_table :divisions do | t |
    t.string :name
  end

  insert("insert into divisions(name) values('Anthocerotophyta')")
  insert("insert into divisions(name) values('Bryophyta')")
  insert("insert into divisions(name) values('Marchantiophyta')")

  create_table :species do | t |
    t.string :name
    t.integer :phylum_id
    t.integer :division_id
  end

end

ActiveRecord::Base.establish_connection(
  :adapter => "sqlite3",
  :dbfile => "life_form_data.db"
)

ActiveRecord::Schema.define do
  create_table :life_forms do |t|
    t.string :name
  end

  insert("insert into life_forms(name) values('Polymorphus spp')")
  insert("insert into life_forms(name) values('Syringothyris sp')")
  insert("insert into life_forms(name) values('Spadella cephaloptera')")
  insert("insert into life_forms(name) values('Phaeoceros laevis')")
  insert("insert into life_forms(name) values('Sphagnum moss')")
  insert("insert into life_forms(name) values('Riccia fluitans')")
end