PageRenderTime 38ms CodeModel.GetById 12ms RepoModel.GetById 1ms app.codeStats 0ms

/magento/app/code/core/Mage/Captcha/sql/captcha_setup/install-1.7.0.0.0.php

https://bitbucket.org/jit_bec/shopifine
PHP | 51 lines | 23 code | 3 blank | 25 comment | 0 complexity | 80a0b4674fea44103b8ff36d9cf12c87 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_Captcha
  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. /* @var $installer Mage_Core_Model_Resource_Setup */
  27. $installer = $this;
  28. $installer->startSetup();
  29. $table = $installer->getConnection()
  30. ->newTable($installer->getTable('captcha/log'))
  31. ->addColumn('type', Varien_Db_Ddl_Table::TYPE_TEXT, 32, array(
  32. 'nullable' => false,
  33. 'primary' => true,
  34. ), 'Type')
  35. ->addColumn('value', Varien_Db_Ddl_Table::TYPE_TEXT, 32, array(
  36. 'nullable' => false,
  37. 'unsigned' => true,
  38. 'primary' => true,
  39. ), 'Value')
  40. ->addColumn('count', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(
  41. 'unsigned' => true,
  42. 'nullable' => false,
  43. 'default' => '0',
  44. ), 'Count')
  45. ->addColumn('updated_at', Varien_Db_Ddl_Table::TYPE_TIMESTAMP, null, array(), 'Update Time')
  46. ->setComment('Count Login Attempts');
  47. $installer->getConnection()->createTable($table);
  48. $installer->endSetup();