Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1)
- CREATE TABLE restaurants {
- Name TEXT PRIMARY KEY,
- Food_Type TEXT,
- Distance INTEGER,
- DATE TEXT AS ISO8601 strings ("YYYY-MM-DD HH:MM:SS.SSS"),
- Rating INTEGER,
- };
- 2)
- public class PostsDatabaseHelper extends SQLiteOpenHelper {
- private static final String DATABASE_NAME = "myRestaurantsList";
- private static final INT DATABASE_VERSION = 1;
- public PostsDatabaseHelper(Context context) {
- super(context, DATABASE_NAME, NULL, DATABASE_VERSION);
- }
- public void onCreate(SQLiteDatabase db) {
- String My_Restaurant_List_TABLE = "CREATE TABLE " + "myRestaurantsList" +
- "("
- + KEY_NAME + " TEXT PRIMARY KEY," // Define a PRIMARY KEY
- + KEY_FOOD_TYPE + " TEXT, "
- + KEY_DISTANCE + "INTEGER,"
- + KEY_DATE + "TEXT,"
- + KEY_RATING + "INTEGER,"
- + ")";
- db.execSQL(CREATE_POSTS_TABLE)
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement