1 files changed, 14 insertions, 0 deletions
diff --git a/util/updates/update_1.22.sql b/util/updates/update_1.22.sql
new file mode 100644
index 00000000..cc475b32
--- /dev/null
+++ b/util/updates/update_1.22.sql
@@ -0,0 +1,14 @@
+
+-- store relation graph image maps in the database
+CREATE TABLE relgraph (
+  id SERIAL NOT NULL PRIMARY KEY,
+  cmap text NOT NULL DEFAULT ''
+) WITHOUT OIDS;
+
+SELECT SETVAL('relgraph_id_seq', NEXTVAL('relgraph_seq'));
+DROP SEQUENCE relgraph_seq;
+
+ALTER TABLE vn ALTER COLUMN rgraph DROP NOT NULL;
+ALTER TABLE vn ALTER COLUMN rgraph SET DEFAULT NULL;
+UPDATE vn SET rgraph = NULL WHERE rgraph = 0;
+