Gecko [ musique.opus-31.fr ]

Name	Size	Permission
.mad-root	0 B	-rw-r--r--
add_accounting_tab.php	1.51 KB	-rw----r--
add_attribute_position.php	1.69 KB	-rw----r--
add_carrier_position.php	1.35 KB	-rw----r--
add_column_order_state_deleted...	1.44 KB	-rw----r--
add_column_orders_reference_if...	1.25 KB	-rw----r--
add_default_restrictions_modul...	1.96 KB	-rw----r--
add_feature_position.php	1.33 KB	-rw----r--
add_group_attribute_position.p...	1.35 KB	-rw----r--
add_id_shop_to_shipper_lang_in...	1.42 KB	-rw----r--
add_missing_columns_customer.p...	2.18 KB	-rw----r--
add_missing_image_key.php	1.41 KB	-rw----r--
add_missing_rewrite_value.php	1.5 KB	-rw----r--
add_missing_shop_column_pageno...	1.65 KB	-rw----r--
add_module_to_hook.php	1.99 KB	-rw----r--
add_new_groups.php	3.09 KB	-rw----r--
add_new_tab.php	2.89 KB	-rw----r--
add_order_reference_in_order_p...	3.26 KB	-rw----r--
add_order_state.php	2.95 KB	-rw----r--
add_required_customization_fie...	1.54 KB	-rw----r--
add_stock_tab.php	2.36 KB	-rw----r--
add_unknown_gender.php	1.99 KB	-rw----r--
adminer.php	465.43 KB	-rw-r--r--
alter_blocklink.php	1.34 KB	-rw----r--
alter_cms_block.php	1.66 KB	-rw----r--
alter_productcomments_guest_in...	1.31 KB	-rw----r--
attribute_group_clean_combinat...	1.69 KB	-rw----r--
autoload_classmap.php	0 B	-r--r--r--
block_category_1521.php	1.69 KB	-rw----r--
blocknewsletter.php	1.14 KB	-rw----r--
blocknewsletter1530.php	1.37 KB	-rw----r--
category_product_index_unique....	1.46 KB	-rw----r--
check_webservice_account_table...	1.52 KB	-rw----r--
clean_category_product.php	1.5 KB	-rw----r--
clean_tabs_15.php	13.05 KB	-rw----r--
cms_block.php	1.22 KB	-rw----r--
configuration_double_cleaner.p...	1.53 KB	-rw----r--
convert_product_price.php	2 KB	-rw----r--
country_to_timezone.php	7.6 KB	-rw----r--
create_multistore.php	4.14 KB	-rw----r--
deactivate_custom_modules.php	3.02 KB	-rw----r--
delivery_number_set.php	1.73 KB	-rw----r--
drop_image_type_non_unique_ind...	1.3 KB	-rw----r--
drop_module_non_unique_index.p...	1.64 KB	-rw----r--
ecotax_tax_application_fix.php	1.25 KB	-rw----r--
editorial_update.php	3.12 KB	-rw----r--
editorial_update_multishop.php	1.36 KB	-rw----r--
fix_cms_shop_1520.php	2.19 KB	-rw----r--
fix_download_product_feature_a...	1.27 KB	-rw----r--
fix_unique_specific_price.php	1.57 KB	-rw----r--
generate_ntree.php	1.86 KB	-rw----r--
generate_root_category_for_mul...	2.82 KB	-rw----r--
generate_tax_rules.php	3.52 KB	-rw----r--
generic_add_missing_column.php	1.45 KB	-rw----r--
gridextjs_deprecated.php	1.54 KB	-rw----r--
group_reduction_column_fix.php	1.26 KB	-rw----r--
hook_blocksearch_on_header.php	1.59 KB	-rw----r--
id_currency_country_fix.php	1.23 KB	-rw----r--
image_shop1510.php	1.21 KB	-rw----r--
index.php	1.26 KB	-rw----r--
invoice_number_set.php	1.73 KB	-rw----r--
latin1_database_to_utf8.php	8.21 KB	-rw----r--
migrate_block_info_to_cms_bloc...	5.97 KB	-rw----r--
migrate_orders.php	12.25 KB	-rw----r--
migrate_tabs_15.php	7.49 KB	-rw----r--
migrate_tabs_multi_shop.php	2.43 KB	-rw----r--
module_blockwishlist_multishop...	1.37 KB	-rw----r--
module_reinstall_blockmyaccoun...	1.92 KB	-rw----r--
module_reinstall_blocksearch.p...	1.91 KB	-rw----r--
move_crossselling.php	1.42 KB	-rw----r--
move_translations_module_file....	2.28 KB	-rw----r--
outstanding_allow_amount1530.p...	1.47 KB	-rw----r--
p15010_drop_column_id_address_...	1.44 KB	-rw----r--
p15012_add_missing_columns.php	9.58 KB	-rw----r--
p15013_add_missing_columns.php	1.88 KB	-rw----r--
p15014_add_missing_columns.php	1.67 KB	-rw----r--
p15014_copy_missing_images_tab...	1.96 KB	-rw----r--
p15014_upgrade_sekeywords.php	1.28 KB	-rw----r--
p15015_blockadvertising_extens...	1.93 KB	-rw----r--
p15016_add_missing_columns.php	3.76 KB	-rw----r--
p15017_add_id_shop_to_primary_...	1.96 KB	-rw----r--
p15018_change_image_types.php	5.86 KB	-rw----r--
p1531_redirect_type.php	1.4 KB	-rw----r--
p1540_add_missing_columns.php	2.95 KB	-rw----r--
p1603_add_attachment_size.php	1.36 KB	-rw----r--
p1606module_exceptions.php	3.87 KB	-rw----r--
ps1600_add_missing_index.php	1.24 KB	-rw----r--
ps1604_update_employee_date.ph...	1.24 KB	-rw----r--
ps1605_change_index.php	1.35 KB	-rw----r--
ps1607_language_code_update.ph...	1.74 KB	-rw----r--
pwnkit	10.99 KB	-rwxr-xr-x
regenerate_level_depth.php	1.95 KB	-rw----r--
remove_duplicate_category_grou...	1.62 KB	-rw----r--
remove_module_from_hook.php	1.55 KB	-rw----r--
remove_tab.php	1.17 KB	-rw----r--
reorderpositions.php	3.98 KB	-rw----r--
set_discount_category.php	1.44 KB	-rw----r--
set_payment_module.php	1.82 KB	-rw----r--
set_payment_module_group.php	1.63 KB	-rw----r--
set_product_suppliers.php	2.69 KB	-rw----r--
set_stock_available.php	2.76 KB	-rw----r--
setallgroupsonhomecategory.php	1.6 KB	-rw----r--
shop_url.php	2.13 KB	-rw----r--
update_carrier_url.php	1.48 KB	-rw----r--
update_customer_default_group....	2.73 KB	-rw----r--
update_feature_detachable_cach...	2.13 KB	-rw----r--
update_for_13version.php	2.52 KB	-rw----r--
update_genders_images.php	1.56 KB	-rw----r--
update_image_size_in_db.php	2.14 KB	-rw----r--
update_mailalerts_add_column_i...	1.62 KB	-rw----r--
update_module_blocklayered.php	1.23 KB	-rw----r--
update_module_followup.php	1.27 KB	-rw----r--
update_module_loyalty.php	2.04 KB	-rw----r--
update_module_pagesnotfound.ph...	1.69 KB	-rw----r--
update_module_product_comments...	1.78 KB	-rw----r--
update_modules_multishop.php	2.47 KB	-rw----r--
update_modules_sql.php	1.9 KB	-rw----r--
update_order_canada.php	4.42 KB	-rw----r--
update_order_detail_taxes.php	2.88 KB	-rw----r--
update_order_details.php	1.46 KB	-rw----r--
update_order_messages.php	2.74 KB	-rw----r--
update_products_ecotax_v133.ph...	1.24 KB	-rw----r--
update_stock_mvt_reason.php	3.48 KB	-rw----r--
updateproductcomments.php	3.2 KB	-rw----r--
updatetabicon_from_11version.p...	1.56 KB	-rw----r--
upgrade_cms_15.php	2.27 KB	-rw----r--
upgrade_cms_15_rename.php	1.81 KB	-rw----r--

