all db.sql
---------------------------------------------
ALTER TABLE ps2_tab
	ADD `module` varchar(64) NULL AFTER class_name;

ALTER TABLE ps2_product
	ADD `indexed` tinyint(1) NOT NULL default '0' AFTER `active`;
	
ALTER TABLE ps2_orders
	DROP INDEX `orders_customer`;
ALTER TABLE ps2_orders
	ADD INDEX id_customer (id_customer);
ALTER TABLE ps2_orders
	ADD INDEX `id_cart` (`id_cart`);

ALTER TABLE ps2_order_state
	ADD hidden TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER unremovable;

ALTER TABLE ps2_carrier
	ADD is_module TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER range_behavior;
ALTER TABLE ps2_carrier
	ADD INDEX deleted (`deleted`, `active`);

ALTER TABLE ps2_state
	CHANGE iso_code `iso_code` char(4) NOT NULL;
	
ALTER TABLE ps2_order_detail
	CHANGE product_quantity_cancelled product_quantity_refunded INT(10) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE ps2_order_detail
	ADD INDEX product_id (product_id);

ALTER TABLE ps2_attribute_lang
	ADD INDEX id_lang (`id_lang`, `name`),
	ADD INDEX id_lang_2 (`id_lang`),
	ADD INDEX id_attribute (`id_attribute`);

ALTER TABLE ps2_block_cms
	ADD PRIMARY KEY (`id_block`, `id_cms`);

ALTER TABLE ps2_carrier_zone
	ADD INDEX `id_carrier` (`id_carrier`);

ALTER TABLE ps2_connections
	CHANGE `http_referer` `http_referer` VARCHAR(255) DEFAULT NULL;
ALTER TABLE ps2_connections
	ADD INDEX `date_add` (`date_add`);

ALTER TABLE ps2_customer
	DROP INDEX `customer_email`;
ALTER TABLE ps2_customer
	ADD UNIQUE `customer_email` (`email`);

ALTER TABLE ps2_delivery
	ADD INDEX id_zone (`id_zone`),
	ADD INDEX id_carrier (`id_carrier`, `id_zone`);

ALTER TABLE ps2_discount_category
	ADD INDEX id_discount (`id_discount`),
	ADD INDEX id_category (`id_category`);

ALTER TABLE ps2_feature_product
	ADD INDEX `id_feature` (`id_feature`);

ALTER TABLE ps2_hook_module
	DROP INDEX `hook_module_index`;
ALTER TABLE ps2_hook_module
	ADD PRIMARY KEY (id_module,id_hook);
ALTER TABLE ps2_hook_module
	ADD INDEX id_module (`id_module`),
	ADD INDEX id_hook (`id_hook`);

ALTER TABLE ps2_module
	CHANGE `active` `active` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0';

ALTER TABLE ps2_page
	CHANGE `id_object` `id_object` INT UNSIGNED NULL DEFAULT NULL;
ALTER TABLE ps2_page
	ADD INDEX `id_page_type` (`id_page_type`),
	ADD INDEX `id_object` (`id_object`);

ALTER TABLE ps2_page_type
	ADD INDEX `name` (`name`);
ALTER TABLE ps2_page_type
	CHANGE `name` `name` VARCHAR(255) NOT NULL;
	
ALTER TABLE ps2_product_attribute
	ADD INDEX reference (reference),
	ADD INDEX supplier_reference (supplier_reference);

ALTER TABLE ps2_product_lang
	ADD INDEX id_product (id_product),
	ADD INDEX id_lang (id_lang),
	ADD INDEX `name` (`name`),
	ADD FULLTEXT KEY ftsname (`name`);

ALTER TABLE ps2_discount_category
	ADD PRIMARY KEY (id_discount,id_category);

ALTER TABLE ps2_image_lang
	ADD INDEX id_image (id_image);

ALTER TABLE ps2_range_price
	CHANGE `delimiter1` `delimiter1` DECIMAL(13, 6) NOT NULL,
	CHANGE `delimiter2` `delimiter2` DECIMAL(13, 6) NOT NULL,
	CHANGE `id_carrier` `id_carrier` INT(10) UNSIGNED NOT NULL;
