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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +6 lines)
Lines 2741-2747 CREATE TABLE `action_logs` ( -- logs of actions taken in Koha (requires that the Link Here
2741
  `object` int(11) default NULL, -- the object that the action was taken against (could be a borrowernumber, itemnumber, etc)
2741
  `object` int(11) default NULL, -- the object that the action was taken against (could be a borrowernumber, itemnumber, etc)
2742
  `info` text, -- information about the action (usually includes SQL statement)
2742
  `info` text, -- information about the action (usually includes SQL statement)
2743
  PRIMARY KEY (`action_id`),
2743
  PRIMARY KEY (`action_id`),
2744
  KEY  (`timestamp`,`user`)
2744
  KEY `timestamp_idx` (`timestamp`),
2745
  KEY `user_idx` (`user`),
2746
  KEY `module_idx` (`module`(255)),
2747
  KEY `action_idx` (`action`(255)),
2748
  KEY `object_idx` (`object`),
2749
  KEY `info_idx` (`info`(255))
2745
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2750
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2746
2751
2747
--
2752
--
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +16 lines)
Lines 7885-7890 if(CheckVersion($DBversion)) { Link Here
7885
    SetVersion($DBversion);
7885
    SetVersion($DBversion);
7886
}
7886
}
7887
7887
7888
$DBversion = "3.15.00.XXX";
7889
if(CheckVersion($DBversion)) {
7890
    $dbh->do(q{
7891
        ALTER TABLE `action_logs`
7892
            DROP KEY timestamp,
7893
            ADD KEY `timestamp_idx` (`timestamp`),
7894
            ADD KEY `user_idx` (`user`),
7895
            ADD KEY `module_idx` (`module`(255)),
7896
            ADD KEY `action_idx` (`action`(255)),
7897
            ADD KEY `object_idx` (`object`),
7898
            ADD KEY `info_idx` (`info`(255))
7899
    });
7900
    print "Upgrade to $DBversion done (Bug 3445: Add indexes to action_logs table)\n";
7901
    SetVersion($DBversion);
7902
}
7903
7888
=head1 FUNCTIONS
7904
=head1 FUNCTIONS
7889
7905
7890
=head2 TableExists($table)
7906
=head2 TableExists($table)
7891
- 

Return to bug 3445