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 11 milliseconds