Lines Matching defs:execSQL
361 execSQL("CREATE TEMPORARY TABLE state_backup(_sync_account TEXT, "
363 db.execSQL("INSERT INTO state_backup SELECT _sync_account, _sync_account_type, data"
367 db.execSQL("DROP TABLE " + Tables.SYNC_STATE + ";");
369 db.execSQL("INSERT INTO " + Tables.SYNC_STATE + "("
374 db.execSQL("DROP TABLE state_backup;");
399 db.execSQL("CREATE TABLE " + Tables.EVENTS_RAW_TIMES + " (" +
409 db.execSQL("CREATE TABLE " + Tables.INSTANCES + " (" +
424 db.execSQL("CREATE INDEX instancesStartDayIndex ON " + Tables.INSTANCES + " (" +
432 db.execSQL("CREATE TABLE " + Tables.ATTENDEES + " (" +
444 db.execSQL("CREATE INDEX attendeesEventIdIndex ON " + Tables.ATTENDEES + " (" +
448 db.execSQL("CREATE TABLE " + Tables.REMINDERS + " (" +
456 db.execSQL("CREATE INDEX remindersEventIdIndex ON " + Tables.REMINDERS + " (" +
461 db.execSQL("CREATE TABLE " + Tables.CALENDAR_ALERTS + " (" +
481 db.execSQL("CREATE INDEX calendarAlertsEventIdIndex ON " + Tables.CALENDAR_ALERTS + " (" +
485 db.execSQL("CREATE TABLE " + Tables.EXTENDED_PROPERTIES + " (" +
492 db.execSQL("CREATE INDEX extendedPropertiesEventIdIndex ON " + Tables.EXTENDED_PROPERTIES
500 db.execSQL("CREATE TRIGGER events_cleanup_delete DELETE ON " + Tables.EVENTS + " " +
511 db.execSQL(CREATE_SYNC_ID_UPDATE_TRIGGER);
522 db.execSQL("CREATE TABLE " + Tables.EVENTS + " (" +
586 db.execSQL("CREATE INDEX eventsCalendarIdIndex ON " + Tables.EVENTS + " ("
591 db.execSQL("CREATE TABLE Events ("
649 db.execSQL("CREATE INDEX eventsCalendarIdIndex ON Events (calendar_id);");
654 db.execSQL("CREATE TABLE Events (" +
706 db.execSQL("CREATE INDEX eventsCalendarIdIndex ON Events (calendar_id);");
710 db.execSQL("CREATE TABLE " + Tables.CALENDARS + " (" +
741 db.execSQL("CREATE TRIGGER calendar_cleanup DELETE ON " + Tables.CALENDARS + " " +
749 db.execSQL("CREATE TABLE " + Tables.COLORS + " (" +
761 db.execSQL(CREATE_EVENT_COLOR_UPDATE_TRIGGER);
762 db.execSQL(CREATE_CALENDAR_COLOR_UPDATE_TRIGGER);
766 db.execSQL("CREATE TABLE " + Tables.CALENDARS + " (" +
805 db.execSQL("CREATE TRIGGER calendar_cleanup DELETE ON " + Tables.CALENDARS + " " +
812 db.execSQL("CREATE TABLE Calendars (" +
846 db.execSQL("CREATE TRIGGER calendar_cleanup DELETE ON Calendars " +
853 db.execSQL("CREATE TABLE " + Tables.CALENDARS + " (" +
884 db.execSQL("CREATE TRIGGER calendar_cleanup DELETE ON " + Tables.CALENDARS + " " +
891 db.execSQL("CREATE TABLE Calendars (" +
924 db.execSQL("CREATE TABLE Calendars (" +
956 db.execSQL("CREATE TABLE Calendars (" +
988 db.execSQL("CREATE TRIGGER calendar_cleanup DELETE ON Calendars " +
995 db.execSQL("CREATE TABLE " + Tables.CALENDAR_META_DATA + " (" +
1004 db.execSQL("CREATE TABLE CalendarMetaData (" +
1015 db.execSQL("DROP TABLE IF EXISTS " + Tables.CALENDAR_CACHE + ";");
1018 db.execSQL("CREATE TABLE IF NOT EXISTS " + Tables.CALENDAR_CACHE + " (" +
1033 db.execSQL("INSERT OR REPLACE INTO " + Tables.CALENDAR_CACHE +
1045 db.execSQL("INSERT INTO " + Tables.CALENDAR_CACHE +
1057 db.execSQL("INSERT INTO " + Tables.CALENDAR_CACHE +
1067 db.execSQL("INSERT INTO " + Tables.CALENDAR_CACHE +
1082 db.execSQL("INSERT OR REPLACE INTO CalendarCache" +
1094 db.execSQL("INSERT INTO CalendarCache" +
1104 db.execSQL("INSERT INTO CalendarCache" +
1112 db.execSQL("INSERT INTO CalendarCache" +
1465 db.execSQL("DROP TABLE CalendarMetaData;");
1469 db.execSQL("DELETE FROM Instances;");
1496 db.execSQL("ALTER TABLE Events ADD COLUMN mutators TEXT;");
1497 db.execSQL("ALTER TABLE Calendars ADD COLUMN mutators TEXT;");
1510 db.execSQL("ALTER TABLE Events ADD COLUMN isOrganizer INTEGER;");
1511 db.execSQL("ALTER TABLE Calendars ADD COLUMN isPrimary INTEGER;");
1519 db.execSQL("ALTER TABLE Events ADD COLUMN uid2445 TEXT;");
1531 db.execSQL("ALTER TABLE Events ADD COLUMN customAppPackage TEXT;");
1532 db.execSQL("ALTER TABLE Events ADD COLUMN customAppUri TEXT;");
1540 db.execSQL("ALTER TABLE Attendees ADD COLUMN attendeeIdentity TEXT;");
1541 db.execSQL("ALTER TABLE Attendees ADD COLUMN attendeeIdNamespace TEXT;");
1549 db.execSQL("UPDATE events SET original_id=(SELECT _id FROM events inner_events WHERE " +
1557 db.execSQL("DROP TRIGGER IF EXISTS calendar_color_update");
1559 db.execSQL("CREATE TRIGGER "
1570 db.execSQL("DROP TRIGGER IF EXISTS event_color_update");
1572 db.execSQL("CREATE TRIGGER "
1598 db.execSQL("ALTER TABLE Calendars ADD COLUMN allowedAvailability TEXT DEFAULT '0,1';");
1599 db.execSQL("ALTER TABLE Calendars ADD COLUMN allowedAttendeeTypes TEXT DEFAULT '0,1,2';");
1600 db.execSQL("ALTER TABLE Calendars ADD COLUMN calendar_color_index TEXT;");
1601 db.execSQL("ALTER TABLE Events ADD COLUMN eventColor_index TEXT;");
1605 db.execSQL("UPDATE Calendars SET allowedAvailability='0,1,2' WHERE _id IN "
1618 db.execSQL("ALTER TABLE Events RENAME TO Events_Backup;");
1619 db.execSQL("DROP TRIGGER IF EXISTS events_cleanup_delete");
1620 db.execSQL("DROP TRIGGER IF EXISTS original_sync_update");
1621 db.execSQL("DROP INDEX IF EXISTS eventsCalendarIdIndex");
1673 db.execSQL("INSERT INTO Events (" + FIELD_LIST + ") SELECT " + FIELD_LIST +
1676 db.execSQL("DROP TABLE Events_Backup;");
1679 db.execSQL("CREATE TRIGGER events_cleanup_delete DELETE ON " + Tables.EVENTS + " " +
1684 db.execSQL(CREATE_SYNC_ID_UPDATE_TRIGGER);
1698 db.execSQL("DROP TRIGGER IF EXISTS original_sync_update");
1699 db.execSQL("UPDATE Events SET "
1706 db.execSQL(CREATE_SYNC_ID_UPDATE_TRIGGER);
1708 db.execSQL("UPDATE Calendars SET canPartiallyUpdate = 1 WHERE account_type = 'com.google'");
1710 db.execSQL("DELETE FROM _sync_state WHERE account_type = 'com.google'");
1734 db.execSQL("ALTER TABLE Calendars RENAME TO Calendars_Backup;");
1735 db.execSQL("DROP TRIGGER IF EXISTS calendar_cleanup");
1739 db.execSQL("INSERT INTO Calendars (" +
1800 db.execSQL("DROP TABLE Calendars_Backup;");
1802 db.execSQL("ALTER TABLE Events RENAME TO Events_Backup;");
1803 db.execSQL("DROP TRIGGER IF EXISTS events_cleanup_delete");
1804 db.execSQL("DROP INDEX IF EXISTS eventsCalendarIdIndex");
1812 db.execSQL("INSERT INTO Events (" +
1905 db.execSQL("DROP TABLE Events_Backup;");
1908 db.execSQL("CREATE TRIGGER events_cleanup_delete DELETE ON " + Tables.EVENTS + " " +
1915 db.execSQL(CREATE_SYNC_ID_UPDATE_TRIGGER);
1925 db.execSQL("ALTER TABLE Calendars ADD COLUMN canPartiallyUpdate INTEGER DEFAULT 0;");
1926 db.execSQL("ALTER TABLE Events ADD COLUMN sync_data7 TEXT;");
1927 db.execSQL("ALTER TABLE Events ADD COLUMN lastSynced INTEGER DEFAULT 0;");
1937 db.execSQL("ALTER TABLE Calendars RENAME TO Calendars_Backup;");
1938 db.execSQL("DROP TRIGGER IF EXISTS calendar_cleanup");
1942 db.execSQL("INSERT INTO Calendars (" +
2002 db.execSQL("DROP TABLE Calendars_Backup;");
2010 db.execSQL("UPDATE Events SET sync_data1=eventEndTimezone WHERE calendar_id IN "
2013 db.execSQL("UPDATE Events SET eventEndTimezone=NULL WHERE calendar_id IN "
2024 db.execSQL("DROP TRIGGER IF EXISTS " + SYNC_ID_UPDATE_TRIGGER_NAME + ";");
2026 db.execSQL("ALTER TABLE Events ADD COLUMN original_id INTEGER;");
2029 db.execSQL("UPDATE Events set original_id=" +
2035 db.execSQL(CREATE_SYNC_ID_UPDATE_TRIGGER);
2059 db.execSQL("ALTER TABLE Calendars RENAME TO Calendars_Backup;");
2060 db.execSQL("DROP TRIGGER IF EXISTS calendar_cleanup;");
2064 db.execSQL("INSERT INTO Calendars (" +
2125 db.execSQL("UPDATE Calendars SET allowedReminders = '0,1,2' " +
2129 db.execSQL("DROP TABLE Calendars_Backup;");
2131 db.execSQL("ALTER TABLE Events RENAME TO Events_Backup;");
2132 db.execSQL("DROP TRIGGER IF EXISTS events_insert");
2133 db.execSQL("DROP TRIGGER IF EXISTS events_cleanup_delete");
2134 db.execSQL("DROP INDEX IF EXISTS eventSyncAccountAndIdIndex");
2135 db.execSQL("DROP INDEX IF EXISTS eventsCalendarIdIndex");
2139 db.execSQL("INSERT INTO Events (" +
2226 db.execSQL("DROP TABLE Events_Backup;");
2229 db.execSQL("CREATE TRIGGER events_cleanup_delete DELETE ON " + Tables.EVENTS + " " +
2248 db.execSQL("ALTER TABLE Calendars RENAME TO Calendars_Backup;");
2249 db.execSQL("DROP TRIGGER IF EXISTS calendar_cleanup");
2253 db.execSQL("INSERT INTO Calendars (" +
2311 db.execSQL("UPDATE Calendars SET canModifyTimeZone=0, maxReminders=1 " +
2315 db.execSQL("DROP TABLE Calendars_Backup;");
2331 db.execSQL("DELETE FROM CalendarCache;");
2347 db.execSQL("ALTER TABLE Calendars RENAME TO Calendars_Backup;");
2349 db.execSQL("DROP TRIGGER IF EXISTS calendar_cleanup");
2354 db.execSQL("INSERT INTO Calendars (" +
2410 db.execSQL("DROP TABLE Calendars_Backup;");
2414 db.execSQL("ALTER TABLE Calendars ADD COLUMN sync4 TEXT;");
2420 db.execSQL("ALTER TABLE Calendars RENAME TO Calendars_Backup;");
2422 db.execSQL("DROP TRIGGER IF EXISTS calendar_cleanup");
2426 db.execSQL("INSERT INTO Calendars (" +
2500 db.execSQL(updateSql, bindArgs);
2509 db.execSQL("DROP TABLE Calendars_Backup;");
2598 db.execSQL("UPDATE Events SET " +
2661 db.execSQL("UPDATE Events SET " +
2692 db.execSQL("ALTER TABLE Calendars" +
2698 db.execSQL("ALTER TABLE Events" +
2704 db.execSQL("ALTER TABLE Events" +
2706 db.execSQL("ALTER TABLE Events" +
2708 db.execSQL("ALTER TABLE Events" +
2713 db.execSQL("UPDATE Events SET " +
2770 db.execSQL("UPDATE Events SET " +
2784 db.execSQL("DROP TABLE IF EXISTS CalendarCache;");
2787 db.execSQL("CREATE TABLE IF NOT EXISTS CalendarCache (" +
2793 db.execSQL("INSERT INTO CalendarCache (" +
2804 db.execSQL("DROP TRIGGER IF EXISTS calendar_cleanup");
2805 db.execSQL("CREATE TRIGGER calendar_cleanup DELETE ON Calendars " +
2810 db.execSQL("ALTER TABLE Events" +
2812 db.execSQL("DROP TRIGGER IF EXISTS events_insert");
2814 db.execSQL("CREATE TRIGGER events_insert AFTER INSERT ON Events " +
2825 db.execSQL("DROP TABLE IF EXISTS DeletedEvents;");
2826 db.execSQL("DROP TRIGGER IF EXISTS events_cleanup_delete");
2828 db.execSQL("CREATE TRIGGER events_cleanup_delete DELETE ON Events " +
2843 db.execSQL("DROP TRIGGER IF EXISTS attendees_update");
2844 db.execSQL("DROP TRIGGER IF EXISTS attendees_insert");
2845 db.execSQL("DROP TRIGGER IF EXISTS attendees_delete");
2846 db.execSQL("DROP TRIGGER IF EXISTS reminders_update");
2847 db.execSQL("DROP TRIGGER IF EXISTS reminders_insert");
2848 db.execSQL("DROP TRIGGER IF EXISTS reminders_delete");
2849 db.execSQL("DROP TRIGGER IF EXISTS extended_properties_update");
2850 db.execSQL("DROP TRIGGER IF EXISTS extended_properties_insert");
2851 db.execSQL("DROP TRIGGER IF EXISTS extended_properties_delete");
2855 db.execSQL("DROP TABLE IF EXISTS BusyBits;");
2856 db.execSQL("CREATE TEMPORARY TABLE CalendarMetaData_Backup(" +
2862 db.execSQL("INSERT INTO CalendarMetaData_Backup " +
2869 db.execSQL("DROP TABLE CalendarMetaData;");
2871 db.execSQL("INSERT INTO CalendarMetaData " +
2878 db.execSQL("DROP TABLE CalendarMetaData_Backup;");
2882 db.execSQL("ALTER TABLE Events" +
2885 db.execSQL("ALTER TABLE Events" +
2888 db.execSQL("ALTER TABLE Events" +
2891 db.execSQL("ALTER TABLE Events" +
2894 db.execSQL("UPDATE Events SET organizer=" +
2905 db.execSQL("ALTER TABLE Calendars" +
2907 db.execSQL("ALTER TABLE Events" +
2914 db.execSQL("UPDATE Events"
2924 db.execSQL("UPDATE Calendars"
2942 db.execSQL(updateSql, new Object[] {owner, id});
2952 db.execSQL("DELETE FROM _sync_state;");
2974 db.execSQL("ALTER TABLE Calendars ADD COLUMN " +
2976 db.execSQL("ALTER TABLE Events ADD COLUMN " +
2978 db.execSQL("ALTER TABLE DeletedEvents ADD COLUMN _sync_account_type TEXT;");
2979 db.execSQL("UPDATE Calendars"
2982 db.execSQL("UPDATE Events"
2985 db.execSQL("UPDATE DeletedEvents"
2989 db.execSQL("DROP INDEX eventSyncAccountAndIdIndex");
2990 db.execSQL("CREATE INDEX eventSyncAccountAndIdIndex ON Events ("
2998 db.execSQL("CREATE INDEX eventSyncAccountAndIdIndex ON Events ("
3004 db.execSQL("ALTER TABLE CalendarAlerts ADD COLUMN " +
3006 db.execSQL("ALTER TABLE CalendarAlerts ADD COLUMN " +
3008 db.execSQL("ALTER TABLE CalendarAlerts ADD COLUMN " +
3019 db.execSQL("ALTER TABLE Events ADD COLUMN " +
3064 db.execSQL("UPDATE Events" +
3087 db.execSQL("ALTER TABLE DeletedEvents ADD COLUMN calendar_id INTEGER;");
3090 db.execSQL("DROP TRIGGER IF EXISTS calendar_cleanup");
3091 db.execSQL("CREATE TRIGGER calendar_cleanup DELETE ON Calendars " +
3097 db.execSQL("DROP TRIGGER IF EXISTS event_to_deleted");
3117 db.execSQL(sql);
3160 db.execSQL("DROP VIEW IF EXISTS " + Views.EVENTS + ";");
3258 db.execSQL("CREATE VIEW " + Views.EVENTS + " AS " + eventsSelect);
3380 db.execSQL("INSERT INTO " + CalendarDatabaseHelper.Tables.EVENTS
3412 db.execSQL("INSERT INTO " + Tables.REMINDERS
3419 db.execSQL("INSERT INTO "
3426 db.execSQL("INSERT INTO " + Tables.EXTENDED_PROPERTIES
3456 db.execSQL("DELETE FROM Events WHERE " + Events._ID + " = ?", new Object[]{dupId});
