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

(-)a/installer/data/mysql/en/optional/auth_val.sql (-2 / +2 lines)
Lines 72-77 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED Link Here
72
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Book with audio tape');
72
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Book with audio tape');
73
73
74
-- order cancellation reasons
74
-- order cancellation reasons
75
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason');
75
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided');
76
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Sold out');
76
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock');
77
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking');
77
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking');
(-)a/installer/data/mysql/updatedatabase.pl (-3 / +2 lines)
Lines 9763-9770 $DBversion = "3.19.00.XXX"; Link Here
9763
if(CheckVersion($DBversion)) {
9763
if(CheckVersion($DBversion)) {
9764
    $dbh->do(q{
9764
    $dbh->do(q{
9765
        INSERT INTO authorised_values (category, authorised_value, lib) VALUES
9765
        INSERT INTO authorised_values (category, authorised_value, lib) VALUES
9766
         ('ORDER_CANCELLATION_REASON', 0, 'No reason'),
9766
         ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'),
9767
         ('ORDER_CANCELLATION_REASON', 1, 'Sold out'),
9767
         ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'),
9768
         ('ORDER_CANCELLATION_REASON', 2, 'Restocking')
9768
         ('ORDER_CANCELLATION_REASON', 2, 'Restocking')
9769
    });
9769
    });
9770
9770
9771
- 

Return to bug 13380