blob: cc475b3294ad26cc5a5aebb252c9d83e86d7524b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
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;
|