Attachment #146238 for bug #31028

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




use Modern::Perl;

return {
    bug_number => "31028",
    description => "Add a way to record users concerns about catalog records",
    up => sub {
        my ($args) = @_;
        my ($dbh, $out) = @$args{qw(dbh out)};
        unless ( TableExists('tickets') ) {
            $dbh->do(q{
                CREATE TABLE IF NOT EXISTS `tickets` (
                  `id` int(11) NOT NULL auto_increment COMMENT 'primary key',
                  `reporter_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the patron who reported the ticket',
                  `reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported',
                  `title` text NOT NULL COMMENT 'ticket title',
                  `body` text NOT NULL COMMENT 'ticket details',
                  `resolver_id` int(11) DEFAULT NULL COMMENT 'id of the user who resolved the ticket',
                  `resolved_date` datetime DEFAULT NULL COMMENT 'date and time this ticket was resolved',
                  `biblio_id` int(11) DEFAULT NULL COMMENT 'id of biblio linked',
                  PRIMARY KEY(`id`),
                  CONSTRAINT `tickets_ibfk_1` FOREIGN KEY (`reporter_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
                  CONSTRAINT `tickets_ibfk_2` FOREIGN KEY (`resolver_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
                  CONSTRAINT `tickets_ibfk_3` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
            });

            say $out "Added new table 'tickets'";
        }

        unless ( TableExists('ticket_updates') ) {
            $dbh->do(q{
                CREATE TABLE IF NOT EXISTS `ticket_updates` (
                  `id` int(11) NOT NULL auto_increment COMMENT 'primary key',
                  `ticket_id` int(11) NOT NULL COMMENT 'id of catalog ticket the update relates to',
                  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the user who logged the update',
                  `public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public',
                  `date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged',
                  `message` text NOT NULL COMMENT 'update message content',
                  PRIMARY KEY(`id`),
                  CONSTRAINT `ticket_updates_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
                  CONSTRAINT `ticket_updates_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
            });

            say $out "Added new table 'ticket_updates'";
        }
    }
}




) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tickets`
--

DROP TABLE IF EXISTS `tickets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `tickets` (
  `id` int(11) NOT NULL auto_increment COMMENT 'primary key',
  `reporter_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the patron who reported the ticket',
  `reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported',
  `title` text NOT NULL COMMENT 'ticket title',
  `body` text NOT NULL COMMENT 'ticket details',
  `resolver_id` int(11) DEFAULT NULL COMMENT 'id of the user who resolved the ticket',
  `resolved_date` datetime DEFAULT NULL COMMENT 'date and time this ticket was resolved',
  `biblio_id` int(11) DEFAULT NULL COMMENT 'id of biblio linked',
  PRIMARY KEY(`id`),
  CONSTRAINT `tickets_ibfk_1` FOREIGN KEY (`reporter_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `tickets_ibfk_2` FOREIGN KEY (`resolver_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `tickets_ibfk_3` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ticket_updates`
--

DROP TABLE IF EXISTS `ticket_updates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `ticket_updates` (
  `id` int(11) NOT NULL auto_increment COMMENT 'primary key',
  `ticket_id` int(11) NOT NULL COMMENT 'id of catalog ticket the update relates to',
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the user who logged the update',
  `public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public',
  `date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged',
  `message` text NOT NULL COMMENT 'update message content',
  PRIMARY KEY(`id`),
  CONSTRAINT `ticket_updates_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `ticket_updates_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tmp_holdsqueue`
--
- 

Return to bug 31028

Lines 5734-5739 CREATE TABLE `tags_index` ( Link Here

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

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_31028.pl (+48 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => "31028",
	5	description => "Add a way to record users concerns about catalog records",
	6	up => sub {
	7	my ($args) = @_;
	8	my ($dbh, $out) = @$args{qw(dbh out)};
	9	unless ( TableExists('tickets') ) {
	10	$dbh->do(q{
	11	CREATE TABLE IF NOT EXISTS `tickets` (
	12	`id` int(11) NOT NULL auto_increment COMMENT 'primary key',
	13	`reporter_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the patron who reported the ticket',
	14	`reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported',
	15	`title` text NOT NULL COMMENT 'ticket title',
	16	`body` text NOT NULL COMMENT 'ticket details',
	17	`resolver_id` int(11) DEFAULT NULL COMMENT 'id of the user who resolved the ticket',
	18	`resolved_date` datetime DEFAULT NULL COMMENT 'date and time this ticket was resolved',
	19	`biblio_id` int(11) DEFAULT NULL COMMENT 'id of biblio linked',
	20	PRIMARY KEY(`id`),
	21	CONSTRAINT `tickets_ibfk_1` FOREIGN KEY (`reporter_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
	22	CONSTRAINT `tickets_ibfk_2` FOREIGN KEY (`resolver_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
	23	CONSTRAINT `tickets_ibfk_3` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
	24	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
	25	});
	26
	27	say $out "Added new table 'tickets'";
	28	}
	29
	30	unless ( TableExists('ticket_updates') ) {
	31	$dbh->do(q{
	32	CREATE TABLE IF NOT EXISTS `ticket_updates` (
	33	`id` int(11) NOT NULL auto_increment COMMENT 'primary key',
	34	`ticket_id` int(11) NOT NULL COMMENT 'id of catalog ticket the update relates to',
	35	`user_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the user who logged the update',
	36	`public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public',
	37	`date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged',
	38	`message` text NOT NULL COMMENT 'update message content',
	39	PRIMARY KEY(`id`),
	40	CONSTRAINT `ticket_updates_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
	41	CONSTRAINT `ticket_updates_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
	42	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
	43	});
	44
	45	say $out "Added new table 'ticket_updates'";
	46	}
	47	}
	48	}