ContactsProvider建表的都在

packages/providers/ContactsProvider/src/com/android/providers/contacts/ContactsDatabaseHelper.java

首先该文件中有个Tables接口，其中的常量定义了数据库中大部分的表

    public interface Tables {public static final String CONTACTS = "contacts";  //联系人，由raw_contacts表聚合而成public static final String DELETED_CONTACTS = "deleted_contacts"; //标记要删除的联系人public static final String RAW_CONTACTS = "raw_contacts"; //联系人的原始数据，同一个联系人可能对应多个raw_contactspublic static final String STREAM_ITEMS = "stream_items"; //IM信息public static final String STREAM_ITEM_PHOTOS = "stream_item_photos"; //IM信息相关头像public static final String PHOTO_FILES = "photo_files"; //照片public static final String PACKAGES = "packages"; //包名public static final String MIMETYPES = "mimetypes"; //mime类型public static final String PHONE_LOOKUP = "phone_lookup"; //依据号码查联系人public static final String NAME_LOOKUP = "name_lookup"; //依据名字查联系人public static final String AGGREGATION_EXCEPTIONS = "agg_exceptions"; //合并联系人规则public static final String SETTINGS = "settings"; //设置public static final String DATA = "data"; //联系人最原始的数据，每一个row可以是号码、地址、名字等等public static final String GROUPS = "groups"; //联系人组public static final String PRESENCE = "presence"; //IM在线状态public static final String AGGREGATED_PRESENCE = "agg_presence"; //IM在线状态，聚合使用public static final String NICKNAME_LOOKUP = "nickname_lookup"; //昵称查找public static final String CALLS = "calls"; //通话记录public static final String STATUS_UPDATES = "status_updates";//聊天程序状态public static final String PROPERTIES = "properties"; //属性public static final String ACCOUNTS = "accounts"; //账户public static final String VISIBLE_CONTACTS = "visible_contacts"; //标记可见联系人public static final String DIRECTORIES = "directories";//通讯录public static final String DEFAULT_DIRECTORY = "default_directory";//默认通讯录public static final String SEARCH_INDEX = "search_index"; //搜索public static final String VOICEMAIL_STATUS = "voicemail_status";//语音邮箱public static final String PRE_AUTHORIZED_URIS = "pre_authorized_uris";//申请权限...public static final String DATA_USAGE_STAT = "data_usage_stat"; //data使用统计...public static final String DIALER_SEARCH = "dialer_search";//拨号盘搜索表public static final String CONFERENCE_CALLS = "conference_calls"; //会议组通话}  

PROPERTIES

        db.execSQL("CREATE TABLE " + Tables.PROPERTIES + " (" +PropertiesColumns.PROPERTY_KEY + " TEXT PRIMARY KEY, " + //keyPropertiesColumns.PROPERTY_VALUE + " TEXT " + //value");");

    public interface DbProperties {String DIRECTORY_SCAN_COMPLETE = "directoryScanComplete"; //Directory扫描完毕String AGGREGATION_ALGORITHM = "aggregation_v2";//联系人聚合算法String KNOWN_ACCOUNTS = "known_accounts"; //系统所有账号String ICU_VERSION = "icu_version"; //icu版本String LOCALE = "locale"; //所在区域String DATABASE_TIME_CREATED = "database_time_created"; //数据库创建时间String CALL_LOG_LAST_SYNCED = "call_log_last_synced"; //最后一次同步通话记录的时间}

ICU的解释见点击打开链接

ACCOUNTS 

        db.execSQL("CREATE TABLE " + Tables.ACCOUNTS + " (" + AccountsColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +AccountsColumns.ACCOUNT_NAME + " TEXT, " + //账户名称AccountsColumns.ACCOUNT_TYPE + " TEXT, " + //账户类型AccountsColumns.DATA_SET + " TEXT" + //所属数据集");");

账户类型在ContactsProvider2中针对手机定义了5个，一个本地账户（最常用的账户）和4个卡账户.

    public static final String ACCOUNT_TYPE_LOCAL_PHONE = "Local Phone Account";public static final String ACCOUNT_TYPE_SIM = "SIM Account";public static final String ACCOUNT_TYPE_USIM = "USIM Account";public static final String ACCOUNT_TYPE_UIM = "UIM Account";public static final String ACCOUNT_TYPE_CSIM = "CSIM Account";

CONTACTS

        db.execSQL("CREATE TABLE " + Tables.CONTACTS + " (" +BaseColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +Contacts.NAME_RAW_CONTACT_ID + " INTEGER REFERENCES raw_contacts(_id)," + //对应raw_contacts表中id，用于显示名字Contacts.PHOTO_ID + " INTEGER REFERENCES data(_id)," + //data表中photo相关row的idContacts.PHOTO_FILE_ID + " INTEGER REFERENCES photo_files(_id)," + //对应photo_files表中idContacts.CUSTOM_RINGTONE + " TEXT," + //来电铃声Contacts.SEND_TO_VOICEMAIL + " INTEGER NOT NULL  DEFAULT 0," + //标记该联系人来电是否直接转接到语音邮箱Contacts.TIMES_CONTACTED + " INTEGER NOT NULL DEFAULT 0," + //联系次数，如拨号会更新该值。Contacts.LAST_TIME_CONTACTED + " INTEGER," + //最后一次联系的时间，如电话、短信等Contacts.STARRED + " INTEGER NOT NULL DEFAULT 0," + //是否为星标联系人Contacts.PINNED + " INTEGER NOT NULL DEFAULT " + PinnedPositions.UNPINNED + "," + //标记在联系人列表中是否订住，订住后滑动列表不会消失Contacts.HAS_PHONE_NUMBER + " INTEGER NOT NULL DEFAULT 0," + //是否有号码Contacts.LOOKUP_KEY + " TEXT," + //lookup_key, 方便在聚合的情况下找到联系人，因为聚合的时候有可能id无效ContactsColumns.LAST_STATUS_UPDATE_ID + " INTEGER REFERENCES data(_id)," + //最后更新的对应data表中的idContacts.CONTACT_LAST_UPDATED_TIMESTAMP + " INTEGER," + //最后更新时间Contacts.SEND_TO_VOICEMAIL_VT + " INTEGER NOT NULL DEFAULT 0," +    //add by MTK 类似SEND_TO_VOICEMAIL，视频通话相关Contacts.SEND_TO_VOICEMAIL_SIP + " INTEGER NOT NULL DEFAULT 0," +   //add by MTK 类似SEND_TO_VOICEMAIL，sip通话相关Contacts.INDICATE_PHONE_SIM + " INTEGER NOT NULL DEFAULT -1," + //add by MTK,是否为卡联系人Contacts.INDEX_IN_SIM + " INTEGER NOT NULL DEFAULT -1," +       //add by MTK 在sim卡中的索引Contacts.FILTER + " INTEGER NOT NULL DEFAULT 0," +              //add by MTK 用于标记该联系人是否可以显示桌面widgetContacts.IS_SDN_CONTACT + " INTEGER NOT NULL DEFAULT 0" +  // add by MTK 是否为sdn联系人");");

DELETED_CONTACTS

删除联系人表

        db.execSQL("CREATE TABLE " + ContactsDatabaseHelper.Tables.DELETED_CONTACTS + " (" +ContactsContract.DeletedContacts.CONTACT_ID + " INTEGER PRIMARY KEY," + //删除的联系人idContactsContract.DeletedContacts.CONTACT_DELETED_TIMESTAMP + //删除时间" INTEGER NOT NULL default 0"+ ");");

RAW_CONTACTS 

  db.execSQL("CREATE TABLE " + Tables.RAW_CONTACTS + " (" +RawContacts._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +RawContactsColumns.ACCOUNT_ID + " INTEGER REFERENCES " + //账户id，对应于account表中的idTables.ACCOUNTS + "(" + AccountsColumns._ID + ")," +RawContacts.SOURCE_ID + " TEXT," + //源账户id，例如当前是手机账户id，但是源id是sim卡账户，表示该联系人是从sim卡导入的RawContacts.BACKUP_ID + " TEXT," + //备份源id，唯一的RawContacts.RAW_CONTACT_IS_READ_ONLY + " INTEGER NOT NULL DEFAULT 0," + //是否为只读RawContacts.VERSION + " INTEGER NOT NULL DEFAULT 1," + //版本号，每次更新后都会有变化RawContacts.DIRTY + " INTEGER NOT NULL DEFAULT 0," + //VERSION有变化，表示要同步数据RawContacts.DELETED + " INTEGER NOT NULL DEFAULT 0," + //标记该联系人要删除，删除聚合联系人和同步server中的数据，最后再删除数据RawContacts.CONTACT_ID + " INTEGER REFERENCES contacts(_id)," + //对应Contacts表中的idRawContacts.AGGREGATION_MODE + " INTEGER NOT NULL DEFAULT " + //聚合模式，解释见后文RawContacts.AGGREGATION_MODE_DEFAULT + "," +RawContactsColumns.AGGREGATION_NEEDED + " INTEGER NOT NULL DEFAULT 1," + //标记是否要聚合RawContacts.CUSTOM_RINGTONE + " TEXT," + //铃声RawContacts.SEND_TO_VOICEMAIL + " INTEGER NOT NULL DEFAULT 0," + //标记该联系人来电后是否要直接转到语音邮箱RawContacts.TIMES_CONTACTED + " INTEGER NOT NULL DEFAULT 0," + //联系次数RawContacts.LAST_TIME_CONTACTED + " INTEGER," + //最后联系时间点RawContacts.STARRED + " INTEGER NOT NULL DEFAULT 0," + //是否为星标联系人RawContacts.PINNED + " INTEGER NOT NULL DEFAULT "  + PinnedPositions.UNPINNED + //是否在列表中“订住”"," + RawContacts.DISPLAY_NAME_PRIMARY + " TEXT," + //名字，名在前，RawContacts.DISPLAY_NAME_ALTERNATIVE + " TEXT," + //名字，姓在前RawContacts.DISPLAY_NAME_SOURCE + " INTEGER NOT NULL DEFAULT " + //名字源，解释见后文DisplayNameSources.UNDEFINED + "," +RawContacts.PHONETIC_NAME + " TEXT," + //名字对应的语音序列，如汉字对应的拼音RawContacts.PHONETIC_NAME_STYLE + " TEXT," + //语音序列类型，解释见后文RawContacts.SORT_KEY_PRIMARY + " TEXT COLLATE " + //排序字段ContactsProvider2.PHONEBOOK_COLLATOR_NAME + "," +RawContactsColumns.PHONEBOOK_LABEL_PRIMARY + " TEXT," + //名字首对应首字母，这个是为了归类名字到26个字母。RawContactsColumns.PHONEBOOK_BUCKET_PRIMARY + " INTEGER," + //名字对应首字母对应的序号，如字母D对应4，RawContacts.SORT_KEY_ALTERNATIVE + " TEXT COLLATE " + //姓在前名字排序字段ContactsProvider2.PHONEBOOK_COLLATOR_NAME + "," +RawContactsColumns.PHONEBOOK_LABEL_ALTERNATIVE + " TEXT," +  //类似PHONEBOOK_LABEL_PRIMARYRawContactsColumns.PHONEBOOK_BUCKET_ALTERNATIVE + " INTEGER," + //类似PHONEBOOK_BUCKET_PRIMARYRawContactsColumns.NAME_VERIFIED_OBSOLETE + " INTEGER NOT NULL DEFAULT 0," + //这个字段目前已不用RawContacts.SYNC1 + " TEXT, " + //同步要用的字段RawContacts.SYNC2 + " TEXT, " +RawContacts.SYNC3 + " TEXT, " +RawContacts.SYNC4 + " TEXT, " +RawContacts.TIMESTAMP + " INTEGER," +                               //add by MTK ,VERSION变化时间点RawContacts.SEND_TO_VOICEMAIL_VT + " INTEGER NOT NULL DEFAULT 0," + // add by MTK，后续同Contacts表中解释RawContacts.SEND_TO_VOICEMAIL_SIP + " INTEGER NOT NULL DEFAULT 0," + // add by MTKRawContacts.INDICATE_PHONE_SIM + " INTEGER NOT NULL DEFAULT -1," +  //add by MTKRawContacts.INDEX_IN_SIM + " INTEGER NOT NULL DEFAULT -1," +        //add by MTKRawContacts.IS_SDN_CONTACT + " INTEGER NOT NULL DEFAULT 0" +  // add by MTK");");

AGGREGATION_MODE  

        public static final int AGGREGATION_MODE_DEFAULT = 0; //不覆盖之前设置的模式public static final int AGGREGATION_MODE_IMMEDIATE = 1; //插入或者更新时马上合并public static final int AGGREGATION_MODE_SUSPENDED = 2; //暂缓合并，例如批量插入时先不合并，插入完毕后再统一合并public static final int AGGREGATION_MODE_DISABLED = 3; //不合并

DISPLAY_NAME_SOURCE

    public interface DisplayNameSources {public static final int UNDEFINED = 0; public static final int EMAIL = 10; //电子邮件public static final int PHONE = 20; //电话public static final int ORGANIZATION = 30; //公司public static final int NICKNAME = 35; //昵称public static final int STRUCTURED_NAME = 40; //名字}

   public interface PhoneticNameStyle {public static final int UNDEFINED = 0;public static final int PINYIN = 3; //中文public static final int JAPANESE = 4; //日文public static final int KOREAN = 5; //朝鲜文}

STREAM_ITEMS

        db.execSQL("CREATE TABLE " + Tables.STREAM_ITEMS + " (" +StreamItems._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +StreamItems.RAW_CONTACT_ID + " INTEGER NOT NULL, " + //对应的RawContact IdStreamItems.RES_PACKAGE + " TEXT, " +  //相关程序包名StreamItems.RES_ICON + " TEXT, " + //相关程序的图标StreamItems.RES_LABEL + " TEXT, " + //相关程序名，例如“Google Talk”StreamItems.TEXT + " TEXT, " + //信息字符串，例如朋友圈的内容StreamItems.TIMESTAMP + " INTEGER NOT NULL, " + //时间戳StreamItems.COMMENTS + " TEXT, " + //摘要信息，例如Text已被几人读过StreamItems.SYNC1 + " TEXT, " + //同步需要的字段StreamItems.SYNC2 + " TEXT, " +StreamItems.SYNC3 + " TEXT, " +StreamItems.SYNC4 + " TEXT, " +"FOREIGN KEY(" + StreamItems.RAW_CONTACT_ID + ") REFERENCES " +Tables.RAW_CONTACTS + "(" + RawContacts._ID + "));");

        db.execSQL("CREATE TABLE " + Tables.STREAM_ITEM_PHOTOS + " (" +StreamItemPhotos._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +StreamItemPhotos.STREAM_ITEM_ID + " INTEGER NOT NULL, " + //对应的stream item idStreamItemPhotos.SORT_INDEX + " INTEGER, " +  //排序字段StreamItemPhotos.PHOTO_FILE_ID + " INTEGER NOT NULL, " + //头像文件idStreamItemPhotos.SYNC1 + " TEXT, " +StreamItemPhotos.SYNC2 + " TEXT, " +StreamItemPhotos.SYNC3 + " TEXT, " +StreamItemPhotos.SYNC4 + " TEXT, " +"FOREIGN KEY(" + StreamItemPhotos.STREAM_ITEM_ID + ") REFERENCES " +Tables.STREAM_ITEMS + "(" + StreamItems._ID + "));");

        db.execSQL("CREATE TABLE " + Tables.PHOTO_FILES + " (" +PhotoFiles._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +PhotoFiles.HEIGHT + " INTEGER NOT NULL, " +  //高PhotoFiles.WIDTH + " INTEGER NOT NULL, " +  //宽PhotoFiles.FILESIZE + " INTEGER NOT NULL);"); //文件大小

        db.execSQL("CREATE TABLE " + Tables.PACKAGES + " (" +PackagesColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +PackagesColumns.PACKAGE + " TEXT NOT NULL" + //包名");");

        db.execSQL("CREATE TABLE " + Tables.MIMETYPES + " (" +MimetypesColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +MimetypesColumns.MIMETYPE + " TEXT NOT NULL" +");");

            /** MIME type used when storing this in data table. */public static final String CONTENT_ITEM_TYPE = "vnd.android.cursor.item/phone_v2";

            /** MIME type used when storing this in data table. */public static final String CONTENT_ITEM_TYPE = "vnd.android.cursor.item/name";

 db.execSQL("CREATE TABLE " + Tables.DATA + " (" +Data._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +DataColumns.PACKAGE_ID + " INTEGER REFERENCES package(_id)," + //插入数据的程序包名idDataColumns.MIMETYPE_ID + " INTEGER REFERENCES mimetype(_id) NOT NULL," + //mime类型idData.RAW_CONTACT_ID + " INTEGER REFERENCES raw_contacts(_id) NOT NULL," +  //所属的RawContact IdData.HASH_ID + " TEXT," + //哈希值,用于恢复和备份数据Data.IS_READ_ONLY + " INTEGER NOT NULL DEFAULT 0," + //是否只读Data.IS_PRIMARY + " INTEGER NOT NULL DEFAULT 0," + //标记为联系人的主要属性Data.IS_SUPER_PRIMARY + " INTEGER NOT NULL DEFAULT 0," + //标记为联系人聚合后的主要属性，IS_SUPER_PRIMARY的前提是IS_PRIMARY为trueData.DATA_VERSION + " INTEGER NOT NULL DEFAULT 0," + //版本号Data.DATA1 + " TEXT," + //数据Data.DATA2 + " TEXT," +Data.DATA3 + " TEXT," +Data.DATA4 + " TEXT," +Data.DATA5 + " TEXT," +Data.DATA6 + " TEXT," +Data.DATA7 + " TEXT," +Data.DATA8 + " TEXT," +Data.DATA9 + " TEXT," +Data.DATA10 + " TEXT," +Data.DATA11 + " TEXT," +Data.DATA12 + " TEXT," +Data.DATA13 + " TEXT," +Data.DATA14 + " TEXT," +Data.DATA15 + " TEXT," +Data.SYNC1 + " TEXT, " + //同步需要的字段Data.SYNC2 + " TEXT, " +Data.SYNC3 + " TEXT, " +Data.SYNC4 + " TEXT, " +Data.CARRIER_PRESENCE + " INTEGER NOT NULL DEFAULT 0," + //目前只有一个可选值，标记是否可以视频通话Data.SIM_ASSOCIATION_ID + " INTEGER NOT NULL DEFAULT -1, " +    //add by MTK 卡联系人相关的sub_idData.IS_ADDITIONAL_NUMBER + " INTEGER NOT NULL DEFAULT 0 " +    //add by MTK 作用未知");");

private interface RawContactNameQuery {...public static final int DATA1 = 2;                              //全名public static final int GIVEN_NAME = 3;                         // data2 名public static final int FAMILY_NAME = 4;                        // data3 姓public static final int PREFIX = 5;                             // data4 前缀public static final int TITLE = 5;                              // data4 头衔public static final int MIDDLE_NAME = 6;                        // data5 中间名public static final int SUFFIX = 7;                             // data6 后缀public static final int PHONETIC_GIVEN_NAME = 8;                // data7 姓的语音字符序列public static final int PHONETIC_MIDDLE_NAME = 9;               // data8 中间名语音字符序列public static final int ORGANIZATION_PHONETIC_NAME = 9;         // data8 公司名语音字符序列public static final int PHONETIC_FAMILY_NAME = 10;              // data9 姓语音字符序列public static final int FULL_NAME_STYLE = 11;                   // data10 名字类型，解释如下public static final int ORGANIZATION_PHONETIC_NAME_STYLE = 11;  // data10public static final int PHONETIC_NAME_STYLE = 12;               // data11}

   public interface FullNameStyle {public static final int UNDEFINED = 0;public static final int WESTERN = 1;/*** Used if the name is written in Hanzi/Kanji/Hanja and we could not determine* which specific language it belongs to: Chinese, Japanese or Korean.*/public static final int CJK = 2;public static final int CHINESE = 3;public static final int JAPANESE = 4;public static final int KOREAN = 5;}

        db.execSQL("CREATE TABLE " + Tables.PHONE_LOOKUP + " (" +PhoneLookupColumns.DATA_ID+ " INTEGER REFERENCES data(_id) NOT NULL," + //对应data表中的idPhoneLookupColumns.RAW_CONTACT_ID+ " INTEGER REFERENCES raw_contacts(_id) NOT NULL," + //对应raw_contacts表idPhoneLookupColumns.NORMALIZED_NUMBER + " TEXT NOT NULL," + //号码PhoneLookupColumns.MIN_MATCH + " TEXT NOT NULL" + //最小匹配号码");");

        db.execSQL("CREATE TABLE " + Tables.NAME_LOOKUP + " (" +NameLookupColumns.DATA_ID+ " INTEGER REFERENCES data(_id) NOT NULL," +NameLookupColumns.RAW_CONTACT_ID+ " INTEGER REFERENCES raw_contacts(_id) NOT NULL," +NameLookupColumns.NORMALIZED_NAME + " TEXT NOT NULL," +NameLookupColumns.NAME_TYPE + " INTEGER NOT NULL," +"PRIMARY KEY ("+ NameLookupColumns.DATA_ID + ", "+ NameLookupColumns.NORMALIZED_NAME + ", "+ NameLookupColumns.NAME_TYPE + ")" +");");

        public static final int NAME_EXACT = 0;//名字public static final int NAME_VARIANT = 1; //名字变体，就是token的所有顺序public static final int NAME_COLLATION_KEY = 2; //为了排序public static final int NICKNAME = 3; //昵称public static final int EMAIL_BASED_NICKNAME = 4; //邮箱地址

        db.execSQL("CREATE TABLE " + Tables.NICKNAME_LOOKUP + " (" +NicknameLookupColumns.NAME + " TEXT," + //名字NicknameLookupColumns.CLUSTER + " TEXT" + //名字对应id");");

    private void loadNicknameLookupTable(SQLiteDatabase db) {db.execSQL("DELETE FROM " + Tables.NICKNAME_LOOKUP);String[] strings = mContext.getResources().getStringArray(com.android.internal.R.array.common_nicknames);...}

 <string-array name="common_nicknames"><item>Abigail, Abbie</item><item>Abigail, Gail, Gayle</item><item>Abe, Abraham</item>...

        db.execSQL("CREATE TABLE " + Tables.GROUPS + " (" +Groups._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +GroupsColumns.PACKAGE_ID + " INTEGER REFERENCES package(_id)," + //对应package表中的idGroupsColumns.ACCOUNT_ID + " INTEGER REFERENCES " + //对应account表中的idTables.ACCOUNTS + "(" + AccountsColumns._ID + ")," +Groups.SOURCE_ID + " TEXT," + //源账户idGroups.VERSION + " INTEGER NOT NULL DEFAULT 1," + //版本号Groups.DIRTY + " INTEGER NOT NULL DEFAULT 0," + //是否要同步Groups.TITLE + " TEXT," + //群组名Groups.TITLE_RES + " INTEGER," + //群组名资源idGroups.NOTES + " TEXT," + //备注Groups.SYSTEM_ID + " TEXT," + //系统群组id，对同步有重要意义，从代码中看有系统id的GROUP_IS_READ_ONLY都会设置为1Groups.DELETED + " INTEGER NOT NULL DEFAULT 0," + //标记是否删除Groups.GROUP_VISIBLE + " INTEGER NOT NULL DEFAULT 0," + //是否可见Groups.SHOULD_SYNC + " INTEGER NOT NULL DEFAULT 1," + //当SYNC_EVERYTHING设置为false的时候，是否同步Groups.AUTO_ADD + " INTEGER NOT NULL DEFAULT 0," + //新建联系人后是否自动添加到该群组Groups.FAVORITES + " INTEGER NOT NULL DEFAULT 0," + //星标联系人是否自动添加到该群组Groups.GROUP_IS_READ_ONLY + " INTEGER NOT NULL DEFAULT 0," + //是否只读Groups.SYNC1 + " TEXT, " + //同步字段Groups.SYNC2 + " TEXT, " +Groups.SYNC3 + " TEXT, " +Groups.SYNC4 + " TEXT " +");");

        db.execSQL("CREATE TABLE IF NOT EXISTS " + Tables.AGGREGATION_EXCEPTIONS + " (" +AggregationExceptionColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +AggregationExceptions.TYPE + " INTEGER NOT NULL, " +AggregationExceptions.RAW_CONTACT_ID1+ " INTEGER REFERENCES raw_contacts(_id), " +AggregationExceptions.RAW_CONTACT_ID2+ " INTEGER REFERENCES raw_contacts(_id)" +");");

        public static final int TYPE_AUTOMATIC = 0; //自动聚合public static final int TYPE_KEEP_TOGETHER = 1; //聚合public static final int TYPE_KEEP_SEPARATE = 2; //不聚合

        db.execSQL("CREATE TABLE IF NOT EXISTS " + Tables.SETTINGS + " (" +Settings.ACCOUNT_NAME + " STRING NOT NULL," + //账户名称Settings.ACCOUNT_TYPE + " STRING NOT NULL," + //账户类型Settings.DATA_SET + " STRING," + //标记同步源，一个数据库可备份到多处Settings.UNGROUPED_VISIBLE + " INTEGER NOT NULL DEFAULT 0," + //不再群组内的联系人是否可见Settings.SHOULD_SYNC + " INTEGER NOT NULL DEFAULT 1" + //是否启用同步，这个是最高等级的开关");");

        db.execSQL("CREATE TABLE " + Tables.VISIBLE_CONTACTS + " (" +Contacts._ID + " INTEGER PRIMARY KEY" +");");

        db.execSQL("CREATE TABLE " + Tables.DEFAULT_DIRECTORY + " (" +Contacts._ID + " INTEGER PRIMARY KEY" +");");

        db.execSQL("CREATE TABLE " + Tables.VOICEMAIL_STATUS + " (" +VoicemailContract.Status._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +VoicemailContract.Status.SOURCE_PACKAGE + " TEXT UNIQUE NOT NULL," + //VoicemailContract.Status.PHONE_ACCOUNT_COMPONENT_NAME + " TEXT," + //phone进程的包名VoicemailContract.Status.PHONE_ACCOUNT_ID + " TEXT," +  //实际就是sim卡的subidVoicemailContract.Status.SETTINGS_URI + " TEXT," + //action view加上这个uri的intent可以拉起设置界面VoicemailContract.Status.VOICEMAIL_ACCESS_URI + " TEXT," + //获取语音邮件VoicemailContract.Status.CONFIGURATION_STATE + " INTEGER," + //设置状态，解释见下VoicemailContract.Status.DATA_CHANNEL_STATE + " INTEGER," +  //数据连接状态VoicemailContract.Status.NOTIFICATION_CHANNEL_STATE + " INTEGER" + //通知连接状态");");

        public static final int CONFIGURATION_STATE_OK = 0;public static final int CONFIGURATION_STATE_NOT_CONFIGURED = 1;public static final int CONFIGURATION_STATE_CAN_BE_CONFIGURED = 2;

        public static final int DATA_CHANNEL_STATE_OK = 0;public static final int DATA_CHANNEL_STATE_NO_CONNECTION = 1;

        public static final int NOTIFICATION_CHANNEL_STATE_OK = 0;public static final int NOTIFICATION_CHANNEL_STATE_NO_CONNECTION = 1;

        db.execSQL("CREATE TABLE " + Tables.STATUS_UPDATES + " (" +StatusUpdatesColumns.DATA_ID + " INTEGER PRIMARY KEY REFERENCES data(_id)," +StatusUpdates.STATUS + " TEXT," + //状态StatusUpdates.STATUS_TIMESTAMP + " INTEGER," + //时间戳StatusUpdates.STATUS_RES_PACKAGE + " TEXT, " + //提供资源的包名StatusUpdates.STATUS_LABEL + " INTEGER, " + //状态资源idStatusUpdates.STATUS_ICON + " INTEGER" + //状态图标id");");

        db.execSQL("CREATE TABLE " + Tables.DIRECTORIES + "(" +Directory._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +Directory.PACKAGE_NAME + " TEXT NOT NULL," +Directory.DIRECTORY_AUTHORITY + " TEXT NOT NULL," + Directory.TYPE_RESOURCE_ID + " INTEGER," +DirectoryColumns.TYPE_RESOURCE_NAME + " TEXT," +Directory.ACCOUNT_TYPE + " TEXT," +Directory.ACCOUNT_NAME + " TEXT," +Directory.DISPLAY_NAME + " TEXT, " +Directory.EXPORT_SUPPORT + " INTEGER NOT NULL" + //后面详细解释" DEFAULT " + Directory.EXPORT_SUPPORT_NONE + "," +Directory.SHORTCUT_SUPPORT + " INTEGER NOT NULL" +" DEFAULT " + Directory.SHORTCUT_SUPPORT_NONE + "," +Directory.PHOTO_SUPPORT + " INTEGER NOT NULL" +" DEFAULT " + Directory.PHOTO_SUPPORT_NONE +");");

        /*** _ID of the default directory, which represents locally stored contacts.*/public static final long DEFAULT = 0;/*** _ID of the directory that represents locally stored invisible contacts.*/public static final long LOCAL_INVISIBLE = 1;

<meta-data android:name="android.content.ContactDirectory"  android:value="true"/>

        public static final int EXPORT_SUPPORT_NONE = 0; //不支持导出联系人public static final int EXPORT_SUPPORT_SAME_ACCOUNT_ONLY = 1; //只能导出到指定的账户public static final int EXPORT_SUPPORT_ANY_ACCOUNT = 2; //能导出到任何账户

        public static final int SHORTCUT_SUPPORT_NONE = 0; //不支持快捷方式public static final int SHORTCUT_SUPPORT_DATA_ITEMS_ONLY = 1; //只支持单个data itempublic static final int SHORTCUT_SUPPORT_FULL = 2; //支持全部

       public static final int PHOTO_SUPPORT_NONE = 0; //不支持头像public static final int PHOTO_SUPPORT_THUMBNAIL_ONLY = 1;  //小头像public static final int PHOTO_SUPPORT_FULL_SIZE_ONLY = 2; //大头像public static final int PHOTO_SUPPORT_FULL = 3; //全部支持

            db.execSQL("CREATE VIRTUAL TABLE " + Tables.SEARCH_INDEX+ " USING FTS4 ("+ SearchIndexColumns.CONTACT_ID + " INTEGER REFERENCES contacts(_id) NOT NULL,"+ SearchIndexColumns.CONTENT + " TEXT, " //公司、备注等其它信息+ SearchIndexColumns.NAME + " TEXT, " //名字+ SearchIndexColumns.TOKENS + " TEXT" //号码+ ")");

            db.execSQL("CREATE TABLE " + Tables.CONFERENCE_CALLS + " (" +ConferenceCalls._ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +ConferenceCalls.GROUP_ID + " INTEGER REFERENCES groups(_id)," + //对应group idConferenceCalls.CONFERENCE_DATE + " INTEGER " + //日期");");

        db.execSQL("CREATE TABLE " + Tables.DATA_USAGE_STAT + "(" +DataUsageStatColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +DataUsageStatColumns.DATA_ID + " INTEGER NOT NULL, " + //对应data表的idDataUsageStatColumns.USAGE_TYPE_INT + " INTEGER NOT NULL DEFAULT 0, " + //类型，解释见下DataUsageStatColumns.TIMES_USED + " INTEGER NOT NULL DEFAULT 0, " + // 使用次数DataUsageStatColumns.LAST_TIME_USED + " INTERGER NOT NULL DEFAULT 0, " + //最后一次使用的时间"FOREIGN KEY(" + DataUsageStatColumns.DATA_ID + ") REFERENCES "+ Tables.DATA + "(" + Data._ID + ")" +");");

        public static final String USAGE_TYPE_CALL = "call"; //通话public static final String USAGE_TYPE_LONG_TEXT = "long_text"; //长的文本通信，例如电子邮件public static final String USAGE_TYPE_SHORT_TEXT = "short_text"; //短的文本通信，例如短信

        db.execSQL("CREATE TABLE " + Tables.PRE_AUTHORIZED_URIS + " ("+PreAuthorizedUris._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +PreAuthorizedUris.URI + " STRING NOT NULL, " +PreAuthorizedUris.EXPIRATION + " INTEGER NOT NULL DEFAULT 0);");

        db.execSQL("ATTACH DATABASE ':memory:' AS " + DATABASE_PRESENCE + ";");db.execSQL("CREATE TABLE IF NOT EXISTS " + DATABASE_PRESENCE + "." + Tables.PRESENCE + " ("+StatusUpdates.DATA_ID + " INTEGER PRIMARY KEY REFERENCES data(_id)," + //对应data表中的idStatusUpdates.PROTOCOL + " INTEGER NOT NULL," + //协议常量StatusUpdates.CUSTOM_PROTOCOL + " TEXT," + //订制协议名称StatusUpdates.IM_HANDLE + " TEXT," + //和协议相关StatusUpdates.IM_ACCOUNT + " TEXT," + //IM账号PresenceColumns.CONTACT_ID + " INTEGER REFERENCES contacts(_id)," + //对应contacts idPresenceColumns.RAW_CONTACT_ID + " INTEGER REFERENCES raw_contacts(_id)," + //对应raw_contacts idStatusUpdates.PRESENCE + " INTEGER," + //im的在线状态，解释见下StatusUpdates.CHAT_CAPABILITY + " INTEGER NOT NULL DEFAULT 0," + //通话能力，解释见下"UNIQUE(" + StatusUpdates.PROTOCOL + ", " + StatusUpdates.CUSTOM_PROTOCOL+ ", " + StatusUpdates.IM_HANDLE + ", " + StatusUpdates.IM_ACCOUNT + ")" + ");");

        int OFFLINE = 0; //不在线int INVISIBLE = 1; //隐身int AWAY = 2; //离开int IDLE = 3; //空闲int DO_NOT_DISTURB = 4; //勿扰int AVAILABLE = 5; //在线

        public static final int CAPABILITY_HAS_VOICE = 1; //语音public static final int CAPABILITY_HAS_VIDEO = 2; //视频public static final int CAPABILITY_HAS_CAMERA = 4; //有前置摄像头

        db.execSQL("CREATE TABLE IF NOT EXISTS "+ DATABASE_PRESENCE + "." + Tables.AGGREGATED_PRESENCE + " ("+AggregatedPresenceColumns.CONTACT_ID+ " INTEGER PRIMARY KEY REFERENCES contacts(_id)," +StatusUpdates.PRESENCE + " INTEGER," +StatusUpdates.CHAT_CAPABILITY + " INTEGER NOT NULL DEFAULT 0" +");");