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