2007年11月22日 (四) 19:56的修訂版本

Archive table

欄位

ar_text

ar_rev_id

ar_text_id

ar_deleted

ar_len

Schema summary

DESCRIBE archive in MediaWiki 1.10 gives the following:

mysql> describe mw_archive;
+---------------+---------------------+------+-----+---------+-------+
| Field         | Type                | Null | Key | Default | Extra |
+---------------+---------------------+------+-----+---------+-------+
| ar_namespace  | int(11)             | NO   | MUL | 0       |       |
| ar_title      | varchar(255)        | NO   |     | NULL    |       |
| ar_text       | mediumblob          | NO   |     | NULL    |       |
| ar_comment    | tinyblob            | NO   |     | NULL    |       |
| ar_user       | int(5) unsigned     | NO   |     | 0       |       |
| ar_user_text  | varchar(255)        | NO   |     | NULL    |       |
| ar_timestamp  | char(14)            | NO   |     | NULL    |       |
| ar_minor_edit | tinyint(1)          | NO   |     | 0       |       |
| ar_flags      | tinyblob            | NO   |     | NULL    |       |
| ar_rev_id     | int(8) unsigned     | YES  |     | NULL    |       |
| ar_text_id    | int(8) unsigned     | YES  |     | NULL    |       |
| ar_deleted    | tinyint(1) unsigned | NO   |     | 0       |       |
| ar_len        | int(8) unsigned     | YES  |     | NULL    |       |
+---------------+---------------------+------+-----+---------+-------+
13 rows in set (0.02 sec)

DESCRIBE archive in versions before 1.5 gives the following:

+---------------+---------------------+------+-----+---------+-------+
| Field         | Type                | Null | Key | Default | Extra |
+---------------+---------------------+------+-----+---------+-------+
| ar_namespace  | tinyint(2) unsigned |      |     | 0       |       |
| ar_title      | varchar(255) binary |      |     |         |       |
| ar_text       | mediumtext          |      |     |         |       |
| ar_comment    | tinyblob            |      |     |         |       |
| ar_user       | int(5) unsigned     |      |     | 0       |       |
| ar_user_text  | varchar(255) binary |      |     |         |       |
| ar_timestamp  | varchar(14) binary  |      |     |         |       |
| ar_minor_edit | tinyint(1)          |      |     | 0       |       |
| ar_flags      | tinyblob            |      |     |         |       |
+---------------+---------------------+------+-----+---------+-------+

Image table

+-----------------+---------------------+------+-----+---------+-------+
| Field           | Type                | Null | Key | Default | Extra |
+-----------------+---------------------+------+-----+---------+-------+
| img_name        | varchar(255) binary |      |     |         |       |
| img_size        | int(8) unsigned     |      |     | 0       |       |
| img_description | tinyblob            |      |     |         |       |
| img_user        | int(5) unsigned     |      |     | 0       |       |
| img_user_text   | varchar(255) binary |      |     |         |       |
| img_timestamp   | varchar(14) binary  |      |     |         |       |
+-----------------+---------------------+------+-----+---------+-------+

mysql> describe mw_image; +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | img_name | varchar(255) | NO | PRI | NULL | | | img_size | int(8) unsigned | NO | MUL | 0 | | | img_width | int(5) | NO | | 0 | | | img_height | int(5) | NO | | 0 | | | img_metadata | mediumblob | NO | | NULL | | | img_bits | int(3) | NO | | 0 | | | img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | | | img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart') | NO | | unknown | | | img_minor_mime | varchar(32) | NO | | unknown | | | img_description | tinyblob | NO | | NULL | | | img_user | int(5) unsigned | NO | | 0 | | | img_user_text | varchar(255) | NO | | NULL | | | img_timestamp | char(14) | NO | MUL | NULL | | +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ 13 rows in set (0.00 sec)