Contents

Sequel.migration do
  up do 
    create_table(:events) do
      primary_key :id
      String :course_id
      DateTime :from
      DateTime :to
      foreign_key :location_id, :locations
      index :course_id
    end
    create_table(:locations) do 
      primary_key :id
      String :name, limit:100
      String :address, limit: 100
      String :postal_code, limit: 15
      String :city, limit: 100
      String :url
    end
  end

  down do 
    drop_table(:locations)
    drop_table(:events)
  end
end

Version data entries

10 entries across 10 versions & 1 rubygems

Version	Path
qcourses-0.1.11	db/migrations/001_initial_database.rb
qcourses-0.1.10	db/migrations/001_initial_database.rb
qcourses-0.1.9	db/migrations/001_initial_database.rb
qcourses-0.1.8	db/migrations/001_initial_database.rb
qcourses-0.1.7	db/migrations/001_initial_database.rb
qcourses-0.1.6	db/migrations/001_initial_database.rb
qcourses-0.1.5	db/migrations/001_initial_database.rb
qcourses-0.1.4	db/migrations/001_initial_database.rb
qcourses-0.1.3	db/migrations/001_initial_database.rb
qcourses-0.1.2	db/migrations/001_initial_database.rb