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)
