Yes, it is fully populated as are the _comment_id fields needed for joins. Brooke Storm Operations Engineer Wikimedia Cloud Services bst...@wikimedia.org <mailto:bst...@wikimedia.org> IRC: bstorm_
> On Mar 7, 2019, at 11:21 AM, Jesse Plamondon-Willard <pathosch...@gmail.com> > wrote: > > Is the comment table fully populated, so we can migrate tools immediately? > > -- > Pathoschild (Jesse) > > On Thu, 7 Mar 2019 at 12:54, Brooke Storm <bst...@wikimedia.org > <mailto:bst...@wikimedia.org>> wrote: > After some discussion, we are moving back the date by a week to 3/19/2019 for > people to have a bit more time to update tools and such. > Thanks everyone! > > Brooke Storm > Operations Engineer > Wikimedia Cloud Services > bst...@wikimedia.org <mailto:bst...@wikimedia.org> > IRC: bstorm_ > >> On Mar 7, 2019, at 9:13 AM, Brooke Storm <bst...@wikimedia.org >> <mailto:bst...@wikimedia.org>> wrote: >> >> Since the MCR refactor of the Mediawiki database schema has been progressing >> (https://phabricator.wikimedia.org/T166733 >> <https://phabricator.wikimedia.org/T166732> and many other tickets), one of >> the last steps is dropping the columns from the wiki replica schema. >> >> The column drops are being tracked and are explained well here >> https://phabricator.wikimedia.org/T212972 >> <https://phabricator.wikimedia.org/T212972>, and currently the change is >> ready to be applied. It is already applied to two wikis (eswiki and huwiki >> since there was a column problem that needed fixing). The tables with names >> such as <tablename>_compat will retain a similar structure if that is needed >> for refactoring. >> >> From the ticket, this is a summary of what is changing, organized by table >> name: >> archive: Remove ar_comment >> archive_userindex: Remove ar_comment >> filearchive: >> Remove fa_deleted_reason >> Remove fa_description >> filearchive_userindex: >> Remove fa_deleted_reason >> Remove fa_description >> image: Remove img_description >> ipblocks: Remove ipb_reason. >> ipblocks_ipindex: Remove ipb_reason. >> logging: Remove log_comment. >> logging_logindex: Remove log_comment. >> logging_userindex: Remove log_comment. >> oldimage: Remove oi_description >> oldimage_userindex: Remove oi_description >> recentchanges: Remove rc_comment. >> recentchanges_userindex: Remove rc_comment. >> revision: Remove rev_comment. >> revision_userindex: Remove rev_comment. >> >> The changes to the _compat tables should not affect anything. >> >> We will deploy the change early next week (Tuesday - 3/12/2019). In most >> cases, if a table isn’t working for your tool or app anymore because of the >> change, you can switch to a table named $tablename_compat and it will appear >> to have the same schema, but it is recommended that comment references use a >> join to the new comment table on a “comment_id” field instead where possible. >> >> Brooke Storm >> Operations Engineer >> Wikimedia Cloud Services >> bst...@wikimedia.org <mailto:bst...@wikimedia.org> >> IRC: bstorm_ >> > > _______________________________________________ > Wikimedia Cloud Services announce mailing list > cloud-annou...@lists.wikimedia.org > <mailto:cloud-annou...@lists.wikimedia.org> (formerly > labs-annou...@lists.wikimedia.org <mailto:labs-annou...@lists.wikimedia.org>) > https://lists.wikimedia.org/mailman/listinfo/cloud-announce > <https://lists.wikimedia.org/mailman/listinfo/cloud-announce> > _______________________________________________ > Wikimedia Cloud Services mailing list > Cloud@lists.wikimedia.org <mailto:Cloud@lists.wikimedia.org> (formerly > lab...@lists.wikimedia.org <mailto:lab...@lists.wikimedia.org>) > https://lists.wikimedia.org/mailman/listinfo/cloud > <https://lists.wikimedia.org/mailman/listinfo/cloud>_______________________________________________ > Wikimedia Cloud Services mailing list > Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) > https://lists.wikimedia.org/mailman/listinfo/cloud
_______________________________________________ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
