| /packages/providers/CalendarProvider/src/com/android/providers/calendar/ |
| D | CalendarDatabaseHelper.java | 361 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/MediaProvider/tests/src/com/android/providers/media/ |
| D | DatabaseHelperTest.java | 323 db.execSQL("CREATE TABLE android_metadata (locale TEXT)"); in createOSchema()
324 db.execSQL("CREATE TABLE thumbnails (_id INTEGER PRIMARY KEY,_data TEXT,image_id INTEGER," in createOSchema()
326 db.execSQL("CREATE TABLE artists (artist_id INTEGER PRIMARY KEY," in createOSchema()
328 db.execSQL("CREATE TABLE albums (album_id INTEGER PRIMARY KEY," in createOSchema()
330 db.execSQL("CREATE TABLE album_art (album_id INTEGER PRIMARY KEY,_data TEXT)"); in createOSchema()
331 db.execSQL("CREATE TABLE videothumbnails (_id INTEGER PRIMARY KEY,_data TEXT," in createOSchema()
333 db.execSQL("CREATE TABLE files (_id INTEGER PRIMARY KEY AUTOINCREMENT," in createOSchema()
346 db.execSQL("CREATE TABLE log (time DATETIME, message TEXT)"); in createOSchema()
348 db.execSQL("CREATE TABLE audio_genres (_id INTEGER PRIMARY KEY,name TEXT NOT NULL)"); in createOSchema()
349 db.execSQL("CREATE TABLE audio_genres_map (_id INTEGER PRIMARY KEY," in createOSchema()
[all …]
|
| /packages/providers/TelephonyProvider/src/com/android/providers/telephony/ |
| D | MmsSmsDatabaseHelper.java | 428 db.execSQL( in updateThreads()
452 db.execSQL( in updateThreads()
480 db.execSQL( in updateThreads()
664 …db.execSQL("CREATE VIRTUAL TABLE words USING FTS3 (_id INTEGER PRIMARY KEY, index_text TEXT, sourc… in createWordsTables()
671 db.execSQL("CREATE TRIGGER sms_words_update AFTER UPDATE ON sms BEGIN UPDATE words " + in createWordsTables()
674 db.execSQL("CREATE TRIGGER sms_words_delete AFTER DELETE ON sms BEGIN DELETE FROM " + in createWordsTables()
692 db.execSQL("CREATE INDEX IF NOT EXISTS typeThreadIdIndex ON sms" + in createThreadIdIndex()
701 db.execSQL("CREATE INDEX IF NOT EXISTS threadIdDateIndex ON sms" + in createThreadIdDateIndex()
710 db.execSQL("CREATE INDEX IF NOT EXISTS partMidIndex ON part (mid)"); in createPartMidIndex()
718 db.execSQL("CREATE INDEX IF NOT EXISTS addrMsgIdIndex ON addr (msg_id)"); in createAddrMsgIdIndex()
[all …]
|
| D | TelephonyProvider.java | 570 db.execSQL(getStringForSimInfoTableCreation(tableName)); in createSimInfoTable()
577 db.execSQL(getStringForCarrierTableCreation(tableName)); in createCarriersTable()
778 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
785 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
787 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
793 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
795 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
802 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
804 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
809 db.execSQL("ALTER TABLE " + CARRIERS_TABLE + in onUpgrade()
[all …]
|
| D | RcsProviderThreadHelper.java | 69 db.execSQL("CREATE TABLE " + RCS_THREAD_TABLE + " (" + in createThreadTables()
72 db.execSQL("CREATE TABLE " + RCS_1_TO_1_THREAD_TABLE + " (" + in createThreadTables()
80 db.execSQL("CREATE TABLE " + RCS_GROUP_THREAD_TABLE + " (" + in createThreadTables()
116 db.execSQL("CREATE VIEW " + UNIFIED_RCS_THREAD_VIEW + " AS " in createThreadTables()
165 db.execSQL("CREATE TRIGGER deleteRcsThreadAfter1to1 AFTER DELETE ON " in createThreadTables()
177 db.execSQL("CREATE TRIGGER deleteRcsThreadAfterGroup AFTER DELETE ON " in createThreadTables()
193 db.execSQL("CREATE TRIGGER delete1To1JunctionEntries AFTER DELETE ON " in createThreadTables()
210 db.execSQL("CREATE TRIGGER deleteGroupJunctionEntries AFTER DELETE ON " in createThreadTables()
|
| D | RcsProviderMessageHelper.java | 103 db.execSQL("CREATE TABLE " + RCS_MESSAGE_TABLE + "(" + MESSAGE_ID_COLUMN in createRcsMessageTables()
111 db.execSQL("CREATE TABLE " + RCS_INCOMING_MESSAGE_TABLE + "(" + MESSAGE_ID_COLUMN in createRcsMessageTables()
118 db.execSQL("CREATE TABLE " + RCS_OUTGOING_MESSAGE_TABLE + "(" + MESSAGE_ID_COLUMN in createRcsMessageTables()
122 db.execSQL("CREATE TABLE " + RCS_MESSAGE_DELIVERY_TABLE + "(" + MESSAGE_ID_COLUMN in createRcsMessageTables()
132 db.execSQL("CREATE TABLE " + RCS_FILE_TRANSFER_TABLE + " (" + FILE_TRANSFER_ID_COLUMN in createRcsMessageTables()
187 db.execSQL("CREATE VIEW " + UNIFIED_MESSAGE_VIEW + " AS SELECT " in createRcsMessageTables()
243 db.execSQL("CREATE VIEW " + UNIFIED_INCOMING_MESSAGE_VIEW + " AS SELECT " in createRcsMessageTables()
277 db.execSQL("CREATE VIEW " + UNIFIED_OUTGOING_MESSAGE_VIEW + " AS SELECT " in createRcsMessageTables()
300 db.execSQL("CREATE TRIGGER deleteCommonMessageAfterIncoming AFTER DELETE ON " in createRcsMessageTables()
312 db.execSQL("CREATE TRIGGER deleteCommonMessageAfterOutgoing AFTER DELETE ON " in createRcsMessageTables()
|
| /packages/apps/Email/provider_src/com/android/email/provider/ |
| D | DBHelper.java | 215 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/ |
| D | CalendarDatabaseHelperTest.java | 55 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/ |
| D | ContactsDatabaseHelper.java | 1111 db.execSQL("DELETE FROM " + Tables.PRESENCE + ";"); in onOpen()
1112 db.execSQL("DELETE FROM " + Tables.AGGREGATED_PRESENCE + ";"); in onOpen()
1150 db.execSQL("CREATE TABLE IF NOT EXISTS " + Tables.PRESENCE + " ("+ in createPresenceTables()
1164 db.execSQL("CREATE INDEX IF NOT EXISTS presenceIndex" + " ON " in createPresenceTables()
1166 db.execSQL("CREATE INDEX IF NOT EXISTS presenceIndex2" + " ON " in createPresenceTables()
1169 db.execSQL("CREATE TABLE IF NOT EXISTS " in createPresenceTables()
1177 db.execSQL("CREATE TRIGGER IF NOT EXISTS " + Tables.PRESENCE + "_deleted" in createPresenceTables()
1217 db.execSQL("CREATE TRIGGER IF NOT EXISTS " + Tables.PRESENCE + "_inserted" in createPresenceTables()
1223 db.execSQL("CREATE TRIGGER IF NOT EXISTS " + Tables.PRESENCE + "_updated" in createPresenceTables()
1242 db.execSQL("CREATE TABLE " + Tables.ACCOUNTS + " (" + in onCreate()
[all …]
|
| D | CallLogDatabaseHelper.java | 119 db.execSQL("CREATE TABLE " + Tables.CALLS + " (" + in onCreate()
172 db.execSQL("CREATE TABLE " + Tables.VOICEMAIL_STATUS + " (" + in onCreate()
268 db.execSQL("ALTER TABLE " + Tables.CALLS + " ADD " + Calls.VIA_NUMBER + in upgradeToVersion2()
276 db.execSQL("ALTER TABLE " + Tables.VOICEMAIL_STATUS + " ADD " + Status.SOURCE_TYPE + in upgradeToVersion3()
285 db.execSQL("ALTER TABLE calls ADD backed_up INTEGER NOT NULL DEFAULT 0"); in upgradeToVersion4()
286 db.execSQL("ALTER TABLE calls ADD restored INTEGER NOT NULL DEFAULT 0"); in upgradeToVersion4()
287 db.execSQL("ALTER TABLE calls ADD archived INTEGER NOT NULL DEFAULT 0"); in upgradeToVersion4()
288 db.execSQL("ALTER TABLE calls ADD is_omtp_voicemail INTEGER NOT NULL DEFAULT 0"); in upgradeToVersion4()
295 db.execSQL("ALTER TABLE calls ADD transcription_state INTEGER NOT NULL DEFAULT 0"); in upgradeToVersion5()
304 db.execSQL("ALTER TABLE calls ADD call_screening_component_name TEXT"); in upgradeToVersion6()
[all …]
|
| /packages/providers/TvProvider/tests/src/com/android/providers/tv/ |
| D | DatabaseHelperTest.java | 114 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/apps/TV/tests/common/src/com/android/tv/testing/ |
| D | FakeTvProvider.java | 998 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/apps/Dialer/java/com/android/dialer/database/ |
| D | DialerDatabaseHelper.java | 115 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/providers/TvProvider/src/com/android/providers/tv/ |
| D | TvProvider.java | 785 db.execSQL("CREATE TABLE " + CHANNELS_TABLE + " (" in onCreate()
820 db.execSQL("CREATE TABLE " + PROGRAMS_TABLE + " (" in onCreate()
858 db.execSQL("CREATE INDEX " + PROGRAMS_TABLE_PACKAGE_NAME_INDEX + " ON " + PROGRAMS_TABLE in onCreate()
860 db.execSQL("CREATE INDEX " + PROGRAMS_TABLE_CHANNEL_ID_INDEX + " ON " + PROGRAMS_TABLE in onCreate()
862 db.execSQL("CREATE INDEX " + PROGRAMS_TABLE_START_TIME_INDEX + " ON " + PROGRAMS_TABLE in onCreate()
864 db.execSQL("CREATE INDEX " + PROGRAMS_TABLE_END_TIME_INDEX + " ON " + PROGRAMS_TABLE in onCreate()
866 db.execSQL("CREATE TABLE " + WATCHED_PROGRAMS_TABLE + " (" in onCreate()
888 db.execSQL("CREATE INDEX " + WATCHED_PROGRAMS_TABLE_CHANNEL_ID_INDEX + " ON " in onCreate()
890 db.execSQL(CREATE_RECORDED_PROGRAMS_TABLE_SQL); in onCreate()
891 db.execSQL(CREATE_PREVIEW_PROGRAMS_TABLE_SQL); in onCreate()
[all …]
|
| /packages/apps/SettingsIntelligence/src/com/android/settings/intelligence/search/indexing/ |
| D | IndexDatabaseHelper.java | 192 db.execSQL(CREATE_INDEX_TABLE); in bootstrapDB()
193 db.execSQL(CREATE_META_TABLE); in bootstrapDB()
194 db.execSQL(CREATE_SAVED_QUERIES_TABLE); in bootstrapDB()
195 db.execSQL(CREATE_SITE_MAP_TABLE); in bootstrapDB()
196 db.execSQL(INSERT_BUILD_VERSION); in bootstrapDB()
326 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_META_INDEX); in dropTables()
327 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_PREFS_INDEX); in dropTables()
328 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_SAVED_QUERIES); in dropTables()
329 db.execSQL("DROP TABLE IF EXISTS " + Tables.TABLE_SITE_MAP); in dropTables()
|
| /packages/apps/Dialer/java/com/android/dialer/calllog/database/ |
| D | AnnotatedCallLogDatabaseHelper.java | 150 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/Messaging/src/com/android/messaging/datamodel/ |
| D | DatabaseHelper.java | 655 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/providers/MediaProvider/src/com/android/providers/media/ |
| D | MediaProvider.java | 958 db.execSQL("DROP TRIGGER IF EXISTS " + c.getString(0)); in makePristineSchema()
967 db.execSQL("DROP VIEW IF EXISTS " + c.getString(0)); in makePristineSchema()
976 db.execSQL("DROP INDEX IF EXISTS " + c.getString(0)); in makePristineSchema()
985 db.execSQL("DROP TABLE IF EXISTS " + c.getString(0)); in makePristineSchema()
1009 db.execSQL("CREATE TABLE android_metadata (locale TEXT)"); in createLatestSchema()
1010 db.execSQL("CREATE TABLE thumbnails (_id INTEGER PRIMARY KEY,_data TEXT,image_id INTEGER," in createLatestSchema()
1012 db.execSQL("CREATE TABLE artists (artist_id INTEGER PRIMARY KEY," in createLatestSchema()
1014 db.execSQL("CREATE TABLE albums (album_id INTEGER PRIMARY KEY," in createLatestSchema()
1016 db.execSQL("CREATE TABLE album_art (album_id INTEGER PRIMARY KEY,_data TEXT)"); in createLatestSchema()
1017 db.execSQL("CREATE TABLE videothumbnails (_id INTEGER PRIMARY KEY,_data TEXT," in createLatestSchema()
[all …]
|
| /packages/apps/DeskClock/src/com/android/deskclock/provider/ |
| D | ClockDatabaseHelper.java | 74 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/apps/Bluetooth/src/com/android/bluetooth/btservice/storage/ |
| D | MetadataDatabase.java | 106 database.execSQL("ALTER TABLE metadata ADD COLUMN `pbap_client_priority` INTEGER");
113 database.execSQL("CREATE TABLE IF NOT EXISTS `metadata_tmp` ("
132 database.execSQL("INSERT INTO metadata_tmp ("
167 database.execSQL("DROP TABLE `metadata`");
168 database.execSQL("ALTER TABLE `metadata_tmp` RENAME TO `metadata`");
|
| /packages/providers/BlockedNumberProvider/src/com/android/providers/blockednumber/ |
| D | BlockedNumberDatabaseHelper.java | 59 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/modules/NetworkStack/src/com/android/server/connectivity/ipmemorystore/ |
| D | IpMemoryStoreDatabase.java | 154 db.execSQL(NetworkAttributesContract.CREATE_TABLE); in onCreate()
155 db.execSQL(PrivateDataContract.CREATE_TABLE); in onCreate()
175 db.execSQL(sqlUpgradeAddressExpiry); in onUpgrade()
184 db.execSQL(NetworkAttributesContract.DROP_TABLE); in onUpgrade()
185 db.execSQL(PrivateDataContract.DROP_TABLE); in onUpgrade()
195 db.execSQL(NetworkAttributesContract.DROP_TABLE); in onDowngrade()
196 db.execSQL(PrivateDataContract.DROP_TABLE); in onDowngrade()
197 db.execSQL("DROP TRIGGER " + TRIGGER_NAME); in onDowngrade()
209 db.execSQL(createTrigger); in createTrigger()
617 db.execSQL("VACUUM"); in dropAllExpiredRecords()
[all …]
|
| /packages/inputmethods/LatinIME/java/src/com/android/inputmethod/dictionarypack/ |
| D | MetadataDbHelper.java | 208 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/ContactsProvider/tests/src/com/android/providers/contacts/ |
| D | SynchronousContactsProvider2.java | 194 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/ |
| D | ApnDatabase.java | 308 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()
|