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 ,migrate_available TEXT
147 INSERT INTO gsheet_tracked_table
148 (table_name,tab_name,created)
150 ('map_tlc_phone','Patron Phone Numbers',NOW())
153 INSERT INTO gsheet_tracked_column
154 (table_id,column_name)
156 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Phone Numbers'),'x_count')
157 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Phone Numbers'),'legacy_phone')
158 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Phone Numbers'),'evergreen_phone')
159 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Phone Numbers'),'note')
162 -- ############################################
164 CREATE TABLE map_tlc_block_status (
167 ,tlc_block_status TEXT
174 INSERT INTO gsheet_tracked_table
175 (table_name,tab_name,created)
177 ('map_tlc_block_status','Patrons by Block Status',NOW())
180 INSERT INTO gsheet_tracked_column
181 (table_id,column_name)
183 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'x_count')
184 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'tlc_block_status')
185 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'block')
186 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'bar')
187 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'dnm')
188 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'note')
192 -- ############################################
194 CREATE TABLE map_tlc_patron_gender (
197 ,tlc_block_status TEXT
204 INSERT INTO gsheet_tracked_table
205 (table_name,tab_name,created)
207 ('map_tlc_patron_gender','Patrons by Gender',NOW())
210 INSERT INTO gsheet_tracked_column
211 (table_id,column_name)
213 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'x_count')
214 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'tlc_block_status')
215 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'block')
216 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'bar')
217 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'dnm')
218 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'note')
222 -- ############################################
225 CREATE TABLE map_tlc_holding_code (
229 ,shelving_location TEXT
237 INSERT INTO gsheet_tracked_table
238 (table_name,tab_name,created)
240 ('map_tlc_holding_code','Holdings Code',NOW())
243 INSERT INTO gsheet_tracked_column
244 (table_id,column_name)
246 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'x_count')
247 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'holding_code')
248 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'shelving_location')
249 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'circ_mod')
250 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert')
251 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert_message')
252 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'dnm')
253 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'note')
259 -- ############################################
262 CREATE TABLE map_tlc_stat_cat (
275 INSERT INTO gsheet_tracked_table
276 (table_name,tab_name,created)
278 ('map_tlc_stat_cat','Patron Stat Cats',NOW())
281 INSERT INTO gsheet_tracked_column
282 (table_id,column_name)
284 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'x_count')
285 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'tlc_stat_cat')
286 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat')
287 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat_entry')
288 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'show')
289 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'required')
290 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'dnm')
291 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'note')
292 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'note2')
296 -- ############################################
298 CREATE TABLE map_tlc_patron_note (
301 ,legacy_mnote_type TEXT
308 INSERT INTO gsheet_tracked_table
309 (table_name,tab_name,created)
311 ('map_tlc_patron_note','Patron Notes',NOW())
314 INSERT INTO gsheet_tracked_column
315 (table_id,column_name)
317 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'x_count')
318 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'note_type')
319 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'subset_values')
320 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'matching_text')
321 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'action')
322 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'note')
325 -- ############################################
327 CREATE TABLE map_tlc_item_note (
337 INSERT INTO gsheet_tracked_table
338 (table_name,tab_name,created)
340 ('map_tlc_item_note','Item Notes',NOW())
343 INSERT INTO gsheet_tracked_column
344 (table_id,column_name)
346 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'x_count')
347 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'note_type')
348 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'subset_values')
349 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'matching_text')
350 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'action')
351 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'note')