Contents

class CreateSongOccurencesTable < ActiveRecord::Migration
  
  def up
    create_table :song_occurences, :id => false do |t|
      t.string :uuid, :primary => true, :null => false
      t.string :show_uuid
      t.string :song_ref_uuid
      t.integer :position      
    end

    add_index :song_occurences, [:uuid, :song_ref_uuid]
  end

  def down
    drop_table :song_occurences
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
gdshowsdb-0.9.1	lib/gdshowsdb/db/migrations/006_create_song_occurences_table.rb
gdshowsdb-0.9.0	lib/gdshowsdb/db/migrations/006_create_song_occurences_table.rb