updated newly created waredb create query with reformatting and added data values.