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