PHP Varien_Db_Ddl_Table::addColumn Examples

Example #1

File: Aggregator.php Project: cnglobal-sl/caterez

 /**
  * Create database for grid columns
  * @param string $name
  * @param AW_Advancedreports_Block_Advanced_Grid $grid
  * @return AW_Advancedreports_Helper_Tools_Aggregator
  */
 private function _createFlatTable($name, $grid)
 {
     if ($grid) {
         $table = new Varien_Db_Ddl_Table();
         $table->setName($name);
         $periodKey = self::DATE_KEY_FIELD;
         $table->addColumn('entity_id', Varien_Db_Ddl_Table::TYPE_BIGINT, null, array('unsigned' => true, 'primary' => true, 'nullable' => false, 'identity' => true));
         $table->addColumn($periodKey, Varien_Db_Ddl_Table::TYPE_TIMESTAMP, null, array('nullable' => false));
         foreach ($grid->getSetupColumns() as $column) {
             $index = $column->getIndex();
             $type = $column->getDdlType();
             $size = $column->getDdlSize();
             $options = $column->getDdlOptions();
             if ($index && $type) {
                 $table->addColumn($index, $type, $size, $options);
             }
         }
         $write = $this->_getWriteAdapter()->createTable($table);
     }
     return $this;
 }

Example #2

File: install-0.0.1.php Project: 215jc/magento_newsview

$table = new Varien_Db_Ddl_Table();
/**
 * This is an alias to the real name of our database table, which is 
 * configured in config.xml. By using an alias we can reference the same
 * table throughout our code if we wish and if the table name ever had to 
 * change we could simply update a single location, config.xml
 * - jc_newsview is the model alias
 * - news is the table reference
 */
$table->setName($this->getTable('jc_newsview/news'));
/**
 * Add the columns we need for now. If you need more in the future you can
 * always create a new setup script as an upgrade, we will introduce that 
 * later on in the tutorial.
 */
$table->addColumn('entity_id', Varien_Db_Ddl_Table::TYPE_INTEGER, 10, array('auto_increment' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true));
$table->addColumn('created_at', Varien_Db_Ddl_Table::TYPE_DATETIME, null, array('nullable' => false));
$table->addColumn('updated_at', Varien_Db_Ddl_Table::TYPE_DATETIME, null, array('nullable' => false));
$table->addColumn('title', Varien_Db_Ddl_Table::TYPE_VARCHAR, 255, array('nullable' => false));
$table->addColumn('summary', Varien_Db_Ddl_Table::TYPE_TEXT, null, array('nullable' => false));
$table->addColumn('content', Varien_Db_Ddl_Table::TYPE_TEXT, null, array('nullable' => false));
/**
 * A couple of important lines that are often missed.
 */
$table->setOption('type', 'InnoDB');
$table->setOption('charset', 'utf8');
/**
 * Create the table!
 */
$this->getConnection()->createTable($table);
$this->endSetup();

Example #3

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 #4

File: mysql4-install-0.0.1.php Project: greghoole/magento_extensions

<?php

$this->startSetup();
$table1 = new Varien_Db_Ddl_Table();
$table1->setName($this->getTable('ultimatenewmedia_social/likes'));
$table1->addColumn('entity_id', Varien_Db_Ddl_Table::TYPE_INTEGER, 10, array('auto_increment' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true));
$table1->addColumn('product_id', Varien_Db_Ddl_Table::TYPE_INTEGER, 10, array('nullable' => false));
$table1->addColumn('ip_address', Varien_Db_Ddl_Table::TYPE_VARCHAR, 255, array('nullable' => false));
$table1->addColumn('created_at', Varien_Db_Ddl_Table::TYPE_DATETIME, null, array('nullable' => false));
$table1->setOption('type', 'InnoDB');
$table1->setOption('charset', 'utf8');
$table2 = new Varien_Db_Ddl_Table();
$table2->setName($this->getTable('ultimatenewmedia_social/review'));
$table2->addColumn('entity_id', Varien_Db_Ddl_Table::TYPE_INTEGER, 10, array('auto_increment' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true));
$table2->addColumn('review_id', Varien_Db_Ddl_Table::TYPE_INTEGER, 10, array('nullable' => false));
$table2->addColumn('ip_address', Varien_Db_Ddl_Table::TYPE_VARCHAR, 255, array('nullable' => false));
$table2->addColumn('created_at', Varien_Db_Ddl_Table::TYPE_DATETIME, null, array('nullable' => false));
$table2->setOption('type', 'InnoDB');
$table2->setOption('charset', 'utf8');
$this->getConnection()->createTable($table1);
$this->getConnection()->createTable($table2);
$this->endSetup();

Example #5

File: install-0.1.0.php Project: nverhoye/mage-compta

<?php

$installer = $this;
/* @var $installer Mage_Core_Model_Resource_Setup */
$installer->startSetup();
$table = new Varien_Db_Ddl_Table();
$table->setName($this->getTable('admin/user'));
$table->addColumn('manager_id', Varien_Db_Ddl_Table::TYPE_INTEGER, 10, array('unsigned' => true, 'nullable' => false, 'default' => "0"));
//ALTER TABLE admin_user ADD manager_id INT NOT NULL DEFAULT 0 AFTER password;
$installer->endSetup();

