@@ -, +, @@ --- .../bug_20772-add-price_paid_column_to_illrequests.perl | 2 +- .../bug_20772-add-readonly-flag-to-illrequestattributes.perl | 2 +- koha-tmpl/intranet-tmpl/prog/en/modules/ill/ill-requests.tt | 10 +++++----- koha-tmpl/opac-tmpl/bootstrap/en/modules/opac-illrequests.tt | 10 +++++++--- 4 files changed, 14 insertions(+), 10 deletions(-) --- 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 @@ -2,7 +2,7 @@ $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" ); + $dbh->do( "ALTER TABLE illrequests ADD COLUMN price_paid varchar(20) DEFAULT NULL AFTER 'cost'" ); } SetVersion( $DBversion ); --- a/installer/data/mysql/atomicupdate/bug_20772-add-readonly-flag-to-illrequestattributes.perl +++ a/installer/data/mysql/atomicupdate/bug_20772-add-readonly-flag-to-illrequestattributes.perl @@ -2,7 +2,7 @@ $DBversion = 'XXX'; # will be replaced by the RM if( CheckVersion( $DBversion ) ) { if( !column_exists( 'illrequestattributes', 'readonly' ) ) { - $dbh->do( "ALTER TABLE illrequestattributes ADD COLUMN readonly tinyint(1) NOT NULL DEFAULT 1" ); + $dbh->do( "ALTER TABLE illrequestattributes ADD COLUMN readonly tinyint(1) NOT NULL DEFAULT 1 AFTER 'value'" ); $dbh->do( "UPDATE illrequestattributes SET readonly = 1" ); } --- a/koha-tmpl/intranet-tmpl/prog/en/modules/ill/ill-requests.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/ill/ill-requests.tt @@ -441,7 +441,7 @@