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 (
196 ,tlc_block_status TEXT
203 INSERT INTO gsheet_tracked_table
204 (table_name,tab_name,created)
206 ('map_tlc_patron_gender','Patrons by Gender',NOW())
209 INSERT INTO gsheet_tracked_column
210 (table_id,column_name)
212 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'x_count')
213 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'tlc_block_status')
214 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'block')
215 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'bar')
216 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'dnm')
217 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'note')
221 -- ############################################
224 CREATE TABLE map_tlc_holding_code (
228 ,shelving_location TEXT
236 INSERT INTO gsheet_tracked_table
237 (table_name,tab_name,created)
239 ('map_tlc_holding_code','Holdings Code',NOW())
242 INSERT INTO gsheet_tracked_column
243 (table_id,column_name)
245 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'x_count')
246 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'holding_code')
247 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'shelving_location')
248 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'circ_mod')
249 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert')
250 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert_message')
251 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'dnm')
252 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'note')
258 -- ############################################
261 CREATE TABLE map_tlc_stat_cat (
274 INSERT INTO gsheet_tracked_table
275 (table_name,tab_name,created)
277 ('map_tlc_stat_cat','Patron Stat Cats',NOW())
280 INSERT INTO gsheet_tracked_column
281 (table_id,column_name)
283 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'x_count')
284 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'tlc_stat_cat')
285 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat')
286 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat_entry')
287 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'show')
288 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'required')
289 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'dnm')
290 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'note')
291 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'note2')
295 -- ############################################
297 CREATE TABLE map_tlc_patron_note (
300 ,legacy_mnote_type TEXT
307 INSERT INTO gsheet_tracked_table
308 (table_name,tab_name,created)
310 ('map_tlc_patron_note','Patron Notes',NOW())
313 INSERT INTO gsheet_tracked_column
314 (table_id,column_name)
316 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'x_count')
317 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'note_type')
318 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'subset_values')
319 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'matching_text')
320 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'action')
321 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'note')
324 -- ############################################
326 CREATE TABLE map_tlc_item_note (
336 INSERT INTO gsheet_tracked_table
337 (table_name,tab_name,created)
339 ('map_tlc_item_note','Item Notes',NOW())
342 INSERT INTO gsheet_tracked_column
343 (table_id,column_name)
345 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'x_count')
346 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'note_type')
347 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'subset_values')
348 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'matching_text')
349 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'action')
350 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'note')