1 CREATE TABLE map_create_shelving_location (
10 ,x_migrate BOOLEAN NOT NULL DEFAULT TRUE
12 ) INHERITS (asset_copy_location);
14 INSERT INTO gsheet_tracked_table
15 (table_name,tab_name,created)
17 ('map_create_shelving_location','New Copy Locations',NOW())
20 INSERT INTO gsheet_tracked_column
21 (table_id,column_name)
23 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_owning_lib')
24 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_copy_location')
25 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_opac_visible')
26 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_checkin_alert')
27 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_holdable')
28 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_circulate')
29 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_note')
32 CREATE TABLE map_create_account (
46 ,x_migrate BOOLEAN NOT NULL DEFAULT TRUE
47 ) INHERITS (actor_usr);
49 INSERT INTO gsheet_tracked_table
50 (table_name,tab_name,created)
52 ('map_create_account','New Accounts',NOW())
55 INSERT INTO gsheet_tracked_column
56 (table_id,column_name)
58 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_usrname')
59 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_first_name')
60 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_family_name')
61 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_email')
62 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_password')
63 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_home_library')
64 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile1')
65 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile2')
66 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile3')
67 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou')
68 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_note')
69 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_note2')
73 CREATE TABLE map_threshold (
76 ,checkout_threshold TEXT
78 ,overdue_threshold TEXT
82 INSERT INTO gsheet_tracked_table
83 (table_name,tab_name,created)
85 ('map_threshold','Patron Thresholds',NOW())
88 INSERT INTO gsheet_tracked_column
89 (table_id,column_name)
91 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'profile')
92 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'checkout_threshold')
93 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'fine_threshold')
94 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'overdue_threshold')
95 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'note')
99 CREATE TABLE map_misc (
108 INSERT INTO gsheet_tracked_table
109 (table_name,tab_name,created)
111 ('map_misc','Miscellaneous Options',NOW())
114 INSERT INTO gsheet_tracked_column
115 (table_id,column_name)
117 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'count')
118 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'option')
119 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'Choice')
120 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'value')
121 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'note')
124 CREATE TABLE map_org_setting (
134 INSERT INTO gsheet_tracked_table
135 (table_name,tab_name,created)
137 ('map_org_setting','Org Settings',NOW())
140 INSERT INTO gsheet_tracked_column
141 (table_id,column_name)
143 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_name')
144 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_label')
145 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_entry_type')
146 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_org_unit')
147 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_value')
148 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_note')
152 CREATE TABLE map_bib_manipulations (
162 INSERT INTO gsheet_tracked_table
163 (table_name,tab_name,created)
165 ('map_bib_manipulations','Bib Records',NOW())
168 INSERT INTO gsheet_tracked_column
169 (table_id,column_name)
171 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'name')
172 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'action')
173 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'field')
174 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'subfield')
175 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'matching_value')
176 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'target_value')
177 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'note')