	(2114, 'jamie@mantle.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>URGENT NOTIFICATION - PUB EGM 30 SEPTEMBER CANCELLED </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 shareholder,</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>We are pleased to say that the new directors were appointed yesterday and James McCulloch and Henry Harris have resigned as directors in the face of overwhelming support for the resolution. Therefore the EGM has been cancelled.</p>\r\n\r\n<p>The new directors will be in touch with you regarding next steps in the next two days.</p>\r\n\r\n<p>Thank you for your support.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>The Shareholder Action Group</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 (jamie@mantle.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', NULL, 'London pubs  - Jamie Baker : URGENT NOTIFICATION - PUB EGM 30 SEPTEMBER CANCELLED', '2020-09-29 11:06:17', '2020-09-29 11:06:40', 'parkhouse87@btinternet.com', NULL, NULL),
	(2115, 'adrian.loader@orzala.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>URGENT NOTIFICATION - PUB EGM 30 SEPTEMBER CANCELLED </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 shareholder,</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>We are pleased to say that the new directors were appointed yesterday and James McCulloch and Henry Harris have resigned as directors in the face of overwhelming support for the resolution. Therefore the EGM has been cancelled.</p>\r\n\r\n<p>The new directors will be in touch with you regarding next steps in the next two days.</p>\r\n\r\n<p>Thank you for your support.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>The Shareholder Action Group</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 (adrian.loader@orzala.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', NULL, 'London pubs  - Adrian Loader : URGENT NOTIFICATION - PUB EGM 30 SEPTEMBER CANCELLED', '2020-09-29 11:06:17', '2020-09-29 11:06:31', NULL, NULL, NULL),
	(2116, 'bart.huby@btinternet.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>URGENT NOTIFICATION - PUB EGM 30 SEPTEMBER CANCELLED </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 shareholder,</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>We are pleased to say that the new directors were appointed yesterday and James McCulloch and Henry Harris have resigned as directors in the face of overwhelming support for the resolution. Therefore the EGM has been cancelled.</p>\r\n\r\n<p>The new directors will be in touch with you regarding next steps in the next two days.</p>\r\n\r\n<p>Thank you for your support.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>The Shareholder Action Group</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 (bart.huby@btinternet.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', NULL, 'London pubs  - Bartholomew Huby : URGENT NOTIFICATION - PUB EGM 30 SEPTEMBER CANCELLED', '2020-09-29 11:06:17', '2020-09-29 11:06:34', NULL, NULL, NULL),
	(2117, 'diegoxfortunati@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>URGENT NOTIFICATION - PUB EGM 30 SEPTEMBER CANCELLED </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 shareholder,</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>We are pleased to say that the new directors were appointed yesterday and James McCulloch and Henry Harris have resigned as directors in the face of overwhelming support for the resolution. Therefore the EGM has been cancelled.</p>\r\n\r\n<p>The new directors will be in touch with you regarding next steps in the next two days.</p>\r\n\r\n<p>Thank you for your support.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>The Shareholder Action Group</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 (diegoxfortunati@gmail.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', NULL, 'London pubs  - Diego Fortunati : URGENT NOTIFICATION - PUB EGM 30 SEPTEMBER CANCELLED', '2020-09-29 11:06:17', '2020-09-29 11:06:37', NULL, NULL, NULL),
	(2118, 'laurence@enwised.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>URGENT NOTIFICATION - PUB EGM 30 SEPTEMBER CANCELLED </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 shareholder,</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>We are pleased to say that the new directors were appointed yesterday and James McCulloch and Henry Harris have resigned as directors in the face of overwhelming support for the resolution. Therefore the EGM has been cancelled.</p>\r\n\r\n<p>The new directors will be in touch with you regarding next steps in the next two days.</p>\r\n\r\n<p>Thank you for your support.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>The Shareholder Action Group</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 (laurence@enwised.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', NULL, 'London pubs  - Laurence Ede : URGENT NOTIFICATION - PUB EGM 30 SEPTEMBER CANCELLED', '2020-09-29 11:06:17', '2020-09-29 11:06:43', 'tony.kenny@cliftondowncf.com', NULL, NULL),
	(2119, 'routledge913@btinternet.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>URGENT NOTIFICATION - PUB EGM 30 SEPTEMBER CANCELLED </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 shareholder,</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>We are pleased to say that the new directors were appointed yesterday and James McCulloch and Henry Harris have resigned as directors in the face of overwhelming support for the resolution. Therefore the EGM has been cancelled.</p>\r\n\r\n<p>The new directors will be in touch with you regarding next steps in the next two days.</p>\r\n\r\n<p>Thank you for your support.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>The Shareholder Action Group</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 (routledge913@btinternet.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', NULL, 'London pubs  - Peter Routledge : URGENT NOTIFICATION - PUB EGM 30 SEPTEMBER CANCELLED', '2020-09-29 11:06:17', '2020-09-29 11:06:52', NULL, NULL, NULL),
	(2120, 'phisha100@aol.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>URGENT NOTIFICATION - PUB EGM 30 SEPTEMBER CANCELLED </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 shareholder,</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>We are pleased to say that the new directors were appointed yesterday and James McCulloch and Henry Harris have resigned as directors in the face of overwhelming support for the resolution. Therefore the EGM has been cancelled.</p>\r\n\r\n<p>The new directors will be in touch with you regarding next steps in the next two days.</p>\r\n\r\n<p>Thank you for your support.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>The Shareholder Action Group</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 (phisha100@aol.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', NULL, 'London pubs  - Philippa Fisher : URGENT NOTIFICATION - PUB EGM 30 SEPTEMBER CANCELLED', '2020-09-29 11:06:17', '2020-09-29 11:06:49', NULL, NULL, NULL),
	(2121, 'shane.gallwey@guinnessfunds.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>URGENT NOTIFICATION - PUB EGM 30 SEPTEMBER CANCELLED </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 shareholder,</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>We are pleased to say that the new directors were appointed yesterday and James McCulloch and Henry Harris have resigned as directors in the face of overwhelming support for the resolution. Therefore the EGM has been cancelled.</p>\r\n\r\n<p>The new directors will be in touch with you regarding next steps in the next two days.</p>\r\n\r\n<p>Thank you for your support.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>The Shareholder Action Group</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 (shane.gallwey@guinnessfunds.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', NULL, 'London pubs  - Guinness Asset Management Limited : URGENT NOTIFICATION - PUB EGM 30 SEPTEMBER CANCELLED', '2020-09-29 11:06:17', '2020-09-29 11:06:53', 'n.curtis123@btinternet.com', NULL, NULL),
	(2122, 'rogernjames@icloud.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>URGENT NOTIFICATION - PUB EGM 30 SEPTEMBER CANCELLED </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 shareholder,</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>We are pleased to say that the new directors were appointed yesterday and James McCulloch and Henry Harris have resigned as directors in the face of overwhelming support for the resolution. Therefore the EGM has been cancelled.</p>\r\n\r\n<p>The new directors will be in touch with you regarding next steps in the next two days.</p>\r\n\r\n<p>Thank you for your support.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>The Shareholder Action Group</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 (rogernjames@icloud.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', NULL, 'London pubs  - Roger James : URGENT NOTIFICATION - PUB EGM 30 SEPTEMBER CANCELLED', '2020-09-29 11:06:17', '2020-09-29 11:06:52', NULL, NULL, NULL),
	(2123, 'tinkoo.malhi@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>URGENT NOTIFICATION - PUB EGM 30 SEPTEMBER CANCELLED </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 shareholder,</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>We are pleased to say that the new directors were appointed yesterday and James McCulloch and Henry Harris have resigned as directors in the face of overwhelming support for the resolution. Therefore the EGM has been cancelled.</p>\r\n\r\n<p>The new directors will be in touch with you regarding next steps in the next two days.</p>\r\n\r\n<p>Thank you for your support.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>The Shareholder Action Group</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 (tinkoo.malhi@gmail.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', NULL, 'London pubs  - Tinkoo Malhi : URGENT NOTIFICATION - PUB EGM 30 SEPTEMBER CANCELLED', '2020-09-29 11:06:17', '2020-09-29 11:06:57', NULL, NULL, NULL),
	(2771, '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>111 </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                <br><br>\n<h3>Investor Website</h3>\n<p>The URL for the website is <a TARGET="_blank" href="https://london-pubs.atts-systems.com">https://london-pubs.atts-systems.com</a>\n    <br>\n    Your login is your email (nurse_stephen@hotmail.com).\n    <br>\n    Please reply to this email if you need a password reset.\n    <br>\n</p>\n             </td>\n        </tr>\n    </table>\n</center>\n\n\n    <!-- Optional JavaScript -->\n</body>\n</html>\n', NULL, 'Harcourt - Stephen Nurse (IT ) : 111', '2021-01-23 13:43:06', '2021-03-07 18:33:37', NULL, NULL, 7);

