summaryrefslogtreecommitdiff
path: root/util/updates
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-08-15 14:41:13 +0200
committerYorhel <git@yorhel.nl>2009-08-15 14:41:13 +0200
commitb18be0094764d3afb2ba6f57a5b747ad103b4c1f (patch)
tree0836d69784e0980ae704d51d445903c740728522 /util/updates
parente6bccf922dac29e6307f8dea6319230e67859cff (diff)
Improved VN relations
Diffstat (limited to 'util/updates')
-rw-r--r--util/updates/update_2.7.sql12
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;
+