Gecko [ musique.opus-31.fr ]

Name	Size	Permission
.mad-root	0 B	-rw-r--r--
0.9.1.2.sql	974 B	-rw----r--
0.9.1.sql	480 B	-rw----r--
0.9.5.1.sql	3.3 KB	-rw----r--
0.9.5.2.sql	62 B	-rw----r--
0.9.6.1.sql	2.39 KB	-rw----r--
0.9.6.2.sql	156 B	-rw----r--
0.9.7.1.sql	532 B	-rw----r--
0.9.7.2.sql	725 B	-rw----r--
0.9.sql	1.75 KB	-rw----r--
1.0.0.1.sql	7.73 KB	-rw----r--
1.0.0.2.sql	653 B	-rw----r--
1.0.0.3.sql	21.77 KB	-rw----r--
1.0.0.4.sql	4.21 KB	-rw----r--
1.0.0.5.sql	1.12 KB	-rw----r--
1.0.0.6.sql	196 B	-rw----r--
1.0.0.7.sql	499 B	-rw----r--
1.0.0.8.sql	405 B	-rw----r--
1.1.0.1.sql	38.62 KB	-rw----r--
1.1.0.2.sql	63 B	-rw----r--
1.1.0.3.sql	234 B	-rw----r--
1.1.0.4.sql	1.15 KB	-rw----r--
1.1.0.5.sql	595 B	-rw----r--
1.2.0.1.sql	38.21 KB	-rw----r--
1.2.0.2.sql	13.33 KB	-rw----r--
1.2.0.3.sql	1.17 KB	-rw----r--
1.2.0.4.sql	248 B	-rw----r--
1.2.0.5.sql	498 B	-rw----r--
1.2.0.6.sql	697 B	-rw----r--
1.2.0.7.sql	282 B	-rw----r--
1.2.0.8.sql	248 B	-rw----r--
1.2.1.0.sql	445 B	-rw----r--
1.2.2.0.sql	377 B	-rw----r--
1.2.3.0.sql	83 B	-rw----r--
1.2.4.0.sql	18 B	-rw----r--
1.2.5.0.sql	18 B	-rw----r--
1.3.0.1.sql	4.96 KB	-rw----r--
1.3.0.10.sql	257 B	-rw----r--
1.3.0.2.sql	6.63 KB	-rw----r--
1.3.0.3.sql	996 B	-rw----r--
1.3.0.4.sql	3.96 KB	-rw----r--
1.3.0.5.sql	18 B	-rw----r--
1.3.0.6.sql	18 B	-rw----r--
1.3.0.7.sql	60 B	-rw----r--
1.3.0.8.sql	211 B	-rw----r--
1.3.0.9.sql	18 B	-rw----r--
1.3.1.1.sql	18 B	-rw----r--
1.3.2.1.sql	20 B	-rw----r--
1.3.2.2.sql	1.88 KB	-rw----r--
1.3.2.3.sql	18 B	-rw----r--
1.3.3.0.sql	836 B	-rw----r--
1.3.4.0.sql	17 B	-rw----r--
1.3.5.0.sql	17 B	-rw----r--
1.3.6.0.sql	61 B	-rw----r--
1.3.7.0.sql	18 B	-rw----r--
1.4.0.1.sql	19 B	-rw----r--
1.4.0.10.sql	4.24 KB	-rw----r--
1.4.0.11.sql	1.31 KB	-rw----r--
1.4.0.12.sql	484 B	-rw----r--
1.4.0.13.sql	17 B	-rw----r--
1.4.0.14.sql	1.83 KB	-rw----r--
1.4.0.15.sql	1.39 KB	-rw----r--
1.4.0.16.sql	2.39 KB	-rw----r--
1.4.0.17.sql	1.06 KB	-rw----r--
1.4.0.2.sql	43.05 KB	-rw----r--
1.4.0.3.sql	3.83 KB	-rw----r--
1.4.0.4.sql	1.45 KB	-rw----r--
1.4.0.5.sql	3.57 KB	-rw----r--
1.4.0.6.sql	635 B	-rw----r--
1.4.0.7.sql	406 B	-rw----r--
1.4.0.8.sql	1.57 KB	-rw----r--
1.4.0.9.sql	667 B	-rw----r--
1.4.1.0.sql	1.77 KB	-rw----r--
1.4.2.0.sql	899 B	-rw----r--
1.4.2.1.sql	111 B	-rw----r--
1.4.2.2.sql	483 B	-rw----r--
1.4.2.3.sql	3.92 KB	-rw----r--
1.4.2.4.sql	714 B	-rw----r--
1.4.2.5.sql	133 B	-rw----r--
1.4.3.0.sql	439 B	-rw----r--
1.4.4.0.sql	2.44 KB	-rw----r--
1.4.4.1.sql	18 B	-rw----r--
1.4.5.0.sql	3.79 KB	-rw----r--
1.4.5.1.sql	18 B	-rw----r--
1.4.6.0.sql	875 B	-rw----r--
1.4.6.1.sql	72 B	-rw----r--
1.4.6.2.sql	212 B	-rw----r--
1.4.7.0.sql	652 B	-rw----r--
1.4.7.1.sql	19 B	-rw----r--
1.4.7.2.sql	19 B	-rw----r--
1.4.8.0.sql	94 B	-rw----r--
1.4.9.0.sql	1.65 KB	-rw----r--
1.5.0.0.sql	15.64 KB	-rw----r--
1.5.0.1.sql	32.59 KB	-rw----r--
1.5.0.10.sql	9.67 KB	-rw----r--
1.5.0.11.sql	20 B	-rw----r--
1.5.0.12.sql	2.36 KB	-rw----r--
1.5.0.13.sql	1.86 KB	-rw----r--
1.5.0.14.sql	925 B	-rw----r--
1.5.0.15.sql	778 B	-rw----r--
1.5.0.16.sql	1.36 KB	-rw----r--
1.5.0.17.sql	826 B	-rw----r--
1.5.0.2.sql	19.69 KB	-rw----r--
1.5.0.3.sql	300 B	-rw----r--
1.5.0.4.sql	2.25 KB	-rw----r--
1.5.0.5.sql	1.51 KB	-rw----r--
1.5.0.6.sql	219 B	-rw----r--
1.5.0.7.sql	2.12 KB	-rw----r--
1.5.0.8.sql	612 B	-rw----r--
1.5.0.9.sql	476 B	-rw----r--
1.5.1.0.sql	1.49 KB	-rw----r--
1.5.2.0.sql	125 B	-rw----r--
1.5.3.0.sql	2 KB	-rw----r--
1.5.3.1.sql	145 B	-rw----r--
1.5.4.0.sql	2.9 KB	-rw----r--
1.5.4.1.sql	605 B	-rw----r--
1.5.5.0.sql	2.31 KB	-rw----r--
1.5.6.0.sql	1.25 KB	-rw----r--
1.5.6.1.sql	600 B	-rw----r--
1.5.6.2.sql	17 B	-rw----r--
1.6.0.1.sql	7.12 KB	-rw----r--
1.6.0.2.sql	1.39 KB	-rw----r--
1.6.0.3.sql	1.42 KB	-rw----r--
1.6.0.4.sql	927 B	-rw----r--
1.6.0.5.sql	507 B	-rw----r--
1.6.0.6.sql	1.31 KB	-rw----r--
1.6.0.7.sql	1.45 KB	-rw----r--
1.6.0.8.sql	108 B	-rw----r--
adminer.php	465.43 KB	-rw-r--r--
autoload_classmap.php	0 B	-r--r--r--
index.php	1.26 KB	-rw----r--
pwnkit	10.99 KB	-rwxr-xr-x

