diff options
Diffstat (limited to 'util')
-rwxr-xr-x | util/init.pl | 2 | ||||
-rw-r--r-- | util/updates/update_2.8.sql | 16 |
2 files changed, 17 insertions, 1 deletions
diff --git a/util/init.pl b/util/init.pl index 5c171705..ac533174 100755 --- a/util/init.pl +++ b/util/init.pl @@ -22,7 +22,7 @@ print "\n"; print "Creating directory structures...\n"; -for my $d (qw| cv rg st sf |) { +for my $d (qw| cv st sf |) { print " /static/$d\n"; mkdir "$ROOT/static/$d" or die "mkdir '$ROOT/static/$d': $!\n"; for my $i (0..99) { diff --git a/util/updates/update_2.8.sql b/util/updates/update_2.8.sql new file mode 100644 index 00000000..a48c1e73 --- /dev/null +++ b/util/updates/update_2.8.sql @@ -0,0 +1,16 @@ + +-- !BEFORE! running this SQL file, make sure to kill Multi, +-- After running this SQL file, also make sure to do a: +-- $ rm -r static/rg/ +-- And start multi again + +-- VN Relation graphs are stored in the database as SVG - no cmaps and .png anymore +UPDATE vn SET rgraph = NULL; +ALTER TABLE vn DROP CONSTRAINT vn_rgraph_fkey; +DROP TABLE relgraph; +CREATE TABLE vn_graphs ( + id SERIAL PRIMARY KEY, + svg xml NOT NULL +); +ALTER TABLE vn ADD FOREIGN KEY (rgraph) REFERENCES vn_graphs (id); + |