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

(-)a/installer/data/mysql/atomicupdate/bug_31948_tmp_holdsqueue.pl (+13 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "31948",
5
    description => "Add timestamp to tmp_holdsqueue table",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
10
        $dbh->do(q{ALTER TABLE `tmp_holdsqueue` ADD `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP AFTER item_level_request});
11
        say $out "";
12
    },
13
};
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 5382-5387 CREATE TABLE `tmp_holdsqueue` ( Link Here
5382
  `pickbranch` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
5382
  `pickbranch` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
5383
  `notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
5383
  `notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
5384
  `item_level_request` tinyint(4) NOT NULL DEFAULT 0,
5384
  `item_level_request` tinyint(4) NOT NULL DEFAULT 0,
5385
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this entry as added/last updated',
5385
  KEY `tmp_holdsqueue_ibfk_1` (`itemnumber`),
5386
  KEY `tmp_holdsqueue_ibfk_1` (`itemnumber`),
5386
  KEY `tmp_holdsqueue_ibfk_2` (`biblionumber`),
5387
  KEY `tmp_holdsqueue_ibfk_2` (`biblionumber`),
5387
  KEY `tmp_holdsqueue_ibfk_3` (`borrowernumber`),
5388
  KEY `tmp_holdsqueue_ibfk_3` (`borrowernumber`),
5388
- 

Return to bug 31948