android8.1 MediaProvider中添加字段

在相机拍的照片中添加定位信息（市，区），并且在数据库中保存：

--- a/src/com/android/providers/media/MediaProvider.java
+++ b/src/com/android/providers/media/MediaProvider.java
@@ -721,13 +721,13 @@ public class MediaProvider extends ContentProvider {
 
     private static final String IMAGE_COLUMNS =
                         "_data,_size,_display_name,mime_type,title,date_added," +
-                        "date_modified,description,picasa_id,isprivate,latitude,longitude," +
+                        "date_modified,description,picasa_id,isprivate,latitude,longitude,city,district," +
                         "datetaken,orientation,mini_thumb_magic,bucket_id,bucket_display_name," +
                         "width,height";
 
     private static final String IMAGE_COLUMNSv407 =
                         "_data,_size,_display_name,mime_type,title,date_added," +
-                        "date_modified,description,picasa_id,isprivate,latitude,longitude," +
+                        "date_modified,description,picasa_id,isprivate,latitude,longitude,city,district," +
                         "datetaken,orientation,mini_thumb_magic,bucket_id,bucket_display_name";
 
     private static final String AUDIO_COLUMNSv99 =
@@ -751,14 +751,14 @@ public class MediaProvider extends ContentProvider {
     private static final String VIDEO_COLUMNS =
                         "_data,_display_name,_size,mime_type,date_added,date_modified," +
                         "title,duration,artist,album,resolution,description,isprivate,tags," +
-                        "category,language,mini_thumb_data,latitude,longitude,datetaken," +
+                        "category,language,mini_thumb_data,latitude,longitude,city,district,datetaken," +
                         "mini_thumb_magic,bucket_id,bucket_display_name,bookmark,width," +
                         "height";
 
     private static final String VIDEO_COLUMNSv407 =
                         "_data,_display_name,_size,mime_type,date_added,date_modified," +
                         "title,duration,artist,album,resolution,description,isprivate,tags," +
-                        "category,language,mini_thumb_data,latitude,longitude,datetaken," +
+                        "category,language,mini_thumb_data,latitude,longitude,city,district,datetaken," +
                         "mini_thumb_magic,bucket_id,bucket_display_name, bookmark";
 
     private static final String PLAYLIST_COLUMNS = "_data,name,date_added,date_modified";
@@ -815,7 +815,7 @@ public class MediaProvider extends ContentProvider {
                 + "_data TEXT UNIQUE COLLATE NOCASE,_size INTEGER,format INTEGER,parent INTEGER,"
                 + "date_added INTEGER,date_modified INTEGER,mime_type TEXT,title TEXT,"
                 + "description TEXT,_display_name TEXT,picasa_id TEXT,orientation INTEGER,"
-                + "latitude DOUBLE,longitude DOUBLE,datetaken INTEGER,mini_thumb_magic INTEGER,"
+                + "latitude DOUBLE,longitude DOUBLE,city TEXT,district TEXT,datetaken INTEGER,mini_thumb_magic INTEGER,"
                 + "bucket_id TEXT,bucket_display_name TEXT,isprivate INTEGER,title_key TEXT,"
                 + "artist_id INTEGER,album_id INTEGER,composer TEXT,track INTEGER,"
                 + "year INTEGER CHECK(year!=0),is_ringtone INTEGER,is_music INTEGER,"
@@ -902,12 +902,12 @@ public class MediaProvider extends ContentProvider {
         db.execSQL("CREATE VIEW audio_genres_map_noid AS SELECT audio_id,genre_id"
                 + " FROM audio_genres_map");
         db.execSQL("CREATE VIEW images AS SELECT _id,_data,_size,_display_name,mime_type,title,"
-                + "date_added,date_modified,description,picasa_id,isprivate,latitude,longitude,"
+                + "date_added,date_modified,description,picasa_id,isprivate,latitude,longitude,city,district,"
                 + "datetaken,orientation,mini_thumb_magic,bucket_id,bucket_display_name,width,"
                 + "height FROM files WHERE media_type=1");
         db.execSQL("CREATE VIEW video AS SELECT _id,_data,_display_name,_size,mime_type,"
                 + "date_added,date_modified,title,duration,artist,album,resolution,description,"
-                + "isprivate,tags,category,language,mini_thumb_data,latitude,longitude,datetaken,"
+                + "isprivate,tags,category,language,mini_thumb_data,latitude,longitude,city,district,datetaken,"
                 + "mini_thumb_magic,bucket_id,bucket_display_name,bookmark,width,height"
                 + " FROM files WHERE media_type=3");
————————————————
版权声明：本文为CSDN博主「三火哥」的原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/zjy764219923/article/details/8743