<?php 
/**
 * Magmodules.eu
 * http://www.magmodules.eu
 *
 * 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 info@magmodules.eu so we can send you a copy immediately.
 *
 * @category    Magmodules
 * @package     Magmodules_Sortbydate
 * @author      Magmodules <info@magmodules.eu)
 * @copyright   Copyright (c) 2013 (http://www.magmodules.eu)
 * @license     http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
 */

// Load Magento
require 'app/Mage.php'; 
Mage::app();

// Load attribute_id of created_at
$eavAttribute = new Mage_Eav_Model_Mysql4_Entity_Attribute();
$attribute_id = $eavAttribute->getIdByCode('catalog_product', 'created_at');

// Update database
if($attribute_id) {
	$write = Mage::getSingleton('core/resource')->getConnection('core_write');
	$sql  = "UPDATE catalog_eav_attribute SET used_for_sort_by = 1 WHERE attribute_id = '$attribute_id' LIMIT 1";
	$write->query($sql);
	echo 'Uninstalled!';
} else {
	echo 'Error!';
}	
?>