|
Lines 5734-5739
CREATE TABLE `tags_index` (
Link Here
|
| 5734 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
5734 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 5735 |
/*!40101 SET character_set_client = @saved_cs_client */; |
5735 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 5736 |
|
5736 |
|
|
|
5737 |
-- |
| 5738 |
-- Table structure for table `tickets` |
| 5739 |
-- |
| 5740 |
|
| 5741 |
DROP TABLE IF EXISTS `tickets`; |
| 5742 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 5743 |
/*!40101 SET character_set_client = utf8 */; |
| 5744 |
CREATE TABLE IF NOT EXISTS `tickets` ( |
| 5745 |
`id` int(11) NOT NULL auto_increment COMMENT 'primary key', |
| 5746 |
`reporter_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the patron who reported the ticket', |
| 5747 |
`reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported', |
| 5748 |
`title` text NOT NULL COMMENT 'ticket title', |
| 5749 |
`body` text NOT NULL COMMENT 'ticket details', |
| 5750 |
`resolver_id` int(11) DEFAULT NULL COMMENT 'id of the user who resolved the ticket', |
| 5751 |
`resolved_date` datetime DEFAULT NULL COMMENT 'date and time this ticket was resolved', |
| 5752 |
`biblio_id` int(11) DEFAULT NULL COMMENT 'id of biblio linked', |
| 5753 |
PRIMARY KEY(`id`), |
| 5754 |
CONSTRAINT `tickets_ibfk_1` FOREIGN KEY (`reporter_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 5755 |
CONSTRAINT `tickets_ibfk_2` FOREIGN KEY (`resolver_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 5756 |
CONSTRAINT `tickets_ibfk_3` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
| 5757 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 5758 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 5759 |
|
| 5760 |
-- |
| 5761 |
-- Table structure for table `ticket_updates` |
| 5762 |
-- |
| 5763 |
|
| 5764 |
DROP TABLE IF EXISTS `ticket_updates`; |
| 5765 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 5766 |
/*!40101 SET character_set_client = utf8 */; |
| 5767 |
CREATE TABLE IF NOT EXISTS `ticket_updates` ( |
| 5768 |
`id` int(11) NOT NULL auto_increment COMMENT 'primary key', |
| 5769 |
`ticket_id` int(11) NOT NULL COMMENT 'id of catalog ticket the update relates to', |
| 5770 |
`user_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the user who logged the update', |
| 5771 |
`public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public', |
| 5772 |
`date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged', |
| 5773 |
`message` text NOT NULL COMMENT 'update message content', |
| 5774 |
PRIMARY KEY(`id`), |
| 5775 |
CONSTRAINT `ticket_updates_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 5776 |
CONSTRAINT `ticket_updates_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE |
| 5777 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 5778 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 5779 |
|
| 5737 |
-- |
5780 |
-- |
| 5738 |
-- Table structure for table `tmp_holdsqueue` |
5781 |
-- Table structure for table `tmp_holdsqueue` |
| 5739 |
-- |
5782 |
-- |
| 5740 |
- |
|
|