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