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

--
-- Table structure for table `params`
--

DROP TABLE IF EXISTS `params`;
CREATE TABLE IF NOT EXISTS `params` (
  `name` varchar(50) NOT NULL,
  `value` varchar(200) DEFAULT NULL,
  `large_value` text,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- RELATIONS FOR TABLE `params`:
--

--
-- Dumping data for table `params`
--

INSERT INTO `params` (`name`, `value`, `large_value`) VALUES
('authBotAccessToken', 'REMOVED', NULL),
('authBotEmail', 'bot@cenos-platform.com', NULL),
('authBotRefreshToken', 'REMOVED', NULL),
('authClientId', 'REMOVED', NULL),
('authClientSecret', 'REMOVED', NULL),
('authPersonAccessToken', 'REMOVED', NULL),
('authPersonEmail', 'ev@cenos-platform.com', NULL),
('authPersonRefreshToken', 'REMOVED', NULL),
('betaVersion@ALL', '2.5.1-beta.1', NULL),
('betaVersion@ANTENNAS', '1.0.0-beta.5', NULL),
('betaVersion@INDUCTION', '2.5.1-beta.1', NULL),
('betaVersionLink@ALL', 'not-relevant', NULL),
('betaVersionLink@ANTENNAS', 'https://server.cenos-platform.com/download/cenos-antennas-setup', NULL),
('betaVersionLink@INDUCTION', 'no-beta-yet', NULL),
('cenosAppName@ANTENNAS', 'CENOS Antenna Design', NULL),
('cenosAppName@INDUCTION', 'CENOS Induction Heating', NULL),
('docLink@ANTENNAS', 'https://ad.cenos-platform.com', NULL),
('docLink@INDUCTION', 'https://ih.cenos-platform.com', NULL),
('downloadLink@ANTENNAS', 'https://server.cenos-platform.com/download/cenos-antennas-setup', NULL),
('downloadLink@INDUCTION', 'https://server.cenos-platform.com/download/cenos-setup', NULL),
('emailOrderHtml', NULL, '            <html>\n                <head>\n                    <title>CENOS license key</title>\n                </head>\n                \n                <body>\n                    <p>Dear ${company.toUpperCase()},</p>\n                    <p>Thank you for purchasing CENOS simulation software.</p>\n                    <p>Download the software from <a href=\"https://server.cenos-platform.com/download/cenos-antennas-setup\">https://server.cenos-platform.com/download/cenos-antennas-setup</a></p>\n                    \n                    <ul>\n                        <li><b>Here is your license key:</b> ${licenseKey}</li>\n                        <li>Copy the license key and enter it during the installation.</li>\n                    </ul>\n                    \n                    <p>\n                        <b>Please let us know if you have any problems during the installation by replying to this email or reach us\n                         at <a href=\"mailto:support@cenos-platform.com\">support@cenos-platform.com</a>.</b>\n                    </p>\n                    \n                    <p>\n                        Emils Vjaters<br>\n                        Head of Sales<br>\n                        <a href=\"https://www.cenos-platform.com/\">cenos-platform.com</a>\n                    </p>\n                </body>\n            </html>\n'),
('emailOrderText', NULL, 'Dear ${company.toUpperCase()},\n\nThank you for downloading CENOS simulation software.\n\nDownload the software from ${link}\n        \n• Here is your license key: ${licenseKey}\n• Copy the license key and enter it during the installation.\n  \nPlease let us know if you have any problems during the installation by replying to this email or reach us at support@cenos-platform.com.\n \nEmils Vjaters\nHead of Sales\nhttps://www.cenos-platform.com/\n'),
('emailTrialHtml@ANTENNAS', NULL, '<html>\n    <head>\n        <title>CENOS license key</title>\n    </head>\n    \n    <body>\n        <p>Dear {name},</p>\n        <p>Thank you for downloading CENOS Antenna Design simulation software.</p>\n        \n        <ul>\n            <li><b>Here is your license key:</b> {licenseKey}</li>\n            <li>The license is valid for {fixedTrialDays} days from now.</li>\n            <li>Copy the license key and enter it during the installation.</li>\n        </ul>\n        \n        <p>\n            <b>Please let us know if you have any problems during the installation by replying to this email or reach us\n             at <a href=\"mailto:support@cenos-platform.com\">support@cenos-platform.com</a>.</b>\n        </p>\n        \n        <p>\n            Emils Vjaters<br>\n            Head of Sales<br>\n            EU: +371 2200 3845<br>\n            US: +1 708 794 4046<br>\n            <a href=\"https://www.linkedin.com/in/emilsvjaters\">LinkedIn</a><br>\n            <a href=\"https://www.cenos-platform.com/\">cenos-platform.com</a>\n        </p>\n    </body>\n</html>\n'),
('emailTrialHtml@INDUCTION', NULL, '<html>\n    <head>\n        <title>CENOS license key</title>\n    </head>\n    \n    <body>\n        <p>Dear {name},</p>\n        <p>Thank you for downloading CENOS Induction Heating simulation software.</p>\n        \n        <ul>\n            <li>\n                Here is your license key:<span style=\"font-size: 20px; color: #4A86E8; margin-left: 5px; margin-right: 5px; padding-left: 5px; padding-right: 5px\"><b>{licenseKey}</b></span><br>\n                You can use the free trial version for {maxTrialDays} nonconsecutive days – that means you can spend these {maxTrialDays} days whenever and however it\'s convenient for you within a {trialLength}-month period.<br>\n                Copy the license key and enter it during the installation.<br>\n            </li>\n            <li>Visit <a href=\"{docLink}\">Get Started</a> page for basic and advanced tutorials</li>\n            <li>Use <a href=\"mailto:support@cenos-platform.com\">support@cenos-platform.com</a> if you need any help or have any questions (support is available in EN, DE, RU).</li>\n        </ul>\n        \n        <p>\n           We are excited to have you on board!<br> \n           Please let us know if you have any feedback about our product during the trial. \n        </p>\n        \n        <p>\n            Emils Vjaters<br>\n            Head of Sales<br>\n            EU: +371 2200 3845<br>\n            US: +1 708 794 4046<br>\n            <a href=\"https://www.linkedin.com/in/emilsvjaters\">LinkedIn</a><br>\n            <a href=\"https://www.cenos-platform.com/\">cenos-platform.com</a>\n        </p>\n    </body>\n</html>\n'),
('emailTrialText@ANTENNAS', NULL, 'Dear {name},\n\nThank you for downloading CENOS Antenna Design simulation software.\n        \n• Here is your license key: {licenseKey}\n• The license is valid for {fixedTrialDays} days from now.\n• Copy the license key and enter it during the installation.\n  \nPlease let us know if you have any problems during the installation by replying to this email or reach us at support@cenos-platform.com.\n \nEmils Vjaters\nHead of Sales\nEU: +371 2200 3845\nUS: +1 708 794 4046\nLinkedIn: www.linkedin.com/in/emilsvjaters\nhttps://www.cenos-platform.com/\n'),
('emailTrialText@INDUCTION', NULL, 'Dear {name},\n\nThank you for downloading CENOS Induction Heating simulation software.\n        \n• Here is your license key: {licenseKey}\n  You can use the free trial version for {maxTrialDays} nonconsecutive days – that means you can spend these {maxTrialDays} days whenever and however it\'s convenient for you within a {trialLength}-month period.\n  Copy the license key and enter it during the installation.\n  \n• Visit Get Started page for basic and advanced tutorials: {docLink}\n• Use support@cenos-platform.com if you need any help or have any questions (support is available in EN, DE, RU).\n\nWe are excited to have you on board! \nPlease let us know if you have any feedback about our product during the trial.\n\nEmils Vjaters\nHead of Sales\nEU: +371 2200 3845\nUS: +1 708 794 4046\nLinkedIn: www.linkedin.com/in/emilsvjaters\nhttps://www.cenos-platform.com/\n'),
('fixedTrialDays', '10', NULL),
('latestVersion@ALL', '2.7.1', NULL),
('latestVersion@ANTENNAS', '1.1.5', NULL),
('latestVersion@INDUCTION', '3.1.0', NULL),
('latestVersionLink', 'https://server.cenos-platform.com/download/cenos-setup', NULL),
('latestVersionLink@ALL', 'not-relevant', NULL),
('latestVersionLink@ANTENNAS', 'https://server.cenos-platform.com/download/cenos-antennas-setup', NULL),
('latestVersionLink@INDUCTION', 'https://server.cenos-platform.com/download/cenos-setup', NULL),
('maxTrialDays', '10', NULL),
('trialLength', '1', NULL);
