diff options
Diffstat (limited to 'util/updates/update_2.7.sql')
-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; + |