|
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 |
-- |