/magento/app/code/core/Mage/Sendfriend/sql/sendfriend_setup/install-1.6.0.0.php
PHP | 60 lines | 31 code | 4 blank | 25 comment | 0 complexity | aa4ee702de32ed6afce2647e424fa81e MD5 | raw file
Possible License(s): LGPL-3.0
- <?php
- /**
- * Magento
- *
- * 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@magentocommerce.com so we can send you a copy immediately.
- *
- * DISCLAIMER
- *
- * Do not edit or add to this file if you wish to upgrade Magento to newer
- * versions in the future. If you wish to customize Magento for your
- * needs please refer to http://www.magentocommerce.com for more information.
- *
- * @category Mage
- * @package Mage_Sendfriend
- * @copyright Copyright (c) 2012 Magento Inc. (http://www.magentocommerce.com)
- * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
- */
- $installer = $this;
- /* @var $installer Mage_Sendfriend_Model_Resource_Setup */
- $installer->startSetup();
- $table = $installer->getConnection()
- ->newTable($installer->getTable('sendfriend/sendfriend'))
- ->addColumn('log_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(
- 'identity' => true,
- 'unsigned' => true,
- 'nullable' => false,
- 'primary' => true,
- ), 'Log ID')
- ->addColumn('ip', Varien_Db_Ddl_Table::TYPE_BIGINT, '20', array(
- 'unsigned' => true,
- 'nullable' => false,
- 'default' => '0',
- ), 'Customer IP address')
- ->addColumn('time', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(
- 'unsigned' => true,
- 'nullable' => false,
- 'default' => '0',
- ), 'Log time')
- ->addColumn('website_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array(
- 'unsigned' => true,
- 'nullable' => false,
- 'default' => '0',
- ), 'Website ID')
- ->addIndex($installer->getIdxName('sendfriend/sendfriend', 'ip'), 'ip')
- ->addIndex($installer->getIdxName('sendfriend/sendfriend', 'time'), 'time')
- ->setComment('Send to friend function log storage table');
- $installer->getConnection()->createTable($table);
- $installer->endSetup();