<?php
/**
 * J2T RewardsPoint2
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Open Software License (OSL 3.0)
 * that is 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@j2t-design.com so we can send you a copy immediately.
 *
 * @category   Magento extension
 * @package    RewardsPoint2
 * @copyright  Copyright (c) 2009 J2T DESIGN. (http://www.j2t-design.com)
 * @license    http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
 */
?>
<?php

/*
ALTER TABLE `rewardpoints_account` ADD `date_start` DATE NULL DEFAULT NULL AFTER `points_spent` ,
ADD `date_end` DATE NULL DEFAULT NULL AFTER `date_start`
ALTER TABLE rewardpoints_account DROP INDEX FK_catalog_category_ENTITY_STORE
ALTER TABLE `rewardpoints_account` CHANGE `store_id` `store_id` TEXT NULL DEFAULT NULL
*/
$sqls = array();
$connection = Mage::getSingleton('core/resource')
                 ->getConnection('rewardpoints_read');
$select = $connection->select()
                    ->from('information_schema.COLUMNS')
                    ->where("COLUMN_NAME='date_start' AND TABLE_NAME='{$this->getTable('rewardpoints_account')}'");
$data = $connection->fetchRow($select);
if(!isset($data['COLUMN_NAME'])){
    $sqls[] = "ALTER TABLE {$this->getTable('rewardpoints_account')} ADD COLUMN `date_start` DATE NULL DEFAULT NULL AFTER `points_spent` , ADD `date_end` DATE NULL DEFAULT NULL AFTER `date_start`;";

    //$installer = $this;
    /* @var $installer Mage_Core_Model_Resource_Setup */
    /*
    $installer->startSetup();

    $installer->run("
    ALTER TABLE {$this->getTable('rewardpoints_account')} ADD COLUMN `date_start` DATE NULL DEFAULT NULL AFTER `points_spent` , ADD `date_end` DATE NULL DEFAULT NULL AFTER `date_start`;
    ");

    $installer->endSetup();

     */
}
/*
SELECT COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME='store_id' AND DATA_TYPE='text' AND table_name = 'rewardpoints_account'
 */
$select = $connection->select()
                    ->from('information_schema.COLUMNS')
                    ->where("COLUMN_NAME='store_id' AND TABLE_NAME='{$this->getTable('rewardpoints_account')}'");
$data = $connection->fetchRow($select);
if(!isset($data['COLUMN_NAME'])){
    $sqls[] = "ALTER TABLE {$this->getTable('rewardpoints_account')} DROP INDEX FK_catalog_category_ENTITY_STORE;";
    $sqls[] = "ALTER TABLE {$this->getTable('rewardpoints_account')} CHANGE `store_id` `store_id` TEXT NULL DEFAULT NULL;";
}

if ($sqls != array()){
    $installer = $this;
    $installer->run(implode(' ',$sqls));
    $installer->endSetup();
}