From 96e77619793fbe8351e023d17e257e96cdb37509 Mon Sep 17 00:00:00 2001
From: Yorhel <git@yorhel.nl>
Date: Wed, 21 Oct 2009 14:21:38 +0200
Subject: SQL: Renamed vn_graphs to relgraphs and synced dbgraph.pl

As the same table can easily be used to store producer relation graphs
as well.
---
 lib/Multi/Maintenance.pm | 2 +-
 lib/Multi/RG.pm          | 2 +-
 lib/VNDB/DB/VN.pm        | 2 +-
 3 files changed, 3 insertions(+), 3 deletions(-)

(limited to 'lib')

diff --git a/lib/Multi/Maintenance.pm b/lib/Multi/Maintenance.pm
index 59d30ce6..ecc80486 100644
--- a/lib/Multi/Maintenance.pm
+++ b/lib/Multi/Maintenance.pm
@@ -119,7 +119,7 @@ sub vnpopularity {
 
 sub cleangraphs {
   # should be pretty fast
-  $_[KERNEL]->post(pg => do => 'DELETE FROM vn_graphs vg WHERE NOT EXISTS(SELECT 1 FROM vn WHERE rgraph = vg.id)',
+  $_[KERNEL]->post(pg => do => 'DELETE FROM relgraphs vg WHERE NOT EXISTS(SELECT 1 FROM vn WHERE rgraph = vg.id)',
     undef, 'log_stats', 'cleangraphs');
 }
 
diff --git a/lib/Multi/RG.pm b/lib/Multi/RG.pm
index 1ee69911..5cb03ed4 100644
--- a/lib/Multi/RG.pm
+++ b/lib/Multi/RG.pm
@@ -220,7 +220,7 @@ sub savegraph {
   $w->end();
 
   # save the processed SVG in the database and fetch graph ID
-  $_[KERNEL]->post(pg => query => 'INSERT INTO vn_graphs (svg) VALUES (?) RETURNING id', [ $svg ], 'finish');
+  $_[KERNEL]->post(pg => query => 'INSERT INTO relgraphs (svg) VALUES (?) RETURNING id', [ $svg ], 'finish');
 }
 
 
diff --git a/lib/VNDB/DB/VN.pm b/lib/VNDB/DB/VN.pm
index 662057d5..bb2c1275 100644
--- a/lib/VNDB/DB/VN.pm
+++ b/lib/VNDB/DB/VN.pm
@@ -77,7 +77,7 @@ sub dbVNGet {
     $o{what} =~ /changes/ ?
       'JOIN users u ON u.id = c.requester' : (),
     $o{what} =~ /relgraph/ ?
-      'JOIN vn_graphs vg ON vg.id = v.rgraph' : (),
+      'JOIN relgraphs vg ON vg.id = v.rgraph' : (),
   );
 
   my $tag_ids = $o{tags_include} && join ',', @{$o{tags_include}[1]};
-- 
cgit v1.2.3