1 CREATE TABLE map_hold_policies (
13 ,x_migrate BOOLEAN DEFAULT TRUE
14 ) INHERITS (config.hold_matrix_matchpoint);
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')
37 CREATE TABLE map_hold_combo_policies (
42 ,l_request_user_group TEXT
47 ,l_max_includes_frozen TEXT
52 ,x_user_home_lib INTEGER
53 ,x_request_lib INTEGER
55 ,x_item_circ_lib INTEGER
56 ,x_request_user_group INTEGER
58 ,x_active BOOLEAN DEFAULT TRUE
59 ,x_holdable BOOLEAN DEFAULT TRUE
61 ,x_max_includes_frozen BOOLEAN DEFAULT FALSE
62 ,x_range_from BOOLEAN DEFAULT TRUE
63 ,x_trasnit_range INTEGER
65 ,x_migrate BOOLEAN DEFAULT TRUE
68 INSERT INTO gsheet_tracked_table
69 (table_name,tab_name,created)
71 ('map_combo_circ_policies','Hold Combos',NOW())
74 INSERT INTO gsheet_tracked_column
75 (table_id,column_name)
77 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_user_home_lib')
78 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_request_lib')
79 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_owning_lib')
80 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_item_circ_lib')
81 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_request_user_group')
82 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_circ_mod')
83 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_active')
84 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_holdable')
85 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_max_holds')
86 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_max_includes_frozen')
87 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_range_from')
88 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_transit_range')
89 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_user_group')
90 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_notes')
93 CREATE TABLE map_circ_policies (
99 ,l_circ_limit_set TEXT
100 ,l_duration_rule TEXT
103 ,l_fine_interval TEXT
106 ,l_grace_override TEXT
107 ,l_renewal_boolean TEXT
111 ,x_copy_location INTEGER
112 ,x_circ_limit INTEGER
115 ,x_fine_interval INTEGER
117 ) INHERITS (config.circ_matrix_matchpoint);
119 INSERT INTO gsheet_tracked_table
120 (table_name,tab_name,created)
122 ('map_circ_policies','Circ Policies',NOW())
125 INSERT INTO gsheet_tracked_column
126 (table_id,column_name)
128 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_org_unit')
129 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_user_group')
130 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circ_mod')
131 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_copy_location')
132 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circulate')
133 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circ_limit_set')
134 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_duration_rule')
135 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_renewals')
136 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_fine')
137 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_fine_interval')
138 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_grace_period')
139 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_max_fine')
140 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_grace_override')
141 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_renewal_boolean')
142 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_notes')
146 CREATE TABLE map_circ_combo_policies (
151 ,l_user_home_lib TEXT
155 ,l_duration_rule TEXT
156 ,l_recurring_fine_rule TEXT
157 ,l_grace_override TEXT
158 ,l_max_fine_rule TEXT
159 ,l_circ_limit_set_name TEXT
162 ,x_user_group INTEGER
164 ,x_copy_own_lib INTEGER
165 ,x_user_home_lib INTEGER
169 ,x_duration_rule INTEGER
170 ,x_recurring_fine_rule INTEGER
171 ,x_grace_override INTERVAL
172 ,x_max_fine_rule INTEGER
173 ,x_circ_limit_set INTEGER
174 ,x_migrate BOOLEAN DEFAULT TRUE
177 INSERT INTO gsheet_tracked_table
178 (table_name,tab_name,created)
180 ('map_combo_circ_policies','Circ Combos',NOW())
183 INSERT INTO gsheet_tracked_column
184 (table_id,column_name)
186 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_active')
187 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_user_group')
188 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_org_unit')
189 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_copy_own_lib')
190 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_user_home_lib')
191 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_circ_mod')
192 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_circulate')
193 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_copy_loc')
194 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_duration_rule')
195 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_recurring_fine_rule')
196 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_grace_override')
197 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_max_fine_rule')
198 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_circ_limit_set_name')
199 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_notes')
202 CREATE TABLE map_create_shelving_location (
205 ,l_copy_location TEXT
207 ,l_checkin_alert TEXT
211 ,x_migrate BOOLEAN NOT NULL DEFAULT TRUE
213 ) INHERITS (asset_copy_location);
215 INSERT INTO gsheet_tracked_table
216 (table_name,tab_name,created)
218 ('map_create_shelving_location','New Copy Locations',NOW())
221 INSERT INTO gsheet_tracked_column
222 (table_id,column_name)
224 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_owning_lib')
225 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_copy_location')
226 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_opac_visible')
227 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_checkin_alert')
228 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_holdable')
229 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_circulate')
230 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_note')
233 CREATE TABLE map_create_account (
247 ,x_migrate BOOLEAN NOT NULL DEFAULT TRUE
248 ) INHERITS (actor_usr);
250 INSERT INTO gsheet_tracked_table
251 (table_name,tab_name,created)
253 ('map_create_account','New Accounts',NOW())
256 INSERT INTO gsheet_tracked_column
257 (table_id,column_name)
259 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_usrname')
260 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_first_name')
261 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_family_name')
262 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_email')
263 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_password')
264 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_home_library')
265 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile1')
266 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile2')
267 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile3')
268 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou')
269 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_note')
270 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_note2')
274 CREATE TABLE map_threshold (
277 ,checkout_threshold TEXT
279 ,overdue_threshold TEXT
283 INSERT INTO gsheet_tracked_table
284 (table_name,tab_name,created)
286 ('map_threshold','Patron Thresholds',NOW())
289 INSERT INTO gsheet_tracked_column
290 (table_id,column_name)
292 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'profile')
293 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'checkout_threshold')
294 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'fine_threshold')
295 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'overdue_threshold')
296 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'note')
300 CREATE TABLE map_misc (
309 INSERT INTO gsheet_tracked_table
310 (table_name,tab_name,created)
312 ('map_misc','Miscellaneous Options',NOW())
315 INSERT INTO gsheet_tracked_column
316 (table_id,column_name)
318 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'count')
319 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'option')
320 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'Choice')
321 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'value')
322 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'note')
325 CREATE TABLE map_org_setting (
335 INSERT INTO gsheet_tracked_table
336 (table_name,tab_name,created)
338 ('map_org_setting','Org Settings',NOW())
341 INSERT INTO gsheet_tracked_column
342 (table_id,column_name)
344 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_name')
345 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_label')
346 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_entry_type')
347 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_org_unit')
348 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_value')
349 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_note')
353 CREATE TABLE map_bib_manipulations (
363 INSERT INTO gsheet_tracked_table
364 (table_name,tab_name,created)
366 ('map_bib_manipulations','Bib Records',NOW())
369 INSERT INTO gsheet_tracked_column
370 (table_id,column_name)
372 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'name')
373 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'action')
374 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'field')
375 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'subfield')
376 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'matching_value')
377 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'target_value')
378 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'note')