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
240 INSERT INTO gsheet_tracked_table
241 (table_name,tab_name,created)
243 ('map_tlc_holding_code','Holdings Code',NOW())
246 INSERT INTO gsheet_tracked_column
247 (table_id,column_name)
249 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'x_count')
250 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'holding_code')
251 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'shelving_location')
252 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'circ_mod')
253 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert')
254 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert_message')
255 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'dnm')
256 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'note')
262 -- ############################################
265 CREATE TABLE map_tlc_stat_cat (
278 INSERT INTO gsheet_tracked_table
279 (table_name,tab_name,created)
281 ('map_tlc_stat_cat','Patron Stat Cats',NOW())
284 INSERT INTO gsheet_tracked_column
285 (table_id,column_name)
287 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'x_count')
288 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'tlc_stat_cat')
289 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat')
290 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat_entry')
291 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'show')
292 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'required')
293 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'dnm')
294 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'note')
295 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'note2')
299 -- ############################################
301 CREATE TABLE map_tlc_patron_note (
311 INSERT INTO gsheet_tracked_table
312 (table_name,tab_name,created)
314 ('map_tlc_patron_note','Patron Notes',NOW())
317 INSERT INTO gsheet_tracked_column
318 (table_id,column_name)
320 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'x_count')
321 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'note_type')
322 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'subset_values')
323 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'matching_text')
324 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'action')
325 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'note')
328 -- ############################################
330 CREATE TABLE map_tlc_item_note (
340 INSERT INTO gsheet_tracked_table
341 (table_name,tab_name,created)
343 ('map_tlc_item_note','Item Notes',NOW())
346 INSERT INTO gsheet_tracked_column
347 (table_id,column_name)
349 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'x_count')
350 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'note_type')
351 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'subset_values')
352 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'matching_text')
353 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'action')
354 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'note')