X-Git-Url: https://git.sur5r.net/?a=blobdiff_plain;f=bacula%2Fsrc%2Fcats%2Fdrop_ingres_tables.in;h=33ad322f8c2bbb1a48bc70ed0dec588444b5503d;hb=3980a53dce47b0f14bca61082b762323ab2cdf12;hp=4a0bd512ea31a4190be742d800d78d3d8af4b022;hpb=a81a43f67cba9200b06372ec71492a77d9ea4323;p=bacula%2Fbacula

diff --git a/bacula/src/cats/drop_ingres_tables.in b/bacula/src/cats/drop_ingres_tables.in
index 4a0bd512ea..33ad322f8c 100755
--- a/bacula/src/cats/drop_ingres_tables.in
+++ b/bacula/src/cats/drop_ingres_tables.in
@@ -8,47 +8,49 @@ db_name=${db_name:-@db_name@}
 db_user=${db_user:-@db_user@}
 
 sql -u${db_user} ${db_name} $* <<END-OF-DATA
-DROP TABLE filename;
-DROP TABLE path;
-DROP TABLE file;
+DROP TABLE Filename;
+DROP TABLE Path;
+DROP TABLE File;
+DROP TABLE RestoreObject;
 DROP TABLE Job;
 DROP TABLE JobHisto;
 DROP TABLE Location;
-DROP TABLE fileset;
-DROP TABLE jobmedia;
-DROP TABLE media;
+DROP TABLE Fileset;
+DROP TABLE JobMedia;
+DROP TABLE Media;
 DROP TABLE MediaType;
 DROP TABLE Storage;
 DROP TABLE Device;
-DROP TABLE pool;
-DROP TABLE client;
+DROP TABLE Pool;
+DROP TABLE Client;
 DROP TABLE Log;
 DROP TABLE LocationLog;
-DROP TABLE counters;
-DROP TABLE basefiles;
-DROP TABLE unsavedfiles;
+DROP TABLE Counters;
+DROP TABLE BaseFiles;
+DROP TABLE UnsavedFiles;
 DROP TABLE CDImages ;
 DROP TABLE PathHierarchy;
 DROP TABLE PathVisibility;
-DROP TABLE version;
+DROP TABLE Version;
 DROP TABLE Status;
-DROP SEQUENCE filename_seq;
-DROP SEQUENCE path_seq;
-DROP SEQUENCE file_seq;
-DROP SEQUENCE Job_seq;
-DROP SEQUENCE JobHisto_seq;
-DROP SEQUENCE Location_seq;
-DROP SEQUENCE fileset_seq;
-DROP SEQUENCE jobmedia_seq;
-DROP SEQUENCE media_seq;
-DROP SEQUENCE MediaType_seq;
-DROP SEQUENCE Storage_seq;
-DROP SEQUENCE Device_seq;
-DROP SEQUENCE pool_seq;
-DROP SEQUENCE client_seq;
-DROP SEQUENCE Log_seq;
-DROP SEQUENCE LocationLog_seq;
-DROP SEQUENCE basefiles_seq;
+DROP SEQUENCE Filename_Seq;
+DROP SEQUENCE Path_Seq;
+DROP SEQUENCE File_Seq;
+DROP SEQUENCE RestoreObject_Seq;
+DROP SEQUENCE Job_Seq;
+DROP SEQUENCE JobHisto_Seq;
+DROP SEQUENCE Location_Seq;
+DROP SEQUENCE Fileset_Seq;
+DROP SEQUENCE JobMedia_Seq;
+DROP SEQUENCE Media_Seq;
+DROP SEQUENCE MediaType_Seq;
+DROP SEQUENCE Storage_Seq;
+DROP SEQUENCE Device_Seq;
+DROP SEQUENCE Pool_Seq;
+DROP SEQUENCE Client_Seq;
+DROP SEQUENCE Log_Seq;
+DROP SEQUENCE LocationLog_Seq;
+DROP SEQUENCE BaseFiles_Seq;
 \g
 END-OF-DATA
 pstat=$?