mashup.db places - change primary key/accuracy data type

Question

When I create places table in mashup.db, I created country_code as primary key and not be null until I realize how stupid this is. But how could I change it using sqlite statement? Or should I just create another table? Besides, what's the data type for column accuracy? Numeric or Integer? Or does it matter?

Thanks

Answer 1

SQLite does not support the alter table drop constraint commands. You will need to create a new table without the primary key.

The column accuracy is an Integer.

https://developers.google.com/maps/documentation/javascript/3.exp/reference