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_block_status (
141 ,tlc_block_status TEXT
148 INSERT INTO gsheet_tracked_table
149 (table_name,tab_name,created)
151 ('map_tlc_block_status','Patrons by Block Status',NOW())
154 INSERT INTO gsheet_tracked_column
155 (table_id,column_name)
157 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'x_count')
158 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'tlc_block_status')
159 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'block')
160 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'bar')
161 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'dnm')
162 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'note')
166 -- ############################################
168 CREATE TABLE map_tlc_patron_gender (
180 INSERT INTO gsheet_tracked_table
181 (table_name,tab_name,created)
183 ('map_tlc_patron_gender','Patrons by Gender',NOW())
186 INSERT INTO gsheet_tracked_column
187 (table_id,column_name)
189 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'x_count')
190 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'gender')
191 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'stat_cat')
192 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'stat_cat_entry')
193 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'show')
194 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'required')
195 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'dnm')
196 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'note')
200 -- ############################################
203 CREATE TABLE map_tlc_holding_code (
207 ,shelving_location TEXT
216 INSERT INTO gsheet_tracked_table
217 (table_name,tab_name,created)
219 ('map_tlc_holding_code','Holdings Code',NOW())
222 INSERT INTO gsheet_tracked_column
223 (table_id,column_name)
225 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'x_count')
226 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'holding_code')
227 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'shelving_location')
228 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'org_unit')
229 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'circ_mod')
230 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert')
231 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert_message')
232 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'dnm')
233 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'note')
239 -- ############################################
242 CREATE TABLE map_tlc_stat_cat (
255 INSERT INTO gsheet_tracked_table
256 (table_name,tab_name,created)
258 ('map_tlc_stat_cat','Patron Stat Cats',NOW())
261 INSERT INTO gsheet_tracked_column
262 (table_id,column_name)
264 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'x_count')
265 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'tlc_stat_cat')
266 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat')
267 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat_entry')
268 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'show')
269 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'required')
270 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'dnm')
271 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'note')
272 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'note2')
276 -- ############################################
278 CREATE TABLE map_tlc_patron_note (
288 INSERT INTO gsheet_tracked_table
289 (table_name,tab_name,created)
291 ('map_tlc_patron_note','Patron Notes',NOW())
294 INSERT INTO gsheet_tracked_column
295 (table_id,column_name)
297 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'x_count')
298 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'note_type')
299 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'subset_values')
300 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'matching_text')
301 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'action')
302 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'note')
305 -- ############################################
307 CREATE TABLE map_tlc_item_note (
317 INSERT INTO gsheet_tracked_table
318 (table_name,tab_name,created)
320 ('map_tlc_item_note','Item Notes',NOW())
323 INSERT INTO gsheet_tracked_column
324 (table_id,column_name)
326 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'x_count')
327 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'note_type')
328 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'subset_values')
329 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'matching_text')
330 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'action')
331 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'note')