diff options
| author | Jochen Topf <jochen@topf.org> | 2014-08-21 15:02:17 +0200 |
|---|---|---|
| committer | Jochen Topf <jochen@topf.org> | 2014-08-21 15:02:17 +0200 |
| commit | 9595e921c113c09aadc57b1179593a1648b04067 (patch) | |
| tree | d5a406940e40bb26ee01cec0a8c17d57ac12f52a /sources/projects | |
| parent | 329464dfc287de90850b334f147c9d5ab71a4fdb (diff) | |
| download | taginfo-9595e921c113c09aadc57b1179593a1648b04067.tar taginfo-9595e921c113c09aadc57b1179593a1648b04067.tar.gz | |
Don't create indexes for projects source.
Not needed anyway at the moment and older versions of sqlite don't handle WHERE
clause.
Diffstat (limited to 'sources/projects')
| -rw-r--r-- | sources/projects/post.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sources/projects/post.sql b/sources/projects/post.sql index b8d210f..9f94257 100644 --- a/sources/projects/post.sql +++ b/sources/projects/post.sql @@ -6,8 +6,8 @@ .bail ON -CREATE INDEX project_keys_idx ON project_tags (key) WHERE value IS NULL; -CREATE INDEX project_tags_idx ON project_tags (key, value) WHERE value IS NOT NULL; +-- CREATE INDEX project_keys_idx ON project_tags (key) WHERE value IS NULL; +-- CREATE INDEX project_tags_idx ON project_tags (key, value) WHERE value IS NOT NULL; ANALYZE; |