maintenance/postgres/archives/patch-msg_resource.sql


1
2
3
4
5
6
7
8

CREATE TABLE msg_resource (
	mr_resource TEXT NOT NULL,
	mr_lang		TEXT NOT NULL,
	mr_blob		TEXT NOT NULL,
	mr_timestamp	TIMESTAMPTZ NOT NULL
);

CREATE UNIQUE INDEX mr_resource_lang_idx ON msg_resource (mr_resource, mr_lang);