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_trasnit_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 (
98 ,l_circ_limit_set TEXT
102 ,l_fine_interval TEXT
105 ,l_grace_override TEXT
106 ,l_renewal_boolean TEXT
110 ,x_copy_location INTEGER
111 ,x_circ_limit INTEGER
114 ,x_fine_interval INTEGER
118 INSERT INTO gsheet_tracked_table
119 (table_name,tab_name,created)
121 ('map_circ_policies','Circ Policies',NOW())
124 INSERT INTO gsheet_tracked_column
125 (table_id,column_name)
127 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_org_unit')
128 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_user_group')
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_renewals')
135 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_fine')
136 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_fine_interval')
137 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_grace_period')
138 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_max_fine')
139 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_grace_override')
140 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_renewal_boolean')
141 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_notes')
145 CREATE TABLE map_circ_combo_policies (
150 ,l_user_home_lib TEXT
154 ,l_duration_rule TEXT
155 ,l_recurring_fine_rule TEXT
156 ,l_grace_override TEXT
157 ,l_max_fine_rule TEXT
158 ,l_circ_limit_set_name TEXT
161 ,x_user_group INTEGER
163 ,x_copy_own_lib INTEGER
164 ,x_user_home_lib INTEGER
168 ,x_duration_rule INTEGER
169 ,x_recurring_fine_rule INTEGER
170 ,x_grace_override INTERVAL
171 ,x_max_fine_rule INTEGER
172 ,x_circ_limit_set INTEGER
173 ,x_migrate BOOLEAN DEFAULT TRUE
176 INSERT INTO gsheet_tracked_table
177 (table_name,tab_name,created)
179 ('map_circ_combo_policies','Circ Combos',NOW())
182 INSERT INTO gsheet_tracked_column
183 (table_id,column_name)
185 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_active')
186 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_user_group')
187 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_org_unit')
188 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_copy_own_lib')
189 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_user_home_lib')
190 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_circ_mod')
191 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_circulate')
192 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_copy_loc')
193 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_duration_rule')
194 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_recurring_fine_rule')
195 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_grace_override')
196 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_max_fine_rule')
197 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_circ_limit_set_name')
198 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_notes')
201 CREATE TABLE map_create_shelving_location (
204 ,l_copy_location TEXT
206 ,l_checkin_alert TEXT
210 ,x_migrate BOOLEAN NOT NULL DEFAULT TRUE
212 ) INHERITS (asset_copy_location);
214 INSERT INTO gsheet_tracked_table
215 (table_name,tab_name,created)
217 ('map_create_shelving_location','New Copy Locations',NOW())
220 INSERT INTO gsheet_tracked_column
221 (table_id,column_name)
223 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_owning_lib')
224 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_copy_location')
225 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_opac_visible')
226 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_checkin_alert')
227 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_holdable')
228 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_circulate')
229 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_note')
232 CREATE TABLE map_create_account (
246 ,x_migrate BOOLEAN NOT NULL DEFAULT TRUE
247 ) INHERITS (actor_usr);
249 INSERT INTO gsheet_tracked_table
250 (table_name,tab_name,created)
252 ('map_create_account','New Accounts',NOW())
255 INSERT INTO gsheet_tracked_column
256 (table_id,column_name)
258 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_usrname')
259 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_first_name')
260 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_family_name')
261 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_email')
262 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_password')
263 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_home_library')
264 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile1')
265 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile2')
266 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile3')
267 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou')
268 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_note')
269 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_note2')
273 CREATE TABLE map_threshold (
276 ,checkout_threshold TEXT
278 ,overdue_threshold TEXT
282 INSERT INTO gsheet_tracked_table
283 (table_name,tab_name,created)
285 ('map_threshold','Patron Thresholds',NOW())
288 INSERT INTO gsheet_tracked_column
289 (table_id,column_name)
291 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'profile')
292 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'checkout_threshold')
293 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'fine_threshold')
294 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'overdue_threshold')
295 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'note')
299 CREATE TABLE map_misc (
308 INSERT INTO gsheet_tracked_table
309 (table_name,tab_name,created)
311 ('map_misc','Miscellaneous Options',NOW())
314 INSERT INTO gsheet_tracked_column
315 (table_id,column_name)
317 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'count')
318 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'option')
319 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'Choice')
320 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'value')
321 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'note')
324 CREATE TABLE map_org_setting (
334 INSERT INTO gsheet_tracked_table
335 (table_name,tab_name,created)
337 ('map_org_setting','Org Settings',NOW())
340 INSERT INTO gsheet_tracked_column
341 (table_id,column_name)
343 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_name')
344 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_label')
345 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_entry_type')
346 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_org_unit')
347 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_value')
348 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_note')
352 CREATE TABLE map_bib_manipulations (
362 INSERT INTO gsheet_tracked_table
363 (table_name,tab_name,created)
365 ('map_bib_manipulations','Bib Records',NOW())
368 INSERT INTO gsheet_tracked_column
369 (table_id,column_name)
371 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'name')
372 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'action')
373 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'field')
374 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'subfield')
375 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'matching_value')
376 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'target_value')
377 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'note')