fields(array( 'country_id' => 178, 'country_name' => 'Congo', 'country_iso_code_2' => 'CG', 'country_iso_code_3' => 'COG', 'version' => 1, )) ->execute(); // Make the entries in the zones table. $zones = array( array(178, '11', 'Bouenza'), array(178, 'BZV', 'Brazzaville'), array(178, '8', 'Cuvette'), array(178, '15', 'Cuvette-Ouest'), array(178, '5', 'Kouilou'), array(178, '2', 'Lekoumou'), array(178, '7', 'Likouala'), array(178, '9', 'Niari'), array(178, '14', 'Plateaux'), array(178, '12', 'Pool'), array(178, '13', 'Sangha'), ); $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( 178, "!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" ); }