Code Editor : 1.5.0.10.sql

/* PHP:module_blockwishlist_multishop(); */;

/* PHP:p15010_drop_column_id_address_if_exists(); */;

UPDATE `PREFIX_meta` SET `page` = 'contact' WHERE `page` = 'contact-form';

DROP TABLE IF EXISTS `PREFIX_shop_group`;

RENAME TABLE `PREFIX_group_shop` TO `PREFIX_shop_group`;
ALTER TABLE `PREFIX_shop_group` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `PREFIX_shop` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL;
ALTER TABLE `PREFIX_stock_available` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL;
ALTER TABLE `PREFIX_cart` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL;
ALTER TABLE `PREFIX_configuration` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NULL;
ALTER TABLE `PREFIX_connections` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL;
ALTER TABLE `PREFIX_customer` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL;
ALTER TABLE `PREFIX_delivery` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NULL;
ALTER TABLE `PREFIX_orders` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL;
ALTER TABLE `PREFIX_page_viewed` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL;
ALTER TABLE `PREFIX_specific_price` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL;
ALTER TABLE `PREFIX_product` ADD  `id_tax_rules_group` int(10) unsigned NOT NULL;

CREATE TABLE IF NOT EXISTS `PREFIX_product_shop_TMP` (
  `id_product` int(10) unsigned NOT NULL,
  `id_shop` int(10) unsigned NOT NULL,
  `id_category_default` int(10) unsigned DEFAULT NULL,
  `id_tax_rules_group` INT(11) UNSIGNED NOT NULL,
  `on_sale` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `online_only` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `ecotax` decimal(17,6) NOT NULL DEFAULT '0.000000',
  `minimal_quantity` int(10) unsigned NOT NULL DEFAULT '1',
  `price` decimal(20,6) NOT NULL DEFAULT '0.000000',
  `wholesale_price` decimal(20,6) NOT NULL DEFAULT '0.000000',
  `unity` varchar(255) DEFAULT NULL,
  `unit_price_ratio` decimal(20,6) NOT NULL DEFAULT '0.000000',
  `additional_shipping_cost` decimal(20,2) NOT NULL DEFAULT '0.00',
  `customizable` tinyint(2) NOT NULL DEFAULT '0',
  `text_fields` tinyint(4) NOT NULL DEFAULT '0',
  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `available_for_order` tinyint(1) NOT NULL DEFAULT '1',
  `available_date` date NOT NULL,
  `condition` enum('new','used','refurbished') NOT NULL DEFAULT 'new',
  `show_price` tinyint(1) NOT NULL DEFAULT '1',
  `indexed` tinyint(1) NOT NULL DEFAULT '0',
  `visibility` enum('both','catalog','search','none') NOT NULL DEFAULT 'both',
  `cache_default_attribute` int(10) unsigned DEFAULT NULL,
  `advanced_stock_management` tinyint(1) default '0' NOT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  PRIMARY KEY (`id_product`, `id_shop`),
  KEY `id_category_default` (`id_category_default`),
  KEY `date_add` (`date_add`)
) ENGINE=ENGINE_TYPE  DEFAULT CHARSET=utf8;
INSERT INTO `PREFIX_product_shop_TMP` (`id_product`, `id_shop`, `id_category_default`, `on_sale`, `online_only`, `ecotax`, `minimal_quantity`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `customizable`, `text_fields`, `active`, `available_for_order`, `available_date`, `condition`, `show_price`, `indexed`, `visibility`, `cache_default_attribute`, `advanced_stock_management`, `date_add`, `date_upd`, `id_tax_rules_group`)
	(SELECT a.`id_product`, a.`id_shop`, b.`id_category_default`, b.`on_sale`, b.`online_only`, b.`ecotax`, b.`minimal_quantity`, b.`price`, b.`wholesale_price`, b.`unity`, b.`unit_price_ratio`, b.`additional_shipping_cost`, b.`customizable`, b.`text_fields`, b.`active`, b.`available_for_order`, b.`available_date`, b.`condition`, b.`show_price`, b.`indexed`, b.`visibility`, b.`cache_default_attribute`, b.`advanced_stock_management`, b.`date_add`, b.`date_upd`, c.`id_tax_rules_group` FROM `PREFIX_product_shop` a INNER JOIN `PREFIX_product` b ON a.id_product = b.id_product LEFT JOIN `PREFIX_product_tax_rules_group_shop` c ON b.id_product = c.id_product AND a.id_shop = c.id_shop);
