MediaWiki/RecentChanges

Description of the "recentchanges" table in "wikidb".

For Zakx. Thank you mutante 23:11, 5 Mar 2005 (CET)

mysql> use wikidb; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A

Database changed mysql> describe recentchanges; +---+-+--+-+-+-- --+ | +---+-+--+-+-+-- --+  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | t | +---+-+--+-+-+-- --+ 18 rows in set (0.03 sec)
 * Field            | Type                | Null | Key | Default | Extra
 * rc_timestamp     | varchar(14) binary  |      | MUL |         |
 * rc_cur_time      | varchar(14) binary  |      |     |         |
 * rc_user          | int(10) unsigned    |      |     | 0       |
 * rc_user_text     | varchar(255) binary |      |     |         |
 * rc_namespace     | tinyint(3) unsigned |      | MUL | 0       |
 * rc_title         | varchar(255) binary |      |     |         |
 * rc_comment       | varchar(255) binary |      |     |         |
 * rc_minor         | tinyint(3) unsigned |      |     | 0       |
 * rc_bot           | tinyint(3) unsigned |      |     | 0       |
 * rc_new           | tinyint(3) unsigned |      | MUL | 0       |
 * rc_cur_id        | int(10) unsigned    |      | MUL | 0       |
 * rc_this_oldid    | int(10) unsigned    |      |     | 0       |
 * rc_last_oldid    | int(10) unsigned    |      |     | 0       |
 * rc_type          | tinyint(3) unsigned |      |     | 0       |
 * rc_moved_to_ns   | tinyint(3) unsigned |      |     | 0       |
 * rc_moved_to_title | varchar(255) binary |     |     |         |
 * rc_ip            | varchar(15)         |      | MUL |         |
 * rc_id            | int(8)              |      | PRI | NULL    | auto_incremen