Lines Matching refs:INDEX

117 CREATE INDEX contacts_has_phone_index ON contacts (has_phone_number);
118 CREATE INDEX contacts_name_raw_contact_id_index ON contacts (name_raw_contact_id);
119 CREATE INDEX contacts_contact_last_updated_timestamp_index ON contacts(contact_last_updated_timesta…
120 CREATE INDEX deleted_contacts_contact_deleted_timestamp_index ON deleted_contacts(contact_deleted_t…
121 CREATE INDEX raw_contacts_contact_id_index ON raw_contacts (contact_id);
122 CREATE INDEX raw_contacts_source_id_account_id_index ON raw_contacts (sourceid, account_id);
123 CREATE UNIQUE INDEX raw_contacts_backup_id_account_id_index ON raw_contacts (backup_id, account_id);
124 CREATE UNIQUE INDEX mime_type ON mimetypes (mimetype);
125 CREATE INDEX data_raw_contact_id ON data (raw_contact_id);
126 CREATE INDEX data_mimetype_data1_index ON data (mimetype_id,data1);
127 CREATE INDEX data_hash_id_index ON data (hash_id);
128 CREATE INDEX phone_lookup_index ON phone_lookup (normalized_number,raw_contact_id,data_id);
129 CREATE INDEX phone_lookup_min_match_index ON phone_lookup (min_match,raw_contact_id,data_id);
130 CREATE INDEX phone_lookup_data_id_min_match_index ON phone_lookup (data_id, min_match);
131 CREATE INDEX name_lookup_raw_contact_id_index ON name_lookup (raw_contact_id);
132 CREATE UNIQUE INDEX nickname_lookup_index ON nickname_lookup (name, cluster);
133 CREATE INDEX groups_source_id_account_id_index ON groups (sourceid, account_id);
134 CREATE UNIQUE INDEX aggregation_exception_index1 ON agg_exceptions (raw_contact_id1, raw_contact_id…
135 CREATE UNIQUE INDEX aggregation_exception_index2 ON agg_exceptions (raw_contact_id2, raw_contact_id…
136 CREATE UNIQUE INDEX data_usage_stat_index ON data_usage_stat (data_id, usage_type);
137 CREATE UNIQUE INDEX metadata_sync_index ON metadata_sync (raw_contact_backup_id, account_id);
138 CREATE UNIQUE INDEX metadata_sync_state_index ON metadata_sync_state (account_id);
163 CREATE INDEX name_lookup_index ON name_lookup (normalized_name,name_type, raw_contact_id, data_id);
164 CREATE INDEX raw_contact_sort_key1_index ON raw_contacts (sort_key);
165 CREATE INDEX raw_contact_sort_key2_index ON raw_contacts (sort_key_alt);