-- phpMyAdmin SQL Dump
-- version 4.2.10
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Oct 11, 2018 at 03:34 PM
-- Server version: 5.5.38
-- PHP Version: 5.6.2

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `consent`
--

-- --------------------------------------------------------

--
-- Table structure for table `Consent`
--

CREATE TABLE `Consent` (
`id` bigint(20) NOT NULL,
  `registeredOn` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `validUntil` datetime DEFAULT NULL,
  `inclusion_id` bigint(20) NOT NULL,
  `oldVersion_id` bigint(20) DEFAULT NULL,
  `user_id` bigint(20) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=284 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Consent`
--

INSERT INTO `Consent` (`id`, `registeredOn`, `status`, `validUntil`, `inclusion_id`, `oldVersion_id`, `user_id`) VALUES
(1, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 1, NULL, 7),
(2, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 2, NULL, 7),
(3, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 3, NULL, 7),
(4, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 13, NULL, 7),
(5, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 14, NULL, 7),
(6, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 15, NULL, 7),
(7, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 7, NULL, 8),
(8, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 8, NULL, 8),
(9, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 9, NULL, 8),
(10, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 11, NULL, 8),
(11, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 9, NULL, 5),
(12, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 13, NULL, 5),
(13, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 14, NULL, 5),
(14, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 15, NULL, 5),
(15, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 4, NULL, 2),
(16, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 5, NULL, 2),
(17, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 6, NULL, 2),
(18, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 13, NULL, 2),
(19, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 12, NULL, 10),
(20, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 13, NULL, 10),
(21, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 14, NULL, 10),
(22, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 15, NULL, 10),
(23, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 3, NULL, 6),
(24, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 4, NULL, 6),
(25, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 5, NULL, 6),
(26, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 6, NULL, 6),
(27, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 7, NULL, 9),
(28, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 8, NULL, 9),
(29, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 9, NULL, 9),
(30, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 10, NULL, 9),
(31, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 11, NULL, 9),
(32, '2018-10-11 00:00:00', 0, '2019-01-09 00:00:00', 12, NULL, 9),
(33, '2018-10-14 00:00:00', 2, NULL, 1, 1, 7),
(34, '2018-10-17 00:00:00', 2, NULL, 5, 25, 6),
(35, '2018-10-17 00:00:00', 2, NULL, 6, 26, 6),
(36, '2018-10-17 00:00:00', 0, '2019-01-15 00:00:00', 10, NULL, 8),
(37, '2018-10-20 00:00:00', 0, '2019-01-18 00:00:00', 15, NULL, 2),
(38, '2018-10-20 00:00:00', 2, NULL, 5, 16, 2),
(39, '2018-10-20 00:00:00', 0, '2019-01-18 00:00:00', 8, NULL, 5),
(40, '2018-10-23 00:00:00', 2, NULL, 6, 17, 2),
(41, '2018-10-26 00:00:00', 2, NULL, 10, 30, 9),
(42, '2018-10-29 00:00:00', 2, NULL, 8, 8, 8),
(43, '2018-11-01 00:00:00', 2, NULL, 13, 18, 2),
(44, '2018-11-01 00:00:00', 0, '2019-01-30 00:00:00', 5, 34, 6),
(45, '2018-11-01 00:00:00', 2, NULL, 10, 36, 8),
(46, '2018-11-04 00:00:00', 2, NULL, 15, 37, 2),
(47, '2018-11-04 00:00:00', 2, NULL, 13, 20, 10),
(48, '2018-11-04 00:00:00', 0, '2019-02-02 00:00:00', 8, 42, 8),
(49, '2018-11-04 00:00:00', 2, NULL, 11, 10, 8),
(50, '2018-11-04 00:00:00', 0, '2019-02-02 00:00:00', 10, 41, 9),
(51, '2018-11-07 00:00:00', 2, NULL, 7, 7, 8),
(52, '2018-11-07 00:00:00', 2, NULL, 11, 31, 9),
(53, '2018-11-13 00:00:00', 2, NULL, 9, 29, 9),
(54, '2018-11-16 00:00:00', 0, '2019-02-14 00:00:00', 6, 35, 6),
(55, '2018-11-19 00:00:00', 0, '2019-02-17 00:00:00', 15, 46, 2),
(56, '2018-11-19 00:00:00', 0, '2019-02-17 00:00:00', 12, NULL, 8),
(57, '2018-11-22 00:00:00', 2, NULL, 14, 5, 7),
(58, '2018-11-22 00:00:00', 2, NULL, 15, 14, 5),
(59, '2018-11-25 00:00:00', 2, NULL, 15, 55, 2),
(60, '2018-11-28 00:00:00', 2, NULL, 8, 39, 5),
(61, '2018-11-28 00:00:00', 0, '2019-02-26 00:00:00', 11, 49, 8),
(62, '2018-12-01 00:00:00', 0, '2019-03-01 00:00:00', 5, 38, 2),
(63, '2018-12-07 00:00:00', 2, NULL, 5, 44, 6),
(64, '2018-12-13 00:00:00', 2, NULL, 2, 2, 7),
(65, '2018-12-13 00:00:00', 2, NULL, 12, 56, 8),
(66, '2018-12-16 00:00:00', 0, '2019-03-16 00:00:00', 2, 64, 7),
(67, '2018-12-16 00:00:00', 0, '2019-03-16 00:00:00', 5, 63, 6),
(68, '2018-12-16 00:00:00', 0, '2019-03-16 00:00:00', 7, NULL, 5),
(69, '2018-12-16 00:00:00', 0, '2019-03-16 00:00:00', 10, NULL, 10),
(70, '2018-12-19 00:00:00', 2, NULL, 2, 66, 7),
(71, '2018-12-19 00:00:00', 0, '2019-03-19 00:00:00', 14, NULL, 2),
(72, '2018-12-22 00:00:00', 0, '2019-03-22 00:00:00', 15, 58, 5),
(73, '2018-12-22 00:00:00', 0, '2019-03-22 00:00:00', 13, 47, 10),
(74, '2018-12-22 00:00:00', 0, '2019-03-22 00:00:00', 7, 51, 8),
(75, '2018-12-31 00:00:00', 0, '2019-03-31 00:00:00', 16, NULL, 8),
(76, '2018-12-31 00:00:00', 0, '2019-03-31 00:00:00', 17, NULL, 8),
(77, '2018-12-31 00:00:00', 0, '2019-03-31 00:00:00', 18, NULL, 8),
(78, '2018-12-31 00:00:00', 0, '2019-03-31 00:00:00', 16, NULL, 10),
(79, '2018-12-31 00:00:00', 0, '2019-03-31 00:00:00', 16, NULL, 9),
(80, '2018-12-31 00:00:00', 0, '2019-03-31 00:00:00', 17, NULL, 9),
(81, '2018-12-31 00:00:00', 0, '2019-03-31 00:00:00', 18, NULL, 9),
(82, '2018-12-31 00:00:00', 0, '2019-03-31 00:00:00', 2, NULL, 6),
(83, '2018-12-31 00:00:00', 2, NULL, 14, 71, 2),
(84, '2019-01-03 00:00:00', 2, NULL, 14, 13, 5),
(85, '2019-01-03 00:00:00', 2, NULL, 18, 77, 8),
(86, '2019-01-03 00:00:00', 0, '2019-04-03 00:00:00', 18, NULL, 10),
(87, '2019-01-09 00:00:00', 2, NULL, 17, 76, 8),
(88, '2019-01-12 00:00:00', 0, '2019-04-12 00:00:00', 3, 3, 7),
(89, '2019-01-12 00:00:00', 0, '2019-04-12 00:00:00', 3, 23, 6),
(90, '2019-01-12 00:00:00', 2, NULL, 13, 73, 10),
(91, '2019-01-12 00:00:00', 0, '2019-04-12 00:00:00', 14, 21, 10),
(92, '2019-01-12 00:00:00', 0, '2019-04-12 00:00:00', 4, 15, 2),
(93, '2019-01-12 00:00:00', 2, NULL, 5, 67, 6),
(94, '2019-01-12 00:00:00', 0, '2019-04-12 00:00:00', 9, 9, 8),
(95, '2019-01-12 00:00:00', 0, '2019-04-12 00:00:00', 9, 11, 5),
(96, '2019-01-12 00:00:00', 0, '2019-04-12 00:00:00', 7, 27, 9),
(97, '2019-01-15 00:00:00', 2, NULL, 3, 89, 6),
(98, '2019-01-15 00:00:00', 0, '2019-04-15 00:00:00', 13, 4, 7),
(99, '2019-01-15 00:00:00', 0, '2019-04-15 00:00:00', 15, 6, 7),
(100, '2019-01-15 00:00:00', 0, '2019-04-15 00:00:00', 13, 12, 5),
(101, '2019-01-15 00:00:00', 0, '2019-04-15 00:00:00', 13, 43, 2),
(102, '2019-01-15 00:00:00', 0, '2019-04-15 00:00:00', 15, 22, 10),
(103, '2019-01-15 00:00:00', 0, '2019-04-15 00:00:00', 4, 24, 6),
(104, '2019-01-15 00:00:00', 0, '2019-04-15 00:00:00', 17, 87, 8),
(105, '2019-01-15 00:00:00', 2, NULL, 7, 68, 5),
(106, '2019-01-15 00:00:00', 0, '2019-04-15 00:00:00', 8, 28, 9),
(107, '2019-01-18 00:00:00', 2, NULL, 17, 104, 8),
(108, '2019-01-21 00:00:00', 2, NULL, 8, 48, 8),
(109, '2019-01-24 00:00:00', 2, NULL, 15, 72, 5),
(110, '2019-01-24 00:00:00', 2, NULL, 15, 102, 10),
(111, '2019-01-27 00:00:00', 2, NULL, 9, 95, 5),
(112, '2019-01-27 00:00:00', 2, NULL, 7, 96, 9),
(113, '2019-01-30 00:00:00', 2, NULL, 4, 92, 2),
(114, '2019-01-30 00:00:00', 2, NULL, 6, 54, 6),
(115, '2019-02-02 00:00:00', 0, '2019-05-03 00:00:00', 13, 90, 10),
(116, '2019-02-05 00:00:00', 0, '2019-05-06 00:00:00', 5, 93, 6),
(117, '2019-02-05 00:00:00', 2, NULL, 16, 75, 8),
(118, '2019-02-05 00:00:00', 0, '2019-05-06 00:00:00', 8, 108, 8),
(119, '2019-02-08 00:00:00', 2, NULL, 5, 116, 6),
(120, '2019-02-08 00:00:00', 2, NULL, 18, 81, 9),
(121, '2019-02-11 00:00:00', 0, '2019-05-12 00:00:00', 16, 117, 8),
(122, '2019-02-14 00:00:00', 2, NULL, 9, 94, 8),
(123, '2019-02-17 00:00:00', 0, '2019-05-18 00:00:00', 6, 114, 6),
(124, '2019-02-20 00:00:00', 2, NULL, 13, 101, 2),
(125, '2019-02-23 00:00:00', 2, NULL, 14, 91, 10),
(126, '2019-02-23 00:00:00', 0, '2019-05-24 00:00:00', 18, 85, 8),
(127, '2019-02-23 00:00:00', 2, NULL, 18, 86, 10),
(128, '2019-02-23 00:00:00', 0, '2019-05-24 00:00:00', 9, 122, 8),
(129, '2019-02-26 00:00:00', 0, '2019-05-27 00:00:00', 15, 109, 5),
(130, '2019-02-26 00:00:00', 0, '2019-05-27 00:00:00', 7, 105, 5),
(131, '2019-03-01 00:00:00', 2, NULL, 2, 82, 6),
(132, '2019-03-01 00:00:00', 0, '2019-05-30 00:00:00', 14, 125, 10),
(133, '2019-03-01 00:00:00', 0, '2019-05-30 00:00:00', 15, 110, 10),
(134, '2019-03-07 00:00:00', 0, '2019-06-05 00:00:00', 1, 33, 7),
(135, '2019-03-07 00:00:00', 0, '2019-06-05 00:00:00', 5, 62, 2),
(136, '2019-03-10 00:00:00', 0, '2019-06-08 00:00:00', 3, 97, 6),
(137, '2019-03-10 00:00:00', 0, '2019-06-08 00:00:00', 17, 107, 8),
(138, '2019-03-13 00:00:00', 2, NULL, 15, 99, 7),
(139, '2019-03-16 00:00:00', 0, '2019-06-14 00:00:00', 9, 111, 5),
(140, '2019-03-19 00:00:00', 2, NULL, 3, 136, 6),
(141, '2019-03-19 00:00:00', 2, NULL, 13, 98, 7),
(142, '2019-03-19 00:00:00', 0, '2019-06-17 00:00:00', 17, NULL, 10),
(143, '2019-03-25 00:00:00', 0, '2019-06-23 00:00:00', 2, 131, 6),
(144, '2019-03-25 00:00:00', 0, '2019-06-23 00:00:00', 14, 84, 5),
(145, '2019-03-25 00:00:00', 0, '2019-06-23 00:00:00', 14, 83, 2),
(146, '2019-03-25 00:00:00', 2, NULL, 5, 135, 2),
(147, '2019-03-25 00:00:00', 2, NULL, 6, 123, 6),
(148, '2019-03-25 00:00:00', 0, '2019-06-23 00:00:00', 7, 74, 8),
(149, '2019-03-25 00:00:00', 2, NULL, 7, 130, 5),
(150, '2019-03-28 00:00:00', 0, '2019-06-26 00:00:00', 14, 57, 7),
(151, '2019-03-28 00:00:00', 2, NULL, 13, 115, 10),
(152, '2019-03-28 00:00:00', 2, NULL, 17, 137, 8),
(153, '2019-03-31 00:00:00', 0, '2019-06-29 00:00:00', 13, 151, 10),
(154, '2019-03-31 00:00:00', 2, NULL, 8, 118, 8),
(155, '2019-03-31 00:00:00', 0, '2019-06-29 00:00:00', 8, 60, 5),
(156, '2019-03-31 00:00:00', 0, '2019-06-29 00:00:00', 7, 112, 9),
(157, '2019-04-03 00:00:00', 0, '2019-07-02 00:00:00', 2, 70, 7),
(158, '2019-04-03 00:00:00', 2, NULL, 14, 144, 5),
(159, '2019-04-03 00:00:00', 0, '2019-07-02 00:00:00', 5, 146, 2),
(160, '2019-04-03 00:00:00', 0, '2019-07-02 00:00:00', 16, 78, 10),
(161, '2019-04-03 00:00:00', 0, '2019-07-02 00:00:00', 16, 79, 9),
(162, '2019-04-03 00:00:00', 0, '2019-07-02 00:00:00', 8, 154, 8),
(163, '2019-04-06 00:00:00', 0, '2019-07-05 00:00:00', 1, NULL, 6),
(164, '2019-04-06 00:00:00', 2, NULL, 8, 155, 5),
(165, '2019-04-09 00:00:00', 0, '2019-07-08 00:00:00', 19, NULL, 2),
(166, '2019-04-09 00:00:00', 0, '2019-07-08 00:00:00', 20, NULL, 2),
(167, '2019-04-09 00:00:00', 0, '2019-07-08 00:00:00', 21, NULL, 2),
(168, '2019-04-09 00:00:00', 0, '2019-07-08 00:00:00', 19, NULL, 6),
(169, '2019-04-09 00:00:00', 0, '2019-07-08 00:00:00', 20, NULL, 6),
(170, '2019-04-09 00:00:00', 0, '2019-07-08 00:00:00', 21, NULL, 6),
(171, '2019-04-09 00:00:00', 0, '2019-07-08 00:00:00', 15, 138, 7),
(172, '2019-04-09 00:00:00', 2, NULL, 16, 161, 9),
(173, '2019-04-09 00:00:00', 2, NULL, 8, 162, 8),
(174, '2019-04-09 00:00:00', 2, NULL, 7, 156, 9),
(175, '2019-04-12 00:00:00', 2, NULL, 19, 165, 2),
(176, '2019-04-12 00:00:00', 2, NULL, 9, 139, 5),
(177, '2019-04-15 00:00:00', 0, '2019-07-14 00:00:00', 8, 164, 5),
(178, '2019-04-18 00:00:00', 0, '2019-07-17 00:00:00', 3, 88, 7),
(179, '2019-04-18 00:00:00', 0, '2019-07-17 00:00:00', 13, 141, 7),
(180, '2019-04-18 00:00:00', 2, NULL, 14, 150, 7),
(181, '2019-04-18 00:00:00', 0, '2019-07-17 00:00:00', 18, 127, 10),
(182, '2019-04-18 00:00:00', 0, '2019-07-17 00:00:00', 8, 106, 9),
(183, '2019-04-21 00:00:00', 2, NULL, 2, 143, 6),
(184, '2019-04-21 00:00:00', 0, '2019-07-20 00:00:00', 13, 100, 5),
(185, '2019-04-21 00:00:00', 0, '2019-07-20 00:00:00', 14, 158, 5),
(186, '2019-04-21 00:00:00', 0, '2019-07-20 00:00:00', 16, 172, 9),
(187, '2019-04-21 00:00:00', 0, '2019-07-20 00:00:00', 17, 80, 9),
(188, '2019-04-27 00:00:00', 0, '2019-07-26 00:00:00', 19, 175, 2),
(189, '2019-04-27 00:00:00', 2, NULL, 16, 160, 10),
(190, '2019-05-03 00:00:00', 0, '2019-08-01 00:00:00', 22, NULL, 7),
(191, '2019-05-03 00:00:00', 0, '2019-08-01 00:00:00', 23, NULL, 7),
(192, '2019-05-03 00:00:00', 0, '2019-08-01 00:00:00', 24, NULL, 7),
(193, '2019-05-03 00:00:00', 0, '2019-08-01 00:00:00', 22, NULL, 5),
(194, '2019-05-03 00:00:00', 0, '2019-08-01 00:00:00', 22, NULL, 2),
(195, '2019-05-03 00:00:00', 0, '2019-08-01 00:00:00', 23, NULL, 2),
(196, '2019-05-03 00:00:00', 0, '2019-08-01 00:00:00', 24, NULL, 2),
(197, '2019-05-03 00:00:00', 0, '2019-08-01 00:00:00', 24, NULL, 10),
(198, '2019-05-03 00:00:00', 2, NULL, 22, 194, 2),
(199, '2019-05-03 00:00:00', 2, NULL, 7, 148, 8),
(200, '2019-05-06 00:00:00', 2, NULL, 2, 157, 7),
(201, '2019-05-06 00:00:00', 0, '2019-08-04 00:00:00', 16, 189, 10),
(202, '2019-05-06 00:00:00', 0, '2019-08-04 00:00:00', 7, 199, 8),
(203, '2019-05-06 00:00:00', 0, '2019-08-04 00:00:00', 7, 174, 9),
(204, '2019-05-06 00:00:00', 2, NULL, 8, 182, 9),
(205, '2019-05-09 00:00:00', 2, NULL, 23, 191, 7),
(206, '2019-05-09 00:00:00', 2, NULL, 19, 168, 6),
(207, '2019-05-09 00:00:00', 2, NULL, 18, 126, 8),
(208, '2019-05-12 00:00:00', 0, '2019-08-10 00:00:00', 25, NULL, 7),
(209, '2019-05-12 00:00:00', 0, '2019-08-10 00:00:00', 26, NULL, 7),
(210, '2019-05-12 00:00:00', 0, '2019-08-10 00:00:00', 27, NULL, 7),
(211, '2019-05-12 00:00:00', 0, '2019-08-10 00:00:00', 27, NULL, 5),
(212, '2019-05-12 00:00:00', 0, '2019-08-10 00:00:00', 25, NULL, 2),
(213, '2019-05-12 00:00:00', 0, '2019-08-10 00:00:00', 25, NULL, 10),
(214, '2019-05-12 00:00:00', 0, '2019-08-10 00:00:00', 26, NULL, 10),
(215, '2019-05-12 00:00:00', 0, '2019-08-10 00:00:00', 27, NULL, 10),
(216, '2019-05-12 00:00:00', 2, NULL, 1, 134, 7),
(217, '2019-05-12 00:00:00', 2, NULL, 26, 214, 10),
(218, '2019-05-18 00:00:00', 0, '2019-08-16 00:00:00', 2, 200, 7),
(219, '2019-05-18 00:00:00', 0, '2019-08-16 00:00:00', 16, 121, 8),
(220, '2019-05-18 00:00:00', 2, NULL, 18, 181, 10),
(221, '2019-05-24 00:00:00', 0, '2019-08-22 00:00:00', 2, 183, 6),
(222, '2019-05-27 00:00:00', 0, '2019-08-25 00:00:00', 18, 220, 10),
(223, '2019-05-27 00:00:00', 0, '2019-08-25 00:00:00', 9, 53, 9),
(224, '2019-05-30 00:00:00', 0, '2019-08-28 00:00:00', 3, 140, 6),
(225, '2019-05-30 00:00:00', 2, NULL, 16, 201, 10),
(226, '2019-05-30 00:00:00', 0, '2019-08-28 00:00:00', 9, 128, 8),
(227, '2019-06-02 00:00:00', 2, NULL, 2, 221, 6),
(228, '2019-06-05 00:00:00', 0, '2019-09-03 00:00:00', 26, NULL, 5),
(229, '2019-06-05 00:00:00', 2, NULL, 9, 223, 9),
(230, '2019-06-08 00:00:00', 0, '2019-09-06 00:00:00', 1, 216, 7),
(231, '2019-06-11 00:00:00', 2, NULL, 19, 188, 2),
(232, '2019-06-14 00:00:00', 2, NULL, 27, 210, 7),
(233, '2019-06-14 00:00:00', 2, NULL, 25, 212, 2),
(234, '2019-06-17 00:00:00', 0, '2019-09-15 00:00:00', 25, NULL, 5),
(235, '2019-06-17 00:00:00', 0, '2019-09-15 00:00:00', 26, NULL, 2),
(236, '2019-06-17 00:00:00', 2, NULL, 26, 214, 10),
(237, '2019-06-17 00:00:00', 2, NULL, 21, 167, 2),
(238, '2019-06-17 00:00:00', 2, NULL, 21, 170, 6),
(239, '2019-06-17 00:00:00', 0, '2019-09-15 00:00:00', 9, 229, 9),
(240, '2019-06-20 00:00:00', 0, '2019-09-18 00:00:00', 27, 232, 7),
(241, '2019-06-20 00:00:00', 0, '2019-09-18 00:00:00', 21, 238, 6),
(242, '2019-06-20 00:00:00', 0, '2019-09-18 00:00:00', 17, 142, 10),
(243, '2019-06-23 00:00:00', 2, NULL, 17, 187, 9),
(244, '2019-06-26 00:00:00', 2, NULL, 17, 242, 10),
(245, '2019-06-29 00:00:00', 2, NULL, 26, 235, 2),
(246, '2019-06-29 00:00:00', 2, NULL, 21, 241, 6),
(247, '2019-07-02 00:00:00', 0, '2019-09-30 00:00:00', 30, NULL, 8),
(248, '2019-07-02 00:00:00', 0, '2019-09-30 00:00:00', 28, NULL, 10),
(249, '2019-07-02 00:00:00', 0, '2019-09-30 00:00:00', 29, NULL, 10),
(250, '2019-07-02 00:00:00', 0, '2019-09-30 00:00:00', 30, NULL, 10),
(251, '2019-07-02 00:00:00', 0, '2019-09-30 00:00:00', 28, NULL, 9),
(252, '2019-07-02 00:00:00', 0, '2019-09-30 00:00:00', 29, NULL, 9),
(253, '2019-07-02 00:00:00', 0, '2019-09-30 00:00:00', 30, NULL, 9),
(254, '2019-07-08 00:00:00', 0, '2019-10-06 00:00:00', 1, 163, 6),
(255, '2019-07-08 00:00:00', 2, NULL, 27, 215, 10),
(256, '2019-07-08 00:00:00', 2, NULL, 30, 253, 9),
(257, '2019-07-11 00:00:00', 0, '2019-10-09 00:00:00', 25, 233, 2),
(258, '2019-07-11 00:00:00', 0, '2019-10-09 00:00:00', 21, 246, 6),
(259, '2019-07-14 00:00:00', 0, '2019-10-12 00:00:00', 28, NULL, 8),
(260, '2019-07-14 00:00:00', 0, '2019-10-12 00:00:00', 20, 166, 2),
(261, '2019-07-14 00:00:00', 0, '2019-10-12 00:00:00', 20, 169, 6),
(262, '2019-07-14 00:00:00', 2, NULL, 21, 258, 6),
(263, '2019-07-17 00:00:00', 2, NULL, 26, 209, 7),
(264, '2019-07-17 00:00:00', 2, NULL, 27, 240, 7),
(265, '2019-07-17 00:00:00', 0, '2019-10-15 00:00:00', 27, 255, 10),
(266, '2019-07-17 00:00:00', 0, '2019-10-15 00:00:00', 30, 256, 9),
(267, '2019-07-17 00:00:00', 0, '2019-10-15 00:00:00', 8, 177, 5),
(268, '2019-07-20 00:00:00', 0, '2019-10-18 00:00:00', 3, 178, 7),
(269, '2019-07-20 00:00:00', 2, NULL, 25, 208, 7),
(270, '2019-07-20 00:00:00', 2, NULL, 25, 234, 5),
(271, '2019-07-20 00:00:00', 0, '2019-10-18 00:00:00', 26, 236, 10),
(272, '2019-07-20 00:00:00', 0, '2019-10-18 00:00:00', 8, 173, 8),
(273, '2019-07-20 00:00:00', 0, '2019-10-18 00:00:00', 8, 204, 9),
(274, '2019-07-23 00:00:00', 0, '2019-10-21 00:00:00', 7, 149, 5),
(275, '2019-07-26 00:00:00', 2, NULL, 27, 211, 5),
(276, '2019-07-26 00:00:00', 2, NULL, 25, 257, 2),
(277, '2019-07-26 00:00:00', 2, NULL, 30, 247, 8),
(278, '2019-07-26 00:00:00', 2, NULL, 29, 252, 9),
(279, '2019-07-29 00:00:00', 0, '2019-10-27 00:00:00', 27, 275, 5),
(280, '2019-07-29 00:00:00', 2, NULL, 7, 203, 9),
(281, '2019-08-04 00:00:00', 2, NULL, 30, 266, 9),
(282, '2019-08-07 00:00:00', 0, '2019-11-05 00:00:00', 27, NULL, 2),
(283, '2019-08-07 00:00:00', 0, '2019-11-05 00:00:00', 29, 278, 9);

-- --------------------------------------------------------

--
-- Table structure for table `Inclusion`
--

CREATE TABLE `Inclusion` (
`id` bigint(20) NOT NULL,
  `policy_id` bigint(20) NOT NULL,
  `purpose_id` bigint(20) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Inclusion`
--

INSERT INTO `Inclusion` (`id`, `policy_id`, `purpose_id`) VALUES
(1, 1, 7),
(2, 1, 10),
(3, 1, 8),
(4, 2, 1),
(5, 2, 10),
(6, 2, 7),
(7, 3, 1),
(8, 3, 8),
(9, 3, 3),
(10, 4, 9),
(11, 4, 2),
(12, 4, 3),
(13, 5, 6),
(14, 5, 3),
(15, 5, 5),
(16, 6, 2),
(17, 6, 3),
(18, 6, 7),
(19, 7, 1),
(20, 7, 10),
(21, 7, 5),
(22, 8, 6),
(23, 8, 5),
(24, 8, 8),
(25, 9, 6),
(26, 9, 5),
(27, 9, 10),
(28, 10, 3),
(29, 10, 7),
(30, 10, 8);

-- --------------------------------------------------------

--
-- Table structure for table `Policy`
--

CREATE TABLE `Policy` (
`id` bigint(20) NOT NULL,
  `dateGenerated` datetime DEFAULT NULL,
  `isPublished` bit(1) NOT NULL,
  `system` varchar(255) DEFAULT NULL,
  `version` int(11) NOT NULL,
  `oldVersion_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Policy`
--

INSERT INTO `Policy` (`id`, `dateGenerated`, `isPublished`, `system`, `version`, `oldVersion_id`) VALUES
(1, '2018-10-11 00:00:00', b'1', 'System 1', 1, NULL),
(2, '2018-10-11 00:00:00', b'1', 'System 2', 1, NULL),
(3, '2018-10-11 00:00:00', b'1', 'System 3', 1, NULL),
(4, '2018-10-11 00:00:00', b'1', 'System 4', 1, NULL),
(5, '2018-10-11 00:00:00', b'1', 'System 5', 1, NULL),
(6, '2018-12-31 00:00:00', b'1', 'System 4', 2, 4),
(7, '2019-04-09 00:00:00', b'1', 'System 2', 2, 2),
(8, '2019-05-03 00:00:00', b'1', 'System 5', 2, 5),
(9, '2019-05-12 00:00:00', b'1', 'System 5', 3, 8),
(10, '2019-07-02 00:00:00', b'1', 'System 4', 3, 6);

-- --------------------------------------------------------

--
-- Table structure for table `Purpose`
--

CREATE TABLE `Purpose` (
`id` bigint(20) NOT NULL,
  `description` varchar(255) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Purpose`
--

INSERT INTO `Purpose` (`id`, `description`) VALUES
(1, 'Purpose 1'),
(10, 'Purpose 10'),
(2, 'Purpose 2'),
(3, 'Purpose 3'),
(4, 'Purpose 4'),
(5, 'Purpose 5'),
(6, 'Purpose 6'),
(7, 'Purpose 7'),
(8, 'Purpose 8'),
(9, 'Purpose 9');

-- --------------------------------------------------------

--
-- Table structure for table `User`
--

CREATE TABLE `User` (
`id` bigint(20) NOT NULL,
  `email` varchar(255) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `User`
--

INSERT INTO `User` (`id`, `email`) VALUES
(10, 'user_10@example.org'),
(1, 'user_1@example.org'),
(2, 'user_2@example.org'),
(3, 'user_3@example.org'),
(4, 'user_4@example.org'),
(5, 'user_5@example.org'),
(6, 'user_6@example.org'),
(7, 'user_7@example.org'),
(8, 'user_8@example.org'),
(9, 'user_9@example.org');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `Consent`
--
ALTER TABLE `Consent`
 ADD PRIMARY KEY (`id`), ADD KEY `FK_5rtxgv4yvils0mu9h74lk84dm` (`inclusion_id`), ADD KEY `FK_c6qdhstd5e7ec4y96cb68u74v` (`oldVersion_id`), ADD KEY `FK_sxmqdfoh1y7omkkxy0iq4cbuo` (`user_id`);

--
-- Indexes for table `Inclusion`
--
ALTER TABLE `Inclusion`
 ADD PRIMARY KEY (`id`), ADD KEY `FK_jpvahap73a1bhl5likrmu9aw1` (`policy_id`), ADD KEY `FK_bqnkagmlm3676jc3hkdb9wr25` (`purpose_id`);

--
-- Indexes for table `Policy`
--
ALTER TABLE `Policy`
 ADD PRIMARY KEY (`id`), ADD KEY `FK_kvkhxtql03aj0k1am9ww706ib` (`oldVersion_id`);

--
-- Indexes for table `Purpose`
--
ALTER TABLE `Purpose`
 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `UK_4qsgx8vk2atm0nyc397absbk1` (`description`);

--
-- Indexes for table `User`
--
ALTER TABLE `User`
 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `UK_e6gkqunxajvyxl5uctpl2vl2p` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `Consent`
--
ALTER TABLE `Consent`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=284;
--
-- AUTO_INCREMENT for table `Inclusion`
--
ALTER TABLE `Inclusion`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=31;
--
-- AUTO_INCREMENT for table `Policy`
--
ALTER TABLE `Policy`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `Purpose`
--
ALTER TABLE `Purpose`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `User`
--
ALTER TABLE `User`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `Consent`
--
ALTER TABLE `Consent`
ADD CONSTRAINT `FK_sxmqdfoh1y7omkkxy0iq4cbuo` FOREIGN KEY (`user_id`) REFERENCES `User` (`id`),
ADD CONSTRAINT `FK_5rtxgv4yvils0mu9h74lk84dm` FOREIGN KEY (`inclusion_id`) REFERENCES `Inclusion` (`id`),
ADD CONSTRAINT `FK_c6qdhstd5e7ec4y96cb68u74v` FOREIGN KEY (`oldVersion_id`) REFERENCES `Consent` (`id`);

--
-- Constraints for table `Inclusion`
--
ALTER TABLE `Inclusion`
ADD CONSTRAINT `FK_bqnkagmlm3676jc3hkdb9wr25` FOREIGN KEY (`purpose_id`) REFERENCES `Purpose` (`id`),
ADD CONSTRAINT `FK_jpvahap73a1bhl5likrmu9aw1` FOREIGN KEY (`policy_id`) REFERENCES `Policy` (`id`);

--
-- Constraints for table `Policy`
--
ALTER TABLE `Policy`
ADD CONSTRAINT `FK_kvkhxtql03aj0k1am9ww706ib` FOREIGN KEY (`oldVersion_id`) REFERENCES `Policy` (`id`);

