| 
      
            Lines 1690-1695
          CREATE TABLE `categories_branches` (
      
      
        Link Here
      
     | 
  
        
          | 1690 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
          1690 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
        
        
          | 1691 | 
          /*!40101 SET character_set_client = @saved_cs_client */;  | 
          1691 | 
          /*!40101 SET character_set_client = @saved_cs_client */;  | 
        
        
          | 1692 | 
           | 
          1692 | 
           | 
        
            
               | 
               | 
              1693 | 
              --  | 
            
            
              | 1694 | 
              -- Table structure for table `checkout_renewals`  | 
            
            
              | 1695 | 
              --  | 
            
            
              | 1696 | 
               | 
            
            
              | 1697 | 
              DROP TABLE IF EXISTS `checkout_renewals`;  | 
            
            
              | 1698 | 
              /*!40101 SET @saved_cs_client     = @@character_set_client */;  | 
            
            
              | 1699 | 
              /*!40101 SET character_set_client = utf8 */;  | 
            
            
              | 1700 | 
              CREATE TABLE `checkout_renewals` (  | 
            
            
              | 1701 | 
                `id` int(11) NOT NULL AUTO_INCREMENT,  | 
            
            
              | 1702 | 
                `issue_id` int(11) DEFAULT NULL COMMENT 'the id of the issue this renewal pertains to',  | 
            
            
              | 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',  | 
            
            
              | 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',  | 
            
            
              | 1707 | 
                PRIMARY KEY (`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  | 
            
            
              | 1710 | 
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
            
            
              | 1711 | 
              /*!40101 SET character_set_client = @saved_cs_client */;  | 
            
            
              | 1712 | 
               | 
            
        
          | 1693 | 
          --  | 
          1713 | 
          --  | 
        
        
          | 1694 | 
          -- Table structure for table `circulation_rules`  | 
          1714 | 
          -- Table structure for table `circulation_rules`  | 
        
        
          | 1695 | 
          --  | 
          1715 | 
          --  | 
        
            
              | 1696 | 
              -   | 
               | 
               |