Dear List Members,
Is there a definition (in human language) of the fields of the SQL
dumps at
http://download.wikimedia.org/enwiki ?
For example in the file page.sql.gz what is the definition of the
following fields: counter, is_new, random, touched, latest,
no_title_convert ?
Sorry if I'm sending this question to the wrong list. If this is the
case, then could you please suggest a list where I should send this
question ?
Thanks.
counter -> Number of times the page has been viewed (disabled on WMF wikis)
is_new -> The page has only one revision
random -> A random value, used to get a random page
touched -> When the page view has been changed (not necessarily the
text, may be a change on a included template)
latest -> id of the latest revision
no_title_convert -> This one is not on the official mediawiki schema. It
was meant to prevent title conversion for languages with variants.