From e57800a28734f8df747a561d94cdf1ec90ee92d5 Mon Sep 17 00:00:00 2001 From: Jochen Topf Date: Sat, 19 Jan 2013 12:34:52 +0100 Subject: Rename sql indexes --- sources/wiki/cache.sql | 2 +- 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; -- cgit v1.2.3