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=@SQL_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 Job;
  15 DROP TABLE JobHisto;
  16 DROP TABLE Location;
  17 DROP TABLE fileset;
  18 DROP TABLE jobmedia;
  19 DROP TABLE media;
  20 DROP TABLE MediaType;
  21 DROP TABLE Storage;
  22 DROP TABLE Device;
  23 DROP TABLE pool;
  24 DROP TABLE client;
  25 DROP TABLE Log;
  26 DROP TABLE LocationLog;
  27 DROP TABLE counters;
  28 DROP TABLE basefiles;
  29 DROP TABLE unsavedfiles;
  30 DROP TABLE CDImages ;
  31 DROP TABLE PathHierarchy;
  32 DROP TABLE PathVisibility;
  33 DROP TABLE version;
  34 DROP TABLE Status;
  35 DROP SEQUENCE filename_seq;
  36 DROP SEQUENCE path_seq;
  37 DROP SEQUENCE file_seq;
  38 DROP SEQUENCE Job_seq;
  39 DROP SEQUENCE JobHisto_seq;
  40 DROP SEQUENCE Location_seq;
  41 DROP SEQUENCE fileset_seq;
  42 DROP SEQUENCE jobmedia_seq;
  43 DROP SEQUENCE media_seq;
  44 DROP SEQUENCE MediaType_seq;
  45 DROP SEQUENCE Storage_seq;
  46 DROP SEQUENCE Device_seq;
  47 DROP SEQUENCE pool_seq;
  48 DROP SEQUENCE client_seq;
  49 DROP SEQUENCE Log_seq;
  50 DROP SEQUENCE LocationLog_seq;
  51 DROP SEQUENCE basefiles_seq;
  52 \g
  53 END-OF-DATA
  54 pstat=$?
  55 if test $pstat = 0;
  56 then
  57    echo "Deletion of Bacula Ingres tables succeeded."
  58 else
  59    echo "Deletion of Bacula Ingres tables failed."
  60 fi
  61 exit $pstat