From 1f0ac5ad83c7927c201b724a13b486f851c859fb Mon Sep 17 00:00:00 2001 From: Jochen Topf Date: Mon, 14 Jan 2013 11:53:51 +0100 Subject: Add db indexes for relation types and roles --- sources/db/post.sql | 3 +++ 1 file changed, 3 insertions(+) (limited to 'sources/db') diff --git a/sources/db/post.sql b/sources/db/post.sql index 484b186..46969ec 100644 --- a/sources/db/post.sql +++ b/sources/db/post.sql @@ -22,6 +22,9 @@ CREATE UNIQUE INDEX key_distributions_key_idx ON key_distributions (key, object_ CREATE INDEX tagpairs_key1_value1_idx ON tagpairs (key1, value1); CREATE INDEX tagpairs_key2_value2_idx ON tagpairs (key2, value2); +CREATE UNIQUE INDEX relation_types_rtype ON relation_types (rtype); +CREATE INDEX relation_roles_rtype ON relation_roles (rtype); + CREATE TABLE selected_tags ( skey VARCHAR, svalue VARCHAR, -- cgit v1.2.3