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.
  • 0
    is used to hide callers ID
    Found 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
  • 0
    Hal myshrall
    This 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
  • 0
    Anonymous
    I 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
  • 0
    Adrian
    Fake Windows IT support.
    • Call type: Scam suspicion
  • 0
    Diana
    Guy 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
  • 0
    Seth
    This number is associated with hacking.
    • Caller: Wouldn't say
  • 0
    Bob replies to LUIS
    Did you get the free gas?!?!?!?!?
  • 0
    Keith clark
    I am being billed for sms messages....and I have not sent any
    • Caller: ???
  • 0
    Keith clark
    I am being charged for sending sms messages....and I am not sending any !!!
    • Caller: Not known
  • 0
    Cindy
    Indian 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
  • 0
    John The Local Chav replies to SAFIYA
    did that to me yestarday mate its 2019 9 years later
  • 0
    John The Local Chav
    He called me a lot of times its 2019
    • Caller: asda
    • Call type: Valid
  • 0
    Lexx replies to SAFIYA
    Scam on how you have been chosen to receive a 9k Federal Grant and not have to pay it back.
  • 0
    Lexx replies to Matt
    Scam on how you have been chosen to receive a 9k Federal Grant and not have to pay it back.
  • 0
    Kristin C
    This 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
  • 0
    Jake
    This number is listed as my =1, mchannelNumber on my phone as connection status through my supposed cell carrier
    • Caller: 214 748 3647
  • 0
    Brandy replies to Jenn
    | 1 reply
    I 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.
  • 0
    B-Edwards replies to Brandy
    Did 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.
  • 0
    Daniel
    I want to know who, I miss his/her call
    • Caller: 2147483647

Submit a comment about 2147483647 phone number:

The company that called you.
 
Other phone numbers that starts with 214