Content added Content deleted
imported>mutante mNo edit summary |
Hoof Hearted (talk | contribs) (Fix redirect) |
||
(7 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
Description of the "recentchanges" table in "wikidb". |
Description of the "recentchanges" table in "wikidb". |
||
For [[User:Zakx|Zakx]]. Thank you [[User:mutante|mutante]] 23:11, 5 Mar 2005 (CET) |
For [[User:Zakx|Zakx]]. Thank you, [[User:mutante|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. |
|||
[[User:mutante|mutante]] 23:15, 5 Mar 2005 (CET) |
|||
⚫ | |||
mysql> use wikidb; |
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 |
Database changed |
||
Line 55: | Line 62: | ||
+-------------------+---------------------+------+-----+---------+-------------- |
+-------------------+---------------------+------+-----+---------+-------------- |
||
--+ |
--+ |
||
18 rows in set (0.03 sec) |
18 rows in set (0.03 sec)</pre> |
||
[[Category:Internal]] |
|||
</pre> |
|||
[[Category:Wiki]] |
|||
[[Category:Mediawiki]] |
Latest revision as of 16:04, 29 August 2022
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)