@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug22273.perl | 8 ++++++++ installer/data/mysql/kohastructure.sql | 4 ++-- 2 files changed, 10 insertions(+), 2 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug22273.perl --- a/installer/data/mysql/atomicupdate/bug22273.perl +++ a/installer/data/mysql/atomicupdate/bug22273.perl @@ -0,0 +1,8 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + $dbh->do( q| +ALTER TABLE article_requests MODIFY COLUMN created_on timestamp NULL, MODIFY COLUMN updated_on timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() + |); + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 22273: Column article_requests.created_on should not be updated)\n"; +} --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -3977,8 +3977,8 @@ CREATE TABLE `article_requests` ( `patron_notes` MEDIUMTEXT, `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING', `notes` MEDIUMTEXT, - `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, - `updated_on` timestamp NULL DEFAULT NULL, + `created_on` timestamp NULL DEFAULT NULL, -- Be careful with two timestamps in one table not allowing NULL + `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `borrowernumber` (`borrowernumber`), KEY `biblionumber` (`biblionumber`), --