Home
last modified time | relevance | path

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

1234567

/packages/providers/MediaProvider/tests/src/com/android/providers/media/
DDatabaseHelperTest.java662 db.execSQL("CREATE TABLE android_metadata (locale TEXT)"); in createOSchema()
663 db.execSQL("CREATE TABLE thumbnails (_id INTEGER PRIMARY KEY,_data TEXT,image_id INTEGER," in createOSchema()
665 db.execSQL("CREATE TABLE artists (artist_id INTEGER PRIMARY KEY," in createOSchema()
667 db.execSQL("CREATE TABLE albums (album_id INTEGER PRIMARY KEY," in createOSchema()
669 db.execSQL("CREATE TABLE album_art (album_id INTEGER PRIMARY KEY,_data TEXT)"); in createOSchema()
670 db.execSQL("CREATE TABLE videothumbnails (_id INTEGER PRIMARY KEY,_data TEXT," in createOSchema()
672 db.execSQL("CREATE TABLE files (_id INTEGER PRIMARY KEY AUTOINCREMENT," in createOSchema()
685 db.execSQL("CREATE TABLE log (time DATETIME, message TEXT)"); in createOSchema()
687 db.execSQL("CREATE TABLE audio_genres (_id INTEGER PRIMARY KEY,name TEXT NOT NULL)"); in createOSchema()
688 db.execSQL("CREATE TABLE audio_genres_map (_id INTEGER PRIMARY KEY," in createOSchema()
[all …]
/packages/providers/MediaProvider/legacy/src/com/android/providers/media/
DLegacyDatabaseHelper.java246 db.execSQL("UPDATE local_metadata SET generation=generation+1;"); in beginTransactionInternal()
386 db.execSQL("DROP TRIGGER IF EXISTS " + c.getString(0)); in makePristineSchema()
395 db.execSQL("DROP VIEW IF EXISTS " + c.getString(0)); in makePristineSchema()
404 db.execSQL("DROP INDEX IF EXISTS " + c.getString(0)); in makePristineSchema()
413 db.execSQL("DROP TABLE IF EXISTS " + c.getString(0)); in makePristineSchema()
437 db.execSQL("CREATE TABLE local_metadata (generation INTEGER DEFAULT 0)"); in createLatestSchema()
438 db.execSQL("INSERT INTO local_metadata VALUES (0)"); in createLatestSchema()
440 db.execSQL("CREATE TABLE android_metadata (locale TEXT)"); in createLatestSchema()
441 db.execSQL("CREATE TABLE thumbnails (_id INTEGER PRIMARY KEY,_data TEXT,image_id INTEGER," in createLatestSchema()
443 db.execSQL("CREATE TABLE album_art (album_id INTEGER PRIMARY KEY,_data TEXT)"); in createLatestSchema()
[all …]
/packages/modules/Bluetooth/android/app/src/com/android/bluetooth/btservice/storage/
DMetadataDatabase.java128 database.execSQL(
138 database.execSQL(
159 database.execSQL(
192 database.execSQL("DROP TABLE `metadata`");
193 database.execSQL("ALTER TABLE `metadata_tmp` RENAME TO `metadata`");
203 database.execSQL(
229 database.execSQL(
266 database.execSQL(
269 database.execSQL(
272 database.execSQL(
[all …]
/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/CalendarProvider/tests/src/com/android/providers/calendar/
DCalendarDatabaseHelperTest.java65 db.execSQL("CREATE TABLE Calendars (" + in bootstrapDbVersion50()
87 db.execSQL("CREATE TRIGGER calendar_cleanup DELETE ON Calendars " + in bootstrapDbVersion50()
94 db.execSQL("CREATE TABLE Events (" + in bootstrapDbVersion50()
131 db.execSQL("CREATE INDEX eventsCalendarIdIndex ON Events (calendar_id);"); in bootstrapDbVersion50()
133 db.execSQL("CREATE TABLE EventsRawTimes (" + in bootstrapDbVersion50()
146 db.execSQL("CREATE TABLE DeletedEvents (" + in bootstrapDbVersion50()
153 db.execSQL("CREATE TABLE Instances (" + in bootstrapDbVersion50()
165 db.execSQL("CREATE INDEX instancesStartDayIndex ON Instances (startDay);"); in bootstrapDbVersion50()
167 db.execSQL("CREATE TABLE CalendarMetaData (" + in bootstrapDbVersion50()
176 db.execSQL("CREATE TABLE BusyBits(" + in bootstrapDbVersion50()
[all …]
/packages/providers/TelephonyProvider/src/com/android/providers/telephony/
DMmsSmsDatabaseHelper.java452 db.execSQL( in updateThreads()
476 db.execSQL( in updateThreads()
504 db.execSQL( in updateThreads()
710 db.execSQL("DROP TABLE IF EXISTS " + MmsProvider.TABLE_WORDS); in createWordsTables()
711 …db.execSQL("CREATE VIRTUAL TABLE words USING FTS3 (_id INTEGER PRIMARY KEY, index_text TEXT, sourc… in createWordsTables()
718 db.execSQL("CREATE TRIGGER IF NOT EXISTS sms_words_update AFTER UPDATE ON sms " in createWordsTables()
721 db.execSQL("CREATE TRIGGER IF NOT EXISTS sms_words_delete AFTER DELETE ON sms " in createWordsTables()
745 db.execSQL("CREATE INDEX IF NOT EXISTS typeThreadIdIndex ON sms" + in createThreadIdIndex()
760 db.execSQL("CREATE INDEX IF NOT EXISTS threadIdDateIndex ON sms" + in createThreadIdDateIndex()
775 db.execSQL("CREATE INDEX IF NOT EXISTS partMidIndex ON part (mid)"); in createPartMidIndex()
[all …]
DCarrierDatabaseHelper.java80 db.execSQL(getStringForCarrierKeyTableCreation(CARRIER_KEY_TABLE)); in onCreate()
84 db.execSQL(getStringForCarrierKeyTableCreation(CARRIER_KEY_TABLE)); in createCarrierTable()
88 db.execSQL("DROP TABLE IF EXISTS " + CARRIER_KEY_TABLE + ";"); in dropCarrierTable()
105 db.execSQL("COMMIT"); in onUpgrade()
112 db.execSQL( in renameCarrierTable()
125 db.execSQL(copyStr); in copyContents()
130 db.execSQL("DROP TABLE IF EXISTS " + TEMPORARY_CARRIER_KEY_TABLE + ";"); in dropTemporaryTable()
/packages/providers/MediaProvider/src/com/android/providers/media/
DDatabaseHelper.java820 db.execSQL("UPDATE local_metadata SET generation=generation+1;"); in beginTransactionInternal()
1049 db.execSQL("DROP TRIGGER IF EXISTS " + c.getString(0)); in makePristineSchema()
1058 db.execSQL("DROP VIEW IF EXISTS " + c.getString(0)); in makePristineSchema()
1067 db.execSQL("DROP INDEX IF EXISTS " + c.getString(0)); in makePristineSchema()
1076 db.execSQL("DROP TABLE IF EXISTS " + c.getString(0)); in makePristineSchema()
1100 db.execSQL("CREATE TABLE local_metadata (generation INTEGER DEFAULT 0)"); in createLatestSchema()
1101 db.execSQL("INSERT INTO local_metadata VALUES (0)"); in createLatestSchema()
1103 db.execSQL("CREATE TABLE android_metadata (locale TEXT)"); in createLatestSchema()
1104 db.execSQL("CREATE TABLE thumbnails (_id INTEGER PRIMARY KEY,_data TEXT,image_id INTEGER," in createLatestSchema()
1106 db.execSQL("CREATE TABLE album_art (album_id INTEGER PRIMARY KEY,_data TEXT)"); in createLatestSchema()
[all …]
/packages/providers/MediaProvider/src/com/android/providers/media/photopicker/data/
DPickerDatabaseHelper.java114 db.execSQL("DROP TABLE IF EXISTS " + c.getString(0)); in dropAllTables()
121 db.execSQL("CREATE TABLE media (_id INTEGER PRIMARY KEY AUTOINCREMENT," in createLatestSchema()
138 db.execSQL("CREATE TABLE album_media (_id INTEGER PRIMARY KEY AUTOINCREMENT," in createLatestSchema()
156 db.execSQL("CREATE INDEX local_id_index on media(local_id)"); in createLatestIndexes()
157 db.execSQL("CREATE INDEX cloud_id_index on media(cloud_id)"); in createLatestIndexes()
158 db.execSQL("CREATE INDEX is_visible_index on media(is_visible)"); in createLatestIndexes()
159 db.execSQL("CREATE INDEX size_index on media(size_bytes)"); in createLatestIndexes()
160 db.execSQL("CREATE INDEX mime_type_index on media(mime_type)"); in createLatestIndexes()
161 db.execSQL("CREATE INDEX is_favorite_index on media(is_favorite)"); in createLatestIndexes()
162 db.execSQL("CREATE INDEX date_taken_row_id_index on media(date_taken_ms, _id)"); in createLatestIndexes()
[all …]
/packages/providers/ContactsProvider/src/com/android/providers/contacts/
DCallLogDatabaseHelper.java135 db.execSQL("CREATE TABLE " + Tables.CALLS + " (" + in onCreate()
196 db.execSQL("CREATE TABLE " + Tables.VOICEMAIL_STATUS + " (" + in onCreate()
339 db.execSQL("ALTER TABLE " + Tables.CALLS + " ADD " + Calls.VIA_NUMBER + in upgradeToVersion2()
347 db.execSQL("ALTER TABLE " + Tables.VOICEMAIL_STATUS + " ADD " + Status.SOURCE_TYPE + in upgradeToVersion3()
356 db.execSQL("ALTER TABLE calls ADD backed_up INTEGER NOT NULL DEFAULT 0"); in upgradeToVersion4()
357 db.execSQL("ALTER TABLE calls ADD restored INTEGER NOT NULL DEFAULT 0"); in upgradeToVersion4()
358 db.execSQL("ALTER TABLE calls ADD archived INTEGER NOT NULL DEFAULT 0"); in upgradeToVersion4()
359 db.execSQL("ALTER TABLE calls ADD is_omtp_voicemail INTEGER NOT NULL DEFAULT 0"); in upgradeToVersion4()
366 db.execSQL("ALTER TABLE calls ADD transcription_state INTEGER NOT NULL DEFAULT 0"); in upgradeToVersion5()
375 db.execSQL("ALTER TABLE calls ADD call_screening_component_name TEXT"); in upgradeToVersion6()
[all …]
DContactsDatabaseHelper.java1107 db.execSQL("DELETE FROM " + Tables.PRESENCE + ";"); in onOpen()
1108 db.execSQL("DELETE FROM " + Tables.AGGREGATED_PRESENCE + ";"); in onOpen()
1147 db.execSQL("CREATE TABLE IF NOT EXISTS " + Tables.PRESENCE + " ("+ in createPresenceTables()
1161 db.execSQL("CREATE INDEX IF NOT EXISTS presenceIndex" + " ON " in createPresenceTables()
1163 db.execSQL("CREATE INDEX IF NOT EXISTS presenceIndex2" + " ON " in createPresenceTables()
1166 db.execSQL("CREATE TABLE IF NOT EXISTS " in createPresenceTables()
1174 db.execSQL("CREATE TRIGGER IF NOT EXISTS " + Tables.PRESENCE + "_deleted" in createPresenceTables()
1214 db.execSQL("CREATE TRIGGER IF NOT EXISTS " + Tables.PRESENCE + "_inserted" in createPresenceTables()
1220 db.execSQL("CREATE TRIGGER IF NOT EXISTS " + Tables.PRESENCE + "_updated" in createPresenceTables()
1239 db.execSQL("CREATE TABLE " + Tables.ACCOUNTS + " (" + in onCreate()
[all …]
/packages/providers/TvProvider/tests/src/com/android/providers/tv/
DDatabaseHelperTest.java114 db.execSQL("CREATE TABLE " + TvProvider.CHANNELS_TABLE + " (" in onCreate()
142 db.execSQL("CREATE TABLE " + TvProvider.PROGRAMS_TABLE + " (" in onCreate()
171 db.execSQL("CREATE INDEX " + TvProvider.PROGRAMS_TABLE_PACKAGE_NAME_INDEX + " ON " in onCreate()
174 db.execSQL("CREATE INDEX " + TvProvider.PROGRAMS_TABLE_CHANNEL_ID_INDEX + " ON " in onCreate()
177 db.execSQL("CREATE INDEX " + TvProvider.PROGRAMS_TABLE_START_TIME_INDEX + " ON " in onCreate()
180 db.execSQL("CREATE INDEX " + TvProvider.PROGRAMS_TABLE_END_TIME_INDEX + " ON " in onCreate()
183 db.execSQL("CREATE TABLE " + TvProvider.WATCHED_PROGRAMS_TABLE + " (" in onCreate()
206 db.execSQL("CREATE INDEX " + TvProvider.WATCHED_PROGRAMS_TABLE_CHANNEL_ID_INDEX + " ON " in onCreate()
214 db.execSQL("DROP TABLE IF EXISTS " + TvProvider.WATCH_NEXT_PROGRAMS_TABLE); in onDowngrade()
215 db.execSQL("DROP TABLE IF EXISTS " + TvProvider.PREVIEW_PROGRAMS_TABLE); in onDowngrade()
[all …]
/packages/modules/OnDevicePersonalization/tests/servicetests/src/com/android/ondevicepersonalization/services/data/
DOnDevicePersonalizationDbHelperTest.java252 db.execSQL(VendorSettingsContract.VendorSettingsEntry.CREATE_TABLE_STATEMENT); in createV1Tables()
255 db.execSQL(CREATE_QUERIES_V1_STATEMENT); in createV1Tables()
256 db.execSQL(EventsContract.EventsEntry.CREATE_TABLE_STATEMENT); in createV1Tables()
257 db.execSQL(EventStateContract.EventStateEntry.CREATE_TABLE_STATEMENT); in createV1Tables()
261 db.execSQL(VendorSettingsContract.VendorSettingsEntry.CREATE_TABLE_STATEMENT); in createV2Tables()
264 db.execSQL(CREATE_QUERIES_V2_STATEMENT); in createV2Tables()
265 db.execSQL(EventsContract.EventsEntry.CREATE_TABLE_STATEMENT); in createV2Tables()
266 db.execSQL(EventStateContract.EventStateEntry.CREATE_TABLE_STATEMENT); in createV2Tables()
270 db.execSQL(VendorSettingsContract.VendorSettingsEntry.CREATE_TABLE_STATEMENT); in createV3Tables()
273 db.execSQL(CREATE_QUERIES_V3_STATEMENT); in createV3Tables()
[all …]
/packages/modules/AdServices/adservices/service-core/java/com/android/adservices/data/measurement/migration/
DMigrationHelpers.java55 db.execSQL("PRAGMA foreign_keys=OFF"); in copyAndUpdateTable()
56 db.execSQL(renameTableQuery); in copyAndUpdateTable()
57 db.execSQL(createTableQuery); in copyAndUpdateTable()
73 db.execSQL(dropBackupTable); in copyAndUpdateTable()
87 db.execSQL(insertValuesFromBackupQuery); in copyAndUpdateTable()
88 db.execSQL(dropBackupTable); in copyAndUpdateTable()
89 db.execSQL("PRAGMA foreign_keys=ON"); in copyAndUpdateTable()
105 db.execSQL(String.format("ALTER TABLE %1$s ADD %2$s INTEGER", tableName, columnName)); in addIntColumnIfAbsent()
113 db.execSQL(String.format("ALTER TABLE %1$s ADD %2$s TEXT", tableName, columnName)); in addTextColumnIfAbsent()
DMeasurementDbMigratorV9.java236 db.execSQL(MeasurementTables.CREATE_TABLE_SOURCE_DESTINATION_LATEST); in performMigration()
237 db.execSQL(SOURCE_DESTINATION_CREATE_INDEX_D); in performMigration()
238 db.execSQL(SOURCE_DESTINATION_CREATE_INDEX_S); in performMigration()
239 db.execSQL(MIGRATE_SOURCE_APP_DESTINATION); in performMigration()
240 db.execSQL(MIGRATE_SOURCE_WEB_DESTINATION); in performMigration()
251 db.execSQL(SOURCE_CREATE_INDEX_EI); in alterSourceTable()
252 db.execSQL(SOURCE_CREATE_INDEX_EI_ET); in alterSourceTable()
253 db.execSQL(SOURCE_CREATE_INDEX_ET); in alterSourceTable()
254 db.execSQL(SOURCE_CREATE_INDEX_P_S_ET); in alterSourceTable()
/packages/providers/TelephonyProvider/tests/src/com/android/providers/telephony/
DMmsSmsDatabaseHelperTest.java194 db.execSQL("CREATE TABLE " + MmsProvider.TABLE_PDU + " (" + in createMmsTables()
225 db.execSQL("CREATE TABLE " + MmsProvider.TABLE_ADDR + " (" + in createMmsTables()
233 db.execSQL("CREATE TABLE " + MmsProvider.TABLE_PART + " (" + in createMmsTables()
248 db.execSQL("CREATE TABLE " + MmsProvider.TABLE_RATE + " (" + in createMmsTables()
251 db.execSQL("CREATE TABLE " + MmsProvider.TABLE_DRM + " (" + in createMmsTables()
261 db.execSQL("CREATE TABLE sms (" + in createSmsTables()
276 db.execSQL("CREATE TABLE raw (" + in createSmsTables()
286 db.execSQL("CREATE TABLE attachments (" + in createSmsTables()
291 db.execSQL("CREATE TABLE sr_pending (" + in createSmsTables()
302 db.execSQL("CREATE TABLE canonical_addresses (" + in createCommonTables()
[all …]
DMmsProviderTestable.java64 db.execSQL(CREATE_PDU_TABLE_STR); in onCreate()
65 db.execSQL(CREATE_ADDR_TABLE_STR); in onCreate()
66 db.execSQL(CREATE_PART_TABLE_STR); in onCreate()
67 db.execSQL(CREATE_RATE_TABLE_STR); in onCreate()
68 db.execSQL(CREATE_DRM_TABLE_STR); in onCreate()
/packages/providers/TvProvider/src/com/android/providers/tv/
DTvProvider.java840 db.execSQL("CREATE TABLE " + CHANNELS_TABLE + " (" in onCreate()
885 db.execSQL("CREATE TABLE " + PROGRAMS_TABLE + " (" in onCreate()
929 db.execSQL("CREATE INDEX " + PROGRAMS_TABLE_PACKAGE_NAME_INDEX + " ON " + PROGRAMS_TABLE in onCreate()
931 db.execSQL("CREATE INDEX " + PROGRAMS_TABLE_CHANNEL_ID_INDEX + " ON " + PROGRAMS_TABLE in onCreate()
933 db.execSQL("CREATE INDEX " + PROGRAMS_TABLE_START_TIME_INDEX + " ON " + PROGRAMS_TABLE in onCreate()
935 db.execSQL("CREATE INDEX " + PROGRAMS_TABLE_END_TIME_INDEX + " ON " + PROGRAMS_TABLE in onCreate()
937 db.execSQL("CREATE TABLE " + WATCHED_PROGRAMS_TABLE + " (" in onCreate()
959 db.execSQL("CREATE INDEX " + WATCHED_PROGRAMS_TABLE_CHANNEL_ID_INDEX + " ON " in onCreate()
961 db.execSQL(CREATE_RECORDED_PROGRAMS_TABLE_SQL); in onCreate()
962 db.execSQL(CREATE_PREVIEW_PROGRAMS_TABLE_SQL); in onCreate()
[all …]
/packages/apps/Dialer/java/com/android/dialer/calllog/database/
DAnnotatedCallLogDatabaseHelper.java150 db.execSQL(CREATE_TABLE_SQL); in onCreate()
151 db.execSQL(String.format(Locale.US, CREATE_TRIGGER_SQL, maxRows, maxRows)); in onCreate()
152 db.execSQL(CREATE_INDEX_ON_CALL_TYPE_SQL); in onCreate()
153 db.execSQL(CREATE_INDEX_ON_NUMBER_SQL); in onCreate()
175 db.execSQL( in upgradeToV2()
181 db.execSQL( in upgradeToV2()
205 db.execSQL( in upgradeToV4()
/packages/apps/Dialer/java/com/android/dialer/database/
DDialerDatabaseHelper.java115 db.execSQL( in setupTables()
151 db.execSQL( in setupTables()
163 db.execSQL( in setupTables()
176 db.execSQL( in setupTables()
207 db.execSQL("DROP TABLE IF EXISTS " + Tables.PREFIX_TABLE); in dropTables()
208 db.execSQL("DROP TABLE IF EXISTS " + Tables.SMARTDIAL_TABLE); in dropTables()
209 db.execSQL("DROP TABLE IF EXISTS " + Tables.PROPERTIES); in dropTables()
210 db.execSQL("DROP TABLE IF EXISTS " + Tables.FILTERED_NUMBER_TABLE); in dropTables()
211 db.execSQL("DROP TABLE IF EXISTS " + Tables.VOICEMAIL_ARCHIVE_TABLE); in dropTables()
234 db.execSQL("DROP TABLE IF EXISTS " + Tables.FILTERED_NUMBER_TABLE); in onUpgrade()
[all …]
/packages/apps/TV/tests/common/src/com/android/tv/testing/fakes/
DFakeTvProvider.java998 db.execSQL( in onCreate()
1073 db.execSQL( in onCreate()
1149 db.execSQL( in onCreate()
1157 db.execSQL( in onCreate()
1165 db.execSQL( in onCreate()
1173 db.execSQL( in onCreate()
1181 db.execSQL( in onCreate()
1221 db.execSQL( in onCreate()
1229 db.execSQL(CREATE_RECORDED_PROGRAMS_TABLE_SQL); in onCreate()
1230 db.execSQL(CREATE_PREVIEW_PROGRAMS_TABLE_SQL); in onCreate()
[all …]
/packages/modules/OnDevicePersonalization/federatedcompute/src/com/android/federatedcompute/services/data/
DFederatedComputeDbHelper.java173 db.execSQL(CREATE_TRAINING_TASK_TABLE); in onCreate()
174 db.execSQL(CREATE_TRAINING_TASK_OWNER_PACKAGE_INDEX); in onCreate()
175 db.execSQL(CREATE_ENCRYPTION_KEY_TABLE); in onCreate()
176 db.execSQL(CREATE_ODP_AUTHORIZATION_TOKEN_TABLE); in onCreate()
177 db.execSQL(CREATE_TASK_HISTORY_TABLE_STATEMENT); in onCreate()
186 db.execSQL( in onUpgrade()
192 db.execSQL( in onUpgrade()
232 db.execSQL(CREATE_TRAINING_TASK_OWNER_PACKAGE_INDEX); in onUpgrade()
/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/SettingsIntelligence/src/com/android/settings/intelligence/search/indexing/
DIndexDatabaseHelper.java201 db.execSQL(CREATE_INDEX_TABLE); in bootstrapDB()
202 db.execSQL(CREATE_META_TABLE); in bootstrapDB()
203 db.execSQL(CREATE_SAVED_QUERIES_TABLE); in bootstrapDB()
204 db.execSQL(CREATE_SITE_MAP_TABLE); in bootstrapDB()
205 db.execSQL(INSERT_BUILD_VERSION); in bootstrapDB()
350 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_META_INDEX); in dropTables()
351 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_PREFS_INDEX); in dropTables()
352 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_SAVED_QUERIES); in dropTables()
353 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_SITE_MAP); in dropTables()
/packages/apps/TV/src/com/android/tv/dvr/provider/
DDvrDatabaseHelper.java310 db.execSQL(SQL_CREATE_SCHEDULES_WITH_TIME_OFFSET); in onCreate()
313 db.execSQL(SQL_CREATE_SCHEDULES); in onCreate()
316 db.execSQL(SQL_CREATE_SERIES_RECORDINGS); in onCreate()
323 db.execSQL(SQL_DROP_SCHEDULES); in onUpgrade()
325 db.execSQL(SQL_DROP_SERIES_RECORDINGS); in onUpgrade()
330 db.execSQL( in onUpgrade()
338 db.execSQL("ALTER TABLE " + Schedules.TABLE_NAME + " ADD COLUMN " in onUpgrade()
340 db.execSQL("ALTER TABLE " + Schedules.TABLE_NAME + " ADD COLUMN " in onUpgrade()
349 db.execSQL(buildCreateSchedulesSql(schedulesBackup, COLUMNS_SCHEDULES)); in onDowngrade()
350 db.execSQL("INSERT INTO " + schedulesBackup + in onDowngrade()
[all …]

1234567