Lines Matching refs:data
3 …INTEGER PRIMARY KEY,account_name TEXT NOT NULL,account_type TEXT NOT NULL,data TEXT,UNIQUE(account… field
15 …data(_id),photo_file_id INTEGER REFERENCES photo_files(_id),custom_ringtone TEXT,send_to_voicemail…
34 CREATE TABLE data (_id INTEGER PRIMARY KEY AUTOINCREMENT,package_id INTEGER REFERENCES package(_id)… table
35 CREATE TABLE phone_lookup (data_id INTEGER REFERENCES data(_id) NOT NULL,raw_contact_id INTEGER REF…
36 CREATE TABLE name_lookup (data_id INTEGER REFERENCES data(_id) NOT NULL,raw_contact_id INTEGER REFE…
45 …photo_id INTEGER NOT NULL DEFAULT 0,photo_uri TEXT,formatted_number TEXT,_data TEXT,has_content IN…
48 CREATE TABLE status_updates (status_update_data_id INTEGER PRIMARY KEY REFERENCES data(_id),status …
52 …L DEFAULT 0, last_time_used INTEGER NOT NULL DEFAULT 0, FOREIGN KEY(data_id) REFERENCES data(_id));
53 …INCREMENT,raw_contact_backup_id TEXT NOT NULL,account_id INTEGER NOT NULL,data TEXT,deleted INTEGE… field
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);
139 …data._id AS _id,hash_id, raw_contact_id, raw_contacts.contact_id AS contact_id, raw_contacts.accou…
142 …data.package_id,package AS res_package,data.mimetype_id,mimetype AS mimetype, is_read_only, data1,…
143 …data.package_id,package AS res_package,data.mimetype_id,mimetype AS mimetype, is_read_only, data1,…
144 … JOIN data ON (data._id=data_usage_stat.data_id) JOIN raw_contacts ON (raw_contacts._id=data.raw_c…
146 …ta_sync._id, raw_contact_backup_id, account_name, account_type, data_set, data, deleted FROM metad…
149 CREATE TRIGGER raw_contacts_deleted BEFORE DELETE ON raw_contacts BEGIN DELETE FROM data …
151 CREATE TRIGGER data_updated AFTER UPDATE ON data BEGIN UPDATE data SET data_version=OLD.data…
152 CREATE TRIGGER data_deleted BEFORE DELETE ON data BEGIN UPDATE raw_contacts SET version=vers…
154 …efault_directory SELECT contact_id FROM raw_contacts JOIN data ON (raw_c…
155 …data name ON (raw_contacts._id = name.raw_contact_id AND (SELECT mimetype FROM mimetypes WHERE mim…
156 …data._id AS _id, raw_contact_id AS person, is_primary AS isprimary, accounts.account_name, account…
157 …data._id AS _id, data.raw_contact_id AS person, CAST ((CASE WHEN mimetype='vnd.android.cursor.item…
158 …data._id AS _id, data.raw_contact_id AS person, data.is_primary AS isprimary, data.data1 AS number…
159 …data._id AS _id, data.raw_contact_id AS person, accounts.account_name, accounts.account_type, data…
161 …data._id AS _id, data.raw_contact_id AS person, accounts.account_name, accounts.account_type, data…
162 …data._id AS _id, data.raw_contact_id AS person, accounts.account_name, accounts.account_type, data…