diff options
| author | yorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b> | 2008-08-20 14:17:47 +0000 |
|---|---|---|
| committer | yorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b> | 2008-08-20 14:17:47 +0000 |
| commit | d4368e6342088e8d244cd82dcecce94e74f18299 (patch) | |
| tree | 90033eb3ce8c0953c5575968781ddd37c1866d71 /util/updates/update_1.22.sql | |
| parent | cbd1e5abe69b7ad6e92b95142123e99f544b747e (diff) | |
Converted relation graphs to PNG
git-svn-id: svn://vndb.org/vndb@101 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
Diffstat (limited to 'util/updates/update_1.22.sql')
| -rw-r--r-- | util/updates/update_1.22.sql | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/util/updates/update_1.22.sql b/util/updates/update_1.22.sql index e3729765..9a81b2c6 100644 --- a/util/updates/update_1.22.sql +++ b/util/updates/update_1.22.sql @@ -5,12 +5,11 @@ CREATE TABLE relgraph ( 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; +UPDATE vn SET rgraph = NULL; +ALTER TABLE vn ADD FOREIGN KEY (rgraph) REFERENCES relgraph (id) DEFERRABLE INITIALLY DEFERRED; -- add foreign table constraint to changes.causedby |