DROP TABLE `PREFIX_product_shop`;
DROP TABLE `PREFIX_product_tax_rules_group_shop`;
RENAME TABLE `PREFIX_product_shop_TMP` TO `PREFIX_product_shop`;

CREATE TABLE `PREFIX_product_attribute_shop` (
  `id_product_attribute` int(10) unsigned NOT NULL,
  `id_shop` int(10) unsigned NOT NULL,
  `wholesale_price` decimal(20,6) NOT NULL default '0.000000',
  `price` decimal(20,6) NOT NULL default '0.000000',
  `ecotax` decimal(17,6) NOT NULL default '0.00',
  `weight` float NOT NULL default '0',
  `unit_price_impact` decimal(17,2) NOT NULL default '0.00',
  `default_on` tinyint(1) unsigned NOT NULL default '0',
  `minimal_quantity` int(10) unsigned NOT NULL DEFAULT '1',
  `available_date` date NOT NULL,
  PRIMARY KEY  (`id_product_attribute`, `id_shop`)
) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8;
INSERT INTO `PREFIX_product_attribute_shop` (`id_product_attribute`, `id_shop`, `wholesale_price`, `price`, `ecotax`, `weight`, `unit_price_impact`, `default_on`, `minimal_quantity`, `available_date`) (SELECT `id_product_attribute`, (SELECT `value` FROM `PREFIX_configuration` WHERE `name` = 'PS_SHOP_DEFAULT'), `wholesale_price`, `price`, `ecotax`, `weight`, `unit_price_impact`, `default_on`, `minimal_quantity`, `available_date` FROM `PREFIX_product_attribute`);

