| Lines 2-17
          $DBversion = 'XXX';    # will be replaced by the RM
      
      
        Link Here | 
        
          | 2 | if ( CheckVersion($DBversion) ) { | 2 | if ( CheckVersion($DBversion) ) { | 
        
          | 3 |  | 3 |  | 
        
          | 4 |     $dbh->do(qq{ | 4 |     $dbh->do(qq{ | 
          
            
              | 5 | CREATE TABLE `cash_register_actions` ( | 5 |         CREATE TABLE  IF NOT EXISTS `cash_register_actions` ( | 
            
              | 6 |   `id` int(11) NOT NULL auto_increment, -- unique identifier for each account register action | 6 |           `id` int(11) NOT NULL auto_increment, -- unique identifier for each account register action | 
            
              | 7 |   `code` varchar(24) NOT NULL, -- action code denoting the type of action recorded (enum), | 7 |           `code` varchar(24) NOT NULL, -- action code denoting the type of action recorded (enum), | 
            
              | 8 |   `manager_id` int(11) NOT NULL, -- staff member performing the action | 8 |           `register_id` int(11) NOT NULL, -- id of cash_register this action belongs to, | 
            
              | 9 |   `amount` decimal(28,6) DEFAULT NULL, -- amount recorded in action (signed) | 9 |           `manager_id` int(11) NOT NULL, -- staff member performing the action | 
            
              | 10 |   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, | 10 |           `amount` decimal(28,6) DEFAULT NULL, -- amount recorded in action (signed) | 
            
              | 11 |   PRIMARY KEY (`id`), | 11 |           `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, | 
            
              | 12 |   CONSTRAINT `cash_register_actions_manager` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, | 12 |           PRIMARY KEY (`id`), | 
            
              | 13 |   CONSTRAINT `cash_register_actions_register` FOREIGN KEY (`register_id`) REFERENCES `cash_registers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE | 13 |           CONSTRAINT `cash_register_actions_manager` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, | 
            
              | 14 | ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; | 14 |           CONSTRAINT `cash_register_actions_register` FOREIGN KEY (`register_id`) REFERENCES `cash_registers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE | 
            
              |  |  | 15 |         ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; | 
        
          | 15 |     }); | 16 |     }); | 
        
          | 16 |  | 17 |  | 
        
          | 17 |     SetVersion($DBversion); | 18 |     SetVersion($DBversion); | 
            
              | 18 | -  |  |  |