Farkas, Illes wrote: > 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.
The meanings are defined within the table schema, at tables.sql http://svn.wikimedia.org/viewvc/mediawiki/trunk/phase3/maintenance/tables.sql?view=markup 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. http://svn.wikimedia.org/viewvc/mediawiki/trunk/phase3/maintenance/archives/patch-page_no_title_convert.sql?revision=16525&view=markup _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
