summaryrefslogtreecommitdiff
path: root/maintenance/postgres/archives/patch-msg_resource_links.sql
blob: e7b80219faa52068b417b674dd53d58ec7feed3a (plain)
1
2
3
4
5
6
CREATE TABLE msg_resource_links (
	mrl_resource TEXT NOT NULL,
	mrl_message TEXT NOT NULL
);

CREATE UNIQUE INDEX mrl_message_resource_idx ON msg_resource_links (mrl_message, mrl_resource);