moar columns for bre

[migration-tools.git] / mig-sql / init / 020_common_tables.sql

diff --git a/mig-sql/init/020_common_tables.sql b/mig-sql/init/020_common_tables.sql
index 9c1503e..1ad339d 100644 (file)
--- a/mig-sql/init/020_common_tables.sql
+++ b/mig-sql/init/020_common_tables.sql
@@ -29,9 +29,9 @@ CREATE TABLE map_hold_policies (
 );
 
 INSERT INTO gsheet_tracked_table 
-    (table_name,tab_name,created)
+    (sheet_name,table_name,tab_name,created)
 VALUES
-    ('map_hold_policies','Hold Policies',NOW())
+    ((SELECT SPLIT_PART(reset_val,',',1) FROM pg_settings WHERE name = 'search_path'),'map_hold_policies','Hold Policies',NOW())
 ;
 
 INSERT INTO gsheet_tracked_column
@@ -79,13 +79,18 @@ CREATE TABLE map_circ_policies (
     ,x_fine_rule            INTEGER
     ,x_grace_override       INTERVAL
     ,x_max_fine             INTEGER
+    ,x_circ_limit_quantity  INTEGER
+    ,x_circ_limit_parts     INTEGER
+    ,x_circ_limit_ou_name   TEXT
+    ,x_circ_limit_ou_id     INTEGER
+    ,x_circ_limit_id        INTEGER
     ,x_migrate              BOOLEAN DEFAULT FALSE
 );
 
 INSERT INTO gsheet_tracked_table
-    (table_name,tab_name,created)
+    (sheet_name,table_name,tab_name,created)
 VALUES
-    ('map_circ_policies','Circ Policies',NOW())
+    ((SELECT SPLIT_PART(reset_val,',',1) FROM pg_settings WHERE name = 'search_path'),'map_circ_policies','Circ Policies',NOW())
 ;
 
 INSERT INTO gsheet_tracked_column
@@ -124,9 +129,9 @@ CREATE TABLE map_circ_limit_sets (
 );
 
 INSERT INTO gsheet_tracked_table
-    (table_name,tab_name,created)
+    (sheet_name,table_name,tab_name,created)
 VALUES
-    ('map_circ_limit_sets','Circ Limit Sets',NOW())
+    ((SELECT SPLIT_PART(reset_val,',',1) FROM pg_settings WHERE name = 'search_path'),'map_circ_limit_sets','Circ Limit Sets',NOW())
 ;
 
 INSERT INTO gsheet_tracked_column
@@ -156,9 +161,9 @@ CREATE TABLE map_create_shelving_location (
 ) INHERITS (asset_copy_location);
 
 INSERT INTO gsheet_tracked_table 
-    (table_name,tab_name,created)
+    (sheet_name,table_name,tab_name,created)
 VALUES 
-    ('map_create_shelving_location','New Copy Locations',NOW())
+    ((SELECT SPLIT_PART(reset_val,',',1) FROM pg_settings WHERE name = 'search_path'),'map_create_shelving_location','New Copy Locations',NOW())
 ;
 
 INSERT INTO gsheet_tracked_column 
@@ -175,6 +180,7 @@ VALUES
 
 CREATE TABLE map_create_account (
     l_id                  SERIAL
+    ,l_barcode            TEXT
     ,l_usrname            TEXT            
     ,l_first_name         TEXT
     ,l_family_name        TEXT
@@ -184,22 +190,34 @@ CREATE TABLE map_create_account (
     ,l_profile1           TEXT
     ,l_profile2           TEXT
     ,l_profile3           TEXT
-    ,l_work_ou            TEXT
+    ,l_work_ou1           TEXT
+    ,l_work_ou2           TEXT
+    ,l_work_ou3           TEXT
+    ,l_work_ou4           TEXT
+    ,l_work_ou5           TEXT
+    ,l_work_ou6           TEXT
+    ,l_work_ou7           TEXT
+    ,l_work_ou8           TEXT
+    ,l_work_ou9           TEXT
+    ,l_work_ou10          TEXT
+    ,l_work_ou11          TEXT
+    ,l_work_ou12          TEXT
+    ,l_work_ou13          TEXT
     ,l_note               TEXT
-    ,l_note2              TEXT
     ,x_migrate            BOOLEAN NOT NULL DEFAULT TRUE
-) INHERITS (actor_usr);
+);
 
 INSERT INTO gsheet_tracked_table 
