1 CREATE TABLE map_tlc_branches (
13 INSERT INTO gsheet_tracked_table
14 (table_name,tab_name,created)
16 ('map_tlc_branches','Branches Present in Extract',NOW())
19 INSERT INTO gsheet_tracked_column
20 (table_id,column_name)
22 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'x_count')
23 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'tlc_branch_id')
24 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'tlc_name')
25 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'org_unit')
26 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'note')
27 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'mig_patrons')
28 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'mig_items')
31 -- ############################################
33 CREATE TABLE map_tlc_perm_group (
44 INSERT INTO gsheet_tracked_table
45 (table_name,tab_name,created)
47 ('map_tlc_perm_group','Patron Type',NOW())
50 INSERT INTO gsheet_tracked_column
51 (table_id,column_name)
53 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'x_count')
54 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'legacy_group')
55 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'target_group')
56 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'stat_cat_name')
57 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'stat_cat_entry')
58 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'dmn')
59 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'note')
62 -- ############################################
64 CREATE TABLE map_tlc_patron_expire (
73 INSERT INTO gsheet_tracked_table
74 (table_name,tab_name,created)
76 ('map_tlc_patron_expire','Patrons by Expiration Date',NOW())
79 INSERT INTO gsheet_tracked_column
80 (table_id,column_name)
82 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Expiration Date'),'x_count')
83 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Expiration Date'),'expire_year')
84 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Expiration Date'),'set_to_date')
85 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Expiration Date'),'dnm')
86 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Expiration Date'),'note')
89 -- ############################################
91 CREATE TABLE map_tlc_patron_last_active (
100 INSERT INTO gsheet_tracked_table
101 (table_name,tab_name,created)
103 ('map_tlc_patron_last_active','Patrons by Last Active Date',NOW())
106 INSERT INTO gsheet_tracked_column
107 (table_id,column_name)
109 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Last Active Date'),'x_count')
110 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Last Active Date'),'last_active')
111 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Last Active Date'),'inactive')
112 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Last Active Date'),'dnm')
113 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Last Active Date'),'note')
116 -- ############################################
118 CREATE TABLE map_tlc_billing_type (
127 INSERT INTO gsheet_tracked_table
128 (table_name,tab_name,created)
130 ('map_tlc_billing_type','Migrating Bills by Bill Type',NOW())
133 INSERT INTO gsheet_tracked_column
134 (table_id,column_name)
136 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'x_count')
137 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'tlc_code')
138 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'billing_type')
139 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'dnm')
140 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'note')
143 -- ############################################
145 CREATE TABLE map_tlc_password (
149 ,migrate_available TEXT
154 INSERT INTO gsheet_tracked_table
155 (table_name,tab_name,created)
157 ('map_tlc_password','Patrons w NULL Passwords',NOW())
160 INSERT INTO gsheet_tracked_column
161 (table_id,column_name)
163 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'x_count')
164 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'note')
165 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'migrate_available')
166 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'fill_in_method')
167 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'static_value')
170 -- ############################################
172 CREATE TABLE map_tlc_block_status (
175 ,tlc_block_status TEXT
182 INSERT INTO gsheet_tracked_table
183 (table_name,tab_name,created)
185 ('map_tlc_block_status','Patrons by Block Status',NOW())
188 INSERT INTO gsheet_tracked_column
189 (table_id,column_name)
191 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'x_count')
192 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'tlc_block_status')
193 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'block')
194 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'bar')
195 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'dnm')
196 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'note')
200 -- ############################################
202 CREATE TABLE map_tlc_patron_gender (
214 INSERT INTO gsheet_tracked_table
215 (table_name,tab_name,created)
217 ('map_tlc_patron_gender','Patrons by Gender',NOW())
220 INSERT INTO gsheet_tracked_column
221 (table_id,column_name)
223 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'x_count')
224 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'gender')
225 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'stat_cat')
226 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'stat_cat_entry')
227 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'show')
228 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'required')
229 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'dnm')
230 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'note')
234 -- ############################################
237 CREATE TABLE map_tlc_holding_code (
241 ,shelving_location TEXT
255 INSERT INTO gsheet_tracked_table
256 (table_name,tab_name,created)
258 ('map_tlc_holding_code','Holdings Code',NOW())
261 INSERT INTO gsheet_tracked_column
262 (table_id,column_name)
264 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'x_count')
265 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'holding_code')
266 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'shelving_location')
267 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'org_unit')
268 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'circ_mod')
269 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert')
270 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert_message')
271 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'dnm')
272 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'note')
278 -- ############################################
281 CREATE TABLE map_tlc_stat_cat (
285 ,tlc_stat_cat_value TEXT
295 INSERT INTO gsheet_tracked_table
296 (table_name,tab_name,created)
298 ('map_tlc_stat_cat','Patron Stat Cats',NOW())
301 INSERT INTO gsheet_tracked_column
302 (table_id,column_name)
304 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'x_count')
305 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'tlc_stat_cat')
306 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'tlc_stat_cat_value')
307 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat')
308 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat_entry')
309 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'show')
310 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'required')
311 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'dnm')
312 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'note')
313 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'note2')
317 -- ############################################
319 CREATE TABLE map_tlc_patron_note (
329 INSERT INTO gsheet_tracked_table
330 (table_name,tab_name,created)
332 ('map_tlc_patron_note','Patron Notes',NOW())
335 INSERT INTO gsheet_tracked_column
336 (table_id,column_name)
338 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'x_count')
339 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'note_type')
340 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'subset_values')
341 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'matching_text')
342 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'action')
343 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'note')
346 -- ############################################
348 CREATE TABLE map_tlc_item_note (
358 INSERT INTO gsheet_tracked_table
359 (table_name,tab_name,created)
361 ('map_tlc_item_note','Item Notes',NOW())
364 INSERT INTO gsheet_tracked_column
365 (table_id,column_name)
367 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'x_count')
368 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'note_type')
369 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'subset_values')
370 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'matching_text')
371 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'action')
372 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'note')