View | Details | Raw Unified | Return to bug 6716
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-9 / +8 lines)
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
- 

Return to bug 6716