git.sur5r.net Git - bacula/bacula/blob - bacula/src/cats/drop_ingres_tables.in

   1 #!/bin/sh
   2 #
   3 # shell script to delete Bacula tables for PostgreSQL
   4
   5 bindir=@INGRES_BINDIR@
   6 PATH="$bindir:$PATH"
   7 db_name=${db_name:-@db_name@}
   8 db_user=${db_user:-@db_user@}
   9
  10 sql -u${db_user} ${db_name} $* <<END-OF-DATA
  11 DROP TABLE Filename;
  12 DROP TABLE Path;
  13 DROP TABLE File;
  14 DROP TABLE RestoreObject;
  15 DROP TABLE Job;
  16 DROP TABLE JobHisto;
  17 DROP TABLE Location;
  18 DROP TABLE Fileset;
  19 DROP TABLE JobMedia;
  20 DROP TABLE Media;
  21 DROP TABLE MediaType;
  22 DROP TABLE Storage;
  23 DROP TABLE Device;
  24 DROP TABLE Pool;
  25 DROP TABLE Client;
  26 DROP TABLE Log;
  27 DROP TABLE LocationLog;
  28 DROP TABLE Counters;
  29 DROP TABLE BaseFiles;
  30 DROP TABLE UnsavedFiles;
  31 DROP TABLE CDImages ;
  32 DROP TABLE PathHierarchy;
  33 DROP TABLE PathVisibility;
  34 DROP TABLE Version;
  35 DROP TABLE Status;
  36 DROP SEQUENCE Filename_Seq;
  37 DROP SEQUENCE Path_Seq;
  38 DROP SEQUENCE File_Seq;
  39 DROP SEQUENCE RestoreObject_Seq;
  40 DROP SEQUENCE Job_Seq;
  41 DROP SEQUENCE JobHisto_Seq;
  42 DROP SEQUENCE Location_Seq;
  43 DROP SEQUENCE Fileset_Seq;
  44 DROP SEQUENCE JobMedia_Seq;
  45 DROP SEQUENCE Media_Seq;
  46 DROP SEQUENCE MediaType_Seq;
  47 DROP SEQUENCE Storage_Seq;
  48 DROP SEQUENCE Device_Seq;
  49 DROP SEQUENCE Pool_Seq;
  50 DROP SEQUENCE Client_Seq;
  51 DROP SEQUENCE Log_Seq;
  52 DROP SEQUENCE LocationLog_Seq;
  53 DROP SEQUENCE BaseFiles_Seq;
  54 \g
  55 END-OF-DATA
  56 pstat=$?
  57 if test $pstat = 0;
  58 then
  59    echo "Deletion of Bacula Ingres tables succeeded."
  60 else
  61    echo "Deletion of Bacula Ingres tables failed."
  62 fi
  63 exit $pstat