|
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 |
- |
|
|