MediaWiki/RecentChanges

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

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

You dont need all those fields though,Zakx. Also see: Custom_Recent_Changes, the query used there goes like:

$res = mysql_query("SELECT rc_id,rc_timestamp,rc_title,rc_comment,rc_user_text FROM recentchanges WHERE rc_title LIKE \"$input%\" ORDER by rc_timestamp desc", $hd) or die ("Unable to run query");

In a default MediaWiki installation the db name is "wikidb" and the user is "wikiuser". Only password would need to be configurable of course.

mutante 23:15, 5 Mar 2005 (CET)

mysql> use wikidb;

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