View | Details | Raw Unified | Return to bug 31503
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_31503.pl (+16 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => 31503,
5
    description => "Adjust patron_consent.type and add AV category",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        $dbh->do(q{
10
ALTER TABLE patron_consent CHANGE COLUMN `type` `type` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'patron consent type; controlled by authorised values';
11
        });
12
        $dbh->do(q{
13
INSERT IGNORE INTO authorised_value_categories (category_name) VALUES ('PATRON_CONSENT');
14
        });
15
    },
16
};
(-)a/installer/data/mysql/mandatory/auth_val_cat.sql (-1 / +1 lines)
Lines 19-24 INSERT IGNORE INTO authorised_value_categories( category_name, is_system ) Link Here
19
    ('PA_CLASS', 0),
19
    ('PA_CLASS', 0),
20
    ('HOLD_CANCELLATION', 0),
20
    ('HOLD_CANCELLATION', 0),
21
    ('ROADTYPE', 0),
21
    ('ROADTYPE', 0),
22
    ('PATRON_CONSENT', 0),
22
    ('AR_CANCELLATION', 0);
23
    ('AR_CANCELLATION', 0);
23
24
24
INSERT IGNORE INTO authorised_value_categories( category_name, is_system )
25
INSERT IGNORE INTO authorised_value_categories( category_name, is_system )
25
- 

Return to bug 31503