From 8a3d13ef7665a9a223addf798b964eccd879ef7d Mon Sep 17 00:00:00 2001
From: Marco van Wieringen <mvw@planets.elm.net>
Date: Wed, 31 Mar 2010 22:02:59 +0200
Subject: [PATCH] Change Ingres drop script so we can run any form of
 regression and a drop really drops the content of the database so we can run
 make_ingres_tables again.

---
 bacula/src/cats/drop_ingres_tables.in | 64 +++++++++++++++++----------
 1 file changed, 41 insertions(+), 23 deletions(-)

diff --git a/bacula/src/cats/drop_ingres_tables.in b/bacula/src/cats/drop_ingres_tables.in
index 5b20c50108..10b9f3c4bd 100755
--- a/bacula/src/cats/drop_ingres_tables.in
+++ b/bacula/src/cats/drop_ingres_tables.in
@@ -7,29 +7,47 @@ db_name=@db_name@
 db_user=@db_user@
 
 sql -u${db_user} ${db_name} $* <<END-OF-DATA
-drop table unsavedfiles;
-drop table basefiles;
-drop table jobmedia;
-drop table file;
-drop table job;
-drop table jobhisto;
-drop table media;
-drop table client;
-drop table pool;
-drop table fileset;
-drop table path;
-drop table filename;
-drop table counters;
-drop table version;
-drop table CDImages;
-drop table Device;
-drop table Storage;
-drop table MediaType;
-drop table Status;
-drop table MAC;
-drop table log;
-drop table Location;
-drop table locationlog;
+DROP TABLE filename\g
+DROP TABLE path\g
+DROP TABLE file\g
+DROP TABLE Job\g
+DROP TABLE JobHisto\g
+DROP TABLE Location\g
+DROP TABLE fileset\g
+DROP TABLE jobmedia\g
+DROP TABLE media\g
+DROP TABLE MediaType\g
+DROP TABLE Storage\g
+DROP TABLE Device\g
+DROP TABLE pool\g
+DROP TABLE client\g
+DROP TABLE Log\g
+DROP TABLE LocationLog\g
+DROP TABLE counters\g
+DROP TABLE basefiles\g
+DROP TABLE unsavedfiles\g
+DROP TABLE CDImages \g
+DROP TABLE PathHierarchy\g
+DROP TABLE PathVisibility\g
+DROP TABLE version\g
+DROP TABLE Status\g
+DROP SEQUENCE filename_seq\g
+DROP SEQUENCE path_seq\g
+DROP SEQUENCE file_seq\g
+DROP SEQUENCE Job_seq\g
+DROP SEQUENCE JobHisto_seq\g
+DROP SEQUENCE Location_seq\g
+DROP SEQUENCE fileset_seq\g
+DROP SEQUENCE jobmedia_seq\g
+DROP SEQUENCE media_seq\g
+DROP SEQUENCE MediaType_seq\g
+DROP SEQUENCE Storage_seq\g
+DROP SEQUENCE Device_seq\g
+DROP SEQUENCE pool_seq\g
+DROP SEQUENCE client_seq\g
+DROP SEQUENCE Log_seq\g
+DROP SEQUENCE LocationLog_seq\g
+DROP SEQUENCE basefiles_seq\g
 END-OF-DATA
 pstat=$?
 if test $pstat = 0; 
-- 
2.39.5