1 CREATE TABLE map_hold_policies (
11 ,l_includes_frozen_holds TEXT
12 ,l_distiance_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_distiance_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_create_shelving_location (
112 ,l_copy_location TEXT
114 ,l_checkin_alert TEXT
118 ,x_migrate BOOLEAN NOT NULL DEFAULT TRUE
120 ) INHERITS (asset_copy_location);
122 INSERT INTO gsheet_tracked_table
123 (table_name,tab_name,created)
125 ('map_create_shelving_location','New Copy Locations',NOW())
128 INSERT INTO gsheet_tracked_column
129 (table_id,column_name)
131 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_owning_lib')
132 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_copy_location')
133 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_opac_visible')
134 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_checkin_alert')
135 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_holdable')
136 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_circulate')
137 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_note')
140 CREATE TABLE map_create_account (
154 ,x_migrate BOOLEAN NOT NULL DEFAULT TRUE
155 ) INHERITS (actor_usr);
157 INSERT INTO gsheet_tracked_table
158 (table_name,tab_name,created)
160 ('map_create_account','New Accounts',NOW())
163 INSERT INTO gsheet_tracked_column
164 (table_id,column_name)
166 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_usrname')
167 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_first_name')
168 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_family_name')
169 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_email')
170 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_password')
171 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_home_library')
172 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile1')
173 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile2')
174 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile3')
175 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou')
176 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_note')
177 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_note2')
181 CREATE TABLE map_threshold (
184 ,checkout_threshold TEXT
186 ,overdue_threshold TEXT
190 INSERT INTO gsheet_tracked_table
191 (table_name,tab_name,created)
193 ('map_threshold','Patron Thresholds',NOW())
196 INSERT INTO gsheet_tracked_column
197 (table_id,column_name)
199 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'profile')
200 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'checkout_threshold')
201 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'fine_threshold')
202 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'overdue_threshold')
203 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'note')
207 CREATE TABLE map_misc (
216 INSERT INTO gsheet_tracked_table
217 (table_name,tab_name,created)
219 ('map_misc','Miscellaneous Options',NOW())
222 INSERT INTO gsheet_tracked_column
223 (table_id,column_name)
225 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'count')
226 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'option')
227 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'Choice')
228 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'value')
229 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'note')
232 CREATE TABLE map_org_setting (
242 INSERT INTO gsheet_tracked_table
243 (table_name,tab_name,created)
245 ('map_org_setting','Org Settings',NOW())
248 INSERT INTO gsheet_tracked_column
249 (table_id,column_name)
251 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_name')
252 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_label')
253 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_entry_type')
254 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_org_unit')
255 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_value')
256 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_note')
260 CREATE TABLE map_bib_manipulations (
270 INSERT INTO gsheet_tracked_table
271 (table_name,tab_name,created)
273 ('map_bib_manipulations','Bib Records',NOW())
276 INSERT INTO gsheet_tracked_column
277 (table_id,column_name)
279 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'name')
280 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'action')
281 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'field')
282 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'subfield')
283 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'matching_value')
284 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'target_value')
285 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'note')