Lines Matching refs:INDEX

106 CREATE INDEX contactMethodsPeopleIndex ON contact_methods (person);
107 CREATE INDEX extensionsIndex1 ON extensions (person, name);
108 CREATE INDEX groupmembershipIndex1 ON groupmembership (person, group_id);
109 CREATE INDEX groupmembershipIndex2 ON groupmembership (group_id, person);
110 CREATE INDEX groupmembershipIndex3 ON groupmembership (group_sync_account, group_sync_id);
111 CREATE INDEX groupsSyncDirtyIndex ON groups (_sync_dirty);
112 CREATE INDEX organizationsIndex1 ON organizations (person);
113 CREATE INDEX peopleLookupIndex ON peopleLookup (token,source);
114 CREATE INDEX peopleLookupWithPhoneticNameIndex ON peopleLookupWithPhoneticName (token,source);
115 CREATE INDEX peopleNameIndex ON people (name);
116 CREATE INDEX peopleSyncDirtyIndex ON people (_sync_dirty);
117 CREATE INDEX peopleSyncIdIndex ON people (_sync_id);
118 CREATE INDEX phonesIndex1 ON phones (person);
119 CREATE INDEX phonesIndex2 ON phones (number_key);
120 CREATE INDEX photoPersonIndex ON photos (person);
121 CREATE INDEX photosSyncDirtyIndex ON photos (_sync_dirty);