User:Titoxd/To do

From MediaWiki.org

[edit] Manual:Database layout cleanup

As of MediaWiki 1.11:

• archive table
• categorylinks table
• externallinks table
• filearchive table
• hitcounter table
• image table
• imagelinks table
• interwiki table
• ipblocks table
• job table
• langlinks table
• logging table
• math table
• objectcache table
• oldimage table
• page restrictions table
• page table
• pagelinks table
• querycache table
• querycachetwo table
• querycache info table
• recentchanges table
• redirect table
• revision table
• searchindex table
• site_stats table
• templatelinks table
• text table
• trackbacks table
• transcache table
• user table
• user_groups table
• user_newtalk table
• watchlist table

Ideally, all pages should look like Revision table:

1. Quick description of the table, per WP:LEDE and WP:MOS
2. Links to fields in other tables, not just the tables
3. A level-2 "Fields" header, and a level-2 "Schema summary" header
4. One level-3 section for each field
5. Detailed description of each field, including usage, and if applicable, introduction version (release version, although SVN link is nice too)
6. MySQL DESCRIBE {{{table}}} statement results for each version. (If there were no schema changes between versions, it is fair to say so, or just to dump one of the many {{MW 1.x}} templates).
7. Categorization within Category:MediaWiki database tables.

[edit] Database layout update

• maintenance/archives/patch-rc_deleted.sql
• maintenance/archives/patch-log_id.sql
• maintenance/archives/patch-log_deleted.sql
• maintenance/archives/patch-ar_deleted.sql
• maintenance/archives/patch-ipb_deleted.sql
• maintenance/archives/patch-fa_deleted.sql
• maintenance/archives/patch-rev_len.sql
• maintenance/archives/patch-ar_len.sql
• maintenance/archives/patch-rev_parent_id.sql
• maintenance/archives/patch-page_restrictions.sql
• maintenance/archives/patch-page_restrictions_sortkey.sql