diff options
author | Yorhel <git@yorhel.nl> | 2008-12-07 15:10:25 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2008-12-07 15:10:25 +0100 |
commit | 40797ed315c9d58f9d5042c02ef165dceb944610 (patch) | |
tree | 958f6de6d83e681c36e9c9faf4f2c5fbde31b160 /util | |
parent | aaa0cf49ce27ff453dfd648e193597198c86372f (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.sql | 5 |
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; + + |