Dtjytyk

I get some trouble in auto create table for model . I create module 'rewardpoint' by moduleCreator and it generate rewardpoint model automatically,But i want to create new Model 'rate' in my module . So , this is my code :

-config.xml

<models>
 <rate>
 <class>Magestore_Rewardpoint_Model</class>
 <resourceModel>rate_mysql4</resourceModel>
 </rate>
 <rate_mysql4>
 <class>Magestore_Rewardpoint_Model_Mysql4</class>
 <entities>
 <rate>
 <table>rewardpoints_rate</table>
 </rate>
 </entities>
 </rate_mysql4>
 </models>
<resources>
 <rewardpoint_setup>
 <setup>
 <module>Magestore_Rewardpoint</module>
 </setup>
 <connection>
 <use>core_setup</use>
 </connection>
 </rewardpoint_setup>
 <rewardpoint_write>
 <connection>
 <use>core_write</use>
 </connection>
 </rewardpoint_write>
 <rewardpoint_read>
 <connection>
 <use>core_read</use>
 </connection>
 </rewardpoint_read>
 </resources>

And in sql folder , i change code too

$installer = $this;

$installer->startSetup();

/**
 * create rewardpoint table
 */
$installer->run("

DROP TABLE IF EXISTS $this->getTable('rewardpoints_rate');

CREATE TABLE $this->getTable('rewardpoints_rate') (
 `rate_id` int(11) unsigned NOT NULL auto_increment,
 `direction` smallint(6) NOT NULL,
 `point` int(11) NOT NULL,
 `money` int(11) NOT NULL,
 `customer_group` varchar(20) NOT NULL ,
 PRIMARY KEY (`rate_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

");

Then i refesh browser and see my phpadmin result , there's no table name 'rewardpoints_rate'.

I would like to add this as a comment, but then it is unreadable.

You don't need all the XML nodes, because magento adds them automatically:

<resources>
 <rewardpoint_setup>
 <connection>
 <use>core_setup</use>
 </connection>
 </rewardpoint_setup>
 <rewardpoint_write>
 <connection>
 <use>core_write</use>
 </connection>
 </rewardpoint_write>
 <rewardpoint_read>
 <connection>
 <use>core_read</use>
 </connection>
 </rewardpoint_read>

You can remove them if you want.

For run sql_setup you need define resource

<resources>
 <rate_setup>
 <setup>
 <module>Magestore_Rewardpoint</module>
 </setup>
 <connection>
 <use>core_setup</use>
 </connection>
 </rate_setup>
 <rate_read>
 <connection>
 <use>core_read</use>
 </connection>
 </rate_read>
 <rate_write>
 <connection>
 <use>core_write</use>
 </connection>
 </rate_write>
</resources>

Also try this

<?xml version="1.0"?>
<config>
 <modules>
 <Magestore_Rewardpoint>
 <version>0.1.0</version>
 </Magestore_Rewardpoint>
 </modules>
 <global>
 <helpers>
 <rewardpoint>
 <class>Magestore_Rewardpoint_Helper</class>
 </rewardpoint>
 </helpers>
 <resources>
 <rewardpoint_setup>
 <setup>
 <module>Magestore_Rewardpoint</module>
 </setup>
 <connection>
 <use>core_setup</use>
 </connection>
 </rewardpoint_setup>
 <rewardpoint_write>
 <connection>
 <use>core_write</use>
 </connection>
 </rewardpoint_write>
 <rewardpoint_read>
 <connection>
 <use>core_read</use>
 </connection>
 </rewardpoint_read>
 </resources>
 </global>
</config> 

Also try this code for appcodelocalMagestoreRewardpointsqlrewardpoint_setupmysql4-install-0.1.0.php

<?php
$installer = $this;
$installer->startSetup();
$sql=<<<SQLTEXT
create table rewardpoints_rate('rate_id' int(11) unsigned NOT NULL auto_increment, 'direction' smallint(6) NOT NULL,'point` int(11) NOT NULL,'money' int(11) NOT NULL, 'customer_group' varchar(20) NOT NULL , PRIMARY KEY ('rate_id'));
SQLTEXT;

$installer->run($sql);

$installer->endSetup();

Hope this will work for you