How to add new attribute using script?

Question

I tried below code -

    $installer = $this;
    $installer->startSetup();

    $installer->addAttribute("eav_attribute", "cv1_price", array("type"=>"decimal"));
    $installer->addAttribute("eav_attribute", "cv1_shipping_cost", array("type"=>"decimal"));
    $installer->endSetup();

But I want to add new attribute to all related table.

Answer 1

You can try below code:

$installer = $this;
$installer->startSetup();
$installer->addAttribute('catalog_product', 'page_layout', array(
  'type'              => 'varchar',
  'backend'           => '',
  'frontend'          => '',
  'label'             => 'Page Layout',
  'input'             => 'select',
  'class'             => '',
  'source'            => 'catalog/product_attribute_source_layout',
  'global'            => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
  'visible'           => true,
  'required'          => false,
  'user_defined'      => false,
  'default'           => '',
  'searchable'        => false,
  'filterable'        => false,
  'comparable'        => false,
  'visible_on_front'  => false,
  'unique'            => false,
  'group'             => 'Design'
));

$installer->endSetup();