Example #6

File: install-0.0.1.php Project: bhargavmehta/accordion

*/
$table = new Varien_Db_Ddl_Table();
/**
* This is an alias of the real name of our database table, which is
* configured in config.xml. By using an alias, we can refer to the same
* table throughout our code if we wish, and if the table name ever has
* to change, we can simply update a single location, config.xml
* is the model alias is the table reference
*/
$table->setName($this->getTable('bhargav_accordion/accordion'));
/**
* Add the columns we need for now. If you need more later, you can
* always create a new setup script as an upgrade. We will introduce
* that later in this tutorial.
*/
$table->addColumn('entity_id', Varien_Db_Ddl_Table::TYPE_INTEGER, 10, array('auto_increment' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true));
$table->addColumn('created_at', Varien_Db_Ddl_Table::TYPE_DATETIME, null, array('nullable' => false));
$table->addColumn('updated_at', Varien_Db_Ddl_Table::TYPE_DATETIME, null, array('nullable' => false));
$table->addColumn('title', Varien_Db_Ddl_Table::TYPE_TEXT, null, array('nullable' => false));
$table->addColumn('text', Varien_Db_Ddl_Table::TYPE_TEXT, null, array('nullable' => false));
$table->addColumn('visibility', Varien_Db_Ddl_Table::TYPE_BOOLEAN, null, array('nullable' => false));
$table->addColumn('store_id', Varien_Db_Ddl_Table::TYPE_TEXT, 63, array('nullable' => true, 'default' => null));
$table->addColumn('page', Varien_Db_Ddl_Table::TYPE_TEXT, 63, array('nullable' => true, 'default' => null));
/**
 * These two important lines are often missed.
 */
$table->setOption('type', 'InnoDB');
$table->setOption('charset', 'utf8');
/**
 * Create the table!
 */

Example #7

File: install-1.0.0.php Project: p-makowski/magento-untranslatedstrings

<?php

$installer = $this;
/* @var $installer Mage_Core_Model_Resource_Setup */
$installer->startSetup();
$tableName = $installer->getTable('ew_untranslatedstrings/string');
$table = new Varien_Db_Ddl_Table();
$table->setName($tableName);
$table->addColumn('id', Varien_Db_Ddl_Table::TYPE_INTEGER, 11, array('nullable' => false, 'identity' => true, 'primary' => true));
$table->addColumn('store_id', Varien_Db_Ddl_Table::TYPE_INTEGER, 11, array('nullable' => false));
$table->addColumn('untranslated_string', Varien_Db_Ddl_Table::TYPE_VARCHAR, 255, array('nullable' => false));
$table->addColumn('translation_code', Varien_Db_Ddl_Table::TYPE_VARCHAR, 255, array('nullable' => false));
$table->addColumn('translation_module', Varien_Db_Ddl_Table::TYPE_VARCHAR, 255, array('nullable' => true));
$table->addColumn('locale', Varien_Db_Ddl_Table::TYPE_VARCHAR, 10, array('nullable' => true));
$table->addColumn('url_found', Varien_Db_Ddl_Table::TYPE_VARCHAR, 255, array('nullable' => true));
$table->addColumn('date_found', Varien_Db_Ddl_Table::TYPE_DATETIME, null, array('nullable' => false));
$installer->getConnection()->createTable($table);
$uniqueFields = array('store_id', 'untranslated_string', 'translation_code', 'locale');
$installer->getConnection()->addIndex($tableName, $installer->getIdxName($tableName, $uniqueFields, Varien_Db_Adapter_Interface::INDEX_TYPE_UNIQUE), $uniqueFields, Varien_Db_Adapter_Interface::INDEX_TYPE_UNIQUE);
$installer->endSetup();

Example #8

File: mysql4-install-0.1.0.php Project: santhosh400/ecart

<?php

/* @var $this Mage_Core_Model_Resource_Setup */
$this->startSetup();
$quotes = new Varien_Db_Ddl_Table();
$quotes->setName($this->getTable('guestcookies/quote'));
// Reference to foreign table
$quotes->addColumn('quote_id', Varien_Db_Ddl_Table::TYPE_INTEGER, 10, array('primary' => true, 'nullable' => false, 'unsigned' => true));
$quotes->addForeignKey('FK_GUESTCOOKIES_QUOTE_ID_SALES_QUOTE_ENTITY_ID', 'quote_id', $this->getTable('sales/quote'), 'entity_id', Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE);
// Token key to be stored in cookie
$quotes->addColumn('token', Varien_Db_Ddl_Table::TYPE_CHAR, 32, array('nullable' => false));
$quotes->addIndex('IDX_TOKEN', 'token', array('unique' => true));
$this->getConnection()->createTable($quotes);
$this->endSetup();

Example #9

File: install-0.0.0.1.php Project: agentelinux/omise-magento

<?php

