Create Own Module in Magento – Part -2 – Create Own Mysql Install file (table) in magento

Create Own Mysql Install file (table) in magento:

I have declared my Mysql declaration code in above config file. Now i need to create my first Install setup file in (own table) my module. Create a file folder like

Jute/Travelinfo/sql/travelinfo_setup/ mysql4-install-0.1.0.php

$installer = $this;

$installer->startSetup();

$installer->run(“

DROP TABLE IF EXISTS `jute_travelinfo`;

   CREATE TABLE `jute_travelinfo` (

     `entity_id` int(11) NOT NULL auto_increment,

     `travelinfo_number` int(11) NOT NULL,

     `travel_name` VARCHAR(255) NULL,

     `package` VARCHAR(255) NULL,

     `placetovisit` VARCHAR(255) NULL,

     PRIMARY KEY (`entity_id`)

   ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

“);

$installer->endSetup();

Cleare the cache and check. Your table will be created in magento DB. For verification you table refer Core_resource table, check travelinfo, you will get the version number (one row it will create)