/magento/app/code/core/Mage/Captcha/sql/captcha_setup/install-1.7.0.0.0.php
PHP | 51 lines | 23 code | 3 blank | 25 comment | 0 complexity | 80a0b4674fea44103b8ff36d9cf12c87 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_Captcha
- * @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)
- */
- /* @var $installer Mage_Core_Model_Resource_Setup */
- $installer = $this;
- $installer->startSetup();
- $table = $installer->getConnection()
- ->newTable($installer->getTable('captcha/log'))
- ->addColumn('type', Varien_Db_Ddl_Table::TYPE_TEXT, 32, array(
- 'nullable' => false,
- 'primary' => true,
- ), 'Type')
- ->addColumn('value', Varien_Db_Ddl_Table::TYPE_TEXT, 32, array(
- 'nullable' => false,
- 'unsigned' => true,
- 'primary' => true,
- ), 'Value')
- ->addColumn('count', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(
- 'unsigned' => true,
- 'nullable' => false,
- 'default' => '0',
- ), 'Count')
- ->addColumn('updated_at', Varien_Db_Ddl_Table::TYPE_TIMESTAMP, null, array(), 'Update Time')
- ->setComment('Count Login Attempts');
- $installer->getConnection()->createTable($table);
- $installer->endSetup();