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;
+-------------------+---------------------+------+-----+---------+--------------
--+
| 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
t |
+-------------------+---------------------+------+-----+---------+--------------
--+
18 rows in set (0.03 sec)

Recent changes