moved drop and create statements to separate functions