User:RichMorin/mw transcache

From Meta, a Wikimedia project coordination wiki

Cache of InterWiki transclusions.


Inter-table Relationships[edit]

NA

MySQL Table Description[edit]

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[edit]

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