@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_21066.perl | 17 ++++++++++++----- 1 file changed, 12 insertions(+), 5 deletions(-) --- a/installer/data/mysql/atomicupdate/bug_21066.perl +++ a/installer/data/mysql/atomicupdate/bug_21066.perl @@ -1,9 +1,16 @@ $DBversion = 'XXX'; # will be replaced by the RM if( CheckVersion( $DBversion ) ) { - $dbh->do(q| - ALTER TABLE opac_news - CHANGE COLUMN timestamp publicationdate date DEFAULT NULL, - ADD COLUMN updated_on timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP - |); + if( column_exists( 'opac_news', 'timestamp' ) ) { + $dbh->do(q| + ALTER TABLE opac_news + CHANGE COLUMN timestamp publicationdate date DEFAULT NULL + |); + } + if( !column_exists( 'opac_news', 'updated_on' ) ) { + $dbh->do(q| + ALTER TABLE opac_news + ADD COLUMN updated_on timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER publicationdate + |); + } NewVersion( $DBversion, 21066, "Update table opac_news"); } --