Searched refs:organizations (Results 1 – 3 of 3) sorted by relevance
| /packages/providers/ContactsProvider/tests/assets/test1/ |
| D | legacy_contacts.sql | 51 CREATE TABLE organizations (_id INTEGER PRIMARY KEY AUTOINCREMENT,company TEXT,title TEXT,isprimary… table
52 INSERT INTO organizations VALUES(1,'Acme Corp','President',0,1,NULL,3);
53 …NTEGER REFERENCES phones(_id),primary_organization INTEGER REFERENCES organizations(_id),primary_e…
112 CREATE INDEX organizationsIndex1 ON organizations (person);
122 …ld._id;DELETE FROM contact_methods WHERE person = old._id;DELETE FROM organizations WHERE person =…
136 CREATE TRIGGER organizations_INSERT_typeAndLabel AFTER INSERT ON organizations WHEN (NEW.type != …
137 CREATE TRIGGER organizations_UPDATE_typeAndLabel AFTER UPDATE ON organizations WHEN (NEW.type != …
138 CREATE TRIGGER organizations_delete DELETE ON organizations BEGIN UPDATE people SET _sync_dirty=1 W…
139 CREATE TRIGGER organizations_insert INSERT ON organizations BEGIN UPDATE people SET _sync_dirty=1 W…
140 CREATE TRIGGER organizations_update AFTER UPDATE ON organizations BEGIN UPDATE people SET _sync_dir…
|
| /packages/providers/ContactsProvider/tests/assets/testUnsynced/ |
| D | legacy_contacts.sql | 32 CREATE TABLE organizations (_id INTEGER PRIMARY KEY AUTOINCREMENT,company TEXT,title TEXT,isprimary… table
33 …NTEGER REFERENCES phones(_id),primary_organization INTEGER REFERENCES organizations(_id),primary_e…
80 CREATE INDEX organizationsIndex1 ON organizations (person);
90 …ld._id;DELETE FROM contact_methods WHERE person = old._id;DELETE FROM organizations WHERE person =…
104 CREATE TRIGGER organizations_INSERT_typeAndLabel AFTER INSERT ON organizations WHEN (NEW.type != …
105 CREATE TRIGGER organizations_UPDATE_typeAndLabel AFTER UPDATE ON organizations WHEN (NEW.type != …
106 CREATE TRIGGER organizations_delete DELETE ON organizations BEGIN UPDATE people SET _sync_dirty=1 W…
107 CREATE TRIGGER organizations_insert INSERT ON organizations BEGIN UPDATE people SET _sync_dirty=1 W…
108 CREATE TRIGGER organizations_update AFTER UPDATE ON organizations BEGIN UPDATE people SET _sync_dir…
|
| /packages/providers/ContactsProvider/tests/assets/testSynced/ |
| D | legacy_contacts.sql | 42 CREATE TABLE organizations (_id INTEGER PRIMARY KEY AUTOINCREMENT,company TEXT,title TEXT,isprimary… table
43 …NTEGER REFERENCES phones(_id),primary_organization INTEGER REFERENCES organizations(_id),primary_e…
136 CREATE INDEX organizationsIndex1 ON organizations (person);
146 …ld._id;DELETE FROM contact_methods WHERE person = old._id;DELETE FROM organizations WHERE person =…
160 CREATE TRIGGER organizations_INSERT_typeAndLabel AFTER INSERT ON organizations WHEN (NEW.type != …
161 CREATE TRIGGER organizations_UPDATE_typeAndLabel AFTER UPDATE ON organizations WHEN (NEW.type != …
162 CREATE TRIGGER organizations_delete DELETE ON organizations BEGIN UPDATE people SET _sync_dirty=1 W…
163 CREATE TRIGGER organizations_insert INSERT ON organizations BEGIN UPDATE people SET _sync_dirty=1 W…
164 CREATE TRIGGER organizations_update AFTER UPDATE ON organizations BEGIN UPDATE people SET _sync_dir…
|