added sql statement to create gnomes