+++ /dev/null
-CREATE TABLE map_tlc_branches (
- id SERIAL
- ,tlc_branch_id TEXT
- ,tlc_name TEXT
- ,org_unit TEXT
- ,mig_patrons TEXT
- ,mig_items TEXT
- ,note TEXT
- ,x_org_id INTEGER
-
-);
-
-INSERT INTO gsheet_tracked_table
- (table_name,tab_name,created)
-VALUES
- ('map_tlc_branches','Branches Present in Extract',NOW())
-;
-
-INSERT INTO gsheet_tracked_column
- (table_id,column_name)
-VALUES
- ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'x_count')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'tlc_branch_id')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'tlc_name')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'org_unit')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'note')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'mig_patrons')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Branches Present in Extract'),'mig_items')
-;
-
--- ############################################
-
-CREATE TABLE map_tlc_perm_group (
- id SERIAL
- ,x_count TEXT
- ,legacy_group TEXT
- ,target_group TEXT
- ,stat_cat_name TEXT
- ,stat_cat_entry TEXT
- ,dnm TEXT
- ,note TEXT
-);
-
-INSERT INTO gsheet_tracked_table
- (table_name,tab_name,created)
-VALUES
- ('map_tlc_perm_group','Patron Type',NOW())
-;
-
-INSERT INTO gsheet_tracked_column
- (table_id,column_name)
-VALUES
- ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'x_count')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'legacy_group')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'target_group')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'stat_cat_name')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'stat_cat_entry')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'dmn')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Type'),'note')
-;
-
--- ############################################
-
-CREATE TABLE map_tlc_patron_expire (
- id SERIAL
- ,x_count TEXT
- ,expire_year TEXT
- ,set_to_date TEXT
- ,dnm TEXT
- ,note TEXT
-);
-
-INSERT INTO gsheet_tracked_table
- (table_name,tab_name,created)
-VALUES
- ('map_tlc_patron_expire','Patrons by Expiration Date',NOW())
-;
-
-INSERT INTO gsheet_tracked_column
- (table_id,column_name)
-VALUES
- ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Expiration Date'),'x_count')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Expiration Date'),'expire_year')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Expiration Date'),'set_to_date')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Expiration Date'),'dnm')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Expiration Date'),'note')
-;
-
--- ############################################
-
-CREATE TABLE map_tlc_patron_last_active (
- id SERIAL
- ,x_count TEXT
- ,last_active TEXT
- ,inactive TEXT
- ,dnm TEXT
- ,note TEXT
-);
-
-INSERT INTO gsheet_tracked_table
- (table_name,tab_name,created)
-VALUES
- ('map_tlc_patron_last_active','Patrons by Last Active Date',NOW())
-;
-
-INSERT INTO gsheet_tracked_column
- (table_id,column_name)
-VALUES
- ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Last Active Date'),'x_count')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Last Active Date'),'last_active')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Last Active Date'),'inactive')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Last Active Date'),'dnm')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Last Active Date'),'note')
-;
-
--- ############################################
-
-CREATE TABLE map_tlc_billing_type (
- id SERIAL
- ,x_count TEXT
- ,tlc_code TEXT
- ,billing_type TEXT
- ,dnm TEXT
- ,note TEXT
-);
-
-INSERT INTO gsheet_tracked_table
- (table_name,tab_name,created)
-VALUES
- ('map_tlc_billing_type','Migrating Bills by Bill Type',NOW())
-;
-
-INSERT INTO gsheet_tracked_column
- (table_id,column_name)
-VALUES
- ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'x_count')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'tlc_code')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'billing_type')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'dnm')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'note')
-;
-
--- ############################################
-
-CREATE TABLE map_tlc_password (
- id SERIAL
- ,x_count TEXT
- ,note TEXT
- ,migrate_available TEXT
- ,fill_in_method TEXT
- ,static_value TEXT
-);
-
-INSERT INTO gsheet_tracked_table
- (table_name,tab_name,created)
-VALUES
- ('map_tlc_password','Patrons w NULL Passwords',NOW())
-;
-
-INSERT INTO gsheet_tracked_column
- (table_id,column_name)
-VALUES
- ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'x_count')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'note')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'migrate_available')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'fill_in_method')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons w NULL Passwords'),'static_value')
-;
-
--- ############################################
-
-CREATE TABLE map_tlc_block_status (
- id SERIAL
- ,x_count TEXT
- ,tlc_block_status TEXT
- ,block TEXT
- ,bar TEXT
- ,dnm TEXT
- ,note TEXT
-);
-
-INSERT INTO gsheet_tracked_table
- (table_name,tab_name,created)
-VALUES
- ('map_tlc_block_status','Patrons by Block Status',NOW())
-;
-
-INSERT INTO gsheet_tracked_column
- (table_id,column_name)
-VALUES
- ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'x_count')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'tlc_block_status')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'block')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'bar')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'dnm')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Block Status'),'note')
-;
-
-
--- ############################################
-
-CREATE TABLE map_tlc_patron_gender (
- id SERIAL
- ,x_count TEXT
- ,gender TEXT
- ,stat_cat TEXT
- ,stat_cat_entry TEXT
- ,show TEXT
- ,required TEXT
- ,dnm TEXT
- ,note TEXT
-);
-
-INSERT INTO gsheet_tracked_table
- (table_name,tab_name,created)
-VALUES
- ('map_tlc_patron_gender','Patrons by Gender',NOW())
-;
-
-INSERT INTO gsheet_tracked_column
- (table_id,column_name)
-VALUES
- ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'x_count')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'gender')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'stat_cat')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'stat_cat_entry')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'show')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'required')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'dnm')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'note')
-;
-
-
--- ############################################
-
-
-CREATE TABLE map_tlc_holding_code (
- id SERIAL
- ,x_count TEXT
- ,holding_code TEXT
- ,shelving_location TEXT
- ,org_unit TEXT
- ,circ_mod TEXT
- ,alert TEXT
- ,alert_message TEXT
- ,dnm TEXT
- ,note TEXT
- ,reference TEXT
- ,item_status TEXT
- ,stat_cat_title TEXT
- ,stat_cat_entry TEXT
- ,x_migrate TEXT
-);
-
-INSERT INTO gsheet_tracked_table
- (table_name,tab_name,created)
-VALUES
- ('map_tlc_holding_code','Holdings Code',NOW())
-;
-
-INSERT INTO gsheet_tracked_column
- (table_id,column_name)
-VALUES
- ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'x_count')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'holding_code')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'shelving_location')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'org_unit')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'circ_mod')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert_message')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'dnm')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'note')
-;
-
-
-
-
--- ############################################
-
-
-CREATE TABLE map_tlc_stat_cat (
- id SERIAL
- ,x_count TEXT
- ,tlc_stat_cat TEXT
- ,tlc_stat_cat_value TEXT
- ,stat_cat TEXT
- ,stat_cat_entry TEXT
- ,show TEXT
- ,required TEXT
- ,dnm TEXT
- ,note TEXT
- ,note2 TEXT
-);
-
-INSERT INTO gsheet_tracked_table
- (table_name,tab_name,created)
-VALUES
- ('map_tlc_stat_cat','Patron Stat Cats',NOW())
-;
-
-INSERT INTO gsheet_tracked_column
- (table_id,column_name)
-VALUES
- ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'x_count')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'tlc_stat_cat')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'tlc_stat_cat_value')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat_entry')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'show')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'required')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'dnm')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'note')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'note2')
-;
-
-
--- ############################################
-
-CREATE TABLE map_tlc_patron_note (
- id SERIAL
- ,x_count TEXT
- ,note_type TEXT
- ,subset_values TEXT
- ,matching_text TEXT
- ,action TEXT
- ,note TEXT
-);
-
-INSERT INTO gsheet_tracked_table
- (table_name,tab_name,created)
-VALUES
- ('map_tlc_patron_note','Patron Notes',NOW())
-;
-
-INSERT INTO gsheet_tracked_column
- (table_id,column_name)
-VALUES
- ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'x_count')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'note_type')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'subset_values')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'matching_text')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'action')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Notes'),'note')
-;
-
--- ############################################
-
-CREATE TABLE map_tlc_item_note (
- id SERIAL
- ,x_count TEXT
- ,note_type TEXT
- ,subset_values TEXT
- ,matching_text TEXT
- ,action TEXT
- ,note TEXT
-);
-
-INSERT INTO gsheet_tracked_table
- (table_name,tab_name,created)
-VALUES
- ('map_tlc_item_note','Item Notes',NOW())
-;
-
-INSERT INTO gsheet_tracked_column
- (table_id,column_name)
-VALUES
- ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'x_count')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'note_type')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'subset_values')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'matching_text')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'action')
- ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Item Notes'),'note')
-;
-
-
projects / migration-tools.git / blobdiff