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

(-)a/installer/data/mysql/kohastructure.sql (-3 / +8 lines)
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
- 

Return to bug 35657