X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-sql%2Finit%2F020_common_tables.sql;h=1ad339df20498e0121436bd7df0e471b676b8c66;hp=9c1503e0f12acd124531fc21bf106da72c38dbaa;hb=8f3c70aa5aaeb1c4742c4d15da7fc535035b3a2e;hpb=ebd4cccb28dd53814a42ba0c50b1ed7a891397c2 diff --git a/mig-sql/init/020_common_tables.sql b/mig-sql/init/020_common_tables.sql index 9c1503e..1ad339d 100644 --- 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