4r2AAPcz

1<?xml version="1.0" ?>
2<config>
3   <modules>
4      <Amit_Custommodule>
5         <version>1.1.0</version>
6      </Amit_Custommodule>
7   </modules>
8 <global>
9<models>
10    <custommodule>
11        <class>Amit_Custommodule_Model</class>
12        <resourceModel>custommodule_resource</resourceModel>
13    </custommodule>
14    <custommodule_resource>
15        <entities>
16            <custommodule>
17                <table>custommodule</table>
18            </custommodule>
19            <custommodule>
20                <table>custommodule2</table>
21            </custommodule>             
22            <custommodule>
23                <table>custommodule3</table>
24            </custommodule>
25        </entities>
26    </custommodule_resource>
27</models>
28<resources>
29    <custommodule_setup>
30        <setup>
31            <module>Amit_Custommodule</module>
32            <class>Mage_Customer_Model_Entity_Setup</class>
33        </setup>
34        <connection>
35            <use>core_setup</use>
36        </connection>
37    </custommodule_setup>
38    <custommodule_read>
39        <connection>
40            <use>core_read</use>
41        </connection>
42    </custommodule_read>
43    <custommodule_write>
44        <connection>
45            <use>core_write</use>
46        </connection>
47    </custommodule_write>
48</resources>
49<!-- start of block -->
50<blocks>
51    <custommodule>
52        <class>Amit_Custommodule_Block</class>
53    </custommodule>
54</blocks>
55	
56<?php
57$installer=$this;
58$installer->startSetup();
59
60$installer->run("
61-- DROP TABLE IF EXISTS {$this->getTable('custommodule3')};
62CREATE TABLE {$this->getTable('custommodule3')} (
63  `custommodule_id` int(11) unsigned NOT NULL auto_increment COMMENT 'Q&A ID',
64  `product_id` int(11) NOT NULL  COMMENT 'Product Id' ,
65  `customer_name` varchar(255) NOT NULL COMMENT 'Customer Name',
66  `customer_email` varchar(255) NOT NULL  COMMENT 'Customer Email',
67  `question` text NOT NULL  COMMENT 'Question',
68  `answer` text NOT NULL  COMMENT 'Answer',
69  `status` smallint(6) NOT NULL default '0' COMMENT 'Status',
70  `created_time` datetime NULL,
71  `update_time` datetime NULL,
72  PRIMARY KEY (`custommodule_id`)
73) ENGINE=InnoDB DEFAULT CHARSET=utf8;
74
75    ");
76$installer->endSetup();
77?>