ALTER TABLE ps2_range_price
	DROP INDEX `range_price_unique`;
ALTER TABLE ps2_range_price
	ADD UNIQUE KEY `id_carrier` (`id_carrier`,`delimiter1`,`delimiter2`);

ALTER TABLE ps2_range_weight
	CHANGE `delimiter1` `delimiter1` DECIMAL(13, 6) NOT NULL,
	CHANGE `delimiter2` `delimiter2` DECIMAL(13, 6) NOT NULL,
	CHANGE `id_carrier` `id_carrier` INT(10) UNSIGNED NOT NULL;
ALTER TABLE ps2_range_weight
	DROP INDEX `range_weight_unique`;
ALTER TABLE ps2_range_weight
	ADD UNIQUE KEY `id_carrier` (`id_carrier`,`delimiter1`,`delimiter2`);

/* ############################################################ */

CREATE TABLE `ps2_customer_group` (
	`id_customer` int(10) unsigned NOT NULL,
	`id_group` int(10) unsigned NOT NULL,
	KEY `customer_group_index` (`id_customer`,`id_group`),
	KEY `id_customer` (`id_customer`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `ps2_search_index` (
  `id_product` int(11) NOT NULL,
  `id_word` int(11) NOT NULL,
  `weight` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`id_product`,`id_word`),
  INDEX  (`id_word`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `ps2_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;

// -----------------------------------------------------------
INSERT INTO `ps2_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES
('PS_SEARCH_MINWORDLEN', '3', NOW(), NOW()),
('PS_SEARCH_WEIGHT_PNAME', '6', NOW(), NOW()),
('PS_SEARCH_WEIGHT_REF', '10', NOW(), NOW()),
('PS_SEARCH_WEIGHT_SHORTDESC', '1', NOW(), NOW()),
('PS_SEARCH_WEIGHT_DESC', '1', NOW(), NOW()),
('PS_SEARCH_WEIGHT_CNAME', '3', NOW(), NOW()),
('PS_SEARCH_WEIGHT_MNAME', '3', NOW(), NOW()),
('PS_SEARCH_WEIGHT_TAG', '4', NOW(), NOW()),
('PS_SEARCH_WEIGHT_ATTRIBUTE', '2', NOW(), NOW()),
('PS_SEARCH_WEIGHT_FEATURE', '2', NOW(), NOW()),
('PS_TIMEZONE', '336', NOW(), NOW());

INSERT INTO ps2_hook (`name`, `title`, `description`, `position`) VALUES
	('shoppingCartExtra', 'Shopping cart extra button', 'Display some specific informations', 0),
	('search', 'Search', NULL, 0);


INSERT INTO ps2_tab (id_parent, class_name, position) VALUES ((SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM ps2_tab t WHERE t.class_name = 'AdminCatalog' LIMIT 1) AS tmp), 'AdminTags', (SELECT tmp.max FROM (SELECT MAX(position) max FROM `ps2_tab` WHERE id_parent = (SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM ps2_tab t WHERE t.class_name = 'AdminCatalog' LIMIT 1) AS tmp )) AS tmp));
INSERT INTO ps2_tab_lang (id_lang, id_tab, name) (
	SELECT id_lang,
	(SELECT id_tab FROM ps2_tab t WHERE t.class_name = 'AdminTags' LIMIT 1),
	'Tags' FROM ps2_lang);
INSERT INTO ps2_access (id_profile, id_tab, `view`, `add`, edit, `delete`) VALUES ('1', (SELECT id_tab FROM ps2_tab t WHERE t.class_name = 'AdminTags' LIMIT 1), 1, 1, 1, 1);

INSERT INTO ps2_tab (id_parent, class_name, position) VALUES ((SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM ps2_tab t WHERE t.class_name = 'AdminPreferences' LIMIT 1) AS tmp), 'AdminSearchConf', (SELECT tmp.max FROM (SELECT MAX(position) max FROM `ps2_tab` WHERE id_parent = (SELECT tmp.`id_tab` FROM (SELECT `id_tab` FROM ps2_tab t WHERE t.class_name = 'AdminPreferences' LIMIT 1) AS tmp )) AS tmp));
INSERT INTO ps2_tab_lang (id_lang, id_tab, name) (
	SELECT id_lang,
	(SELECT id_tab FROM ps2_tab t WHERE t.class_name = 'AdminSearchConf' LIMIT 1),
	'Search' FROM ps2_lang);
