1 CREATE TABLE map_tlc_branches (
10 INSERT INTO gsheet_tracked_table
11 (table_name,tab_name,created)
13 ('map_tlc_branches','Branches Present in Extract',NOW())
16 INSERT INTO gsheet_tracked_column
17 (table_id,column_name)
19 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'x_count')
20 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'tlc_branch_id')
21 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'tlc_name')
22 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'org_unit')
23 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'note')
26 -- ############################################
28 CREATE TABLE map_tlc_perm_group (
39 INSERT INTO gsheet_tracked_table
40 (table_name,tab_name,created)
42 ('map_tlc_perm_group','Patron Type',NOW())
45 INSERT INTO gsheet_tracked_column
46 (table_id,column_name)
48 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'x_count')
49 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'legacy_group')
50 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'target_group')
51 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'stat_cat_name')
52 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'stat_cat_entry')
53 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'dmn')
54 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'note')
57 -- ############################################
59 CREATE TABLE map_tlc_patron_expire (
68 INSERT INTO gsheet_tracked_table
69 (table_name,tab_name,created)
71 ('map_tlc_patron_expire','Patrons by Expiration Date',NOW())
74 INSERT INTO gsheet_tracked_column
75 (table_id,column_name)
77 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Expiration Date'),'x_count')
78 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Expiration Date'),'expire_year')
79 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Expiration Date'),'set_to_date')
80 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Expiration Date'),'dnm')
81 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Expiration Date'),'note')
84 -- ############################################
86 CREATE TABLE map_tlc_patron_last_active (
95 INSERT INTO gsheet_tracked_table
96 (table_name,tab_name,created)
98 ('map_tlc_patron_last_active','Patrons by Last Active Date',NOW())
101 INSERT INTO gsheet_tracked_column
102 (table_id,column_name)
104 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Last Active Date'),'x_count')
105 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Last Active Date'),'last_active')
106 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Last Active Date'),'inactive')
107 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Last Active Date'),'dnm')
108 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Last Active Date'),'note')
111 -- ############################################
113 CREATE TABLE map_tlc_billing_type (
122 INSERT INTO gsheet_tracked_table
123 (table_name,tab_name,created)
125 ('map_tlc_billing_type','Migrating Bills by Bill Type',NOW())
128 INSERT INTO gsheet_tracked_column
129 (table_id,column_name)
131 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'x_count')
132 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'tlc_code')
133 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'billing_type')
134 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'dnm')
135 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'note')
138 -- ############################################
140 CREATE TABLE map_tlc_password (
144 ,migrate_available TEXT
149 INSERT INTO gsheet_tracked_table
150 (table_name,tab_name,created)
152 ('map_tlc_password','Patrons w NULL Passwords',NOW())
155 INSERT INTO gsheet_tracked_column
156 (table_id,column_name)
158 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'x_count')
159 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'note')
160 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'migrate_available')
161 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'fill_in_method')
162 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'static_value')
165 -- ############################################
167 CREATE TABLE map_tlc_block_status (
170 ,tlc_block_status TEXT
177 INSERT INTO gsheet_tracked_table
178 (table_name,tab_name,created)
180 ('map_tlc_block_status','Patrons by Block Status',NOW())
183 INSERT INTO gsheet_tracked_column
184 (table_id,column_name)
186 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'x_count')
187 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'tlc_block_status')
188 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'block')
189 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'bar')
190 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'dnm')
191 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'note')
195 -- ############################################
197 CREATE TABLE map_tlc_patron_gender (
209 INSERT INTO gsheet_tracked_table
210 (table_name,tab_name,created)
212 ('map_tlc_patron_gender','Patrons by Gender',NOW())
215 INSERT INTO gsheet_tracked_column
216 (table_id,column_name)
218 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'x_count')
219 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'gender')
220 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'stat_cat')
221 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'stat_cat_entry')
222 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'show')
223 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'required')
224 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'dnm')
225 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'note')
229 -- ############################################
232 CREATE TABLE map_tlc_holding_code (
236 ,shelving_location TEXT
245 INSERT INTO gsheet_tracked_table
246 (table_name,tab_name,created)
248 ('map_tlc_holding_code','Holdings Code',NOW())
251 INSERT INTO gsheet_tracked_column
252 (table_id,column_name)
254 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'x_count')
255 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'holding_code')
256 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'shelving_location')
257 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'org_unit')
258 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'circ_mod')
259 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert')
260 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert_message')
261 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'dnm')
262 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'note')
268 -- ############################################
271 CREATE TABLE map_tlc_stat_cat (
275 ,tlc_stat_cat_value TEXT
285 INSERT INTO gsheet_tracked_table
286 (table_name,tab_name,created)
288 ('map_tlc_stat_cat','Patron Stat Cats',NOW())
291 INSERT INTO gsheet_tracked_column
292 (table_id,column_name)
294 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'x_count')
295 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'tlc_stat_cat')
296 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'tlc_stat_cat_value')
297 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat')
298 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat_entry')
299 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'show')
300 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'required')
301 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'dnm')
302 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'note')
303 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'note2')
307 -- ############################################
309 CREATE TABLE map_tlc_patron_note (
319 INSERT INTO gsheet_tracked_table
320 (table_name,tab_name,created)
322 ('map_tlc_patron_note','Patron Notes',NOW())
325 INSERT INTO gsheet_tracked_column
326 (table_id,column_name)
328 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'x_count')
329 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'note_type')
330 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'subset_values')
331 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'matching_text')
332 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'action')
333 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'note')
336 -- ############################################
338 CREATE TABLE map_tlc_item_note (
348 INSERT INTO gsheet_tracked_table
349 (table_name,tab_name,created)
351 ('map_tlc_item_note','Item Notes',NOW())
354 INSERT INTO gsheet_tracked_column
355 (table_id,column_name)
357 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'x_count')
358 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'note_type')
359 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'subset_values')
360 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'matching_text')
361 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'action')
362 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'note')