1 CREATE TABLE map_create_shelving_location (
10 ,x_migrate BOOLEAN NOT NULL DEFAULT TRUE
13 ) INHERITS (asset_copy_location);
15 INSERT INTO gsheet_tracked_table
16 (table_name,tab_name,created)
18 ('map_create_shelving_location','New Copy Locations',NOW())
21 INSERT INTO gsheet_tracked_column
22 (table_id,column_name)
24 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_owning_lib')
25 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_copy_location')
26 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_opac_visible')
27 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_checkin_alert')
28 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_holdable')
29 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_circulate')
30 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_note')
33 CREATE TABLE map_create_account (
47 ,x_migrate BOOLEAN NOT NULL DEFAULT TRUE
48 ) INHERITS (actor_usr);
50 INSERT INTO gsheet_tracked_table
51 (table_name,tab_name,created)
53 ('map_create_account','New Accounts',NOW())
56 INSERT INTO gsheet_tracked_column
57 (table_id,column_name)
59 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_usrname')
60 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_first_name')
61 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_family_name')
62 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_email')
63 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_password')
64 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_home_library')
65 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile1')
66 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile2')
67 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile3')
68 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou')
69 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_note')
70 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_note2')
74 CREATE TABLE map_threshold (
77 ,checkout_threshold TEXT
79 ,overdue_threshold TEXT
83 INSERT INTO gsheet_tracked_table
84 (table_name,tab_name,created)
86 ('map_threshold','Patron Thresholds',NOW())
89 INSERT INTO gsheet_tracked_column
90 (table_id,column_name)
92 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'profile')
93 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'checkout_threshold')
94 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'fine_threshold')
95 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'overdue_threshold')
96 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'note')
100 CREATE TABLE map_misc (
109 INSERT INTO gsheet_tracked_table
110 (table_name,tab_name,created)
112 ('map_misc','Miscellaneous Options',NOW())
115 INSERT INTO gsheet_tracked_column
116 (table_id,column_name)
118 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'count')
119 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'option')
120 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'Choice')
121 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'value')
122 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'note')
125 CREATE TABLE map_org_setting (
135 INSERT INTO gsheet_tracked_table
136 (table_name,tab_name,created)
138 ('map_org_setting','Org Settings',NOW())
141 INSERT INTO gsheet_tracked_column
142 (table_id,column_name)
144 ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_name')
145 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_label')
146 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_entry_type')
147 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_org_unit')
148 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_value')
149 ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_note')