Contents

class CreateProposalTokens < ActiveRecord::Migration[5.0]
  def up
    create_table :proposal_tokens do |t|
      t.string  :token,           null: false
      t.string  :email,           null: false
      t.string  :proposable_type, null: false
      t.string  :resource_type
      t.integer :resource_id
      t.string  :proposer_type
      t.integer :proposer_id
      t.text    :arguments

      t.datetime :accepted_at
      t.datetime :reminded_at
      t.datetime :expires_at,     null: false
      t.datetime :updated_at,     null: false
      t.datetime :created_at,     null: false
    end

    add_index :proposal_tokens, :token, unique: true

    execute <<~SQL
      CREATE UNIQUE INDEX proposal_idx ON proposal_tokens (
        email,
        proposable_type,
        resource_type,
        resource_id,
        expires_at,
        accepted_at
      )
    SQL
  end

  def down
    drop_table :proposal_tokens
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
proposal-2.0.2	db/migrate/20121026005348_create_proposal_tokens.rb
proposal-2.0.1	db/migrate/20121026005348_create_proposal_tokens.rb