$this->startSetup();
$table = new Varien_Db_Ddl_Table();
$table->setName($this->getTable('omise_gateway/omise'));
$table->addColumn('id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array('identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true));
$table->addColumn('public_key', Varien_Db_Ddl_Table::TYPE_TEXT, 45, array('nullable' => true));
$table->addColumn('secret_key', Varien_Db_Ddl_Table::TYPE_TEXT, 45, array('nullable' => true));
$table->addColumn('public_key_test', Varien_Db_Ddl_Table::TYPE_TEXT, 45, array('nullable' => true));
$table->addColumn('secret_key_test', Varien_Db_Ddl_Table::TYPE_TEXT, 45, array('nullable' => true));
$table->addColumn('test_mode', Varien_Db_Ddl_Table::TYPE_BOOLEAN, null, array('default' => false));
$table->setOption('type', 'InnoDB');
$table->setOption('charset', 'utf8');
$this->getConnection()->createTable($table);
$this->endSetup();

Example #10

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

$ipnTable->addColumn('current_time', Varien_Db_Ddl_Table::TYPE_INTEGER, 11);
$ipnTable->addColumn('pos_data', Varien_Db_Ddl_Table::TYPE_TEXT, 255);
$ipnTable->addColumn('btc_paid', Varien_Db_Ddl_Table::TYPE_DECIMAL, array(16, 8));
$ipnTable->addColumn('rate', Varien_Db_Ddl_Table::TYPE_DECIMAL, array(16, 8));
$ipnTable->addColumn('exception_status', Varien_Db_Ddl_Table::TYPE_TEXT, 255);
$ipnTable->setOption('type', 'InnoDB');
$ipnTable->setOption('charset', 'utf8');
$this->getConnection()->createTable($ipnTable);
/**
 * 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);

Example #11

File: install-0.0.1.php Project: JakeWymer/Magento_ResellBlocker

<?php

$this->startSetup();
$table = new Varien_Db_Ddl_Table();
$table->setName($this->getTable('jakey_resellblocker/basetime'));
$table->addColumn('id', Varien_Db_Ddl_Table::TYPE_INTEGER, 10, array('auto_increment' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true));
$table->addColumn('base_time', Varien_Db_Ddl_Table::TYPE_DATETIME, null, array('nullable' => false));
$table->addColumn('time_frame', Varien_Db_Ddl_Table::TYPE_INTEGER, 10, array('nullable' => false));
$table->setOption('type', 'InnoDB');
$table->setOption('charset', 'utf8');
$this->getConnection()->createTable($table);
//TABLE 2
$table2 = new Varien_Db_Ddl_Table();
$table2->setName($this->getTable('jakey_resellblocker/emaillist'));
$table2->addColumn('id', Varien_Db_Ddl_Table::TYPE_INTEGER, 10, array('auto_increment' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true));
$table2->addColumn('customer_email', Varien_Db_Ddl_Table::TYPE_VARCHAR, 30, array('nullable' => false));
$table2->addColumn('email_date', Varien_Db_Ddl_Table::TYPE_DATETIME, null, array('nullable' => false));
$table2->addColumn('order_number', Varien_Db_Ddl_Table::TYPE_VARCHAR, 30, array('nullable' => false));
$table2->setOption('type', 'InnoDB');
$table2->setOption('charset', 'utf8');
$this->getConnection()->createTable($table2);
$this->endSetup();

Example #12

File: install-0.0.1.php Project: vesviet/dellocal

$table = new Varien_Db_Ddl_Table();
/**
 * This is an alias to the real name of our database table, which is 
 * configured in config.xml. By using an alias we can reference the same
 * table throughout our code if we wish and if the table name ever had to 
 * change we could simply update a single location, config.xml
 * - smashingmagazine_branddirectory is the model alias
 * - brand is the table reference
 */
$table->setName($this->getTable('infobitsolutions_managevendor/mapping'));
/**
 * Add the columns we need for now. If you need more in the future you can
 * always create a new setup script as an upgrade, we will introduce that 
 * later on in the tutorial.
 */
$table->addColumn('entity_id', Varien_Db_Ddl_Table::TYPE_INTEGER, 10, array('auto_increment' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true));
$table->addColumn('vendor', Varien_Db_Ddl_Table::TYPE_INTEGER, 10, array('nullable' => false));
$table->addColumn('vendor_identifier', Varien_Db_Ddl_Table::TYPE_VARCHAR, 255, array('nullable' => false));
$table->addColumn('subdomain', Varien_Db_Ddl_Table::TYPE_VARCHAR, 255, array('nullable' => false));
$table->addColumn('created_at', Varien_Db_Ddl_Table::TYPE_DATETIME, null, array('nullable' => false));
$table->addColumn('updated_at', Varien_Db_Ddl_Table::TYPE_DATETIME, null, array('nullable' => false));
/**
 * A couple of important lines that are often missed.
 */
$table->setOption('type', 'InnoDB');
$table->setOption('charset', 'utf8');
/**
 * Create the table!
 */
$this->getConnection()->createTable($table);
$this->endSetup();