Extension:CatTalk/cattalk table

Other languages:

Table used by the CatTalk extension to process categories specified on talk pages for main pages.

FieldsEdit

cattalk_idEdit

Primary key, auto_increments

main_page_idEdit

Key that references the relevant page_id for the page we want to categorise. Note that this isn't the ID of the Main Page!

talk_page_idEdit

Key that references the relevant page_id for the talk page corresponding to the main_page_id.

categoriesEdit

A blob of categories to apply to the page, kept as strings of category names delimited by pipe characters (|).

SchemaEdit

mysql> describe cattalk;
+--------------+---------+------+-----+---------+----------------+
| Field        | Type    | Null | Key | Default | Extra          |
+--------------+---------+------+-----+---------+----------------+
| cattalk_id   | int(11) | NO   | PRI | NULL    | auto_increment |
| main_page_id | int(11) | NO   | UNI | NULL    |                |
| talk_page_id | int(11) | NO   | UNI | NULL    |                |
| categories   | blob    | NO   |     | NULL    |                |
+--------------+---------+------+-----+---------+----------------+