1 CREATE TABLE map_tlc_perm_group (
12 INSERT INTO gsheet_tracked_table
13 (table_name,tab_name,created)
15 ('map_tlc_perm_group','Patron Type',NOW())
18 INSERT INTO gsheet_tracked_column
19 (table_id,column_name)
21 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'x_count')
22 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'legacy_group')
23 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'target_group')
24 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'stat_cat_name')
25 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'stat_cat_entry')
26 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'dmn')
27 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'note')
30 -- ############################################
32 CREATE TABLE map_tlc_patron_expire (
41 INSERT INTO gsheet_tracked_table
42 (table_name,tab_name,created)
44 ('map_tlc_patron_expire','Patrons by Expiration Date',NOW())
47 INSERT INTO gsheet_tracked_column
48 (table_id,column_name)
50 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Expiration Date'),'x_count')
51 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Expiration Date'),'expire_year')
52 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Expiration Date'),'set_to_date')
53 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Expiration Date'),'dnm')
54 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Expiration Date'),'note')
57 -- ############################################
59 CREATE TABLE map_tlc_patron_last_active (
68 INSERT INTO gsheet_tracked_table
69 (table_name,tab_name,created)
71 ('map_tlc_patron_last_active','Patrons by Last Active 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 Last Active Date'),'x_count')
78 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Last Active Date'),'last_active')
79 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Last Active Date'),'inactive')
80 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Last Active Date'),'dnm')
81 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Last Active Date'),'note')
84 -- ############################################
86 CREATE TABLE map_tlc_billing_type (
94 INSERT INTO gsheet_tracked_table
95 (table_name,tab_name,created)
97 ('map_tlc_billing_type','Migrating Bills by Bill Type',NOW())
100 INSERT INTO gsheet_tracked_column
101 (table_id,column_name)
103 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'x_count')
104 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'billing_type')
105 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'dnm')
106 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'note')
109 -- ############################################
111 CREATE TABLE map_tlc_password (
115 ,migrate_available TEXT
120 INSERT INTO gsheet_tracked_table
121 (table_name,tab_name,created)
123 ('map_tlc_password','Patrons w NULL Passwords',NOW())
126 INSERT INTO gsheet_tracked_column
127 (table_id,column_name)
129 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'x_count')
130 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'note')
131 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'migrate_available')
132 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'fill_in_method')
133 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'static_value')
136 -- ############################################
138 CREATE TABLE map_tlc_phone (
142 ,evergreen_phone TEXT
146 INSERT INTO gsheet_tracked_table
147 (table_name,tab_name,created)
149 ('map_tlc_phone','Patron Phone Numbers',NOW())
152 INSERT INTO gsheet_tracked_column
153 (table_id,column_name)
155 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Phone Numbers'),'x_count')
156 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Phone Numbers'),'legacy_phone')
157 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Phone Numbers'),'evergreen_phone')
158 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Phone Numbers'),'note')
161 -- ############################################
163 CREATE TABLE map_tlc_block_status (
166 ,tlc_block_status TEXT
173 INSERT INTO gsheet_tracked_table
174 (table_name,tab_name,created)
176 ('map_tlc_block_status','Patrons by Block Status',NOW())
179 INSERT INTO gsheet_tracked_column
180 (table_id,column_name)
182 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'x_count')
183 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'tlc_block_status')
184 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'block')
185 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'bar')
186 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'dnm')
187 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'note')
191 -- ############################################
193 CREATE TABLE map_tlc_patron_gender (
205 INSERT INTO gsheet_tracked_table
206 (table_name,tab_name,created)
208 ('map_tlc_patron_gender','Patrons by Gender',NOW())
211 INSERT INTO gsheet_tracked_column
212 (table_id,column_name)
214 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'x_count')
215 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'gender')
216 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'stat_cat')
217 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'stat_cat_entry')
218 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'show')
219 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'required')
220 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'dnm')
221 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'note')
225 -- ############################################
228 CREATE TABLE map_tlc_holding_code (
232 ,shelving_location TEXT
241 INSERT INTO gsheet_tracked_table
242 (table_name,tab_name,created)
244 ('map_tlc_holding_code','Holdings Code',NOW())
247 INSERT INTO gsheet_tracked_column
248 (table_id,column_name)
250 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'x_count')
251 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'holding_code')
252 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'shelving_location')
253 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'org_unit')
254 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'circ_mod')
255 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert')
256 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert_message')
257 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'dnm')
258 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'note')
264 -- ############################################
267 CREATE TABLE map_tlc_stat_cat (
280 INSERT INTO gsheet_tracked_table
281 (table_name,tab_name,created)
283 ('map_tlc_stat_cat','Patron Stat Cats',NOW())
286 INSERT INTO gsheet_tracked_column
287 (table_id,column_name)
289 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'x_count')
290 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'tlc_stat_cat')
291 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat')
292 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat_entry')
293 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'show')
294 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'required')
295 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'dnm')
296 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'note')
297 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'note2')
301 -- ############################################
303 CREATE TABLE map_tlc_patron_note (
313 INSERT INTO gsheet_tracked_table
314 (table_name,tab_name,created)
316 ('map_tlc_patron_note','Patron Notes',NOW())
319 INSERT INTO gsheet_tracked_column
320 (table_id,column_name)
322 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'x_count')
323 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'note_type')
324 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'subset_values')
325 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'matching_text')
326 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'action')
327 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'note')
330 -- ############################################
332 CREATE TABLE map_tlc_item_note (
342 INSERT INTO gsheet_tracked_table
343 (table_name,tab_name,created)
345 ('map_tlc_item_note','Item Notes',NOW())
348 INSERT INTO gsheet_tracked_column
349 (table_id,column_name)
351 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'x_count')
352 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'note_type')
353 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'subset_values')
354 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'matching_text')
355 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'action')
356 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'note')