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
250 INSERT INTO gsheet_tracked_table
251 (table_name,tab_name,created)
253 ('map_tlc_holding_code','Holdings Code',NOW())
256 INSERT INTO gsheet_tracked_column
257 (table_id,column_name)
259 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'x_count')
260 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'holding_code')
261 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'shelving_location')
262 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'org_unit')
263 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'circ_mod')
264 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert')
265 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert_message')
266 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'dnm')
267 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'note')
273 -- ############################################
276 CREATE TABLE map_tlc_stat_cat (
280 ,tlc_stat_cat_value TEXT
290 INSERT INTO gsheet_tracked_table
291 (table_name,tab_name,created)
293 ('map_tlc_stat_cat','Patron Stat Cats',NOW())
296 INSERT INTO gsheet_tracked_column
297 (table_id,column_name)
299 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'x_count')
300 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'tlc_stat_cat')
301 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'tlc_stat_cat_value')
302 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat')
303 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat_entry')
304 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'show')
305 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'required')
306 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'dnm')
307 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'note')
308 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'note2')
312 -- ############################################
314 CREATE TABLE map_tlc_patron_note (
324 INSERT INTO gsheet_tracked_table
325 (table_name,tab_name,created)
327 ('map_tlc_patron_note','Patron Notes',NOW())
330 INSERT INTO gsheet_tracked_column
331 (table_id,column_name)
333 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'x_count')
334 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'note_type')
335 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'subset_values')
336 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'matching_text')
337 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'action')
338 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'note')
341 -- ############################################
343 CREATE TABLE map_tlc_item_note (
353 INSERT INTO gsheet_tracked_table
354 (table_name,tab_name,created)
356 ('map_tlc_item_note','Item Notes',NOW())
359 INSERT INTO gsheet_tracked_column
360 (table_id,column_name)
362 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'x_count')
363 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'note_type')
364 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'subset_values')
365 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'matching_text')
366 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'action')
367 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'note')