jro_apps/redmine Commit - r2361:fc6d6b1e3b27

Fixed: migration 98 breaks when using table name prefix....

Jean-Philippe Lang -

r2361:fc6d6b1e3b27

parent child

Context file:

r2361:fc6d6b1e3b27

db/migrate/098_set_topic_authors_as_watchers.rb +4 -3

              class SetTopicAuthorsAsWatchers < ActiveRecord::Migration
                def self.up
                  # Sets active users who created/replied a topic as watchers of the topic
                  # so that the new watch functionality at topic level doesn't affect notifications behaviour
-                 Message.connection.execute("INSERT INTO watchers (watchable_type, watchable_id, user_id)" +
-                                              " SELECT DISTINCT 'Message', COALESCE(messages.parent_id, messages.id), messages.author_id FROM messages, users" +
-                                              " WHERE messages.author_id = users.id AND users.status = 1")
+                 Message.connection.execute("INSERT INTO #{Watcher.table_name} (watchable_type, watchable_id, user_id)" +
+                                              " SELECT DISTINCT 'Message', COALESCE(m.parent_id, m.id), m.author_id" +
+                                              " FROM #{Message.table_name} m, #{User.table_name} u" +
+                                              " WHERE m.author_id = u.id AND u.status = 1")
                end
                def self.down
                  # Removes all message watchers
                  Watcher.delete_all("watchable_type = 'Message'")
                end
              end

General Comments 0

You need to be logged in to leave comments. Login now

No TODOs yet

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages