FRENCH STATES LIST - liste des departement francais

[rezopac]

voici le script sql permettant d'ajouter les départements français dans virtuemart (avec les id correspondant au numéro de département - on à une baguette sous le bras et un beret... ou pas!):

Code: [Select]

UPDATE jos_vm_state SET state_id = state_id + 6000;
UPDATE jos_vm_state SET state_id = state_id - 5900;

INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('1', '73', 'Ain', 'AIN', 'AI');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('2', '73', 'Aisne', 'AIS', 'AS');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('3', '73', 'Allier', 'ALL', 'AL');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('4', '73', 'Alpes-de-Haute-Provence', 'ALP', 'AP');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('6', '73', 'Alpes-Maritimes', 'AMP', 'AM');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('31', '73', 'Haute-Garonne', 'HGA', 'HG');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('43', '73', 'Haute-Loire', 'HLO', 'HL');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('5', '73', 'Hautes-Alpes', 'HAL', 'HA');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('52', '73', 'Haute-Marne', 'HMA', 'HM');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('70', '73', 'Haute-Saône', 'HSA', 'HS');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('74', '73', 'Haute-Savoie', 'HSV', 'HV');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('87', '73', 'Haute-Vienne', 'HVI', 'HE');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('2002', '73', 'Haute-Corse', 'HCO', 'HC');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('7', '73', 'Ardèche', 'ARC', 'AC');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('8', '73', 'Ardennes', 'ARN', 'AN');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('9', '73', 'Ariège', 'ARI', 'AR');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('10', '73', 'Aube', 'AUB', 'AU');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('11', '73', 'Aude', 'AUD', 'AD');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('12', '73', 'Aveyron', 'AVE', 'AV');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('13', '73', 'Bouches-du-Rhône', 'BOU', 'BO');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('14', '73', 'Calvados', 'CAL', 'CA');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('15', '73', 'Cantal', 'CAN', 'CN');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('16', '73', 'Charente', 'CHA', 'CH');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('17', '73', 'Charente-Maritime', 'CHM', 'CM');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('18', '73', 'Cher', 'CHE', 'CE');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('19', '73', 'Corrèze', 'COR', 'CO');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('21', '73', 'Côte-d\'Or', 'COT', 'CT');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('22', '73', 'Côtes-d\'Armor', 'COA', 'CD');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('2001', '73', 'Corse-du-Sud', 'COS', 'CS');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('23', '73', 'Creuse', 'CRE', 'CR');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('24', '73', 'Dordogne', 'DOR', 'DO');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('25', '73', 'Doubs', 'DOU', 'DU');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('26', '73', 'Drôme', 'DRO', 'DR');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('27', '73', 'Eure', 'EUR', 'ER');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('28', '73', 'Eure-et-Loir', 'EUL', 'EU');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('29', '73', 'Finistère', 'FIN', 'FI');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('30', '73', 'Gard', 'GAR', 'GA');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('32', '73', 'Gers', 'GER', 'GE');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('33', '73', 'Gironde', 'GIR', 'GI');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('34', '73', 'Hérault', 'HER', 'HT');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('35', '73', 'Ille-et-Vilaine', 'ILL', 'IL');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('36', '73', 'Indre', 'IND', 'ID');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('37', '73', 'Indre-et-Loire', 'INL', 'IN');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('38', '73', 'Isère', 'ISÈ', 'IS');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('39', '73', 'Jura', 'JUR', 'JU');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('40', '73', 'Landes', 'LAN', 'LA');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('41', '73', 'Loir-et-Cher', 'LOI', 'LI');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('42', '73', 'Loire', 'LOE', 'LE');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('44', '73', 'Loire-Atlantique', 'LOA', 'LQ');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('45', '73', 'Loiret', 'LOR', 'LR');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('46', '73', 'Lot', 'LOT', 'LT');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('47', '73', 'Lot-et-Garonne', 'LOG', 'LG');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('48', '73', 'Lozère', 'LOZ', 'LO');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('49', '73', 'Maine-et-Loire', 'MAI', 'MI');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('50', '73', 'Manche', 'MAN', 'MN');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('51', '73', 'Marne', 'MAR', 'MR');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('53', '73', 'Mayenne', 'MAY', 'MY');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('54', '73', 'Meurthe-et-Moselle', 'MEM', 'MM');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('55', '73', 'Meuse', 'MEU', 'ME');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('56', '73', 'Morbihan', 'MOR', 'MB');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('57', '73', 'Moselle', 'MOS', 'MS');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('58', '73', 'Nièvre', 'NIÈ', 'NI');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('59', '73', 'Nord', 'NOR', 'NO');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('60', '73', 'Oise', 'OIS', 'OI');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('61', '73', 'Orne', 'ORN', 'OR');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('62', '73', 'Pas-de-Calais', 'PAS', 'PC');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('63', '73', 'Puy-de-Dôme', 'PUY', 'PU');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('64', '73', 'Pyrénées-Atlantiques', 'PYA', 'PR');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('65', '73', 'Hautes-Pyrénées', 'HPY', 'HP');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('66', '73', 'Pyrénées-Orientales', 'PYR', 'PY');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('67', '73', 'Bas-Rhin', 'BAS', 'BA');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('68', '73', 'Haut-Rhin', 'HRH', 'HR');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('69', '73', 'Rhône', 'RHO', 'RH');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('71', '73', 'Saône-et-Loire', 'SAO', 'SL');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('72', '73', 'Sarthe', 'SAR', 'SR');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('73', '73', 'Savoie', 'SAV', 'SV');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('75', '73', 'Paris', 'PAR', 'PA');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('76', '73', 'Seine-Maritime', 'SMA', 'SA');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('77', '73', 'Seine-et-Marne', 'SEM', 'SE');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('78', '73', 'Yvelines', 'YVE', 'YV');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('79', '73', 'Deux-Sèvres', 'DEU', 'DE');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('80', '73', 'Somme', 'SOM', 'SO');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('81', '73', 'Tarn', 'TAR', 'TA');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('82', '73', 'Tarn-et-Garonne', 'TAG', 'TG');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('83', '73', 'Var', 'VAR', 'VR');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('84', '73', 'Vaucluse', 'VAU', 'VU');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('85', '73', 'Vendée', 'VEN', 'VE');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('86', '73', 'Vienne', 'VIE', 'VI');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('88', '73', 'Vosges', 'VOS', 'VO');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('89', '73', 'Yonne', 'YON', 'YO');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('90', '73', 'Territoire de Belfort', 'TER', 'TE');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('91', '73', 'Essonne', 'ESS', 'ES');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('92', '73', 'Hauts-de-Seine', 'HSE', 'HI');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('93', '73', 'Seine-Saint-Denis', 'SEI', 'SS');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('94', '73', 'Val-de-Marne', 'VAM', 'VM');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('95', '73', 'Val-d\'Oise', 'VAL', 'VS');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('971', '73', 'Guadeloupe', 'GUA', 'GL');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('972', '73', 'Martinique', 'MAT', 'MA');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('973', '73', 'Guyane', 'GUY', 'GU');
INSERT INTO jos_vm_state (state_id, country_id, state_name, state_3_code, state_2_code) VALUES('974', '73', 'La Réunion', 'LAR', 'LN');
copyright BSD-SYS

