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
107 ,x_user_group INTEGER
108 ,x_copy_owning_lib INTEGER
109 ,x_user_home_lib INTEGER
111 ,x_copy_location INTEGER
113 ,x_circ_limit_set INTEGER
114 ,x_duration_rule INTEGER
116 ,x_grace_override INTERVAL
118 ,x_migrate BOOLEAN DEFAULT FALSE
121 INSERT INTO gsheet_tracked_table
122 (table_name,tab_name,created)
124 ('map_circ_policies','Circ Policies',NOW())
127 INSERT INTO gsheet_tracked_column
128 (table_id,column_name)
130 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_org_unit')
131 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_user_group')
132 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_copy_owning')
133 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_user_home_lib')
134 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circ_mod')
135 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_copy_location')
136 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circulate')
137 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circ_limit_set')
138 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_duration_rule')
139 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_fine_rule')
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_max_fine')
142 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_notes')
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')