From d41e5037038251797787406a0deba110a36574ca Mon Sep 17 00:00:00 2001 From: Kevin Day Date: Tue, 30 May 2017 22:46:41 -0500 Subject: [PATCH] Update: remove currently unused or incorrect sql data --- database/sql/reservation/reservation-permissions.sql | 2 +- database/sql/standard/standard-files.sql | 2 -- 2 files changed, 1 insertion(+), 3 deletions(-) diff --git a/database/sql/reservation/reservation-permissions.sql b/database/sql/reservation/reservation-permissions.sql index 759e832..97ef023 100644 --- a/database/sql/reservation/reservation-permissions.sql +++ b/database/sql/reservation/reservation-permissions.sql @@ -470,7 +470,7 @@ grant select,usage on s_tables.se_files_id to r_reservation_administer; grant usage on s_tables.se_files_id to r_reservation, r_reservation_system; grant select on s_users.v_files to r_reservation, r_reservation_system; -grant select on public.v_path_types to r_reservation, r_reservation_public, r_reservation_system; +grant select on public.v_files to r_reservation, r_reservation_public, r_reservation_system; /* standard-paths.sql permissions */ diff --git a/database/sql/standard/standard-files.sql b/database/sql/standard/standard-files.sql index b0a290b..b26d985 100644 --- a/database/sql/standard/standard-files.sql +++ b/database/sql/standard/standard-files.sql @@ -37,14 +37,12 @@ create table s_tables.t_files ( constraint cp_files primary key (id), constraint cu_files_name_machine unique (name_machine), - constraint cu_files_field_path unique (field_path), constraint cc_files_id check (id > 0), constraint cc_files_name_machine check (name_machine ~ '[A-Za-z]\w*'), constraint cf_files_id_creator foreign key (id_creator) references s_tables.t_users (id) on delete cascade on update cascade, constraint cf_files_id_creator_session foreign key (id_creator_session) references s_tables.t_users (id) on delete cascade on update cascade, - constraint cf_files_id_type foreign key (id_type) references s_tables.t_file_types (id) on delete restrict on update cascade, constraint cf_files_id_group foreign key (id_group) references s_tables.t_groups (id) on delete restrict on update cascade ); -- 1.8.3.1