-    (table_name,tab_name,created)
+    (sheet_name,table_name,tab_name,created)
 VALUES 
-    ('map_create_account','New Accounts',NOW())
+    ((SELECT SPLIT_PART(reset_val,',',1) FROM pg_settings WHERE name = 'search_path'),'map_create_account','New Accounts',NOW())
 ;
 
 INSERT INTO gsheet_tracked_column 
     (table_id,column_name) 
 VALUES 
      ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_usrname')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_barcode')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_first_name')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_family_name')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_email')
@@ -208,14 +226,25 @@ VALUES
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile1')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile2')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile3')
-    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou1')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou2')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou3')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou4')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou5')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou6')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou7')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou8')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou9')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou10')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou11')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou12')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou13')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_note')
-    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_note2')
 ;
 
-
 CREATE TABLE map_threshold (
     id                  SERIAL
+    ,library            TEXT
     ,profile            TEXT            
     ,checkout_threshold TEXT
     ,fine_threshold     TEXT
@@ -224,15 +253,16 @@ CREATE TABLE map_threshold (
 );
 
 INSERT INTO gsheet_tracked_table 
-    (table_name,tab_name,created)
+    (sheet_name,table_name,tab_name,created)
 VALUES 
-    ('map_threshold','Patron Thresholds',NOW())
+    ((SELECT SPLIT_PART(reset_val,',',1) FROM pg_settings WHERE name = 'search_path'),'map_threshold','Patron Thresholds',NOW())
 ;
 
 INSERT INTO gsheet_tracked_column 
     (table_id,column_name) 
 VALUES 
      ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'profile')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'library')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'checkout_threshold')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'fine_threshold')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'overdue_threshold')
@@ -250,9 +280,9 @@ CREATE TABLE map_misc (
 );
 
 INSERT INTO gsheet_tracked_table 
-    (table_name,tab_name,created)
+    (sheet_name,table_name,tab_name,created)
 VALUES 
-    ('map_misc','Miscellaneous Options',NOW())
+    ((SELECT SPLIT_PART(reset_val,',',1) FROM pg_settings WHERE name = 'search_path'),'map_misc','Miscellaneous Options',NOW())
 ;
 
 INSERT INTO gsheet_tracked_column 
@@ -276,9 +306,9 @@ CREATE TABLE map_org_setting (
 );
 
 INSERT INTO gsheet_tracked_table 
-    (table_name,tab_name,created)
+    (sheet_name,table_name,tab_name,created)
 VALUES 
-    ('map_org_setting','Org Settings',NOW())
+    ((SELECT SPLIT_PART(reset_val,',',1) FROM pg_settings WHERE name = 'search_path'),'map_org_setting','Org Settings',NOW())
 ;
 
 INSERT INTO gsheet_tracked_column 
@@ -304,9 +334,9 @@ CREATE TABLE map_bib_manipulations (
 );
 
 INSERT INTO gsheet_tracked_table
-    (table_name,tab_name,created)
+    (sheet_name,table_name,tab_name,created)
 VALUES
-    ('map_bib_manipulations','Bib Records',NOW())
+    ((SELECT SPLIT_PART(reset_val,',',1) FROM pg_settings WHERE name = 'search_path'),'map_bib_manipulations','Bib Records',NOW())
 ;
 
 INSERT INTO gsheet_tracked_column