Contents

class CreateCredentials < ActiveRecord::Migration
  def change
    create_table :credentials do |t|
      t.references :user, :null => false
      t.string :type, :limit => 32, :null => false
      t.string :name, :limit => 256, :null => true
      
      t.boolean :verified, :null => false, :default => false
      
      t.binary :key, :limit => 2.kilobytes, :null => true
    end
    
    # All the credentials (maybe of a specific type) belonging to a user.
    add_index :credentials, [:user_id, :type], :unique => false,
                                               :null => false
    # A specific credential, to find out what user it belongs to.
    add_index :credentials, [:type, :name], :unique => true, :null => true
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
authpwn_rails-0.10.1	lib/authpwn_rails/generators/templates/003_create_credentials.rb
authpwn_rails-0.10.0	lib/authpwn_rails/generators/templates/002_create_credentials.rb