Lines Matching refs:_ID
168 "old." + CalendarContract.Events._ID + ";" +
171 "old." + CalendarContract.Events._ID + ";" +
174 "old." + CalendarContract.Events._ID + ";" +
177 "old." + CalendarContract.Events._ID + ";" +
180 "old." + CalendarContract.Events._ID + ";" +
183 "old." + CalendarContract.Events._ID + ";";
190 " WHERE " + Events.ORIGINAL_ID + "=old." + Events._ID + ";";
202 "old." + CalendarContract.Events._ID + ";";
210 + " WHERE " + Calendars._ID + "=" + "old." + Calendars._ID
221 + Tables.CALENDARS + " WHERE " + Calendars._ID + "=new." + Events.CALENDAR_ID
223 + Tables.CALENDARS + " WHERE " + Calendars._ID + "=new." + Events.CALENDAR_ID
226 + " WHERE " + Events._ID + "=" + "old." + Events._ID + ";";
237 Attendees.EVENT_ID + "=" + Tables.EVENTS + "." + Events._ID +
238 " WHERE " + Tables.EVENTS + "." + Events._ID + " IS NULL)";
243 Reminders.EVENT_ID + "=" + Tables.EVENTS + "." + Events._ID +
244 " WHERE " + Tables.EVENTS + "." + Events._ID + " IS NULL)";
400 CalendarContract.EventsRawTimes._ID + " INTEGER PRIMARY KEY," +
410 CalendarContract.Instances._ID + " INTEGER PRIMARY KEY," +
433 CalendarContract.Attendees._ID + " INTEGER PRIMARY KEY," +
449 CalendarContract.Reminders._ID + " INTEGER PRIMARY KEY," +
462 CalendarContract.CalendarAlerts._ID + " INTEGER PRIMARY KEY," +
486 CalendarContract.ExtendedProperties._ID + " INTEGER PRIMARY KEY," +
523 CalendarContract.Events._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
592 + "_id INTEGER PRIMARY KEY AUTOINCREMENT,"
655 "_id INTEGER PRIMARY KEY," +
711 "_id INTEGER PRIMARY KEY," +
750 CalendarContract.Colors._ID + " INTEGER PRIMARY KEY," +
767 Calendars._ID + " INTEGER PRIMARY KEY," +
813 "_id INTEGER PRIMARY KEY," +
848 "DELETE FROM Events WHERE calendar_id=old._id;" +
854 "_id INTEGER PRIMARY KEY," +
892 "_id INTEGER PRIMARY KEY," +
925 "_id INTEGER PRIMARY KEY," +
957 "_id INTEGER PRIMARY KEY," +
990 "DELETE FROM Events WHERE calendar_id=old._id;" +
996 CalendarContract.CalendarMetaData._ID + " INTEGER PRIMARY KEY," +
1005 "_id INTEGER PRIMARY KEY," +
1083 " (_id, " +
1095 " (_id, key, value) VALUES (" +
1105 " (_id, key, value) VALUES (" +
1113 " (_id, key, value) VALUES (" +
1130 Attendees._ID + ", " + Attendees.EVENT_ID + " FROM " + Tables.ATTENDEES +
1145 Attendees._ID + ", " + Reminders.EVENT_ID + " FROM " + Tables.REMINDERS +
1298 // v102 is v101 with Event._id changed to autoincrement.
1324 // v206 exists only in HC (change Event._id to autoincrement). Otherwise
1549 db.execSQL("UPDATE events SET original_id=(SELECT _id FROM events inner_events WHERE " +
1553 "ex_events._id=events.original_id) <> calendar_id ");
1568 + " WHERE " + Calendars._ID + "=" + "old." + Calendars._ID
1578 + Tables.CALENDARS + " WHERE " + Calendars._ID + "=new." + Events.CALENDAR_ID
1580 + " FROM " + Tables.CALENDARS + " WHERE " + Calendars._ID + "=new."
1584 + " WHERE " + Events._ID + "=" + "old." + Events._ID + ";" + " END");
1605 db.execSQL("UPDATE Calendars SET allowedAvailability='0,1,2' WHERE _id IN "
1606 + "(SELECT _id FROM Calendars WHERE account_type='com.android.exchange');");
1616 * - Changed _id field to AUTOINCREMENT
1625 "_id, " +
1702 + "WHERE _id IN (SELECT Events._id FROM Events "
1703 + "JOIN Calendars ON Events.calendar_id = Calendars._id "
1740 "_id, " +
1769 "_id, " +
1806 // addition of "autoincrement" to _ID doesn't affect the upgrade path. (Note that
1813 "_id, " +
1858 "_id, " +
1943 "_id, " +
1971 "_id, " +
2011 + "(SELECT _id FROM Calendars WHERE account_type='com.android.exchange');");
2014 + "(SELECT _id FROM Calendars WHERE account_type='com.android.exchange');");
2030 "(SELECT Events2._id FROM Events AS Events2 " +
2065 "_id, " +
2094 "_id, " +
2140 "_id, " +
2182 "_id, " +
2254 "_id, " +
2281 "_id, " +
2355 "_id, " +
2381 "_id, " +
2427 "_id, " +
2449 "_id, " +
2475 String selectSql = "SELECT _id, url" +
2483 "WHERE _id=?;";
2520 final String sql = "SELECT _id, " +
2606 "WHERE _id=?",
2669 "WHERE _id=?",
2722 Cursor cursor = db.rawQuery("SELECT Events._id," +
2728 "WHERE Events.calendar_id=Calendars._id" +
2774 "WHERE _id=?",
2788 "_id INTEGER PRIMARY KEY," +
2808 " WHERE calendar_id=old._id;") +
2819 " WHERE Calendars._id=new.calendar_id)," +
2822 " WHERE Calendars._id=new.calendar_id) " +
2823 "WHERE Events._id=new._id;" +
2831 " WHERE event_id=old._id;" +
2833 " WHERE event_id=old._id;" +
2835 " WHERE event_id=old._id;" +
2837 " WHERE event_id=old._id;" +
2839 " WHERE event_id=old._id;" +
2841 " WHERE event_id=old._id;") +
2857 "_id," +
2864 "_id," +
2873 "_id," +
2899 "Events._id" +
2929 Cursor cursor = db.rawQuery("SELECT _id, " +
2937 " WHERE _id=?";
3038 Cursor cursor = db.rawQuery("SELECT _id," +
3066 " WHERE _id="+id);
3094 "old._id;" +
3095 "DELETE FROM DeletedEvents WHERE calendar_id = old._id;" +
3162 + Tables.EVENTS + "." + CalendarContract.Events._ID
3163 + " AS " + CalendarContract.Events._ID + ","
3255 + "=" + Tables.CALENDARS + "." + Calendars._ID
3367 * @param id The _id of the event to duplicate.
3374 + " WHERE " + Events._ID + " = ?", new String[] {
3394 + " WHERE " + Events._ID + " = ? AND " + Events.DIRTY + " = ?",
3446 final Cursor cursor = db.rawQuery("SELECT " + Events._ID + " FROM " + Tables.EVENTS
3450 + " WHERE " + Events._ID + " = ?) "
3465 db.execSQL("DELETE FROM Events WHERE " + Events._ID + " = ?", new Object[]{dupId});
