All language subtitles for 2. Migrations Setup

Always welcome to the course of Lavallade EP ministerial, this is partnered with Eddine and satisfied

you will see migration settings if I go back to slide, as we had discussed in that last video, that

in the second phase of EPRDF meant we need two different tables.

One table is to store the student's data and the other will to projects.

Data for this is too unstable.

We need the caller ID name, email, password and phone number.

And here are the columns for our projects table.

So to create table, we need migration files.

So to create migration files back to terminal BHB, Partition, Mieke Migration and Rita created to

get students DBL NAPI Free Press enter the first migration created successfully.

Vietri Partition Lizzi Mieke Migration.

Here we have pigmeat projects dbl.

Now if you press enter the second migration created successfully back to Ed Relu destabilises structure

means full-day structure to see all the migrations going sideways migrations.

And inside this folder we can see that these two migrations we have created.

Now if you click on this file by the help of this created students table, we are creating students

table by the help of this create projects Diebel plus we are creating projects Diebel.

Now, next, we need to set our columns what we had discussed inside slide.

So let's see all about for the students table.

So for the students table, we need Idy Neame, email, password and phone number.

So if I go back to Ed by default, decide Matal is going to generate idea column, which is a primary

key as well as auto increment.

And also we don't want this timestamp value.

So I will remove that dbl.

We need to take the string for the name value Litsa 120 characters in length.

Next we have the column.

As for the email address.

So here we have email.

It's a fifty characters in length dbl string.

This is for the Basswood filled Litsa.

It will be 70 characters in length because inside this password will be released to hast value and the

Haast values.

Basically long text in comparison of plaintext.

So that's why we are taking 70 characters in length.

And finally, what is students table?

We need one more column.

That is phone number.

So Kahil, if I copy the last line pasting it will lead to the column name we have called phone number

and we will put twenty five characters in land.

So all we have done with this student's table now the same thing we need to do for the project stable.

So click on this file.

Cohill again inside this table.

We don't want any timestamp values so I will remove this.

We want student ID so let's Intisar column name.

We should have called student ID and it should be unsigned now.

Next we need the name filled.

The name filled indicates all about present name.

It is 150 characters in length.

Next we want all about description.

So we need to Deakes as a data type and the column name we have should something a description and finally

duration so suitable let's say in Tehsil column name we have called duration and insert this duration

privily stole something lets three five seven eight nine user value.

So here now we are at the students table as well as project stable.

One more time if you leave with the columns, student ID, name, description and duration not to migrate.

All the migration's what we had done back terminal BHP additions my grade.

If I press enter as we can see that the migration now running and migrated all the migrations.

If I back to database go and load this.

Phase two, here we have our students stable, if we click on the deeply good structure, here are the

columns.

And if I go inside Projet Stable inside the stable, here are the columns.

Now, in the next feed, you will walk over model and control the settings state by state.

Now, we had seen the migration files for this student stable and our project stable so far.

This decision.

Guys, thank you for watching and have a great.