View | Details | Raw Unified | Return to bug 22273
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug22273.perl (+8 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do( q|
4
ALTER TABLE article_requests MODIFY COLUMN created_on timestamp NULL, MODIFY COLUMN updated_on timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
5
    |);
6
    SetVersion( $DBversion );
7
    print "Upgrade to $DBversion done (Bug 22273: Column article_requests.created_on should not be updated)\n";
8
}
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 3977-3984 CREATE TABLE `article_requests` ( Link Here
3977
  `patron_notes` MEDIUMTEXT,
3977
  `patron_notes` MEDIUMTEXT,
3978
  `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING',
3978
  `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING',
3979
  `notes` MEDIUMTEXT,
3979
  `notes` MEDIUMTEXT,
3980
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3980
  `created_on` timestamp NULL DEFAULT NULL, -- Be careful with two timestamps in one table not allowing NULL
3981
  `updated_on` timestamp NULL DEFAULT NULL,
3981
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3982
  PRIMARY KEY (`id`),
3982
  PRIMARY KEY (`id`),
3983
  KEY `borrowernumber` (`borrowernumber`),
3983
  KEY `borrowernumber` (`borrowernumber`),
3984
  KEY `biblionumber` (`biblionumber`),
3984
  KEY `biblionumber` (`biblionumber`),
3985
- 

Return to bug 22273