User:RichMorin/mw trackbacks

From Meta, a Wikimedia project coordination wiki

Contains page trackback information. (unused at this time)


Inter-table Relationships[edit]

  • tb_page - page ID ( page.page_id)
  • tb_title - page title ( page.page_title)


MySQL Table Description[edit]

mysql> desc mw_trackbacks;
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| tb_id    | int(11)      |      | PRI | NULL    | auto_increment |
| tb_page  | int(11)      | YES  | MUL | NULL    |                |
| tb_title | varchar(255) |      |     |         |                |
| tb_url   | varchar(255) |      |     |         |                |
| tb_ex    | text         | YES  |     | NULL    |                |
| tb_name  | varchar(255) | YES  |     | NULL    |                |
+----------+--------------+------+-----+---------+----------------+
6 rows in set


Annotated Table Creation Code[edit]

CREATE TABLE /*$wgDBprefix*/trackbacks (

  tb_id               integer        AUTO_INCREMENT PRIMARY KEY,
  tb_page             integer        REFERENCES page(page_id) ON DELETE CASCADE,
  tb_title            varchar(255)                NOT NULL,
  tb_url              varchar(255)                NOT NULL,
  tb_ex               text,
  tb_name             varchar(255),

INDEX                 (tb_page)

) ENGINE=InnoDB;