SET FOREIGN_KEY_CHECKS = 0;

TRUNCATE TABLE `catalog_product_bundle_option`;

TRUNCATE TABLE `catalog_product_bundle_option_value`;

TRUNCATE TABLE `catalog_product_bundle_selection`;

TRUNCATE TABLE `catalog_product_entity_datetime`;

TRUNCATE TABLE `catalog_product_entity_decimal`;

TRUNCATE TABLE `catalog_product_entity_gallery`;

TRUNCATE TABLE `catalog_product_entity_int`;

TRUNCATE TABLE `catalog_product_entity_media_gallery`;

TRUNCATE TABLE `catalog_product_entity_media_gallery_value`;

TRUNCATE TABLE `catalog_product_entity_text`;

TRUNCATE TABLE `catalog_product_entity_tier_price`;

TRUNCATE TABLE `catalog_product_entity_varchar`;

TRUNCATE TABLE `catalog_product_link`;

TRUNCATE TABLE `catalog_product_link_attribute`;

TRUNCATE TABLE `catalog_product_link_attribute_decimal`;

TRUNCATE TABLE `catalog_product_link_attribute_int`;

TRUNCATE TABLE `catalog_product_link_attribute_varchar`;

TRUNCATE TABLE `catalog_product_link_type`;

TRUNCATE TABLE `catalog_product_option`;

TRUNCATE TABLE `catalog_product_option_price`;

TRUNCATE TABLE `catalog_product_option_title`;

TRUNCATE TABLE `catalog_product_option_type_price`;

TRUNCATE TABLE `catalog_product_option_type_title`;

TRUNCATE TABLE `catalog_product_option_type_value`;

TRUNCATE TABLE `catalog_product_super_attribute`;

TRUNCATE TABLE `catalog_product_super_attribute_label`;

TRUNCATE TABLE `catalog_product_super_attribute_pricing`;

TRUNCATE TABLE `catalog_product_super_link`;

TRUNCATE TABLE `catalog_product_enabled_index`;

TRUNCATE TABLE `catalog_product_website`;

TRUNCATE TABLE `catalog_product_entity`;

TRUNCATE TABLE `cataloginventory_stock`;

TRUNCATE TABLE `cataloginventory_stock_item`;

TRUNCATE TABLE `cataloginventory_stock_status`;

TRUNCATE TABLE `catalog_product_link`;

TRUNCATE TABLE `catalog_product_link_type`;

TRUNCATE TABLE `catalog_product_option`;

TRUNCATE TABLE `catalog_product_option_type_value`;

TRUNCATE TABLE `catalog_product_super_attribute`;

TRUNCATE TABLE `catalog_product_entity`;

TRUNCATE TABLE `cataloginventory_stock`;

DELETE FROM catalog_product_flat_1;

DELETE FROM catalog_product_flat_10;

DELETE FROM catalog_product_flat_11;

DELETE FROM catalog_product_flat_12;

DELETE FROM catalog_product_flat_13;

DELETE FROM catalog_product_flat_14;

DELETE FROM catalog_product_flat_15;

DELETE FROM catalog_product_flat_16;

DELETE FROM catalog_product_flat_17;

DELETE FROM catalog_product_flat_18;

DELETE FROM catalog_product_flat_19;

DELETE FROM catalog_product_flat_2;

DELETE FROM catalog_product_flat_20;

DELETE FROM catalog_product_flat_21;

DELETE FROM catalog_product_flat_22;

DELETE FROM catalog_product_flat_23;

DELETE FROM catalog_product_flat_24;

DELETE FROM catalog_product_flat_25;

DELETE FROM catalog_product_flat_26;

DELETE FROM catalog_product_flat_27;

DELETE FROM catalog_product_flat_28;

DELETE FROM catalog_product_flat_29;

DELETE FROM catalog_product_flat_3;

DELETE FROM catalog_product_flat_30;

DELETE FROM catalog_product_flat_31;

DELETE FROM catalog_product_flat_32;

DELETE FROM catalog_product_flat_33;

DELETE FROM catalog_product_flat_34;

DELETE FROM catalog_product_flat_35;

DELETE FROM catalog_product_flat_36;

DELETE FROM catalog_product_flat_37;

DELETE FROM catalog_product_flat_4;

DELETE FROM catalog_product_flat_5;

DELETE FROM catalog_product_flat_6;

DELETE FROM catalog_product_flat_7;

DELETE FROM catalog_product_flat_8;

DELETE FROM catalog_product_flat_9;

SET FOREIGN_KEY_CHECKS = 1;

insert  into `catalog_product_link_type`(`link_type_id`,`code`) values (1,'relation'),(2,'bundle'),(3,'super'),(4,'up_sell'),(5,'cross_sell');

insert  into `catalog_product_link_attribute`(`product_link_attribute_id`,`link_type_id`,`product_link_attribute_code`,`data_type`) values (1,2,'qty','decimal'),(2,1,'position','int'),(3,4,'position','int'),(4,5,'position','int'),(6,1,'qty','decimal'),(7,3,'position','int'),(8,3,'qty','decimal');

insert  into `cataloginventory_stock`(`stock_id`,`stock_name`) values (1,'Default');

foreach($collection2 as $coll) {

    $collection1->addItem($coll);

}

protected function _customerExists($email, $websiteId = null)

{

    $customer = Mage::getModel('customer/customer');

    if ($websiteId) {

        $customer->setWebsiteId($websiteId);

    }

    $customer->loadByEmail($email);

    if ($customer->getId()) {

        return $customer;

    }

    return false;

}

$installer = $this;

$installer->startSetup();

$setup = new Mage_Eav_Model_Entity_Setup('core_setup');

$setup->addAttribute('customer', 'facebook', array(

    'label'     => 'Facebook',

    'type'      => 'varchar',

    'input' => 'text',

    'default'   => '',                      

    'visible'   => true,

    'required'  => false,

    'unique'    => true,

    'user_defined'  => true,

));