PHP Varien_Db_Ddl_Table::setOption Examples

Example #1

File: install-0.0.1.php Project: bele90/magento-test2

<?php

$this->startSetup();
$table = new Varien_Db_Ddl_Table();
$table->setName($this->getTable('bluecom_branddirectory/brand'));
$table->addColumn('entity_id', Varien_Db_Ddl_Table::TYPE_INTEGER, 10, array('auto_increment' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true));
$table->addColumn('create_at', Varien_Db_Ddl_Table::TYPE_DATETIME, null, array('nullable' => false));
$table->addColumn('update_at', Varien_Db_Ddl_Table::TYPE_DATETIME, null, array('nullable' => false));
$table->addColumn('name', Varien_Db_Ddl_Table::TYPE_VARCHAR, 255, array('nullable' => false));
$table->addColumn('url_key', Varien_Db_Ddl_Table::TYPE_VARCHAR, 255, array('nullable' => false));
$table->addColumn('description', Varien_Db_Ddl_Table::TYPE_TEXT, null, array('nullable' => false));
$table->addColumn('visibility', Varien_Db_Ddl_Table::TYPE_BOOLEAN, null, array('nullable' => false));
$table->setOption('type', 'InnoDB');
$table->setOption('charset', 'utf8');
$this->getConnection()->createTable($table);
$this->endSetup();

Example #2

File: install-2.1.4.php Project: keramist/magento-plugin

/**
 * Table used to keep track of invoices that have been created. The
 * IPNs that are received are used to update this table.
 */
$this->run(sprintf('DROP TABLE IF EXISTS `%s`;', $this->getTable('bitpay/invoice')));
$invoiceTable = new Varien_Db_Ddl_Table();
$invoiceTable->setName($this->getTable('bitpay/invoice'));
$invoiceTable->addColumn('id', Varien_Db_Ddl_Table::TYPE_TEXT, 64, array('nullable' => false, 'primary' => true));
$invoiceTable->addColumn('quote_id', Varien_Db_Ddl_Table::TYPE_INTEGER, 11);
$invoiceTable->addColumn('increment_id', Varien_Db_Ddl_Table::TYPE_INTEGER, 11);
$invoiceTable->addColumn('updated_at', Varien_Db_Ddl_Table::TYPE_TIMESTAMP);
$invoiceTable->addColumn('url', Varien_Db_Ddl_Table::TYPE_TEXT, 200);
$invoiceTable->addColumn('pos_data', Varien_Db_Ddl_Table::TYPE_TEXT, 255);
$invoiceTable->addColumn('status', Varien_Db_Ddl_Table::TYPE_TEXT, 20);
$invoiceTable->addColumn('btc_price', Varien_Db_Ddl_Table::TYPE_DECIMAL, array(16, 8));
$invoiceTable->addColumn('btc_due', Varien_Db_Ddl_Table::TYPE_DECIMAL, array(16, 8));
$invoiceTable->addColumn('price', Varien_Db_Ddl_Table::TYPE_DECIMAL, array(16, 8));
$invoiceTable->addColumn('currency', Varien_Db_Ddl_Table::TYPE_TEXT, 10);
$invoiceTable->addColumn('ex_rates', Varien_Db_Ddl_Table::TYPE_TEXT, 255);
$invoiceTable->addColumn('order_id', Varien_Db_Ddl_Table::TYPE_TEXT, 64);
$invoiceTable->addColumn('invoice_time', Varien_Db_Ddl_Table::TYPE_INTEGER, 11);
$invoiceTable->addColumn('expiration_time', Varien_Db_Ddl_Table::TYPE_INTEGER, 11);
$invoiceTable->addColumn('current_time', Varien_Db_Ddl_Table::TYPE_INTEGER, 11);
$invoiceTable->addColumn('btc_paid', Varien_Db_Ddl_Table::TYPE_DECIMAL, array(16, 8));
$invoiceTable->addColumn('rate', Varien_Db_Ddl_Table::TYPE_DECIMAL, array(16, 8));
$invoiceTable->addColumn('exception_status', Varien_Db_Ddl_Table::TYPE_TEXT, 255);
$invoiceTable->addColumn('token', Varien_Db_Ddl_Table::TYPE_TEXT, 164);
$invoiceTable->setOption('type', 'InnoDB');
$invoiceTable->setOption('charset', 'utf8');
$this->getConnection()->createTable($invoiceTable);
$this->endSetup();