2147483647
Country: USA
214 area code:
Texas (Dallas)
Report a phone call from 214-748-3647 and help to identify who and why is calling from this number.
- is used to hide callers IDFound this file called addressbook.plist on computer. Anyone know where it came from - looks like its a file that goes with something that is intended to allow someone to hide their identity when making calls. ABPerson is the reference. This number on this thread is the default number in the file. Date on this file is 2.5.14 . Mentions "Shadow" calling...
Anyone familiar?
DisplayName TEXT, ExternalRepresentation BLOB, FirstSortSection TEXT, LastSortSection TEXT, FirstSortLanguageIndex INTEGER DEFAULT 2147483647, LastSortLanguageIndex INTEGER DEFAULT 2147483647, PersonLink INTEGER DEFAULT -1, ImageURI TEXT, IsPreferredName INTEGER DEFAULT 1, guid TEXT DEFAULT (ab_generate_guid()), PhonemeData TEXT, UNIQUE(guid))/Cindexsqlite_autoindex_ABPerson_1ABPersonÅ++ÅutableABPersonChangesABPersonChanges CREATE TABLE ABPersonChanges (record INTEGER, type INTEGER, Image INTEGER, ExternalIdentifier TEXT, StoreID INTEGER)Å= %%Ç=tableABPersonLinkABPersonLink
CREATE TABLE ABPersonLink (ROWID INTEGER PRIMARY KEY AUTOINCREMENT, PreferredImagePersonID INTEGER DEFAULT -1, PreferredNamePersonID INTEGER DEFAULT -1)Å
//ÅgtableABPersonSearchKeyABPersonSearchKeyCREATE TABLE ABPersonSearchKey (person_id INTEGER, SearchKey BLOB, NameOnlySearchKey BLOB, UNIQUE(person_id))AU/indexsqlite_autoindex_ABPersonSearchKey_1ABPersonSearchKeyÅ55ÅUtableABPersonBasicChangesABPersonBasicChanges
CREATE TABLE ABPersonBasicChanges (record INTEGER PRIMARY KEY, type INTEGER, sequenceNumber INTEGER)Å\
ÉtableABGroupABGroupCREATE TABLE ABGroup (ROWID INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT, ExternalIdentifier TEXT, StoreID INTEGER, ExternalModificationTag TEXT, ExternalRepresentation BLOB, ExternalUUID TEXT)Å
))ÅUtableABGroupChangesABGroupChangesCREATE TABLE ABGroupChanges (record INTEGER, type INTEGER, ExternalIdentifier TEXT, StoreID INTEGER)ÅÅqtableABAccountABAccountCREATE TABLE ABAccount (ROWID INTEGER PRIMARY KEY, AccountIdentifier TEXT, Flags INTEGER, DefaultSourceID INTEGER)ÅB))Ç?tableABGroupMembersABGroupMembersCREATE TABLE ABGroupMembers (UID INTEGER PRIMARY KEY, group_id INTEGER, member_type INTEGER, member_id INTEGER, UNIQUE(group_id, member_type, member_id));O)indexsqlite_autoindex_ABGroupMembers_1ABGroupMembersÅb%%ÉtableABMultiValueABMultiValueCREATE TABLE ABMultiValue (UID INTEGER PRIMARY KEY, record_id INTEGER, property INTEGER, identifier INTEGER, label INTEGER, value TEXT, guid TEXT DEFAULT (ab_generate_guid()), UNIQUE(guid))7K%indexsqlite_autoindex_ABMultiValue_1ABMultiValuei//ÅtableABMultiValueLabelABMultiValueLabelCREATE TABLE ABMultiValueLabel (value TEXT, UNIQUE(value))
]Ú5©Úk√櫟, ót
ments(CREATE TABLE 'ABPersonFullTextSearch_segments'(blockid INTEGER PRIMARY KEY, block BLOB)Åo'GGÇ]tableABPersonFullTextSearch_segdirABPersonFullTextSearch_segdir)CREATE TABLE 'ABPersonFullTextSearch_segdir'(level INTEGER,idx INTEGER,start_block INTEGER,leaves_end_block INTEGER,end_block INTEGER,root BLOB,PRIMARY KEY(level, idx))Y(mGindexsqlite_autoindex_ABPersonFullTextSearch_segdir_1ABPersonFullTextSearch_segdir*Å)IIÅ3tableABPersonFullTextSearch_docsizeABPersonFullTextSearch_docsize+CREATE TABLE 'ABPersonFullTextSearch_docsize'(docid INTEGER PRIMARY KEY, size BLOB)Å*CCÅ)tableABPersonFullTextSearch_statABPersonFullTextSearch_stat,CREATE TABLE 'ABPersonFullTextSearch_stat'(id INTEGER PRIMARY KEY, value BLOB)_+ÅtableABRecentABRecent-CREATE TABLE ABRecent(date INTEGER, name, property INTEGER, value)Å,-ÅIindexABFirstSortIndexABPerson.CREATE INDEX ABFirstSortIndex on ABPerson(FirstSortLanguageIndex, FirstSortSection, FirstSort)~-+ÅAindexABLastSortIndexABPerson/CREATE INDEX ABLastSortIndex on ABPerson(LastSortLanguageIndex, LastSortSection, LastSort)
ÅÅÆõñ9 -
1î˛ß
KºèƒaÇ`8MÑatriggerNamePreferredPeÅ.7ÅeindexABFirstSortStoreIndexABPerson0CREATE INDEX ABFirstSortStoreIndex on ABPerson(StoreID, FirstSortLanguageIndex, FirstSortSection, FirstSort)Å/5Å]indexABLastSortStoreIndexABPerson1CREATE INDEX ABLastSortStoreIndex on ABPerson(StoreID, LastSortLanguageIndex, LastSortSection, LastSort)Åj0-ÉtriggerDeletePersonLinkABPersonCREATE TRIGGER DeletePersonLink AFTER DELETE ON ABPerson BEGIN DELETE FROM ABPersonLink WHERE (ROWID = OLD.PersonLink AND (SELECT count() FROM ABPerson WHERE PersonLink = OLD.PersonLink) < 2); ENDÅx1-É1triggerUpdatePersonLinkABPersonCREATE TRIGGER UpdatePersonLink AFTER UPDATE OF PersonLink ON ABPerson BEGIN DELETE FROM ABPersonLink WHERE (ROWID = OLD.PersonLink AND (SELECT count() FROM ABPerson WHERE PersonLink = OLD.PersonLink) < 2); ENDÉ 2MÖatriggerUpdatePersonLinkUponPersonUnlinkABPersonCREATE TRIGGER UpdatePersonLinkUponPersonUnlink AFTER UPDATE OF PersonLink ON ABPerson WHEN OLD.PersonLink != -1 AND NEW.PersonLink = -1 BEGIN UPDATE ABPersonLink SET PreferredNamePersonID = (SELECT ROWID FROM ABPerson abp WHERE abp.PersonLink = OLD.PersonLink ORDER BY abp.ROWID LIMIT 1) WHERE (ROWID = OLD.PersonLink AND PreferredNamePersonID = OLD.ROWID); ENDÅc3E%ÇgtriggerUpdatePersonUponLinkDeletionABPersonLinkCREATE TRIGGER UpdatePersonUponLinkDeletion AFTER DELETE ON ABPersonLink BEGIN UPDATE ABPerson SET PersonLink = -1, IsPreferredName = 1 WHERE PersonLink = OLD.ROWID; ENDÅy4G%ÉtriggerUpdatePersonUponLinkInsertionABPersonLinkCREATE TRIGGER UpdatePersonUponLinkInsertion AFTER INSERT ON ABPersonLink
BEGIN
UPDATE ABPerson SET IsPreferredName = (ROWID = NEW.PreferredNamePersonID) WHERE PersonLink = NEW.ROWID;
ENDÅs5A%ÉtriggerUpdatePersonUponLinkUpdateABPersonLinkCREATE TRIGGER UpdatePersonUponLinkUpdate AFTER UPDATE ON ABPersonLink
BEGIN
UPDATE ABPerson SET IsPreferredName = (ROWID = NEW.PreferredNamePersonID) WHERE PersonLink = NEW.ROWID;
ENDÇ6IÉWtriggerNamePreferredPersonEditTriggerABPersonCREATE TRIGGER NamePreferredPersonEditTrigger AFTER UPDATE OF Prefix, First, Middle, Last, Suffix, Organization, Kind ON ABPerson BEGIN UPDATE ABPersonLink SET PreferredNamePersonID = OLD.ROWID WHERE (OLD.PersonLink = ROWID); ENDÇ7MÉ#triggerNamePreferredPersonInsertTriggerABPersonCREATE TRIGGER NamePreferredPersonInsertTrigger AFTER INSERT ON ABPerson BEGIN UPDATE ABPersonLink SET PreferredNamePersonID = NEW.ROWID WHERE (ROWID = NEW.PersonLink AND PreferredNamePersonID = -1); ENDÇ`8MÑatriggerNamePreferredPersonDeleteTriggerABPersonCREATE TRIGGER NamePreferredPersonDeleteTrigger AFTER DELETE ON ABPerson BEGIN UPDATE ABPersonLink SET PreferredNamePersonID = (SELECT ROWID FROM ABPerson abp WHERE abp.PersonLink = OLD.PersonLink ORDER BY abp.ROWID LIMIT 1) WHERE (ROWID = OLD.PersonLink AND PreferredNamePersonID = OLD.ROWID); ENDh9;ÅindexABPersonPersonLinkIndexABPerson3CREATE INDEX ABPersonPersonLinkIndex on ABPerson(PersonLink)Å&:?Å}indexABPreferredFirstSortIndexABPerson4CREATE INDEX ABPreferredFirstSortIndex on ABPerson(IsPreferredName, FirstSortLanguageIndex, FirstSortSection, FirstSort)Å!;=ÅuindexABPreferredLastSortIndexABPerson5CREATE INDEX ABPreferredLastSortIndex on ABPerson(IsPreferredName, LastSortLanguageIndex, LastSortSection, LastSort)Çn<7ÖtriggerUpdatePersonLinkFieldABPersonCREATE TRIGGER UpdatePersonLinkField AFTER UPDATE OF PersonLink ON ABPerson
WHEN OLD.PersonLink != NEW.PersonLink
BEGIN
UPDATE ABPerson
SET IsPreferredName = (NEW.PersonLink = -1 OR ROWID = (SELECT PreferredNamePersonID FROM ABPersonLink abl WHERE abl.ROWID = NEW.PersonLink))
WHERE ROWID = NEW.ROWID;
ENDÇA=?Ñ1triggerInitializePersonLinkFieldABPersonCREATE TRIGGER InitializePersonLinkField AFTER INSERT ON ABPerson
BEGIN
UPDATE ABPerson
SET IsPreferredName = (NEW.PersonLink = -1 OR ROWID = (SELECT PreferredNamePersonID FROM ABPersonLink abl WHERE abl.ROWID = NEW.PersonLink))
WHERE ROWID = NEW.ROWID;
END
55ŸIÃA¨A∫'·ç\Ò<∫É!J7ÖytriggerLastSortSectionInsertABPersonCREATE TRIGGER LastSortSectionInsert AFTER INSERT ON ABPerson BEGIN INSERT OR REPLACE INTO LastSortSectionCount VALUES(NEW.LastSortLanguageIndex, IFNULL(NEW.LastSortSection, ''), NEW.StoreID, 1 + IFNULL((SELECT number from LastSortSectionCount WHERE LanguageIndex = NEW.LastSortÅ!>+ÇtriggerDeleteSearchKeyABPersonCREATE TRIGGER DeleteSearchKey AFTER DELETE ON ABPerson BEGIN DELETE FROM ABPersonSearchKey WHERE person_id = OLD.ROWID; ENDn??Å
indexABPersonExternalUUIDIndexABPerson6CREATE INDEX ABPersonExternalUUIDIndex on ABPerson(ExternalUUID)Å@KÅ%indexABPersonExternalIdentifierIndexABPerson7CREATE INDEX ABPersonExternalIdentifierIndex on ABPerson(ExternalIdentifier)sA?%ÅindexABMultiValueRecordIDIndexABMultiValue8CREATE INDEX ABMultiValueRecordIDIndex on ABMultiValue(record_id)iB9%ÅindexABMultiValueLabelIndexABMultiValue9CREATE INDEX ABMultiValueLabelIndex ON ABMultiValue(label)ÅCI%ÅCindexABMultiValuePropertyValueIndexABMultiValue;CREATE INDEX ABMultiValuePropertyValueIndex ON ABMultiValue(property, value COLLATE NOCASE)wD?/Å
indexABMultiValueEntryKeyIndexABMultiValueEntry<CREATE INDEX ABMultiValueEntryKeyIndex ON ABMultiValueEntry(key)kE5+ÅindexABPhoneLastFourIndexABPhoneLastFour=CREATE INDEX ABPhoneLastFourIndex ON ABPhoneLastFour(value)Å7F9%Çtriggerdelete_phone_last_fourABMultiValueCREATE TRIGGER delete_phone_last_four AFTER DELETE ON ABMultiValue
BEGIN
DELETE FROM ABPhoneLastFour WHERE multivalue_id = OLD.UID;
ENDÉ)G9ÜtriggerFirstSortSectionInsertABPersonCREATE TRIGGER FirstSortSectionInsert AFTER INSERT ON ABPerson BEGIN INSERT OR REPLACE INTO FirstSortSectionCount VALUES(NEW.FirstSortLanguageIndex, IFNULL(NEW.FirstSortSection, ''), NEW.StoreID, 1 + IFNULL((SELECT number from FirstSortSectionCount WHERE LanguageIndex = NEW.FirstSortLanguageIndex AND Section = IFNULL(NEW.FirstSortSection, '') AND StoreID = NEW.StoreID), 0)); ENDÜH9ç3triggerFirstSortSectionUpdateABPersonCREATE TRIGGER FirstSortSectionUpdate AFTER UPDATE ON ABPerson BEGIN INSERT OR REPLACE INTO FirstSortSectionCount VALUES(OLD.FirstSortLanguageIndex, IFNULL(OLD.FirstSortSection, ''), OLD.StoreID, (SELECT number from FirstSortSectionCount WHERE LanguageIndex = OLD.FirstSortLanguageIndex AND Section = IFNULL(OLD.FirstSortSection, '') AND StoreID = OLD.StoreID) - 1); DELETE FROM FirstSortSectionCount WHERE LanguageIndex = OLD.FirstSortLanguageIndex AND Section = IFNULL(OLD.FirstSortSection, '') AND StoreID = OLD.StoreID AND number = 0; INSERT OR REPLACE INTO FirstSortSectionCount VALUES(NEW.FirstSortLanguageIndex, IFNULL(NEW.FirstSortSection, ''), NEW.StoreID, 1 + IFNULL((SELECT number from FirstSortSectionCount WHERE LanguageIndex = NEW.FirstSortLanguageIndex AND Section = IFNULL(NEW.FirstSortSection, '') AND StoreID = NEW.StoreID), 0)); ENDÑJI9àItriggerFirstSortSectionDeleteABPersonCREATE TRIGGER FirstSortSectionDelete AFTER DELETE ON ABPerson BEGIN INSERT OR REPLACE INTO FirstSortSectionCount VALUES(OLD.FirstSortLanguageIndex, IFNULL(OLD.FirstSortSection, ''), OLD.StoreID, (SELECT number from FirstSortSectionCount WHERE LanguageIndex = OLD.FirstSortLanguageIndex AND Section = IFNULL(OLD.FirstSortSection, '') AND StoreID = OLD.StoreID) - 1); DELETE FROM FirstSortSectionCount WHERE LanguageIndex = OLD.FirstSortLanguageIndex AND Section = IFNULL(OLD.FirstSortSection, '') AND StoreID = OLD.StoreID AND number = 0; ENDÉ!J7ÖytriggerLastSortSectionInsertABPersonCREATE TRIGGER LastSortSectionInsert AFTER INSERT ON ABPerson BEGIN INSERT OR REPLACE INTO LastSortSectionCount VALUES(NEW.LastSortLanguageIndex, IFNULL(NEW.LastSortSection, ''), NEW.StoreID, 1 + IFNULL((SELECT number from LastSortSectionCount WHERE LanguageIndex = NEW.LastSortLanguageIndex AND Section = IFNULL(NEW.LastSortSection, '') AND StoreID = NEW.StoreID), 0)); END
ÿÿI
ã
KËÖÉqPAátriggerLastSortSectionTotalInsertABPersonCREATE TRIGGER LastSortSectionTotalInsert AFTER INSERT ON ABPerson
WHEN NEW.IsPreferredName=1
BEGIN
INSERT OR REPLACE INTO LastSortSectionCountTotal
VALUES(
NEW.LastSortLanguageIndex,
IFNULL(NEW.LastSortSection, ''),
0,
1 + IFNULL((SELECT number from LastSortSectionCountTotal WHERE LanguageIndex = NEW.LastSortLanguageIndex AND Section = IFNULL(NEW.LastSortSection, '') AND Type = 0), 0)
);
ENDÜnK7çtriggerLastSortSectionUpdateABPersonCREATE TRIGGER LastSortSectionUpdate AFTER UPDATE ON ABPerson BEGIN INSERT OR REPLACE INTO LastSortSectionCount VALUES(OLD.LastSortLanguageIndex, IFNULL(OLD.LastSortSection, ''), OLD.StoreID, (SELECT number from LastSortSectionCount WHERE LanguageIndex = OLD.LastSortLanguageIndex AND Section = IFNULL(OLD.LastSortSection, '') AND StoreID = OLD.StoreID) - 1); DELETE FROM LastSortSectionCount WHERE LanguageIndex = OLD.LastSortLanguageIndex AND Section = IFNULL(ÜnK7çtriggerLastSortSectionUpdateABPersonCREATE TRIGGER LastSortSectionUpdate AFTER UPDATE ON ABPerson BEGIN INSERT OR REPLACE INTO LastSortSectionCount VALUES(OLD.LastSortLanguageIndex, IFNULL(OLD.LastSortSection, ''), OLD.StoreID, (SELECT number from LastSortSectionCount WHERE LanguageIndex = OLD.LastSortLanguageIndex AND Section = IFNULL(OLD.LastSortSection, '') AND StoreID = OLD.StoreID) - 1); DELETE FROM LastSortSectionCount WHERE LanguageIndex = OLD.LastSortLanguageIndex AND Section = IFNULL(OLD.LastSortSection, '') AND StoreID = OLD.StoreID AND number = 0; INSERT OR REPLACE INTO LastSortSectionCount VALUES(NEW.LastSortLanguageIndex, IFNULL(NEW.LastSortSection, ''), NEW.StoreID, 1 + IFNULL((SELECT number from LastSortSectionCount WHERE LanguageIndex = NEW.LastSortLanguageIndex AND Section = IFNULL(NEW.LastSortSection, '') AND StoreID = NEW.StoreID), 0)); ENDÑ?L7à5triggerLastSortSectionDeleteABPersonCREATE TRIGGER LastSortSectionDelete AFTER DELETE ON ABPerson BEGIN INSERT OR REPLACE INTO LastSortSectionCount VALUES(OLD.LastSortLanguageIndex, IFNULL(OLD.LastSortSection, ''), OLD.StoreID, (SELECT number from LastSortSectionCount WHERE LanguageIndex = OLD.LastSortLanguageIndex AND Section = IFNULL(OLD.LastSortSection, '') AND StoreID = OLD.StoreID) - 1); DELETE FROM LastSortSectionCount WHERE LanguageIndex = OLD.LastSortLanguageIndex AND Section = IFNULL(OLD.LastSortSection, '') AND StoreID = OLD.StoreID AND number = 0; ENDÖ=MCä%triggerFirstSortSectionTotalDeleteABPersonCREATE TRIGGER FirstSortSectionTotalDelete AFTER DELETE ON ABPerson
WHEN OLD.IsPreferredName=1
BEGIN
INSERT OR REPLACE INTO FirstSortSectionCountTotal
VALUES(
OLD.FirstSortLanguageIndex,
IFNULL(OLD.FirstSortSection, ''),
0,
(SELECT number FROM FirstSortSectionCountTotal WHERE LanguageIndex = OLD.FirstSortLanguageIndex AND Section = IFNULL(OLD.FirstSortSection, '') AND Type = 0) - 1
);
DELETE FROM FirstSortSectionCountTotal
WHERE LanguageIndex = OLD.FirstSortLanguageIndex AND
Section = IFNULL(OLD.FirstSortSection, '') AND
Type = 0 AND
number <= 0;
ENDÖ2NAätriggerLastSortSectionTotalDeleteABPersonCREATE TRIGGER LastSortSectionTotalDelete AFTER DELETE ON ABPerson
WHEN OLD.IsPreferredName=1
BEGIN
INSERT OR REPLACE INTO LastSortSectionCountTotal
VALUES(
OLD.LastSortLanguageIndex,
IFNULL(OLD.LastSortSection, ''),
0,
(SELECT number FROM LastSortSectionCountTotal WHERE LanguageIndex = OLD.LastSortLanguageIndex AND Section = IFNULL(OLD.LastSortSection, '') AND Type = 0) - 1
);
DELETE FROM LastSortSectionCountTotal
WHERE LanguageIndex = OLD.LastSortLanguageIndex AND
Section = IFNULL(OLD.LastSortSection, '') AND
Type = 0 AND
number <= 0;
END
r 51
%OAÿrdV3ÅindexABRecent_date_indexABRecentACREATE INDEX ABRecent_date_index ON ABRecent(property, date)gU5Å indexABRecent_value_indexABRecent@CREATE INDEX ABRecent_value_index ON ABRecent(property, value)ÑT[á)triggerLastSortSectionTotalUpdateIfIsPreferredABPersonCREATE TRIGGER LastSortSectionTotalUpdateIfIsPreferred AFTER UPDATE ON ABPerson
WHEN NEW.IsPreferredName=1
BEGIN
INSERT OR REPLACE INTO LastSortSectionCountTotal
VALUES(
NEW.LastSortLanguageIndex,
IFNULL(NEW.LastSortSection, ''),
0,
1 + IFNULL((SELECT number from LastSortSectionCountTotal WHERE LanguageIndex = NEW.LastSortLanguageIndex AND Section = IFNULL(NEW.LastSortSection, '') AND Type = 0), 0)
);
ENDÖMS]ä+triggerLastSortSectionTotalUpdateIfWasPreferredABPersonCREATE TRIGGER LastSortSectionTotalUpdateIfWasPreferred AFTER UPDATE ON ABPerson
WHEN OLD.IsPreferredName=1
BEGIN
INSERT OR REPLACE INTO LastSortSectionCountTotal
VALUES(
OLD.LastSortLanguageIndex,
IFNULL(OLD.LastSortSection, ''),
0,
(SELECT number FROM LastSortSectionCountTotal WHERE LanguageIndex = OLD.LastSortLanguageIndex AND Section = IFNULL(OLD.LastSortSection, '') AND Type = 0) - 1
);
DELETE FROM LastSortSectionCountTotal
WHERE LanguageIndex = OLD.LastSortLanguageIndex AND
Section = IFNULL(OLD.LastSortSection, '') AND
Type = 0 AND
number = 0;
ENDÑR]á7triggerFirstSortSectionTotalUpdateIfIsPreferredABPersonCREATE TRIGGER FirstSortSectionTotalUpdateIfIsPreferred AFTER UPDATE ON ABPerson
WHEN NEW.IsPreferredName=1
BEGIN
INSERT OR REPLACE INTO FirstSortSectionCountTotal
VALUES(
NEW.FirstSortLanguageIndex,
IFNULL(NEW.FirstSortSection, ''),
0,
1 + IFNULL((SELECT number from FirstSortSectionCountTotal WHERE LanguageIndex = NEW.FirstSortLanguageIndex AND Section = IFNULL(NEW.FirstSortSection, '') AND Type = 0), 0)
);
ENDÉyOCátriggerFirstSortSectionTotalInsertABPersonCREATE TRIGGER FirstSortSectionTotalInsert AFTER INSERT ON ABPerson
WHEN NEW.IsPreferredName=1
BEGIN
INSERT OR REPLACE INTO FirstSortSectionCountTotal
VALUES(
NEW.FirstSortLanguageIndex,
IFNULL(NEW.FirstSortSection, ''),
0,
1 + IFNULL((SELECT number from FirstSortSectionCountTotal WHERE LanguageIndex = NEW.FirstSortLanguageIndex AND Section = IFNULL(NEW.FirstSortSection, '') AND Type = 0), 0)
);
ENDÉqPAátriggerLastSortSectionTotalInsertABPersonCREATE TRIGGER LastSortSectionTotalInsert AFTER INSERT ON ABPerson
WHEN NEW.IsPreferredName=1
BEGIN
INSERT OR REPLACE INTO LastSortSectionCountTotal
VALUES(
NEW.LastSortLanguageIndex,
IFNULL(NEW.LastSortSection, ''),
0,
1 + IFNULL((SELECT number from LastSortSectionCountTotal WHERE LanguageIndex = NEW.LastSortLanguageIndex AND Section = IFNULL(NEW.LastSortSection, '') AND Type = 0), 0)
);
ENDÖXQ_ä?triggerFirstSortSectionTotalUpdateIfWasPreferredABPersonCREATE TRIGGER FirstSortSectionTotalUpdateIfWasPreferred AFTER UPDATE ON ABPerson
WHEN OLD.IsPreferredName=1
BEGIN
INSERT OR REPLACE INTO FirstSortSectionCountTotal
VALUES(
OLD.FirstSortLanguageIndex,
IFNULL(OLD.FirstSortSection, ''),
0,
(SELECT number FROM FirstSortSectionCountTotal WHERE LanguageIndex = OLD.FirstSortLanguageIndex AND Section = IFNULL(OLD.FirstSortSection, '') AND Type = 0) - 1
);
DELETE FROM FirstSortSectionCountTotal
WHERE LanguageIndex = OLD.FirstSortLanguageIndex AND
Section = IFNULL(OLD.FirstSortSection, '') AND
Type = 0 AND
number = 0;
END- Caller: 2147483647
- Call type: Scam suspicion
- Hal myshrallThis is a fraud call tried telling they were from Microsoft Windows. Microsoft does not call people wanting your credit card info and such do not fall for this scam
Caller: 214 748 3647Call type: Scam suspicion- Call type: Scam suspicion
- AnonymousI am getting phone calls from spam numbers and this is one of them. Please do not pick up the phone and even if you do, do not give them any personal or financial information. Stay safe.
- Caller: Unknown
- AdrianFake Windows IT support.
- Call type: Scam suspicion
- DianaGuy with Indian accent says he's from Microsoft and is calling in regards to "my computer". I could hear lots of voices in the background. Obvious attempt at scamming. Second time this week.
- Call type: Scam suspicion
- SethThis number is associated with hacking.
- Caller: Wouldn't say
- Bob replies to LUISDid you get the free gas?!?!?!?!?
- Keith clarkI am being billed for sms messages....and I have not sent any
- Caller: ???
- Keith clarkI am being charged for sending sms messages....and I am not sending any !!!
- Caller: Not known
- CindyIndian accent calling; 'Concerning your computer' from an UNKNOWN #. I asked him to tell me WHOM he was calling (my name). He could not answer so I asked again and he just repeated it was 'concerning my computer'. Told him not to call back. IMO, this is a SCAMMER.
- Call type: Scam suspicion
- John The Local Chav replies to SAFIYAdid that to me yestarday mate its 2019 9 years later
- John The Local ChavHe called me a lot of times its 2019
- Caller: asda
- Call type: Valid
- Lexx replies to SAFIYAScam on how you have been chosen to receive a 9k Federal Grant and not have to pay it back.
- Lexx replies to MattScam on how you have been chosen to receive a 9k Federal Grant and not have to pay it back.
- Kristin CThis number called for me at work and then asked if this was my business line or my personal line, when I said my business line, they hung up on me
- Caller: New Perspective
- JakeThis number is listed as my =1, mchannelNumber on my phone as connection status through my supposed cell carrier
- Caller: 214 748 3647
- Brandy replies to Jenn| 1 replyI am seeing this listed as a server in my operating system.. Info of mine is streamed somehow and somewhere else.. Any helpful ideas will be appreciated.
- B-Edwards replies to BrandyDid you recently give "tech help"control of your computer? If so, you might be able to go to Add/Remove programs and delete any software that was installed to allow access. If you are not confident about this, you need to disconnect from the internet, shut down your computer and take it to a shop that can take a look and get rid of the problem.
BTW - Jenn was here last 10 years ago and will not see your post. - DanielI want to know who, I miss his/her call
- Caller: 2147483647
Submit a comment about 2147483647 phone number: