CREATE TABLE IF NOT EXISTS `fundraise` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pub_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_1B68650483FDE077` (`pub_id`),
  CONSTRAINT `FK_1B68650483FDE077` FOREIGN KEY (`pub_id`) REFERENCES `pub` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table harcourt.fundraise: ~6 rows (approximately)
INSERT INTO `fundraise` (`id`, `pub_id`) VALUES
	(7, 7),
	(6, 8),
	(5, 9),
	(4, 10),
	(3, 11),
	(2, 12),
	(8, 13);

-- Dumping structure for table harcourt.fund_raise_contribution
CREATE TABLE IF NOT EXISTS `fund_raise_contribution` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fundraise_id` int(11) NOT NULL,
  `shareholder_id` int(11) NOT NULL,
  `amount` int(11) DEFAULT '0',
  `monies_received` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `proxyvote` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_sent` datetime DEFAULT NULL,
  `share_cert_number_standard` int(11) DEFAULT NULL,
  `share_cert_number_enhanced` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_88B0FA523AAB1B7F` (`fundraise_id`),
  KEY `IDX_88B0FA529D59475` (`shareholder_id`),
  CONSTRAINT `FK_88B0FA523AAB1B7F` FOREIGN KEY (`fundraise_id`) REFERENCES `fundraise` (`id`),
  CONSTRAINT `FK_88B0FA529D59475` FOREIGN KEY (`shareholder_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=556 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table harcourt.fund_raise_contribution: ~480 rows (approximately)
INSERT INTO `fund_raise_contribution` (`id`, `fundraise_id`, `shareholder_id`, `amount`, `monies_received`, `proxyvote`, `payment_sent`, `share_cert_number_standard`, `share_cert_number_enhanced`) VALUES
	(75, 2, 277, NULL, NULL, NULL, NULL, NULL, NULL),
	(76, 2, 425, 0, NULL, NULL, NULL, NULL, NULL),
	(77, 2, 390, 0, NULL, NULL, NULL, NULL, NULL),
	(78, 2, 278, 0, NULL, NULL, NULL, NULL, NULL),
	(79, 2, 537, 0, NULL, NULL, NULL, NULL, NULL),
	(80, 2, 289, 0, NULL, NULL, NULL, NULL, NULL),
	(81, 2, 432, 0, NULL, NULL, NULL, NULL, NULL),
	(82, 2, 292, 0, NULL, NULL, NULL, NULL, NULL),
	(83, 2, 538, 0, NULL, NULL, NULL, NULL, NULL),
	(84, 2, 293, 0, NULL, NULL, NULL, NULL, NULL),
	(85, 2, 487, 0, NULL, NULL, NULL, NULL, NULL),
	(86, 2, 367, 0, NULL, NULL, NULL, NULL, NULL),
	(87, 2, 296, 0, NULL, NULL, NULL, NULL, NULL),
	(88, 2, 402, 0, NULL, NULL, NULL, NULL, NULL),
	(89, 2, 303, 0, NULL, NULL, NULL, NULL, NULL),
	(90, 2, 439, 0, NULL, NULL, NULL, NULL, NULL),
	(91, 2, 308, 0, NULL, NULL, NULL, NULL, NULL),
	(92, 2, 539, 0, NULL, NULL, NULL, NULL, NULL),
	(93, 2, 310, 0, NULL, NULL, NULL, NULL, NULL),
	(94, 2, 312, 0, NULL, NULL, NULL, NULL, NULL),
	(95, 2, 313, 0, NULL, NULL, NULL, NULL, NULL),
	(96, 2, 540, 0, NULL, NULL, NULL, NULL, NULL),
	(97, 2, 541, 0, NULL, NULL, NULL, NULL, NULL),
	(98, 2, 542, 0, NULL, NULL, NULL, NULL, NULL),
	(99, 2, 543, 0, NULL, NULL, NULL, NULL, NULL),
	(100, 2, 459, 0, NULL, NULL, NULL, NULL, NULL),
	(101, 2, 330, 0, NULL, NULL, NULL, NULL, NULL),
	(102, 2, 331, 0, NULL, NULL, NULL, NULL, NULL),
	(103, 2, 419, 0, NULL, NULL, NULL, NULL, NULL),
	(104, 2, 460, 0, NULL, NULL, NULL, NULL, NULL),
	(105, 2, 461, 0, NULL, NULL, NULL, NULL, NULL),
	(106, 2, 420, 0, NULL, NULL, NULL, NULL, NULL),
	(107, 2, 385, 0, NULL, NULL, NULL, NULL, NULL),
	(108, 2, 386, 0, NULL, NULL, NULL, NULL, NULL),
	(109, 2, 387, 0, NULL, NULL, NULL, NULL, NULL),
	(110, 2, 339, 0, NULL, NULL, NULL, NULL, NULL),
	(111, 2, 544, 0, NULL, NULL, NULL, NULL, NULL),
	(112, 2, 392, 0, NULL, NULL, NULL, NULL, NULL),
	(113, 2, 550, 0, NULL, NULL, NULL, NULL, NULL),
	(114, 3, 472, 0, NULL, NULL, NULL, NULL, NULL),
	(115, 3, 277, 90000, NULL, NULL, NULL, NULL, NULL),
	(116, 3, 473, 0, NULL, NULL, NULL, NULL, NULL),
	(117, 3, 425, 0, NULL, NULL, NULL, NULL, NULL),
	(118, 3, 390, 0, NULL, NULL, NULL, NULL, NULL),
	(119, 3, 474, 0, NULL, NULL, NULL, NULL, NULL),
	(120, 3, 353, 0, NULL, NULL, NULL, NULL, NULL),
	(121, 3, 354, 0, NULL, NULL, NULL, NULL, NULL),
	(122, 3, 475, 0, NULL, NULL, NULL, NULL, NULL),
	(123, 3, 279, 0, NULL, NULL, NULL, NULL, NULL),
	(124, 3, 280, 0, NULL, NULL, NULL, NULL, NULL),
	(125, 3, 281, 0, NULL, NULL, NULL, NULL, NULL),
	(126, 3, 283, NULL, NULL, NULL, NULL, NULL, NULL),
	(127, 3, 476, 0, NULL, NULL, NULL, NULL, NULL),
	(128, 3, 287, 0, NULL, NULL, NULL, NULL, NULL),
	(129, 3, 477, 0, NULL, NULL, NULL, NULL, NULL),
	(130, 3, 391, 0, NULL, NULL, NULL, NULL, NULL),
	(131, 3, 478, 0, NULL, NULL, NULL, NULL, NULL),
	(132, 3, 392, 0, NULL, NULL, NULL, NULL, NULL),
	(133, 3, 479, 0, NULL, NULL, NULL, NULL, NULL),
	(134, 3, 480, 0, NULL, NULL, NULL, NULL, NULL),
	(135, 3, 481, 0, NULL, NULL, NULL, NULL, NULL),
	(136, 3, 482, 0, NULL, NULL, NULL, NULL, NULL),
	(137, 3, 483, 0, NULL, NULL, NULL, NULL, NULL),
	(138, 3, 289, 0, NULL, NULL, NULL, NULL, NULL),
	(139, 3, 484, 0, NULL, NULL, NULL, NULL, NULL),
	(140, 3, 362, 0, NULL, NULL, NULL, NULL, NULL),
	(141, 3, 431, 0, NULL, NULL, NULL, NULL, NULL),
	(142, 3, 290, NULL, NULL, NULL, NULL, NULL, NULL),
	(143, 3, 432, 0, NULL, NULL, NULL, NULL, NULL),
	(144, 3, 485, 0, NULL, NULL, NULL, NULL, NULL),
	(145, 3, 486, 0, NULL, NULL, NULL, NULL, NULL),
	(146, 3, 365, 0, NULL, NULL, NULL, NULL, NULL),
	(147, 3, 487, 0, NULL, NULL, NULL, NULL, NULL),
	(148, 3, 294, 0, NULL, NULL, NULL, NULL, NULL),
	(149, 3, 488, 0, NULL, NULL, NULL, NULL, NULL),
	(150, 3, 399, 0, NULL, NULL, NULL, NULL, NULL),
	(151, 3, 489, 0, NULL, NULL, NULL, NULL, NULL),
	(152, 3, 490, 0, NULL, NULL, NULL, NULL, NULL),
	(153, 3, 434, NULL, NULL, NULL, NULL, NULL, NULL),
	(154, 3, 491, 0, NULL, NULL, NULL, NULL, NULL),
	(155, 3, 298, 0, NULL, NULL, NULL, NULL, NULL),
	(156, 3, 299, 56250, NULL, NULL, NULL, NULL, NULL),
	(157, 3, 492, 0, NULL, NULL, NULL, NULL, NULL),
	(158, 3, 493, 0, NULL, NULL, NULL, NULL, NULL),
	(159, 3, 494, 0, NULL, NULL, NULL, NULL, NULL),
	(160, 3, 495, 0, NULL, NULL, NULL, NULL, NULL),
	(161, 3, 496, 0, NULL, NULL, NULL, NULL, NULL),
	(162, 3, 497, 0, NULL, NULL, NULL, NULL, NULL),
	(163, 3, 498, 0, NULL, NULL, NULL, NULL, NULL),
	(164, 3, 437, 0, NULL, NULL, NULL, NULL, NULL),
	(165, 3, 499, 0, NULL, NULL, NULL, NULL, NULL),
	(166, 3, 303, 0, NULL, NULL, NULL, NULL, NULL),
	(167, 3, 374, 0, NULL, NULL, NULL, NULL, NULL),
	(168, 3, 500, 0, NULL, NULL, NULL, NULL, NULL),
	(169, 3, 404, 0, NULL, NULL, NULL, NULL, NULL),
	(170, 3, 405, 0, NULL, NULL, NULL, NULL, NULL),
	(171, 3, 501, 0, NULL, NULL, NULL, NULL, NULL),
	(172, 3, 502, 0, NULL, NULL, NULL, NULL, NULL),
	(173, 3, 375, 0, NULL, NULL, NULL, NULL, NULL),
	(174, 3, 503, 0, NULL, NULL, NULL, NULL, NULL),
	(175, 3, 504, 0, NULL, NULL, NULL, NULL, NULL),
	(176, 3, 505, 0, NULL, NULL, NULL, NULL, NULL),
	(177, 3, 506, 0, NULL, NULL, NULL, NULL, NULL),
	(178, 3, 507, 0, NULL, NULL, NULL, NULL, NULL),
	(179, 3, 442, 0, NULL, NULL, NULL, NULL, NULL),
	(180, 3, 310, 0, NULL, NULL, NULL, NULL, NULL),
	(181, 3, 508, 0, NULL, NULL, NULL, NULL, NULL),
	(182, 3, 407, 0, NULL, NULL, NULL, NULL, NULL),
	(183, 3, 509, 0, NULL, NULL, NULL, NULL, NULL),
	(184, 3, 510, 0, NULL, NULL, NULL, NULL, NULL),
	(185, 3, 446, 0, NULL, NULL, NULL, NULL, NULL),
	(186, 3, 312, 0, NULL, NULL, NULL, NULL, NULL),
	(187, 3, 316, 0, NULL, NULL, NULL, NULL, NULL),
	(188, 3, 511, 0, NULL, NULL, NULL, NULL, NULL),
	(189, 3, 512, 0, NULL, NULL, NULL, NULL, NULL),
	(190, 3, 411, 0, NULL, NULL, NULL, NULL, NULL),
	(191, 3, 451, 0, NULL, NULL, NULL, NULL, NULL),
	(192, 3, 415, 0, NULL, NULL, NULL, NULL, NULL),
	(193, 3, 380, 0, NULL, NULL, NULL, NULL, NULL),
	(194, 3, 513, 0, NULL, NULL, NULL, NULL, NULL),
	(195, 3, 514, 0, NULL, NULL, NULL, NULL, NULL),
	(196, 3, 515, 0, NULL, NULL, NULL, NULL, NULL),
	(197, 3, 516, 0, NULL, NULL, NULL, NULL, NULL),
	(198, 3, 517, 0, NULL, NULL, NULL, NULL, NULL),
	(199, 3, 518, 0, NULL, NULL, NULL, NULL, NULL),
	(200, 3, 519, 0, NULL, NULL, NULL, NULL, NULL),
	(201, 3, 520, 0, NULL, NULL, NULL, NULL, NULL),
	(202, 3, 521, 0, NULL, NULL, NULL, NULL, NULL),
	(203, 3, 382, 0, NULL, NULL, NULL, NULL, NULL),
	(204, 3, 522, 0, NULL, NULL, NULL, NULL, NULL),
	(205, 3, 523, 0, NULL, NULL, NULL, NULL, NULL),
	(206, 3, 524, 0, NULL, NULL, NULL, NULL, NULL),
	(207, 3, 330, 0, NULL, NULL, NULL, NULL, NULL),
	(208, 3, 331, 0, NULL, NULL, NULL, NULL, NULL),
	(209, 3, 525, 0, NULL, NULL, NULL, NULL, NULL),
	(210, 3, 526, 0, NULL, NULL, NULL, NULL, NULL),
	(211, 3, 527, 0, NULL, NULL, NULL, NULL, NULL),
	(212, 3, 528, 0, NULL, NULL, NULL, NULL, NULL),
	(213, 3, 529, 0, NULL, NULL, NULL, NULL, NULL),
	(214, 3, 530, 0, NULL, NULL, NULL, NULL, NULL),
	(215, 3, 463, 0, NULL, NULL, NULL, NULL, NULL),
	(216, 3, 464, 0, NULL, NULL, NULL, NULL, NULL),
	(217, 3, 466, 0, NULL, NULL, NULL, NULL, NULL),
	(218, 3, 531, 0, NULL, NULL, NULL, NULL, NULL),
	(219, 3, 420, 0, NULL, NULL, NULL, NULL, NULL),
	(220, 3, 532, 0, NULL, NULL, NULL, NULL, NULL),
	(221, 3, 533, 0, NULL, NULL, NULL, NULL, NULL),
	(222, 3, 470, NULL, NULL, NULL, NULL, NULL, NULL),
	(223, 3, 534, 0, NULL, NULL, NULL, NULL, NULL),
	(224, 3, 535, 0, NULL, NULL, NULL, NULL, NULL),
	(225, 3, 344, 0, NULL, NULL, NULL, NULL, NULL),
	(226, 3, 536, 0, NULL, NULL, NULL, NULL, NULL),
	(227, 3, 308, 0, NULL, NULL, NULL, NULL, NULL),
	(228, 4, 277, 70000, NULL, 'Yes', NULL, NULL, NULL),
	(229, 4, 425, 0, NULL, NULL, NULL, NULL, NULL),
	(230, 4, 426, 0, NULL, NULL, NULL, NULL, NULL),
	(231, 4, 390, 0, NULL, NULL, NULL, NULL, NULL),
	(232, 4, 354, 0, NULL, NULL, NULL, NULL, NULL),
	(233, 4, 279, 0, NULL, NULL, NULL, NULL, NULL),
	(234, 4, 280, 0, NULL, NULL, NULL, NULL, NULL),
	(235, 4, 427, 0, NULL, NULL, NULL, NULL, NULL),
	(236, 4, 428, 0, NULL, NULL, NULL, NULL, NULL),
	(237, 4, 282, NULL, NULL, NULL, NULL, NULL, NULL),
	(238, 4, 283, NULL, NULL, NULL, NULL, NULL, NULL),
	(239, 4, 284, 0, NULL, NULL, NULL, NULL, NULL),
	(240, 4, 287, 0, NULL, NULL, NULL, NULL, NULL),
	(241, 4, 392, 0, NULL, NULL, NULL, NULL, NULL),
	(242, 4, 358, 0, NULL, NULL, NULL, NULL, NULL),
	(243, 4, 429, 0, NULL, NULL, NULL, NULL, NULL),
	(244, 4, 360, 0, NULL, NULL, NULL, NULL, NULL),
	(245, 4, 430, 0, NULL, NULL, NULL, NULL, NULL),
	(246, 4, 362, NULL, NULL, NULL, NULL, NULL, NULL),
	(247, 4, 431, 0, NULL, NULL, NULL, NULL, NULL),
	(248, 4, 290, 110000, NULL, NULL, NULL, NULL, NULL),
	(249, 4, 432, 0, NULL, NULL, NULL, NULL, NULL),
	(250, 4, 292, 0, NULL, NULL, NULL, NULL, NULL),
	(251, 4, 365, 0, NULL, NULL, NULL, NULL, NULL),
	(252, 4, 293, 0, NULL, NULL, NULL, NULL, NULL),
	(253, 4, 398, 0, NULL, NULL, NULL, NULL, NULL),
	(254, 4, 399, 0, NULL, NULL, NULL, NULL, NULL),
	(255, 4, 296, NULL, NULL, NULL, NULL, NULL, NULL),
	(256, 4, 433, 0, NULL, NULL, NULL, NULL, NULL),
	(257, 4, 434, NULL, NULL, NULL, NULL, NULL, NULL),
	(258, 4, 298, 0, NULL, NULL, NULL, NULL, NULL),
	(259, 4, 402, 0, NULL, NULL, NULL, NULL, NULL),
	(260, 4, 300, 0, NULL, NULL, NULL, NULL, NULL),
	(261, 4, 435, 0, NULL, NULL, NULL, NULL, NULL),
	(262, 4, 436, 0, NULL, NULL, NULL, NULL, NULL),
	(263, 4, 437, 0, NULL, NULL, NULL, NULL, NULL),
	(264, 4, 438, 0, NULL, NULL, NULL, NULL, NULL),
	(265, 4, 403, 0, NULL, NULL, NULL, NULL, NULL),
	(266, 4, 303, 0, NULL, NULL, NULL, NULL, NULL),
	(267, 4, 374, 0, NULL, NULL, NULL, NULL, NULL),
	(268, 4, 439, 0, NULL, NULL, NULL, NULL, NULL),
	(269, 4, 376, 0, NULL, NULL, NULL, NULL, NULL),
	(270, 4, 440, 0, NULL, NULL, NULL, NULL, NULL),
	(271, 4, 441, 0, NULL, NULL, NULL, NULL, NULL),
	(272, 4, 442, 0, NULL, NULL, NULL, NULL, NULL),
	(273, 4, 443, 0, NULL, NULL, NULL, NULL, NULL),
	(274, 4, 444, 205000, NULL, NULL, NULL, NULL, NULL),
	(275, 4, 445, 0, NULL, NULL, NULL, NULL, NULL),
	(276, 4, 407, 0, NULL, NULL, NULL, NULL, NULL),
	(277, 4, 446, 0, NULL, NULL, NULL, NULL, NULL),
	(278, 4, 312, 0, NULL, NULL, NULL, NULL, NULL),
	(279, 4, 313, 0, NULL, NULL, NULL, NULL, NULL),
	(280, 4, 316, 0, NULL, NULL, NULL, NULL, NULL),
	(281, 4, 447, 0, NULL, NULL, NULL, NULL, NULL),
	(282, 4, 409, 0, NULL, NULL, NULL, NULL, NULL),
	(283, 4, 448, 0, NULL, NULL, NULL, NULL, NULL),
	(284, 4, 449, 0, NULL, NULL, NULL, NULL, NULL),
	(285, 4, 450, 0, NULL, NULL, NULL, NULL, NULL),
	(286, 4, 410, 0, NULL, NULL, NULL, NULL, NULL),
	(287, 4, 412, 0, NULL, NULL, NULL, NULL, NULL),
	(288, 4, 413, 0, NULL, NULL, NULL, NULL, NULL),
	(289, 4, 451, 0, NULL, NULL, NULL, NULL, NULL),
	(290, 4, 415, 0, NULL, NULL, NULL, NULL, NULL),
	(291, 4, 380, 0, NULL, NULL, NULL, NULL, NULL),
	(292, 4, 452, 0, NULL, NULL, NULL, NULL, NULL),
	(293, 4, 453, 0, NULL, NULL, NULL, NULL, NULL),
	(294, 4, 454, 0, NULL, NULL, NULL, NULL, NULL),
	(295, 4, 327, 50000, NULL, NULL, NULL, NULL, NULL),
	(296, 4, 455, 0, NULL, NULL, NULL, NULL, NULL),
	(297, 4, 456, 0, NULL, NULL, NULL, NULL, NULL),
	(298, 4, 457, 0, NULL, NULL, NULL, NULL, NULL),
	(299, 4, 458, 0, NULL, NULL, NULL, NULL, NULL),
	(300, 4, 459, 0, NULL, NULL, NULL, NULL, NULL),
	(301, 4, 330, 0, NULL, NULL, NULL, NULL, NULL),
	(302, 4, 331, 0, NULL, NULL, NULL, NULL, NULL),
	(303, 4, 460, 0, NULL, NULL, NULL, NULL, NULL),
	(304, 4, 461, 0, NULL, NULL, NULL, NULL, NULL),
	(305, 4, 462, 0, NULL, NULL, NULL, NULL, NULL),
	(306, 4, 463, 0, NULL, NULL, NULL, NULL, NULL),
	(307, 4, 464, 0, NULL, NULL, NULL, NULL, NULL),
	(308, 4, 465, 0, NULL, NULL, NULL, NULL, NULL),
	(309, 4, 466, 0, NULL, NULL, NULL, NULL, NULL),
	(310, 4, 420, 0, NULL, NULL, NULL, NULL, NULL),
	(311, 4, 467, 0, NULL, NULL, NULL, NULL, NULL),
	(312, 4, 468, 0, NULL, NULL, NULL, NULL, NULL),
	(313, 4, 385, NULL, NULL, NULL, NULL, NULL, NULL),
	(314, 4, 470, NULL, NULL, NULL, NULL, NULL, NULL),
	(315, 4, 339, 120000, NULL, NULL, NULL, NULL, NULL),
	(316, 4, 422, 0, NULL, NULL, NULL, NULL, NULL),
	(317, 4, 344, 0, NULL, NULL, NULL, NULL, NULL),
	(318, 4, 471, 0, NULL, NULL, NULL, NULL, NULL),
	(319, 4, 340, 0, NULL, NULL, NULL, NULL, NULL),
	(320, 4, 308, 0, NULL, NULL, NULL, NULL, NULL),
	(321, 5, 277, 18000, NULL, 'Yes', NULL, NULL, NULL),
	(322, 5, 389, 0, NULL, NULL, NULL, NULL, NULL),
	(323, 5, 390, 0, NULL, NULL, NULL, NULL, NULL),
	(324, 5, 353, 0, NULL, NULL, NULL, NULL, NULL),
	(325, 5, 354, 0, NULL, NULL, NULL, NULL, NULL),
	(326, 5, 279, 0, NULL, NULL, NULL, NULL, NULL),
	(327, 5, 280, 0, NULL, NULL, NULL, NULL, NULL),
	(328, 5, 281, 0, NULL, NULL, NULL, NULL, NULL),
	(329, 5, 282, NULL, NULL, NULL, NULL, NULL, NULL),
	(330, 5, 283, 0, NULL, NULL, NULL, NULL, NULL),
	(331, 5, 285, 0, NULL, NULL, NULL, NULL, NULL),
	(332, 5, 287, 0, NULL, NULL, NULL, NULL, NULL),
	(333, 5, 391, 0, NULL, NULL, NULL, NULL, NULL),
	(334, 5, 356, 0, NULL, NULL, NULL, NULL, NULL),
	(335, 5, 392, 0, NULL, NULL, NULL, NULL, NULL),
	(336, 5, 360, 0, NULL, NULL, NULL, NULL, NULL),
	(337, 5, 393, 0, NULL, NULL, NULL, NULL, NULL),
	(338, 5, 289, 0, NULL, NULL, NULL, NULL, NULL),
	(339, 5, 394, 0, NULL, NULL, NULL, NULL, NULL),
	(340, 5, 362, 0, NULL, NULL, NULL, NULL, NULL),
	(341, 5, 363, 0, NULL, NULL, NULL, NULL, NULL),
	(342, 5, 396, 0, NULL, NULL, NULL, NULL, NULL),
	(343, 5, 292, 0, NULL, NULL, NULL, NULL, NULL),
	(344, 5, 397, 0, NULL, NULL, NULL, NULL, NULL),
	(345, 5, 293, 0, NULL, NULL, NULL, NULL, NULL),
	(346, 5, 398, 0, NULL, NULL, NULL, NULL, NULL),
	(347, 5, 399, 0, NULL, NULL, NULL, NULL, NULL),
	(348, 5, 400, 0, NULL, NULL, NULL, NULL, NULL),
	(349, 5, 295, 0, NULL, NULL, NULL, NULL, NULL),
	(350, 5, 296, NULL, NULL, NULL, NULL, NULL, NULL),
	(351, 5, 297, 12000, NULL, NULL, NULL, NULL, NULL),
	(352, 5, 401, 0, NULL, NULL, NULL, NULL, NULL),
	(353, 5, 299, 9600, NULL, NULL, NULL, NULL, NULL),
	(354, 5, 402, 0, NULL, NULL, NULL, NULL, NULL),
	(355, 5, 300, 0, NULL, NULL, NULL, NULL, NULL),
	(356, 5, 301, 0, NULL, NULL, NULL, NULL, NULL),
	(357, 5, 403, 0, NULL, NULL, NULL, NULL, NULL),
	(358, 5, 303, 0, NULL, NULL, NULL, NULL, NULL),
	(359, 5, 404, 0, NULL, NULL, NULL, NULL, NULL),
	(360, 5, 405, 0, NULL, NULL, NULL, NULL, NULL),
	(361, 5, 306, 0, NULL, NULL, NULL, NULL, NULL),
	(362, 5, 406, 0, NULL, NULL, NULL, NULL, NULL),
	(363, 5, 310, 0, NULL, NULL, NULL, NULL, NULL),
	(364, 5, 378, 0, NULL, NULL, NULL, NULL, NULL),
	(365, 5, 407, 0, NULL, NULL, NULL, NULL, NULL),
	(366, 5, 312, 0, NULL, NULL, NULL, NULL, NULL),
	(367, 5, 313, 0, NULL, NULL, NULL, NULL, NULL),
	(368, 5, 408, 0, NULL, NULL, NULL, NULL, NULL),
	(369, 5, 315, 0, NULL, NULL, NULL, NULL, NULL),
	(370, 5, 316, 0, NULL, NULL, NULL, NULL, NULL),
	(371, 5, 409, 0, NULL, NULL, NULL, NULL, NULL),
	(372, 5, 410, 0, NULL, NULL, NULL, NULL, NULL),
	(373, 5, 411, 0, NULL, NULL, NULL, NULL, NULL),
	(374, 5, 412, 0, NULL, NULL, NULL, NULL, NULL),
	(375, 5, 413, 0, NULL, NULL, NULL, NULL, NULL),
	(376, 5, 414, 0, NULL, NULL, NULL, NULL, NULL),
	(377, 5, 415, 0, NULL, NULL, NULL, NULL, NULL),
	(378, 5, 380, 0, NULL, NULL, NULL, NULL, NULL),
	(379, 5, 319, 0, NULL, NULL, NULL, NULL, NULL),
	(380, 5, 321, 0, NULL, NULL, NULL, NULL, NULL),
	(381, 5, 322, 0, NULL, NULL, NULL, NULL, NULL),
	(382, 5, 416, 0, NULL, NULL, NULL, NULL, NULL),
	(383, 5, 417, 0, NULL, NULL, NULL, NULL, NULL),
	(384, 5, 418, 0, NULL, NULL, NULL, NULL, NULL),
	(385, 5, 419, 0, NULL, NULL, NULL, NULL, NULL),
	(386, 5, 420, 0, NULL, NULL, NULL, NULL, NULL),
	(387, 5, 385, NULL, NULL, NULL, NULL, NULL, NULL),
	(388, 5, 422, 0, NULL, NULL, NULL, NULL, NULL),
	(389, 5, 423, 0, NULL, NULL, NULL, NULL, NULL),
	(390, 5, 345, 0, NULL, NULL, NULL, NULL, NULL),
	(391, 5, 424, 0, NULL, NULL, NULL, NULL, NULL),
	(392, 5, 290, 51360, NULL, NULL, NULL, NULL, NULL),
	(393, 5, 531, 0, NULL, NULL, NULL, NULL, NULL),
	(394, 5, 308, 0, NULL, NULL, NULL, NULL, NULL),
	(395, 6, 349, 0, NULL, NULL, NULL, NULL, NULL),
	(396, 6, 277, 35000, '35011', NULL, NULL, NULL, NULL),
	(397, 6, 350, 21000, '21000', NULL, NULL, NULL, NULL),
	(398, 6, 351, 0, NULL, NULL, NULL, NULL, NULL),
	(399, 6, 352, 0, NULL, NULL, NULL, NULL, NULL),
	(400, 6, 353, 0, NULL, NULL, NULL, NULL, NULL),
	(401, 6, 354, 0, NULL, NULL, NULL, NULL, NULL),
	(402, 6, 278, 0, NULL, NULL, NULL, NULL, NULL),
	(403, 6, 279, 0, NULL, NULL, NULL, NULL, NULL),
	(404, 6, 281, 0, NULL, NULL, NULL, NULL, NULL),
	(405, 6, 355, 0, NULL, NULL, NULL, NULL, NULL),
	(406, 6, 282, NULL, NULL, NULL, NULL, NULL, NULL),
	(407, 6, 283, NULL, NULL, NULL, NULL, NULL, NULL),
	(408, 6, 285, 0, NULL, NULL, NULL, NULL, NULL),
	(409, 6, 287, 0, NULL, NULL, NULL, NULL, NULL),
	(410, 6, 356, 0, NULL, NULL, NULL, NULL, NULL),
	(411, 6, 357, 0, NULL, NULL, NULL, NULL, NULL),
	(412, 6, 359, 0, NULL, NULL, NULL, NULL, NULL),
	(413, 6, 288, 0, NULL, NULL, NULL, NULL, NULL),
	(414, 6, 360, 0, NULL, NULL, NULL, NULL, NULL),
	(415, 6, 361, 16800, '16801', NULL, NULL, NULL, NULL),
	(416, 6, 289, 0, NULL, NULL, NULL, NULL, NULL),
	(417, 6, 362, 0, NULL, NULL, NULL, NULL, NULL),
	(418, 6, 363, 0, NULL, NULL, NULL, NULL, NULL),
	(419, 6, 364, 0, NULL, NULL, NULL, NULL, NULL),
	(420, 6, 365, 0, NULL, NULL, NULL, NULL, NULL),
	(421, 6, 294, 0, NULL, NULL, NULL, NULL, NULL),
	(422, 6, 366, 0, NULL, NULL, NULL, NULL, NULL),
	(423, 6, 367, 0, NULL, NULL, NULL, NULL, NULL),
	(424, 6, 368, 0, NULL, NULL, NULL, NULL, NULL),
	(425, 6, 369, 0, NULL, NULL, NULL, NULL, NULL),
	(426, 6, 370, 0, NULL, NULL, NULL, NULL, NULL),
	(427, 6, 371, 0, NULL, NULL, NULL, NULL, NULL),
	(428, 6, 372, 0, NULL, NULL, NULL, NULL, NULL),
	(429, 6, 373, 0, NULL, NULL, NULL, NULL, NULL),
	(430, 6, 374, 0, NULL, NULL, NULL, NULL, NULL),
	(431, 6, 375, 0, NULL, NULL, NULL, NULL, NULL),
	(432, 6, 376, 0, NULL, NULL, NULL, NULL, NULL),
	(433, 6, 377, 0, NULL, NULL, NULL, NULL, NULL),
	(434, 6, 378, 0, NULL, NULL, NULL, NULL, NULL),
	(435, 6, 379, 0, NULL, NULL, NULL, NULL, NULL),
	(436, 6, 316, 0, NULL, NULL, NULL, NULL, NULL),
	(437, 6, 380, 0, NULL, NULL, NULL, NULL, NULL),
	(438, 6, 381, 0, NULL, NULL, NULL, NULL, NULL),
	(439, 6, 382, 0, NULL, NULL, NULL, NULL, NULL),
	(440, 6, 383, 0, NULL, NULL, NULL, NULL, NULL),
	(441, 6, 384, 0, NULL, NULL, NULL, NULL, NULL),
	(442, 6, 385, NULL, NULL, NULL, NULL, NULL, NULL),
	(443, 6, 386, 0, NULL, NULL, NULL, NULL, NULL),
	(444, 6, 387, 0, NULL, NULL, NULL, NULL, NULL),
	(445, 6, 388, 0, NULL, NULL, NULL, NULL, NULL),
	(446, 6, 340, 0, NULL, NULL, NULL, NULL, NULL),
	(447, 6, 308, 0, NULL, NULL, NULL, NULL, NULL),
	(448, 6, 274, NULL, '75001', 'No', '2021-01-23 10:34:07', NULL, NULL),
	(449, 3, 274, 449999, NULL, 'Yes', NULL, NULL, NULL),
	(450, 5, 274, NULL, NULL, 'Yes', '2021-01-23 13:49:04', NULL, NULL),
	(451, 2, 274, 0, NULL, NULL, NULL, NULL, NULL),
	(452, 4, 274, 375000, NULL, 'No', '2021-01-23 13:49:03', NULL, NULL),
	(454, 7, 276, 0, NULL, NULL, NULL, NULL, NULL),
	(455, 7, 277, 28000, '28000', 'Yes', NULL, 2, NULL),
	(456, 7, 278, 0, NULL, NULL, NULL, NULL, NULL),
	(457, 7, 279, 0, NULL, NULL, NULL, NULL, NULL),
	(458, 7, 280, 0, NULL, NULL, NULL, NULL, NULL),
	(459, 7, 281, NULL, NULL, NULL, NULL, NULL, NULL),
	(460, 7, 282, NULL, '0', NULL, NULL, NULL, NULL),
	(461, 7, 283, 16500, '16500', NULL, NULL, NULL, NULL),
	(462, 7, 284, 0, NULL, NULL, NULL, NULL, NULL),
	(463, 7, 285, 0, NULL, NULL, NULL, NULL, NULL),
	(464, 7, 286, 0, NULL, NULL, NULL, NULL, NULL),
	(465, 7, 287, 0, NULL, NULL, NULL, NULL, NULL),
	(466, 7, 288, 0, NULL, NULL, NULL, NULL, NULL),
	(467, 7, 289, 0, NULL, NULL, NULL, NULL, NULL),
	(468, 7, 290, NULL, NULL, NULL, NULL, NULL, NULL),
	(469, 7, 291, 0, NULL, NULL, NULL, NULL, NULL),
	(470, 7, 292, 0, NULL, NULL, NULL, NULL, NULL),
	(471, 7, 293, 0, NULL, NULL, NULL, NULL, NULL),
	(472, 7, 294, 0, NULL, NULL, NULL, NULL, NULL),
	(473, 7, 295, 0, NULL, NULL, NULL, NULL, NULL),
	(474, 7, 296, 17000, '17000', NULL, NULL, NULL, NULL),
	(475, 7, 297, 16000, '16000', NULL, NULL, NULL, NULL),
	(476, 7, 298, 0, NULL, NULL, NULL, NULL, NULL),
	(477, 7, 299, NULL, NULL, NULL, NULL, NULL, NULL),
	(478, 7, 300, 0, NULL, NULL, NULL, NULL, NULL),
	(479, 7, 301, 0, NULL, NULL, NULL, NULL, NULL),
	(480, 7, 302, 0, NULL, NULL, NULL, NULL, NULL),
	(481, 7, 303, 0, NULL, NULL, NULL, NULL, NULL),
	(482, 7, 304, 0, NULL, NULL, NULL, NULL, NULL),
	(483, 7, 305, 0, NULL, NULL, NULL, NULL, NULL),
	(484, 7, 306, 16000, '16000', NULL, NULL, NULL, NULL),
	(485, 7, 307, 0, NULL, NULL, NULL, NULL, NULL),
	(486, 7, 308, 0, NULL, NULL, NULL, NULL, NULL),
	(487, 7, 309, 0, NULL, NULL, NULL, NULL, NULL),
	(488, 7, 310, NULL, NULL, NULL, NULL, NULL, NULL),
	(489, 7, 311, 0, NULL, NULL, NULL, NULL, NULL),
	(490, 7, 312, 0, NULL, NULL, NULL, NULL, NULL),
	(491, 7, 313, 0, NULL, NULL, NULL, NULL, NULL),
	(492, 7, 314, 24000, '24000', NULL, NULL, 3, NULL),
	(493, 7, 315, 0, NULL, NULL, NULL, NULL, NULL),
	(494, 7, 316, 0, NULL, NULL, NULL, NULL, NULL),
	(495, 7, 317, 0, NULL, NULL, NULL, NULL, NULL),
	(496, 7, 318, 0, NULL, NULL, NULL, NULL, NULL),
	(497, 7, 319, 0, NULL, NULL, NULL, NULL, NULL),
	(498, 7, 320, 16000, '16000', NULL, NULL, NULL, NULL),
	(499, 7, 321, 0, NULL, NULL, NULL, NULL, NULL),
	(500, 7, 322, 0, NULL, NULL, NULL, NULL, NULL),
	(501, 7, 323, 0, NULL, NULL, NULL, NULL, NULL),
	(502, 7, 324, 0, NULL, NULL, NULL, NULL, NULL),
	(503, 7, 325, 0, NULL, NULL, NULL, NULL, NULL),
	(504, 7, 326, 0, NULL, NULL, NULL, NULL, NULL),
	(505, 7, 327, 16000, '16000', NULL, NULL, NULL, NULL),
	(506, 7, 328, 0, NULL, NULL, NULL, NULL, NULL),
	(507, 7, 329, 0, NULL, NULL, NULL, NULL, NULL),
	(508, 7, 330, 0, NULL, NULL, NULL, NULL, NULL),
	(509, 7, 331, 0, NULL, NULL, NULL, NULL, NULL),
	(510, 7, 332, 0, NULL, NULL, NULL, NULL, NULL),
	(511, 7, 333, 16000, NULL, NULL, NULL, NULL, NULL),
	(512, 7, 334, 0, NULL, NULL, NULL, NULL, NULL),
	(513, 7, 335, 20000, '20000', NULL, NULL, NULL, NULL),
	(514, 7, 336, 0, NULL, NULL, NULL, NULL, NULL),
	(515, 7, 337, 0, NULL, NULL, NULL, NULL, NULL),
	(516, 7, 338, 0, NULL, NULL, NULL, NULL, NULL),
	(517, 7, 339, 50000, '50000', 'Yes', NULL, 1, 4),
	(518, 7, 340, 0, NULL, NULL, NULL, NULL, NULL),
	(519, 7, 341, 0, NULL, NULL, NULL, NULL, NULL),
	(520, 7, 342, 0, NULL, NULL, NULL, NULL, NULL),
	(521, 7, 343, 0, NULL, NULL, NULL, NULL, NULL),
	(522, 7, 344, 0, NULL, NULL, NULL, NULL, NULL),
	(523, 7, 345, 0, NULL, NULL, NULL, NULL, NULL),
	(524, 7, 346, 0, NULL, NULL, NULL, NULL, NULL),
	(525, 7, 347, 0, NULL, NULL, NULL, NULL, NULL),
	(526, 7, 348, 0, NULL, NULL, NULL, NULL, NULL),
	(527, 7, 392, 0, NULL, NULL, NULL, NULL, NULL),
	(528, 7, 534, 0, NULL, NULL, NULL, NULL, NULL),
	(529, 7, 426, 0, NULL, NULL, NULL, NULL, NULL),
	(530, 7, 547, 0, NULL, NULL, NULL, NULL, NULL),
	(531, 8, 549, 0, NULL, NULL, NULL, NULL, NULL),
	(532, 8, 290, 0, NULL, NULL, NULL, NULL, NULL),
	(533, 8, 274, 0, NULL, NULL, NULL, NULL, NULL),
	(534, 8, 402, 0, NULL, NULL, NULL, NULL, NULL),
	(535, 8, 398, 0, NULL, NULL, NULL, NULL, NULL),
	(536, 8, 337, 0, NULL, NULL, NULL, NULL, NULL),
	(537, 8, 303, 0, NULL, NULL, NULL, NULL, NULL),
	(538, 8, 401, 0, NULL, NULL, NULL, NULL, NULL),
	(539, 8, 343, 0, NULL, NULL, NULL, NULL, NULL),
	(540, 8, 525, 0, NULL, NULL, NULL, NULL, NULL),
	(541, 8, 296, 0, NULL, NULL, NULL, NULL, NULL),
	(542, 8, 330, 0, NULL, NULL, NULL, NULL, NULL),
	(543, 8, 331, 0, NULL, NULL, NULL, NULL, NULL),
	(544, 8, 283, 0, NULL, NULL, NULL, NULL, NULL),
	(545, 8, 310, 0, NULL, NULL, NULL, NULL, NULL),
	(546, 8, 292, 0, NULL, NULL, NULL, NULL, NULL),
	(547, 8, 504, 0, NULL, NULL, NULL, NULL, NULL),
	(548, 8, 282, 0, NULL, NULL, NULL, NULL, NULL),
	(549, 8, 339, 0, NULL, NULL, NULL, NULL, NULL),
	(550, 8, 297, 0, NULL, NULL, NULL, NULL, NULL),
	(551, 8, 281, 0, NULL, NULL, NULL, NULL, NULL),
	(552, 8, 293, 0, NULL, NULL, NULL, NULL, NULL),
	(553, 8, 407, 0, NULL, NULL, NULL, NULL, NULL),
	(554, 8, 306, 0, NULL, NULL, NULL, NULL, NULL),
	(555, 7, 274, 190000, '359999', 'No', '2021-01-23 13:49:01', 4, NULL);

-- Dumping structure for table harcourt.import
CREATE TABLE IF NOT EXISTS `import` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `pub_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_9D4ECE1DA76ED395` (`user_id`),
  KEY `IDX_9D4ECE1D83FDE077` (`pub_id`),
  CONSTRAINT `FK_9D4ECE1D83FDE077` FOREIGN KEY (`pub_id`) REFERENCES `pub` (`id`),
  CONSTRAINT `FK_9D4ECE1DA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table harcourt.import: ~7 rows (approximately)
INSERT INTO `import` (`id`, `user_id`, `pub_id`, `created_at`, `filename`, `status`) VALUES
	(7, 274, 7, '2020-06-08 11:18:17', 'harcourt1-5ede025a1f99e.csv', 'failed'),
	(8, 274, 8, '2020-06-08 11:19:42', 'threecranes1-5ede02af28a49.csv', 'failed'),
	(9, 274, 9, '2020-06-08 11:20:26', 'coach1-5ede02da56440.csv', 'failed'),
	(10, 274, 10, '2020-06-08 11:21:51', 'heromaida1-5ede0330267a5.csv', 'failed'),
	(11, 274, 11, '2020-06-08 11:22:40', 'crownchiswick1-5ede0361369f6.csv', 'failed'),
	(12, 274, 12, '2020-06-08 11:25:37', 'kph1-5ede04118a99e.csv', 'failed'),
	(13, 274, 13, '2020-07-20 15:06:13', 'xxx-5f1596c5dbf43.csv', 'failed');

-- Dumping structure for table harcourt.investor_meeting
CREATE TABLE IF NOT EXISTS `investor_meeting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `attendance` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `investor_skills` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_prepared_to_help` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table harcourt.investor_meeting: ~54 rows (approximately)
INSERT INTO `investor_meeting` (`id`, `attendance`, `investor_skills`, `is_prepared_to_help`) VALUES
	(1, 'DialIn', 'Probably no very useful skills, I\'m afraid - I\'m a quant', 'Yes'),
	(2, 'NotAttending', NULL, 'No'),
	(3, 'DialIn', NULL, 'Yes'),
	(4, 'DialIn', 'Finance and management', 'Yes'),
	(5, 'InPerson', NULL, 'No'),
	(6, 'DialIn', 'Investment Banking', 'Yes'),
	(7, 'InPerson', 'None sorry', 'Yes'),
	(8, 'NotAttending', NULL, 'No'),
	(9, 'NotAttending', NULL, 'No'),
	(10, 'InPerson', 'My background is in construction so might have some skills which could  be of use should we decide to apply for planning into residential properties etc', 'No'),
	(11, 'DialIn', 'Operational restructuring; general management consultancy.', 'Yes'),
	(12, 'NotAttending', NULL, 'No'),
	(13, 'DialIn', NULL, 'No'),
	(14, 'InPerson', NULL, 'No'),
	(15, 'NotAttending', NULL, 'Yes'),
	(16, 'InPerson', NULL, 'No'),
	(17, 'InPerson', NULL, 'No'),
	(18, 'DialIn', 'due diligence, detail -', 'Yes'),
	(19, 'DialIn', NULL, 'Yes'),
	(20, 'NotAttending', NULL, 'No'),
	(21, 'InPerson', NULL, 'No'),
	(22, 'InPerson', NULL, 'Yes'),
	(23, 'InPerson', NULL, 'No'),
	(24, 'DialIn', 'Finance', 'Yes'),
	(25, 'DialIn', NULL, 'Yes'),
	(26, 'DialIn', 'Solicitor', 'Yes'),
	(27, 'DialIn', NULL, 'No'),
	(28, 'DialIn', 'Accounting', 'Yes'),
	(29, 'DialIn', 'Tax, retired EY tax partner', 'Yes'),
	(30, 'DialIn', 'Former banker (28 years) now CEO of a reinsurer.  [Note: limited time hence answer "No" above]', 'No'),
	(31, 'DialIn', 'Private Equity', 'Yes'),
	(32, 'DialIn', NULL, 'No'),
	(33, 'NotAttending', 'Whilst I am keen to help I have limited time available due to having a full time job. In terms of my skill sets I am a corporate finance advisor and known to Tony Kenny.  Thank you for your time in this matter.', 'No'),
	(34, 'DialIn', NULL, 'No'),
	(35, 'DialIn', NULL, 'No'),
	(36, 'DialIn', 'Accounting', 'Yes'),
	(37, 'DialIn', 'Financial Modelling, IT, Data Management', 'Yes'),
	(38, 'DialIn', 'Finance / banking', 'Yes'),
	(39, 'DialIn', 'suspect no relevant skills.  Happy to supply supporting information etc.', 'No'),
	(40, 'DialIn', 'I am a chartered accountant and I have worked as COO in corporate finance of a major Inv Bank for over 20 years including. Happy to help in anyway I can on the pubs I am invested in or indeed any others.', 'Yes'),
	(41, 'DialIn', 'Linkeding profile: https://www.linkedin.com/in/enrico-michelotti-553b5732/', 'Yes'),
	(42, 'DialIn', NULL, 'No'),
	(43, 'DialIn', 'Unfortunately I don\'t think I have any relevant skills (my work is IT/web so happy to contribute in that way if required).', 'Yes'),
	(44, 'DialIn', 'Legal', 'Yes'),
	(45, 'DialIn', '20+ years working in tax enhanced, structured finance', 'Yes'),
	(46, 'DialIn', NULL, 'No'),
	(47, 'DialIn', NULL, 'Yes'),
	(48, 'DialIn', NULL, 'No'),
	(49, 'DialIn', 'ACA, 30 years in business, CFO', 'Yes'),
	(50, 'DialIn', NULL, 'Yes'),
	(51, 'DialIn', 'As known', 'Yes'),
	(52, 'DialIn', NULL, 'No'),
	(53, 'NotAttending', 'I have some tax and legal knowledge but do not claim expertise in EIS', 'Yes'),
	(54, 'DialIn', 'legal', 'Yes');

-- Dumping structure for table harcourt.linked_in_contacts_jm
CREATE TABLE IF NOT EXISTS `linked_in_contacts_jm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contact` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_linked_in_contact` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table harcourt.linked_in_contacts_jm: ~0 rows (approximately)

-- Dumping structure for table harcourt.log
CREATE TABLE IF NOT EXISTS `log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` datetime NOT NULL,
  `event_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `additional_info` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_8F3F68C5A76ED395` (`user_id`),
  CONSTRAINT `FK_8F3F68C5A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=430 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table harcourt.log: ~350 rows (approximately)
INSERT INTO `log` (`id`, `created_at`, `event_key`, `additional_info`, `user_id`) VALUES
	(1, '2020-08-18 08:51:08', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(2, '2020-08-18 12:53:25', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(3, '2020-08-18 15:57:15', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(4, '2020-08-18 22:33:11', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(5, '2020-08-18 23:49:26', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(6, '2020-08-19 11:11:08', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(7, '2020-08-19 13:14:44', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(8, '2020-08-20 07:00:40', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(9, '2020-08-20 08:41:41', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(10, '2020-08-20 10:41:34', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(11, '2020-08-20 11:38:21', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(12, '2020-08-21 08:23:15', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(13, '2020-08-21 08:30:07', 'user.logged_in', 'David Fishwick Logged in', NULL),
	(15, '2020-08-21 11:03:21', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(16, '2020-08-22 07:47:47', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(17, '2020-08-22 12:11:21', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(18, '2020-08-23 14:03:05', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(19, '2020-08-23 19:33:48', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(20, '2020-08-24 06:57:41', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(21, '2020-08-24 07:05:00', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(22, '2020-08-24 14:48:03', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(23, '2020-08-25 00:15:28', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(24, '2020-08-25 11:32:47', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(25, '2020-08-25 14:45:40', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(26, '2020-08-25 14:45:51', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(27, '2020-08-27 06:57:40', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(28, '2020-08-27 08:40:20', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(29, '2020-08-27 11:44:31', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(30, '2020-08-27 12:44:12', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(31, '2020-08-27 15:29:57', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(32, '2020-08-27 17:44:38', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(33, '2020-08-27 18:00:56', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(34, '2020-08-28 07:04:17', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(35, '2020-08-28 11:36:30', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(36, '2020-08-28 11:37:55', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(37, '2020-08-28 17:29:14', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(39, '2020-08-29 08:36:42', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(44, '2020-08-29 09:12:21', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(45, '2020-08-29 12:03:53', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(46, '2020-08-29 15:03:58', 'user.logged_in', 'David Fishwick Logged in', NULL),
	(47, '2020-08-29 15:04:14', 'user.logged_in', 'John Soden Logged in', NULL),
	(48, '2020-08-29 15:05:34', 'user.logged_in', 'Michael Herrington Logged in', NULL),
	(49, '2020-08-29 15:06:40', 'user.logged_in', 'Michael Herrington Logged in', NULL),
	(50, '2020-08-30 10:10:23', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(51, '2020-08-30 11:56:29', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(52, '2020-08-30 12:46:35', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(53, '2020-08-30 12:46:43', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(54, '2020-08-30 12:50:32', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(55, '2020-08-30 12:50:43', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(56, '2020-08-30 13:09:58', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(57, '2020-08-30 13:10:45', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(60, '2020-08-30 15:11:44', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(61, '2020-08-31 07:02:07', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(62, '2020-08-31 07:02:21', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(63, '2020-08-31 07:03:54', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(64, '2020-08-31 07:10:41', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(65, '2020-08-31 07:10:57', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(66, '2020-08-31 07:12:31', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(67, '2020-08-31 07:13:31', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(68, '2020-09-01 07:06:22', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(69, '2020-09-01 07:21:50', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(72, '2020-09-01 10:51:22', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(73, '2020-09-01 16:47:31', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(74, '2020-09-01 16:48:26', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(75, '2020-09-01 19:41:07', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(76, '2020-09-01 20:06:47', 'user.logged_in', 'David Smith Logged in', NULL),
	(77, '2020-09-02 06:56:47', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(78, '2020-09-02 06:57:43', 'user.logged_in', 'David Smith Logged in', NULL),
	(79, '2020-09-02 10:36:52', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(80, '2020-09-03 13:31:24', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(81, '2020-09-03 15:48:47', 'user.logged_in', 'David Smith Logged in', NULL),
	(82, '2020-09-03 16:35:14', 'user.logged_in', 'Richard Fleming Logged in', NULL),
	(83, '2020-09-03 19:22:50', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(85, '2020-09-03 19:46:53', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(86, '2020-09-03 20:06:55', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(87, '2020-09-04 07:06:12', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(88, '2020-09-04 07:56:11', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(89, '2020-09-04 09:01:28', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(90, '2020-09-04 12:13:14', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(91, '2020-09-05 07:05:39', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(93, '2020-09-05 12:45:37', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(97, '2020-09-05 13:44:11', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(99, '2020-09-05 14:01:35', 'user.logged_in', 'Anthony Kenny Logged in', NULL),
	(100, '2020-09-05 14:22:45', 'user.logged_in', 'Stephen Nurse Logged in', NULL),
	(101, '2020-09-05 14:54:58', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(102, '2020-09-05 15:31:16', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(103, '2020-09-05 19:04:35', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(104, '2020-09-05 22:13:53', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(105, '2020-09-06 00:51:22', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(106, '2020-09-06 11:22:19', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(107, '2020-09-07 10:04:06', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(108, '2020-09-07 10:04:07', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(109, '2020-09-07 14:44:52', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(110, '2020-09-07 19:26:00', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(111, '2020-09-07 20:25:00', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(112, '2020-09-08 06:58:56', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(113, '2020-09-08 11:56:56', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(114, '2020-09-08 12:23:29', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(115, '2020-09-08 13:39:55', 'user.logged_in', 'Paul Bartram Logged in', NULL),
	(116, '2020-09-09 08:26:58', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(117, '2020-09-09 10:59:42', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(118, '2020-09-09 11:26:58', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(119, '2020-09-09 11:48:19', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(120, '2020-09-09 13:36:31', 'user.logged_in', 'Andrew Ayers Logged in', NULL),
	(121, '2020-09-09 13:44:00', 'user.logged_in', 'Andrew Ayers Logged in', NULL),
	(122, '2020-09-09 14:08:25', 'user.logged_in', 'Lilian Watkins Logged in', NULL),
	(123, '2020-09-09 14:17:17', 'user.logged_in', 'Andrew Ayers Logged in', NULL),
	(124, '2020-09-09 14:27:12', 'user.logged_in', 'Stephan Marot Logged in', NULL),
	(125, '2020-09-09 14:29:21', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(126, '2020-09-09 14:35:48', 'user.logged_in', 'Simon Wainwright Logged in', NULL),
	(127, '2020-09-09 17:31:48', 'user.logged_in', 'Howard Doberman Logged in', NULL),
	(128, '2020-09-09 18:05:34', 'user.logged_in', 'Simon Wainwright Logged in', NULL),
	(129, '2020-09-09 18:07:12', 'user.logged_in', 'Martin Wright Logged in', NULL),
	(130, '2020-09-09 18:13:46', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(131, '2020-09-09 18:20:59', 'user.logged_in', 'Martin Wright Logged in', NULL),
	(132, '2020-09-09 18:54:09', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(133, '2020-09-09 23:14:47', 'user.logged_in', 'Julian Liddy Logged in', NULL),
	(134, '2020-09-09 23:20:31', 'user.logged_in', 'Tim Young Logged in', NULL),
	(135, '2020-09-10 08:24:28', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(136, '2020-09-10 11:28:55', 'user.logged_in', 'Edward Falinski Logged in', NULL),
	(137, '2020-09-10 11:34:29', 'user.logged_in', 'Nick Rustad Logged in', NULL),
	(138, '2020-09-10 12:03:20', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(139, '2020-09-10 13:41:33', 'user.logged_in', 'Tony Webb Logged in', NULL),
	(140, '2020-09-10 14:05:09', 'user.logged_in', 'Andrew Chu Logged in', NULL),
	(141, '2020-09-10 14:28:12', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(142, '2020-09-10 14:30:34', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(143, '2020-09-10 22:24:11', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(144, '2020-09-11 10:02:48', 'user.logged_in', 'Andrew Chu Logged in', NULL),
	(145, '2020-09-11 10:57:04', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(146, '2020-09-11 11:01:06', 'user.logged_in', 'Martin Wright Logged in', NULL),
	(147, '2020-09-11 11:03:00', 'user.logged_in', 'Martin Wright Logged in', NULL),
	(148, '2020-09-11 11:03:35', 'user.logged_in', 'Martin Wright Logged in', NULL),
	(149, '2020-09-11 11:06:12', 'user.logged_in', 'Martin Wright Logged in', NULL),
	(150, '2020-09-11 11:18:55', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(151, '2020-09-11 11:39:31', 'user.logged_in', 'Stephen Nurse Logged in', NULL),
	(152, '2020-09-11 11:54:22', 'user.logged_in', 'Simon Wainwright Logged in', NULL),
	(153, '2020-09-11 13:46:51', 'user.logged_in', 'Stephane Darc Logged in', NULL),
	(154, '2020-09-11 17:34:35', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(155, '2020-09-12 07:46:55', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', NULL),
	(156, '2020-09-12 08:57:07', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(157, '2020-09-12 11:28:48', 'user.logged_in', 'Clive Penwarden Logged in', 327),
	(158, '2020-09-12 14:19:16', 'user.logged_in', 'Stephen Jefferies Logged in', 339),
	(159, '2020-09-12 22:31:14', 'user.logged_in', 'David Bradford Logged in', 482),
	(160, '2020-09-13 00:07:26', 'user.logged_in', 'Amadeo Alentorn-Farre Logged in', 474),
	(161, '2020-09-13 04:51:20', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(162, '2020-09-13 10:19:27', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(163, '2020-09-13 10:20:06', 'user.logged_in', 'Alex Davies Logged in', 426),
	(164, '2020-09-13 10:20:08', 'user.logged_in', 'Alex Davies Logged in', 426),
	(165, '2020-09-13 10:23:34', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(166, '2020-09-13 13:37:06', 'user.logged_in', 'Dee Narga Logged in', 485),
	(167, '2020-09-13 14:28:31', 'user.logged_in', 'Howard Doberman Logged in', 298),
	(168, '2020-09-13 14:40:54', 'user.logged_in', 'Martin Wright Logged in', 328),
	(169, '2020-09-13 14:41:16', 'user.logged_in', 'Martin Wright Logged in', 328),
	(170, '2020-09-13 16:09:03', 'user.logged_in', 'Clive Hill Logged in', 480),
	(171, '2020-09-13 16:18:21', 'user.logged_in', 'Howard Doberman Logged in', 298),
	(172, '2020-09-14 09:22:28', 'user.logged_in', 'Dan Keeble Logged in', 360),
	(173, '2020-09-14 09:42:36', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(174, '2020-09-14 09:58:58', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(175, '2020-09-14 11:19:00', 'user.logged_in', 'Stewart Williams Logged in', 531),
	(176, '2020-09-14 11:26:46', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(177, '2020-09-14 12:25:25', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(178, '2020-09-14 12:47:20', 'user.logged_in', 'David Bradford Logged in', 482),
	(179, '2020-09-14 13:36:23', 'user.logged_in', 'Frank Dowling Logged in', 308),
	(180, '2020-09-14 13:49:12', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(181, '2020-09-14 17:55:44', 'user.logged_in', 'Mike Lloyd Logged in', 316),
	(182, '2020-09-14 21:26:48', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(183, '2020-09-14 22:30:49', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(184, '2020-09-14 23:09:57', 'user.logged_in', 'Alex Rolle Logged in', 351),
	(185, '2020-09-15 12:27:03', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(186, '2020-09-15 13:47:18', 'user.logged_in', 'Guy Fothergill Logged in', 490),
	(187, '2020-09-15 14:38:00', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(188, '2020-09-15 15:07:37', 'user.logged_in', 'Tim Rigby Logged in', 340),
	(189, '2020-09-15 16:40:41', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(190, '2020-09-15 19:09:50', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(191, '2020-09-15 22:08:19', 'user.logged_in', 'David Bradford Logged in', 482),
	(192, '2020-09-15 22:23:30', 'user.logged_in', 'John Mayhew Logged in', 410),
	(193, '2020-09-15 23:16:04', 'user.logged_in', 'Alex Davies Logged in', 426),
	(194, '2020-09-15 23:20:43', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(197, '2020-09-15 23:50:40', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(198, '2020-09-16 11:05:28', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(199, '2020-09-16 12:33:05', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(200, '2020-09-16 13:31:32', 'user.logged_in', 'Alex Davies Logged in', 426),
	(201, '2020-09-16 13:43:19', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(202, '2020-09-16 13:48:15', 'user.logged_in', 'Gayle Bowen Logged in', 342),
	(203, '2020-09-16 14:49:49', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(204, '2020-09-16 16:31:52', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(205, '2020-09-16 16:44:41', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(206, '2020-09-16 17:18:02', 'user.logged_in', 'David Bradford Logged in', 482),
	(207, '2020-09-17 09:09:22', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(208, '2020-09-17 09:37:35', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(209, '2020-09-17 11:05:14', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(210, '2020-09-17 11:52:51', 'user.logged_in', 'Justin Pendlebury Logged in', 279),
	(211, '2020-09-17 12:17:15', 'user.logged_in', 'William Loader Logged in', 536),
	(212, '2020-09-17 12:19:20', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(213, '2020-09-17 14:01:23', 'user.logged_in', 'Tim Rigby Logged in', 340),
	(214, '2020-09-17 19:17:26', 'user.logged_in', 'Robert Searcy Logged in', 519),
	(215, '2020-09-17 19:21:59', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(216, '2020-09-17 21:17:49', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(217, '2020-09-17 21:39:01', 'user.logged_in', 'Robert Searcy Logged in', 519),
	(218, '2020-09-17 22:04:57', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(219, '2020-09-17 23:05:05', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(220, '2020-09-18 10:39:22', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(221, '2020-09-18 11:10:12', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(222, '2020-09-18 11:13:51', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(223, '2020-09-18 12:02:36', 'user.logged_in', 'Richard West Logged in', 517),
	(224, '2020-09-19 10:59:34', 'user.logged_in', 'Mark Sloan Logged in', 442),
	(225, '2020-09-19 11:33:53', 'user.logged_in', 'David Smith Logged in', 306),
	(226, '2020-09-19 13:24:07', 'user.logged_in', 'Mark Sloan Logged in', 442),
	(227, '2020-09-19 22:53:46', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(228, '2020-09-19 23:53:11', 'user.logged_in', 'Enrico Michelotti Logged in', 399),
	(229, '2020-09-20 08:52:03', 'user.logged_in', 'Rod Roman Logged in', 521),
	(230, '2020-09-20 11:20:28', 'user.logged_in', 'Nick Phillips Logged in', 317),
	(231, '2020-09-20 16:24:22', 'user.logged_in', 'Tom Maher Logged in', 422),
	(232, '2020-09-20 16:48:11', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(233, '2020-09-20 17:00:39', 'user.logged_in', 'Michael Raffan Logged in', 408),
	(234, '2020-09-20 17:46:18', 'user.logged_in', 'David Hardwick Logged in', 394),
	(236, '2020-09-20 18:18:06', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(237, '2020-09-20 19:34:58', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(238, '2020-09-21 09:29:43', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(239, '2020-09-21 09:30:20', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(240, '2020-09-21 10:50:21', 'user.logged_in', 'Anthony Riley Logged in', 284),
	(241, '2020-09-21 11:59:30', 'user.logged_in', 'Andrei Legostaev Logged in', 301),
	(242, '2020-09-21 13:51:01', 'user.logged_in', 'Graham McDevitt Logged in', 367),
	(243, '2020-09-21 14:33:42', 'user.logged_in', 'David Smith Logged in', 306),
	(244, '2020-09-21 14:33:44', 'user.logged_in', 'David Smith Logged in', 306),
	(245, '2020-09-21 16:53:03', 'user.logged_in', 'David Smith Logged in', 306),
	(246, '2020-09-21 17:01:21', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(247, '2020-09-21 21:25:51', 'user.logged_in', 'Steven Saywell Logged in', 466),
	(248, '2020-09-22 11:24:25', 'user.logged_in', 'David Hardwick Logged in', 394),
	(249, '2020-09-22 13:44:30', 'user.logged_in', 'Perry Thomas Logged in', 454),
	(250, '2020-09-22 18:11:36', 'user.logged_in', 'Juliet Armstrong Logged in', 503),
	(251, '2020-09-22 18:13:31', 'user.logged_in', 'Gulamabbas Lakha Logged in', 433),
	(252, '2020-09-22 21:02:46', 'user.logged_in', 'Perry Thomas Logged in', 454),
	(253, '2020-09-22 21:47:51', 'user.logged_in', 'Justin Watts Logged in', 437),
	(254, '2020-09-22 23:41:30', 'user.logged_in', 'Roland Hartwig Logged in', 458),
	(255, '2020-09-23 09:00:40', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(256, '2020-09-23 09:18:42', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(257, '2020-09-23 09:57:08', 'user.logged_in', 'Adam Rae-Smith Logged in', 472),
	(258, '2020-09-23 11:44:07', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(259, '2020-09-23 12:04:37', 'user.logged_in', 'Mark St Giles Logged in', 467),
	(260, '2020-09-23 12:14:10', 'user.logged_in', 'Stephen Jefferies Logged in', 339),
	(261, '2020-09-23 12:20:17', 'user.logged_in', 'Iain O\'Neill Logged in', 359),
	(262, '2020-09-23 12:28:55', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(263, '2020-09-23 13:45:34', 'user.logged_in', 'Nigel Middleton Logged in', 380),
	(264, '2020-09-23 15:39:23', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(265, '2020-09-23 17:47:22', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(266, '2020-09-24 07:29:05', 'user.logged_in', 'Martin Dunnett Logged in', 444),
	(267, '2020-09-24 08:41:23', 'user.logged_in', 'Volker Wellman Logged in', 348),
	(268, '2020-09-24 10:38:22', 'user.logged_in', 'Steven Saywell Logged in', 466),
	(269, '2020-09-24 10:45:09', 'user.logged_in', 'Mark Sloan Logged in', 442),
	(270, '2020-09-24 10:49:20', 'user.logged_in', 'Nigel Moore Logged in', 452),
	(271, '2020-09-24 11:25:31', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(272, '2020-09-24 11:32:06', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(274, '2020-09-24 14:17:41', 'user.logged_in', 'Thomas Demeure Logged in', 470),
	(275, '2020-09-24 15:01:04', 'user.logged_in', 'Nigel Moore Logged in', 452),
	(276, '2020-09-24 18:18:24', 'user.logged_in', 'Enrico Michelotti Logged in', 399),
	(277, '2020-09-24 21:49:29', 'user.logged_in', 'Stephen Phillips Logged in', 283),
	(278, '2020-09-25 10:27:32', 'user.logged_in', 'Steven Partridge Logged in', 282),
	(279, '2020-09-25 11:13:38', 'user.logged_in', 'Clive Wells Logged in', 429),
	(280, '2020-09-25 12:35:06', 'user.logged_in', 'Steven Partridge Logged in', 282),
	(281, '2020-09-25 13:13:24', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(282, '2020-09-25 13:24:19', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(283, '2020-09-25 14:14:20', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(284, '2020-09-25 15:53:25', 'user.logged_in', 'Andrei Legostaev Logged in', 301),
	(285, '2020-09-25 16:13:26', 'user.logged_in', 'Mark Sloan Logged in', 442),
	(286, '2020-09-25 17:44:28', 'user.logged_in', 'Nicholas Leyhane Logged in', 512),
	(287, '2020-09-25 18:03:04', 'user.logged_in', 'Jason Bryom Logged in', 496),
	(288, '2020-09-25 18:33:02', 'user.logged_in', 'Christopher Such Logged in', 479),
	(289, '2020-09-25 18:43:41', 'user.logged_in', 'Marios Paparistodemou Logged in', 441),
	(290, '2020-09-26 06:56:58', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(291, '2020-09-26 10:48:54', 'user.logged_in', 'Michael Furber Logged in', 446),
	(292, '2020-09-26 10:53:08', 'user.logged_in', 'Michael Furber Logged in', 446),
	(293, '2020-09-26 12:08:26', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(294, '2020-09-26 13:38:45', 'user.logged_in', 'Alexandre Farid Issa-el-Khoury Logged in', 390),
	(295, '2020-09-26 13:44:36', 'user.logged_in', 'Michael Richard FURBER Logged in', 446),
	(296, '2020-09-26 17:50:20', 'user.logged_in', 'Edward Falinski Logged in', 294),
	(297, '2020-09-27 10:23:48', 'user.logged_in', 'Trevor Leydon Logged in', 525),
	(298, '2020-09-27 12:23:04', 'user.logged_in', 'Rod Roman Logged in', 521),
	(299, '2020-09-27 12:54:19', 'user.logged_in', 'Andrew Connell Logged in', 280),
	(300, '2020-09-27 20:43:22', 'user.logged_in', 'Andrei Legostaev Logged in', 301),
	(301, '2020-09-27 21:33:49', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(302, '2020-09-28 11:21:40', 'user.logged_in', 'Steven Saywell Logged in', 466),
	(303, '2020-09-28 13:11:42', 'user.logged_in', 'James Snape Logged in', 493),
	(304, '2020-09-28 17:35:37', 'user.logged_in', 'Anna Scharnetzky Logged in', 547),
	(305, '2020-09-28 17:38:41', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(306, '2020-09-28 18:41:22', 'user.logged_in', 'Tim Rigby Logged in', 340),
	(307, '2020-09-28 21:02:05', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(308, '2020-09-29 08:35:50', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(309, '2020-09-29 09:36:23', 'user.logged_in', 'Nick Leyhane Logged in', 512),
	(310, '2020-09-29 10:28:34', 'user.logged_in', 'Steven Saywell Logged in', 466),
	(311, '2020-09-29 10:43:33', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(312, '2020-09-29 11:10:25', 'user.logged_in', 'David Bradford Logged in', 482),
	(313, '2020-09-29 11:24:00', 'user.logged_in', 'Enrico Michelotti Logged in', 399),
	(314, '2020-09-29 18:51:41', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(315, '2020-09-29 21:38:45', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(316, '2020-09-30 02:05:06', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(317, '2020-09-30 11:20:33', 'user.logged_in', 'Peter Routledge Logged in', 540),
	(318, '2020-09-30 12:53:03', 'user.logged_in', 'Richard West Logged in', 517),
	(319, '2020-09-30 14:06:46', 'user.logged_in', 'Anna Scharnetzky Logged in', 547),
	(320, '2020-09-30 15:08:38', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(321, '2020-10-03 12:44:13', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(322, '2020-10-05 15:52:15', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(323, '2020-10-05 16:16:00', 'user.logged_in', 'Nick Leyhane Logged in', 512),
	(324, '2020-10-05 22:10:51', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(325, '2020-10-06 00:33:45', 'user.logged_in', 'Mark Sloan Logged in', 442),
	(326, '2020-10-06 11:42:36', 'user.logged_in', 'John Northcott Logged in', 499),
	(327, '2020-10-06 11:50:29', 'user.logged_in', 'Enrico Michelotti Logged in', 399),
	(328, '2020-10-06 12:27:12', 'user.logged_in', 'Dee Narga Logged in', 485),
	(329, '2020-10-06 12:27:14', 'user.logged_in', 'Dee Narga Logged in', 485),
	(330, '2020-10-06 16:09:05', 'user.logged_in', 'Nick Rustad Logged in', 335),
	(331, '2020-10-06 16:29:25', 'user.logged_in', 'Paul Knox Logged in', 514),
	(332, '2020-10-06 17:58:54', 'user.logged_in', 'Clive Penwarden Logged in', 327),
	(333, '2020-10-06 19:25:27', 'user.logged_in', 'Shailen Patel Logged in', 419),
	(334, '2020-10-07 12:45:20', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(335, '2020-10-09 13:40:01', 'user.logged_in', 'Steven Saywell Logged in', 466),
	(336, '2020-10-10 07:04:16', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(337, '2020-10-12 04:08:39', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(338, '2020-10-12 17:01:54', 'user.logged_in', 'Denis Shafranik Logged in', 407),
	(339, '2020-10-14 16:07:37', 'user.logged_in', 'Nick Leyhane Logged in', 512),
	(340, '2020-10-14 18:42:58', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(341, '2020-10-14 21:00:37', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(342, '2020-10-15 22:53:21', 'user.logged_in', 'Teddy Morau Logged in', 468),
	(343, '2020-10-18 10:52:58', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(344, '2020-10-19 11:46:04', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(345, '2020-10-19 12:00:47', 'user.logged_in', 'Nick Leyhane Logged in', 512),
	(346, '2020-10-20 12:31:06', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(347, '2020-10-20 12:37:28', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(348, '2020-10-20 13:09:34', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(349, '2020-10-21 12:23:27', 'user.logged_in', 'Shailen Patel Logged in', 419),
	(350, '2020-10-23 20:15:47', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(351, '2020-10-24 10:47:36', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(352, '2020-10-24 11:49:30', 'user.logged_in', 'Shailen Patel Logged in', 419),
	(353, '2020-10-25 12:50:35', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(354, '2020-10-25 15:01:01', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(355, '2020-10-26 07:09:53', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(356, '2020-10-28 20:24:57', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(357, '2020-10-30 13:36:06', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(358, '2020-11-03 11:34:13', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(359, '2020-11-03 11:35:57', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(360, '2020-11-06 17:51:21', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(361, '2020-11-07 14:26:15', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(362, '2020-11-08 11:22:48', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(363, '2020-11-09 11:37:57', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(364, '2020-11-09 12:36:48', 'user.logged_in', 'Shailen Patel Logged in', 419),
	(365, '2020-11-09 19:20:33', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(366, '2020-11-09 20:35:59', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(367, '2020-11-10 18:32:49', 'user.logged_in', 'Nick Leyhane Logged in', 512),
	(368, '2020-11-10 20:52:45', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(369, '2020-11-11 11:29:51', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(370, '2020-11-12 06:52:24', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(371, '2020-11-14 23:29:02', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(372, '2020-11-15 11:47:39', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(373, '2020-11-15 13:55:44', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(374, '2020-11-15 14:11:01', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(375, '2020-11-18 20:52:39', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(376, '2020-11-18 21:26:21', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(377, '2020-11-19 00:44:52', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(378, '2020-11-21 10:11:29', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(379, '2020-11-21 19:34:04', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(380, '2020-11-22 14:24:46', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(381, '2020-11-23 21:55:04', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(382, '2020-11-24 21:48:03', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(383, '2020-11-25 19:42:01', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(384, '2020-11-26 10:47:11', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(385, '2020-11-26 12:22:55', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(386, '2020-11-26 20:33:33', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(387, '2020-11-27 11:36:41', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(388, '2020-11-28 06:47:49', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(389, '2020-11-28 12:58:42', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(390, '2020-11-29 19:49:35', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(391, '2020-12-02 10:48:03', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(392, '2020-12-03 11:47:57', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(393, '2020-12-03 22:44:07', 'user.logged_in', 'Stephen Nurse (IT admin account) Logged in', 274),
	(394, '2020-12-05 14:18:11', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(395, '2020-12-11 16:55:44', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(396, '2020-12-12 16:23:14', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(397, '2020-12-13 10:41:35', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(398, '2020-12-15 06:21:43', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(399, '2020-12-16 20:18:43', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(400, '2020-12-16 23:04:32', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(401, '2020-12-17 20:09:33', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(402, '2020-12-24 22:24:02', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(403, '2020-12-25 00:15:06', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(404, '2021-01-10 10:14:16', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(405, '2021-01-17 21:15:58', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(406, '2021-01-17 21:23:16', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(407, '2021-01-17 21:24:47', 'user.logged_in', 'Charles Bristow Logged in', 299),
	(408, '2021-01-19 20:30:25', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(409, '2021-01-21 08:57:29', 'user.logged_in', 'Rod Roman Logged in', 521),
	(410, '2021-01-23 00:26:32', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(411, '2021-01-23 13:26:36', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(412, '2021-01-24 15:55:22', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(413, '2021-01-28 19:32:09', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(414, '2021-01-30 12:10:04', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(415, '2021-02-10 06:50:51', 'user.logged_in', 'Charles Bristow Logged in', 299),
	(416, '2021-02-10 07:23:56', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(417, '2021-02-15 06:08:23', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(418, '2021-03-07 18:32:15', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(419, '2021-03-13 08:02:15', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(420, '2021-03-13 09:42:27', 'user.logged_in', 'Stephen Nurse (IT ) Logged in', 274),
	(421, '2021-03-14 06:11:35', 'user.logged_in', 'Stephen Nurse (IT) Logged in', 274),
	(422, '2021-05-02 06:49:05', 'user.logged_in', 'Stephen Nurse (IT) Logged in', 274),
	(423, '2021-05-03 09:12:40', 'user.logged_in', 'Stephen NurseIT Logged in', 274),
	(424, '2021-05-03 14:24:58', 'user.logged_in', 'Stephen NurseIT Logged in', 274),
	(425, '2021-05-03 14:28:54', 'user.logged_in', 'Stephen NurseIT Logged in', 274),
	(426, '2021-05-04 04:47:42', 'user.logged_in', 'Stephen NurseIT Logged in', 274),
	(427, '2021-05-04 05:24:11', 'user.logged_in', 'Stephen NurseIT Logged in', 274),
	(428, '2021-05-04 05:25:02', 'user.logged_in', 'Charles Bristow Logged in', 299),
	(429, '2021-05-04 05:27:16', 'user.logged_in', 'Stephen NurseIT Logged in', 274);

-- Dumping structure for table harcourt.mail
CREATE TABLE IF NOT EXISTS `mail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `recipient` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attachment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `send_at` datetime DEFAULT NULL,
  `cc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `real_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pub_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_5126AC4883FDE077` (`pub_id`),
  CONSTRAINT `FK_5126AC4883FDE077` FOREIGN KEY (`pub_id`) REFERENCES `pub` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2772 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table harcourt.mail: ~1,112 rows (approximately)
INSERT INTO `mail` (`id`, `recipient`, `content`, `attachment`, `subject`, `created_at`, `send_at`, `cc`, `real_path`, `pub_id`) VALUES
	(474, 'sjwn71@gmail.com', '<!DOCTYPE html>\n<html>\n<head>\n    <meta charset="utf-8"> <!-- utf-8 works for most cases -->\n    <meta name="viewport" content="width=device-width"> <!-- Forcing initial-scale shouldn\'t be necessary -->\n    <meta http-equiv="X-UA-Compatible" content="IE=edge"> <!-- Use the latest (edge) version of IE rendering engine -->\n    <meta name="x-apple-disable-message-reformatting">  <!-- Disable auto-scale in iOS 10 Mail entirely -->\n    <meta name="format-detection" content="telephone=no,address=no,email=no,date=no,url=no">\n    <!-- Tell iOS not to automatically link certain text strings. -->\n    <meta name="color-scheme" content="light">\n    <meta name="supported-color-schemes" content="light">\n\n    <title>Background regarding the General Meeting on 30 September at 9am </title>\n            <style>\n\n            /* What it does: Tells the email client that only light styles are provided but the client can transform them to dark. A duplicate of meta color-scheme meta tag above. */\n            :root {\n                color-scheme: light;\n                supported-color-schemes: light;\n            }\n\n            /* What it does: Remove spaces around the email design added by some email clients. */\n            /* Beware: It can remove the padding / margin and add a background color to the compose a reply window. */\n            html,\n            body {\n                margin: 0 auto !important;\n                padding: 0 !important;\n                height: 100% !important;\n                width: 100% !important;\n            }\n\n            /* What it does: Stops email clients resizing small text. */\n            * {\n                -ms-text-size-adjust: 100%;\n                -webkit-text-size-adjust: 100%;\n            }\n\n            /* What it does: Centers email on Android 4.4 */\n            div[style*="margin: 16px 0"] {\n                margin: 0 !important;\n            }\n\n            /* What it does: forces Samsung Android mail clients to use the entire viewport */\n            #MessageViewBody, #MessageWebViewDiv {\n                width: 100% !important;\n            }\n\n            /* What it does: Stops Outlook from adding extra spacing to tables. */\n            table,\n            td {\n                mso-table-lspace: 0pt !important;\n                mso-table-rspace: 0pt !important;\n            }\n\n            /* What it does: Replaces default bold style. */\n            th {\n                font-weight: normal;\n            }\n\n            /* What it does: Fixes webkit padding issue. */\n            table {\n                border-spacing: 0 !important;\n                border-collapse: collapse !important;\n                table-layout: fixed !important;\n                margin: 0 auto !important;\n            }\n\n            /* What it does: Prevents Windows 10 Mail from underlining links despite inline CSS. Styles for underlined links should be inline. */\n            a {\n                text-decoration: none;\n            }\n\n            /* What it does: Uses a better rendering method when resizing images in IE. */\n            img {\n                -ms-interpolation-mode: bicubic;\n            }\n\n            /* What it does: A work-around for email clients meddling in triggered links. */\n            a[x-apple-data-detectors], /* iOS */\n            .unstyle-auto-detected-links a,\n            .aBn {\n                border-bottom: 0 !important;\n                cursor: default !important;\n                color: inherit !important;\n                text-decoration: none !important;\n                font-size: inherit !important;\n                font-family: inherit !important;\n                font-weight: inherit !important;\n                line-height: inherit !important;\n            }\n\n            /* What it does: Prevents Gmail from changing the text color in conversation threads. */\n            .im {\n                color: inherit !important;\n            }\n\n            /* What it does: Prevents Gmail from displaying a download button on large, non-linked images. */\n            .a6S {\n                display: none !important;\n                opacity: 0.01 !important;\n            }\n\n            /* If the above doesn\'t work, add a .g-img class to any image in question. */\n            img.g-img + div {\n                display: none !important;\n            }\n\n            /* What it does: Removes right gutter in Gmail iOS app: https://github.com/TedGoas/Cerberus/issues/89  */\n            /* Create one of these media queries for each additional viewport size you\'d like to fix */\n\n            /* iPhone 4, 4S, 5, 5S, 5C, and 5SE */\n            @media only screen and (min-device-width: 320px) and (max-device-width: 374px) {\n                u ~ div .email-container {\n                    min-width: 320px !important;\n                }\n            }\n\n            /* iPhone 6, 6S, 7, 8, and X */\n            @media only screen and (min-device-width: 375px) and (max-device-width: 413px) {\n                u ~ div .email-container {\n                    min-width: 375px !important;\n                }\n            }\n\n            /* iPhone 6+, 7+, and 8+ */\n            @media only screen and (min-device-width: 414px) {\n                u ~ div .email-container {\n                    min-width: 414px !important;\n                }\n            }\n\n        </style>\n        <!-- CSS Reset : END -->\n\n        <!-- Progressive Enhancements : BEGIN -->\n        <style>\n\n            /* What it does: Hover styles for buttons */\n            .button-td,\n            .button-a {\n                transition: all 100ms ease-in;\n            }\n\n            .button-td-primary:hover,\n            .button-a-primary:hover {\n                background: #555555 !important;\n                border-color: #555555 !important;\n            }\n\n            /* Media Queries */\n            @media screen and (max-width: 600px) {\n\n                .email-container {\n                    width: 100% !important;\n                    margin: auto !important;\n                }\n\n                /* What it does: Forces table cells into full-width rows. */\n                .stack-column,\n                .stack-column-center {\n                    display: block !important;\n                    width: 100% !important;\n                    max-width: 100% !important;\n                    direction: ltr !important;\n                }\n\n                /* And center justify these ones. */\n                .stack-column-center {\n                    text-align: center !important;\n                }\n\n                /* What it does: Generic utility class for centering. Useful for images, buttons, and nested tables. */\n                .center-on-narrow {\n                    text-align: center !important;\n                    display: block !important;\n                    margin-left: auto !important;\n                    margin-right: auto !important;\n                    float: none !important;\n                }\n\n                table.center-on-narrow {\n                    display: inline-block !important;\n                }\n\n                /* What it does: Adjust typography on small screens to improve readability */\n                .email-container p {\n                    font-size: 17px !important;\n                }\n            }\n\n        </style>\n    </head>\n<body width="100%" style="margin: 0; padding: 0 !important; mso-line-height-rule: exactly; background-color: #dadada;">\n\n<center role="article" aria-roledescription="email" lang="en" style="width: 100%; background-color: #ffffff;">\n\n    <table role="presentation" border="0" cellpadding="0" cellspacing="0" width="100%"\n           style="background-color: #fff;">\n\n    <!-- Preview Text Spacing Hack : BEGIN -->\n    <div style="display: none; font-size: 1px; line-height: 1px; max-height: 0px; max-width: 0px; opacity: 0; overflow: hidden; mso-hide: all; font-family: sans-serif;">\n        &zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;\n    </div>\n    <!-- Preview Text Spacing Hack : END -->\n\n    <!-- Email Body : BEGIN -->\n    <table align="center" role="presentation" cellspacing="0" cellpadding="0" border="0" width="600"\n           style="margin: auto;" class="email-container">\n        <!-- Email Header : BEGIN -->\n        <tr>\n            <td style="padding: 20px 0;">\n                <p><strong>Background regarding the General Meeting on 30 September at 9am</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Dear fellow shareholder,</p>\r\n\r\n<p>You should by now have received notice of a General Meeting with a resolution to change the directors of the company and you will be wondering about the background to this request.</p>\r\n\r\n<p>The request came from the Shareholder Action Group which was recently formed after general dissatisfaction built up about how our investments were being managed.</p>\r\n\r\n<p>We attach a letter which sets out why and how the Shareholder Action Group came together, information on the financial position of the pub and the major loss of value that has been presided over by James McCulloch.</p>\r\n\r\n<p>Please read the information, consider your position and be prepared to vote either in person at the General Meeting or by proxy.</p>\r\n\r\n<p>We hope that you will see the personal benefit in supporting the resolution.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Thank you.</p>\r\n\r\n<p>The Shareholder Action Group</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Practicalities &ndash; The Proxy form:-</strong></p>\r\n\r\n<p>If you are supportive of the change of directors, the proxy form should be filled in as below. It should be emailed to <a href="mailto:james@harcourtinns.co.uk">james@harcourtinns.co.uk</a>, with the subject &ldquo;Proxy form&rdquo; .&nbsp;</p>\r\n\r\n<p>Please cc&rsquo;d <a href="mailto:harcourt-investors-action-group@atts-systems.com">harcourt-investors-action-group@atts-systems.com</a></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><a name="_Hlk50722516"><img src="data:image/png;base64,[encoded data, 62844 characters]" style="height:408.75pt; width:359.25pt" /> </a></p>\r\n\r\n<h3>&nbsp;</h3>\r\n\r\n<h3><strong>Website: Your login and password details</strong></h3>\r\n\r\n<p>The URL for the website is <a href="https://u18464332.ct.sendgrid.net/ls/click?upn=FcfDpG4MWY7BBJLvMw6-2BmKK0E4CfB1mdiexj2N64LupApus0VuIFxiVF2cLx-2BGLRXv41_WPFvr-2B1ki7aLmMFpZHRZ8JiliobnqUQQeYViDbObHPL98acs5WDmUK-2BbU9clmNW75W1zc6DqpsEx1MCurmD3K1PGCxAjVTiGBEqcfVzDU-2BQFq3rNAE-2B0y8y9WphjZdtUnxx12nUNUM7sgGLFw3acJG3eL0FHp0hh61tASvRsrtmwrBTBB1sJ-2BfBreAE5zLaDJMGFR-2BLE6UqoxObvviHWAEKqcpofq8jPL06EXnJi5gk0bG83XOwLYfiZcPyn3WVQ8gy4BWzY5m84MqPVNeP7gQ-3D-3D">https://london-pubs.atts-systems.com</a><br />\r\nYour login is your email; the password is &quot;londonpubinvestor_184&quot; (please update in My Contact Details)</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>General Meeting logistics:</strong></p>\r\n\r\n<p><strong>Venue </strong>: 55 Shirland Rd, Maida Vale, London, W9 2JD (Hero of Maida pub)<br />\r\n<strong>Date </strong>: Wednesday, 30 September 2020</p>\r\n\r\n<ul>\r\n	<li>09.00h Coach</li>\r\n	<li>10.30h Harcourt</li>\r\n	<li>12.00h Crown</li>\r\n	<li>13.30h Three Cranes</li>\r\n	<li>15.00h Hero</li>\r\n</ul>\r\n\r\n<p>We are asking the directors for clarification of the logistics given the recently announced Rule of 6.&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\n    <h3>Website: Your login and password details</h3>\n    <p>The URL for the website is <a href="https://london-pubs.atts-systems.com">https://london-pubs.atts-systems.com</a>\n        <br>\n\n                    Your login is your email (sjwn71@gmail.com); the password is "Descartes99"\n        \n        <br>\n    </p>\n             </td>\n        </tr>\n    </table>\n</center>\n\n\n    <!-- Optional JavaScript -->\n</body>\n</html>\n', '/admin/attachments/notify/Harcourt-Investor-email-Final-8-Sep-2020.pdf', 'ALL - Stephen Nurse : Background regarding the General Meeting on 30 September at 9am', '2020-09-11 17:16:49', '2020-09-11 17:18:07', NULL, '/home/attssyg/london-pubs/public/admin/attachments/notify//Harcourt-Investor-email-Final-8-Sep-2020.pdf', 7),
	(475, 'nurse_stephen@hotmail.com', '<!DOCTYPE html>\n<html>\n<head>\n    <meta charset="utf-8"> <!-- utf-8 works for most cases -->\n    <meta name="viewport" content="width=device-width"> <!-- Forcing initial-scale shouldn\'t be necessary -->\n    <meta http-equiv="X-UA-Compatible" content="IE=edge"> <!-- Use the latest (edge) version of IE rendering engine -->\n    <meta name="x-apple-disable-message-reformatting">  <!-- Disable auto-scale in iOS 10 Mail entirely -->\n    <meta name="format-detection" content="telephone=no,address=no,email=no,date=no,url=no">\n    <!-- Tell iOS not to automatically link certain text strings. -->\n    <meta name="color-scheme" content="light">\n    <meta name="supported-color-schemes" content="light">\n\n    <title>Background regarding the General Meeting on 30 September at 9am </title>\n            <style>\n\n            /* What it does: Tells the email client that only light styles are provided but the client can transform them to dark. A duplicate of meta color-scheme meta tag above. */\n            :root {\n                color-scheme: light;\n                supported-color-schemes: light;\n            }\n\n            /* What it does: Remove spaces around the email design added by some email clients. */\n            /* Beware: It can remove the padding / margin and add a background color to the compose a reply window. */\n            html,\n            body {\n                margin: 0 auto !important;\n                padding: 0 !important;\n                height: 100% !important;\n                width: 100% !important;\n            }\n\n            /* What it does: Stops email clients resizing small text. */\n            * {\n                -ms-text-size-adjust: 100%;\n                -webkit-text-size-adjust: 100%;\n            }\n\n            /* What it does: Centers email on Android 4.4 */\n            div[style*="margin: 16px 0"] {\n                margin: 0 !important;\n            }\n\n            /* What it does: forces Samsung Android mail clients to use the entire viewport */\n            #MessageViewBody, #MessageWebViewDiv {\n                width: 100% !important;\n            }\n\n            /* What it does: Stops Outlook from adding extra spacing to tables. */\n            table,\n            td {\n                mso-table-lspace: 0pt !important;\n                mso-table-rspace: 0pt !important;\n            }\n\n            /* What it does: Replaces default bold style. */\n            th {\n                font-weight: normal;\n            }\n\n            /* What it does: Fixes webkit padding issue. */\n            table {\n                border-spacing: 0 !important;\n                border-collapse: collapse !important;\n                table-layout: fixed !important;\n                margin: 0 auto !important;\n            }\n\n            /* What it does: Prevents Windows 10 Mail from underlining links despite inline CSS. Styles for underlined links should be inline. */\n            a {\n                text-decoration: none;\n            }\n\n            /* What it does: Uses a better rendering method when resizing images in IE. */\n            img {\n                -ms-interpolation-mode: bicubic;\n            }\n\n            /* What it does: A work-around for email clients meddling in triggered links. */\n            a[x-apple-data-detectors], /* iOS */\n            .unstyle-auto-detected-links a,\n            .aBn {\n                border-bottom: 0 !important;\n                cursor: default !important;\n                color: inherit !important;\n                text-decoration: none !important;\n                font-size: inherit !important;\n                font-family: inherit !important;\n                font-weight: inherit !important;\n                line-height: inherit !important;\n            }\n\n            /* What it does: Prevents Gmail from changing the text color in conversation threads. */\n            .im {\n                color: inherit !important;\n            }\n\n            /* What it does: Prevents Gmail from displaying a download button on large, non-linked images. */\n            .a6S {\n                display: none !important;\n                opacity: 0.01 !important;\n            }\n\n            /* If the above doesn\'t work, add a .g-img class to any image in question. */\n            img.g-img + div {\n                display: none !important;\n            }\n\n            /* What it does: Removes right gutter in Gmail iOS app: https://github.com/TedGoas/Cerberus/issues/89  */\n            /* Create one of these media queries for each additional viewport size you\'d like to fix */\n\n            /* iPhone 4, 4S, 5, 5S, 5C, and 5SE */\n            @media only screen and (min-device-width: 320px) and (max-device-width: 374px) {\n                u ~ div .email-container {\n                    min-width: 320px !important;\n                }\n            }\n\n            /* iPhone 6, 6S, 7, 8, and X */\n            @media only screen and (min-device-width: 375px) and (max-device-width: 413px) {\n                u ~ div .email-container {\n                    min-width: 375px !important;\n                }\n            }\n\n            /* iPhone 6+, 7+, and 8+ */\n            @media only screen and (min-device-width: 414px) {\n                u ~ div .email-container {\n                    min-width: 414px !important;\n                }\n            }\n\n        </style>\n        <!-- CSS Reset : END -->\n\n        <!-- Progressive Enhancements : BEGIN -->\n        <style>\n\n            /* What it does: Hover styles for buttons */\n            .button-td,\n            .button-a {\n                transition: all 100ms ease-in;\n            }\n\n            .button-td-primary:hover,\n            .button-a-primary:hover {\n                background: #555555 !important;\n                border-color: #555555 !important;\n            }\n\n            /* Media Queries */\n            @media screen and (max-width: 600px) {\n\n                .email-container {\n                    width: 100% !important;\n                    margin: auto !important;\n                }\n\n                /* What it does: Forces table cells into full-width rows. */\n                .stack-column,\n                .stack-column-center {\n                    display: block !important;\n                    width: 100% !important;\n                    max-width: 100% !important;\n                    direction: ltr !important;\n                }\n\n                /* And center justify these ones. */\n                .stack-column-center {\n                    text-align: center !important;\n                }\n\n                /* What it does: Generic utility class for centering. Useful for images, buttons, and nested tables. */\n                .center-on-narrow {\n                    text-align: center !important;\n                    display: block !important;\n                    margin-left: auto !important;\n                    margin-right: auto !important;\n                    float: none !important;\n                }\n\n                table.center-on-narrow {\n                    display: inline-block !important;\n                }\n\n                /* What it does: Adjust typography on small screens to improve readability */\n                .email-container p {\n                    font-size: 17px !important;\n                }\n            }\n\n        </style>\n    </head>\n<body width="100%" style="margin: 0; padding: 0 !important; mso-line-height-rule: exactly; background-color: #dadada;">\n\n<center role="article" aria-roledescription="email" lang="en" style="width: 100%; background-color: #ffffff;">\n\n    <table role="presentation" border="0" cellpadding="0" cellspacing="0" width="100%"\n           style="background-color: #fff;">\n\n    <!-- Preview Text Spacing Hack : BEGIN -->\n    <div style="display: none; font-size: 1px; line-height: 1px; max-height: 0px; max-width: 0px; opacity: 0; overflow: hidden; mso-hide: all; font-family: sans-serif;">\n        &zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;\n    </div>\n    <!-- Preview Text Spacing Hack : END -->\n\n    <!-- Email Body : BEGIN -->\n    <table align="center" role="presentation" cellspacing="0" cellpadding="0" border="0" width="600"\n           style="margin: auto;" class="email-container">\n        <!-- Email Header : BEGIN -->\n        <tr>\n            <td style="padding: 20px 0;">\n                <p><strong>Background regarding the General Meeting on 30 September at 9am</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Dear fellow shareholder,</p>\r\n\r\n<p>You should by now have received notice of a General Meeting with a resolution to change the directors of the company and you will be wondering about the background to this request.</p>\r\n\r\n<p>The request came from the Shareholder Action Group which was recently formed after general dissatisfaction built up about how our investments were being managed.</p>\r\n\r\n<p>We attach a letter which sets out why and how the Shareholder Action Group came together, information on the financial position of the pub and the major loss of value that has been presided over by James McCulloch.</p>\r\n\r\n<p>Please read the information, consider your position and be prepared to vote either in person at the General Meeting or by proxy.</p>\r\n\r\n<p>We hope that you will see the personal benefit in supporting the resolution.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Thank you.</p>\r\n\r\n<p>The Shareholder Action Group</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Practicalities &ndash; The Proxy form:-</strong></p>\r\n\r\n<p>If you are supportive of the change of directors, the proxy form should be filled in as below. It should be emailed to <a href="mailto:james@harcourtinns.co.uk">james@harcourtinns.co.uk</a>, with the subject &ldquo;Proxy form&rdquo; .&nbsp;</p>\r\n\r\n<p>Please cc&rsquo;d <a href="mailto:harcourt-investors-action-group@atts-systems.com">harcourt-investors-action-group@atts-systems.com</a></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><a name="_Hlk50722516"><img src="data:image/png;base64,[encoded data, 62844 characters]" style="height:408.75pt; width:359.25pt" /> </a></p>\r\n\r\n<h3>&nbsp;</h3>\r\n\r\n<h3><strong>Website: Your login and password details</strong></h3>\r\n\r\n<p>The URL for the website is <a href="https://u18464332.ct.sendgrid.net/ls/click?upn=FcfDpG4MWY7BBJLvMw6-2BmKK0E4CfB1mdiexj2N64LupApus0VuIFxiVF2cLx-2BGLRXv41_WPFvr-2B1ki7aLmMFpZHRZ8JiliobnqUQQeYViDbObHPL98acs5WDmUK-2BbU9clmNW75W1zc6DqpsEx1MCurmD3K1PGCxAjVTiGBEqcfVzDU-2BQFq3rNAE-2B0y8y9WphjZdtUnxx12nUNUM7sgGLFw3acJG3eL0FHp0hh61tASvRsrtmwrBTBB1sJ-2BfBreAE5zLaDJMGFR-2BLE6UqoxObvviHWAEKqcpofq8jPL06EXnJi5gk0bG83XOwLYfiZcPyn3WVQ8gy4BWzY5m84MqPVNeP7gQ-3D-3D">https://london-pubs.atts-systems.com</a><br />\r\nYour login is your email; the password is &quot;londonpubinvestor_184&quot; (please update in My Contact Details)</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>General Meeting logistics:</strong></p>\r\n\r\n<p><strong>Venue </strong>: 55 Shirland Rd, Maida Vale, London, W9 2JD (Hero of Maida pub)<br />\r\n<strong>Date </strong>: Wednesday, 30 September 2020</p>\r\n\r\n<ul>\r\n	<li>09.00h Coach</li>\r\n	<li>10.30h Harcourt</li>\r\n	<li>12.00h Crown</li>\r\n	<li>13.30h Three Cranes</li>\r\n	<li>15.00h Hero</li>\r\n</ul>\r\n\r\n<p>We are asking the directors for clarification of the logistics given the recently announced Rule of 6.&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\n    <h3>Website: Your login and password details</h3>\n    <p>The URL for the website is <a href="https://london-pubs.atts-systems.com">https://london-pubs.atts-systems.com</a>\n        <br>\n\n                    Your login is your email (nurse_stephen@hotmail.com); the password is "londonpubinvestor_184" (unless you changed yourself)\n        \n        <br>\n    </p>\n             </td>\n        </tr>\n    </table>\n</center>\n\n\n    <!-- Optional JavaScript -->\n</body>\n</html>\n', '/admin/attachments/notify/Harcourt-Investor-email-Final-8-Sep-2020.pdf', 'ALL - Stephen Nurse (IT admin account) : Background regarding the General Meeting on 30 September at 9am', '2020-09-11 17:16:49', '2020-09-11 17:18:06', NULL, '/home/attssyg/london-pubs/public/admin/attachments/notify//Harcourt-Investor-email-Final-8-Sep-2020.pdf', 7),
	(476, 'sjwn71@gmail.com', '<!DOCTYPE html>\n<html>\n<head>\n    <meta charset="utf-8"> <!-- utf-8 works for most cases -->\n    <meta name="viewport" content="width=device-width"> <!-- Forcing initial-scale shouldn\'t be necessary -->\n    <meta http-equiv="X-UA-Compatible" content="IE=edge"> <!-- Use the latest (edge) version of IE rendering engine -->\n    <meta name="x-apple-disable-message-reformatting">  <!-- Disable auto-scale in iOS 10 Mail entirely -->\n    <meta name="format-detection" content="telephone=no,address=no,email=no,date=no,url=no">\n    <!-- Tell iOS not to automatically link certain text strings. -->\n    <meta name="color-scheme" content="light">\n    <meta name="supported-color-schemes" content="light">\n\n    <title>Background regarding the General Meeting on 30 September at 9am </title>\n            <style>\n\n            /* What it does: Tells the email client that only light styles are provided but the client can transform them to dark. A duplicate of meta color-scheme meta tag above. */\n            :root {\n                color-scheme: light;\n                supported-color-schemes: light;\n            }\n\n            /* What it does: Remove spaces around the email design added by some email clients. */\n            /* Beware: It can remove the padding / margin and add a background color to the compose a reply window. */\n            html,\n            body {\n                margin: 0 auto !important;\n                padding: 0 !important;\n                height: 100% !important;\n                width: 100% !important;\n            }\n\n            /* What it does: Stops email clients resizing small text. */\n            * {\n                -ms-text-size-adjust: 100%;\n                -webkit-text-size-adjust: 100%;\n            }\n\n            /* What it does: Centers email on Android 4.4 */\n            div[style*="margin: 16px 0"] {\n                margin: 0 !important;\n            }\n\n            /* What it does: forces Samsung Android mail clients to use the entire viewport */\n            #MessageViewBody, #MessageWebViewDiv {\n                width: 100% !important;\n            }\n\n            /* What it does: Stops Outlook from adding extra spacing to tables. */\n            table,\n            td {\n                mso-table-lspace: 0pt !important;\n                mso-table-rspace: 0pt !important;\n            }\n\n            /* What it does: Replaces default bold style. */\n            th {\n                font-weight: normal;\n            }\n\n            /* What it does: Fixes webkit padding issue. */\n            table {\n                border-spacing: 0 !important;\n                border-collapse: collapse !important;\n                table-layout: fixed !important;\n                margin: 0 auto !important;\n            }\n\n            /* What it does: Prevents Windows 10 Mail from underlining links despite inline CSS. Styles for underlined links should be inline. */\n            a {\n                text-decoration: none;\n            }\n\n            /* What it does: Uses a better rendering method when resizing images in IE. */\n            img {\n                -ms-interpolation-mode: bicubic;\n            }\n\n            /* What it does: A work-around for email clients meddling in triggered links. */\n            a[x-apple-data-detectors], /* iOS */\n            .unstyle-auto-detected-links a,\n            .aBn {\n                border-bottom: 0 !important;\n                cursor: default !important;\n                color: inherit !important;\n                text-decoration: none !important;\n                font-size: inherit !important;\n                font-family: inherit !important;\n                font-weight: inherit !important;\n                line-height: inherit !important;\n            }\n\n            /* What it does: Prevents Gmail from changing the text color in conversation threads. */\n            .im {\n                color: inherit !important;\n            }\n\n            /* What it does: Prevents Gmail from displaying a download button on large, non-linked images. */\n            .a6S {\n                display: none !important;\n                opacity: 0.01 !important;\n            }\n\n            /* If the above doesn\'t work, add a .g-img class to any image in question. */\n            img.g-img + div {\n                display: none !important;\n            }\n\n            /* What it does: Removes right gutter in Gmail iOS app: https://github.com/TedGoas/Cerberus/issues/89  */\n            /* Create one of these media queries for each additional viewport size you\'d like to fix */\n\n            /* iPhone 4, 4S, 5, 5S, 5C, and 5SE */\n            @media only screen and (min-device-width: 320px) and (max-device-width: 374px) {\n                u ~ div .email-container {\n                    min-width: 320px !important;\n                }\n            }\n\n            /* iPhone 6, 6S, 7, 8, and X */\n            @media only screen and (min-device-width: 375px) and (max-device-width: 413px) {\n                u ~ div .email-container {\n                    min-width: 375px !important;\n                }\n            }\n\n            /* iPhone 6+, 7+, and 8+ */\n            @media only screen and (min-device-width: 414px) {\n                u ~ div .email-container {\n                    min-width: 414px !important;\n                }\n            }\n\n        </style>\n        <!-- CSS Reset : END -->\n\n        <!-- Progressive Enhancements : BEGIN -->\n        <style>\n\n            /* What it does: Hover styles for buttons */\n            .button-td,\n            .button-a {\n                transition: all 100ms ease-in;\n            }\n\n            .button-td-primary:hover,\n            .button-a-primary:hover {\n                background: #555555 !important;\n                border-color: #555555 !important;\n            }\n\n            /* Media Queries */\n            @media screen and (max-width: 600px) {\n\n                .email-container {\n                    width: 100% !important;\n                    margin: auto !important;\n                }\n\n                /* What it does: Forces table cells into full-width rows. */\n                .stack-column,\n                .stack-column-center {\n                    display: block !important;\n                    width: 100% !important;\n                    max-width: 100% !important;\n                    direction: ltr !important;\n                }\n\n                /* And center justify these ones. */\n                .stack-column-center {\n                    text-align: center !important;\n                }\n\n                /* What it does: Generic utility class for centering. Useful for images, buttons, and nested tables. */\n                .center-on-narrow {\n                    text-align: center !important;\n                    display: block !important;\n                    margin-left: auto !important;\n                    margin-right: auto !important;\n                    float: none !important;\n                }\n\n                table.center-on-narrow {\n                    display: inline-block !important;\n                }\n\n                /* What it does: Adjust typography on small screens to improve readability */\n                .email-container p {\n                    font-size: 17px !important;\n                }\n            }\n\n        </style>\n    </head>\n<body width="100%" style="margin: 0; padding: 0 !important; mso-line-height-rule: exactly; background-color: #dadada;">\n\n<center role="article" aria-roledescription="email" lang="en" style="width: 100%; background-color: #ffffff;">\n\n    <table role="presentation" border="0" cellpadding="0" cellspacing="0" width="100%"\n           style="background-color: #fff;">\n\n    <!-- Preview Text Spacing Hack : BEGIN -->\n    <div style="display: none; font-size: 1px; line-height: 1px; max-height: 0px; max-width: 0px; opacity: 0; overflow: hidden; mso-hide: all; font-family: sans-serif;">\n        &zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;\n    </div>\n    <!-- Preview Text Spacing Hack : END -->\n\n    <!-- Email Body : BEGIN -->\n    <table align="center" role="presentation" cellspacing="0" cellpadding="0" border="0" width="600"\n           style="margin: auto;" class="email-container">\n        <!-- Email Header : BEGIN -->\n        <tr>\n            <td style="padding: 20px 0;">\n                <p>Dear fellow shareholder,</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>You should by now have received notice of a General Meeting with a resolution to change the directors of the company and you will be wondering about the background to this request.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>The request came from the Shareholder Action Group which was recently formed after general dissatisfaction built up about how our investments were being managed.</p>\r\n\r\n<p>We attach a letter which sets out why and how the Shareholder Action Group came together, information on the financial position of the pub and the major loss of value that has been presided over by James McCulloch.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Please read the information, consider your position and be prepared to vote either in person at the General Meeting or by proxy.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>We hope that you will see the personal benefit in supporting the resolution.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Thank you.</p>\r\n\r\n<p>The Shareholder Action Group</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Next steps &ndash; The Proxy form:-</strong></p>\r\n\r\n<p>If you are supportive of the change of directors, the proxy form should be filled in as below. It should be emailed to <a href="mailto:james@harcourtinns.co.uk">james@harcourtinns.co.uk</a>, with the subject &ldquo;Proxy form&rdquo;.&nbsp;</p>\r\n\r\n<p>Please cc&rsquo;d <a href="mailto:harcourt-investors-action-group@atts-systems.com">harcourt-investors-action-group@atts-systems.com</a></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><a name="_Hlk50722516"><img src="data:image/png;base64,[encoded data, 62844 characters]" style="height:408.75pt; width:359.25pt" /> </a></p>\r\n\r\n<h3>&nbsp;</h3>\r\n\r\n<p><strong>General Meeting logistics:</strong></p>\r\n\r\n<p><strong>Venue </strong>: 55 Shirland Rd, Maida Vale, London, W9 2JD (Hero of Maida pub)<br />\r\n<strong>Date </strong>: Wednesday, 30 September 2020</p>\r\n\r\n<ul>\r\n	<li>09.00h Coach</li>\r\n	<li>10.30h Harcourt</li>\r\n	<li>12.00h Crown</li>\r\n	<li>13.30h Three Cranes</li>\r\n	<li>15.00h Hero</li>\r\n</ul>\r\n\r\n<p>We are asking the directors for clarification of the logistics given the recently announced Rule of 6.&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\n    <h3>Website: Your login and password details</h3>\n    <p>The URL for the website is <a href="https://london-pubs.atts-systems.com">https://london-pubs.atts-systems.com</a>\n        <br>\n\n                    Your login is your email (sjwn71@gmail.com); the password is "Descartes99"\n        \n        <br>\n    </p>\n             </td>\n        </tr>\n    </table>\n</center>\n\n\n    <!-- Optional JavaScript -->\n</body>\n</html>\n', '/admin/attachments/notify/Hero-Investor-email-Final-8-Sep-2020.pdf', 'ALL - Stephen Nurse : Background regarding the General Meeting on 30 September at 9am', '2020-09-11 17:31:36', '2020-09-11 17:31:50', NULL, '/home/attssyg/london-pubs/public/admin/attachments/notify//Hero-Investor-email-Final-8-Sep-2020.pdf', 7),
	(477, 'nurse_stephen@hotmail.com', '<!DOCTYPE html>\n<html>\n<head>\n    <meta charset="utf-8"> <!-- utf-8 works for most cases -->\n    <meta name="viewport" content="width=device-width"> <!-- Forcing initial-scale shouldn\'t be necessary -->\n    <meta http-equiv="X-UA-Compatible" content="IE=edge"> <!-- Use the latest (edge) version of IE rendering engine -->\n    <meta name="x-apple-disable-message-reformatting">  <!-- Disable auto-scale in iOS 10 Mail entirely -->\n    <meta name="format-detection" content="telephone=no,address=no,email=no,date=no,url=no">\n    <!-- Tell iOS not to automatically link certain text strings. -->\n    <meta name="color-scheme" content="light">\n    <meta name="supported-color-schemes" content="light">\n\n    <title>Background regarding the General Meeting on 30 September at 9am </title>\n            <style>\n\n            /* What it does: Tells the email client that only light styles are provided but the client can transform them to dark. A duplicate of meta color-scheme meta tag above. */\n            :root {\n                color-scheme: light;\n                supported-color-schemes: light;\n            }\n\n            /* What it does: Remove spaces around the email design added by some email clients. */\n            /* Beware: It can remove the padding / margin and add a background color to the compose a reply window. */\n            html,\n            body {\n                margin: 0 auto !important;\n                padding: 0 !important;\n                height: 100% !important;\n                width: 100% !important;\n            }\n\n            /* What it does: Stops email clients resizing small text. */\n            * {\n                -ms-text-size-adjust: 100%;\n                -webkit-text-size-adjust: 100%;\n            }\n\n            /* What it does: Centers email on Android 4.4 */\n            div[style*="margin: 16px 0"] {\n                margin: 0 !important;\n            }\n\n            /* What it does: forces Samsung Android mail clients to use the entire viewport */\n            #MessageViewBody, #MessageWebViewDiv {\n                width: 100% !important;\n            }\n\n            /* What it does: Stops Outlook from adding extra spacing to tables. */\n            table,\n            td {\n                mso-table-lspace: 0pt !important;\n                mso-table-rspace: 0pt !important;\n            }\n\n            /* What it does: Replaces default bold style. */\n            th {\n                font-weight: normal;\n            }\n\n            /* What it does: Fixes webkit padding issue. */\n            table {\n                border-spacing: 0 !important;\n                border-collapse: collapse !important;\n                table-layout: fixed !important;\n                margin: 0 auto !important;\n            }\n\n            /* What it does: Prevents Windows 10 Mail from underlining links despite inline CSS. Styles for underlined links should be inline. */\n            a {\n                text-decoration: none;\n            }\n\n            /* What it does: Uses a better rendering method when resizing images in IE. */\n            img {\n                -ms-interpolation-mode: bicubic;\n            }\n\n            /* What it does: A work-around for email clients meddling in triggered links. */\n            a[x-apple-data-detectors], /* iOS */\n            .unstyle-auto-detected-links a,\n            .aBn {\n                border-bottom: 0 !important;\n                cursor: default !important;\n                color: inherit !important;\n                text-decoration: none !important;\n                font-size: inherit !important;\n                font-family: inherit !important;\n                font-weight: inherit !important;\n                line-height: inherit !important;\n            }\n\n            /* What it does: Prevents Gmail from changing the text color in conversation threads. */\n            .im {\n                color: inherit !important;\n            }\n\n            /* What it does: Prevents Gmail from displaying a download button on large, non-linked images. */\n            .a6S {\n                display: none !important;\n                opacity: 0.01 !important;\n            }\n\n            /* If the above doesn\'t work, add a .g-img class to any image in question. */\n            img.g-img + div {\n                display: none !important;\n            }\n\n            /* What it does: Removes right gutter in Gmail iOS app: https://github.com/TedGoas/Cerberus/issues/89  */\n            /* Create one of these media queries for each additional viewport size you\'d like to fix */\n\n            /* iPhone 4, 4S, 5, 5S, 5C, and 5SE */\n            @media only screen and (min-device-width: 320px) and (max-device-width: 374px) {\n                u ~ div .email-container {\n                    min-width: 320px !important;\n                }\n            }\n\n            /* iPhone 6, 6S, 7, 8, and X */\n            @media only screen and (min-device-width: 375px) and (max-device-width: 413px) {\n                u ~ div .email-container {\n                    min-width: 375px !important;\n                }\n            }\n\n            /* iPhone 6+, 7+, and 8+ */\n            @media only screen and (min-device-width: 414px) {\n                u ~ div .email-container {\n                    min-width: 414px !important;\n                }\n            }\n\n        </style>\n        <!-- CSS Reset : END -->\n\n        <!-- Progressive Enhancements : BEGIN -->\n        <style>\n\n            /* What it does: Hover styles for buttons */\n            .button-td,\n            .button-a {\n                transition: all 100ms ease-in;\n            }\n\n            .button-td-primary:hover,\n            .button-a-primary:hover {\n                background: #555555 !important;\n                border-color: #555555 !important;\n            }\n\n            /* Media Queries */\n            @media screen and (max-width: 600px) {\n\n                .email-container {\n                    width: 100% !important;\n                    margin: auto !important;\n                }\n\n                /* What it does: Forces table cells into full-width rows. */\n                .stack-column,\n                .stack-column-center {\n                    display: block !important;\n                    width: 100% !important;\n                    max-width: 100% !important;\n                    direction: ltr !important;\n                }\n\n                /* And center justify these ones. */\n                .stack-column-center {\n                    text-align: center !important;\n                }\n\n                /* What it does: Generic utility class for centering. Useful for images, buttons, and nested tables. */\n                .center-on-narrow {\n                    text-align: center !important;\n                    display: block !important;\n                    margin-left: auto !important;\n                    margin-right: auto !important;\n                    float: none !important;\n                }\n\n                table.center-on-narrow {\n                    display: inline-block !important;\n                }\n\n                /* What it does: Adjust typography on small screens to improve readability */\n                .email-container p {\n                    font-size: 17px !important;\n                }\n            }\n\n        </style>\n    </head>\n<body width="100%" style="margin: 0; padding: 0 !important; mso-line-height-rule: exactly; background-color: #dadada;">\n\n<center role="article" aria-roledescription="email" lang="en" style="width: 100%; background-color: #ffffff;">\n\n    <table role="presentation" border="0" cellpadding="0" cellspacing="0" width="100%"\n           style="background-color: #fff;">\n\n    <!-- Preview Text Spacing Hack : BEGIN -->\n    <div style="display: none; font-size: 1px; line-height: 1px; max-height: 0px; max-width: 0px; opacity: 0; overflow: hidden; mso-hide: all; font-family: sans-serif;">\n        &zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;\n    </div>\n    <!-- Preview Text Spacing Hack : END -->\n\n    <!-- Email Body : BEGIN -->\n    <table align="center" role="presentation" cellspacing="0" cellpadding="0" border="0" width="600"\n           style="margin: auto;" class="email-container">\n        <!-- Email Header : BEGIN -->\n        <tr>\n            <td style="padding: 20px 0;">\n                <p>Dear fellow shareholder,</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>You should by now have received notice of a General Meeting with a resolution to change the directors of the company and you will be wondering about the background to this request.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>The request came from the Shareholder Action Group which was recently formed after general dissatisfaction built up about how our investments were being managed.</p>\r\n\r\n<p>We attach a letter which sets out why and how the Shareholder Action Group came together, information on the financial position of the pub and the major loss of value that has been presided over by James McCulloch.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Please read the information, consider your position and be prepared to vote either in person at the General Meeting or by proxy.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>We hope that you will see the personal benefit in supporting the resolution.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Thank you.</p>\r\n\r\n<p>The Shareholder Action Group</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Next steps &ndash; The Proxy form:-</strong></p>\r\n\r\n<p>If you are supportive of the change of directors, the proxy form should be filled in as below. It should be emailed to <a href="mailto:james@harcourtinns.co.uk">james@harcourtinns.co.uk</a>, with the subject &ldquo;Proxy form&rdquo;.&nbsp;</p>\r\n\r\n<p>Please cc&rsquo;d <a href="mailto:harcourt-investors-action-group@atts-systems.com">harcourt-investors-action-group@atts-systems.com</a></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><a name="_Hlk50722516"><img src="data:image/png;base64,[encoded data, 62844 characters]" style="height:408.75pt; width:359.25pt" /> </a></p>\r\n\r\n<h3>&nbsp;</h3>\r\n\r\n<p><strong>General Meeting logistics:</strong></p>\r\n\r\n<p><strong>Venue </strong>: 55 Shirland Rd, Maida Vale, London, W9 2JD (Hero of Maida pub)<br />\r\n<strong>Date </strong>: Wednesday, 30 September 2020</p>\r\n\r\n<ul>\r\n	<li>09.00h Coach</li>\r\n	<li>10.30h Harcourt</li>\r\n	<li>12.00h Crown</li>\r\n	<li>13.30h Three Cranes</li>\r\n	<li>15.00h Hero</li>\r\n</ul>\r\n\r\n<p>We are asking the directors for clarification of the logistics given the recently announced Rule of 6.&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\n    <h3>Website: Your login and password details</h3>\n    <p>The URL for the website is <a href="https://london-pubs.atts-systems.com">https://london-pubs.atts-systems.com</a>\n        <br>\n\n                    Your login is your email (nurse_stephen@hotmail.com); the password is "londonpubinvestor_184" (unless you changed yourself)\n        \n        <br>\n    </p>\n             </td>\n        </tr>\n    </table>\n</center>\n\n\n    <!-- Optional JavaScript -->\n</body>\n</html>\n', '/admin/attachments/notify/Hero-Investor-email-Final-8-Sep-2020.pdf', 'ALL - Stephen Nurse (IT admin account) : Background regarding the General Meeting on 30 September at 9am', '2020-09-11 17:31:36', '2020-09-11 17:31:50', NULL, '/home/attssyg/london-pubs/public/admin/attachments/notify//Hero-Investor-email-Final-8-Sep-2020.pdf', 7),
	(478, 'adamwatkins@me.com', '<!DOCTYPE html>\n<html>\n<head>\n    <meta charset="utf-8"> <!-- utf-8 works for most cases -->\n    <meta name="viewport" content="width=device-width"> <!-- Forcing initial-scale shouldn\'t be necessary -->\n    <meta http-equiv="X-UA-Compatible" content="IE=edge"> <!-- Use the latest (edge) version of IE rendering engine -->\n    <meta name="x-apple-disable-message-reformatting">  <!-- Disable auto-scale in iOS 10 Mail entirely -->\n    <meta name="format-detection" content="telephone=no,address=no,email=no,date=no,url=no">\n    <!-- Tell iOS not to automatically link certain text strings. -->\n    <meta name="color-scheme" content="light">\n    <meta name="supported-color-schemes" content="light">\n\n    <title>Background regarding the General Meeting on 30 September at 10.30am </title>\n            <style>\n\n            /* What it does: Tells the email client that only light styles are provided but the client can transform them to dark. A duplicate of meta color-scheme meta tag above. */\n            :root {\n                color-scheme: light;\n                supported-color-schemes: light;\n            }\n\n            /* What it does: Remove spaces around the email design added by some email clients. */\n            /* Beware: It can remove the padding / margin and add a background color to the compose a reply window. */\n            html,\n            body {\n                margin: 0 auto !important;\n                padding: 0 !important;\n                height: 100% !important;\n                width: 100% !important;\n            }\n\n            /* What it does: Stops email clients resizing small text. */\n            * {\n                -ms-text-size-adjust: 100%;\n                -webkit-text-size-adjust: 100%;\n            }\n\n            /* What it does: Centers email on Android 4.4 */\n            div[style*="margin: 16px 0"] {\n                margin: 0 !important;\n            }\n\n            /* What it does: forces Samsung Android mail clients to use the entire viewport */\n            #MessageViewBody, #MessageWebViewDiv {\n                width: 100% !important;\n            }\n\n            /* What it does: Stops Outlook from adding extra spacing to tables. */\n            table,\n            td {\n                mso-table-lspace: 0pt !important;\n                mso-table-rspace: 0pt !important;\n            }\n\n            /* What it does: Replaces default bold style. */\n            th {\n                font-weight: normal;\n            }\n\n            /* What it does: Fixes webkit padding issue. */\n            table {\n                border-spacing: 0 !important;\n                border-collapse: collapse !important;\n                table-layout: fixed !important;\n                margin: 0 auto !important;\n            }\n\n            /* What it does: Prevents Windows 10 Mail from underlining links despite inline CSS. Styles for underlined links should be inline. */\n            a {\n                text-decoration: none;\n            }\n\n            /* What it does: Uses a better rendering method when resizing images in IE. */\n            img {\n                -ms-interpolation-mode: bicubic;\n            }\n\n            /* What it does: A work-around for email clients meddling in triggered links. */\n            a[x-apple-data-detectors], /* iOS */\n            .unstyle-auto-detected-links a,\n            .aBn {\n                border-bottom: 0 !important;\n                cursor: default !important;\n                color: inherit !important;\n                text-decoration: none !important;\n                font-size: inherit !important;\n                font-family: inherit !important;\n                font-weight: inherit !important;\n                line-height: inherit !important;\n            }\n\n            /* What it does: Prevents Gmail from changing the text color in conversation threads. */\n            .im {\n                color: inherit !important;\n            }\n\n            /* What it does: Prevents Gmail from displaying a download button on large, non-linked images. */\n            .a6S {\n                display: none !important;\n                opacity: 0.01 !important;\n            }\n\n            /* If the above doesn\'t work, add a .g-img class to any image in question. */\n            img.g-img + div {\n                display: none !important;\n            }\n\n            /* What it does: Removes right gutter in Gmail iOS app: https://github.com/TedGoas/Cerberus/issues/89  */\n            /* Create one of these media queries for each additional viewport size you\'d like to fix */\n\n            /* iPhone 4, 4S, 5, 5S, 5C, and 5SE */\n            @media only screen and (min-device-width: 320px) and (max-device-width: 374px) {\n                u ~ div .email-container {\n                    min-width: 320px !important;\n                }\n            }\n\n            /* iPhone 6, 6S, 7, 8, and X */\n            @media only screen and (min-device-width: 375px) and (max-device-width: 413px) {\n                u ~ div .email-container {\n                    min-width: 375px !important;\n                }\n            }\n\n            /* iPhone 6+, 7+, and 8+ */\n            @media only screen and (min-device-width: 414px) {\n                u ~ div .email-container {\n                    min-width: 414px !important;\n                }\n            }\n\n        </style>\n        <!-- CSS Reset : END -->\n\n        <!-- Progressive Enhancements : BEGIN -->\n        <style>\n\n            /* What it does: Hover styles for buttons */\n            .button-td,\n            .button-a {\n                transition: all 100ms ease-in;\n            }\n\n            .button-td-primary:hover,\n            .button-a-primary:hover {\n                background: #555555 !important;\n                border-color: #555555 !important;\n            }\n\n            /* Media Queries */\n            @media screen and (max-width: 600px) {\n\n                .email-container {\n                    width: 100% !important;\n                    margin: auto !important;\n                }\n\n                /* What it does: Forces table cells into full-width rows. */\n                .stack-column,\n                .stack-column-center {\n                    display: block !important;\n                    width: 100% !important;\n                    max-width: 100% !important;\n                    direction: ltr !important;\n                }\n\n                /* And center justify these ones. */\n                .stack-column-center {\n                    text-align: center !important;\n                }\n\n                /* What it does: Generic utility class for centering. Useful for images, buttons, and nested tables. */\n                .center-on-narrow {\n                    text-align: center !important;\n                    display: block !important;\n                    margin-left: auto !important;\n                    margin-right: auto !important;\n                    float: none !important;\n                }\n\n                table.center-on-narrow {\n                    display: inline-block !important;\n                }\n\n                /* What it does: Adjust typography on small screens to improve readability */\n                .email-container p {\n                    font-size: 17px !important;\n                }\n            }\n\n        </style>\n    </head>\n<body width="100%" style="margin: 0; padding: 0 !important; mso-line-height-rule: exactly; background-color: #dadada;">\n\n<center role="article" aria-roledescription="email" lang="en" style="width: 100%; background-color: #ffffff;">\n\n    <table role="presentation" border="0" cellpadding="0" cellspacing="0" width="100%"\n           style="background-color: #fff;">\n\n    <!-- Preview Text Spacing Hack : BEGIN -->\n    <div style="display: none; font-size: 1px; line-height: 1px; max-height: 0px; max-width: 0px; opacity: 0; overflow: hidden; mso-hide: all; font-family: sans-serif;">\n        &zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;\n    </div>\n    <!-- Preview Text Spacing Hack : END -->\n\n    <!-- Email Body : BEGIN -->\n    <table align="center" role="presentation" cellspacing="0" cellpadding="0" border="0" width="600"\n           style="margin: auto;" class="email-container">\n        <!-- Email Header : BEGIN -->\n        <tr>\n            <td style="padding: 20px 0;">\n                <p>Dear fellow shareholder,</p>\r\n\r\n<p>You should by now have received notice of a General Meeting with a resolution to change the directors of the company and you will be wondering about the background to this request.</p>\r\n\r\n<p>The request came from the Shareholder Action Group which was recently formed after general dissatisfaction built up about how our investments were being managed.</p>\r\n\r\n<p>We attach a letter that sets out why and how the Shareholder Action Group came together, information on the financial position of the pub and the major loss of value that has been presided over by James McCulloch.</p>\r\n\r\n<p>Please read the information, consider your position and be prepared to vote either in person at the General Meeting or by proxy.</p>\r\n\r\n<p>We hope that you will see the personal benefit in supporting the resolution.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Thank you.</p>\r\n\r\n<p>The Shareholder Action Group</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Practicalities &ndash; The Proxy form:-</strong></p>\r\n\r\n<p>If you are supportive of the change of directors, the proxy form should be filled in as below. It should be emailed to <a href="mailto:james@harcourtinns.co.uk">james@harcourtinns.co.uk</a>, with the subject &ldquo;Proxy form&rdquo;.&nbsp;</p>\r\n\r\n<p>Please cc: &nbsp;<a href="mailto:harcourt-investors-action-group@atts-systems.com">harcourt-investors-action-group@atts-systems.com</a></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><a name="_Hlk50722516"><img src="data:image/png;base64,[encoded data, 62844 characters]" style="height:408.75pt; width:359.25pt" /> </a></p>\r\n\r\n<h3>&nbsp;</h3>\r\n\r\n<p><strong>General Meeting logistics:</strong></p>\r\n\r\n<p><strong>Venue </strong>: 55 Shirland Rd, Maida Vale, London, W9 2JD (Hero of Maida pub)<br />\r\n<strong>Date </strong>: Wednesday, 30 September 2020</p>\r\n\r\n<ul>\r\n	<li>09.00h Coach</li>\r\n	<li>10.30h Harcourt</li>\r\n	<li>12.00h Crown</li>\r\n	<li>13.30h Three Cranes</li>\r\n	<li>15.00h Hero</li>\r\n</ul>\n    <h3>Website: Your login and password details</h3>\n    <p>The URL for the website is <a href="https://london-pubs.atts-systems.com">https://london-pubs.atts-systems.com</a>\n        <br>\n\n                    Your login is your email (adamwatkins@me.com); the password is "zYpzy5-gedsik-pezfow"\n        \n        <br>\n    </p>\n             </td>\n        </tr>\n    </table>\n</center>\n\n\n    <!-- Optional JavaScript -->\n</body>\n</html>\n', '/admin/attachments/notify/Harcourt-Investor-email-Final-8-Sep-2020.pdf', 'Harcourt - Adam Oliver-Watkins : Background regarding the General Meeting on 30 September at 10.30am', '2020-09-11 17:56:28', '2020-09-11 18:13:57', NULL, '/home/attssyg/london-pubs/public/admin/attachments/notify//Harcourt-Investor-email-Final-8-Sep-2020.pdf', 7),
	(479, 'dave.fishwick@mandg.co.uk', '<!DOCTYPE html>\n<html>\n<head>\n    <meta charset="utf-8"> <!-- utf-8 works for most cases -->\n    <meta name="viewport" content="width=device-width"> <!-- Forcing initial-scale shouldn\'t be necessary -->\n    <meta http-equiv="X-UA-Compatible" content="IE=edge"> <!-- Use the latest (edge) version of IE rendering engine -->\n    <meta name="x-apple-disable-message-reformatting">  <!-- Disable auto-scale in iOS 10 Mail entirely -->\n    <meta name="format-detection" content="telephone=no,address=no,email=no,date=no,url=no">\n    <!-- Tell iOS not to automatically link certain text strings. -->\n    <meta name="color-scheme" content="light">\n    <meta name="supported-color-schemes" content="light">\n\n    <title>Background regarding the General Meeting on 30 September at 10.30am </title>\n            <style>\n\n            /* What it does: Tells the email client that only light styles are provided but the client can transform them to dark. A duplicate of meta color-scheme meta tag above. */\n            :root {\n                color-scheme: light;\n                supported-color-schemes: light;\n            }\n\n            /* What it does: Remove spaces around the email design added by some email clients. */\n            /* Beware: It can remove the padding / margin and add a background color to the compose a reply window. */\n            html,\n            body {\n                margin: 0 auto !important;\n                padding: 0 !important;\n                height: 100% !important;\n                width: 100% !important;\n            }\n\n            /* What it does: Stops email clients resizing small text. */\n            * {\n                -ms-text-size-adjust: 100%;\n                -webkit-text-size-adjust: 100%;\n            }\n\n            /* What it does: Centers email on Android 4.4 */\n            div[style*="margin: 16px 0"] {\n                margin: 0 !important;\n            }\n\n            /* What it does: forces Samsung Android mail clients to use the entire viewport */\n            #MessageViewBody, #MessageWebViewDiv {\n                width: 100% !important;\n            }\n\n            /* What it does: Stops Outlook from adding extra spacing to tables. */\n            table,\n            td {\n                mso-table-lspace: 0pt !important;\n                mso-table-rspace: 0pt !important;\n            }\n\n            /* What it does: Replaces default bold style. */\n            th {\n                font-weight: normal;\n            }\n\n            /* What it does: Fixes webkit padding issue. */\n            table {\n                border-spacing: 0 !important;\n                border-collapse: collapse !important;\n                table-layout: fixed !important;\n                margin: 0 auto !important;\n            }\n\n            /* What it does: Prevents Windows 10 Mail from underlining links despite inline CSS. Styles for underlined links should be inline. */\n            a {\n                text-decoration: none;\n            }\n\n            /* What it does: Uses a better rendering method when resizing images in IE. */\n            img {\n                -ms-interpolation-mode: bicubic;\n            }\n\n            /* What it does: A work-around for email clients meddling in triggered links. */\n            a[x-apple-data-detectors], /* iOS */\n            .unstyle-auto-detected-links a,\n            .aBn {\n                border-bottom: 0 !important;\n                cursor: default !important;\n                color: inherit !important;\n                text-decoration: none !important;\n                font-size: inherit !important;\n                font-family: inherit !important;\n                font-weight: inherit !important;\n                line-height: inherit !important;\n            }\n\n            /* What it does: Prevents Gmail from changing the text color in conversation threads. */\n            .im {\n                color: inherit !important;\n            }\n\n            /* What it does: Prevents Gmail from displaying a download button on large, non-linked images. */\n            .a6S {\n                display: none !important;\n                opacity: 0.01 !important;\n            }\n\n            /* If the above doesn\'t work, add a .g-img class to any image in question. */\n            img.g-img + div {\n                display: none !important;\n            }\n\n            /* What it does: Removes right gutter in Gmail iOS app: https://github.com/TedGoas/Cerberus/issues/89  */\n            /* Create one of these media queries for each additional viewport size you\'d like to fix */\n\n            /* iPhone 4, 4S, 5, 5S, 5C, and 5SE */\n            @media only screen and (min-device-width: 320px) and (max-device-width: 374px) {\n                u ~ div .email-container {\n                    min-width: 320px !important;\n                }\n            }\n\n            /* iPhone 6, 6S, 7, 8, and X */\n            @media only screen and (min-device-width: 375px) and (max-device-width: 413px) {\n                u ~ div .email-container {\n                    min-width: 375px !important;\n                }\n            }\n\n            /* iPhone 6+, 7+, and 8+ */\n            @media only screen and (min-device-width: 414px) {\n                u ~ div .email-container {\n                    min-width: 414px !important;\n                }\n            }\n\n        </style>\n        <!-- CSS Reset : END -->\n\n        <!-- Progressive Enhancements : BEGIN -->\n        <style>\n\n            /* What it does: Hover styles for buttons */\n            .button-td,\n            .button-a {\n                transition: all 100ms ease-in;\n            }\n\n            .button-td-primary:hover,\n            .button-a-primary:hover {\n                background: #555555 !important;\n                border-color: #555555 !important;\n            }\n\n            /* Media Queries */\n            @media screen and (max-width: 600px) {\n\n                .email-container {\n                    width: 100% !important;\n                    margin: auto !important;\n                }\n\n                /* What it does: Forces table cells into full-width rows. */\n                .stack-column,\n                .stack-column-center {\n                    display: block !important;\n                    width: 100% !important;\n                    max-width: 100% !important;\n                    direction: ltr !important;\n                }\n\n                /* And center justify these ones. */\n                .stack-column-center {\n                    text-align: center !important;\n                }\n\n                /* What it does: Generic utility class for centering. Useful for images, buttons, and nested tables. */\n                .center-on-narrow {\n                    text-align: center !important;\n                    display: block !important;\n                    margin-left: auto !important;\n                    margin-right: auto !important;\n                    float: none !important;\n                }\n\n                table.center-on-narrow {\n                    display: inline-block !important;\n                }\n\n                /* What it does: Adjust typography on small screens to improve readability */\n                .email-container p {\n                    font-size: 17px !important;\n                }\n            }\n\n        </style>\n    </head>\n<body width="100%" style="margin: 0; padding: 0 !important; mso-line-height-rule: exactly; background-color: #dadada;">\n\n<center role="article" aria-roledescription="email" lang="en" style="width: 100%; background-color: #ffffff;">\n\n    <table role="presentation" border="0" cellpadding="0" cellspacing="0" width="100%"\n           style="background-color: #fff;">\n\n    <!-- Preview Text Spacing Hack : BEGIN -->\n    <div style="display: none; font-size: 1px; line-height: 1px; max-height: 0px; max-width: 0px; opacity: 0; overflow: hidden; mso-hide: all; font-family: sans-serif;">\n        &zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;&zwnj;&nbsp;\n    </div>\n    <!-- Preview Text Spacing Hack : END -->\n\n    <!-- Email Body : BEGIN -->\n    <table align="center" role="presentation" cellspacing="0" cellpadding="0" border="0" width="600"\n           style="margin: auto;" class="email-container">\n        <!-- Email Header : BEGIN -->\n        <tr>\n            <td style="padding: 20px 0;">\n                <p>Dear fellow shareholder,</p>\r\n\r\n<p>You should by now have received notice of a General Meeting with a resolution to change the directors of the company and you will be wondering about the background to this request.</p>\r\n\r\n<p>The request came from the Shareholder Action Group which was recently formed after general dissatisfaction built up about how our investments were being managed.</p>\r\n\r\n<p>We attach a letter that sets out why and how the Shareholder Action Group came together, information on the financial position of the pub and the major loss of value that has been presided over by James McCulloch.</p>\r\n\r\n<p>Please read the information, consider your position and be prepared to vote either in person at the General Meeting or by proxy.</p>\r\n\r\n<p>We hope that you will see the personal benefit in supporting the resolution.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Thank you.</p>\r\n\r\n<p>The Shareholder Action Group</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Practicalities &ndash; The Proxy form:-</strong></p>\r\n\r\n<p>If you are supportive of the change of directors, the proxy form should be filled in as below. It should be emailed to <a href="mailto:james@harcourtinns.co.uk">james@harcourtinns.co.uk</a>, with the subject &ldquo;Proxy form&rdquo;.&nbsp;</p>\r\n\r\n<p>Please cc: &nbsp;<a href="mailto:harcourt-investors-action-group@atts-systems.com">harcourt-investors-action-group@atts-systems.com</a></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><a name="_Hlk50722516"><img src="data:image/png;base64,[encoded data, 62844 characters]" style="height:408.75pt; width:359.25pt" /> </a></p>\r\n\r\n<h3>&nbsp;</h3>\r\n\r\n<p><strong>General Meeting logistics:</strong></p>\r\n\r\n<p><strong>Venue </strong>: 55 Shirland Rd, Maida Vale, London, W9 2JD (Hero of Maida pub)<br />\r\n<strong>Date </strong>: Wednesday, 30 September 2020</p>\r\n\r\n<ul>\r\n	<li>09.00h Coach</li>\r\n	<li>10.30h Harcourt</li>\r\n	<li>12.00h Crown</li>\r\n	<li>13.30h Three Cranes</li>\r\n	<li>15.00h Hero</li>\r\n</ul>\n    <h3>Website: Your login and password details</h3>\n    <p>The URL for the website is <a href="https://london-pubs.atts-systems.com">https://london-pubs.atts-systems.com</a>\n        <br>\n\n                    Your login is your email (dave.fishwick@mandg.co.uk); the password is "londonpubinvestor_184" (unless you changed yourself)\n        \n        <br>\n    </p>\n             </td>\n        </tr>\n    </table>\n</center>\n\n\n    <!-- Optional JavaScript -->\n</body>\n</html>\n', '/admin/attachments/notify/Harcourt-Investor-email-Final-8-Sep-2020.pdf', 'Harcourt - David Fishwick : Background regarding the General Meeting on 30 September at 10.30am', '2020-09-11 17:56:28', '2020-09-11 20:00:05', 'nicholasstockdale@googlemail.com', '/home/attssyg/london-pubs/public/admin/attachments/notify//Harcourt-Investor-email-Final-8-Sep-2020.pdf', 7),
