Sha256: 622c606dcbb088d6a8c18090b1c1c279baac46b091538492200f61ef22e94ea1

Contents?: true

Size: 635 Bytes

Versions: 9

Compression:

Stored size: 635 Bytes

Contents

<% if db.database_type == :postgres -%>
begin
  run "CREATE EXTENSION IF NOT EXISTS citext"
rescue NoMethodError # migration is being reverted
end

<% end -%>
create_table :accounts do
  primary_key :id, type: :Bignum
<% if db.database_type == :postgres -%>
  citext :email, null: false
  constraint :valid_email, email: /^[^,;@ \r\n]+@[^,@; \r\n]+\.[^,@; \r\n]+$/
<% else -%>
  String :email, null: false
<% end -%>
  Integer :status, null: false, default: 1
<% if db.supports_partial_indexes? -%>
  index :email, unique: true, where: { status: [1, 2] }
<% else -%>
  index :email, unique: true
<% end -%>
  String :password_hash
end

Version data entries

9 entries across 9 versions & 1 rubygems

Version Path
rodauth-rails-1.7.1 lib/generators/rodauth/migration/sequel/base.erb
rodauth-rails-1.7.0 lib/generators/rodauth/migration/sequel/base.erb
rodauth-rails-1.6.4 lib/generators/rodauth/migration/sequel/base.erb
rodauth-rails-1.6.3 lib/generators/rodauth/migration/sequel/base.erb
rodauth-rails-1.6.2 lib/generators/rodauth/migration/sequel/base.erb
rodauth-rails-1.6.1 lib/generators/rodauth/migration/sequel/base.erb
rodauth-rails-1.6.0 lib/generators/rodauth/migration/sequel/base.erb
rodauth-rails-1.5.5 lib/generators/rodauth/migration/sequel/base.erb
rodauth-rails-1.5.4 lib/generators/rodauth/migration/sequel/base.erb