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

(-)a/installer/data/mysql/kohastructure.sql (-3 / +8 lines)
Lines 6306-6311 CREATE TABLE `ticket_updates` ( Link Here
6306
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key',
6306
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key',
6307
  `ticket_id` int(11) NOT NULL COMMENT 'id of catalog ticket the update relates to',
6307
  `ticket_id` int(11) NOT NULL COMMENT 'id of catalog ticket the update relates to',
6308
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the user who logged the update',
6308
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the user who logged the update',
6309
  `assignee_id` int(11) DEFAULT NULL COMMENT 'id of the user who this ticket was assigned to at this update',
6309
  `public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public',
6310
  `public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public',
6310
  `date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged',
6311
  `date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged',
6311
  `message` text NOT NULL COMMENT 'update message content',
6312
  `message` text NOT NULL COMMENT 'update message content',
Lines 6313-6320 CREATE TABLE `ticket_updates` ( Link Here
6313
  PRIMARY KEY (`id`),
6314
  PRIMARY KEY (`id`),
6314
  KEY `ticket_updates_ibfk_1` (`ticket_id`),
6315
  KEY `ticket_updates_ibfk_1` (`ticket_id`),
6315
  KEY `ticket_updates_ibfk_2` (`user_id`),
6316
  KEY `ticket_updates_ibfk_2` (`user_id`),
6317
  KEY `ticket_updates_ibfk_3` (`assignee_id`),
6316
  CONSTRAINT `ticket_updates_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
6318
  CONSTRAINT `ticket_updates_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
6317
  CONSTRAINT `ticket_updates_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
6319
  CONSTRAINT `ticket_updates_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
6320
  CONSTRAINT `ticket_updates_ibfk_3` FOREIGN KEY (`assignee_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
6318
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6321
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6319
/*!40101 SET character_set_client = @saved_cs_client */;
6322
/*!40101 SET character_set_client = @saved_cs_client */;
6320
6323
Lines 6333-6338 CREATE TABLE `tickets` ( Link Here
6333
  `title` text NOT NULL COMMENT 'ticket title',
6336
  `title` text NOT NULL COMMENT 'ticket title',
6334
  `body` text NOT NULL COMMENT 'ticket details',
6337
  `body` text NOT NULL COMMENT 'ticket details',
6335
  `status` varchar(80) DEFAULT NULL COMMENT 'current status of the ticket',
6338
  `status` varchar(80) DEFAULT NULL COMMENT 'current status of the ticket',
6339
  `assignee_id` int(11) DEFAULT NULL COMMENT 'id of the user who this ticket is assigned to',
6336
  `resolver_id` int(11) DEFAULT NULL COMMENT 'id of the user who resolved the ticket',
6340
  `resolver_id` int(11) DEFAULT NULL COMMENT 'id of the user who resolved the ticket',
6337
  `resolved_date` datetime DEFAULT NULL COMMENT 'date and time this ticket was resolved',
6341
  `resolved_date` datetime DEFAULT NULL COMMENT 'date and time this ticket was resolved',
6338
  `biblio_id` int(11) DEFAULT NULL COMMENT 'id of biblio linked',
6342
  `biblio_id` int(11) DEFAULT NULL COMMENT 'id of biblio linked',
Lines 6340-6348 CREATE TABLE `tickets` ( Link Here
6340
  KEY `tickets_ibfk_1` (`reporter_id`),
6344
  KEY `tickets_ibfk_1` (`reporter_id`),
6341
  KEY `tickets_ibfk_2` (`resolver_id`),
6345
  KEY `tickets_ibfk_2` (`resolver_id`),
6342
  KEY `tickets_ibfk_3` (`biblio_id`),
6346
  KEY `tickets_ibfk_3` (`biblio_id`),
6347
  KEY `tickets_ibfk_4` (`assignee_id`),
6343
  CONSTRAINT `tickets_ibfk_1` FOREIGN KEY (`reporter_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
6348
  CONSTRAINT `tickets_ibfk_1` FOREIGN KEY (`reporter_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
6344
  CONSTRAINT `tickets_ibfk_2` FOREIGN KEY (`resolver_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
6349
  CONSTRAINT `tickets_ibfk_2` FOREIGN KEY (`resolver_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
6345
  CONSTRAINT `tickets_ibfk_3` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
6350
  CONSTRAINT `tickets_ibfk_3` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
6351
  CONSTRAINT `tickets_ibfk_4` FOREIGN KEY (`assignee_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
6346
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6352
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6347
/*!40101 SET character_set_client = @saved_cs_client */;
6353
/*!40101 SET character_set_client = @saved_cs_client */;
6348
6354
6349
- 

Return to bug 35657