fields(array( 'country_id' => 586, 'country_name' => 'Pakistan', 'country_iso_code_2' => 'PK', 'country_iso_code_3' => 'PAK', 'version' => 1, )) ->execute(); // Make the entries in the zones table. Use %d for the zone_id and the // VALUES = Parent Country ID, Zone Abbreviation, Zone Name $zones = array( array(586, 'PB', 'Punjab'), array(586, 'SN', 'Sindh'), array(586, 'BL', 'Balochistan'), array(586, 'NW', 'N.W.F.P'), ); $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( 586, "!company\r\n" . "!first_name !last_name\r\n" . "!street1\r\n" . "!street2\r\n" . "!city, !zone_code\r\n" . "!country_name_if" ); }