コード例 #1
0
ファイル: crm.php プロジェクト: nahakiole/cloudrexx
function _crmInstall()
{
    try {
        $result = \Cx\Lib\UpdateUtil::sql('SELECT `id` FROM `' . DBPREFIX . 'core_text` WHERE `section` = \'crm\'');
        if (!$result || $result->RecordCount() == 0) {
            // add core mail template table because it is possible it doesn't yet exist
            \Cx\Lib\UpdateUtil::table(DBPREFIX . 'core_mail_template', array('key' => array('type' => 'tinytext'), 'section' => array('type' => 'tinytext', 'after' => 'key'), 'text_id' => array('type' => 'INT(10)', 'unsigned' => true, 'after' => 'section'), 'html' => array('type' => 'TINYINT(1)', 'unsigned' => true, 'notnull' => true, 'default' => '0', 'after' => 'text_id'), 'protected' => array('type' => 'TINYINT(1)', 'unsigned' => true, 'notnull' => true, 'default' => '0', 'after' => 'html')), null, 'MyISAM', 'cx3upgrade');
            Cx\Lib\UpdateUtil::sql("\n                ALTER TABLE `" . DBPREFIX . "core_mail_template`\n                ADD PRIMARY KEY (`key` (32), `section` (32))\n            ");
            // migrate mail templates
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(12, 1, \'crm\', \'core_mail_template_bcc\', \'\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(12, 1, \'crm\', \'core_mail_template_cc\', \'\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(12, 1, \'crm\', \'core_mail_template_from\', \'info@example.com\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(12, 1, \'crm\', \'core_mail_template_message\', \'Guten Tag,\\r\\n\\r\\nNachfolgend erhalten Sie Ihre persönlichen Zugangsdaten zur Website http://www.example.com/\\r\\n\\r\\nBenutzername: [CRM_CONTACT_USERNAME]\\r\\nKennwort: [CRM_CONTACT_PASSWORD]\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(12, 1, \'crm\', \'core_mail_template_message_html\', \'<div>Guten Tag,<br />\\r\\n<br />\\r\\nNachfolgend erhalten Sie Ihre pers&ouml;nlichen Zugangsdaten zur Website <a href="http://www.example.com/">http://www.example.com/</a><br />\\r\\n<br />\\r\\nBenutzername: [CRM_CONTACT_USERNAME]<br />\\r\\nKennwort: [CRM_CONTACT_PASSWORD]</div>\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(12, 1, \'crm\', \'core_mail_template_name\', \'Benachrichtigung über Benutzerkonto\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(12, 1, \'crm\', \'core_mail_template_reply\', \'info@example.com\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(12, 1, \'crm\', \'core_mail_template_sender\', \'Ihr Firmenname\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(12, 1, \'crm\', \'core_mail_template_subject\', \'Ihr persönlischer Zugang\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(12, 1, \'crm\', \'core_mail_template_to\', \'[CRM_CONTACT_EMAIL]\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(13, 1, \'crm\', \'core_mail_template_bcc\', \'\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(13, 1, \'crm\', \'core_mail_template_cc\', \'\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(13, 1, \'crm\', \'core_mail_template_from\', \'info@example.com\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(13, 1, \'crm\', \'core_mail_template_message\', \'Der Mitarbeiter [CRM_TASK_CREATED_USER] hat eine neue Aufgabe erstellt und Ihnen zugewiesen: [CRM_TASK_URL]\\r\\n\\r\\nBeschreibung: [CRM_TASK_DESCRIPTION_TEXT_VERSION]\\r\\n\\r\\nFällig am: [CRM_TASK_DUE_DATE]\\r\\n\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(13, 1, \'crm\', \'core_mail_template_message_html\', \'<div style="padding:0px; margin:0px; font-family:Tahoma, sans-serif; font-size:14px; width:620px; color: #333;">\\r\\n<div style="padding: 0px 20px; border:1px solid #e0e0e0; margin-bottom: 10px; width:618px;">\\r\\n<h1 style="background-color: #e0e0e0;color: #3d4a6b;font-size: 18px;font-weight: normal;padding: 15px 20px;margin-top: 0 !important;margin-bottom: 0 !important;margin-left: -20px !important;margin-right: -20px !important;-webkit-margin-before: 0 !important;-webkit-margin-after: 0 !important;-webkit-margin-start: -20px !important;-webkit-margin-end: -20px !important;">Neue Aufgabe wurde Ihnen zugewiesen</h1>\\r\\n\\r\\n<p style="margin-top: 20px;word-wrap: break-word !important;">Der Mitarbeiter [CRM_TASK_CREATED_USER] hat eine neue Aufgabe erstellt und Ihnen zugewiesen: [CRM_TASK_LINK]</p>\\r\\n\\r\\n<p style="margin-top: 20px;word-wrap: break-word !important;">Beschreibung: [CRM_TASK_DESCRIPTION_HTML_VERSION]<br />\\r\\nF&auml;llig am: [CRM_TASK_DUE_DATE]</p>\\r\\n</div>\\r\\n</div>\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(13, 1, \'crm\', \'core_mail_template_name\', \'Neue Aufgabe\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(13, 1, \'crm\', \'core_mail_template_reply\', \'info@example.com\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(13, 1, \'crm\', \'core_mail_template_sender\', \'Ihr Firmenname\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(13, 1, \'crm\', \'core_mail_template_subject\', \'Neue Aufgabe : [CRM_TASK_NAME]\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(13, 1, \'crm\', \'core_mail_template_to\', \'[CRM_ASSIGNED_USER_EMAIL]\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(14, 1, \'crm\', \'core_mail_template_bcc\', \'\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(14, 1, \'crm\', \'core_mail_template_cc\', \'\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(14, 1, \'crm\', \'core_mail_template_from\', \'info@example.com\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(14, 1, \'crm\', \'core_mail_template_message\', \'Im CRM wurde ein neuer Kontakt erfasst: [CRM_CONTACT_DETAILS_URL]\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(14, 1, \'crm\', \'core_mail_template_message_html\', \'<div style="padding:0px; margin:0px; font-family:Tahoma, sans-serif; font-size:14px; width:620px; color: #333;">\\r\\n<div style="padding: 0px 20px; border:1px solid #e0e0e0; margin-bottom: 10px; width:618px;">\\r\\n<h1 style="background-color: #e0e0e0;color: #3d4a6b;font-size: 18px;font-weight: normal;padding: 15px 20px;margin-top: 0 !important;margin-bottom: 0 !important;margin-left: -20px !important;margin-right: -20px !important;-webkit-margin-before: 0 !important;-webkit-margin-after: 0 !important;-webkit-margin-start: -20px !important;-webkit-margin-end: -20px !important;">Neuer Kontakt im CRM</h1>\\r\\n\\r\\n<p style="margin-top: 20px;word-wrap: break-word !important;">Neuer Kontakt: [CRM_CONTACT_DETAILS_LINK].</p>\\r\\n</div>\\r\\n</div>\\r\\n\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(14, 1, \'crm\', \'core_mail_template_name\', \'Benachrichtigung an Mitarbeiter über neue Kontakte\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(14, 1, \'crm\', \'core_mail_template_reply\', \'info@example.com\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(14, 1, \'crm\', \'core_mail_template_sender\', \'Ihr Firmenname\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(14, 1, \'crm\', \'core_mail_template_subject\', \'Neuer Kontakt erfasst\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_text` (`id`, `lang_id`, `section`, `key`, `text`) VALUES(14, 1, \'crm\', \'core_mail_template_to\', \'[CRM_ASSIGNED_USER_EMAIL]\')');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_mail_template` (`key`, `section`, `text_id`, `html`, `protected`) VALUES(\'crm_user_account_created\', \'crm\', 12, 1, 1)');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_mail_template` (`key`, `section`, `text_id`, `html`, `protected`) VALUES(\'crm_notify_staff_on_contact_added\', \'crm\', 14, 1, 1)');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_mail_template` (`key`, `section`, `text_id`, `html`, `protected`) VALUES(\'crm_task_assigned\', \'crm\', 13, 1, 1)');
            \Cx\Lib\UpdateUtil::sql('INSERT IGNORE INTO `' . DBPREFIX . 'core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`) VALUES (\'crm\',\'numof_mailtemplate_per_page_backend\',\'config\',\'text\',\'25\',\'\',1001)');
        }
    } catch (\Cx\Lib\UpdateException $e) {
        return \Cx\Lib\UpdateUtil::DefaultActionHandler($e);
    }
}
コード例 #2
0
ファイル: shop.php プロジェクト: Cloudrexx/cloudrexx
function _shopInstall()
{
    try {
        \Cx\Lib\UpdateUtil::table(DBPREFIX . 'core_country', array('id' => array('type' => 'INT(10)', 'unsigned' => true, 'notnull' => true, 'auto_increment' => true, 'primary' => true), 'alpha2' => array('type' => 'CHAR(2)', 'notnull' => true, 'default' => '', 'after' => 'id'), 'alpha3' => array('type' => 'CHAR(3)', 'notnull' => true, 'default' => '', 'after' => 'alpha2'), 'ord' => array('type' => 'INT(5)', 'unsigned' => true, 'notnull' => true, 'default' => '0', 'after' => 'alpha3'), 'active' => array('type' => 'TINYINT(1)', 'unsigned' => true, 'notnull' => true, 'default' => '1', 'after' => 'ord')), null, 'MyISAM', 'cx3upgrade');
        \Cx\Lib\UpdateUtil::sql("\n            INSERT INTO `" . DBPREFIX . "core_country` (`id`, `alpha2`, `alpha3`, `ord`, `active`)\n            VALUES  (1, 'AF', 'AFG', 0, 0),\n                    (2, 'AL', 'ALB', 0, 0),\n                    (3, 'DZ', 'DZA', 0, 0),\n                    (4, 'AS', 'ASM', 0, 0),\n                    (5, 'AD', 'AND', 0, 0),\n                    (6, 'AO', 'AGO', 0, 0),\n                    (7, 'AI', 'AIA', 0, 0),\n                    (8, 'AQ', 'ATA', 0, 0),\n                    (9, 'AG', 'ATG', 0, 0),\n                    (10, 'AR', 'ARG', 0, 0),\n                    (11, 'AM', 'ARM', 0, 0),\n                    (12, 'AW', 'ABW', 0, 0),\n                    (13, 'AU', 'AUS', 0, 0),\n                    (14, 'AT', 'AUT', 0, 1),\n                    (15, 'AZ', 'AZE', 0, 0),\n                    (16, 'BS', 'BHS', 0, 0),\n                    (17, 'BH', 'BHR', 0, 0),\n                    (18, 'BD', 'BGD', 0, 0),\n                    (19, 'BB', 'BRB', 0, 0),\n                    (20, 'BY', 'BLR', 0, 0),\n                    (21, 'BE', 'BEL', 0, 0),\n                    (22, 'BZ', 'BLZ', 0, 0),\n                    (23, 'BJ', 'BEN', 0, 0),\n                    (24, 'BM', 'BMU', 0, 0),\n                    (25, 'BT', 'BTN', 0, 0),\n                    (26, 'BO', 'BOL', 0, 0),\n                    (27, 'BA', 'BIH', 0, 0),\n                    (28, 'BW', 'BWA', 0, 0),\n                    (29, 'BV', 'BVT', 0, 0),\n                    (30, 'BR', 'BRA', 0, 0),\n                    (31, 'IO', 'IOT', 0, 0),\n                    (32, 'BN', 'BRN', 0, 0),\n                    (33, 'BG', 'BGR', 0, 0),\n                    (34, 'BF', 'BFA', 0, 0),\n                    (35, 'BI', 'BDI', 0, 0),\n                    (36, 'KH', 'KHM', 0, 0),\n                    (37, 'CM', 'CMR', 0, 0),\n                    (38, 'CA', 'CAN', 0, 0),\n                    (39, 'CV', 'CPV', 0, 0),\n                    (40, 'KY', 'CYM', 0, 0),\n                    (41, 'CF', 'CAF', 0, 0),\n                    (42, 'TD', 'TCD', 0, 0),\n                    (43, 'CL', 'CHL', 0, 0),\n                    (44, 'CN', 'CHN', 0, 0),\n                    (45, 'CX', 'CXR', 0, 0),\n                    (46, 'CC', 'CCK', 0, 0),\n                    (47, 'CO', 'COL', 0, 0),\n                    (48, 'KM', 'COM', 0, 0),\n                    (49, 'CG', 'COG', 0, 0),\n                    (50, 'CK', 'C*K', 0, 0),\n                    (51, 'CR', 'CRI', 0, 0),\n                    (52, 'CI', 'CIV', 0, 0),\n                    (53, 'HR', 'HRV', 0, 0),\n                    (54, 'CU', 'CUB', 0, 0),\n                    (55, 'CY', 'CYP', 0, 0),\n                    (56, 'CZ', 'CZE', 0, 0),\n                    (57, 'DK', 'DNK', 0, 0),\n                    (58, 'DJ', 'DJI', 0, 0),\n                    (59, 'DM', 'DMA', 0, 0),\n                    (60, 'DO', 'DOM', 0, 0),\n                    (61, 'TP', 'TMP', 0, 0),\n                    (62, 'EC', 'ECU', 0, 0),\n                    (63, 'EG', 'EGY', 0, 0),\n                    (64, 'SV', 'SLV', 0, 0),\n                    (65, 'GQ', 'GNQ', 0, 0),\n                    (66, 'ER', 'ERI', 0, 0),\n                    (67, 'EE', 'EST', 0, 0),\n                    (68, 'ET', 'ETH', 0, 0),\n                    (69, 'FK', 'FLK', 0, 0),\n                    (70, 'FO', 'FRO', 0, 0),\n                    (71, 'FJ', 'FJI', 0, 0),\n                    (72, 'FI', 'FIN', 0, 0),\n                    (73, 'FR', 'FRA', 0, 0),\n                    (74, 'FX', 'FXX', 0, 0),\n                    (75, 'GF', 'GUF', 0, 0),\n                    (76, 'PF', 'PYF', 0, 0),\n                    (77, 'TF', 'ATF', 0, 0),\n                    (78, 'GA', 'GAB', 0, 0),\n                    (79, 'GM', 'GMB', 0, 0),\n                    (80, 'GE', 'GEO', 0, 0),\n                    (81, 'DE', 'DEU', 0, 1),\n                    (82, 'GH', 'GHA', 0, 0),\n                    (83, 'GI', 'GIB', 0, 0),\n                    (84, 'GR', 'GRC', 0, 0),\n                    (85, 'GL', 'GRL', 0, 0),\n                    (86, 'GD', 'GRD', 0, 0),\n                    (87, 'GP', 'GLP', 0, 0),\n                    (88, 'GU', 'GUM', 0, 0),\n                    (89, 'GT', 'GTM', 0, 0),\n                    (90, 'GN', 'GIN', 0, 0),\n                    (91, 'GW', 'GNB', 0, 0),\n                    (92, 'GY', 'GUY', 0, 0),\n                    (93, 'HT', 'HTI', 0, 0),\n                    (94, 'HM', 'HMD', 0, 0),\n                    (95, 'HN', 'HND', 0, 0),\n                    (96, 'HK', 'HKG', 0, 0),\n                    (97, 'HU', 'HUN', 0, 0),\n                    (98, 'IS', 'ISL', 0, 0),\n                    (99, 'IN', 'IND', 0, 0),\n                    (100, 'ID', 'IDN', 0, 0),\n                    (101, 'IR', 'IRN', 0, 0),\n                    (102, 'IQ', 'IRQ', 0, 0),\n                    (103, 'IE', 'IRL', 0, 0),\n                    (104, 'IL', 'ISR', 0, 0),\n                    (105, 'IT', 'ITA', 0, 0),\n                    (106, 'JM', 'JAM', 0, 0),\n                    (107, 'JP', 'JPN', 0, 0),\n                    (108, 'JO', 'JOR', 0, 0),\n                    (109, 'KZ', 'KAZ', 0, 0),\n                    (110, 'KE', 'KEN', 0, 0),\n                    (111, 'KI', 'KIR', 0, 0),\n                    (112, 'KP', 'PRK', 0, 0),\n                    (113, 'KR', 'KOR', 0, 0),\n                    (114, 'KW', 'KWT', 0, 0),\n                    (115, 'KG', 'KGZ', 0, 0),\n                    (116, 'LA', 'LAO', 0, 0),\n                    (117, 'LV', 'LVA', 0, 0),\n                    (118, 'LB', 'LBN', 0, 0),\n                    (119, 'LS', 'LSO', 0, 0),\n                    (120, 'LR', 'LBR', 0, 0),\n                    (121, 'LY', 'LBY', 0, 0),\n                    (122, 'LI', 'LIE', 0, 1),\n                    (123, 'LT', 'LTU', 0, 0),\n                    (124, 'LU', 'LUX', 0, 0),\n                    (125, 'MO', 'MAC', 0, 0),\n                    (126, 'MK', 'MKD', 0, 0),\n                    (127, 'MG', 'MDG', 0, 0),\n                    (128, 'MW', 'MWI', 0, 0),\n                    (129, 'MY', 'MYS', 0, 0),\n                    (130, 'MV', 'MDV', 0, 0),\n                    (131, 'ML', 'MLI', 0, 0),\n                    (132, 'MT', 'MLT', 0, 0),\n                    (133, 'MH', 'MHL', 0, 0),\n                    (134, 'MQ', 'MTQ', 0, 0),\n                    (135, 'MR', 'MRT', 0, 0),\n                    (136, 'MU', 'MUS', 0, 0),\n                    (137, 'YT', 'MYT', 0, 0),\n                    (138, 'MX', 'MEX', 0, 0),\n                    (139, 'FM', 'FSM', 0, 0),\n                    (140, 'MD', 'MDA', 0, 0),\n                    (141, 'MC', 'MCO', 0, 0),\n                    (142, 'MN', 'MNG', 0, 0),\n                    (143, 'MS', 'MSR', 0, 0),\n                    (144, 'MA', 'MAR', 0, 0),\n                    (145, 'MZ', 'MOZ', 0, 0),\n                    (146, 'MM', 'MMR', 0, 0),\n                    (147, 'NA', 'NAM', 0, 0),\n                    (148, 'NR', 'NRU', 0, 0),\n                    (149, 'NP', 'NPL', 0, 0),\n                    (150, 'NL', 'NLD', 0, 0),\n                    (151, 'AN', 'ANT', 0, 0),\n                    (152, 'NC', 'NCL', 0, 0),\n                    (153, 'NZ', 'NZL', 0, 0),\n                    (154, 'NI', 'NIC', 0, 0),\n                    (155, 'NE', 'NER', 0, 0),\n                    (156, 'NG', 'NGA', 0, 0),\n                    (157, 'NU', 'NIU', 0, 0),\n                    (158, 'NF', 'NFK', 0, 0),\n                    (159, 'MP', 'MNP', 0, 0),\n                    (160, 'NO', 'NOR', 0, 0),\n                    (161, 'OM', 'OMN', 0, 0),\n                    (162, 'PK', 'PAK', 0, 0),\n                    (163, 'PW', 'PLW', 0, 0),\n                    (164, 'PA', 'PAN', 0, 0),\n                    (165, 'PG', 'PNG', 0, 0),\n                    (166, 'PY', 'PRY', 0, 0),\n                    (167, 'PE', 'PER', 0, 0),\n                    (168, 'PH', 'PHL', 0, 0),\n                    (169, 'PN', 'PCN', 0, 0),\n                    (170, 'PL', 'POL', 0, 0),\n                    (171, 'PT', 'PRT', 0, 0),\n                    (172, 'PR', 'PRI', 0, 0),\n                    (173, 'QA', 'QAT', 0, 0),\n                    (174, 'RE', 'REU', 0, 0),\n                    (175, 'RO', 'ROM', 0, 0),\n                    (176, 'RU', 'RUS', 0, 0),\n                    (177, 'RW', 'RWA', 0, 0),\n                    (178, 'KN', 'KNA', 0, 0),\n                    (179, 'LC', 'LCA', 0, 0),\n                    (180, 'VC', 'VCT', 0, 0),\n                    (181, 'WS', 'WSM', 0, 0),\n                    (182, 'SM', 'SMR', 0, 0),\n                    (183, 'ST', 'STP', 0, 0),\n                    (184, 'SA', 'SAU', 0, 0),\n                    (185, 'SN', 'SEN', 0, 0),\n                    (186, 'SC', 'SYC', 0, 0),\n                    (187, 'SL', 'SLE', 0, 0),\n                    (188, 'SG', 'SGP', 0, 0),\n                    (189, 'SK', 'SVK', 0, 0),\n                    (190, 'SI', 'SVN', 0, 0),\n                    (191, 'SB', 'SLB', 0, 0),\n                    (192, 'SO', 'SOM', 0, 0),\n                    (193, 'ZA', 'ZAF', 0, 0),\n                    (194, 'GS', 'SGS', 0, 0),\n                    (195, 'ES', 'ESP', 0, 0),\n                    (196, 'LK', 'LKA', 0, 0),\n                    (197, 'SH', 'SHN', 0, 0),\n                    (198, 'PM', 'SPM', 0, 0),\n                    (199, 'SD', 'SDN', 0, 0),\n                    (200, 'SR', 'SUR', 0, 0),\n                    (201, 'SJ', 'SJM', 0, 0),\n                    (202, 'SZ', 'SWZ', 0, 0),\n                    (203, 'SE', 'SWE', 0, 0),\n                    (204, 'CH', 'CHE', 0, 1),\n                    (205, 'SY', 'SYR', 0, 0),\n                    (206, 'TW', 'TWN', 0, 0),\n                    (207, 'TJ', 'TJK', 0, 0),\n                    (208, 'TZ', 'TZA', 0, 0),\n                    (209, 'TH', 'THA', 0, 0),\n                    (210, 'TG', 'TGO', 0, 0),\n                    (211, 'TK', 'TKL', 0, 0),\n                    (212, 'TO', 'TON', 0, 0),\n                    (213, 'TT', 'TTO', 0, 0),\n                    (214, 'TN', 'TUN', 0, 0),\n                    (215, 'TR', 'TUR', 0, 0),\n                    (216, 'TM', 'TKM', 0, 0),\n                    (217, 'TC', 'TCA', 0, 0),\n                    (218, 'TV', 'TUV', 0, 0),\n                    (219, 'UG', 'UGA', 0, 0),\n                    (220, 'UA', 'UKR', 0, 0),\n                    (221, 'AE', 'ARE', 0, 0),\n                    (222, 'GB', 'GBR', 0, 0),\n                    (223, 'US', 'USA', 0, 0),\n                    (224, 'UM', 'UMI', 0, 0),\n                    (225, 'UY', 'URY', 0, 0),\n                    (226, 'UZ', 'UZB', 0, 0),\n                    (227, 'VU', 'VUT', 0, 0),\n                    (228, 'VA', 'VAT', 0, 0),\n                    (229, 'VE', 'VEN', 0, 0),\n                    (230, 'VN', 'VNM', 0, 0),\n                    (231, 'VG', 'VGB', 0, 0),\n                    (232, 'VI', 'VIR', 0, 0),\n                    (233, 'WF', 'WLF', 0, 0),\n                    (234, 'EH', 'ESH', 0, 0),\n                    (235, 'YE', 'YEM', 0, 0),\n                    (236, 'YU', 'YUG', 0, 0),\n                    (237, 'ZR', 'ZAR', 0, 0),\n                    (238, 'ZM', 'ZMB', 0, 0),\n                    (239, 'ZW', 'ZWE', 0, 0)\n            ON DUPLICATE KEY UPDATE `id` = `id`\n        ");
        \Cx\Lib\UpdateUtil::table(DBPREFIX . 'core_mail_template', array('key' => array('type' => 'tinytext'), 'section' => array('type' => 'tinytext', 'after' => 'key'), 'text_id' => array('type' => 'INT(10)', 'unsigned' => true, 'after' => 'section'), 'html' => array('type' => 'TINYINT(1)', 'unsigned' => true, 'notnull' => true, 'default' => '0', 'after' => 'text_id'), 'protected' => array('type' => 'TINYINT(1)', 'unsigned' => true, 'notnull' => true, 'default' => '0', 'after' => 'html')), null, 'MyISAM', 'cx3upgrade');
        Cx\Lib\UpdateUtil::sql("\n            ALTER TABLE `" . DBPREFIX . "core_mail_template`\n            ADD PRIMARY KEY (`key` (32), `section` (32))\n        ");
        \Cx\Lib\UpdateUtil::sql("\n            INSERT INTO `" . DBPREFIX . "core_mail_template` (`key`, `section`, `text_id`, `html`, `protected`)\n            VALUES  ('customer_login', 'shop', 1, 1, 1),\n                    ('order_complete', 'shop', 2, 1, 1),\n                    ('order_confirmation', 'shop', 3, 1, 1)\n            ON DUPLICATE KEY UPDATE `key` = `key`\n        ");
        \Cx\Lib\UpdateUtil::table(DBPREFIX . 'core_setting', array('section' => array('type' => 'VARCHAR(32)', 'default' => '', 'primary' => true), 'name' => array('type' => 'VARCHAR(255)', 'default' => '', 'primary' => true), 'group' => array('type' => 'VARCHAR(32)', 'default' => '', 'primary' => true), 'type' => array('type' => 'VARCHAR(32)', 'notnull' => true, 'default' => 'text', 'after' => 'group'), 'value' => array('type' => 'text', 'notnull' => true, 'after' => 'type'), 'values' => array('type' => 'text', 'notnull' => true, 'after' => 'value'), 'ord' => array('type' => 'INT(10)', 'unsigned' => true, 'notnull' => true, 'default' => '0', 'after' => 'values')), null, 'MyISAM', 'cx3upgrade');
        \Cx\Lib\UpdateUtil::sql("\n            INSERT INTO `" . DBPREFIX . "core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`)\n            VALUES  ('core', 'numof_countries_per_page_backend', 'country', 'text', '30', '', 101),\n                    ('shop', 'address', 'config', 'text', 'MaxMuster AG\r\nFirmenstrasse 1\r\n4321 Irgendwo', '', 20),\n                    ('shop', 'company', 'config', 'text', 'MaxMuster AG', '', 19),\n                    ('shop', 'country_id', 'config', 'text', '204', '', 13),\n                    ('shop', 'datatrans_active', 'config', 'text', '1', '', 29),\n                    ('shop', 'datatrans_merchant_id', 'config', 'text', '123456789', '', 28),\n                    ('shop', 'datatrans_request_type', 'config', 'text', 'CAA', '', 30),\n                    ('shop', 'datatrans_use_testserver', 'config', 'text', '1', '', 31),\n                    ('shop', 'email', 'config', 'text', '*****@*****.**', '', 1),\n                    ('shop', 'email_confirmation', 'config', 'text', '*****@*****.**', '', 5),\n                    ('shop', 'fax', 'config', 'text', '012 3456790', '', 7),\n                    ('shop', 'numof_coupon_per_page_backend', 'config', 'text', '25', '', 58),\n                    ('shop', 'numof_customers_per_page_backend', 'config', 'text', '25', '', 55),\n                    ('shop', 'numof_mailtemplate_per_page_backend', 'config', 'text', '25', '', 57),\n                    ('shop', 'numof_manufacturers_per_page_backend', 'config', 'text', '25', '', 56),\n                    ('shop', 'numof_orders_per_page_backend', 'config', 'text', '25', '', 54),\n                    ('shop', 'numof_products_per_page_backend', 'config', 'text', '25', '', 216),\n                    ('shop', 'numof_products_per_page_frontend', 'config', 'text', '25', '', 53),\n                    ('shop', 'orderitems_amount_max', 'config', 'text', '0', '', 45),\n                    ('shop', 'payment_lsv_active', 'config', 'text', '1', '', 18),\n                    ('shop', 'paypal_account_email', 'config', 'text', '*****@*****.**', '', 9),\n                    ('shop', 'paypal_active', 'config', 'text', '1', '', 10),\n                    ('shop', 'paypal_default_currency', 'config', 'text', 'EUR', '', 17),\n                    ('shop', 'postfinance_accepted_payment_methods', 'config', 'text', '', '', 25),\n                    ('shop', 'postfinance_active', 'config', 'text', '1', '', 12),\n                    ('shop', 'postfinance_authorization_type', 'config', 'text', 'SAL', '', 8),\n                    ('shop', 'postfinance_hash_signature_in', 'config', 'text', 'sech10zeichenminimum', '', 47),\n                    ('shop', 'postfinance_hash_signature_out', 'config', 'text', 'sech10zeichenminimum', '', 48),\n                    ('shop', 'postfinance_mobile_ijustwanttotest', 'config', 'text', '1', '', 51),\n                    ('shop', 'postfinance_mobile_sign', 'config', 'text', 'geheime_signatur', '', 50),\n                    ('shop', 'postfinance_mobile_status', 'config', 'text', '0', '', 52),\n                    ('shop', 'postfinance_mobile_webuser', 'config', 'text', 'Benutzername', '', 49),\n                    ('shop', 'postfinance_shop_id', 'config', 'text', 'demoShop', '', 11),\n                    ('shop', 'postfinance_use_testserver', 'config', 'text', '1', '', 26),\n                    ('shop', 'product_sorting', 'config', 'text', '1', '', 27),\n                    ('shop', 'register', 'config', 'dropdown', 'optional', '0:mandatory,1:optional,2:none', 46),\n                    ('shop', 'saferpay_active', 'config', 'text', '1', '', 3),\n                    ('shop', 'saferpay_finalize_payment', 'config', 'text', '1', '', 15),\n                    ('shop', 'saferpay_id', 'config', 'text', '12345-12345678', '', 2),\n                    ('shop', 'saferpay_use_test_account', 'config', 'text', '1', '', 14),\n                    ('shop', 'saferpay_window_option', 'config', 'text', '2', '', 16),\n                    ('shop', 'show_products_default', 'config', 'text', '1', '', 32),\n                    ('shop', 'telephone', 'config', 'text', '012 3456789', '', 6),\n                    ('shop', 'thumbnail_max_height', 'config', 'text', '999', '', 22),\n                    ('shop', 'thumbnail_max_width', 'config', 'text', '180', '', 21),\n                    ('shop', 'thumbnail_quality', 'config', 'text', '95', '', 23),\n                    ('shop', 'user_profile_attribute_customer_group_id', 'config', 'dropdown_user_custom_attribute', '2', '', 351),\n                    ('shop', 'user_profile_attribute_notes', 'config', 'dropdown_user_custom_attribute', '1', '', 352),\n                    ('shop', 'usergroup_id_customer', 'config', 'dropdown_usergroup', '6', '', 341),\n                    ('shop', 'usergroup_id_reseller', 'config', 'dropdown_usergroup', '7', '', 342),\n                    ('shop', 'vat_default_id', 'config', 'text', '1', '', 41),\n                    ('shop', 'vat_enabled_foreign_customer', 'config', 'text', '0', '', 33),\n                    ('shop', 'vat_enabled_foreign_reseller', 'config', 'text', '0', '', 34),\n                    ('shop', 'vat_enabled_home_customer', 'config', 'text', '1', '', 35),\n                    ('shop', 'vat_enabled_home_reseller', 'config', 'text', '1', '', 36),\n                    ('shop', 'vat_included_foreign_customer', 'config', 'text', '0', '', 37),\n                    ('shop', 'vat_included_foreign_reseller', 'config', 'text', '0', '', 38),\n                    ('shop', 'vat_included_home_customer', 'config', 'text', '1', '', 39),\n                    ('shop', 'vat_included_home_reseller', 'config', 'text', '1', '', 40),\n                    ('shop', 'vat_other_id', 'config', 'text', '1', '', 42),\n                    ('shop', 'weight_enable', 'config', 'text', '0', '', 24),\n                    ('egov', 'postfinance_shop_id', 'config', 'text', 'Ihr Kontoname', '', 1),\n                    ('egov', 'postfinance_active', 'config', 'checkbox', '0', '1', 2),\n                    ('egov', 'postfinance_authorization_type', 'config', 'dropdown', 'SAL', 'RES:Reservation,SAL:Verkauf', 3),\n                    ('egov', 'postfinance_hash_signature_in', 'config', 'text', 'Mindestens 16 Buchstaben, Ziffern und Zeichen', '', 5),\n                    ('egov', 'postfinance_hash_signature_out', 'config', 'text', 'Mindestens 16 Buchstaben, Ziffern und Zeichen', '', 6),\n                    ('egov', 'postfinance_use_testserver', 'config', 'checkbox', '1', '1', 7),\n                    ('shop', 'use_js_cart', 'config', 'checkbox', '0', '1', 47),\n                    ('shop', 'shopnavbar_on_all_pages', 'config', 'checkbox', '1', '1', 48),\n                    ('filesharing', 'permission', 'config', 'text', 'off', '', 0),\n                    ('shop','payment_lsv_active','config','text','1','','18'),\n                    ('shop','paymill_active','config','text','1','',3),\n                    ('shop','paymill_live_private_key','config','text','','',0),\n                    ('shop','paymill_live_public_key','config','text','','',0),\n                    ('shop','paymill_live_public_key','config','text','','',0),\n                    ('shop','paymill_test_private_key','config','text','','',2),\n                    ('shop','paymill_test_public_key','config','text','','',16),\n                    ('shop','paymill_use_test_account','config','text','0','',15)\n            ON DUPLICATE KEY UPDATE `section` = `section`\n        ");
        \Cx\Lib\UpdateUtil::table(DBPREFIX . 'core_text', array('id' => array('type' => 'INT(10)', 'unsigned' => true, 'notnull' => true, 'default' => '0', 'primary' => true), 'lang_id' => array('type' => 'INT(10)', 'unsigned' => true, 'notnull' => true, 'default' => '1', 'primary' => true, 'after' => 'id'), 'section' => array('type' => 'VARCHAR(32)', 'notnull' => true, 'default' => '', 'primary' => true, 'after' => 'lang_id'), 'key' => array('type' => 'VARCHAR(255)', 'notnull' => true, 'primary' => 32, 'after' => 'section'), 'text' => array('type' => 'text', 'after' => 'key')), array('text' => array('fields' => array('text'), 'type' => 'FULLTEXT')), 'MyISAM', 'cx3upgrade');
        \Cx\Lib\UpdateUtil::sql("\n            INSERT INTO `" . DBPREFIX . "core_text` (`id`, `lang_id`, `section`, `key`, `text`)\n            VALUES  (1, 1, 'core', 'core_country_name', 'Afghanistan'),\n                    (1, 1, 'shop', 'attribute_name', 'Zusatzleistungen'),\n                    (1, 1, 'shop', 'core_mail_template_bcc', ''),\n                    (1, 1, 'shop', 'core_mail_template_cc', ''),\n                    (1, 1, 'shop', 'core_mail_template_from', '*****@*****.**'),\n                    (1, 1, 'shop', 'core_mail_template_message', '[CUSTOMER_SALUTATION]\r\n\r\nHier Ihre Zugangsdaten zum Shop:[[CUSTOMER_LOGIN]\r\nBenutzername: [CUSTOMER_USERNAME]\r\nPasswort: [CUSTOMER_PASSWORD][CUSTOMER_LOGIN]]\r\n\r\nMit freundlichen Grüssen\r\nIhr [SHOP_COMPANY] Online Shop Team\r\n\r\n[SHOP_HOMEPAGE]\r\n'),\n                    (1, 1, 'shop', 'core_mail_template_message_html', '[CUSTOMER_SALUTATION]<br />\r\n<br />\r\nHier Ihre Zugangsdaten zum Shop:<br /><!-- [[CUSTOMER_LOGIN] -->\r\nBenutzername: [CUSTOMER_USERNAME]<br />\r\nPasswort: [CUSTOMER_PASSWORD]<br /><!-- [CUSTOMER_LOGIN]] -->\r\n<br />\r\nMit freundlichen Gr&uuml;ssen<br />\r\nIhr [SHOP_COMPANY] Online Shop Team<br />\r\n<br />\r\n[SHOP_HOMEPAGE]<br />\r\n'),\n                    (1, 1, 'shop', 'core_mail_template_name', 'Zugangsdaten'),\n                    (1, 1, 'shop', 'core_mail_template_reply', '*****@*****.**'),\n                    (1, 1, 'shop', 'core_mail_template_sender', 'Contrexx Demo'),\n                    (1, 1, 'shop', 'core_mail_template_subject', 'Zugangsdaten'),\n                    (1, 1, 'shop', 'core_mail_template_to', '*****@*****.**'),\n                    (1, 1, 'shop', 'discount_group_article', 'Telefone'),\n                    (1, 1, 'shop', 'discount_group_customer', 'Neukunden'),\n                    (1, 1, 'shop', 'discount_group_name', 'Mengenrabatt'),\n                    (1, 1, 'shop', 'discount_group_unit', 'Stück'),\n                    (1, 1, 'shop', 'manufacturer_name', 'Comvation Internet Solutions'),\n                    (1, 1, 'shop', 'manufacturer_uri', 'http://www.comvation.com'),\n                    (1, 1, 'shop', 'option_name', 'Leder-Etui'),\n                    (12, 1, 'shop', 'product_uri', 'http://www.htc.com/de/'),\n                    (1, 1, 'shop', 'shipper_name', 'PostPac Priority'),\n                    (1, 1, 'shop', 'vat_class', 'Nicht Taxpflichtig'),\n                    (1, 1, 'shop', 'zone_name', 'All'),\n                    (1, 2, 'shop', 'category_name', 'Gadgets'),\n                    (1, 2, 'shop', 'currency_name', 'Schweizer Franken'),\n                    (2, 1, 'core', 'core_country_name', 'Albania'),\n                    (2, 1, 'shop', 'core_mail_template_bcc', ''),\n                    (2, 1, 'shop', 'core_mail_template_cc', ''),\n                    (2, 1, 'shop', 'core_mail_template_from', '*****@*****.**'),\n                    (2, 1, 'shop', 'core_mail_template_message', '[CUSTOMER_SALUTATION]\r\n\r\nIhre Bestellung wurde ausgeführt. Sie werden in den nächsten Tagen ihre Lieferung erhalten.\r\n\r\nHerzlichen Dank für das Vertrauen.\r\nWir würden uns freuen, wenn Sie uns weiterempfehlen und wünschen Ihnen noch einen schönen Tag.\r\n\r\nMit freundlichen Grüssen\r\nIhr [SHOP_COMPANY] Online Shop Team\r\n\r\n[SHOP_HOMEPAGE]\r\n'),\n                    (2, 1, 'shop', 'core_mail_template_name', 'Auftrag abgeschlossen'),\n                    (2, 1, 'shop', 'core_mail_template_reply', '*****@*****.**'),\n                    (2, 1, 'shop', 'core_mail_template_sender', 'Contrexx Demo'),\n                    (2, 1, 'shop', 'core_mail_template_subject', 'Auftrag abgeschlossen'),\n                    (2, 1, 'shop', 'core_mail_template_to', '*****@*****.**'),\n                    (2, 1, 'shop', 'discount_group_customer', 'Stammkunden'),\n                    (2, 1, 'shop', 'manufacturer_name', 'Apple, Inc.'),\n                    (2, 1, 'shop', 'manufacturer_uri', 'http://www.apple.com/'),\n                    (2, 1, 'shop', 'option_name', 'Pimp my Handy Kit'),\n                    (2, 1, 'shop', 'payment_name', 'VISA, Mastercard (Saferpay)'),\n                    (2, 1, 'shop', 'shipper_name', 'Express Post'),\n                    (2, 1, 'shop', 'vat_class', 'Deutschland Normalsatz'),\n                    (2, 1, 'shop', 'zone_name', 'Schweiz'),\n                    (3, 1, 'core', 'core_country_name', 'Algeria'),\n                    (3, 1, 'shop', 'core_mail_template_bcc', ''),\n                    (3, 1, 'shop', 'core_mail_template_cc', ''),\n                    (3, 1, 'shop', 'core_mail_template_from', '*****@*****.**'),\n                    (3, 1, 'shop', 'core_mail_template_message', '[CUSTOMER_SALUTATION],\r\n\r\nHerzlichen Dank für Ihre Bestellung im [SHOP_COMPANY] Online Shop.\r\n\r\nIhre Auftrags-Nr. lautet: [ORDER_ID]\r\nIhre Kunden-Nr. lautet: [CUSTOMER_ID]\r\nBestellungszeit: [ORDER_DATE] [ORDER_TIME]\r\n\r\n------------------------------------------------------------------------\r\nBestellinformationen\r\n------------------------------------------------------------------------[[ORDER_ITEM]\r\nID:             [PRODUCT_ID]\r\nArtikel Nr.:    [PRODUCT_CODE]\r\nMenge:          [PRODUCT_QUANTITY]\r\nBeschreibung:   [PRODUCT_TITLE][[PRODUCT_OPTIONS]\r\n                [PRODUCT_OPTIONS][PRODUCT_OPTIONS]]\r\nStückpreis:      [PRODUCT_ITEM_PRICE] [CURRENCY]                       Total [PRODUCT_TOTAL_PRICE] [CURRENCY][[USER_DATA]\r\nBenutzername:   [USER_NAME]\r\nPasswort:       [USER_PASS][USER_DATA]][[COUPON_DATA]\r\nGutschein Code: [COUPON_CODE][COUPON_DATA]][ORDER_ITEM]]\r\n------------------------------------------------------------------------\r\nZwischensumme:    [ORDER_ITEM_COUNT] Artikel                             [ORDER_ITEM_SUM] [CURRENCY][[DISCOUNT_COUPON]\r\nGutschein Code: [DISCOUNT_COUPON_CODE]   [DISCOUNT_COUPON_AMOUNT] [CURRENCY][DISCOUNT_COUPON]]\r\n------------------------------------------------------------------------[[SHIPMENT]\r\nVersandart:     [SHIPMENT_NAME]   [SHIPMENT_PRICE] [CURRENCY][SHIPMENT]][[PAYMENT]\r\nBezahlung:      [PAYMENT_NAME]   [PAYMENT_PRICE] [CURRENCY][PAYMENT]][[TAX]\r\n[TAX_TEXT]                   [TAX_PRICE] [CURRENCY][TAX]]\r\n------------------------------------------------------------------------\r\nGesamtsumme                                                [ORDER_SUM] [CURRENCY]\r\n------------------------------------------------------------------------\r\n\r\nIhre Kundenadresse:\r\n[CUSTOMER_COMPANY]\r\n[CUSTOMER_FIRSTNAME] [CUSTOMER_LASTNAME]\r\n[CUSTOMER_ADDRESS]\r\n[CUSTOMER_ZIP] [CUSTOMER_CITY]\r\n[CUSTOMER_COUNTRY][[SHIPPING_ADDRESS]\r\n\r\n\r\nLieferadresse:\r\n[SHIPPING_COMPANY]\r\n[SHIPPING_FIRSTNAME] [SHIPPING_LASTNAME]\r\n[SHIPPING_ADDRESS]\r\n[SHIPPING_ZIP] [SHIPPING_CITY]\r\n[SHIPPING_COUNTRY][SHIPPING_ADDRESS]]\r\n\r\nIhr Link zum Online Store: [SHOP_HOMEPAGE][[CUSTOMER_LOGIN]\r\n\r\nIhre Zugangsdaten zum Shop:\r\nBenutzername:   [CUSTOMER_USERNAME]\r\nPasswort:       [CUSTOMER_PASSWORD][CUSTOMER_LOGIN]]\r\n\r\nWir freuen uns auf Ihren nächsten Besuch im [SHOP_COMPANY] Online Store und wünschen Ihnen noch einen schönen Tag.\r\n\r\nP.S. Diese Auftragsbestätigung wurde gesendet an: [CUSTOMER_EMAIL]\r\n\r\nMit freundlichen Grüssen\r\nIhr [SHOP_COMPANY] Online Shop Team\r\n\r\n[SHOP_HOMEPAGE]\r\n'),\n                    (3, 1, 'shop', 'core_mail_template_message_html', '[CUSTOMER_SALUTATION],<br />\r\n<br />\r\nHerzlichen Dank f&uuml;r Ihre Bestellung im [SHOP_COMPANY] Online Shop.<br />\r\n<br />\r\nIhre Auftrags-Nr. lautet: [ORDER_ID]<br />\r\nIhre Kunden-Nr. lautet: [CUSTOMER_ID]<br />\r\nBestellungszeit: [ORDER_DATE] [ORDER_TIME]<br />\r\n<br />\r\n<br />\r\n<table cellspacing=\"1\" cellpadding=\"1\" style=\"border: 0;\">\r\n  <tbody>\r\n    <tr>\r\n      <td colspan=\"6\">Bestellinformationen</td>\r\n    </tr>\r\n    <tr>\r\n      <td><div style=\"text-align: right;\">ID</div></td>\r\n      <td><div style=\"text-align: right;\">Artikel Nr.</div></td>\r\n      <td><div style=\"text-align: right;\">Menge</div></td>\r\n      <td>Beschreibung</td>\r\n      <td><div style=\"text-align: right;\">St&uuml;ckpreis</div></td>\r\n      <td><div style=\"text-align: right;\">Total</div></td>\r\n    </tr><!--[[ORDER_ITEM]-->\r\n    <tr>\r\n      <td><div style=\"text-align: right;\">[PRODUCT_ID]</div></td>\r\n      <td><div style=\"text-align: right;\">[PRODUCT_CODE]</div></td>\r\n      <td><div style=\"text-align: right;\">[PRODUCT_QUANTITY]</div></td>\r\n      <td>[PRODUCT_TITLE]<!--[[PRODUCT_OPTIONS]--><br />\r\n        [PRODUCT_OPTIONS]<!--[PRODUCT_OPTIONS]]--></td>\r\n      <td><div style=\"text-align: right;\">[PRODUCT_ITEM_PRICE] [CURRENCY]</div></td>\r\n      <td><div style=\"text-align: right;\">[PRODUCT_TOTAL_PRICE] [CURRENCY]</div></td>\r\n    </tr><!--[[USER_DATA]-->\r\n    <tr>\r\n      <td colspan=\"3\">&nbsp;</td>\r\n      <td>Benutzername: [USER_NAME]<br />Passwort: [USER_PASS]</td>\r\n      <td colspan=\"2\">&nbsp;</td>\r\n    </tr><!--[USER_DATA]]--><!--[[COUPON_DATA]-->\r\n    <tr>\r\n      <td colspan=\"3\">&nbsp;</td>\r\n      <td>Gutschein Code: [COUPON_CODE]</td>\r\n      <td colspan=\"2\">&nbsp;</td>\r\n    </tr><!--[COUPON_DATA]]--><!--[ORDER_ITEM]]-->\r\n    <tr style=\"border-top: 4px none;\">\r\n      <td colspan=\"2\">Zwischensumme</td>\r\n      <td><div style=\"text-align: right;\">[ORDER_ITEM_COUNT]</div></td>\r\n      <td colspan=\"2\">Artikel</td>\r\n      <td><div style=\"text-align: right;\">[ORDER_ITEM_SUM] [CURRENCY]</div></td>\r\n    </tr><!--[[DISCOUNT_COUPON]-->\r\n    <tr style=\"border-top: 4px none;\">\r\n      <td colspan=\"3\">Gutscheincode</td>\r\n      <td colspan=\"2\">[DISCOUNT_COUPON_CODE]</td>\r\n      <td><div style=\"text-align: right;\">[DISCOUNT_COUPON_AMOUNT] [CURRENCY]</div></td>\r\n    </tr><!--[DISCOUNT_COUPON]]-->\r\n    <tr style=\"border-top: 2px none;\">\r\n      <td colspan=\"3\">Versandart</td>\r\n      <td colspan=\"2\">[SHIPMENT_NAME]</td>\r\n      <td><div style=\"text-align: right;\">[SHIPMENT_PRICE] [CURRENCY]</div></td>\r\n    </tr>\r\n    <tr style=\"border-top: 2px none;\">\r\n      <td colspan=\"3\">Bezahlung</td>\r\n      <td colspan=\"2\">[PAYMENT_NAME]</td>\r\n      <td><div style=\"text-align: right;\">[PAYMENT_PRICE] [CURRENCY]</div></td>\r\n    </tr>\r\n    <tr style=\"border-top: 2px none;\">\r\n      <td colspan=\"5\">[TAX_TEXT]</td>\r\n      <td><div style=\"text-align: right;\">[TAX_PRICE] [CURRENCY]</div></td>\r\n    </tr>\r\n    <tr style=\"border-top: 4px none;\">\r\n      <td colspan=\"5\">Gesamtsumme</td>\r\n      <td><div style=\"text-align: right;\">[ORDER_SUM] [CURRENCY]</div></td>\r\n    </tr>\r\n  </tbody>\r\n</table>\r\n<br />\r\n<br />\r\nIhre Kundenadresse:<br />\r\n[CUSTOMER_COMPANY]<br />\r\n[CUSTOMER_FIRSTNAME] [CUSTOMER_LASTNAME]<br />\r\n[CUSTOMER_ADDRESS]<br />\r\n[CUSTOMER_ZIP] [CUSTOMER_CITY]<br />\r\n[CUSTOMER_COUNTRY]<br /><!--[[SHIPPING_ADDRESS]-->\r\n<br />\r\n<br />\r\nLieferadresse:<br />\r\n[SHIPPING_COMPANY]<br />\r\n[SHIPPING_FIRSTNAME] [SHIPPING_LASTNAME]<br />\r\n[SHIPPING_ADDRESS]<br />\r\n[SHIPPING_ZIP] [SHIPPING_CITY]<br />\r\n[SHIPPING_COUNTRY]<br /><!--[SHIPPING_ADDRESS]]-->\r\n<br />\r\n<br />\r\nIhr Link zum Online Store: [SHOP_HOMEPAGE]<br /><!--[[CUSTOMER_LOGIN]-->\r\n<br />\r\nIhre Zugangsdaten zum Shop:<br />\r\nBenutzername:   [CUSTOMER_USERNAME]<br />\r\nPasswort:       [CUSTOMER_PASSWORD]<br /><!--[CUSTOMER_LOGIN]]-->\r\n<br />\r\nWir freuen uns auf Ihren n&auml;chsten Besuch im [SHOP_COMPANY] Online Store und w&uuml;nschen Ihnen noch einen sch&ouml;nen Tag.<br />\r\n<br />\r\nP.S. Diese Auftragsbest&auml;tigung wurde gesendet an: [CUSTOMER_EMAIL]<br />\r\n<br />\r\nMit freundlichen Gr&uuml;ssen<br />\r\nIhr [SHOP_COMPANY] Online Shop Team<br />\r\n<br />\r\n[SHOP_HOMEPAGE]<br />\r\n<br />\r\n'),\n                    (3, 1, 'shop', 'core_mail_template_name', 'Bestellungsbestätigung'),\n                    (3, 1, 'shop', 'core_mail_template_reply', '*****@*****.**'),\n                    (3, 1, 'shop', 'core_mail_template_sender', 'Contrexx Demo'),\n                    (3, 1, 'shop', 'core_mail_template_subject', 'Bestellungsbestätigung'),\n                    (3, 1, 'shop', 'core_mail_template_to', '*****@*****.**'),\n                    (3, 1, 'shop', 'discount_group_customer', 'Goldkunden'),\n                    (3, 1, 'shop', 'shipper_name', 'Schweizerische Post'),\n                    (3, 1, 'shop', 'vat_class', 'Deutschland ermässigt'),\n                    (3, 1, 'shop', 'zone_name', 'Deutschland'),\n                    (3, 2, 'shop', 'category_name', 'Mitgliedschaft'),\n                    (4, 1, 'core', 'core_country_name', 'American Samoa'),\n                    (4, 1, 'shop', 'shipper_name', 'Direct to Me'),\n                    (4, 1, 'shop', 'vat_class', 'Deutschland stark ermässigt'),\n                    (4, 2, 'shop', 'currency_name', 'Euro'),\n                    (5, 1, 'core', 'core_country_name', 'Andorra'),\n                    (5, 1, 'shop', 'vat_class', 'Deutschland Zwischensatz 1'),\n                    (5, 2, 'shop', 'currency_name', 'United States Dollars'),\n                    (6, 1, 'core', 'core_country_name', 'Angola'),\n                    (1, 1, 'shop', 'currency_name', 'Schweizer Franken'),\n                    (3, 1, 'shop', 'option_name', 'Headset'),\n                    (13, 1, 'shop', 'product_name', 'Contrexx® Premium'),\n                    (3, 1, 'shop', 'manufacturer_name', 'HTC'),\n                    (3, 1, 'shop', 'manufacturer_uri', 'http://www.htc.com/'),\n                    (11, 1, 'shop', 'category_name', 'Mitgliedschaft'),\n                    (6, 1, 'shop', 'vat_class', 'Deutschland Zwischensatz 2'),\n                    (7, 1, 'core', 'core_country_name', 'Anguilla'),\n                    (7, 1, 'shop', 'vat_class', 'Österreich Normalsatz'),\n                    (8, 1, 'core', 'core_country_name', 'Antarctica'),\n                    (8, 1, 'shop', 'vat_class', 'Österreich ermässigt'),\n                    (9, 1, 'core', 'core_country_name', 'Antigua and Barbuda'),\n                    (9, 1, 'shop', 'payment_name', 'Nachnahme'),\n                    (9, 1, 'shop', 'vat_class', 'Österreich Zwischensatz'),\n                    (10, 1, 'core', 'core_country_name', 'Argentina'),\n                    (10, 1, 'shop', 'vat_class', 'Schweiz'),\n                    (11, 1, 'core', 'core_country_name', 'Armenia'),\n                    (11, 1, 'shop', 'vat_class', 'Schweiz ermässigt 1'),\n                    (12, 1, 'core', 'core_country_name', 'Aruba'),\n                    (12, 1, 'shop', 'payment_name', 'Paypal'),\n                    (12, 1, 'shop', 'vat_class', 'Schweiz ermässigt 2'),\n                    (13, 1, 'core', 'core_country_name', 'Australia'),\n                    (13, 1, 'shop', 'payment_name', 'LSV'),\n                    (13, 1, 'shop', 'vat_class', 'Great Britain'),\n                    (14, 1, 'core', 'core_country_name', 'Österreich'),\n                    (14, 1, 'shop', 'payment_name', 'PostFinance (PostCard, Kreditkarte)'),\n                    (14, 1, 'shop', 'vat_class', 'Great Britain reduced'),\n                    (15, 1, 'core', 'core_country_name', 'Azerbaijan'),\n                    (15, 1, 'shop', 'payment_name', 'Datatrans'),\n                    (16, 1, 'core', 'core_country_name', 'Bahamas'),\n                    (17, 1, 'core', 'core_country_name', 'Bahrain'),\n                    (18, 1, 'core', 'core_country_name', 'Bangladesh'),\n                    (19, 1, 'core', 'core_country_name', 'Barbados'),\n                    (20, 1, 'core', 'core_country_name', 'Belarus'),\n                    (21, 1, 'core', 'core_country_name', 'Belgium'),\n                    (22, 1, 'core', 'core_country_name', 'Belize'),\n                    (23, 1, 'core', 'core_country_name', 'Benin'),\n                    (24, 1, 'core', 'core_country_name', 'Bermuda'),\n                    (25, 1, 'core', 'core_country_name', 'Bhutan'),\n                    (26, 1, 'core', 'core_country_name', 'Bolivia'),\n                    (27, 1, 'core', 'core_country_name', 'Bosnia and Herzegowina'),\n                    (28, 1, 'core', 'core_country_name', 'Botswana'),\n                    (29, 1, 'core', 'core_country_name', 'Bouvet Island'),\n                    (30, 1, 'core', 'core_country_name', 'Brazil'),\n                    (31, 1, 'core', 'core_country_name', 'British Indian Ocean Territory'),\n                    (32, 1, 'core', 'core_country_name', 'Brunei Darussalam'),\n                    (33, 1, 'core', 'core_country_name', 'Bulgaria'),\n                    (34, 1, 'core', 'core_country_name', 'Burkina Faso'),\n                    (35, 1, 'core', 'core_country_name', 'Burundi'),\n                    (36, 1, 'core', 'core_country_name', 'Cambodia'),\n                    (37, 1, 'core', 'core_country_name', 'Cameroon'),\n                    (38, 1, 'core', 'core_country_name', 'Canada'),\n                    (39, 1, 'core', 'core_country_name', 'Cape Verde'),\n                    (40, 1, 'core', 'core_country_name', 'Cayman Islands'),\n                    (41, 1, 'core', 'core_country_name', 'Central African Republic'),\n                    (42, 1, 'core', 'core_country_name', 'Chad'),\n                    (43, 1, 'core', 'core_country_name', 'Chile'),\n                    (44, 1, 'core', 'core_country_name', 'China'),\n                    (45, 1, 'core', 'core_country_name', 'Christmas Island'),\n                    (46, 1, 'core', 'core_country_name', 'Cocos (Keeling) Islands'),\n                    (47, 1, 'core', 'core_country_name', 'Colombia'),\n                    (48, 1, 'core', 'core_country_name', 'Comoros'),\n                    (49, 1, 'core', 'core_country_name', 'Congo'),\n                    (50, 1, 'core', 'core_country_name', 'Cook Islands'),\n                    (51, 1, 'core', 'core_country_name', 'Costa Rica'),\n                    (52, 1, 'core', 'core_country_name', 'Cote D''Ivoire'),\n                    (53, 1, 'core', 'core_country_name', 'Croatia'),\n                    (54, 1, 'core', 'core_country_name', 'Cuba'),\n                    (55, 1, 'core', 'core_country_name', 'Cyprus'),\n                    (56, 1, 'core', 'core_country_name', 'Czech Republic'),\n                    (57, 1, 'core', 'core_country_name', 'Denmark'),\n                    (58, 1, 'core', 'core_country_name', 'Djibouti'),\n                    (59, 1, 'core', 'core_country_name', 'Dominica'),\n                    (60, 1, 'core', 'core_country_name', 'Dominican Republic'),\n                    (61, 1, 'core', 'core_country_name', 'East Timor'),\n                    (62, 1, 'core', 'core_country_name', 'Ecuador'),\n                    (63, 1, 'core', 'core_country_name', 'Egypt'),\n                    (64, 1, 'core', 'core_country_name', 'El Salvador'),\n                    (65, 1, 'core', 'core_country_name', 'Equatorial Guinea'),\n                    (66, 1, 'core', 'core_country_name', 'Eritrea'),\n                    (67, 1, 'core', 'core_country_name', 'Estonia'),\n                    (68, 1, 'core', 'core_country_name', 'Ethiopia'),\n                    (69, 1, 'core', 'core_country_name', 'Falkland Islands (Malvinas)'),\n                    (70, 1, 'core', 'core_country_name', 'Faroe Islands'),\n                    (71, 1, 'core', 'core_country_name', 'Fiji'),\n                    (72, 1, 'core', 'core_country_name', 'Finland'),\n                    (73, 1, 'core', 'core_country_name', 'France'),\n                    (74, 1, 'core', 'core_country_name', 'France, Metropolitan'),\n                    (75, 1, 'core', 'core_country_name', 'French Guiana'),\n                    (76, 1, 'core', 'core_country_name', 'French Polynesia'),\n                    (77, 1, 'core', 'core_country_name', 'French Southern Territories'),\n                    (78, 1, 'core', 'core_country_name', 'Gabon'),\n                    (79, 1, 'core', 'core_country_name', 'Gambia'),\n                    (80, 1, 'core', 'core_country_name', 'Georgia'),\n                    (81, 1, 'core', 'core_country_name', 'Deutschland'),\n                    (82, 1, 'core', 'core_country_name', 'Ghana'),\n                    (83, 1, 'core', 'core_country_name', 'Gibraltar'),\n                    (84, 1, 'core', 'core_country_name', 'Greece'),\n                    (85, 1, 'core', 'core_country_name', 'Greenland'),\n                    (86, 1, 'core', 'core_country_name', 'Grenada'),\n                    (87, 1, 'core', 'core_country_name', 'Guadeloupe'),\n                    (88, 1, 'core', 'core_country_name', 'Guam'),\n                    (89, 1, 'core', 'core_country_name', 'Guatemala'),\n                    (90, 1, 'core', 'core_country_name', 'Guinea'),\n                    (91, 1, 'core', 'core_country_name', 'Guinea-bissau'),\n                    (92, 1, 'core', 'core_country_name', 'Guyana'),\n                    (93, 1, 'core', 'core_country_name', 'Haiti'),\n                    (94, 1, 'core', 'core_country_name', 'Heard and Mc Donald Islands'),\n                    (95, 1, 'core', 'core_country_name', 'Honduras'),\n                    (96, 1, 'core', 'core_country_name', 'Hong Kong'),\n                    (97, 1, 'core', 'core_country_name', 'Hungary'),\n                    (98, 1, 'core', 'core_country_name', 'Iceland'),\n                    (99, 1, 'core', 'core_country_name', 'India'),\n                    (100, 1, 'core', 'core_country_name', 'Indonesia'),\n                    (101, 1, 'core', 'core_country_name', 'Iran (Islamic Republic of)'),\n                    (102, 1, 'core', 'core_country_name', 'Iraq'),\n                    (103, 1, 'core', 'core_country_name', 'Ireland'),\n                    (104, 1, 'core', 'core_country_name', 'Israel'),\n                    (105, 1, 'core', 'core_country_name', 'Italy'),\n                    (106, 1, 'core', 'core_country_name', 'Jamaica'),\n                    (107, 1, 'core', 'core_country_name', 'Japan'),\n                    (108, 1, 'core', 'core_country_name', 'Jordan'),\n                    (109, 1, 'core', 'core_country_name', 'Kazakhstan'),\n                    (110, 1, 'core', 'core_country_name', 'Kenya'),\n                    (111, 1, 'core', 'core_country_name', 'Kiribati'),\n                    (112, 1, 'core', 'core_country_name', 'Korea, Democratic People''s Republic of'),\n                    (113, 1, 'core', 'core_country_name', 'Korea, Republic of'),\n                    (114, 1, 'core', 'core_country_name', 'Kuwait'),\n                    (115, 1, 'core', 'core_country_name', 'Kyrgyzstan'),\n                    (116, 1, 'core', 'core_country_name', 'Lao People''s Democratic Republic'),\n                    (117, 1, 'core', 'core_country_name', 'Latvia'),\n                    (118, 1, 'core', 'core_country_name', 'Lebanon'),\n                    (119, 1, 'core', 'core_country_name', 'Lesotho'),\n                    (120, 1, 'core', 'core_country_name', 'Liberia'),\n                    (121, 1, 'core', 'core_country_name', 'Libyan Arab Jamahiriya'),\n                    (122, 1, 'core', 'core_country_name', 'Liechtenstein'),\n                    (123, 1, 'core', 'core_country_name', 'Lithuania'),\n                    (124, 1, 'core', 'core_country_name', 'Luxembourg'),\n                    (125, 1, 'core', 'core_country_name', 'Macau'),\n                    (126, 1, 'core', 'core_country_name', 'Macedonia, The Former Yugoslav Republic of'),\n                    (127, 1, 'core', 'core_country_name', 'Madagascar'),\n                    (128, 1, 'core', 'core_country_name', 'Malawi'),\n                    (129, 1, 'core', 'core_country_name', 'Malaysia'),\n                    (130, 1, 'core', 'core_country_name', 'Maldives'),\n                    (131, 1, 'core', 'core_country_name', 'Mali'),\n                    (132, 1, 'core', 'core_country_name', 'Malta'),\n                    (133, 1, 'core', 'core_country_name', 'Marshall Islands'),\n                    (134, 1, 'core', 'core_country_name', 'Martinique'),\n                    (135, 1, 'core', 'core_country_name', 'Mauritania'),\n                    (136, 1, 'core', 'core_country_name', 'Mauritius'),\n                    (137, 1, 'core', 'core_country_name', 'Mayotte'),\n                    (138, 1, 'core', 'core_country_name', 'Mexico'),\n                    (139, 1, 'core', 'core_country_name', 'Micronesia, Federated States of'),\n                    (140, 1, 'core', 'core_country_name', 'Moldova, Republic of'),\n                    (141, 1, 'core', 'core_country_name', 'Monaco'),\n                    (142, 1, 'core', 'core_country_name', 'Mongolia'),\n                    (143, 1, 'core', 'core_country_name', 'Montserrat'),\n                    (144, 1, 'core', 'core_country_name', 'Morocco'),\n                    (145, 1, 'core', 'core_country_name', 'Mozambique'),\n                    (146, 1, 'core', 'core_country_name', 'Myanmar'),\n                    (147, 1, 'core', 'core_country_name', 'Namibia'),\n                    (148, 1, 'core', 'core_country_name', 'Nauru'),\n                    (149, 1, 'core', 'core_country_name', 'Nepal'),\n                    (150, 1, 'core', 'core_country_name', 'Netherlands'),\n                    (151, 1, 'core', 'core_country_name', 'Netherlands Antilles'),\n                    (152, 1, 'core', 'core_country_name', 'New Caledonia'),\n                    (153, 1, 'core', 'core_country_name', 'New Zealand'),\n                    (154, 1, 'core', 'core_country_name', 'Nicaragua'),\n                    (155, 1, 'core', 'core_country_name', 'Niger'),\n                    (156, 1, 'core', 'core_country_name', 'Nigeria'),\n                    (157, 1, 'core', 'core_country_name', 'Niue'),\n                    (158, 1, 'core', 'core_country_name', 'Norfolk Island'),\n                    (159, 1, 'core', 'core_country_name', 'Northern Mariana Islands'),\n                    (160, 1, 'core', 'core_country_name', 'Norway'),\n                    (161, 1, 'core', 'core_country_name', 'Oman'),\n                    (162, 1, 'core', 'core_country_name', 'Pakistan'),\n                    (163, 1, 'core', 'core_country_name', 'Palau'),\n                    (164, 1, 'core', 'core_country_name', 'Panama'),\n                    (165, 1, 'core', 'core_country_name', 'Papua New Guinea'),\n                    (166, 1, 'core', 'core_country_name', 'Paraguay'),\n                    (167, 1, 'core', 'core_country_name', 'Peru'),\n                    (168, 1, 'core', 'core_country_name', 'Philippines'),\n                    (169, 1, 'core', 'core_country_name', 'Pitcairn'),\n                    (170, 1, 'core', 'core_country_name', 'Poland'),\n                    (171, 1, 'core', 'core_country_name', 'Portugal'),\n                    (172, 1, 'core', 'core_country_name', 'Puerto Rico'),\n                    (173, 1, 'core', 'core_country_name', 'Qatar'),\n                    (174, 1, 'core', 'core_country_name', 'Reunion'),\n                    (175, 1, 'core', 'core_country_name', 'Romania'),\n                    (176, 1, 'core', 'core_country_name', 'Russian Federation'),\n                    (177, 1, 'core', 'core_country_name', 'Rwanda'),\n                    (178, 1, 'core', 'core_country_name', 'Saint Kitts and Nevis'),\n                    (179, 1, 'core', 'core_country_name', 'Saint Lucia'),\n                    (180, 1, 'core', 'core_country_name', 'Saint Vincent and the Grenadines'),\n                    (181, 1, 'core', 'core_country_name', 'Samoa'),\n                    (182, 1, 'core', 'core_country_name', 'San Marino'),\n                    (183, 1, 'core', 'core_country_name', 'Sao Tome and Principe'),\n                    (184, 1, 'core', 'core_country_name', 'Saudi Arabia'),\n                    (185, 1, 'core', 'core_country_name', 'Senegal'),\n                    (186, 1, 'core', 'core_country_name', 'Seychelles'),\n                    (187, 1, 'core', 'core_country_name', 'Sierra Leone'),\n                    (188, 1, 'core', 'core_country_name', 'Singapore'),\n                    (189, 1, 'core', 'core_country_name', 'Slovakia (Slovak Republic)'),\n                    (190, 1, 'core', 'core_country_name', 'Slovenia'),\n                    (191, 1, 'core', 'core_country_name', 'Solomon Islands'),\n                    (192, 1, 'core', 'core_country_name', 'Somalia'),\n                    (193, 1, 'core', 'core_country_name', 'South Africa'),\n                    (194, 1, 'core', 'core_country_name', 'South Georgia and the South Sandwich Islands'),\n                    (195, 1, 'core', 'core_country_name', 'Spain'),\n                    (196, 1, 'core', 'core_country_name', 'Sri Lanka'),\n                    (197, 1, 'core', 'core_country_name', 'St. Helena'),\n                    (198, 1, 'core', 'core_country_name', 'St. Pierre and Miquelon'),\n                    (199, 1, 'core', 'core_country_name', 'Sudan'),\n                    (200, 1, 'core', 'core_country_name', 'Suriname'),\n                    (201, 1, 'core', 'core_country_name', 'Svalbard and Jan Mayen Islands'),\n                    (202, 1, 'core', 'core_country_name', 'Swaziland'),\n                    (203, 1, 'core', 'core_country_name', 'Sweden'),\n                    (204, 1, 'core', 'core_country_name', 'Schweiz'),\n                    (205, 1, 'core', 'core_country_name', 'Syrian Arab Republic'),\n                    (206, 1, 'core', 'core_country_name', 'Taiwan'),\n                    (207, 1, 'core', 'core_country_name', 'Tajikistan'),\n                    (208, 1, 'core', 'core_country_name', 'Tanzania, United Republic of'),\n                    (209, 1, 'core', 'core_country_name', 'Thailand'),\n                    (210, 1, 'core', 'core_country_name', 'Togo'),\n                    (211, 1, 'core', 'core_country_name', 'Tokelau'),\n                    (212, 1, 'core', 'core_country_name', 'Tonga'),\n                    (213, 1, 'core', 'core_country_name', 'Trinidad and Tobago'),\n                    (214, 1, 'core', 'core_country_name', 'Tunisia'),\n                    (215, 1, 'core', 'core_country_name', 'Turkey'),\n                    (216, 1, 'core', 'core_country_name', 'Turkmenistan'),\n                    (217, 1, 'core', 'core_country_name', 'Turks and Caicos Islands'),\n                    (218, 1, 'core', 'core_country_name', 'Tuvalu'),\n                    (219, 1, 'core', 'core_country_name', 'Uganda'),\n                    (220, 1, 'core', 'core_country_name', 'Ukraine'),\n                    (221, 1, 'core', 'core_country_name', 'United Arab Emirates'),\n                    (222, 1, 'core', 'core_country_name', 'United Kingdom'),\n                    (223, 1, 'core', 'core_country_name', 'United States'),\n                    (224, 1, 'core', 'core_country_name', 'United States Minor Outlying Islands'),\n                    (225, 1, 'core', 'core_country_name', 'Uruguay'),\n                    (226, 1, 'core', 'core_country_name', 'Uzbekistan'),\n                    (227, 1, 'core', 'core_country_name', 'Vanuatu'),\n                    (228, 1, 'core', 'core_country_name', 'Vatican City State (Holy See)'),\n                    (229, 1, 'core', 'core_country_name', 'Venezuela'),\n                    (230, 1, 'core', 'core_country_name', 'Viet Nam'),\n                    (231, 1, 'core', 'core_country_name', 'Virgin Islands (British)'),\n                    (232, 1, 'core', 'core_country_name', 'Virgin Islands (U.S.)'),\n                    (233, 1, 'core', 'core_country_name', 'Wallis and Futuna Islands'),\n                    (234, 1, 'core', 'core_country_name', 'Western Sahara'),\n                    (235, 1, 'core', 'core_country_name', 'Yemen'),\n                    (236, 1, 'core', 'core_country_name', 'Yugoslavia'),\n                    (237, 1, 'core', 'core_country_name', 'Zaire'),\n                    (238, 1, 'core', 'core_country_name', 'Zambia'),\n                    (239, 1, 'core', 'core_country_name', 'Zimbabwe'),\n                    (4, 2, 'shop', 'category_name', 'Lorem ipsum1'),\n                    (4, 2, 'shop', 'category_description', 'lorem ipsum lorem ipsum lorem ipsum lorem ipsum'),\n                    (5, 2, 'shop', 'category_name', 'Lorem ipsum2'),\n                    (5, 2, 'shop', 'category_description', 'lorem ipsum lorem ipsum lorem ipsum lorem ipsum'),\n                    (6, 2, 'shop', 'category_name', 'Lorem ipsum3'),\n                    (6, 2, 'shop', 'category_description', 'lorem ipsum lorem ipsum lorem ipsum lorem ipsum'),\n                    (12, 1, 'shop', 'product_short', 'Als eines der ersten Smartphones besitzt das HTC One X einen Quad-Core-Prozessor &ndash; d.h. die Leistung verteilt sich auf 4 Rechenkerne. Dies macht das HTC One X extrem schnell und leistungsf&auml;hig.'),\n                    (12, 1, 'shop', 'product_long', '<table border=\"0\">\r\n    <tbody>\r\n        <tr>\r\n            <td style=\"width: 120px;\">\r\n                <strong>Gr&ouml;&szlig;e:</strong></td>\r\n            <td>\r\n                134,36 x 69,9 x 8,9 mm</td>\r\n        </tr>\r\n        <tr>\r\n            <td>\r\n                <strong>Gewicht:</strong></td>\r\n            <td>\r\n                130 g mit Akku</td>\r\n        </tr>\r\n        <tr>\r\n            <td>\r\n                <strong>Display:</strong></td>\r\n            <td>\r\n                HD 720P Touchscreen</td>\r\n        </tr>\r\n        <tr>\r\n            <td>\r\n                <strong>Bildschirm:</strong></td>\r\n            <td>\r\n                4,7&ldquo; (1280 x 720 Aufl&ouml;sung)</td>\r\n        </tr>\r\n    </tbody>\r\n</table>'),\n                    (12, 1, 'shop', 'product_keys', 'HTC, HTC One X'),\n                    (12, 1, 'shop', 'product_code', ''),\n                    (10, 1, 'shop', 'category_description', 'Alle Versionen des Contrexx Content Management Systems zur Verwaltung Ihrer Website.'),\n                    (12, 1, 'shop', 'product_name', 'HTC One X'),\n                    (10, 1, 'shop', 'category_name', 'Contrexx CMS Software'),\n                    (9, 1, 'shop', 'category_name', 'Mobile Phones'),\n                    (9, 1, 'shop', 'category_description', 'Mobile Phones von über 10 Marken wie Apple, HTC & Samsung.'),\n                    (8, 2, 'shop', 'category_name', 'Iphone'),\n                    (8, 2, 'shop', 'category_description', 'lorem ipsum lorem ipsum lorem ipsum lorem ipsum'),\n                    (13, 1, 'shop', 'product_code', ''),\n                    (13, 1, 'shop', 'product_uri', 'http://www.contrexx.com'),\n                    (13, 1, 'shop', 'product_keys', 'Contrexx CMS'),\n                    (13, 1, 'shop', 'product_long', 'Mit dem Contrexx CMS stehen Ihnen &uuml;ber 20 Anwendungen zur Verf&uuml;gung, beispielsweise ein kompletter Online Shop, ein umfangreiches Newsletter-Modul und eine mehrsprachige Website.'),\n                    (13, 1, 'shop', 'product_short', 'Contrexx&reg; CMS f&uuml;r die schnelle Verwaltung Ihrer Website.'),\n                    (7, 2, 'shop', 'category_name', 'Samsung'),\n                    (7, 2, 'shop', 'category_description', 'lorem ipsum lorem ipsum lorem ipsum lorem ipsum'),\n                    (1, 2, 'shop', 'manufacturer_name', 'Samsung'),\n                    (1, 2, 'shop', 'manufacturer_uri', 'http://www.samsung.com'),\n                    (2, 2, 'shop', 'manufacturer_name', 'Apple, Inc.'),\n                    (2, 2, 'shop', 'manufacturer_uri', 'http://www.apple.com/'),\n                    (4, 1, 'shop', 'manufacturer_name', 'Contrexx'),\n                    (4, 1, 'shop', 'manufacturer_uri', 'http://www.contrexx.com'),\n                    (11, 1, 'shop', 'category_description', 'Zum Erwerben von Mitgliedschaften bei verschiedenen Vereienen und Organisationen.'),\n                    (14, 1, 'shop', 'product_name', 'Mitglied von der MaxMuster-Foundation'),\n                    (14, 1, 'shop', 'product_short', 'Unterst&uuml;tzen Sie die MaxMuster-Foundation und werden Sie noch heute Mitglied! Sie profitieren von MItgliederrabatten an verschiedenen Anl&auml;ssen.'),\n                    (14, 1, 'shop', 'product_long', 'Die Foundation hilft Schulen und Ausbildungsinstitutionen seit 10 Jahren sich technisch weiterzuentwickeln und den Lernenden so verbesserte Ausbildungsm&ouml;glichkeiten zu bieten. Durch eine Mitgliedschaft erhalten Sie Rabatte an verschiedenen Firmenanl&auml;ssen der MaxMuster AG.'),\n                    (14, 1, 'shop', 'product_keys', ''),\n                    (14, 1, 'shop', 'product_code', ''),\n                    (14, 1, 'shop', 'product_uri', ''),\n                    (5, 1, 'shop', 'manufacturer_name', 'MaxMuster AG'),\n                    (5, 1, 'shop', 'manufacturer_uri', ''),\n                    (2, 1, 'shop', 'core_mail_template_message_html', '[CUSTOMER_SALUTATION]<br />\r\n<br />\r\nIhre Bestellung wurde ausgef&uuml;hrt. Sie werden in den n&auml;chsten Tagen ihre Lieferung erhalten.<br />\r\n<br />\r\nHerzlichen Dank f&uuml;r das Vertrauen.<br />\r\nWir w&uuml;rden uns freuen, wenn Sie uns weiterempfehlen und w&uuml;nschen Ihnen noch einen sch&ouml;nen Tag.<br />\r\n<br />\r\nMit freundlichen Gr&uuml;ssen<br />\r\nIhr [SHOP_COMPANY] Online Shop Team<br />\r\n<br />\r\n[SHOP_HOMEPAGE]'),\n                    (4, 1, 'shop', 'currency_name', 'Euro'),\n                    (5, 1, 'shop', 'currency_name', 'United States Dollars'),\n                    (16,1,'shop','payment_name','Kreditkarte (Paymill)'),\n                    (16,2,'shop','payment_name','paymill'),\n                    (17,1,'shop','payment_name','ELV (Paymill)'),\n                    (18,1,'shop','payment_name','IBAN/BIC (Paymill)')\n            ON DUPLICATE KEY UPDATE `id` = `id`\n        ");
        try {
            $queries = array('INSERT IGNORE INTO `' . DBPREFIX . 'core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`) VALUES ("shop","payment_lsv_active","config","text","1","",18)', 'INSERT IGNORE INTO `' . DBPREFIX . 'core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`) VALUES ("shop","paymill_active","config","text","1","",3)', 'INSERT IGNORE INTO `' . DBPREFIX . 'core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`) VALUES ("shop","paymill_live_private_key","config","text","","",0)', 'INSERT IGNORE INTO `' . DBPREFIX . 'core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`) VALUES ("shop","paymill_live_public_key","config","text","","",0)', 'INSERT IGNORE INTO `' . DBPREFIX . 'core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`) VALUES ("shop","paymill_live_public_key","config","text","","",0)', 'INSERT IGNORE INTO `' . DBPREFIX . 'core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`) VALUES ("shop","paymill_test_private_key","config","text","","",2)', 'INSERT IGNORE INTO `' . DBPREFIX . 'core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`) VALUES ("shop","paymill_test_public_key","config","text","","",16)', 'INSERT IGNORE INTO `' . DBPREFIX . 'core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`) VALUES ("shop","paymill_use_test_account","config","text","0","",15)', 'INSERT IGNORE INTO `' . DBPREFIX . 'core_setting` (`section`, `name`, `group`, `type`, `value`, `values`, `ord`) VALUES (\'shop\',\'orderitems_amount_min\',\'config\',\'text\',\'0\',\'\',0);');
            foreach ($queries as $query) {
                \Cx\Lib\UpdateUtil::sql($query);
            }
        } catch (\Cx\Lib\UpdateException $e) {
            return \Cx\Lib\UpdateUtil::DefaultActionHandler($e);
        }
    } catch (\Cx\Lib\UpdateException $e) {
        return \Cx\Lib\UpdateUtil::DefaultActionHandler($e);
    }
}