[Summary view] [Print] [Text view]

   1  -- Table for storing JSON message blobs for the resource loader
   2  CREATE TABLE /*_*/msg_resource (
   3    -- Resource name
   4    mr_resource varbinary(255) NOT NULL,
   5    -- Language code
   6    mr_lang varbinary(32) NOT NULL,
   7    -- JSON blob. This is an incomplete JSON object, i.e. without the wrapping {}
   8    mr_blob mediumblob NOT NULL,
   9    -- Timestamp of last update
  10    mr_timestamp binary(14) NOT NULL
  11  ) /*$wgDBTableOptions*/;
  12  CREATE UNIQUE INDEX /*i*/mr_resource_lang ON /*_*/msg_resource(mr_resource, mr_lang);
  13  
  14  -- Table for administering which message is contained in which resource
  15  CREATE TABLE /*_*/msg_resource_links (
  16    mrl_resource varbinary(255) NOT NULL,
  17    -- Message key
  18    mrl_message varbinary(255) NOT NULL
  19  ) /*$wgDBTableOptions*/;
  20  CREATE UNIQUE INDEX /*i*/mrl_message_resource ON /*_*/msg_resource_links (mrl_message, mrl_resource);