@@ -, +, @@ --- installer/data/mysql/kohastructure.sql | 16 ++++++++-------- 1 files changed, 8 insertions(+), 8 deletions(-) --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -2504,14 +2504,14 @@ CREATE TABLE `accountoffsets` ( -- DROP TABLE IF EXISTS `action_logs`; -CREATE TABLE `action_logs` ( - `action_id` int(11) NOT NULL auto_increment, - `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, - `user` int(11) NOT NULL default 0, - `module` text, - `action` text, - `object` int(11) default NULL, - `info` text, +CREATE TABLE `action_logs` ( -- logs of actions taken in Koha (requires that the logs be turned on) + `action_id` int(11) NOT NULL auto_increment, -- unique identifier for each action + `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time the action took place + `user` int(11) NOT NULL default 0, -- the staff member who performed the action (borrowers.borrowernumber) + `module` text, -- the module this action was taken against + `action` text, -- the action (includes things like DELETED, ADDED, MODIFY, etc) + `object` int(11) default NULL, -- the object that the action was taken against (could be a borrowernumber, itemnumber, etc) + `info` text, -- information about the action (usually includes SQL statement) PRIMARY KEY (`action_id`), KEY (`timestamp`,`user`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --