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