| Anomie added a comment. |
To be specific, and based on the current status of https://gerrit.wikimedia.org/r/#/c/378729/, that means:
- page_content_model would be emulated using content_models.model_name with JOIN revision ON (rev_id = page_latest) JOIN slots ON (slot_revision_id = rev_id) JOIN slot_roles ON (slot_role_id = role_id AND role_name = 'main') JOIN content ON (slot_content_id = content_id) JOIN content_models ON (content_model = model_id).
- For various revision fields, JOIN slots ON (slot_revision_id = rev_id) JOIN slot_roles ON (slot_role_id = role_id AND role_name = 'main') JOIN content ON (slot_content_id = content_id) JOIN content_models ON (content_model = model_id):
- rev_text_id => content_id
- rev_content_model => model_name
- rev_content_format => null I guess, multiple formats per model are planned to be removed.
- archive will need something similar, joining slots on slot_revision_id = ar_rev_id.
- archive.ar_flags is going away entirely with no sane replacement, but I don't see any point to it being exposed in the current schema anyway. Just null it like ar_text if you don't drop both of those entirely.
TASK DETAIL
EMAIL PREFERENCES
To: Anomie
Cc: Anomie, Aklapper, daniel, 1978Gage2001, Lahi, PDrouin-WMF, Gq86, E1presidente, Ramsey-WMF, SandraF_WMF, GoranSMilovanovic, QZanden, Tbscho, Tramullas, Acer, LawExplorer, JJMC89, Susannaanas, Aschroet, Jane023, Wikidata-bugs, PKM, Base, matthiasmullie, aude, Gryllida, Ricordisamoa, Fabrice_Florin, Raymond, scfc, Steinsplitter, Mbch331, Krenair, chasemp
Cc: Anomie, Aklapper, daniel, 1978Gage2001, Lahi, PDrouin-WMF, Gq86, E1presidente, Ramsey-WMF, SandraF_WMF, GoranSMilovanovic, QZanden, Tbscho, Tramullas, Acer, LawExplorer, JJMC89, Susannaanas, Aschroet, Jane023, Wikidata-bugs, PKM, Base, matthiasmullie, aude, Gryllida, Ricordisamoa, Fabrice_Florin, Raymond, scfc, Steinsplitter, Mbch331, Krenair, chasemp
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
