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

(-)a/installer/data/mysql/atomicupdate/bug_20772-add-price_paid_column_to_illrequests.perl (+10 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
4
     if( !column_exists( 'illrequests', 'price_paid' ) ) {
5
        $dbh->do( "ALTER TABLE illrequests ADD COLUMN price_paid varchar(20) DEFAULT NULL" );
6
     }
7
8
    SetVersion( $DBversion );
9
    print "Upgrade to $DBversion done (Bug 20772 - Add illrequest.price_paid column)\n";
10
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 4143-4149 CREATE TABLE illrequests ( Link Here
4143
    completed date DEFAULT NULL,                -- Date the request was completed
4143
    completed date DEFAULT NULL,                -- Date the request was completed
4144
    medium varchar(30) DEFAULT NULL,            -- The Koha request type
4144
    medium varchar(30) DEFAULT NULL,            -- The Koha request type
4145
    accessurl varchar(500) DEFAULT NULL,        -- Potential URL for accessing item
4145
    accessurl varchar(500) DEFAULT NULL,        -- Potential URL for accessing item
4146
    cost varchar(20) DEFAULT NULL,              -- Cost of request
4146
    cost varchar(20) DEFAULT NULL,              -- Quotes cost of request
4147
    price_paid varchar(20) DEFAULT NULL,              -- Final cost of request
4147
    notesopac MEDIUMTEXT DEFAULT NULL,                -- Patron notes attached to request
4148
    notesopac MEDIUMTEXT DEFAULT NULL,                -- Patron notes attached to request
4148
    notesstaff MEDIUMTEXT DEFAULT NULL,               -- Staff notes attached to request
4149
    notesstaff MEDIUMTEXT DEFAULT NULL,               -- Staff notes attached to request
4149
    orderid varchar(50) DEFAULT NULL,           -- Backend id attached to request
4150
    orderid varchar(50) DEFAULT NULL,           -- Backend id attached to request
4150
- 

Return to bug 20772