Searched refs:phone_lookup (Results 1 – 1 of 1) sorted by relevance
35 CREATE TABLE phone_lookup (data_id INTEGER REFERENCES data(_id) NOT NULL,raw_contact_id INTEGER REF… table128 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);152 …ET version=version+1 WHERE _id=OLD.raw_contact_id; DELETE FROM phone_lookup WHERE data_…158 …PPED_REVERSED(phone.data1) AS number_key FROM data JOIN phone_lookup ON (data._id = phone_lookup.d…