From 226d3a9b79b21652ad02ac87a7e518bed6d3681d Mon Sep 17 00:00:00 2001 From: Jochen Topf Date: Sun, 18 May 2014 18:54:09 +0200 Subject: Fixed detection of wiki page types. --- sources/wiki/post.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/sources/wiki/post.sql b/sources/wiki/post.sql index 8d1fea3..fb3a803 100644 --- a/sources/wiki/post.sql +++ b/sources/wiki/post.sql @@ -7,16 +7,16 @@ .bail ON UPDATE wikipages SET status='r' WHERE type='redirect'; -UPDATE wikipages SET status='p' WHERE type='page' AND has_templ='false'; -UPDATE wikipages SET status='t' WHERE type='page' AND has_templ='true' AND parsed=1; -UPDATE wikipages SET status='e' WHERE type='page' AND has_templ='true' AND parsed=0; +UPDATE wikipages SET status='p' WHERE type='page' AND has_templ=0; +UPDATE wikipages SET status='t' WHERE type='page' AND has_templ=1 AND parsed=1; +UPDATE wikipages SET status='e' WHERE type='page' AND has_templ=1 AND parsed=0; CREATE INDEX wikipages_key_value_idx ON wikipages(key, value); UPDATE relation_pages SET status='r' WHERE type='redirect'; -UPDATE relation_pages SET status='p' WHERE type='page' AND has_templ='false'; -UPDATE relation_pages SET status='t' WHERE type='page' AND has_templ='true' AND parsed=1; -UPDATE relation_pages SET status='e' WHERE type='page' AND has_templ='true' AND parsed=0; +UPDATE relation_pages SET status='p' WHERE type='page' AND has_templ=0; +UPDATE relation_pages SET status='t' WHERE type='page' AND has_templ=1 AND parsed=1; +UPDATE relation_pages SET status='e' WHERE type='page' AND has_templ=1 AND parsed=0; CREATE INDEX relation_pages_rtype_idx ON relation_pages(rtype); -- cgit v1.2.3