Attachment #143302 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 5359-5364 CREATE TABLE `tags_index` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +43 lines)
5359	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;	5359	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5360	/!40101 SET character_set_client = @saved_cs_client /;	5360	/!40101 SET character_set_client = @saved_cs_client /;
5361		5361
		5362	--
		5363	-- Table structure for table `tickets`
		5364	--
		5365
		5366	DROP TABLE IF EXISTS `tickets`;
		5367	/!40101 SET @saved_cs_client = @@character_set_client /;
		5368	/!40101 SET character_set_client = utf8 /;
		5369	CREATE TABLE IF NOT EXISTS `tickets` (
		5370	`id` int(11) NOT NULL auto_increment COMMENT 'primary key',
		5371	`reporter_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the patron who reported the ticket',
		5372	`reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported',
		5373	`title` text NOT NULL COMMENT 'ticket title',
		5374	`body` text NOT NULL COMMENT 'ticket details',
		5375	`resolver_id` int(11) DEFAULT NULL COMMENT 'id of the user who resolved the ticket',
		5376	`resolved_date` datetime DEFAULT NULL COMMENT 'date and time this ticket was resolved',
		5377	`biblio_id` int(11) DEFAULT NULL COMMENT 'id of biblio linked',
		5378	PRIMARY KEY(`id`),
		5379	CONSTRAINT `tickets_ibfk_1` FOREIGN KEY (`reporter_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
		5380	CONSTRAINT `tickets_ibfk_2` FOREIGN KEY (`resolver_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
		5381	CONSTRAINT `tickets_ibfk_3` FOREIGN KEY (`biblio_id`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
		5382	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
		5383	/!40101 SET character_set_client = @saved_cs_client /;
		5384
		5385	--
		5386	-- Table structure for table `ticket_updates`
		5387	--
		5388
		5389	DROP TABLE IF EXISTS `ticket_updates`;
		5390	/!40101 SET @saved_cs_client = @@character_set_client /;
		5391	/!40101 SET character_set_client = utf8 /;
		5392	CREATE TABLE IF NOT EXISTS `ticket_updates` (
		5393	`id` int(11) NOT NULL auto_increment COMMENT 'primary key',
		5394	`ticket_id` int(11) NOT NULL COMMENT 'id of catalog ticket the update relates to',
		5395	`user_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the user who logged the update',
		5396	`public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public',
		5397	`date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged',
		5398	`message` text NOT NULL COMMENT 'update message content',
		5399	PRIMARY KEY(`id`),
		5400	CONSTRAINT `ticket_updates_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
		5401	CONSTRAINT `ticket_updates_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE
		5402	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
		5403	/!40101 SET character_set_client = @saved_cs_client /;
		5404
5362	--	5405	--
5363	-- Table structure for table `tmp_holdsqueue`	5406	-- Table structure for table `tmp_holdsqueue`
5364	--	5407	--
5365	-

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	}