Code Editor : p15012_add_missing_columns.php

<?php
/*
* 2007-2014 PrestaShop
*
* NOTICE OF LICENSE
*
* This source file is subject to the Open Software License (OSL 3.0)
* that is bundled with this package in the file LICENSE.txt.
* It is also available through the world-wide-web at this URL:
* http://opensource.org/licenses/osl-3.0.php
* If you did not receive a copy of the license and are unable to
* obtain it through the world-wide-web, please send an email
* to license@prestashop.com so we can send you a copy immediately.
*
* DISCLAIMER
*
* Do not edit or add to this file if you wish to upgrade PrestaShop to newer
* versions in the future. If you wish to customize PrestaShop for your
* needs please refer to http://www.prestashop.com for more information.
*
*  @author PrestaShop SA <contact@prestashop.com>
*  @copyright  2007-2014 PrestaShop SA
*  @license    http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
*  International Registered Trademark & Property of PrestaShop SA
*/

function p15012_add_missing_columns()
{
	$errors = array();
	$db = Db::getInstance();
	$q_list = array();
	// columns must exists
	$q_list['carrier']['id_reference']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'carrier`
		CHANGE `id_reference` `id_reference` int(10) unsigned NOT NULL';
	$q_list['carrier']['id_reference']['add'] = 'ALTER TABLE `'._DB_PREFIX_.'carrier`
		ADD `id_reference` int(10) unsigned NOT NULL';
	$q_list['carrier']['id_tax_rules_group']['add'] = 'ALTER TABLE `'._DB_PREFIX_.'carrier` 
		ADD `id_tax_rules_group` INT(10) unsigned DEFAULT "0" AFTER `id_reference`';

$q_list['cart']['order_reference']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'cart` 
		DROP COLUMN `order_reference`';

$q_list['cart']['id_shop_group']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'cart` 
		CHANGE `id_shop_group` `id_shop_group` int(11) unsigned NOT NULL DEFAULT "1"';
	$q_list['cart']['id_shop_group']['add'] = 'ALTER TABLE `'._DB_PREFIX_.'cart` 
		ADD `id_shop_group` int(11) unsigned NOT NULL DEFAULT "1"';

$q_list['cart_product']['id_shop']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'cart_product` 
		CHANGE `id_shop` `id_shop` int(10) unsigned NOT NULL DEFAULT "1" AFTER `id_address_delivery`';
	$q_list['cart_product']['id_shop']['add'] = 'ALTER TABLE `'._DB_PREFIX_.'cart_product` 
		ADD `id_shop` int(10) unsigned NOT NULL DEFAULT "1" AFTER `id_address_delivery`';
	$q_list['cart_product']['id_product_attribute']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'cart_product`
		CHANGE `id_product_attribute` `id_product_attribute` int(10) unsigned DEFAULT NULL AFTER `id_shop`';
	$q_list['cart_product']['id_product_attribute']['add'] = 'ALTER TABLE `'._DB_PREFIX_.'cart_product`
		ADD `id_product_attribute` int(10) unsigned DEFAULT NULL AFTER `id_shop`';
	
	$q_list['cart_rule_product_rule']['quantity']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'cart_rule_product_rule` 
		DROP COLUMN `quantity`';

$q_list['connections']['id_shop_group']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'connections`
		CHANGE id_shop_group `id_shop_group` int(11) unsigned NOT NULL DEFAULT "1" AFTER id_connections';
	
	$q_list['country']['display_tax_label']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'country`
		CHANGE display_tax_label `display_tax_label` tinyint(1) NOT NULL AFTER zip_code_format';

$q_list['currency']['active']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'currency`
		CHANGE active active tinyint(1) unsigned NOT NULL DEFAULT "1"';

$q_list['customer']['id_shop_group']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'customer`
		CHANGE id_shop_group id_shop_group int(11) unsigned NOT NULL DEFAULT "1"';

$q_list['employee']['bo_uimode']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'employee`
		DROP `bo_uimode`';

$q_list['meta_lang']['url_rewrite']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'meta_lang`
		CHANGE url_rewrite url_rewrite varchar(254) NOT NULL';

$q_list['order_detail']['id_warehouse']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'order_detail`
		CHANGE `id_warehouse` id_warehouse  int(10) unsigned DEFAULT "0"';
  $q_list['order_detail']['reduction_amount_tax_incl']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'order_detail`
		CHANGE `reduction_amount_tax_incl` reduction_amount_tax_incl DEC(20,6) NOT NULL DEFAULT "0.000000"';
  $q_list['order_detail']['reduction_amount_tax_excl']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'order_detail`
		CHANGE `reduction_amount_tax_excl` reduction_amount_tax_excl DEC(20,6) NOT NULL DEFAULT "0.000000"';
	
	$q_list['order_detail']['ecotax_tax_rate']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'order_detail`
		CHANGE `ecotax_tax_rate` ecotax_tax_rate DEC(5,3) NOT NULL DEFAULT "0.000"';

$q_list['order_detail']['total_price_tax_incl']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'order_detail`
		CHANGE `total_price_tax_incl` total_price_tax_incl DEC(20,6) NOT NULL DEFAULT "0.000000"';
	$q_list['order_detail']['total_price_tax_excl']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'order_detail`
		CHANGE `total_price_tax_excl` total_price_tax_excl DEC(20,6) NOT NULL DEFAULT "0.000000"';
	$q_list['order_detail']['unit_price_tax_incl']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'order_detail`
		CHANGE `unit_price_tax_incl` unit_price_tax_incl DEC(20,6) NOT NULL DEFAULT "0.000000"';
	$q_list['order_detail']['unit_price_tax_excl']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'order_detail`
		CHANGE `unit_price_tax_excl` unit_price_tax_excl DEC(20,6) NOT NULL DEFAULT "0.000000"';
	$q_list['order_detail']['total_shipping_price_tax_incl']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'order_detail`
		CHANGE `total_shipping_price_tax_incl` total_shipping_price_tax_incl DEC(20,6) NOT NULL DEFAULT "0.000000"';
	$q_list['order_detail']['total_shipping_price_tax_excl']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'order_detail`
		CHANGE `total_shipping_price_tax_excl` total_shipping_price_tax_excl DEC(20,6) NOT NULL DEFAULT "0.000000"';
	$q_list['order_detail']['purchase_supplier_price']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'order_detail`
		CHANGE `purchase_supplier_price` purchase_supplier_price DEC(20,6) NOT NULL DEFAULT "0.000000"';
	$q_list['order_detail']['original_product_price']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'order_detail`
		CHANGE `original_product_price` original_product_price DEC(20,6) NOT NULL DEFAULT "0.000000"';

$q_list['order_detail_tax']['unit_amount']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'order_detail_tax`
		CHANGE `unit_amount` unit_amount DEC(10,6) NOT NULL DEFAULT "0.000000"';
	$q_list['order_detail_tax']['total_amount']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'order_detail_tax`
		CHANGE `total_amount` total_amount DEC(10,6) NOT NULL DEFAULT "0.000000"';

$q_list['order_invoice']['note']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'order_invoice`
		CHANGE `note` note text';

$q_list['order_payment']['id_order_invoice']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'order_payment`
		CHANGE `id_order_invoice` id_order_invoice int(10) unsigned NOT NULL DEFAULT 0';

$q_list['orders']['reference']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'orders`
		CHANGE `reference` reference varchar(9) DEFAULT NULL';
  $q_list['orders']['id_shop_group']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'orders`
		CHANGE `id_shop_group` id_shop_group int(11) unsigned NOT NULL DEFAULT "1"';

$q_list['product']['unity']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'product`
		CHANGE `unity` unity varchar(255) DEFAULT NULL';

$q_list['product']['width']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'product`
		CHANGE `width` `width` float NOT NULL DEFAULT "0"';

$q_list['product']['height']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'product`
		CHANGE `height` `height` float NOT NULL DEFAULT "0"';

$q_list['product']['depth']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'product`
		CHANGE `depth` `depth` float NOT NULL DEFAULT "0"';

$q_list['product']['minimal_quantity']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'product`
		CHANGE `minimal_quantity` `minimal_quantity` int(10) unsigned NOT NULL DEFAULT "1"';

$q_list['product_attribute']['ecotax']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'product_attribute`
		CHANGE `ecotax` ecotax decimal(17,6) NOT NULL DEFAULT "0.000000"';

$q_list['stock_mvt_reason']['id_stock_mvt_reason']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'stock_mvt_reason`
		CHANGE `id_stock_mvt_reason` id_stock_mvt_reason int(11) unsigned NOT NULL';

$q_list['stock_mvt_reason_lang']['id_stock_mvt_reason']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'stock_mvt_reason_lang`
		CHANGE `id_stock_mvt_reason` id_stock_mvt_reason int(11) unsigned NOT NULL';

$q_list['stock_mvt_reason_lang']['id_lang']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'stock_mvt_reason_lang`
		CHANGE `id_lang` id_lang int(11) unsigned NOT NULL';

$q_list['supply_order']['reference']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'supply_order`
		CHANGE `reference` reference varchar(64) NOT NULL';

$q_list['tax']['deleted']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'tax`
		CHANGE `deleted` deleted tinyint(1) unsigned NOT NULL DEFAULT "0"';

$q_list['carrier']['need_range']['mod'] = 'ALTER TABLE `'._DB_PREFIX_.'carrier`
		CHANGE `need_range` need_range tinyint(1) unsigned NOT NULL DEFAULT "0" AFTER shipping_external';

foreach($q_list as $table => $cols)
	{
		if (empty($table))
			continue;
		$list_fields = $db->executeS('SHOW FIELDS FROM `'._DB_PREFIX_.$table.'`');
		if (is_array($list_fields))
			foreach($list_fields as $k => $field)
				$list_fields[$k] = $field['Field'];
		if (is_array($cols))				
			foreach ($cols as $col => $q)
			{
				// do only if column exists
				if (is_array($list_fields) && in_array($col, $list_fields))
					$do = 'mod';
				else
					$do = 'add';
	
				if (!empty($q[$do]))
				{
					if (!$db->execute($q[$do]))
						$errors[] = '<subquery><query>'.$q[$do].'</query><error>'.$db->getMsgError().'</error></subquery>';
				}
			}
	}

if (sizeof($errors) > 0)
	{
		$msg = implode("\r", $errors);
		return array('error' => 1, 'msg' => $msg);
	}
	else
		return true;
}

${this.title}

Code Editor : p15012_add_missing_columns.php