Lines 2504-2517
CREATE TABLE `accountoffsets` (
Link Here
|
2504 |
-- |
2504 |
-- |
2505 |
|
2505 |
|
2506 |
DROP TABLE IF EXISTS `action_logs`; |
2506 |
DROP TABLE IF EXISTS `action_logs`; |
2507 |
CREATE TABLE `action_logs` ( |
2507 |
CREATE TABLE `action_logs` ( -- logs of actions taken in Koha (requires that the logs be turned on) |
2508 |
`action_id` int(11) NOT NULL auto_increment, |
2508 |
`action_id` int(11) NOT NULL auto_increment, -- unique identifier for each action |
2509 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
2509 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time the action took place |
2510 |
`user` int(11) NOT NULL default 0, |
2510 |
`user` int(11) NOT NULL default 0, -- the staff member who performed the action (borrowers.borrowernumber) |
2511 |
`module` text, |
2511 |
`module` text, -- the module this action was taken against |
2512 |
`action` text, |
2512 |
`action` text, -- the action (includes things like DELETED, ADDED, MODIFY, etc) |
2513 |
`object` int(11) default NULL, |
2513 |
`object` int(11) default NULL, -- the object that the action was taken against (could be a borrowernumber, itemnumber, etc) |
2514 |
`info` text, |
2514 |
`info` text, -- information about the action (usually includes SQL statement) |
2515 |
PRIMARY KEY (`action_id`), |
2515 |
PRIMARY KEY (`action_id`), |
2516 |
KEY (`timestamp`,`user`) |
2516 |
KEY (`timestamp`,`user`) |
2517 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2517 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2518 |
- |
|
|