diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrate/20170625151955_devise_create_users.rb | 44 | ||||
| -rw-r--r-- | db/schema.rb | 21 |
2 files changed, 64 insertions, 1 deletions
| diff --git a/db/migrate/20170625151955_devise_create_users.rb b/db/migrate/20170625151955_devise_create_users.rb new file mode 100644 index 0000000..799f225 --- /dev/null +++ b/db/migrate/20170625151955_devise_create_users.rb | |||
| @@ -0,0 +1,44 @@ | |||
| 1 | class DeviseCreateUsers < ActiveRecord::Migration[5.1] | ||
| 2 | def change | ||
| 3 | create_table :users do |t| | ||
| 4 | ## Database authenticatable | ||
| 5 | t.string :login, null: false, default: "" | ||
| 6 | t.string :email, null: false, default: "" | ||
| 7 | t.string :encrypted_password, null: false, default: "" | ||
| 8 | |||
| 9 | ## Recoverable | ||
| 10 | t.string :reset_password_token | ||
| 11 | t.datetime :reset_password_sent_at | ||
| 12 | |||
| 13 | ## Rememberable | ||
| 14 | t.datetime :remember_created_at | ||
| 15 | |||
| 16 | ## Trackable | ||
| 17 | t.integer :sign_in_count, default: 0, null: false | ||
| 18 | t.datetime :current_sign_in_at | ||
| 19 | t.datetime :last_sign_in_at | ||
| 20 | t.string :current_sign_in_ip | ||
| 21 | t.string :last_sign_in_ip | ||
| 22 | |||
| 23 | ## Confirmable | ||
| 24 | # t.string :confirmation_token | ||
| 25 | # t.datetime :confirmed_at | ||
| 26 | # t.datetime :confirmation_sent_at | ||
| 27 | # t.string :unconfirmed_email # Only if using reconfirmable | ||
| 28 | |||
| 29 | ## Lockable | ||
| 30 | # t.integer :failed_attempts, default: 0, null: false # Only if lock strategy is :failed_attempts | ||
| 31 | # t.string :unlock_token # Only if unlock strategy is :email or :both | ||
| 32 | # t.datetime :locked_at | ||
| 33 | |||
| 34 | |||
| 35 | t.timestamps null: false | ||
| 36 | end | ||
| 37 | |||
| 38 | add_index :users, :login, unique: true | ||
| 39 | add_index :users, :email, unique: true | ||
| 40 | add_index :users, :reset_password_token, unique: true | ||
| 41 | # add_index :users, :confirmation_token, unique: true | ||
| 42 | # add_index :users, :unlock_token, unique: true | ||
| 43 | end | ||
| 44 | end | ||
| diff --git a/db/schema.rb b/db/schema.rb index 6eca6ad..b690393 100644 --- a/db/schema.rb +++ b/db/schema.rb | |||
| @@ -10,7 +10,7 @@ | |||
| 10 | # | 10 | # |
| 11 | # It's strongly recommended that you check this file into your version control system. | 11 | # It's strongly recommended that you check this file into your version control system. |
| 12 | 12 | ||
| 13 | ActiveRecord::Schema.define(version: 20170625004938) do | 13 | ActiveRecord::Schema.define(version: 20170625151955) do |
| 14 | 14 | ||
| 15 | create_table "entries", force: :cascade do |t| | 15 | create_table "entries", force: :cascade do |t| |
| 16 | t.string "title" | 16 | t.string "title" |
| @@ -31,4 +31,23 @@ ActiveRecord::Schema.define(version: 20170625004938) do | |||
| 31 | t.index ["recordable_type", "recordable_id"], name: "index_records_on_recordable_type_and_recordable_id" | 31 | t.index ["recordable_type", "recordable_id"], name: "index_records_on_recordable_type_and_recordable_id" |
| 32 | end | 32 | end |
| 33 | 33 | ||
| 34 | create_table "users", force: :cascade do |t| | ||
| 35 | t.string "login", default: "", null: false | ||
| 36 | t.string "email", default: "", null: false | ||
| 37 | t.string "encrypted_password", default: "", null: false | ||
| 38 | t.string "reset_password_token" | ||
| 39 | t.datetime "reset_password_sent_at" | ||
| 40 | t.datetime "remember_created_at" | ||
| 41 | t.integer "sign_in_count", default: 0, null: false | ||
| 42 | t.datetime "current_sign_in_at" | ||
| 43 | t.datetime "last_sign_in_at" | ||
| 44 | t.string "current_sign_in_ip" | ||
| 45 | t.string "last_sign_in_ip" | ||
| 46 | t.datetime "created_at", null: false | ||
| 47 | t.datetime "updated_at", null: false | ||
| 48 | t.index ["email"], name: "index_users_on_email", unique: true | ||
| 49 | t.index ["login"], name: "index_users_on_login", unique: true | ||
| 50 | t.index ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true | ||
| 51 | end | ||
| 52 | |||
| 34 | end | 53 | end |
