51457ec18cbe48ae43d24a809b595231e01c75b3
1 -- Table for storing JSON message blobs for the resource loader
2 CREATE TABLE /*_*/msg_resource (
4 mr_resource
varchar(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
);
14 -- Table for administering which message is contained in which resource
15 CREATE TABLE /*_*/msg_resource_links (
16 mrl_resource
varchar(255) NOT NULL,
18 mrl_message
varchar(255) NOT NULL
19 ) /*$wgDBTableOptions*/;
20 CREATE UNIQUE INDEX /*i*/mrl_message_resource
ON /*_*/msg_resource_links (mrl_message
, mrl_resource
);