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 / +16 lines)
Lines 7778-7783 if(CheckVersion($DBversion)) { Link Here
7778
    SetVersion($DBversion);
7778
    SetVersion($DBversion);
7779
}
7779
}
7780
7780
7781
$DBversion = "3.15.00.XXX";
7782
if(CheckVersion($DBversion)) {
7783
    $dbh->do(q{
7784
        ALTER TABLE `action_logs`
7785
            DROP KEY timestamp,
7786
            ADD KEY `timestamp_idx` (`timestamp`),
7787
            ADD KEY `user_idx` (`user`),
7788
            ADD KEY `module_idx` (`module`(255)),
7789
            ADD KEY `action_idx` (`action`(255)),
7790
            ADD KEY `object_idx` (`object`),
7791
            ADD KEY `info_idx` (`info`(255))
7792
    });
7793
    print "Upgrade to $DBversion done (Bug 3445 - action_logs table needs some thought)\n";
7794
    SetVersion($DBversion);
7795
}
7796
7781
=head1 FUNCTIONS
7797
=head1 FUNCTIONS
7782
7798
7783
=head2 TableExists($table)
7799
=head2 TableExists($table)
7784
- 

Return to bug 3445