update sql script to create transport record details