| Lines 5734-5739
          CREATE TABLE `tags_index` (
      
      
        Link Here | 
        
          | 5734 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 5734 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 
        
          | 5735 | /*!40101 SET character_set_client = @saved_cs_client */; | 5735 | /*!40101 SET character_set_client = @saved_cs_client */; | 
        
          | 5736 |  | 5736 |  | 
            
              |  |  | 5737 | -- | 
            
              | 5738 | -- Table structure for table `tickets` | 
            
              | 5739 | -- | 
            
              | 5740 |  | 
            
              | 5741 | DROP TABLE IF EXISTS `tickets`; | 
            
              | 5742 | /*!40101 SET @saved_cs_client     = @@character_set_client */; | 
            
              | 5743 | /*!40101 SET character_set_client = utf8 */; | 
            
              | 5744 | CREATE TABLE IF NOT EXISTS `tickets` ( | 
            
              | 5745 |   `id` int(11) NOT NULL auto_increment COMMENT 'primary key', | 
            
              | 5746 |   `reporter_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the patron who reported the ticket', | 
            
              | 5747 |   `reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported', | 
            
              | 5748 |   `title` text NOT NULL COMMENT 'ticket title', | 
            
              | 5749 |   `body` text NOT NULL COMMENT 'ticket details', | 
            
              | 5750 |   `resolver_id` int(11) DEFAULT NULL COMMENT 'id of the user who resolved the ticket', | 
            
              | 5751 |   `resolved_date` datetime DEFAULT NULL COMMENT 'date and time this ticket was resolved', | 
            
              | 5752 |   `biblio_id` int(11) DEFAULT NULL COMMENT 'id of biblio linked', | 
            
              | 5753 |   PRIMARY KEY(`id`), | 
            
              | 5754 |   CONSTRAINT `tickets_ibfk_1` FOREIGN KEY (`reporter_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, | 
            
              | 5755 |   CONSTRAINT `tickets_ibfk_2` FOREIGN KEY (`resolver_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, | 
            
              | 5756 |   CONSTRAINT `tickets_ibfk_3` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE | 
            
              | 5757 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 
            
              | 5758 | /*!40101 SET character_set_client = @saved_cs_client */; | 
            
              | 5759 |  | 
            
              | 5760 | -- | 
            
              | 5761 | -- Table structure for table `ticket_updates` | 
            
              | 5762 | -- | 
            
              | 5763 |  | 
            
              | 5764 | DROP TABLE IF EXISTS `ticket_updates`; | 
            
              | 5765 | /*!40101 SET @saved_cs_client     = @@character_set_client */; | 
            
              | 5766 | /*!40101 SET character_set_client = utf8 */; | 
            
              | 5767 | CREATE TABLE IF NOT EXISTS `ticket_updates` ( | 
            
              | 5768 |   `id` int(11) NOT NULL auto_increment COMMENT 'primary key', | 
            
              | 5769 |   `ticket_id` int(11) NOT NULL COMMENT 'id of catalog ticket the update relates to', | 
            
              | 5770 |   `user_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the user who logged the update', | 
            
              | 5771 |   `public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public', | 
            
              | 5772 |   `date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged', | 
            
              | 5773 |   `message` text NOT NULL COMMENT 'update message content', | 
            
              | 5774 |   PRIMARY KEY(`id`), | 
            
              | 5775 |   CONSTRAINT `ticket_updates_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, | 
            
              | 5776 |   CONSTRAINT `ticket_updates_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE | 
            
              | 5777 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; | 
            
              | 5778 | /*!40101 SET character_set_client = @saved_cs_client */; | 
            
              | 5779 |  | 
        
          | 5737 | -- | 5780 | -- | 
        
          | 5738 | -- Table structure for table `tmp_holdsqueue` | 5781 | -- Table structure for table `tmp_holdsqueue` | 
        
          | 5739 | -- | 5782 | -- | 
            
              | 5740 | -  |  |  |