Contents

require 'rodauth/migrations'

class AddRodauthTables < ActiveRecord::Migration[6.0]
  DB = Sequel.postgres(extensions: :activerecord_connection)

  def change
    enable_extension "citext"

    create_table :accounts, id: :uuid do |t|
      t.citext :email, null: false, index: { unique: true, where: "status_id IN (1, 2)" }
      t.integer :status_id, null: false, default: 1
      t.string :role, null: false, default: 'admin'
      t.string :oauth_client_id, null: true, index: true
    end

    create_table :account_password_hashes, id: :uuid do |t|
      t.foreign_key :accounts, column: :id
      t.string :password_hash, null: false
    end

    Rodauth.create_database_authentication_functions(DB, table_name: "account_password_hashes")

    # Used by the password reset feature
    create_table :account_password_reset_keys, id: :uuid do |t|
      t.foreign_key :accounts, column: :id
      t.string :key, null: false
      t.datetime :deadline, null: false
      t.datetime :email_last_sent, null: false, default: -> { "CURRENT_TIMESTAMP" }
    end

    # Used by the account verification feature
    create_table :account_verification_keys, id: :uuid do |t|
      t.string :key, null: false
      t.datetime :requested_at, null: false, default: -> { "CURRENT_TIMESTAMP" }
      t.datetime :email_last_sent, null: false, default: -> { "CURRENT_TIMESTAMP" }
    end

    add_reference :account_verification_keys, :account, type: :uuid, index: true

    # Used by the remember me feature
    create_table :account_remember_keys, id: :uuid do |t|
      t.foreign_key :accounts, column: :id
      t.string :key, null: false
      t.datetime :deadline, null: false
    end
  end
end

Version data entries

10 entries across 10 versions & 1 rubygems

Version	Path
osso-0.1.2	lib/osso/db/migrate/20201023142158_add_rodauth_tables.rb
osso-0.1.1	lib/osso/db/migrate/20201023142158_add_rodauth_tables.rb
osso-0.1.0	lib/osso/db/migrate/20201023142158_add_rodauth_tables.rb
osso-0.0.11	lib/osso/db/migrate/20201023142158_add_rodauth_tables.rb
osso-0.0.10	lib/osso/db/migrate/20201023142158_add_rodauth_tables.rb
osso-0.0.8	lib/osso/db/migrate/20201023142158_add_rodauth_tables.rb
osso-0.0.7	lib/osso/db/migrate/20201023142158_add_rodauth_tables.rb
osso-0.0.6	lib/osso/db/migrate/20201023142158_add_rodauth_tables.rb
osso-0.0.6.alpha	lib/osso/db/migrate/20201023142158_add_rodauth_tables.rb
osso-0.0.5	lib/osso/db/migrate/20201023142158_add_rodauth_tables.rb