Contents

class CreateSocialStreamEvents < ActiveRecord::Migration
  
  def self.up

  create_table :events do |t|
    t.references :actor
    t.datetime :start_at
    t.datetime :end_at
    t.integer :founder_id
    t.timestamps
  end

  create_table :agendas do |t|
    t.references :activity_object
    t.references :event
    t.timestamps
  end

  create_table :sessions do |t|
    t.references :activity_object
    t.references :agenda
    t.datetime :start_at
    t.datetime :end_at
    t.string   :title
    t.string  :description
    t.timestamps
  end


  add_foreign_key "agendas", "activity_objects", :name => "agendas_on_activity_object_id"
  add_foreign_key "agendas", "events", :name => "agendas_on_event_id"

  add_foreign_key "events", "actors", :name => "events_on_actor_id"

  add_foreign_key "sessions", "activity_objects", :name => "sessions_on_activity_object_id"
  add_foreign_key "sessions", "agendas", :name => "sessions_on_agenda_id"
   
  end
  
  def self.down
    remove_foreign_key "agendas", :name => "agendas_on_activity_object_id"
    remove_foreign_key "agendas", :name => "agendas_on_event_id"

    remove_foreign_key "events", :name => "events_on_actor_id"

    remove_foreign_key "sessions", :name => "sessions_on_activity_object_id"
    remove_foreign_key "sessions", :name => "sessions_on_agenda_id"
   
    drop_table :sessions
    drop_table :agendas
    drop_table :events           
  end
  
end

Version data entries

41 entries across 41 versions & 2 rubygems

Version	Path
social_stream-0.12.4	events/db/migrate/20110910161707_create_social_stream_events.rb
social_stream-0.12.3	events/db/migrate/20110910161707_create_social_stream_events.rb
social_stream-0.12.2	events/db/migrate/20110910161707_create_social_stream_events.rb
social_stream-events-0.0.17	db/migrate/20110910161707_create_social_stream_events.rb
social_stream-0.12.1	events/db/migrate/20110910161707_create_social_stream_events.rb
social_stream-events-0.0.16	db/migrate/20110910161707_create_social_stream_events.rb
social_stream-0.12.0	events/db/migrate/20110910161707_create_social_stream_events.rb
social_stream-0.11.8	events/db/migrate/20110910161707_create_social_stream_events.rb
social_stream-events-0.0.15	db/migrate/20110910161707_create_social_stream_events.rb
social_stream-events-0.0.14	db/migrate/20110910161707_create_social_stream_events.rb
social_stream-0.11.7	events/db/migrate/20110910161707_create_social_stream_events.rb
social_stream-events-0.0.13	db/migrate/20110910161707_create_social_stream_events.rb
social_stream-0.11.6	events/db/migrate/20110910161707_create_social_stream_events.rb
social_stream-0.11.5	events/db/migrate/20110910161707_create_social_stream_events.rb
social_stream-events-0.0.12	db/migrate/20110910161707_create_social_stream_events.rb
social_stream-0.11.4	events/db/migrate/20110910161707_create_social_stream_events.rb
social_stream-events-0.0.11	db/migrate/20110910161707_create_social_stream_events.rb
social_stream-0.11.3	events/db/migrate/20110910161707_create_social_stream_events.rb
social_stream-0.11.2	events/db/migrate/20110910161707_create_social_stream_events.rb
social_stream-events-0.0.10	db/migrate/20110910161707_create_social_stream_events.rb