Now, we're going to do this.
A few things I want you to take note of as we're
going through these slides--
this number right here should not
change unless you want it to.
Notice, this is ZVIBERMESSAGE.
240 is our magic number.
If that number changes, we are either doing something wrong,
or we are intentionally asking it to change.
So we have ZATTACHMENT and ZPHONENUMINDEX are just
kind of useless at this point.
That means the real information for those
are going to exist in another table.
ZTEXT, ZDATE, ZSTATE is going to give us what we need to start.
If I quiz you, is this from an iPhone or an Android?
I hope you would say, iPhone.
We see the columns start with Z, and we have a Mac date/time
stamp.
So I'm going to give you an example at this point.
I'm going to switch to the VM, and I am actually
going to open Words With Friends because that's a good one that
has lots of joining from the last lab--
so back into the 5.1, iOS.
I know my problem.
It's not showing me the WordsFrameword
because I'm on All files.
There we go, WordsFramework.
Now, in here, if we go into chat_messages,
this is a great place to start.
So what I'm going to say that we're going to do here
is I'm going to go to Execute SQL.
And I'm going to do select * from z--
I forget what the table is called.
I need to look--
just chat_message.
And I press Enter, and I get everything.
So I can just look and say, what do I want?
So now, I want to back this out.
And I'm going to say, OK, I want pk because I
like to have that Primary Key.
I want message, created_at, user_id, and probably game_id--
no comma, Enter.
And now, it narrowed it down.
Do you see the issue?
We have chats.
We have a date/time stamp.
We have no idea who sent it.
We need to dig deeper at this point.
So I'm going to stop here and go back to the slides.