From c9e2deadd0818d7c14c206e5f26b78b8a92085fd Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Thu, 21 Jun 2018 13:20:23 -0400 Subject: [PATCH 1/1] removing inheritance from matrix mapping tables --- mig-sql/init/020_common_tables.sql | 5 ++--- 1 files changed, 2 insertions(+), 3 deletions(-) diff --git a/mig-sql/init/020_common_tables.sql b/mig-sql/init/020_common_tables.sql index 910a632..3f845ea 100644 --- a/mig-sql/init/020_common_tables.sql +++ b/mig-sql/init/020_common_tables.sql @@ -11,7 +11,7 @@ CREATE TABLE map_hold_policies ( ,x_org_unit INTEGER ,x_grp_id INTEGER ,x_migrate BOOLEAN DEFAULT TRUE -) INHERITS (config.hold_matrix_matchpoint); +); INSERT INTO gsheet_tracked_table (table_name,tab_name,created) @@ -33,7 +33,6 @@ VALUES ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_notes') ; - CREATE TABLE map_hold_combo_policies ( l_user_home_lib TEXT ,l_request_lib TEXT @@ -114,7 +113,7 @@ CREATE TABLE map_circ_policies ( ,x_max_fine INTEGER ,x_fine_interval INTEGER ,x_migrate INTEGER -) INHERITS (config.circ_matrix_matchpoint); +); INSERT INTO gsheet_tracked_table (table_name,tab_name,created) -- 1.7.2.5