$DBversion = 'XXX'; # will be replaced by the RM

if( CheckVersion( $DBversion ) ) {

    # Add authorised value category "CHECKOUT_TYPE"

    $dbh->do( q|

        INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES ('CHECKOUT_TYPE');

    | );

    # Add authorised value "OS" under "CHECKOUT_TYPE" category

    $dbh->do( q|

        INSERT IGNORE INTO authorised_values(category, authorised_value, lib, lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout');

    | );

    # Add authorised value "C" under "CHECKOUT_TYPE" category

    $dbh->do( q|

        INSERT IGNORE INTO authorised_values(category, authorised_value, lib, lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout');

    | );

    # Always end with this (adjust the bug info)

    SetVersion( $DBversion );

    print "Upgrade to $DBversion done (Bug 25037 - Add authorised value for checkout types )\n";

}