| 
      
            Lines 1698-1710
          DROP TABLE IF EXISTS `checkout_renewals`;
      
      
        Link Here
      
     | 
  
        
          | 1698 | 
          /*!40101 SET @saved_cs_client     = @@character_set_client */;  | 
          1698 | 
          /*!40101 SET @saved_cs_client     = @@character_set_client */;  | 
        
        
          | 1699 | 
          /*!40101 SET character_set_client = utf8 */;  | 
          1699 | 
          /*!40101 SET character_set_client = utf8 */;  | 
        
        
          | 1700 | 
          CREATE TABLE `checkout_renewals` (  | 
          1700 | 
          CREATE TABLE `checkout_renewals` (  | 
        
          
            
              | 1701 | 
                `id` int(11) NOT NULL AUTO_INCREMENT,  | 
              1701 | 
                `renewal_id` int(11) NOT NULL AUTO_INCREMENT,  | 
            
            
              | 1702 | 
                `issue_id` int(11) DEFAULT NULL COMMENT 'the id of the issue this renewal pertains to',  | 
              1702 | 
                `checkout_id` int(11) DEFAULT NULL COMMENT 'the id of the checkout this renewal pertains to',  | 
            
        
          | 1703 | 
            `renewer_id` int(11) DEFAULT NULL COMMENT 'the id of the user who processed the renewal',  | 
          1703 | 
            `renewer_id` int(11) DEFAULT NULL COMMENT 'the id of the user who processed the renewal',  | 
        
        
          | 1704 | 
            `seen` tinyint(1) DEFAULT 0 COMMENT 'boolean denoting whether the item was present or not',  | 
          1704 | 
            `seen` tinyint(1) DEFAULT 0 COMMENT 'boolean denoting whether the item was present or not',  | 
        
        
          | 1705 | 
            `interface` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the interface this renewal took place on',  | 
          1705 | 
            `interface` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the interface this renewal took place on',  | 
        
        
          | 1706 | 
            `timestamp` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'the date and time the renewal took place',  | 
          1706 | 
            `timestamp` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'the date and time the renewal took place',  | 
        
          
            
              | 1707 | 
                PRIMARY KEY (`id`),  | 
              1707 | 
                PRIMARY KEY (`renewal_id`),  | 
            
        
          | 1708 | 
            KEY `renewer_id` (`renewer_id`),  | 
          1708 | 
            KEY `renewer_id` (`renewer_id`),  | 
        
        
          | 1709 | 
            CONSTRAINT `renewals_renewer_id` FOREIGN KEY (`renewer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE  | 
          1709 | 
            CONSTRAINT `renewals_renewer_id` FOREIGN KEY (`renewer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE  | 
        
        
          | 1710 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
          1710 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
        
            
              | 1711 | 
              -   | 
               | 
               |