1 CREATE TABLE map_hold_policies (
13 ,x_migrate BOOLEAN DEFAULT TRUE
16 INSERT INTO gsheet_tracked_table
17 (table_name,tab_name,created)
19 ('map_hold_policies','Hold Policies',NOW())
22 INSERT INTO gsheet_tracked_column
23 (table_id,column_name)
25 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_org_unit')
26 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_user_group')
27 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_circ_mod')
28 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_holdable')
29 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_max_holds')
30 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_include_frozen')
31 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_transit_range')
32 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_range_from')
33 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_notes')
36 CREATE TABLE map_hold_combo_policies (
41 ,l_request_user_group TEXT
46 ,l_max_includes_frozen TEXT
51 ,x_user_home_lib INTEGER
52 ,x_request_lib INTEGER
54 ,x_item_circ_lib INTEGER
55 ,x_request_user_group INTEGER
57 ,x_active BOOLEAN DEFAULT TRUE
58 ,x_holdable BOOLEAN DEFAULT TRUE
60 ,x_max_includes_frozen BOOLEAN DEFAULT FALSE
61 ,x_range_from BOOLEAN DEFAULT TRUE
62 ,x_transit_range INTEGER
64 ,x_migrate BOOLEAN DEFAULT TRUE
67 INSERT INTO gsheet_tracked_table
68 (table_name,tab_name,created)
70 ('map_hold_combo_policies','Hold Combos',NOW())
73 INSERT INTO gsheet_tracked_column
74 (table_id,column_name)
76 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_user_home_lib')
77 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_request_lib')
78 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_owning_lib')
79 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_item_circ_lib')
80 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_request_user_group')
81 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_circ_mod')
82 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_active')
83 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_holdable')
84 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_max_holds')
85 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_max_includes_frozen')
86 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_range_from')
87 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_transit_range')
88 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_user_group')
89 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_notes')
92 CREATE TABLE map_circ_policies (
95 ,l_copy_owning_lib TEXT
100 ,l_circ_limit_set TEXT
101 ,l_duration_rule TEXT
103 ,l_grace_override TEXT
108 ,x_copy_location INTEGER
109 ,x_circ_limit INTEGER
112 ,x_fine_interval INTEGER
113 ,x_migrate BOOLEAN DEFAULT FALSE
116 INSERT INTO gsheet_tracked_table
117 (table_name,tab_name,created)
119 ('map_circ_policies','Circ Policies',NOW())
122 INSERT INTO gsheet_tracked_column
123 (table_id,column_name)
125 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_org_unit')
126 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_user_group')
127 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_copy_owning')
128 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_user_home_lib')
129 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circ_mod')
130 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_copy_location')
131 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circulate')
132 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circ_limit_set')
133 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_duration_rule')
134 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_fine_rule')
135 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_grace_override')
136 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_max_fine')
137 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_notes')
140 CREATE TABLE map_create_shelving_location (
143 ,l_copy_location TEXT
145 ,l_checkin_alert TEXT
149 ,x_migrate BOOLEAN NOT NULL DEFAULT TRUE
151 ) INHERITS (asset_copy_location);
153 INSERT INTO gsheet_tracked_table
154 (table_name,tab_name,created)
156 ('map_create_shelving_location','New Copy Locations',NOW())
159 INSERT INTO gsheet_tracked_column
160 (table_id,column_name)
162 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_owning_lib')
163 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_copy_location')
164 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_opac_visible')
165 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_checkin_alert')
166 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_holdable')
167 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_circulate')
168 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_note')
171 CREATE TABLE map_create_account (
185 ,x_migrate BOOLEAN NOT NULL DEFAULT TRUE
186 ) INHERITS (actor_usr);
188 INSERT INTO gsheet_tracked_table
189 (table_name,tab_name,created)
191 ('map_create_account','New Accounts',NOW())
194 INSERT INTO gsheet_tracked_column
195 (table_id,column_name)
197 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_usrname')
198 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_first_name')
199 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_family_name')
200 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_email')
201 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_password')
202 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_home_library')
203 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile1')
204 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile2')
205 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile3')
206 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou')
207 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_note')
208 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_note2')
212 CREATE TABLE map_threshold (
215 ,checkout_threshold TEXT
217 ,overdue_threshold TEXT
221 INSERT INTO gsheet_tracked_table
222 (table_name,tab_name,created)
224 ('map_threshold','Patron Thresholds',NOW())
227 INSERT INTO gsheet_tracked_column
228 (table_id,column_name)
230 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'profile')
231 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'checkout_threshold')
232 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'fine_threshold')
233 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'overdue_threshold')
234 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'note')
238 CREATE TABLE map_misc (
247 INSERT INTO gsheet_tracked_table
248 (table_name,tab_name,created)
250 ('map_misc','Miscellaneous Options',NOW())
253 INSERT INTO gsheet_tracked_column
254 (table_id,column_name)
256 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'count')
257 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'option')
258 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'Choice')
259 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'value')
260 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'note')
263 CREATE TABLE map_org_setting (
273 INSERT INTO gsheet_tracked_table
274 (table_name,tab_name,created)
276 ('map_org_setting','Org Settings',NOW())
279 INSERT INTO gsheet_tracked_column
280 (table_id,column_name)
282 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_name')
283 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_label')
284 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_entry_type')
285 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_org_unit')
286 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_value')
287 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_note')
291 CREATE TABLE map_bib_manipulations (
301 INSERT INTO gsheet_tracked_table
302 (table_name,tab_name,created)
304 ('map_bib_manipulations','Bib Records',NOW())
307 INSERT INTO gsheet_tracked_column
308 (table_id,column_name)
310 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'name')
311 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'action')
312 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'field')
313 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'subfield')
314 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'matching_value')
315 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'target_value')
316 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'note')