1072 lines
38 KiB
SQL
1072 lines
38 KiB
SQL
SET NAMES 'utf8';
|
|
|
|
/* ##################################### */
|
|
/* STRUCTURE */
|
|
/* ##################################### */
|
|
|
|
DROP TABLE IF EXISTS PREFIX_order_customization_return;
|
|
|
|
ALTER TABLE PREFIX_cart
|
|
ADD id_guest INT UNSIGNED NULL AFTER id_customer;
|
|
|
|
ALTER TABLE PREFIX_tab
|
|
ADD `module` varchar(64) NULL AFTER class_name;
|
|
|
|
ALTER TABLE PREFIX_product
|
|
ADD `indexed` tinyint(1) NOT NULL default '0' AFTER `active`;
|
|
|
|
ALTER TABLE PREFIX_orders
|
|
DROP INDEX `orders_customer`;
|
|
ALTER TABLE PREFIX_orders
|
|
ADD INDEX id_customer (id_customer);
|
|
ALTER TABLE PREFIX_orders
|
|
ADD valid INTEGER(1) UNSIGNED NOT NULL DEFAULT '0' AFTER delivery_date;
|
|
ALTER TABLE PREFIX_orders
|
|
ADD INDEX `id_cart` (`id_cart`);
|
|
|
|
ALTER TABLE PREFIX_customer
|
|
ADD deleted TINYINT(1) NOT NULL DEFAULT '0' AFTER active;
|
|
|
|
ALTER TABLE PREFIX_employee
|
|
ADD stats_date_to DATE NULL DEFAULT NULL AFTER last_passwd_gen;
|
|
ALTER TABLE PREFIX_employee
|
|
ADD stats_date_from DATE NULL DEFAULT NULL AFTER last_passwd_gen;
|
|
|
|
ALTER TABLE PREFIX_order_state
|
|
ADD hidden TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER unremovable;
|
|
|
|
ALTER TABLE PREFIX_carrier
|
|
ADD is_module TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER range_behavior;
|
|
ALTER TABLE PREFIX_carrier
|
|
ADD INDEX deleted (`deleted`, `active`);
|
|
|
|
ALTER TABLE PREFIX_state
|
|
CHANGE iso_code `iso_code` char(4) NOT NULL;
|
|
|
|
ALTER TABLE PREFIX_order_detail
|
|
CHANGE product_quantity_cancelled product_quantity_refunded INT(10) UNSIGNED NOT NULL DEFAULT '0';
|
|
ALTER TABLE PREFIX_order_detail
|
|
ADD INDEX product_id (product_id);
|
|
|
|
ALTER TABLE PREFIX_attribute_lang
|
|
ADD INDEX id_lang (`id_lang`, `name`);
|
|
ALTER TABLE PREFIX_attribute_lang
|
|
ADD INDEX id_lang_2 (`id_lang`);
|
|
ALTER TABLE PREFIX_attribute_lang
|
|
ADD INDEX id_attribute (`id_attribute`);
|
|
|
|
ALTER TABLE PREFIX_block_cms
|
|
ADD PRIMARY KEY (`id_block`, `id_cms`);
|
|
|
|
/* IGNORE because can raise error data truncated */
|
|
ALTER IGNORE TABLE PREFIX_connections
|
|
CHANGE `http_referer` `http_referer` VARCHAR(255) DEFAULT NULL;
|
|
|
|
ALTER TABLE PREFIX_connections
|
|
ADD INDEX `date_add` (`date_add`);
|
|
|
|
ALTER TABLE PREFIX_customer
|
|
DROP INDEX `customer_email`;
|
|
ALTER TABLE PREFIX_customer
|
|
ADD UNIQUE `customer_email` (`email`);
|
|
|
|
ALTER TABLE PREFIX_delivery
|
|
ADD INDEX id_zone (`id_zone`);
|
|
ALTER TABLE PREFIX_delivery
|
|
ADD INDEX id_carrier (`id_carrier`, `id_zone`);
|
|
|
|
ALTER TABLE PREFIX_feature_product
|
|
ADD INDEX `id_feature` (`id_feature`);
|
|
|
|
ALTER TABLE PREFIX_hook_module
|
|
DROP INDEX `hook_module_index`;
|
|
ALTER TABLE PREFIX_hook_module
|
|
ADD PRIMARY KEY (id_module,id_hook);
|
|
ALTER TABLE PREFIX_hook_module
|
|
ADD INDEX id_module (`id_module`);
|
|
ALTER TABLE PREFIX_hook_module
|
|
ADD INDEX id_hook (`id_hook`);
|
|
|
|
ALTER TABLE PREFIX_module
|
|
CHANGE `active` `active` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0';
|
|
|
|
ALTER TABLE PREFIX_page
|
|
CHANGE `id_object` `id_object` INT UNSIGNED NULL DEFAULT NULL;
|
|
ALTER TABLE PREFIX_page
|
|
ADD INDEX `id_page_type` (`id_page_type`);
|
|
ALTER TABLE PREFIX_page
|
|
ADD INDEX `id_object` (`id_object`);
|
|
|
|
ALTER TABLE PREFIX_page_type
|
|
CHANGE `name` `name` VARCHAR(255) NOT NULL;
|
|
ALTER TABLE PREFIX_page_type
|
|
ADD INDEX `name` (`name`);
|
|
|
|
ALTER TABLE PREFIX_product_attribute
|
|
ADD INDEX reference (reference);
|
|
ALTER TABLE PREFIX_product_attribute
|
|
ADD INDEX supplier_reference (supplier_reference);
|
|
|
|
ALTER TABLE PREFIX_product_lang
|
|
ADD INDEX id_product (id_product);
|
|
ALTER TABLE PREFIX_product_lang
|
|
ADD INDEX id_lang (id_lang);
|
|
ALTER TABLE PREFIX_product_lang
|
|
ADD INDEX `name` (`name`);
|
|
ALTER TABLE PREFIX_product_lang
|
|
ADD FULLTEXT KEY ftsname (`name`);
|
|
|
|
ALTER TABLE PREFIX_cart_discount
|
|
ADD INDEX `id_discount` (`id_discount`);
|
|
|
|
ALTER TABLE PREFIX_discount_category
|
|
ADD PRIMARY KEY (`id_category`,`id_discount`);
|
|
|
|
ALTER TABLE PREFIX_image_lang
|
|
ADD INDEX id_image (id_image);
|
|
|
|
ALTER TABLE PREFIX_range_price
|
|
CHANGE `delimiter1` `delimiter1` DECIMAL(13, 6) NOT NULL;
|
|
ALTER TABLE PREFIX_range_price
|
|
CHANGE `delimiter2` `delimiter2` DECIMAL(13, 6) NOT NULL;
|
|
ALTER TABLE PREFIX_range_price
|
|
CHANGE `id_carrier` `id_carrier` INT(10) UNSIGNED NOT NULL;
|
|
ALTER TABLE PREFIX_range_price
|
|
DROP INDEX `range_price_unique`;
|
|
ALTER TABLE PREFIX_range_price
|
|
ADD UNIQUE KEY `id_carrier` (`id_carrier`,`delimiter1`,`delimiter2`);
|
|
|
|
ALTER TABLE PREFIX_range_weight
|
|
CHANGE `delimiter1` `delimiter1` DECIMAL(13, 6) NOT NULL;
|
|
ALTER TABLE PREFIX_range_weight
|
|
CHANGE `delimiter2` `delimiter2` DECIMAL(13, 6) NOT NULL;
|
|
ALTER TABLE PREFIX_range_weight
|
|
CHANGE `id_carrier` `id_carrier` INT(10) UNSIGNED NOT NULL;
|
|
ALTER TABLE PREFIX_range_weight
|
|
DROP INDEX `range_weight_unique`;
|
|
ALTER TABLE PREFIX_range_weight
|
|
ADD UNIQUE KEY `id_carrier` (`id_carrier`,`delimiter1`,`delimiter2`);
|
|
|
|
ALTER TABLE PREFIX_scene_products
|
|
ADD PRIMARY KEY (`id_scene`, `id_product`, `x_axis`, `y_axis`);
|
|
|
|
ALTER TABLE PREFIX_product_lang DROP INDEX fts;
|
|
ALTER TABLE PREFIX_product_lang DROP INDEX ftsname ;
|
|
|
|
/* KEY management */
|
|
ALTER TABLE PREFIX_attribute_lang DROP INDEX `id_lang_2`;
|
|
ALTER TABLE PREFIX_attribute_lang DROP INDEX `id_attribute`;
|
|
ALTER TABLE PREFIX_attribute_lang DROP INDEX `attribute_lang_index`, ADD PRIMARY KEY (`id_attribute`, `id_lang`);
|
|
ALTER TABLE PREFIX_carrier_zone DROP INDEX `carrier_zone_index`, ADD PRIMARY KEY (`id_carrier`, `id_zone`);
|
|
ALTER TABLE PREFIX_discount_category CHANGE `id_discount` `id_discount` int(11) NOT NULL AFTER `id_category`;
|
|
ALTER TABLE PREFIX_feature_product DROP INDEX `id_feature`;
|
|
ALTER TABLE PREFIX_hook_module DROP INDEX `id_module`;
|
|
ALTER TABLE PREFIX_image_lang DROP INDEX `id_image`;
|
|
ALTER TABLE PREFIX_product_lang DROP INDEX `id_product`;
|
|
|
|
/* ############################################################ */
|
|
|
|
CREATE TABLE `PREFIX_customer_group` (
|
|
`id_customer` int(10) unsigned NOT NULL,
|
|
`id_group` int(10) unsigned NOT NULL,
|
|
PRIMARY KEY (`id_customer`,`id_group`),
|
|
INDEX customer_login(id_group)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE PREFIX_category_group (
|
|
id_category INTEGER UNSIGNED NOT NULL,
|
|
id_group INTEGER UNSIGNED NOT NULL,
|
|
INDEX category_group_index(id_category, id_group)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE `PREFIX_group` (
|
|
id_group INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
reduction DECIMAL(10,2) NOT NULL DEFAULT 0,
|
|
date_add DATETIME NOT NULL,
|
|
date_upd DATETIME NOT NULL,
|
|
PRIMARY KEY(id_group)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE PREFIX_group_lang (
|
|
id_group INTEGER UNSIGNED NOT NULL,
|
|
id_lang INTEGER UNSIGNED NOT NULL,
|
|
name VARCHAR(32) NOT NULL,
|
|
UNIQUE INDEX attribute_lang_index(id_group, id_lang)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE PREFIX_message_readed (
|
|
id_message INTEGER UNSIGNED NOT NULL,
|
|
id_employee INTEGER UNSIGNED NOT NULL,
|
|
date_add DATETIME NOT NULL,
|
|
PRIMARY KEY (id_message,id_employee)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE `PREFIX_attachment` (
|
|
`id_attachment` int(10) unsigned NOT NULL auto_increment,
|
|
`file` varchar(40) NOT NULL,
|
|
`mime` varchar(32) NOT NULL,
|
|
PRIMARY KEY (`id_attachment`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE `PREFIX_attachment_lang` (
|
|
`id_attachment` int(10) unsigned NOT NULL auto_increment,
|
|
`id_lang` int(10) unsigned NOT NULL,
|
|
`name` varchar(32) default NULL,
|
|
`description` TEXT,
|
|
PRIMARY KEY (`id_attachment`, `id_lang`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE `PREFIX_product_attachment` (
|
|
`id_product` int(10) NOT NULL,
|
|
`id_attachment` int(10) NOT NULL,
|
|
PRIMARY KEY (`id_product`,`id_attachment`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE IF NOT EXISTS `PREFIX_connections_source` (
|
|
id_connections_source INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
id_connections INTEGER UNSIGNED NOT NULL,
|
|
http_referer VARCHAR(255) NULL,
|
|
request_uri VARCHAR(255) NULL,
|
|
keywords VARCHAR(255) NULL,
|
|
date_add DATETIME NOT NULL,
|
|
PRIMARY KEY (id_connections_source),
|
|
INDEX connections (id_connections),
|
|
INDEX orderby (date_add),
|
|
INDEX http_referer (`http_referer`),
|
|
INDEX request_uri(`request_uri`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE `PREFIX_referrer` (
|
|
`id_referrer` int(10) unsigned NOT NULL auto_increment,
|
|
`name` varchar(64) NOT NULL,
|
|
`passwd` varchar(32) default NULL,
|
|
`http_referer_regexp` varchar(64) default NULL,
|
|
`http_referer_like` varchar(64) default NULL,
|
|
`request_uri_regexp` varchar(64) default NULL,
|
|
`request_uri_like` varchar(64) default NULL,
|
|
`http_referer_regexp_not` varchar(64) default NULL,
|
|
`http_referer_like_not` varchar(64) default NULL,
|
|
`request_uri_regexp_not` varchar(64) default NULL,
|
|
`request_uri_like_not` varchar(64) default NULL,
|
|
`base_fee` decimal(5,2) NOT NULL default '0.00',
|
|
`percent_fee` decimal(5,2) NOT NULL default '0.00',
|
|
`click_fee` decimal(5,2) NOT NULL default '0.00',
|
|
`cache_visitors` int(11) default NULL,
|
|
`cache_visits` int(11) default NULL,
|
|
`cache_pages` int(11) default NULL,
|
|
`cache_registrations` int(11) default NULL,
|
|
`cache_orders` int(11) default NULL,
|
|
`cache_sales` decimal(10,2) default NULL,
|
|
`cache_reg_rate` decimal(5,4) default NULL,
|
|
`cache_order_rate` decimal(5,4) default NULL,
|
|
`date_add` datetime NOT NULL,
|
|
PRIMARY KEY (`id_referrer`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE `PREFIX_referrer_cache` (
|
|
`id_connections_source` int(11) NOT NULL,
|
|
`id_referrer` int(11) NOT NULL,
|
|
PRIMARY KEY (`id_connections_source`, `id_referrer`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE IF NOT EXISTS `PREFIX_search_engine` (
|
|
id_search_engine INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
server VARCHAR(64) NOT NULL,
|
|
getvar VARCHAR(16) NOT NULL,
|
|
PRIMARY KEY(id_search_engine)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE `PREFIX_module_group` (
|
|
`id_module` INTEGER UNSIGNED NOT NULL,
|
|
`id_group` INTEGER NOT NULL,
|
|
PRIMARY KEY (`id_module`, `id_group`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE `PREFIX_product_attribute_image` (
|
|
`id_product_attribute` int(10) NOT NULL,
|
|
`id_image` int(10) NOT NULL,
|
|
PRIMARY KEY (`id_product_attribute`,`id_image`),
|
|
KEY `id_image` (`id_image`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE `PREFIX_search_index` (
|
|
`id_product` int(11) NOT NULL,
|
|
`id_word` int(11) NOT NULL,
|
|
`weight` tinyint(4) NOT NULL default '1',
|
|
PRIMARY KEY (`id_word`, `id_product`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE `PREFIX_search_word` (
|
|
`id_word` int(10) unsigned NOT NULL auto_increment,
|
|
`id_lang` int(10) unsigned NOT NULL,
|
|
`word` varchar(15) NOT NULL,
|
|
PRIMARY KEY (`id_word`),
|
|
UNIQUE KEY `id_lang` (`id_lang`,`word`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE PREFIX_timezone (
|
|
id_timezone INTEGER UNSIGNED NOT NULL auto_increment,
|
|
name VARCHAR(32) NOT NULL,
|
|
PRIMARY KEY timezone_index(`id_timezone`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
/* ##################################### */
|
|
/* CONTENTS */
|
|
/* ##################################### */
|
|
|
|
INSERT INTO `PREFIX_order_state` (`id_order_state`, `invoice`, `send_email`, `color`, `unremovable`, `logable`, `delivery`) VALUES
|
|
(11, 0, 0, 'lightblue', 1, 0, 0);
|
|
|
|
INSERT INTO `PREFIX_order_state_lang` (`id_order_state`, `id_lang`, `name`, `template`) VALUES
|
|
(11, 1, 'Awaiting PayPal payment', '');
|
|
INSERT INTO `PREFIX_order_state_lang` (`id_order_state`, `id_lang`, `name`, `template`) VALUES
|
|
(11, 2, 'En attente du paiement par PayPal', '');
|
|
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES
|
|
('PS_SEARCH_MINWORDLEN', '3', NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES
|
|
('PS_SEARCH_WEIGHT_PNAME', '6', NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES
|
|
('PS_SEARCH_WEIGHT_REF', '10', NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES
|
|
('PS_SEARCH_WEIGHT_SHORTDESC', '1', NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES
|
|
('PS_SEARCH_WEIGHT_DESC', '1', NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES
|
|
('PS_SEARCH_WEIGHT_CNAME', '3', NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES
|
|
('PS_SEARCH_WEIGHT_MNAME', '3', NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES
|
|
('PS_SEARCH_WEIGHT_TAG', '4', NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES
|
|
('PS_SEARCH_WEIGHT_ATTRIBUTE', '2', NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES
|
|
('PS_SEARCH_WEIGHT_FEATURE', '2', NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES
|
|
('PS_SEARCH_AJAX', '1', NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES
|
|
('PS_TIMEZONE', '374', NOW(), NOW());
|
|
INSERT INTO `PREFIX_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES
|
|
('BLOCKTAGS_NBR', '10', NOW(), NOW());
|
|
|
|
INSERT INTO PREFIX_hook (`name`, `title`, `description`, `position`) VALUES
|
|
('extraCarrier', 'Extra carrier (module mode)', NULL, 0);
|
|
INSERT INTO PREFIX_hook (`name`, `title`, `description`, `position`) VALUES
|
|
('shoppingCartExtra', 'Shopping cart extra button', 'Display some specific informations', 1);
|
|
INSERT INTO PREFIX_hook (`name`, `title`, `description`, `position`) VALUES
|
|
('search', 'Search', NULL, 0);
|
|
INSERT INTO PREFIX_hook (`name`, `title`, `description`, `position`) VALUES
|
|
('backBeforePayment', 'Redirect in order process', 'Redirect user to the module instead of displaying payment modules', 0);
|
|
|
|
UPDATE PREFIX_orders o SET o.valid = IFNULL((
|
|
SELECT os.logable
|
|
FROM PREFIX_order_history oh
|
|
LEFT JOIN PREFIX_order_state os ON os.id_order_state = oh.id_order_state
|
|
WHERE oh.id_order = o.id_order
|
|
ORDER BY oh.date_add DESC, oh.id_order_history DESC
|
|
LIMIT 1
|
|
), 0);
|
|
|
|
INSERT INTO `PREFIX_search_engine` (`id_search_engine`, `server`,`getvar`) VALUES
|
|
(1, 'google','q'),
|
|
(2, 'search.aol','query'),
|
|
(3, 'yandex.ru','text'),
|
|
(4, 'ask.com','q'),
|
|
(5, 'nhl.com','q'),
|
|
(6, 'search.yahoo','p'),
|
|
(7, 'baidu.com','wd'),
|
|
(8, 'search.lycos','query'),
|
|
(9, 'exalead','q'),
|
|
(10, 'search.live.com','q'),
|
|
(11, 'search.ke.voila','rdata'),
|
|
(12, 'altavista','q')
|
|
ON DUPLICATE KEY UPDATE server = server;
|
|
|
|
/* GROUPS, CUSTOMERS GROUPS, & CATEGORY GROUPS */
|
|
INSERT INTO `PREFIX_group` (`reduction`, `date_add`, `date_upd`) VALUES (0, NOW(), NOW());
|
|
INSERT INTO `PREFIX_group_lang` (`id_lang`, `id_group`, `name`) (
|
|
SELECT `id_lang`,
|
|
(SELECT `id_group` FROM `PREFIX_group` LIMIT 1),
|
|
'Default' FROM `PREFIX_lang`);
|
|
UPDATE `PREFIX_group_lang` SET `name` = 'Défaut'
|
|
WHERE `id_group` = (SELECT `id_group` FROM `PREFIX_group` LIMIT 1)
|
|
AND `id_lang` = (SELECT `id_lang` FROM `PREFIX_lang` l WHERE l.iso_code = 'fr');
|
|
INSERT INTO `PREFIX_customer_group` (`id_customer`, `id_group`)
|
|
(SELECT `id_customer`,
|
|
(SELECT `id_group` FROM `PREFIX_group` LIMIT 1) FROM `PREFIX_customer`);
|
|
INSERT INTO `PREFIX_category_group` (`id_category`, `id_group`)
|
|
(SELECT `id_category`,
|
|
(SELECT `id_group` FROM `PREFIX_group` LIMIT 1) FROM `PREFIX_category`);
|
|
|
|
/* NEW TABS */
|
|
INSERT INTO PREFIX_tab (id_parent, class_name, position) VALUES ((SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM PREFIX_tab t WHERE t.class_name = 'AdminOrders' LIMIT 1) AS tmp), 'AdminMessages', (SELECT tmp.max FROM (SELECT MAX(position) max FROM `PREFIX_tab` WHERE id_parent = (SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM PREFIX_tab t WHERE t.class_name = 'AdminOrders' LIMIT 1) AS tmp )) AS tmp));
|
|
INSERT INTO PREFIX_tab_lang (id_lang, id_tab, name) (
|
|
SELECT id_lang,
|
|
(SELECT id_tab FROM PREFIX_tab t WHERE t.class_name = 'AdminMessages' LIMIT 1),
|
|
'Customer messages' FROM PREFIX_lang);
|
|
UPDATE `PREFIX_tab_lang` SET `name` = 'Messages clients'
|
|
WHERE `id_tab` = (SELECT `id_tab` FROM `PREFIX_tab` t WHERE t.class_name = 'AdminMessages')
|
|
AND `id_lang` = (SELECT `id_lang` FROM `PREFIX_lang` l WHERE l.iso_code = 'fr');
|
|
INSERT INTO PREFIX_access (id_profile, id_tab, `view`, `add`, edit, `delete`) VALUES ('1', (SELECT id_tab FROM PREFIX_tab t WHERE t.class_name = 'AdminMessages' LIMIT 1), 1, 1, 1, 1);
|
|
|
|
INSERT INTO PREFIX_tab (id_parent, class_name, position) VALUES ((SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM PREFIX_tab t WHERE t.class_name = 'AdminCatalog' LIMIT 1) AS tmp), 'AdminTracking', (SELECT tmp.max FROM (SELECT MAX(position) max FROM `PREFIX_tab` WHERE id_parent = (SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM PREFIX_tab t WHERE t.class_name = 'AdminCatalog' LIMIT 1) AS tmp )) AS tmp));
|
|
INSERT INTO PREFIX_tab_lang (id_lang, id_tab, name) (
|
|
SELECT id_lang,
|
|
(SELECT id_tab FROM PREFIX_tab t WHERE t.class_name = 'AdminTracking' LIMIT 1),
|
|
'Tracking' FROM PREFIX_lang);
|
|
UPDATE `PREFIX_tab_lang` SET `name` = 'Suivi'
|
|
WHERE `id_tab` = (SELECT `id_tab` FROM `PREFIX_tab` t WHERE t.class_name = 'AdminTracking')
|
|
AND `id_lang` = (SELECT `id_lang` FROM `PREFIX_lang` l WHERE l.iso_code = 'fr');
|
|
INSERT INTO PREFIX_access (id_profile, id_tab, `view`, `add`, edit, `delete`) VALUES ('1', (SELECT id_tab FROM PREFIX_tab t WHERE t.class_name = 'AdminTracking' LIMIT 1), 1, 1, 1, 1);
|
|
|
|
INSERT INTO PREFIX_tab (id_parent, class_name, position) VALUES ((SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM PREFIX_tab t WHERE t.class_name = 'AdminStats' LIMIT 1) AS tmp), 'AdminSearchEngines', (SELECT tmp.max FROM (SELECT MAX(position) max FROM `PREFIX_tab` WHERE id_parent = (SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM PREFIX_tab t WHERE t.class_name = 'AdminStats' LIMIT 1) AS tmp )) AS tmp));
|
|
INSERT INTO PREFIX_tab_lang (id_lang, id_tab, name) (
|
|
SELECT id_lang,
|
|
(SELECT id_tab FROM PREFIX_tab t WHERE t.class_name = 'AdminSearchEngines' LIMIT 1),
|
|
'Search Engines' FROM PREFIX_lang);
|
|
UPDATE `PREFIX_tab_lang` SET `name` = 'Moteurs de recherche'
|
|
WHERE `id_tab` = (SELECT `id_tab` FROM `PREFIX_tab` t WHERE t.class_name = 'AdminSearchEngines')
|
|
AND `id_lang` = (SELECT `id_lang` FROM `PREFIX_lang` l WHERE l.iso_code = 'fr');
|
|
INSERT INTO PREFIX_access (id_profile, id_tab, `view`, `add`, edit, `delete`) VALUES ('1', (SELECT id_tab FROM PREFIX_tab t WHERE t.class_name = 'AdminSearchEngines' LIMIT 1), 1, 1, 1, 1);
|
|
|
|
INSERT INTO PREFIX_tab (id_parent, class_name, position) VALUES ((SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM PREFIX_tab t WHERE t.class_name = 'AdminStats' LIMIT 1) AS tmp), 'AdminReferrers', (SELECT tmp.max FROM (SELECT MAX(position) max FROM `PREFIX_tab` WHERE id_parent = (SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM PREFIX_tab t WHERE t.class_name = 'AdminStats' LIMIT 1) AS tmp )) AS tmp));
|
|
INSERT INTO PREFIX_tab_lang (id_lang, id_tab, name) (
|
|
SELECT id_lang,
|
|
(SELECT id_tab FROM PREFIX_tab t WHERE t.class_name = 'AdminReferrers' LIMIT 1),
|
|
'Referrers' FROM PREFIX_lang);
|
|
UPDATE `PREFIX_tab_lang` SET `name` = 'Sites affluents'
|
|
WHERE `id_tab` = (SELECT `id_tab` FROM `PREFIX_tab` t WHERE t.class_name = 'AdminReferrers')
|
|
AND `id_lang` = (SELECT `id_lang` FROM `PREFIX_lang` l WHERE l.iso_code = 'fr');
|
|
INSERT INTO PREFIX_access (id_profile, id_tab, `view`, `add`, edit, `delete`) VALUES ('1', (SELECT id_tab FROM PREFIX_tab t WHERE t.class_name = 'AdminReferrers' LIMIT 1), 1, 1, 1, 1);
|
|
|
|
INSERT INTO PREFIX_tab (id_parent, class_name, position) VALUES ((SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM PREFIX_tab t WHERE t.class_name = 'AdminCustomers' LIMIT 1) AS tmp), 'AdminGroups', (SELECT tmp.max FROM (SELECT MAX(position) max FROM `PREFIX_tab` WHERE id_parent = (SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM PREFIX_tab t WHERE t.class_name = 'AdminCustomers' LIMIT 1) AS tmp )) AS tmp));
|
|
INSERT INTO PREFIX_tab_lang (id_lang, id_tab, name) (
|
|
SELECT id_lang,
|
|
(SELECT id_tab FROM PREFIX_tab t WHERE t.class_name = 'AdminGroups' LIMIT 1),
|
|
'Groups' FROM PREFIX_lang);
|
|
UPDATE `PREFIX_tab_lang` SET `name` = 'Groupes'
|
|
WHERE `id_tab` = (SELECT `id_tab` FROM `PREFIX_tab` t WHERE t.class_name = 'AdminGroups')
|
|
AND `id_lang` = (SELECT `id_lang` FROM `PREFIX_lang` l WHERE l.iso_code = 'fr');
|
|
INSERT INTO PREFIX_access (id_profile, id_tab, `view`, `add`, edit, `delete`) VALUES ('1', (SELECT id_tab FROM PREFIX_tab t WHERE t.class_name = 'AdminGroups' LIMIT 1), 1, 1, 1, 1);
|
|
|
|
INSERT INTO PREFIX_tab (id_parent, class_name, position) VALUES ((SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM PREFIX_tab t WHERE t.class_name = 'AdminCustomers' LIMIT 1) AS tmp), 'AdminCarts', (SELECT tmp.max FROM (SELECT MAX(position) max FROM `PREFIX_tab` WHERE id_parent = (SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM PREFIX_tab t WHERE t.class_name = 'AdminCustomers' LIMIT 1) AS tmp )) AS tmp));
|
|
INSERT INTO PREFIX_tab_lang (id_lang, id_tab, name) (
|
|
SELECT id_lang,
|
|
(SELECT id_tab FROM PREFIX_tab t WHERE t.class_name = 'AdminCarts' LIMIT 1),
|
|
'Carts' FROM PREFIX_lang);
|
|
UPDATE `PREFIX_tab_lang` SET `name` = 'Paniers'
|
|
WHERE `id_tab` = (SELECT `id_tab` FROM `PREFIX_tab` t WHERE t.class_name = 'AdminCarts')
|
|
AND `id_lang` = (SELECT `id_lang` FROM `PREFIX_lang` l WHERE l.iso_code = 'fr');
|
|
INSERT INTO PREFIX_access (id_profile, id_tab, `view`, `add`, edit, `delete`) VALUES ('1', (SELECT id_tab FROM PREFIX_tab t WHERE t.class_name = 'AdminCarts' LIMIT 1), 1, 1, 1, 1);
|
|
|
|
INSERT INTO PREFIX_tab (id_parent, class_name, position) VALUES ((SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM PREFIX_tab t WHERE t.class_name = 'AdminCatalog' LIMIT 1) AS tmp), 'AdminTags', (SELECT tmp.max FROM (SELECT MAX(position) max FROM `PREFIX_tab` WHERE id_parent = (SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM PREFIX_tab t WHERE t.class_name = 'AdminCatalog' LIMIT 1) AS tmp )) AS tmp));
|
|
INSERT INTO PREFIX_tab_lang (id_lang, id_tab, name) (
|
|
SELECT id_lang,
|
|
(SELECT id_tab FROM PREFIX_tab t WHERE t.class_name = 'AdminTags' LIMIT 1),
|
|
'Tags' FROM PREFIX_lang);
|
|
INSERT INTO PREFIX_access (id_profile, id_tab, `view`, `add`, edit, `delete`) VALUES ('1', (SELECT id_tab FROM PREFIX_tab t WHERE t.class_name = 'AdminTags' LIMIT 1), 1, 1, 1, 1);
|
|
|
|
INSERT INTO PREFIX_tab (id_parent, class_name, position) VALUES ((SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM PREFIX_tab t WHERE t.class_name = 'AdminPreferences' LIMIT 1) AS tmp), 'AdminSearchConf', (SELECT tmp.max FROM (SELECT MAX(position) max FROM `PREFIX_tab` WHERE id_parent = (SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM PREFIX_tab t WHERE t.class_name = 'AdminPreferences' LIMIT 1) AS tmp )) AS tmp));
|
|
INSERT INTO PREFIX_tab_lang (id_lang, id_tab, name) (
|
|
SELECT id_lang,
|
|
(SELECT id_tab FROM PREFIX_tab t WHERE t.class_name = 'AdminSearchConf' LIMIT 1),
|
|
'Search' FROM PREFIX_lang);
|
|
UPDATE `PREFIX_tab_lang` SET `name` = 'Recherche'
|
|
WHERE `id_tab` = (SELECT `id_tab` FROM `PREFIX_tab` t WHERE t.class_name = 'AdminSearchConf')
|
|
AND `id_lang` = (SELECT `id_lang` FROM `PREFIX_lang` l WHERE l.iso_code = 'fr');
|
|
INSERT INTO PREFIX_access (id_profile, id_tab, `view`, `add`, edit, `delete`) VALUES ('1', (SELECT id_tab FROM PREFIX_tab t WHERE t.class_name = 'AdminSearchConf' LIMIT 1), 1, 1, 1, 1);
|
|
|
|
INSERT INTO PREFIX_tab (id_parent, class_name, position) VALUES ((SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM PREFIX_tab t WHERE t.class_name = 'AdminCatalog' LIMIT 1) AS tmp), 'AdminAttachments', (SELECT tmp.max FROM (SELECT MAX(position) max FROM `PREFIX_tab` WHERE id_parent = (SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM PREFIX_tab t WHERE t.class_name = 'AdminCatalog' LIMIT 1) AS tmp )) AS tmp));
|
|
INSERT INTO PREFIX_tab_lang (id_lang, id_tab, name) (
|
|
SELECT id_lang,
|
|
(SELECT id_tab FROM PREFIX_tab t WHERE t.class_name = 'AdminAttachments' LIMIT 1),
|
|
'Attachments' FROM PREFIX_lang);
|
|
UPDATE `PREFIX_tab_lang` SET `name` = 'Documents joints'
|
|
WHERE `id_tab` = (SELECT `id_tab` FROM `PREFIX_tab` t WHERE t.class_name = 'AdminAttachments')
|
|
AND `id_lang` = (SELECT `id_lang` FROM `PREFIX_lang` l WHERE l.iso_code = 'fr');
|
|
INSERT INTO PREFIX_access (id_profile, id_tab, `view`, `add`, edit, `delete`) VALUES ('1', (SELECT id_tab FROM PREFIX_tab t WHERE t.class_name = 'AdminAttachments' LIMIT 1), 1, 1, 1, 1);
|
|
|
|
/* CHANGE TABS */
|
|
UPDATE `PREFIX_tab` SET `class_name` = 'AdminStatuses' WHERE `class_name` = 'AdminOrdersStates';
|
|
UPDATE `PREFIX_tab_lang` SET `name` = 'Statuses'
|
|
WHERE `id_tab` = (SELECT `id_tab` FROM `PREFIX_tab` t WHERE t.class_name = 'AdminStatuses')
|
|
AND `id_lang` = (SELECT `id_lang` FROM `PREFIX_lang` l WHERE l.iso_code = 'en');
|
|
UPDATE `PREFIX_tab_lang` SET `name` = 'Statuts'
|
|
WHERE `id_tab` = (SELECT `id_tab` FROM `PREFIX_tab` t WHERE t.class_name = 'AdminStatuses')
|
|
AND `id_lang` = (SELECT `id_lang` FROM `PREFIX_lang` l WHERE l.iso_code = 'fr');
|
|
|
|
INSERT IGNORE INTO PREFIX_product_attribute_image (id_image, id_product_attribute)
|
|
(SELECT id_image, id_product_attribute FROM PREFIX_product_attribute WHERE id_image IS NOT NULL);
|
|
/* ALTER query must stay here (right after the INSERT INTO PREFIX_product_attribute_image)! */
|
|
ALTER TABLE PREFIX_product_attribute DROP id_image;
|
|
|
|
UPDATE PREFIX_category_lang SET link_rewrite = 'home' WHERE id_category = 1;
|
|
|
|
/* TIMEZONES */
|
|
|
|
INSERT INTO `PREFIX_timezone` (`id_timezone`, `name`) VALUES
|
|
(1, 'Africa/Abidjan'),
|
|
(2, 'Africa/Accra'),
|
|
(3, 'Africa/Addis_Ababa'),
|
|
(4, 'Africa/Algiers'),
|
|
(5, 'Africa/Asmara'),
|
|
(6, 'Africa/Asmera'),
|
|
(7, 'Africa/Bamako'),
|
|
(8, 'Africa/Bangui'),
|
|
(9, 'Africa/Banjul'),
|
|
(10, 'Africa/Bissau'),
|
|
(11, 'Africa/Blantyre'),
|
|
(12, 'Africa/Brazzaville'),
|
|
(13, 'Africa/Bujumbura'),
|
|
(14, 'Africa/Cairo'),
|
|
(15, 'Africa/Casablanca'),
|
|
(16, 'Africa/Ceuta'),
|
|
(17, 'Africa/Conakry'),
|
|
(18, 'Africa/Dakar'),
|
|
(19, 'Africa/Dar_es_Salaam'),
|
|
(20, 'Africa/Djibouti'),
|
|
(21, 'Africa/Douala'),
|
|
(22, 'Africa/El_Aaiun'),
|
|
(23, 'Africa/Freetown'),
|
|
(24, 'Africa/Gaborone'),
|
|
(25, 'Africa/Harare'),
|
|
(26, 'Africa/Johannesburg'),
|
|
(27, 'Africa/Kampala'),
|
|
(28, 'Africa/Khartoum'),
|
|
(29, 'Africa/Kigali'),
|
|
(30, 'Africa/Kinshasa'),
|
|
(31, 'Africa/Lagos'),
|
|
(32, 'Africa/Libreville'),
|
|
(33, 'Africa/Lome'),
|
|
(34, 'Africa/Luanda'),
|
|
(35, 'Africa/Lubumbashi'),
|
|
(36, 'Africa/Lusaka'),
|
|
(37, 'Africa/Malabo'),
|
|
(38, 'Africa/Maputo'),
|
|
(39, 'Africa/Maseru'),
|
|
(40, 'Africa/Mbabane'),
|
|
(41, 'Africa/Mogadishu'),
|
|
(42, 'Africa/Monrovia'),
|
|
(43, 'Africa/Nairobi'),
|
|
(44, 'Africa/Ndjamena'),
|
|
(45, 'Africa/Niamey'),
|
|
(46, 'Africa/Nouakchott'),
|
|
(47, 'Africa/Ouagadougou'),
|
|
(48, 'Africa/Porto-Novo'),
|
|
(49, 'Africa/Sao_Tome'),
|
|
(50, 'Africa/Timbuktu'),
|
|
(51, 'Africa/Tripoli'),
|
|
(52, 'Africa/Tunis'),
|
|
(53, 'Africa/Windhoek'),
|
|
(54, 'America/Adak'),
|
|
(55, 'America/Anchorage '),
|
|
(56, 'America/Anguilla'),
|
|
(57, 'America/Antigua'),
|
|
(58, 'America/Araguaina'),
|
|
(59, 'America/Argentina/Buenos_Aires'),
|
|
(60, 'America/Argentina/Catamarca'),
|
|
(61, 'America/Argentina/ComodRivadavia'),
|
|
(62, 'America/Argentina/Cordoba'),
|
|
(63, 'America/Argentina/Jujuy'),
|
|
(64, 'America/Argentina/La_Rioja'),
|
|
(65, 'America/Argentina/Mendoza'),
|
|
(66, 'America/Argentina/Rio_Gallegos'),
|
|
(67, 'America/Argentina/Salta'),
|
|
(68, 'America/Argentina/San_Juan'),
|
|
(69, 'America/Argentina/San_Luis'),
|
|
(70, 'America/Argentina/Tucuman'),
|
|
(71, 'America/Argentina/Ushuaia'),
|
|
(72, 'America/Aruba'),
|
|
(73, 'America/Asuncion'),
|
|
(74, 'America/Atikokan'),
|
|
(75, 'America/Atka'),
|
|
(76, 'America/Bahia'),
|
|
(77, 'America/Barbados'),
|
|
(78, 'America/Belem'),
|
|
(79, 'America/Belize'),
|
|
(80, 'America/Blanc-Sablon'),
|
|
(81, 'America/Boa_Vista'),
|
|
(82, 'America/Bogota'),
|
|
(83, 'America/Boise'),
|
|
(84, 'America/Buenos_Aires'),
|
|
(85, 'America/Cambridge_Bay'),
|
|
(86, 'America/Campo_Grande'),
|
|
(87, 'America/Cancun'),
|
|
(88, 'America/Caracas'),
|
|
(89, 'America/Catamarca'),
|
|
(90, 'America/Cayenne'),
|
|
(91, 'America/Cayman'),
|
|
(92, 'America/Chicago'),
|
|
(93, 'America/Chihuahua'),
|
|
(94, 'America/Coral_Harbour'),
|
|
(95, 'America/Cordoba'),
|
|
(96, 'America/Costa_Rica'),
|
|
(97, 'America/Cuiaba'),
|
|
(98, 'America/Curacao'),
|
|
(99, 'America/Danmarkshavn'),
|
|
(100, 'America/Dawson'),
|
|
(101, 'America/Dawson_Creek'),
|
|
(102, 'America/Denver'),
|
|
(103, 'America/Detroit'),
|
|
(104, 'America/Dominica'),
|
|
(105, 'America/Edmonton'),
|
|
(106, 'America/Eirunepe'),
|
|
(107, 'America/El_Salvador'),
|
|
(108, 'America/Ensenada'),
|
|
(109, 'America/Fort_Wayne'),
|
|
(110, 'America/Fortaleza'),
|
|
(111, 'America/Glace_Bay'),
|
|
(112, 'America/Godthab'),
|
|
(113, 'America/Goose_Bay'),
|
|
(114, 'America/Grand_Turk'),
|
|
(115, 'America/Grenada'),
|
|
(116, 'America/Guadeloupe'),
|
|
(117, 'America/Guatemala'),
|
|
(118, 'America/Guayaquil'),
|
|
(119, 'America/Guyana'),
|
|
(120, 'America/Halifax'),
|
|
(121, 'America/Havana'),
|
|
(122, 'America/Hermosillo'),
|
|
(123, 'America/Indiana/Indianapolis'),
|
|
(124, 'America/Indiana/Knox'),
|
|
(125, 'America/Indiana/Marengo'),
|
|
(126, 'America/Indiana/Petersburg'),
|
|
(127, 'America/Indiana/Tell_City'),
|
|
(128, 'America/Indiana/Vevay'),
|
|
(129, 'America/Indiana/Vincennes'),
|
|
(130, 'America/Indiana/Winamac'),
|
|
(131, 'America/Indianapolis'),
|
|
(132, 'America/Inuvik'),
|
|
(133, 'America/Iqaluit'),
|
|
(134, 'America/Jamaica'),
|
|
(135, 'America/Jujuy'),
|
|
(136, 'America/Juneau'),
|
|
(137, 'America/Kentucky/Louisville'),
|
|
(138, 'America/Kentucky/Monticello'),
|
|
(139, 'America/Knox_IN'),
|
|
(140, 'America/La_Paz'),
|
|
(141, 'America/Lima'),
|
|
(142, 'America/Los_Angeles'),
|
|
(143, 'America/Louisville'),
|
|
(144, 'America/Maceio'),
|
|
(145, 'America/Managua'),
|
|
(146, 'America/Manaus'),
|
|
(147, 'America/Marigot'),
|
|
(148, 'America/Martinique'),
|
|
(149, 'America/Mazatlan'),
|
|
(150, 'America/Mendoza'),
|
|
(151, 'America/Menominee'),
|
|
(152, 'America/Merida'),
|
|
(153, 'America/Mexico_City'),
|
|
(154, 'America/Miquelon'),
|
|
(155, 'America/Moncton'),
|
|
(156, 'America/Monterrey'),
|
|
(157, 'America/Montevideo'),
|
|
(158, 'America/Montreal'),
|
|
(159, 'America/Montserrat'),
|
|
(160, 'America/Nassau'),
|
|
(161, 'America/New_York'),
|
|
(162, 'America/Nipigon'),
|
|
(163, 'America/Nome'),
|
|
(164, 'America/Noronha'),
|
|
(165, 'America/North_Dakota/Center'),
|
|
(166, 'America/North_Dakota/New_Salem'),
|
|
(167, 'America/Panama'),
|
|
(168, 'America/Pangnirtung'),
|
|
(169, 'America/Paramaribo'),
|
|
(170, 'America/Phoenix'),
|
|
(171, 'America/Port-au-Prince'),
|
|
(172, 'America/Port_of_Spain'),
|
|
(173, 'America/Porto_Acre'),
|
|
(174, 'America/Porto_Velho'),
|
|
(175, 'America/Puerto_Rico'),
|
|
(176, 'America/Rainy_River'),
|
|
(177, 'America/Rankin_Inlet'),
|
|
(178, 'America/Recife'),
|
|
(179, 'America/Regina'),
|
|
(180, 'America/Resolute'),
|
|
(181, 'America/Rio_Branco'),
|
|
(182, 'America/Rosario'),
|
|
(183, 'America/Santarem'),
|
|
(184, 'America/Santiago'),
|
|
(185, 'America/Santo_Domingo'),
|
|
(186, 'America/Sao_Paulo'),
|
|
(187, 'America/Scoresbysund'),
|
|
(188, 'America/Shiprock'),
|
|
(189, 'America/St_Barthelemy'),
|
|
(190, 'America/St_Johns'),
|
|
(191, 'America/St_Kitts'),
|
|
(192, 'America/St_Lucia'),
|
|
(193, 'America/St_Thomas'),
|
|
(194, 'America/St_Vincent'),
|
|
(195, 'America/Swift_Current'),
|
|
(196, 'America/Tegucigalpa'),
|
|
(197, 'America/Thule'),
|
|
(198, 'America/Thunder_Bay'),
|
|
(199, 'America/Tijuana'),
|
|
(200, 'America/Toronto'),
|
|
(201, 'America/Tortola'),
|
|
(202, 'America/Vancouver'),
|
|
(203, 'America/Virgin'),
|
|
(204, 'America/Whitehorse'),
|
|
(205, 'America/Winnipeg'),
|
|
(206, 'America/Yakutat'),
|
|
(207, 'America/Yellowknife'),
|
|
(208, 'Antarctica/Casey'),
|
|
(209, 'Antarctica/Davis'),
|
|
(210, 'Antarctica/DumontDUrville'),
|
|
(211, 'Antarctica/Mawson'),
|
|
(212, 'Antarctica/McMurdo'),
|
|
(213, 'Antarctica/Palmer'),
|
|
(214, 'Antarctica/Rothera'),
|
|
(215, 'Antarctica/South_Pole'),
|
|
(216, 'Antarctica/Syowa'),
|
|
(217, 'Antarctica/Vostok'),
|
|
(218, 'Arctic/Longyearbyen'),
|
|
(219, 'Asia/Aden'),
|
|
(220, 'Asia/Almaty'),
|
|
(221, 'Asia/Amman'),
|
|
(222, 'Asia/Anadyr'),
|
|
(223, 'Asia/Aqtau'),
|
|
(224, 'Asia/Aqtobe'),
|
|
(225, 'Asia/Ashgabat'),
|
|
(226, 'Asia/Ashkhabad'),
|
|
(227, 'Asia/Baghdad'),
|
|
(228, 'Asia/Bahrain'),
|
|
(229, 'Asia/Baku'),
|
|
(230, 'Asia/Bangkok'),
|
|
(231, 'Asia/Beirut'),
|
|
(232, 'Asia/Bishkek'),
|
|
(233, 'Asia/Brunei'),
|
|
(234, 'Asia/Calcutta'),
|
|
(235, 'Asia/Choibalsan'),
|
|
(236, 'Asia/Chongqing'),
|
|
(237, 'Asia/Chungking'),
|
|
(238, 'Asia/Colombo'),
|
|
(239, 'Asia/Dacca'),
|
|
(240, 'Asia/Damascus'),
|
|
(241, 'Asia/Dhaka'),
|
|
(242, 'Asia/Dili'),
|
|
(243, 'Asia/Dubai'),
|
|
(244, 'Asia/Dushanbe'),
|
|
(245, 'Asia/Gaza'),
|
|
(246, 'Asia/Harbin'),
|
|
(247, 'Asia/Ho_Chi_Minh'),
|
|
(248, 'Asia/Hong_Kong'),
|
|
(249, 'Asia/Hovd'),
|
|
(250, 'Asia/Irkutsk'),
|
|
(251, 'Asia/Istanbul'),
|
|
(252, 'Asia/Jakarta'),
|
|
(253, 'Asia/Jayapura'),
|
|
(254, 'Asia/Jerusalem'),
|
|
(255, 'Asia/Kabul'),
|
|
(256, 'Asia/Kamchatka'),
|
|
(257, 'Asia/Karachi'),
|
|
(258, 'Asia/Kashgar'),
|
|
(259, 'Asia/Kathmandu'),
|
|
(260, 'Asia/Katmandu'),
|
|
(261, 'Asia/Kolkata'),
|
|
(262, 'Asia/Krasnoyarsk'),
|
|
(263, 'Asia/Kuala_Lumpur'),
|
|
(264, 'Asia/Kuching'),
|
|
(265, 'Asia/Kuwait'),
|
|
(266, 'Asia/Macao'),
|
|
(267, 'Asia/Macau'),
|
|
(268, 'Asia/Magadan'),
|
|
(269, 'Asia/Makassar'),
|
|
(270, 'Asia/Manila'),
|
|
(271, 'Asia/Muscat'),
|
|
(272, 'Asia/Nicosia'),
|
|
(273, 'Asia/Novosibirsk'),
|
|
(274, 'Asia/Omsk'),
|
|
(275, 'Asia/Oral'),
|
|
(276, 'Asia/Phnom_Penh'),
|
|
(277, 'Asia/Pontianak'),
|
|
(278, 'Asia/Pyongyang'),
|
|
(279, 'Asia/Qatar'),
|
|
(280, 'Asia/Qyzylorda'),
|
|
(281, 'Asia/Rangoon'),
|
|
(282, 'Asia/Riyadh'),
|
|
(283, 'Asia/Saigon'),
|
|
(284, 'Asia/Sakhalin'),
|
|
(285, 'Asia/Samarkand'),
|
|
(286, 'Asia/Seoul'),
|
|
(287, 'Asia/Shanghai'),
|
|
(288, 'Asia/Singapore'),
|
|
(289, 'Asia/Taipei'),
|
|
(290, 'Asia/Tashkent'),
|
|
(291, 'Asia/Tbilisi'),
|
|
(292, 'Asia/Tehran'),
|
|
(293, 'Asia/Tel_Aviv'),
|
|
(294, 'Asia/Thimbu'),
|
|
(295, 'Asia/Thimphu'),
|
|
(296, 'Asia/Tokyo'),
|
|
(297, 'Asia/Ujung_Pandang'),
|
|
(298, 'Asia/Ulaanbaatar'),
|
|
(299, 'Asia/Ulan_Bator'),
|
|
(300, 'Asia/Urumqi'),
|
|
(301, 'Asia/Vientiane'),
|
|
(302, 'Asia/Vladivostok'),
|
|
(303, 'Asia/Yakutsk'),
|
|
(304, 'Asia/Yekaterinburg'),
|
|
(305, 'Asia/Yerevan'),
|
|
(306, 'Atlantic/Azores'),
|
|
(307, 'Atlantic/Bermuda'),
|
|
(308, 'Atlantic/Canary'),
|
|
(309, 'Atlantic/Cape_Verde'),
|
|
(310, 'Atlantic/Faeroe'),
|
|
(311, 'Atlantic/Faroe'),
|
|
(312, 'Atlantic/Jan_Mayen'),
|
|
(313, 'Atlantic/Madeira'),
|
|
(314, 'Atlantic/Reykjavik'),
|
|
(315, 'Atlantic/South_Georgia'),
|
|
(316, 'Atlantic/St_Helena'),
|
|
(317, 'Atlantic/Stanley'),
|
|
(318, 'Australia/ACT'),
|
|
(319, 'Australia/Adelaide'),
|
|
(320, 'Australia/Brisbane'),
|
|
(321, 'Australia/Broken_Hill'),
|
|
(322, 'Australia/Canberra'),
|
|
(323, 'Australia/Currie'),
|
|
(324, 'Australia/Darwin'),
|
|
(325, 'Australia/Eucla'),
|
|
(326, 'Australia/Hobart'),
|
|
(327, 'Australia/LHI'),
|
|
(328, 'Australia/Lindeman'),
|
|
(329, 'Australia/Lord_Howe'),
|
|
(330, 'Australia/Melbourne'),
|
|
(331, 'Australia/North'),
|
|
(332, 'Australia/NSW'),
|
|
(333, 'Australia/Perth'),
|
|
(334, 'Australia/Queensland'),
|
|
(335, 'Australia/South'),
|
|
(336, 'Australia/Sydney'),
|
|
(337, 'Australia/Tasmania'),
|
|
(338, 'Australia/Victoria'),
|
|
(339, 'Australia/West'),
|
|
(340, 'Australia/Yancowinna'),
|
|
(341, 'Europe/Amsterdam'),
|
|
(342, 'Europe/Andorra'),
|
|
(343, 'Europe/Athens'),
|
|
(344, 'Europe/Belfast'),
|
|
(345, 'Europe/Belgrade'),
|
|
(346, 'Europe/Berlin'),
|
|
(347, 'Europe/Bratislava'),
|
|
(348, 'Europe/Brussels'),
|
|
(349, 'Europe/Bucharest'),
|
|
(350, 'Europe/Budapest'),
|
|
(351, 'Europe/Chisinau'),
|
|
(352, 'Europe/Copenhagen'),
|
|
(353, 'Europe/Dublin'),
|
|
(354, 'Europe/Gibraltar'),
|
|
(355, 'Europe/Guernsey'),
|
|
(356, 'Europe/Helsinki'),
|
|
(357, 'Europe/Isle_of_Man'),
|
|
(358, 'Europe/Istanbul'),
|
|
(359, 'Europe/Jersey'),
|
|
(360, 'Europe/Kaliningrad'),
|
|
(361, 'Europe/Kiev'),
|
|
(362, 'Europe/Lisbon'),
|
|
(363, 'Europe/Ljubljana'),
|
|
(364, 'Europe/London'),
|
|
(365, 'Europe/Luxembourg'),
|
|
(366, 'Europe/Madrid'),
|
|
(367, 'Europe/Malta'),
|
|
(368, 'Europe/Mariehamn'),
|
|
(369, 'Europe/Minsk'),
|
|
(370, 'Europe/Monaco'),
|
|
(371, 'Europe/Moscow'),
|
|
(372, 'Europe/Nicosia'),
|
|
(373, 'Europe/Oslo'),
|
|
(374, 'Europe/Paris'),
|
|
(375, 'Europe/Podgorica'),
|
|
(376, 'Europe/Prague'),
|
|
(377, 'Europe/Riga'),
|
|
(378, 'Europe/Rome'),
|
|
(379, 'Europe/Samara'),
|
|
(380, 'Europe/San_Marino'),
|
|
(381, 'Europe/Sarajevo'),
|
|
(382, 'Europe/Simferopol'),
|
|
(383, 'Europe/Skopje'),
|
|
(384, 'Europe/Sofia'),
|
|
(385, 'Europe/Stockholm'),
|
|
(386, 'Europe/Tallinn'),
|
|
(387, 'Europe/Tirane'),
|
|
(388, 'Europe/Tiraspol'),
|
|
(389, 'Europe/Uzhgorod'),
|
|
(390, 'Europe/Vaduz'),
|
|
(391, 'Europe/Vatican'),
|
|
(392, 'Europe/Vienna'),
|
|
(393, 'Europe/Vilnius'),
|
|
(394, 'Europe/Volgograd'),
|
|
(395, 'Europe/Warsaw'),
|
|
(396, 'Europe/Zagreb'),
|
|
(397, 'Europe/Zaporozhye'),
|
|
(398, 'Europe/Zurich'),
|
|
(399, 'Indian/Antananarivo'),
|
|
(400, 'Indian/Chagos'),
|
|
(401, 'Indian/Christmas'),
|
|
(402, 'Indian/Cocos'),
|
|
(403, 'Indian/Comoro'),
|
|
(404, 'Indian/Kerguelen'),
|
|
(405, 'Indian/Mahe'),
|
|
(406, 'Indian/Maldives'),
|
|
(407, 'Indian/Mauritius'),
|
|
(408, 'Indian/Mayotte'),
|
|
(409, 'Indian/Reunion'),
|
|
(410, 'Pacific/Apia'),
|
|
(411, 'Pacific/Auckland'),
|
|
(412, 'Pacific/Chatham'),
|
|
(413, 'Pacific/Easter'),
|
|
(414, 'Pacific/Efate'),
|
|
(415, 'Pacific/Enderbury'),
|
|
(416, 'Pacific/Fakaofo'),
|
|
(417, 'Pacific/Fiji'),
|
|
(418, 'Pacific/Funafuti'),
|
|
(419, 'Pacific/Galapagos'),
|
|
(420, 'Pacific/Gambier'),
|
|
(421, 'Pacific/Guadalcanal'),
|
|
(422, 'Pacific/Guam'),
|
|
(423, 'Pacific/Honolulu'),
|
|
(424, 'Pacific/Johnston'),
|
|
(425, 'Pacific/Kiritimati'),
|
|
(426, 'Pacific/Kosrae'),
|
|
(427, 'Pacific/Kwajalein'),
|
|
(428, 'Pacific/Majuro'),
|
|
(429, 'Pacific/Marquesas'),
|
|
(430, 'Pacific/Midway'),
|
|
(431, 'Pacific/Nauru'),
|
|
(432, 'Pacific/Niue'),
|
|
(433, 'Pacific/Norfolk'),
|
|
(434, 'Pacific/Noumea'),
|
|
(435, 'Pacific/Pago_Pago'),
|
|
(436, 'Pacific/Palau'),
|
|
(437, 'Pacific/Pitcairn'),
|
|
(438, 'Pacific/Ponape'),
|
|
(439, 'Pacific/Port_Moresby'),
|
|
(440, 'Pacific/Rarotonga'),
|
|
(441, 'Pacific/Saipan'),
|
|
(442, 'Pacific/Samoa'),
|
|
(443, 'Pacific/Tahiti'),
|
|
(444, 'Pacific/Tarawa'),
|
|
(445, 'Pacific/Tongatapu'),
|
|
(446, 'Pacific/Truk'),
|
|
(447, 'Pacific/Wake'),
|
|
(448, 'Pacific/Wallis'),
|
|
(449, 'Pacific/Yap'),
|
|
(450, 'Brazil/Acre'),
|
|
(451, 'Brazil/DeNoronha'),
|
|
(452, 'Brazil/East'),
|
|
(453, 'Brazil/West'),
|
|
(454, 'Canada/Atlantic'),
|
|
(455, 'Canada/Central'),
|
|
(456, 'Canada/East-Saskatchewan'),
|
|
(457, 'Canada/Eastern'),
|
|
(458, 'Canada/Mountain'),
|
|
(459, 'Canada/Newfoundland'),
|
|
(460, 'Canada/Pacific'),
|
|
(461, 'Canada/Saskatchewan'),
|
|
(462, 'Canada/Yukon'),
|
|
(463, 'CET'),
|
|
(464, 'Chile/Continental'),
|
|
(465, 'Chile/EasterIsland'),
|
|
(466, 'CST6CDT'),
|
|
(467, 'Cuba'),
|
|
(468, 'EET'),
|
|
(469, 'Egypt'),
|
|
(470, 'Eire'),
|
|
(471, 'EST'),
|
|
(472, 'EST5EDT'),
|
|
(473, 'Etc/GMT'),
|
|
(474, 'Etc/GMT+0'),
|
|
(475, 'Etc/GMT+1'),
|
|
(476, 'Etc/GMT+10'),
|
|
(477, 'Etc/GMT+11'),
|
|
(478, 'Etc/GMT+12'),
|
|
(479, 'Etc/GMT+2'),
|
|
(480, 'Etc/GMT+3'),
|
|
(481, 'Etc/GMT+4'),
|
|
(482, 'Etc/GMT+5'),
|
|
(483, 'Etc/GMT+6'),
|
|
(484, 'Etc/GMT+7'),
|
|
(485, 'Etc/GMT+8'),
|
|
(486, 'Etc/GMT+9'),
|
|
(487, 'Etc/GMT-0'),
|
|
(488, 'Etc/GMT-1'),
|
|
(489, 'Etc/GMT-10'),
|
|
(490, 'Etc/GMT-11'),
|
|
(491, 'Etc/GMT-12'),
|
|
(492, 'Etc/GMT-13'),
|
|
(493, 'Etc/GMT-14'),
|
|
(494, 'Etc/GMT-2'),
|
|
(495, 'Etc/GMT-3'),
|
|
(496, 'Etc/GMT-4'),
|
|
(497, 'Etc/GMT-5'),
|
|
(498, 'Etc/GMT-6'),
|
|
(499, 'Etc/GMT-7'),
|
|
(500, 'Etc/GMT-8'),
|
|
(501, 'Etc/GMT-9'),
|
|
(502, 'Etc/GMT0'),
|
|
(503, 'Etc/Greenwich'),
|
|
(504, 'Etc/UCT'),
|
|
(505, 'Etc/Universal'),
|
|
(506, 'Etc/UTC'),
|
|
(507, 'Etc/Zulu'),
|
|
(508, 'Factory'),
|
|
(509, 'GB'),
|
|
(510, 'GB-Eire'),
|
|
(511, 'GMT'),
|
|
(512, 'GMT+0'),
|
|
(513, 'GMT-0'),
|
|
(514, 'GMT0'),
|
|
(515, 'Greenwich'),
|
|
(516, 'Hongkong'),
|
|
(517, 'HST'),
|
|
(518, 'Iceland'),
|
|
(519, 'Iran'),
|
|
(520, 'Israel'),
|
|
(521, 'Jamaica'),
|
|
(522, 'Japan'),
|
|
(523, 'Kwajalein'),
|
|
(524, 'Libya'),
|
|
(525, 'MET'),
|
|
(526, 'Mexico/BajaNorte'),
|
|
(527, 'Mexico/BajaSur'),
|
|
(528, 'Mexico/General'),
|
|
(529, 'MST'),
|
|
(530, 'MST7MDT'),
|
|
(531, 'Navajo'),
|
|
(532, 'NZ'),
|
|
(533, 'NZ-CHAT'),
|
|
(534, 'Poland'),
|
|
(535, 'Portugal'),
|
|
(536, 'PRC'),
|
|
(537, 'PST8PDT'),
|
|
(538, 'ROC'),
|
|
(539, 'ROK'),
|
|
(540, 'Singapore'),
|
|
(541, 'Turkey'),
|
|
(542, 'UCT'),
|
|
(543, 'Universal'),
|
|
(544, 'US/Alaska'),
|
|
(545, 'US/Aleutian'),
|
|
(546, 'US/Arizona'),
|
|
(547, 'US/Central'),
|
|
(548, 'US/East-Indiana'),
|
|
(549, 'US/Eastern'),
|
|
(550, 'US/Hawaii'),
|
|
(551, 'US/Indiana-Starke'),
|
|
(552, 'US/Michigan'),
|
|
(553, 'US/Mountain'),
|
|
(554, 'US/Pacific'),
|
|
(555, 'US/Pacific-New'),
|
|
(556, 'US/Samoa'),
|
|
(557, 'UTC'),
|
|
(558, 'W-SU'),
|
|
(559, 'WET'),
|
|
(560, 'Zulu');
|
|
|
|
/* PHP:blocknewsletter(); */;
|
|
/* PHP:set_payment_module_group(); */;
|
|
/* PHP:add_new_tab(AdminGenerator, fr:Générateurs|es:Generadores|en:Generators|de:Generatoren|it:Generatori, 9); */;
|