User:RichMorin/mw math

From Meta, a Wikimedia project coordination wiki

-- Used by the math module to keep track -- of previously-rendered items.


Inter-table Relationships[edit]

NA

MySQL Table Description[edit]

mysql> desc mw_math;
+----------------------------+-------------+------+-----+---------+-------+
| Field                      | Type        | Null | Key | Default | Extra |
+----------------------------+-------------+------+-----+---------+-------+
| math_inputhash             | varchar(16) |      | PRI |         |       |
| math_outputhash            | varchar(16) |      |     |         |       |
| math_html_conservativeness | tinyint(1)  |      |     | 0       |       |
| math_html                  | text        | YES  |     | NULL    |       |
| math_mathml                | text        | YES  |     | NULL    |       |
+----------------------------+-------------+------+-----+---------+-------+
5 rows in set


Annotated Table Creation Code[edit]

-- Used by the math module to keep track
-- of previously-rendered items.

CREATE TABLE /*$wgDBprefix*/math (

  -- Binary MD5 hash of the LaTeX fragment,
  -- used as an identifier key.

  math_inputhash      varchar(16)                 NOT NULL,
  
  -- Not sure what this is, exactly...

  math_outputhash     varchar(16)                 NOT NULL,
  
  -- texvc reports how well it thinks the HTML conversion worked;
  -- if it's a low level, the PNG rendering may be preferred.

  math_html_conservativeness  tinyint(1)          NOT NULL,
  
  -- HTML output from texvc, if any

  math_html           text,
  
  -- MathML output from texvc, if any

  math_mathml         text,
  
  UNIQUE KEY math_inputhash (math_inputhash)

) ENGINE=InnoDB;