Contents

<% if activerecord_adapter == "postgresql" -%>
enable_extension "citext"

<% end -%>
create_table :accounts<%= primary_key_type %> do |t|
<% case activerecord_adapter -%>
<% when "postgresql" -%>
  t.citext :email, null: false
<% else -%>
  t.string :email, null: false
<% end -%>
  t.integer :status, null: false, default: 1
<% case activerecord_adapter -%>
<% when "postgresql", "sqlite3" -%>
  t.index :email, unique: true, where: "status IN (1, 2)"
<% else -%>
  t.index :email, unique: true
<% end -%>
end

# Used if storing password hashes in a separate table (default)
create_table :account_password_hashes<%= primary_key_type %> do |t|
  t.foreign_key :accounts, column: :id
  t.string :password_hash, null: false
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
rodauth-rails-1.2.2	lib/generators/rodauth/migration/base.erb
rodauth-rails-1.2.1	lib/generators/rodauth/migration/base.erb