User:RichMorin/mw transcache

Cache of InterWiki transclusions.

Inter-table Relationships

NA

MySQL Table Description

mysql> desc mw_objectcache;
+-------------+--------------+------+-----+---------+-------+
| Field       | Type         | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| tc_url      | varchar(255) |      | PRI |         |       |
| tc_contents | text         | YES  |     |         |       |
| tc_time     | int          |      |     |         |       |
+-------------+--------------+------+-----+---------+-------+
3 rows in set

Annotated Table Creation Code

-- Cache of InterWiki transclusions.

CREATE TABLE /*$wgDBprefix*/transcache (

  tc_url              varchar(255)                NOT NULL, 
  tc_contents         text,
  tc_time             int                         NOT NULL,

  UNIQUE INDEX        tc_url_idx(tc_url)

) ENGINE=InnoDB;