User:Titoxd/To do

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  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  templates).
 * 7) Categorization within Category:MediaWiki database tables.

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