| 
      
            Lines 1681-1686
          CREATE TABLE `categories_branches` (
      
      
        Link Here
      
     | 
  
        
          | 1681 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
          1681 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
        
        
          | 1682 | 
          /*!40101 SET character_set_client = @saved_cs_client */;  | 
          1682 | 
          /*!40101 SET character_set_client = @saved_cs_client */;  | 
        
        
          | 1683 | 
           | 
          1683 | 
           | 
        
            
               | 
               | 
              1684 | 
              --  | 
            
            
              | 1685 | 
              -- Table structure for table `checkout_renewals`  | 
            
            
              | 1686 | 
              --  | 
            
            
              | 1687 | 
               | 
            
            
              | 1688 | 
              DROP TABLE IF EXISTS `checkout_renewals`;  | 
            
            
              | 1689 | 
              /*!40101 SET @saved_cs_client     = @@character_set_client */;  | 
            
            
              | 1690 | 
              /*!40101 SET character_set_client = utf8 */;  | 
            
            
              | 1691 | 
              CREATE TABLE `checkout_renewals` (  | 
            
            
              | 1692 | 
                `id` int(11) NOT NULL AUTO_INCREMENT,  | 
            
            
              | 1693 | 
                `issue_id` int(11) DEFAULT NULL COMMENT 'the id of the issue this renewal pertains to',  | 
            
            
              | 1694 | 
                `renewer_id` int(11) DEFAULT NULL COMMENT 'the id of the user who processed the renewal',  | 
            
            
              | 1695 | 
                `seen` tinyint(1) DEFAULT 0 COMMENT 'boolean denoting whether the item was present or not',  | 
            
            
              | 1696 | 
                `interface` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the interface this renewal took place on',  | 
            
            
              | 1697 | 
                `timestamp` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'the date and time the renewal took place',  | 
            
            
              | 1698 | 
                PRIMARY KEY (`id`),  | 
            
            
              | 1699 | 
                KEY `renewer_id` (`renewer_id`),  | 
            
            
              | 1700 | 
                CONSTRAINT `renewals_renewer_id` FOREIGN KEY (`renewer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE  | 
            
            
              | 1701 | 
              ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
            
            
              | 1702 | 
              /*!40101 SET character_set_client = @saved_cs_client */;  | 
            
            
              | 1703 | 
               | 
            
        
          | 1684 | 
          --  | 
          1704 | 
          --  | 
        
        
          | 1685 | 
          -- Table structure for table `circulation_rules`  | 
          1705 | 
          -- Table structure for table `circulation_rules`  | 
        
        
          | 1686 | 
          --  | 
          1706 | 
          --  | 
        
            
              | 1687 | 
              -   | 
               | 
               |