X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-sql%2Finit%2F020_common_tables.sql;h=b3abe75e159117bbed6d79f517120c8176dcdf46;hp=02e3fb83f46eb53340bea849352e44119bab2ffc;hb=3e52c324dc8760e92b5ed57b7c941133b75786e8;hpb=90eac21c7051b19b7be20179287bb6b63fb17f0f diff --git a/mig-sql/init/020_common_tables.sql b/mig-sql/init/020_common_tables.sql index 02e3fb8..b3abe75 100644 --- a/mig-sql/init/020_common_tables.sql +++ b/mig-sql/init/020_common_tables.sql @@ -8,8 +8,8 @@ CREATE TABLE map_hold_policies ( ,l_active TEXT ,l_holdable TEXT ,l_max_holds TEXT - ,l_includes_frozen_holds TEXT - ,l_distiance_is_from_owner TEXT + ,l_includes_frozen_holds TEXT + ,l_distance_is_from_owner TEXT ,l_transit_range TEXT ,l_usr_grp TEXT ,x_user_home_ou INTEGER @@ -21,8 +21,8 @@ CREATE TABLE map_hold_policies ( ,x_active BOOLEAN ,x_holdable BOOLEAN ,x_max_holds INTEGER - ,x_includes_frozen_holds BOOLEAN - ,x_distiance_is_from_owner BOOLEAN + ,x_includes_frozen_holds BOOLEAN + ,x_distance_is_from_owner BOOLEAN ,x_transit_range INTEGER ,x_usr_grp INTEGER ,x_migrate BOOLEAN DEFAULT TRUE @@ -79,6 +79,11 @@ 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 ); @@ -106,6 +111,42 @@ VALUES ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_notes') ; +CREATE TABLE map_circ_limit_sets ( + l_owning_lib TEXT + ,l_name TEXT + ,l_items_out TEXT + ,l_depth TEXT + ,l_global TEXT + ,l_description TEXT + ,l_circ_mod TEXT + ,l_copy_loc TEXT + ,x_owning_lib INTEGER + ,x_name TEXT + ,x_items_out INTEGER + ,x_global BOOLEAN + ,x_depth INTEGER + ,x_description TEXT +); + +INSERT INTO gsheet_tracked_table + (table_name,tab_name,created) +VALUES + ('map_circ_limit_sets','Circ Limit Sets',NOW()) +; + +INSERT INTO gsheet_tracked_column + (table_id,column_name) +VALUES + ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_owning_lib') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_name') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_items_out') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_depth') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_global') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_description') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_circ_mod') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_copy_loc') +; + CREATE TABLE map_create_shelving_location ( l_id SERIAL ,l_owning_lib TEXT @@ -139,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 @@ -148,11 +190,22 @@ 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) @@ -164,6 +217,7 @@ 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') @@ -172,14 +226,28 @@ 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 @@ -197,6 +265,7 @@ 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')