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