https://bugzilla.wikimedia.org/show_bug.cgi?id=52929

       Web browser: ---
            Bug ID: 52929
           Summary: Drop database table "namespaces" from Wikimedia wikis
           Product: Wikimedia
           Version: wmf-deployment
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: Unprioritized
         Component: Site requests
          Assignee: wikibugs-l@lists.wikimedia.org
          Reporter: b...@mzmcbride.com
                CC: benap...@gmail.com, dereck...@espace-win.org,
                    wikimedia.b...@snowolf.eu
            Blocks: 52921
    Classification: Unclassified
   Mobile Platform: ---

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to