pwX2VG7N

1<models>
2        <rate>
3            <class>Magestore_Rewardpoint_Model</class>
4            <resourceModel>rate_mysql4</resourceModel>
5        </rate>
6        <rate_mysql4>
7            <class>Magestore_Rewardpoint_Model_Mysql4</class>
8            <entities>
9                <rate>
10                    <table>rewardpoints_rate</table>
11                </rate>
12            </entities>
13        </rate_mysql4>
14    </models>
15<resources>
16        <rewardpoint_setup>
17            <setup>
18                <module>Magestore_Rewardpoint</module>
19            </setup>
20            <connection>
21                <use>core_setup</use>
22            </connection>
23        </rewardpoint_setup>
24        <rewardpoint_write>
25            <connection>
26                <use>core_write</use>
27            </connection>
28        </rewardpoint_write>
29        <rewardpoint_read>
30            <connection>
31                <use>core_read</use>
32            </connection>
33        </rewardpoint_read>
34   </resources> 
35     
36$installer = $this;
37
38$installer->startSetup();
39
40/**
41 * create rewardpoint table
42 */
43$installer->run("
44
45DROP TABLE IF EXISTS {$this->getTable('rewardpoints_rate')};
46
47CREATE TABLE {$this->getTable('rewardpoints_rate')} (
48  `rate_id` int(11) unsigned NOT NULL auto_increment,
49  `direction` smallint(6) NOT NULL,
50  `point` int(11) NOT NULL,
51  `money` int(11) NOT NULL,
52  `customer_group` varchar(20) NOT NULL ,
53  PRIMARY KEY (`rate_id`)
54) ENGINE=InnoDB DEFAULT CHARSET=utf8;
55
56"); 
57     
58<resources>
59    <rewardpoint_setup>
60        <connection>
61            <use>core_setup</use>
62        </connection>
63    </rewardpoint_setup>
64    <rewardpoint_write>
65        <connection>
66            <use>core_write</use>
67        </connection>
68    </rewardpoint_write>
69    <rewardpoint_read>
70        <connection>
71            <use>core_read</use>
72        </connection>
73    </rewardpoint_read> 
74     
75<resources>
76    <rate_setup>
77    <setup>
78        <module>Magestore_Rewardpoint</module>
79    </setup>
80    <connection>
81        <use>core_setup</use>
82    </connection>
83    </rate_setup>
84    <rate_read>
85    <connection>
86        <use>core_read</use>
87    </connection>
88    </rate_read>
89    <rate_write>
90    <connection>
91        <use>core_write</use>
92    </connection>
93    </rate_write>
94</resources> 
95     
96<?xml version="1.0"?>
97<config>
98  <modules>
99    <Magestore_Rewardpoint>
100      <version>0.1.0</version>
101    </Magestore_Rewardpoint>
102  </modules>
103  <global>
104    <helpers>
105      <rewardpoint>
106         <class>Magestore_Rewardpoint_Helper</class>
107      </rewardpoint>
108    </helpers>
109    <resources>
110      <rewardpoint_setup>
111        <setup>
112          <module>Magestore_Rewardpoint</module>
113        </setup>
114        <connection>
115          <use>core_setup</use>
116        </connection>
117      </rewardpoint_setup>
118      <rewardpoint_write>
119        <connection>
120          <use>core_write</use>
121        </connection>
122      </rewardpoint_write>
123      <rewardpoint_read>
124        <connection>
125          <use>core_read</use>
126        </connection>
127      </rewardpoint_read>
128    </resources>
129  </global>
130</config> 
131     
132<?php
133$installer = $this;
134$installer->startSetup();
135$sql=<<<SQLTEXT
136create 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'));
137SQLTEXT;
138
139$installer->run($sql);
140
141$installer->endSetup();