summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2008-12-07 15:10:25 +0100
committerYorhel <git@yorhel.nl>2008-12-07 15:10:25 +0100
commit40797ed315c9d58f9d5042c02ef165dceb944610 (patch)
tree958f6de6d83e681c36e9c9faf4f2c5fbde31b160 /util
parentaaa0cf49ce27ff453dfd648e193597198c86372f (diff)
Added extra user rank for people who can't edit but can post on the discussion board
Diffstat (limited to 'util')
-rw-r--r--util/updates/update_2.0.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/util/updates/update_2.0.sql b/util/updates/update_2.0.sql
index f074dfee..1c84c23f 100644
--- a/util/updates/update_2.0.sql
+++ b/util/updates/update_2.0.sql
@@ -132,3 +132,8 @@ CREATE TRIGGER threads_posts_stats_update AFTER INSERT OR UPDATE ON threads_post
CREATE TRIGGER users_stats_update AFTER INSERT OR DELETE ON users FOR EACH ROW EXECUTE PROCEDURE update_stats_cache();
+
+-- extra user rank
+UPDATE users SET rank = rank+1;
+
+