From 1631e71bc654085574f0dba8b147124d1b701ac4 Mon Sep 17 00:00:00 2001 From: Nicole C. Engard Date: Wed, 11 Jul 2012 23:24:50 -0400 Subject: [PATCH] Bug 6716: Document action_logs table --- installer/data/mysql/kohastructure.sql | 16 ++++++++-------- 1 files changed, 8 insertions(+), 8 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 3b9827a..fa16e37 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/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; -- 1.7.2.3