/** * 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; }
$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();
<?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();
<?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();
<?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();
*/ $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! */
<?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();
<?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();
<?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();
$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);
<?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();
$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();