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