Content added Content deleted
imported>mutante mNo edit summary |
imported>mutante mNo edit summary |
||
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) |
||
<pre> |
<pre> |
Revision as of 22:11, 5 March 2005
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; +-------------------+---------------------+------+-----+---------+-------------- --+ | 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)