summaryrefslogtreecommitdiff
path: root/maintenance/postgres/archives/patch-msg_resource_links.sql
blob: 88109da3c9ce83a41301c06c55652773df5e0d0e (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 ON msg_resource_links (mrl_message, mrl_resource);