Home
last modified time | relevance | path

Searched refs:execSQL (Results 1 – 25 of 75) sorted by relevance

123

/packages/providers/CalendarProvider/src/com/android/providers/calendar/
DCalendarDatabaseHelper.java361 db.execSQL("CREATE TEMPORARY TABLE state_backup(_sync_account TEXT, " in upgradeSyncState()
363 db.execSQL("INSERT INTO state_backup SELECT _sync_account, _sync_account_type, data" in upgradeSyncState()
367 db.execSQL("DROP TABLE " + Tables.SYNC_STATE + ";"); in upgradeSyncState()
369 db.execSQL("INSERT INTO " + Tables.SYNC_STATE + "(" in upgradeSyncState()
374 db.execSQL("DROP TABLE state_backup;"); in upgradeSyncState()
399 db.execSQL("CREATE TABLE " + Tables.EVENTS_RAW_TIMES + " (" + in bootstrapDB()
409 db.execSQL("CREATE TABLE " + Tables.INSTANCES + " (" + in bootstrapDB()
424 db.execSQL("CREATE INDEX instancesStartDayIndex ON " + Tables.INSTANCES + " (" + in bootstrapDB()
432 db.execSQL("CREATE TABLE " + Tables.ATTENDEES + " (" + in bootstrapDB()
444 db.execSQL("CREATE INDEX attendeesEventIdIndex ON " + Tables.ATTENDEES + " (" + in bootstrapDB()
[all …]
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/
DMmsSmsDatabaseHelper.java366 db.execSQL( in updateThreads()
390 db.execSQL( in updateThreads()
418 db.execSQL( in updateThreads()
548 …db.execSQL("CREATE VIRTUAL TABLE words USING FTS3 (_id INTEGER PRIMARY KEY, index_text TEXT, sourc… in createWordsTables()
555 db.execSQL("CREATE TRIGGER sms_words_update AFTER UPDATE ON sms BEGIN UPDATE words " + in createWordsTables()
558 db.execSQL("CREATE TRIGGER sms_words_delete AFTER DELETE ON sms BEGIN DELETE FROM " + in createWordsTables()
574 db.execSQL("CREATE INDEX IF NOT EXISTS typeThreadIdIndex ON sms" + in createThreadIdIndex()
583 db.execSQL("CREATE INDEX IF NOT EXISTS threadIdDateIndex ON sms" + in createThreadIdDateIndex()
593 db.execSQL("CREATE TABLE " + MmsProvider.TABLE_PDU + " (" + in createMmsTables()
632 db.execSQL("CREATE TABLE " + MmsProvider.TABLE_ADDR + " (" + in createMmsTables()
[all …]
DTelephonyProvider.java414 db.execSQL(CREATE_SIMINFO_TABLE_STRING); in createSimInfoTable()
421 db.execSQL(getStringForCarrierTableCreation(tableName)); in createCarriersTable()
603 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
610 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
612 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
618 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
620 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
627 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
629 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
634 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
[all …]
DHbpcdLookupDatabaseHelper.java111 db.execSQL("CREATE TABLE " + HbpcdLookupProvider.TABLE_MCC_IDD + in onCreate()
116 db.execSQL("CREATE TABLE " + HbpcdLookupProvider.TABLE_MCC_LOOKUP_TABLE + in onCreate()
128 db.execSQL("CREATE TABLE " + HbpcdLookupProvider.TABLE_MCC_SID_CONFLICT + in onCreate()
133 db.execSQL("CREATE TABLE " + HbpcdLookupProvider.TABLE_MCC_SID_RANGE + in onCreate()
139 db.execSQL("CREATE TABLE " + HbpcdLookupProvider.TABLE_NANP_AREA_CODE + in onCreate()
143 db.execSQL("CREATE TABLE " + HbpcdLookupProvider.TABLE_ARBITRARY_MCC_SID_MATCH + in onCreate()
/packages/apps/Email/provider_src/com/android/email/provider/
DDBHelper.java215 db.execSQL("create trigger message_count_message_insert after insert on " + in createMessageCountTriggers()
223 db.execSQL("create trigger message_count_message_delete after delete on " + in createMessageCountTriggers()
231 db.execSQL("create trigger message_count_message_move after update of " + in createMessageCountTriggers()
249 db.execSQL("create table " + Credential.TABLE_NAME + s); in createCredentialsTable()
250 db.execSQL(TRIGGER_HOST_AUTH_DELETE); in createCredentialsTable()
254 db.execSQL("drop trigger message_delete_duplicates_on_insert"); in dropDeleteDuplicateMessagesTrigger()
276 db.execSQL("create trigger message_delete_duplicates_on_insert before insert on " in createDeleteDuplicateMessagesTrigger()
341 db.execSQL("create table " + Message.TABLE_NAME + createString); in createMessageTable()
342 db.execSQL("create table " + Message.UPDATED_TABLE_NAME + altCreateString); in createMessageTable()
343 db.execSQL("create table " + Message.DELETED_TABLE_NAME + altCreateString); in createMessageTable()
[all …]
/packages/providers/CalendarProvider/tests/src/com/android/providers/calendar/
DCalendarDatabaseHelperTest.java55 db.execSQL("CREATE TABLE Calendars (" + in bootstrapDbVersion50()
77 db.execSQL("CREATE TRIGGER calendar_cleanup DELETE ON Calendars " + in bootstrapDbVersion50()
84 db.execSQL("CREATE TABLE Events (" + in bootstrapDbVersion50()
121 db.execSQL("CREATE INDEX eventsCalendarIdIndex ON Events (calendar_id);"); in bootstrapDbVersion50()
123 db.execSQL("CREATE TABLE EventsRawTimes (" + in bootstrapDbVersion50()
136 db.execSQL("CREATE TABLE DeletedEvents (" + in bootstrapDbVersion50()
143 db.execSQL("CREATE TABLE Instances (" + in bootstrapDbVersion50()
155 db.execSQL("CREATE INDEX instancesStartDayIndex ON Instances (startDay);"); in bootstrapDbVersion50()
157 db.execSQL("CREATE TABLE CalendarMetaData (" + in bootstrapDbVersion50()
166 db.execSQL("CREATE TABLE BusyBits(" + in bootstrapDbVersion50()
[all …]
/packages/providers/ContactsProvider/src/com/android/providers/contacts/
DContactsDatabaseHelper.java1110 db.execSQL("DELETE FROM " + Tables.PRESENCE + ";"); in onOpen()
1111 db.execSQL("DELETE FROM " + Tables.AGGREGATED_PRESENCE + ";"); in onOpen()
1149 db.execSQL("CREATE TABLE IF NOT EXISTS " + Tables.PRESENCE + " ("+ in createPresenceTables()
1163 db.execSQL("CREATE INDEX IF NOT EXISTS presenceIndex" + " ON " in createPresenceTables()
1165 db.execSQL("CREATE INDEX IF NOT EXISTS presenceIndex2" + " ON " in createPresenceTables()
1168 db.execSQL("CREATE TABLE IF NOT EXISTS " in createPresenceTables()
1176 db.execSQL("CREATE TRIGGER IF NOT EXISTS " + Tables.PRESENCE + "_deleted" in createPresenceTables()
1216 db.execSQL("CREATE TRIGGER IF NOT EXISTS " + Tables.PRESENCE + "_inserted" in createPresenceTables()
1222 db.execSQL("CREATE TRIGGER IF NOT EXISTS " + Tables.PRESENCE + "_updated" in createPresenceTables()
1241 db.execSQL("CREATE TABLE " + Tables.ACCOUNTS + " (" + in onCreate()
[all …]
DCallLogDatabaseHelper.java119 db.execSQL("CREATE TABLE " + Tables.CALLS + " (" + in onCreate()
168 db.execSQL("CREATE TABLE " + Tables.VOICEMAIL_STATUS + " (" + in onCreate()
252 db.execSQL("ALTER TABLE " + Tables.CALLS + " ADD " + Calls.VIA_NUMBER + in upgradeToVersion2()
260 db.execSQL("ALTER TABLE " + Tables.VOICEMAIL_STATUS + " ADD " + Status.SOURCE_TYPE + in upgradeToVersion3()
269 db.execSQL("ALTER TABLE calls ADD backed_up INTEGER NOT NULL DEFAULT 0"); in upgradeToVersion4()
270 db.execSQL("ALTER TABLE calls ADD restored INTEGER NOT NULL DEFAULT 0"); in upgradeToVersion4()
271 db.execSQL("ALTER TABLE calls ADD archived INTEGER NOT NULL DEFAULT 0"); in upgradeToVersion4()
272 db.execSQL("ALTER TABLE calls ADD is_omtp_voicemail INTEGER NOT NULL DEFAULT 0"); in upgradeToVersion4()
279 db.execSQL("ALTER TABLE calls ADD transcription_state INTEGER NOT NULL DEFAULT 0"); in upgradeToVersion5()
338 contacts.execSQL("DROP TABLE " + LegacyConstants.CALLS_LEGACY + ";"); in migrateFromLegacyTables()
[all …]
DLegacyApiSupport.java567 db.execSQL("DROP VIEW IF EXISTS " + LegacyTables.PEOPLE + ";"); in createViews()
568 db.execSQL("CREATE VIEW " + LegacyTables.PEOPLE + " AS SELECT " + in createViews()
575 db.execSQL("DROP VIEW IF EXISTS " + LegacyTables.ORGANIZATIONS + ";"); in createViews()
576 db.execSQL("CREATE VIEW " + LegacyTables.ORGANIZATIONS + " AS SELECT " + in createViews()
599 db.execSQL("DROP VIEW IF EXISTS " + LegacyTables.CONTACT_METHODS + ";"); in createViews()
600 db.execSQL("CREATE VIEW " + LegacyTables.CONTACT_METHODS + " AS SELECT " + in createViews()
624 db.execSQL("DROP VIEW IF EXISTS " + LegacyTables.PHONES + ";"); in createViews()
625 db.execSQL("CREATE VIEW " + LegacyTables.PHONES + " AS SELECT DISTINCT " + in createViews()
651 db.execSQL("DROP VIEW IF EXISTS " + LegacyTables.EXTENSIONS + ";"); in createViews()
652 db.execSQL("CREATE VIEW " + LegacyTables.EXTENSIONS + " AS SELECT " + in createViews()
[all …]
/packages/providers/TvProvider/tests/src/com/android/providers/tv/
DDatabaseHelperTest.java110 db.execSQL("CREATE TABLE " + TvProvider.CHANNELS_TABLE + " (" in onCreate()
138 db.execSQL("CREATE TABLE " + TvProvider.PROGRAMS_TABLE + " (" in onCreate()
167 db.execSQL("CREATE INDEX " + TvProvider.PROGRAMS_TABLE_PACKAGE_NAME_INDEX + " ON " in onCreate()
170 db.execSQL("CREATE INDEX " + TvProvider.PROGRAMS_TABLE_CHANNEL_ID_INDEX + " ON " in onCreate()
173 db.execSQL("CREATE INDEX " + TvProvider.PROGRAMS_TABLE_START_TIME_INDEX + " ON " in onCreate()
176 db.execSQL("CREATE INDEX " + TvProvider.PROGRAMS_TABLE_END_TIME_INDEX + " ON " in onCreate()
179 db.execSQL("CREATE TABLE " + TvProvider.WATCHED_PROGRAMS_TABLE + " (" in onCreate()
202 db.execSQL("CREATE INDEX " + TvProvider.WATCHED_PROGRAMS_TABLE_CHANNEL_ID_INDEX + " ON " in onCreate()
210 db.execSQL("DROP TABLE IF EXISTS " + TvProvider.WATCH_NEXT_PROGRAMS_TABLE); in onDowngrade()
211 db.execSQL("DROP TABLE IF EXISTS " + TvProvider.PREVIEW_PROGRAMS_TABLE); in onDowngrade()
[all …]
/packages/apps/Dialer/java/com/android/dialer/database/
DDialerDatabaseHelper.java103 db.execSQL( in setupTables()
139 db.execSQL( in setupTables()
151 db.execSQL( in setupTables()
164 db.execSQL( in setupTables()
195 db.execSQL("DROP TABLE IF EXISTS " + Tables.PREFIX_TABLE); in dropTables()
196 db.execSQL("DROP TABLE IF EXISTS " + Tables.SMARTDIAL_TABLE); in dropTables()
197 db.execSQL("DROP TABLE IF EXISTS " + Tables.PROPERTIES); in dropTables()
198 db.execSQL("DROP TABLE IF EXISTS " + Tables.FILTERED_NUMBER_TABLE); in dropTables()
199 db.execSQL("DROP TABLE IF EXISTS " + Tables.VOICEMAIL_ARCHIVE_TABLE); in dropTables()
222 db.execSQL("DROP TABLE IF EXISTS " + Tables.FILTERED_NUMBER_TABLE); in onUpgrade()
[all …]
/packages/providers/TvProvider/src/com/android/providers/tv/
DTvProvider.java767 db.execSQL("CREATE TABLE " + CHANNELS_TABLE + " (" in onCreate()
802 db.execSQL("CREATE TABLE " + PROGRAMS_TABLE + " (" in onCreate()
839 db.execSQL("CREATE INDEX " + PROGRAMS_TABLE_PACKAGE_NAME_INDEX + " ON " + PROGRAMS_TABLE in onCreate()
841 db.execSQL("CREATE INDEX " + PROGRAMS_TABLE_CHANNEL_ID_INDEX + " ON " + PROGRAMS_TABLE in onCreate()
843 db.execSQL("CREATE INDEX " + PROGRAMS_TABLE_START_TIME_INDEX + " ON " + PROGRAMS_TABLE in onCreate()
845 db.execSQL("CREATE INDEX " + PROGRAMS_TABLE_END_TIME_INDEX + " ON " + PROGRAMS_TABLE in onCreate()
847 db.execSQL("CREATE TABLE " + WATCHED_PROGRAMS_TABLE + " (" in onCreate()
869 db.execSQL("CREATE INDEX " + WATCHED_PROGRAMS_TABLE_CHANNEL_ID_INDEX + " ON " in onCreate()
871 db.execSQL(CREATE_RECORDED_PROGRAMS_TABLE_SQL); in onCreate()
872 db.execSQL(CREATE_PREVIEW_PROGRAMS_TABLE_SQL); in onCreate()
[all …]
/packages/providers/MediaProvider/src/com/android/providers/media/
DMediaProvider.java773 db.execSQL("DROP TRIGGER IF EXISTS " + c.getString(0)); in makePristine()
781 db.execSQL("DROP VIEW IF EXISTS " + c.getString(0)); in makePristine()
789 db.execSQL("DROP INDEX IF EXISTS " + c.getString(0)); in makePristine()
797 db.execSQL("DROP TABLE IF EXISTS " + c.getString(0)); in makePristine()
805 db.execSQL("CREATE TABLE android_metadata (locale TEXT)"); in createLatestSchema()
806 db.execSQL("CREATE TABLE thumbnails (_id INTEGER PRIMARY KEY,_data TEXT,image_id INTEGER," in createLatestSchema()
808 db.execSQL("CREATE TABLE artists (artist_id INTEGER PRIMARY KEY," in createLatestSchema()
810 db.execSQL("CREATE TABLE albums (album_id INTEGER PRIMARY KEY," in createLatestSchema()
812 db.execSQL("CREATE TABLE album_art (album_id INTEGER PRIMARY KEY,_data TEXT)"); in createLatestSchema()
813 db.execSQL("CREATE TABLE videothumbnails (_id INTEGER PRIMARY KEY,_data TEXT," in createLatestSchema()
[all …]
/packages/apps/Settings/src/com/android/settings/search/
DIndexDatabaseHelper.java191 db.execSQL(CREATE_INDEX_TABLE); in bootstrapDB()
192 db.execSQL(CREATE_META_TABLE); in bootstrapDB()
193 db.execSQL(CREATE_SAVED_QUERIES_TABLE); in bootstrapDB()
194 db.execSQL(CREATE_SITE_MAP_TABLE); in bootstrapDB()
195 db.execSQL(INSERT_BUILD_VERSION); in bootstrapDB()
323 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_META_INDEX); in dropTables()
324 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_PREFS_INDEX); in dropTables()
325 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_SAVED_QUERIES); in dropTables()
326 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_SITE_MAP); in dropTables()
/packages/apps/Messaging/src/com/android/messaging/datamodel/
DDatabaseHelper.java655 db.execSQL(createViewSql); in rebuildView()
662 db.execSQL(dropPrefix + viewName); in dropView()
677 db.execSQL(sql); in rebuildAllViews()
698 db.execSQL(dropPrefix + tableName); in dropAllTables()
729 db.execSQL(dropPrefix + triggerName); in dropAllTriggers()
773 db.execSQL(dropPrefix + indexName); in dropAllIndexes()
789 db.execSQL(sql); in createDatabase()
793 db.execSQL(sql); in createDatabase()
797 db.execSQL(sql); in createDatabase()
801 db.execSQL(sql); in createDatabase()
[all …]
/packages/apps/ExactCalculator/src/com/android/calculator2/
DExpressionDB.java150 db.execSQL(SQL_CREATE_ENTRIES); in onCreate()
151 db.execSQL(SQL_CREATE_TIMESTAMP_INDEX); in onCreate()
155 db.execSQL(SQL_DROP_TIMESTAMP_INDEX); in onUpgrade()
156 db.execSQL(SQL_DROP_TABLE); in onUpgrade()
355 mExpressionDB.execSQL(SQL_DROP_TIMESTAMP_INDEX); in doInBackground()
356 mExpressionDB.execSQL(SQL_DROP_TABLE); in doInBackground()
358 mExpressionDB.execSQL("VACUUM"); in doInBackground()
363 mExpressionDB.execSQL(SQL_CREATE_ENTRIES); in doInBackground()
364 mExpressionDB.execSQL(SQL_CREATE_TIMESTAMP_INDEX); in doInBackground()
/packages/apps/DeskClock/src/com/android/deskclock/provider/
DClockDatabaseHelper.java74 db.execSQL("CREATE TABLE " + ALARMS_TABLE_NAME + " (" + in createAlarmsTable()
88 db.execSQL("CREATE TABLE " + INSTANCES_TABLE_NAME + " (" + in createInstanceTable()
127 db.execSQL(insertMe + DEFAULT_ALARM_1); in onCreate()
128 db.execSQL(insertMe + DEFAULT_ALARM_2); in onCreate()
137 db.execSQL("DROP TABLE IF EXISTS " + SELECTED_CITIES_TABLE_NAME + ";"); in onUpgrade()
142 db.execSQL("DROP TABLE IF EXISTS " + INSTANCES_TABLE_NAME + ";"); in onUpgrade()
191 db.execSQL("DROP TABLE IF EXISTS " + OLD_ALARMS_TABLE_NAME + ";"); in onUpgrade()
/packages/inputmethods/LatinIME/java/src/com/android/inputmethod/dictionarypack/
DMetadataDbHelper.java208 db.execSQL(METADATA_CREATE_CLIENT_TABLE); in createClientTable()
228 db.execSQL(METADATA_TABLE_CREATE); in onCreate()
234 db.execSQL("SELECT " + RAW_CHECKSUM_COLUMN + " FROM " in addRawChecksumColumnUnlessPresent()
238 db.execSQL("ALTER TABLE " + METADATA_TABLE_NAME + " ADD COLUMN " in addRawChecksumColumnUnlessPresent()
245 db.execSQL("SELECT " + RETRY_COUNT_COLUMN + " FROM " in addRetryCountColumnUnlessPresent()
249 db.execSQL("ALTER TABLE " + METADATA_TABLE_NAME + " ADD COLUMN " in addRetryCountColumnUnlessPresent()
286 db.execSQL("DROP TABLE IF EXISTS " + CLIENT_TABLE_NAME); in onUpgrade()
295 db.execSQL("DROP TABLE IF EXISTS " + METADATA_TABLE_NAME); in onUpgrade()
296 db.execSQL("DROP TABLE IF EXISTS " + CLIENT_TABLE_NAME); in onUpgrade()
328 db.execSQL("DROP TABLE IF EXISTS " + METADATA_TABLE_NAME); in onDowngrade()
[all …]
/packages/providers/BlockedNumberProvider/src/com/android/providers/blockednumber/
DBlockedNumberDatabaseHelper.java59 db.execSQL("DROP TABLE IF EXISTS blocked"); in onUpgrade()
65 db.execSQL("CREATE TABLE " + Tables.BLOCKED_NUMBERS + " (" + in createTables()
71 db.execSQL("CREATE INDEX blocked_number_idx_original ON " + Tables.BLOCKED_NUMBERS + in createTables()
73 db.execSQL("CREATE INDEX blocked_number_idx_e164 ON " + Tables.BLOCKED_NUMBERS + " (" + in createTables()
109 getWritableDatabase().execSQL("DELETE FROM " + Tables.BLOCKED_NUMBERS); in wipeForTest()
/packages/apps/Launcher3/src/com/android/launcher3/
DLauncherProvider.java669 db.execSQL("CREATE TABLE " + ifNotExists + WorkspaceScreens.TABLE_NAME + " (" + in addWorkspacesTable()
687 db.execSQL(removeOrphanedDesktopItems); in removeOrphanedItems()
704 db.execSQL(removeOrphanedFolderItems); in removeOrphanedItems()
733 db.execSQL(sql); in handleOneTimeDataUpgrade()
752 db.execSQL("ALTER TABLE favorites " + in onUpgrade()
764 db.execSQL("ALTER TABLE favorites " + in onUpgrade()
766 db.execSQL("ALTER TABLE workspaceScreens " + in onUpgrade()
855 db.execSQL("DROP TABLE IF EXISTS " + Favorites.TABLE_NAME); in createEmptyDB()
856 db.execSQL("DROP TABLE IF EXISTS " + WorkspaceScreens.TABLE_NAME); in createEmptyDB()
959 db.execSQL("DROP TABLE IF EXISTS " + WorkspaceScreens.TABLE_NAME); in recreateWorkspaceTable()
[all …]
/packages/providers/ContactsProvider/tests/src/com/android/providers/contacts/
DSynchronousContactsProvider2.java194 db.execSQL("UPDATE raw_contacts SET aggregation_mode=0,aggregation_needed=1;");
198 db.execSQL("DELETE FROM raw_contacts WHERE _id > " + rowId + ";");
216 db.execSQL("replace into SQLITE_SEQUENCE (name,seq) values('raw_contacts', 42)");
217 db.execSQL("replace into SQLITE_SEQUENCE (name,seq) values('contacts', 2009)");
218 db.execSQL("replace into SQLITE_SEQUENCE (name,seq) values('data', 777)");
/packages/apps/Messaging/src/com/android/messaging/sms/
DApnDatabase.java308 db.execSQL("DROP TABLE IF EXISTS " + APN_TABLE + ";"); in rebuildTables()
309 db.execSQL(APN_TABLE_SQL); in rebuildTables()
356 db.execSQL("DROP TABLE IF EXISTS " + APN_TABLE); in forceBuildAndLoadApnTables()
361 db.execSQL(APN_TABLE_SQL); in forceBuildAndLoadApnTables()
371 db.execSQL("DROP TABLE IF EXISTS " + APN_TABLE); in clearTables()
372 db.execSQL(APN_TABLE_SQL); in clearTables()
/packages/services/Car/car-usb-handler/src/android/car/usb/handler/
DUsbSettingsStorage.java203 db.execSQL("CREATE TABLE " + tableName + " (" in createTable()
216 db.execSQL("CREATE INDEX " + TABLE_USB_SETTINGS + "_" + COLUMN_SERIAL + " ON " in createSerialIndex()
227 db.execSQL("INSERT INTO " + tempTableName in onUpgrade()
229 db.execSQL("DROP TABLE " + TABLE_USB_SETTINGS); in onUpgrade()
230 db.execSQL("ALTER TABLE " + tempTableName + " RENAME TO " in onUpgrade()
/packages/providers/ContactsProvider/src/com/android/providers/contacts/database/
DContactsTableUtil.java46 db.execSQL("CREATE INDEX contacts_has_phone_index ON " + table + " (" + in createIndexes()
50 db.execSQL("CREATE INDEX contacts_name_raw_contact_id_index ON " + table + " (" + in createIndexes()
54 db.execSQL(MoreDatabaseUtils.buildCreateIndexSql(table, in createIndexes()
78 db.execSQL(buildUpdateLastUpdateSql(rawContactIds)); in updateContactLastUpdateByRawContactId()
/packages/apps/CellBroadcastReceiver/src/com/android/cellbroadcastreceiver/
DCellBroadcastDatabaseHelper.java63 db.execSQL("CREATE TABLE " + TABLE_NAME + " (" in onCreate()
89 db.execSQL("CREATE INDEX IF NOT EXISTS deliveryTimeIndex ON " + TABLE_NAME in createDeliveryTimeIndex()
127 db.execSQL("DROP TABLE IF EXISTS " + TEMP_TABLE_NAME); in onUpgrade()
128 db.execSQL("ALTER TABLE " + TABLE_NAME + " RENAME TO " + TEMP_TABLE_NAME); in onUpgrade()
145 db.execSQL("DROP TABLE " + TEMP_TABLE_NAME); in onUpgrade()

123