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>
|
