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.0.0.1.sql

/* PHP */
/* PHP:latin1_database_to_utf8(); */;

/* STRUCTURE */
SET NAMES 'utf8';

CREATE TABLE PREFIX_attribute_impact (
  id_attribute_impact int(11) NOT NULL AUTO_INCREMENT,
  id_product int(11) NOT NULL,
  id_attribute int(11) NOT NULL,
  weight float NOT NULL,
  price decimal(10,2) NOT NULL,
  PRIMARY KEY  (id_attribute_impact),
  UNIQUE KEY id_product (id_product,id_attribute)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE PREFIX_supplier_lang (
  id_supplier INTEGER UNSIGNED NOT NULL,
  id_lang INTEGER UNSIGNED NOT NULL,
  description TEXT NULL,
  INDEX supplier_lang_index(id_supplier, id_lang)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE PREFIX_manufacturer_lang (
  id_manufacturer INTEGER UNSIGNED NOT NULL,
  id_lang INTEGER UNSIGNED NOT NULL,
  description TEXT NULL,
  INDEX manufacturer_lang_index(id_manufacturer, id_lang)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE PREFIX_state (
  id_state int(10) unsigned NOT NULL AUTO_INCREMENT,
  id_country int(11) NOT NULL,
  name varchar(64) NOT NULL,
  iso_code varchar(3) NOT NULL,
  active tinyint(1) NOT NULL default 0,
  PRIMARY KEY (id_state)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE PREFIX_customer ADD secure_key VARCHAR(32) NOT NULL DEFAULT '-1' AFTER id_gender;
ALTER TABLE PREFIX_orders ADD secure_key VARCHAR(32) NOT NULL DEFAULT '-1' AFTER id_address_invoice;
ALTER TABLE PREFIX_product ADD id_category_default INT NULL AFTER id_tax;
ALTER TABLE PREFIX_category_product ADD position INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER id_product;
ALTER TABLE PREFIX_product ADD INDEX (id_category_default);
ALTER TABLE PREFIX_order_detail ADD ecotax DECIMAL(10, 2) NOT NULL DEFAULT 0 AFTER tax_rate;
ALTER TABLE PREFIX_employee
	CHANGE name lastname VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
	CHANGE surname firstname VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE PREFIX_address
	CHANGE name lastname VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
	CHANGE surname firstname VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE PREFIX_customer
	CHANGE name lastname VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
	CHANGE surname firstname VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE PREFIX_quick_access ADD new_window TINYINT( 1 ) NOT NULL DEFAULT 0 AFTER id_quick_access;

/*  CONTENTS */
UPDATE PREFIX_hook_module SET id_hook = 14 WHERE id_hook = 9;
UPDATE PREFIX_quick_access SET new_window = 1 WHERE id_quick_access = 2 LIMIT 1;
INSERT INTO PREFIX_hook (name, title, description, position) VALUES ('orderConfirmation', 'Order confirmation page', 'Called on order confirmation page', 0);
UPDATE PREFIX_order_detail odt
	SET product_price = (
		odt.product_price * (
			SELECT conversion_rate FROM PREFIX_currency c, PREFIX_orders o WHERE o.id_order = odt.id_order AND c.id_currency = o.id_currency
		)
);
UPDATE PREFIX_product p SET p.id_category_default = (SELECT id_category FROM PREFIX_category_product cp WHERE cp.id_product = p.id_product GROUP BY id_product ORDER BY cp.id_category ASC);
UPDATE PREFIX_category_product cp SET cp.position= cp.id_product;

/* 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), 'AdminPrintPDF', (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 = 'AdminPrintPDF' LIMIT 1),
	'Print invoices' FROM PREFIX_lang);
UPDATE `PREFIX_tab_lang` SET `name` = 'Impression factures'
	WHERE `id_tab` = (SELECT `id_tab` FROM `PREFIX_tab` t WHERE t.class_name = 'AdminPrintPDF')
	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 = 'AdminPrintPDF' LIMIT 1), 1, 1, 1, 1);

INSERT INTO PREFIX_tab (id_parent, class_name, position) VALUES (-1, 'AdminSearch', 2);
INSERT INTO PREFIX_tab_lang (id_lang, id_tab, name) (
	SELECT id_lang,
	(SELECT id_tab FROM PREFIX_tab t WHERE t.class_name = 'AdminSearch' 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 = 'AdminSearch')
	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 = 'AdminSearch' 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), 'AdminLocalization', (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 = 'AdminLocalization' LIMIT 1),
	'Localization' FROM PREFIX_lang);
UPDATE `PREFIX_tab_lang` SET `name` = 'Localisation'
	WHERE `id_tab` = (SELECT `id_tab` FROM `PREFIX_tab` t WHERE t.class_name = 'AdminLocalization')
	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 = 'AdminLocalization' 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 = 'AdminShipping' LIMIT 1) AS tmp), 'AdminStates', (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 = 'AdminShipping' 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 = 'AdminStates' LIMIT 1),
	'States' FROM PREFIX_lang);
UPDATE `PREFIX_tab_lang` SET `name` = 'Etats'
	WHERE `id_tab` = (SELECT `id_tab` FROM `PREFIX_tab` t WHERE t.class_name = 'AdminStates')
	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 = 'AdminStates' LIMIT 1), 1, 1, 1, 1);

INSERT INTO PREFIX_image_type (`name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`) VALUES ('home', 129, 129, 1, 0, 0, 0);

/* CONFIGURATION VARIABLE */
INSERT INTO PREFIX_configuration (name, value, date_add, date_upd) VALUES ('PS_NB_DAYS_NEW_PRODUCT', 20, NOW(), NOW());
INSERT INTO PREFIX_configuration (name, value, date_add, date_upd) VALUES ('PS_WEIGHT_UNIT', 'kg', NOW(), NOW());
INSERT INTO PREFIX_configuration (name, value, date_add, date_upd) VALUES ('PS_BLOCK_CART_AJAX', '1', NOW(), NOW());
INSERT INTO PREFIX_configuration (name, value, date_add, date_upd) VALUES ('PS_FO_PROTOCOL', 'http://', NOW(), NOW());
UPDATE PREFIX_configuration SET name = 'PS_MAIL_SMTP_PORT', value = 25 WHERE name = 'PS_MAIL_SMTP_PORT' AND value = 'default';
UPDATE PREFIX_configuration SET name = 'PS_MAIL_SMTP_PORT', value = 465 WHERE name = 'PS_MAIL_SMTP_PORT' AND value = 'secure';

/* PHP:add_new_tab(AdminPDF, fr:PDF|es:PDF|en:PDF|de:PDF|it:PDF, 3); */;

${this.title}

Code Editor : 1.0.0.1.sql