Last modified: 2014-05-27 17:19:29 UTC
On at least enwiki, there is a "namespaces" database table that appears to be unused and unneeded. Its schema: MariaDB [enwiki_p]> describe namespaces; +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | i | int(11) | YES | | NULL | | | v | blob | YES | | NULL | | +-------+---------+------+-----+---------+-------+ 2 rows in set (0.03 sec) Its contents: MariaDB [enwiki_p]> select * from namespaces; +------+----------------+ | i | v | +------+----------------+ | 0 | | | 1 | Talk | | 2 | User | | 3 | User_talk | | 4 | Wikipedia | | 5 | Wikipedia_talk | | 6 | Image | | 7 | Image_talk | | 8 | MediaWiki | | 9 | MediaWiki_talk | | 10 | Template | | 11 | Template_talk | | 12 | Help | | 13 | Help_talk | | 14 | Category | | 15 | Category_talk | +------+----------------+ 16 rows in set (0.03 sec) This database table should be dropped from all Wikimedia wikis.
Note that https://www.mediawiki.org/wiki/Requests_for_comment/Associated_namespaces plans to re-purpose and use this table – see https://www.mediawiki.org/wiki/Requests_for_comment/Associated_namespaces/Database_schemas and discussion there.