diff options
author | Yorhel <git@yorhel.nl> | 2009-08-15 14:41:13 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2009-08-15 14:41:13 +0200 |
commit | b18be0094764d3afb2ba6f57a5b747ad103b4c1f (patch) | |
tree | 0836d69784e0980ae704d51d445903c740728522 /util/updates | |
parent | e6bccf922dac29e6307f8dea6319230e67859cff (diff) |
Improved VN relations
Diffstat (limited to 'util/updates')
-rw-r--r-- | util/updates/update_2.7.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/util/updates/update_2.7.sql b/util/updates/update_2.7.sql index 1feea9be..ff9b175e 100644 --- a/util/updates/update_2.7.sql +++ b/util/updates/update_2.7.sql @@ -19,3 +19,15 @@ BEGIN END; $$ LANGUAGE plpgsql; + + +-- VN relations cleanup + +UPDATE vn_relations SET relation = relation + 50 WHERE relation IN(8, 9, 10); +UPDATE vn_relations SET relation = relation - 1 WHERE relation > 3 AND relation < 50; +UPDATE vn_relations SET relation = 7 WHERE relation = 60; +DELETE FROM vn_relations WHERE relation > 50; + +-- Be sure to execute the following query after restarting Multi, to regenerate the relation graphs: +-- UPDATE vn SET rgraph = NULL; + |