,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
,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
);
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
,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
,((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
+ (sheet_name,table_name,tab_name,created)
+VALUES
+ ((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
+ (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
) 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
CREATE TABLE map_create_account (
l_id SERIAL
+ ,l_barcode TEXT
,l_usrname TEXT
,l_first_name TEXT
,l_family_name TEXT
,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')
,((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
);
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')
);
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
);
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
);
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