| Lines 6270-6275
          CREATE TABLE `ticket_updates` (
      
      
        Link Here | 
        
          | 6270 |   `public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public', | 6270 |   `public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public', | 
        
          | 6271 |   `date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged', | 6271 |   `date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged', | 
        
          | 6272 |   `message` text NOT NULL COMMENT 'update message content', | 6272 |   `message` text NOT NULL COMMENT 'update message content', | 
            
              |  |  | 6273 |   `status` varchar(80) DEFAULT NULL COMMENT 'status of ticket at this update', | 
        
          | 6273 |   PRIMARY KEY (`id`), | 6274 |   PRIMARY KEY (`id`), | 
        
          | 6274 |   KEY `ticket_updates_ibfk_1` (`ticket_id`), | 6275 |   KEY `ticket_updates_ibfk_1` (`ticket_id`), | 
        
          | 6275 |   KEY `ticket_updates_ibfk_2` (`user_id`), | 6276 |   KEY `ticket_updates_ibfk_2` (`user_id`), | 
  
    | Lines 6291-6296
          CREATE TABLE `tickets` (
      
      
        Link Here | 
        
          | 6291 |   `reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported', | 6292 |   `reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported', | 
        
          | 6292 |   `title` text NOT NULL COMMENT 'ticket title', | 6293 |   `title` text NOT NULL COMMENT 'ticket title', | 
        
          | 6293 |   `body` text NOT NULL COMMENT 'ticket details', | 6294 |   `body` text NOT NULL COMMENT 'ticket details', | 
            
              |  |  | 6295 |   `status` varchar(80) DEFAULT NULL COMMENT 'current status of the ticket', | 
        
          | 6294 |   `resolver_id` int(11) DEFAULT NULL COMMENT 'id of the user who resolved the ticket', | 6296 |   `resolver_id` int(11) DEFAULT NULL COMMENT 'id of the user who resolved the ticket', | 
        
          | 6295 |   `resolved_date` datetime DEFAULT NULL COMMENT 'date and time this ticket was resolved', | 6297 |   `resolved_date` datetime DEFAULT NULL COMMENT 'date and time this ticket was resolved', | 
        
          | 6296 |   `biblio_id` int(11) DEFAULT NULL COMMENT 'id of biblio linked', | 6298 |   `biblio_id` int(11) DEFAULT NULL COMMENT 'id of biblio linked', |