productfeed table

productfeed

<?php

$installer = $this;

$installer->startSetup();

$cdonFeedTable = $installer->getTable('nwtcdon/feed');

// Table 'nwtcdon/feed'
if (!$installer->getConnection()->isTableExists($cdonFeedTable)) {
    $table = $installer->getConnection()
        ->newTable($cdonFeedTable)
        ->addColumn('entity_id',
            Varien_Db_Ddl_Table::TYPE_INTEGER,
            null,
            array(
                'unsigned' => true,
                'nullable' => false,
                'primary' => true,
                'default' => '0',
            ),
            'Entity Id'
        )
        ->addColumn(
            'import_id',
            Varien_Db_Ddl_Table::TYPE_VARCHAR,
            255,
            array(
                'nullable'  => false,
            ), 'CDON Import Id'
        )
        ->addColumn(
            'import_previous_id',
            Varien_Db_Ddl_Table::TYPE_VARCHAR,
            255,
            array(
                'nullable'  => false,
            ),
            'CDON Import Previous Id'
        )
        ->addColumn(
            'store_id',
            Varien_Db_Ddl_Table::TYPE_VARCHAR,
            55,
            array(
                'nullable'  => false,
            ),
            'Store Id'
        )
        ->addColumn(
            'created_at',
            Varien_Db_Ddl_Table::TYPE_DATETIME,
            null,
            array(
                'nullable' => true,
            ),
            'Feed creation time'
        )
        ->addColumn(
            'feed_error',
            Varien_Db_Ddl_Table::TYPE_VARCHAR,
            255,
            array(
                'nullable'  => true,
            ), 'Feed error message'
        )
        ->addColumn(
            'curl_error',
            Varien_Db_Ddl_Table::TYPE_VARCHAR,
            255,
            array(
                'nullable'  => true,
            ), 'Curl error message'
        )
    ;
    $installer->getConnection()->createTable($table);
}

$installer->endSetup();