1 --Upgrade Script for 2.12.6 to 2.12.7
2 \set eg_version '''2.12.7'''
4 INSERT INTO config.upgrade_log (version, applied_to) VALUES ('2.12.7', :eg_version);
6 SELECT evergreen.upgrade_deps_block_check('1078', :eg_version); -- csharp/bshum/gmcharlt
8 -- The following billing types would not have been automatically added
9 -- in upgrade scripts between versions 1.2 and 1.4 (early 2009). We
10 -- add them here. It's okay if they fail, so this should probably be
11 -- run outside a transaction if added to the version-upgrade scripts.
13 INSERT INTO config.billing_type (id, name, owner)
14 SELECT 7, 'Damaged Item', 1
15 WHERE NOT EXISTS (SELECT 1 FROM config.billing_type WHERE name = 'Damaged Item');
17 INSERT INTO config.billing_type (id, name, owner)
18 SELECT 8, 'Damaged Item Processing Fee', 1
19 WHERE NOT EXISTS (SELECT 1 FROM config.billing_type WHERE name = 'Damaged Item Processing Fee');
21 INSERT INTO config.billing_type (id, name, owner)
22 SELECT 9, 'Notification Fee', 1
23 WHERE NOT EXISTS (SELECT 1 FROM config.billing_type WHERE name = 'Notification Fee');