Skumar_IndiaRegions - Version 1.0.0

Version Notes

Magento provides country and regions and cities as dropdown option in addresses. India Regions extension extends this feature by adding updated states of India.

Download this release

Release Info

Developer Shyam Kumar
Extension Skumar_IndiaRegions
Version 1.0.0
Comparing to
See all releases


Version 1.0.0

Files changed (4) hide show
  1. app/code/community/Skumar/IndiaRegions/etc/config.xml +30 -0
  2. app/code/community/Skumar/IndiaRegions/sql/indiaregions_setup/mysql4-install-1.0.0.php +209 -0
  3. app/etc/modules/Skumar_IndiaRegions.xml +9 -0
  4. package.xml +18 -0
app/code/community/Skumar/IndiaRegions/etc/config.xml ADDED
@@ -0,0 +1,30 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?xml version="1.0"?>
2
+ <config>
3
+ <modules>
4
+ <Skumar_IndiaRegions>
5
+ <version>1.0.0</version>
6
+ </Skumar_IndiaRegions>
7
+ </modules>
8
+ <global>
9
+ <resources>
10
+ <indiaregions_setup>
11
+ <setup>
12
+ <module>Skumar_IndiaRegions</module>
13
+ </setup>
14
+ <connection>
15
+ <use>core_setup</use>
16
+ </connection>
17
+ </indiaregions_setup>
18
+ <indiaregions_write>
19
+ <connection>
20
+ <use>core_write</use>
21
+ </connection>
22
+ </indiaregions_write>
23
+ <indiaregions_read>
24
+ <connection>
25
+ <use>core_read</use>
26
+ </connection>
27
+ </indiaregions_read>
28
+ </resources>
29
+ </global>
30
+ </config>
app/code/community/Skumar/IndiaRegions/sql/indiaregions_setup/mysql4-install-1.0.0.php ADDED
@@ -0,0 +1,209 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+ /**
3
+ * Skumar
4
+ *
5
+ * NOTICE OF LICENSE
6
+ *
7
+ * This source file is subject to the Open Software License (OSL 3.0)
8
+ * that is bundled with this package in the file LICENSE.txt.
9
+ * It is also available through the world-wide-web at this URL:
10
+ * http://opensource.org/licenses/osl-3.0.php
11
+ *
12
+ * @category Skumar
13
+ * @package Skumar_IndiaRegions
14
+ * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
15
+ * @author Shyam Kumar <kumar.30.shyam@gmail.com>
16
+ */
17
+
18
+ $installer = $this;
19
+ $installer->startSetup();
20
+ $installer->run("
21
+
22
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
23
+ ('IN', 'AP', 'Andhra Pradesh');
24
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
25
+ ('en_US', LAST_INSERT_ID(), 'Andhra Pradesh');
26
+
27
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
28
+ ('IN', 'AR', 'Arunachal Pradesh');
29
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
30
+ ('en_US', LAST_INSERT_ID(), 'Arunachal Pradesh');
31
+
32
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
33
+ ('IN', 'AS', 'Assam');
34
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
35
+ ('en_US', LAST_INSERT_ID(), 'Assam');
36
+
37
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
38
+ ('IN', 'BR', 'Bihar');
39
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
40
+ ('en_US', LAST_INSERT_ID(), 'Bihar');
41
+
42
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
43
+ ('IN', 'CG', 'Chhattisgarh');
44
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
45
+ ('en_US', LAST_INSERT_ID(), 'Chhattisgarh');
46
+
47
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
48
+ ('IN', 'GA', 'Goa');
49
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
50
+ ('en_US', LAST_INSERT_ID(), 'Goa');
51
+
52
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
53
+ ('IN', 'GJ', 'Gujarat');
54
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
55
+ ('en_US', LAST_INSERT_ID(), 'Gujarat');
56
+
57
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
58
+ ('IN', 'HR', 'Haryana');
59
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
60
+ ('en_US', LAST_INSERT_ID(), 'Haryana');
61
+
62
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
63
+ ('IN', 'HP', 'Himachal Pradesh');
64
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
65
+ ('en_US', LAST_INSERT_ID(), 'Himachal Pradesh');
66
+
67
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
68
+ ('IN', 'JK', 'Jammu and Kashmir');
69
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
70
+ ('en_US', LAST_INSERT_ID(), 'Jammu and Kashmir');
71
+
72
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
73
+ ('IN', 'JH', 'Jharkhand');
74
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
75
+ ('en_US', LAST_INSERT_ID(), 'Jharkhand');
76
+
77
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
78
+ ('IN', 'KA', 'Karnataka');
79
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
80
+ ('en_US', LAST_INSERT_ID(), 'Karnataka');
81
+
82
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
83
+ ('IN', 'KL', 'Kerala');
84
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
85
+ ('en_US', LAST_INSERT_ID(), 'Kerala');
86
+
87
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
88
+ ('IN', 'MP', 'Madhya Pradesh');
89
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
90
+ ('en_US', LAST_INSERT_ID(), 'Madhya Pradesh');
91
+
92
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
93
+ ('IN', 'MH', 'Maharashtra');
94
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
95
+ ('en_US', LAST_INSERT_ID(), 'Maharashtra');
96
+
97
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
98
+ ('IN', 'MN', 'Manipur');
99
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
100
+ ('en_US', LAST_INSERT_ID(), 'Manipur');
101
+
102
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
103
+ ('IN', 'ML', 'Meghalaya');
104
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
105
+ ('en_US', LAST_INSERT_ID(), 'Meghalaya');
106
+
107
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
108
+ ('IN', 'MZ', 'Mizoram');
109
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
110
+ ('en_US', LAST_INSERT_ID(), 'Mizoram');
111
+
112
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
113
+ ('IN', 'NL', 'Nagaland');
114
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
115
+ ('en_US', LAST_INSERT_ID(), 'Nagaland');
116
+
117
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
118
+ ('IN', 'OR', 'Orissa');
119
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
120
+ ('en_US', LAST_INSERT_ID(), 'Orissa');
121
+
122
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
123
+ ('IN', 'PB', 'Punjab');
124
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
125
+ ('en_US', LAST_INSERT_ID(), 'Punjab');
126
+
127
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
128
+ ('IN', 'RJ', 'Rajasthan');
129
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
130
+ ('en_US', LAST_INSERT_ID(), 'Rajasthan');
131
+
132
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
133
+ ('IN', 'SK', 'Sikkim');
134
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
135
+ ('en_US', LAST_INSERT_ID(), 'Sikkim');
136
+
137
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
138
+ ('IN', 'TN', 'Tamil Nadu');
139
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
140
+ ('en_US', LAST_INSERT_ID(), 'Tamil Nadu');
141
+
142
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
143
+ ('IN', 'TR', 'Tripura');
144
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
145
+ ('en_US', LAST_INSERT_ID(), 'Tripura');
146
+
147
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
148
+ ('IN', 'UK', 'Uttarakhand');
149
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
150
+ ('en_US', LAST_INSERT_ID(), 'Uttarakhand');
151
+
152
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
153
+ ('IN', 'UP', 'Uttar Pradesh');
154
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
155
+ ('en_US', LAST_INSERT_ID(), 'Uttar Pradesh');
156
+
157
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
158
+ ('IN', 'WB', 'West Bengal');
159
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
160
+ ('en_US', LAST_INSERT_ID(), 'West Bengal');
161
+
162
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
163
+ ('IN', 'TN', 'Tamil Nadu');
164
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
165
+ ('en_US', LAST_INSERT_ID(), 'Tamil Nadu');
166
+
167
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
168
+ ('IN', 'TR', 'Tripura');
169
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
170
+ ('en_US', LAST_INSERT_ID(), 'Tripura');
171
+
172
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
173
+ ('IN', 'AN', 'Andaman and Nicobar Islands');
174
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
175
+ ('en_US', LAST_INSERT_ID(), 'Andaman and Nicobar Islands');
176
+
177
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
178
+ ('IN', 'CH', 'Chandigarh');
179
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
180
+ ('en_US', LAST_INSERT_ID(), 'Chandigarh');
181
+
182
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
183
+ ('IN', 'DH', 'Dadra and Nagar Haveli');
184
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
185
+ ('en_US', LAST_INSERT_ID(), 'Dadra and Nagar Haveli');
186
+
187
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
188
+ ('IN', 'DD', 'Daman and Diu');
189
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
190
+ ('en_US', LAST_INSERT_ID(), 'Daman and Diu');
191
+
192
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
193
+ ('IN', 'DL', 'Delhi');
194
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
195
+ ('en_US', LAST_INSERT_ID(), 'Delhi');
196
+
197
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
198
+ ('IN', 'LD', 'Lakshadweep');
199
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
200
+ ('en_US', LAST_INSERT_ID(), 'Lakshadweep');
201
+
202
+ INSERT INTO `{$installer->getTable('directory_country_region')}` (`country_id`, `code`, `default_name`) VALUES
203
+ ('IN', 'PY', 'Pondicherry');
204
+ INSERT INTO `{$installer->getTable('directory_country_region_name')}` (`locale`, `region_id`, `name`) VALUES
205
+ ('en_US', LAST_INSERT_ID(), 'Pondicherry');
206
+ ");
207
+
208
+ $installer->endSetup();
209
+
app/etc/modules/Skumar_IndiaRegions.xml ADDED
@@ -0,0 +1,9 @@
 
 
 
 
 
 
 
 
 
1
+ <?xml version="1.0"?>
2
+ <config>
3
+ <modules>
4
+ <Skumar_IndiaRegions>
5
+ <active>true</active>
6
+ <codePool>community</codePool>
7
+ </Skumar_IndiaRegions>
8
+ </modules>
9
+ </config>
package.xml ADDED
@@ -0,0 +1,18 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?xml version="1.0"?>
2
+ <package>
3
+ <name>Skumar_IndiaRegions</name>
4
+ <version>1.0.0</version>
5
+ <stability>stable</stability>
6
+ <license uri="http://www.opensource.org/licenses/osl-3.0.php">OSL v3.0</license>
7
+ <channel>community</channel>
8
+ <extends/>
9
+ <summary>Magento provides country and regions and cities as dropdown option in addresses. India Regions extension extends this feature by adding updated states of India.</summary>
10
+ <description>Magento provides country and regions and cities as dropdown option in addresses. India Regions extension extends this feature by adding updated states of India.</description>
11
+ <notes>Magento provides country and regions and cities as dropdown option in addresses. India Regions extension extends this feature by adding updated states of India.</notes>
12
+ <authors><author><name>Shyam Kumar</name><user>shyamkumar</user><email>kumar.30.shyam@gmail.com</email></author></authors>
13
+ <date>2014-12-30</date>
14
+ <time>07:49:44</time>
15
+ <contents><target name="mageetc"><dir name="modules"><file name="Skumar_IndiaRegions.xml" hash="9499be1a54281b9d4e729fdca3be8302"/></dir></target><target name="magecommunity"><dir name="Skumar"><dir name="IndiaRegions"><dir name="etc"><file name="config.xml" hash="224171b9939f0762ceaf27f98f012af6"/></dir><dir name="sql"><dir name="indiaregions_setup"><file name="mysql4-install-1.0.0.php" hash="b9f4183dbe0d825afa7a7bef1bfd7917"/></dir></dir></dir></dir></target></contents>
16
+ <compatible/>
17
+ <dependencies><required><php><min>5.2.0</min><max>6.0.0</max></php></required></dependencies>
18
+ </package>