Lines Matching defs:Tables
123 public interface Tables {
148 "DELETE FROM " + Tables.INSTANCES +
151 "DELETE FROM " + Tables.EVENTS_RAW_TIMES +
154 "DELETE FROM " + Tables.ATTENDEES +
157 "DELETE FROM " + Tables.REMINDERS +
160 "DELETE FROM " + Tables.CALENDAR_ALERTS +
163 "DELETE FROM " + Tables.EXTENDED_PROPERTIES +
170 "UPDATE " + Tables.EVENTS +
177 " ON " + Tables.EVENTS +
182 private static final String CALENDAR_CLEANUP_TRIGGER_SQL = "DELETE FROM " + Tables.EVENTS +
186 private static final String CALENDAR_UPDATE_COLOR_TRIGGER_SQL = "UPDATE " + Tables.CALENDARS
187 + " SET calendar_color=(SELECT " + Colors.COLOR + " FROM " + Tables.COLORS + " WHERE "
196 + " ON " + Tables.CALENDARS + " WHEN new." + Calendars.CALENDAR_COLOR_KEY
199 private static final String EVENT_UPDATE_COLOR_TRIGGER_SQL = "UPDATE " + Tables.EVENTS
200 + " SET eventColor=(SELECT " + Colors.COLOR + " FROM " + Tables.COLORS + " WHERE "
202 + Tables.CALENDARS + " WHERE " + Calendars._ID + "=new." + Events.CALENDAR_ID
204 + Tables.CALENDARS + " WHERE " + Calendars._ID + "=new." + Events.CALENDAR_ID
210 + Tables.EVENTS + " WHEN new." + Events.EVENT_COLOR_KEY + " NOT NULL BEGIN "
216 Tables.ATTENDEES + " LEFT OUTER JOIN " + Tables.EVENTS + " ON " +
217 Attendees.EVENT_ID + "=" + Tables.EVENTS + "." + Events._ID +
218 " WHERE " + Tables.EVENTS + "." + Events._ID + " IS NULL)";
222 Tables.REMINDERS + " LEFT OUTER JOIN " + Tables.EVENTS + " ON " +
223 Reminders.EVENT_ID + "=" + Tables.EVENTS + "." + Events._ID +
224 " WHERE " + Tables.EVENTS + "." + Events._ID + " IS NULL)";
309 mCalendarsInserter = new DatabaseUtils.InsertHelper(db, Tables.CALENDARS);
310 mColorsInserter = new DatabaseUtils.InsertHelper(db, Tables.COLORS);
311 mEventsInserter = new DatabaseUtils.InsertHelper(db, Tables.EVENTS);
312 mEventsRawTimesInserter = new DatabaseUtils.InsertHelper(db, Tables.EVENTS_RAW_TIMES);
313 mInstancesInserter = new DatabaseUtils.InsertHelper(db, Tables.INSTANCES);
314 mAttendeesInserter = new DatabaseUtils.InsertHelper(db, Tables.ATTENDEES);
315 mRemindersInserter = new DatabaseUtils.InsertHelper(db, Tables.REMINDERS);
316 mCalendarAlertsInserter = new DatabaseUtils.InsertHelper(db, Tables.CALENDAR_ALERTS);
318 new DatabaseUtils.InsertHelper(db, Tables.EXTENDED_PROPERTIES);
337 + " FROM " + Tables.SYNC_STATE_META,
345 + Tables.SYNC_STATE
347 db.execSQL("DROP TABLE " + Tables.SYNC_STATE + ";");
349 db.execSQL("INSERT INTO " + Tables.SYNC_STATE + "("
379 db.execSQL("CREATE TABLE " + Tables.EVENTS_RAW_TIMES + " (" +
389 db.execSQL("CREATE TABLE " + Tables.INSTANCES + " (" +
404 db.execSQL("CREATE INDEX instancesStartDayIndex ON " + Tables.INSTANCES + " (" +
412 db.execSQL("CREATE TABLE " + Tables.ATTENDEES + " (" +
422 db.execSQL("CREATE INDEX attendeesEventIdIndex ON " + Tables.ATTENDEES + " (" +
426 db.execSQL("CREATE TABLE " + Tables.REMINDERS + " (" +
434 db.execSQL("CREATE INDEX remindersEventIdIndex ON " + Tables.REMINDERS + " (" +
439 db.execSQL("CREATE TABLE " + Tables.CALENDAR_ALERTS + " (" +
459 db.execSQL("CREATE INDEX calendarAlertsEventIdIndex ON " + Tables.CALENDAR_ALERTS + " (" +
463 db.execSQL("CREATE TABLE " + Tables.EXTENDED_PROPERTIES + " (" +
470 db.execSQL("CREATE INDEX extendedPropertiesEventIdIndex ON " + Tables.EXTENDED_PROPERTIES
478 db.execSQL("CREATE TRIGGER events_cleanup_delete DELETE ON " + Tables.EVENTS + " " +
500 db.execSQL("CREATE TABLE " + Tables.EVENTS + " (" +
559 db.execSQL("CREATE INDEX eventsCalendarIdIndex ON " + Tables.EVENTS + " ("
683 db.execSQL("CREATE TABLE " + Tables.CALENDARS + " (" +
714 db.execSQL("CREATE TRIGGER calendar_cleanup DELETE ON " + Tables.CALENDARS + " " +
722 db.execSQL("CREATE TABLE " + Tables.COLORS + " (" +
739 db.execSQL("CREATE TABLE " + Tables.CALENDARS + " (" +
776 db.execSQL("CREATE TRIGGER calendar_cleanup DELETE ON " + Tables.CALENDARS + " " +
824 db.execSQL("CREATE TABLE " + Tables.CALENDARS + " (" +
855 db.execSQL("CREATE TRIGGER calendar_cleanup DELETE ON " + Tables.CALENDARS + " " +
966 db.execSQL("CREATE TABLE " + Tables.CALENDAR_META_DATA + " (" +
986 db.execSQL("DROP TABLE IF EXISTS " + Tables.CALENDAR_CACHE + ";");
989 db.execSQL("CREATE TABLE IF NOT EXISTS " + Tables.CALENDAR_CACHE + " (" +
1004 db.execSQL("INSERT OR REPLACE INTO " + Tables.CALENDAR_CACHE +
1016 db.execSQL("INSERT INTO " + Tables.CALENDAR_CACHE +
1028 db.execSQL("INSERT INTO " + Tables.CALENDAR_CACHE +
1038 db.execSQL("INSERT INTO " + Tables.CALENDAR_CACHE +
1101 Attendees._ID + ", " + Attendees.EVENT_ID + " FROM " + Tables.ATTENDEES +
1116 Attendees._ID + ", " + Reminders.EVENT_ID + " FROM " + Tables.REMINDERS +
1135 count = db.delete(Tables.ATTENDEES, WHERE_ATTENDEES_ORPHANS, null);
1140 count = db.delete(Tables.REMINDERS, WHERE_REMINDERS_ORPHANS, null);
1499 db.execSQL("CREATE TRIGGER events_cleanup_delete DELETE ON " + Tables.EVENTS + " " +
1730 db.execSQL("CREATE TRIGGER events_cleanup_delete DELETE ON " + Tables.EVENTS + " " +
2056 db.execSQL("CREATE TRIGGER events_cleanup_delete DELETE ON " + Tables.EVENTS + " " +
2926 db.execSQL("DROP TABLE IF EXISTS " + Tables.COLORS + ";");
2927 db.execSQL("DROP TABLE IF EXISTS " + Tables.CALENDARS + ";");
2928 db.execSQL("DROP TABLE IF EXISTS " + Tables.EVENTS + ";");
2929 db.execSQL("DROP TABLE IF EXISTS " + Tables.EVENTS_RAW_TIMES + ";");
2930 db.execSQL("DROP TABLE IF EXISTS " + Tables.INSTANCES + ";");
2931 db.execSQL("DROP TABLE IF EXISTS " + Tables.CALENDAR_META_DATA + ";");
2932 db.execSQL("DROP TABLE IF EXISTS " + Tables.CALENDAR_CACHE + ";");
2933 db.execSQL("DROP TABLE IF EXISTS " + Tables.ATTENDEES + ";");
2934 db.execSQL("DROP TABLE IF EXISTS " + Tables.REMINDERS + ";");
2935 db.execSQL("DROP TABLE IF EXISTS " + Tables.CALENDAR_ALERTS + ";");
2936 db.execSQL("DROP TABLE IF EXISTS " + Tables.EXTENDED_PROPERTIES + ";");
2974 + Tables.EVENTS + "." + CalendarContract.Events._ID
3018 + Tables.EVENTS + "." + CalendarContract.Events.DELETED
3020 + Tables.EVENTS + "." + CalendarContract.Events._SYNC_ID
3022 + Tables.EVENTS + "." + CalendarContract.Events.DIRTY
3025 + Tables.CALENDARS + "." + CalendarContract.Calendars.ACCOUNT_NAME
3027 + Tables.CALENDARS + "." + CalendarContract.Calendars.ACCOUNT_TYPE
3055 + " FROM " + Tables.EVENTS + " JOIN " + Tables.CALENDARS
3056 + " ON (" + Tables.EVENTS + "." + CalendarContract.Events.CALENDAR_ID
3057 + "=" + Tables.CALENDARS + "." + CalendarContract.Calendars._ID
3183 db.execSQL("INSERT INTO " + CalendarDatabaseHelper.Tables.EVENTS
3187 + " FROM " + Tables.EVENTS
3215 db.execSQL("INSERT INTO " + Tables.REMINDERS
3219 + " FROM " + Tables.REMINDERS
3223 + Tables.ATTENDEES
3226 + "SELECT ?," + LAST_SYNCED_ATTENDEE_COLUMNS + " FROM " + Tables.ATTENDEES
3229 db.execSQL("INSERT INTO " + Tables.EXTENDED_PROPERTIES
3233 + " FROM " + Tables.EXTENDED_PROPERTIES
3240 final Cursor cursor = db.rawQuery("SELECT " + Events._ID + " FROM " + Tables.EVENTS
3243 + " FROM " + Tables.EVENTS