Lines Matching refs:VIEW

139 CREATE VIEW view_data AS SELECT data._id AS _id,hash_id, raw_contact_id, raw_contacts.contact_id AS…
140 CREATE VIEW view_raw_contacts AS SELECT raw_contacts._id AS _id,contact_id, aggregation_mode, raw_c…
141 CREATE VIEW view_contacts AS SELECT contacts._id AS _id,contacts.custom_ringtone AS custom_ringtone…
142 CREATE VIEW view_raw_entities AS SELECT contact_id, raw_contacts.deleted AS deleted,raw_contacts.me…
143 CREATE VIEW view_entities AS SELECT raw_contacts.contact_id AS _id, raw_contacts.contact_id AS cont…
144 CREATE VIEW view_data_usage_stat AS SELECT data_usage_stat.stat_id AS stat_id, data_id, raw_contact…
145 CREATE VIEW view_stream_items AS SELECT stream_items._id, contacts._id AS contact_id, contacts.look…
146 CREATE VIEW view_metadata_sync AS SELECT metadata_sync._id, raw_contact_backup_id, account_name, ac…
147 CREATE VIEW view_metadata_sync_state AS SELECT metadata_sync_state._id, account_name, account_type,…
148 CREATE VIEW view_groups AS SELECT groups._id AS _id,groups.account_id AS account_id,accounts.accoun…
155 CREATE VIEW view_v1_people AS SELECT raw_contacts._id AS _id, name.data1 AS name, raw_contacts.disp…
156 CREATE VIEW view_v1_organizations AS SELECT data._id AS _id, raw_contact_id AS person, is_primary A…
157 CREATE VIEW view_v1_contact_methods AS SELECT data._id AS _id, data.raw_contact_id AS person, CAST …
158 CREATE VIEW view_v1_phones AS SELECT DISTINCT data._id AS _id, data.raw_contact_id AS person, data.…
159 CREATE VIEW view_v1_extensions AS SELECT data._id AS _id, data.raw_contact_id AS person, accounts.a…
160 CREATE VIEW view_v1_groups AS SELECT groups._id AS _id, accounts.account_name, accounts.account_typ…
161 CREATE VIEW view_v1_group_membership AS SELECT data._id AS _id, data.raw_contact_id AS person, acco…
162 CREATE VIEW view_v1_photos AS SELECT data._id AS _id, data.raw_contact_id AS person, accounts.accou…