| 
      
            Lines 2743-2748
          CREATE TABLE `account_offsets` (
      
      
        Link Here
      
     | 
  
        
          | 2743 | 
            CONSTRAINT `account_offsets_ibfk_t` FOREIGN KEY (`type`) REFERENCES `account_offset_types` (`type`) ON DELETE CASCADE ON UPDATE CASCADE  | 
          2743 | 
            CONSTRAINT `account_offsets_ibfk_t` FOREIGN KEY (`type`) REFERENCES `account_offset_types` (`type`) ON DELETE CASCADE ON UPDATE CASCADE  | 
        
        
          | 2744 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
          2744 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
        
        
          | 2745 | 
           | 
          2745 | 
           | 
        
            
               | 
               | 
              2746 | 
              --  | 
            
            
              | 2747 | 
              -- Table structure for table `cash_register_actions`  | 
            
            
              | 2748 | 
              --  | 
            
            
              | 2749 | 
               | 
            
            
              | 2750 | 
              CREATE TABLE `cash_register_actions` (  | 
            
            
              | 2751 | 
                `id` int(11) NOT NULL auto_increment, -- unique identifier for each account register action  | 
            
            
              | 2752 | 
                `code` varchar(24) NOT NULL, -- action code denoting the type of action recorded (enum),  | 
            
            
              | 2753 | 
                `register_id` int(11) NOT NULL, -- id of cash_register this action belongs to,  | 
            
            
              | 2754 | 
                `manager_id` int(11) NOT NULL, -- staff member performing the action  | 
            
            
              | 2755 | 
                `amount` decimal(28,6) DEFAULT NULL, -- amount recorded in action (signed)  | 
            
            
              | 2756 | 
                `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  | 
            
            
              | 2757 | 
                PRIMARY KEY (`id`),  | 
            
            
              | 2758 | 
                CONSTRAINT `cash_register_actions_manager` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,  | 
            
            
              | 2759 | 
                CONSTRAINT `cash_register_actions_register` FOREIGN KEY (`register_id`) REFERENCES `cash_registers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE  | 
            
            
              | 2760 | 
              ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;  | 
            
            
              | 2761 | 
               | 
            
        
          | 2746 | 
          --  | 
          2762 | 
          --  | 
        
        
          | 2747 | 
          -- Table structure for table `action_logs`  | 
          2763 | 
          -- Table structure for table `action_logs`  | 
        
        
          | 2748 | 
          --  | 
          2764 | 
          --  | 
        
            
              | 2749 | 
              -   | 
               | 
               |