Lines 2533-2539
CREATE TABLE `accountoffsets` (
Link Here
|
2533 |
DROP TABLE IF EXISTS `action_logs`; |
2533 |
DROP TABLE IF EXISTS `action_logs`; |
2534 |
CREATE TABLE `action_logs` ( -- logs of actions taken in Koha (requires that the logs be turned on) |
2534 |
CREATE TABLE `action_logs` ( -- logs of actions taken in Koha (requires that the logs be turned on) |
2535 |
`action_id` int(11) NOT NULL auto_increment, -- unique identifier for each action |
2535 |
`action_id` int(11) NOT NULL auto_increment, -- unique identifier for each action |
2536 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time the action took place |
2536 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the action took place |
2537 |
`user` int(11) NOT NULL default 0, -- the staff member who performed the action (borrowers.borrowernumber) |
2537 |
`user` int(11) NOT NULL default 0, -- the staff member who performed the action (borrowers.borrowernumber) |
2538 |
`module` text, -- the module this action was taken against |
2538 |
`module` text, -- the module this action was taken against |
2539 |
`action` text, -- the action (includes things like DELETED, ADDED, MODIFY, etc) |
2539 |
`action` text, -- the action (includes things like DELETED, ADDED, MODIFY, etc) |