-- Dumping structure for table harcourt.migration_versions
CREATE TABLE IF NOT EXISTS `migration_versions` (
  `version` varchar(14) COLLATE utf8mb4_unicode_ci NOT NULL,
  `executed_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table harcourt.migration_versions: ~37 rows (approximately)
INSERT INTO `migration_versions` (`version`, `executed_at`) VALUES
	('20200605052237', '2020-06-08 07:01:59'),
	('20200608055917', '2020-06-08 07:01:59'),
	('20200608063001', '2020-06-08 07:01:59'),
	('20200609061315', '2020-06-09 06:34:00'),
	('20200610061838', '2020-06-10 06:54:47'),
	('20200610062526', '2020-06-10 06:54:47'),
	('20200612055324', '2020-06-13 05:32:53'),
	('20200612065248', '2020-06-13 05:32:53'),
	('20200627060846', '2020-06-27 06:53:12'),
	('20200627070339', '2020-06-27 07:12:21'),
	('20200627203250', '2020-06-27 20:42:34'),
	('20200711183413', '2020-07-14 07:05:59'),
	('20200719175228', '2020-07-20 19:34:38'),
	('20200720191102', '2020-07-20 19:34:38'),
	('20200804053449', '2020-08-04 05:44:26'),
	('20200804064645', '2020-08-04 06:52:35'),
	('20200810055055', '2020-08-11 05:31:43'),
	('20200812055426', '2020-08-12 06:13:55'),
	('20200812060557', '2020-08-12 06:13:55'),
	('20200812135608', '2020-08-13 06:46:09'),
	('20200813060922', '2020-08-13 06:46:09'),
	('20200814052437', '2020-08-14 06:41:37'),
	('20200818051112', '2020-08-18 05:33:06'),
	('20200818062337', '2020-08-18 06:49:39'),
	('20200819055537', '2020-08-20 06:41:13'),
	('20200819061957', '2020-08-20 06:41:13'),
	('20200820065137', '2020-08-21 06:22:43'),
	('20200824051413', '2020-08-24 05:22:24'),
	('20200831055422', '2020-09-01 05:05:49'),
	('20200904051323', '2020-09-04 05:55:41'),
	('20200904052217', '2020-09-04 05:55:41'),
	('20200910184708', '2020-09-10 20:23:31'),
	('20200910200324', '2020-09-10 20:23:31'),
	('20200911143649', '2020-09-11 14:42:25'),
	('20200912055013', '2020-09-12 06:07:21'),
	('20200912064230', '2020-09-12 06:56:03'),
	('20201004223828', '2020-10-04 23:26:26'),
	('20201112060605', '2020-11-14 14:18:09'),
	('20201114063442', '2020-11-14 14:18:10'),
	('20201114065730', '2020-11-14 14:18:10'),
	('20201114074116', '2020-11-14 14:18:10'),
	('20201114122753', '2020-11-14 14:18:10'),
	('20201114222520', '2020-11-14 22:26:53'),
	('20201115060416', '2020-11-15 06:04:33'),
	('20201115114111', '2020-11-15 11:41:24'),
	('20201121194305', '2020-11-21 19:43:19'),
	('20201123205400', '2020-11-23 20:54:56'),
	('20201128075620', '2020-11-28 07:56:36'),
	('20201128110922', '2020-11-28 11:09:33'),
	('20201128164554', '2020-11-28 16:46:06'),
	('20201129163801', '2020-11-29 16:38:14'),
	('20201210220108', '2020-12-10 22:01:20'),
	('20201212133054', '2020-12-12 13:31:17'),
	('20201212133909', '2020-12-12 13:39:19'),
	('20201215055208', '2020-12-15 05:52:28'),
	('20201215060416', '2020-12-15 06:04:29'),
	('20201215060622', '2020-12-15 06:06:34'),
	('20201216202902', '2020-12-16 20:29:20'),
	('20201216214039', '2020-12-16 21:42:52'),
	('20210119135050', '2021-01-19 13:51:08'),
	('20210122092107', '2021-01-22 09:21:23'),
	('20210127070807', '2021-01-27 07:08:34'),
	('20210313084332', '2021-03-13 08:43:47'),
	('20210313084758', '2021-03-13 08:51:00'),
	('20210313085434', '2021-03-13 08:54:48'),
	('20210313100535', '2021-03-13 10:05:53'),
	('20210313120235', '2021-03-13 12:02:47'),
	('20210502091348', '2021-05-02 09:14:01'),
	('20210502095220', '2021-05-02 09:52:31'),
	('20210502131807', '2021-05-02 13:18:19');

-- Dumping structure for table harcourt.pnl
CREATE TABLE IF NOT EXISTS `pnl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `financial_id` int(11) NOT NULL,
  `year` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attachment_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_14CADA18F73B619` (`financial_id`),
  CONSTRAINT `FK_14CADA18F73B619` FOREIGN KEY (`financial_id`) REFERENCES `financial` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

-- Dumping structure for table harcourt.pub
CREATE TABLE IF NOT EXISTS `pub` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address1` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `postcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `launch_at` datetime DEFAULT NULL,
  `website` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_eis_application_complete` tinyint(1) NOT NULL,
  `companies_house_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `director1_id` int(11) DEFAULT NULL,
  `director2_id` int(11) DEFAULT NULL,
  `mtm` double DEFAULT NULL,
  `share_issue_date_at` datetime DEFAULT NULL,
  `fund_raise_percent` double DEFAULT NULL,
  `pref_share_interest_rate` double DEFAULT NULL,
  `pref_share_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `max_percent_equity_in_excess_pref_shares` double DEFAULT NULL,
  `ducalian_and_harcourt_inns_fees` int(11) DEFAULT NULL,
  `director4_id` int(11) DEFAULT NULL,
  `director3_id` int(11) DEFAULT NULL,
  `bank_sort_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_account_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_account_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pref_share_form` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_sag_managed` tinyint(1) DEFAULT NULL,
  `company_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `legal_company_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_5A443C857234764D` (`director1_id`),
  KEY `IDX_5A443C856081D9A3` (`director2_id`),
  KEY `IDX_5A443C8545EA867F` (`director4_id`),
  KEY `IDX_5A443C85D83DBEC6` (`director3_id`),
  CONSTRAINT `FK_5A443C8545EA867F` FOREIGN KEY (`director4_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_5A443C856081D9A3` FOREIGN KEY (`director2_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_5A443C857234764D` FOREIGN KEY (`director1_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_5A443C85D83DBEC6` FOREIGN KEY (`director3_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table harcourt.pub: ~7 rows (approximately)
INSERT INTO `pub` (`id`, `name`, `slug`, `address1`, `address2`, `city`, `postcode`, `launch_at`, `website`, `is_eis_application_complete`, `companies_house_url`, `director1_id`, `director2_id`, `mtm`, `share_issue_date_at`, `fund_raise_percent`, `pref_share_interest_rate`, `pref_share_link`, `max_percent_equity_in_excess_pref_shares`, `ducalian_and_harcourt_inns_fees`, `director4_id`, `director3_id`, `bank_sort_code`, `bank_account_number`, `bank_account_name`, `pref_share_form`, `is_sag_managed`, `company_number`, `legal_company_name`) VALUES
	(7, 'Harcourt', 'harcourt', '32 Harcourt Street', 'Marylebone', 'London', 'W1H 4HX', '2016-03-01 00:00:00', 'https://theharcourt.com/', 1, 'https://beta.companieshouse.gov.uk/company/09320540', 292, 331, 0.31, '2016-03-01 00:00:00', 0.16, 0.09, 'https://london-pubs.atts-systems.com/dashboard/financial/97', 0.2, 100000, 290, 290, '20-12-34', '234456779', 'HarcourtSPV', 'https://london-pubs.atts-systems.com/dashboard/financial/97', 1, '12345', 'HARCOURT PUB LIMITED'),
	(8, 'Three Cranes', 'threecranes', '28 Garlick Hill', 'Mansion House', 'London', 'EC4V 2BA', '2016-09-01 00:00:00', 'https://threecranescity.co.uk/', 1, 'https://beta.companieshouse.gov.uk/company/09584570', 282, 339, 0.33, '2016-09-01 00:00:00', 0.14, 0.08, 'https://london-pubs.atts-systems.com/dashboard/financial/97', 2.5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '777', NULL),
	(9, 'The Coach', 'coach', '26-28 Ray Street', 'Clerkenwell', 'London', 'EC1R 3DJ', '2018-01-01 00:00:00', 'https://thecoachclerkenwell.co.uk/', 1, 'https://beta.companieshouse.gov.uk/company/09907475', 297, 292, 0.34, '2018-01-01 00:00:00', 0.12, 0.08, 'https://london-pubs.atts-systems.com/dashboard/financial/97', 2.3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '444', 'FARRINGDON PUB LTD'),
	(10, 'Hero of Maida', 'heroofmaida', '55 Shirland Rd', 'Maida Vale', 'London', 'W9 2JD', '2018-06-01 00:00:00', 'https://theheromaidavale.co.uk/', 0, 'https://beta.companieshouse.gov.uk/company/10364451', 290, 296, 0.19, '2018-06-01 00:00:00', 0.5, 0.12, 'https://london-pubs.atts-systems.com/dashboard/financial/97', 2.1, NULL, NULL, NULL, NULL, NULL, NULL, 'https://london-pubs.atts-systems.com/dashboard/financial/98', 1, '666', 'MAIDA VALE LEISURE LIMITED'),
	(11, 'The Crown', 'crown', '210 Chiswick High Rd', 'Chiswick', 'London', 'W4 1PD', '2019-01-01 00:00:00', 'https://thecrownchiswick.co.uk/', 0, 'https://beta.companieshouse.gov.uk/company/10735544', 330, 290, 0.13, '2019-01-01 00:00:00', 0.45, 0.11, 'https://london-pubs.atts-systems.com/dashboard/financial/97', 2.4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '333', 'SOUTH WEST LEISURE LIMITED'),
	(12, 'KPH (Barts)', 'kph', '139 Ladbroke Grove', 'Notting Hill', 'London', 'W10 6HJ', '2019-02-01 00:00:00', 'https://thekph.co.uk/', 0, 'https://beta.companieshouse.gov.uk/company/09996432', 339, 339, 0.03, '2019-02-01 00:00:00', 0, 0, 'https://london-pubs.atts-systems.com/dashboard/financial/97', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '111', 'BARTS PUB LTD'),
	(13, 'ALL', 'xxx', '.', '.', '.', '.', '2020-11-28 14:49:17', 'http://.google.com', 0, NULL, 339, 339, 0.1, '2020-11-28 14:49:09', 0, 0, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '222', NULL);

-- Dumping structure for table harcourt.question
CREATE TABLE IF NOT EXISTS `question` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `relevant_pub_id` int(11) NOT NULL,
  `questiontext` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `author` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `responder` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_B6F7494E26641B0B` (`relevant_pub_id`),
  CONSTRAINT `FK_B6F7494E26641B0B` FOREIGN KEY (`relevant_pub_id`) REFERENCES `pub` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table harcourt.question: ~2 rows (approximately)
INSERT INTO `question` (`id`, `relevant_pub_id`, `questiontext`, `author`, `responder`, `created_at`) VALUES
	(2, 7, 'In the financials, the management fees seem to bounce around every month, and range from 1.5k to 25k per month.   How can they be so variable? \r\n\r\n\r\nI thought the fees were of the order of 2% of equity invested per annum, so should be approx  440k over the 5 yrs, yet they seem to add to £752k.  Can you explain the additional £300k?', 'Stephen Nurse', NULL, '2020-07-15 18:46:32'),
	(6, 11, 'Loans\r\n\r\nI have tried to match the loan interest amounts to the loan notional schedules and cannot get them to macth.\r\n\r\nYou have the Lendvest loan notional as £1.596m, and interest at 0.09% per month (=1.08% nominal), yet I cannot get the loan interest amount to agree to within any reasonable level accuracy. At 1.08% nominal, the interest should be approx  Please advise.  Is the loan start date May 2018?\r\n\r\nCan you advise the loan start date for BBLS and Harcourt Investments?\r\n\r\nWhy did the loan interest amounts suddenly increase from 3.3k pcm to 14.3k from March 2020?', 'Stephen Nurse', NULL, '2020-07-20 00:31:41');

-- Dumping structure for table harcourt.secondary_market
CREATE TABLE IF NOT EXISTS `secondary_market` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pub_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `buy` tinyint(1) DEFAULT NULL,
  `sell` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_CF61FB7383FDE077` (`pub_id`),
  KEY `IDX_CF61FB73A76ED395` (`user_id`),
  CONSTRAINT `FK_CF61FB7383FDE077` FOREIGN KEY (`pub_id`) REFERENCES `pub` (`id`),
  CONSTRAINT `FK_CF61FB73A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table harcourt.secondary_market: ~8 rows (approximately)
INSERT INTO `secondary_market` (`id`, `pub_id`, `user_id`, `buy`, `sell`) VALUES
	(1, 7, 314, 1, 0),
	(2, 10, 314, 0, 1),
	(3, 12, 314, 1, 0),
	(4, 9, 314, 0, 1),
	(5, 11, 314, 1, 0),
	(6, 8, 314, 0, 1),
	(7, 7, 274, 1, NULL),
	(8, 10, 274, 0, NULL);

-- Dumping structure for table harcourt.shareregister
CREATE TABLE IF NOT EXISTS `shareregister` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pub_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `investment_amount` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_69DD0BF583FDE077` (`pub_id`),
  KEY `IDX_69DD0BF5A76ED395` (`user_id`),
  CONSTRAINT `FK_69DD0BF583FDE077` FOREIGN KEY (`pub_id`) REFERENCES `pub` (`id`),
  CONSTRAINT `FK_69DD0BF5A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=953 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table harcourt.shareregister: ~490 rows (approximately)
INSERT INTO `shareregister` (`id`, `pub_id`, `user_id`, `investment_amount`, `created_at`) VALUES
	(445, 7, 276, 50000, '2020-06-08 11:18:19'),
	(446, 7, 277, 175000, '2020-06-08 11:18:20'),
	(447, 7, 278, 55000, '2020-06-08 11:18:20'),
	(448, 7, 279, 55000, '2020-06-08 11:18:21'),
	(449, 7, 280, 50000, '2020-06-08 11:18:22'),
	(450, 7, 281, 55000, '2020-06-08 11:18:23'),
	(451, 7, 282, 100000, '2020-06-08 11:18:24'),
	(452, 7, 283, 100000, '2020-06-08 11:18:25'),
	(453, 7, 284, 50000, '2020-06-08 11:18:26'),
	(454, 7, 285, 50000, '2020-06-08 11:18:27'),
	(455, 7, 286, 75000, '2020-06-08 11:18:28'),
	(456, 7, 287, 35000, '2020-06-08 11:18:29'),
	(457, 7, 288, 50000, '2020-06-08 11:18:30'),
	(458, 7, 289, 50000, '2020-06-08 11:18:31'),
	(459, 7, 290, 50000, '2020-06-08 11:18:32'),
	(460, 7, 291, 30000, '2020-06-08 11:18:33'),
	(461, 7, 292, 50000, '2020-06-08 11:18:34'),
	(462, 7, 293, 1, '2020-06-08 11:18:35'),
	(463, 7, 294, 25000, '2020-06-08 11:18:35'),
	(464, 7, 295, 55000, '2020-06-08 11:18:36'),
	(465, 7, 296, 100000, '2020-06-08 11:18:37'),
	(466, 7, 297, 100000, '2020-06-08 11:18:38'),
	(467, 7, 298, 50000, '2020-06-08 11:18:39'),
	(468, 7, 299, 100000, '2020-06-08 11:18:40'),
	(469, 7, 300, 35000, '2020-06-08 11:18:41'),
	(470, 7, 301, 50000, '2020-06-08 11:18:42'),
	(471, 7, 302, 26250, '2020-06-08 11:18:43'),
	(472, 7, 303, 50000, '2020-06-08 11:18:44'),
	(473, 7, 304, 25000, '2020-06-08 11:18:45'),
	(474, 7, 305, 50000, '2020-06-08 11:18:46'),
	(475, 7, 306, 100000, '2020-06-08 11:18:47'),
	(476, 7, 307, 50000, '2020-06-08 11:18:48'),
	(477, 7, 308, 1, '2020-06-08 11:18:49'),
	(478, 7, 309, 50000, '2020-06-08 11:18:50'),
	(479, 7, 310, 50000, '2020-06-08 11:18:50'),
	(480, 7, 311, 50000, '2020-06-08 11:18:51'),
	(481, 7, 312, 50000, '2020-06-08 11:18:52'),
	(482, 7, 313, 50000, '2020-06-08 11:18:53'),
	(483, 7, 314, 150000, '2020-06-08 11:18:54'),
	(484, 7, 315, 50000, '2020-06-08 11:18:55'),
	(485, 7, 316, 50000, '2020-06-08 11:18:56'),
	(486, 7, 317, 75000, '2020-06-08 11:18:57'),
	(487, 7, 318, 50000, '2020-06-08 11:18:58'),
	(488, 7, 319, 15000, '2020-06-08 11:18:59'),
	(489, 7, 320, 100000, '2020-06-08 11:19:00'),
	(490, 7, 321, 10000, '2020-06-08 11:19:01'),
	(491, 7, 322, 10000, '2020-06-08 11:19:02'),
	(492, 7, 323, 25000, '2020-06-08 11:19:03'),
	(493, 7, 324, 25000, '2020-06-08 11:19:03'),
	(494, 7, 325, 25000, '2020-06-08 11:19:04'),
	(495, 7, 326, 50000, '2020-06-08 11:19:05'),
	(496, 7, 327, 100000, '2020-06-08 11:19:06'),
	(497, 7, 328, 50000, '2020-06-08 11:19:07'),
	(498, 7, 329, 25000, '2020-06-08 11:19:08'),
	(499, 7, 330, 50000, '2020-06-08 11:19:09'),
	(500, 7, 331, 50000, '2020-06-08 11:19:10'),
	(501, 7, 332, 50000, '2020-06-08 11:19:11'),
	(502, 7, 333, 100000, '2020-06-08 11:19:12'),
	(503, 7, 334, 50000, '2020-06-08 11:19:13'),
	(504, 7, 335, 125000, '2020-06-08 11:19:14'),
	(505, 7, 336, 50000, '2020-06-08 11:19:15'),
	(506, 7, 337, 100000, '2020-06-08 11:19:16'),
	(507, 7, 338, 50000, '2020-06-08 11:19:17'),
	(508, 7, 339, 200000, '2020-06-08 11:19:18'),
	(509, 7, 340, 100000, '2020-06-08 11:19:19'),
	(510, 7, 341, 50000, '2020-06-08 11:19:20'),
	(511, 7, 342, 1, '2020-06-08 11:19:21'),
	(512, 7, 343, 100000, '2020-06-08 11:19:21'),
	(513, 7, 344, 100000, '2020-06-08 11:19:22'),
	(514, 7, 345, 45000, '2020-06-08 11:19:23'),
	(515, 7, 346, 75000, '2020-06-08 11:19:24'),
	(516, 7, 347, 25000, '2020-06-08 11:19:25'),
	(517, 7, 348, 65000, '2020-06-08 11:19:26'),
	(518, 8, 349, 30000, '2020-06-08 11:19:44'),
	(519, 8, 277, 250000, '2020-06-08 11:19:44'),
	(520, 8, 350, 150000, '2020-06-08 11:19:45'),
	(521, 8, 351, 25000, '2020-06-08 11:19:45'),
	(522, 8, 352, 25000, '2020-06-08 11:19:46'),
	(523, 8, 353, 100000, '2020-06-08 11:19:47'),
	(524, 8, 354, 100000, '2020-06-08 11:19:48'),
	(525, 8, 278, 75000, '2020-06-08 11:19:48'),
	(526, 8, 279, 60000, '2020-06-08 11:19:48'),
	(527, 8, 281, 60000, '2020-06-08 11:19:48'),
	(528, 8, 355, 60000, '2020-06-08 11:19:49'),
	(529, 8, 282, 50000, '2020-06-08 11:19:49'),
	(530, 8, 283, 50000, '2020-06-08 11:19:49'),
	(531, 8, 285, 50000, '2020-06-08 11:19:49'),
	(532, 8, 287, 30000, '2020-06-08 11:19:49'),
	(533, 8, 356, 50000, '2020-06-08 11:19:50'),
	(534, 8, 357, 20000, '2020-06-08 11:19:51'),
	(536, 8, 359, 50000, '2020-06-08 11:19:53'),
	(537, 8, 288, 50000, '2020-06-08 11:19:53'),
	(538, 8, 360, 50000, '2020-06-08 11:19:54'),
	(539, 8, 361, 120000, '2020-06-08 11:19:55'),
	(540, 8, 289, 45000, '2020-06-08 11:19:55'),
	(541, 8, 362, 100000, '2020-06-08 11:19:56'),
	(542, 8, 363, 30000, '2020-06-08 11:19:57'),
	(543, 8, 364, 25000, '2020-06-08 11:19:58'),
	(544, 8, 365, 25000, '2020-06-08 11:19:59'),
	(545, 8, 294, 50000, '2020-06-08 11:19:59'),
	(546, 8, 366, 50000, '2020-06-08 11:20:00'),
	(547, 8, 367, 50000, '2020-06-08 11:20:00'),
	(548, 8, 368, 25000, '2020-06-08 11:20:01'),
	(549, 8, 369, 30000, '2020-06-08 11:20:02'),
	(550, 8, 370, 25000, '2020-06-08 11:20:03'),
	(551, 8, 371, 50000, '2020-06-08 11:20:04'),
	(552, 8, 372, 50000, '2020-06-08 11:20:05'),
	(553, 8, 373, 50000, '2020-06-08 11:20:06'),
	(554, 8, 374, 50000, '2020-06-08 11:20:07'),
	(555, 8, 375, 80000, '2020-06-08 11:20:08'),
	(556, 8, 376, 50000, '2020-06-08 11:20:09'),
	(557, 8, 377, 50000, '2020-06-08 11:20:10'),
	(558, 8, 378, 100000, '2020-06-08 11:20:11'),
	(559, 8, 379, 50000, '2020-06-08 11:20:12'),
	(560, 8, 316, 50000, '2020-06-08 11:20:12'),
	(561, 8, 380, 50000, '2020-06-08 11:20:13'),
	(562, 8, 381, 50000, '2020-06-08 11:20:14'),
	(563, 8, 382, 50000, '2020-06-08 11:20:15'),
	(564, 8, 383, 50000, '2020-06-08 11:20:16'),
	(565, 8, 384, 25000, '2020-06-08 11:20:17'),
	(566, 8, 385, 50000, '2020-06-08 11:20:18'),
	(567, 8, 386, 50000, '2020-06-08 11:20:19'),
	(568, 8, 387, 15000, '2020-06-08 11:20:19'),
	(569, 8, 388, 50000, '2020-06-08 11:20:20'),
	(570, 8, 340, 60000, '2020-06-08 11:20:20'),
	(571, 9, 277, 150000, '2020-06-08 11:20:26'),
	(572, 9, 389, 50000, '2020-06-08 11:20:27'),
	(573, 9, 390, 20000, '2020-06-08 11:20:28'),
	(574, 9, 353, 100000, '2020-06-08 11:20:28'),
	(575, 9, 354, 100000, '2020-06-08 11:20:28'),
	(576, 9, 279, 50000, '2020-06-08 11:20:28'),
	(577, 9, 280, 50000, '2020-06-08 11:20:28'),
	(578, 9, 281, 40000, '2020-06-08 11:20:28'),
	(579, 9, 282, 100000, '2020-06-08 11:20:28'),
	(580, 9, 283, 75000, '2020-06-08 11:20:28'),
	(581, 9, 285, 40000, '2020-06-08 11:20:28'),
	(582, 9, 287, 20000, '2020-06-08 11:20:28'),
	(583, 9, 391, 20000, '2020-06-08 11:20:29'),
	(584, 9, 356, 25000, '2020-06-08 11:20:29'),
	(585, 9, 392, 50000, '2020-06-08 11:20:30'),
	(586, 9, 360, 50000, '2020-06-08 11:20:30'),
	(587, 9, 393, 160000, '2020-06-08 11:20:31'),
	(588, 9, 289, 65000, '2020-06-08 11:20:31'),
	(589, 9, 394, 100000, '2020-06-08 11:20:31'),
	(590, 9, 362, 50000, '2020-06-08 11:20:31'),
	(591, 9, 363, 45000, '2020-06-08 11:20:31'),
	(593, 9, 396, 50000, '2020-06-08 11:20:33'),
	(594, 9, 292, 230000, '2020-06-08 11:20:33'),
	(595, 9, 397, 150000, '2020-06-08 11:20:34'),
	(596, 9, 293, 12, '2020-06-08 11:20:34'),
	(597, 9, 398, 125000, '2020-06-08 11:20:35'),
	(598, 9, 399, 55000, '2020-06-08 11:20:36'),
	(599, 9, 400, 100000, '2020-06-08 11:20:37'),
	(600, 9, 295, 100000, '2020-06-08 11:20:37'),
	(601, 9, 296, 100000, '2020-06-08 11:20:37'),
	(602, 9, 297, 100000, '2020-06-08 11:20:37'),
	(603, 9, 401, 100000, '2020-06-08 11:20:38'),
	(604, 9, 299, 80000, '2020-06-08 11:20:38'),
	(605, 9, 402, 75000, '2020-06-08 11:20:39'),
	(606, 9, 300, 9820, '2020-06-08 11:20:39'),
	(607, 9, 301, 50000, '2020-06-08 11:20:39'),
	(608, 9, 403, 50000, '2020-06-08 11:20:40'),
	(609, 9, 303, 50000, '2020-06-08 11:20:40'),
	(610, 9, 404, 50000, '2020-06-08 11:20:41'),
	(611, 9, 405, 50000, '2020-06-08 11:20:42'),
	(612, 9, 306, 50000, '2020-06-08 11:20:42'),
	(614, 9, 310, 50000, '2020-06-08 11:20:43'),
	(615, 9, 378, 100000, '2020-06-08 11:20:43'),
	(616, 9, 407, 50000, '2020-06-08 11:20:44'),
	(617, 9, 312, 50000, '2020-06-08 11:20:44'),
	(618, 9, 313, 50000, '2020-06-08 11:20:44'),
	(619, 9, 408, 50000, '2020-06-08 11:20:45'),
	(620, 9, 315, 50000, '2020-06-08 11:20:45'),
	(621, 9, 316, 50000, '2020-06-08 11:20:45'),
	(622, 9, 409, 25000, '2020-06-08 11:20:45'),
	(623, 9, 410, 30000, '2020-06-08 11:20:46'),
	(624, 9, 411, 30000, '2020-06-08 11:20:47'),
	(625, 9, 412, 27000, '2020-06-08 11:20:48'),
	(626, 9, 413, 25000, '2020-06-08 11:20:49'),
	(627, 9, 414, 25000, '2020-06-08 11:20:50'),
	(628, 9, 415, 25000, '2020-06-08 11:20:51'),
	(629, 9, 380, 50000, '2020-06-08 11:20:51'),
	(630, 9, 319, 15180, '2020-06-08 11:20:51'),
	(631, 9, 321, 10000, '2020-06-08 11:20:51'),
	(632, 9, 322, 10000, '2020-06-08 11:20:51'),
	(633, 9, 416, 10000, '2020-06-08 11:20:52'),
	(634, 9, 417, 10000, '2020-06-08 11:20:53'),
	(635, 9, 418, 50000, '2020-06-08 11:20:54'),
	(636, 9, 419, 50000, '2020-06-08 11:20:55'),
	(637, 9, 420, 100000, '2020-06-08 11:20:56'),
	(639, 9, 385, 100000, '2020-06-08 11:20:57'),
	(640, 9, 422, 25000, '2020-06-08 11:20:58'),
	(641, 9, 423, 120000, '2020-06-08 11:20:59'),
	(642, 9, 345, 50000, '2020-06-08 11:20:59'),
	(643, 9, 424, 50000, '2020-06-08 11:20:59'),
	(644, 10, 277, 140000, '2020-06-08 11:21:52'),
	(645, 10, 425, 25000, '2020-06-08 11:21:53'),
	(646, 10, 426, 26250, '2020-06-08 11:21:54'),
	(647, 10, 390, 25000, '2020-06-08 11:21:54'),
	(648, 10, 354, 100000, '2020-06-08 11:21:54'),
	(649, 10, 279, 60000, '2020-06-08 11:21:54'),
	(650, 10, 280, 50000, '2020-06-08 11:21:54'),
	(651, 10, 427, 25000, '2020-06-08 11:21:55'),
	(652, 10, 428, 50000, '2020-06-08 11:21:55'),
	(653, 10, 282, 50000, '2020-06-08 11:21:55'),
	(654, 10, 283, 75000, '2020-06-08 11:21:55'),
	(655, 10, 284, 50000, '2020-06-08 11:21:55'),
	(656, 10, 287, 20000, '2020-06-08 11:21:56'),
	(657, 10, 392, 100000, '2020-06-08 11:21:56'),
	(658, 10, 358, 50000, '2020-06-08 11:21:56'),
	(659, 10, 429, 25000, '2020-06-08 11:21:56'),
	(660, 10, 360, 50000, '2020-06-08 11:21:56'),
	(661, 10, 430, 20000, '2020-06-08 11:21:57'),
	(662, 10, 362, 100000, '2020-06-08 11:21:57'),
	(663, 10, 431, 25000, '2020-06-08 11:21:58'),
	(664, 10, 290, 220000, '2020-06-08 11:21:58'),
	(665, 10, 432, 20000, '2020-06-08 11:21:59'),
	(666, 10, 292, 100000, '2020-06-08 11:21:59'),
	(667, 10, 365, 40000, '2020-06-08 11:21:59'),
	(668, 10, 293, 250, '2020-06-08 11:21:59'),
	(669, 10, 398, 100000, '2020-06-08 11:21:59'),
	(670, 10, 399, 60000, '2020-06-08 11:21:59'),
	(671, 10, 296, 100000, '2020-06-08 11:21:59'),
	(672, 10, 433, 50000, '2020-06-08 11:22:00'),
	(673, 10, 434, 190000, '2020-06-08 11:22:01'),
	(674, 10, 298, 80000, '2020-06-08 11:22:01'),
	(675, 10, 402, 50000, '2020-06-08 11:22:01'),
	(676, 10, 300, 75000, '2020-06-08 11:22:01'),
	(677, 10, 435, 25000, '2020-06-08 11:22:02'),
	(678, 10, 436, 100000, '2020-06-08 11:22:03'),
	(679, 10, 437, 70000, '2020-06-08 11:22:04'),
	(680, 10, 438, 50000, '2020-06-08 11:22:05'),
	(681, 10, 403, 100000, '2020-06-08 11:22:05'),
	(682, 10, 303, 100000, '2020-06-08 11:22:05'),
	(683, 10, 374, 25000, '2020-06-08 11:22:05'),
	(684, 10, 439, 100000, '2020-06-08 11:22:06'),
	(685, 10, 376, 50000, '2020-06-08 11:22:06'),
	(686, 10, 440, 60000, '2020-06-08 11:22:07'),
	(687, 10, 441, 25000, '2020-06-08 11:22:08'),
	(688, 10, 442, 15000, '2020-06-08 11:22:09'),
	(689, 10, 443, 75000, '2020-06-08 11:22:10'),
	(690, 10, 444, 410000, '2020-06-08 11:22:11'),
	(691, 10, 445, 50000, '2020-06-08 11:22:11'),
	(692, 10, 407, 100000, '2020-06-08 11:22:11'),
	(693, 10, 446, 30000, '2020-06-08 11:22:12'),
	(694, 10, 312, 100000, '2020-06-08 11:22:12'),
	(695, 10, 313, 100000, '2020-06-08 11:22:12'),
	(696, 10, 316, 50000, '2020-06-08 11:22:12'),
	(697, 10, 447, 25000, '2020-06-08 11:22:13'),
	(698, 10, 409, 85000, '2020-06-08 11:22:13'),
	(699, 10, 448, 50000, '2020-06-08 11:22:14'),
	(700, 10, 449, 25375, '2020-06-08 11:22:15'),
	(701, 10, 450, 25000, '2020-06-08 11:22:16'),
	(702, 10, 410, 50000, '2020-06-08 11:22:16'),
	(703, 10, 412, 50000, '2020-06-08 11:22:16'),
	(704, 10, 413, 25000, '2020-06-08 11:22:16'),
	(705, 10, 451, 50500, '2020-06-08 11:22:17'),
	(706, 10, 415, 25000, '2020-06-08 11:22:17'),
	(707, 10, 380, 50000, '2020-06-08 11:22:17'),
	(708, 10, 452, 20000, '2020-06-08 11:22:18'),
	(709, 10, 453, 50000, '2020-06-08 11:22:19'),
	(710, 10, 454, 50000, '2020-06-08 11:22:20'),
	(711, 10, 327, 100000, '2020-06-08 11:22:20'),
	(712, 10, 455, 25000, '2020-06-08 11:22:21'),
	(713, 10, 456, 50000, '2020-06-08 11:22:22'),
	(714, 10, 457, 15000, '2020-06-08 11:22:23'),
	(715, 10, 458, 50000, '2020-06-08 11:22:24'),
	(716, 10, 459, 50000, '2020-06-08 11:22:25'),
	(717, 10, 330, 50000, '2020-06-08 11:22:25'),
	(718, 10, 331, 50000, '2020-06-08 11:22:25'),
	(719, 10, 460, 50000, '2020-06-08 11:22:26'),
	(720, 10, 461, 50000, '2020-06-08 11:22:26'),
	(721, 10, 462, 50000, '2020-06-08 11:22:27'),
	(722, 10, 463, 75000, '2020-06-08 11:22:28'),
	(723, 10, 464, 50000, '2020-06-08 11:22:29'),
	(724, 10, 465, 25000, '2020-06-08 11:22:30'),
	(725, 10, 466, 50000, '2020-06-08 11:22:31'),
	(726, 10, 420, 100000, '2020-06-08 11:22:31'),
	(727, 10, 467, 25000, '2020-06-08 11:22:32'),
	(728, 10, 468, 50000, '2020-06-08 11:22:33'),
	(729, 10, 385, 150000, '2020-06-08 11:22:33'),
	(731, 10, 470, 125000, '2020-06-08 11:22:35'),
	(732, 10, 339, 200000, '2020-06-08 11:22:35'),
	(733, 10, 422, 20000, '2020-06-08 11:22:35'),
	(734, 10, 344, 70000, '2020-06-08 11:22:35'),
	(735, 10, 471, 15000, '2020-06-08 11:22:36'),
	(736, 11, 472, 10000, '2020-06-08 11:22:42'),
	(737, 11, 277, 200000, '2020-06-08 11:22:42'),
	(738, 11, 473, 35000, '2020-06-08 11:22:43'),
	(739, 11, 425, 50000, '2020-06-08 11:22:43'),
	(740, 11, 390, 25000, '2020-06-08 11:22:43'),
	(741, 11, 474, 100000, '2020-06-08 11:22:44'),
	(742, 11, 353, 100000, '2020-06-08 11:22:44'),
	(743, 11, 354, 100000, '2020-06-08 11:22:44'),
	(744, 11, 475, 20000, '2020-06-08 11:22:44'),
	(745, 11, 279, 50000, '2020-06-08 11:22:44'),
	(746, 11, 280, 50000, '2020-06-08 11:22:44'),
	(747, 11, 281, 45000, '2020-06-08 11:22:44'),
	(748, 11, 283, 40000, '2020-06-08 11:22:44'),
	(749, 11, 476, 20000, '2020-06-08 11:22:45'),
	(750, 11, 287, 20000, '2020-06-08 11:22:45'),
	(751, 11, 477, 10000, '2020-06-08 11:22:46'),
	(752, 11, 391, 25000, '2020-06-08 11:22:46'),
	(753, 11, 478, 10000, '2020-06-08 11:22:47'),
	(754, 11, 392, 200000, '2020-06-08 11:22:47'),
	(755, 11, 479, 25000, '2020-06-08 11:22:48'),
	(756, 11, 480, 25000, '2020-06-08 11:22:49'),
	(757, 11, 481, 25000, '2020-06-08 11:22:50'),
	(758, 11, 482, 20000, '2020-06-08 11:22:51'),
	(759, 11, 483, 13500, '2020-06-08 11:22:52'),
	(760, 11, 289, 45000, '2020-06-08 11:22:52'),
	(761, 11, 484, 50000, '2020-06-08 11:22:53'),
	(762, 11, 362, 50000, '2020-06-08 11:22:53'),
	(763, 11, 431, 10000, '2020-06-08 11:22:53'),
	(764, 11, 290, 256100, '2020-06-08 11:22:53'),
	(765, 11, 432, 20000, '2020-06-08 11:22:53'),
	(766, 11, 485, 10000, '2020-06-08 11:22:54'),
	(767, 11, 486, 10000, '2020-06-08 11:22:55'),
	(768, 11, 365, 30000, '2020-06-08 11:22:55'),
	(769, 11, 487, 250, '2020-06-08 11:22:56'),
	(770, 11, 294, 25000, '2020-06-08 11:22:56'),
	(771, 11, 488, 50000, '2020-06-08 11:22:57'),
	(772, 11, 399, 50000, '2020-06-08 11:22:57'),
	(773, 11, 489, 10000, '2020-06-08 11:22:58'),
	(774, 11, 490, 10000, '2020-06-08 11:22:58'),
	(775, 11, 434, 160000, '2020-06-08 11:22:58'),
	(776, 11, 491, 10000, '2020-06-08 11:22:59'),
	(777, 11, 298, 40000, '2020-06-08 11:22:59'),
	(778, 11, 299, 125000, '2020-06-08 11:22:59'),
	(779, 11, 492, 20000, '2020-06-08 11:23:00'),
	(780, 11, 493, 25000, '2020-06-08 11:23:01'),
	(781, 11, 494, 20000, '2020-06-08 11:23:02'),
	(782, 11, 495, 10000, '2020-06-08 11:23:03'),
	(783, 11, 496, 10000, '2020-06-08 11:23:04'),
	(784, 11, 497, 30000, '2020-06-08 11:23:05'),
	(785, 11, 498, 10000, '2020-06-08 11:23:06'),
	(786, 11, 437, 75000, '2020-06-08 11:23:06'),
	(787, 11, 499, 10000, '2020-06-08 11:23:07'),
	(788, 11, 303, 100000, '2020-06-08 11:23:07'),
	(789, 11, 374, 50000, '2020-06-08 11:23:07'),
	(790, 11, 500, 50000, '2020-06-08 11:23:08'),
	(791, 11, 404, 50000, '2020-06-08 11:23:08'),
	(792, 11, 405, 100000, '2020-06-08 11:23:08'),
	(793, 11, 501, 10000, '2020-06-08 11:23:09'),
	(794, 11, 502, 10000, '2020-06-08 11:23:10'),
	(795, 11, 375, 50000, '2020-06-08 11:23:10'),
	(796, 11, 503, 10000, '2020-06-08 11:23:11'),
	(797, 11, 504, 10000, '2020-06-08 11:23:12'),
	(798, 11, 505, 10000, '2020-06-08 11:23:12'),
	(799, 11, 506, 50000, '2020-06-08 11:23:13'),
	(800, 11, 507, 12000, '2020-06-08 11:23:14'),
	(801, 11, 442, 10000, '2020-06-08 11:23:14'),
	(802, 11, 310, 75000, '2020-06-08 11:23:14'),
	(803, 11, 508, 25000, '2020-06-08 11:23:15'),
	(804, 11, 407, 50000, '2020-06-08 11:23:15'),
	(805, 11, 509, 50000, '2020-06-08 11:23:16'),
	(806, 11, 510, 50000, '2020-06-08 11:23:17'),
	(807, 11, 446, 25000, '2020-06-08 11:23:17'),
	(808, 11, 312, 50000, '2020-06-08 11:23:17'),
	(809, 11, 316, 50000, '2020-06-08 11:23:17'),
	(810, 11, 511, 10000, '2020-06-08 11:23:18'),
	(811, 11, 512, 75000, '2020-06-08 11:23:19'),
	(812, 11, 411, 25000, '2020-06-08 11:23:19'),
	(813, 11, 451, 50000, '2020-06-08 11:23:19'),
	(814, 11, 415, 25000, '2020-06-08 11:23:19'),
	(815, 11, 380, 50000, '2020-06-08 11:23:19'),
	(816, 11, 513, 10000, '2020-06-08 11:23:20'),
	(817, 11, 514, 50000, '2020-06-08 11:23:21'),
	(818, 11, 515, 50000, '2020-06-08 11:23:22'),
	(819, 11, 516, 20000, '2020-06-08 11:23:23'),
	(820, 11, 517, 10000, '2020-06-08 11:23:24'),
	(821, 11, 518, 10000, '2020-06-08 11:23:25'),
	(822, 11, 519, 10000, '2020-06-08 11:23:26'),
	(823, 11, 520, 50000, '2020-06-08 11:23:26'),
	(824, 11, 521, 60000, '2020-06-08 11:23:27'),
	(825, 11, 382, 50000, '2020-06-08 11:23:27'),
	(826, 11, 522, 50000, '2020-06-08 11:23:28'),
	(827, 11, 523, 10000, '2020-06-08 11:23:29'),
	(828, 11, 524, 10000, '2020-06-08 11:23:30'),
	(829, 11, 330, 50000, '2020-06-08 11:23:30'),
	(830, 11, 331, 50000, '2020-06-08 11:23:30'),
	(831, 11, 525, 50000, '2020-06-08 11:23:31'),
	(832, 11, 526, 50000, '2020-06-08 11:23:32'),
	(833, 11, 527, 50000, '2020-06-08 11:23:33'),
	(834, 11, 528, 20000, '2020-06-08 11:23:34'),
	(835, 11, 529, 20000, '2020-06-08 11:23:35'),
	(836, 11, 530, 10000, '2020-06-08 11:23:36'),
	(837, 11, 463, 50000, '2020-06-08 11:23:36'),
	(838, 11, 464, 25000, '2020-06-08 11:23:36'),
	(839, 11, 466, 29500, '2020-06-08 11:23:36'),
	(840, 11, 531, 20000, '2020-06-08 11:23:37'),
	(841, 11, 420, 50000, '2020-06-08 11:23:37'),
	(842, 11, 532, 25000, '2020-06-08 11:23:38'),
	(843, 11, 533, 100000, '2020-06-08 11:23:39'),
	(844, 11, 470, 406000, '2020-06-08 11:23:39'),
	(845, 11, 534, 30000, '2020-06-08 11:23:40'),
	(846, 11, 535, 25000, '2020-06-08 11:23:41'),
	(847, 11, 344, 20000, '2020-06-08 11:23:41'),
	(848, 11, 536, 20000, '2020-06-08 11:23:42'),
	(849, 12, 277, 70000, '2020-06-08 11:25:37'),
	(850, 12, 425, 25000, '2020-06-08 11:25:37'),
	(851, 12, 390, 25000, '2020-06-08 11:25:37'),
	(852, 12, 278, 50000, '2020-06-08 11:25:37'),
	(853, 12, 537, 25000, '2020-06-08 11:25:38'),
	(854, 12, 289, 30000, '2020-06-08 11:25:38'),
	(855, 12, 432, 20000, '2020-06-08 11:25:38'),
	(856, 12, 292, 50000, '2020-06-08 11:25:38'),
	(857, 12, 538, 50000, '2020-06-08 11:25:39'),
	(858, 12, 293, 100, '2020-06-08 11:25:39'),
	(859, 12, 487, 250, '2020-06-08 11:25:39'),
	(860, 12, 367, 50000, '2020-06-08 11:25:39'),
	(861, 12, 296, 100000, '2020-06-08 11:25:39'),
	(862, 12, 402, 40000, '2020-06-08 11:25:39'),
	(863, 12, 303, 50000, '2020-06-08 11:25:39'),
	(864, 12, 439, 100000, '2020-06-08 11:25:39'),
	(865, 12, 308, 1, '2020-06-08 11:25:39'),
	(866, 12, 539, 50000, '2020-06-08 11:25:40'),
	(867, 12, 310, 50000, '2020-06-08 11:25:40'),
	(868, 12, 312, 80000, '2020-06-08 11:25:40'),
	(869, 12, 313, 100000, '2020-06-08 11:25:40'),
	(870, 12, 540, 50000, '2020-06-08 11:25:41'),
	(871, 12, 541, 25000, '2020-06-08 11:25:42'),
	(872, 12, 542, 3092783, '2020-06-08 11:25:43'),
	(873, 12, 543, 25000, '2020-06-08 11:25:44'),
	(874, 12, 459, 50000, '2020-06-08 11:25:44'),
	(875, 12, 330, 50000, '2020-06-08 11:25:44'),
	(876, 12, 331, 50000, '2020-06-08 11:25:44'),
	(877, 12, 419, 35000, '2020-06-08 11:25:44'),
	(878, 12, 460, 100000, '2020-06-08 11:25:44'),
	(879, 12, 461, 100000, '2020-06-08 11:25:44'),
	(880, 12, 420, 100000, '2020-06-08 11:25:44'),
	(881, 12, 385, 120000, '2020-06-08 11:25:44'),
	(882, 12, 386, 50000, '2020-06-08 11:25:44'),
	(883, 12, 387, 15000, '2020-06-08 11:25:44'),
	(884, 12, 339, 200000, '2020-06-08 11:25:44'),
	(885, 12, 544, 15000, '2020-06-08 11:25:45'),
	(889, 9, 290, 428000, '2020-06-09 12:08:32'),
	(890, 9, 531, 20000, '2020-07-07 17:54:00'),
	(891, 10, 340, 50000, '2020-07-07 17:54:39'),
	(892, 7, 392, 50000, '2020-07-07 22:33:14'),
	(893, 12, 392, 50000, '2020-07-07 22:33:47'),
	(898, 13, 290, 100, '2020-07-20 15:29:03'),
	(899, 13, 274, 100, '2020-07-20 15:29:19'),
	(900, 8, 308, 1, '2020-08-04 07:48:58'),
	(901, 10, 308, 1, '2020-08-04 07:49:00'),
	(903, 9, 308, 1, '2020-08-04 07:49:26'),
	(904, 11, 308, 1, '2020-08-04 07:49:28'),
	(905, 12, 550, 1, '2020-08-17 19:04:14'),
	(929, 7, 534, 30000, '2020-09-09 14:31:13'),
	(930, 9, 437, 50000, '2020-09-12 14:45:37'),
	(931, 8, 342, 1, '2020-09-15 16:42:41'),
	(932, 10, 342, 1, '2020-09-15 16:42:43'),
	(933, 11, 342, 1, '2020-09-15 16:42:46'),
	(934, 12, 342, 1, '2020-09-15 16:42:50'),
	(935, 7, 426, 1, '2020-09-15 16:43:43'),
	(936, 8, 426, 1, '2020-09-15 16:43:46'),
	(937, 9, 426, 1, '2020-09-15 16:43:49'),
	(938, 11, 426, 1, '2020-09-15 16:43:53'),
	(939, 12, 426, 1, '2020-09-15 16:43:57'),
	(940, 9, 342, 1, '2020-09-16 16:45:23'),
	(942, 7, 547, 1, '2020-09-28 11:32:42'),
	(943, 8, 547, 1, '2020-09-28 11:32:45'),
	(944, 9, 547, 1, '2020-09-28 11:32:48'),
	(945, 10, 547, 1, '2020-09-28 11:32:51'),
	(946, 11, 547, 1, '2020-09-28 11:32:54'),
	(947, 12, 547, 1, '2020-09-28 11:33:02'),
	(948, 7, 274, 125000, '2020-11-15 14:14:56'),
	(949, 8, 274, 20000, '2020-11-15 14:14:59'),
	(950, 9, 274, 500000, '2020-11-15 14:15:04'),
	(951, 10, 274, 750000, '2020-11-15 14:15:04'),
	(952, 11, 274, 999999, '2020-11-22 00:05:03');

-- Dumping structure for table harcourt.subject
CREATE TABLE IF NOT EXISTS `subject` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `author_id` int(11) NOT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `category` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `headline` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_viewable_for_alternative_manager` tinyint(1) NOT NULL,
  `subject_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_FBCE3E7AF675F31B` (`author_id`),
  CONSTRAINT `FK_FBCE3E7AF675F31B` FOREIGN KEY (`author_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table harcourt.subject: ~78 rows (approximately)


