diff options
Diffstat (limited to 'util/updates/update_1.22.sql')
-rw-r--r-- | util/updates/update_1.22.sql | 14 |
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; + |