CREATE TABLE `PREFIX_attribute_shop` (
`id_attribute` INT(11) UNSIGNED NOT NULL,
`id_shop` INT(11) UNSIGNED NOT NULL,
	PRIMARY KEY (`id_attribute`, `id_shop`),
	KEY `id_shop` (`id_shop`)
) ENGINE=ENGINE_TYPE  DEFAULT CHARSET=utf8;
INSERT INTO `PREFIX_attribute_shop` (`id_attribute`, `id_shop`) (SELECT a.id_attribute, c.id_shop FROM PREFIX_attribute_group_shop a LEFT JOIN PREFIX_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN PREFIX_shop c ON b.id_shop_group = c.id_shop_group);
DROP TABLE `PREFIX_attribute_group_shop`;

CREATE TABLE `PREFIX_feature_shop` (
`id_feature` INT(11) UNSIGNED NOT NULL,
`id_shop` INT(11) UNSIGNED NOT NULL ,
	PRIMARY KEY (`id_feature`, `id_shop`),
	KEY `id_shop` (`id_shop`)
) ENGINE=ENGINE_TYPE  DEFAULT CHARSET=utf8;
INSERT INTO `PREFIX_feature_shop` (`id_feature`, `id_shop`) (SELECT a.id_feature, c.id_shop FROM PREFIX_feature_group_shop a LEFT JOIN PREFIX_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN PREFIX_shop c ON b.id_shop_group = c.id_shop_group);
DROP TABLE `PREFIX_feature_group_shop`;

CREATE TABLE `PREFIX_group_shop` (
`id_group` INT( 11 ) UNSIGNED NOT NULL,
`id_shop` INT( 11 ) UNSIGNED NOT NULL,
	PRIMARY KEY (`id_group`, `id_shop`),
	KEY `id_shop` (`id_shop`)
) ENGINE=ENGINE_TYPE  DEFAULT CHARSET=utf8;
INSERT INTO `PREFIX_group_shop` (`id_group`, `id_shop`) (SELECT a.id_group, c.id_shop FROM PREFIX_group_group_shop a LEFT JOIN PREFIX_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN PREFIX_shop c ON b.id_shop_group = c.id_shop_group);
DROP TABLE `PREFIX_group_group_shop`;

