BXd0zqw5

1String SQL_CREATE_TABLE = "CREATE TABLE IF NOT EXISTS " + TABLE_A + " ( " + 
2        COLUMN_ID + " INTEGER PRIMARY KEY NOT NULL" + "," + 
3        COLUMN_GROUPNO      + " INTEGER NOT NULL DEFAULT(0)" + "," + 
4        COLUMN_TIMESTAMP    + " DATETIME UNIQUE NOT NULL" + "," + 
5        COLUMN_TAG          + " TEXT" + "," + 
6        COLUMN_VALUE        + " REAL NOT NULL" + "," + 
7        COLUMN_DEVICEID     + " TEXT NOT NULL" + "," +
8        COLUMN_NEW          + " NUMERIC NOT NULL DEFAULT(1)" + " )";
9	
10String SQL_CREATE_INDEX_TIMESTAMP = "CREATE INDEX IF NOT EXISTS " + TABLE_A +
11        "_" + COLUMN_TIMESTAMP + " ON " + TABLE_A + " (" +
12        COLUMN_TIMESTAMP + ") ";
13	
14@Override
15public Cursor query(Uri uri, String[] projection, String selection,
16        String[] selectionArgs, String sortOrder) {
17    final SQLiteQueryBuilder queryBuilder = new SQLiteQueryBuilder();
18    final SQLiteDatabase db = dbHelper.getReadableDatabase();
19
20    String tableName = getTableName(uri);
21
22    queryBuilder.setTables(tableName);
23
24    Cursor cursor = queryBuilder.query(db, projection, selection, selectionArgs, null, null, sortOrder);
25    cursor.setNotificationUri(getContext().getContentResolver(), uri);
26
27    return cursor;
28}