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