UPDATE `ps2_tab_lang` SET `name` = 'Recherche'
	WHERE `id_tab` = (SELECT `id_tab` FROM `ps2_tab` t WHERE t.class_name = 'AdminSearchConf')
	AND `id_lang` = (SELECT `id_lang` FROM `ps2_lang` l WHERE l.iso_code = 'fr');
INSERT INTO ps2_access (id_profile, id_tab, `view`, `add`, edit, `delete`) VALUES ('1', (SELECT id_tab FROM ps2_tab t WHERE t.class_name = 'AdminSearchConf' LIMIT 1), 1, 1, 1, 1);


/// manual Changes
ALTER TABLE ps2_referrer	
	ADD  click_fee decimal(3,2) NOT NULL default '0.00';
ALTER TABLE ps2_referrer
	ADD cache_orders INTEGER NULL;
ALTER TABLE ps2_referrer
	ADD cache_order_rate DECIMAL(5,2) NULL;
ALTER TABLE ps2_referrer
	ADD date_add DATETIME NOT NULL;

ALTER TABLE ps2_product_attribute_image
	ADD KEY (`id_image`);


---------------- Not execute: verification ------------------------------------------
INSERT INTO `ps2_hook` (`id_hook`, `name`, `title`, `description`, `position`) VALUES
(44, 'shoppingCartExtra', 'Shopping cart extra button', 'Display some specific informations', 0),
(45, 'search', 'Search', NULL, 0);

INSERT INTO `ps2_configuration` (`id_configuration`, `name`, `value`, `date_add`, `date_upd`) VALUES
(45, 'PS_SEARCH_MINWORDLEN', '3', NOW(), NOW()),
(46, 'PS_SEARCH_BLACKLIST', '', NOW(), NOW()),
(47, 'PS_SEARCH_WEIGHT_PNAME', '6', NOW(), NOW()),
(48, 'PS_SEARCH_WEIGHT_REF', '10', NOW(), NOW()),
(49, 'PS_SEARCH_WEIGHT_SHORTDESC', '1', NOW(), NOW()),
(50, 'PS_SEARCH_WEIGHT_DESC', '1', NOW(), NOW()),
(51, 'PS_SEARCH_WEIGHT_CNAME', '3', NOW(), NOW()),
(52, 'PS_SEARCH_WEIGHT_MNAME', '3', NOW(), NOW()),
(53, 'PS_SEARCH_WEIGHT_TAG', '4', NOW(), NOW()),
(54, 'PS_SEARCH_WEIGHT_ATTRIBUTE', '2', NOW(), NOW()),
(55, 'PS_SEARCH_WEIGHT_FEATURE', '2', NOW(), NOW()),
(56, 'PS_TIMEZONE', '336', NOW(), NOW());

INSERT INTO `ps2_configuration_lang` (`id_configuration`, `id_lang`, `value`, `date_upd`) VALUES (46, 1, 'a|the|of|on|in|and|to', NOW());
INSERT INTO `ps2_configuration_lang` (`id_configuration`, `id_lang`, `value`, `date_upd`) VALUES (46, 2, 'le|les|de|et|en|des|les|une', NOW());

INSERT INTO `ps2_tab` (`id_tab`, `class_name`, `id_parent`, `position`) VALUES
(66, 'AdminTags', 1, 7),
(63, 'AdminGroups', 2, 2),
(65, 'AdminCarts', 2, 3),                  # change
(67, 'AdminSearchConf', 8, 10),

INSERT INTO `ps2_tab_lang` (`id_lang`, `id_tab`, `name`) VALUES
(1, 66, 'Tags'),
(1, 67, 'Search'),
(2, 66, 'Tags'),
(2, 67, 'Recherche');