Lines Matching refs:INDEX

130 CREATE INDEX contactMethodsPeopleIndex ON contact_methods (person);
131 CREATE INDEX extensionsIndex1 ON extensions (person, name);
132 CREATE INDEX groupmembershipIndex1 ON groupmembership (person, group_id);
133 CREATE INDEX groupmembershipIndex2 ON groupmembership (group_id, person);
134 CREATE INDEX groupmembershipIndex3 ON groupmembership (group_sync_account, group_sync_id);
135 CREATE INDEX groupsSyncDirtyIndex ON groups (_sync_dirty);
136 CREATE INDEX organizationsIndex1 ON organizations (person);
137 CREATE INDEX peopleLookupIndex ON peopleLookup (token,source);
138 CREATE INDEX peopleLookupWithPhoneticNameIndex ON peopleLookupWithPhoneticName (token,source);
139 CREATE INDEX peopleNameIndex ON people (name);
140 CREATE INDEX peopleSyncDirtyIndex ON people (_sync_dirty);
141 CREATE INDEX peopleSyncIdIndex ON people (_sync_id);
142 CREATE INDEX phonesIndex1 ON phones (person);
143 CREATE INDEX phonesIndex2 ON phones (number_key);
144 CREATE INDEX photoPersonIndex ON photos (person);
145 CREATE INDEX photosSyncDirtyIndex ON photos (_sync_dirty);