Class: CreateShowTable

Inherits:
Object
  • Object
show all
Defined in:
lib/gdshowsdb/db/migrations/003_create_show_table.rb

Instance Method Summary collapse

Instance Method Details

#down ⇒ Object 



19
20
21
 
# File 'lib/gdshowsdb/db/migrations/003_create_show_table.rb', line 19

def down
  drop_table :shows
end

#up ⇒ Object 



3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
# File 'lib/gdshowsdb/db/migrations/003_create_show_table.rb', line 3

def up
  create_table :shows, :id => false do |t|
    t.string :uuid, :primary => true, :null => false
    t.integer :year
    t.integer :month
    t.integer :day
    t.integer :position
    t.string :venue
    t.string :city
    t.string :state
    t.string :country     
  end

  add_index :shows, [:uuid, :year, :month, :day]
end