WEBVTT

1
00:00:00.320 --> 00:00:01.490
<v Jose>Hi guys, and welcome back.</v>

2
00:00:01.490 --> 00:00:05.800
Let's talk real quick about the stage two of this project.

3
00:00:05.800 --> 00:00:08.259
We're gonna support multiple users because we need to know

4
00:00:08.259 --> 00:00:11.230
who has watched which movie.

5
00:00:11.230 --> 00:00:13.750
So we need to separate the watched property

6
00:00:13.750 --> 00:00:15.450
from the movies table.

7
00:00:15.450 --> 00:00:18.660
And instead, were gonna associate it with a particular user.

8
00:00:18.660 --> 00:00:21.240
So these are our table changes.

9
00:00:21.240 --> 00:00:22.710
This is what we've got at the moment.

10
00:00:22.710 --> 00:00:26.450
We've got one table with the title, the release timestamp,

11
00:00:26.450 --> 00:00:29.040
and a watched property, a watched column.

12
00:00:29.040 --> 00:00:31.240
Now, we're going to split the watched column

13
00:00:31.240 --> 00:00:34.070
and move it into another table, like this.

14
00:00:34.070 --> 00:00:36.110
So we have the movies table on the left

15
00:00:36.110 --> 00:00:37.960
with the title and the release timestamp.

16
00:00:37.960 --> 00:00:41.080
We have the watched on the right with the user

17
00:00:41.080 --> 00:00:43.520
that watched it, as well as the title of the movie.

18
00:00:43.520 --> 00:00:45.160
As we've spoken about previously,

19
00:00:45.160 --> 00:00:47.120
we've got some duplication here.

20
00:00:47.120 --> 00:00:50.450
The movie title is in two tables, and that's not great.

21
00:00:50.450 --> 00:00:52.490
We're going to fix that in stage three,

22
00:00:52.490 --> 00:00:54.840
but for now, this is going to very easily allow us

23
00:00:54.840 --> 00:00:57.267
to support multiple users.

24
00:00:57.267 --> 00:00:58.860
All right, thanks for watching.

25
00:00:58.860 --> 00:01:00.483
I'll see you in the next video.