diff options
| author | Jochen Topf <jochen@topf.org> | 2013-01-14 11:53:51 +0100 |
|---|---|---|
| committer | Jochen Topf <jochen@topf.org> | 2013-01-14 11:53:51 +0100 |
| commit | 1f0ac5ad83c7927c201b724a13b486f851c859fb (patch) | |
| tree | 06e0658a4c3f37925e4b640ea97cf8b54cb2076d /sources/db | |
| parent | 5f988197e320b47444ce09ec722a7c6e8c4f8b3a (diff) | |
| download | taginfo-1f0ac5ad83c7927c201b724a13b486f851c859fb.tar taginfo-1f0ac5ad83c7927c201b724a13b486f851c859fb.tar.gz | |
Add db indexes for relation types and roles
Diffstat (limited to 'sources/db')
| -rw-r--r-- | sources/db/post.sql | 3 |
1 files changed, 3 insertions, 0 deletions
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, |