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_migrate BOOLEAN DEFAULT FALSE
85 INSERT INTO gsheet_tracked_table
86 (table_name,tab_name,created)
88 ('map_circ_policies','Circ Policies',NOW())
91 INSERT INTO gsheet_tracked_column
92 (table_id,column_name)
94 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_org_unit')
95 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_user_group')
96 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_copy_owning')
97 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_user_home_lib')
98 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circ_mod')
99 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_copy_location')
100 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circulate')
101 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circ_limit_set')
102 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_duration_rule')
103 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_fine_rule')
104 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_grace_override')
105 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_max_fine')
106 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_notes')
109 CREATE TABLE map_circ_limit_sets (
118 ,x_owning_lib INTEGER
126 INSERT INTO gsheet_tracked_table
127 (table_name,tab_name,created)
129 ('map_circ_limit_sets','Circ Limit Sets',NOW())
132 INSERT INTO gsheet_tracked_column
133 (table_id,column_name)
135 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_owning_lib')
136 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_name')
137 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_items_out')
138 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_depth')
139 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_global')
140 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_description')
141 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_circ_mod')
142 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_copy_loc')
145 CREATE TABLE map_create_shelving_location (
148 ,l_copy_location TEXT
150 ,l_checkin_alert TEXT
154 ,x_migrate BOOLEAN NOT NULL DEFAULT TRUE
156 ) INHERITS (asset_copy_location);
158 INSERT INTO gsheet_tracked_table
159 (table_name,tab_name,created)
161 ('map_create_shelving_location','New Copy Locations',NOW())
164 INSERT INTO gsheet_tracked_column
165 (table_id,column_name)
167 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_owning_lib')
168 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_copy_location')
169 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_opac_visible')
170 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_checkin_alert')
171 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_holdable')
172 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_circulate')
173 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_note')
176 CREATE TABLE map_create_account (
190 ,x_migrate BOOLEAN NOT NULL DEFAULT TRUE
191 ) INHERITS (actor_usr);
193 INSERT INTO gsheet_tracked_table
194 (table_name,tab_name,created)
196 ('map_create_account','New Accounts',NOW())
199 INSERT INTO gsheet_tracked_column
200 (table_id,column_name)
202 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_usrname')
203 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_first_name')
204 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_family_name')
205 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_email')
206 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_password')
207 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_home_library')
208 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile1')
209 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile2')
210 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile3')
211 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou')
212 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_note')
213 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_note2')
217 CREATE TABLE map_threshold (
220 ,checkout_threshold TEXT
222 ,overdue_threshold TEXT
226 INSERT INTO gsheet_tracked_table
227 (table_name,tab_name,created)
229 ('map_threshold','Patron Thresholds',NOW())
232 INSERT INTO gsheet_tracked_column
233 (table_id,column_name)
235 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'profile')
236 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'checkout_threshold')
237 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'fine_threshold')
238 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'overdue_threshold')
239 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'note')
243 CREATE TABLE map_misc (
252 INSERT INTO gsheet_tracked_table
253 (table_name,tab_name,created)
255 ('map_misc','Miscellaneous Options',NOW())
258 INSERT INTO gsheet_tracked_column
259 (table_id,column_name)
261 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'count')
262 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'option')
263 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'Choice')
264 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'value')
265 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'note')
268 CREATE TABLE map_org_setting (
278 INSERT INTO gsheet_tracked_table
279 (table_name,tab_name,created)
281 ('map_org_setting','Org Settings',NOW())
284 INSERT INTO gsheet_tracked_column
285 (table_id,column_name)
287 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_name')
288 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_label')
289 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_entry_type')
290 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_org_unit')
291 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_value')
292 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_note')
296 CREATE TABLE map_bib_manipulations (
306 INSERT INTO gsheet_tracked_table
307 (table_name,tab_name,created)
309 ('map_bib_manipulations','Bib Records',NOW())
312 INSERT INTO gsheet_tracked_column
313 (table_id,column_name)
315 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'name')
316 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'action')
317 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'field')
318 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'subfield')
319 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'matching_value')
320 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'target_value')
321 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'note')