From afb1c2ec38fa68ecf12ab91dac985953899942a3 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Fri, 15 Jan 2010 14:38:07 +0100 Subject: [PATCH] Add new Path tables to grant and drop scripts --- bacula/src/cats/drop_mysql_tables.in | 2 ++ bacula/src/cats/drop_postgresql_tables.in | 2 ++ bacula/src/cats/grant_postgresql_privileges.in | 4 ++-- 3 files changed, 6 insertions(+), 2 deletions(-) diff --git a/bacula/src/cats/drop_mysql_tables.in b/bacula/src/cats/drop_mysql_tables.in index 6c2ef32828..a66aa421d5 100644 --- a/bacula/src/cats/drop_mysql_tables.in +++ b/bacula/src/cats/drop_mysql_tables.in @@ -33,6 +33,8 @@ DROP TABLE IF EXISTS MAC; DROP TABLE IF EXISTS Log; DROP TABLE IF EXISTS Location; DROP TABLE IF EXISTS LocationLog; +DROP TABLE IF EXISTS PathVisibility; +DROP TABLE IF EXISTS PathHierarchy; END-OF-DATA then echo "Deletion of ${db_name} MySQL tables succeeded." diff --git a/bacula/src/cats/drop_postgresql_tables.in b/bacula/src/cats/drop_postgresql_tables.in index 71c45b571c..05355ddbe0 100644 --- a/bacula/src/cats/drop_postgresql_tables.in +++ b/bacula/src/cats/drop_postgresql_tables.in @@ -29,6 +29,8 @@ drop table MAC; drop table log; drop table Location; drop table locationlog; +drop table PathVisibility; +drop table PathHierarchy; END-OF-DATA pstat=$? if test $pstat = 0; diff --git a/bacula/src/cats/grant_postgresql_privileges.in b/bacula/src/cats/grant_postgresql_privileges.in index 19ee9bcf4a..5480903bef 100644 --- a/bacula/src/cats/grant_postgresql_privileges.in +++ b/bacula/src/cats/grant_postgresql_privileges.in @@ -33,7 +33,8 @@ grant all on location to ${db_user}; grant all on locationlog to ${db_user}; grant all on log to ${db_user}; grant all on jobhisto to ${db_user}; - +grant all on PathHierarchy to ${db_user}; +grant all on PathVisibility to ${db_user}; -- for sequences on those tables grant select, update on filename_filenameid_seq to ${db_user}; @@ -52,7 +53,6 @@ grant select, update on device_deviceid_seq to ${db_user}; grant select, update on location_locationid_seq to ${db_user}; grant select, update on locationlog_loclogid_seq to ${db_user}; grant select, update on log_logid_seq to ${db_user}; - END-OF-DATA if [ $? -eq 0 ] then -- 2.39.5