diff options
| author | Jochen Topf <jochen@topf.org> | 2014-05-18 18:54:09 +0200 |
|---|---|---|
| committer | Jochen Topf <jochen@topf.org> | 2014-05-18 18:54:09 +0200 |
| commit | 226d3a9b79b21652ad02ac87a7e518bed6d3681d (patch) | |
| tree | 322bf2272fce5a54e1028608ec72ad35330b46bc /sources/wiki/post.sql | |
| parent | f8d478de7494fd7eae2ef4430f34356234c6e769 (diff) | |
| download | taginfo-226d3a9b79b21652ad02ac87a7e518bed6d3681d.tar taginfo-226d3a9b79b21652ad02ac87a7e518bed6d3681d.tar.gz | |
Fixed detection of wiki page types.
Diffstat (limited to 'sources/wiki/post.sql')
| -rw-r--r-- | sources/wiki/post.sql | 12 |
1 files 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); |