Attachment #143470 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 5626-5631 CREATE TABLE `tags_index` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +43 lines)
5626	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;	5626	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5627	/!40101 SET character_set_client = @saved_cs_client /;	5627	/!40101 SET character_set_client = @saved_cs_client /;
5628		5628
		5629	--
		5630	-- Table structure for table `tickets`
		5631	--
		5632
		5633	DROP TABLE IF EXISTS `tickets`;
		5634	/!40101 SET @saved_cs_client = @@character_set_client /;
		5635	/!40101 SET character_set_client = utf8 /;
		5636	CREATE TABLE IF NOT EXISTS `tickets` (
		5637	`id` int(11) NOT NULL auto_increment COMMENT 'primary key',
		5638	`reporter_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the patron who reported the ticket',
		5639	`reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported',
		5640	`title` text NOT NULL COMMENT 'ticket title',
		5641	`body` text NOT NULL COMMENT 'ticket details',
		5642	`resolver_id` int(11) DEFAULT NULL COMMENT 'id of the user who resolved the ticket',
		5643	`resolved_date` datetime DEFAULT NULL COMMENT 'date and time this ticket was resolved',
		5644	`biblio_id` int(11) DEFAULT NULL COMMENT 'id of biblio linked',
		5645	PRIMARY KEY(`id`),
		5646	CONSTRAINT `tickets_ibfk_1` FOREIGN KEY (`reporter_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
		5647	CONSTRAINT `tickets_ibfk_2` FOREIGN KEY (`resolver_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
		5648	CONSTRAINT `tickets_ibfk_3` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
		5649	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
		5650	/!40101 SET character_set_client = @saved_cs_client /;
		5651
		5652	--
		5653	-- Table structure for table `ticket_updates`
		5654	--
		5655
		5656	DROP TABLE IF EXISTS `ticket_updates`;
		5657	/!40101 SET @saved_cs_client = @@character_set_client /;
		5658	/!40101 SET character_set_client = utf8 /;
		5659	CREATE TABLE IF NOT EXISTS `ticket_updates` (
		5660	`id` int(11) NOT NULL auto_increment COMMENT 'primary key',
		5661	`ticket_id` int(11) NOT NULL COMMENT 'id of catalog ticket the update relates to',
		5662	`user_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the user who logged the update',
		5663	`public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public',
		5664	`date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged',
		5665	`message` text NOT NULL COMMENT 'update message content',
		5666	PRIMARY KEY(`id`),
		5667	CONSTRAINT `ticket_updates_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
		5668	CONSTRAINT `ticket_updates_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
		5669	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
		5670	/!40101 SET character_set_client = @saved_cs_client /;
		5671
5629	--	5672	--
5630	-- Table structure for table `tmp_holdsqueue`	5673	-- Table structure for table `tmp_holdsqueue`
5631	--	5674	--
5632	-

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	}