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 (
121 INSERT INTO gsheet_tracked_table
122 (table_name,tab_name,created)
124 ('map_tlc_billing_type','Migrating Bills by Bill Type',NOW())
127 INSERT INTO gsheet_tracked_column
128 (table_id,column_name)
130 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'x_count')
131 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'billing_type')
132 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'dnm')
133 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'note')
136 -- ############################################
138 CREATE TABLE map_tlc_password (
142 ,migrate_available TEXT
147 INSERT INTO gsheet_tracked_table
148 (table_name,tab_name,created)
150 ('map_tlc_password','Patrons w NULL Passwords',NOW())
153 INSERT INTO gsheet_tracked_column
154 (table_id,column_name)
156 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'x_count')
157 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'note')
158 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'migrate_available')
159 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'fill_in_method')
160 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'static_value')
163 -- ############################################
165 CREATE TABLE map_tlc_block_status (
168 ,tlc_block_status TEXT
175 INSERT INTO gsheet_tracked_table
176 (table_name,tab_name,created)
178 ('map_tlc_block_status','Patrons by Block Status',NOW())
181 INSERT INTO gsheet_tracked_column
182 (table_id,column_name)
184 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'x_count')
185 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'tlc_block_status')
186 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'block')
187 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'bar')
188 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'dnm')
189 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'note')
193 -- ############################################
195 CREATE TABLE map_tlc_patron_gender (
207 INSERT INTO gsheet_tracked_table
208 (table_name,tab_name,created)
210 ('map_tlc_patron_gender','Patrons by Gender',NOW())
213 INSERT INTO gsheet_tracked_column
214 (table_id,column_name)
216 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'x_count')
217 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'gender')
218 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'stat_cat')
219 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'stat_cat_entry')
220 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'show')
221 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'required')
222 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'dnm')
223 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'note')
227 -- ############################################
230 CREATE TABLE map_tlc_holding_code (
234 ,shelving_location TEXT
243 INSERT INTO gsheet_tracked_table
244 (table_name,tab_name,created)
246 ('map_tlc_holding_code','Holdings Code',NOW())
249 INSERT INTO gsheet_tracked_column
250 (table_id,column_name)
252 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'x_count')
253 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'holding_code')
254 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'shelving_location')
255 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'org_unit')
256 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'circ_mod')
257 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert')
258 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert_message')
259 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'dnm')
260 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'note')
266 -- ############################################
269 CREATE TABLE map_tlc_stat_cat (
273 ,tlc_stat_cat_value TEXT
283 INSERT INTO gsheet_tracked_table
284 (table_name,tab_name,created)
286 ('map_tlc_stat_cat','Patron Stat Cats',NOW())
289 INSERT INTO gsheet_tracked_column
290 (table_id,column_name)
292 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'x_count')
293 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'tlc_stat_cat')
294 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'tlc_stat_cat_value')
295 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat')
296 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat_entry')
297 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'show')
298 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'required')
299 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'dnm')
300 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'note')
301 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'note2')
305 -- ############################################
307 CREATE TABLE map_tlc_patron_note (
317 INSERT INTO gsheet_tracked_table
318 (table_name,tab_name,created)
320 ('map_tlc_patron_note','Patron Notes',NOW())
323 INSERT INTO gsheet_tracked_column
324 (table_id,column_name)
326 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'x_count')
327 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'note_type')
328 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'subset_values')
329 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'matching_text')
330 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'action')
331 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'note')
334 -- ############################################
336 CREATE TABLE map_tlc_item_note (
346 INSERT INTO gsheet_tracked_table
347 (table_name,tab_name,created)
349 ('map_tlc_item_note','Item Notes',NOW())
352 INSERT INTO gsheet_tracked_column
353 (table_id,column_name)
355 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'x_count')
356 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'note_type')
357 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'subset_values')
358 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'matching_text')
359 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'action')
360 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'note')