Created
December 4, 2011 12:35
-
-
Save brankoajzele/1430098 to your computer and use it in GitHub Desktop.
Inchoo_Phonebook Magento Test Extension: app/code/local/Inchoo/Phonebook/sql/inchoo_phonebook_setup/install-1.0.0.0.php
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /* @var $installer Inchoo_Phonebook_Model_Resource_Setup */ | |
| $installer = $this; | |
| $installer->startSetup(); | |
| /* Create table 'inchoo_phonebook/user' */ | |
| $table = $installer->getConnection() | |
| ->newTable($installer->getTable('inchoo_phonebook/user')) | |
| ->addColumn('entity_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array( | |
| 'identity' => true, | |
| 'unsigned' => true, | |
| 'nullable' => false, | |
| 'primary' => true, | |
| ), 'Entity ID') | |
| ->addColumn('created_at', Varien_Db_Ddl_Table::TYPE_TIMESTAMP, null, array( | |
| ), 'Creation Time') | |
| ->addColumn('updated_at', Varien_Db_Ddl_Table::TYPE_TIMESTAMP, null, array( | |
| ), 'Update Time') | |
| ->setComment('Inchoo Phonebook User Table'); | |
| $installer->getConnection()->createTable($table); | |
| /* Create table 'inchoo_phonebook/user_entity_varchar' */ | |
| $table = $installer->getConnection() | |
| ->newTable($installer->getTable('inchoo_phonebook/user_entity_varchar')) | |
| ->addColumn('value_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array( | |
| 'identity' => true, | |
| 'nullable' => false, | |
| 'primary' => true, | |
| ), 'Value Id') | |
| ->addColumn('entity_type_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array( | |
| 'unsigned' => true, | |
| 'nullable' => false, | |
| 'default' => '0', | |
| ), 'Entity Type Id') | |
| ->addColumn('attribute_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array( | |
| 'unsigned' => true, | |
| 'nullable' => false, | |
| 'default' => '0', | |
| ), 'Attribute Id') | |
| ->addColumn('store_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array( | |
| 'unsigned' => true, | |
| 'nullable' => false, | |
| 'default' => '0', | |
| ), 'Store ID') | |
| ->addColumn('entity_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array( | |
| 'unsigned' => true, | |
| 'nullable' => false, | |
| 'default' => '0', | |
| ), 'Entity Id') | |
| ->addColumn('value', Varien_Db_Ddl_Table::TYPE_TEXT, 255, array( | |
| ), 'Value') | |
| ->addIndex( | |
| $installer->getIdxName( | |
| 'inchoo_phonebook_user_entity_varchar', | |
| array('entity_id', 'attribute_id', 'store_id'), | |
| Varien_Db_Adapter_Interface::INDEX_TYPE_UNIQUE | |
| ), | |
| array('entity_id', 'attribute_id', 'store_id'), | |
| array('type' => Varien_Db_Adapter_Interface::INDEX_TYPE_UNIQUE)) | |
| ->addIndex($installer->getIdxName('inchoo_phonebook_user_entity_varchar', array('attribute_id')), | |
| array('attribute_id')) | |
| ->addIndex($installer->getIdxName('inchoo_phonebook_user_entity_varchar', array('store_id')), | |
| array('store_id')) | |
| ->addIndex($installer->getIdxName('inchoo_phonebook_user_entity_varchar', array('entity_id')), | |
| array('entity_id')) | |
| ->addForeignKey( | |
| $installer->getFkName('inchoo_phonebook_user_entity_varchar', 'attribute_id', 'eav/attribute', 'attribute_id'), | |
| 'attribute_id', $installer->getTable('eav/attribute'), 'attribute_id', | |
| Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE) | |
| ->addForeignKey( | |
| $installer->getFkName('inchoo_phonebook_user_entity_varchar', 'entity_id', 'inchoo_phonebook/user', 'entity_id'), | |
| 'entity_id', $installer->getTable('inchoo_phonebook/user'), 'entity_id', | |
| Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE) | |
| ->addForeignKey( | |
| $installer->getFkName('inchoo_phonebook_user_entity_varchar', 'store_id', 'core/store', 'store_id'), | |
| 'store_id', $installer->getTable('core/store'), 'store_id', | |
| Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE) | |
| ->setComment('Inchoo Phonebook User Entity Varchar'); | |
| $installer->getConnection()->createTable($table); | |
| /* Create table 'inchoo_phonebook/user_entity_int' */ | |
| $table = $installer->getConnection() | |
| ->newTable($installer->getTable('inchoo_phonebook/user_entity_int')) | |
| ->addColumn('value_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array( | |
| 'identity' => true, | |
| 'nullable' => false, | |
| 'primary' => true, | |
| ), 'Value Id') | |
| ->addColumn('entity_type_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array( | |
| 'unsigned' => true, | |
| 'nullable' => false, | |
| 'default' => '0', | |
| ), 'Entity Type Id') | |
| ->addColumn('attribute_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array( | |
| 'unsigned' => true, | |
| 'nullable' => false, | |
| 'default' => '0', | |
| ), 'Attribute Id') | |
| ->addColumn('store_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array( | |
| 'unsigned' => true, | |
| 'nullable' => false, | |
| 'default' => '0', | |
| ), 'Store ID') | |
| ->addColumn('entity_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array( | |
| 'unsigned' => true, | |
| 'nullable' => false, | |
| 'default' => '0', | |
| ), 'Entity Id') | |
| ->addColumn('value', Varien_Db_Ddl_Table::TYPE_TEXT, 255, array( | |
| ), 'Value') | |
| ->addIndex( | |
| $installer->getIdxName( | |
| 'inchoo_phonebook_user_entity_int', | |
| array('entity_id', 'attribute_id', 'store_id'), | |
| Varien_Db_Adapter_Interface::INDEX_TYPE_UNIQUE | |
| ), | |
| array('entity_id', 'attribute_id', 'store_id'), | |
| array('type' => Varien_Db_Adapter_Interface::INDEX_TYPE_UNIQUE)) | |
| ->addIndex($installer->getIdxName('inchoo_phonebook_user_entity_int', array('attribute_id')), | |
| array('attribute_id')) | |
| ->addIndex($installer->getIdxName('inchoo_phonebook_user_entity_int', array('store_id')), | |
| array('store_id')) | |
| ->addIndex($installer->getIdxName('inchoo_phonebook_user_entity_int', array('entity_id')), | |
| array('entity_id')) | |
| ->addForeignKey( | |
| $installer->getFkName('inchoo_phonebook_user_entity_int', 'attribute_id', 'eav/attribute', 'attribute_id'), | |
| 'attribute_id', $installer->getTable('eav/attribute'), 'attribute_id', | |
| Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE) | |
| ->addForeignKey( | |
| $installer->getFkName('inchoo_phonebook_user_entity_int', 'entity_id', 'inchoo_phonebook/user', 'entity_id'), | |
| 'entity_id', $installer->getTable('inchoo_phonebook/user'), 'entity_id', | |
| Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE) | |
| ->addForeignKey( | |
| $installer->getFkName('inchoo_phonebook_user_entity_int', 'store_id', 'core/store', 'store_id'), | |
| 'store_id', $installer->getTable('core/store'), 'store_id', | |
| Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE) | |
| ->setComment('Inchoo Phonebook User Entity Int'); | |
| $installer->getConnection()->createTable($table); | |
| /* Create table 'inchoo_phonebook/user_entity_text' */ | |
| $table = $installer->getConnection() | |
| ->newTable($installer->getTable('inchoo_phonebook/user_entity_text')) | |
| ->addColumn('value_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array( | |
| 'identity' => true, | |
| 'nullable' => false, | |
| 'primary' => true, | |
| ), 'Value Id') | |
| ->addColumn('entity_type_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array( | |
| 'unsigned' => true, | |
| 'nullable' => false, | |
| 'default' => '0', | |
| ), 'Entity Type Id') | |
| ->addColumn('attribute_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array( | |
| 'unsigned' => true, | |
| 'nullable' => false, | |
| 'default' => '0', | |
| ), 'Attribute Id') | |
| ->addColumn('store_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array( | |
| 'unsigned' => true, | |
| 'nullable' => false, | |
| 'default' => '0', | |
| ), 'Store ID') | |
| ->addColumn('entity_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array( | |
| 'unsigned' => true, | |
| 'nullable' => false, | |
| 'default' => '0', | |
| ), 'Entity Id') | |
| ->addColumn('value', Varien_Db_Ddl_Table::TYPE_TEXT, 255, array( | |
| ), 'Value') | |
| ->addIndex( | |
| $installer->getIdxName( | |
| 'inchoo_phonebook_user_entity_text', | |
| array('entity_id', 'attribute_id', 'store_id'), | |
| Varien_Db_Adapter_Interface::INDEX_TYPE_UNIQUE | |
| ), | |
| array('entity_id', 'attribute_id', 'store_id'), | |
| array('type' => Varien_Db_Adapter_Interface::INDEX_TYPE_UNIQUE)) | |
| ->addIndex($installer->getIdxName('inchoo_phonebook_user_entity_text', array('attribute_id')), | |
| array('attribute_id')) | |
| ->addIndex($installer->getIdxName('inchoo_phonebook_user_entity_text', array('store_id')), | |
| array('store_id')) | |
| ->addIndex($installer->getIdxName('inchoo_phonebook_user_entity_text', array('entity_id')), | |
| array('entity_id')) | |
| ->addForeignKey( | |
| $installer->getFkName('inchoo_phonebook_user_entity_text', 'attribute_id', 'eav/attribute', 'attribute_id'), | |
| 'attribute_id', $installer->getTable('eav/attribute'), 'attribute_id', | |
| Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE) | |
| ->addForeignKey( | |
| $installer->getFkName('inchoo_phonebook_user_entity_text', 'entity_id', 'inchoo_phonebook/user', 'entity_id'), | |
| 'entity_id', $installer->getTable('inchoo_phonebook/user'), 'entity_id', | |
| Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE) | |
| ->addForeignKey( | |
| $installer->getFkName('inchoo_phonebook_user_entity_text', 'store_id', 'core/store', 'store_id'), | |
| 'store_id', $installer->getTable('core/store'), 'store_id', | |
| Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE) | |
| ->setComment('Inchoo Phonebook User Entity Text'); | |
| $installer->getConnection()->createTable($table); | |
| $installer->endSetup(); | |
| $installer->installEntities(); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment