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 4128-4134 CREATE TABLE illrequests ( Link Here
4128
    completed date DEFAULT NULL,                -- Date the request was completed
4128
    completed date DEFAULT NULL,                -- Date the request was completed
4129
    medium varchar(30) DEFAULT NULL,            -- The Koha request type
4129
    medium varchar(30) DEFAULT NULL,            -- The Koha request type
4130
    accessurl varchar(500) DEFAULT NULL,        -- Potential URL for accessing item
4130
    accessurl varchar(500) DEFAULT NULL,        -- Potential URL for accessing item
4131
    cost varchar(20) DEFAULT NULL,              -- Cost of request
4131
    cost varchar(20) DEFAULT NULL,              -- Quotes cost of request
4132
    price_paid varchar(20) DEFAULT NULL,              -- Final cost of request
4132
    notesopac MEDIUMTEXT DEFAULT NULL,                -- Patron notes attached to request
4133
    notesopac MEDIUMTEXT DEFAULT NULL,                -- Patron notes attached to request
4133
    notesstaff MEDIUMTEXT DEFAULT NULL,               -- Staff notes attached to request
4134
    notesstaff MEDIUMTEXT DEFAULT NULL,               -- Staff notes attached to request
4134
    orderid varchar(50) DEFAULT NULL,           -- Backend id attached to request
4135
    orderid varchar(50) DEFAULT NULL,           -- Backend id attached to request
4135
- 

Return to bug 20772