Magento installer default boilerplate.

install.php

<?php
/*
 * @var $installer Mage_Catalog_Model_Resource_Eav_Mysql4_Setup
 */
$installer = $this;
$installer->startSetup();
$connection = $installer->getConnection();
$connection->beginTransaction();

try {
    $tableName = $installer->getTable( 'wexo_newswidget/new' );
    $table     = $connection->newTable( $tableName )
                            ->addColumn( 'id', Varien_Db_Ddl_Table::TYPE_INTEGER, NULL, array(
                                'unsigned' => TRUE,
                                'nullable' => FALSE,
                                'primary'  => TRUE,
                                'identity' => TRUE
                            ), 'ID item' )
                            ->addColumn( 'hidden', Varien_Db_Ddl_Table::TYPE_BOOLEAN, NULL, array(
                                'nullable' => TRUE,
                                'primary'  => FALSE,
                                'required' => FALSE
                            ), 'Is hidden or not' )
                            ->addColumn( 'pin', Varien_Db_Ddl_Table::TYPE_BOOLEAN, NULL, array(
                                'nullable' => TRUE,
                                'primary'  => FALSE,
                                'required' => FALSE
                            ), 'Is pinned or not' )
                            ->addColumn( 'bubobuboKey', Varien_Db_Ddl_Table::TYPE_BOOLEAN, NULL, array(
                                'nullable' => TRUE,
                                'primary'  => FALSE,
                                'required' => FALSE
                            ), 'Key retrieved from API' )
                            ->addColumn( 'headline', Varien_Db_Ddl_Table::TYPE_VARCHAR, NULL, array(
                                'unsigned' => TRUE,
                                'nullable' => FALSE,
                                'primary'  => FALSE,
                            ), 'Headline' )
                            ->addColumn( 'content', Varien_Db_Ddl_Table::TYPE_VARCHAR, NULL, array(
                                'unsigned' => TRUE,
                                'nullable' => FALSE,
                                'primary'  => FALSE,
                            ), 'Content' )
                            ->addColumn( 'content_short', Varien_Db_Ddl_Table::TYPE_VARCHAR, NULL, array(
                                'unsigned' => TRUE,
                                'nullable' => FALSE,
                                'primary'  => FALSE,
                            ), 'Shortened content' )
                            ->addColumn( 'createdBy', Varien_Db_Ddl_Table::TYPE_TIMESTAMP, NULL, array(
                                'nullable' => FALSE,
                                'primary'  => FALSE,
                                "default"  => Varien_Db_Ddl_Table::TIMESTAMP_INIT
                            ), 'Author' )
                            ->addColumn( 'fromDate', Varien_Db_Ddl_Table::TYPE_TIMESTAMP, NULL, array(
                                'nullable' => FALSE,
                                'primary'  => FALSE,
                                "default"  => Varien_Db_Ddl_Table::TIMESTAMP_INIT
                            ), 'Valid from' )
                            ->addColumn( 'toDate', Varien_Db_Ddl_Table::TYPE_TIMESTAMP, NULL, array(
                                'nullable' => FALSE,
                                'primary'  => FALSE,
                                "default"  => Varien_Db_Ddl_Table::TIMESTAMP_INIT
                            ), 'Valid to' )
                            ->addColumn( 'contractPartID', Varien_Db_Ddl_Table::TYPE_INTEGER, NULL, array(
                                'nullable' => FALSE,
                                'primary'  => FALSE,
                            ), 'Custom identification' )
                            ->addColumn( 'contractPartNewsID', Varien_Db_Ddl_Table::TYPE_INTEGER, NULL, array(
                                'nullable' => FALSE,
                                'primary'  => FALSE,
                            ), 'Custom identification' )
                            ->addColumn( 'ContractPartNewsGUID', Varien_Db_Ddl_Table::TYPE_VARCHAR, NULL, array(
                                'nullable' => FALSE,
                                'primary'  => FALSE,
                            ), 'Custom identification' )
                            ->addColumn( 'Created', Varien_Db_Ddl_Table::TYPE_TIMESTAMP, NULL, array(
                                'nullable' => FALSE,
                                'primary'  => FALSE,
                                "default"  => Varien_Db_Ddl_Table::TIMESTAMP_INIT
                            ), 'Created at. From API.' )
                            ->addColumn( 'updated_at', Varien_Db_Ddl_Table::TYPE_TIMESTAMP, NULL, array(
                                'nullable' => FALSE,
                                'primary'  => FALSE,
                                "default"  => Varien_Db_Ddl_Table::TIMESTAMP_INIT
                            ), 'Last update of the DB row. Not from API.' );

    $connection->createTable( $table );

    $connection->commit();

} catch( Exception $e ) {
    $connection->rollBack();
    Mage::log( $e->getMessage() );
}

$installer->endSetup();