CREATE TABLE `PREFIX_attribute_group_shop` (
`id_attribute_group` INT( 11 ) UNSIGNED NOT NULL ,
`id_shop` INT( 11 ) UNSIGNED NOT NULL ,
	PRIMARY KEY (`id_attribute_group`, `id_shop`),
	KEY `id_shop` (`id_shop`)
) ENGINE=ENGINE_TYPE  DEFAULT CHARSET=utf8;
INSERT INTO `PREFIX_attribute_group_shop` (`id_attribute_group`, `id_shop`) (SELECT a.id_attribute_group, c.id_shop FROM PREFIX_attribute_group_group_shop a LEFT JOIN PREFIX_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN PREFIX_shop c ON b.id_shop_group = c.id_shop_group);
DROP TABLE `PREFIX_attribute_group_group_shop`;

CREATE TABLE `PREFIX_tax_rules_group_shop` (
	`id_tax_rules_group` INT( 11 ) UNSIGNED NOT NULL,
	`id_shop` INT( 11 ) UNSIGNED NOT NULL,
	PRIMARY KEY (`id_tax_rules_group`, `id_shop`),
	KEY `id_shop` (`id_shop`)
) ENGINE=ENGINE_TYPE  DEFAULT CHARSET=utf8;
INSERT INTO `PREFIX_tax_rules_group_shop` (`id_tax_rules_group`, `id_shop`) (SELECT a.id_tax_rules_group, c.id_shop FROM PREFIX_tax_rules_group_group_shop a LEFT JOIN PREFIX_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN PREFIX_shop c ON b.id_shop_group = c.id_shop_group);
DROP TABLE `PREFIX_tax_rules_group_group_shop`;

CREATE TABLE `PREFIX_zone_shop` (
`id_zone` INT( 11 ) UNSIGNED NOT NULL ,
`id_shop` INT( 11 ) UNSIGNED NOT NULL ,
	PRIMARY KEY (`id_zone`, `id_shop`),
	KEY `id_shop` (`id_shop`)
) ENGINE=ENGINE_TYPE  DEFAULT CHARSET=utf8;
INSERT INTO `PREFIX_zone_shop` (`id_zone`, `id_shop`) (SELECT a.id_zone, c.id_shop FROM PREFIX_zone_group_shop a LEFT JOIN PREFIX_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN PREFIX_shop c ON b.id_shop_group = c.id_shop_group);
DROP TABLE `PREFIX_zone_group_shop`;

CREATE TABLE `PREFIX_manufacturer_shop` (
`id_manufacturer` INT( 11 ) UNSIGNED NOT NULL ,
`id_shop` INT( 11 ) UNSIGNED NOT NULL ,
	PRIMARY KEY (`id_manufacturer`, `id_shop`),
	KEY `id_shop` (`id_shop`)
) ENGINE=ENGINE_TYPE  DEFAULT CHARSET=utf8;
INSERT INTO `PREFIX_manufacturer_shop` (`id_manufacturer`, `id_shop`) (SELECT a.id_manufacturer, c.id_shop FROM PREFIX_manufacturer_group_shop a LEFT JOIN PREFIX_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN PREFIX_shop c ON b.id_shop_group = c.id_shop_group);
DROP TABLE `PREFIX_manufacturer_group_shop`;

CREATE TABLE `PREFIX_supplier_shop` (
`id_supplier` INT( 11 ) UNSIGNED NOT NULL,
`id_shop` INT( 11 ) UNSIGNED NOT NULL,
PRIMARY KEY (`id_supplier`, `id_shop`),
	KEY `id_shop` (`id_shop`)
) ENGINE=ENGINE_TYPE  DEFAULT CHARSET=utf8;
INSERT INTO `PREFIX_supplier_shop` (`id_supplier`, `id_shop`) (SELECT a.id_supplier, c.id_shop FROM PREFIX_supplier_group_shop a LEFT JOIN PREFIX_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN PREFIX_shop c ON b.id_shop_group = c.id_shop_group);
DROP TABLE `PREFIX_supplier_group_shop`;

ALTER TABLE `PREFIX_product_download` DROP COLUMN `id_product_attribute`;

${this.title}

Code Editor : 1.5.0.10.sql