From 39b07aad85c0abd897f37860f5c9da854dcf523d Mon Sep 17 00:00:00 2001 From: Fire Demon Date: Mon, 21 Sep 2020 02:22:56 -0500 Subject: Drop Monsterfork v2 thread permissions; simplify feed filters --- ...20200721212401_backfill_account_id_on_conversations.rb | 15 --------------- 1 file changed, 15 deletions(-) delete mode 100644 db/migrate/20200721212401_backfill_account_id_on_conversations.rb (limited to 'db/migrate/20200721212401_backfill_account_id_on_conversations.rb') diff --git a/db/migrate/20200721212401_backfill_account_id_on_conversations.rb b/db/migrate/20200721212401_backfill_account_id_on_conversations.rb deleted file mode 100644 index 595fd8e52..000000000 --- a/db/migrate/20200721212401_backfill_account_id_on_conversations.rb +++ /dev/null @@ -1,15 +0,0 @@ -class BackfillAccountIdOnConversations < ActiveRecord::Migration[5.2] - disable_ddl_transaction! - - def up - Rails.logger.info('Backfilling owners of conversation threads...') - safety_assured do - Conversation.left_outer_joins(:statuses).where(statuses: { id: nil }).in_batches.destroy_all - execute('UPDATE conversations SET account_id = s.account_id FROM (SELECT account_id, conversation_id FROM statuses WHERE NOT reply) AS s WHERE conversations.id = s.conversation_id') - end - end - - def down - true - end -end -- cgit