From 8c978d76179b4f573c1eb9b9bb9db966c81330bb Mon Sep 17 00:00:00 2001 From: Arne Georg Gleditsch Date: Thu, 15 Nov 2007 21:51:00 +0100 Subject: Too many changes... --- lib/LXRng/Index/Pg.pm | 3 +++ 1 file changed, 3 insertions(+) (limited to 'lib/LXRng/Index/Pg.pm') diff --git a/lib/LXRng/Index/Pg.pm b/lib/LXRng/Index/Pg.pm index 05fe3a0..1b905c0 100644 --- a/lib/LXRng/Index/Pg.pm +++ b/lib/LXRng/Index/Pg.pm @@ -179,6 +179,8 @@ sub init_db { or die($dbh->errstr); $dbh->do(qq{create index ${pre}file_idx1 on ${pre}files using btree (path)}) or die($dbh->errstr); + $dbh->do(qq{create index ${pre}filerel_idx1 on ${pre}filereleases using btree (id_release)}) + or die($dbh->errstr); $dbh->do(qq{grant select on ${pre}charsets to public}) or die($dbh->errstr); $dbh->do(qq{grant select on ${pre}trees to public}) or die($dbh->errstr); @@ -212,6 +214,7 @@ sub drop_db { $dbh->do(qq{drop index ${pre}usage_idx2}); $dbh->do(qq{drop index ${pre}include_idx1}); $dbh->do(qq{drop index ${pre}file_idx1}); + $dbh->do(qq{drop index ${pre}filerel_idx1}); $dbh->do(qq{drop table ${pre}usage}); $dbh->do(qq{drop table ${pre}identifiers}); -- cgit v1.2.3