Lines 2749-2755
CREATE TABLE `account_offsets` (
Link Here
|
2749 |
DROP TABLE IF EXISTS `action_logs`; |
2749 |
DROP TABLE IF EXISTS `action_logs`; |
2750 |
CREATE TABLE `action_logs` ( -- logs of actions taken in Koha (requires that the logs be turned on) |
2750 |
CREATE TABLE `action_logs` ( -- logs of actions taken in Koha (requires that the logs be turned on) |
2751 |
`action_id` int(11) NOT NULL auto_increment, -- unique identifier for each action |
2751 |
`action_id` int(11) NOT NULL auto_increment, -- unique identifier for each action |
2752 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time the action took place |
2752 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the action took place |
2753 |
`user` int(11) NOT NULL default 0, -- the staff member who performed the action (borrowers.borrowernumber) |
2753 |
`user` int(11) NOT NULL default 0, -- the staff member who performed the action (borrowers.borrowernumber) |
2754 |
`module` MEDIUMTEXT, -- the module this action was taken against |
2754 |
`module` MEDIUMTEXT, -- the module this action was taken against |
2755 |
`action` MEDIUMTEXT, -- the action (includes things like DELETED, ADDED, MODIFY, etc) |
2755 |
`action` MEDIUMTEXT, -- the action (includes things like DELETED, ADDED, MODIFY, etc) |
2756 |
- |
|
|