DROP TABLE IF EXISTS `test_CubeCart_access_log`;
CREATE TABLE `test_CubeCart_access_log` (
`log_id` int(10) unsigned NOT NULL auto_increment,
`type` char(1) NOT NULL,
`time` int(10) unsigned NOT NULL,
`username` varchar(100) NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`ip_address` varchar(45) NOT NULL COMMENT 'Supports IPv6 addresses',
`useragent` text NOT NULL,
`success` enum('Y','N') NOT NULL,
PRIMARY KEY (`log_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_addressbook`;
CREATE TABLE `test_CubeCart_addressbook` (
`address_id` int(10) unsigned NOT NULL auto_increment,
`customer_id` int(10) unsigned NOT NULL,
`billing` enum('0','1') NOT NULL default '0',
`default` enum('0','1') NOT NULL default '0',
`description` varchar(250) NOT NULL,
`addressee` varchar(100) NOT NULL,
`title` varchar(20) NOT NULL,
`first_name` varchar(250) NOT NULL,
`last_name` varchar(250) NOT NULL,
`company_name` varchar(200) NOT NULL,
`line1` varchar(200) NOT NULL,
`line2` varchar(200) NOT NULL,
`town` varchar(100) NOT NULL,
`state` varchar(100) NOT NULL,
`postcode` varchar(15) NOT NULL,
`country` smallint(3) unsigned NOT NULL,
PRIMARY KEY (`address_id`),
KEY `customer_id` (`customer_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_admin_error_log`;
CREATE TABLE `test_CubeCart_admin_error_log` (
`log_id` int(10) unsigned NOT NULL auto_increment,
`admin_id` int(10) unsigned NOT NULL,
`time` int(10) unsigned NOT NULL,
`message` text NOT NULL,
`read` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`log_id`),
KEY `admin_id` (`admin_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_admin_log`;
CREATE TABLE `test_CubeCart_admin_log` (
`log_id` int(10) unsigned NOT NULL auto_increment,
`admin_id` int(10) unsigned NOT NULL,
`time` int(10) unsigned NOT NULL,
`ip_address` varchar(45) NOT NULL,
`description` text NOT NULL,
PRIMARY KEY (`log_id`),
KEY `admin_id` (`admin_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_admin_users`;
CREATE TABLE `test_CubeCart_admin_users` (
`admin_id` int(10) unsigned NOT NULL auto_increment,
`customer_id` int(10) unsigned default NULL,
`status` tinyint(1) unsigned NOT NULL default '0',
`name` varchar(150) NOT NULL,
`username` varchar(150) NOT NULL,
`password` varchar(128) NOT NULL,
`salt` varchar(32) default NULL,
`new_password` tinyint(1) NOT NULL default '1',
`email` varchar(254) NOT NULL,
`verify` varchar(32) default NULL,
`logins` int(10) unsigned NOT NULL default '0',
`super_user` tinyint(1) NOT NULL default '0',
`notes` text,
`failLevel` tinyint(1) unsigned NOT NULL default '0',
`blockTime` int(10) unsigned NOT NULL default '0',
`lastTime` int(10) unsigned NOT NULL default '0',
`session_id` varchar(32) default NULL,
`browser` text,
`ip_address` varchar(45) default NULL COMMENT 'Supports IPv6 addresses',
`language` varchar(5) NOT NULL default 'en-US',
`dashboard_notes` text,
`order_notify` tinyint(1) unsigned default '0',
KEY `admin_id` (`admin_id`)
) TYPE=MyISAM ;
INSERT INTO `test_CubeCart_admin_users` VALUES
(1, NULL, 1, 'Website Owner', 'admin', '53d32a61ecbadee12f9455fb3ed4061ff0c5cf9ed2669610da0452e9870463666e4469a1edd61b0e16f80e0a833ac3ac5f09c215bd276ad2d028c0f4ebd45393', '543579ba', 1, 'noreply@installatron.com', NULL, 0, 1, NULL, 0, 0, 0, NULL, NULL, NULL, 'en-GB', NULL, 1);
DROP TABLE IF EXISTS `test_CubeCart_alt_shipping`;
CREATE TABLE `test_CubeCart_alt_shipping` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`status` smallint(1) NOT NULL default '0',
`byprice` smallint(1) NOT NULL,
`global` smallint(1) NOT NULL,
`notes` varchar(255) default NULL,
`order` int(10) unsigned default '0',
KEY `id` (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_alt_shipping_prices`;
CREATE TABLE `test_CubeCart_alt_shipping_prices` (
`id` int(10) unsigned NOT NULL auto_increment,
`alt_ship_id` int(10) unsigned NOT NULL,
`low` decimal(16,3) NOT NULL default '0.000',
`high` decimal(16,3) NOT NULL default '0.000',
`price` decimal(16,2) NOT NULL default '0.00',
KEY `id` (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_blocker`;
CREATE TABLE `test_CubeCart_blocker` (
`block_id` int(10) unsigned NOT NULL auto_increment,
`level` tinyint(3) unsigned NOT NULL default '1',
`last_attempt` int(10) unsigned NOT NULL default '0',
`ban_expires` int(10) unsigned NOT NULL default '0',
`username` text NOT NULL,
`location` char(1) NOT NULL,
`user_agent` text NOT NULL,
`ip_address` varchar(45) NOT NULL COMMENT 'Supports IPv6 addresses',
PRIMARY KEY (`block_id`),
KEY `location` (`location`),
KEY `last_attempt` (`last_attempt`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_category`;
CREATE TABLE `test_CubeCart_category` (
`cat_id` int(10) unsigned NOT NULL auto_increment,
`cat_name` varchar(100) NOT NULL,
`cat_desc` text,
`cat_parent_id` int(10) unsigned NOT NULL default '0',
`cat_image` varbinary(250) NOT NULL default '',
`per_ship` decimal(20,2) NOT NULL default '0.00',
`item_ship` decimal(20,2) NOT NULL default '0.00',
`item_int_ship` decimal(20,2) NOT NULL default '0.00',
`per_int_ship` decimal(20,2) NOT NULL default '0.00',
`hide` smallint(1) NOT NULL default '0',
`seo_meta_title` text NOT NULL,
`seo_meta_description` text NOT NULL,
`seo_meta_keywords` text NOT NULL,
`priority` smallint(6) unsigned NOT NULL default '0',
`status` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`cat_id`),
KEY `cat_parent_id` (`cat_parent_id`)
) TYPE=MyISAM ;
INSERT INTO `test_CubeCart_category` VALUES
(1, 'Test Category', 'This is a test category setup during install. It can be edited or deleted from the store admin control panel.', 0, '', '0.00', '0.00', '0.00', '0.00', 0, '', '', '', 1, 1);
DROP TABLE IF EXISTS `test_CubeCart_category_index`;
CREATE TABLE `test_CubeCart_category_index` (
`id` int(10) unsigned NOT NULL auto_increment,
`cat_id` int(10) unsigned NOT NULL default '0',
`product_id` int(10) unsigned NOT NULL default '0',
`primary` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `cat_id` (`cat_id`),
KEY `product_id` (`product_id`)
) TYPE=MyISAM ;
INSERT INTO `test_CubeCart_category_index` VALUES
(1, 1, 1, 1);
DROP TABLE IF EXISTS `test_CubeCart_category_language`;
CREATE TABLE `test_CubeCart_category_language` (
`translation_id` int(10) unsigned NOT NULL auto_increment,
`cat_id` int(10) unsigned NOT NULL default '0',
`language` varchar(5) default NULL,
`cat_name` varchar(255) default NULL,
`cat_desc` text NOT NULL,
`seo_meta_title` text,
`seo_meta_description` text,
`seo_meta_keywords` text,
`seo_custom_url` text,
KEY `id` (`translation_id`),
KEY `cat_master_id` (`cat_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_config`;
CREATE TABLE `test_CubeCart_config` (
`name` varchar(100) NOT NULL,
`array` text NOT NULL,
UNIQUE KEY `name` (`name`)
) TYPE=MyISAM;
INSERT INTO `test_CubeCart_config` VALUES
('Free_Shipping', 'a:2:{s:7:"trigger";s:0:"";s:9:"countries";s:0:"";}'),
('Print_Order_Form', 'a:16:{s:6:"status";s:1:"1";s:7:"default";s:1:"1";s:13:"multiCurrency";s:1:"1";s:4:"desc";s:17:"Postal Order Form";s:6:"cheque";s:1:"1";s:9:"payableTo";s:16:"Company Name Ltd";s:4:"card";s:1:"1";s:5:"cards";s:35:"Mastercard,Visa,Switch,Maestro,AMEX";s:4:"bank";s:1:"1";s:8:"bankName";s:13:"Your Bank Plc";s:7:"accName";s:12:"Company Name";s:8:"sortCode";s:8:"xx-xx-xx";s:4:"acNo";s:8:"xxxxxxxx";s:9:"swiftCode";s:8:"xxxxxxxx";s:7:"address";s:70:"Address Line 1\r\nAddress Line 2\r\nAddress Line 3\r\nAddress Line 4\r\nxxxxxx";s:5:"notes";s:44:"We can only accept payments in xxx currency.";}'),
('config', 'a:78:{s:19:"admin_notify_status";s:1:"2";s:10:"admin_skin";s:7:"default";s:10:"anon_stats";s:1:"1";s:32:"basket_allow_non_invoice_address";s:1:"1";s:14:"basket_jump_to";s:0:"";s:19:"basket_order_expire";s:0:"";s:28:"basket_out_of_stock_purchase";s:0:"";s:22:"basket_tax_by_delivery";s:0:"";s:5:"cache";s:1:"1";s:19:"cache_memcache_list";s:0:"";s:21:"catalogue_expand_tree";s:1:"1";s:21:"catalogue_hide_prices";s:0:"";s:25:"catalogue_latest_products";s:1:"1";s:31:"catalogue_latest_products_count";s:1:"8";s:14:"catalogue_mode";s:0:"";s:32:"catalogue_popular_products_count";s:2:"10";s:33:"catalogue_popular_products_source";s:1:"1";s:27:"catalogue_products_per_page";s:2:"10";s:20:"catalogue_sale_items";s:2:"10";s:19:"catalogue_sale_mode";s:0:"";s:25:"catalogue_sale_percentage";s:0:"";s:20:"catalogue_show_empty";s:1:"1";s:5:"debug";s:0:"";s:16:"default_currency";s:3:"USD";s:24:"default_directory_symbol";s:1:"/";s:16:"default_language";s:5:"en-US";s:16:"default_rss_feed";s:68:"http://forums.cubecart.com/rss/forums/1-cubecart-news-announcements/";s:14:"download_count";s:2:"10";s:20:"download_custom_path";s:0:"";s:15:"download_expire";s:5:"36000";s:13:"email_address";s:24:"noreply@installatron.com";s:12:"email_method";s:4:"mail";s:10:"email_name";s:23:"Primatech Paper Company";s:10:"email_smtp";s:0:"";s:15:"email_smtp_host";s:0:"";s:19:"email_smtp_password";s:0:"";s:15:"email_smtp_port";s:0:"";s:15:"email_smtp_user";s:0:"";s:14:"enable_reviews";s:1:"1";s:10:"enable_ssl";s:0:"";s:16:"google_analytics";s:0:"";s:12:"install_date";s:10:"1334788216";s:11:"license_key";s:0:"";s:7:"offline";s:0:"";s:19:"offline_allow_admin";s:1:"1";s:15:"offline_content";s:244:"PGRpdiBzdHlsZT0iZm9udC1mYW1pbHk6IGdlb3JnaWEsc2VyaWY7IHRleHQtYWxpZ246IGNlbnRlcjsiPjxwIHN0eWxlPSJmb250LXNpemU6IDE4cHg7Ij5TdG9yZSBpcyBjdXJyZW50bHkgb2ZmbGluZS48L3A+PHAgc3R5bGU9ImZvbnQtc2l6ZTogMTRweDsiPlBsZWFzZSB2aXNpdCBhZ2FpbiBzb29uLjwvcD48L2Rpdj4=";s:14:"product_precis";s:3:"120";s:26:"product_prices_include_tax";s:0:"";s:19:"product_weight_unit";s:2:"Lb";s:5:"proxy";s:0:"";s:10:"proxy_host";s:0:"";s:10:"proxy_port";s:0:"";s:9:"recaptcha";s:1:"1";s:3:"seo";s:1:"0";s:12:"seo_metadata";s:0:"";s:10:"seo_method";s:1:"0";s:14:"seo_trackbacks";s:0:"";s:18:"show_basket_weight";s:1:"1";s:11:"skin_change";s:0:"";s:11:"skin_folder";s:7:"kurouto";s:10:"skin_style";s:4:"blue";s:9:"ssl_force";s:0:"";s:8:"ssl_path";s:0:"";s:12:"standard_url";s:0:"";s:11:"stock_level";s:1:"0";s:16:"stock_warn_level";s:1:"5";s:13:"store_address";s:0:"";s:13:"store_country";s:0:"";s:22:"store_meta_description";s:0:"";s:19:"store_meta_keywords";s:0:"";s:10:"store_name";s:23:"Primatech Paper Company";s:14:"store_postcode";s:0:"";s:11:"store_title";s:23:"Primatech Paper Company";s:10:"store_zone";s:0:"";s:11:"time_format";s:15:"%d %b %Y, %H:%M";s:11:"time_offset";s:1:"0";s:9:"time_zone";s:3:"UTC";s:15:"verify_settings";s:1:"1";}');
DROP TABLE IF EXISTS `test_CubeCart_coupons`;
CREATE TABLE `test_CubeCart_coupons` (
`coupon_id` int(10) unsigned NOT NULL auto_increment,
`status` tinyint(1) unsigned NOT NULL default '1',
`archived` tinyint(1) unsigned NOT NULL default '0',
`code` varchar(25) NOT NULL,
`product_id` text NOT NULL,
`discount_percent` decimal(5,2) NOT NULL default '0.00',
`discount_price` decimal(16,2) NOT NULL default '0.00',
`expires` date NOT NULL,
`allowed_uses` int(10) unsigned NOT NULL default '0',
`min_subtotal` decimal(16,2) unsigned NOT NULL default '0.00',
`count` int(10) unsigned NOT NULL default '0',
`shipping` tinyint(1) unsigned NOT NULL default '0',
`description` text NOT NULL,
`cart_order_id` varchar(18) default NULL,
PRIMARY KEY (`coupon_id`),
UNIQUE KEY `code` (`code`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_currency`;
CREATE TABLE `test_CubeCart_currency` (
`currency_id` int(10) unsigned NOT NULL auto_increment,
`name` varbinary(255) NOT NULL default '',
`code` varchar(7) NOT NULL,
`iso` int(3) unsigned zerofill default NULL,
`symbol_left` varchar(10) default NULL,
`symbol_right` varchar(10) default NULL,
`value` decimal(10,5) NOT NULL default '0.00000',
`decimal_places` tinyint(2) unsigned default '2',
`updated` int(10) unsigned NOT NULL default '0',
`active` tinyint(1) unsigned NOT NULL default '0',
`symbol_decimal` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`currency_id`),
UNIQUE KEY `code` (`code`)
) TYPE=MyISAM ;
INSERT INTO `test_CubeCart_currency` VALUES
(1, 'United States dollar', 'USD', 840, '$', '', '1.00000', 2, 0, 1, 0),
(2, 'Japanese yen', 'JPY', 392, '¥', '', '81.44810', 0, 0, 1, 0),
(3, 'Bulgarian lev', 'BGN', 100, '', 'BGN', '1.49378', 2, 0, 0, 0),
(4, 'Czech koruna', 'CZK', 203, '', 'CZK', '18.95364', 2, 0, 0, 0),
(5, 'Danish krone', 'DKK', 208, 'kr', '', '5.68159', 2, 0, 0, 0),
(6, 'Estonian kroon', 'EEK', 233, 'kr', '', '0.00000', 2, 0, 0, 0),
(7, 'Pound Sterling', 'GBP', 826, '£', '', '0.62564', 2, 0, 1, 0),
(8, 'Hungarian forint', 'HUF', 348, 'Ft', '', '226.71657', 2, 0, 0, 0),
(9, 'Lithuanian litas', 'LTL', 440, 'Lt', '', '2.63713', 2, 0, 0, 0),
(10, 'Latvian lat', 'LVL', 428, 'Ls', '', '0.53372', 2, 0, 0, 0),
(11, 'Polish zloty', 'PLN', 985, 'zl', '', '3.19285', 2, 0, 0, 0),
(12, 'Romanian leu', 'RON', 642, 'lei', '', '3.34438', 2, 0, 0, 0),
(13, 'Swedish krona', 'SEK', 752, 'kr', '', '6.75934', 2, 0, 0, 0),
(14, 'Swiss franc', 'CHF', 756, 'CHF', '', '0.91896', 2, 0, 0, 0),
(15, 'Norwegian krone', 'NOK', 578, 'kr', '', '5.76835', 2, 0, 0, 0),
(16, 'Croatian kuna', 'HRK', 191, 'kn', '', '5.72046', 2, 0, 0, 0),
(17, 'Russian ruble', 'RUB', 643, '', 'RUB', '29.53639', 2, 0, 0, 0),
(18, 'Turkish lira', 'TRY', 792, 'YTL', '', '1.79149', 2, 0, 0, 0),
(19, 'Brazilian real', 'BRL', 986, 'R$', '', '1.86122', 2, 0, 0, 0),
(20, 'Canadian Dollar', 'CAD', 124, '$', '', '0.99030', 2, 0, 1, 0),
(21, 'Chinese yuan', 'CNY', 156, 'å…ƒ', '', '6.29863', 2, 0, 0, 0),
(22, 'Hong Kong dollar', 'HKD', 344, '圓', '', '7.76117', 2, 0, 0, 0),
(23, 'Mexican peso', 'MXN', 484, '$', '', '13.11899', 2, 0, 0, 0),
(24, 'Malaysian ringgit', 'MYR', 458, 'RM', '', '3.06347', 2, 0, 0, 0),
(25, 'New Zealand dollar', 'NZD', 554, '$', '', '1.22226', 2, 0, 0, 0),
(26, 'Philippine peso', 'PHP', 608, 'Php', '', '42.67624', 2, 0, 0, 0),
(27, 'Singapore dollar', 'SGD', 702, '$', '', '1.25113', 2, 0, 0, 0),
(28, 'Thai baht', 'THB', 764, '฿', '', '30.85007', 2, 0, 0, 0),
(29, 'South African rand', 'ZAR', 710, 'R', '', '7.82991', 2, 0, 0, 0),
(30, 'Euro', 'EUR', 978, '€', '', '0.76377', 2, 0, 1, 0),
(31, 'Australian Dollar', 'AUD', 036, '$', '', '0.96448', 2, 0, 1, 0);
DROP TABLE IF EXISTS `test_CubeCart_customer`;
CREATE TABLE `test_CubeCart_customer` (
`customer_id` int(10) unsigned NOT NULL auto_increment,
`email` varchar(254) NOT NULL,
`password` varchar(128) default NULL,
`salt` varchar(32) default NULL,
`new_password` tinyint(1) NOT NULL default '1',
`verify` varchar(32) default NULL,
`title` varchar(10) default NULL,
`first_name` varchar(150) NOT NULL,
`last_name` varchar(150) NOT NULL,
`country` tinyint(3) unsigned NOT NULL default '0',
`phone` varchar(20) NOT NULL,
`mobile` varchar(20) default NULL,
`status` tinyint(1) unsigned NOT NULL default '1',
`registered` int(10) unsigned NOT NULL default '0',
`ip_address` varchar(45) NOT NULL COMMENT 'Supports IPv6 addresses',
`order_count` int(10) unsigned default '0',
`type` tinyint(1) unsigned default '1',
`language` varchar(5) NOT NULL default 'en',
PRIMARY KEY (`customer_id`),
UNIQUE KEY `email` (`email`),
FULLTEXT KEY `fulltext` (`first_name`,`last_name`,`email`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_customer_group`;
CREATE TABLE `test_CubeCart_customer_group` (
`group_id` int(10) unsigned NOT NULL auto_increment,
`group_name` varchar(150) NOT NULL,
`group_description` text NOT NULL,
PRIMARY KEY (`group_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_customer_membership`;
CREATE TABLE `test_CubeCart_customer_membership` (
`membership_id` int(10) unsigned NOT NULL auto_increment,
`group_id` int(10) unsigned NOT NULL,
`customer_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`membership_id`),
KEY `group_id` (`group_id`),
KEY `customer_id` (`customer_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_documents`;
CREATE TABLE `test_CubeCart_documents` (
`doc_id` int(10) unsigned NOT NULL auto_increment,
`doc_parent_id` int(10) unsigned NOT NULL default '0',
`doc_status` tinyint(1) unsigned NOT NULL default '1',
`doc_order` int(10) unsigned NOT NULL default '0',
`doc_terms` tinyint(1) unsigned NOT NULL default '0',
`doc_home` tinyint(1) unsigned NOT NULL default '0',
`doc_lang` varchar(5) NOT NULL,
`doc_name` varchar(200) NOT NULL,
`doc_content` text NOT NULL,
`doc_url` varchar(200) default NULL,
`doc_url_openin` tinyint(1) unsigned default NULL,
`seo_meta_title` text NOT NULL,
`seo_meta_description` text NOT NULL,
`seo_meta_keywords` text NOT NULL,
`seo_custom_url` text NOT NULL,
PRIMARY KEY (`doc_id`),
KEY `doc_parent_id` (`doc_parent_id`)
) TYPE=MyISAM ;
INSERT INTO `test_CubeCart_documents` VALUES
(1, 0, 1, 1, 0, 1, 'en-GB', 'Welcome to CubeCart 5', 'This message can be edited with the Rich Text Editor which can be used to add vibrant content to help sell your products. This can be found on the admin side of your store under Documents.', NULL, NULL, '', '', '', ''),
(2, 0, 1, 2, 0, 0, 'en-GB', 'About Us', 'This can be managed under Documents in the admin control panel.', NULL, NULL, '', '', '', ''),
(3, 0, 1, 3, 1, 0, 'en-GB', 'Terms and Conditions', 'This can be managed under Documents in the admin control panel.', NULL, NULL, '', '', '', ''),
(4, 0, 1, 4, 0, 0, 'en-GB', 'Privacy Policy', 'This can be managed under Documents in the admin control panel.', NULL, NULL, '', '', '', '');
DROP TABLE IF EXISTS `test_CubeCart_downloads`;
CREATE TABLE `test_CubeCart_downloads` (
`digital_id` int(10) unsigned NOT NULL auto_increment,
`order_inv_id` int(10) unsigned NOT NULL,
`customer_id` int(10) unsigned NOT NULL default '0',
`cart_order_id` varchar(18) NOT NULL,
`downloads` int(10) unsigned NOT NULL default '0',
`expire` int(10) unsigned NOT NULL default '0',
`product_id` int(10) unsigned NOT NULL default '0',
`accesskey` varchar(32) NOT NULL,
KEY `id` (`digital_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_email_content`;
CREATE TABLE `test_CubeCart_email_content` (
`content_id` int(10) unsigned NOT NULL auto_increment,
`content_type` varchar(70) NOT NULL,
`language` varchar(5) NOT NULL,
`subject` varchar(250) NOT NULL,
`content_html` text NOT NULL,
`content_text` text NOT NULL,
PRIMARY KEY (`content_id`),
KEY `content_type` (`content_type`),
KEY `language` (`language`)
) TYPE=MyISAM ;
INSERT INTO `test_CubeCart_email_content` VALUES
(1, 'admin.password_recovery', 'de-DE', '\n Admin-Passwortwiederherstellung\n ', 'Sehr geehrte/r {$DATA.name},
\n um wieder Zugriff auf die Administrationsbedienkonsole des Shops zu bekommen, folgen Sie bitte dem nachfolgenden Link:
\n {$DATA.link}
\n Wenn der obige Link nicht funktioniert, kopieren Sie Ihn bitte in die Adressleiste Ihres Browsers.
', 'Sehr geehrte/r {$DATA.name},\n \n um wieder Zugriff auf die Administrationsbedienkonsole des Shops zu bekommen, folgen Sie bitte dem nachfolgenden Link:\n \n {$DATA.link}\n \n Wenn der obige Link nicht funktioniert, kopieren Sie ihn bitte in die Adressleiste Ihres Browsers.'),
(2, 'cart.order_complete', 'de-DE', '\n Bestellung fertiggestellt\n ', 'Hallo {$DATA.first_name},
\n wir freuen uns, Ihnen mitteilen zu können, dass Bestellung Nummer {$DATA.cart_order_id} fertiggestellt wurde. Wenn Sie materielle Waren bestellt haben, sollten sie in Kürze ankommen.
', 'Hallo {$DATA.first_name},\n \n wir freuen uns, Ihnen mitteilen zu können, dass Bestellung Nummer {$DATA.cart_order_id} fertiggestellt wurde. Wenn Sie materielle Waren bestellt haben, sollten sie in Kürze ankommen.'),
(3, 'cart.order_cancelled', 'de-DE', '\n Bestellung storniert\n ', 'Hallo {$DATA.first_name},
\n Bestellung Nummer {$DATA.cart_order_id} wurde storniert.
', 'Hallo {$DATA.first_name},\n \n Bestellung Nummer {$DATA.cart_order_id} wurde storniert.'),
(4, 'cart.order_confirmation', 'de-DE', '\n Bestätigung der Bestellung #{$DATA.cart_order_id}\n ', 'Danke, {$DATA.first_name}!
\n Ihre Bestellung {$DATA.cart_order_id}, die am {$DATA.order_date} aufgegeben wurde, ist bei uns eingegangen. Bitte bewahren Sie diese E-Mail für Ihre Unterlagen auf. Es ist möglich, den Status Ihrer Bestellung online einzusehen.
\n {$DATA.link}
\n \n \n Rechnungsadresse:
\n {$BILLING.first_name} {$BILLING.last_name}
\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}
\n {/if}\n {$BILLING.line1}
\n {if !empty({$BILLING.line2})}{$BILLING.line2}
\n {/if}\n {$BILLING.town}
\n {$BILLING.state}
\n {$BILLING.postcode}
\n {$BILLING.country}
\n {$BILLING.phone}
\n
\n E-Mail-Adresse:
\n {$BILLING.email} | \n Lieferadresse:
\n {$SHIPPING.first_name} {$SHIPPING.last_name}
\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}
\n {/if}{$SHIPPING.line1}
\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}
\n {/if}{$SHIPPING.town}
\n {$SHIPPING.state}
\n {$SHIPPING.postcode}
\n {$SHIPPING.country} | \n
\n
\n \n \n \n | Artikel | \n Menge | \n Preis | \n
\n \n \n {$product.name}
{$product.product_options} | \n {$product.quantity} | \n {$product.price} | \n
\n \n \n | | \n Versand: ({$DATA.ship_method}) | \n {$DATA.shipping} | \n
\n \n | | \n Rabatt: | \n {$DATA.discount} | \n
\n \n | | \n Zwischensumme: | \n {$DATA.subtotal} | \n
\n \n \n | | \n {$tax.tax_name}: ({$tax.tax_percent}%) | \n {$tax.tax_amount} | \n
\n \n \n | | \n Bestellsumme: | \n {$DATA.total} | \n
\n \n \n
', 'Danke, {$DATA.first_name}!\n \n Ihre Bestellung {$DATA.cart_order_id}, die am {$DATA.order_date} aufgegeben wurde, ist bei uns eingegangen. Bitte bewahren Sie diese E-Mail für Ihre Unterlagen auf. Es ist möglich, den Status Ihrer Bestellung online einzusehen. \n \n {$DATA.link}\n \n ----------------------------------------------------------------------\n Rechnungsadresse:\n {$BILLING.first_name} {$BILLING.last_name}\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}\n {/if}{$BILLING.line1}\n {if !empty({$BILLING.line2})}{$BILLING.line2}\n {/if}{$BILLING.town}\n {$BILLING.state}\n {$BILLING.postcode}\n {$BILLING.country}\n {$BILLING.phone}\n \n E-Mail-Adresse:\n {$BILLING.email}\n \n Lieferadresse:\n {$SHIPPING.first_name} {$SHIPPING.last_name}\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}\n {/if}{$SHIPPING.line1}\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}\n {/if}{$SHIPPING.town}\n {$SHIPPING.state}\n {$SHIPPING.postcode}\n {$SHIPPING.country}\n \n ----------------------------------------------------------------------\n Artikel in Ihrer Bestellung\n \n {foreach from=$PRODUCTS item=product}\n -----------------------------------\n {$product.name}\n {$product.product_options}\n \n Artikelnummer: {$product.product_code}\n Stückpreis: {$product.price}\n Menge: {$product.quantity}\n \n {/foreach}\n -----------------------------------\n Zwischensumme: {$DATA.subtotal}\n Rabatt: {$DATA.discount}\n Versand: {$DATA.shipping} ({$DATA.ship_method})\n {foreach from=$TAXES item=tax}{$tax.tax_name} ({$tax.tax_percent}%): {$tax.tax_amount}\n {/foreach}\n --------------------------\n Bestellsumme: {$DATA.total}\n =========================='),
(5, 'cart.payment_fraud', 'de-DE', '\n Problem mit Ihrer Bestellung\n ', 'Hallo {$DATA.first_name},
\n es tut uns sehr leid, aber wir waren nicht in der Lage, die Bezahlung für Bestellung {$DATA.cart_order_id} anzunehmen. Bitte wenden Sie sich jederzeit an einen unserer Mitarbeiter, wenn Sie Fragen haben.
', 'Hallo {$DATA.first_name},\n \n es tut uns sehr leid, aber wir waren nicht in der Lage, die Bezahlung für Bestellung {$DATA.cart_order_id} anzunehmen. Bitte wenden Sie sich jederzeit an einen unserer Mitarbeiter, wenn Sie Fragen haben.'),
(6, 'account.password_recovery', 'de-DE', '\n Passwortwiederherstellung\n ', 'Sehr geehrte/r {$DATA.first_name} {$DATA.last_name},
\n
\n klicken Sie bitte auf den nachfolgenden Link oder kopieren Sie die Adresse in die Adresszeile Ihres Browsers, um Ihr Passwort zurückzusetzen. Sobald Sie auf der Webseite sind, erhalten Sie die Anweisung, Ihr neues Passwort einzugeben und zu bestätigen.
\n
\n {$DATA.reset_link}
\n
\n Wenn Sie weitere Unterstützung bei der Rücksetzung Ihres Passworts brauchen, wenden Sie sich bitte an uns.
', 'Hallo {$DATA.first_name},\n \n klicken Sie bitte auf den nachfolgenden Link oder kopieren Sie die Adresse in die Adresszeile Ihres Browsers, um Ihr Passwort zurückzusetzen. Sobald Sie auf der Webseite sind, erhalten Sie die Anweisung, Ihr neues Passwort einzugeben und zu bestätigen.\n \n {$DATA.reset_link}\n \n Wenn Sie weitere Unterstützung bei der Rücksetzung Ihres Passworts brauchen, wenden Sie sich bitte an uns.'),
(7, 'admin.order_received', 'de-DE', '\n Neue Bestellung #{$DATA.cart_order_id}\n ', '{$DATA.first_name} {$DATA.last_name} {if !empty({$BILLING.company_name})}({$BILLING.company_name}){/if} hat soeben Bestellung Nummer {$DATA.cart_order_id} am {$DATA.order_date} aufgegeben.
\n Diese Bestellung kann online unter dem nachfolgenden Link verwaltet werden.
\n {$DATA.link}
\n \n \n Rechnungsadresse:
\n {$BILLING.first_name} {$BILLING.last_name}
\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}
\n {/if}\n {$BILLING.line1}
\n {if !empty({$BILLING.line2})}{$BILLING.line2}
\n {/if}\n {$BILLING.town}
\n {$BILLING.state}
\n {$BILLING.postcode}
\n {$BILLING.country}
\n {$BILLING.phone}
\n
\n E-Mail-Adresse:
\n {$BILLING.email} | \n Lieferadresse:
\n {$SHIPPING.first_name} {$SHIPPING.last_name}
\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}
\n {/if}{$SHIPPING.line1}
\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}
\n {/if}{$SHIPPING.town}
\n {$SHIPPING.state}
\n {$SHIPPING.postcode}
\n {$SHIPPING.country} | \n
\n
\n \n \n \n | Artikel | \n Menge | \n Preis | \n
\n \n \n {$product.name}
{$product.product_options} | \n {$product.quantity} | \n {$product.price} | \n
\n \n \n | | \n Versand: ({$DATA.ship_method}) | \n {$DATA.shipping} | \n
\n \n | | \n Rabatt: | \n {$DATA.discount} | \n
\n \n | | \n Zwischensumme: | \n {$DATA.subtotal} | \n
\n \n \n | | \n {$tax.tax_name}: ({$tax.tax_percent}%) | \n {$tax.tax_amount} | \n
\n \n \n | | \n Bestellsumme: | \n {$DATA.total} | \n
\n \n \n
', '{$DATA.first_name} {$DATA.last_name} {if !empty({$BILLING.company_name})}({$BILLING.company_name}){/if} hat soeben Bestellung Nummer {$DATA.cart_order_id} am {$DATA.order_date} aufgegeben.\n \n Diese Bestellung kann online unter dem nachfolgenden Link verwaltet werden.\n \n {$DATA.link}\n \n ----------------------------------------------------------------------\n Rechnungsadresse:\n {$BILLING.first_name} {$BILLING.last_name}\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}\n {/if}{$BILLING.line1}\n {if !empty({$BILLING.line2})}{$BILLING.line2}\n {/if}{$BILLING.town}\n {$BILLING.state}\n {$BILLING.postcode}\n {$BILLING.country}\n {$BILLING.phone}\n \n E-Mail-Adresse:\n {$BILLING.email}\n \n Lieferadresse:\n {$SHIPPING.first_name} {$SHIPPING.last_name}\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}\n {/if}{$SHIPPING.line1}\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}\n {/if}{$SHIPPING.town}\n {$SHIPPING.state}\n {$SHIPPING.postcode}\n {$SHIPPING.country}\n \n ----------------------------------------------------------------------\n Artikel in Ihrer Bestellung\n \n {foreach from=$PRODUCTS item=product}\n -----------------------------------\n {$product.name}\n {$product.product_options}\n \n Artikelnummer: {$product.product_code}\n Stückpreis: {$product.price}\n Menge: {$product.quantity}\n \n {/foreach}\n -----------------------------------\n Zwischensumme: {$DATA.subtotal}\n Rabatt: {$DATA.discount}\n Versand: {$DATA.shipping} ({$DATA.ship_method})\n {foreach from=$TAXES item=tax}{$tax.tax_name} ({$tax.tax_percent}%): {$tax.tax_amount}\n {/foreach}\n --------------------------\n Bestellsumme: {$DATA.total}\n =========================='),
(8, 'admin.review_added', 'de-DE', '\n Neue Produktrezension\n ', '{$DATA.name} hat eine neue Rezension/einen neuen Kommentar über ''{$DATA.product_name}'' eingeschickt. Sie/er kann unter dem nachfolgenden Link moderiert werden.\n Moderationslink:
{$DATA.link}
\n Rezensionstext:
{$DATA.review}
', '{$DATA.name} hat eine neue Rezension/einen neuen Kommentar über ''{$DATA.product_name}'' eingeschickt. Sie/er kann unter dem nachfolgenden Link moderiert werden.\n \n Moderationslink: \n {$DATA.link}\n Rezensionstext:\n {$DATA.review}'),
(9, 'cart.digital_download', 'de-DE', '\n Ihre gekauften Downloads\n ', 'Hallo {$DATA.first_name},
\n Ihre digitalen Dateien stehen jetzt zum Download bereit. Bitte benutzen Sie die nachfolgenden Links, um darauf zuzugreifen:
\n {foreach from=$DOWNLOADS item=download} \n {$download.name}: (Link verfällt am {$download.expire})
\n {$download.url}
\n {/foreach}\n Wenn die obigen Links nicht funktionieren, versuchen Sie bitte, sie in die Adressleiste Ihres Browsers zu kopieren. Sie können auf diese Dateien auch von Ihrem Kundenbereich unserer Webseite aus zugreifen.
\n
', 'Hallo {$DATA.first_name},\n \n Ihre digitalen Dateien stehen jetzt zum Download bereit. Bitte benutzen Sie die nachfolgenden Links, um darauf zuzugreifen:\n \n {foreach from=$DOWNLOADS item=download} \n {$download.name}: (Link verfällt am {$download.expire})\n {$download.url}\n {/foreach}\n \n Wenn die obigen Links nicht funktionieren, versuchen Sie bitte, sie in die Adressleiste Ihres Browsers zu kopieren. Sie können auf diese Dateien auch von Ihrem Kundenbereich unserer Webseite aus zugreifen.'),
(10, 'cart.gift_certificate', 'de-DE', '\n Ihr Geschenkgutschein\n ', 'Sehr geehrte/r {$DATA.name},
\n wir freuen uns, Ihnen diesen Gutschein zuschicken zu dürfen, mit dem Sie beliebige Artikel auf unserer Webseite kaufen können.
\n Viel Spaß beim Einkaufen!
\n Von: {$DATA.first_name} {$DATA.last_name}
\n Betrag: {$DATA.value}
\n Gutscheincode: {$DATA.code}
\n Nachricht des Schenkenden: {$DATA.message}
\n -------------------
\n Um diesen Geschenkgutschein einzulösen, geben Sie bitte an der Kasse den obigen "Gutscheincode" in das Textfeld mit der Aufschrift "Geschenkgutschein oder Gutschein hinzufügen" ein.
\n Lösen Sie ihn doch gleich ein!
', 'Sehr geehrte/r {$DATA.name},\n \n wir freuen uns, Ihnen diesen Gutschein zuschicken zu dürfen, mit dem Sie beliebige Artikel auf unserer Webseite kaufen können.\n \n Viel Spaß beim Einkaufen!\n \n Von: {$DATA.first_name} {$DATA.last_name}\n Betrag: {$DATA.value}\n Gutscheincode: {$DATA.code}\n Nachricht des Schenkenden: {$DATA.message}\n \n -------------------\n \n Um diesen Geschenkgutschein einzulösen, geben Sie bitte an der Kasse den obigen "Gutscheincode" in das Textfeld mit der Aufschrift "Geschenkgutschein oder Gutschein hinzufügen" ein.\n \n Lösen Sie ihn doch gleich ein!'),
(11, 'catalogue.tell_friend', 'de-DE', '\n {$DATA.from} hat etwas für Sie empfohlen\n ', 'Sehr geehrte/r{$DATA.to},\n Ihr Freund {$DATA.from} dachte, dass {$DATA.name} Sie vielleicht interessieren könnte.
\n Link zum Produkt: {$DATA.name}
\n {$DATA.message}
', 'Sehr geehrte/r {$DATA.to},\n \n Ihr Freund {$DATA.from} dachte, dass ''{$DATA.name}'' Sie vielleicht interessieren könnte.\n \n {$DATA.name}\n Link zum Produkt: {$DATA.link}\n \n {$DATA.message}'),
(12, 'cart.payment_received', 'de-DE', '\n Danke für Ihre Zahlung!\n ', 'Hallo {$DATA.first_name},
\n vielen Dank. Wir haben eine Zahlung von {$DATA.total} für Bestellung Nummer {$DATA.cart_order_id} erhalten.
', 'Hallo {$DATA.first_name},\n \n vielen Dank. Wir haben eine Zahlung von {$DATA.total} für Bestellung Nummer {$DATA.cart_order_id} erhalten.'),
(13, 'admin.password_recovery', 'en-GB', '\n Admin Password Recovery\n ', 'Dear {$DATA.name},
\n To regain access to the stores administration control panel. Please follow the link below:
\n {$DATA.link}
\n If the link above doesn''t work, please copy and paste it into your browser address bar.
', 'Dear {$DATA.name},\n \n To regain access to the stores administration control panel. Please follow the link below:\n \n {$DATA.link}\n \n If the link above doesn''t work, please copy and paste it into your browser address bar.'),
(14, 'cart.order_complete', 'en-GB', '\n Order Complete\n ', 'Hi {$DATA.first_name},
\n We are pleased to say that order number {$DATA.cart_order_id} is complete. If you have ordered physical goods they should arrive shortly.
', 'Hi {$DATA.first_name},\n \n We are pleased to say that order number {$DATA.cart_order_id} is complete. If you have ordered physical goods they should arrive shortly.'),
(15, 'cart.order_cancelled', 'en-GB', '\n Order Cancelled\n ', 'Hi {$DATA.first_name},
\n Order number {$DATA.cart_order_id} has been cancelled.
', 'Hi {$DATA.first_name},\n \n Order number {$DATA.cart_order_id} has been cancelled.'),
(16, 'cart.order_confirmation', 'en-GB', '\n Order Confirmation #{$DATA.cart_order_id}\n ', 'Thank You {$DATA.first_name}!
\n Your order {$DATA.cart_order_id} has been received which was placed on {$DATA.order_date}. Please keep this email for your records. It is possible to view the status of your order online.
\n {$DATA.link}
\n \n \n Billing address:
\n {$BILLING.first_name} {$BILLING.last_name}
\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}
\n {/if}\n {$BILLING.line1}
\n {if !empty({$BILLING.line2})}{$BILLING.line2}
\n {/if}\n {$BILLING.town}
\n {$BILLING.state}
\n {$BILLING.postcode}
\n {$BILLING.country}
\n {$BILLING.phone}
\n
\n Email:
\n {$BILLING.email} | \n Shipping address:
\n {$SHIPPING.first_name} {$SHIPPING.last_name}
\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}
\n {/if}{$SHIPPING.line1}
\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}
\n {/if}{$SHIPPING.town}
\n {$SHIPPING.state}
\n {$SHIPPING.postcode}
\n {$SHIPPING.country} | \n
\n
\n \n \n \n | Item | \n Quantity | \n Cost | \n
\n \n \n {$product.name}
{$product.product_options} | \n {$product.quantity} | \n {$product.price} | \n
\n \n \n | | \n Shipping: ({$DATA.ship_method}) | \n {$DATA.shipping} | \n
\n \n | | \n Discount: | \n {$DATA.discount} | \n
\n \n | | \n Subtotal: | \n {$DATA.subtotal} | \n
\n \n \n | | \n {$tax.tax_name}: ({$tax.tax_percent}%) | \n {$tax.tax_amount} | \n
\n \n \n | | \n Order Total: | \n {$DATA.total} | \n
\n \n \n
', 'Thank You {$DATA.first_name}!\n \n Your order {$DATA.cart_order_id} has been received which was placed on {$DATA.order_date}. Please keep this email for your records. It is possible to view the status of your order online. \n \n {$DATA.link}\n \n ----------------------------------------------------------------------\n Billing address:\n {$BILLING.first_name} {$BILLING.last_name}\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}\n {/if}{$BILLING.line1}\n {if !empty({$BILLING.line2})}{$BILLING.line2}\n {/if}{$BILLING.town}\n {$BILLING.state}\n {$BILLING.postcode}\n {$BILLING.country}\n {$BILLING.phone}\n \n Email:\n {$BILLING.email}\n \n Shipping address:\n {$SHIPPING.first_name} {$SHIPPING.last_name}\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}\n {/if}{$SHIPPING.line1}\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}\n {/if}{$SHIPPING.town}\n {$SHIPPING.state}\n {$SHIPPING.postcode}\n {$SHIPPING.country}\n \n ----------------------------------------------------------------------\n Items in Your Order\n \n {foreach from=$PRODUCTS item=product}\n -----------------------------------\n {$product.name}\n {$product.product_options}\n \n Part Number: {$product.product_code}\n Unit Price: {$product.price}\n Qty: {$product.quantity}\n \n {/foreach}\n -----------------------------------\n Subtotal: {$DATA.subtotal}\n Discount: {$DATA.discount}\n Shipping: {$DATA.shipping} ({$DATA.ship_method})\n {foreach from=$TAXES item=tax}{$tax.tax_name} ({$tax.tax_percent}%): {$tax.tax_amount}\n {/foreach}\n --------------------------\n Order Total: {$DATA.total}\n =========================='),
(17, 'cart.payment_fraud', 'en-GB', '\n Order Problem\n ', 'Hi {$DATA.first_name},
\n We are very sorry but we have not been able to accept the payment for order {$DATA.cart_order_id}. Please feel free to contact a member of staff if you have any questions.
', 'Hi {$DATA.first_name},\n \n We are very sorry but we have not been able to accept the payment for order {$DATA.cart_order_id}. Please feel free to contact a member of staff if you have any questions.'),
(18, 'account.password_recovery', 'en-GB', '\n Password Recovery\n ', 'Dear {$DATA.first_name} {$DATA.last_name},
\n
\n To reset your password, please click on the link below or copy and paste the address onto your web browser''s address window. Once you''re on the web page, you will be instructed to enter and confirm your new password.
\n
\n {$DATA.reset_link}
\n
\n If you require further assistance in resetting your password, please contact us.
', 'Hi {$DATA.first_name},\n \n To reset your password, please click on the link below or copy and paste the address onto your web browser''s address window. Once you''re on the web page, you will be instructed to enter and confirm your new password.\n \n {$DATA.reset_link}\n \n If you require further assistance in resetting your password, please contact us.'),
(19, 'admin.order_received', 'en-GB', '\n New Order #{$DATA.cart_order_id}\n ', '{$DATA.first_name} {$DATA.last_name} {if !empty({$BILLING.company_name})}({$BILLING.company_name}){/if} just placed order number {$DATA.cart_order_id} on {$DATA.order_date}.
\n This order can be managed online by following the link below.
\n {$DATA.link}
\n \n \n Billing address:
\n {$BILLING.first_name} {$BILLING.last_name}
\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}
\n {/if}\n {$BILLING.line1}
\n {if !empty({$BILLING.line2})}{$BILLING.line2}
\n {/if}\n {$BILLING.town}
\n {$BILLING.state}
\n {$BILLING.postcode}
\n {$BILLING.country}
\n {$BILLING.phone}
\n
\n Email:
\n {$BILLING.email} | \n Shipping address:
\n {$SHIPPING.first_name} {$SHIPPING.last_name}
\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}
\n {/if}{$SHIPPING.line1}
\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}
\n {/if}{$SHIPPING.town}
\n {$SHIPPING.state}
\n {$SHIPPING.postcode}
\n {$SHIPPING.country} | \n
\n
\n \n \n \n | Item | \n Quantity | \n Cost | \n
\n \n \n {$product.name}
{$product.product_options} | \n {$product.quantity} | \n {$product.price} | \n
\n \n \n | | \n Shipping: ({$DATA.ship_method}) | \n {$DATA.shipping} | \n
\n \n | | \n Discount: | \n {$DATA.discount} | \n
\n \n | | \n Subtotal: | \n {$DATA.subtotal} | \n
\n \n \n | | \n {$tax.tax_name}: ({$tax.tax_percent}%) | \n {$tax.tax_amount} | \n
\n \n \n | | \n Order Total: | \n {$DATA.total} | \n
\n \n \n
', '{$DATA.first_name} {$DATA.last_name} {if !empty({$BILLING.company_name})}({$BILLING.company_name}){/if} just placed order number {$DATA.cart_order_id} on {$DATA.order_date}.\n \n This order can be managed online by following the link below.\n \n {$DATA.link}\n \n ----------------------------------------------------------------------\n Billing address:\n {$BILLING.first_name} {$BILLING.last_name}\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}\n {/if}{$BILLING.line1}\n {if !empty({$BILLING.line2})}{$BILLING.line2}\n {/if}{$BILLING.town}\n {$BILLING.state}\n {$BILLING.postcode}\n {$BILLING.country}\n {$BILLING.phone}\n \n Email:\n {$BILLING.email}\n \n Shipping address:\n {$SHIPPING.first_name} {$SHIPPING.last_name}\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}\n {/if}{$SHIPPING.line1}\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}\n {/if}{$SHIPPING.town}\n {$SHIPPING.state}\n {$SHIPPING.postcode}\n {$SHIPPING.country}\n \n ----------------------------------------------------------------------\n Items in Your Order\n \n {foreach from=$PRODUCTS item=product}\n -----------------------------------\n {$product.name}\n {$product.product_options}\n \n Part Number: {$product.product_code}\n Unit Price: {$product.price}\n Qty: {$product.quantity}\n \n {/foreach}\n -----------------------------------\n Subtotal: {$DATA.subtotal}\n Discount: {$DATA.discount}\n Shipping: {$DATA.shipping} ({$DATA.ship_method})\n {foreach from=$TAXES item=tax}{$tax.tax_name} ({$tax.tax_percent}%): {$tax.tax_amount}\n {/foreach}\n --------------------------\n Order Total: {$DATA.total}\n =========================='),
(20, 'admin.review_added', 'en-GB', '\n New Product Review\n ', '{$DATA.name} has submit a new review/comment about ''{$DATA.product_name}''. This can be moderated following the link below.\n Moderation Link:
{$DATA.link}
\n Review Text:
{$DATA.review}
', '{$DATA.name} has submit a new review/comment about ''{$DATA.product_name}''. This can be moderated following the link below.\n \n Moderation Link: \n {$DATA.link}\n Review Text:\n {$DATA.review}'),
(21, 'cart.digital_download', 'en-GB', '\n Your Purchased Downloads\n ', 'Hi {$DATA.first_name},
\n Your digital files are now ready for download. Please use the links provided below to access them below:
\n {foreach from=$DOWNLOADS item=download} \n {$download.name}: (Link expires on {$download.expire})
\n {$download.url}
\n {/foreach}\n If the links above don''t work, please try copy and pasting them it into your browser address bar. You can also find access to these files from your the customer area of our website.
\n
', 'Hi {$DATA.first_name},\n \n Your digital files are now ready for download. Please use the links provided below to access them below:\n \n {foreach from=$DOWNLOADS item=download} \n {$download.name}: (Link expires on {$download.expire})\n {$download.url}\n {/foreach}\n \n If the links above don''t work, please try copy and pasting them it into your browser address bar. You can also find access to these files from your the customer area of our website.'),
(22, 'cart.gift_certificate', 'en-GB', '\n Your Gift Certificate\n ', 'Dear {$DATA.name},
\n We are please to be sending you this gift certificate which you can use towards the purchase of any item(s) on our website.
\n Happy shopping!
\n From: {$DATA.first_name} {$DATA.last_name}
\n Amount: {$DATA.value}
\n Claim Code: {$DATA.code}
\n Gift Message: {$DATA.message}
\n -------------------
\n To reedeem this gift certificate please enter the "Claim Code" above into the text field labeled "Add Gift Certificate or Coupon" during checkout.
\n Why not spend it now?
', 'Dear {$DATA.name},\n \n We are please to be sending you this gift certificate which you can use towards the purchase of any item(s) on our website.\n \n Happy shopping!\n \n From: {$DATA.first_name} {$DATA.last_name}\n Amount: {$DATA.value}\n Claim Code: {$DATA.code}\n Gift Message: {$DATA.message}\n \n -------------------\n \n To reedeem this gift certificate please enter the "Claim Code" above into the text field labeled "Add Gift Certificate or Coupon" during checkout.\n \n Why not spend it now?'),
(23, 'catalogue.tell_friend', 'en-GB', '\n {$DATA.from} has recommended something\n ', 'Dear {$DATA.to},\n Your friend {$DATA.from} thought that you might be interested in {$DATA.name}.
\n Product Link: {$DATA.name}
\n {$DATA.message}
', 'Dear {$DATA.to},\n \n Your friend {$DATA.from} thought that you might be interested in ''{$DATA.name}''.\n \n {$DATA.name}\n Product Link: {$DATA.link}\n \n {$DATA.message}'),
(24, 'cart.payment_received', 'en-GB', '\n Thank you for your payment!\n ', 'Hi {$DATA.first_name},
\n Thank you. We have received a payment of {$DATA.total} for order number {$DATA.cart_order_id}.
', 'Hi {$DATA.first_name},\n \n Thank you. We have received a payment of {$DATA.total} for order number {$DATA.cart_order_id}.'),
(25, 'admin.password_recovery', 'en-US', '\n Admin Password Recovery\n ', 'Dear {$DATA.name},
\n To regain access to the stores administration control panel. Please follow the link below:
\n {$DATA.link}
\n If the link above doesn''t work, please copy and paste it into your browser address bar.
', 'Dear {$DATA.name},\n \n To regain access to the stores administration control panel. Please follow the link below:\n \n {$DATA.link}\n \n If the link above doesn''t work, please copy and paste it into your browser address bar.'),
(26, 'cart.order_complete', 'en-US', '\n Order Complete\n ', 'Hi {$DATA.first_name},
\n We are pleased to say that order number {$DATA.cart_order_id} is complete. If you have ordered physical goods they should arrive shortly.
', 'Hi {$DATA.first_name},\n \n We are pleased to say that order number {$DATA.cart_order_id} is complete. If you have ordered physical goods they should arrive shortly.'),
(27, 'cart.order_cancelled', 'en-US', '\n Order Cancelled\n ', 'Hi {$DATA.first_name},
\n Order number {$DATA.cart_order_id} has been cancelled.
', 'Hi {$DATA.first_name},\n \n Order number {$DATA.cart_order_id} has been cancelled.'),
(28, 'cart.order_confirmation', 'en-US', '\n Order Confirmation #{$DATA.cart_order_id}\n ', 'Thank You {$DATA.first_name}!
\n Your order {$DATA.cart_order_id} has been received which was placed on {$DATA.order_date}. Please keep this email for your records. It is possible to view the status of your order online.
\n {$DATA.link}
\n \n \n Billing address:
\n {$BILLING.first_name} {$BILLING.last_name}
\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}
\n {/if}\n {$BILLING.line1}
\n {if !empty({$BILLING.line2})}{$BILLING.line2}
\n {/if}\n {$BILLING.town}
\n {$BILLING.state}
\n {$BILLING.postcode}
\n {$BILLING.country}
\n {$BILLING.phone}
\n
\n Email:
\n {$BILLING.email} | \n Shipping address:
\n {$SHIPPING.first_name} {$SHIPPING.last_name}
\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}
\n {/if}{$SHIPPING.line1}
\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}
\n {/if}{$SHIPPING.town}
\n {$SHIPPING.state}
\n {$SHIPPING.postcode}
\n {$SHIPPING.country} | \n
\n
\n \n \n \n | Item | \n Quantity | \n Cost | \n
\n \n \n {$product.name}
{$product.product_options} | \n {$product.quantity} | \n {$product.price} | \n
\n \n \n | | \n Shipping: ({$DATA.ship_method}) | \n {$DATA.shipping} | \n
\n \n | | \n Discount: | \n {$DATA.discount} | \n
\n \n | | \n Subtotal: | \n {$DATA.subtotal} | \n
\n \n \n | | \n {$tax.tax_name}: ({$tax.tax_percent}%) | \n {$tax.tax_amount} | \n
\n \n \n | | \n Order Total: | \n {$DATA.total} | \n
\n \n \n
', 'Thank You {$DATA.first_name}!\n \n Your order {$DATA.cart_order_id} has been received which was placed on {$DATA.order_date}. Please keep this email for your records. It is possible to view the status of your order online. \n \n {$DATA.link}\n \n ----------------------------------------------------------------------\n Billing address:\n {$BILLING.first_name} {$BILLING.last_name}\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}\n {/if}{$BILLING.line1}\n {if !empty({$BILLING.line2})}{$BILLING.line2}\n {/if}{$BILLING.town}\n {$BILLING.state}\n {$BILLING.postcode}\n {$BILLING.country}\n {$BILLING.phone}\n \n Email:\n {$BILLING.email}\n \n Shipping address:\n {$SHIPPING.first_name} {$SHIPPING.last_name}\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}\n {/if}{$SHIPPING.line1}\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}\n {/if}{$SHIPPING.town}\n {$SHIPPING.state}\n {$SHIPPING.postcode}\n {$SHIPPING.country}\n \n ----------------------------------------------------------------------\n Items in Your Order\n \n {foreach from=$PRODUCTS item=product}\n -----------------------------------\n {$product.name}\n {$product.product_options}\n \n Part Number: {$product.product_code}\n Unit Price: {$product.price}\n Qty: {$product.quantity}\n \n {/foreach}\n -----------------------------------\n Subtotal: {$DATA.subtotal}\n Discount: {$DATA.discount}\n Shipping: {$DATA.shipping} ({$DATA.ship_method})\n {foreach from=$TAXES item=tax}{$tax.tax_name} ({$tax.tax_percent}%): {$tax.tax_amount}\n {/foreach}\n --------------------------\n Order Total: {$DATA.total}\n =========================='),
(29, 'cart.payment_fraud', 'en-US', '\n Order Problem\n ', 'Hi {$DATA.first_name},
\n We are very sorry but we have not been able to accept the payment for order {$DATA.cart_order_id}. Please feel free to contact a member of staff if you have any questions.
', 'Hi {$DATA.first_name},\n \n We are very sorry but we have not been able to accept the payment for order {$DATA.cart_order_id}. Please feel free to contact a member of staff if you have any questions.'),
(30, 'account.password_recovery', 'en-US', '\n Password Recovery\n ', 'Dear {$DATA.first_name} {$DATA.last_name},
\n
\n To reset your password, please click on the link below or copy and paste the address onto your web browser''s address window. Once you''re on the web page, you will be instructed to enter and confirm your new password.
\n
\n {$DATA.reset_link}
\n
\n If you require further assistance in resetting your password, please contact us.
', 'Hi {$DATA.first_name},\n \n To reset your password, please click on the link below or copy and paste the address onto your web browser''s address window. Once you''re on the web page, you will be instructed to enter and confirm your new password.\n \n {$DATA.reset_link}\n \n If you require further assistance in resetting your password, please contact us.'),
(31, 'admin.order_received', 'en-US', '\n New Order #{$DATA.cart_order_id}\n ', '{$DATA.first_name} {$DATA.last_name} {if !empty({$BILLING.company_name})}({$BILLING.company_name}){/if} just placed order number {$DATA.cart_order_id} on {$DATA.order_date}.
\n This order can be managed online by following the link below.
\n {$DATA.link}
\n \n \n Billing address:
\n {$BILLING.first_name} {$BILLING.last_name}
\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}
\n {/if}\n {$BILLING.line1}
\n {if !empty({$BILLING.line2})}{$BILLING.line2}
\n {/if}\n {$BILLING.town}
\n {$BILLING.state}
\n {$BILLING.postcode}
\n {$BILLING.country}
\n {$BILLING.phone}
\n
\n Email:
\n {$BILLING.email} | \n Shipping address:
\n {$SHIPPING.first_name} {$SHIPPING.last_name}
\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}
\n {/if}{$SHIPPING.line1}
\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}
\n {/if}{$SHIPPING.town}
\n {$SHIPPING.state}
\n {$SHIPPING.postcode}
\n {$SHIPPING.country} | \n
\n
\n \n \n \n | Item | \n Quantity | \n Cost | \n
\n \n \n {$product.name}
{$product.product_options} | \n {$product.quantity} | \n {$product.price} | \n
\n \n \n | | \n Shipping: ({$DATA.ship_method}) | \n {$DATA.shipping} | \n
\n \n | | \n Discount: | \n {$DATA.discount} | \n
\n \n | | \n Subtotal: | \n {$DATA.subtotal} | \n
\n \n \n | | \n {$tax.tax_name}: ({$tax.tax_percent}%) | \n {$tax.tax_amount} | \n
\n \n \n | | \n Order Total: | \n {$DATA.total} | \n
\n \n \n
', '{$DATA.first_name} {$DATA.last_name} {if !empty({$BILLING.company_name})}({$BILLING.company_name}){/if} just placed order number {$DATA.cart_order_id} on {$DATA.order_date}.\n \n This order can be managed online by following the link below.\n \n {$DATA.link}\n \n ----------------------------------------------------------------------\n Billing address:\n {$BILLING.first_name} {$BILLING.last_name}\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}\n {/if}{$BILLING.line1}\n {if !empty({$BILLING.line2})}{$BILLING.line2}\n {/if}{$BILLING.town}\n {$BILLING.state}\n {$BILLING.postcode}\n {$BILLING.country}\n {$BILLING.phone}\n \n Email:\n {$BILLING.email}\n \n Shipping address:\n {$SHIPPING.first_name} {$SHIPPING.last_name}\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}\n {/if}{$SHIPPING.line1}\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}\n {/if}{$SHIPPING.town}\n {$SHIPPING.state}\n {$SHIPPING.postcode}\n {$SHIPPING.country}\n \n ----------------------------------------------------------------------\n Items in Your Order\n \n {foreach from=$PRODUCTS item=product}\n -----------------------------------\n {$product.name}\n {$product.product_options}\n \n Part Number: {$product.product_code}\n Unit Price: {$product.price}\n Qty: {$product.quantity}\n \n {/foreach}\n -----------------------------------\n Subtotal: {$DATA.subtotal}\n Discount: {$DATA.discount}\n Shipping: {$DATA.shipping} ({$DATA.ship_method})\n {foreach from=$TAXES item=tax}{$tax.tax_name} ({$tax.tax_percent}%): {$tax.tax_amount}\n {/foreach}\n --------------------------\n Order Total: {$DATA.total}\n =========================='),
(32, 'admin.review_added', 'en-US', '\n New Product Review\n ', '{$DATA.name} has submit a new review/comment about ''{$DATA.product_name}''. This can be moderated following the link below.\n Moderation Link:
{$DATA.link}
\n Review Text:
{$DATA.review}
', '{$DATA.name} has submit a new review/comment about ''{$DATA.product_name}''. This can be moderated following the link below.\n \n Moderation Link: \n {$DATA.link}\n Review Text:\n {$DATA.review}'),
(33, 'cart.digital_download', 'en-US', '\n Your Purchased Downloads\n ', 'Hi {$DATA.first_name},
\n Your digital files are now ready for download. Please use the links provided below to access them below:
\n {foreach from=$DOWNLOADS item=download} \n {$download.name}: (Link expires on {$download.expire})
\n {$download.url}
\n {/foreach}\n If the links above don''t work, please try copy and pasting them it into your browser address bar. You can also find access to these files from your the customer area of our website.
\n
', 'Hi {$DATA.first_name},\n \n Your digital files are now ready for download. Please use the links provided below to access them below:\n \n {foreach from=$DOWNLOADS item=download} \n {$download.name}: (Link expires on {$download.expire})\n {$download.url}\n {/foreach}\n \n If the links above don''t work, please try copy and pasting them it into your browser address bar. You can also find access to these files from your the customer area of our website.'),
(34, 'cart.gift_certificate', 'en-US', '\n Your Gift Certificate\n ', 'Dear {$DATA.name},
\n We are please to be sending you this gift certificate which you can use towards the purchase of any item(s) on our website.
\n Happy shopping!
\n From: {$DATA.first_name} {$DATA.last_name}
\n Amount: {$DATA.value}
\n Claim Code: {$DATA.code}
\n Gift Message: {$DATA.message}
\n -------------------
\n To reedeem this gift certificate please enter the "Claim Code" above into the text field labeled "Add Gift Certificate or Coupon" during checkout.
\n Why not spend it now?
', 'Dear {$DATA.name},\n \n We are please to be sending you this gift certificate which you can use towards the purchase of any item(s) on our website.\n \n Happy shopping!\n \n From: {$DATA.first_name} {$DATA.last_name}\n Amount: {$DATA.value}\n Claim Code: {$DATA.code}\n Gift Message: {$DATA.message}\n \n -------------------\n \n To reedeem this gift certificate please enter the "Claim Code" above into the text field labeled "Add Gift Certificate or Coupon" during checkout.\n \n Why not spend it now?');
INSERT INTO `test_CubeCart_email_content` VALUES
(35, 'catalogue.tell_friend', 'en-US', '\n {$DATA.from} has recommended something\n ', 'Dear {$DATA.to},\n Your friend {$DATA.from} thought that you might be interested in {$DATA.name}.
\n Product Link: {$DATA.name}
\n {$DATA.message}
', 'Dear {$DATA.to},\n \n Your friend {$DATA.from} thought that you might be interested in ''{$DATA.name}''.\n \n {$DATA.name}\n Product Link: {$DATA.link}\n \n {$DATA.message}'),
(36, 'cart.payment_received', 'en-US', '\n Thank you for your payment!\n ', 'Hi {$DATA.first_name},
\n Thank you. We have received a payment of {$DATA.total} for order number {$DATA.cart_order_id}.
', 'Hi {$DATA.first_name},\n \n Thank you. We have received a payment of {$DATA.total} for order number {$DATA.cart_order_id}.'),
(37, 'admin.password_recovery', 'es-ES', 'Recuperación de contraseña del Admin.', 'Estimado/a {$DATA.name},
\nPara poder volver a acceder al panel de control de administración de las tiendas. Por favor, siga el enlace siguiente:
\n{$DATA.link}
\nSi el enlace anterior no funciona, por favor, copie y péguelo en la barra de direcciones de su navegador.
', 'Estimado/a {$DATA.name},\n \nPara poder volver a acceder al panel de control de administración de las tiendas. Por favor, siga el enlace siguiente:\n \n{$DATA.link}\n \nSi el enlace anterior no funciona, por favor, copie y péguelo en la barra de direcciones de su navegador.'),
(38, 'cart.order_complete', 'es-ES', 'Pedido completado', 'Hola, {$DATA.first_name},
\nNos complace indicarle que el pedido número {$DATA.cart_order_id} ha sido completado. Si ha pedido mercancÃas fÃsicas, estas no tardarán en llegar.
', 'Hola, {$DATA.first_name},\n \nNos complace indicarle que el pedido número {$DATA.cart_order_id} ha sido completado. Si ha pedido mercancÃas fÃsicas, estas no tardarán en llegar.'),
(39, 'cart.order_cancelled', 'es-ES', 'Pedido cancelado', 'Hola, {$DATA.first_name},
\nEl pedido número {$DATA.cart_order_id} ha sido cancelado.
', 'Hola, {$DATA.first_name},\n \nEl pedido número {$DATA.cart_order_id} ha sido cancelado.'),
(40, 'cart.order_confirmation', 'es-ES', 'Confirmación de pedido #{$DATA.cart_order_id}', 'Muchas gracias, {$DATA.first_name}!
\nHemos recibido su pedido {$DATA.cart_order_id} que fue realizado el {$DATA.order_date}. Por favor, conserve este mensaje para sus registros. Puede ver el estado de su pedido en lÃnea.
\n{$DATA.link}
\n\n \n Dirección de facturación:
\n {$BILLING.first_name} {$BILLING.last_name}
\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}
\n {/if}\n {$BILLING.line1}
\n {if !empty({$BILLING.line2})}{$BILLING.line2}
\n {/if}\n {$BILLING.town}
\n {$BILLING.state}
\n {$BILLING.postcode}
\n {$BILLING.country}
\n {$BILLING.phone}
\n
\n Correo electrónico:
\n {$BILLING.email} | \n Dirección de envÃo:
\n {$SHIPPING.first_name} {$SHIPPING.last_name}
\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}
\n {/if}{$SHIPPING.line1}
\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}
\n {/if}{$SHIPPING.town}
\n {$SHIPPING.state}
\n {$SHIPPING.postcode}
\n {$SHIPPING.country} | \n
\n
\n\n \n \n | ArtÃculo | \n Cantidad | \n Coste | \n
\n \n \n {$product.name}
{$product.product_options} | \n {$product.quantity} | \n {$product.price} | \n
\n \n \n | | \n EnvÃo: ({$DATA.ship_method}) | \n {$DATA.shipping} | \n
\n \n | | \n Descuento: | \n {$DATA.discount} | \n
\n \n | | \n Subtotal: | \n {$DATA.subtotal} | \n
\n \n \n | | \n {$tax.tax_name}: ({$tax.tax_percent}%) | \n {$tax.tax_amount} | \n
\n \n \n | | \n Total del pedido: | \n {$DATA.total} | \n
\n \n \n
', 'Muchas gracias, {$DATA.first_name}!\n\nHemos recibido su pedido {$DATA.cart_order_id} que fue realizado el {$DATA.order_date}. Por favor, conserve este mensaje para sus registros. Puede ver el estado de su pedido en lÃnea. \n\n{$DATA.link}\n\n----------------------------------------------------------------------\nDirección de facturación:\n {$BILLING.first_name} {$BILLING.last_name}\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}\n {/if}{$BILLING.line1}\n {if !empty({$BILLING.line2})}{$BILLING.line2}\n {/if}{$BILLING.town}\n {$BILLING.state}\n {$BILLING.postcode}\n {$BILLING.country}\n {$BILLING.phone}\n\nCorreo electrónico:\n {$BILLING.email}\n\nDirección de envÃo:\n {$SHIPPING.first_name} {$SHIPPING.last_name}\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}\n {/if}{$SHIPPING.line1}\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}\n {/if}{$SHIPPING.town}\n {$SHIPPING.state}\n {$SHIPPING.postcode}\n {$SHIPPING.country}\n\n----------------------------------------------------------------------\nArtÃculos en su pedido\n\n{foreach from=$PRODUCTS item=product}\n-----------------------------------\n{$product.name}\n{$product.product_options}\n\n Número de pieza: {$product.product_code}\n Precio por unidad: {$product.price}\n Cdad.: {$product.quantity}\n\n{/foreach}\n-----------------------------------\n Subtotal: {$DATA.subtotal}\n Descuento: {$DATA.discount}\n EnvÃo: {$DATA.shipping} ({$DATA.ship_method})\n {foreach from=$TAXES item=tax}{$tax.tax_name} ({$tax.tax_percent}%): {$tax.tax_amount}\n {/foreach}\n --------------------------\n Total del pedido: {$DATA.total}\n =========================='),
(41, 'cart.payment_fraud', 'es-ES', 'Problema con el pedido', 'Hola, {$DATA.first_name},
\nLo sentimos mucho, pero no hemos podido aceptar el pago del pedido {$DATA.cart_order_id}. Por favor, no dude en contactar con un miembro de nuestro personal si tiene alguna pregunta.
', 'Hola, {$DATA.first_name},\n \nLo sentimos mucho, pero no hemos podido aceptar el pago del pedido {$DATA.cart_order_id}. Por favor, no dude en contactar con un miembro de nuestro personal si tiene alguna pregunta.'),
(42, 'account.password_recovery', 'es-ES', 'Recuperación de contraseña', 'Estimado/a {$DATA.first_name} {$DATA.last_name},
\n
\nPara borrar su contraseña y crear otra, haga clic en el siguiente vÃnculo o copie y pegue la dirección en la barra de direcciones de su navegador. Una vez que esté en la página web, recibirá instrucciones para introducir y confirmar su nueva contraseña.
\n
\n{$DATA.reset_link}
\n
\nSi necesita más ayuda para restablecer su contraseña, por favor, póngase en contacto con nosotros.
', 'Hola, {$DATA.first_name},\n \nPara borrar su contraseña y crear otra, haga clic en el siguiente vÃnculo o copie y pegue la dirección en la barra de direcciones de su navegador. Una vez que esté en la página web, recibirá instrucciones para introducir y confirmar su nueva contraseña.\n \n{$DATA.reset_link}\n \nSi necesita más ayuda para restablecer su contraseña, por favor, póngase en contacto con nosotros.'),
(43, 'admin.order_received', 'es-ES', 'Nuevo pedido #{$DATA.cart_order_id}', '{$DATA.first_name} {$DATA.last_name} {if !empty({$BILLING.company_name})}({$BILLING.company_name}){/if} acaba de realizar el pedido número {$DATA.cart_order_id} el {$DATA.order_date}.
\nEste pedido puede gestionarse en lÃnea siguiendo el enlace que aparece a continuación.
\n{$DATA.link}
\n\n \n Dirección de facturación:
\n {$BILLING.first_name} {$BILLING.last_name}
\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}
\n {/if}\n {$BILLING.line1}
\n {if !empty({$BILLING.line2})}{$BILLING.line2}
\n {/if}\n {$BILLING.town}
\n {$BILLING.state}
\n {$BILLING.postcode}
\n {$BILLING.country}
\n {$BILLING.phone}
\n
\n Correo electrónico:
\n {$BILLING.email} | \n Dirección de envÃo:
\n {$SHIPPING.first_name} {$SHIPPING.last_name}
\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}
\n {/if}{$SHIPPING.line1}
\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}
\n {/if}{$SHIPPING.town}
\n {$SHIPPING.state}
\n {$SHIPPING.postcode}
\n {$SHIPPING.country} | \n
\n
\n\n \n \n | ArtÃculo | \n Cantidad | \n Coste | \n
\n \n \n {$product.name}
{$product.product_options} | \n {$product.quantity} | \n {$product.price} | \n
\n \n \n | | \n EnvÃo: ({$DATA.ship_method}) | \n {$DATA.shipping} | \n
\n \n | | \n Descuento: | \n {$DATA.discount} | \n
\n \n | | \n Subtotal: | \n {$DATA.subtotal} | \n
\n \n \n | | \n {$tax.tax_name}: ({$tax.tax_percent}%) | \n {$tax.tax_amount} | \n
\n \n \n | | \n Total del pedido: | \n {$DATA.total} | \n
\n \n \n
', '{$DATA.first_name} {$DATA.last_name} {if !empty({$BILLING.company_name})}({$BILLING.company_name}){/if} acaba de realizar el pedido número {$DATA.cart_order_id} el {$DATA.order_date}.\n\nEste pedido puede gestionarse en lÃnea siguiendo el enlace que aparece a continuación.\n\n{$DATA.link}\n\n----------------------------------------------------------------------\nDirección de facturación:\n {$BILLING.first_name} {$BILLING.last_name}\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}\n {/if}{$BILLING.line1}\n {if !empty({$BILLING.line2})}{$BILLING.line2}\n {/if}{$BILLING.town}\n {$BILLING.state}\n {$BILLING.postcode}\n {$BILLING.country}\n {$BILLING.phone}\n\nCorreo electrónico:\n {$BILLING.email}\n\nDirección de envÃo:\n {$SHIPPING.first_name} {$SHIPPING.last_name}\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}\n {/if}{$SHIPPING.line1}\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}\n {/if}{$SHIPPING.town}\n {$SHIPPING.state}\n {$SHIPPING.postcode}\n {$SHIPPING.country}\n\n----------------------------------------------------------------------\nArtÃculos en su pedido\n\n{foreach from=$PRODUCTS item=product}\n-----------------------------------\n{$product.name}\n{$product.product_options}\n\n Número de pieza: {$product.product_code}\n Precio por unidad: {$product.price}\n Cdad.: {$product.quantity}\n\n{/foreach}\n-----------------------------------\n Subtotal: {$DATA.subtotal}\n Descuento: {$DATA.discount}\n EnvÃo: {$DATA.shipping} ({$DATA.ship_method})\n {foreach from=$TAXES item=tax}{$tax.tax_name} ({$tax.tax_percent}%): {$tax.tax_amount}\n {/foreach}\n --------------------------\n Total del pedido: {$DATA.total}\n =========================='),
(44, 'admin.review_added', 'es-ES', 'Nueva opinión sobre un producto', '{$DATA.name} ha enviado una nueva opinión/comentario sobre ''{$DATA.product_name}''. Puede ser moderado siguiendo el enlace que aparece a continuación.\nEnlace de moderación:
{$DATA.link}
\nTexto de la opinión:
{$DATA.review}
', '{$DATA.name} ha enviado una nueva opinión/comentario sobre ''{$DATA.product_name}''. Puede ser moderado siguiendo el enlace que aparece a continuación.\n \nEnlace de moderación: \n{$DATA.link}\nTexto de la opinión:\n{$DATA.review}'),
(45, 'cart.digital_download', 'es-ES', 'Sus descargas compradas', 'Hola, {$DATA.first_name},
\nSus archivos digitales están listos para su descarga. Por favor, utilice los enlaces que se proporcionan a continuación para acceder a ellos:
\n{foreach from=$DOWNLOADS item=download} \n{$download.name}: (El enlace caduca en {$download.expire})
\n{$download.url}
\n{/foreach}\nSi los enlaces anteriores no funcionan, por favor, intente copiar y pegar las direcciones en la barra de direcciones de su navegador. También puede encontrar acceso a estos archivos desde el área del cliente de su sitio web.
\n
', 'Hola, {$DATA.first_name},\n \nSus archivos digitales están listos para su descarga. Por favor, utilice los enlaces que se proporcionan a continuación para acceder a ellos:\n \n{foreach from=$DOWNLOADS item=download} \n{$download.name}: (El enlace caduca en {$download.expire})\n{$download.url}\n{/foreach}\n \nSi los enlaces anteriores no funcionan, por favor, intente copiar y pegar las direcciones en la barra de direcciones de su navegador. También puede encontrar acceso a estos archivos desde el área del cliente de su sitio web.'),
(46, 'cart.gift_certificate', 'es-ES', 'Su certificado de regalo', 'Estimado/a {$DATA.name},
\nNos complace enviarle este certificado de regalo que podrá utilizar para la compra de cualquier artÃculo de nuestro sitio web.
\n¡Feliz compra!
\nDe: {$DATA.first_name} {$DATA.last_name}
\nImporte: {$DATA.value}
\nCódigo del certificado: {$DATA.code}
\nMensaje del regalo: {$DATA.message}
\n-------------------
\nPara canjear este ceritficado de regalo, por favor, introduzca el "Código del certificado" que aparece más arriba en el campo de texto con la etiqueta "Añadir Certificado o Cupón de regalo" durante el paso por caja.
\n¿Por qué no gastarlo ahora mismo?
', 'Estimado/a {$DATA.name},\n \nNos complace enviarle este certificado de regalo que podrá utilizar para la compra de cualquier artÃculo de nuestro sitio web.\n \n¡Felices compras!\n \nDe: {$DATA.first_name} {$DATA.last_name}\nImporte: {$DATA.value}\nCódigo del certificado: {$DATA.code}\nMensaje del regalo: {$DATA.message}\n \n-------------------\n \nParra canjear este certificado de regalo, por favor, introduzca el "Código del certificado" que aparece más arriba en el campo de texto con la etiqueta "Añadir Certificado o Cupón de regalo" durante el paso por caja.\n \n¿Por qué no gastarlo ahora mismo?'),
(47, 'catalogue.tell_friend', 'es-ES', '{$DATA.from} ha recomendado algo', 'Estimado/a {$DATA.to},\nSu amigo/a {$DATA.from} pensó que quizá le interesarÃa {$DATA.name}.
\nEnlace al producto: {$DATA.name}
\n{$DATA.message}
', 'Estimado/a {$DATA.to},\n \nSu amigo/a {$DATA.from} pensó que quizá le interesarÃa ''{$DATA.name}''.\n \n{$DATA.name}\nEnlace al producto: {$DATA.link}\n \n{$DATA.message}'),
(48, 'cart.payment_received', 'es-ES', '¡Gracias por su pago!', 'Hola, {$DATA.first_name},
\nGracias. Hemos recibido un pago de {$DATA.total} correspondiente al pedido número {$DATA.cart_order_id}.
', 'Hola, {$DATA.first_name},\n \nGracias. Hemos recibido un pago de {$DATA.total} correspondiente al pedido número {$DATA.cart_order_id}.'),
(49, 'admin.password_recovery', 'fr-FR', 'Récupération du mot de passe Admin', 'Cher {$DATA.name},
\nPour avoir à nouveau accès au panneau de contrôle d''administration des boutiques. Veuillez suivre le lien ci-dessous :
\n{$DATA.link}
\nSi le lien ci-dessus ne fonctionne pas, veuillez le copier et coller dans la barre d''adresse de votre navigateur.
', 'Cher {$DATA.name},\n \nPour avoir à nouveau accès au panneau de contrôle d''administration des boutiques. Veuillez suivre le lien ci-dessous :\n \n{$DATA.link}\n \nSi le lien ci-dessus ne fonctionne pas, veuillez le copier et coller dans la barre d''adresse de votre navigateur.'),
(50, 'cart.order_complete', 'fr-FR', 'Commande terminée', 'Bonjour {$DATA.first_name},
\nNous sommes ravis de vous indiquer votre numéro de commande {$DATA.cart_order_id} est complet. Si vous avez commandé des biens physiques, ils devraient arriver sous peu.
', 'Bonjour {$DATA.first_name},\n \nNous sommes ravis de vous indiquer votre numéro de commande {$DATA.cart_order_id} est complet. Si vous avez commandé des biens physiques, ils devraient arriver sous peu.'),
(51, 'cart.order_cancelled', 'fr-FR', 'Commande annulée', 'Bonjour {$DATA.first_name},
\nNuméro de commande {$DATA.cart_order_id} a été annulé.
', 'Bonjour {$DATA.first_name},\n \nNuméro de commande {$DATA.cart_order_id} a été annulé.'),
(52, 'cart.order_confirmation', 'fr-FR', 'Confirmation de commande #{$DATA.cart_order_id}', 'Merci {$DATA.first_name}!
\nVotre commande {$DATA.cart_order_id} a bien été reçue et a été effectuée le {$DATA.order_date}. Veuillez conserver cet e-mail pour vos archives. Il est possible de voir le statut de votre commande en ligne.
\n{$DATA.link}
\n\n \n Adresse de facturation :
\n {$BILLING.first_name} {$BILLING.last_name}
\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}
\n {/if}\n {$BILLING.line1}
\n {if !empty({$BILLING.line2})}{$BILLING.line2}
\n {/if}\n {$BILLING.town}
\n {$BILLING.state}
\n {$BILLING.postcode}
\n {$BILLING.country}
\n {$BILLING.phone}
\n
\n E-mail :
\n {$BILLING.email} | \n Adresse de livraison :
\n {$SHIPPING.first_name} {$SHIPPING.last_name}
\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}
\n {/if}{$SHIPPING.line1}
\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}
\n {/if}{$SHIPPING.town}
\n {$SHIPPING.state}
\n {$SHIPPING.postcode}
\n {$SHIPPING.country} | \n
\n
\n\n \n \n | Article | \n Quantité | \n Coût | \n
\n \n \n {$product.name}
{$product.product_options} | \n {$product.quantity} | \n {$product.price} | \n
\n \n \n | | \n Livraison : ({$DATA.ship_method}) | \n {$DATA.shipping} | \n
\n \n | | \n Remise : | \n {$DATA.discount} | \n
\n \n | | \n Sous-total : | \n {$DATA.subtotal} | \n
\n \n \n | | \n {$tax.tax_name}: ({$tax.tax_percent}%) | \n {$tax.tax_amount} | \n
\n \n \n | | \n Total de la commande : | \n {$DATA.total} | \n
\n \n \n
', 'Merci {$DATA.first_name}!\n\nVotre commande {$DATA.cart_order_id} a bien été reçue et a été effectuée le {$DATA.order_date}. Veuillez conserver cet e-mail pour vos archives. Il est possible de voir le statut de votre commande en ligne. \n\n{$DATA.link}\n\n----------------------------------------------------------------------\nAdresse de facturation :\n {$BILLING.first_name} {$BILLING.last_name}\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}\n {/if}{$BILLING.line1}\n {if !empty({$BILLING.line2})}{$BILLING.line2}\n {/if}{$BILLING.town}\n {$BILLING.state}\n {$BILLING.postcode}\n {$BILLING.country}\n {$BILLING.phone}\n\nE-mail :\n {$BILLING.email}\n\nAdresse de livraison :\n {$SHIPPING.first_name} {$SHIPPING.last_name}\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}\n {/if}{$SHIPPING.line1}\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}\n {/if}{$SHIPPING.town}\n {$SHIPPING.state}\n {$SHIPPING.postcode}\n {$SHIPPING.country}\n\n----------------------------------------------------------------------\nArticles de votre commande\n\n{foreach from=$PRODUCTS item=product}\n-----------------------------------\n{$product.name}\n{$product.product_options}\n\n Code article : {$product.product_code}\n Prix unitaire : {$product.price}\n Qté : {$product.quantity}\n\n{/foreach}\n-----------------------------------\n Sous-total : {$DATA.subtotal}\n Remise : {$DATA.discount}\n Livraison : {$DATA.shipping} ({$DATA.ship_method})\n {foreach from=$TAXES item=tax}{$tax.tax_name} ({$tax.tax_percent}%): {$tax.tax_amount}\n {/foreach}\n --------------------------\n Total de la commande : {$DATA.total}\n =========================='),
(53, 'cart.payment_fraud', 'fr-FR', 'Problème de la commande', 'Bonjour {$DATA.first_name},
\nNous sommes désolés mais nous ne pouvons pas accepter le paiement pour la commande {$DATA.cart_order_id}. N''hésitez pas à contacter un membre du personnel si vous avez des questions.
', 'Bonjour {$DATA.first_name},\n \nNous sommes désolés mais nous ne pouvons pas accepter le paiement pour la commande {$DATA.cart_order_id}. N''hésitez pas à contacter un membre du personnel si vous avez des questions.'),
(54, 'account.password_recovery', 'fr-FR', 'Récupération du mot de passe', '
Cher {$DATA.first_name} {$DATA.last_name},
\n
\nPour réinitialiser votre mot de passe, veuillez cliquer sur le lien ci-dessous ou copier et coller l''adresse dans la fenêtre d''adresse de votre navigateur Web. Une fois que vous êtes sur la page Web, il vous sera demandé d''entrer et de confirmer votre nouveau mot de passe.
\n
\n{$DATA.reset_link}
\n
\nSi vous avez besoin davantage d''assistance pour la réinitialisation de votre mot de passe, veuillez nous contacter.
', 'Bonjour {$DATA.first_name},\n \nPour réinitialiser votre mot de passe, veuillez cliquer sur le lien ci-dessous ou copier et coller l''adresse dans la fenêtre d''adresse de votre navigateur Web. Une fois que vous êtes sur la page Web, il vous sera demandé d''entrer et de confirmer votre nouveau mot de passe.\n \n{$DATA.reset_link}\n \nSi vous avez besoin davantage d''assistance pour la réinitialisation de votre mot de passe, veuillez nous contacter.'),
(55, 'admin.order_received', 'fr-FR', 'Nouvelle commande #{$DATA.cart_order_id}', '{$DATA.first_name} {$DATA.last_name} {if !empty({$BILLING.company_name})}({$BILLING.company_name}){/if} vient juste d''être passée, numéro de commande {$DATA.cart_order_id} on {$DATA.order_date}.
\nCette commande peut être gérée en ligne en suivant le lien suivant.
\n{$DATA.link}
\n\n \n Adresse de facturation :
\n {$BILLING.first_name} {$BILLING.last_name}
\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}
\n {/if}\n {$BILLING.line1}
\n {if !empty({$BILLING.line2})}{$BILLING.line2}
\n {/if}\n {$BILLING.town}
\n {$BILLING.state}
\n {$BILLING.postcode}
\n {$BILLING.country}
\n {$BILLING.phone}
\n
\n E-mail :
\n {$BILLING.email} | \n Adresse de livraison :
\n {$SHIPPING.first_name} {$SHIPPING.last_name}
\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}
\n {/if}{$SHIPPING.line1}
\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}
\n {/if}{$SHIPPING.town}
\n {$SHIPPING.state}
\n {$SHIPPING.postcode}
\n {$SHIPPING.country} | \n
\n
\n\n \n \n | Article | \n Quantité | \n Coût | \n
\n \n \n {$product.name}
{$product.product_options} | \n {$product.quantity} | \n {$product.price} | \n
\n \n \n | | \n Livraison : ({$DATA.ship_method}) | \n {$DATA.shipping} | \n
\n \n | | \n Remise : | \n {$DATA.discount} | \n
\n \n | | \n Sous-total : | \n {$DATA.subtotal} | \n
\n \n \n | | \n {$tax.tax_name}: ({$tax.tax_percent}%) | \n {$tax.tax_amount} | \n
\n \n \n | | \n Total de la commande : | \n {$DATA.total} | \n
\n \n \n
', '{$DATA.first_name} {$DATA.last_name} {if !empty({$BILLING.company_name})}({$BILLING.company_name}){/if} numéro de commande juste passé {$DATA.cart_order_id} on {$DATA.order_date}.\n\nCette commande peut être gérée en ligne en suivant le lien ci-dessous.\n\n{$DATA.link}\n\n----------------------------------------------------------------------\nAdresse de facturation :\n {$BILLING.first_name} {$BILLING.last_name}\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}\n {/if}{$BILLING.line1}\n {if !empty({$BILLING.line2})}{$BILLING.line2}\n {/if}{$BILLING.town}\n {$BILLING.state}\n {$BILLING.postcode}\n {$BILLING.country}\n {$BILLING.phone}\n\nE-mail :\n {$BILLING.email}\n\nAdresse de livraison :\n {$SHIPPING.first_name} {$SHIPPING.last_name}\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}\n {/if}{$SHIPPING.line1}\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}\n {/if}{$SHIPPING.town}\n {$SHIPPING.state}\n {$SHIPPING.postcode}\n {$SHIPPING.country}\n\n----------------------------------------------------------------------\nArticles de votre commande\n\n{foreach from=$PRODUCTS item=product}\n-----------------------------------\n{$product.name}\n{$product.product_options}\n\n Code article : {$product.product_code}\n Prix unitaire : {$product.price}\n Qté : {$product.quantity}\n\n{/foreach}\n-----------------------------------\n Sous-total : {$DATA.subtotal}\n Remise : {$DATA.discount}\n Livraison : {$DATA.shipping} ({$DATA.ship_method})\n {foreach from=$TAXES item=tax}{$tax.tax_name} ({$tax.tax_percent}%): {$tax.tax_amount}\n {/foreach}\n --------------------------\n Total de la commande : {$DATA.total}\n =========================='),
(56, 'admin.review_added', 'fr-FR', 'Avis relatif au nouveau produit', '{$DATA.name} a soumis un nouvel avis/commentaire sur ''{$DATA.product_name}''. Cette commande peut être modérée en suivant le lien ci-dessous.\nLien de modération :
{$DATA.link}
\nTexte de l''avis :
{$DATA.review}
', '{$DATA.name} a soumis un nouvel avis/commentaire sur ''{$DATA.product_name}''. Cette commande peut être modérée en suivant le lien ci-dessous.\n \nLien de modération : \n{$DATA.link}\nTexte de l''avis :\n{$DATA.review}'),
(57, 'cart.digital_download', 'fr-FR', 'Vos téléchargements achetés', 'Bonjour {$DATA.first_name},
\nVos fichiers numériques sont désormais prêts pour le téléchargement. Veuillez utiliser les liens fournis ci-dessous pour y accéder ensuite :
\n{foreach from=$DOWNLOADS item=download} \n{$download.name}: (Lien expire le {$download.expire})
\n{$download.url}
\n{/foreach}\nSi les liens ci-dessus ne fonctionnent pas, veuillez essayer de les copier et coller dans la barre d''adresse de votre navigateur. Vous pouvez également accéder à ces fichiers à partir de votre espace client de notre site Web.
\n
', 'Bonjour {$DATA.first_name},\n \nVos fichiers numériques sont désormais prêts pour le téléchargement. Veuillez utiliser les liens fournis ci-dessous pour y accéder ensuite :\n \n{foreach from=$DOWNLOADS item=download} \n{$download.name}: (Lien expire le {$download.expire})\n{$download.url}\n{/foreach}\n \nSi les liens ci-dessus ne fonctionnent pas, veuillez essayer de les copier et coller dans la barre d''adresse de votre navigateur. Vous pouvez également accéder à ces fichiers à partir de votre espace client de notre site Web.'),
(58, 'cart.gift_certificate', 'fr-FR', 'Votre bon-cadeau', 'Cher{$DATA.name},
\nNous sommes ravis de vous envoyer ce bon-cadeau que vous pouvez utiliser pour l''achat d''un/des article(s) sur notre site Web.
\nBon shopping !
\nDe : {$DATA.first_name} {$DATA.last_name}
\nMontant : {$DATA.value}
\nCode du bon-cadeau : {$DATA.code}
\nMessage cadeau : {$DATA.message}
\n-------------------
\nPour utiliser ce bon-cadeau, veuillez entrer le "code" figurant sur ce dernier ci-dessus dans le champ texte appelé "Ajouter bon-certificat ou coupon" lors du passage en caisse.
\nPourquoi ne pas l''utiliser maintenant ?
', 'Cher {$DATA.name},\n \nNous sommes ravis de vous envoyer ce bon-cadeau que vous pouvez utiliser pour l''achat d''un/des article(s) sur notre site Web.\n \nBon shopping !\n \nDe : {$DATA.first_name} {$DATA.last_name}\nMontant : {$DATA.value}\nCode du bon-cadeau : {$DATA.code}\nMessage cadeau : {$DATA.message}\n \n-------------------\n \nPour utiliser ce bon-cadeau, veuillez entrer le « code bon-cadeau » ci-dessus dans le champ texte appelé « Ajouter bon-certificat ou coupon » lors du passage en caisse.\n \nPourquoi ne pas l''utiliser maintenant ?'),
(59, 'catalogue.tell_friend', 'fr-FR', '{$DATA.from} a recommandé quelque chose', 'Cher {$DATA.to},\nVotre ami {$DATA.from} a pensé que vous pourriez être intéressé par {$DATA.name}.
\nLien du produit : {$DATA.name}
\n{$DATA.message}
', 'Cher {$DATA.to},\n \nVotre ami {$DATA.from} a pensé que vous pourriez être intéressé par ''{$DATA.name}''.\n \n{$DATA.name}\nLien du produit : {$DATA.link}\n \n{$DATA.message}'),
(60, 'cart.payment_received', 'fr-FR', 'Merci pour votre paiement !', 'Bonjour {$DATA.first_name},
\nMerci. Nous avons reçu un paiement de {$DATA.total} pour le numéro de commande {$DATA.cart_order_id}.
', 'Bonjour {$DATA.first_name},\n \nMerci. Nous avons reçu un paiement de {$DATA.total} pour le numéro de commande {$DATA.cart_order_id}.'),
(61, 'admin.password_recovery', 'nl-NL', '\n Beheerders Wachtwoord Herstellen \n ', 'Beste {$DATA.name},
\n Klik op onderstaande link om weer toegang te krijgen tot het beheerders bedieningspaneel:
\n {$DATA.link}
\n Kopieer en plak bovenstaande link in de adresbalk van uw browser, mits de link niet werkt.
', 'Beste {$DATA.name},\n \n Klik op onderstaande link om weer toegang te krijgen tot het beheerders bedieningspaneel:\n \n {$DATA.link}\n \n Kopieer en plak bovenstaande link in de adresbalk van uw browser, mits de link niet werkt.'),
(62, 'cart.order_complete', 'nl-NL', '\n Bestelling voltooid \n ', 'Hallo {$DATA.first_name},
\n Het verheugd ons om te vertellen dat order nummer {$DATA.cart_order_id} is voltooid. Wanneer u een fysiek product heeft besteld dan zal deze binnenkort arriveren.
', 'Hallo {$DATA.first_name},\n \n Het verheugd ons om te vertellen dat order nummer {$DATA.cart_order_id} is voltooid. Wanneer u een fysiek product heeft besteld dan zal deze binnenkort arriveren.'),
(63, 'cart.order_cancelled', 'nl-NL', '\n Bestelling geannuleerd \n ', 'Hallo {$DATA.first_name},
\n Bestelnummer {$DATA.cart_order_id} is geannuleerd.
', 'Hallo {$DATA.first_name},\n \n Bestelnummer {$DATA.cart_order_id} is geannuleerd.'),
(64, 'cart.order_confirmation', 'nl-NL', '\n Bestellingsbevestiging #{$DATA.cart_order_id} \n ', 'Bedankt {$DATA.first_name}!
\n uw bestelling {$DATA.cart_order_id} is ontvangen en is geplaatst op {$DATA.order_date}. Bewaar alstublief deze email ter referentie. U kunt de status van uw bestelling online bekijken.
\n {$DATA.link}
\n \n \n Factuuradres:
\n {$BILLING.first_name} {$BILLING.last_name}
\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}
\n {/if}\n {$BILLING.line1}
\n {if !empty({$BILLING.line2})}{$BILLING.line2}
\n {/if}\n {$BILLING.town}
\n {$BILLING.state}
\n {$BILLING.postcode}
\n {$BILLING.country}
\n {$BILLING.phone}
\n
\n Email:
\n {$BILLING.email} | \n Bezorgadres:
\n {$SHIPPING.first_name} {$SHIPPING.last_name}
\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}
\n {/if}{$SHIPPING.line1}
\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}
\n {/if}{$SHIPPING.town}
\n {$SHIPPING.state}
\n {$SHIPPING.postcode}
\n {$SHIPPING.country} | \n
\n
\n \n \n \n | Item | \n Hoeveelheid | \n Kosten | \n
\n {foreach from=$PRODUCTS item=product}\n \n {$product.name}
{$product.product_options} | \n {$product.quantity} | \n {$product.price} | \n
\n {/foreach}\n \n | | \n Verzendmethode: ({$DATA.ship_method}) | \n {$DATA.shipping} | \n
\n \n | | \n Korting: | \n {$DATA.discount} | \n
\n \n | | \n Subtotaal: | \n {$DATA.subtotal} | \n
\n {foreach from=$TAXES item=tax}\n \n | | \n {$tax.tax_name}: ({$tax.tax_percent}%) | \n {$tax.tax_amount} | \n
\n {/foreach}\n \n | | \n Bestelling Totaal: | \n {$DATA.total} | \n
\n \n \n
', 'Bedankt {$DATA.first_name}!\n \n Uw bestelling {$DATA.cart_order_id} is ontvangen en is geplaatst op {$DATA.order_date}. Bewaar alstublief deze email ter referentie. U kunt de status van uw bestelling online bekijken.\n \n {$DATA.link}\n \n ----------------------------------------------------------------------\n Factuuradres:\n {$BILLING.first_name} {$BILLING.last_name}\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}\n {/if}{$BILLING.line1}\n {if !empty({$BILLING.line2})}{$BILLING.line2}\n {/if}{$BILLING.town}\n {$BILLING.state}\n {$BILLING.postcode}\n {$BILLING.country}\n {$BILLING.phone}\n \n Email:\n {$BILLING.email}\n \n Bezorgadres:\n {$SHIPPING.first_name} {$SHIPPING.last_name}\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}\n {/if}{$SHIPPING.line1}\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}\n {/if}{$SHIPPING.town}\n {$SHIPPING.state}\n {$SHIPPING.postcode}\n {$SHIPPING.country}\n \n ----------------------------------------------------------------------\n Items in uw bestelling\n \n {foreach from=$PRODUCTS item=product}\n -----------------------------------\n {$product.name}\n {$product.product_options}\n \n Producttype Nummer: {$product.product_code}\n Stuk Prijs: {$product.price}\n Hoeveelheid: {$product.quantity}\n \n {/foreach}\n -----------------------------------\n Subtotaal: {$DATA.subtotal}\n korting: {$DATA.discount}\n Verzending: {$DATA.shipping} ({$DATA.ship_method})\n {foreach from=$TAXES item=tax}{$tax.tax_name} ({$tax.tax_percent}%): {$tax.tax_amount}\n {/foreach}\n --------------------------\n Bestelling totaal: {$DATA.total}\n =========================='),
(65, 'cart.payment_fraud', 'nl-NL', '\n Bestelling probleem \n ', 'Hallo {$DATA.first_name},
\n Het spijt ons heel erg maar We konden de betaling niet ontvangen voor bestelling {$DATA.cart_order_id}. Mochten er vragen zijn dan kunt u het beste contact opnemen met onze medewerkers.
', 'Hallo {$DATA.first_name},\n \n Het spijt ons heel erg maar We konden de betaling niet ontvangen voor bestelling {$DATA.cart_order_id}. Mochten er vragen zijn dan kunt u het beste contact opnemen met onze medewerkers.'),
(66, 'account.password_recovery', 'nl-NL', '\n Wachtwoord herstellen \n ', 'Beste {$DATA.first_name} {$DATA.last_name},
\n
\n Om uw wachtwoord te herestellen kunt u op onderstaande link klikken of deze kopieren en plakken in de adresbalk van uw browser. Op de pagina wordt u gevraagd uw nieuwe wachtwoord in te voeren en te veriefieren.
\n
\n {$DATA.reset_link}
\n
\n Wanneer u meer ondersteuning nodigt heeft, dan kunt u altijd contact met ons opnemen.
', 'Hi {$DATA.first_name},\n \n Om uw wachtwoord te herestellen kunt u op onderstaande link klikken of deze kopieren en plakken in de adresbalk van uw browser. Op de pagina wordt u gevraagd uw nieuwe wachtwoord in te voeren en te veriefieren.\n \n {$DATA.reset_link}\n \n Wanneer u meer ondersteuning nodigt heeft, dan kunt u altijd contact met ons opnemen.'),
(67, 'admin.order_received', 'nl-NL', '\n Nieuwe bestelling #{$DATA.cart_order_id} \n ', '{$DATA.first_name} {$DATA.last_name} {if !empty({$BILLING.company_name})}({$BILLING.company_name}){/if} zojuist geplaatst order nummer {$DATA.cart_order_id} op {$DATA.order_date}.
\n Deze bestelling kan online worden beheerd door op de onderstaande link te klikken.
\n {$DATA.link}
\n \n \n Factuuradres:
\n {$BILLING.first_name} {$BILLING.last_name}
\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}
\n {/if}\n {$BILLING.line1}
\n {if !empty({$BILLING.line2})}{$BILLING.line2}
\n {/if}\n {$BILLING.town}
\n {$BILLING.state}
\n {$BILLING.postcode}
\n {$BILLING.country}
\n {$BILLING.phone}
\n
\n Email:
\n {$BILLING.email} | \n Bezorgadres:
\n {$SHIPPING.first_name} {$SHIPPING.last_name}
\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}
\n {/if}{$SHIPPING.line1}
\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}
\n {/if}{$SHIPPING.town}
\n {$SHIPPING.state}
\n {$SHIPPING.postcode}
\n {$SHIPPING.country} | \n
\n
\n \n \n \n | Item | \n Hoeveelheid | \n Kosten | \n
\n {foreach from=$PRODUCTS item=product}\n \n {$product.name}
{$product.product_options} | \n {$product.quantity} | \n {$product.price} | \n
\n {/foreach}\n \n | | \n Verzendmethode: ({$DATA.ship_method}) | \n {$DATA.shipping} | \n
\n \n | | \n Korting: | \n {$DATA.discount} | \n
\n \n | | \n Subtotaal: | \n {$DATA.subtotal} | \n
\n {foreach from=$TAXES item=tax}\n \n | | \n {$tax.tax_name}: ({$tax.tax_percent}%) | \n {$tax.tax_amount} | \n
\n {/foreach}\n \n | | \n Bestelling Totaal: | \n {$DATA.total} | \n
\n \n \n
', '{$DATA.first_name} {$DATA.last_name} {if !empty({$BILLING.company_name})}({$BILLING.company_name}){/if} zojuist geplaatst order nummer {$DATA.cart_order_id} op {$DATA.order_date}.\n \n Deze bestelling kan online worden beheerd door op de onderstaande link te klikken.\n \n {$DATA.link}\n \n ----------------------------------------------------------------------\n Factuuradres:\n {$BILLING.first_name} {$BILLING.last_name}\n {if !empty({$BILLING.company_name})}{$BILLING.company_name}\n {/if}{$BILLING.line1}\n {if !empty({$BILLING.line2})}{$BILLING.line2}\n {/if}{$BILLING.town}\n {$BILLING.state}\n {$BILLING.postcode}\n {$BILLING.country}\n {$BILLING.phone}\n \n Email:\n {$BILLING.email}\n \n Bezorgadres:\n {$SHIPPING.first_name} {$SHIPPING.last_name}\n {if !empty({$SHIPPING.company_name})}{$SHIPPING.company_name}\n {/if}{$SHIPPING.line1}\n {if !empty({$SHIPPING.line2})}{$SHIPPING.line2}\n {/if}{$SHIPPING.town}\n {$SHIPPING.state}\n {$SHIPPING.postcode}\n {$SHIPPING.country}\n \n ----------------------------------------------------------------------\n Items in uw bestelling\n \n {foreach from=$PRODUCTS item=product}\n -----------------------------------\n {$product.name}\n {$product.product_options}\n \n Producttype Nummer: {$product.product_code}\n Stuk Prijs: {$product.price}\n Hoeveelheid: {$product.quantity}\n \n {/foreach}\n -----------------------------------\n Subtotaal: {$DATA.subtotal}\n korting: {$DATA.discount}\n Verzending: {$DATA.shipping} ({$DATA.ship_method})\n {foreach from=$TAXES item=tax}{$tax.tax_name} ({$tax.tax_percent}%): {$tax.tax_amount}\n {/foreach}\n --------------------------\n Bestelling totaal: {$DATA.total}\n =========================='),
(68, 'admin.review_added', 'nl-NL', '\n Nieuwe product beoordeling \n ', '{$DATA.name} heeft een nieuwe beoordeling/reactie geplaatst over ''{$DATA.product_name}''. Deze kan met de onderstande link worden beheerd.\n Beheer Link:
{$DATA.link}
\n Beoordeling Tekst:
{$DATA.review}
', '{$DATA.name} heeft een nieuwe beoordeling/reactie geplaatst over ''{$DATA.product_name}''. Deze kan met de onderstande link worden beheerd.\n \n Beheer Link: \n {$DATA.link}\n Beoordeling Tekst:\n {$DATA.review}'),
(69, 'cart.digital_download', 'nl-NL', '\n Uw Gekochte Downloads \n ', 'Hallo {$DATA.first_name},
\n Uw digitale bestanden zijn klaar om gedownload te worden. Om toegang tot ze te krijgen kunt u de onderstaande links gebruiken:
\n {foreach from=$DOWNLOADS item=download} \n {$download.name}: (Link vervalt op {$download.expire})
\n {$download.url}
\n {/foreach}\n Wanneer bovenstaande links niet werken, kunt ut proberen ze te kopieren en te plakken in de adresbalk van uw browser. U kunt ook toegang tot deze bestanden krijgen via de klanten sectie van onze website.
\n
', 'Hallo {$DATA.first_name},\n \n Uw digitale bestanden zijn klaar om gedownload te worden. Om toegang tot ze te krijgen kunt u de onderstaande links gebruiken:\n \n {foreach from=$DOWNLOADS item=download} \n {$download.name}: (Link expires on {$download.expire})\n {$download.url}\n {/foreach}\n \n Wanneer bovenstaande links niet werken, kunt ut proberen ze te kopieren en te plakken in de adresbalk van uw browser. U kunt ook toegang tot deze bestanden krijgen via de klanten sectie van onze website.'),
(70, 'cart.gift_certificate', 'nl-NL', '\n Uw Cadeaubon \n ', 'Beste {$DATA.name},
\n Wij zijn verheugd dat wij u deze cadeaubon toe mogen sturen, welke u kan gebruiken voor ieder gewenst product op de website.
\n Veel Winkel Plezier!
\n Van: {$DATA.first_name} {$DATA.last_name}
\n Waarde: {$DATA.value}
\n Claim Code: {$DATA.code}
\n Bericht bij Cadeau: {$DATA.message}
\n -------------------
\n Om uw cadeaubon in te gebruiken voer a.u.b de "Cadeaubon Code" boven in het tekstveld genaamd "Voeg Cadeaubon of Coupon toe" tijdens het afrekenen.
\n Waarom zou u het nu niet uitgeven?
', 'Beste {$DATA.name},\n \n Wij zijn verheugd dat wij u deze cadeaubon toe mogen sturen, welke u kan gebruiken voor ieder gewenst product op de website.\n \n Veel Winkel Plezier!\n \n From: {$DATA.first_name} {$DATA.last_name}\n Amount: {$DATA.value}\n Claim Code: {$DATA.code}\n Gift Message: {$DATA.message}\n \n -------------------\n \n Om uw cadeaubon in te gebruiken voer a.u.b de "Cadeaubon Code" boven in het tekstveld genaamd "Voeg Cadeaubon of Coupon toe" tijdens het afrekenen.\n \n Waarom zou u het nu niet uitgeven?'),
(71, 'catalogue.tell_friend', 'nl-NL', '\n {$DATA.from} heeft iets aangeraden \n ', 'Beste {$DATA.to},\n Uw vriend {$DATA.from} dacht dat u misschien geintreseerd zou zijn in {$DATA.name}.
\n Product Link: {$DATA.name}
\n {$DATA.message}
', 'Beste {$DATA.to},\n \n Uw vriend {$DATA.from} dacht dat u misschien geintreseerd zou zijn in ''{$DATA.name}''.\n \n {$DATA.name}\n Product Link: {$DATA.link}\n \n {$DATA.message}'),
(72, 'cart.payment_received', 'nl-NL', '\n Bedankt voor uw betaling \n ', 'Hallo {$DATA.first_name},
\n Bedankt. We hebben een betaling van {$DATA.total} ontvangen voor bestelnummer {$DATA.cart_order_id}.
', 'Hallo {$DATA.first_name},\n \n We hebben een betaling van {$DATA.total} ontvangen voor bestelnummer {$DATA.cart_order_id}.');
DROP TABLE IF EXISTS `test_CubeCart_email_template`;
CREATE TABLE `test_CubeCart_email_template` (
`template_id` int(10) unsigned NOT NULL auto_increment,
`template_default` enum('0','1') NOT NULL default '0',
`title` varchar(100) NOT NULL,
`content_html` text NOT NULL,
`content_text` text NOT NULL,
PRIMARY KEY (`template_id`)
) TYPE=MyISAM ;
INSERT INTO `test_CubeCart_email_template` VALUES
(1, '1', 'Default Emails', '\r\n\r\n\r\n\r\n\r\nDefault HTML Template\r\n\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n  | \r\n \r\n \r\n | {$EMAIL_CONTENT} | \r\n \r\n \r\n Kind regards, \r\n The {$DATA.storeName} Staff
\r\n {$DATA.storeURL} | \r\n \r\n \r\n | \r\n
\r\n \r\n
\r\n\r\n', '{$EMAIL_CONTENT}\r\n\r\nKind regards,\r\n\r\nThe {$DATA.storeName} Staff\r\n{$DATA.storeURL}'),
(2, '0', 'Default Newsletter', '\r\n\r\n\r\n\r\n\r\nDefault HTML Newsletter Template\r\n\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n | \r\n \r\n \r\n | {$EMAIL_CONTENT} | \r\n \r\n \r\n Kind regards, \r\n The {$DATA.storeName} Staff
\r\n {$DATA.storeURL} \r\n
\r\n To unsubscribe please follow the link below:
\r\n {$DATA.unsubscribeURL} | \r\n \r\n \r\n | \r\n
\r\n \r\n
\r\n\r\n', '{$EMAIL_CONTENT}\r\n\r\nKind regards,\r\n\r\nThe {$DATA.storeName} Staff\r\n{$DATA.storeURL}\r\n\r\n-------------------\r\n\r\nTo unsubscribe please follow the link below:\r\n{$DATA.unsubscribeURL}');
DROP TABLE IF EXISTS `test_CubeCart_filemanager`;
CREATE TABLE `test_CubeCart_filemanager` (
`file_id` int(10) unsigned NOT NULL auto_increment,
`type` tinyint(1) unsigned NOT NULL default '1',
`disabled` tinyint(1) NOT NULL default '0',
`filepath` varchar(255) default NULL,
`filename` varchar(255) NOT NULL,
`filesize` int(10) unsigned NOT NULL,
`mimetype` varchar(50) NOT NULL,
`md5hash` varchar(32) NOT NULL,
`description` text NOT NULL,
PRIMARY KEY (`file_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_geo_country`;
CREATE TABLE `test_CubeCart_geo_country` (
`id` int(10) unsigned NOT NULL auto_increment,
`iso` char(2) NOT NULL,
`name` varbinary(80) NOT NULL default '',
`iso3` char(3) default NULL,
`numcode` smallint(3) unsigned zerofill default NULL,
PRIMARY KEY (`iso`),
KEY `id` (`id`)
) TYPE=MyISAM ;
INSERT INTO `test_CubeCart_geo_country` VALUES
(1, 'AF', 'Afghanistan', 'AFG', 004),
(2, 'AL', 'Albania', 'ALB', 008),
(3, 'DZ', 'Algeria', 'DZA', 012),
(4, 'AS', 'American Samoa', 'ASM', 016),
(5, 'AD', 'Andorra', 'AND', 020),
(7, 'AI', 'Anguilla', 'AIA', 660),
(8, 'AQ', 'Antarctica', 'ATA', 010),
(9, 'AG', 'Antigua and Barbuda', 'ATG', 028),
(10, 'AR', 'Argentina', 'ARG', 032),
(12, 'AW', 'Aruba', 'ABW', 533),
(13, 'AU', 'Australia', 'AUS', 036),
(14, 'AT', 'Austria', 'AUT', 040),
(15, 'AZ', 'Azerbaijan', 'AZE', 031),
(16, 'BS', 'Bahamas', 'BHS', 044),
(17, 'BH', 'Bahrain', 'BHR', 048),
(18, 'BD', 'Bangladesh', 'BGD', 050),
(19, 'BB', 'Barbados', 'BRB', 052),
(20, 'BY', 'Belarus', 'BLR', 112),
(21, 'BE', 'Belgium', 'BEL', 056),
(22, 'BZ', 'Belize', 'BLZ', 084),
(23, 'BJ', 'Benin', 'BEN', 204),
(24, 'BM', 'Bermuda', 'BMU', 060),
(25, 'BT', 'Bhutan', 'BTN', 064),
(26, 'BO', 'Bolivia', 'BOL', 068),
(27, 'BA', 'Bosnia and Herzegovina', 'BIH', 070),
(28, 'BW', 'Botswana', 'BWA', 072),
(29, 'BV', 'Bouvet Island', 'BVT', 074),
(30, 'BR', 'Brazil', 'BRA', 076),
(31, 'IO', 'British Indian Ocean Territory', 'IOT', 086),
(32, 'BN', 'Brunei Darussalam', 'BRN', 096),
(33, 'BG', 'Bulgaria', 'BGR', 100),
(34, 'BF', 'Burkina Faso', 'BFA', 854),
(35, 'BI', 'Burundi', 'BDI', 108),
(36, 'KH', 'Cambodia', 'KHM', 116),
(37, 'CM', 'Cameroon', 'CMR', 120),
(38, 'CA', 'Canada', 'CAN', 124),
(39, 'CV', 'Cape Verde', 'CPV', 132),
(40, 'KY', 'Cayman Islands', 'CYM', 136),
(41, 'CF', 'Central African Republic', 'CAF', 140),
(42, 'TD', 'Chad', 'TCD', 148),
(43, 'CL', 'Chile', 'CHL', 152),
(44, 'CN', 'China', 'CHN', 156),
(45, 'CX', 'Christmas Island', 'CXR', 162),
(46, 'CC', 'Cocos (Keeling) Islands', 'CCK', 166),
(47, 'CO', 'Colombia', 'COL', 170),
(48, 'KM', 'Comoros', 'COM', 174),
(49, 'CG', 'Congo', 'COG', 178),
(50, 'CD', 'Congo, the Democratic Republic of the', 'COD', 180),
(51, 'CK', 'Cook Islands', 'COK', 184),
(52, 'CR', 'Costa Rica', 'CRI', 188),
(53, 'CI', 'Cote D''Ivoire', 'CIV', 384),
(54, 'HR', 'Croatia', 'HRV', 191),
(55, 'CU', 'Cuba', 'CUB', 192),
(56, 'CY', 'Cyprus', 'CYP', 196),
(57, 'CZ', 'Czech Republic', 'CZE', 203),
(58, 'DK', 'Denmark', 'DNK', 208),
(59, 'DJ', 'Djibouti', 'DJI', 262),
(60, 'DM', 'Dominica', 'DMA', 212),
(61, 'DO', 'Dominican Republic', 'DOM', 214),
(62, 'EC', 'Ecuador', 'ECU', 218),
(63, 'EG', 'Egypt', 'EGY', 818),
(64, 'SV', 'El Salvador', 'SLV', 222),
(65, 'GQ', 'Equatorial Guinea', 'GNQ', 226),
(66, 'ER', 'Eritrea', 'ERI', 232),
(67, 'EE', 'Estonia', 'EST', 233),
(68, 'ET', 'Ethiopia', 'ETH', 231),
(69, 'FK', 'Falkland Islands (Malvinas)', 'FLK', 238),
(70, 'FO', 'Faroe Islands', 'FRO', 234),
(71, 'FJ', 'Fiji', 'FJI', 242),
(72, 'FI', 'Finland', 'FIN', 246),
(73, 'FR', 'France', 'FRA', 250),
(74, 'GF', 'French Guiana', 'GUF', 254),
(75, 'PF', 'French Polynesia', 'PYF', 258),
(76, 'TF', 'French Southern Territories', 'ATF', 260),
(77, 'GA', 'Gabon', 'GAB', 266),
(78, 'GM', 'Gambia', 'GMB', 270),
(79, 'GE', 'Georgia', 'GEO', 268),
(80, 'DE', 'Germany', 'DEU', 276),
(81, 'GH', 'Ghana', 'GHA', 288),
(82, 'GI', 'Gibraltar', 'GIB', 292),
(83, 'GR', 'Greece', 'GRC', 300),
(84, 'GL', 'Greenland', 'GRL', 304),
(85, 'GD', 'Grenada', 'GRD', 308),
(86, 'GP', 'Guadeloupe', 'GLP', 312),
(87, 'GU', 'Guam', 'GUM', 316),
(88, 'GT', 'Guatemala', 'GTM', 320),
(89, 'GN', 'Guinea', 'GIN', 324),
(90, 'GW', 'Guinea-Bissau', 'GNB', 624),
(91, 'GY', 'Guyana', 'GUY', 328),
(92, 'HT', 'Haiti', 'HTI', 332),
(93, 'HM', 'Heard Island and Mcdonald Islands', 'HMD', 334),
(94, 'VA', 'Holy See (Vatican City State)', 'VAT', 336),
(95, 'HN', 'Honduras', 'HND', 340),
(96, 'HK', 'Hong Kong', 'HKG', 344),
(97, 'HU', 'Hungary', 'HUN', 348),
(98, 'IS', 'Iceland', 'ISL', 352),
(99, 'IN', 'India', 'IND', 356),
(100, 'ID', 'Indonesia', 'IDN', 360),
(101, 'IR', 'Iran, Islamic Republic of', 'IRN', 364),
(102, 'IQ', 'Iraq', 'IRQ', 368),
(103, 'IE', 'Ireland', 'IRL', 372),
(104, 'IL', 'Israel', 'ISR', 376),
(105, 'IT', 'Italy', 'ITA', 380),
(106, 'JM', 'Jamaica', 'JAM', 388),
(107, 'JP', 'Japan', 'JPN', 392),
(108, 'JO', 'Jordan', 'JOR', 400),
(109, 'KZ', 'Kazakhstan', 'KAZ', 398),
(110, 'KE', 'Kenya', 'KEN', 404),
(111, 'KI', 'Kiribati', 'KIR', 296),
(112, 'KP', 'Korea, Democratic People''s Republic of', 'PRK', 408),
(113, 'KR', 'Korea, Republic of', 'KOR', 410),
(114, 'KW', 'Kuwait', 'KWT', 414),
(115, 'KG', 'Kyrgyzstan', 'KGZ', 417),
(116, 'LA', 'Lao People''s Democratic Republic', 'LAO', 418),
(117, 'LV', 'Latvia', 'LVA', 428),
(118, 'LB', 'Lebanon', 'LBN', 422),
(119, 'LS', 'Lesotho', 'LSO', 426),
(121, 'LY', 'Libyan Arab Jamahiriya', 'LBY', 434),
(122, 'LI', 'Liechtenstein', 'LIE', 438),
(123, 'LT', 'Lithuania', 'LTU', 440),
(124, 'LU', 'Luxembourg', 'LUX', 442),
(125, 'MO', 'Macao', 'MAC', 446),
(126, 'MK', 'Macedonia, the Former Yugoslav Republic of', 'MKD', 807),
(127, 'MG', 'Madagascar', 'MDG', 450),
(128, 'MW', 'Malawi', 'MWI', 454),
(129, 'MY', 'Malaysia', 'MYS', 458),
(130, 'MV', 'Maldives', 'MDV', 462),
(131, 'ML', 'Mali', 'MLI', 466),
(132, 'MT', 'Malta', 'MLT', 470),
(133, 'MH', 'Marshall Islands', 'MHL', 584),
(134, 'MQ', 'Martinique', 'MTQ', 474),
(135, 'MR', 'Mauritania', 'MRT', 478),
(136, 'MU', 'Mauritius', 'MUS', 480),
(137, 'YT', 'Mayotte', 'MYT', 175),
(138, 'MX', 'Mexico', 'MEX', 484),
(139, 'FM', 'Micronesia, Federated States of', 'FSM', 583),
(140, 'MD', 'Moldova, Republic of', 'MDA', 498),
(141, 'MC', 'Monaco', 'MCO', 492),
(142, 'MN', 'Mongolia', 'MNG', 496),
(143, 'MS', 'Montserrat', 'MSR', 500),
(144, 'MA', 'Morocco', 'MAR', 504),
(145, 'MZ', 'Mozambique', 'MOZ', 508),
(146, 'MM', 'Myanmar', 'MMR', 104),
(147, 'NA', 'Namibia', 'NAM', 516),
(148, 'NR', 'Nauru', 'NRU', 520),
(149, 'NP', 'Nepal', 'NPL', 524),
(150, 'NL', 'Netherlands', 'NLD', 528),
(151, 'AN', 'Netherlands Antilles', 'ANT', 530),
(152, 'NC', 'New Caledonia', 'NCL', 540),
(153, 'NZ', 'New Zealand', 'NZL', 554),
(154, 'NI', 'Nicaragua', 'NIC', 558),
(155, 'NE', 'Niger', 'NER', 562),
(156, 'NG', 'Nigeria', 'NGA', 566),
(157, 'NU', 'Niue', 'NIU', 570),
(158, 'NF', 'Norfolk Island', 'NFK', 574),
(159, 'MP', 'Northern Mariana Islands', 'MNP', 580),
(160, 'NO', 'Norway', 'NOR', 578),
(161, 'OM', 'Oman', 'OMN', 512),
(162, 'PK', 'Pakistan', 'PAK', 586),
(163, 'PW', 'Palau', 'PLW', 585),
(164, 'PS', 'Palestinian Territory, Occupied', 'PSE', 275),
(165, 'PA', 'Panama', 'PAN', 591),
(166, 'PG', 'Papua New Guinea', 'PNG', 598),
(167, 'PY', 'Paraguay', 'PRY', 600),
(168, 'PE', 'Peru', 'PER', 604),
(169, 'PH', 'Philippines', 'PHL', 608),
(170, 'PN', 'Pitcairn', 'PCN', 612),
(171, 'PL', 'Poland', 'POL', 616),
(172, 'PT', 'Portugal', 'PRT', 620),
(173, 'PR', 'Puerto Rico', 'PRI', 630),
(174, 'QA', 'Qatar', 'QAT', 634),
(175, 'RE', 'Reunion', 'REU', 638),
(176, 'RO', 'Romania', 'ROM', 642),
(177, 'RU', 'Russian Federation', 'RUS', 643),
(178, 'RW', 'Rwanda', 'RWA', 646),
(179, 'SH', 'Saint Helena', 'SHN', 654),
(180, 'KN', 'Saint Kitts and Nevis', 'KNA', 659),
(181, 'LC', 'Saint Lucia', 'LCA', 662),
(182, 'PM', 'Saint Pierre and Miquelon', 'SPM', 666),
(183, 'VC', 'Saint Vincent and the Grenadines', 'VCT', 670),
(184, 'WS', 'Samoa', 'WSM', 882),
(185, 'SM', 'San Marino', 'SMR', 674),
(186, 'ST', 'Sao Tome and Principe', 'STP', 678),
(187, 'SA', 'Saudi Arabia', 'SAU', 682),
(188, 'SN', 'Senegal', 'SEN', 686),
(244, 'RS', 'Serbia', 'SRB', 688),
(190, 'SC', 'Seychelles', 'SYC', 690),
(191, 'SL', 'Sierra Leone', 'SLE', 694),
(192, 'SG', 'Singapore', 'SGP', 702),
(193, 'SK', 'Slovakia', 'SVK', 703),
(194, 'SI', 'Slovenia', 'SVN', 705),
(195, 'SB', 'Solomon Islands', 'SLB', 090),
(196, 'SO', 'Somalia', 'SOM', 706),
(197, 'ZA', 'South Africa', 'ZAF', 710),
(198, 'GS', 'South Georgia and the South Sandwich Islands', 'SGS', 239),
(199, 'ES', 'Spain', 'ESP', 724),
(200, 'LK', 'Sri Lanka', 'LKA', 144),
(201, 'SD', 'Sudan', 'SDN', 736),
(202, 'SR', 'Suriname', 'SUR', 740),
(203, 'SJ', 'Svalbard and Jan Mayen', 'SJM', 744),
(204, 'SZ', 'Swaziland', 'SWZ', 748),
(205, 'SE', 'Sweden', 'SWE', 752),
(206, 'CH', 'Switzerland', 'CHE', 756),
(207, 'SY', 'Syrian Arab Republic', 'SYR', 760),
(208, 'TW', 'Taiwan', 'TWN', 158),
(209, 'TJ', 'Tajikistan', 'TJK', 762),
(210, 'TZ', 'Tanzania, United Republic of', 'TZA', 834),
(211, 'TH', 'Thailand', 'THA', 764),
(212, 'TL', 'Timor-Leste', 'TLS', 626),
(213, 'TG', 'Togo', 'TGO', 768),
(214, 'TK', 'Tokelau', 'TKL', 772),
(215, 'TO', 'Tonga', 'TON', 776),
(216, 'TT', 'Trinidad and Tobago', 'TTO', 780),
(217, 'TN', 'Tunisia', 'TUN', 788),
(218, 'TR', 'Turkey', 'TUR', 792),
(219, 'TM', 'Turkmenistan', 'TKM', 795),
(220, 'TC', 'Turks and Caicos Islands', 'TCA', 796),
(221, 'TV', 'Tuvalu', 'TUV', 798),
(222, 'UG', 'Uganda', 'UGA', 800),
(223, 'UA', 'Ukraine', 'UKR', 804),
(224, 'AE', 'United Arab Emirates', 'ARE', 784),
(225, 'GB', 'United Kingdom', 'GBR', 826),
(226, 'US', 'United States', 'USA', 840),
(227, 'UM', 'United States Minor Outlying Islands', 'UMI', 581),
(228, 'UY', 'Uruguay', 'URY', 858),
(229, 'UZ', 'Uzbekistan', 'UZB', 860),
(230, 'VU', 'Vanuatu', 'VUT', 548),
(231, 'VE', 'Venezuela', 'VEN', 862),
(232, 'VN', 'Viet Nam', 'VNM', 704),
(233, 'VG', 'Virgin Islands, British', 'VGB', 092),
(234, 'VI', 'Virgin Islands, U.s.', 'VIR', 850),
(235, 'WF', 'Wallis and Futuna', 'WLF', 876),
(236, 'EH', 'Western Sahara', 'ESH', 732),
(237, 'YE', 'Yemen', 'YEM', 887),
(238, 'ZM', 'Zambia', 'ZMB', 894),
(239, 'ZW', 'Zimbabwe', 'ZWE', 716),
(245, 'ME', 'Montenegro', 'MNE', 499);
DROP TABLE IF EXISTS `test_CubeCart_geo_zone`;
CREATE TABLE `test_CubeCart_geo_zone` (
`id` int(10) unsigned NOT NULL auto_increment,
`country_id` smallint(4) unsigned NOT NULL default '0',
`abbrev` varbinary(4) NOT NULL default '',
`name` varbinary(40) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM ;
INSERT INTO `test_CubeCart_geo_zone` VALUES
(1, 226, 'AL', 'Alabama'),
(2, 226, 'AK', 'Alaska'),
(3, 226, 'AS', 'American Samoa'),
(4, 226, 'AZ', 'Arizona'),
(5, 226, 'AR', 'Arkansas'),
(6, 226, 'AF', 'Armed Forces Africa'),
(7, 226, 'AA', 'Armed Forces Americas'),
(8, 226, 'AC', 'Armed Forces Canada'),
(9, 226, 'AE', 'Armed Forces Europe'),
(10, 226, 'AM', 'Armed Forces Middle East'),
(11, 226, 'AP', 'Armed Forces Pacific'),
(12, 226, 'CA', 'California'),
(13, 226, 'CO', 'Colorado'),
(14, 226, 'CT', 'Connecticut'),
(15, 226, 'DE', 'Delaware'),
(16, 226, 'DC', 'District of Columbia'),
(17, 226, 'FM', 'Federated States Of Micronesia'),
(18, 226, 'FL', 'Florida'),
(19, 226, 'GA', 'Georgia'),
(20, 226, 'GU', 'Guam'),
(21, 226, 'HI', 'Hawaii'),
(22, 226, 'ID', 'Idaho'),
(23, 226, 'IL', 'Illinois'),
(24, 226, 'IN', 'Indiana'),
(25, 226, 'IA', 'Iowa'),
(26, 226, 'KS', 'Kansas'),
(27, 226, 'KY', 'Kentucky'),
(28, 226, 'LA', 'Louisiana'),
(29, 226, 'ME', 'Maine'),
(30, 226, 'MH', 'Marshall Islands'),
(31, 226, 'MD', 'Maryland'),
(32, 226, 'MA', 'Massachusetts'),
(33, 226, 'MI', 'Michigan'),
(34, 226, 'MN', 'Minnesota'),
(35, 226, 'MS', 'Mississippi'),
(36, 226, 'MO', 'Missouri'),
(37, 226, 'MT', 'Montana'),
(38, 226, 'NE', 'Nebraska'),
(39, 226, 'NV', 'Nevada'),
(40, 226, 'NH', 'New Hampshire'),
(41, 226, 'NJ', 'New Jersey'),
(42, 226, 'NM', 'New Mexico'),
(43, 226, 'NY', 'New York'),
(44, 226, 'NC', 'North Carolina'),
(45, 226, 'ND', 'North Dakota'),
(46, 226, 'MP', 'Northern Mariana Islands'),
(47, 226, 'OH', 'Ohio'),
(48, 226, 'OK', 'Oklahoma'),
(49, 226, 'OR', 'Oregon'),
(50, 226, 'PW', 'Palau'),
(51, 226, 'PA', 'Pennsylvania'),
(52, 226, 'PR', 'Puerto Rico'),
(53, 226, 'RI', 'Rhode Island'),
(54, 226, 'SC', 'South Carolina'),
(55, 226, 'SD', 'South Dakota'),
(56, 226, 'TN', 'Tennessee'),
(57, 226, 'TX', 'Texas'),
(58, 226, 'UT', 'Utah'),
(59, 226, 'VT', 'Vermont'),
(60, 226, 'VI', 'Virgin Islands'),
(61, 226, 'VA', 'Virginia'),
(62, 226, 'WA', 'Washington'),
(63, 226, 'WV', 'West Virginia'),
(64, 226, 'WI', 'Wisconsin'),
(65, 226, 'WY', 'Wyoming'),
(66, 38, 'AB', 'Alberta'),
(67, 38, 'BC', 'British Columbia'),
(68, 38, 'MB', 'Manitoba'),
(69, 38, 'NF', 'Newfoundland'),
(70, 38, 'NB', 'New Brunswick'),
(71, 38, 'NS', 'Nova Scotia'),
(72, 38, 'NT', 'Northwest Territories'),
(73, 38, 'NU', 'Nunavut'),
(74, 38, 'ON', 'Ontario'),
(75, 38, 'PE', 'Prince Edward Island'),
(76, 38, 'QC', 'Quebec'),
(77, 38, 'SK', 'Saskatchewan'),
(78, 38, 'YT', 'Yukon Territory'),
(79, 80, 'NDS', 'Niedersachsen'),
(80, 80, 'BAW', 'Baden-Württemberg'),
(81, 80, 'BAY', 'Bayern'),
(82, 80, 'BER', 'Berlin'),
(83, 80, 'BRG', 'Brandenburg'),
(84, 80, 'BRE', 'Bremen'),
(85, 80, 'HAM', 'Hamburg'),
(86, 80, 'HES', 'Hessen'),
(87, 80, 'MEC', 'Mecklenburg-Vorpommern'),
(88, 80, 'NRW', 'Nordrhein-Westfalen'),
(89, 80, 'RHE', 'Rheinland-Pfalz'),
(90, 80, 'SAR', 'Saarland'),
(91, 80, 'SAS', 'Sachsen'),
(92, 80, 'SAC', 'Sachsen-Anhalt'),
(93, 80, 'SCN', 'Schleswig-Holstein'),
(94, 80, 'THE', 'Thüringen'),
(95, 14, 'WIE', 'Wien'),
(96, 14, 'NO', 'NiederÖsterreich'),
(97, 14, 'OO', 'OberÖsterreich'),
(98, 14, 'SB', 'Salzburg'),
(99, 14, 'KN', 'Kärnten'),
(100, 14, 'ST', 'Steiermark'),
(101, 14, 'TI', 'Tirol'),
(102, 14, 'BL', 'Burgenland'),
(103, 14, 'VB', 'Voralberg'),
(104, 206, 'AG', 'Aargau'),
(105, 206, 'AI', 'Appenzell Innerrhoden'),
(106, 206, 'APP', 'Appenzell Ausserrhoden'),
(107, 206, 'BE', 'Bern'),
(108, 206, 'BLA', 'Basel-Landschaft'),
(109, 206, 'BS', 'Basel-Stadt'),
(110, 206, 'FR', 'Freiburg'),
(111, 206, 'GE', 'Genf'),
(112, 206, 'GL', 'Glarus'),
(113, 206, 'JUB', 'Graubünden'),
(114, 206, 'JU', 'Jura'),
(115, 206, 'LU', 'Luzern'),
(116, 206, 'NEU', 'Neuenburg'),
(117, 206, 'NW', 'Nidwalden'),
(118, 206, 'OW', 'Obwalden'),
(119, 206, 'SG', 'St. Gallen'),
(120, 206, 'SH', 'Schaffhausen'),
(121, 206, 'SO', 'Solothurn'),
(122, 206, 'SZ', 'Schwyz'),
(123, 206, 'TG', 'Thurgau'),
(124, 206, 'TE', 'Tessin'),
(125, 206, 'UR', 'Uri'),
(126, 206, 'VD', 'Waadt'),
(127, 206, 'VS', 'Wallis'),
(128, 206, 'ZG', 'Zug'),
(129, 206, 'ZH', 'Zürich'),
(130, 199, 'ACOR', 'A Coruña'),
(131, 199, 'ALAV', 'Alava'),
(132, 199, 'ALBA', 'Albacete'),
(133, 199, 'ALIC', 'Alicante'),
(134, 199, 'ALME', 'Almeria'),
(135, 199, 'ASTU', 'Asturias'),
(136, 199, 'AVIL', 'Avila'),
(137, 199, 'BADA', 'Badajoz'),
(138, 199, 'BALE', 'Baleares'),
(139, 199, 'BARC', 'Barcelona'),
(140, 199, 'BURG', 'Burgos'),
(141, 199, 'CACE', 'Caceres'),
(142, 199, 'CADI', 'Cadiz'),
(143, 199, 'CANT', 'Cantabria'),
(144, 199, 'CAST', 'Castellon'),
(145, 199, 'CEUT', 'Ceuta'),
(146, 199, 'CIUD', 'Ciudad Real'),
(147, 199, 'CORD', 'Cordoba'),
(148, 199, 'CUEN', 'Cuenca'),
(149, 199, 'GIRO', 'Girona'),
(150, 199, 'GRAN', 'Granada'),
(151, 199, 'GUAD', 'Guadalajara'),
(152, 199, 'GUIP', 'Guipuzcoa'),
(153, 199, 'HUEL', 'Huelva'),
(154, 199, 'HUES', 'Huesca'),
(155, 199, 'JAEN', 'Jaen'),
(156, 199, 'LAR', 'La Rioja'),
(157, 199, 'LAS', 'Las Palmas'),
(158, 199, 'LEON', 'Leon'),
(159, 199, 'LLEI', 'Lleida'),
(160, 199, 'LUGO', 'Lugo'),
(161, 199, 'MADR', 'Madrid'),
(162, 199, 'MALA', 'Malaga'),
(163, 199, 'MELI', 'Melilla'),
(164, 199, 'MURC', 'Murcia'),
(165, 199, 'NAVA', 'Navarra'),
(166, 199, 'OURE', 'Ourense'),
(167, 199, 'PALE', 'Palencia'),
(168, 199, 'PONT', 'Pontevedra'),
(169, 199, 'SALA', 'Salamanca'),
(170, 199, 'SANT', 'Santa Cruz de Tenerife'),
(171, 199, 'SEGO', 'Segovia'),
(172, 199, 'SEVI', 'Sevilla'),
(173, 199, 'SORI', 'Soria'),
(174, 199, 'TARR', 'Tarragona'),
(175, 199, 'TERU', 'Teruel'),
(176, 199, 'TOLE', 'Toledo'),
(177, 199, 'VALE', 'Valencia'),
(178, 199, 'VALL', 'Valladolid'),
(179, 199, 'VIZC', 'Vizcaya'),
(180, 199, 'ZAMO', 'Zamora'),
(181, 199, 'ZARA', 'Zaragoza'),
(415, 103, 'CW', 'Carlow'),
(416, 103, 'CN', 'Cavan'),
(417, 103, 'CE', 'Clare'),
(418, 103, 'C', 'Cork'),
(419, 103, 'DL', 'Donegal'),
(420, 103, 'D', 'Dublin'),
(421, 103, 'G', 'Galway'),
(422, 103, 'KY', 'Kerry'),
(423, 103, 'KE', 'Kildare'),
(424, 103, 'KK', 'Kilkenny'),
(425, 103, 'LS', 'Laoighis'),
(426, 103, 'LM', 'Leitrim'),
(427, 103, 'LK', 'Limerick'),
(428, 103, 'LD', 'Longford'),
(429, 103, 'LH', 'Louth'),
(430, 103, 'MO', 'Mayo'),
(431, 103, 'MH', 'Meath'),
(432, 103, 'MN', 'Monaghan'),
(433, 103, 'OY', 'Offaly'),
(434, 103, 'RN', 'Roscommon'),
(435, 103, 'SO', 'Sligo'),
(436, 103, 'TA', 'Tipperary'),
(437, 103, 'WD', 'Waterford'),
(438, 103, 'WH', 'Westmeath'),
(439, 103, 'WX', 'Wexford'),
(440, 103, 'WW', 'Wicklow'),
(441, 225, 'AVN', 'Avon'),
(442, 225, 'BDF', 'Bedfordshire'),
(443, 225, 'BRK', 'Berkshire'),
(444, 225, 'BKM', 'Buckinghamshire'),
(445, 225, 'CAM', 'Cambridgeshire'),
(446, 225, 'CHS', 'Cheshire'),
(447, 225, 'CLV', 'Cleveland'),
(448, 225, 'CON', 'Cornwall'),
(449, 225, 'CUL', 'Cumberland'),
(450, 225, 'CMA', 'Cumbria'),
(451, 225, 'DBY', 'Derbyshire'),
(452, 225, 'DEV', 'Devon'),
(453, 225, 'DOR', 'Dorset'),
(454, 225, 'DUR', 'County Durham'),
(455, 225, 'ESS', 'Essex'),
(456, 225, 'GLS', 'Gloucestershire'),
(457, 225, 'HAM', 'Hampshire'),
(458, 225, 'HWR', 'Hereford and Worcester'),
(459, 225, 'HEF', 'Herefordshire'),
(460, 225, 'HRT', 'Hertfordshire'),
(461, 225, 'HUM', 'Humberside'),
(462, 225, 'HUN', 'Huntingdonshire'),
(463, 225, 'IOW', 'Isle of Wight'),
(464, 225, 'KEN', 'Kent'),
(465, 225, 'LAN', 'Lancashire'),
(466, 225, 'LEI', 'Leicestershire'),
(467, 225, 'LIN', 'Lincolnshire'),
(468, 225, 'GTM', 'Greater Manchester'),
(469, 225, 'GTL', 'Greater London'),
(470, 225, 'MSY', 'Merseyside'),
(471, 225, 'MDX', 'Middlesex'),
(472, 225, 'NFK', 'Norfolk'),
(473, 225, 'NTH', 'Northamptonshire'),
(474, 225, 'NBL', 'Northumberland'),
(475, 225, 'NTT', 'Nottinghamshire'),
(476, 225, 'OXF', 'Oxfordshire'),
(477, 225, 'RUT', 'Rutland'),
(478, 225, 'SAL', 'Shropshire'),
(479, 225, 'SOM', 'Somerset'),
(480, 225, 'STS', 'Staffordshire'),
(481, 225, 'SFK', 'Suffolk'),
(482, 225, 'SRY', 'Surrey'),
(483, 225, 'SSX', 'Sussex'),
(484, 225, 'TWR', 'Tyne and Wear'),
(485, 225, 'WAR', 'Warwickshire'),
(486, 225, 'WMD', 'West Midlands'),
(487, 225, 'WES', 'Westmorland'),
(488, 225, 'WIL', 'Wiltshire'),
(489, 225, 'WOR', 'Worcestershire'),
(490, 225, 'YOK', 'Yorkshire'),
(491, 225, 'ABD', 'Aberdeenshire'),
(492, 225, 'ANS', 'Angus'),
(493, 225, 'ARL', 'Argyll'),
(494, 225, 'AYR', 'Ayrshire'),
(495, 225, 'BAN', 'Banffshire'),
(496, 225, 'BEW', 'Berwickshire'),
(497, 225, 'BUT', 'Bute'),
(498, 225, 'CAI', 'Caithness'),
(499, 225, 'CLK', 'Clackmannanshire'),
(500, 225, 'CRO', 'Cromartyshire'),
(501, 225, 'DFS', 'Dumfriesshire'),
(502, 225, 'DNB', 'Dunbartonshire'),
(503, 225, 'ELN', 'East Lothian'),
(504, 225, 'FIF', 'Fife'),
(505, 225, 'INV', 'Inverness-shire'),
(506, 225, 'KRS', 'Kinross-shire'),
(507, 225, 'KKD', 'Kirkcudbrightshire'),
(508, 225, 'LAN', 'Lanarkshire'),
(509, 225, 'MLN', 'Midlothian'),
(510, 225, 'MOR', 'Moray'),
(511, 225, 'NAI', 'Nairnshire'),
(512, 225, 'OKI', 'Orkney'),
(513, 225, 'PEE', 'Peeblesshire'),
(514, 225, 'PER', 'Perthshire'),
(515, 225, 'RFW', 'Renfrewshire'),
(516, 225, 'ROC', 'Ross'),
(517, 225, 'ROX', 'Roxburghshire'),
(518, 225, 'SEL', 'Selkirkshire'),
(519, 225, 'SHI', 'Shetland'),
(520, 225, 'STI', 'Stirlingshire'),
(521, 225, 'SUT', 'Sutherland'),
(522, 225, 'WLN', 'West Lothian'),
(523, 225, 'WIG', 'Wigtownshire'),
(524, 225, 'AGY', 'Anglesey'),
(525, 225, 'BRN', 'Brecknockshire'),
(526, 225, 'CAE', 'Caernarfonshire'),
(527, 225, 'CAD', 'Cardiganshire'),
(528, 225, 'CRR', 'Carmarthenshire'),
(529, 225, 'CLW', 'Clwyd'),
(530, 225, 'DEN', 'Denbighshire'),
(531, 225, 'DFD', 'Dyfed'),
(532, 225, 'FLN', 'Flintshire'),
(533, 225, 'GLA', 'Glamorgan'),
(534, 225, 'GNT', 'Gwent'),
(535, 225, 'GWN', 'Gwynedd'),
(536, 225, 'MER', 'Merionethshire'),
(537, 225, 'MON', 'Monmouthshire'),
(538, 225, 'MGY', 'Montgomeryshire'),
(539, 225, 'PEM', 'Pembrokeshire'),
(540, 225, 'POW', 'Powys'),
(541, 225, 'RAD', 'Radnorshire'),
(542, 225, 'ANT', 'Antrim'),
(543, 225, 'ARM', 'Armagh'),
(544, 225, 'LDY', 'Londonderry'),
(545, 225, 'DOW', 'Down'),
(546, 225, 'FER', 'Fermanagh'),
(547, 225, 'TYR', 'Tyrone'),
(548, 150, 'DR', 'Drenthe'),
(549, 150, 'FL', 'Flevoland'),
(550, 150, 'FR', 'Friesland'),
(551, 150, 'GLD', 'Gelderland'),
(552, 150, 'GR', 'Groningen'),
(553, 150, 'LI', 'Limburg'),
(554, 150, 'NB', 'Noord-Brabant'),
(555, 150, 'NH', 'Noord-Holland'),
(556, 150, 'OV', 'Overijssel'),
(557, 150, 'UT', 'Utrecht'),
(558, 150, 'ZL', 'Zeeland'),
(559, 150, 'ZH', 'Zuid-Holland'),
(560, 13, 'ACT', 'Australian Capital Territory'),
(561, 13, 'NSW', 'New South Wales'),
(562, 13, 'NT', 'Northern Territory'),
(563, 13, 'QLD', 'Queensland'),
(564, 13, 'SA', 'South Australia'),
(565, 13, 'TAS', 'Tasmania'),
(566, 13, 'VIC', 'Victoria'),
(567, 13, 'WA', 'Western Australia');
DROP TABLE IF EXISTS `test_CubeCart_history`;
CREATE TABLE `test_CubeCart_history` (
`id` int(10) unsigned NOT NULL auto_increment,
`version` varchar(50) NOT NULL,
`time` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM ;
INSERT INTO `test_CubeCart_history` VALUES
(1, '5.0.8', 1334788220);
DROP TABLE IF EXISTS `test_CubeCart_hooks`;
CREATE TABLE `test_CubeCart_hooks` (
`hook_id` int(10) unsigned NOT NULL auto_increment,
`plugin` varchar(100) NOT NULL,
`hook_name` varchar(255) NOT NULL COMMENT 'A descriptive name for the hook',
`enabled` tinyint(1) NOT NULL default '0' COMMENT 'All hooks should be disabled by DEFAULT',
`trigger` varchar(255) NOT NULL COMMENT 'The trigger used to call the hook',
`filepath` text NOT NULL,
`priority` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`hook_id`),
KEY `trigger` (`trigger`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_image_index`;
CREATE TABLE `test_CubeCart_image_index` (
`id` int(10) unsigned NOT NULL auto_increment,
`product_id` int(10) unsigned NOT NULL,
`file_id` int(10) unsigned NOT NULL,
`main_img` enum('0','1') NOT NULL default '0',
`img` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `file_id` (`file_id`),
KEY `productId` (`product_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_inventory`;
CREATE TABLE `test_CubeCart_inventory` (
`product_id` int(10) unsigned NOT NULL auto_increment,
`status` tinyint(1) unsigned NOT NULL default '1',
`product_code` varchar(60) default NULL,
`quantity` int(11) NOT NULL default '1',
`description` text,
`price` decimal(16,2) NOT NULL default '0.00',
`sale_price` decimal(16,2) default '0.00',
`name` varchar(250) default NULL,
`cat_id` int(10) unsigned default '0',
`popularity` int(10) unsigned default '0',
`stock_level` int(11) default '0',
`stock_warning` int(10) unsigned NOT NULL default '0',
`use_stock_level` tinyint(1) unsigned NOT NULL default '1',
`digital` tinyint(1) unsigned NOT NULL default '0',
`digital_path` varchar(255) default NULL,
`product_weight` decimal(10,3) default NULL,
`tax_type` int(10) unsigned default NULL,
`tax_inclusive` tinyint(1) unsigned default '0',
`featured` tinyint(1) unsigned NOT NULL default '1',
`seo_meta_title` text NOT NULL,
`seo_meta_description` text NOT NULL,
`seo_meta_keywords` text NOT NULL,
`upc` varchar(20) default NULL,
`ean` varchar(20) default NULL,
`jan` varchar(20) default NULL,
`isbn` varchar(20) default NULL,
`date_added` timestamp NOT NULL default '0000-00-00 00:00:00',
`updated` timestamp NOT NULL,
`seo_custom_url` text NOT NULL,
`manufacturer` int(10) unsigned default NULL,
`condition` varchar(25) default NULL,
PRIMARY KEY (`product_id`),
KEY `status` (`status`),
FULLTEXT KEY `fulltext` (`product_code`,`description`,`name`)
) TYPE=MyISAM ;
INSERT INTO `test_CubeCart_inventory` VALUES
(1, 1, 'TESA31', 1, 'This is the main copy for the product.', '10.00', '6.99', 'Test Product', 1, 0, 0, 0, 0, 0, NULL, '4.000', 1, 0, 1, '', '', '', NULL, NULL, NULL, NULL, '2012-04-18 22:30:19', '2012-04-18 22:30:19', '', NULL, NULL);
DROP TABLE IF EXISTS `test_CubeCart_inventory_language`;
CREATE TABLE `test_CubeCart_inventory_language` (
`translation_id` int(10) unsigned NOT NULL auto_increment,
`product_id` int(10) unsigned NOT NULL,
`language` varchar(5) NOT NULL,
`name` varchar(255) NOT NULL,
`description` text NOT NULL,
`seo_meta_title` text NOT NULL,
`seo_meta_description` text NOT NULL,
`seo_meta_keywords` text NOT NULL,
`seo_custom_url` text NOT NULL,
KEY `id` (`translation_id`),
FULLTEXT KEY `fulltext` (`name`,`description`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_lang_strings`;
CREATE TABLE `test_CubeCart_lang_strings` (
`string_id` int(10) unsigned NOT NULL auto_increment,
`language` varchar(5) NOT NULL,
`type` varchar(50) NOT NULL,
`name` varchar(100) NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`string_id`),
KEY `language` (`language`),
KEY `type` (`type`),
KEY `name` (`name`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_logo`;
CREATE TABLE `test_CubeCart_logo` (
`logo_id` int(10) unsigned NOT NULL auto_increment,
`status` tinyint(1) unsigned NOT NULL,
`filename` varchar(150) NOT NULL,
`mimetype` varchar(100) NOT NULL,
`width` int(10) unsigned NOT NULL,
`height` int(10) unsigned NOT NULL,
`skin` varchar(100) NOT NULL,
`style` varchar(100) NOT NULL,
PRIMARY KEY (`logo_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_manufacturers`;
CREATE TABLE `test_CubeCart_manufacturers` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(200) NOT NULL,
`URL` varchar(250) default NULL,
`image` int(10) unsigned default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_modules`;
CREATE TABLE `test_CubeCart_modules` (
`module_id` int(10) unsigned NOT NULL auto_increment,
`module` varchar(25) NOT NULL,
`folder` varbinary(30) NOT NULL default '',
`status` tinyint(1) unsigned NOT NULL default '0',
`default` tinyint(1) unsigned NOT NULL default '0',
`countries` tinytext,
KEY `module_id` (`module_id`)
) TYPE=MyISAM ;
INSERT INTO `test_CubeCart_modules` VALUES
(1, 'shipping', 'Free_Shipping', 1, 1, NULL),
(2, 'gateway', 'Print_Order_Form', 1, 1, NULL);
DROP TABLE IF EXISTS `test_CubeCart_newsletter`;
CREATE TABLE `test_CubeCart_newsletter` (
`newsletter_id` int(10) unsigned NOT NULL auto_increment,
`status` tinyint(1) unsigned NOT NULL default '0',
`template_id` int(10) unsigned NOT NULL,
`date_saved` timestamp NOT NULL,
`date_sent` timestamp NOT NULL default '0000-00-00 00:00:00',
`subject` varchar(250) NOT NULL,
`sender_email` varchar(254) NOT NULL,
`sender_name` varchar(255) NOT NULL,
`content_html` text NOT NULL,
`content_text` text NOT NULL,
PRIMARY KEY (`newsletter_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_newsletter_subscriber`;
CREATE TABLE `test_CubeCart_newsletter_subscriber` (
`subscriber_id` int(10) unsigned NOT NULL auto_increment,
`customer_id` int(10) unsigned default NULL,
`status` tinyint(1) unsigned NOT NULL default '0',
`email` varchar(254) NOT NULL,
`validation` varchar(50) default NULL,
PRIMARY KEY (`subscriber_id`),
KEY `customer_id` (`customer_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_openid`;
CREATE TABLE `test_CubeCart_openid` (
`identity_id` int(10) unsigned NOT NULL auto_increment,
`customer_id` int(10) unsigned NOT NULL,
`identity_url` tinytext NOT NULL,
`identity_type` varchar(20) NOT NULL,
PRIMARY KEY (`identity_id`),
UNIQUE KEY `identity_url` (`identity_url`(250)),
KEY `customer_id` (`customer_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_options_set`;
CREATE TABLE `test_CubeCart_options_set` (
`set_id` int(10) unsigned NOT NULL auto_increment,
`set_name` text NOT NULL,
`set_description` text NOT NULL,
PRIMARY KEY (`set_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_options_set_member`;
CREATE TABLE `test_CubeCart_options_set_member` (
`set_member_id` int(10) unsigned NOT NULL auto_increment,
`set_id` int(10) unsigned NOT NULL,
`option_id` int(10) unsigned NOT NULL,
`value_id` int(10) unsigned NOT NULL,
`priority` int(11) NOT NULL,
PRIMARY KEY (`set_member_id`),
KEY `set_id` (`set_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_options_set_product`;
CREATE TABLE `test_CubeCart_options_set_product` (
`set_product_id` int(10) unsigned NOT NULL auto_increment,
`set_id` int(10) unsigned NOT NULL,
`product_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`set_product_id`),
KEY `set_id` (`set_id`),
KEY `product_id` (`product_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_option_assign`;
CREATE TABLE `test_CubeCart_option_assign` (
`assign_id` int(10) unsigned NOT NULL auto_increment,
`product` int(10) unsigned NOT NULL default '0',
`option_id` int(10) unsigned NOT NULL default '0',
`value_id` int(10) unsigned NOT NULL default '0',
`set_member_id` int(10) unsigned NOT NULL default '0',
`set_enabled` tinyint(1) unsigned NOT NULL default '1',
`option_negative` tinyint(1) unsigned NOT NULL default '0',
`option_price` decimal(16,2) NOT NULL default '0.00',
`option_weight` decimal(10,2) NOT NULL default '0.00',
`option_use_stock` tinyint(1) unsigned NOT NULL default '0',
`option_stock` int(11) default '0',
PRIMARY KEY (`assign_id`),
KEY `member_id` (`set_member_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_option_group`;
CREATE TABLE `test_CubeCart_option_group` (
`option_id` int(10) unsigned NOT NULL auto_increment,
`option_name` varbinary(30) NOT NULL default '',
`option_description` text NOT NULL,
`option_type` tinyint(4) unsigned NOT NULL default '0',
`option_required` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`option_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_option_value`;
CREATE TABLE `test_CubeCart_option_value` (
`value_id` int(10) unsigned NOT NULL auto_increment,
`value_name` varbinary(30) NOT NULL default '',
`option_id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`value_id`),
KEY `option_id` (`option_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_order_history`;
CREATE TABLE `test_CubeCart_order_history` (
`history_id` int(10) unsigned NOT NULL auto_increment,
`cart_order_id` varchar(18) NOT NULL,
`status` tinyint(2) unsigned NOT NULL default '0',
`updated` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`history_id`),
KEY `cart_order_id` (`cart_order_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_order_inventory`;
CREATE TABLE `test_CubeCart_order_inventory` (
`id` int(10) unsigned NOT NULL auto_increment,
`product_id` int(10) unsigned NOT NULL default '0',
`product_code` varchar(255) NOT NULL,
`name` varchar(225) NOT NULL,
`quantity` smallint(5) unsigned NOT NULL default '0',
`price` decimal(16,2) NOT NULL default '0.00',
`cart_order_id` varchar(18) NOT NULL,
`product_options` blob,
`digital` tinyint(1) unsigned NOT NULL default '0',
`stock_updated` tinyint(1) unsigned NOT NULL default '0',
`custom` blob,
`coupon_id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `product_id` (`product_id`),
KEY `cart_order_id` (`cart_order_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_order_notes`;
CREATE TABLE `test_CubeCart_order_notes` (
`note_id` int(10) unsigned NOT NULL auto_increment,
`admin_id` int(10) unsigned NOT NULL,
`cart_order_id` varchar(18) NOT NULL,
`time` timestamp NOT NULL,
`content` text NOT NULL,
PRIMARY KEY (`note_id`),
KEY `admin_id` (`admin_id`,`cart_order_id`,`time`),
FULLTEXT KEY `content` (`content`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_order_summary`;
CREATE TABLE `test_CubeCart_order_summary` (
`cart_order_id` varchar(18) NOT NULL,
`order_date` int(10) unsigned NOT NULL default '0',
`customer_id` int(11) unsigned NOT NULL default '0',
`status` tinyint(1) unsigned NOT NULL default '1',
`subtotal` decimal(16,2) NOT NULL default '0.00',
`discount` decimal(16,2) NOT NULL default '0.00',
`shipping` decimal(16,2) NOT NULL default '0.00',
`total_tax` decimal(16,2) NOT NULL default '0.00',
`total` decimal(16,2) NOT NULL default '0.00',
`offline_capture` blob,
`ship_method` varchar(100) default NULL,
`ship_date` date default NULL,
`ship_tracking` varchar(100) default NULL,
`gateway` varchar(100) NOT NULL,
`title` varchar(10) default NULL,
`first_name` varchar(100) NOT NULL,
`last_name` varchar(100) NOT NULL,
`company_name` varchar(200) default NULL,
`line1` varchar(100) NOT NULL,
`line2` varchar(100) default NULL,
`town` varchar(120) NOT NULL,
`state` varchar(100) NOT NULL,
`postcode` varchar(50) NOT NULL,
`country` smallint(3) unsigned NOT NULL,
`title_d` varchar(10) NOT NULL,
`first_name_d` varchar(100) NOT NULL,
`last_name_d` varchar(100) NOT NULL,
`company_name_d` varchar(200) default NULL,
`line1_d` varchar(100) NOT NULL,
`line2_d` varchar(100) default NULL,
`town_d` varchar(120) NOT NULL,
`state_d` varchar(100) NOT NULL,
`postcode_d` varchar(50) NOT NULL,
`country_d` smallint(3) unsigned NOT NULL,
`phone` varchar(50) default NULL,
`mobile` varchar(50) default NULL,
`email` varchar(254) default NULL,
`customer_comments` text,
`ip_address` varchar(45) NOT NULL COMMENT 'Supports IPv6 addresses',
`dashboard` tinyint(1) unsigned NOT NULL default '0',
`discount_type` char(1) NOT NULL default 'f',
`basket` blob,
`lang` varchar(5) default NULL,
PRIMARY KEY (`cart_order_id`),
KEY `customer_id` (`customer_id`),
KEY `status` (`status`),
KEY `email` (`email`),
KEY `order_date` (`order_date`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_order_tax`;
CREATE TABLE `test_CubeCart_order_tax` (
`id` int(10) unsigned NOT NULL auto_increment,
`cart_order_id` varchar(18) NOT NULL,
`tax_id` int(10) unsigned NOT NULL,
`amount` decimal(16,2) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `cart_order_id` (`cart_order_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_permissions`;
CREATE TABLE `test_CubeCart_permissions` (
`permission_id` int(10) unsigned NOT NULL auto_increment,
`admin_id` int(10) unsigned NOT NULL default '0',
`section_id` int(10) unsigned NOT NULL default '0',
`level` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`permission_id`),
KEY `admin_id` (`admin_id`),
KEY `section_id` (`section_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_pricing_group`;
CREATE TABLE `test_CubeCart_pricing_group` (
`price_id` int(10) unsigned NOT NULL auto_increment,
`group_id` int(10) unsigned NOT NULL,
`product_id` int(10) unsigned NOT NULL,
`price` decimal(16,2) NOT NULL default '0.00',
`sale_price` decimal(16,2) NOT NULL default '0.00',
`tax_type` int(10) unsigned NOT NULL,
`tax_inclusive` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`price_id`),
KEY `group_id` (`group_id`),
KEY `product_id` (`product_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_pricing_quantity`;
CREATE TABLE `test_CubeCart_pricing_quantity` (
`discount_id` int(10) unsigned NOT NULL auto_increment,
`product_id` int(10) unsigned NOT NULL,
`group_id` int(10) unsigned NOT NULL default '0',
`quantity` int(10) unsigned NOT NULL,
`price` decimal(16,2) NOT NULL,
PRIMARY KEY (`discount_id`),
KEY `product_id` (`product_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_request_log`;
CREATE TABLE `test_CubeCart_request_log` (
`request_id` int(10) unsigned NOT NULL auto_increment,
`request_url` varchar(255) default NULL,
`request` blob NOT NULL,
`result` blob NOT NULL,
`time` timestamp NOT NULL,
PRIMARY KEY (`request_id`)
) TYPE=MyISAM ;
INSERT INTO `test_CubeCart_request_log` VALUES
(1, 'http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml', 0x6e756c6c3d30, 0x3c3f786d6c2076657273696f6e3d22312e302220656e636f64696e673d225554462d38223f3e0a3c6765736d65733a456e76656c6f706520786d6c6e733a6765736d65733d22687474703a2f2f7777772e6765736d65732e6f72672f786d6c2f323030322d30382d30312220786d6c6e733d22687474703a2f2f7777772e6563622e696e742f766f636162756c6172792f323030322d30382d30312f6575726f6678726566223e0a093c6765736d65733a7375626a6563743e5265666572656e63652072617465733c2f6765736d65733a7375626a6563743e0a093c6765736d65733a53656e6465723e0a09093c6765736d65733a6e616d653e4575726f7065616e2043656e7472616c2042616e6b3c2f6765736d65733a6e616d653e0a093c2f6765736d65733a53656e6465723e0a093c437562653e0a09093c437562652074696d653d27323031322d30342d3138273e0a0909093c437562652063757272656e63793d275553442720726174653d27312e33303933272f3e0a0909093c437562652063757272656e63793d274a50592720726174653d273130362e3634272f3e0a0909093c437562652063757272656e63793d2742474e2720726174653d27312e39353538272f3e0a0909093c437562652063757272656e63793d27435a4b2720726174653d2732342e383136272f3e0a0909093c437562652063757272656e63793d27444b4b2720726174653d27372e34333839272f3e0a0909093c437562652063757272656e63793d274742502720726174653d27302e3831393135272f3e0a0909093c437562652063757272656e63793d274855462720726174653d273239362e3834272f3e0a0909093c437562652063757272656e63793d274c544c2720726174653d27332e34353238272f3e0a0909093c437562652063757272656e63793d274c564c2720726174653d27302e36393838272f3e0a0909093c437562652063757272656e63793d27504c4e2720726174653d27342e31383034272f3e0a0909093c437562652063757272656e63793d27524f4e2720726174653d27342e33373838272f3e0a0909093c437562652063757272656e63793d2753454b2720726174653d27382e38353030272f3e0a0909093c437562652063757272656e63793d274348462720726174653d27312e32303332272f3e0a0909093c437562652063757272656e63793d274e4f4b2720726174653d27372e35353235272f3e0a0909093c437562652063757272656e63793d2748524b2720726174653d27372e34383938272f3e0a0909093c437562652063757272656e63793d275255422720726174653d2733382e36373230272f3e0a0909093c437562652063757272656e63793d275452592720726174653d27322e33343536272f3e0a0909093c437562652063757272656e63793d274155442720726174653d27312e32363238272f3e0a0909093c437562652063757272656e63793d2742524c2720726174653d27322e34333639272f3e0a0909093c437562652063757272656e63793d274341442720726174653d27312e32393636272f3e0a0909093c437562652063757272656e63793d27434e592720726174653d27382e32343638272f3e0a0909093c437562652063757272656e63793d27484b442720726174653d2731302e31363137272f3e0a0909093c437562652063757272656e63793d274944522720726174653d2731323031382e3830272f3e0a0909093c437562652063757272656e63793d27494c532720726174653d27342e39333230272f3e0a0909093c437562652063757272656e63793d27494e522720726174653d2736372e38323830272f3e0a0909093c437562652063757272656e63793d274b52572720726174653d27313439312e3039272f3e0a0909093c437562652063757272656e63793d274d584e2720726174653d2731372e31373637272f3e0a0909093c437562652063757272656e63793d274d59522720726174653d27342e30313130272f3e0a0909093c437562652063757272656e63793d274e5a442720726174653d27312e36303033272f3e0a0909093c437562652063757272656e63793d275048502720726174653d2735352e383736272f3e0a0909093c437562652063757272656e63793d275347442720726174653d27312e36333831272f3e0a0909093c437562652063757272656e63793d275448422720726174653d2734302e333932272f3e0a0909093c437562652063757272656e63793d275a41522720726174653d2731302e32353137272f3e0a09093c2f437562653e0a093c2f437562653e0a3c2f6765736d65733a456e76656c6f70653e, '2012-04-18 22:30:19');
DROP TABLE IF EXISTS `test_CubeCart_reviews`;
CREATE TABLE `test_CubeCart_reviews` (
`id` int(10) unsigned NOT NULL auto_increment,
`approved` smallint(1) unsigned NOT NULL default '0',
`product_id` int(10) unsigned NOT NULL default '0',
`customer_id` int(10) unsigned NOT NULL default '0',
`rating` decimal(2,1) unsigned NOT NULL default '0.0',
`vote_up` int(11) NOT NULL default '0',
`vote_down` int(11) NOT NULL default '0',
`anon` tinyint(1) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL,
`email` varchar(254) NOT NULL,
`title` varchar(255) NOT NULL,
`review` text NOT NULL,
`ip_address` varchar(45) NOT NULL COMMENT 'Supports IPv6 addresses',
`time` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `product_id` (`product_id`),
KEY `votes` (`vote_up`,`vote_down`),
FULLTEXT KEY `fulltext` (`name`,`email`,`title`,`review`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_saved_cart`;
CREATE TABLE `test_CubeCart_saved_cart` (
`customer_id` int(10) unsigned NOT NULL,
`basket` mediumblob NOT NULL,
PRIMARY KEY (`customer_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_search`;
CREATE TABLE `test_CubeCart_search` (
`id` int(64) unsigned NOT NULL auto_increment,
`hits` int(64) NOT NULL default '1',
`searchstr` varbinary(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_seo_urls`;
CREATE TABLE `test_CubeCart_seo_urls` (
`id` int(10) unsigned NOT NULL auto_increment,
`path` varchar(255) NOT NULL,
`type` varchar(45) NOT NULL,
`item_id` int(25) unsigned default NULL,
PRIMARY KEY (`path`),
KEY `id` (`id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_sessions`;
CREATE TABLE `test_CubeCart_sessions` (
`session_id` varchar(32) NOT NULL,
`session_start` int(10) unsigned NOT NULL default '0',
`session_last` int(10) unsigned NOT NULL default '0',
`admin_id` int(10) unsigned NOT NULL default '0',
`customer_id` int(10) unsigned NOT NULL default '0',
`location` varbinary(255) default NULL,
`ip_address` varchar(45) default NULL COMMENT 'Supports IPv6 addresses',
`useragent` text,
PRIMARY KEY (`session_id`),
KEY `customer_id` (`customer_id`),
KEY `session_last` (`session_last`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_system_error_log`;
CREATE TABLE `test_CubeCart_system_error_log` (
`log_id` int(10) unsigned NOT NULL auto_increment,
`time` int(10) unsigned NOT NULL,
`message` text NOT NULL,
`read` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`log_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_tax_class`;
CREATE TABLE `test_CubeCart_tax_class` (
`id` int(10) unsigned NOT NULL auto_increment,
`tax_name` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM ;
INSERT INTO `test_CubeCart_tax_class` VALUES
(1, 'Standard Tax'),
(2, 'Reduced Rate'),
(3, 'Tax Exempt');
DROP TABLE IF EXISTS `test_CubeCart_tax_details`;
CREATE TABLE `test_CubeCart_tax_details` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varbinary(150) NOT NULL default '',
`display` varbinary(150) NOT NULL default '',
`reg_number` varbinary(150) NOT NULL default '',
`status` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) TYPE=MyISAM ;
INSERT INTO `test_CubeCart_tax_details` VALUES
(1, 'VAT', 'VAT', '', 1);
DROP TABLE IF EXISTS `test_CubeCart_tax_rates`;
CREATE TABLE `test_CubeCart_tax_rates` (
`id` int(10) unsigned NOT NULL auto_increment,
`type_id` int(10) unsigned NOT NULL default '1',
`details_id` int(10) unsigned NOT NULL default '0',
`country_id` int(10) unsigned NOT NULL default '0',
`county_id` int(10) unsigned NOT NULL default '0',
`tax_percent` decimal(7,4) NOT NULL default '0.0000',
`goods` int(10) unsigned NOT NULL default '0',
`shipping` int(10) unsigned NOT NULL default '0',
`active` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `type_id` (`type_id`,`details_id`,`country_id`,`county_id`)
) TYPE=MyISAM ;
INSERT INTO `test_CubeCart_tax_rates` VALUES
(1, 1, 1, 826, 0, '20.0000', 1, 1, 0),
(2, 2, 1, 826, 0, '5.0000', 1, 1, 0),
(3, 3, 1, 826, 0, '0.0000', 1, 1, 0);
DROP TABLE IF EXISTS `test_CubeCart_trackback`;
CREATE TABLE `test_CubeCart_trackback` (
`trackback_id` int(10) unsigned NOT NULL auto_increment,
`product_id` int(10) unsigned NOT NULL,
`url` varchar(250) NOT NULL,
`title` text,
`excerpt` tinytext,
`blog_name` text,
PRIMARY KEY (`trackback_id`),
UNIQUE KEY `url` (`url`),
KEY `product_id` (`product_id`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `test_CubeCart_transactions`;
CREATE TABLE `test_CubeCart_transactions` (
`id` int(10) unsigned NOT NULL auto_increment,
`gateway` varchar(100) default NULL,
`extra` varchar(255) default NULL,
`status` varchar(50) default NULL,
`customer_id` int(10) unsigned default NULL,
`order_id` varchar(18) default NULL,
`trans_id` varchar(50) default NULL,
`time` int(10) unsigned default NULL,
`amount` decimal(16,2) default NULL,
`captured` decimal(16,2) default NULL,
`notes` text,
PRIMARY KEY (`id`),
KEY `order_id` (`order_id`),
KEY `customer_id` (`customer_id`),
KEY `time` (`time`)
) TYPE=MyISAM;