magento创建表与更新

1、config.xml配置

<models> 
    <home>
	<class>Handheld_Home_Model</class>
	<resourceModel>home_mysql4</resourceModel>
    </home>
    <home_mysql4> 
	<class>Handheld_Home_Model_Resource_Mysql4</class><!--具体到文件夹-->
	<entities>
	    <home_middlepart><!--在sql里面表的标识-->
		<table>home_middlepart</table><!--表名-->
	    </home_middlepart>
	</entities>
    </home_mysql4>
</models>

2、sql文件

命名：install-版本号.php

$installer = $this;

/**
 * Prepare database for install
 */
$installer->startSetup();

/**
 * Create table 'brand/brand'
 */
$table = $installer->getConnection()
    ->newTable($installer->getTable('home/slideshow'))
    ->addColumn('id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(
        'identity'  => true,
        'unsigned'  => true,
        'nullable'  => false,
        'primary'   => true,
        ), 'slideshow Id')
	->addColumn('title', Varien_Db_Ddl_Table::TYPE_TEXT, 255, array(
        ), 'slideshow Name')
	->addColumn('is_active', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array(
        'default'   => '1',
        ), 'Active status')
        ->addColumn('sort_order', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(
        'default'   => '1',
        ), 'sort_order')
	->addColumn('description', Varien_Db_Ddl_Table::TYPE_TEXT, "64k", array(
        ), 'slideshow Description')
	->addColumn('link', Varien_Db_Ddl_Table::TYPE_TEXT, 255, array(
        ), 'slideshow Link Url')
	->addColumn('url', Varien_Db_Ddl_Table::TYPE_TEXT, 255, array(
        ), 'slideshow Url')
	->addColumn('created_at', Varien_Db_Ddl_Table::TYPE_TIMESTAMP, null, array(
        ), 'Creation Time')
        ->addColumn('updated_at', Varien_Db_Ddl_Table::TYPE_TIMESTAMP, null, array(
        ), 'Updated Time')
   // ->addIndex($installer->getIdxName('brand/brand', 'is_active'), 'is_active')
    //->addIndex($installer->getIdxName('brand/brand', 'name'), 'name')
    ->setComment('Slideshow');
$installer->getConnection()->createTable($table);
$installer->endSetup();

3、如需更改表或新添加表，只需升级版本号，并且添加sql文件upgrade-原版本号-新版本号.php文件，内容为更改表的内容或新添加的表