View | Details | Raw Unified | Return to bug 35657
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-3 / +8 lines)
Lines 6284-6289 CREATE TABLE `ticket_updates` ( Link Here
6284
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key',
6284
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key',
6285
  `ticket_id` int(11) NOT NULL COMMENT 'id of catalog ticket the update relates to',
6285
  `ticket_id` int(11) NOT NULL COMMENT 'id of catalog ticket the update relates to',
6286
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the user who logged the update',
6286
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the user who logged the update',
6287
  `assignee_id` int(11) DEFAULT NULL COMMENT 'id of the user who this ticket was assigned to at this update',
6287
  `public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public',
6288
  `public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public',
6288
  `date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged',
6289
  `date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged',
6289
  `message` text NOT NULL COMMENT 'update message content',
6290
  `message` text NOT NULL COMMENT 'update message content',
Lines 6291-6298 CREATE TABLE `ticket_updates` ( Link Here
6291
  PRIMARY KEY (`id`),
6292
  PRIMARY KEY (`id`),
6292
  KEY `ticket_updates_ibfk_1` (`ticket_id`),
6293
  KEY `ticket_updates_ibfk_1` (`ticket_id`),
6293
  KEY `ticket_updates_ibfk_2` (`user_id`),
6294
  KEY `ticket_updates_ibfk_2` (`user_id`),
6295
  KEY `ticket_updates_ibfk_3` (`assignee_id`),
6294
  CONSTRAINT `ticket_updates_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
6296
  CONSTRAINT `ticket_updates_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
6295
  CONSTRAINT `ticket_updates_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
6297
  CONSTRAINT `ticket_updates_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
6298
  CONSTRAINT `ticket_updates_ibfk_3` FOREIGN KEY (`assignee_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
6296
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6299
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6297
/*!40101 SET character_set_client = @saved_cs_client */;
6300
/*!40101 SET character_set_client = @saved_cs_client */;
6298
6301
Lines 6310-6315 CREATE TABLE `tickets` ( Link Here
6310
  `title` text NOT NULL COMMENT 'ticket title',
6313
  `title` text NOT NULL COMMENT 'ticket title',
6311
  `body` text NOT NULL COMMENT 'ticket details',
6314
  `body` text NOT NULL COMMENT 'ticket details',
6312
  `status` varchar(80) DEFAULT NULL COMMENT 'current status of the ticket',
6315
  `status` varchar(80) DEFAULT NULL COMMENT 'current status of the ticket',
6316
  `assignee_id` int(11) DEFAULT NULL COMMENT 'id of the user who this ticket is assigned to',
6313
  `resolver_id` int(11) DEFAULT NULL COMMENT 'id of the user who resolved the ticket',
6317
  `resolver_id` int(11) DEFAULT NULL COMMENT 'id of the user who resolved the ticket',
6314
  `resolved_date` datetime DEFAULT NULL COMMENT 'date and time this ticket was resolved',
6318
  `resolved_date` datetime DEFAULT NULL COMMENT 'date and time this ticket was resolved',
6315
  `biblio_id` int(11) DEFAULT NULL COMMENT 'id of biblio linked',
6319
  `biblio_id` int(11) DEFAULT NULL COMMENT 'id of biblio linked',
Lines 6317-6325 CREATE TABLE `tickets` ( Link Here
6317
  KEY `tickets_ibfk_1` (`reporter_id`),
6321
  KEY `tickets_ibfk_1` (`reporter_id`),
6318
  KEY `tickets_ibfk_2` (`resolver_id`),
6322
  KEY `tickets_ibfk_2` (`resolver_id`),
6319
  KEY `tickets_ibfk_3` (`biblio_id`),
6323
  KEY `tickets_ibfk_3` (`biblio_id`),
6324
  KEY `tickets_ibfk_4` (`assignee_id`),
6320
  CONSTRAINT `tickets_ibfk_1` FOREIGN KEY (`reporter_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
6325
  CONSTRAINT `tickets_ibfk_1` FOREIGN KEY (`reporter_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
6321
  CONSTRAINT `tickets_ibfk_2` FOREIGN KEY (`resolver_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
6326
  CONSTRAINT `tickets_ibfk_2` FOREIGN KEY (`resolver_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
6322
  CONSTRAINT `tickets_ibfk_3` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
6327
  CONSTRAINT `tickets_ibfk_3` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
6328
  CONSTRAINT `tickets_ibfk_4` FOREIGN KEY (`assignee_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
6323
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6329
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6324
/*!40101 SET character_set_client = @saved_cs_client */;
6330
/*!40101 SET character_set_client = @saved_cs_client */;
6325
6331
6326
- 

Return to bug 35657