duplicate code written for creating and dropping location table was removed.