INSERT IGNORE INTO `#__hikashop_zone` (
`zone_id` ,
`zone_namekey` ,
`zone_name` ,
`zone_name_english` ,
`zone_code_2` ,
`zone_code_3` ,
`zone_type` ,
`zone_published` ,
`zone_currency_id`
)
VALUES (
NULL , 'world_europe', 'Europe', 'Europe', '', '', 'world', '1', '0'
), (
NULL , 'world_europe_community', 'Europe communauté', 'Europe community', '', '', 'world', '1', '1'
), (
NULL , 'world_asia', 'Asie', 'Asia', '', '', 'world', '1', '0'
), (
NULL , 'world_america_north', 'Amerique du nord', 'Noth America', '', '', 'world', '1', '2'
), (
NULL , 'world_america_south', 'Amerique du sud', 'South America', '', '', 'world', '1', '0'
), (
NULL , 'world_oceania', 'Oceanie', 'Oceania', '', '', 'world', '1', '0'
), (
NULL , 'world_australia', 'Australie', 'Australia', '', '', 'world', '1', '0'
), (
NULL , 'world_africa', 'Afrique', 'Africa', '', '', 'world', '1', '0'
), (
NULL , 'world_antartica', 'Antartique', 'Antartica', '', '', 'world', '1', '0'
)
;
INSERT IGNORE INTO marc_hikashop_zone_link
(zone_parent_namekey, zone_child_namekey)
VALUES
('world_europe_community' ,'country_Andorra_5' ) ,
('world_europe_community' ,'country_Belgium_21' ) ,
('world_europe_community' ,'country_Bulgaria_33' ) ,
('world_europe_community' ,'country_Cyprus_55' ) ,
('world_europe_community' ,'country_Czech_Republic_56' ) ,
('world_europe_community' ,'country_Denmark_57' ) ,
('world_europe_community' ,'country_Finland_72' ) ,
('world_europe_community' ,'country_France_73' ) ,
('world_europe_community' ,'country_France__Metropolitan_74' ) ,
('world_europe_community' ,'country_Germany_81' ) ,
('world_europe_community' ,'country_Gibraltar_83' ) ,
('world_europe_community' ,'country_Greece_84' ) ,
('world_europe_community' ,'country_Hungary_97' ) ,
('world_europe_community' ,'country_Ireland_103' ) ,
('world_europe_community' ,'country_Italy_105' ) ,
('world_europe_community' ,'country_Latvia_117' ) ,
('world_europe_community' ,'country_Liechtenstein_122' ) ,
('world_europe_community' ,'country_Lithuania_123' ) ,
('world_europe_community' ,'country_Luxembourg_124' ) ,
('world_europe_community' ,'country_Malta_132' ) ,
('world_europe_community' ,'country_Monaco_141' ) ,
('world_europe_community' ,'country_Netherlands_150' ) ,
('world_europe_community' ,'country_Poland_170' ) ,
('world_europe_community' ,'country_Portugal_171' ) ,
('world_europe_community' ,'country_Romania_175' ) ,
('world_europe_community' ,'country_Slovakia_189' ) ,
('world_europe_community' ,'country_Slovenia_190' ) ,
('world_europe_community' ,'country_Spain_195' ) ,
('world_europe_community' ,'country_Sweden_203' ) ,
('world_europe_community' ,'country_United_Kingdom_222' ) ,
('world_europe_community' ,'country_Vatican_City_State__Holy_See__228' )
;
si des ames charitables voulaient partager le boulot a 2 ou 3 deja en faisant pas continent