PageRenderTime 44ms CodeModel.GetById 23ms RepoModel.GetById 1ms app.codeStats 0ms

/magento/app/code/core/Mage/Sendfriend/sql/sendfriend_setup/install-1.6.0.0.php

https://bitbucket.org/jit_bec/shopifine
PHP | 60 lines | 31 code | 4 blank | 25 comment | 0 complexity | aa4ee702de32ed6afce2647e424fa81e MD5 | raw file
Possible License(s): LGPL-3.0
  1. <?php
  2. /**
  3. * Magento
  4. *
  5. * NOTICE OF LICENSE
  6. *
  7. * This source file is subject to the Open Software License (OSL 3.0)
  8. * that is bundled with this package in the file LICENSE.txt.
  9. * It is also available through the world-wide-web at this URL:
  10. * http://opensource.org/licenses/osl-3.0.php
  11. * If you did not receive a copy of the license and are unable to
  12. * obtain it through the world-wide-web, please send an email
  13. * to license@magentocommerce.com so we can send you a copy immediately.
  14. *
  15. * DISCLAIMER
  16. *
  17. * Do not edit or add to this file if you wish to upgrade Magento to newer
  18. * versions in the future. If you wish to customize Magento for your
  19. * needs please refer to http://www.magentocommerce.com for more information.
  20. *
  21. * @category Mage
  22. * @package Mage_Sendfriend
  23. * @copyright Copyright (c) 2012 Magento Inc. (http://www.magentocommerce.com)
  24. * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
  25. */
  26. $installer = $this;
  27. /* @var $installer Mage_Sendfriend_Model_Resource_Setup */
  28. $installer->startSetup();
  29. $table = $installer->getConnection()
  30. ->newTable($installer->getTable('sendfriend/sendfriend'))
  31. ->addColumn('log_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(
  32. 'identity' => true,
  33. 'unsigned' => true,
  34. 'nullable' => false,
  35. 'primary' => true,
  36. ), 'Log ID')
  37. ->addColumn('ip', Varien_Db_Ddl_Table::TYPE_BIGINT, '20', array(
  38. 'unsigned' => true,
  39. 'nullable' => false,
  40. 'default' => '0',
  41. ), 'Customer IP address')
  42. ->addColumn('time', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(
  43. 'unsigned' => true,
  44. 'nullable' => false,
  45. 'default' => '0',
  46. ), 'Log time')
  47. ->addColumn('website_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array(
  48. 'unsigned' => true,
  49. 'nullable' => false,
  50. 'default' => '0',
  51. ), 'Website ID')
  52. ->addIndex($installer->getIdxName('sendfriend/sendfriend', 'ip'), 'ip')
  53. ->addIndex($installer->getIdxName('sendfriend/sendfriend', 'time'), 'time')
  54. ->setComment('Send to friend function log storage table');
  55. $installer->getConnection()->createTable($table);
  56. $installer->endSetup();