fields(array( 'country_id' => 520, 'country_name' => 'Nauru', 'country_iso_code_2' => 'NR', 'country_iso_code_3' => 'NRU', 'version' => 1, )) ->execute(); // Make the entries in the zones table. $zones = array( array(520, 'NR-01', 'Aiwo'), array(520, 'NR-02', 'Anabar'), array(520, 'NR-03', 'Anetan'), array(520, 'NR-04', 'Anibare'), array(520, 'NR-05', 'Baiti'), array(520, 'NR-06', 'Boe'), array(520, 'NR-07', 'Buada'), array(520, 'NR-08', 'Denigomodu'), array(520, 'NR-09', 'Ewa'), array(520, 'NR-10', 'Ijuw'), array(520, 'NR-11', 'Meneng'), array(520, 'NR-12', 'Nibok'), array(520, 'NR-13', 'Uaboe'), array(520, 'NR-14', 'Yaren'), ); $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( 520, "!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" ); }