Last modified: 2013-10-17 18:06:01 UTC
Short description: Add a new field and index to allow differentiation between types of RC_EXTERNAL changes. Currently Wikibase is the only thing using RC_EXTERNAL. To allow Flow to utilize RC_EXTERNAL and let Wikibase continue doing everything it does now a differentiator is required. Which wikis are affected: all? Which tables: recentchanges What is the change to those tables: ALTER TABLE recentchanges ADD rc_external_type VARBINARY(255) NULL DEFAULT NULL; CREATE INDEX rc_type ON recentchanges(rc_type, rc_external_type); Links to gerrit changes and/or other related bug reports. https://bugzilla.wikimedia.org/53230 https://gerrit.wikimedia.org/r/#/c/81277
After further review we have decided the index is unnecessary and the size of this field should be 16 rather than 255. The change required is now just: ALTER TABLE recentchanges ADD rc_external_type VARBINARY(16) NULL DEFAULT NULL;
Where's the accompanying changeset for this as 81277 has been abandoned? Or should this bug be closed as INVALID or similar?
As mentioned by reedy, after consultation with wikitech and other interested parties the solution to this problem changed and there is no longer a need to add rc_external_type to the recentchanges table. The solution taken involves replacing rc_type int field in recentchanges with a new rc_source varbinary(16) field. This has been superseeded by bug 55844
