Extension:CatTalk/cattalk table

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

cattalk_id
Primary key, auto_increments

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

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

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

Schema
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    |                |