-- Table for storing JSON message blobs for the resource loader
CREATE TABLE /*_*/msg_resource (
-- Resource name
- mr_resource varchar(255) NOT NULL,
- -- Language code
+ mr_resource varbinary(255) NOT NULL,
+ -- Language code
mr_lang varbinary(32) NOT NULL,
-- JSON blob. This is an incomplete JSON object, i.e. without the wrapping {}
mr_blob mediumblob NOT NULL,
-- Table for administering which message is contained in which resource
CREATE TABLE /*_*/msg_resource_links (
- mrl_resource varchar(255) NOT NULL,
+ mrl_resource varbinary(255) NOT NULL,
-- Message key
- mrl_message varchar(255) NOT NULL
+ mrl_message varbinary(255) NOT NULL
) /*$wgDBTableOptions*/;
CREATE UNIQUE INDEX /*i*/mrl_message_resource ON /*_*/msg_resource_links (mrl_message, mrl_resource);