maintenance/postgres/archives/patch-iwlinks.sql


1
2
3
4
5
6
7
8


CREATE TABLE iwlinks (
	iwl_from INTEGER NOT NULL DEFAULT 0,
	iwl_prefix TEXT NOT NULL DEFAULT '',
	iwl_title TEXT NOT NULL DEFAULT ''
);
CREATE UNIQUE INDEX iwl_from ON iwlinks (iwl_from, iwl_prefix, iwl_title);
CREATE UNIQUE INDEX iwl_prefix_title_from ON iwlinks (iwl_prefix, iwl_title, iwl_from);