1 CREATE TABLE map_hold_policies (
13 ,x_migrate BOOLEAN DEFAULT TRUE
14 ) INHERITS (config.hold_matrix_matchpoint);
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_circ_policies (
42 ,l_circ_limit_set TEXT
49 ,l_grace_override TEXT
50 ,l_renewal_boolean TEXT
54 ,x_copy_location INTEGER
58 ,x_fine_interval INTEGER
60 ) INHERITS (config.circ_matrix_matchpoint);
62 INSERT INTO gsheet_tracked_table
63 (table_name,tab_name,created)
65 ('map_circ_policies','Circ Policies',NOW())
68 INSERT INTO gsheet_tracked_column
69 (table_id,column_name)
71 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_org_unit')
72 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_user_group')
73 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circ_mod')
74 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_copy_location')
75 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circulate')
76 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circ_limit_set')
77 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_duration_rule')
78 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_renewals')
79 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_fine')
80 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_fine_interval')
81 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_grace_period')
82 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_max_fine')
83 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_grace_override')
84 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_renewal_boolean')
85 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_notes')
89 CREATE TABLE map_create_shelving_location (
98 ,x_migrate BOOLEAN NOT NULL DEFAULT TRUE
100 ) INHERITS (asset_copy_location);
102 INSERT INTO gsheet_tracked_table
103 (table_name,tab_name,created)
105 ('map_create_shelving_location','New Copy Locations',NOW())
108 INSERT INTO gsheet_tracked_column
109 (table_id,column_name)
111 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_owning_lib')
112 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_copy_location')
113 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_opac_visible')
114 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_checkin_alert')
115 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_holdable')
116 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_circulate')
117 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_note')
120 CREATE TABLE map_create_account (
134 ,x_migrate BOOLEAN NOT NULL DEFAULT TRUE
135 ) INHERITS (actor_usr);
137 INSERT INTO gsheet_tracked_table
138 (table_name,tab_name,created)
140 ('map_create_account','New Accounts',NOW())
143 INSERT INTO gsheet_tracked_column
144 (table_id,column_name)
146 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_usrname')
147 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_first_name')
148 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_family_name')
149 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_email')
150 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_password')
151 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_home_library')
152 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile1')
153 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile2')
154 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile3')
155 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou')
156 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_note')
157 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_note2')
161 CREATE TABLE map_threshold (
164 ,checkout_threshold TEXT
166 ,overdue_threshold TEXT
170 INSERT INTO gsheet_tracked_table
171 (table_name,tab_name,created)
173 ('map_threshold','Patron Thresholds',NOW())
176 INSERT INTO gsheet_tracked_column
177 (table_id,column_name)
179 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'profile')
180 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'checkout_threshold')
181 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'fine_threshold')
182 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'overdue_threshold')
183 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'note')
187 CREATE TABLE map_misc (
196 INSERT INTO gsheet_tracked_table
197 (table_name,tab_name,created)
199 ('map_misc','Miscellaneous Options',NOW())
202 INSERT INTO gsheet_tracked_column
203 (table_id,column_name)
205 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'count')
206 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'option')
207 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'Choice')
208 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'value')
209 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'note')
212 CREATE TABLE map_org_setting (
222 INSERT INTO gsheet_tracked_table
223 (table_name,tab_name,created)
225 ('map_org_setting','Org Settings',NOW())
228 INSERT INTO gsheet_tracked_column
229 (table_id,column_name)
231 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_name')
232 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_label')
233 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_entry_type')
234 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_org_unit')
235 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_value')
236 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_note')
240 CREATE TABLE map_bib_manipulations (
250 INSERT INTO gsheet_tracked_table
251 (table_name,tab_name,created)
253 ('map_bib_manipulations','Bib Records',NOW())
256 INSERT INTO gsheet_tracked_column
257 (table_id,column_name)
259 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'name')
260 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'action')
261 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'field')
262 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'subfield')
263 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'matching_value')
264 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'target_value')
265 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'note')