Lines Matching refs:id
3 CREATE TABLE _sync_state (_id INTEGER PRIMARY KEY,account_name TEXT NOT NULL,account_type TEXT NOT …
14 CREATE TABLE accounts (_id INTEGER PRIMARY KEY AUTOINCREMENT,account_name TEXT, account_type TEXT, …
15 …id INTEGER PRIMARY KEY AUTOINCREMENT,name_raw_contact_id INTEGER REFERENCES raw_contacts(_id),phot…
17 …id INTEGER PRIMARY KEY AUTOINCREMENT,account_id INTEGER REFERENCES accounts(_id),sourceid TEXT,bac…
18 …id INTEGER PRIMARY KEY AUTOINCREMENT, raw_contact_id INTEGER NOT NULL, res_package TEXT, icon TEXT…
19 …id INTEGER PRIMARY KEY AUTOINCREMENT, stream_item_id INTEGER NOT NULL, sort_index INTEGER, photo_f…
20 CREATE TABLE photo_files (_id INTEGER PRIMARY KEY AUTOINCREMENT, height INTEGER NOT NULL, width INT…
21 CREATE TABLE packages (_id INTEGER PRIMARY KEY AUTOINCREMENT,package TEXT NOT NULL);
22 CREATE TABLE mimetypes (_id INTEGER PRIMARY KEY AUTOINCREMENT,mimetype TEXT NOT NULL);
34 …id INTEGER PRIMARY KEY AUTOINCREMENT,package_id INTEGER REFERENCES package(_id),mimetype_id INTEGE…
35 …one_lookup (data_id INTEGER REFERENCES data(_id) NOT NULL,raw_contact_id INTEGER REFERENCES raw_co…
36 …ame_lookup (data_id INTEGER REFERENCES data(_id) NOT NULL,raw_contact_id INTEGER REFERENCES raw_co…
38 …TABLE groups (_id INTEGER PRIMARY KEY AUTOINCREMENT,package_id INTEGER REFERENCES package(_id),acc…
41 …id INTEGER PRIMARY KEY AUTOINCREMENT,type INTEGER NOT NULL, raw_contact_id1 INTEGER REFERENCES raw…
43 CREATE TABLE visible_contacts (_id INTEGER PRIMARY KEY);
44 CREATE TABLE default_directory (_id INTEGER PRIMARY KEY);
45 CREATE TABLE calls (_id INTEGER PRIMARY KEY AUTOINCREMENT,number TEXT,presentation INTEGER NOT NULL…
46 CREATE TABLE voicemail_status (_id INTEGER PRIMARY KEY AUTOINCREMENT,source_package TEXT UNIQUE NOT…
48 CREATE TABLE status_updates (status_update_data_id INTEGER PRIMARY KEY REFERENCES data(_id),status …
49 CREATE TABLE directories(_id INTEGER PRIMARY KEY AUTOINCREMENT,packageName TEXT NOT NULL,authority …
52 …L DEFAULT 0, last_time_used INTEGER NOT NULL DEFAULT 0, FOREIGN KEY(data_id) REFERENCES data(_id));
53 CREATE TABLE metadata_sync (_id INTEGER PRIMARY KEY AUTOINCREMENT,raw_contact_backup_id TEXT NOT NU…
54 CREATE TABLE pre_authorized_uris (_id INTEGER PRIMARY KEY AUTOINCREMENT, uri STRING NOT NULL, expir…
55 CREATE TABLE metadata_sync_state (_id INTEGER PRIMARY KEY AUTOINCREMENT,account_id INTEGER NOT NULL…
56 CREATE TABLE v1_settings (_id INTEGER PRIMARY KEY,_sync_account TEXT,_sync_account_type TEXT,key ST…
109 CREATE TABLE 'search_index_stat'(id INTEGER PRIMARY KEY, value BLOB); field
139 …id AS _id,hash_id, raw_contact_id, raw_contacts.contact_id AS contact_id, raw_contacts.account_id,…
140 …id AS _id,contact_id, aggregation_mode, raw_contact_is_read_only, deleted, raw_contacts.metadata_d…
141 …id AS _id,contacts.custom_ringtone AS custom_ringtone, name_raw_contact.display_name_source AS dis…
142 …id AS _id, data._id AS data_id,raw_contacts.starred AS starred,0 AS raw_contact_is_user_profile,gr…
143 …id, raw_contacts.contact_id AS contact_id, raw_contacts.deleted AS deleted,raw_contacts.metadata_d…
144 … data ON (data._id=data_usage_stat.data_id) JOIN raw_contacts ON (raw_contacts._id=data.raw_contac…
145 …id, contacts._id AS contact_id, contacts.lookup AS contact_lookup, accounts.account_name, accounts…
146 …id, raw_contact_backup_id, account_name, account_type, data_set, data, deleted FROM metadata_sync …
147 …c_state._id, account_name, account_type, data_set, state FROM metadata_sync_state JOIN accounts ON…
148 …id AS _id,groups.account_id AS account_id,accounts.account_name AS account_name,accounts.account_t…
149 …id; DELETE FROM agg_exceptions WHERE raw_contact_id1=OLD._id OR raw_contact_id2=OLD._…
150 …BEGIN UPDATE raw_contacts SET version=OLD.version+1 WHERE _id=OLD._id AND NEW.de…
151 …version=OLD.data_version+1 WHERE _id=OLD._id; UPDATE raw_contacts SET version=version+1…
152 …id=OLD.raw_contact_id; DELETE FROM phone_lookup WHERE data_id=OLD._id; DELETE FROM status_…
153 …R UPDATE ON groups BEGIN UPDATE groups SET version=OLD.version+1 WHERE _id=OLD._id; END;
154 …id FROM accounts WHERE account_name IS NULL AND account_type IS NULL AND data_set IS NULL); INSERT…
155 …id AS _id, name.data1 AS name, raw_contacts.display_name AS display_name, trim(trim(ifnull(name.da…
156 …id AS _id, raw_contact_id AS person, is_primary AS isprimary, accounts.account_name, accounts.acco…
157 …id AS _id, data.raw_contact_id AS person, CAST ((CASE WHEN mimetype='vnd.android.cursor.item/email…
158 …id AS _id, data.raw_contact_id AS person, data.is_primary AS isprimary, data.data1 AS number, data…
159 …id AS _id, data.raw_contact_id AS person, accounts.account_name, accounts.account_type, data1 AS n…
160 …id AS _id, accounts.account_name, accounts.account_type, title AS name, notes AS notes , system_id…
161 …id AS _id, data.raw_contact_id AS person, accounts.account_name, accounts.account_type, data1 AS g…
162 …id AS _id, data.raw_contact_id AS person, accounts.account_name, accounts.account_type, data.data1…