--
-- Table structure for table `#__vpadvanceduser_data`
--

CREATE TABLE IF NOT EXISTS `#__vpadvanceduser_data` (
  `user_id` int(11) NOT NULL,
  `data_key` varchar(100) NOT NULL,
  `data_value` text NOT NULL,
  `ordering` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `idx_user_id_data_key` (`user_id`,`data_key`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Simple user profile storage table';

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

--
-- Table structure for table `#__vpadvanceduser_emailtemplates`
--

CREATE TABLE IF NOT EXISTS `#__vpadvanceduser_emailtemplates` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ordering` int(11) NOT NULL DEFAULT '0',
  `state` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `mode` varchar(7) NOT NULL,
  `checked_out` int(11) NOT NULL,
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `name` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `template` longtext NOT NULL,
  `is_default` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `purpose` varchar(50) NOT NULL,
  `created_by` int(11) NOT NULL DEFAULT '0',
  `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int(11) NOT NULL DEFAULT '0',
  `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `idx_is_default_purpose` (`is_default`,`purpose`),
  KEY `idx_state` (`state`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `#__vpadvanceduser_emailtemplates`
--

INSERT IGNORE INTO `#__vpadvanceduser_emailtemplates` (`id`, `ordering`, `state`, `mode`, `checked_out`, `checked_out_time`, `name`, `subject`, `template`, `is_default`, `purpose`, `created_by`, `created_time`, `modified_by`, `modified_time`) VALUES
(1, 1, 1, 'html', 0, '0000-00-00 00:00:00', 'User Registration with No Activation', '{{# JText.sprintf }}COM_USERS_EMAIL_ACCOUNT_DETAILS, {{ name }}, {{ sitename }}{{/ JText.sprintf }}', '<!DOCTYPE html>\r\n<html lang="en">\r\n<head>\r\n  <meta charset="utf-8">\r\n  <meta name="viewport" content="width=device-width, initial-scale=1">\r\n  <meta http-equiv="X-UA-Compatible" content="IE=edge" />\r\n  <style type="text/css">\r\n    /* CLIENT-SPECIFIC STYLES */\r\n    /* Force Outlook to provide a "view in browser" message */\r\n    #outlook a {\r\n      padding:0;\r\n    } \r\n    .ReadMsgBody {\r\n      width:100%;\r\n    }\r\n    /* Force Hotmail to display emails at full width */\r\n    .ExternalClass {\r\n      width:100%;\r\n    }\r\n    /* Force Hotmail to display normal line spacing */\r\n    .ExternalClass,\r\n    .ExternalClass p,\r\n    .ExternalClass span,\r\n    .ExternalClass font,\r\n    .ExternalClass td,\r\n    .ExternalClass div {\r\n      line-height: 100%;\r\n    }\r\n    /* Prevent WebKit and Windows mobile changing default text sizes */\r\n    body, table, td, a{\r\n      -webkit-text-size-adjust:100%;\r\n      -ms-text-size-adjust:100%;\r\n    }\r\n    /* Remove spacing between tables in Outlook 2007 and up */\r\n    table, td {\r\n      mso-table-lspace:0pt;\r\n      mso-table-rspace:0pt;\r\n    }\r\n    /* Allow smoother rendering of resized image in Internet Explorer */\r\n    img {\r\n      -ms-interpolation-mode:bicubic;\r\n    }\r\n\r\n    /* RESET STYLES */\r\n    body {\r\n      margin:0;\r\n      padding:0;\r\n    }\r\n    img {\r\n      border:0;\r\n      height:auto;\r\n      line-height:100%;\r\n      outline:none;\r\n      text-decoration:none;\r\n    }\r\n    table {\r\n      border-collapse:collapse !important;\r\n    }\r\n    body {\r\n      height:100% !important;\r\n      margin:0;\r\n      padding:0;\r\n      width:100% !important;\r\n    }\r\n\r\n    /* iOS BLUE LINKS */\r\n    .appleBody a {\r\n      color:#68440a;\r\n      text-decoration: none;\r\n    }\r\n    .appleFooter a {\r\n      color:#999999;\r\n      text-decoration: none;\r\n    }\r\n\r\n    /* MOBILE STYLES */\r\n    @media screen and (max-width: 525px) {\r\n        /* ALLOWS FOR FLUID TABLES */\r\n        table[class="wrapper"] {\r\n          width:100% !important;\r\n        }\r\n\r\n        /* ADJUSTS LAYOUT OF LOGO IMAGE */\r\n        td[class="logo"] {\r\n          text-align: left;\r\n          padding: 20px 0 20px 0 !important;\r\n        }\r\n        td[class="logo"] img {\r\n          margin:0 auto!important;\r\n        }\r\n\r\n        /* USE THESE CLASSES TO HIDE CONTENT ON MOBILE */\r\n        td[class="mobile-hide"] {\r\n          display:none;\r\n        }\r\n        img[class="mobile-hide"] {\r\n          display: none !important;\r\n        }\r\n        img[class="img-max"] {\r\n          max-width: 100% !important;\r\n          width: 100% !important;\r\n          height:auto !important;\r\n        }\r\n\r\n        /* FULL-WIDTH TABLES */\r\n        table[class="responsive-table"] {\r\n          width:100%!important;\r\n        }\r\n\r\n        /* UTILITY CLASSES FOR ADJUSTING PADDING ON MOBILE */\r\n        td[class="padding"] {\r\n          padding: 10px 5% 15px 5% !important;\r\n        }\r\n        td[class="padding-copy"] {\r\n          padding: 10px 5% 10px 5% !important;\r\n          text-align: left;\r\n        }\r\n        td[class="padding-meta"] {\r\n          padding: 30px 5% 0px 5% !important;\r\n          text-align: center;\r\n        }\r\n        td[class="no-pad"] {\r\n          padding: 0 0 20px 0 !important;\r\n        }\r\n        td[class="no-padding"] {\r\n          padding: 0 !important;\r\n        }\r\n        td[class="section-padding"] {\r\n          padding: 50px 15px 50px 15px !important;\r\n        }\r\n        td[class="section-padding-bottom-image"] {\r\n          padding: 50px 15px 0 15px !important;\r\n        }\r\n\r\n        /* ADJUST BUTTONS ON MOBILE */\r\n        td[class="mobile-wrapper"] {\r\n            padding: 10px 5% 15px 5% !important;\r\n        }\r\n        table[class="mobile-button-container"] {\r\n            margin:0 auto;\r\n            width:100% !important;\r\n        }\r\n        a[class="mobile-button"] {\r\n            width:80% !important;\r\n            padding: 15px !important;\r\n            border: 0 !important;\r\n            font-size: 16px !important;\r\n        }\r\n    }\r\n  </style>\r\n</head>\r\n<body style="margin: 0; padding: 0; background-color: #f2f2f2;" bgcolor=" #f2f2f2">\r\n\r\n    <!-- HEADER -->\r\n    <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n        <tr>\r\n            <td bgcolor="#FFFFFF" style="border-bottom: 1px solid #e2e5e8;">\r\n                <div align="center" style="padding: 0px 15px 0px 15px;">\r\n                    <table border="0" cellpadding="0" cellspacing="0" width="600" class="wrapper">\r\n                        <!-- LOGO/PREHEADER TEXT -->\r\n                        <tr>\r\n                            <td style="padding: 25px 0px 25px 0px;" class="logo">\r\n                                <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n                                    <tr>\r\n                                        <td bgcolor="#FFFFFF" width="300" align="left">\r\n                                            <!--SITE LOGO / SITE NAME-->\r\n                                            {{ offline_logo_link }}\r\n                                        </td>\r\n                                        <td bgcolor="#FFFFFF" width="300" align="right" class="mobile-hide">\r\n                                            <table border="0" cellpadding="0" cellspacing="0">\r\n                                                <tr>\r\n                                                    <td align="right" style="padding: 5px 0 0 0; font-size: 14px; font-family: Arial, sans-serif; color: #666666; text-decoration: none;">\r\n                                                      <!--ANY OTHER CONTENTS THAT YOU WANT TO SHOW AT RIGHT SIDE IN THE HEADER SECTION-->\r\n                                                    </td>\r\n                                                </tr>\r\n                                            </table>\r\n                                        </td>\r\n                                    </tr>\r\n                                </table>\r\n                            </td>\r\n                        </tr>\r\n                    </table>\r\n                </div>\r\n            </td>\r\n        </tr>\r\n    </table>\r\n\r\n    <!-- MAIN CONTENTS SECTION -->\r\n    <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n        <tr>\r\n            <td bgcolor="#f2f2f2" align="center" style="padding: 40px 15px 40px 15px;" class="section-padding">\r\n                <table border="0" cellpadding="0" cellspacing="0" width="600" class="responsive-table">\r\n                    <tr>\r\n                        <td bgcolor="#ffffff" style="background-color: #ffffff; border-bottom: 2px solid #e2e5e8;">\r\n                            <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                                <tr>\r\n                                    <td bgcolor="#ffffff" style="padding: 35px 25px; background-color: #ffffff;">\r\n                                        <!-- MAIN CONTENTS -->\r\n                                        <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                                            <tr>\r\n                                                <td align="left" style="font-size: 14px; line-height: 22px; font-family: Helvetica, Arial, sans-serif; color: #555555;" class="padding-copy">\r\n                                                    <div mc:edit="main_content" style="text-align: left; font-size: 14px; line-height: 22px; font-family: Helvetica, Arial, sans-serif; color: #555555;">\r\n                                                        <!-- JOOMLA CONTENTS GOES HERE -->\r\n                                                        {{# password_clear }}\r\n                                                            <!--If password is available-->\r\n                                                            <p>\r\n                                                              {{# JText.sprintf }}COM_USERS_EMAIL_REGISTERED_BODY, {{ name }}, {{ sitename }}, {{ siteurl_html }}, {{ username }}, {{ password_clear }}{{/ JText.sprintf }} \r\n                                                            </p>\r\n                                                        {{/ password_clear }}\r\n                                                        {{^ password_clear}}\r\n                                                            <!--If password is not available-->\r\n                                                            <p>\r\n                                                              {{# JText.sprintf }}COM_USERS_EMAIL_REGISTERED_BODY_NOPW, {{ name }}, {{ sitename }},  {{ siteurl_html }}{{/ JText.sprintf }} \r\n                                                            </p>\r\n                                                        {{/ password_clear }}\r\n                                                    </div>\r\n                                                </td>\r\n                                            </tr>\r\n                                        </table>\r\n                                    </td>\r\n                                </tr>\r\n                            </table>\r\n                        </td>\r\n                    </tr>\r\n                </table>\r\n            </td>\r\n        </tr>\r\n    </table>\r\n\r\n    <!-- FOOTER -->\r\n    <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n        <tr>\r\n            <td bgcolor="#f2f2f2" align="center" style="padding: 10px 0px 20px 0px;">\r\n                <!-- UNSUBSCRIBE COPY -->\r\n                <table width="600" border="0" cellspacing="0" cellpadding="0" align="center" class="responsive-table">\r\n                    <tr>\r\n                        <td align="left" style="font-size: 13px; line-height: 18px; font-family: Helvetica, Arial, sans-serif; color:#aaaaaa;" class="padding">\r\n                            <!--DISCLAIMER-->\r\n                            {{# JText._ }}COM_VPADVANCEDUSER_EMAIL_DISCLAIMER{{/ JText._ }}\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td align="left" style="font-size: 11px; line-height: 18px; font-family: Helvetica, Arial, sans-serif; color:#aaaaaa; padding-top: 15px;" class="padding">\r\n                            <!--SITE NAME AND OTHER CONTACT DETAILS-->\r\n                            <span class="appleFooter" style="color:#aaaaaa;">{{ sitename }}</span>\r\n                        </td>\r\n                    </tr>\r\n                </table>\r\n            </td>\r\n        </tr>\r\n    </table>\r\n\r\n</body>\r\n</html>', 1, 'user_registration', 939, '2016-04-26 06:15:53', 0, '0000-00-00 00:00:00'),
(2, 2, 1, 'html', 0, '0000-00-00 00:00:00', 'Registration with Self Activation', '{{# JText.sprintf }}COM_USERS_EMAIL_ACCOUNT_DETAILS, {{ name }}, {{ sitename }}{{/ JText.sprintf }}', '<!DOCTYPE html>\r\n<html lang="en">\r\n<head>\r\n  <meta charset="utf-8">\r\n  <meta name="viewport" content="width=device-width, initial-scale=1">\r\n  <meta http-equiv="X-UA-Compatible" content="IE=edge" />\r\n  <style type="text/css">\r\n    /* CLIENT-SPECIFIC STYLES */\r\n    /* Force Outlook to provide a "view in browser" message */\r\n    #outlook a {\r\n      padding:0;\r\n    } \r\n    .ReadMsgBody {\r\n      width:100%;\r\n    }\r\n    /* Force Hotmail to display emails at full width */\r\n    .ExternalClass {\r\n      width:100%;\r\n    }\r\n    /* Force Hotmail to display normal line spacing */\r\n    .ExternalClass,\r\n    .ExternalClass p,\r\n    .ExternalClass span,\r\n    .ExternalClass font,\r\n    .ExternalClass td,\r\n    .ExternalClass div {\r\n      line-height: 100%;\r\n    }\r\n    /* Prevent WebKit and Windows mobile changing default text sizes */\r\n    body, table, td, a{\r\n      -webkit-text-size-adjust:100%;\r\n      -ms-text-size-adjust:100%;\r\n    }\r\n    /* Remove spacing between tables in Outlook 2007 and up */\r\n    table, td {\r\n      mso-table-lspace:0pt;\r\n      mso-table-rspace:0pt;\r\n    }\r\n    /* Allow smoother rendering of resized image in Internet Explorer */\r\n    img {\r\n      -ms-interpolation-mode:bicubic;\r\n    }\r\n\r\n    /* RESET STYLES */\r\n    body {\r\n      margin:0;\r\n      padding:0;\r\n    }\r\n    img {\r\n      border:0;\r\n      height:auto;\r\n      line-height:100%;\r\n      outline:none;\r\n      text-decoration:none;\r\n    }\r\n    table {\r\n      border-collapse:collapse !important;\r\n    }\r\n    body {\r\n      height:100% !important;\r\n      margin:0;\r\n      padding:0;\r\n      width:100% !important;\r\n    }\r\n\r\n    /* iOS BLUE LINKS */\r\n    .appleBody a {\r\n      color:#68440a;\r\n      text-decoration: none;\r\n    }\r\n    .appleFooter a {\r\n      color:#999999;\r\n      text-decoration: none;\r\n    }\r\n\r\n    /* MOBILE STYLES */\r\n    @media screen and (max-width: 525px) {\r\n        /* ALLOWS FOR FLUID TABLES */\r\n        table[class="wrapper"] {\r\n          width:100% !important;\r\n        }\r\n\r\n        /* ADJUSTS LAYOUT OF LOGO IMAGE */\r\n        td[class="logo"] {\r\n          text-align: left;\r\n          padding: 20px 0 20px 0 !important;\r\n        }\r\n        td[class="logo"] img {\r\n          margin:0 auto!important;\r\n        }\r\n\r\n        /* USE THESE CLASSES TO HIDE CONTENT ON MOBILE */\r\n        td[class="mobile-hide"] {\r\n          display:none;\r\n        }\r\n        img[class="mobile-hide"] {\r\n          display: none !important;\r\n        }\r\n        img[class="img-max"] {\r\n          max-width: 100% !important;\r\n          width: 100% !important;\r\n          height:auto !important;\r\n        }\r\n\r\n        /* FULL-WIDTH TABLES */\r\n        table[class="responsive-table"] {\r\n          width:100%!important;\r\n        }\r\n\r\n        /* UTILITY CLASSES FOR ADJUSTING PADDING ON MOBILE */\r\n        td[class="padding"] {\r\n          padding: 10px 5% 15px 5% !important;\r\n        }\r\n        td[class="padding-copy"] {\r\n          padding: 10px 5% 10px 5% !important;\r\n          text-align: left;\r\n        }\r\n        td[class="padding-meta"] {\r\n          padding: 30px 5% 0px 5% !important;\r\n          text-align: center;\r\n        }\r\n        td[class="no-pad"] {\r\n          padding: 0 0 20px 0 !important;\r\n        }\r\n        td[class="no-padding"] {\r\n          padding: 0 !important;\r\n        }\r\n        td[class="section-padding"] {\r\n          padding: 50px 15px 50px 15px !important;\r\n        }\r\n        td[class="section-padding-bottom-image"] {\r\n          padding: 50px 15px 0 15px !important;\r\n        }\r\n\r\n        /* ADJUST BUTTONS ON MOBILE */\r\n        td[class="mobile-wrapper"] {\r\n            padding: 10px 5% 15px 5% !important;\r\n        }\r\n        table[class="mobile-button-container"] {\r\n            margin:0 auto;\r\n            width:100% !important;\r\n        }\r\n        a[class="mobile-button"] {\r\n            width:80% !important;\r\n            padding: 15px !important;\r\n            border: 0 !important;\r\n            font-size: 16px !important;\r\n        }\r\n    }\r\n  </style>\r\n</head>\r\n<body style="margin: 0; padding: 0; background-color: #f2f2f2;" bgcolor=" #f2f2f2">\r\n\r\n    <!-- HEADER -->\r\n    <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n        <tr>\r\n            <td bgcolor="#FFFFFF" style="border-bottom: 1px solid #e2e5e8;">\r\n                <div align="center" style="padding: 0px 15px 0px 15px;">\r\n                    <table border="0" cellpadding="0" cellspacing="0" width="600" class="wrapper">\r\n                        <!-- LOGO/PREHEADER TEXT -->\r\n                        <tr>\r\n                            <td style="padding: 25px 0px 25px 0px;" class="logo">\r\n                                <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n                                    <tr>\r\n                                        <td bgcolor="#FFFFFF" width="300" align="left">\r\n                                            <!--SITE LOGO / SITE NAME-->\r\n                                            {{ offline_logo_link }}\r\n                                        </td>\r\n                                        <td bgcolor="#FFFFFF" width="300" align="right" class="mobile-hide">\r\n                                            <table border="0" cellpadding="0" cellspacing="0">\r\n                                                <tr>\r\n                                                    <td align="right" style="padding: 5px 0 0 0; font-size: 14px; font-family: Arial, sans-serif; color: #666666; text-decoration: none;">\r\n                                                      <!--ANY OTHER CONTENTS THAT YOU WANT TO SHOW AT RIGHT SIDE IN THE HEADER SECTION-->\r\n                                                    </td>\r\n                                                </tr>\r\n                                            </table>\r\n                                        </td>\r\n                                    </tr>\r\n                                </table>\r\n                            </td>\r\n                        </tr>\r\n                    </table>\r\n                </div>\r\n            </td>\r\n        </tr>\r\n    </table>\r\n\r\n    <!-- MAIN CONTENTS SECTION -->\r\n    <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n        <tr>\r\n            <td bgcolor="#f2f2f2" align="center" style="padding: 40px 15px 40px 15px;" class="section-padding">\r\n                <table border="0" cellpadding="0" cellspacing="0" width="600" class="responsive-table">\r\n                    <tr>\r\n                        <td bgcolor="#ffffff" style="background-color: #ffffff; border-bottom: 2px solid #e2e5e8;">\r\n                            <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                                <tr>\r\n                                    <td bgcolor="#ffffff" style="padding: 35px 25px; background-color: #ffffff;">\r\n                                        <!-- MAIN CONTENTS -->\r\n                                        <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                                            <tr>\r\n                                                <td align="left" style="font-size: 14px; line-height: 22px; font-family: Helvetica, Arial, sans-serif; color: #555555;" class="padding-copy">\r\n                                                    <div mc:edit="main_content" style="text-align: left; font-size: 14px; line-height: 22px; font-family: Helvetica, Arial, sans-serif; color: #555555;">\r\n                                                        <!-- JOOMLA CONTENTS GOES HERE -->\r\n                                                        {{# password_clear }}\r\n                                                            <!--If password is available-->\r\n                                                            <p>\r\n                                                              {{# JText.sprintf }}COM_USERS_EMAIL_REGISTERED_WITH_ACTIVATION_BODY, {{ name }}, {{ sitename }}, {{ link_html }}, {{ siteurl_html }}, {{ username }}, {{ password_clear }}{{/ JText.sprintf }} \r\n                                                            </p>\r\n                                                        {{/ password_clear }}\r\n                                                        {{^ password_clear}}\r\n                                                            <!--If password is not available-->\r\n                                                            <p>\r\n                                                              {{# JText.sprintf }}COM_USERS_EMAIL_REGISTERED_WITH_ACTIVATION_BODY_NOPW, {{ name }}, {{ sitename }}, {{ link_html }}, {{ siteurl_html }}, {{ username }}{{/ JText.sprintf }} \r\n                                                            </p>\r\n                                                        {{/ password_clear }}\r\n                                                    </div>\r\n                                                </td>\r\n                                            </tr>\r\n                                        </table>\r\n                                    </td>\r\n                                </tr>\r\n                            </table>\r\n                        </td>\r\n                    </tr>\r\n                </table>\r\n            </td>\r\n        </tr>\r\n    </table>\r\n\r\n    <!-- FOOTER -->\r\n    <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n        <tr>\r\n            <td bgcolor="#f2f2f2" align="center" style="padding: 10px 0px 20px 0px;">\r\n                <!-- UNSUBSCRIBE COPY -->\r\n                <table width="600" border="0" cellspacing="0" cellpadding="0" align="center" class="responsive-table">\r\n                    <tr>\r\n                        <td align="left" style="font-size: 13px; line-height: 18px; font-family: Helvetica, Arial, sans-serif; color:#aaaaaa;" class="padding">\r\n                            <!--DISCLAIMER-->\r\n                            {{# JText._ }}COM_VPADVANCEDUSER_EMAIL_DISCLAIMER{{/ JText._ }}\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td align="left" style="font-size: 11px; line-height: 18px; font-family: Helvetica, Arial, sans-serif; color:#aaaaaa; padding-top: 15px;" class="padding">\r\n                            <!--SITE NAME AND OTHER CONTACT DETAILS-->\r\n                            <span class="appleFooter" style="color:#aaaaaa;">{{ sitename }}</span>\r\n                        </td>\r\n                    </tr>\r\n                </table>\r\n            </td>\r\n        </tr>\r\n    </table>\r\n\r\n</body>\r\n</html>', 1, 'user_activation', 939, '2016-04-26 06:26:28', 0, '0000-00-00 00:00:00'),
(3, 3, 1, 'html', 0, '0000-00-00 00:00:00', 'Registration with Admin Activation', '{{# JText.sprintf }}COM_USERS_EMAIL_ACCOUNT_DETAILS, {{ name }}, {{ sitename }}{{/ JText.sprintf }}', '<!DOCTYPE html>\r\n<html lang="en">\r\n<head>\r\n  <meta charset="utf-8">\r\n  <meta name="viewport" content="width=device-width, initial-scale=1">\r\n  <meta http-equiv="X-UA-Compatible" content="IE=edge" />\r\n  <style type="text/css">\r\n    /* CLIENT-SPECIFIC STYLES */\r\n    /* Force Outlook to provide a "view in browser" message */\r\n    #outlook a {\r\n      padding:0;\r\n    } \r\n    .ReadMsgBody {\r\n      width:100%;\r\n    }\r\n    /* Force Hotmail to display emails at full width */\r\n    .ExternalClass {\r\n      width:100%;\r\n    }\r\n    /* Force Hotmail to display normal line spacing */\r\n    .ExternalClass,\r\n    .ExternalClass p,\r\n    .ExternalClass span,\r\n    .ExternalClass font,\r\n    .ExternalClass td,\r\n    .ExternalClass div {\r\n      line-height: 100%;\r\n    }\r\n    /* Prevent WebKit and Windows mobile changing default text sizes */\r\n    body, table, td, a{\r\n      -webkit-text-size-adjust:100%;\r\n      -ms-text-size-adjust:100%;\r\n    }\r\n    /* Remove spacing between tables in Outlook 2007 and up */\r\n    table, td {\r\n      mso-table-lspace:0pt;\r\n      mso-table-rspace:0pt;\r\n    }\r\n    /* Allow smoother rendering of resized image in Internet Explorer */\r\n    img {\r\n      -ms-interpolation-mode:bicubic;\r\n    }\r\n\r\n    /* RESET STYLES */\r\n    body {\r\n      margin:0;\r\n      padding:0;\r\n    }\r\n    img {\r\n      border:0;\r\n      height:auto;\r\n      line-height:100%;\r\n      outline:none;\r\n      text-decoration:none;\r\n    }\r\n    table {\r\n      border-collapse:collapse !important;\r\n    }\r\n    body {\r\n      height:100% !important;\r\n      margin:0;\r\n      padding:0;\r\n      width:100% !important;\r\n    }\r\n\r\n    /* iOS BLUE LINKS */\r\n    .appleBody a {\r\n      color:#68440a;\r\n      text-decoration: none;\r\n    }\r\n    .appleFooter a {\r\n      color:#999999;\r\n      text-decoration: none;\r\n    }\r\n\r\n    /* MOBILE STYLES */\r\n    @media screen and (max-width: 525px) {\r\n        /* ALLOWS FOR FLUID TABLES */\r\n        table[class="wrapper"] {\r\n          width:100% !important;\r\n        }\r\n\r\n        /* ADJUSTS LAYOUT OF LOGO IMAGE */\r\n        td[class="logo"] {\r\n          text-align: left;\r\n          padding: 20px 0 20px 0 !important;\r\n        }\r\n        td[class="logo"] img {\r\n          margin:0 auto!important;\r\n        }\r\n\r\n        /* USE THESE CLASSES TO HIDE CONTENT ON MOBILE */\r\n        td[class="mobile-hide"] {\r\n          display:none;\r\n        }\r\n        img[class="mobile-hide"] {\r\n          display: none !important;\r\n        }\r\n        img[class="img-max"] {\r\n          max-width: 100% !important;\r\n          width: 100% !important;\r\n          height:auto !important;\r\n        }\r\n\r\n        /* FULL-WIDTH TABLES */\r\n        table[class="responsive-table"] {\r\n          width:100%!important;\r\n        }\r\n\r\n        /* UTILITY CLASSES FOR ADJUSTING PADDING ON MOBILE */\r\n        td[class="padding"] {\r\n          padding: 10px 5% 15px 5% !important;\r\n        }\r\n        td[class="padding-copy"] {\r\n          padding: 10px 5% 10px 5% !important;\r\n          text-align: left;\r\n        }\r\n        td[class="padding-meta"] {\r\n          padding: 30px 5% 0px 5% !important;\r\n          text-align: center;\r\n        }\r\n        td[class="no-pad"] {\r\n          padding: 0 0 20px 0 !important;\r\n        }\r\n        td[class="no-padding"] {\r\n          padding: 0 !important;\r\n        }\r\n        td[class="section-padding"] {\r\n          padding: 50px 15px 50px 15px !important;\r\n        }\r\n        td[class="section-padding-bottom-image"] {\r\n          padding: 50px 15px 0 15px !important;\r\n        }\r\n\r\n        /* ADJUST BUTTONS ON MOBILE */\r\n        td[class="mobile-wrapper"] {\r\n            padding: 10px 5% 15px 5% !important;\r\n        }\r\n        table[class="mobile-button-container"] {\r\n            margin:0 auto;\r\n            width:100% !important;\r\n        }\r\n        a[class="mobile-button"] {\r\n            width:80% !important;\r\n            padding: 15px !important;\r\n            border: 0 !important;\r\n            font-size: 16px !important;\r\n        }\r\n    }\r\n  </style>\r\n</head>\r\n<body style="margin: 0; padding: 0; background-color: #f2f2f2;" bgcolor=" #f2f2f2">\r\n\r\n    <!-- HEADER -->\r\n    <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n        <tr>\r\n            <td bgcolor="#FFFFFF" style="border-bottom: 1px solid #e2e5e8;">\r\n                <div align="center" style="padding: 0px 15px 0px 15px;">\r\n                    <table border="0" cellpadding="0" cellspacing="0" width="600" class="wrapper">\r\n                        <!-- LOGO/PREHEADER TEXT -->\r\n                        <tr>\r\n                            <td style="padding: 25px 0px 25px 0px;" class="logo">\r\n                                <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n                                    <tr>\r\n                                        <td bgcolor="#FFFFFF" width="300" align="left">\r\n                                            <!--SITE LOGO / SITE NAME-->\r\n                                            {{ offline_logo_link }}\r\n                                        </td>\r\n                                        <td bgcolor="#FFFFFF" width="300" align="right" class="mobile-hide">\r\n                                            <table border="0" cellpadding="0" cellspacing="0">\r\n                                                <tr>\r\n                                                    <td align="right" style="padding: 5px 0 0 0; font-size: 14px; font-family: Arial, sans-serif; color: #666666; text-decoration: none;">\r\n                                                      <!--ANY OTHER CONTENTS THAT YOU WANT TO SHOW AT RIGHT SIDE IN THE HEADER SECTION-->\r\n                                                    </td>\r\n                                                </tr>\r\n                                            </table>\r\n                                        </td>\r\n                                    </tr>\r\n                                </table>\r\n                            </td>\r\n                        </tr>\r\n                    </table>\r\n                </div>\r\n            </td>\r\n        </tr>\r\n    </table>\r\n\r\n    <!-- MAIN CONTENTS SECTION -->\r\n    <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n        <tr>\r\n            <td bgcolor="#f2f2f2" align="center" style="padding: 40px 15px 40px 15px;" class="section-padding">\r\n                <table border="0" cellpadding="0" cellspacing="0" width="600" class="responsive-table">\r\n                    <tr>\r\n                        <td bgcolor="#ffffff" style="background-color: #ffffff; border-bottom: 2px solid #e2e5e8;">\r\n                            <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                                <tr>\r\n                                    <td bgcolor="#ffffff" style="padding: 35px 25px; background-color: #ffffff;">\r\n                                        <!-- MAIN CONTENTS -->\r\n                                        <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                                            <tr>\r\n                                                <td align="left" style="font-size: 14px; line-height: 22px; font-family: Helvetica, Arial, sans-serif; color: #555555;" class="padding-copy">\r\n                                                    <div mc:edit="main_content" style="text-align: left; font-size: 14px; line-height: 22px; font-family: Helvetica, Arial, sans-serif; color: #555555;">\r\n                                                        <!-- JOOMLA CONTENTS GOES HERE -->\r\n                                                        {{# password_clear }}\r\n                                                            <!--If password is available-->\r\n                                                            <p>\r\n                                                              {{# JText.sprintf }}COM_USERS_EMAIL_REGISTERED_WITH_ADMIN_ACTIVATION_BODY, {{ name }}, {{ sitename }}, {{ link_html }}, {{ siteurl_html }}, {{ username }}, {{ password_clear }}{{/ JText.sprintf }} \r\n                                                            </p>\r\n                                                        {{/ password_clear }}\r\n                                                        {{^ password_clear}}\r\n                                                            <!--If password is not available-->\r\n                                                            <p>\r\n                                                              {{# JText.sprintf }}COM_USERS_EMAIL_REGISTERED_WITH_ADMIN_ACTIVATION_BODY_NOPW, {{ name }}, {{ sitename }}, {{ link_html }}, {{ siteurl_html }}, {{ username }}{{/ JText.sprintf }} \r\n                                                            </p>\r\n                                                        {{/ password_clear }}\r\n                                                    </div>\r\n                                                </td>\r\n                                            </tr>\r\n                                        </table>\r\n                                    </td>\r\n                                </tr>\r\n                            </table>\r\n                        </td>\r\n                    </tr>\r\n                </table>\r\n            </td>\r\n        </tr>\r\n    </table>\r\n\r\n    <!-- FOOTER -->\r\n    <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n        <tr>\r\n            <td bgcolor="#f2f2f2" align="center" style="padding: 10px 0px 20px 0px;">\r\n                <!-- UNSUBSCRIBE COPY -->\r\n                <table width="600" border="0" cellspacing="0" cellpadding="0" align="center" class="responsive-table">\r\n                    <tr>\r\n                        <td align="left" style="font-size: 13px; line-height: 18px; font-family: Helvetica, Arial, sans-serif; color:#aaaaaa;" class="padding">\r\n                            <!--DISCLAIMER-->\r\n                            {{# JText._ }}COM_VPADVANCEDUSER_EMAIL_DISCLAIMER{{/ JText._ }}\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td align="left" style="font-size: 11px; line-height: 18px; font-family: Helvetica, Arial, sans-serif; color:#aaaaaa; padding-top: 15px;" class="padding">\r\n                            <!--SITE NAME AND OTHER CONTACT DETAILS-->\r\n                            <span class="appleFooter" style="color:#aaaaaa;">{{ sitename }}</span>\r\n                        </td>\r\n                    </tr>\r\n                </table>\r\n            </td>\r\n        </tr>\r\n    </table>\r\n\r\n</body>\r\n</html>', 1, 'admin_activation', 939, '2016-04-26 06:29:53', 0, '0000-00-00 00:00:00'),
(4, 4, 1, 'html', 0, '0000-00-00 00:00:00', 'Password Reset', '{{# JText.sprintf }}COM_USERS_EMAIL_PASSWORD_RESET_SUBJECT, {{ sitename }}{{/ JText.sprintf }}', '<!DOCTYPE html>\r\n<html lang="en">\r\n<head>\r\n  <meta charset="utf-8">\r\n  <meta name="viewport" content="width=device-width, initial-scale=1">\r\n  <meta http-equiv="X-UA-Compatible" content="IE=edge" />\r\n  <style type="text/css">\r\n    /* CLIENT-SPECIFIC STYLES */\r\n    /* Force Outlook to provide a "view in browser" message */\r\n    #outlook a {\r\n      padding:0;\r\n    } \r\n    .ReadMsgBody {\r\n      width:100%;\r\n    }\r\n    /* Force Hotmail to display emails at full width */\r\n    .ExternalClass {\r\n      width:100%;\r\n    }\r\n    /* Force Hotmail to display normal line spacing */\r\n    .ExternalClass,\r\n    .ExternalClass p,\r\n    .ExternalClass span,\r\n    .ExternalClass font,\r\n    .ExternalClass td,\r\n    .ExternalClass div {\r\n      line-height: 100%;\r\n    }\r\n    /* Prevent WebKit and Windows mobile changing default text sizes */\r\n    body, table, td, a{\r\n      -webkit-text-size-adjust:100%;\r\n      -ms-text-size-adjust:100%;\r\n    }\r\n    /* Remove spacing between tables in Outlook 2007 and up */\r\n    table, td {\r\n      mso-table-lspace:0pt;\r\n      mso-table-rspace:0pt;\r\n    }\r\n    /* Allow smoother rendering of resized image in Internet Explorer */\r\n    img {\r\n      -ms-interpolation-mode:bicubic;\r\n    }\r\n\r\n    /* RESET STYLES */\r\n    body {\r\n      margin:0;\r\n      padding:0;\r\n    }\r\n    img {\r\n      border:0;\r\n      height:auto;\r\n      line-height:100%;\r\n      outline:none;\r\n      text-decoration:none;\r\n    }\r\n    table {\r\n      border-collapse:collapse !important;\r\n    }\r\n    body {\r\n      height:100% !important;\r\n      margin:0;\r\n      padding:0;\r\n      width:100% !important;\r\n    }\r\n\r\n    /* iOS BLUE LINKS */\r\n    .appleBody a {\r\n      color:#68440a;\r\n      text-decoration: none;\r\n    }\r\n    .appleFooter a {\r\n      color:#999999;\r\n      text-decoration: none;\r\n    }\r\n\r\n    /* MOBILE STYLES */\r\n    @media screen and (max-width: 525px) {\r\n        /* ALLOWS FOR FLUID TABLES */\r\n        table[class="wrapper"] {\r\n          width:100% !important;\r\n        }\r\n\r\n        /* ADJUSTS LAYOUT OF LOGO IMAGE */\r\n        td[class="logo"] {\r\n          text-align: left;\r\n          padding: 20px 0 20px 0 !important;\r\n        }\r\n        td[class="logo"] img {\r\n          margin:0 auto!important;\r\n        }\r\n\r\n        /* USE THESE CLASSES TO HIDE CONTENT ON MOBILE */\r\n        td[class="mobile-hide"] {\r\n          display:none;\r\n        }\r\n        img[class="mobile-hide"] {\r\n          display: none !important;\r\n        }\r\n        img[class="img-max"] {\r\n          max-width: 100% !important;\r\n          width: 100% !important;\r\n          height:auto !important;\r\n        }\r\n\r\n        /* FULL-WIDTH TABLES */\r\n        table[class="responsive-table"] {\r\n          width:100%!important;\r\n        }\r\n\r\n        /* UTILITY CLASSES FOR ADJUSTING PADDING ON MOBILE */\r\n        td[class="padding"] {\r\n          padding: 10px 5% 15px 5% !important;\r\n        }\r\n        td[class="padding-copy"] {\r\n          padding: 10px 5% 10px 5% !important;\r\n          text-align: left;\r\n        }\r\n        td[class="padding-meta"] {\r\n          padding: 30px 5% 0px 5% !important;\r\n          text-align: center;\r\n        }\r\n        td[class="no-pad"] {\r\n          padding: 0 0 20px 0 !important;\r\n        }\r\n        td[class="no-padding"] {\r\n          padding: 0 !important;\r\n        }\r\n        td[class="section-padding"] {\r\n          padding: 50px 15px 50px 15px !important;\r\n        }\r\n        td[class="section-padding-bottom-image"] {\r\n          padding: 50px 15px 0 15px !important;\r\n        }\r\n\r\n        /* ADJUST BUTTONS ON MOBILE */\r\n        td[class="mobile-wrapper"] {\r\n            padding: 10px 5% 15px 5% !important;\r\n        }\r\n        table[class="mobile-button-container"] {\r\n            margin:0 auto;\r\n            width:100% !important;\r\n        }\r\n        a[class="mobile-button"] {\r\n            width:80% !important;\r\n            padding: 15px !important;\r\n            border: 0 !important;\r\n            font-size: 16px !important;\r\n        }\r\n    }\r\n  </style>\r\n</head>\r\n<body style="margin: 0; padding: 0; background-color: #f2f2f2;" bgcolor=" #f2f2f2">\r\n\r\n    <!-- HEADER -->\r\n    <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n        <tr>\r\n            <td bgcolor="#FFFFFF" style="border-bottom: 1px solid #e2e5e8;">\r\n                <div align="center" style="padding: 0px 15px 0px 15px;">\r\n                    <table border="0" cellpadding="0" cellspacing="0" width="600" class="wrapper">\r\n                        <!-- LOGO/PREHEADER TEXT -->\r\n                        <tr>\r\n                            <td style="padding: 25px 0px 25px 0px;" class="logo">\r\n                                <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n                                    <tr>\r\n                                        <td bgcolor="#FFFFFF" width="300" align="left">\r\n                                            <!--SITE LOGO / SITE NAME-->\r\n                                            {{ offline_logo_link }}\r\n                                        </td>\r\n                                        <td bgcolor="#FFFFFF" width="300" align="right" class="mobile-hide">\r\n                                            <table border="0" cellpadding="0" cellspacing="0">\r\n                                                <tr>\r\n                                                    <td align="right" style="padding: 5px 0 0 0; font-size: 14px; font-family: Arial, sans-serif; color: #666666; text-decoration: none;">\r\n                                                      <!--ANY OTHER CONTENTS THAT YOU WANT TO SHOW AT RIGHT SIDE IN THE HEADER SECTION-->\r\n                                                    </td>\r\n                                                </tr>\r\n                                            </table>\r\n                                        </td>\r\n                                    </tr>\r\n                                </table>\r\n                            </td>\r\n                        </tr>\r\n                    </table>\r\n                </div>\r\n            </td>\r\n        </tr>\r\n    </table>\r\n\r\n    <!-- MAIN CONTENTS SECTION -->\r\n    <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n        <tr>\r\n            <td bgcolor="#f2f2f2" align="center" style="padding: 40px 15px 40px 15px;" class="section-padding">\r\n                <table border="0" cellpadding="0" cellspacing="0" width="600" class="responsive-table">\r\n                    <tr>\r\n                        <td bgcolor="#ffffff" style="background-color: #ffffff; border-bottom: 2px solid #e2e5e8;">\r\n                            <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                                <tr>\r\n                                    <td bgcolor="#ffffff" style="padding: 35px 25px; background-color: #ffffff;">\r\n                                        <!-- MAIN CONTENTS -->\r\n                                        <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                                            <tr>\r\n                                                <td align="left" style="font-size: 14px; line-height: 22px; font-family: Helvetica, Arial, sans-serif; color: #555555;" class="padding-copy">\r\n                                                    <div mc:edit="main_content" style="text-align: left; font-size: 14px; line-height: 22px; font-family: Helvetica, Arial, sans-serif; color: #555555;">\r\n                                                        <!-- JOOMLA CONTENTS GOES HERE -->\r\n                                                        {{# JText.sprintf }}COM_USERS_EMAIL_PASSWORD_RESET_BODY, {{ sitename }}, {{ token }}, {{ link_html }}{{/ JText.sprintf }}\r\n                                                    </div>\r\n                                                </td>\r\n                                            </tr>\r\n                                        </table>\r\n                                    </td>\r\n                                </tr>\r\n                            </table>\r\n                        </td>\r\n                    </tr>\r\n                </table>\r\n            </td>\r\n        </tr>\r\n    </table>\r\n\r\n    <!-- FOOTER -->\r\n    <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n        <tr>\r\n            <td bgcolor="#f2f2f2" align="center" style="padding: 10px 0px 20px 0px;">\r\n                <!-- UNSUBSCRIBE COPY -->\r\n                <table width="600" border="0" cellspacing="0" cellpadding="0" align="center" class="responsive-table">\r\n                    <tr>\r\n                        <td align="left" style="font-size: 13px; line-height: 18px; font-family: Helvetica, Arial, sans-serif; color:#aaaaaa;" class="padding">\r\n                            <!--DISCLAIMER-->\r\n                            {{# JText._ }}COM_VPADVANCEDUSER_EMAIL_DISCLAIMER{{/ JText._ }}\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td align="left" style="font-size: 11px; line-height: 18px; font-family: Helvetica, Arial, sans-serif; color:#aaaaaa; padding-top: 15px;" class="padding">\r\n                            <!--SITE NAME AND OTHER CONTACT DETAILS-->\r\n                            <span class="appleFooter" style="color:#aaaaaa;">{{ sitename }}</span>\r\n                        </td>\r\n                    </tr>\r\n                </table>\r\n            </td>\r\n        </tr>\r\n    </table>\r\n\r\n</body>\r\n</html>', 1, 'password_reset', 939, '2016-04-26 06:33:07', 939, '2016-04-26 06:33:10');
INSERT IGNORE INTO `#__vpadvanceduser_emailtemplates` (`id`, `ordering`, `state`, `mode`, `checked_out`, `checked_out_time`, `name`, `subject`, `template`, `is_default`, `purpose`, `created_by`, `created_time`, `modified_by`, `modified_time`) VALUES
(5, 5, 1, 'html', 0, '0000-00-00 00:00:00', 'Registration Notification to Admin', '{{# JText.sprintf }}COM_USERS_EMAIL_ACCOUNT_DETAILS, {{ name }}, {{ sitename }}{{/ JText.sprintf }}', '<!DOCTYPE html>\r\n<html lang="en">\r\n<head>\r\n  <meta charset="utf-8">\r\n  <meta name="viewport" content="width=device-width, initial-scale=1">\r\n  <meta http-equiv="X-UA-Compatible" content="IE=edge" />\r\n  <style type="text/css">\r\n    /* CLIENT-SPECIFIC STYLES */\r\n    /* Force Outlook to provide a "view in browser" message */\r\n    #outlook a {\r\n      padding:0;\r\n    } \r\n    .ReadMsgBody {\r\n      width:100%;\r\n    }\r\n    /* Force Hotmail to display emails at full width */\r\n    .ExternalClass {\r\n      width:100%;\r\n    }\r\n    /* Force Hotmail to display normal line spacing */\r\n    .ExternalClass,\r\n    .ExternalClass p,\r\n    .ExternalClass span,\r\n    .ExternalClass font,\r\n    .ExternalClass td,\r\n    .ExternalClass div {\r\n      line-height: 100%;\r\n    }\r\n    /* Prevent WebKit and Windows mobile changing default text sizes */\r\n    body, table, td, a{\r\n      -webkit-text-size-adjust:100%;\r\n      -ms-text-size-adjust:100%;\r\n    }\r\n    /* Remove spacing between tables in Outlook 2007 and up */\r\n    table, td {\r\n      mso-table-lspace:0pt;\r\n      mso-table-rspace:0pt;\r\n    }\r\n    /* Allow smoother rendering of resized image in Internet Explorer */\r\n    img {\r\n      -ms-interpolation-mode:bicubic;\r\n    }\r\n\r\n    /* RESET STYLES */\r\n    body {\r\n      margin:0;\r\n      padding:0;\r\n    }\r\n    img {\r\n      border:0;\r\n      height:auto;\r\n      line-height:100%;\r\n      outline:none;\r\n      text-decoration:none;\r\n    }\r\n    table {\r\n      border-collapse:collapse !important;\r\n    }\r\n    body {\r\n      height:100% !important;\r\n      margin:0;\r\n      padding:0;\r\n      width:100% !important;\r\n    }\r\n\r\n    /* iOS BLUE LINKS */\r\n    .appleBody a {\r\n      color:#68440a;\r\n      text-decoration: none;\r\n    }\r\n    .appleFooter a {\r\n      color:#999999;\r\n      text-decoration: none;\r\n    }\r\n\r\n    /* MOBILE STYLES */\r\n    @media screen and (max-width: 525px) {\r\n        /* ALLOWS FOR FLUID TABLES */\r\n        table[class="wrapper"] {\r\n          width:100% !important;\r\n        }\r\n\r\n        /* ADJUSTS LAYOUT OF LOGO IMAGE */\r\n        td[class="logo"] {\r\n          text-align: left;\r\n          padding: 20px 0 20px 0 !important;\r\n        }\r\n        td[class="logo"] img {\r\n          margin:0 auto!important;\r\n        }\r\n\r\n        /* USE THESE CLASSES TO HIDE CONTENT ON MOBILE */\r\n        td[class="mobile-hide"] {\r\n          display:none;\r\n        }\r\n        img[class="mobile-hide"] {\r\n          display: none !important;\r\n        }\r\n        img[class="img-max"] {\r\n          max-width: 100% !important;\r\n          width: 100% !important;\r\n          height:auto !important;\r\n        }\r\n\r\n        /* FULL-WIDTH TABLES */\r\n        table[class="responsive-table"] {\r\n          width:100%!important;\r\n        }\r\n\r\n        /* UTILITY CLASSES FOR ADJUSTING PADDING ON MOBILE */\r\n        td[class="padding"] {\r\n          padding: 10px 5% 15px 5% !important;\r\n        }\r\n        td[class="padding-copy"] {\r\n          padding: 10px 5% 10px 5% !important;\r\n          text-align: left;\r\n        }\r\n        td[class="padding-meta"] {\r\n          padding: 30px 5% 0px 5% !important;\r\n          text-align: center;\r\n        }\r\n        td[class="no-pad"] {\r\n          padding: 0 0 20px 0 !important;\r\n        }\r\n        td[class="no-padding"] {\r\n          padding: 0 !important;\r\n        }\r\n        td[class="section-padding"] {\r\n          padding: 50px 15px 50px 15px !important;\r\n        }\r\n        td[class="section-padding-bottom-image"] {\r\n          padding: 50px 15px 0 15px !important;\r\n        }\r\n\r\n        /* ADJUST BUTTONS ON MOBILE */\r\n        td[class="mobile-wrapper"] {\r\n            padding: 10px 5% 15px 5% !important;\r\n        }\r\n        table[class="mobile-button-container"] {\r\n            margin:0 auto;\r\n            width:100% !important;\r\n        }\r\n        a[class="mobile-button"] {\r\n            width:80% !important;\r\n            padding: 15px !important;\r\n            border: 0 !important;\r\n            font-size: 16px !important;\r\n        }\r\n    }\r\n  </style>\r\n</head>\r\n<body style="margin: 0; padding: 0; background-color: #f2f2f2;" bgcolor=" #f2f2f2">\r\n\r\n    <!-- HEADER -->\r\n    <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n        <tr>\r\n            <td bgcolor="#FFFFFF" style="border-bottom: 1px solid #e2e5e8;">\r\n                <div align="center" style="padding: 0px 15px 0px 15px;">\r\n                    <table border="0" cellpadding="0" cellspacing="0" width="600" class="wrapper">\r\n                        <!-- LOGO/PREHEADER TEXT -->\r\n                        <tr>\r\n                            <td style="padding: 25px 0px 25px 0px;" class="logo">\r\n                                <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n                                    <tr>\r\n                                        <td bgcolor="#FFFFFF" width="300" align="left">\r\n                                            <!--SITE LOGO / SITE NAME-->\r\n                                            {{ offline_logo_link }}\r\n                                        </td>\r\n                                        <td bgcolor="#FFFFFF" width="300" align="right" class="mobile-hide">\r\n                                            <table border="0" cellpadding="0" cellspacing="0">\r\n                                                <tr>\r\n                                                    <td align="right" style="padding: 5px 0 0 0; font-size: 14px; font-family: Arial, sans-serif; color: #666666; text-decoration: none;">\r\n                                                      <!--ANY OTHER CONTENTS THAT YOU WANT TO SHOW AT RIGHT SIDE IN THE HEADER SECTION-->\r\n                                                    </td>\r\n                                                </tr>\r\n                                            </table>\r\n                                        </td>\r\n                                    </tr>\r\n                                </table>\r\n                            </td>\r\n                        </tr>\r\n                    </table>\r\n                </div>\r\n            </td>\r\n        </tr>\r\n    </table>\r\n\r\n    <!-- MAIN CONTENTS SECTION -->\r\n    <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n        <tr>\r\n            <td bgcolor="#f2f2f2" align="center" style="padding: 40px 15px 40px 15px;" class="section-padding">\r\n                <table border="0" cellpadding="0" cellspacing="0" width="600" class="responsive-table">\r\n                    <tr>\r\n                        <td bgcolor="#ffffff" style="background-color: #ffffff; border-bottom: 2px solid #e2e5e8;">\r\n                            <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                                <tr>\r\n                                    <td bgcolor="#ffffff" style="padding: 35px 25px; background-color: #ffffff;">\r\n                                        <!-- MAIN CONTENTS -->\r\n                                        <table width="100%" border="0" cellspacing="0" cellpadding="0">\r\n                                            <tr>\r\n                                                <td align="left" style="font-size: 14px; line-height: 22px; font-family: Helvetica, Arial, sans-serif; color: #555555;" class="padding-copy">\r\n                                                    <div mc:edit="main_content" style="text-align: left; font-size: 14px; line-height: 22px; font-family: Helvetica, Arial, sans-serif; color: #555555;">\r\n                                                        <!-- JOOMLA CONTENTS GOES HERE -->\r\n                                                        <p>\r\n                                                          {{# JText.sprintf }}COM_USERS_EMAIL_REGISTERED_NOTIFICATION_TO_ADMIN_BODY, {{ name }}, {{ username }}, {{ siteurl_html }}{{/ JText.sprintf }} \r\n                                                        </p>\r\n                                                    </div>\r\n                                                </td>\r\n                                            </tr>\r\n                                        </table>\r\n                                    </td>\r\n                                </tr>\r\n                            </table>\r\n                        </td>\r\n                    </tr>\r\n                </table>\r\n            </td>\r\n        </tr>\r\n    </table>\r\n\r\n    <!-- FOOTER -->\r\n    <table border="0" cellpadding="0" cellspacing="0" width="100%">\r\n        <tr>\r\n            <td bgcolor="#f2f2f2" align="center" style="padding: 10px 0px 20px 0px;">\r\n                <!-- UNSUBSCRIBE COPY -->\r\n                <table width="600" border="0" cellspacing="0" cellpadding="0" align="center" class="responsive-table">\r\n                    <tr>\r\n                        <td align="left" style="font-size: 13px; line-height: 18px; font-family: Helvetica, Arial, sans-serif; color:#aaaaaa;" class="padding">\r\n                            <!--DISCLAIMER-->\r\n                            {{# JText._ }}COM_VPADVANCEDUSER_EMAIL_DISCLAIMER{{/ JText._ }}\r\n                        </td>\r\n                    </tr>\r\n                    <tr>\r\n                        <td align="left" style="font-size: 11px; line-height: 18px; font-family: Helvetica, Arial, sans-serif; color:#aaaaaa; padding-top: 15px;" class="padding">\r\n                            <!--SITE NAME AND OTHER CONTACT DETAILS-->\r\n                            <span class="appleFooter" style="color:#aaaaaa;">{{ sitename }}</span>\r\n                        </td>\r\n                    </tr>\r\n                </table>\r\n            </td>\r\n        </tr>\r\n    </table>\r\n\r\n</body>\r\n</html>', 1, 'admin_notification', 939, '2016-04-26 06:38:32', 939, '2016-04-26 06:39:51');

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

--
-- Table structure for table `#__vpadvanceduser_fields`
--

CREATE TABLE IF NOT EXISTS `#__vpadvanceduser_fields` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `label` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(191) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `type` varchar(255) NOT NULL,
  `show_in_registration` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `show_in_profile` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `access` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `params` text NOT NULL,
  `ordering` int(11) NOT NULL DEFAULT '0',
  `state` tinyint(3) NOT NULL DEFAULT '0',
  `checked_out` int(11) NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `language` char(7) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `#__vpadvanceduser_fields`
--

INSERT IGNORE INTO `#__vpadvanceduser_fields` (`id`, `label`, `name`, `description`, `type`, `show_in_registration`, `show_in_profile`, `access`, `params`, `ordering`, `state`, `checked_out`, `checked_out_time`, `language`) VALUES
(1, 'COM_VPADVANCEDUSER_FIELD_FIRSTNAME', 'firstname', '', 'text', 0, 1, 1, '{\"options\":\"\",\"format\":\"\",\"default\":\"\",\"filter\":\"\",\"size\":\"40\",\"maxlength\":\"255\",\"multiple\":\"0\",\"required\":\"0\",\"readonly\":\"0\",\"disabled\":\"0\",\"autocomplete\":\"1\",\"hint\":\"\",\"class\":\"\",\"onchange\":\"\",\"onclick\":\"\",\"custom_type\":\"\"}', 3, 1, 0, '0000-00-00 00:00:00', '*'),
(2, 'COM_VPADVANCEDUSER_FIELD_LASTNAME', 'lastname', '', 'text', 0, 1, 1, '{\"options\":\"\",\"format\":\"\",\"default\":\"\",\"filter\":\"\",\"size\":\"40\",\"maxlength\":\"\",\"multiple\":\"0\",\"required\":\"0\",\"readonly\":\"0\",\"disabled\":\"0\",\"autocomplete\":\"1\",\"hint\":\"\",\"class\":\"\",\"onchange\":\"\",\"onclick\":\"\",\"custom_type\":\"\"}', 4, 1, 0, '0000-00-00 00:00:00', '*'),
(3, 'COM_VPADVANCEDUSER_FIELD_GENDER', 'gender', '', 'vplist', 0, 1, 1, '{\"options\":\"-,Male,Female\",\"format\":\"\",\"default\":\"0\",\"filter\":\"\",\"size\":\"\",\"maxlength\":\"\",\"multiple\":\"0\",\"required\":\"0\",\"readonly\":\"0\",\"disabled\":\"0\",\"autocomplete\":\"1\",\"hint\":\"\",\"class\":\"\",\"onchange\":\"\",\"onclick\":\"\",\"custom_type\":\"\"}', 5, 1, 0, '0000-00-00 00:00:00', '*'),
(4, 'COM_VPADVANCEDUSER_FIELD_ADDRESS', 'address', '', 'textarea', 0, 1, 1, '{\"options\":\"\",\"format\":\"\",\"default\":\"\",\"filter\":\"\",\"size\":\"\",\"maxlength\":\"1020\",\"multiple\":\"0\",\"required\":\"0\",\"readonly\":\"0\",\"disabled\":\"0\",\"autocomplete\":\"1\",\"hint\":\"\",\"class\":\"\",\"onchange\":\"\",\"onclick\":\"\",\"custom_type\":\"\"}', 6, 1, 0, '0000-00-00 00:00:00', '*'),
(5, 'COM_VPADVANCEDUSER_FIELD_COUNTRY', 'country', '', 'text', 0, 1, 1, '{\"options\":\"\",\"format\":\"\",\"default\":\"\",\"filter\":\"\",\"size\":\"\",\"maxlength\":\"255\",\"multiple\":\"0\",\"required\":\"0\",\"readonly\":\"0\",\"disabled\":\"0\",\"autocomplete\":\"1\",\"hint\":\"\",\"class\":\"\",\"onchange\":\"\",\"onclick\":\"\",\"custom_type\":\"\"}', 7, 1, 0, '0000-00-00 00:00:00', '*'),
(6, 'COM_VPADVANCEDUSER_FIELD_REGION', 'region', '', 'text', 0, 1, 1, '{\"options\":\"\",\"format\":\"\",\"default\":\"\",\"filter\":\"\",\"size\":\"\",\"maxlength\":\"255\",\"multiple\":\"0\",\"required\":\"0\",\"readonly\":\"0\",\"disabled\":\"0\",\"autocomplete\":\"1\",\"hint\":\"\",\"class\":\"\",\"onchange\":\"\",\"onclick\":\"\",\"custom_type\":\"\"}', 8, 1, 0, '0000-00-00 00:00:00', '*'),
(7, 'COM_VPADVANCEDUSER_FIELD_CITY', 'city', '', 'text', 0, 1, 1, '{\"options\":\"\",\"format\":\"\",\"default\":\"\",\"filter\":\"\",\"size\":\"\",\"maxlength\":\"255\",\"multiple\":\"0\",\"required\":\"0\",\"readonly\":\"0\",\"disabled\":\"0\",\"autocomplete\":\"1\",\"hint\":\"\",\"class\":\"\",\"onchange\":\"\",\"onclick\":\"\",\"custom_type\":\"\"}', 9, 1, 0, '0000-00-00 00:00:00', '*'),
(8, 'COM_VPADVANCEDUSER_FIELD_ZIP', 'zip', '', 'text', 0, 1, 1, '{\"options\":\"\",\"format\":\"\",\"default\":\"\",\"filter\":\"\",\"size\":\"\",\"maxlength\":\"122\",\"multiple\":\"0\",\"required\":\"0\",\"readonly\":\"0\",\"disabled\":\"0\",\"autocomplete\":\"1\",\"hint\":\"\",\"class\":\"\",\"onchange\":\"\",\"onclick\":\"\",\"custom_type\":\"\"}', 10, 1, 0, '0000-00-00 00:00:00', '*'),
(9, 'COM_VPADVANCEDUSER_FIELD_DOB', 'dob', '', 'calendar', 0, 1, 1, '{\"options\":\"\",\"format\":\"\",\"default\":\"\",\"filter\":\"\",\"size\":\"\",\"maxlength\":\"\",\"multiple\":\"0\",\"required\":\"0\",\"readonly\":\"0\",\"disabled\":\"0\",\"autocomplete\":\"1\",\"hint\":\"\",\"class\":\"\",\"onchange\":\"\",\"onclick\":\"\",\"custom_type\":\"\"}', 11, 1, 0, '0000-00-00 00:00:00', '*'),
(10, 'COM_VPADVANCEDUSER_FIELD_DESCRIPTION', 'description', '', 'textarea', 0, 1, 1, '{\"options\":\"\",\"format\":\"\",\"default\":\"\",\"filter\":\"\",\"size\":\"\",\"maxlength\":\"\",\"multiple\":\"0\",\"required\":\"0\",\"readonly\":\"0\",\"disabled\":\"0\",\"autocomplete\":\"1\",\"hint\":\"\",\"class\":\"\",\"onchange\":\"\",\"onclick\":\"\",\"custom_type\":\"\"}', 12, 1, 0, '0000-00-00 00:00:00', '*'),
(11, 'COM_VPADVANCEDUSER_FIELD_PROFILE_PCTURE', 'profile_picture', '', 'avatar', 0, 1, 1, '{\"options\":\"\",\"format\":\"\",\"default\":\"\",\"filter\":\"\",\"size\":\"\",\"maxlength\":\"\",\"multiple\":\"0\",\"required\":\"0\",\"readonly\":\"0\",\"disabled\":\"0\",\"autocomplete\":\"1\",\"hint\":\"\",\"class\":\"\",\"onchange\":\"\",\"onclick\":\"\",\"custom_type\":\"\"}', 2, 1, 0, '0000-00-00 00:00:00', '*'),
(12, 'COM_VPADVANCEDUSER_FIELD_PROFILE', 'profile', '', 'legend', 0, 1, 1, '{\"options\":\"\",\"format\":\"\",\"default\":\"\",\"filter\":\"\",\"size\":\"\",\"maxlength\":\"\",\"multiple\":\"0\",\"required\":\"0\",\"readonly\":\"0\",\"disabled\":\"0\",\"autocomplete\":\"1\",\"hint\":\"\",\"class\":\"\",\"onchange\":\"\",\"onclick\":\"\",\"custom_type\":\"\"}', 1, 1, 0, '0000-00-00 00:00:00', '*'),
(13, 'COM_VPADVANCEDUSER_FIELD_SOCIAL_MEDIA', 'social_media', '', 'legend', 0, 1, 1, '{\"options\":\"\",\"format\":\"\",\"default\":\"\",\"filter\":\"\",\"size\":\"\",\"maxlength\":\"\",\"multiple\":\"0\",\"required\":\"0\",\"readonly\":\"0\",\"disabled\":\"0\",\"autocomplete\":\"1\",\"hint\":\"\",\"class\":\"\",\"onchange\":\"\",\"onclick\":\"\",\"custom_type\":\"\"}', 15, 1, 0, '0000-00-00 00:00:00', '*'),
(14, 'COM_VPADVANCEDUSER_FIELD_GOOGLE_PLUS', 'google_plus', '', 'text', 0, 1, 1, '{\"options\":\"\",\"format\":\"\",\"default\":\"\",\"filter\":\"string\",\"size\":\"255\",\"maxlength\":\"\",\"multiple\":\"0\",\"required\":\"0\",\"readonly\":\"0\",\"disabled\":\"0\",\"autocomplete\":\"1\",\"hint\":\"COM_VPADVANCEDUSER_FIELD_GOOGLE_PLUS_HINT\",\"class\":\"\",\"onchange\":\"\",\"onclick\":\"\",\"custom_type\":\"\"}', 16, 1, 0, '0000-00-00 00:00:00', '*'),
(15, 'COM_VPADVANCEDUSER_FIELD_FACEBOOK', 'facebook', '', 'text', 0, 1, 1, '{\"options\":\"\",\"format\":\"\",\"default\":\"\",\"filter\":\"\",\"size\":\"125\",\"maxlength\":\"\",\"multiple\":\"0\",\"required\":\"0\",\"readonly\":\"0\",\"disabled\":\"0\",\"autocomplete\":\"1\",\"hint\":\"COM_VPADVANCEDUSER_FIELD_FACEBOOK_HINT\",\"class\":\"\",\"onchange\":\"\",\"onclick\":\"\",\"custom_type\":\"\"}', 17, 1, 0, '0000-00-00 00:00:00', '*'),
(16, 'COM_VPADVANCEDUSER_FIELD_TWITTER', 'twitter', '', 'text', 0, 1, 1, '{\"options\":\"\",\"format\":\"\",\"default\":\"\",\"filter\":\"\",\"size\":\"125\",\"maxlength\":\"\",\"multiple\":\"0\",\"required\":\"0\",\"readonly\":\"0\",\"disabled\":\"0\",\"autocomplete\":\"1\",\"hint\":\"COM_VPADVANCEDUSER_FIELD_TWITTER_HINT\",\"class\":\"\",\"onchange\":\"\",\"onclick\":\"\",\"custom_type\":\"\"}', 18, 1, 0, '0000-00-00 00:00:00', '*'),
(17, 'COM_VPADVANCEDUSER_FIELD_TOS', 'tos', '', 'vptos', 1, 1, 1, '{\"tos_article\":\"\",\"options\":\"\",\"format\":\"\",\"default\":\"\",\"filter\":\"\",\"size\":\"\",\"maxlength\":\"\",\"multiple\":\"0\",\"required\":\"1\",\"readonly\":\"0\",\"disabled\":\"0\",\"autocomplete\":\"1\",\"hint\":\"\",\"class\":\"\",\"onchange\":\"\",\"onclick\":\"\",\"custom_type\":\"\"}', 13, 1, 0, '0000-00-00 00:00:00', '*'),
(18, 'COM_VPADVANCEDUSER_FIELD_PRIVACY', 'privacy', '', 'vptos', 1, 1, 1, '{\"tos_article\":\"\",\"options\":\"\",\"format\":\"\",\"default\":\"\",\"filter\":\"\",\"size\":\"\",\"maxlength\":\"\",\"multiple\":\"0\",\"required\":\"1\",\"readonly\":\"0\",\"disabled\":\"0\",\"autocomplete\":\"1\",\"hint\":\"\",\"class\":\"\",\"onchange\":\"\",\"onclick\":\"\",\"custom_type\":\"\"}', 14, 1, 0, '0000-00-00 00:00:00', '*');

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

--
-- Table structure for table `#__vpadvanceduser_session_providers`
--

CREATE TABLE IF NOT EXISTS `#__vpadvanceduser_session_providers` (
  `session_id` varchar(191) CHARACTER SET latin1 NOT NULL,
  `provider` varchar(55) CHARACTER SET latin1 NOT NULL,
  `openid_identifier` varchar(255) NOT NULL,
  `provider_entry` text NOT NULL,
  `provider_return` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `#__vpadvanceduser_users`
--

CREATE TABLE IF NOT EXISTS `#__vpadvanceduser_users` (
  `identifier` varchar(255) CHARACTER SET latin1 NOT NULL,
  `provider` varchar(55) CHARACTER SET latin1 NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  UNIQUE KEY `idx_identifier_provider` (`identifier`,`provider`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `#__content_types` (`type_title`, `type_alias`, `table`, `content_history_options`)
SELECT * FROM ( SELECT 'Custom Field','com_vpadvanceduser.customfield','{"special":{"dbtable":"#__vpadvanceduser_fields","key":"id","type":"Custom Field","prefix":"VP Advanced UserTable"}}', '{"formFile":"administrator\/components\/com_vpadvanceduser\/models\/forms\/customfield.xml", "hideFields":["checked_out","checked_out_time","params","language" ,"description"], "ignoreChanges":["modified_by", "modified", "checked_out", "checked_out_time"], "convertToInt":["publish_up", "publish_down"], "displayLookup":[{"sourceColumn":"catid","targetTable":"#__categories","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"group_id","targetTable":"#__usergroups","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"created_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"},{"sourceColumn":"access","targetTable":"#__viewlevels","targetColumn":"id","displayColumn":"title"},{"sourceColumn":"modified_by","targetTable":"#__users","targetColumn":"id","displayColumn":"name"}]}') AS tmp
WHERE NOT EXISTS (
	SELECT type_alias FROM `#__content_types` WHERE (`type_alias` = 'com_vpadvanceduser.customfield')
) LIMIT 1;