modify oncreate to createthe locationentry database table using the constants we definedin the contract. the good news is thatthis is a similar but simpler statement than whatwe have in weatherentry. you'll be creating and executinga string that stores an sqli command.
Android quiz, you want to make sure to usethe correct data types for each column. also, make sure that youhave the right constraints. in general, forall the model of the weather table. with the exception of the id,all columns must be defined as not null.
the location query shouldadditionally be defined as unique or coordinates are real, orfloating point values. you should consider adding loggingstatements to print the sqli statement, and verify that itlooks as you intended. pay close attention to spaces,parenthesis, and commas. once you have finished writingthe sql to create the table,
continue to run test create testcreatedbfrom within the test db, and let it guide you as to how tofix your creation statement. once you have finished coding,i recommend looking at our solution,
just in case our test missed something.
