1 -- Table for storing JSON message blobs for ResourceLoader
2 CREATE TABLE /*_*/msg_resource (
4 mr_resource
varbinary(255) NOT NULL,
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
);