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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +6 lines)
Lines 2735-2741 CREATE TABLE `action_logs` ( -- logs of actions taken in Koha (requires that the Link Here
2735
  `object` int(11) default NULL, -- the object that the action was taken against (could be a borrowernumber, itemnumber, etc)
2735
  `object` int(11) default NULL, -- the object that the action was taken against (could be a borrowernumber, itemnumber, etc)
2736
  `info` text, -- information about the action (usually includes SQL statement)
2736
  `info` text, -- information about the action (usually includes SQL statement)
2737
  PRIMARY KEY (`action_id`),
2737
  PRIMARY KEY (`action_id`),
2738
  KEY  (`timestamp`,`user`)
2738
  KEY `timestamp_idx` (`timestamp`),
2739
  KEY `user_idx` (`user`),
2740
  KEY `module_idx` (`module`(255)),
2741
  KEY `action_idx` (`action`(255)),
2742
  KEY `object_idx` (`object`),
2743
  KEY `info_idx` (`info`(255))
2739
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2744
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2740
2745
2741
--
2746
--
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +15 lines)
Lines 7750-7755 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
7750
    SetVersion($DBversion);
7750
    SetVersion($DBversion);
7751
}
7751
}
7752
7752
7753
$DBversion = "3.13.00.XXX";
7754
if(CheckVersion($DBversion)) {
7755
    $dbh->do(q{
7756
        ALTER TABLE `action_logs`
7757
            DROP KEY timestamp,
7758
            ADD KEY `timestamp_idx` (`timestamp`),
7759
            ADD KEY `user_idx` (`user`),
7760
            ADD KEY `module_idx` (`module`(255)),
7761
            ADD KEY `action_idx` (`action`(255)),
7762
            ADD KEY `object_idx` (`object`),
7763
            ADD KEY `info_idx` (`info`(255))
7764
    });
7765
    print "Upgrade to $DBversion done (Bug 3445 - action_logs table needs some thought)\n";
7766
    SetVersion($DBversion);
7767
}
7753
7768
7754
=head1 FUNCTIONS
7769
=head1 FUNCTIONS
7755
7770
7756
- 

Return to bug 3445