下面是sql 语句

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

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

在sdk中的doc文档为：

public static interface

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

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

internal: /system/media

external: /sdcard