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 3944-3951 CREATE TABLE `article_requests` ( Link Here
3944
  `patron_notes` MEDIUMTEXT,
3944
  `patron_notes` MEDIUMTEXT,
3945
  `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING',
3945
  `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING',
3946
  `notes` MEDIUMTEXT,
3946
  `notes` MEDIUMTEXT,
3947
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3947
  `created_on` timestamp NULL DEFAULT NULL, -- Be careful with two timestamps in one table not allowing NULL
3948
  `updated_on` timestamp NULL DEFAULT NULL,
3948
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3949
  PRIMARY KEY (`id`),
3949
  PRIMARY KEY (`id`),
3950
  KEY `borrowernumber` (`borrowernumber`),
3950
  KEY `borrowernumber` (`borrowernumber`),
3951
  KEY `biblionumber` (`biblionumber`),
3951
  KEY `biblionumber` (`biblionumber`),
3952
- 

Return to bug 22273