https://bugzilla.wikimedia.org/show_bug.cgi?id=57084
--- Comment #17 from Aaron Halfaker <[email protected]> --- When considering this change, I like to consider the EventLogging schema that we set up for tracking page moves on Wikimedia wikis given the lack of useful data in the logging table. See https://meta.wikimedia.org/wiki/Schema:PageMove. In matching that schema to the proposed data structure: * userId -- rc.userid * userText -- rc.user * pageId -- rc.pageid * oldNamespace -- rc.ns * oldTitle -- parsed(rc.title) (to remove namespace prefix) * newNamespace -- rc.move.new_ns * newTitle -- parsed(rc.move.new_title) (to remove namespace prefix) * redirectId -- rc.move.redirpageid * comment -- rc.comment Is that mapping right? If so, it makes sense to me. Also, re. zero for rc.move.redirpageid, we decided to go that way in the EventLogging schema since it follows the pattern of zero'd ID fields that is relatively consistent across the database (e.g. rev_user and rev_parent_id in revision). -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