[openecommerce]

INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Ain', 'AIN', 'AI');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Aisne', 'AIS', 'AS');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Allier', 'ALL', 'AL');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Alpes-de-Haute-Provence', 'ALP', 'AP');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Alpes-Maritimes', 'AMP', 'AM');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Haute-Garonne', 'HGA', 'HG');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Haute-Loire', 'HLO', 'HL');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Hautes-Alpes', 'HAL', 'HA');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Haute-Marne', 'HMA', 'HM');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Haute-Saône', 'HSA', 'HS');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Haute-Savoie', 'HSV', 'HV');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Haute-Vienne', 'HVI', 'HE');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Haute-Corse', 'HCO', 'HC');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Ardèche', 'ARC', 'AC');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Ardennes', 'ARN', 'AN');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Ariège', 'ARI', 'AR');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Aube', 'AUB', 'AU');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Aude', 'AUD', 'AD');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Aveyron', 'AVE', 'AV');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Bouches-du-Rhône', 'BOU', 'BO');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Calvados', 'CAL', 'CA');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Cantal', 'CAN', 'CN');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Charente', 'CHA', 'CH');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Charente-Maritime', 'CHM', 'CM');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Cher', 'CHE', 'CE');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Corrèze', 'COR', 'CO');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Côte-d\'Or', 'COT', 'CT');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Côtes-d\'Armor', 'COA', 'CD');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Corse-du-Sud', 'COS', 'CS');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Creuse', 'CRE', 'CR');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Dordogne', 'DOR', 'DO');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Doubs', 'DOU', 'DU');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Drôme', 'DRO', 'DR');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Eure', 'EUR', 'ER');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Eure-et-Loir', 'EUL', 'EU');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Finistère', 'FIN', 'FI');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Gard', 'GAR', 'GA');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Gers', 'GER', 'GE');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Gironde', 'GIR', 'GI');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Hérault', 'HER', 'HT');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Ille-et-Vilaine', 'ILL', 'IL');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Indre', 'IND', 'ID');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Indre-et-Loire', 'INL', 'IN');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Isère', 'ISÈ', 'IS');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Jura', 'JUR', 'JU');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Landes', 'LAN', 'LA');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Loir-et-Cher', 'LOI', 'LI');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Loire', 'LOE', 'LE');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Loire-Atlantique', 'LOA', 'LQ');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Loiret', 'LOR', 'LR');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Lot', 'LOT', 'LT');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Lot-et-Garonne', 'LOG', 'LG');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Lozère', 'LOZ', 'LO');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Maine-et-Loire', 'MAI', 'MI');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Manche', 'MAN', 'MN');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Marne', 'MAR', 'MR');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Mayenne', 'MAY', 'MY');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Meurthe-et-Moselle', 'MEM', 'MM');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Meuse', 'MEU', 'ME');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Morbihan', 'MOR', 'MB');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Moselle', 'MOS', 'MS');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Nièvre', 'NIÈ', 'NI');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Nord', 'NOR', 'NO');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Oise', 'OIS', 'OI');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Orne', 'ORN', 'OR');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Pas-de-Calais', 'PAS', 'PC');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Puy-de-Dôme', 'PUY', 'PU');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Pyrénées-Atlantiques', 'PYA', 'PR');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Hautes-Pyrénées', 'HPY', 'HP');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Pyrénées-Orientales', 'PYR', 'PY');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Bas-Rhin', 'BAS', 'BA');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Haut-Rhin', 'HRH', 'HR');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Rhône', 'RHO', 'RH');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Saône-et-Loire', 'SAO', 'SL');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Sarthe', 'SAR', 'SR');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Savoie', 'SAV', 'SV');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Paris', 'PAR', 'PA');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Seine-Maritime', 'SMA', 'SA');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Seine-et-Marne', 'SEM', 'SE');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Yvelines', 'YVE', 'YV');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Deux-Sèvres', 'DEU', 'DE');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Somme', 'SOM', 'SO');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Tarn', 'TAR', 'TA');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Tarn-et-Garonne', 'TAG', 'TG');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Var', 'VAR', 'VR');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Vaucluse', 'VAU', 'VU');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Vendée', 'VEN', 'VE');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Vienne', 'VIE', 'VI');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Vosges', 'VOS', 'VO');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Yonne', 'YON', 'YO');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Territoire de Belfort', 'TER', 'TE');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Essonne', 'ESS', 'ES');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Hauts-de-Seine', 'HSE', 'HI');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Seine-Saint-Denis', 'SEI', 'SS');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Val-de-Marne', 'VAM', 'VM');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Val-d\'Oise', 'VAL', 'VS');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Guadeloupe', 'GUA', 'GL');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Martinique', 'MAT', 'MA');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'Guyane', 'GUY', 'GU');
INSERT INTO virtuemart_states (virtuemart_vendor_id, virtuemart_worldzone_id, virtuemart_country_id, state_name, state_3_code, state_2_code) VALUES('1', '0', '73', 'La Réunion', 'LAR', 'LN');