<?xml version="1.0" encoding="utf-8"?> <resources> <string name="app_name">180. SQLite Database</string> <string name="sql_onCreate">" CREATE TABLE locations(_id INTEGER PRIMARY KEY AUTOINCREMENT, longitude DOUBLE, latitude DOUBLE, created DATETIME); INSERT INTO locations (_id,latitude, longitude, created) VALUES (NULL, '42.2905', '-87.9550', datetime('now')); INSERT INTO locations (_id, latitude, longitude, created) VALUES (NULL, '41.889923', '-87.629077', datetime('now')); " </string> <string name="sql_onUpdate">" UPDATE ... "</string> </resources> |
