Last modified: 2014-05-27 17:19:29 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T54929, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 52929 - Drop database table "namespaces" from Wikimedia wikis
Drop database table "namespaces" from Wikimedia wikis
Status: NEW
Product: Wikimedia
Classification: Unclassified
Site requests (Other open bugs)
wmf-deployment
All All
: Normal enhancement (vote)
: ---
Assigned To: Sean Pringle
:
Depends on:
Blocks: 52921
  Show dependency treegraph
 
Reported: 2013-08-16 17:03 UTC by MZMcBride
Modified: 2014-05-27 17:19 UTC (History)
5 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description MZMcBride 2013-08-16 17:03:49 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.
Comment 1 James Forrester 2014-05-27 17:19:29 UTC
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.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links