android --music database-1

 

数据库在 data/data/下的com.android.providers.media/databases -->分为2部分

• external-cfe1d0f.db//外部数据 主要是从sd card中的 数据
• internal.db//主要是系统的数据，比如系统铃声

 

 

其中上面的和music有关 后面的跟Vdiao有关后面表 还和Gallery有关 今天我研究的就是针对Music

album_art artists_albums_map audio_playlists_map album_info audio images albums audio_genres thumbnails android_metadata audio_genres_map video artist_info audio_meta artists audio_playlists 

主要把这些关系理清楚！

audio_meta表       // Contains meta data about audio files

主要的列名如下：

_id     _data   _display_name   _size   mime_type    date_added     date_modified   title   title_key  duration  

• _data : /sdcard/when your see.mp3 为路径
• mime_type：audio/mpeg :格式

下面是sql 语句

db.execSQL("CREATE TABLE IF NOT EXISTS audio_meta (" + "_id INTEGER PRIMARY KEY," + "_data TEXT NOT NULL," + "_display_name TEXT," + "_size INTEGER," + "mime_type TEXT," + "date_added INTEGER," + "date_modified INTEGER," + "title TEXT NOT NULL," + "title_key TEXT NOT NULL," + "duration INTEGER," + "artist_id INTEGER," + "composer TEXT," + "album_id INTEGER," + "track INTEGER," + // track is an integer to allow proper sorting "year INTEGER CHECK(year!=0)," + "is_ringtone INTEGER," + "is_music INTEGER," + "is_alarm INTEGER," + "is_notification INTEGER" + ");"); 

 

在源码的位置是framework.base.core.java.android.provider.MediaStore.java

在sdk中的doc文档为：

public static interface

public static interface MediaStore.MediaColumns(下面是它的子类)implements BaseColumns MediaStore.Audio.AudioColumns Columns for audio file that show up in multiple tables. MediaStore.Audio.Genres.Members Sub-directory of each genre containing all members. MediaStore.Audio.Media MediaStore.Audio.Playlists.Members Sub-directory of each playlist containing all members. MediaStore.Images.ImageColumns MediaStore.Images.Media MediaStore.Video.Media MediaStore.Video.VideoColumns 定义的字段如下： String DATA _data String DATE_ADDED date_added String DATE_MODIFIED date_modified String DISPLAY_NAME _display_name String MIME_TYPE mime_type String SIZE size String TITLE title 因为继承BaseColumns-->因此有下行两个属性 String _id String _count 

 

数据实际存储物理位置如下：

internal: /system/media

external: /sdcard