1 CREATE TABLE map_hold_policies (
11 ,l_includes_frozen_holds TEXT
12 ,l_distance_is_from_owner TEXT
15 ,x_user_home_ou INTEGER
17 ,x_item_owning_ou INTEGER
18 ,x_item_circ_ou INTEGER
19 ,x_requestor_grp INTEGER
24 ,x_includes_frozen_holds BOOLEAN
25 ,x_distance_is_from_owner BOOLEAN
26 ,x_transit_range INTEGER
28 ,x_migrate BOOLEAN DEFAULT TRUE
31 INSERT INTO gsheet_tracked_table
32 (table_name,tab_name,created)
34 ('map_hold_policies','Hold Policies',NOW())
37 INSERT INTO gsheet_tracked_column
38 (table_id,column_name)
40 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_user_home_ou')
41 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_request_ou')
42 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_item_owning_ou')
43 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_item_circ_ou')
44 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_requestor_grp')
45 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_circ_modifier')
46 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_active')
47 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_holdable')
48 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_max_holds')
49 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_includes_frozen_holds')
50 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_distance_is_from_owner')
51 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_transit_range')
52 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_usr_grp')
56 CREATE TABLE map_circ_policies (
59 ,l_copy_owning_lib TEXT
64 ,l_circ_limit_set TEXT
67 ,l_grace_override TEXT
72 ,x_copy_owning_lib INTEGER
73 ,x_user_home_lib INTEGER
75 ,x_copy_location INTEGER
77 ,x_circ_limit_set INTEGER
78 ,x_duration_rule INTEGER
80 ,x_grace_override INTERVAL
82 ,x_circ_limit_quantity INTEGER
83 ,x_circ_limit_parts INTEGER
84 ,x_circ_limit_ou_name TEXT
85 ,x_circ_limit_ou_id INTEGER
86 ,x_circ_limit_id INTEGER
87 ,x_migrate BOOLEAN DEFAULT FALSE
90 INSERT INTO gsheet_tracked_table
91 (table_name,tab_name,created)
93 ('map_circ_policies','Circ Policies',NOW())
96 INSERT INTO gsheet_tracked_column
97 (table_id,column_name)
99 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_org_unit')
100 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_user_group')
101 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_copy_owning')
102 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_user_home_lib')
103 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circ_mod')
104 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_copy_location')
105 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circulate')
106 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circ_limit_set')
107 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_duration_rule')
108 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_fine_rule')
109 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_grace_override')
110 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_max_fine')
111 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_notes')
114 CREATE TABLE map_circ_limit_sets (
123 ,x_owning_lib INTEGER
131 INSERT INTO gsheet_tracked_table
132 (table_name,tab_name,created)
134 ('map_circ_limit_sets','Circ Limit Sets',NOW())
137 INSERT INTO gsheet_tracked_column
138 (table_id,column_name)
140 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_owning_lib')
141 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_name')
142 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_items_out')
143 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_depth')
144 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_global')
145 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_description')
146 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_circ_mod')
147 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_copy_loc')
150 CREATE TABLE map_create_shelving_location (
153 ,l_copy_location TEXT
155 ,l_checkin_alert TEXT
159 ,x_migrate BOOLEAN NOT NULL DEFAULT TRUE
161 ) INHERITS (asset_copy_location);
163 INSERT INTO gsheet_tracked_table
164 (table_name,tab_name,created)
166 ('map_create_shelving_location','New Copy Locations',NOW())
169 INSERT INTO gsheet_tracked_column
170 (table_id,column_name)
172 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_owning_lib')
173 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_copy_location')
174 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_opac_visible')
175 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_checkin_alert')
176 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_holdable')
177 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_circulate')
178 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_note')
181 CREATE TABLE map_create_account (
207 ,x_migrate BOOLEAN NOT NULL DEFAULT TRUE
210 INSERT INTO gsheet_tracked_table
211 (table_name,tab_name,created)
213 ('map_create_account','New Accounts',NOW())
216 INSERT INTO gsheet_tracked_column
217 (table_id,column_name)
219 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_usrname')
220 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_barcode')
221 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_first_name')
222 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_family_name')
223 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_email')
224 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_password')
225 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_home_library')
226 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile1')
227 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile2')
228 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile3')
229 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou1')
230 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou2')
231 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou3')
232 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou4')
233 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou5')
234 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou6')
235 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou7')
236 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou8')
237 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou9')
238 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou10')
239 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou11')
240 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou12')
241 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou13')
242 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_note')
248 CREATE TABLE map_threshold (
252 ,checkout_threshold TEXT
254 ,overdue_threshold TEXT
258 INSERT INTO gsheet_tracked_table
259 (table_name,tab_name,created)
261 ('map_threshold','Patron Thresholds',NOW())
264 INSERT INTO gsheet_tracked_column
265 (table_id,column_name)
267 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'profile')
268 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'library')
269 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'checkout_threshold')
270 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'fine_threshold')
271 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'overdue_threshold')
272 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'note')
276 CREATE TABLE map_misc (
285 INSERT INTO gsheet_tracked_table
286 (table_name,tab_name,created)
288 ('map_misc','Miscellaneous Options',NOW())
291 INSERT INTO gsheet_tracked_column
292 (table_id,column_name)
294 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'count')
295 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'option')
296 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'Choice')
297 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'value')
298 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'note')
301 CREATE TABLE map_org_setting (
311 INSERT INTO gsheet_tracked_table
312 (table_name,tab_name,created)
314 ('map_org_setting','Org Settings',NOW())
317 INSERT INTO gsheet_tracked_column
318 (table_id,column_name)
320 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_name')
321 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_label')
322 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_entry_type')
323 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_org_unit')
324 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_value')
325 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_note')
329 CREATE TABLE map_bib_manipulations (
339 INSERT INTO gsheet_tracked_table
340 (table_name,tab_name,created)
342 ('map_bib_manipulations','Bib Records',NOW())
345 INSERT INTO gsheet_tracked_column
346 (table_id,column_name)
348 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'name')
349 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'action')
350 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'field')
351 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'subfield')
352 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'matching_value')
353 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'target_value')
354 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'note')