From f025cc67827a5b1b1faf10dec9d5a1e14e67fa5f Mon Sep 17 00:00:00 2001 From: Matt Jankowski Date: Mon, 1 May 2017 11:42:13 -0400 Subject: Filter on allowed user language preferences (#2361) * Naive approached to timeline filtering * Convert allowed_languages into a db column * Allow users to choose languages to see statuses in * Style list items as two columns * Add a hint to explain language filtering preference --- db/migrate/20170423005413_add_allowed_languages_to_user.rb | 6 ++++++ db/schema.rb | 2 ++ 2 files changed, 8 insertions(+) create mode 100644 db/migrate/20170423005413_add_allowed_languages_to_user.rb (limited to 'db') diff --git a/db/migrate/20170423005413_add_allowed_languages_to_user.rb b/db/migrate/20170423005413_add_allowed_languages_to_user.rb new file mode 100644 index 000000000..044a13334 --- /dev/null +++ b/db/migrate/20170423005413_add_allowed_languages_to_user.rb @@ -0,0 +1,6 @@ +class AddAllowedLanguagesToUser < ActiveRecord::Migration[5.0] + def change + add_column :users, :allowed_languages, :string, array: true, default: [], null: false + add_index :users, :allowed_languages, using: :gin + end +end diff --git a/db/schema.rb b/db/schema.rb index 66326f2e2..f6a13671c 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -326,7 +326,9 @@ ActiveRecord::Schema.define(version: 20170425202925) do t.boolean "otp_required_for_login" t.datetime "last_emailed_at" t.string "otp_backup_codes", array: true + t.string "allowed_languages", default: [], null: false, array: true t.index ["account_id"], name: "index_users_on_account_id", using: :btree + t.index ["allowed_languages"], name: "index_users_on_allowed_languages", using: :gin t.index ["confirmation_token"], name: "index_users_on_confirmation_token", unique: true, using: :btree t.index ["email"], name: "index_users_on_email", unique: true, using: :btree t.index ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true, using: :btree -- cgit