diff options
author | Thibaut Girka <thib@sitedethib.com> | 2020-08-30 16:13:08 +0200 |
---|---|---|
committer | Thibaut Girka <thib@sitedethib.com> | 2020-08-30 16:13:08 +0200 |
commit | 8c3c27bf063d648823da39a206be3efd285611ad (patch) | |
tree | c78c0bed2bab5ed64a7dfd546b91b21600947112 /db | |
parent | 30632adf9eda6d83a9b4269f23f11ced5e09cd93 (diff) | |
parent | 52157fdcba0837c782edbfd240be07cabc551de9 (diff) |
Merge branch 'master' into glitch-soc/merge-upstream
Conflicts: - `app/controllers/accounts_controller.rb`: Upstream change too close to a glitch-soc change related to instance-local toots. Merged upstream changes. - `app/services/fan_out_on_write_service.rb`: Minor conflict due to glitch-soc's handling of Direct Messages, merged upstream changes. - `yarn.lock`: Not really a conflict, caused by glitch-soc-only dependencies being textually too close to updated upstream dependencies. Merged upstream changes.
Diffstat (limited to 'db')
-rw-r--r-- | db/migrate/20200630190240_create_webauthn_credentials.rb | 16 | ||||
-rw-r--r-- | db/migrate/20200630190544_add_webauthn_id_to_users.rb | 5 | ||||
-rw-r--r-- | db/schema.rb | 16 |
3 files changed, 36 insertions, 1 deletions
diff --git a/db/migrate/20200630190240_create_webauthn_credentials.rb b/db/migrate/20200630190240_create_webauthn_credentials.rb new file mode 100644 index 000000000..ea924238d --- /dev/null +++ b/db/migrate/20200630190240_create_webauthn_credentials.rb @@ -0,0 +1,16 @@ +class CreateWebauthnCredentials < ActiveRecord::Migration[5.2] + def change + create_table :webauthn_credentials do |t| + t.string :external_id, null: false + t.string :public_key, null: false + t.string :nickname, null: false + t.bigint :sign_count, null: false, default: 0 + + t.index :external_id, unique: true + + t.references :user, foreign_key: true + + t.timestamps + end + end +end diff --git a/db/migrate/20200630190544_add_webauthn_id_to_users.rb b/db/migrate/20200630190544_add_webauthn_id_to_users.rb new file mode 100644 index 000000000..95d3c92a8 --- /dev/null +++ b/db/migrate/20200630190544_add_webauthn_id_to_users.rb @@ -0,0 +1,5 @@ +class AddWebauthnIdToUsers < ActiveRecord::Migration[5.2] + def change + add_column :users, :webauthn_id, :string + end +end diff --git a/db/schema.rb b/db/schema.rb index 37cd34136..b56aa109a 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -10,7 +10,7 @@ # # It's strongly recommended that you check this file into your version control system. -ActiveRecord::Schema.define(version: 2020_06_28_133322) do +ActiveRecord::Schema.define(version: 2020_06_30_190544) do # These are extensions that must be enabled in order to support this database enable_extension "plpgsql" @@ -883,6 +883,7 @@ ActiveRecord::Schema.define(version: 2020_06_28_133322) do t.boolean "approved", default: true, null: false t.string "sign_in_token" t.datetime "sign_in_token_sent_at" + t.string "webauthn_id" t.index ["account_id"], name: "index_users_on_account_id" t.index ["confirmation_token"], name: "index_users_on_confirmation_token", unique: true t.index ["created_by_application_id"], name: "index_users_on_created_by_application_id" @@ -912,6 +913,18 @@ ActiveRecord::Schema.define(version: 2020_06_28_133322) do t.index ["user_id"], name: "index_web_settings_on_user_id", unique: true end + create_table "webauthn_credentials", force: :cascade do |t| + t.string "external_id", null: false + t.string "public_key", null: false + t.string "nickname", null: false + t.bigint "sign_count", default: 0, null: false + t.bigint "user_id" + t.datetime "created_at", null: false + t.datetime "updated_at", null: false + t.index ["external_id"], name: "index_webauthn_credentials_on_external_id", unique: true + t.index ["user_id"], name: "index_webauthn_credentials_on_user_id" + end + add_foreign_key "account_aliases", "accounts", on_delete: :cascade add_foreign_key "account_conversations", "accounts", on_delete: :cascade add_foreign_key "account_conversations", "conversations", on_delete: :cascade @@ -1010,4 +1023,5 @@ ActiveRecord::Schema.define(version: 2020_06_28_133322) do add_foreign_key "web_push_subscriptions", "oauth_access_tokens", column: "access_token_id", on_delete: :cascade add_foreign_key "web_push_subscriptions", "users", on_delete: :cascade add_foreign_key "web_settings", "users", name: "fk_11910667b2", on_delete: :cascade + add_foreign_key "webauthn_credentials", "users" end |