Lines 6267-6272
CREATE TABLE `ticket_updates` (
Link Here
|
6267 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
6267 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
6268 |
`ticket_id` int(11) NOT NULL COMMENT 'id of catalog ticket the update relates to', |
6268 |
`ticket_id` int(11) NOT NULL COMMENT 'id of catalog ticket the update relates to', |
6269 |
`user_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the user who logged the update', |
6269 |
`user_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the user who logged the update', |
|
|
6270 |
`assignee_id` int(11) DEFAULT NULL COMMENT 'id of the user who this ticket was assigned to at this update', |
6270 |
`public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public', |
6271 |
`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', |
6272 |
`date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged', |
6272 |
`message` text NOT NULL COMMENT 'update message content', |
6273 |
`message` text NOT NULL COMMENT 'update message content', |
Lines 6274-6281
CREATE TABLE `ticket_updates` (
Link Here
|
6274 |
PRIMARY KEY (`id`), |
6275 |
PRIMARY KEY (`id`), |
6275 |
KEY `ticket_updates_ibfk_1` (`ticket_id`), |
6276 |
KEY `ticket_updates_ibfk_1` (`ticket_id`), |
6276 |
KEY `ticket_updates_ibfk_2` (`user_id`), |
6277 |
KEY `ticket_updates_ibfk_2` (`user_id`), |
|
|
6278 |
KEY `ticket_updates_ibfk_3` (`assignee_id`), |
6277 |
CONSTRAINT `ticket_updates_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
6279 |
CONSTRAINT `ticket_updates_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
6278 |
CONSTRAINT `ticket_updates_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE |
6280 |
CONSTRAINT `ticket_updates_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
|
6281 |
CONSTRAINT `ticket_updates_ibfk_3` FOREIGN KEY (`assignee_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE |
6279 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6282 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6280 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6283 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6281 |
|
6284 |
|
Lines 6293-6298
CREATE TABLE `tickets` (
Link Here
|
6293 |
`title` text NOT NULL COMMENT 'ticket title', |
6296 |
`title` text NOT NULL COMMENT 'ticket title', |
6294 |
`body` text NOT NULL COMMENT 'ticket details', |
6297 |
`body` text NOT NULL COMMENT 'ticket details', |
6295 |
`status` varchar(80) DEFAULT NULL COMMENT 'current status of the ticket', |
6298 |
`status` varchar(80) DEFAULT NULL COMMENT 'current status of the ticket', |
|
|
6299 |
`assignee_id` int(11) DEFAULT NULL COMMENT 'id of the user who this ticket is assigned to', |
6296 |
`resolver_id` int(11) DEFAULT NULL COMMENT 'id of the user who resolved the ticket', |
6300 |
`resolver_id` int(11) DEFAULT NULL COMMENT 'id of the user who resolved the ticket', |
6297 |
`resolved_date` datetime DEFAULT NULL COMMENT 'date and time this ticket was resolved', |
6301 |
`resolved_date` datetime DEFAULT NULL COMMENT 'date and time this ticket was resolved', |
6298 |
`biblio_id` int(11) DEFAULT NULL COMMENT 'id of biblio linked', |
6302 |
`biblio_id` int(11) DEFAULT NULL COMMENT 'id of biblio linked', |
Lines 6300-6308
CREATE TABLE `tickets` (
Link Here
|
6300 |
KEY `tickets_ibfk_1` (`reporter_id`), |
6304 |
KEY `tickets_ibfk_1` (`reporter_id`), |
6301 |
KEY `tickets_ibfk_2` (`resolver_id`), |
6305 |
KEY `tickets_ibfk_2` (`resolver_id`), |
6302 |
KEY `tickets_ibfk_3` (`biblio_id`), |
6306 |
KEY `tickets_ibfk_3` (`biblio_id`), |
|
|
6307 |
KEY `tickets_ibfk_4` (`assignee_id`), |
6303 |
CONSTRAINT `tickets_ibfk_1` FOREIGN KEY (`reporter_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
6308 |
CONSTRAINT `tickets_ibfk_1` FOREIGN KEY (`reporter_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
6304 |
CONSTRAINT `tickets_ibfk_2` FOREIGN KEY (`resolver_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
6309 |
CONSTRAINT `tickets_ibfk_2` FOREIGN KEY (`resolver_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
6305 |
CONSTRAINT `tickets_ibfk_3` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
6310 |
CONSTRAINT `tickets_ibfk_3` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
|
6311 |
CONSTRAINT `tickets_ibfk_4` FOREIGN KEY (`assignee_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE |
6306 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6312 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
6307 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6313 |
/*!40101 SET character_set_client = @saved_cs_client */; |
6308 |
|
6314 |
|
6309 |
- |
|
|