Searched defs:group_id (Results 1 - 3 of 3) sorted by relevance
| /packages/providers/ContactsProvider/tests/assets/test1/ |
| H A D | legacy_contacts.sql | 40 CREATE TABLE groupmembership (_id INTEGER PRIMARY KEY,person INTEGER REFERENCES people(_id),group_id INTEGER REFERENCES groups(_id),group_sync_account STRING,group_sync_id STRING);
108 CREATE INDEX groupmembershipIndex1 ON groupmembership (person, group_id);
109 CREATE INDEX groupmembershipIndex2 ON groupmembership (group_id, person);
134 CREATE TRIGGER groups_cleanup DELETE ON groups BEGIN UPDATE groupmembership SET group_id = null WHERE group_id = old._id;END;
|
| /packages/providers/ContactsProvider/tests/assets/testSynced/ |
| H A D | legacy_contacts.sql | 28 CREATE TABLE groupmembership (_id INTEGER PRIMARY KEY,person INTEGER REFERENCES people(_id),group_id INTEGER REFERENCES groups(_id),group_sync_account STRING,group_sync_id STRING);
132 CREATE INDEX groupmembershipIndex1 ON groupmembership (person, group_id);
133 CREATE INDEX groupmembershipIndex2 ON groupmembership (group_id, person);
158 CREATE TRIGGER groups_cleanup DELETE ON groups BEGIN UPDATE groupmembership SET group_id = null WHERE group_id = old._id;END;
|
| /packages/providers/ContactsProvider/tests/assets/testUnsynced/ |
| H A D | legacy_contacts.sql | 24 CREATE TABLE groupmembership (_id INTEGER PRIMARY KEY,person INTEGER REFERENCES people(_id),group_id INTEGER REFERENCES groups(_id),group_sync_account STRING,group_sync_id STRING);
76 CREATE INDEX groupmembershipIndex1 ON groupmembership (person, group_id);
77 CREATE INDEX groupmembershipIndex2 ON groupmembership (group_id, person);
102 CREATE TRIGGER groups_cleanup DELETE ON groups BEGIN UPDATE groupmembership SET group_id = null WHERE group_id = old._id;END;
|
Completed in 29 milliseconds