Contents

class CreateShowTable < ActiveRecord::Migration[5.0]
	
	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

	def down
		drop_table :shows
	end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
gdshowsdb-3.0.0	lib/gdshowsdb/db/migrations/003_create_show_table.rb
gdshowsdb-2.1.0	lib/gdshowsdb/db/migrations/003_create_show_table.rb
gdshowsdb-2.0.0	lib/gdshowsdb/db/migrations/003_create_show_table.rb
gdshowsdb-1.0.3	lib/gdshowsdb/db/migrations/003_create_show_table.rb
gdshowsdb-1.0.2	lib/gdshowsdb/db/migrations/003_create_show_table.rb
gdshowsdb-1.0.1	lib/gdshowsdb/db/migrations/003_create_show_table.rb
gdshowsdb-1.0.0	lib/gdshowsdb/db/migrations/003_create_show_table.rb