diff options
author | Jochen Topf <jochen@topf.org> | 2013-01-19 12:34:52 +0100 |
---|---|---|
committer | Jochen Topf <jochen@topf.org> | 2013-01-19 12:34:52 +0100 |
commit | e57800a28734f8df747a561d94cdf1ec90ee92d5 (patch) | |
tree | bd7c80d1a33ecc8525a08db76fc456039a474b26 | |
parent | d5422cb98f377fe6388a718425822b0896c3cced (diff) | |
download | taginfo-e57800a28734f8df747a561d94cdf1ec90ee92d5.tar taginfo-e57800a28734f8df747a561d94cdf1ec90ee92d5.tar.gz |
Rename sql indexes
-rw-r--r-- | sources/wiki/cache.sql | 2 | ||||
-rw-r--r-- | sources/wiki/post.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/sources/wiki/cache.sql b/sources/wiki/cache.sql index 7c56b0f..28be6a2 100644 --- a/sources/wiki/cache.sql +++ b/sources/wiki/cache.sql @@ -12,5 +12,5 @@ CREATE TABLE cache_pages ( body TEXT ); -CREATE INDEX cache_pages_title_timestamp ON cache_pages (title, timestamp); +CREATE INDEX cache_pages_title_timestamp_idx ON cache_pages (title, timestamp); diff --git a/sources/wiki/post.sql b/sources/wiki/post.sql index 8bff9fd..9cd6b14 100644 --- a/sources/wiki/post.sql +++ b/sources/wiki/post.sql @@ -20,7 +20,7 @@ UPDATE relation_pages SET status='e' WHERE type='page' AND has_templ='true' AND CREATE INDEX relation_pages_rtype_idx ON relation_pages(rtype); -CREATE INDEX wiki_images_image ON wiki_images(image); +CREATE INDEX wiki_images_image_idx ON wiki_images(image); INSERT INTO wikipages_keys (key, langs, lang_count) SELECT key, group_concat(lang || ' ' || status), count(*) FROM wikipages WHERE value IS NULL GROUP BY key; INSERT INTO wikipages_tags (key, value, langs, lang_count) SELECT key, value, group_concat(lang || ' ' || status), count(*) FROM wikipages WHERE value IS NOT NULL GROUP BY key, value; |