Lines Matching refs:INDEX

74 CREATE INDEX contactMethodsPeopleIndex ON contact_methods (person);
75 CREATE INDEX extensionsIndex1 ON extensions (person, name);
76 CREATE INDEX groupmembershipIndex1 ON groupmembership (person, group_id);
77 CREATE INDEX groupmembershipIndex2 ON groupmembership (group_id, person);
78 CREATE INDEX groupmembershipIndex3 ON groupmembership (group_sync_account, group_sync_id);
79 CREATE INDEX groupsSyncDirtyIndex ON groups (_sync_dirty);
80 CREATE INDEX organizationsIndex1 ON organizations (person);
81 CREATE INDEX peopleLookupIndex ON peopleLookup (token,source);
82 CREATE INDEX peopleLookupWithPhoneticNameIndex ON peopleLookupWithPhoneticName (token,source);
83 CREATE INDEX peopleNameIndex ON people (name);
84 CREATE INDEX peopleSyncDirtyIndex ON people (_sync_dirty);
85 CREATE INDEX peopleSyncIdIndex ON people (_sync_id);
86 CREATE INDEX phonesIndex1 ON phones (person);
87 CREATE INDEX phonesIndex2 ON phones (number_key);
88 CREATE INDEX photoPersonIndex ON photos (person);
89 CREATE INDEX photosSyncDirtyIndex ON photos (_sync_dirty);