Watchlist table/pl

From MediaWiki.org

↑ Manual:Contents

MediaWiki database layout

Watchlist table/pl

Tabela watchlist table zawiera numery id obserwowanych stron użytkowników, numer przestrzeni nazw, tytuł strony oprócz przestrzeni nazw, data, używana dla: powiadomień o zmianach na stronie.

Wygląd tabeli w wersji 1.4:

+------------------+---------------------+------+-----+---------+----------------+
| Pole             | Typ                 | Null |Klucz|Domyślnie| Extra          |
+------------------+---------------------+------+-----+---------+----------------+
| wl_user          | int(5) unsigned     |      |     |         |                |
| wl_namespace     | tinyint(2) unsigned |      |     |    0    |                |
| wl_title         | varchar(255) binary |      |     |    ''   |                |
+------------------+---------------------+------+-----+---------+----------------+

Wygląd tabeli w wersji 1.5:

+--------------------------+-----------------+------+-----+---------+-------+
| Pole                     | Typ             | Null |Klucz|Domyślnie | Extra |
+--------------------------+-----------------+------+-----+---------+-------+
| wl_user                  | int(5) unsigned | NO   | PRI |         |       |
| wl_namespace             | int(11)         | NO   | PRI | 0       |       |
| wl_title                 | varchar(255)    | NO   | PRI |         |       |
| wl_notificationtimestamp | varchar(14)     | NO   |     | 0       |       |
+--------------------------+-----------------+------+-----+---------+-------+

Wygląd tabeli w wersji 1.8:

+--------------------------+-----------------+------+-----+---------+-------+
| Field                    | Typ             | Null |Klucz|Domyślne| Extra |
+--------------------------+-----------------+------+-----+---------+-------+
| wl_user                  | int(5) unsigned | NO   | PRI | NULL    |       |
| wl_namespace             | int(11)         | NO   | PRI | 0       |       |
| wl_title                 | varchar(255)    | NO   | PRI | NULL    |       |
| wl_notificationtimestamp | varchar(14)     | YES  |     | NULL    |       |
+--------------------------+-----------------+------+-----+---------+-------+

mysql> opis tabeli mw_watchlist;
+--------------------------+-----------------+------+-----+---------+-------+
| Pole                     | Typ             | Null |Klucz|Domyślne| Extra |
+--------------------------+-----------------+------+-----+---------+-------+
| wl_user                  | int(5) unsigned | NO   | PRI | NULL    |       |
| wl_namespace             | int(11)         | NO   | PRI | 0       |       |
| wl_title                 | varchar(255)    | NO   | PRI | NULL    |       |
| wl_notificationtimestamp | varchar(14)     | YES  |     | NULL    |       |
+--------------------------+-----------------+------+-----+---------+-------+
4 rows in set (0.01 sec)

Część informacji znajduje się w pliku schema.doc w katalogu MediaWiki: docs/