diff options
author | ThibG <thib@sitedethib.com> | 2019-06-04 17:12:25 +0200 |
---|---|---|
committer | GitHub <noreply@github.com> | 2019-06-04 17:12:25 +0200 |
commit | 58946fef3c05342289c1c50132996fc4fd01cf68 (patch) | |
tree | af2df753e591d65a77e55c851cfe2b1979f47683 /db | |
parent | 1d5434d34c9bf86dea669676b7e8587255d38135 (diff) | |
parent | 8eb7c3304ee1260de3e8e1d1f32bd67409488756 (diff) |
Merge pull request #1079 from ThibG/glitch-soc/merge-upstream
Merge upstream changes
Diffstat (limited to 'db')
5 files changed, 21 insertions, 4 deletions
diff --git a/db/migrate/20171005102658_create_account_moderation_notes.rb b/db/migrate/20171005102658_create_account_moderation_notes.rb index 974ed9940..010b94586 100644 --- a/db/migrate/20171005102658_create_account_moderation_notes.rb +++ b/db/migrate/20171005102658_create_account_moderation_notes.rb @@ -8,6 +8,6 @@ class CreateAccountModerationNotes < ActiveRecord::Migration[5.1] t.timestamps end - add_foreign_key :account_moderation_notes, :accounts, column: :target_account_id + safety_assured { add_foreign_key :account_moderation_notes, :accounts, column: :target_account_id } end end diff --git a/db/migrate/20171010023049_add_foreign_key_to_account_moderation_notes.rb b/db/migrate/20171010023049_add_foreign_key_to_account_moderation_notes.rb index fc1e1ab91..cdcd15934 100644 --- a/db/migrate/20171010023049_add_foreign_key_to_account_moderation_notes.rb +++ b/db/migrate/20171010023049_add_foreign_key_to_account_moderation_notes.rb @@ -1,5 +1,5 @@ class AddForeignKeyToAccountModerationNotes < ActiveRecord::Migration[5.1] def change - add_foreign_key :account_moderation_notes, :accounts + safety_assured { add_foreign_key :account_moderation_notes, :accounts } end end diff --git a/db/migrate/20171118012443_add_moved_to_account_id_to_accounts.rb b/db/migrate/20171118012443_add_moved_to_account_id_to_accounts.rb index 0c8a894cc..586ef6f02 100644 --- a/db/migrate/20171118012443_add_moved_to_account_id_to_accounts.rb +++ b/db/migrate/20171118012443_add_moved_to_account_id_to_accounts.rb @@ -1,6 +1,6 @@ class AddMovedToAccountIdToAccounts < ActiveRecord::Migration[5.1] def change add_column :accounts, :moved_to_account_id, :bigint, null: true, default: nil - add_foreign_key :accounts, :accounts, column: :moved_to_account_id, on_delete: :nullify + safety_assured { add_foreign_key :accounts, :accounts, column: :moved_to_account_id, on_delete: :nullify } end end diff --git a/db/migrate/20190529143559_preserve_old_layout_for_existing_users.rb b/db/migrate/20190529143559_preserve_old_layout_for_existing_users.rb new file mode 100644 index 000000000..72b7c609d --- /dev/null +++ b/db/migrate/20190529143559_preserve_old_layout_for_existing_users.rb @@ -0,0 +1,17 @@ +class PreserveOldLayoutForExistingUsers < ActiveRecord::Migration[5.2] + disable_ddl_transaction! + + def up + # Assume that currently active users are already using the layout that they + # want to use, therefore ensure that it is saved explicitly and not based + # on the to-be-changed default + + User.where(User.arel_table[:current_sign_in_at].gteq(1.month.ago)).find_each do |user| + next if Setting.unscoped.where(thing_type: 'User', thing_id: user.id, var: 'advanced_layout').exists? + user.settings.advanced_layout = true + end + end + + def down + end +end diff --git a/db/schema.rb b/db/schema.rb index 96961c812..aa02be55f 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: 2019_05_19_130537) do +ActiveRecord::Schema.define(version: 2019_05_29_143559) do # These are extensions that must be enabled in order to support this database enable_extension "plpgsql" |