You mean, pages like MediaWiki has but modified for use in Labs? I don't think there's MediaWiki-style documentation on that, I'd just use the 'list databases', 'list tables' and 'describe $view' commands. You can use 'show create view $view' to see some restrictions (e.g. it selects NULL in place of user.user_password), but that doesn't always tell you everything as tables (and columns?) can get filtered out before a row even gets to the labsdb machines. On 1 October 2017 at 05:14, Martin Domdey <animalia(a)gmx.net> wrote: > May I ask you, where you could find a database schema? > > Regards, Martin > > -- > Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail gesendet. > Am 01.10.2017, 06:10, Alex Monk <krenair(a)gmail.com> schrieb: >> >> The MediaWiki schema description is only valid for the underlying >> database, you do not have access to that as a labs user - you just >> have security-sanitised views. rev_text_ids are not useful to you as >> you cannot access revision texts via the DBs - you must go through the >> API. >> >> On 1 October 2017 at 04:31, Roy Smith <roy(a)panix.com> wrote: >> > I’ve been exploring the enwiki database. I can find the page row for >> > [[Iron]] >> > >> > MariaDB [enwiki_p]> select page_title from page where page_id = 14734; >> > +------------+ >> > | page_title | >> > +------------+ >> > | Iron | >> > +------------+ >> > >> > >> > It looks like it has the right number of revisions: >> > >> > MariaDB [enwiki_p]> select count(*) from revision where rev_page = >> > 14734; >> > +----------+ >> > | count(*) | >> > +----------+ >> > | 5560 | >> > +----------+ >> > >> > >> > But, all of the rev_text_ids are 0 >> > >> > MariaDB [enwiki_p]> select rev_text_id from revision where rev_page = >> > 14734 >> > and rev_text_id != 0; >> > Empty set (0.02 sec) >> > >> > >> > The schema description seems pretty straight-forward. What am I not >> > understanding? >> > >> > _______________________________________________ >> > Cloud mailing list >> > Cloud(a)lists.wikimedia.org >> > https://lists.wikimedia.org/mailman/listinfo/cloud >> > >> >> _______________________________________________ >> Cloud mailing list >> Cloud(a)lists.wikimedia.org >> https://lists.wikimedia.org/mailman/listinfo/cloud > > > _______________________________________________ > Cloud mailing list > Cloud(a)lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/cloud >

I'm talking about something like this: https://upload.wikimedia.org/wikipedia/commons/f/f7/MediaWiki_1.24.1_databa… , a graphical database schema, but I guess that it is outdated and needs to be updated.

The database schema is available at https://phabricator.wikimedia.org/source/mediawiki/browse/master/maintenanc… It's not too useful, but I would say that sometimes having the (opaque) rev_text_id could be handy, eg. to detect a rollback.