Version Notes
First release Greek regions.
Download this release
Release Info
Developer | Magento Core Team |
Extension | Nikolakisae_GreekRegions |
Version | 0.1.0 |
Comparing to | |
See all releases |
Version 0.1.0
app/code/community/Nikolakisae/GreekRegions/etc/config.xml
ADDED
@@ -0,0 +1,30 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?xml version="1.0"?>
|
2 |
+
<config>
|
3 |
+
<modules>
|
4 |
+
<Nikolakisae_GreekRegions>
|
5 |
+
<version>0.1.0</version>
|
6 |
+
</Nikolakisae_GreekRegions>
|
7 |
+
</modules>
|
8 |
+
<global>
|
9 |
+
<resources>
|
10 |
+
<greekregions_setup>
|
11 |
+
<setup>
|
12 |
+
<module>Nikolakisae_GreekRegions</module>
|
13 |
+
</setup>
|
14 |
+
<connection>
|
15 |
+
<use>core_setup</use>
|
16 |
+
</connection>
|
17 |
+
</greekregions_setup>
|
18 |
+
<greekregions_write>
|
19 |
+
<connection>
|
20 |
+
<use>core_write</use>
|
21 |
+
</connection>
|
22 |
+
</greekregions_write>
|
23 |
+
<greekregions_read>
|
24 |
+
<connection>
|
25 |
+
<use>core_read</use>
|
26 |
+
</connection>
|
27 |
+
</greekregions_read>
|
28 |
+
</resources>
|
29 |
+
</global>
|
30 |
+
</config>
|
app/code/community/Nikolakisae/GreekRegions/sql/greekregions_setup/mysql4-install-0.1.0.php
ADDED
@@ -0,0 +1,275 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?php
|
2 |
+
/**
|
3 |
+
* Greek Regions - Greek Regions Module
|
4 |
+
*
|
5 |
+
* @title Magento -> Greek Regions (Greek)
|
6 |
+
* @category Languages / Locales
|
7 |
+
* @package Nikolakisae_GreekRegions
|
8 |
+
* @author Niko K
|
9 |
+
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
|
10 |
+
*/
|
11 |
+
|
12 |
+
$installer = $this;
|
13 |
+
$installer->startSetup();
|
14 |
+
$installer->run("
|
15 |
+
|
16 |
+
|
17 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
18 |
+
('GR', 'AI', 'Αιτωλοακαρνανίας');
|
19 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
20 |
+
('en_US', LAST_INSERT_ID(), 'Aetolia-Acarnania'), ('el_GR', LAST_INSERT_ID(), 'Αιτωλοακαρνανίας');
|
21 |
+
|
22 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
23 |
+
('GR', 'ARG', 'Αργολίδας');
|
24 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
25 |
+
('en_US', LAST_INSERT_ID(), 'Argolis'), ('el_GR', LAST_INSERT_ID(), 'Αργολίδας');
|
26 |
+
|
27 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
28 |
+
('GR', 'ARK', 'Αρκαδίας');
|
29 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
30 |
+
('en_US', LAST_INSERT_ID(), 'Arcadia'), ('el_GR', LAST_INSERT_ID(), 'Αρκαδίας');
|
31 |
+
|
32 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
33 |
+
('GR', 'AR', 'Άρτας');
|
34 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
35 |
+
('en_US', LAST_INSERT_ID(), 'Arta'), ('el_GR', LAST_INSERT_ID(), 'Άρτας');
|
36 |
+
|
37 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
38 |
+
('GR', 'AT', 'Αττικής');
|
39 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
40 |
+
('en_US', LAST_INSERT_ID(), 'Attica'), ('el_GR', LAST_INSERT_ID(), 'Αττικής');
|
41 |
+
|
42 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
43 |
+
('GR', 'AC', 'Αχαΐας');
|
44 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
45 |
+
('en_US', LAST_INSERT_ID(), 'Achaea'), ('el_GR', LAST_INSERT_ID(), 'Αχαΐας');
|
46 |
+
|
47 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
48 |
+
('GR', 'BO', 'Βοιωτίας');
|
49 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
50 |
+
('en_US', LAST_INSERT_ID(), 'Boeotia'), ('el_GR', LAST_INSERT_ID(), 'Βοιωτίας');
|
51 |
+
|
52 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
53 |
+
('GR', 'GRV', 'Γρεβενών');
|
54 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
55 |
+
('en_US', LAST_INSERT_ID(), 'Grevena'), ('el_GR', LAST_INSERT_ID(), 'Γρεβενών');
|
56 |
+
|
57 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
58 |
+
('GR', 'DR', 'Δράμας');
|
59 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
60 |
+
('en_US', LAST_INSERT_ID(), 'Drama'), ('el_GR', LAST_INSERT_ID(), 'Δράμας');
|
61 |
+
|
62 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
63 |
+
('GR', 'DO', 'Δωδεκανήσου');
|
64 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
65 |
+
('en_US', LAST_INSERT_ID(), 'Dodecanese'), ('el_GR', LAST_INSERT_ID(), 'Δωδεκανήσου');
|
66 |
+
|
67 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
68 |
+
('GR', 'EVR', 'Έβρου');
|
69 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
70 |
+
('en_US', LAST_INSERT_ID(), 'Evros'), ('el_GR', LAST_INSERT_ID(), 'Έβρου');
|
71 |
+
|
72 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
73 |
+
('GR', 'ΕU', 'Εύβοιας');
|
74 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
75 |
+
('en_US', LAST_INSERT_ID(), 'Euboea'), ('el_GR', LAST_INSERT_ID(), 'Εύβοιας');
|
76 |
+
|
77 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
78 |
+
('GR', 'EV', 'Ευρυτανίας');
|
79 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
80 |
+
('en_US', LAST_INSERT_ID(), 'Evrytania'), ('el_GR', LAST_INSERT_ID(), 'Ευρυτανίας');
|
81 |
+
|
82 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
83 |
+
('GR', 'ZA', 'Ζακύνθου');
|
84 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
85 |
+
('en_US', LAST_INSERT_ID(), 'Zakynthos'), ('el_GR', LAST_INSERT_ID(), 'Ζακύνθου');
|
86 |
+
|
87 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
88 |
+
('GR', 'EL', 'Ηλείας');
|
89 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
90 |
+
('en_US', LAST_INSERT_ID(), 'Elis'), ('el_GR', LAST_INSERT_ID(), 'Ηλείας');
|
91 |
+
|
92 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
93 |
+
('GR', 'IM', 'Ημαθίας');
|
94 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
95 |
+
('en_US', LAST_INSERT_ID(), 'Imathia'), ('el_GR', LAST_INSERT_ID(), 'Ημαθίας');
|
96 |
+
|
97 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
98 |
+
('GR', 'HE', 'Ηρακλείου');
|
99 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
100 |
+
('en_US', LAST_INSERT_ID(), 'Heraklion'), ('el_GR', LAST_INSERT_ID(), 'Ηρακλείου');
|
101 |
+
|
102 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
103 |
+
('GR', 'THE', 'Θεσπρωτίας');
|
104 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
105 |
+
('en_US', LAST_INSERT_ID(), 'Thesprotia'), ('el_GR', LAST_INSERT_ID(), 'Θεσπρωτίας');
|
106 |
+
|
107 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
108 |
+
('GR', 'TH', 'Θεσσαλονίκης');
|
109 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
110 |
+
('en_US', LAST_INSERT_ID(), 'Thessaloniki'), ('el_GR', LAST_INSERT_ID(), 'Θεσσαλονίκης');
|
111 |
+
|
112 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
113 |
+
('GR', 'IO', 'Ιωαννίνων');
|
114 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
115 |
+
('en_US', LAST_INSERT_ID(), 'Ioannina'), ('el_GR', LAST_INSERT_ID(), 'Ιωαννίνων');
|
116 |
+
|
117 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
118 |
+
('GR', 'KA', 'Καβάλας');
|
119 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
120 |
+
('en_US', LAST_INSERT_ID(), 'Kavala'), ('el_GR', LAST_INSERT_ID(), 'Καβάλας');
|
121 |
+
|
122 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
123 |
+
('GR', 'KAR', 'Καρδίτσας');
|
124 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
125 |
+
('en_US', LAST_INSERT_ID(), 'Karditsa'), ('el_GR', LAST_INSERT_ID(), 'Καρδίτσας');
|
126 |
+
|
127 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
128 |
+
('GR', 'KAS', 'Καστοριάς');
|
129 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
130 |
+
('en_US', LAST_INSERT_ID(), 'Kastoria'), ('el_GR', LAST_INSERT_ID(), 'Καστοριάς');
|
131 |
+
|
132 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
133 |
+
('GR', 'CO', 'Κέρκυρας');
|
134 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
135 |
+
('en_US', LAST_INSERT_ID(), 'Corfu'), ('el_GR', LAST_INSERT_ID(), 'Κέρκυρας');
|
136 |
+
|
137 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
138 |
+
('GR', 'KE', 'Κεφαλληνίας');
|
139 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
140 |
+
('en_US', LAST_INSERT_ID(), 'Kefalonia and Ithaca'), ('el_GR', LAST_INSERT_ID(), 'Κεφαλληνίας');
|
141 |
+
|
142 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
143 |
+
('GR', 'KI', 'Κιλκίς');
|
144 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
145 |
+
('en_US', LAST_INSERT_ID(), 'Kilkis'), ('el_GR', LAST_INSERT_ID(), 'Κιλκίς');
|
146 |
+
|
147 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
148 |
+
('GR', 'KO', 'Κοζάνης');
|
149 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
150 |
+
('en_US', LAST_INSERT_ID(), 'Kozani'), ('el_GR', LAST_INSERT_ID(), 'Κοζάνης');
|
151 |
+
|
152 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
153 |
+
('GR', 'COR', 'Κορινθίας');
|
154 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
155 |
+
('en_US', LAST_INSERT_ID(), 'Corinthia'), ('el_GR', LAST_INSERT_ID(), 'Κορινθίας');
|
156 |
+
|
157 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
158 |
+
('GR', 'CY', 'Κυκλάδων');
|
159 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
160 |
+
('en_US', LAST_INSERT_ID(), 'Cyclades'), ('el_GR', LAST_INSERT_ID(), 'Κυκλάδων');
|
161 |
+
|
162 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
163 |
+
('GR', 'LAC', 'Λακωνίας');
|
164 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
165 |
+
('en_US', LAST_INSERT_ID(), 'Laconia'), ('el_GR', LAST_INSERT_ID(), 'Λακωνίας');
|
166 |
+
|
167 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
168 |
+
('GR', 'LAR', 'Λάρισας');
|
169 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
170 |
+
('en_US', LAST_INSERT_ID(), 'Larissa'), ('el_GR', LAST_INSERT_ID(), 'Λάρισας');
|
171 |
+
|
172 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
173 |
+
('GR', 'LA', 'Λασιθίου');
|
174 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
175 |
+
('en_US', LAST_INSERT_ID(), 'Lasithi'), ('el_GR', LAST_INSERT_ID(), 'Λασιθίου');
|
176 |
+
|
177 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
178 |
+
('GR', 'LES', 'Λέσβου');
|
179 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
180 |
+
('en_US', LAST_INSERT_ID(), 'Lesbos'), ('el_GR', LAST_INSERT_ID(), 'Λέσβου');
|
181 |
+
|
182 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
183 |
+
('GR', 'LE', 'Λευκάδας');
|
184 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
185 |
+
('en_US', LAST_INSERT_ID(), 'Lefkada'), ('el_GR', LAST_INSERT_ID(), 'Λευκάδας');
|
186 |
+
|
187 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
188 |
+
('GR', 'MA', 'Μαγνησίας');
|
189 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
190 |
+
('en_US', LAST_INSERT_ID(), 'Magnesia'), ('el_GR', LAST_INSERT_ID(), 'Μαγνησίας');
|
191 |
+
|
192 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
193 |
+
('GR', 'ME', 'Μεσσηνίας');
|
194 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
195 |
+
('en_US', LAST_INSERT_ID(), 'Messenia'), ('el_GR', LAST_INSERT_ID(), 'Μεσσηνίας');
|
196 |
+
|
197 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
198 |
+
('GR', 'XA', 'Ξάνθης');
|
199 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
200 |
+
('en_US', LAST_INSERT_ID(), 'Xanthi'), ('el_GR', LAST_INSERT_ID(), 'Ξάνθης');
|
201 |
+
|
202 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
203 |
+
('GR', 'PE', 'Πέλλας');
|
204 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
205 |
+
('en_US', LAST_INSERT_ID(), 'Pella'), ('el_GR', LAST_INSERT_ID(), 'Πέλλας');
|
206 |
+
|
207 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
208 |
+
('GR', 'PI', 'Πιερίας');
|
209 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
210 |
+
('en_US', LAST_INSERT_ID(), 'Pieria'), ('el_GR', LAST_INSERT_ID(), 'Πιερίας');
|
211 |
+
|
212 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
213 |
+
('GR', 'PR', 'Πρέβεζας');
|
214 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
215 |
+
('en_US', LAST_INSERT_ID(), 'Preveza'), ('el_GR', LAST_INSERT_ID(), 'Πρέβεζας');
|
216 |
+
|
217 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
218 |
+
('GR', 'RE', 'Ρεθύμνης');
|
219 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
220 |
+
('en_US', LAST_INSERT_ID(), 'Rethymno'), ('el_GR', LAST_INSERT_ID(), 'Ρεθύμνης');
|
221 |
+
|
222 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
223 |
+
('GR', 'RH', 'Ροδόπης');
|
224 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
225 |
+
('en_US', LAST_INSERT_ID(), 'Rhodope'), ('el_GR', LAST_INSERT_ID(), 'Ροδόπης');
|
226 |
+
|
227 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
228 |
+
('GR', 'SA', 'Σάμου');
|
229 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
230 |
+
('en_US', LAST_INSERT_ID(), 'Samos'), ('el_GR', LAST_INSERT_ID(), 'Σάμου');
|
231 |
+
|
232 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
233 |
+
('GR', 'SE', 'Σερρών');
|
234 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
235 |
+
('en_US', LAST_INSERT_ID(), 'Serres'), ('el_GR', LAST_INSERT_ID(), 'Σερρών');
|
236 |
+
|
237 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
238 |
+
('GR', 'TR', 'Τρικάλων');
|
239 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
240 |
+
('en_US', LAST_INSERT_ID(), 'Trikala'), ('el_GR', LAST_INSERT_ID(), 'Τρικάλων');
|
241 |
+
|
242 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
243 |
+
('GR', 'PHT', 'Φθιώτιδας');
|
244 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
245 |
+
('en_US', LAST_INSERT_ID(), 'Phthiotis'), ('el_GR', LAST_INSERT_ID(), 'Φθιώτιδας');
|
246 |
+
|
247 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
248 |
+
('GR', 'FL', 'Φλώρινας');
|
249 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
250 |
+
('en_US', LAST_INSERT_ID(), 'Florina'), ('el_GR', LAST_INSERT_ID(), 'Φλώρινας');
|
251 |
+
|
252 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
253 |
+
('GR', 'PH', 'Φωκίδας');
|
254 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
255 |
+
('en_US', LAST_INSERT_ID(), 'Phocis'), ('el_GR', LAST_INSERT_ID(), 'Φωκίδας');
|
256 |
+
|
257 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
258 |
+
('GR', 'CHAL', 'Χαλκιδικής');
|
259 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
260 |
+
('en_US', LAST_INSERT_ID(), 'Chalkidiki'), ('el_GR', LAST_INSERT_ID(), 'Χαλκιδικής');
|
261 |
+
|
262 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
263 |
+
('GR', 'CH', 'Χανίων');
|
264 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
265 |
+
('en_US', LAST_INSERT_ID(), 'Chania'), ('el_GR', LAST_INSERT_ID(), 'Χανίων');
|
266 |
+
|
267 |
+
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
|
268 |
+
('GR', 'CHI', 'Χίου');
|
269 |
+
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
|
270 |
+
('en_US', LAST_INSERT_ID(), 'Chios'), ('el_GR', LAST_INSERT_ID(), 'Χίου');
|
271 |
+
|
272 |
+
");
|
273 |
+
|
274 |
+
$installer->endSetup();
|
275 |
+
|
app/etc/modules/Nikolakisae_GreekRegions.xml
ADDED
@@ -0,0 +1,9 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?xml version="1.0"?>
|
2 |
+
<config>
|
3 |
+
<modules>
|
4 |
+
<Nikolakisae_GreekRegions>
|
5 |
+
<active>true</active>
|
6 |
+
<codePool>community</codePool>
|
7 |
+
</Nikolakisae_GreekRegions>
|
8 |
+
</modules>
|
9 |
+
</config>
|
package.xml
ADDED
@@ -0,0 +1,18 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?xml version="1.0"?>
|
2 |
+
<package>
|
3 |
+
<name>Nikolakisae_GreekRegions</name>
|
4 |
+
<version>0.1.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>List of Greek regions.</summary>
|
10 |
+
<description>List of Greek regions usefull for localization and shipping.</description>
|
11 |
+
<notes>First release Greek regions.</notes>
|
12 |
+
<authors><author><name>Niko K</name><user>auto-converted</user><email>nikolakisae@gmail.com</email></author></authors>
|
13 |
+
<date>2011-12-03</date>
|
14 |
+
<time>21:05:26</time>
|
15 |
+
<contents><target name="mageetc"><dir name="modules"><file name="Nikolakisae_GreekRegions.xml" hash="21a51acb58b201b3ee7e0d50958da20d"/></dir></target><target name="magecommunity"><dir name="Nikolakisae"><dir name="GreekRegions"><dir name="etc"><file name="config.xml" hash="56b87f20f137d3ded9903fc5d52615c2"/></dir><dir name="sql"><dir name="greekregions_setup"><file name="mysql4-install-0.1.0.php" hash="a4489ab609897c9487d3074989a7a583"/></dir></dir></dir></dir></target></contents>
|
16 |
+
<compatible/>
|
17 |
+
<dependencies/>
|
18 |
+
</package>
|