fields(array( 'country_id' => 418, 'country_name' => "Lao People's Democratic Republic", 'country_iso_code_2' => 'LA', 'country_iso_code_3' => 'LAO', 'version' => 1, )) ->execute(); // Make the entries in the zones table. $zones = array( array(418, 'LA-VT', 'Vientiane'), array(418, 'LA-AT', 'Attapu [Attopeu]'), array(418, 'LA-BK', 'Bokè'), array(418, 'LA-BL', 'Bolikhamxai [Borikhane]'), array(418, 'LA-CH', 'Champasak [Champassak]'), array(418, 'LA-HO', 'Houaphan'), array(418, 'LA-KH', 'Khammouan'), array(418, 'LA-LM', 'Louang Namtha'), array(418, 'LA-LP', 'Louangphabang [Louang Prabang]'), array(418, 'LA-OU', 'Oudômxai [Oudomsai]'), array(418, 'LA-PH', 'Phôngsali [Phong Saly]'), array(418, 'LA-SL', 'Salavan [Saravane]'), array(418, 'LA-SV', 'Savannakhé'), array(418, 'LA-VI', 'Vientiane'), array(418, 'LA-XA', 'Xaignabouli'), array(418, 'LA-XE', 'Xekong'), array(418, 'LA-XI', 'Xiangkhoang [Xieng Khouang]'), array(418, 'LA-XN', 'Xaisômbou'), ); $query = db_insert('uc_zones')->fields(array('zone_country_id', 'zone_code', 'zone_name')); foreach ($zones as $zone) { $query->values($zone); } $query->execute(); // Set address format uc_set_address_format( 418, "!company\r\n" . "!first_name !last_name\r\n" . "!street1\r\n" . "!street2\r\n" . "!city, !zone_name !postal_code\r\n" . "!country_name_if" ); }